APPS.GR_WF_UTIL_PVT dependencies on GMI_RESERVATION_UTIL

Line 92: -- gmi_reservation_util.println('PAL inside OUR GetXMLTP ');

88: select ecx_trigger_id_s.NEXTVAL
89: from dual;
90:
91: BEGIN
92: -- gmi_reservation_util.println('PAL inside OUR GetXMLTP ');
93: -- gmd_pl_log('PAL inside OUR GetXMLTP ');
94:
95: /* Set Transaction Type, Tx subtype. */
96: transaction_type := 'GR';

Line 203: -- gmi_reservation_util.println('PAL leaving OUR GetXMLTP ');

199: to_char(actid),
200: funcmode);
201: raise;
202: --gmd_pl_log('PAL leaving OUR GetXMLTP ');
203: -- gmi_reservation_util.println('PAL leaving OUR GetXMLTP ');
204: end;
205:
206:
207:

Line 302: -- gmi_reservation_util.println('PAL inside GET_ITEM_DETAILS ');

298:
299: BEGIN
300: /* Check to see if the item exists in Process Inventory and get the Item details*/
301:
302: -- gmi_reservation_util.println('PAL inside GET_ITEM_DETAILS ');
303: -- gmd_pl_log('PAL inside GET_ITEM_DETAILS');
304:
305: -- gmi_reservation_util.println('p_orgn_id : ' || p_orgn_id ||
306:

Line 305: -- gmi_reservation_util.println('p_orgn_id : ' || p_orgn_id ||

301:
302: -- gmi_reservation_util.println('PAL inside GET_ITEM_DETAILS ');
303: -- gmd_pl_log('PAL inside GET_ITEM_DETAILS');
304:
305: -- gmi_reservation_util.println('p_orgn_id : ' || p_orgn_id ||
306:
307:
308: OPEN get_item_details;
309: FETCH get_item_details INTO p_item_no, p_item_desc;

Line 312: --gmi_reservation_util.println('PAL get_item_details - SQL%NOTFOUND ');

308: OPEN get_item_details;
309: FETCH get_item_details INTO p_item_no, p_item_desc;
310:
311: IF (get_item_details %NOTFOUND) THEN
312: --gmi_reservation_util.println('PAL get_item_details - SQL%NOTFOUND ');
313: --P_item_no := ' '; -- 6750439
314: P_item_desc := ' ';
315: P_item_no := NULL; -- 6750439
316:

Line 757: --gmi_reservation_util.println('PAL inside Gr_Wf_Util_PVT.SEND_OUTBOUND_DOCUMENT ');

753: l_ws_service_namespace_profile VARCHAR2(150) := nvl (FND_PROFILE.VALUE ('GR_WS_SERVICE_NAMESPACE'),'http://ap6192rt.us.oracle.com/oracle/apps/fnd/XMLGateway/ReceiveDocument');
754:
755:
756: BEGIN
757: --gmi_reservation_util.println('PAL inside Gr_Wf_Util_PVT.SEND_OUTBOUND_DOCUMENT ');
758: wf_event_t.initialize(p_event);
759:
760: l_party_site_id := FND_PROFILE.VALUE('GR_3RD_PARTY_SITE_ID');
761:

Line 771: --gmi_reservation_util.println('PAL ECX_TP_HEADERS - SQL%NOTFOUND ');

767: FROM ECX_TP_HEADERS
768: WHERE PARTY_SITE_ID = l_party_site_id;
769:
770: IF SQL%NOTFOUND THEN
771: --gmi_reservation_util.println('PAL ECX_TP_HEADERS - SQL%NOTFOUND ');
772:
773:
774: RETURN;
775: END IF;

Line 838: -- gmi_reservation_util.println('PAL l_soap_profile = ' || l_soap_profile );

834: p_value=>l_soap_profile,
835: --p_value=>'http://ap6192rt.us.oracle.com/oracle/apps/fnd/XMLGateway/ReceiveDocument',
836: p_parameterlist=>l_parameter_list);
837:
838: -- gmi_reservation_util.println('PAL l_soap_profile = ' || l_soap_profile );
839: wf_event.AddParameterToList( p_name=>'WS_SERVICE_NAMESPACE',
840: p_value=>l_ws_service_namespace_profile,
841: --p_value=>'http://ap6192rt.us.oracle.com/oracle/apps/fnd/XMLGateway',
842: p_parameterlist=>l_parameter_list);

Line 843: --gmi_reservation_util.println('PAL l_ws_service_namespace_profile = ' || l_ws_service_namespace_profile);

839: wf_event.AddParameterToList( p_name=>'WS_SERVICE_NAMESPACE',
840: p_value=>l_ws_service_namespace_profile,
841: --p_value=>'http://ap6192rt.us.oracle.com/oracle/apps/fnd/XMLGateway',
842: p_parameterlist=>l_parameter_list);
843: --gmi_reservation_util.println('PAL l_ws_service_namespace_profile = ' || l_ws_service_namespace_profile);
844: SELECT gr_item_information_seq.nextval
845: INTO l_event_key
846: FROM DUAL;
847: IF SQL%NOTFOUND THEN

Line 848: gmi_reservation_util.println('PAL DUAL - SQL%NOTFOUND ');

844: SELECT gr_item_information_seq.nextval
845: INTO l_event_key
846: FROM DUAL;
847: IF SQL%NOTFOUND THEN
848: gmi_reservation_util.println('PAL DUAL - SQL%NOTFOUND ');
849: END IF;
850:
851: l_event_name := 'oracle.apps.gr.message.send';
852:

Line 853: --gmi_reservation_util.println('PAL about to call wf_event.raise ');

849: END IF;
850:
851: l_event_name := 'oracle.apps.gr.message.send';
852:
853: --gmi_reservation_util.println('PAL about to call wf_event.raise ');
854:
855: wf_event.raise( p_event_name => l_event_name,
856: p_event_key => l_event_key,
857: p_parameters => l_parameter_list);