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_UTILS_PKG dependencies on CLN_DEBUG_PUB

Line 45: l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');

41: l_debug_mode VARCHAR2(255);
42: l_doc_status VARCHAR2(255);
43: BEGIN
44: -- Sets the debug mode to be FILE
45: l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
46:
47: IF (l_Debug_Level <= 2) THEN
48: cln_debug_pub.Add('ENTERING UPDATE_COLLABORATION', 2);
49: END IF;

Line 48: cln_debug_pub.Add('ENTERING UPDATE_COLLABORATION', 2);

44: -- Sets the debug mode to be FILE
45: l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
46:
47: IF (l_Debug_Level <= 2) THEN
48: cln_debug_pub.Add('ENTERING UPDATE_COLLABORATION', 2);
49: END IF;
50:
51: -- Initialize API return status to success
52: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 61: cln_debug_pub.Add('With the following parameters', 1);

57:
58: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
59:
60: IF (l_Debug_Level <= 1) THEN
61: cln_debug_pub.Add('With the following parameters', 1);
62: cln_debug_pub.Add('p_ref_id' || p_ref_id, 1);
63: cln_debug_pub.Add('p_doc_no:' || p_doc_no, 1);
64: cln_debug_pub.Add('p_status_code:' || p_status_code, 1);
65: cln_debug_pub.Add('p_msg_text:' || p_msg_text, 1);

Line 62: cln_debug_pub.Add('p_ref_id' || p_ref_id, 1);

58: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
59:
60: IF (l_Debug_Level <= 1) THEN
61: cln_debug_pub.Add('With the following parameters', 1);
62: cln_debug_pub.Add('p_ref_id' || p_ref_id, 1);
63: cln_debug_pub.Add('p_doc_no:' || p_doc_no, 1);
64: cln_debug_pub.Add('p_status_code:' || p_status_code, 1);
65: cln_debug_pub.Add('p_msg_text:' || p_msg_text, 1);
66: cln_debug_pub.Add('p_part_doc_no:' || p_part_doc_no, 1);

Line 63: cln_debug_pub.Add('p_doc_no:' || p_doc_no, 1);

59:
60: IF (l_Debug_Level <= 1) THEN
61: cln_debug_pub.Add('With the following parameters', 1);
62: cln_debug_pub.Add('p_ref_id' || p_ref_id, 1);
63: cln_debug_pub.Add('p_doc_no:' || p_doc_no, 1);
64: cln_debug_pub.Add('p_status_code:' || p_status_code, 1);
65: cln_debug_pub.Add('p_msg_text:' || p_msg_text, 1);
66: cln_debug_pub.Add('p_part_doc_no:' || p_part_doc_no, 1);
67: cln_debug_pub.Add('p_int_ctl_num:' || p_int_ctl_num, 1);

Line 64: cln_debug_pub.Add('p_status_code:' || p_status_code, 1);

60: IF (l_Debug_Level <= 1) THEN
61: cln_debug_pub.Add('With the following parameters', 1);
62: cln_debug_pub.Add('p_ref_id' || p_ref_id, 1);
63: cln_debug_pub.Add('p_doc_no:' || p_doc_no, 1);
64: cln_debug_pub.Add('p_status_code:' || p_status_code, 1);
65: cln_debug_pub.Add('p_msg_text:' || p_msg_text, 1);
66: cln_debug_pub.Add('p_part_doc_no:' || p_part_doc_no, 1);
67: cln_debug_pub.Add('p_int_ctl_num:' || p_int_ctl_num, 1);
68: cln_debug_pub.Add('p_tp_header_id:' || p_tp_header_id, 1);

Line 65: cln_debug_pub.Add('p_msg_text:' || p_msg_text, 1);

