eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_NP_PROCESSOR_PKG dependencies on ECX_CLN_DEBUG_PUB

Line 57: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');

53: l_debug_mode VARCHAR2(255);
54: l_embedded_notif_screen VARCHAR2(5);
55: BEGIN
56: -- Sets the debug mode to FILE
57: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
58: IF (l_Debug_Level <= 2) THEN
59: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);
60: END IF;
61:

Line 59: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);

55: BEGIN
56: -- Sets the debug mode to FILE
57: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
58: IF (l_Debug_Level <= 2) THEN
59: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);
60: END IF;
61:
62: IF (l_Debug_Level <= 1) THEN
63: ecx_cln_debug_pub.Add('E-Mail to be sent to :' || p_role , 1);

Line 63: ecx_cln_debug_pub.Add('E-Mail to be sent to :' || p_role , 1);

59: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);
60: END IF;
61:
62: IF (l_Debug_Level <= 1) THEN
63: ecx_cln_debug_pub.Add('E-Mail to be sent to :' || p_role , 1);
64: ecx_cln_debug_pub.Add('With the following parameters :', 1);
65: ecx_cln_debug_pub.Add('TO_TP_OR_ADMIN :' || p_admin_or_tp, 1);
66: ecx_cln_debug_pub.Add('P_Role :' || p_role, 1);
67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);

Line 64: ecx_cln_debug_pub.Add('With the following parameters :', 1);

60: END IF;
61:
62: IF (l_Debug_Level <= 1) THEN
63: ecx_cln_debug_pub.Add('E-Mail to be sent to :' || p_role , 1);
64: ecx_cln_debug_pub.Add('With the following parameters :', 1);
65: ecx_cln_debug_pub.Add('TO_TP_OR_ADMIN :' || p_admin_or_tp, 1);
66: ecx_cln_debug_pub.Add('P_Role :' || p_role, 1);
67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);
68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);

Line 65: ecx_cln_debug_pub.Add('TO_TP_OR_ADMIN :' || p_admin_or_tp, 1);

61:
62: IF (l_Debug_Level <= 1) THEN
63: ecx_cln_debug_pub.Add('E-Mail to be sent to :' || p_role , 1);
64: ecx_cln_debug_pub.Add('With the following parameters :', 1);
65: ecx_cln_debug_pub.Add('TO_TP_OR_ADMIN :' || p_admin_or_tp, 1);
66: ecx_cln_debug_pub.Add('P_Role :' || p_role, 1);
67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);
68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);
69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);

Line 66: ecx_cln_debug_pub.Add('P_Role :' || p_role, 1);

62: IF (l_Debug_Level <= 1) THEN
63: ecx_cln_debug_pub.Add('E-Mail to be sent to :' || p_role , 1);
64: ecx_cln_debug_pub.Add('With the following parameters :', 1);
65: ecx_cln_debug_pub.Add('TO_TP_OR_ADMIN :' || p_admin_or_tp, 1);
66: ecx_cln_debug_pub.Add('P_Role :' || p_role, 1);
67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);
68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);
69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);
70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);

Line 67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);

63: ecx_cln_debug_pub.Add('E-Mail to be sent to :' || p_role , 1);
64: ecx_cln_debug_pub.Add('With the following parameters :', 1);
65: ecx_cln_debug_pub.Add('TO_TP_OR_ADMIN :' || p_admin_or_tp, 1);
66: ecx_cln_debug_pub.Add('P_Role :' || p_role, 1);
67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);
68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);
69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);
70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);
71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);

Line 68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);

64: ecx_cln_debug_pub.Add('With the following parameters :', 1);
65: ecx_cln_debug_pub.Add('TO_TP_OR_ADMIN :' || p_admin_or_tp, 1);
66: ecx_cln_debug_pub.Add('P_Role :' || p_role, 1);
67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);
68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);
69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);
70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);
71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);
72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);

Line 69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);

65: ecx_cln_debug_pub.Add('TO_TP_OR_ADMIN :' || p_admin_or_tp, 1);
66: ecx_cln_debug_pub.Add('P_Role :' || p_role, 1);
67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);
68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);
69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);
70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);
71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);
72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);
73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);

Line 70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);

66: ecx_cln_debug_pub.Add('P_Role :' || p_role, 1);
67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);
68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);
69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);
70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);
71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);
72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);
73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);
74: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_revision_number, 1);

Line 71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);

67: ecx_cln_debug_pub.Add('NOTIFICATION_CODE :' || p_notification_code, 1);
68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);
69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);
70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);
71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);
72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);
73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);
74: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_revision_number, 1);
75: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_release_number, 1);

Line 72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);

68: ecx_cln_debug_pub.Add('NOTIFICATION_DESC :' || p_notification_desc, 1);
69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);
70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);
71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);
72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);
73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);
74: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_revision_number, 1);
75: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_release_number, 1);
76: ecx_cln_debug_pub.Add('COLLABORATION_ID :' || p_collaboration_id, 1);

Line 73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);

69: ecx_cln_debug_pub.Add('NOTIFICATION_MESSAGE :' || p_notification_mesg, 1);
70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);
71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);
72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);
73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);
74: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_revision_number, 1);
75: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_release_number, 1);
76: ecx_cln_debug_pub.Add('COLLABORATION_ID :' || p_collaboration_id, 1);
77: ecx_cln_debug_pub.Add('COLLABORATION_TYPE :' || p_collaboration_type, 1);

Line 74: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_revision_number, 1);

70: ecx_cln_debug_pub.Add('APPLICATION_NAME :' || p_application_name, 1);
71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);
72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);
73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);
74: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_revision_number, 1);
75: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_release_number, 1);
76: ecx_cln_debug_pub.Add('COLLABORATION_ID :' || p_collaboration_id, 1);
77: ecx_cln_debug_pub.Add('COLLABORATION_TYPE :' || p_collaboration_type, 1);
78: END IF;

Line 75: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_release_number, 1);

71: ecx_cln_debug_pub.Add('ORG_ID :' || p_org_id, 1);
72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);
73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);
74: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_revision_number, 1);
75: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_release_number, 1);
76: ecx_cln_debug_pub.Add('COLLABORATION_ID :' || p_collaboration_id, 1);
77: ecx_cln_debug_pub.Add('COLLABORATION_TYPE :' || p_collaboration_type, 1);
78: END IF;
79:

Line 76: ecx_cln_debug_pub.Add('COLLABORATION_ID :' || p_collaboration_id, 1);

72: ecx_cln_debug_pub.Add('DOCUMENT_NUMBER :' || p_document_number, 1);
73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);
74: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_revision_number, 1);
75: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_release_number, 1);
76: ecx_cln_debug_pub.Add('COLLABORATION_ID :' || p_collaboration_id, 1);
77: ecx_cln_debug_pub.Add('COLLABORATION_TYPE :' || p_collaboration_type, 1);
78: END IF;
79:
80: l_embedded_notif_screen := FND_PROFILE.VALUE('CLN_EMBEDDED_NOT_SCREEN');

Line 77: ecx_cln_debug_pub.Add('COLLABORATION_TYPE :' || p_collaboration_type, 1);

73: ecx_cln_debug_pub.Add('REVISION_NUMBER :' || p_revision_number, 1);
74: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_revision_number, 1);
75: ecx_cln_debug_pub.Add('RELEASE_NUMBER :' || p_release_number, 1);
76: ecx_cln_debug_pub.Add('COLLABORATION_ID :' || p_collaboration_id, 1);
77: ecx_cln_debug_pub.Add('COLLABORATION_TYPE :' || p_collaboration_type, 1);
78: END IF;
79:
80: l_embedded_notif_screen := FND_PROFILE.VALUE('CLN_EMBEDDED_NOT_SCREEN');
81: IF (l_Debug_Level <= 1) THEN

Line 82: ecx_cln_debug_pub.Add('Embedded Notification reqd :' || l_embedded_notif_screen , 1);

78: END IF;
79:
80: l_embedded_notif_screen := FND_PROFILE.VALUE('CLN_EMBEDDED_NOT_SCREEN');
81: IF (l_Debug_Level <= 1) THEN
82: ecx_cln_debug_pub.Add('Embedded Notification reqd :' || l_embedded_notif_screen , 1);
83: END IF;
84:
85: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
86:

Line 89: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_SOMEONE', 1);

85: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
86:
87: IF(l_embedded_notif_screen = 'N') THEN
88: IF (l_Debug_Level <= 1) THEN
89: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_SOMEONE', 1);
90: END IF;
91:
92: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_SOMEONE');
93: ELSE

Line 95: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_SOMEONE_EMBEDDED_RGN', 1);

91:
92: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_SOMEONE');
93: ELSE
94: IF (l_Debug_Level <= 1) THEN
95: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_SOMEONE_EMBEDDED_RGN', 1);
96: END IF;
97:
98: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_SOMEONE_EMBEDDED_RGN');
99: END IF;

Line 120: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);

116: -- if not then continue with the old code and if no, then we call different process
117:
118:
119: IF (l_Debug_Level <= 2) THEN
120: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);
121: END IF;
122:
123: END SEND_MAIL;
124:

Line 212: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');

208: ORDER BY details.ACTION_DTL_ID;
209:
210: BEGIN
211: -- Sets the debug mode to be FILE
212: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
213: IF (l_Debug_Level <= 2) THEN
214: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
215: END IF;
216:

Line 214: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);

210: BEGIN
211: -- Sets the debug mode to be FILE
212: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
213: IF (l_Debug_Level <= 2) THEN
214: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
215: END IF;
216:
217: IF (l_Debug_Level <= 1) THEN
218: ecx_cln_debug_pub.Add('With the following parameters:', 1);

Line 218: ecx_cln_debug_pub.Add('With the following parameters:', 1);

214: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
215: END IF;
216:
217: IF (l_Debug_Level <= 1) THEN
218: ecx_cln_debug_pub.Add('With the following parameters:', 1);
219: ecx_cln_debug_pub.Add('p_notification_code:' || p_notification_code, 1);
220: ecx_cln_debug_pub.Add('p_notification_desc:' || p_notification_desc, 1);
221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);

Line 219: ecx_cln_debug_pub.Add('p_notification_code:' || p_notification_code, 1);

215: END IF;
216:
217: IF (l_Debug_Level <= 1) THEN
218: ecx_cln_debug_pub.Add('With the following parameters:', 1);
219: ecx_cln_debug_pub.Add('p_notification_code:' || p_notification_code, 1);
220: ecx_cln_debug_pub.Add('p_notification_desc:' || p_notification_desc, 1);
221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
223: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);

Line 220: ecx_cln_debug_pub.Add('p_notification_desc:' || p_notification_desc, 1);

216:
217: IF (l_Debug_Level <= 1) THEN
218: ecx_cln_debug_pub.Add('With the following parameters:', 1);
219: ecx_cln_debug_pub.Add('p_notification_code:' || p_notification_code, 1);
220: ecx_cln_debug_pub.Add('p_notification_desc:' || p_notification_desc, 1);
221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
223: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
224: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);

Line 221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);

217: IF (l_Debug_Level <= 1) THEN
218: ecx_cln_debug_pub.Add('With the following parameters:', 1);
219: ecx_cln_debug_pub.Add('p_notification_code:' || p_notification_code, 1);
220: ecx_cln_debug_pub.Add('p_notification_desc:' || p_notification_desc, 1);
221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
223: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
224: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
225: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);

Line 222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);

218: ecx_cln_debug_pub.Add('With the following parameters:', 1);
219: ecx_cln_debug_pub.Add('p_notification_code:' || p_notification_code, 1);
220: ecx_cln_debug_pub.Add('p_notification_desc:' || p_notification_desc, 1);
221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
223: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
224: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
225: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
226: END IF;

Line 223: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);

219: ecx_cln_debug_pub.Add('p_notification_code:' || p_notification_code, 1);
220: ecx_cln_debug_pub.Add('p_notification_desc:' || p_notification_desc, 1);
221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
223: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
224: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
225: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
226: END IF;
227:

Line 224: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);

220: ecx_cln_debug_pub.Add('p_notification_desc:' || p_notification_desc, 1);
221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
223: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
224: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
225: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
226: END IF;
227:
228:

Line 225: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);

221: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
222: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
223: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
224: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
225: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
226: END IF;
227:
228:
229: IF(p_update_collaboration_flag) THEN

Line 231: ecx_cln_debug_pub.Add('p_update_collaboration_flag:TRUE', 1);

