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_XMLG_EVENT_HANDLER_PKG dependencies on ECX_CLN_DEBUG_PUB

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

58:
59: BEGIN
60:
61: -- Sets the debug mode to be FILE
62: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
63:
64: IF (l_Debug_Level <= 2) THEN
65: ecx_cln_debug_pub.Add('ENTERING NOTIFIY_XMLG_IN_ERROR', 2);
66: END IF;

Line 65: ecx_cln_debug_pub.Add('ENTERING NOTIFIY_XMLG_IN_ERROR', 2);

61: -- Sets the debug mode to be FILE
62: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
63:
64: IF (l_Debug_Level <= 2) THEN
65: ecx_cln_debug_pub.Add('ENTERING NOTIFIY_XMLG_IN_ERROR', 2);
66: END IF;
67:
68: IF (l_Debug_Level <= 1) THEN
69: ecx_cln_debug_pub.Add('With the following parameters:', 1);

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

65: ecx_cln_debug_pub.Add('ENTERING NOTIFIY_XMLG_IN_ERROR', 2);
66: END IF;
67:
68: IF (l_Debug_Level <= 1) THEN
69: ecx_cln_debug_pub.Add('With the following parameters:', 1);
70: ecx_cln_debug_pub.Add('p_msg_id:' || p_msg_id, 1);
71: ecx_cln_debug_pub.Add('p_err_code:' || p_err_code, 1);
72: ecx_cln_debug_pub.Add('p_err_desc:' || p_err_desc, 1);
73: END IF;

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

66: END IF;
67:
68: IF (l_Debug_Level <= 1) THEN
69: ecx_cln_debug_pub.Add('With the following parameters:', 1);
70: ecx_cln_debug_pub.Add('p_msg_id:' || p_msg_id, 1);
71: ecx_cln_debug_pub.Add('p_err_code:' || p_err_code, 1);
72: ecx_cln_debug_pub.Add('p_err_desc:' || p_err_desc, 1);
73: END IF;
74:

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

67:
68: IF (l_Debug_Level <= 1) THEN
69: ecx_cln_debug_pub.Add('With the following parameters:', 1);
70: ecx_cln_debug_pub.Add('p_msg_id:' || p_msg_id, 1);
71: ecx_cln_debug_pub.Add('p_err_code:' || p_err_code, 1);
72: ecx_cln_debug_pub.Add('p_err_desc:' || p_err_desc, 1);
73: END IF;
74:
75:

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

68: IF (l_Debug_Level <= 1) THEN
69: ecx_cln_debug_pub.Add('With the following parameters:', 1);
70: ecx_cln_debug_pub.Add('p_msg_id:' || p_msg_id, 1);
71: ecx_cln_debug_pub.Add('p_err_code:' || p_err_code, 1);
72: ecx_cln_debug_pub.Add('p_err_desc:' || p_err_desc, 1);
73: END IF;
74:
75:
76: -- Initialize API return status to success

Line 108: ecx_cln_debug_pub.Add('INVALID_DATA_FOUND EXCEPTION IN ECX_DOCLOGS FOR MESSSAGE ID:' || p_msg_id, 1);

104: rownum < 2;
105: EXCEPTION
106: WHEN NO_DATA_FOUND THEN
107: IF (l_Debug_Level <= 1) THEN
108: ecx_cln_debug_pub.Add('INVALID_DATA_FOUND EXCEPTION IN ECX_DOCLOGS FOR MESSSAGE ID:' || p_msg_id, 1);
109: END IF;
110:
111: SELECT internal_control_number, attribute5, transaction_type,
112: transaction_subtype, document_number, protocol_type, message_standard

Line 121: ecx_cln_debug_pub.Add('l_np_tp_id:' || l_np_tp_id, 1);