61: cln_debug_pub.Add('With the following parameters', 1);
62: cln_debug_pub.Add('p_ref_id' || p_ref_id, 1);
63: cln_debug_pub.Add('p_doc_no:' || p_doc_no, 1);
64: cln_debug_pub.Add('p_status_code:' || p_status_code, 1);
65: cln_debug_pub.Add('p_msg_text:' || p_msg_text, 1);
66: cln_debug_pub.Add('p_part_doc_no:' || p_part_doc_no, 1);
67: cln_debug_pub.Add('p_int_ctl_num:' || p_int_ctl_num, 1);
68: cln_debug_pub.Add('p_tp_header_id:' || p_tp_header_id, 1);
69: END IF;

Line 66: cln_debug_pub.Add('p_part_doc_no:' || p_part_doc_no, 1);

62: cln_debug_pub.Add('p_ref_id' || p_ref_id, 1);
63: cln_debug_pub.Add('p_doc_no:' || p_doc_no, 1);
64: cln_debug_pub.Add('p_status_code:' || p_status_code, 1);
65: cln_debug_pub.Add('p_msg_text:' || p_msg_text, 1);
66: cln_debug_pub.Add('p_part_doc_no:' || p_part_doc_no, 1);
67: cln_debug_pub.Add('p_int_ctl_num:' || p_int_ctl_num, 1);
68: cln_debug_pub.Add('p_tp_header_id:' || p_tp_header_id, 1);
69: END IF;
70:

Line 67: cln_debug_pub.Add('p_int_ctl_num:' || p_int_ctl_num, 1);

63: cln_debug_pub.Add('p_doc_no:' || p_doc_no, 1);
64: cln_debug_pub.Add('p_status_code:' || p_status_code, 1);
65: cln_debug_pub.Add('p_msg_text:' || p_msg_text, 1);
66: cln_debug_pub.Add('p_part_doc_no:' || p_part_doc_no, 1);
67: cln_debug_pub.Add('p_int_ctl_num:' || p_int_ctl_num, 1);
68: cln_debug_pub.Add('p_tp_header_id:' || p_tp_header_id, 1);
69: END IF;
70:
71: IF p_status_code = 0 THEN

Line 68: cln_debug_pub.Add('p_tp_header_id:' || p_tp_header_id, 1);

64: cln_debug_pub.Add('p_status_code:' || p_status_code, 1);
65: cln_debug_pub.Add('p_msg_text:' || p_msg_text, 1);
66: cln_debug_pub.Add('p_part_doc_no:' || p_part_doc_no, 1);
67: cln_debug_pub.Add('p_int_ctl_num:' || p_int_ctl_num, 1);
68: cln_debug_pub.Add('p_tp_header_id:' || p_tp_header_id, 1);
69: END IF;
70:
71: IF p_status_code = 0 THEN
72: l_doc_status := 'SUCCESS';

Line 80: cln_debug_pub.Add('l_doc_status:' || l_doc_status, 1);

76: l_doc_status := 'ERROR';
77: END IF;
78:
79: IF (l_Debug_Level <= 1) THEN
80: cln_debug_pub.Add('l_doc_status:' || l_doc_status, 1);
81: END IF;
82:
83: l_cln_ch_parameters := wf_parameter_list_t();
84:

Line 99: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update raised', 1);

95: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',
96: l_event_key, NULL, l_cln_ch_parameters, NULL);
97:
98: IF (l_Debug_Level <= 1) THEN
99: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update raised', 1);
100: END IF;
101:
102: IF (l_Debug_Level <= 2) THEN
103: cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);

Line 103: cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);

99: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update raised', 1);
100: END IF;
101:
102: IF (l_Debug_Level <= 2) THEN
103: cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);
104: END IF;
105: EXCEPTION
106: WHEN OTHERS THEN
107: l_error_code := SQLCODE;

Line 112: cln_debug_pub.Add(x_msg_data, 4);

108: l_error_msg := SQLERRM;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: x_msg_data := l_error_code || ':' || l_error_msg;
111: IF (l_Debug_Level <= 6) THEN
112: cln_debug_pub.Add(x_msg_data, 4);
113: END IF;
114: IF (l_Debug_Level <= 2) THEN
115: cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);
116: END IF;