227:
228:
229: IF(p_update_collaboration_flag) THEN
230: IF (l_Debug_Level <= 1) THEN
231: ecx_cln_debug_pub.Add('p_update_collaboration_flag:TRUE', 1);
232: END IF;
233: ELSE
234: IF (l_Debug_Level <= 1) THEN
235: ecx_cln_debug_pub.Add('p_update_collaboration_flag:FALSE', 1);

Line 235: ecx_cln_debug_pub.Add('p_update_collaboration_flag:FALSE', 1);

231: ecx_cln_debug_pub.Add('p_update_collaboration_flag:TRUE', 1);
232: END IF;
233: ELSE
234: IF (l_Debug_Level <= 1) THEN
235: ecx_cln_debug_pub.Add('p_update_collaboration_flag:FALSE', 1);
236: END IF;
237: END IF;
238:
239: IF(p_update_coll_mess_flag) THEN

Line 241: ecx_cln_debug_pub.Add('p_update_coll_mess_flag:TRUE', 1);

237: END IF;
238:
239: IF(p_update_coll_mess_flag) THEN
240: IF (l_Debug_Level <= 1) THEN
241: ecx_cln_debug_pub.Add('p_update_coll_mess_flag:TRUE', 1);
242: END IF;
243: ELSE
244: IF (l_Debug_Level <= 1) THEN
245: ecx_cln_debug_pub.Add('p_update_coll_mess_flag:FALSE', 1);

Line 245: ecx_cln_debug_pub.Add('p_update_coll_mess_flag:FALSE', 1);

241: ecx_cln_debug_pub.Add('p_update_coll_mess_flag:TRUE', 1);
242: END IF;
243: ELSE
244: IF (l_Debug_Level <= 1) THEN
245: ecx_cln_debug_pub.Add('p_update_coll_mess_flag:FALSE', 1);
246: END IF;
247: END IF;
248:
249: IF (l_Debug_Level <= 1) THEN

Line 250: ecx_cln_debug_pub.Add('p_all_notification_codes:' || p_all_notification_codes, 1);

246: END IF;
247: END IF;
248:
249: IF (l_Debug_Level <= 1) THEN
250: ecx_cln_debug_pub.Add('p_all_notification_codes:' || p_all_notification_codes, 1);
251: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
252: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
253: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
254: ecx_cln_debug_pub.Add('Collaboration ID:' || p_coll_id, 1);

Line 251: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);

247: END IF;
248:
249: IF (l_Debug_Level <= 1) THEN
250: ecx_cln_debug_pub.Add('p_all_notification_codes:' || p_all_notification_codes, 1);
251: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
252: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
253: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
254: ecx_cln_debug_pub.Add('Collaboration ID:' || p_coll_id, 1);
255: END IF;

Line 252: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);

248:
249: IF (l_Debug_Level <= 1) THEN
250: ecx_cln_debug_pub.Add('p_all_notification_codes:' || p_all_notification_codes, 1);
251: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
252: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
253: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
254: ecx_cln_debug_pub.Add('Collaboration ID:' || p_coll_id, 1);
255: END IF;
256:

Line 253: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);

249: IF (l_Debug_Level <= 1) THEN
250: ecx_cln_debug_pub.Add('p_all_notification_codes:' || p_all_notification_codes, 1);
251: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
252: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
253: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
254: ecx_cln_debug_pub.Add('Collaboration ID:' || p_coll_id, 1);
255: END IF;
256:
257:

Line 254: ecx_cln_debug_pub.Add('Collaboration ID:' || p_coll_id, 1);

250: ecx_cln_debug_pub.Add('p_all_notification_codes:' || p_all_notification_codes, 1);
251: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
252: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
253: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
254: ecx_cln_debug_pub.Add('Collaboration ID:' || p_coll_id, 1);
255: END IF;
256:
257:
258: x_ret_code := FND_API.G_RET_STS_SUCCESS;

Line 265: ecx_cln_debug_pub.Add('Take Actions :' || p_notification_code, 1);

261:
262:
263: BEGIN
264: IF (l_Debug_Level <= 1) THEN
265: ecx_cln_debug_pub.Add('Take Actions :' || p_notification_code, 1);
266: END IF;
267:
268: -- Query collaboration history header for information using the reference
269: IF ( (p_coll_id IS NOT NULL) AND (LENGTH(TRIM(p_coll_id)) <> 0) ) THEN

Line 304: ecx_cln_debug_pub.Add('l_tp_id:' || l_tp_id, 1);

300: END IF;
301: END IF;
302:
303: IF (l_Debug_Level <= 1) THEN
304: ecx_cln_debug_pub.Add('l_tp_id:' || l_tp_id, 1);
305: ecx_cln_debug_pub.Add('Queried the following from Collaboration History', 1);
306: ecx_cln_debug_pub.Add('l_application_id:' || l_application_id, 1);
307: ecx_cln_debug_pub.Add('l_collaboration_type:' || l_collaboration_type, 1);
308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);

Line 305: ecx_cln_debug_pub.Add('Queried the following from Collaboration History', 1);

301: END IF;
302:
303: IF (l_Debug_Level <= 1) THEN
304: ecx_cln_debug_pub.Add('l_tp_id:' || l_tp_id, 1);
305: ecx_cln_debug_pub.Add('Queried the following from Collaboration History', 1);
306: ecx_cln_debug_pub.Add('l_application_id:' || l_application_id, 1);
307: ecx_cln_debug_pub.Add('l_collaboration_type:' || l_collaboration_type, 1);
308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
309: ecx_cln_debug_pub.Add('l_document_number:' || l_document_number, 1);

Line 306: ecx_cln_debug_pub.Add('l_application_id:' || l_application_id, 1);

302:
303: IF (l_Debug_Level <= 1) THEN
304: ecx_cln_debug_pub.Add('l_tp_id:' || l_tp_id, 1);
305: ecx_cln_debug_pub.Add('Queried the following from Collaboration History', 1);
306: ecx_cln_debug_pub.Add('l_application_id:' || l_application_id, 1);
307: ecx_cln_debug_pub.Add('l_collaboration_type:' || l_collaboration_type, 1);
308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
309: ecx_cln_debug_pub.Add('l_document_number:' || l_document_number, 1);
310: ecx_cln_debug_pub.Add('l_revision_number:' || l_revision_number, 1);

Line 307: ecx_cln_debug_pub.Add('l_collaboration_type:' || l_collaboration_type, 1);

303: IF (l_Debug_Level <= 1) THEN
304: ecx_cln_debug_pub.Add('l_tp_id:' || l_tp_id, 1);
305: ecx_cln_debug_pub.Add('Queried the following from Collaboration History', 1);
306: ecx_cln_debug_pub.Add('l_application_id:' || l_application_id, 1);
307: ecx_cln_debug_pub.Add('l_collaboration_type:' || l_collaboration_type, 1);
308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
309: ecx_cln_debug_pub.Add('l_document_number:' || l_document_number, 1);
310: ecx_cln_debug_pub.Add('l_revision_number:' || l_revision_number, 1);
311: ecx_cln_debug_pub.Add('l_release_number:' || l_release_number, 1);

Line 308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);

304: ecx_cln_debug_pub.Add('l_tp_id:' || l_tp_id, 1);
305: ecx_cln_debug_pub.Add('Queried the following from Collaboration History', 1);
306: ecx_cln_debug_pub.Add('l_application_id:' || l_application_id, 1);
307: ecx_cln_debug_pub.Add('l_collaboration_type:' || l_collaboration_type, 1);
308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
309: ecx_cln_debug_pub.Add('l_document_number:' || l_document_number, 1);
310: ecx_cln_debug_pub.Add('l_revision_number:' || l_revision_number, 1);
311: ecx_cln_debug_pub.Add('l_release_number:' || l_release_number, 1);
312: ecx_cln_debug_pub.Add('l_collaboration_id:' || l_collaboration_id, 1);

Line 309: ecx_cln_debug_pub.Add('l_document_number:' || l_document_number, 1);

305: ecx_cln_debug_pub.Add('Queried the following from Collaboration History', 1);
306: ecx_cln_debug_pub.Add('l_application_id:' || l_application_id, 1);
307: ecx_cln_debug_pub.Add('l_collaboration_type:' || l_collaboration_type, 1);
308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
309: ecx_cln_debug_pub.Add('l_document_number:' || l_document_number, 1);
310: ecx_cln_debug_pub.Add('l_revision_number:' || l_revision_number, 1);
311: ecx_cln_debug_pub.Add('l_release_number:' || l_release_number, 1);
312: ecx_cln_debug_pub.Add('l_collaboration_id:' || l_collaboration_id, 1);
313: END IF;

Line 310: ecx_cln_debug_pub.Add('l_revision_number:' || l_revision_number, 1);

306: ecx_cln_debug_pub.Add('l_application_id:' || l_application_id, 1);
307: ecx_cln_debug_pub.Add('l_collaboration_type:' || l_collaboration_type, 1);
308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
309: ecx_cln_debug_pub.Add('l_document_number:' || l_document_number, 1);
310: ecx_cln_debug_pub.Add('l_revision_number:' || l_revision_number, 1);
311: ecx_cln_debug_pub.Add('l_release_number:' || l_release_number, 1);
312: ecx_cln_debug_pub.Add('l_collaboration_id:' || l_collaboration_id, 1);
313: END IF;
314:

Line 311: ecx_cln_debug_pub.Add('l_release_number:' || l_release_number, 1);

307: ecx_cln_debug_pub.Add('l_collaboration_type:' || l_collaboration_type, 1);
308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
309: ecx_cln_debug_pub.Add('l_document_number:' || l_document_number, 1);
310: ecx_cln_debug_pub.Add('l_revision_number:' || l_revision_number, 1);
311: ecx_cln_debug_pub.Add('l_release_number:' || l_release_number, 1);
312: ecx_cln_debug_pub.Add('l_collaboration_id:' || l_collaboration_id, 1);
313: END IF;
314:
315:

Line 312: ecx_cln_debug_pub.Add('l_collaboration_id:' || l_collaboration_id, 1);

308: ecx_cln_debug_pub.Add('l_org_id:' || l_org_id, 1);
309: ecx_cln_debug_pub.Add('l_document_number:' || l_document_number, 1);
310: ecx_cln_debug_pub.Add('l_revision_number:' || l_revision_number, 1);
311: ecx_cln_debug_pub.Add('l_release_number:' || l_release_number, 1);
312: ecx_cln_debug_pub.Add('l_collaboration_id:' || l_collaboration_id, 1);
313: END IF;
314:
315:
316: EXCEPTION

Line 323: ecx_cln_debug_pub.Add('Collaboration does not exist or Invalid Collaboration', 1);

319: FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_REFERENCE'); -- 'Invalid reference'
320: x_ret_desc := FND_MESSAGE.GET;
321:
322: IF (l_Debug_Level <= 1) THEN
323: ecx_cln_debug_pub.Add('Collaboration does not exist or Invalid Collaboration', 1);
324: END IF;
325:
326: -- removed 28June 2004.Now, we intend to support the case
327: -- when no collaboration is there

Line 344: ecx_cln_debug_pub.Add('Profile option - CLN_DELIVERY_CONFIRMATION_CODE:' || l_delivery_confirmation_code, 1);

340:
341: END IF;
342:
343: IF (l_Debug_Level <= 1) THEN
344: ecx_cln_debug_pub.Add('Profile option - CLN_DELIVERY_CONFIRMATION_CODE:' || l_delivery_confirmation_code, 1);
345: END IF;
346:
347:
348: -- If the notification code is delivery confirmation code then call delivery confirmation API

Line 360: ecx_cln_debug_pub.Add('l_xmlg_transaction_type:' || l_xmlg_transaction_type, 1);

356: (SELECT MAX(collaboration_dtl_id) FROM CLN_COLL_HIST_DTL
357: WHERE document_direction = 'OUT' AND collaboration_id = l_collaboration_id);
358:
359: IF (l_Debug_Level <= 1) THEN
360: ecx_cln_debug_pub.Add('l_xmlg_transaction_type:' || l_xmlg_transaction_type, 1);
361: ecx_cln_debug_pub.Add('l_xmlg_transaction_subtype:' || l_xmlg_transaction_subtype, 1);
362: ecx_cln_debug_pub.Add('l_xmlg_document_id:' || l_xmlg_document_id, 1);
363: END IF;
364:

Line 361: ecx_cln_debug_pub.Add('l_xmlg_transaction_subtype:' || l_xmlg_transaction_subtype, 1);

