0 Replies Latest reply on Jul 1, 2011 1:57 AM by N@*841964*

    Issue with po_document_actions_sv.po_request_action in R12(Reserve PO)

    N@*841964*
      Hi Gurus,

      I need some technical assistance in procurement process. I have one request set where number of interfaces are used to create whole PO cycle, intially to create PR first. Once PR is successfully created then I am creating the PO by using package 'po_interface_s' (autocreate). Once PO is created I need to reserve by using this
      po_document_actions_sv.po_request_action package. I am passing the 'RESERVE' as action. Below mentioned is the snippet of the code
      declare
       vn_result             NUMBER          := NULL;
            action                VARCHAR2 (25)   := 'RESERVE';
            document_type         VARCHAR2 (25)   := 'PO';
            document_subtype      VARCHAR2 (25)   := 'STANDARD';
            document_id           NUMBER;
            line_id               NUMBER          := NULL;
            shipment_id           NUMBER          := NULL;
            distribution_id       NUMBER          := NULL;
            employee_id           NUMBER          := 59;
            new_document_status   VARCHAR2 (30)   := 'APPROVED';
            offline_code          VARCHAR2 (1)    := 'Y';
            note                  VARCHAR2 (240)  := NULL;
            approval_path_id      NUMBER          := NULL;
            forward_to_id         NUMBER;
            action_date           DATE            := NULL;
            override_funds        VARCHAR2 (1)    := NULL;
            info_request          VARCHAR2 (25);
            document_status       VARCHAR2 (240);
            online_report_id      NUMBER;
            return_code           VARCHAR2 (25);
            error_msg             VARCHAR2 (2000);
         BEGIN
            document_id := vn_document_id;
            vn_result :=
               po_document_actions_sv.po_request_action (action,
                                                         document_type,
                                                         document_subtype,
                                                         document_id,
                                                         line_id,
                                                         shipment_id,
                                                         distribution_id,
                                                         employee_id,
                                                         new_document_status,
                                                         offline_code,
                                                         note,
                                                         approval_path_id,
                                                         forward_to_id,
                                                         action_date,
                                                         override_funds,
                                                         info_request,
                                                         document_status,
                                                         online_report_id,
                                                         return_code,
                                                         error_msg
                                                        );
      end;
      But this package is not at all reserving PO in R12. This code was successfully working in 11.5.7, as it is standard package I hope it has to work as expected.

      I tried to google on this package, but I did not find any source for this package. Please give me some technical inputs for this package. Or is there anything do with workflow process in R12.

      Thanks in advance for your help.

      Regards,
      Nagendra