117: END;
118:
119:
120: IF (l_Debug_Level <= 1) THEN
121: ecx_cln_debug_pub.Add('l_np_tp_id:' || l_np_tp_id, 1);
122: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
123: ecx_cln_debug_pub.Add('l_tp_location_code:' || l_tp_location_code, 1);
124: ecx_cln_debug_pub.Add('l_party_type:' || l_party_type, 1);
125: ecx_cln_debug_pub.Add('l_int_con_no:' || l_int_con_no, 1);

Line 122: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);

118:
119:
120: IF (l_Debug_Level <= 1) THEN
121: ecx_cln_debug_pub.Add('l_np_tp_id:' || l_np_tp_id, 1);
122: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
123: ecx_cln_debug_pub.Add('l_tp_location_code:' || l_tp_location_code, 1);
124: ecx_cln_debug_pub.Add('l_party_type:' || l_party_type, 1);
125: ecx_cln_debug_pub.Add('l_int_con_no:' || l_int_con_no, 1);
126: ecx_cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);

Line 123: ecx_cln_debug_pub.Add('l_tp_location_code:' || l_tp_location_code, 1);

119:
120: IF (l_Debug_Level <= 1) THEN
121: ecx_cln_debug_pub.Add('l_np_tp_id:' || l_np_tp_id, 1);
122: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
123: ecx_cln_debug_pub.Add('l_tp_location_code:' || l_tp_location_code, 1);
124: ecx_cln_debug_pub.Add('l_party_type:' || l_party_type, 1);
125: ecx_cln_debug_pub.Add('l_int_con_no:' || l_int_con_no, 1);
126: ecx_cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
127:

Line 124: ecx_cln_debug_pub.Add('l_party_type:' || l_party_type, 1);

120: IF (l_Debug_Level <= 1) THEN
121: ecx_cln_debug_pub.Add('l_np_tp_id:' || l_np_tp_id, 1);
122: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
123: ecx_cln_debug_pub.Add('l_tp_location_code:' || l_tp_location_code, 1);
124: ecx_cln_debug_pub.Add('l_party_type:' || l_party_type, 1);
125: ecx_cln_debug_pub.Add('l_int_con_no:' || l_int_con_no, 1);
126: ecx_cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
127:
128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);

Line 125: ecx_cln_debug_pub.Add('l_int_con_no:' || l_int_con_no, 1);

121: ecx_cln_debug_pub.Add('l_np_tp_id:' || l_np_tp_id, 1);
122: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
123: ecx_cln_debug_pub.Add('l_tp_location_code:' || l_tp_location_code, 1);
124: ecx_cln_debug_pub.Add('l_party_type:' || l_party_type, 1);
125: ecx_cln_debug_pub.Add('l_int_con_no:' || l_int_con_no, 1);
126: ecx_cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
127:
128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);
129: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_xmlg_tran_subtype, 1);

Line 126: ecx_cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);

122: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
123: ecx_cln_debug_pub.Add('l_tp_location_code:' || l_tp_location_code, 1);
124: ecx_cln_debug_pub.Add('l_party_type:' || l_party_type, 1);
125: ecx_cln_debug_pub.Add('l_int_con_no:' || l_int_con_no, 1);
126: ecx_cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
127:
128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);
129: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_xmlg_tran_subtype, 1);
130: ecx_cln_debug_pub.Add('Document ID:' || l_xmlg_doc_id, 1);

Line 128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);

124: ecx_cln_debug_pub.Add('l_party_type:' || l_party_type, 1);
125: ecx_cln_debug_pub.Add('l_int_con_no:' || l_int_con_no, 1);
126: ecx_cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
127:
128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);
129: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_xmlg_tran_subtype, 1);
130: ecx_cln_debug_pub.Add('Document ID:' || l_xmlg_doc_id, 1);
131: ecx_cln_debug_pub.Add('Application reference ID from attribute5:' || l_app_ref_id, 1);
132: ecx_cln_debug_pub.Add('Message Standard:' || l_message_standard, 1);

Line 129: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_xmlg_tran_subtype, 1);

