29: itg_debug_pub.Add('--- Entering create_outbound_collaboration ---' ,2);
30: END IF;
31:
32: IF funcmode = 'RUN' THEN
33: IF NOT itg_x_utils.g_initialized THEN
34: /* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE
35: * Missing Trading Partner setup and/or Connector uninitialized.
36: * Should never get here, since the workflow should not be activated.
37: */
61: /* See CLNPOWFB.pls */
62: CLN_CH_COLLABORATION_PKG.create_collaboration(
63: x_return_status => l_return_status,
64: x_msg_data => l_buff,
65: p_app_id => itg_x_utils.c_application_id,
66: p_ref_id => NULL,
67: p_org_id => l_org_id,
68: p_rel_no => l_rel_num,
69: p_doc_no => l_doc_num,
72: p_xmlg_transaction_subtype => l_xact_subtype,
73: p_xmlg_document_id => l_doc_id,
74: p_partner_doc_no => NULL, /* NOTE: ??? */
75: p_coll_type => l_cln_type,
76: p_tr_partner_type => itg_x_utils.c_party_type,
77: p_tr_partner_id => itg_x_utils.g_party_id,
78: p_tr_partner_site => itg_x_utils.g_party_site_id,
79: p_resend_flag => 'N',
80: p_resend_count => 0,
73: p_xmlg_document_id => l_doc_id,
74: p_partner_doc_no => NULL, /* NOTE: ??? */
75: p_coll_type => l_cln_type,
76: p_tr_partner_type => itg_x_utils.c_party_type,
77: p_tr_partner_id => itg_x_utils.g_party_id,
78: p_tr_partner_site => itg_x_utils.g_party_site_id,
79: p_resend_flag => 'N',
80: p_resend_count => 0,
81: p_doc_owner => FND_GLOBAL.USER_ID,
74: p_partner_doc_no => NULL, /* NOTE: ??? */
75: p_coll_type => l_cln_type,
76: p_tr_partner_type => itg_x_utils.c_party_type,
77: p_tr_partner_id => itg_x_utils.g_party_id,
78: p_tr_partner_site => itg_x_utils.g_party_site_id,
79: p_resend_flag => 'N',
80: p_resend_count => 0,
81: p_doc_owner => FND_GLOBAL.USER_ID,
82: p_init_date => SYSDATE,
83: p_doc_creation_date => SYSDATE, /* NOTE: value from record? */
84: p_doc_revision_date => SYSDATE,
85: p_doc_type => l_doc_type,
86: p_doc_dir => 'OUT',
87: p_coll_pt => itg_x_utils.c_coll_pt,
88: p_xmlg_msg_id => NULL,
89: p_unique1 => null,
90: p_unique2 => NULL,
91: p_unique3 => NULL,
150: itg_debug_pub.Add('--- Entering update_outbound_collaboration ---' ,2);
151: END IF;
152:
153: IF funcmode = 'RUN' THEN
154: IF NOT itg_x_utils.g_initialized THEN
155: /* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE
156: * Missing Trading Partner setup and/or Connector uninitialized.
157: * Should never get here, since the workflow should not be activated.
158: */
177: x_return_status => l_return_status,
178: x_msg_data => l_buff,
179: p_coll_id => l_coll_id,
180: /* Returned from previous call */
181: p_app_id => itg_x_utils.c_application_id,
182: p_ref_id => l_ref_id,
183: /* The value of
184: p_rel_no => NULL,
185: p_doc_no => NULL,
192: p_disposition => NULL,
193: p_coll_status => 'COMPLETED',
194: p_doc_type => l_doc_type,
195: p_doc_dir => 'OUT',
196: p_coll_pt => itg_x_utils.c_xmlg_coll_pt,
197: p_org_ref => NULL,
198: p_doc_status => 'SUCCESS',
199: p_notification_id => NULL,
200: p_msg_text => 'Document successfully sent',
197: p_org_ref => NULL,
198: p_doc_status => 'SUCCESS',
199: p_notification_id => NULL,
200: p_msg_text => 'Document successfully sent',
201: p_tr_partner_type => itg_x_utils.c_party_type,
202: p_tr_partner_id => itg_x_utils.g_party_id,
203: p_tr_partner_site => itg_x_utils.g_party_site_id,
204: p_sender_component => NULL,
205: p_rosettanet_check_required => FALSE,
198: p_doc_status => 'SUCCESS',
199: p_notification_id => NULL,
200: p_msg_text => 'Document successfully sent',
201: p_tr_partner_type => itg_x_utils.c_party_type,
202: p_tr_partner_id => itg_x_utils.g_party_id,
203: p_tr_partner_site => itg_x_utils.g_party_site_id,
204: p_sender_component => NULL,
205: p_rosettanet_check_required => FALSE,
206: p_xmlg_msg_id => l_xmlg_msg_id,
199: p_notification_id => NULL,
200: p_msg_text => 'Document successfully sent',
201: p_tr_partner_type => itg_x_utils.c_party_type,
202: p_tr_partner_id => itg_x_utils.g_party_id,
203: p_tr_partner_site => itg_x_utils.g_party_site_id,
204: p_sender_component => NULL,
205: p_rosettanet_check_required => FALSE,
206: p_xmlg_msg_id => l_xmlg_msg_id,
207: x_dtl_coll_id => l_collaboration_dtl_id,
292: END IF;
293: END;
294: END IF;
295:
296: IF NOT itg_x_utils.g_initialized THEN
297: /* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE
298: * Missing Trading Partner setup and/or Connector uninitialized.
299: * Should never get here, since the workflow should not be activated.
300: */
328: x_return_status => l_return_status,
329: x_msg_data => l_buff,
330: p_coll_id => l_coll_id,
331: /* Returned from previous call */
332: p_app_id => itg_x_utils.c_application_id,
333: p_ref_id => NULL,
334: p_rel_no => NULL,
335: p_doc_no => NULL,
336: p_doc_rev_no => NULL,
342: p_disposition => NULL,
343: p_coll_status => l_coll_status, /*'COMPLETED',*/
344: p_doc_type => l_doc_type,
345: p_doc_dir => 'OUT',
346: p_coll_pt => itg_x_utils.c_xmlg_coll_pt,
347: p_org_ref => NULL,
348: p_doc_status => 'SUCCESS',
349: p_notification_id => NULL,
350: p_msg_text => 'Document successfully sent',
347: p_org_ref => NULL,
348: p_doc_status => 'SUCCESS',
349: p_notification_id => NULL,
350: p_msg_text => 'Document successfully sent',
351: p_tr_partner_type => itg_x_utils.c_party_type,
352: p_tr_partner_id => itg_x_utils.g_party_id,
353: p_tr_partner_site => itg_x_utils.g_party_site_id,
354: p_sender_component => NULL,
355: p_rosettanet_check_required => FALSE,
348: p_doc_status => 'SUCCESS',
349: p_notification_id => NULL,
350: p_msg_text => 'Document successfully sent',
351: p_tr_partner_type => itg_x_utils.c_party_type,
352: p_tr_partner_id => itg_x_utils.g_party_id,
353: p_tr_partner_site => itg_x_utils.g_party_site_id,
354: p_sender_component => NULL,
355: p_rosettanet_check_required => FALSE,
356: p_xmlg_msg_id => l_xmlg_msg_id,
349: p_notification_id => NULL,
350: p_msg_text => 'Document successfully sent',
351: p_tr_partner_type => itg_x_utils.c_party_type,
352: p_tr_partner_id => itg_x_utils.g_party_id,
353: p_tr_partner_site => itg_x_utils.g_party_site_id,
354: p_sender_component => NULL,
355: p_rosettanet_check_required => FALSE,
356: p_xmlg_msg_id => l_xmlg_msg_id,
357: x_dtl_coll_id => l_collaboration_dtl_id
450: END IF;
451: null; -- if any error, continue to use current session langauge.
452: END;
453:
454: l_cbod_message := itg_x_utils.translateCBODDescMsg(p_msg_list=> parameter7);
455:
456: IF (l_Debug_Level <= 1) THEN
457: itg_debug_pub.Add('l_cbod_message' || l_cbod_message ,1);
458: END IF;