Line 115: cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);

111: IF (l_Debug_Level <= 6) THEN
112: cln_debug_pub.Add(x_msg_data, 4);
113: END IF;
114: IF (l_Debug_Level <= 2) THEN
115: cln_debug_pub.Add('EXITING UPDATE_COLLABORATION', 2);
116: END IF;
117: END UPDATE_COLLABORATION;
118:
119:

Line 152: l_debug_mode :=cln_debug_pub.Set_Debug_Mode('FILE');

148: l_debug_mode VARCHAR2(255);
149: l_msg_data VARCHAR2(2000);
150: BEGIN
151: -- Sets the debug mode to be FILE
152: l_debug_mode :=cln_debug_pub.Set_Debug_Mode('FILE');
153:
154: IF (l_Debug_Level <= 2) THEN
155: cln_debug_pub.Add('ENTERING ADD_COLLABORATION_MESSAGE', 2);
156: END IF;

Line 155: cln_debug_pub.Add('ENTERING ADD_COLLABORATION_MESSAGE', 2);

151: -- Sets the debug mode to be FILE
152: l_debug_mode :=cln_debug_pub.Set_Debug_Mode('FILE');
153:
154: IF (l_Debug_Level <= 2) THEN
155: cln_debug_pub.Add('ENTERING ADD_COLLABORATION_MESSAGE', 2);
156: END IF;
157:
158: -- Parameters received
159: IF (l_Debug_Level <= 1) THEN

Line 160: cln_debug_pub.Add('With the following parameters',1);

156: END IF;
157:
158: -- Parameters received
159: IF (l_Debug_Level <= 1) THEN
160: cln_debug_pub.Add('With the following parameters',1);
161: cln_debug_pub.Add('p_ictrl_no - ' || p_ictrl_no,1);
162: cln_debug_pub.Add('p_ref1 - ' || p_ref1,1);
163: cln_debug_pub.Add('p_ref2 - ' || p_ref2,1);
164: cln_debug_pub.Add('p_ref3 - ' || p_ref3,1);

Line 161: cln_debug_pub.Add('p_ictrl_no - ' || p_ictrl_no,1);

157:
158: -- Parameters received
159: IF (l_Debug_Level <= 1) THEN
160: cln_debug_pub.Add('With the following parameters',1);
161: cln_debug_pub.Add('p_ictrl_no - ' || p_ictrl_no,1);
162: cln_debug_pub.Add('p_ref1 - ' || p_ref1,1);
163: cln_debug_pub.Add('p_ref2 - ' || p_ref2,1);
164: cln_debug_pub.Add('p_ref3 - ' || p_ref3,1);
165: cln_debug_pub.Add('p_ref4 - ' || p_ref4,1);

Line 162: cln_debug_pub.Add('p_ref1 - ' || p_ref1,1);

158: -- Parameters received
159: IF (l_Debug_Level <= 1) THEN
160: cln_debug_pub.Add('With the following parameters',1);
161: cln_debug_pub.Add('p_ictrl_no - ' || p_ictrl_no,1);
162: cln_debug_pub.Add('p_ref1 - ' || p_ref1,1);
163: cln_debug_pub.Add('p_ref2 - ' || p_ref2,1);
164: cln_debug_pub.Add('p_ref3 - ' || p_ref3,1);
165: cln_debug_pub.Add('p_ref4 - ' || p_ref4,1);
166: cln_debug_pub.Add('p_ref5 - ' || p_ref5,1);

Line 163: cln_debug_pub.Add('p_ref2 - ' || p_ref2,1);