125: ecx_cln_debug_pub.Add('l_int_con_no:' || l_int_con_no, 1);
126: ecx_cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
127:
128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);
129: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_xmlg_tran_subtype, 1);
130: ecx_cln_debug_pub.Add('Document ID:' || l_xmlg_doc_id, 1);
131: ecx_cln_debug_pub.Add('Application reference ID from attribute5:' || l_app_ref_id, 1);
132: ecx_cln_debug_pub.Add('Message Standard:' || l_message_standard, 1);
133: END IF;

Line 130: ecx_cln_debug_pub.Add('Document ID:' || l_xmlg_doc_id, 1);

126: ecx_cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
127:
128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);
129: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_xmlg_tran_subtype, 1);
130: ecx_cln_debug_pub.Add('Document ID:' || l_xmlg_doc_id, 1);
131: ecx_cln_debug_pub.Add('Application reference ID from attribute5:' || l_app_ref_id, 1);
132: ecx_cln_debug_pub.Add('Message Standard:' || l_message_standard, 1);
133: END IF;
134:

Line 131: ecx_cln_debug_pub.Add('Application reference ID from attribute5:' || l_app_ref_id, 1);

127:
128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);
129: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_xmlg_tran_subtype, 1);
130: ecx_cln_debug_pub.Add('Document ID:' || l_xmlg_doc_id, 1);
131: ecx_cln_debug_pub.Add('Application reference ID from attribute5:' || l_app_ref_id, 1);
132: ecx_cln_debug_pub.Add('Message Standard:' || l_message_standard, 1);
133: END IF;
134:
135:

Line 132: ecx_cln_debug_pub.Add('Message Standard:' || l_message_standard, 1);

128: ecx_cln_debug_pub.Add('Transaction Type:' || l_xmlg_tran_type, 1);
129: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_xmlg_tran_subtype, 1);
130: ecx_cln_debug_pub.Add('Document ID:' || l_xmlg_doc_id, 1);
131: ecx_cln_debug_pub.Add('Application reference ID from attribute5:' || l_app_ref_id, 1);
132: ecx_cln_debug_pub.Add('Message Standard:' || l_message_standard, 1);
133: END IF;
134:
135:
136:

Line 144: ecx_cln_debug_pub.Add('l_doc_no:' || l_doc_no, 1);

