77: END IF;
78:
79:
80: /* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE */
81: IF NOT itg_x_utils.g_initialized THEN
82: g_return_status := FND_API.G_RET_STS_ERROR;
83: itg_msg.incorrect_setup;
84:
85: IF (l_Debug_Level <= 1) THEN
92: FND_MSG_PUB.INITIALIZE;
93:
94: /*
95: FND_GLOBAL.apps_initialize(
96: user_id => nvl(fnd_profile.value('ITG_XML_USER'),itg_x_utils.c_user_id),
97: resp_id => itg_x_utils.c_resp_id,
98: resp_appl_id => itg_x_utils.c_resp_appl_id
99: );*/
100:
93:
94: /*
95: FND_GLOBAL.apps_initialize(
96: user_id => nvl(fnd_profile.value('ITG_XML_USER'),itg_x_utils.c_user_id),
97: resp_id => itg_x_utils.c_resp_id,
98: resp_appl_id => itg_x_utils.c_resp_appl_id
99: );*/
100:
101: -- po_acctions.close_po api checks for value of fnd_global.login_id
94: /*
95: FND_GLOBAL.apps_initialize(
96: user_id => nvl(fnd_profile.value('ITG_XML_USER'),itg_x_utils.c_user_id),
97: resp_id => itg_x_utils.c_resp_id,
98: resp_appl_id => itg_x_utils.c_resp_appl_id
99: );*/
100:
101: -- po_acctions.close_po api checks for value of fnd_global.login_id
102: -- fnd_global.apps_initialize sets it to -1,
102: -- fnd_global.apps_initialize sets it to -1,
103: -- hence calling FND_GLOBAl.INITIALIZE as a workaround.
104: -- this resolves the issue with the close_PO API failue
105: FND_GLOBAl.INITIALIZE(l_session_id,
106: nvl(fnd_profile.value('ITG_XML_USER'),itg_x_utils.c_user_id),
107: itg_x_utils.c_resp_id,
108: itg_x_utils.c_resp_appl_id,
109: 0, -1, 1, -1, -1, -1, -1, null,null,null,null,null,null,-1);
110:
103: -- hence calling FND_GLOBAl.INITIALIZE as a workaround.
104: -- this resolves the issue with the close_PO API failue
105: FND_GLOBAl.INITIALIZE(l_session_id,
106: nvl(fnd_profile.value('ITG_XML_USER'),itg_x_utils.c_user_id),
107: itg_x_utils.c_resp_id,
108: itg_x_utils.c_resp_appl_id,
109: 0, -1, 1, -1, -1, -1, -1, null,null,null,null,null,null,-1);
110:
111: MO_GLOBAL.init('PO');
104: -- this resolves the issue with the close_PO API failue
105: FND_GLOBAl.INITIALIZE(l_session_id,
106: nvl(fnd_profile.value('ITG_XML_USER'),itg_x_utils.c_user_id),
107: itg_x_utils.c_resp_id,
108: itg_x_utils.c_resp_appl_id,
109: 0, -1, 1, -1, -1, -1, -1, null,null,null,null,null,null,-1);
110:
111: MO_GLOBAL.init('PO');
112:
129:
130: CLN_CH_COLLABORATION_PKG.create_collaboration(
131: x_return_status => l_return_status,
132: x_msg_data => l_msg_buff,
133: p_app_id => itg_x_utils.c_application_id,
134: p_ref_id => p_refid,
135: p_org_id => p_org,
136: p_rel_no => p_rel,
137: p_doc_no => p_doc,
140: p_xmlg_transaction_subtype => p_xmlg_xstyp,
141: p_xmlg_document_id => p_xmlg_docid,
142: p_partner_doc_no => NULL, /* NOTE: ??? */
143: p_coll_type => p_clntyp,
144: p_tr_partner_type => itg_x_utils.c_party_type,
145: p_tr_partner_id => itg_x_utils.g_party_id,
146: p_tr_partner_site => itg_x_utils.g_party_site_id,
147: p_resend_flag => 'N',
148: p_resend_count => 0,
141: p_xmlg_document_id => p_xmlg_docid,
142: p_partner_doc_no => NULL, /* NOTE: ??? */
143: p_coll_type => p_clntyp,
144: p_tr_partner_type => itg_x_utils.c_party_type,
145: p_tr_partner_id => itg_x_utils.g_party_id,
146: p_tr_partner_site => itg_x_utils.g_party_site_id,
147: p_resend_flag => 'N',
148: p_resend_count => 0,
149: p_doc_owner => FND_GLOBAL.USER_ID,
142: p_partner_doc_no => NULL, /* NOTE: ??? */
143: p_coll_type => p_clntyp,
144: p_tr_partner_type => itg_x_utils.c_party_type,
145: p_tr_partner_id => itg_x_utils.g_party_id,
146: p_tr_partner_site => itg_x_utils.g_party_site_id,
147: p_resend_flag => 'N',
148: p_resend_count => 0,
149: p_doc_owner => FND_GLOBAL.USER_ID,
150: p_init_date => SYSDATE,
151: p_doc_creation_date => p_cdate,
152: p_doc_revision_date => NULL,
153: p_doc_type => p_doctyp,
154: p_doc_dir => 'IN',
155: p_coll_pt => itg_x_utils.c_xmlg_coll_pt,
156: p_xmlg_msg_id => NULL,
157: p_unique1 => NULL,
158: p_unique2 => NULL,
159: p_unique3 => NULL,
230: ELSE
231: x_return_status := '99';
232: END IF;
233:
234: x_return_message := itg_x_utils.getCBODDescMsg(true);
235:
236: Reap_Messages(
237: p_refid => p_refid,
238: p_doc => p_doc,
280: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Reap_Messages', 2);
281: END IF;
282:
283: /* g_return_message is not obtained from the FND stack */
284: /* It is based on itg_x_utils.getCBODDesc */
285: /* Removed batch management specifi code */
286:
287: IF nvl(g_collaboration_id,0) > 0 THEN
288: IF nvl(g_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
322: p_disposition => NULL,
323: p_coll_status => l_cln_status,
324: p_doc_type => g_doctyp,
325: p_doc_dir => 'IN',
326: p_coll_pt => itg_x_utils.c_coll_pt,
327: p_org_ref => NULL,
328: p_doc_status => l_doc_status,
329: p_notification_id => NULL,
330: p_msg_text => l_message,
328: p_doc_status => l_doc_status,
329: p_notification_id => NULL,
330: p_msg_text => l_message,
331: p_xmlg_msg_id => NULL,
332: p_tr_partner_type => itg_x_utils.c_party_type,
333: p_tr_partner_id => itg_x_utils.g_party_id,
334: p_tr_partner_site => itg_x_utils.g_party_site_id,
335: p_sender_component => NULL,
336: p_rosettanet_check_required => FALSE,
329: p_notification_id => NULL,
330: p_msg_text => l_message,
331: p_xmlg_msg_id => NULL,
332: p_tr_partner_type => itg_x_utils.c_party_type,
333: p_tr_partner_id => itg_x_utils.g_party_id,
334: p_tr_partner_site => itg_x_utils.g_party_site_id,
335: p_sender_component => NULL,
336: p_rosettanet_check_required => FALSE,
337: x_dtl_coll_id => l_dtl_id,
330: p_msg_text => l_message,
331: p_xmlg_msg_id => NULL,
332: p_tr_partner_type => itg_x_utils.c_party_type,
333: p_tr_partner_id => itg_x_utils.g_party_id,
334: p_tr_partner_site => itg_x_utils.g_party_site_id,
335: p_sender_component => NULL,
336: p_rosettanet_check_required => FALSE,
337: x_dtl_coll_id => l_dtl_id,
338: p_xmlg_internal_control_number => p_refid,