159: IF (l_Debug_Level <= 1) THEN
160: cln_debug_pub.Add('With the following parameters',1);
161: cln_debug_pub.Add('p_ictrl_no - ' || p_ictrl_no,1);
162: cln_debug_pub.Add('p_ref1 - ' || p_ref1,1);
163: cln_debug_pub.Add('p_ref2 - ' || p_ref2,1);
164: cln_debug_pub.Add('p_ref3 - ' || p_ref3,1);
165: cln_debug_pub.Add('p_ref4 - ' || p_ref4,1);
166: cln_debug_pub.Add('p_ref5 - ' || p_ref5,1);
167: cln_debug_pub.Add('p_dtl_msg - ' || p_dtl_msg,1);

Line 164: cln_debug_pub.Add('p_ref3 - ' || p_ref3,1);

160: cln_debug_pub.Add('With the following parameters',1);
161: cln_debug_pub.Add('p_ictrl_no - ' || p_ictrl_no,1);
162: cln_debug_pub.Add('p_ref1 - ' || p_ref1,1);
163: cln_debug_pub.Add('p_ref2 - ' || p_ref2,1);
164: cln_debug_pub.Add('p_ref3 - ' || p_ref3,1);
165: cln_debug_pub.Add('p_ref4 - ' || p_ref4,1);
166: cln_debug_pub.Add('p_ref5 - ' || p_ref5,1);
167: cln_debug_pub.Add('p_dtl_msg - ' || p_dtl_msg,1);
168: END IF;

Line 165: cln_debug_pub.Add('p_ref4 - ' || p_ref4,1);

161: cln_debug_pub.Add('p_ictrl_no - ' || p_ictrl_no,1);
162: cln_debug_pub.Add('p_ref1 - ' || p_ref1,1);
163: cln_debug_pub.Add('p_ref2 - ' || p_ref2,1);
164: cln_debug_pub.Add('p_ref3 - ' || p_ref3,1);
165: cln_debug_pub.Add('p_ref4 - ' || p_ref4,1);
166: cln_debug_pub.Add('p_ref5 - ' || p_ref5,1);
167: cln_debug_pub.Add('p_dtl_msg - ' || p_dtl_msg,1);
168: END IF;
169:

Line 166: cln_debug_pub.Add('p_ref5 - ' || p_ref5,1);

162: cln_debug_pub.Add('p_ref1 - ' || p_ref1,1);
163: cln_debug_pub.Add('p_ref2 - ' || p_ref2,1);
164: cln_debug_pub.Add('p_ref3 - ' || p_ref3,1);
165: cln_debug_pub.Add('p_ref4 - ' || p_ref4,1);
166: cln_debug_pub.Add('p_ref5 - ' || p_ref5,1);
167: cln_debug_pub.Add('p_dtl_msg - ' || p_dtl_msg,1);
168: END IF;
169:
170: -- Initialize API return status to success

Line 167: cln_debug_pub.Add('p_dtl_msg - ' || p_dtl_msg,1);

163: cln_debug_pub.Add('p_ref2 - ' || p_ref2,1);
164: cln_debug_pub.Add('p_ref3 - ' || p_ref3,1);
165: cln_debug_pub.Add('p_ref4 - ' || p_ref4,1);
166: cln_debug_pub.Add('p_ref5 - ' || p_ref5,1);
167: cln_debug_pub.Add('p_dtl_msg - ' || p_dtl_msg,1);
168: END IF;
169:
170: -- Initialize API return status to success
171: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 196: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);

192: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.addmessage',
193: l_event_key, NULL, l_cln_ch_parameters, NULL);
194:
195: IF (l_Debug_Level <= 1) THEN
196: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);
197: END IF;
198:
199: IF (l_Debug_Level <= 2) THEN
200: cln_debug_pub.Add('EXITING ADD_COLLABORATION_MESSAGE', 2);

Line 200: cln_debug_pub.Add('EXITING ADD_COLLABORATION_MESSAGE', 2);

196: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.addmessage', 1);
197: END IF;
198:
199: IF (l_Debug_Level <= 2) THEN
200: cln_debug_pub.Add('EXITING ADD_COLLABORATION_MESSAGE', 2);
201: END IF;
202: EXCEPTION
203: WHEN OTHERS THEN
204: l_error_code := SQLCODE;