140: INTO l_doc_no
141: FROM DUAL;
142:
143: IF (l_Debug_Level <= 1) THEN
144: ecx_cln_debug_pub.Add('l_doc_no:' || l_doc_no, 1);
145: END IF;
146:
147: CLN_CH_COLLABORATION_PKG.DEFAULT_XMLGTXN_MAPPING(
148: x_return_status => x_return_status,

Line 161: ecx_cln_debug_pub.Add('Application reference ID obtained thru payload parsing:'|| l_app_ref_id, 1);

157: -- Getting Application Refernce ID by Calling GET_DATA_AREA_REFID
158: IF l_app_ref_id IS NULL THEN
159: CLN_CH_COLLABORATION_PKG.GET_DATA_AREA_REFID(p_msg_id, l_message_standard, l_app_ref_id, l_app_id, l_coll_type);
160: IF (l_Debug_Level <= 1) THEN
161: ecx_cln_debug_pub.Add('Application reference ID obtained thru payload parsing:'|| l_app_ref_id, 1);
162: END IF;
163:
164: END IF;
165:

Line 206: ecx_cln_debug_pub.Add('Collaboration does not exist', 1);

202: -- If collaboration doesn't exist
203: IF NOT l_coll_exists_flag THEN
204:
205: IF (l_Debug_Level <= 1) THEN
206: ecx_cln_debug_pub.Add('Collaboration does not exist', 1);
207: END IF;
208:
209:
210: -- Getting Party ID

Line 212: ecx_cln_debug_pub.Add('Party ID :' || l_party_id, 1);

208:
209:
210: -- Getting Party ID
211: IF (l_Debug_Level <= 1) THEN
212: ecx_cln_debug_pub.Add('Party ID :' || l_party_id, 1);
213: END IF;
214:
215:
216:

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

220: -- SELECT COMPONENT INTO l_sender_component FROM ECX_OAG_CBOD_V WHERE MSGID = p_msg_id;
221:
222: -- Create collaboration
223: IF (l_Debug_Level <= 1) THEN
224: ecx_cln_debug_pub.Add('CREATE_COLLABORATION: ', 1);
225: ecx_cln_debug_pub.Add('l_app_id:' || l_app_id, 1);
226: ecx_cln_debug_pub.Add('l_coll_type:' || l_coll_type, 1);
227: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
228: ecx_cln_debug_pub.Add('l_doc_dir:' || l_doc_dir, 1);

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

221:
222: -- Create collaboration
223: IF (l_Debug_Level <= 1) THEN
224: ecx_cln_debug_pub.Add('CREATE_COLLABORATION: ', 1);
225: ecx_cln_debug_pub.Add('l_app_id:' || l_app_id, 1);
226: ecx_cln_debug_pub.Add('l_coll_type:' || l_coll_type, 1);
227: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
228: ecx_cln_debug_pub.Add('l_doc_dir:' || l_doc_dir, 1);
229: ecx_cln_debug_pub.Add('l_sender_component:' || l_sender_component, 1);

Line 226: ecx_cln_debug_pub.Add('l_coll_type:' || l_coll_type, 1);

222: -- Create collaboration
223: IF (l_Debug_Level <= 1) THEN
224: ecx_cln_debug_pub.Add('CREATE_COLLABORATION: ', 1);
225: ecx_cln_debug_pub.Add('l_app_id:' || l_app_id, 1);
226: ecx_cln_debug_pub.Add('l_coll_type:' || l_coll_type, 1);
227: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
228: ecx_cln_debug_pub.Add('l_doc_dir:' || l_doc_dir, 1);
229: ecx_cln_debug_pub.Add('l_sender_component:' || l_sender_component, 1);
230: END IF;

Line 227: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);

223: IF (l_Debug_Level <= 1) THEN
224: ecx_cln_debug_pub.Add('CREATE_COLLABORATION: ', 1);
225: ecx_cln_debug_pub.Add('l_app_id:' || l_app_id, 1);
226: ecx_cln_debug_pub.Add('l_coll_type:' || l_coll_type, 1);
227: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
228: ecx_cln_debug_pub.Add('l_doc_dir:' || l_doc_dir, 1);
229: ecx_cln_debug_pub.Add('l_sender_component:' || l_sender_component, 1);
230: END IF;
231:

Line 228: ecx_cln_debug_pub.Add('l_doc_dir:' || l_doc_dir, 1);