357: WHERE document_direction = 'OUT' AND collaboration_id = l_collaboration_id);
358:
359: IF (l_Debug_Level <= 1) THEN
360: ecx_cln_debug_pub.Add('l_xmlg_transaction_type:' || l_xmlg_transaction_type, 1);
361: ecx_cln_debug_pub.Add('l_xmlg_transaction_subtype:' || l_xmlg_transaction_subtype, 1);
362: ecx_cln_debug_pub.Add('l_xmlg_document_id:' || l_xmlg_document_id, 1);
363: END IF;
364:
365:

Line 362: ecx_cln_debug_pub.Add('l_xmlg_document_id:' || l_xmlg_document_id, 1);

358:
359: IF (l_Debug_Level <= 1) THEN
360: ecx_cln_debug_pub.Add('l_xmlg_transaction_type:' || l_xmlg_transaction_type, 1);
361: ecx_cln_debug_pub.Add('l_xmlg_transaction_subtype:' || l_xmlg_transaction_subtype, 1);
362: ecx_cln_debug_pub.Add('l_xmlg_document_id:' || l_xmlg_document_id, 1);
363: END IF;
364:
365:
366: -- We are assuming that the first message after any out bound will be delviery confirmation

Line 377: ecx_cln_debug_pub.Add('Quried ECX_DOCLOGS for l_msg_id:' || l_msg_id, 1);

373: WHERE transaction_type = l_xmlg_transaction_type AND
374: transaction_subtype = l_xmlg_transaction_subtype AND document_number = l_xmlg_document_id
375: AND direction = 'OUT';
376: IF (l_Debug_Level <= 1) THEN
377: ecx_cln_debug_pub.Add('Quried ECX_DOCLOGS for l_msg_id:' || l_msg_id, 1);
378: END IF;
379:
380: EXCEPTION
381: WHEN NO_DATA_FOUND THEN

Line 400: ecx_cln_debug_pub.Add('Executed delivery confirmation API:' || l_ret_code || ':' || l_ret_msg, 1);

396: x_ret_desc := FND_MESSAGE.GET;
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;
399: IF (l_Debug_Level <= 1) THEN
400: ecx_cln_debug_pub.Add('Executed delivery confirmation API:' || l_ret_code || ':' || l_ret_msg, 1);
401: END IF;
402:
403: END IF; -- Delivery Comfirmation
404:

Line 416: ecx_cln_debug_pub.Add('l_document_status:' || l_document_status, 1);

412: l_collaboration_status := 'ERROR';
413: END IF;
414:
415: IF (l_Debug_Level <= 1) THEN
416: ecx_cln_debug_pub.Add('l_document_status:' || l_document_status, 1);
417: ecx_cln_debug_pub.Add('l_collaboration_status:' || l_collaboration_status, 1);
418: END IF;
419:
420: l_all_notification_codes := rtrim(p_all_notification_codes);

Line 417: ecx_cln_debug_pub.Add('l_collaboration_status:' || l_collaboration_status, 1);

413: END IF;
414:
415: IF (l_Debug_Level <= 1) THEN
416: ecx_cln_debug_pub.Add('l_document_status:' || l_document_status, 1);
417: ecx_cln_debug_pub.Add('l_collaboration_status:' || l_collaboration_status, 1);
418: END IF;
419:
420: l_all_notification_codes := rtrim(p_all_notification_codes);
421:

Line 436: ecx_cln_debug_pub.Add('INVOKING CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION', 2);

432: l_doc_dir := p_doc_dir;
433: END IF;
434:
435: IF (l_Debug_Level <= 2) THEN
436: ecx_cln_debug_pub.Add('INVOKING CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION', 2);
437: END IF;
438:
439: CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION(
440: x_return_status => l_return_status,

Line 457: ecx_cln_debug_pub.Add('INVOKING CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION', 2);

453: x_dtl_coll_id => x_dtl_coll_id,
454: p_collaboration_standard => p_collaboration_standard);
455: ELSE
456: IF (l_Debug_Level <= 2) THEN
457: ecx_cln_debug_pub.Add('INVOKING CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION', 2);
458: END IF;
459:
460: CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION(
461: x_return_status => l_return_status,

Line 481: ecx_cln_debug_pub.Add('COMPLETED CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION', 2);

477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: IF (l_Debug_Level <= 2) THEN
481: ecx_cln_debug_pub.Add('COMPLETED CLN_CH_COLLABORATION_PKG.UPDATE_COLLABORATION', 2);
482: END IF;
483:
484: END IF;
485:

Line 501: ecx_cln_debug_pub.Add('COMPLETED CLN_CH_COLLABORATION_PKG.ADD_COLLABORATION_MESSAGES', 2);

497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499:
500: IF (l_Debug_Level <= 2) THEN
501: ecx_cln_debug_pub.Add('COMPLETED CLN_CH_COLLABORATION_PKG.ADD_COLLABORATION_MESSAGES', 2);
502: END IF;
503:
504: END IF;
505:

Line 512: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);

508: SELECT application_name INTO l_application_name
509: FROM fnd_application_vl
510: WHERE application_id = l_application_id;
511: IF (l_Debug_Level <= 1) THEN
512: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);
513: ecx_cln_debug_pub.Add('l_application_name:' || l_application_name, 1);
514: END IF;
515:
516: EXCEPTION

Line 513: ecx_cln_debug_pub.Add('l_application_name:' || l_application_name, 1);

509: FROM fnd_application_vl
510: WHERE application_id = l_application_id;
511: IF (l_Debug_Level <= 1) THEN
512: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);
513: ecx_cln_debug_pub.Add('l_application_name:' || l_application_name, 1);
514: END IF;
515:
516: EXCEPTION
517: WHEN NO_DATA_FOUND THEN

Line 526: ecx_cln_debug_pub.Add('Action parameters:');

522: END;
523:
524:
525: IF (l_Debug_Level <= 1) THEN
526: ecx_cln_debug_pub.Add('Action parameters:');
527: ecx_cln_debug_pub.Add('APPLICATION_ID:' || l_application_id);
528: ecx_cln_debug_pub.Add('COLLABORATION_ID:' || l_collaboration_id);
529: ecx_cln_debug_pub.Add('COLLABORATION_TYPE:' || l_collaboration_type);
530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);

Line 527: ecx_cln_debug_pub.Add('APPLICATION_ID:' || l_application_id);

523:
524:
525: IF (l_Debug_Level <= 1) THEN
526: ecx_cln_debug_pub.Add('Action parameters:');
527: ecx_cln_debug_pub.Add('APPLICATION_ID:' || l_application_id);
528: ecx_cln_debug_pub.Add('COLLABORATION_ID:' || l_collaboration_id);
529: ecx_cln_debug_pub.Add('COLLABORATION_TYPE:' || l_collaboration_type);
530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);
531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);

Line 528: ecx_cln_debug_pub.Add('COLLABORATION_ID:' || l_collaboration_id);

524:
525: IF (l_Debug_Level <= 1) THEN
526: ecx_cln_debug_pub.Add('Action parameters:');
527: ecx_cln_debug_pub.Add('APPLICATION_ID:' || l_application_id);
528: ecx_cln_debug_pub.Add('COLLABORATION_ID:' || l_collaboration_id);
529: ecx_cln_debug_pub.Add('COLLABORATION_TYPE:' || l_collaboration_type);
530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);
531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);
532: ecx_cln_debug_pub.Add('HEADER_DESCRIPTION:' || p_header_desc);

Line 529: ecx_cln_debug_pub.Add('COLLABORATION_TYPE:' || l_collaboration_type);

525: IF (l_Debug_Level <= 1) THEN
526: ecx_cln_debug_pub.Add('Action parameters:');
527: ecx_cln_debug_pub.Add('APPLICATION_ID:' || l_application_id);
528: ecx_cln_debug_pub.Add('COLLABORATION_ID:' || l_collaboration_id);
529: ecx_cln_debug_pub.Add('COLLABORATION_TYPE:' || l_collaboration_type);
530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);
531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);
532: ecx_cln_debug_pub.Add('HEADER_DESCRIPTION:' || p_header_desc);
533: ecx_cln_debug_pub.Add('NOTIFICATION_DESCRIPTION:' || p_notification_desc);

Line 530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);

526: ecx_cln_debug_pub.Add('Action parameters:');
527: ecx_cln_debug_pub.Add('APPLICATION_ID:' || l_application_id);
528: ecx_cln_debug_pub.Add('COLLABORATION_ID:' || l_collaboration_id);
529: ecx_cln_debug_pub.Add('COLLABORATION_TYPE:' || l_collaboration_type);
530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);
531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);
532: ecx_cln_debug_pub.Add('HEADER_DESCRIPTION:' || p_header_desc);
533: ecx_cln_debug_pub.Add('NOTIFICATION_DESCRIPTION:' || p_notification_desc);
534: ecx_cln_debug_pub.Add('NOTIFICATION_CODE:' || p_notification_code);

Line 531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);

527: ecx_cln_debug_pub.Add('APPLICATION_ID:' || l_application_id);
528: ecx_cln_debug_pub.Add('COLLABORATION_ID:' || l_collaboration_id);
529: ecx_cln_debug_pub.Add('COLLABORATION_TYPE:' || l_collaboration_type);
530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);
531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);
532: ecx_cln_debug_pub.Add('HEADER_DESCRIPTION:' || p_header_desc);
533: ecx_cln_debug_pub.Add('NOTIFICATION_DESCRIPTION:' || p_notification_desc);
534: ecx_cln_debug_pub.Add('NOTIFICATION_CODE:' || p_notification_code);
535: ecx_cln_debug_pub.Add('STATUS:' || p_statuslvl);

Line 532: ecx_cln_debug_pub.Add('HEADER_DESCRIPTION:' || p_header_desc);

528: ecx_cln_debug_pub.Add('COLLABORATION_ID:' || l_collaboration_id);
529: ecx_cln_debug_pub.Add('COLLABORATION_TYPE:' || l_collaboration_type);
530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);
531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);
532: ecx_cln_debug_pub.Add('HEADER_DESCRIPTION:' || p_header_desc);
533: ecx_cln_debug_pub.Add('NOTIFICATION_DESCRIPTION:' || p_notification_desc);
534: ecx_cln_debug_pub.Add('NOTIFICATION_CODE:' || p_notification_code);
535: ecx_cln_debug_pub.Add('STATUS:' || p_statuslvl);
536: END IF;

Line 533: ecx_cln_debug_pub.Add('NOTIFICATION_DESCRIPTION:' || p_notification_desc);

529: ecx_cln_debug_pub.Add('COLLABORATION_TYPE:' || l_collaboration_type);
530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);
531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);
532: ecx_cln_debug_pub.Add('HEADER_DESCRIPTION:' || p_header_desc);
533: ecx_cln_debug_pub.Add('NOTIFICATION_DESCRIPTION:' || p_notification_desc);
534: ecx_cln_debug_pub.Add('NOTIFICATION_CODE:' || p_notification_code);
535: ecx_cln_debug_pub.Add('STATUS:' || p_statuslvl);
536: END IF;
537:

Line 534: ecx_cln_debug_pub.Add('NOTIFICATION_CODE:' || p_notification_code);

530: ecx_cln_debug_pub.Add('REFERENCE_ID:' || p_reference);
531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);
532: ecx_cln_debug_pub.Add('HEADER_DESCRIPTION:' || p_header_desc);
533: ecx_cln_debug_pub.Add('NOTIFICATION_DESCRIPTION:' || p_notification_desc);
534: ecx_cln_debug_pub.Add('NOTIFICATION_CODE:' || p_notification_code);
535: ecx_cln_debug_pub.Add('STATUS:' || p_statuslvl);
536: END IF;
537:
538: -- if notification code is not null then only do this step

Line 535: ecx_cln_debug_pub.Add('STATUS:' || p_statuslvl);

531: ecx_cln_debug_pub.Add('TRADING_PARTNER_ID:' || l_tp_id);
532: ecx_cln_debug_pub.Add('HEADER_DESCRIPTION:' || p_header_desc);
533: ecx_cln_debug_pub.Add('NOTIFICATION_DESCRIPTION:' || p_notification_desc);
534: ecx_cln_debug_pub.Add('NOTIFICATION_CODE:' || p_notification_code);
535: ecx_cln_debug_pub.Add('STATUS:' || p_statuslvl);
536: END IF;
537:
538: -- if notification code is not null then only do this step
539: -- else check if any of the three Send_mail_tp/ send_mail_admin/ send_mail_docowner

Line 545: ecx_cln_debug_pub.Add('Obtained cursor row for action code:' || c_actions.action_code, 1);