Line 209: cln_debug_pub.Add(x_msg_data, 4);

205: l_error_msg := SQLERRM;
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: x_msg_data := l_error_code || ':' || l_error_msg;
208: IF (l_Debug_Level <= 6) THEN
209: cln_debug_pub.Add(x_msg_data, 4);
210: END IF;
211: IF (l_Debug_Level <= 2) THEN
212: cln_debug_pub.Add('EXITING ADD_COLLABORATION_MESSAGE', 2);
213: END IF;

Line 212: cln_debug_pub.Add('EXITING ADD_COLLABORATION_MESSAGE', 2);

208: IF (l_Debug_Level <= 6) THEN
209: cln_debug_pub.Add(x_msg_data, 4);
210: END IF;
211: IF (l_Debug_Level <= 2) THEN
212: cln_debug_pub.Add('EXITING ADD_COLLABORATION_MESSAGE', 2);
213: END IF;
214: END ADD_COLLABORATION_MESSAGE;
215:
216:

Line 246: l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');

242: l_error_msg VARCHAR2(2000);
243: BEGIN
244:
245: -- Sets the debug mode to be FILE
246: l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
247:
248: IF (l_Debug_Level <= 2) THEN
249: cln_debug_pub.Add('ENTERING GET_FND_MESSSAGE', 2);
250: END IF;

Line 249: cln_debug_pub.Add('ENTERING GET_FND_MESSSAGE', 2);

245: -- Sets the debug mode to be FILE
246: l_debug_mode := cln_debug_pub.Set_Debug_Mode('FILE');
247:
248: IF (l_Debug_Level <= 2) THEN
249: cln_debug_pub.Add('ENTERING GET_FND_MESSSAGE', 2);
250: END IF;
251:
252: IF (l_Debug_Level <= 1) THEN
253: cln_debug_pub.Add('With the following parameters:', 1);

Line 253: cln_debug_pub.Add('With the following parameters:', 1);

249: cln_debug_pub.Add('ENTERING GET_FND_MESSSAGE', 2);
250: END IF;
251:
252: IF (l_Debug_Level <= 1) THEN
253: cln_debug_pub.Add('With the following parameters:', 1);
254: cln_debug_pub.Add('p_fnd_message_name:' || p_fnd_message_name, 1);
255: cln_debug_pub.Add('p_token_name1:' || p_token_name1, 1);
256: cln_debug_pub.Add('p_token_value1:' || p_token_value1, 1);
257: cln_debug_pub.Add('p_token_name2:' || p_token_name2, 1);

Line 254: cln_debug_pub.Add('p_fnd_message_name:' || p_fnd_message_name, 1);

250: END IF;
251:
252: IF (l_Debug_Level <= 1) THEN
253: cln_debug_pub.Add('With the following parameters:', 1);
254: cln_debug_pub.Add('p_fnd_message_name:' || p_fnd_message_name, 1);
255: cln_debug_pub.Add('p_token_name1:' || p_token_name1, 1);
256: cln_debug_pub.Add('p_token_value1:' || p_token_value1, 1);
257: cln_debug_pub.Add('p_token_name2:' || p_token_name2, 1);
258: cln_debug_pub.Add('p_token_value2:' || p_token_value2, 1);

Line 255: cln_debug_pub.Add('p_token_name1:' || p_token_name1, 1);

251:
252: IF (l_Debug_Level <= 1) THEN
253: cln_debug_pub.Add('With the following parameters:', 1);
254: cln_debug_pub.Add('p_fnd_message_name:' || p_fnd_message_name, 1);
255: cln_debug_pub.Add('p_token_name1:' || p_token_name1, 1);
256: cln_debug_pub.Add('p_token_value1:' || p_token_value1, 1);
257: cln_debug_pub.Add('p_token_name2:' || p_token_name2, 1);
258: cln_debug_pub.Add('p_token_value2:' || p_token_value2, 1);
259: END IF;