224: ecx_cln_debug_pub.Add('CREATE_COLLABORATION: ', 1);
225: ecx_cln_debug_pub.Add('l_app_id:' || l_app_id, 1);
226: ecx_cln_debug_pub.Add('l_coll_type:' || l_coll_type, 1);
227: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
228: ecx_cln_debug_pub.Add('l_doc_dir:' || l_doc_dir, 1);
229: ecx_cln_debug_pub.Add('l_sender_component:' || l_sender_component, 1);
230: END IF;
231:
232: /*

Line 229: ecx_cln_debug_pub.Add('l_sender_component:' || l_sender_component, 1);

225: ecx_cln_debug_pub.Add('l_app_id:' || l_app_id, 1);
226: ecx_cln_debug_pub.Add('l_coll_type:' || l_coll_type, 1);
227: ecx_cln_debug_pub.Add('l_party_id:' || l_party_id, 1);
228: ecx_cln_debug_pub.Add('l_doc_dir:' || l_doc_dir, 1);
229: ecx_cln_debug_pub.Add('l_sender_component:' || l_sender_component, 1);
230: END IF;
231:
232: /*
233: CLN_CH_COLLABORATION_PKG.CREATE_COLLABORATION(

Line 288: ecx_cln_debug_pub.Add('ERROR:' || x_msg_data, 1);

284: x_coll_id => l_coll_id);
285: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
286: x_msg_data := 'Create Collaboration Failed:' || x_msg_data;
287: IF (l_Debug_Level <= 1) THEN
288: ecx_cln_debug_pub.Add('ERROR:' || x_msg_data, 1);
289: END IF;
290:
291: IF (l_Debug_Level <= 2) THEN
292: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);

Line 292: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);

288: ecx_cln_debug_pub.Add('ERROR:' || x_msg_data, 1);
289: END IF;
290:
291: IF (l_Debug_Level <= 2) THEN
292: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);
293: END IF;
294:
295: RETURN;
296: END IF;

Line 299: ecx_cln_debug_pub.Add('Collaboration exists', 1);

295: RETURN;
296: END IF;
297: ELSE
298: IF (l_Debug_Level <= 1) THEN
299: ecx_cln_debug_pub.Add('Collaboration exists', 1);
300: END IF;
301:
302: END IF; -- IF NOT l_coll_exists_flag THEN
303:

Line 314: ecx_cln_debug_pub.Add('ERROR:' || x_msg_data, 4);

310: l_int_con_no, 'XML_GATEWAY', l_doc_dir, l_coll_id,NULL);
311: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
312: x_msg_data := 'Process Notification Failed:' || x_msg_data;
313: IF (l_Debug_Level <= 4) THEN
314: ecx_cln_debug_pub.Add('ERROR:' || x_msg_data, 4);
315: END IF;
316:
317: IF (l_Debug_Level <= 2) THEN
318: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);

Line 318: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);

314: ecx_cln_debug_pub.Add('ERROR:' || x_msg_data, 4);
315: END IF;
316:
317: IF (l_Debug_Level <= 2) THEN
318: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);
319: END IF;
320:
321: RETURN;
322: END IF;

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

326: l_error_msg := SQLERRM;
327: x_msg_data := 'ERROR: ' || l_error_code||' : '||l_error_msg;
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: IF (l_Debug_Level <= 5) THEN
330: ecx_cln_debug_pub.Add(x_msg_data, 6);
331: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);
332: END IF;
333:
334: END NOTIFIY_XMLG_IN_ERROR;

Line 331: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);

327: x_msg_data := 'ERROR: ' || l_error_code||' : '||l_error_msg;
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: IF (l_Debug_Level <= 5) THEN
330: ecx_cln_debug_pub.Add(x_msg_data, 6);
331: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);
332: END IF;
333:
334: END NOTIFIY_XMLG_IN_ERROR;
335:

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

356: l_debug_mode VARCHAR2(255);
357: i_cln_not_parameters wf_parameter_list_t;
358: BEGIN
359: -- Sets the debug mode to be FILE
360: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
361:
362: IF (l_Debug_Level <= 2) THEN
363: ecx_cln_debug_pub.Add('ENTERING CLN_XMLG_PROCESSING_ERROR_F', 2);
364: END IF;

Line 363: ecx_cln_debug_pub.Add('ENTERING CLN_XMLG_PROCESSING_ERROR_F', 2);

359: -- Sets the debug mode to be FILE
360: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
361:
362: IF (l_Debug_Level <= 2) THEN
363: ecx_cln_debug_pub.Add('ENTERING CLN_XMLG_PROCESSING_ERROR_F', 2);
364: END IF;
365:
366:
367: i_cln_not_parameters := p_event.getParameterList();

Line 375: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_PROCESSING_ERROR_F', 2);

371: l_error_msg := WF_EVENT.getValueForParameter('ECX_ERROR_MSG',i_cln_not_parameters);
372: NOTIFIY_XMLG_IN_ERROR(l_return_code, l_return_msg,
373: l_msg_id, l_error_code, l_error_msg);
374: IF (l_Debug_Level <= 2) THEN
375: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_PROCESSING_ERROR_F', 2);
376: END IF;
377:
378: RETURN 'SUCCESS';
379: EXCEPTION

Line 384: ecx_cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 3);

380: WHEN OTHERS THEN
381: l_error_code := SQLCODE;
382: l_error_msg := SQLERRM;
383: IF (l_Debug_Level <= 5) THEN
384: ecx_cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 3);
385: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_PROCESSING_ERROR_Fw', 2);
386: END IF;
387:
388: RETURN 'SUCCESS';

Line 385: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_PROCESSING_ERROR_Fw', 2);

381: l_error_code := SQLCODE;
382: l_error_msg := SQLERRM;
383: IF (l_Debug_Level <= 5) THEN
384: ecx_cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 3);
385: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_PROCESSING_ERROR_Fw', 2);
386: END IF;
387:
388: RETURN 'SUCCESS';
389: END;

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

411: l_debug_mode VARCHAR2(255);
412: i_cln_not_parameters wf_parameter_list_t;
413: BEGIN
414: -- Sets the debug mode to be FILE
415: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
416:
417: IF (l_Debug_Level <= 2) THEN
418: ecx_cln_debug_pub.Add('ENTERING CLN_XMLG_SETUP_ERROR_F', 2);
419: END IF;

Line 418: ecx_cln_debug_pub.Add('ENTERING CLN_XMLG_SETUP_ERROR_F', 2);

414: -- Sets the debug mode to be FILE
415: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
416:
417: IF (l_Debug_Level <= 2) THEN
418: ecx_cln_debug_pub.Add('ENTERING CLN_XMLG_SETUP_ERROR_F', 2);
419: END IF;
420:
421:
422: i_cln_not_parameters := p_event.getParameterList();

Line 431: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_SETUP_ERROR_F', 2);

427: WHERE msgid = HEXTORAW(l_msg_id);
428: NOTIFIY_XMLG_IN_ERROR(l_return_code, l_return_msg,
429: l_msg_id, l_error_code, l_error_msg);
430: IF (l_Debug_Level <= 2) THEN
431: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_SETUP_ERROR_F', 2);
432: END IF;
433:
434: RETURN 'SUCCESS';
435: EXCEPTION

Line 440: ecx_cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 5);

436: WHEN OTHERS THEN
437: l_error_code := SQLCODE;
438: l_error_msg := SQLERRM;
439: IF (l_Debug_Level <= 5) THEN
440: ecx_cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 5);
441: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_SETUP_ERROR_F', 2);
442: END IF;
443:
444: RETURN 'SUCCESS';

Line 441: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_SETUP_ERROR_F', 2);

437: l_error_code := SQLCODE;
438: l_error_msg := SQLERRM;
439: IF (l_Debug_Level <= 5) THEN
440: ecx_cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 5);
441: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_SETUP_ERROR_F', 2);
442: END IF;
443:
444: RETURN 'SUCCESS';
445: END;

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

479: i_cln_not_parameters wf_parameter_list_t;
480: l_message_standard VARCHAR2(30);
481: BEGIN
482: -- Sets the debug mode to be FILE
483: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
484:
485: IF (l_Debug_Level <= 2) THEN
486: ecx_cln_debug_pub.Add('ENTERING CLN_XMLG_EVENT_SUB_F', 2);
487: END IF;

Line 486: ecx_cln_debug_pub.Add('ENTERING CLN_XMLG_EVENT_SUB_F', 2);

482: -- Sets the debug mode to be FILE
483: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
484:
485: IF (l_Debug_Level <= 2) THEN
486: ecx_cln_debug_pub.Add('ENTERING CLN_XMLG_EVENT_SUB_F', 2);
487: END IF;
488:
489:
490: i_cln_not_parameters := p_event.getParameterList();

Line 494: ecx_cln_debug_pub.Add('Message ID:' || l_msg_id, 1);

490: i_cln_not_parameters := p_event.getParameterList();
491:
492: l_msg_id := WF_EVENT.getValueForParameter('ECX_MSGID',i_cln_not_parameters);
493: IF (l_Debug_Level <= 1) THEN
494: ecx_cln_debug_pub.Add('Message ID:' || l_msg_id, 1);
495: END IF;
496:
497:
498: SELECT TRANSACTION_TYPE, TRANSACTION_SUBTYPE, DIRECTION, ATTRIBUTE5, message_standard

Line 504: ecx_cln_debug_pub.Add('Transaction Type:' || l_txn_type, 1);

500: FROM ecx_doclogs
501: WHERE msgid = HEXTORAW(l_msg_id);
502:
503: IF (l_Debug_Level <= 1) THEN
504: ecx_cln_debug_pub.Add('Transaction Type:' || l_txn_type, 1);
505: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_txn_subtype, 1);
506: ecx_cln_debug_pub.Add('Direction:' || l_direction, 1);
507: ecx_cln_debug_pub.Add('Application Reference ID:' || l_app_ref_id, 1);
508: END IF;

Line 505: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_txn_subtype, 1);

501: WHERE msgid = HEXTORAW(l_msg_id);
502:
503: IF (l_Debug_Level <= 1) THEN
504: ecx_cln_debug_pub.Add('Transaction Type:' || l_txn_type, 1);
505: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_txn_subtype, 1);
506: ecx_cln_debug_pub.Add('Direction:' || l_direction, 1);
507: ecx_cln_debug_pub.Add('Application Reference ID:' || l_app_ref_id, 1);
508: END IF;
509:

Line 506: ecx_cln_debug_pub.Add('Direction:' || l_direction, 1);

502:
503: IF (l_Debug_Level <= 1) THEN
504: ecx_cln_debug_pub.Add('Transaction Type:' || l_txn_type, 1);
505: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_txn_subtype, 1);
506: ecx_cln_debug_pub.Add('Direction:' || l_direction, 1);
507: ecx_cln_debug_pub.Add('Application Reference ID:' || l_app_ref_id, 1);
508: END IF;
509:
510:

Line 507: ecx_cln_debug_pub.Add('Application Reference ID:' || l_app_ref_id, 1);

503: IF (l_Debug_Level <= 1) THEN
504: ecx_cln_debug_pub.Add('Transaction Type:' || l_txn_type, 1);
505: ecx_cln_debug_pub.Add('Transaction Subtype:' || l_txn_subtype, 1);
506: ecx_cln_debug_pub.Add('Direction:' || l_direction, 1);
507: ecx_cln_debug_pub.Add('Application Reference ID:' || l_app_ref_id, 1);
508: END IF;
509:
510:
511: IF (l_txn_type = 'CLN' AND l_txn_subtype = 'NBOD') THEN

Line 513: ecx_cln_debug_pub.Add('This message (Confirm BOD) will be processed by Notification Processor',1);

509:
510:
511: IF (l_txn_type = 'CLN' AND l_txn_subtype = 'NBOD') THEN
512: IF (l_Debug_Level <= 1) THEN
513: ecx_cln_debug_pub.Add('This message (Confirm BOD) will be processed by Notification Processor',1);
514: END IF;
515:
516: IF (l_Debug_Level <= 2) THEN
517: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);

Line 517: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);

513: ecx_cln_debug_pub.Add('This message (Confirm BOD) will be processed by Notification Processor',1);
514: END IF;
515:
516: IF (l_Debug_Level <= 2) THEN
517: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);
518: END IF;
519:
520: RETURN 'SUCCESS';
521: END IF;

Line 536: ecx_cln_debug_pub.Add('This message is not for oracle supply chain trading connector',1);

532: -- IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
533: -- Procedure will return success even if there is NO_DATA_FOUND exception
534: IF ((l_app_id IS NULL) OR (l_coll_type IS NULL) OR (l_doc_type IS NULL)) THEN
535: IF (l_Debug_Level <= 1) THEN
536: ecx_cln_debug_pub.Add('This message is not for oracle supply chain trading connector',1);
537: END IF;
538:
539: IF (l_Debug_Level <= 2) THEN
540: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);

Line 540: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);

536: ecx_cln_debug_pub.Add('This message is not for oracle supply chain trading connector',1);
537: END IF;
538:
539: IF (l_Debug_Level <= 2) THEN
540: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);
541: END IF;
542:
543: RETURN 'SUCCESS';
544: END IF;

Line 549: ecx_cln_debug_pub.Add('Application reference ID obtained thru payload parsing:'|| l_app_ref_id, 1);

545:
546: IF l_app_ref_id IS NULL THEN
547: CLN_CH_COLLABORATION_PKG.GET_DATA_AREA_REFID(l_msg_id, l_message_standard, l_app_ref_id, l_app_id, l_coll_type);
548: IF (l_Debug_Level <= 1) THEN
549: ecx_cln_debug_pub.Add('Application reference ID obtained thru payload parsing:'|| l_app_ref_id, 1);
550: END IF;
551:
552: END IF;
553:

Line 565: ecx_cln_debug_pub.Add('Collaboration ID:' || l_coll_id, 1);

561: l_coll_id := NULL;
562: END;
563:
564: IF (l_Debug_Level <= 1) THEN
565: ecx_cln_debug_pub.Add('Collaboration ID:' || l_coll_id, 1);
566: END IF;
567:
568: FND_MESSAGE.SET_NAME('CLN','CLN_NP_XMLEH_SUCCESS');
569: l_msg := FND_MESSAGE.GET;

Line 585: ecx_cln_debug_pub.Add('ERROR:' || l_return_msg, 4);

581: x_dtl_coll_id => l_dtl_coll_id);
582: IF l_return_code <> FND_API.G_RET_STS_SUCCESS THEN
583: l_return_msg := 'Create Collaboration Failed:' || l_return_msg;
584: IF (l_Debug_Level <= 4) THEN
585: ecx_cln_debug_pub.Add('ERROR:' || l_return_msg, 4);
586: END IF;
587:
588: CLN_NP_PROCESSOR_PKG. NOTIFY_ADMINISTRATOR('While trying to create '
589: || 'new collaboration for the inbound message ID#'

Line 594: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);

590: || l_msg_id
591: || ', the following error is encountered:'
592: || l_return_msg);
593: IF (l_Debug_Level <= 2) THEN
594: ecx_cln_debug_pub.Add('EXITING NOTIFIY_XMLG_IN_ERROR', 2);
595: END IF;
596:
597: RETURN 'SUCCESS';
598: END IF;

Line 613: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);

609: p_rosettanet_check_required => FALSE,
610: x_dtl_coll_id => l_dtl_coll_id);
611: END IF;
612: IF (l_Debug_Level <= 2) THEN
613: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);
614: END IF;
615:
616: RETURN 'SUCCESS';
617: EXCEPTION

Line 622: ecx_cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 3);

618: WHEN OTHERS THEN
619: l_error_code := SQLCODE;
620: l_error_msg := SQLERRM;
621: IF (l_Debug_Level <= 5) THEN
622: ecx_cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 3);
623: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);
624: END IF;
625:
626: RETURN 'SUCCESS';

Line 623: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);

619: l_error_code := SQLCODE;
620: l_error_msg := SQLERRM;
621: IF (l_Debug_Level <= 5) THEN
622: ecx_cln_debug_pub.Add('Error:' || l_error_code || ':' || l_error_msg, 3);
623: ecx_cln_debug_pub.Add('EXITING CLN_XMLG_EVENT_SUB_F', 2);
624: END IF;
625:
626: RETURN 'SUCCESS';
627: END;