541: FOR c_actions IN Get_actions(p_notification_code, p_coll_point, l_application_id, l_collaboration_type) LOOP
542: BEGIN
543: SAVEPOINT ACTION;
544: IF (l_Debug_Level <= 1) THEN
545: ecx_cln_debug_pub.Add('Obtained cursor row for action code:' || c_actions.action_code, 1);
546: END IF;
547:
548:
549: IF c_actions.action_code = 'START_WORKFLOW' THEN

Line 553: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key

549: IF c_actions.action_code = 'START_WORKFLOW' THEN
550: -- attribute1 => Item , attribute2 => Process
551: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
552: IF (l_Debug_Level <= 2) THEN
553: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key
554: || ':' || c_actions.attribute2, 2);
555: END IF;
556:
557: WF_ENGINE.CreateProcess(c_actions.attribute1, l_notification_flow_key, c_actions.attribute2);

Line 559: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key || ':' || c_actions.attribute2, 2);

555: END IF;
556:
557: WF_ENGINE.CreateProcess(c_actions.attribute1, l_notification_flow_key, c_actions.attribute2);
558: IF (l_Debug_Level <= 2) THEN
559: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key || ':' || c_actions.attribute2, 2);
560: END IF;
561:
562: -- Set attributes
563: -- pass on the object of type wf_event_t also here.

Line 578: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);

574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);
575: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
576: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'STATUS', p_statuslvl);
577: IF (l_Debug_Level <= 2) THEN
578: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);
579: END IF;
580:
581: WF_ENGINE.StartProcess(c_actions.attribute1,l_notification_flow_key);
582: IF (l_Debug_Level <= 2) THEN

Line 583: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);

579: END IF;
580:
581: WF_ENGINE.StartProcess(c_actions.attribute1,l_notification_flow_key);
582: IF (l_Debug_Level <= 2) THEN
583: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);
584: END IF;
585: ELSIF c_actions.action_code = 'NOTIFY_ADMINISTRATOR' THEN
586: l_notify_default_admin_flag := TRUE;
587: IF c_actions.attribute1 IS NOT NULL THEN

Line 680: ecx_cln_debug_pub.Add('Administrator Roles not specified', 1);

676: END IF;
677: IF l_notify_default_admin_flag = TRUE THEN
678: -- Get administrator e-mail from profile value
679: IF (l_Debug_Level <= 1) THEN
680: ecx_cln_debug_pub.Add('Administrator Roles not specified', 1);
681: END IF;
682:
683: l_role := FND_PROFILE.VALUE('CLN_ADMINISTRATOR');
684: IF (l_Debug_Level <= 1) THEN

Line 685: ecx_cln_debug_pub.Add('Administrator Profile Role or E-Mail:' || l_email, 1);

681: END IF;
682:
683: l_role := FND_PROFILE.VALUE('CLN_ADMINISTRATOR');
684: IF (l_Debug_Level <= 1) THEN
685: ecx_cln_debug_pub.Add('Administrator Profile Role or E-Mail:' || l_email, 1);
686: END IF;
687: BEGIN
688: SELECT 'x'
689: INTO l_temp

Line 696: ecx_cln_debug_pub.Add('CLN Administrator Profile has email(not role)', 1);

692: AND rownum < 2;
693: EXCEPTION
694: WHEN NO_DATA_FOUND THEN
695: IF (l_Debug_Level <= 1) THEN
696: ecx_cln_debug_pub.Add('CLN Administrator Profile has email(not role)', 1);
697: END IF;
698: l_email := l_role;
699: l_role := 'CLN_ADMINISTRATOR';
700: SELECT email_address

Line 705: ecx_cln_debug_pub.Add('Administrator Role E-Mail:' || l_admin_email, 1);

701: INTO l_admin_email
702: FROM WF_USERS
703: WHERE NAME = 'CLN_ADMINISTRATOR';
704: IF (l_Debug_Level <= 1) THEN
705: ecx_cln_debug_pub.Add('Administrator Role E-Mail:' || l_admin_email, 1);
706: END IF;
707: IF( l_email <> l_admin_email or l_admin_email is null) THEN
708: WF_DIRECTORY.SetAdHocUserAttr (USER_NAME => l_role, EMAIL_ADDRESS => l_email);
709: END IF;

Line 720: ecx_cln_debug_pub.Add('Entering notify document Owner', 1);

716: END IF;
717: ELSIF c_actions.action_code = 'NOTIFY_DOC_OWNER' THEN
718: BEGIN
719: IF (l_Debug_Level <= 1) THEN
720: ecx_cln_debug_pub.Add('Entering notify document Owner', 1);
721: END IF;
722:
723: SELECT OWNER_ROLE
724: INTO l_role

Line 729: ecx_cln_debug_pub.Add('Notification Receiver '||l_role, 1);

725: FROM CLN_COLL_HIST_HDR
726: where COLLABORATION_ID = l_collaboration_id;
727:
728: IF (l_Debug_Level <= 1) THEN
729: ecx_cln_debug_pub.Add('Notification Receiver '||l_role, 1);
730: END IF;
731:
732: BEGIN
733: SELECT 'x'

Line 741: ecx_cln_debug_pub.Add('CLN Administrator Profile has email(not role)', 1);

737: AND rownum < 2;
738: EXCEPTION
739: WHEN NO_DATA_FOUND THEN
740: IF (l_Debug_Level <= 1) THEN
741: ecx_cln_debug_pub.Add('CLN Administrator Profile has email(not role)', 1);
742: END IF;
743:
744: l_email := l_role;
745: l_role := 'CLN_ADMINISTRATOR';

Line 753: ecx_cln_debug_pub.Add('Administrator Role E-Mail:' || l_admin_email, 1);

749: FROM WF_USERS
750: WHERE NAME = 'CLN_ADMINISTRATOR';
751:
752: IF (l_Debug_Level <= 1) THEN
753: ecx_cln_debug_pub.Add('Administrator Role E-Mail:' || l_admin_email, 1);
754: END IF;
755:
756: IF( l_email <> l_admin_email or l_admin_email is null) THEN
757: WF_DIRECTORY.SetAdHocUserAttr (USER_NAME => l_role, EMAIL_ADDRESS => l_email);

Line 768: ecx_cln_debug_pub.Add('No Document Owner Found', 3);

764: EXCEPTION
765: WHEN NO_DATA_FOUND THEN
766: -- No Document Owner Found
767: IF (l_Debug_Level <= 4) THEN
768: ecx_cln_debug_pub.Add('No Document Owner Found', 3);
769: END IF;
770:
771: END;
772: ELSIF c_actions.action_code = 'NOTIFY_TRADING_PARTNER' THEN

Line 775: ecx_cln_debug_pub.Add('Entering notify trading partner', 1);

771: END;
772: ELSIF c_actions.action_code = 'NOTIFY_TRADING_PARTNER' THEN
773: BEGIN
774: IF (l_Debug_Level <= 1) THEN
775: ecx_cln_debug_pub.Add('Entering notify trading partner', 1);
776: END IF;
777: SELECT company_admin_email
778: INTO l_email
779: FROM ecx_tp_headers

Line 782: ecx_cln_debug_pub.Add('Queried the following from ecx_tp_headers using l_tp_id:' || l_tp_id, 1);

778: INTO l_email
779: FROM ecx_tp_headers
780: where tp_header_id = l_tp_id;
781: IF (l_Debug_Level <= 1) THEN
782: ecx_cln_debug_pub.Add('Queried the following from ecx_tp_headers using l_tp_id:' || l_tp_id, 1);
783: ecx_cln_debug_pub.Add('l_email:' || l_email, 1);
784: END IF;
785: l_role := null;
786: l_temp := null;

Line 783: ecx_cln_debug_pub.Add('l_email:' || l_email, 1);

779: FROM ecx_tp_headers
780: where tp_header_id = l_tp_id;
781: IF (l_Debug_Level <= 1) THEN
782: ecx_cln_debug_pub.Add('Queried the following from ecx_tp_headers using l_tp_id:' || l_tp_id, 1);
783: ecx_cln_debug_pub.Add('l_email:' || l_email, 1);
784: END IF;
785: l_role := null;
786: l_temp := null;
787: WF_DIRECTORY.CreateAdHocUser(name => l_role, display_name => l_temp, email_address => l_email, expiration_date => sysdate + 10);

Line 790: ecx_cln_debug_pub.Add('Before callling send_mail to trading partner- trading partner role : ' || l_role, 1);

786: l_temp := null;
787: WF_DIRECTORY.CreateAdHocUser(name => l_role, display_name => l_temp, email_address => l_email, expiration_date => sysdate + 10);
788:
789: IF (l_Debug_Level <= 1) THEN
790: ecx_cln_debug_pub.Add('Before callling send_mail to trading partner- trading partner role : ' || l_role, 1);
791: END IF;
792:
793: SEND_MAIL('Trading Partner', l_role, p_notification_code, c_actions.notification_message, p_notification_desc,
794: l_application_name, l_org_id, l_document_number, l_revision_number,

Line 800: ecx_cln_debug_pub.Add('Invalid trading partner: Unable to notify trading partner:' || l_tp_id, 3);

796: EXCEPTION
797: WHEN NO_DATA_FOUND THEN
798: -- Invalid trading partner
799: IF (l_Debug_Level <= 4) THEN
800: ecx_cln_debug_pub.Add('Invalid trading partner: Unable to notify trading partner:' || l_tp_id, 3);
801: END IF;
802:
803: -- FND_MESSAGE.SET_NAME('CLN', 'CLN_INVALID_TRADING_PARTNER'); -- 'Invalid trading partner'
804: -- x_ret_desc := FND_MESSAGE.GET;

Line 865: ecx_cln_debug_pub.Add('UserDefined PL/SQL API :' || c_actions.attribute1, 1);

861: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
862: WF_EVENT.Raise(c_actions.attribute1, l_notification_flow_key, NULL, l_cln_not_parameters, NULL);
863: ELSIF c_actions.action_code = 'PROCEDURE_CALL' THEN
864: IF (l_Debug_Level <= 1) THEN
865: ecx_cln_debug_pub.Add('UserDefined PL/SQL API :' || c_actions.attribute1, 1);
866: ecx_cln_debug_pub.Add('UserDefined PL/SQL API Mode:' || c_actions.attribute3, 1);
867: END IF;
868:
869: IF c_actions.attribute3 = 'CONCURRENT' THEN

Line 866: ecx_cln_debug_pub.Add('UserDefined PL/SQL API Mode:' || c_actions.attribute3, 1);

862: WF_EVENT.Raise(c_actions.attribute1, l_notification_flow_key, NULL, l_cln_not_parameters, NULL);
863: ELSIF c_actions.action_code = 'PROCEDURE_CALL' THEN
864: IF (l_Debug_Level <= 1) THEN
865: ecx_cln_debug_pub.Add('UserDefined PL/SQL API :' || c_actions.attribute1, 1);
866: ecx_cln_debug_pub.Add('UserDefined PL/SQL API Mode:' || c_actions.attribute3, 1);
867: END IF;
868:
869: IF c_actions.attribute3 = 'CONCURRENT' THEN
870: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;

Line 872: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);

868:
869: IF c_actions.attribute3 = 'CONCURRENT' THEN
870: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
871: IF (l_Debug_Level <= 2) THEN
872: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
873: END IF;
874:
875: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'CALL_API_CONC');
876: IF (l_Debug_Level <= 2) THEN

Line 877: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);

873: END IF;
874:
875: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'CALL_API_CONC');
876: IF (l_Debug_Level <= 2) THEN
877: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
878: END IF;
879:
880: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'PROCEDURE_NAME', c_actions.attribute1);
881: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'APPLICATION_ID', l_application_id);

Line 891: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);

887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
888: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
889: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'STATUS', p_statuslvl);
890: IF (l_Debug_Level <= 2) THEN
891: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
892: END IF;
893:
894: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
895: IF (l_Debug_Level <= 2) THEN

Line 896: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key, 2);

892: END IF;
893:
894: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
895: IF (l_Debug_Level <= 2) THEN
896: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key, 2);
897: END IF;
898:
899: ELSE
900: l_cln_not_parameters := wf_parameter_list_t();

Line 922: ecx_cln_debug_pub.Add('Rolledback transaction', 6);