Line 256: cln_debug_pub.Add('p_token_value1:' || p_token_value1, 1);

252: IF (l_Debug_Level <= 1) THEN
253: cln_debug_pub.Add('With the following parameters:', 1);
254: cln_debug_pub.Add('p_fnd_message_name:' || p_fnd_message_name, 1);
255: cln_debug_pub.Add('p_token_name1:' || p_token_name1, 1);
256: cln_debug_pub.Add('p_token_value1:' || p_token_value1, 1);
257: cln_debug_pub.Add('p_token_name2:' || p_token_name2, 1);
258: cln_debug_pub.Add('p_token_value2:' || p_token_value2, 1);
259: END IF;
260:

Line 257: cln_debug_pub.Add('p_token_name2:' || p_token_name2, 1);

253: cln_debug_pub.Add('With the following parameters:', 1);
254: cln_debug_pub.Add('p_fnd_message_name:' || p_fnd_message_name, 1);
255: cln_debug_pub.Add('p_token_name1:' || p_token_name1, 1);
256: cln_debug_pub.Add('p_token_value1:' || p_token_value1, 1);
257: cln_debug_pub.Add('p_token_name2:' || p_token_name2, 1);
258: cln_debug_pub.Add('p_token_value2:' || p_token_value2, 1);
259: END IF;
260:
261: FND_MESSAGE.SET_NAME('CLN', p_fnd_message_name);

Line 258: cln_debug_pub.Add('p_token_value2:' || p_token_value2, 1);

254: cln_debug_pub.Add('p_fnd_message_name:' || p_fnd_message_name, 1);
255: cln_debug_pub.Add('p_token_name1:' || p_token_name1, 1);
256: cln_debug_pub.Add('p_token_value1:' || p_token_value1, 1);
257: cln_debug_pub.Add('p_token_name2:' || p_token_name2, 1);
258: cln_debug_pub.Add('p_token_value2:' || p_token_value2, 1);
259: END IF;
260:
261: FND_MESSAGE.SET_NAME('CLN', p_fnd_message_name);
262: IF p_token_name1 IS NOT NULL THEN

Line 271: cln_debug_pub.Add('p_message:' || p_message, 1);

267: END IF;
268: p_message := FND_MESSAGE.GET;
269:
270: IF (l_Debug_Level <= 1) THEN
271: cln_debug_pub.Add('p_message:' || p_message, 1);
272: END IF;
273:
274: IF (l_Debug_Level <= 2) THEN
275: cln_debug_pub.Add('EXITING GET_FND_MESSSAGE', 2);

Line 275: cln_debug_pub.Add('EXITING GET_FND_MESSSAGE', 2);

271: cln_debug_pub.Add('p_message:' || p_message, 1);
272: END IF;
273:
274: IF (l_Debug_Level <= 2) THEN
275: cln_debug_pub.Add('EXITING GET_FND_MESSSAGE', 2);
276: END IF;
277:
278: EXCEPTION
279: WHEN OTHERS THEN

Line 283: cln_debug_pub.Add(l_return_msg, 3);

279: WHEN OTHERS THEN
280: l_error_code := SQLCODE;
281: l_error_msg := SQLERRM;
282: l_return_msg := l_error_code||' : '||l_error_msg;
283: cln_debug_pub.Add(l_return_msg, 3);
284: l_return_msg := 'While trying to get the FND message '
285: || ' for '
286: || p_fnd_message_name
287: || ', the following error is encountered:'

Line 290: cln_debug_pub.Add(l_return_msg, 3);

286: || p_fnd_message_name
287: || ', the following error is encountered:'
288: || l_return_msg;
289: IF (l_Debug_Level <= 6) THEN
290: cln_debug_pub.Add(l_return_msg, 3);
291: END IF;
292: IF (l_Debug_Level <= 2) THEN
293: cln_debug_pub.Add('EXITING GET_FND_MESSSAGE', 2);
294: END IF;

Line 293: cln_debug_pub.Add('EXITING GET_FND_MESSSAGE', 2);

289: IF (l_Debug_Level <= 6) THEN
290: cln_debug_pub.Add(l_return_msg, 3);
291: END IF;
292: IF (l_Debug_Level <= 2) THEN
293: cln_debug_pub.Add('EXITING GET_FND_MESSSAGE', 2);
294: END IF;
295: END GET_FND_MESSSAGE;
296:
297:

Line 336: l_debug_mode :=cln_debug_pub.Set_Debug_Mode('FILE');

332: l_tp_type VARCHAR2(255);
333: BEGIN
334:
335: -- Sets the debug mode to be FILE
336: l_debug_mode :=cln_debug_pub.Set_Debug_Mode('FILE');
337:
338: x_resultout:='Yes';
339:
340: IF (l_Debug_Level <= 2) THEN

Line 341: cln_debug_pub.Add('ENTERING CALL_TAKE_ACTIONS API', 2);

337:
338: x_resultout:='Yes';
339:
340: IF (l_Debug_Level <= 2) THEN
341: cln_debug_pub.Add('ENTERING CALL_TAKE_ACTIONS API', 2);
342: END IF;
343:
344: IF (l_Debug_Level <= 1) THEN
345: cln_debug_pub.Add('Parameters:', 1);

Line 345: cln_debug_pub.Add('Parameters:', 1);

341: cln_debug_pub.Add('ENTERING CALL_TAKE_ACTIONS API', 2);
342: END IF;
343:
344: IF (l_Debug_Level <= 1) THEN
345: cln_debug_pub.Add('Parameters:', 1);
346: END IF;
347:
348: -- Internal Control Number
349: l_int_ctl_num := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER1', TRUE));

Line 351: cln_debug_pub.Add('l_int_ctl_num:' || l_int_ctl_num, 1);

347:
348: -- Internal Control Number
349: l_int_ctl_num := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER1', TRUE));
350: IF (l_Debug_Level <= 1) THEN
351: cln_debug_pub.Add('l_int_ctl_num:' || l_int_ctl_num, 1);
352: END IF;
353:
354: -- Application Reference ID
355: l_app_ref_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);

Line 357: cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);

353:
354: -- Application Reference ID
355: l_app_ref_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);
356: IF (l_Debug_Level <= 1) THEN
357: cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
358: END IF;
359:
360: -- Document Status
361: l_doc_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);

Line 363: cln_debug_pub.Add('l_doc_status:' || l_doc_status, 1);

359:
360: -- Document Status
361: l_doc_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);
362: IF (l_Debug_Level <= 1) THEN
363: cln_debug_pub.Add('l_doc_status:' || l_doc_status, 1);
364: END IF;
365:
366: -- TP Header ID
367: l_trp_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);

Line 369: cln_debug_pub.Add('l_tp_id:' || l_trp_id, 1);

365:
366: -- TP Header ID
367: l_trp_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);
368: IF (l_Debug_Level <= 1) THEN
369: cln_debug_pub.Add('l_tp_id:' || l_trp_id, 1);
370: END IF;
371:
372: -- Confirm BOD Status lvl
373: l_cbod_statuslvl := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', TRUE);

Line 375: cln_debug_pub.Add('l_cbod_statuslvl:' || l_cbod_statuslvl, 1);

371:
372: -- Confirm BOD Status lvl
373: l_cbod_statuslvl := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', TRUE);
374: IF (l_Debug_Level <= 1) THEN
375: cln_debug_pub.Add('l_cbod_statuslvl:' || l_cbod_statuslvl, 1);
376: END IF;
377:
378:
379: -- If either statuslvl or document status is available, set the other one

Line 401: cln_debug_pub.Add('l_not_code1:' || l_not_code1, 1);

397:
398: -- Notification Code1
399: l_not_code1 := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);
400: IF (l_Debug_Level <= 1) THEN
401: cln_debug_pub.Add('l_not_code1:' || l_not_code1, 1);
402: END IF;
403:
404: -- Notification Code Description1
405: l_not_code_desc1 := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);

Line 407: cln_debug_pub.Add('l_not_code_desc1:' || l_not_code_desc1, 1);

403:
404: -- Notification Code Description1
405: l_not_code_desc1 := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);
406: IF (l_Debug_Level <= 1) THEN
407: cln_debug_pub.Add('l_not_code_desc1:' || l_not_code_desc1, 1);
408: END IF;
409:
410:
411: -- Trading Partner Type

Line 414: cln_debug_pub.Add('l_tp_type:' || l_tp_type, 1);

410:
411: -- Trading Partner Type
412: l_tp_type := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
413: IF (l_Debug_Level <= 1) THEN
414: cln_debug_pub.Add('l_tp_type:' || l_tp_type, 1);
415: END IF;
416:
417: -- For futurte use
418: -- l_unused := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE);

Line 423: cln_debug_pub.Add('Trading Partner ID:' || l_tp_id, 1);

419:
420:
421: CLN_UTILS.GET_TRADING_PARTNER(l_trp_id, l_tp_id);
422: IF (l_Debug_Level <= 1) THEN
423: cln_debug_pub.Add('Trading Partner ID:' || l_tp_id, 1);
424: END IF;
425:
426:
427: IF l_not_code1 IS NOT NULL AND LENGTH(TRIM(l_not_code1)) > 0 THEN

Line 440: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 6);

436: p_coll_point => 'APPS',
437: p_int_con_no => l_int_ctl_num);
438: IF l_return_status <> 'S' THEN
439: IF (l_Debug_Level <= 6) THEN
440: cln_debug_pub.Add('CALL_TAKE_ACTIONS CALL FAILED', 6);
441: END IF;
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444: END IF;

Line 447: cln_debug_pub.Add('EXITING CALL_TAKE_ACTIONS API', 2);

443: END IF;
444: END IF;
445:
446: IF (l_Debug_Level <= 2) THEN
447: cln_debug_pub.Add('EXITING CALL_TAKE_ACTIONS API', 2);
448: END IF;
449:
450: EXCEPTION
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 453: cln_debug_pub.Add(l_return_msg, 6);

449:
450: EXCEPTION
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: IF (l_Debug_Level <= 6) THEN
453: cln_debug_pub.Add(l_return_msg, 6);
454: END IF;
455:
456: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_return_msg);
457: IF (l_Debug_Level <= 2) THEN

Line 458: cln_debug_pub.Add('EXITING CALL_TAKE_ACTIONS API', 2);

454: END IF;
455:
456: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_return_msg);
457: IF (l_Debug_Level <= 2) THEN
458: cln_debug_pub.Add('EXITING CALL_TAKE_ACTIONS API', 2);
459: END IF;
460:
461: WHEN OTHERS THEN
462: l_error_code := SQLCODE;

Line 466: cln_debug_pub.Add(l_not_msg, 6);

462: l_error_code := SQLCODE;
463: l_error_msg := SQLERRM;
464: l_not_msg := l_error_code || ':' || l_error_msg;
465: IF (l_Debug_Level <= 6) THEN
466: cln_debug_pub.Add(l_not_msg, 6);
467: END IF;
468:
469: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_not_msg);
470: IF (l_Debug_Level <= 2) THEN

Line 471: cln_debug_pub.Add('EXITING CALL_TAKE_ACTIONS API', 2);

467: END IF;
468:
469: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_not_msg);
470: IF (l_Debug_Level <= 2) THEN
471: cln_debug_pub.Add('EXITING CALL_TAKE_ACTIONS API', 2);
472: END IF;
473: END CALL_TAKE_ACTIONS;
474:
475: