1 Reply Latest reply on Sep 22, 2015 10:17 PM by 1567114

    Getting Execution Error Calling po_requisition_update_pub.update_requisition

    1567114

      Hello,

       

      In 12.2.4 I am facing problems in executing the API:

       

      Please need help on this.

       

      Below is the creation for the executing the Package:

       

      declare

      v_ret_stat varchar2(255);

      v_msg_cnt number;

      v_msg_our varchar2(255);

      v_msg_data varchar2(255);

       

       

      v_req_line_out po_requisition_update_pub.req_line_rec_type;

      v_req_line_err po_requisition_update_pub.req_line_rec_type;

       

       

      v_source_hdr po_requisition_update_pub.req_hdr;

      v_source_tab1 po_requisition_update_pub.req_hdr_tbl;

       

       

      v_source_rec po_requisition_update_pub.req_line_rec_type;

      v_source_tab po_requisition_update_pub.req_line_tbl;

       

       

      v_source_dist po_requisition_update_pub.req_dist;

      v_source_tab2 po_requisition_update_pub.req_dist_tbl;

       

       

      v_source_out po_requisition_update_pub.req_line_tbl;

      v_source_err po_requisition_update_pub.req_line_tbl;

      begin

       

       

      dbms_output.put_line('Before Header Calling');

       

       

      v_source_hdr.requisition_header_id:=17565262;  --     NUMBER, --required

        v_source_hdr.org_id:=116817;    --                  NUMBER,

        v_source_hdr.summary_flag:='N';--                po_requisition_headers_all.summary_flag%TYPE,

        v_source_hdr.enabled_flag:='Y';--                po_requisition_headers_all.enabled_flag%TYPE,

        v_source_hdr.segment1:='TESTABC'; --                   po_requisition_headers_all.segment1%TYPE,

        v_source_hdr.segment2:=NULL;--                    po_requisition_headers_all.segment2%TYPE,

        v_source_hdr.segment3:=NULL;--                    po_requisition_headers_all.segment3%TYPE,

        v_source_hdr.segment4:=NULL;--                    po_requisition_headers_all.segment4%TYPE,

        v_source_hdr.segment5:=NULL;--                    po_requisition_headers_all.segment5%TYPE,

        v_source_hdr.start_date_active:=NULL;--           DATE,

        v_source_hdr.end_date_active:=NULL;--             DATE,

        v_source_hdr.description:=NULL;--                 po_requisition_headers_all.description%TYPE,

        v_source_hdr.note_to_authorizer:=NULL;--          po_requisition_headers_all.type_lookup_code%TYPE,

        v_source_hdr.attribute_category:='TESTABC';--          po_requisition_headers_all.attribute_category%TYPE,

        v_source_hdr.attribute1:=NULL;--                  po_requisition_headers_all.attribute1%TYPE,

        v_source_hdr.attribute2:=NULL;--                  po_requisition_headers_all.attribute2%TYPE,

        v_source_hdr.attribute3:=NULL;--                  po_requisition_headers_all.attribute3%TYPE,

        v_source_hdr.attribute4:=NULL;--                  po_requisition_headers_all.attribute4%TYPE,

        v_source_hdr.attribute5:=NULL;--                  po_requisition_headers_all.attribute5%TYPE,

        v_source_hdr.attribute6:=NULL;--                  po_requisition_headers_all.attribute6%TYPE,

        v_source_hdr.attribute7:=NULL;--                  po_requisition_headers_all.attribute7%TYPE,

        v_source_hdr.attribute8:=NULL;--                  po_requisition_headers_all.attribute8%TYPE,

        v_source_hdr.attribute9:=30;--                  po_requisition_headers_all.attribute9%TYPE,

        v_source_hdr.attribute10:=NULL;--                 po_requisition_headers_all.attribute10%TYPE,

        v_source_hdr.attribute11:=NULL;--                 po_requisition_headers_all.attribute11%TYPE,

        v_source_hdr.attribute12:=NULL;--                 po_requisition_headers_all.attribute12%TYPE,

        v_source_hdr.attribute13:=NULL;--                 po_requisition_headers_all.attribute13%TYPE,

        v_source_hdr.attribute14:=NULL;--                 po_requisition_headers_all.attribute14%TYPE,

        v_source_hdr.attribute15:=NULL;--                 po_requisition_headers_all.attribute15%TYPE,

        v_source_hdr.government_context:=NULL;--          po_requisition_headers_all.government_context%TYPE,

        v_source_hdr.authorization_status:='APPROVED';--  po_requisition_headers_all.authorization_status%TYPE,

        v_source_hdr.error_message:=NULL;-- VARCHAR2(2000),

        v_source_hdr.Submit_for_approval:='N';-- VARCHAR2(1),

        v_source_hdr.note_to_approver:=NULL;-- VARCHAR2(2000)

       

       

        v_source_tab1(1):=v_source_hdr;

       

        dbms_output.put_line('Before Line Calling');

       

       

                v_source_rec.requisition_number:='ABC001';

                v_source_rec.requisition_line_num:=2;

                v_source_rec.suggested_buyer_name:=NULL;

                v_source_rec.blanket_po_number:=NULL;

                v_source_rec.un_number:=NULL;

                v_source_rec.hazard_class:=NULL;

                v_source_rec.source_organization_name:='TEST US';

                -- destination_organization_name  HR_ORGANIZATION_UNITS.NAME%TYPE;

                v_source_rec.suggested_vendor_name:=NULL;

                v_source_rec.suggested_vendor_location:=NULL;

                v_source_rec.suggested_vendor_contact:=NULL;

                v_source_rec.suggested_vendor_phone:=NULL;

                v_source_rec.requestor_name:=NULL;--requestor_name        VARCHAR2(240);

                v_source_rec.deliver_to_location_code:='Sunnyvale';--deliver_to_location_code HR_LOCATIONS.LOCATION_CODE%TYPE;

                v_source_rec.requestor:=NULL;--requestor          PER_PEOPLE_F.FULL_NAME%TYPE;

                v_source_rec.line_type:=NULL;--line_type             VARCHAR2(100);

                v_source_rec.contract_number:=NULL;--contract_number okc_k_headers_b.contract_number%TYPE;

                v_source_rec.destination_organization:='Sunnyvale';--destination_organization  org_organization_definitions.organization_name%TYPE;

                v_source_rec.item_id:=NULL;--item_id PO_REQUISITION_LINES_ALL.item_id%TYPE;

                v_source_rec.item_revision:=NULL;--item_revision PO_REQUISITION_LINES_ALL.item_revision%TYPE;

                v_source_rec.item_number:=NULL;--item_number mtl_system_items_kfv.concatenated_segments%TYPE;

                -- fields for validations

                v_source_rec.reference_num:=NULL;--reference_num         PO_REQUISITION_LINES_ALL.reference_num%TYPE;

                v_source_rec.rfq_required_flag:=NULL;--rfq_required_flag     PO_REQUISITION_LINES_ALL.RFQ_REQUIRED_FLAG%TYPE;

                v_source_rec.to_person_id:=139167;--to_person_id         NUMBER;

                v_source_rec.line_type_id:=1;--line_type_id          PO_REQUISITION_LINES_ALL.line_type_id%TYPE;

                v_source_rec.item_description:='MECHANICAL UNIT';--item_description        PO_REQUISITION_LINES_ALL.item_description%TYPE;

                v_source_rec.unit_meas_lookup_code:='EACH';--unit_meas_lookup_code     PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE;

                v_source_rec.unit_price:=0;---unit_price          PO_REQUISITION_LINES_ALL.unit_price%TYPE;

                v_source_rec.base_unit_price:=0;--base_unit_price         PO_REQUISITION_LINES_ALL.base_unit_price%TYPE;

                v_source_rec.quantity:=10;--quantity            PO_REQUISITION_LINES_ALL.quantity%TYPE;

                v_source_rec.amount:=NULL;--amount            PO_REQUISITION_LINES_ALL.amount%TYPE;

                v_source_rec.source_type_code:='INVENTORY';--source_type_code        PO_REQUISITION_LINES_ALL.source_type_code%TYPE;

                v_source_rec.suggested_buyer_id:=NULL;--suggested_buyer_id            PO_REQUISITION_LINES_ALL.Suggested_Buyer_Id%TYPE;

                v_source_rec.document_type_code:=NULL;--document_type_code            PO_REQUISITION_LINES_ALL.Document_Type_Code%TYPE;

                v_source_rec.blanket_po_header_id:=NULL;--blanket_po_header_id          PO_REQUISITION_LINES_ALL.Blanket_Po_Header_Id%TYPE;

                v_source_rec.blanket_po_line_num:=NULL;--blanket_po_line_num           PO_REQUISITION_LINES_ALL.Blanket_Po_Line_Num%TYPE;

                v_source_rec.currency_code:='USD';--currency_code                 PO_REQUISITION_LINES_ALL.Currency_Code%TYPE;

                v_source_rec.rate_type:=NULL;--rate_type                     PO_REQUISITION_LINES_ALL.Rate_Type%TYPE;

                v_source_rec.rate_date:=NULL;--rate_date                     PO_REQUISITION_LINES_ALL.Rate_Date%TYPE;

                v_source_rec.rate:=NULL;--rate                          PO_REQUISITION_LINES_ALL.Rate%TYPE;

                v_source_rec.currency_unit_price:=NULL;--currency_unit_price           PO_REQUISITION_LINES_ALL.Currency_Unit_Price%TYPE;

                v_source_rec.currency_amount:=NULL;--currency_amount               PO_REQUISITION_LINES_ALL.Currency_Amount%TYPE;

                v_source_rec.un_number_id:=NULL;--un_number_id                  PO_REQUISITION_LINES_ALL.Un_Number_Id%TYPE;

                v_source_rec.hazard_class_id:=NULL;--hazard_class_id               PO_REQUISITION_LINES_ALL.Hazard_Class_Id%TYPE;

                v_source_rec.source_organization_id:=116820;--source_organization_id        PO_REQUISITION_LINES_ALL.Source_Organization_Id%TYPE;

                v_source_rec.source_subinventory:='ZONE-RCV';--source_subinventory           PO_REQUISITION_LINES_ALL.Source_Subinventory%TYPE;

                v_source_rec.destination_type_code:='INVENTORY';--destination_type_code         PO_REQUISITION_LINES_ALL.Destination_Type_Code%TYPE;

                v_source_rec.destination_organization_id:=116818;--destination_organization_id   PO_REQUISITION_LINES_ALL.Destination_Organization_Id%TYPE;

                v_source_rec.destination_subinventory:='ZONE-RCV';--destination_subinventory      PO_REQUISITION_LINES_ALL.Destination_Subinventory%TYPE;

                v_source_rec.secondary_quantity:=NULL;--secondary_quantity          PO_REQUISITION_LINES_ALL.Secondary_Quantity%TYPE;

                v_source_rec.vendor_id:=NULL;--vendor_id                  po_vendors.Vendor_Id%TYPE;

                v_source_rec.vendor_site_id:=NULL;--vendor_site_id             po_vendor_sites_all.Vendor_Site_Id%TYPE;

                v_source_rec.vendor_contact_id:=NULL;--vendor_contact_id          po_vendor_contacts.Vendor_Contact_Id%TYPE;

                v_source_rec.research_agent_id:=NULL;--research_agent_id           PO_REQUISITION_LINES_ALL.Research_Agent_Id%TYPE;

                v_source_rec.on_line_flag:=NULL;--on_line_flag                PO_REQUISITION_LINES_ALL.On_Line_Flag%TYPE;

                v_source_rec.preferred_grade:=NULL;--preferred_grade             PO_REQUISITION_LINES_ALL.preferred_grade%TYPE;

                v_source_rec.secondary_uom_code:=NULL;--secondary_uom_code          PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;

                v_source_rec.TRANSACTION_REASON_CODE:=NULL;--TRANSACTION_REASON_CODE     PO_REQUISITION_LINES_ALL.TRANSACTION_REASON_CODE%TYPE;

                v_source_rec.requisition_line_id:=PO_REQUISITION_LINES_S.nextval;--requisition_line_id         PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;

                v_source_rec.requisition_header_id:=17565262;--requisition_header_id       PO_REQUISITION_LINES_ALL.requisition_header_id%TYPE;

                v_source_rec.order_type_lookup_code:='QUANTITY';--order_type_lookup_code      PO_REQUISITION_LINES_ALL.order_type_lookup_code%TYPE;

                v_source_rec.org_id:=116817;--org_id                      PO_REQUISITION_LINES_ALL.org_id%TYPE;

                v_source_rec.justification:=NULL;--justification                 PO_REQUISITION_LINES_ALL.Justification%TYPE;

                v_source_rec.note_to_agent:=NULL;--note_to_agent                 PO_REQUISITION_LINES_ALL.Note_To_Agent%TYPE;

                v_source_rec.need_by_date:=NULL;--need_by_date                  PO_REQUISITION_LINES_ALL.Need_By_Date%TYPE;

                v_source_rec.note_to_receiver:=NULL;--note_to_receiver              PO_REQUISITION_LINES_ALL.Note_To_Receiver%TYPE;

                v_source_rec.urgent_flag:=NULL;--urgent_flag                   PO_REQUISITION_LINES_ALL.Urgent_Flag%TYPE;

                v_source_rec.suggested_vendor_product_code:=NULL;--suggested_vendor_product_code PO_REQUISITION_LINES_ALL.Suggested_Vendor_Product_Code%TYPE;

                v_source_rec.deliver_to_location_id:=NULL;--deliver_to_location_id           PO_REQUISITION_LINES_ALL.DELIVER_TO_LOCATION_ID%TYPE;

                v_source_rec.oke_contract_header_id:=NULL;--oke_contract_header_id  po_requisition_lines_all.oke_contract_header_id%TYPE;

                v_source_rec.attribute1:=NULL;--attribute1          PO_REQUISITION_LINES_ALL.attribute1%TYPE;

                v_source_rec.attribute2:=NULL;--attribute2          PO_REQUISITION_LINES_ALL.attribute2%TYPE;

                v_source_rec.attribute3:=NULL;--attribute3          PO_REQUISITION_LINES_ALL.attribute3%TYPE;

                v_source_rec.attribute4:=NULL;--attribute4          PO_REQUISITION_LINES_ALL.attribute4%TYPE;

                v_source_rec.attribute5:=NULL;--attribute5          PO_REQUISITION_LINES_ALL.attribute5%TYPE;

                v_source_rec.attribute6:=NULL;--attribute6          PO_REQUISITION_LINES_ALL.attribute6%TYPE;

                v_source_rec.attribute7:=NULL;--attribute7          PO_REQUISITION_LINES_ALL.attribute7%TYPE;

                v_source_rec.attribute8:=NULL;--attribute8          PO_REQUISITION_LINES_ALL.attribute8%TYPE;

                v_source_rec.attribute9:=NULL;--attribute9          PO_REQUISITION_LINES_ALL.attribute9%TYPE;

                v_source_rec.attribute10:=NULL;--attribute10         PO_REQUISITION_LINES_ALL.attribute10%TYPE;

                v_source_rec.attribute11:=NULL;--attribute11         PO_REQUISITION_LINES_ALL.attribute11%TYPE;

                v_source_rec.attribute12:=NULL;--attribute12         PO_REQUISITION_LINES_ALL.attribute12%TYPE;

                v_source_rec.attribute13:=NULL;--attribute13         PO_REQUISITION_LINES_ALL.attribute13%TYPE;

                v_source_rec.attribute14:=NULL;--attribute14         PO_REQUISITION_LINES_ALL.attribute14%TYPE;

                v_source_rec.attribute15:=NULL;--attribute15         PO_REQUISITION_LINES_ALL.attribute15%TYPE;

                v_source_rec.category_id:=NULL;--category_id         NUMBER;

                v_source_rec.rebuild_accounts:=NULL;--rebuild_accounts VARCHAR2(1) DEFAULT 'N';

                v_source_rec.error_message:=NULL;--error_message VARCHAR2(2000);

                v_source_rec.Submit_for_approval:=NULL;--Submit_for_approval VARCHAR2(1);

                v_source_rec.note_to_approver:=NULL;--note_to_approver VARCHAR2(2000);

                v_source_rec.authorization_status:='APPROVED';--authorization_status VARCHAR2(50);

                v_source_rec.item_category:=NULL;--item_category       mtl_categories_kfv.CONCATENATED_SEGMENTS%type;

                v_source_rec.manufacturer_part_number:=NULL;--manufacturer_part_number po_requisition_lines_all.manufacturer_part_number%TYPE;

                v_source_rec.manufacturer_name:=NULL;--manufacturer_name po_requisition_lines_all.manufacturer_name%TYPE;

                v_source_rec.manufacturer_id:=NULL;--manufacturer_id po_requisition_lines_all.manufacturer_id%TYPE;

                v_source_rec.destination_type:=NULL;--destination_type    PO_REQUISITION_LINES_V.destination_type_disp%type;

                v_source_rec.deliver_to_location:=NULL;--deliver_to_location PO_REQUISITION_LINES_V.deliver_to_location%type;

                v_source_rec.source_type:=NULL;--source_type         PO_REQUISITION_LINES_V.source_type_disp%type;

                v_source_rec.negotiated_by_preparer_flag:=NULL;--negotiated_by_preparer_flag PO_REQUISITION_LINES_ALL.negotiated_by_preparer_flag%TYPE;

                v_source_rec.action_flag:='NEW';

           

            v_source_tab(1):=v_source_rec;

       

       

      dbms_output.put_line('Before Distribution Calling');

           

          v_source_dist.distribution_id:=PO_REQ_DISTRIBUTIONS_S.NEXTVAL;--               NUMBER, --required

          v_source_dist.coa_id:=NULL;--  NUMBER,

          v_source_dist.distribution_num:=2;--         NUMBER,

          v_source_dist.req_header_id:=17565262;--        NUMBER,

          v_source_dist.requisition_number:='ABC001';--   po_requisition_headers_all.segment1%TYPE,

          v_source_dist.req_line_num:=2;--      po_requisition_lines_all.line_num%TYPE,

          v_source_dist.req_line_id:=PO_REQUISITION_LINES_S.currval;--          NUMBER,

          v_source_dist.org_id:=116817;      --           NUMBER,

          v_source_dist.charge_account_id:=NULL;--   NUMBER,

          v_source_dist.charge_account:=NULL;--  VARCHAR2(1000),

          v_source_dist.accrual_account:=NULL;-- VARCHAR2(1000),

          v_source_dist.variance_account:=NULL;-- VARCHAR2(1000),

          v_source_dist.budget_account:=NULL;-- VARCHAR2(1000),

          v_source_dist.code_combination_id:=789755;-- NUMBER,

          v_source_dist.req_line_quantity:=15;--             NUMBER,

          v_source_dist.req_line_amount:=NULL;--               NUMBER,

          v_source_dist.gl_encumbered_date:=NULL;--            DATE,

          v_source_dist.gl_encumbered_period_name:=NULL;--     po_req_distributions_all.gl_encumbered_period_name%TYPE,

          v_source_dist.budget_account_id:=NULL;--             NUMBER,

          v_source_dist.accrual_account_id:=NULL;--  NUMBER,

          v_source_dist.variance_account_id:=NULL;-- NUMBER,

          v_source_dist.attribute_category:=NULL;--            po_req_distributions_all.attribute_category%TYPE,

          v_source_dist.attribute1:=NULL;--      po_req_distributions_all.attribute1%TYPE,

          v_source_dist.attribute2:=NULL;--      po_req_distributions_all.attribute2%TYPE,

          v_source_dist.attribute3:=NULL;--        po_req_distributions_all.attribute3%TYPE,

          v_source_dist.attribute4:=NULL;--        po_req_distributions_all.attribute4%TYPE,

          v_source_dist.attribute5:=NULL;--    po_req_distributions_all.attribute5%TYPE,

          v_source_dist.attribute6:=NULL;--    po_req_distributions_all.attribute6%TYPE,

          v_source_dist.attribute7:=NULL;--      po_req_distributions_all.attribute7%TYPE,

          v_source_dist.attribute8:=NULL;--                    po_req_distributions_all.attribute8%TYPE,

          v_source_dist.attribute9:=NULL;--                    po_req_distributions_all.attribute9%TYPE,

          v_source_dist.attribute10:=NULL;--                   po_req_distributions_all.attribute10%TYPE,

          v_source_dist.attribute11:=NULL;--                   po_req_distributions_all.attribute11%TYPE,

          v_source_dist.attribute12:=NULL;--                   po_req_distributions_all.attribute12%TYPE,

          v_source_dist.attribute13:=NULL;--                   po_req_distributions_all.attribute13%TYPE,

          v_source_dist.attribute14:=NULL;--                   po_req_distributions_all.attribute14%TYPE,

          v_source_dist.attribute15:=NULL;--                   po_req_distributions_all.attribute15%TYPE,

          v_source_dist.government_context:=NULL;--            po_req_distributions_all.government_context%TYPE,

          v_source_dist.project_id:=NULL;--  NUMBER,

          v_source_dist.project_no:=NULL;--  pa_projects_all.segment1%TYPE,

          v_source_dist.task_id:=NULL;-- NUMBER,

          v_source_dist.task_no:=NULL;-- pa_tasks.task_number%TYPE,

          v_source_dist.award_id:=NULL;-- po_req_distributions_all.award_id%TYPE,

          v_source_dist.expenditure_type:=NULL;--              po_req_distributions_all.expenditure_type%TYPE,

          v_source_dist.expenditure_org_name:=NULL;--  org_organization_definitions.organization_name%TYPE,

          v_source_dist.expenditure_item_date:=NULL;-- po_req_distributions_all.expenditure_item_date%TYPE,

          v_source_dist.EXPENDITURE_ORGANIZATION_ID:=NULL;-- po_req_distributions_all.EXPENDITURE_ORGANIZATION_ID%TYPE,

          v_source_dist.project_accounting_context:=NULL;--  po_req_distributions_all.project_accounting_context%TYPE,

          v_source_dist.error_message:=NULL;-- VARCHAR2(2000),

          v_source_dist.Submit_for_approval:='N';-- VARCHAR2(1),

          v_source_dist.note_to_approver:=NULL;-- VARCHAR2(2000),

          v_source_dist.preparer_id:=NULL;-- NUMBER,

          v_source_dist.authorization_status:='APPROVED';-- VARCHAR2(20),

          v_source_dist.oke_contract_line_num:=NULL;-- okc_k_lines_b.line_number%TYPE,

          v_source_dist.oke_contract_line_id:=NULL;-- po_req_distributions_all.oke_contract_line_id%TYPE,

          v_source_dist.oke_contract_deliverable_num:=NULL;-- oke_k_deliverables_b.deliverable_num%TYPE,

          v_source_dist.oke_contract_deliverable_id:=NULL;-- po_req_distributions_all.oke_contract_deliverable_id%TYPE,

          v_source_dist.dist_quantity:=NULL;-- NUMBER,

          v_source_dist.dist_amount:=NULL;-- NUMBER,

          v_source_dist.currency_amount:=NULL;-- NUMBER,

          v_source_dist.allocation_value:=NULL;-- NUMBER,

          v_source_dist.action_flag:='NEW';--  VARCHAR2(20) DEFAULT 'UPDATE', -- Internal Purpose

          v_source_dist.qty_amount_check:='N'; -- Internal Purpose

         

          v_source_tab2(1):=v_source_dist;

         

        po_requisition_update_pub.update_requisition

            (

            'False',

           'Y'   ,

            v_ret_stat,            

            v_msg_cnt,  

            v_msg_data,          

            'N',                 

            v_source_tab1,

            v_source_tab,

            v_source_tab2);

           

           

      END;

       

      When I execute the anonymous block I am getting error:

       

      ORA-06550: line 252, column 7:

      PLS-00306: wrong number or types of arguments in call to 'UPDATE_REQUISITION'

      ORA-06550: line 252, column 7:

      PL/SQL: Statement ignored

      06550. 00000 -  "line %s, column %s:\n%s"

      *Cause:    Usually a PL/SQL compilation error.

      *Action:

        • 1. Re: Getting Execution Error Calling po_requisition_update_pub.update_requisition
          1567114

          Hello,

           

          I corrected the above Anonymous block and able to execute the procedure.But now I am getting the Error Messages as:

           

          Error report -

          ORA-06502: PL/SQL: numeric or value error: character string buffer too small

          ORA-06512: at "APPS.PO_MESSAGE_S", line 411

          ORA-06512: at "APPS.PO_REQUISITION_VALIDATE_PVT", line 221

          ORA-06510: PL/SQL: unhandled user-defined exception

          ORA-06512: at "APPS.PO_REQUISITION_UPDATE_PVT", line 165

          ORA-06512: at "APPS.PO_REQUISITION_UPDATE_PUB", line 227

          ORA-06512: at line 256

          06502. 00000 -  "PL/SQL: numeric or value error%s"

          *Cause:    An arithmetic, numeric, string, conversion, or constraint error

                     occurred. For example, this error occurs if an attempt is made to

                     assign the value NULL to a variable declared NOT NULL, or if an

                     attempt is made to assign an integer larger than 99 to a variable

                     declared NUMBER(2).

          *Action:   Change the data, how it is manipulated, or how it is declared so

                     that values do not violate constraints.