918: EXCEPTION
919: WHEN FND_API.G_EXC_ERROR THEN
920: ROLLBACK TO ACTION;
921: IF (l_Debug_Level <= 5) THEN
922: ecx_cln_debug_pub.Add('Rolledback transaction', 6);
923: ecx_cln_debug_pub.Add(x_ret_desc, 6);
924: END IF;
925:
926: NOTIFY_ADMINISTRATOR('While trying to execute user defined actions as part of '

Line 923: ecx_cln_debug_pub.Add(x_ret_desc, 6);

919: WHEN FND_API.G_EXC_ERROR THEN
920: ROLLBACK TO ACTION;
921: IF (l_Debug_Level <= 5) THEN
922: ecx_cln_debug_pub.Add('Rolledback transaction', 6);
923: ecx_cln_debug_pub.Add(x_ret_desc, 6);
924: END IF;
925:
926: NOTIFY_ADMINISTRATOR('While trying to execute user defined actions as part of '
927: || 'notification processing for inbound confirmbod for the '

Line 933: ecx_cln_debug_pub.Add('Proceeding with the next action', 6);

929: || l_collaboration_id
930: || ', the following error is encountered:'
931: || x_ret_desc);
932: IF (l_Debug_Level <= 2) THEN
933: ecx_cln_debug_pub.Add('Proceeding with the next action', 6);
934: END IF;
935: WHEN OTHERS THEN
936:
937: ROLLBACK TO ACTION;

Line 939: ecx_cln_debug_pub.Add('Rolledback transaction', 6);

935: WHEN OTHERS THEN
936:
937: ROLLBACK TO ACTION;
938: IF (l_Debug_Level <= 5) THEN
939: ecx_cln_debug_pub.Add('Rolledback transaction', 6);
940: END IF;
941:
942: l_error_code := SQLCODE;
943: l_error_msg := SQLERRM;

Line 945: ecx_cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 6);

941:
942: l_error_code := SQLCODE;
943: l_error_msg := SQLERRM;
944: IF (l_Debug_Level <= 5) THEN
945: ecx_cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 6);
946: END IF;
947:
948: NOTIFY_ADMINISTRATOR('While trying to execute user defined actions as part of '
949: || 'notification processing for inbound confirmbod for the '

Line 955: ecx_cln_debug_pub.Add('Proceeding with the next action', 6);

951: || l_collaboration_id
952: || ', the following error is encountered:'
953: || l_error_code || ':' || l_error_msg);
954: IF (l_Debug_Level <= 5) THEN
955: ecx_cln_debug_pub.Add('Proceeding with the next action', 6);
956: END IF;
957:
958: END;
959: END Loop;

Line 961: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);

957:
958: END;
959: END Loop;
960: IF (l_Debug_Level <= 2) THEN
961: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
962: END IF;
963:
964: EXCEPTION
965: WHEN FND_API.G_EXC_ERROR THEN

Line 968: ecx_cln_debug_pub.Add(x_ret_desc, 6);

964: EXCEPTION
965: WHEN FND_API.G_EXC_ERROR THEN
966: x_ret_code := FND_API.G_RET_STS_ERROR;
967: IF (l_Debug_Level <= 5) THEN
968: ecx_cln_debug_pub.Add(x_ret_desc, 6);
969: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
970: END IF;
971:
972: WHEN OTHERS THEN

Line 969: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);

965: WHEN FND_API.G_EXC_ERROR THEN
966: x_ret_code := FND_API.G_RET_STS_ERROR;
967: IF (l_Debug_Level <= 5) THEN
968: ecx_cln_debug_pub.Add(x_ret_desc, 6);
969: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
970: END IF;
971:
972: WHEN OTHERS THEN
973: l_error_code := SQLCODE;

Line 978: ecx_cln_debug_pub.Add(x_ret_desc,6);

974: l_error_msg := SQLERRM;
975: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR ;
976: x_ret_desc := l_error_code || ':' || l_error_msg;
977: IF (l_Debug_Level <= 5) THEN
978: ecx_cln_debug_pub.Add(x_ret_desc,6);
979: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
980: END IF;
981:
982: END TAKE_ACTIONS_INTERNAL;

Line 979: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);

975: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR ;
976: x_ret_desc := l_error_code || ':' || l_error_msg;
977: IF (l_Debug_Level <= 5) THEN
978: ecx_cln_debug_pub.Add(x_ret_desc,6);
979: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS_INTERNAL', 2);
980: END IF;
981:
982: END TAKE_ACTIONS_INTERNAL;
983:

Line 1041: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');

1037: l_error_msg VARCHAR2(1000);
1038: BEGIN
1039: SAVEPOINT PROCESS_NOTIFICATION;
1040: -- Sets the debug mode to be FILE
1041: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
1042: IF (l_Debug_Level <= 2) THEN
1043: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);
1044: END IF;
1045:

Line 1043: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);

1039: SAVEPOINT PROCESS_NOTIFICATION;
1040: -- Sets the debug mode to be FILE
1041: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
1042: IF (l_Debug_Level <= 2) THEN
1043: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);
1044: END IF;
1045:
1046: IF (l_Debug_Level <= 1) THEN
1047: ecx_cln_debug_pub.Add('With the following parameters:', 1);

Line 1047: ecx_cln_debug_pub.Add('With the following parameters:', 1);

1043: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);
1044: END IF;
1045:
1046: IF (l_Debug_Level <= 1) THEN
1047: ecx_cln_debug_pub.Add('With the following parameters:', 1);
1048: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
1049: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
1050: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);

Line 1048: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);

1044: END IF;
1045:
1046: IF (l_Debug_Level <= 1) THEN
1047: ecx_cln_debug_pub.Add('With the following parameters:', 1);
1048: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
1049: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
1050: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);

Line 1049: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);

1045:
1046: IF (l_Debug_Level <= 1) THEN
1047: ecx_cln_debug_pub.Add('With the following parameters:', 1);
1048: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
1049: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
1050: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);
1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);

Line 1050: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);

1046: IF (l_Debug_Level <= 1) THEN
1047: ecx_cln_debug_pub.Add('With the following parameters:', 1);
1048: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
1049: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
1050: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);
1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);
1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);

Line 1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);

1047: ecx_cln_debug_pub.Add('With the following parameters:', 1);
1048: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
1049: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
1050: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);
1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);
1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);

Line 1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);

1048: ecx_cln_debug_pub.Add('p_tp_id:' || p_tp_id, 1);
1049: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
1050: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);
1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);
1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
1056: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);

Line 1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);

1049: ecx_cln_debug_pub.Add('p_reference:' || p_reference, 1);
1050: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);
1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);
1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
1056: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
1057: ecx_cln_debug_pub.Add('p_coll_id:' || p_coll_id, 1);

Line 1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);

1050: ecx_cln_debug_pub.Add('p_statuslvl:' || p_statuslvl, 1);
1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);
1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);
1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
1056: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
1057: ecx_cln_debug_pub.Add('p_coll_id:' || p_coll_id, 1);
1058: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);

Line 1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);

1051: ecx_cln_debug_pub.Add('p_header_desc:' || p_header_desc, 1);
1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);
1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);
1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
1056: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
1057: ecx_cln_debug_pub.Add('p_coll_id:' || p_coll_id, 1);
1058: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
1059: END IF;

Line 1056: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);

1052: ecx_cln_debug_pub.Add('p_reason_code:' || p_reason_code, 1);
1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);
1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
1056: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
1057: ecx_cln_debug_pub.Add('p_coll_id:' || p_coll_id, 1);
1058: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
1059: END IF;
1060:

Line 1057: ecx_cln_debug_pub.Add('p_coll_id:' || p_coll_id, 1);

1053: ecx_cln_debug_pub.Add('p_line_desc:' || p_line_desc, 1);
1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
1056: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
1057: ecx_cln_debug_pub.Add('p_coll_id:' || p_coll_id, 1);
1058: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
1059: END IF;
1060:
1061:

Line 1058: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);

1054: ecx_cln_debug_pub.Add('p_int_con_no:' || p_int_con_no, 1);
1055: ecx_cln_debug_pub.Add('p_coll_point:' || p_coll_point, 1);
1056: ecx_cln_debug_pub.Add('p_doc_dir:' || p_doc_dir, 1);
1057: ecx_cln_debug_pub.Add('p_coll_id:' || p_coll_id, 1);
1058: ecx_cln_debug_pub.Add('p_collaboration_standard:' || p_collaboration_standard, 1);
1059: END IF;
1060:
1061:
1062: x_ret_code := FND_API.G_RET_STS_SUCCESS;

Line 1102: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);

1098: END IF;
1099: l_update_collaboration_flag := FALSE; -- no need to update second or third time
1100: END LOOP;
1101: IF (l_Debug_Level <= 2) THEN
1102: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);
1103: END IF;
1104:
1105: EXCEPTION
1106: WHEN FND_API.G_EXC_ERROR THEN

Line 1109: ecx_cln_debug_pub.Add('Rolledback transaction',5);

1105: EXCEPTION
1106: WHEN FND_API.G_EXC_ERROR THEN
1107: ROLLBACK TO PROCESS_NOTIFICATION;
1108: IF (l_Debug_Level <= 5) THEN
1109: ecx_cln_debug_pub.Add('Rolledback transaction',5);
1110: END IF;
1111:
1112: x_ret_code := FND_API.G_RET_STS_ERROR;
1113: IF (l_Debug_Level <= 5) THEN

Line 1114: ecx_cln_debug_pub.Add(x_ret_desc, 6);

1110: END IF;
1111:
1112: x_ret_code := FND_API.G_RET_STS_ERROR;
1113: IF (l_Debug_Level <= 5) THEN
1114: ecx_cln_debug_pub.Add(x_ret_desc, 6);
1115: END IF;
1116:
1117: NOTIFY_ADMINISTRATOR('Notification processing for inbound confirmbod '
1118: || 'for the collaboration ID#'

Line 1123: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);

1119: || p_coll_id
1120: || ', encountered the following error:'
1121: || x_ret_desc);
1122: IF (l_Debug_Level <= 5) THEN
1123: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);
1124: END IF;
1125:
1126: WHEN OTHERS THEN
1127: ROLLBACK TO PROCESS_NOTIFICATION;

Line 1129: ecx_cln_debug_pub.Add('Rolledback transaction');

1125:
1126: WHEN OTHERS THEN
1127: ROLLBACK TO PROCESS_NOTIFICATION;
1128: IF (l_Debug_Level <= 5) THEN
1129: ecx_cln_debug_pub.Add('Rolledback transaction');
1130: END IF;
1131:
1132: l_error_code := SQLCODE;
1133: l_error_msg := SQLERRM;

Line 1141: ecx_cln_debug_pub.Add(x_ret_desc, 6);

1137: || p_coll_id
1138: || ', encountered the following error:'
1139: || l_error_code || ':' || l_error_msg);
1140: IF (l_Debug_Level <= 5) THEN
1141: ecx_cln_debug_pub.Add(x_ret_desc, 6);
1142: END IF;
1143:
1144: NOTIFY_ADMINISTRATOR(x_ret_desc);
1145: IF (l_Debug_Level <= 5) THEN

Line 1146: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);

1142: END IF;
1143:
1144: NOTIFY_ADMINISTRATOR(x_ret_desc);
1145: IF (l_Debug_Level <= 5) THEN
1146: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIFICATION', 2);
1147: END IF;
1148:
1149: END PROCESS_NOTIFICATION;
1150:

Line 1188: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');

1184: l_debug_mode VARCHAR2(255);
1185: BEGIN
1186: SAVEPOINT TAKE_ACTIONS;
1187: -- Sets the debug mode to be FILE
1188: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
1189: IF (l_Debug_Level <= 2) THEN
1190: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1191: END IF;
1192:

Line 1190: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);

1186: SAVEPOINT TAKE_ACTIONS;
1187: -- Sets the debug mode to be FILE
1188: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
1189: IF (l_Debug_Level <= 2) THEN
1190: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1191: END IF;
1192:
1193:
1194: x_ret_code := FND_API.G_RET_STS_SUCCESS;

Line 1226: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);

1222: x_ret_desc := l_return_msg;
1223: RAISE FND_API.G_EXC_ERROR;
1224: END IF;
1225: IF (l_Debug_Level <= 2) THEN
1226: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1227: END IF;
1228:
1229: EXCEPTION
1230: WHEN FND_API.G_EXC_ERROR THEN

Line 1233: ecx_cln_debug_pub.Add('Rolledback transaction');

1229: EXCEPTION
1230: WHEN FND_API.G_EXC_ERROR THEN
1231: ROLLBACK TO TAKE_ACTIONS;
1232: IF (l_Debug_Level <= 5) THEN
1233: ecx_cln_debug_pub.Add('Rolledback transaction');
1234: END IF;
1235:
1236: x_ret_code := FND_API.G_RET_STS_ERROR;
1237: IF (l_Debug_Level <= 5) THEN

Line 1238: ecx_cln_debug_pub.Add(x_ret_desc, 6);

1234: END IF;
1235:
1236: x_ret_code := FND_API.G_RET_STS_ERROR;
1237: IF (l_Debug_Level <= 5) THEN
1238: ecx_cln_debug_pub.Add(x_ret_desc, 6);
1239: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1240: END IF;
1241:
1242: WHEN OTHERS THEN

Line 1239: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);

1235:
1236: x_ret_code := FND_API.G_RET_STS_ERROR;
1237: IF (l_Debug_Level <= 5) THEN
1238: ecx_cln_debug_pub.Add(x_ret_desc, 6);
1239: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1240: END IF;
1241:
1242: WHEN OTHERS THEN
1243: ROLLBACK TO TAKE_ACTIONS;

Line 1245: ecx_cln_debug_pub.Add('Rolledback transaction');

1241:
1242: WHEN OTHERS THEN
1243: ROLLBACK TO TAKE_ACTIONS;
1244: IF (l_Debug_Level <= 5) THEN
1245: ecx_cln_debug_pub.Add('Rolledback transaction');
1246: END IF;
1247:
1248: l_return_code := SQLCODE;
1249: l_return_msg := SQLERRM;

Line 1253: ecx_cln_debug_pub.Add(x_ret_desc, 6);

1249: l_return_msg := SQLERRM;
1250: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR;
1251: x_ret_desc := l_return_code||' : '||l_return_msg;
1252: IF (l_Debug_Level <= 5) THEN
1253: ecx_cln_debug_pub.Add(x_ret_desc, 6);
1254: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1255: END IF;
1256:
1257: END TAKE_ACTIONS;

Line 1254: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);

1250: x_ret_code := FND_API.G_RET_STS_UNEXP_ERROR;
1251: x_ret_desc := l_return_code||' : '||l_return_msg;
1252: IF (l_Debug_Level <= 5) THEN
1253: ecx_cln_debug_pub.Add(x_ret_desc, 6);
1254: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.TAKE_ACTIONS', 2);
1255: END IF;
1256:
1257: END TAKE_ACTIONS;
1258:

Line 1301: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');

1297: l_debug_mode VARCHAR2(255);
1298: BEGIN
1299:
1300: -- Sets the debug mode to be FILE
1301: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
1302: IF (l_Debug_Level <= 2) THEN
1303: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);
1304: END IF;
1305:

Line 1303: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);

1299:
1300: -- Sets the debug mode to be FILE
1301: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
1302: IF (l_Debug_Level <= 2) THEN
1303: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);
1304: END IF;
1305:
1306:
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1335: ecx_cln_debug_pub.Add('p_tr_partner_id:' || p_tr_partner_id, 1);

1331: x_msg_data := FND_MESSAGE.GET;
1332: RAISE FND_API.G_EXC_ERROR;
1333: END;
1334: IF (l_Debug_Level <= 1) THEN
1335: ecx_cln_debug_pub.Add('p_tr_partner_id:' || p_tr_partner_id, 1);
1336: END IF;
1337:
1338: IF (l_Debug_Level <= 2) THEN
1339: ecx_cln_debug_pub.Add('EXITING GET_TRADING_PARTNER_DETAILS', 2);

Line 1339: ecx_cln_debug_pub.Add('EXITING GET_TRADING_PARTNER_DETAILS', 2);

1335: ecx_cln_debug_pub.Add('p_tr_partner_id:' || p_tr_partner_id, 1);
1336: END IF;
1337:
1338: IF (l_Debug_Level <= 2) THEN
1339: ecx_cln_debug_pub.Add('EXITING GET_TRADING_PARTNER_DETAILS', 2);
1340: END IF;
1341:
1342: EXCEPTION
1343: WHEN FND_API.G_EXC_ERROR THEN

Line 1346: ecx_cln_debug_pub.Add(x_msg_data, 4);

1342: EXCEPTION
1343: WHEN FND_API.G_EXC_ERROR THEN
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: IF (l_Debug_Level <= 5) THEN
1346: ecx_cln_debug_pub.Add(x_msg_data, 4);
1347: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);
1348: END IF;
1349:
1350: WHEN OTHERS THEN

Line 1347: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);

1343: WHEN FND_API.G_EXC_ERROR THEN
1344: x_return_status := FND_API.G_RET_STS_ERROR;
1345: IF (l_Debug_Level <= 5) THEN
1346: ecx_cln_debug_pub.Add(x_msg_data, 4);
1347: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);
1348: END IF;
1349:
1350: WHEN OTHERS THEN
1351: l_error_code := SQLCODE;

Line 1356: ecx_cln_debug_pub.Add(x_msg_data, 6);

1352: l_error_msg := SQLERRM;
1353: x_msg_data := l_error_code || ':' || l_error_msg;
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: IF (l_Debug_Level <= 5) THEN
1356: ecx_cln_debug_pub.Add(x_msg_data, 6);
1357: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);
1358: END IF;
1359:
1360: END GET_TRADING_PARTNER_DETAILS;

Line 1357: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);

1353: x_msg_data := l_error_code || ':' || l_error_msg;
1354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1355: IF (l_Debug_Level <= 5) THEN
1356: ecx_cln_debug_pub.Add(x_msg_data, 6);
1357: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.GET_TRADING_PARTNER_DETAILS', 2);
1358: END IF;
1359:
1360: END GET_TRADING_PARTNER_DETAILS;
1361:

Line 1388: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');

1384: l_temp VARCHAR2(100);
1385: BEGIN
1386:
1387: -- Sets the debug mode to be FILE
1388: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
1389:
1390: IF (l_Debug_Level <= 2) THEN
1391: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);
1392: END IF;

Line 1391: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);

1387: -- Sets the debug mode to be FILE
1388: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
1389:
1390: IF (l_Debug_Level <= 2) THEN
1391: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);
1392: END IF;
1393:
1394:
1395: l_role := FND_PROFILE.VALUE('CLN_ADMINISTRATOR');

Line 1397: ecx_cln_debug_pub.Add('Administrator Profile Role or E-Mail:' || l_email, 1);

1393:
1394:
1395: l_role := FND_PROFILE.VALUE('CLN_ADMINISTRATOR');
1396: IF (l_Debug_Level <= 1) THEN
1397: ecx_cln_debug_pub.Add('Administrator Profile Role or E-Mail:' || l_email, 1);
1398: END IF;
1399:
1400: BEGIN
1401: SELECT 'x'

Line 1409: ecx_cln_debug_pub.Add('CLN Administrator Profile has email(not role)', 1);

1405: AND rownum < 2;
1406: EXCEPTION
1407: WHEN NO_DATA_FOUND THEN
1408: IF (l_Debug_Level <= 1) THEN
1409: ecx_cln_debug_pub.Add('CLN Administrator Profile has email(not role)', 1);
1410: END IF;
1411: l_email := l_role;
1412: l_role := 'CLN_ADMINISTRATOR';
1413: SELECT email_address

Line 1418: ecx_cln_debug_pub.Add('Administrator Role E-Mail:' || l_admin_email, 1);

1414: INTO l_admin_email
1415: FROM WF_USERS
1416: WHERE NAME = 'CLN_ADMINISTRATOR';
1417: IF (l_Debug_Level <= 1) THEN
1418: ecx_cln_debug_pub.Add('Administrator Role E-Mail:' || l_admin_email, 1);
1419: END IF;
1420: IF( l_email <> l_admin_email or l_admin_email is null) THEN
1421: WF_DIRECTORY.SetAdHocUserAttr (USER_NAME => l_role, EMAIL_ADDRESS => l_email);
1422: END IF;

Line 1428: ecx_cln_debug_pub.Add('About to start workflow', 1);

1424: END;
1425:
1426:
1427: IF (l_Debug_Level <= 1) THEN
1428: ecx_cln_debug_pub.Add('About to start workflow', 1);
1429: END IF;
1430:
1431:
1432: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;

Line 1434: ecx_cln_debug_pub.Add('Process Item Key to send a mail to administrator:' || l_notification_flow_key, 1);

1430:
1431:
1432: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
1433: IF (l_Debug_Level <= 1) THEN
1434: ecx_cln_debug_pub.Add('Process Item Key to send a mail to administrator:' || l_notification_flow_key, 1);
1435: END IF;
1436: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY');
1437: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CONTENT', p_message);
1438: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_role );

Line 1442: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);

1438: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_role );
1439: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
1440:
1441: IF (l_Debug_Level <= 2) THEN
1442: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);
1443: END IF;
1444:
1445: EXCEPTION
1446: WHEN OTHERS THEN

Line 1450: ecx_cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 6);

1446: WHEN OTHERS THEN
1447: l_error_code := SQLCODE;
1448: l_error_msg := SQLERRM;
1449: IF (l_Debug_Level <= 5) THEN
1450: ecx_cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 6);
1451: ecx_cln_debug_pub.Add('Failed to send a mail to administrator', 3);
1452: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);
1453: END IF;
1454:

Line 1451: ecx_cln_debug_pub.Add('Failed to send a mail to administrator', 3);

1447: l_error_code := SQLCODE;
1448: l_error_msg := SQLERRM;
1449: IF (l_Debug_Level <= 5) THEN
1450: ecx_cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 6);
1451: ecx_cln_debug_pub.Add('Failed to send a mail to administrator', 3);
1452: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);
1453: END IF;
1454:
1455: END NOTIFY_ADMINISTRATOR;

Line 1452: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);

1448: l_error_msg := SQLERRM;
1449: IF (l_Debug_Level <= 5) THEN
1450: ecx_cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 6);
1451: ecx_cln_debug_pub.Add('Failed to send a mail to administrator', 3);
1452: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);
1453: END IF;
1454:
1455: END NOTIFY_ADMINISTRATOR;
1456:

Line 1552: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);

1548:
1549:
1550: BEGIN
1551: IF (l_Debug_Level <= 2) THEN
1552: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);
1553: END IF;
1554:
1555: -- Initialize API return status to success
1556: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1561: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);

1557: l_msg_data := 'Notifications Processing Successfully completed';
1558:
1559: -- get the paramaters passed
1560: IF (l_Debug_Level <= 1) THEN
1561: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1562: ecx_cln_debug_pub.Add('COLLABORATION ID ----- >>>'||p_coll_id,1);
1563: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_application_id,1);
1564: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||p_xmlg_transaction_type,1);
1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);

Line 1562: ecx_cln_debug_pub.Add('COLLABORATION ID ----- >>>'||p_coll_id,1);

1558:
1559: -- get the paramaters passed
1560: IF (l_Debug_Level <= 1) THEN
1561: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1562: ecx_cln_debug_pub.Add('COLLABORATION ID ----- >>>'||p_coll_id,1);
1563: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_application_id,1);
1564: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||p_xmlg_transaction_type,1);
1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);
1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);

Line 1563: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_application_id,1);

1559: -- get the paramaters passed
1560: IF (l_Debug_Level <= 1) THEN
1561: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1562: ecx_cln_debug_pub.Add('COLLABORATION ID ----- >>>'||p_coll_id,1);
1563: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_application_id,1);
1564: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||p_xmlg_transaction_type,1);
1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);
1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);
1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);

Line 1564: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||p_xmlg_transaction_type,1);

1560: IF (l_Debug_Level <= 1) THEN
1561: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1562: ecx_cln_debug_pub.Add('COLLABORATION ID ----- >>>'||p_coll_id,1);
1563: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_application_id,1);
1564: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||p_xmlg_transaction_type,1);
1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);
1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);
1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);
1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);

Line 1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);

1561: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1562: ecx_cln_debug_pub.Add('COLLABORATION ID ----- >>>'||p_coll_id,1);
1563: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_application_id,1);
1564: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||p_xmlg_transaction_type,1);
1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);
1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);
1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);
1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);
1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);

Line 1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);

1562: ecx_cln_debug_pub.Add('COLLABORATION ID ----- >>>'||p_coll_id,1);
1563: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_application_id,1);
1564: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||p_xmlg_transaction_type,1);
1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);
1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);
1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);
1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);
1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);
1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);

Line 1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);

1563: ecx_cln_debug_pub.Add('APPLCATION ID ----- >>>'||p_application_id,1);
1564: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||p_xmlg_transaction_type,1);
1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);
1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);
1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);
1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);
1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);
1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);
1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);

Line 1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);

1564: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||p_xmlg_transaction_type,1);
1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);
1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);
1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);
1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);
1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);
1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);
1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);
1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);

Line 1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);

1565: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_transaction_subtype,1);
1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);
1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);
1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);
1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);
1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);
1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);
1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);
1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);

Line 1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);

1566: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION TYPE ----- >>>'||p_xmlg_int_transaction_type,1);
1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);
1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);
1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);
1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);
1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);
1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);
1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);
1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);

Line 1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);

1567: ecx_cln_debug_pub.Add('XMLG INT TRANSACTION SUBTYPE ----- >>>'||p_xmlg_int_transaction_subtype,1);
1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);
1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);
1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);
1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);
1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);
1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);
1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);
1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);

Line 1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);

1568: ecx_cln_debug_pub.Add('XMLG DOCUMENT ID ----- >>>'||p_xmlg_document_id,1);
1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);
1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);
1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);
1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);
1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);
1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);
1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);
1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);

Line 1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);

1569: ecx_cln_debug_pub.Add('DOCUMENT DIRECTION ----- >>>'||p_doc_dir,1);
1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);
1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);
1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);
1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);
1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);
1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);
1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);
1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);

Line 1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);

1570: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_pt,1);
1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);
1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);
1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);
1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);
1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);
1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);
1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);
1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);

Line 1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);

1571: ecx_cln_debug_pub.Add('XMLG MESSAGE ID ----- >>>'||p_xmlg_msg_id,1);
1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);
1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);
1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);
1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);
1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);
1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);
1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);

Line 1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);

1572: ecx_cln_debug_pub.Add('UNIQUE 1 ----- >>>'||p_unique1,1);
1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);
1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);
1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);
1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);
1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);
1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);

Line 1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);

1573: ecx_cln_debug_pub.Add('UNIQUE 2 ----- >>>'||p_unique2,1);
1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);
1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);
1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);
1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);
1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
1581: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);

Line 1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);

1574: ecx_cln_debug_pub.Add('UNIQUE 3 ----- >>>'||p_unique3,1);
1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);
1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);
1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);
1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
1581: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1582: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_desc,1);

Line 1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);

1575: ecx_cln_debug_pub.Add('UNIQUE 4 ----- >>>'||p_unique4,1);
1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);
1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);
1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
1581: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1582: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_desc,1);
1583: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);

Line 1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);

1576: ecx_cln_debug_pub.Add('UNIQUE 5 ----- >>>'||p_unique5,1);
1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);
1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
1581: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1582: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_desc,1);
1583: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1584: ecx_cln_debug_pub.Add('=========================================================',1);

Line 1581: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);

1577: ecx_cln_debug_pub.Add('TRADING PARTNER TYPE ----- >>>'||p_tr_partner_type,1);
1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
1581: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1582: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_desc,1);
1583: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1584: ecx_cln_debug_pub.Add('=========================================================',1);
1585: END IF;

Line 1582: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_desc,1);

1578: ecx_cln_debug_pub.Add('TRADING PARTNER ID ----- >>>'||p_tr_partner_id,1);
1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
1581: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1582: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_desc,1);
1583: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1584: ecx_cln_debug_pub.Add('=========================================================',1);
1585: END IF;
1586:

Line 1583: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);

1579: ecx_cln_debug_pub.Add('TRADING PARTNER SITE ----- >>>'||p_tr_partner_site,1);
1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
1581: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1582: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_desc,1);
1583: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1584: ecx_cln_debug_pub.Add('=========================================================',1);
1585: END IF;
1586:
1587:

Line 1584: ecx_cln_debug_pub.Add('=========================================================',1);

1580: ecx_cln_debug_pub.Add('XMLG INTERNAL CONTROL NO ----- >>>'||p_xmlg_internal_control_number,1);
1581: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1582: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_desc,1);
1583: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1584: ecx_cln_debug_pub.Add('=========================================================',1);
1585: END IF;
1586:
1587:
1588:

Line 1621: ecx_cln_debug_pub.Add('Getting values for External Transaction type and SubType and msg standard',1);

1617: IF((l_xmlg_int_transaction_type IS NOT NULL) AND (l_xmlg_int_transaction_subtype IS NOT NULL) AND (l_tr_partner_id IS NOT NULL) AND (l_tr_partner_site IS NOT NULL)) THEN
1618: IF ((l_xmlg_transaction_type IS NULL) OR (l_xmlg_transaction_subtype IS NULL)) THEN
1619:
1620: IF (l_Debug_Level <= 1) THEN
1621: ecx_cln_debug_pub.Add('Getting values for External Transaction type and SubType and msg standard',1);
1622: END IF;
1623:
1624: BEGIN
1625: SELECT ecxproc.EXT_TYPE,ecxproc.EXT_SUBTYPE

Line 1640: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);

1636: AND ecxproc.direction = nvl(l_doc_dir,ecxproc.direction)
1637: AND estd.standard_id = ecxproc.standard_id;
1638:
1639: IF (l_Debug_Level <= 1) THEN
1640: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
1641: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);
1642: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||l_xmlg_transaction_subtype,1);
1643: ecx_cln_debug_pub.Add('==================================================================',1);
1644: END IF;

Line 1641: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);

1637: AND estd.standard_id = ecxproc.standard_id;
1638:
1639: IF (l_Debug_Level <= 1) THEN
1640: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
1641: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);
1642: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||l_xmlg_transaction_subtype,1);
1643: ecx_cln_debug_pub.Add('==================================================================',1);
1644: END IF;
1645:

Line 1642: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||l_xmlg_transaction_subtype,1);

1638:
1639: IF (l_Debug_Level <= 1) THEN
1640: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
1641: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);
1642: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||l_xmlg_transaction_subtype,1);
1643: ecx_cln_debug_pub.Add('==================================================================',1);
1644: END IF;
1645:
1646: EXCEPTION

Line 1643: ecx_cln_debug_pub.Add('==================================================================',1);

1639: IF (l_Debug_Level <= 1) THEN
1640: ecx_cln_debug_pub.Add('====Parameters Received From ECX_TRANSACTIONS/ECX_EXT_PROCESSES====',1);
1641: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION TYPE ----- >>>'||l_xmlg_transaction_type,1);
1642: ecx_cln_debug_pub.Add('XMLG EXT TRANSACTION SUBTYPE ----- >>>'||l_xmlg_transaction_subtype,1);
1643: ecx_cln_debug_pub.Add('==================================================================',1);
1644: END IF;
1645:
1646: EXCEPTION
1647: WHEN NO_DATA_FOUND THEN

Line 1669: ecx_cln_debug_pub.Add('Collaboration ID passed as null',1);

1665: --check whether the collaboration is being recorded or not at first instance
1666: IF l_coll_id IS NULL THEN
1667:
1668: IF (l_Debug_Level <= 1) THEN
1669: ecx_cln_debug_pub.Add('Collaboration ID passed as null',1);
1670: ecx_cln_debug_pub.Add('==========Call to FIND_COLLABORATION_ID API=============',1);
1671: END IF;
1672:
1673: CLN_CH_COLLABORATION_PKG.FIND_COLLABORATION_ID(

Line 1670: ecx_cln_debug_pub.Add('==========Call to FIND_COLLABORATION_ID API=============',1);

1666: IF l_coll_id IS NULL THEN
1667:
1668: IF (l_Debug_Level <= 1) THEN
1669: ecx_cln_debug_pub.Add('Collaboration ID passed as null',1);
1670: ecx_cln_debug_pub.Add('==========Call to FIND_COLLABORATION_ID API=============',1);
1671: END IF;
1672:
1673: CLN_CH_COLLABORATION_PKG.FIND_COLLABORATION_ID(
1674: x_return_status => x_return_status,

Line 1710: ecx_cln_debug_pub.Add('==========Call to GET_TRADING_PARTNER_DETAILS API=============',1);

1706: END IF;
1707:
1708: -- Call the API to get the trading partner set up details
1709: IF (l_Debug_Level <= 1) THEN
1710: ecx_cln_debug_pub.Add('==========Call to GET_TRADING_PARTNER_DETAILS API=============',1);
1711: END IF;
1712:
1713: CLN_CH_COLLABORATION_PKG.GET_TRADING_PARTNER_DETAILS(
1714: x_return_status => x_return_status,

Line 1739: ecx_cln_debug_pub.Add('==========Call to DEFAULT_XMLGTXN_MAPPING API=============',1);

1735: END IF;
1736:
1737: IF (l_Debug_Level <= 1) THEN
1738: -- call the API to get the default parameters through XMLG settings
1739: ecx_cln_debug_pub.Add('==========Call to DEFAULT_XMLGTXN_MAPPING API=============',1);
1740: END IF;
1741:
1742: CLN_CH_COLLABORATION_PKG.DEFAULT_XMLGTXN_MAPPING(
1743: x_return_status => x_return_status,

Line 1802: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);

1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:
1801: IF (l_Debug_Level <= 2) THEN
1802: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);
1803: END IF;
1804:
1805: EXCEPTION
1806: WHEN FND_API.G_EXC_ERROR THEN

Line 1809: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);

1805: EXCEPTION
1806: WHEN FND_API.G_EXC_ERROR THEN
1807: x_return_status := FND_API.G_RET_STS_ERROR;
1808: IF (l_Debug_Level <= 5) THEN
1809: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);
1810: END IF;
1811:
1812: WHEN OTHERS THEN
1813: l_return_code := SQLCODE;

Line 1819: ecx_cln_debug_pub.Add(x_msg_data, 6);

1815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1816: x_msg_data := l_return_code||' : '||x_msg_data;
1817:
1818: IF (l_Debug_Level <= 5) THEN
1819: ecx_cln_debug_pub.Add(x_msg_data, 6);
1820: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);
1821: END IF;
1822:
1823: END PROCESS_NOTIF_ACTIONS_EVT;

Line 1820: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);

1816: x_msg_data := l_return_code||' : '||x_msg_data;
1817:
1818: IF (l_Debug_Level <= 5) THEN
1819: ecx_cln_debug_pub.Add(x_msg_data, 6);
1820: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_ACTIONS_EVT', 2);
1821: END IF;
1822:
1823: END PROCESS_NOTIF_ACTIONS_EVT;
1824:

Line 1887: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);

1883: l_collaboration_standard VARCHAR2(30);
1884:
1885: BEGIN
1886: IF (l_Debug_Level <= 2) THEN
1887: ecx_cln_debug_pub.Add('ENTERING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);
1888: END IF;
1889:
1890: -- Initialize API return status to success
1891: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1896: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);

1892: l_msg_data := 'Batch Notification Processing Successfully completed';
1893:
1894: -- get the paramaters passed
1895: IF (l_Debug_Level <= 1) THEN
1896: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1897: ecx_cln_debug_pub.Add('ATTRIBUTE NAME ----- >>>'||p_attribute_name,1);
1898: ecx_cln_debug_pub.Add('ATTRIBUTE VALUE ----- >>>'||p_attribute_value,1);
1899: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_application_id,1);
1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);

Line 1897: ecx_cln_debug_pub.Add('ATTRIBUTE NAME ----- >>>'||p_attribute_name,1);

1893:
1894: -- get the paramaters passed
1895: IF (l_Debug_Level <= 1) THEN
1896: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1897: ecx_cln_debug_pub.Add('ATTRIBUTE NAME ----- >>>'||p_attribute_name,1);
1898: ecx_cln_debug_pub.Add('ATTRIBUTE VALUE ----- >>>'||p_attribute_value,1);
1899: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_application_id,1);
1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);
1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);

Line 1898: ecx_cln_debug_pub.Add('ATTRIBUTE VALUE ----- >>>'||p_attribute_value,1);

1894: -- get the paramaters passed
1895: IF (l_Debug_Level <= 1) THEN
1896: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1897: ecx_cln_debug_pub.Add('ATTRIBUTE NAME ----- >>>'||p_attribute_name,1);
1898: ecx_cln_debug_pub.Add('ATTRIBUTE VALUE ----- >>>'||p_attribute_value,1);
1899: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_application_id,1);
1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);
1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);
1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);

Line 1899: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_application_id,1);

1895: IF (l_Debug_Level <= 1) THEN
1896: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1897: ecx_cln_debug_pub.Add('ATTRIBUTE NAME ----- >>>'||p_attribute_name,1);
1898: ecx_cln_debug_pub.Add('ATTRIBUTE VALUE ----- >>>'||p_attribute_value,1);
1899: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_application_id,1);
1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);
1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);
1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);
1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);

Line 1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);

1896: ecx_cln_debug_pub.Add('==========Parameters Received=============',1);
1897: ecx_cln_debug_pub.Add('ATTRIBUTE NAME ----- >>>'||p_attribute_name,1);
1898: ecx_cln_debug_pub.Add('ATTRIBUTE VALUE ----- >>>'||p_attribute_value,1);
1899: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_application_id,1);
1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);
1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);
1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);
1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);
1904: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);

Line 1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);

1897: ecx_cln_debug_pub.Add('ATTRIBUTE NAME ----- >>>'||p_attribute_name,1);
1898: ecx_cln_debug_pub.Add('ATTRIBUTE VALUE ----- >>>'||p_attribute_value,1);
1899: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_application_id,1);
1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);
1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);
1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);
1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);
1904: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1905: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_msg,1);

Line 1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);

1898: ecx_cln_debug_pub.Add('ATTRIBUTE VALUE ----- >>>'||p_attribute_value,1);
1899: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_application_id,1);
1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);
1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);
1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);
1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);
1904: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1905: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_msg,1);
1906: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);

Line 1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);

1899: ecx_cln_debug_pub.Add('APPLICATION ID ----- >>>'||p_application_id,1);
1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);
1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);
1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);
1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);
1904: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1905: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_msg,1);
1906: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1907: ecx_cln_debug_pub.Add('=========================================================',1);

Line 1904: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);

1900: ecx_cln_debug_pub.Add('COLLABORATION STD ----- >>>'||p_collaboration_std,1);
1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);
1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);
1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);
1904: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1905: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_msg,1);
1906: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1907: ecx_cln_debug_pub.Add('=========================================================',1);
1908: END IF;

Line 1905: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_msg,1);

1901: ecx_cln_debug_pub.Add('COLLABORATION TYPE ----- >>>'||p_collaboration_type,1);
1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);
1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);
1904: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1905: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_msg,1);
1906: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1907: ecx_cln_debug_pub.Add('=========================================================',1);
1908: END IF;
1909:

Line 1906: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);

1902: ecx_cln_debug_pub.Add('COLLABORATION POINT ----- >>>'||p_collaboration_point,1);
1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);
1904: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1905: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_msg,1);
1906: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1907: ecx_cln_debug_pub.Add('=========================================================',1);
1908: END IF;
1909:
1910: -- assigning parameter to local variables

Line 1907: ecx_cln_debug_pub.Add('=========================================================',1);

1903: ecx_cln_debug_pub.Add('NOTIFICATION RECEIVER ----- >>>'||p_notification_receiver,1);
1904: ecx_cln_debug_pub.Add('NOTIFICATION CODE ----- >>>'||p_notification_code,1);
1905: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||p_notification_msg,1);
1906: ecx_cln_debug_pub.Add('NOTIFICATION STATUS ----- >>>'||p_notification_status,1);
1907: ecx_cln_debug_pub.Add('=========================================================',1);
1908: END IF;
1909:
1910: -- assigning parameter to local variables
1911: l_attribute_name := p_attribute_name;

Line 1918: ecx_cln_debug_pub.Add('Getting the Application Name from the Application ID as '||l_application_id, 1);

1914: l_application_id := p_application_id;
1915: l_collaboration_std := p_collaboration_std;
1916:
1917: IF (l_Debug_Level <= 4) THEN
1918: ecx_cln_debug_pub.Add('Getting the Application Name from the Application ID as '||l_application_id, 1);
1919: END IF;
1920:
1921:
1922: -- Query fnd_application_vl for application name using application id

Line 1930: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);

1926: FROM fnd_application_vl
1927: WHERE application_id = l_application_id;
1928:
1929: IF (l_Debug_Level <= 1) THEN
1930: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);
1931: ecx_cln_debug_pub.Add('APPLICATION NAME ----- >>>'||l_application_name, 1);
1932: END IF;
1933:
1934: EXCEPTION

Line 1931: ecx_cln_debug_pub.Add('APPLICATION NAME ----- >>>'||l_application_name, 1);

1927: WHERE application_id = l_application_id;
1928:
1929: IF (l_Debug_Level <= 1) THEN
1930: ecx_cln_debug_pub.Add('Queried the following from fnd_application_vl using application id:'|| l_application_id, 1);
1931: ecx_cln_debug_pub.Add('APPLICATION NAME ----- >>>'||l_application_name, 1);
1932: END IF;
1933:
1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN

Line 1949: ecx_cln_debug_pub.Add('Queried the display setup using application id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 1);

1945: RAISE FND_API.G_EXC_ERROR;
1946: END IF;
1947:
1948: IF (l_Debug_Level <= 4) THEN
1949: ecx_cln_debug_pub.Add('Queried the display setup using application id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 1);
1950: END IF;
1951:
1952:
1953: -- GET THE ATTRIBUTE COLUMN NAME

Line 1967: ecx_cln_debug_pub.Add('ATTRIBUTE COLUMN VALUE ----- >>>'||l_attribute_col_value, 1);

1963: AND collaboration_type IS NULL
1964: AND LANGUAGE = USERENV('LANG');
1965:
1966: IF (l_Debug_Level <= 1) THEN
1967: ecx_cln_debug_pub.Add('ATTRIBUTE COLUMN VALUE ----- >>>'||l_attribute_col_value, 1);
1968: END IF;
1969:
1970: EXCEPTION
1971: WHEN NO_DATA_FOUND THEN

Line 1978: ecx_cln_debug_pub.Add('Display SetUp Not Found forapplication id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 4);

1974: FND_MESSAGE.SET_TOKEN('APPLID',l_application_id);
1975: FND_MESSAGE.SET_TOKEN('COLLSTD',l_collaboration_std);
1976:
1977: IF (l_Debug_Level <= 4) THEN
1978: ecx_cln_debug_pub.Add('Display SetUp Not Found forapplication id/collaboration standard/attribute name as :'|| l_application_id||'/'||l_collaboration_std||'/'||l_attribute_name, 4);
1979: END IF;
1980:
1981: x_msg_data := FND_MESSAGE.GET;
1982: RAISE FND_API.G_EXC_ERROR;

Line 1986: ecx_cln_debug_pub.Add('Getting the Notification desc for Code ----- >>>'||p_notification_code, 1);

1982: RAISE FND_API.G_EXC_ERROR;
1983: END;
1984:
1985: IF (l_Debug_Level <= 4) THEN
1986: ecx_cln_debug_pub.Add('Getting the Notification desc for Code ----- >>>'||p_notification_code, 1);
1987: END IF;
1988:
1989: IF(p_collaboration_point IS NOT NULL AND p_notification_code IS NOT NULL) THEN
1990: BEGIN

Line 2000: ecx_cln_debug_pub.Add('Queried the Notification Codes Setup', 1);

1996: AND COLLABORATION_POINT = p_collaboration_point
1997: AND LANGUAGE = USERENV('LANG');
1998:
1999: IF (l_Debug_Level <= 1) THEN
2000: ecx_cln_debug_pub.Add('Queried the Notification Codes Setup', 1);
2001: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||l_notification_desc, 1);
2002: END IF;
2003:
2004: EXCEPTION

Line 2001: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||l_notification_desc, 1);

1997: AND LANGUAGE = USERENV('LANG');
1998:
1999: IF (l_Debug_Level <= 1) THEN
2000: ecx_cln_debug_pub.Add('Queried the Notification Codes Setup', 1);
2001: ecx_cln_debug_pub.Add('NOTIFICATION DESC ----- >>>'||l_notification_desc, 1);
2002: END IF;
2003:
2004: EXCEPTION
2005: WHEN NO_DATA_FOUND THEN

Line 2008: ecx_cln_debug_pub.Add('No setup found for Notification Code ---- >>>'||p_notification_code, 4);

2004: EXCEPTION
2005: WHEN NO_DATA_FOUND THEN
2006: -- DISPLAY SETUP NOT DONE
2007: IF (l_Debug_Level <= 4) THEN
2008: ecx_cln_debug_pub.Add('No setup found for Notification Code ---- >>>'||p_notification_code, 4);
2009: END IF;
2010: l_notification_desc := 'xxxxxxxxxx';
2011: END;
2012: ELSE

Line 2019: ecx_cln_debug_pub.Add('Notification Receiver Defaulted to CLN:Admimistrator', 1);

2015:
2016:
2017: IF(l_notif_receiver_role IS NULL) THEN
2018: IF (l_Debug_Level <= 1) THEN
2019: ecx_cln_debug_pub.Add('Notification Receiver Defaulted to CLN:Admimistrator', 1);
2020: END IF;
2021:
2022: l_notif_receiver_role := FND_PROFILE.VALUE('CLN_ADMINISTRATOR');
2023:

Line 2025: ecx_cln_debug_pub.Add('Notification Receiver ---- >>>'||l_notif_receiver_role, 1);

2021:
2022: l_notif_receiver_role := FND_PROFILE.VALUE('CLN_ADMINISTRATOR');
2023:
2024: IF (l_Debug_Level <= 1) THEN
2025: ecx_cln_debug_pub.Add('Notification Receiver ---- >>>'||l_notif_receiver_role, 1);
2026: END IF;
2027: END IF;
2028:
2029: BEGIN

Line 2039: ecx_cln_debug_pub.Add('CLN Administrator Profile has email(not role)', 1);

2035:
2036: EXCEPTION
2037: WHEN NO_DATA_FOUND THEN
2038: IF (l_Debug_Level <= 1) THEN
2039: ecx_cln_debug_pub.Add('CLN Administrator Profile has email(not role)', 1);
2040: END IF;
2041:
2042: l_email := l_notif_receiver_role;
2043: l_role := 'CLN_ADMINISTRATOR';

Line 2051: ecx_cln_debug_pub.Add('Administrator Role E-Mail:' || l_admin_email, 1);

2047: FROM WF_USERS
2048: WHERE NAME = 'CLN_ADMINISTRATOR';
2049:
2050: IF (l_Debug_Level <= 1) THEN
2051: ecx_cln_debug_pub.Add('Administrator Role E-Mail:' || l_admin_email, 1);
2052: END IF;
2053:
2054: IF( l_email <> l_admin_email or l_admin_email is null) THEN
2055: WF_DIRECTORY.SetAdHocUserAttr (USER_NAME => l_role, EMAIL_ADDRESS => l_email);

Line 2070: ecx_cln_debug_pub.Add('l_notification_dtls : '||l_notification_dtls , 4);

2066: FND_MESSAGE.SET_TOKEN('ATTRVALUE',p_attribute_value);
2067: l_notification_dtls := FND_MESSAGE.GET;
2068:
2069: IF (l_Debug_Level <= 4) THEN
2070: ecx_cln_debug_pub.Add('l_notification_dtls : '||l_notification_dtls , 4);
2071: END IF;
2072:
2073: -------------
2074:

Line 2076: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_BATCH', 1);

2072:
2073: -------------
2074:
2075: IF (l_Debug_Level <= 1) THEN
2076: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_BATCH', 1);
2077: END IF;
2078:
2079:
2080: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_BATCH');

Line 2095: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);

2091: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_notif_receiver_role);
2092: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
2093:
2094: IF (l_Debug_Level <= 2) THEN
2095: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);
2096: END IF;
2097:
2098:
2099: IF (l_Debug_Level <= 2) THEN

Line 2100: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);

2096: END IF;
2097:
2098:
2099: IF (l_Debug_Level <= 2) THEN
2100: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);
2101: END IF;
2102:
2103: EXCEPTION
2104: WHEN FND_API.G_EXC_ERROR THEN

Line 2107: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);

2103: EXCEPTION
2104: WHEN FND_API.G_EXC_ERROR THEN
2105: x_return_status := FND_API.G_RET_STS_ERROR;
2106: IF (l_Debug_Level <= 5) THEN
2107: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);
2108: END IF;
2109:
2110: WHEN OTHERS THEN
2111: l_return_code := SQLCODE;

Line 2117: ecx_cln_debug_pub.Add(x_msg_data, 6);

2113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2114: x_msg_data := l_return_code||' : '||x_msg_data;
2115:
2116: IF (l_Debug_Level <= 5) THEN
2117: ecx_cln_debug_pub.Add(x_msg_data, 6);
2118: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);
2119: END IF;
2120:
2121: END PROCESS_NOTIF_BATCH_EVT;

Line 2118: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);

2114: x_msg_data := l_return_code||' : '||x_msg_data;
2115:
2116: IF (l_Debug_Level <= 5) THEN
2117: ecx_cln_debug_pub.Add(x_msg_data, 6);
2118: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.PROCESS_NOTIF_BATCH_EVT', 2);
2119: END IF;
2120:
2121: END PROCESS_NOTIF_BATCH_EVT;
2122: