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.M4U_PARTY_QUERY dependencies on CLN_DEBUG_PUB

Line 43: cln_debug_pub.Add('=========================================', 2);

39: r_pos NUMBER;
40: BEGIN
41:
42: IF (l_debug_Level <= 2) THEN
43: cln_debug_pub.Add('=========================================', 2);
44: cln_debug_pub.Add('Entering m4u_party_query.parse_param_list', 2);
45: END IF;
46:
47: IF (l_debug_Level <= 1) THEN

Line 44: cln_debug_pub.Add('Entering m4u_party_query.parse_param_list', 2);

40: BEGIN
41:
42: IF (l_debug_Level <= 2) THEN
43: cln_debug_pub.Add('=========================================', 2);
44: cln_debug_pub.Add('Entering m4u_party_query.parse_param_list', 2);
45: END IF;
46:
47: IF (l_debug_Level <= 1) THEN
48: cln_debug_pub.Add('p_param_list - ' || p_param_list, 1);

Line 48: cln_debug_pub.Add('p_param_list - ' || p_param_list, 1);

44: cln_debug_pub.Add('Entering m4u_party_query.parse_param_list', 2);
45: END IF;
46:
47: IF (l_debug_Level <= 1) THEN
48: cln_debug_pub.Add('p_param_list - ' || p_param_list, 1);
49: END IF;
50:
51: l_pos := 1;
52: r_pos := INSTR(p_param_list,'$',1,1);

Line 94: cln_debug_pub.Add('x_org_gln - ' || x_org_gln, 1);

90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: x_msg_data := '';
92:
93: IF (l_debug_Level <= 1) THEN
94: cln_debug_pub.Add('x_org_gln - ' || x_org_gln, 1);
95: cln_debug_pub.Add('x_duns_code - ' || x_duns_code, 1);
96: cln_debug_pub.Add('x_org_name - ' || x_org_name, 1);
97: cln_debug_pub.Add('x_post_code - ' || x_post_code, 1);
98: cln_debug_pub.Add('x_city - ' || x_city, 1);

Line 95: cln_debug_pub.Add('x_duns_code - ' || x_duns_code, 1);

91: x_msg_data := '';
92:
93: IF (l_debug_Level <= 1) THEN
94: cln_debug_pub.Add('x_org_gln - ' || x_org_gln, 1);
95: cln_debug_pub.Add('x_duns_code - ' || x_duns_code, 1);
96: cln_debug_pub.Add('x_org_name - ' || x_org_name, 1);
97: cln_debug_pub.Add('x_post_code - ' || x_post_code, 1);
98: cln_debug_pub.Add('x_city - ' || x_city, 1);
99: cln_debug_pub.Add('x_return_status - ' || x_return_status, 1);

Line 96: cln_debug_pub.Add('x_org_name - ' || x_org_name, 1);

92:
93: IF (l_debug_Level <= 1) THEN
94: cln_debug_pub.Add('x_org_gln - ' || x_org_gln, 1);
95: cln_debug_pub.Add('x_duns_code - ' || x_duns_code, 1);
96: cln_debug_pub.Add('x_org_name - ' || x_org_name, 1);
97: cln_debug_pub.Add('x_post_code - ' || x_post_code, 1);
98: cln_debug_pub.Add('x_city - ' || x_city, 1);
99: cln_debug_pub.Add('x_return_status - ' || x_return_status, 1);
100: cln_debug_pub.Add('x_msg_data - ' || x_msg_data, 1);

Line 97: cln_debug_pub.Add('x_post_code - ' || x_post_code, 1);

93: IF (l_debug_Level <= 1) THEN
94: cln_debug_pub.Add('x_org_gln - ' || x_org_gln, 1);
95: cln_debug_pub.Add('x_duns_code - ' || x_duns_code, 1);
96: cln_debug_pub.Add('x_org_name - ' || x_org_name, 1);
97: cln_debug_pub.Add('x_post_code - ' || x_post_code, 1);
98: cln_debug_pub.Add('x_city - ' || x_city, 1);
99: cln_debug_pub.Add('x_return_status - ' || x_return_status, 1);
100: cln_debug_pub.Add('x_msg_data - ' || x_msg_data, 1);
101: END IF;

Line 98: cln_debug_pub.Add('x_city - ' || x_city, 1);

94: cln_debug_pub.Add('x_org_gln - ' || x_org_gln, 1);
95: cln_debug_pub.Add('x_duns_code - ' || x_duns_code, 1);
96: cln_debug_pub.Add('x_org_name - ' || x_org_name, 1);
97: cln_debug_pub.Add('x_post_code - ' || x_post_code, 1);
98: cln_debug_pub.Add('x_city - ' || x_city, 1);
99: cln_debug_pub.Add('x_return_status - ' || x_return_status, 1);
100: cln_debug_pub.Add('x_msg_data - ' || x_msg_data, 1);
101: END IF;
102:

Line 99: cln_debug_pub.Add('x_return_status - ' || x_return_status, 1);

95: cln_debug_pub.Add('x_duns_code - ' || x_duns_code, 1);
96: cln_debug_pub.Add('x_org_name - ' || x_org_name, 1);
97: cln_debug_pub.Add('x_post_code - ' || x_post_code, 1);
98: cln_debug_pub.Add('x_city - ' || x_city, 1);
99: cln_debug_pub.Add('x_return_status - ' || x_return_status, 1);
100: cln_debug_pub.Add('x_msg_data - ' || x_msg_data, 1);
101: END IF;
102:
103:

Line 100: cln_debug_pub.Add('x_msg_data - ' || x_msg_data, 1);

96: cln_debug_pub.Add('x_org_name - ' || x_org_name, 1);
97: cln_debug_pub.Add('x_post_code - ' || x_post_code, 1);
98: cln_debug_pub.Add('x_city - ' || x_city, 1);
99: cln_debug_pub.Add('x_return_status - ' || x_return_status, 1);
100: cln_debug_pub.Add('x_msg_data - ' || x_msg_data, 1);
101: END IF;
102:
103:
104:

Line 106: cln_debug_pub.Add('Exiting m4u_party_query.parse_param_list - normal', 2);

102:
103:
104:
105: IF (l_debug_Level <= 2) THEN
106: cln_debug_pub.Add('Exiting m4u_party_query.parse_param_list - normal', 2);
107: cln_debug_pub.Add('=================================================', 2);
108: END IF;
109:
110:

Line 107: cln_debug_pub.Add('=================================================', 2);

103:
104:
105: IF (l_debug_Level <= 2) THEN
106: cln_debug_pub.Add('Exiting m4u_party_query.parse_param_list - normal', 2);
107: cln_debug_pub.Add('=================================================', 2);
108: END IF;
109:
110:
111: EXCEPTION

Line 153: cln_debug_pub.Add('M4U:----- Entering raise_partyqry_event ------- ',2);

149: l_msg_count NUMBER;
150: BEGIN
151:
152: IF (l_debug_Level <= 2) THEN
153: cln_debug_pub.Add('M4U:----- Entering raise_partyqry_event ------- ',2);
154: END IF;
155:
156: -- Parameters received
157: IF (l_Debug_Level <= 1) THEN

Line 158: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);

154: END IF;
155:
156: -- Parameters received
157: IF (l_Debug_Level <= 1) THEN
158: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
159: cln_debug_pub.Add('p_tp_gln - '||p_tp_gln ,1);
160: cln_debug_pub.Add('p_org_gln - '||p_org_gln,1);
161: cln_debug_pub.Add('p_org_name - '||p_org_name,1);
162: cln_debug_pub.Add('p_duns - '||p_duns ,1);

Line 159: cln_debug_pub.Add('p_tp_gln - '||p_tp_gln ,1);

155:
156: -- Parameters received
157: IF (l_Debug_Level <= 1) THEN
158: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
159: cln_debug_pub.Add('p_tp_gln - '||p_tp_gln ,1);
160: cln_debug_pub.Add('p_org_gln - '||p_org_gln,1);
161: cln_debug_pub.Add('p_org_name - '||p_org_name,1);
162: cln_debug_pub.Add('p_duns - '||p_duns ,1);
163: cln_debug_pub.Add('p_postal_code - '||p_postal_code,1);

Line 160: cln_debug_pub.Add('p_org_gln - '||p_org_gln,1);

156: -- Parameters received
157: IF (l_Debug_Level <= 1) THEN
158: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
159: cln_debug_pub.Add('p_tp_gln - '||p_tp_gln ,1);
160: cln_debug_pub.Add('p_org_gln - '||p_org_gln,1);
161: cln_debug_pub.Add('p_org_name - '||p_org_name,1);
162: cln_debug_pub.Add('p_duns - '||p_duns ,1);
163: cln_debug_pub.Add('p_postal_code - '||p_postal_code,1);
164: cln_debug_pub.Add('p_city - '||p_city,1);

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

157: IF (l_Debug_Level <= 1) THEN
158: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
159: cln_debug_pub.Add('p_tp_gln - '||p_tp_gln ,1);
160: cln_debug_pub.Add('p_org_gln - '||p_org_gln,1);
161: cln_debug_pub.Add('p_org_name - '||p_org_name,1);
162: cln_debug_pub.Add('p_duns - '||p_duns ,1);
163: cln_debug_pub.Add('p_postal_code - '||p_postal_code,1);
164: cln_debug_pub.Add('p_city - '||p_city,1);
165: cln_debug_pub.Add('p_org_status - '||p_org_status,1);

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

158: cln_debug_pub.Add('++++ PARAMETERS RECEIVED FROM CONCURRENT PROGRAM ++ ',1);
159: cln_debug_pub.Add('p_tp_gln - '||p_tp_gln ,1);
160: cln_debug_pub.Add('p_org_gln - '||p_org_gln,1);
161: cln_debug_pub.Add('p_org_name - '||p_org_name,1);
162: cln_debug_pub.Add('p_duns - '||p_duns ,1);
163: cln_debug_pub.Add('p_postal_code - '||p_postal_code,1);
164: cln_debug_pub.Add('p_city - '||p_city,1);
165: cln_debug_pub.Add('p_org_status - '||p_org_status,1);
166: cln_debug_pub.Add('p_msg_count - '||p_msg_count,1);

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

159: cln_debug_pub.Add('p_tp_gln - '||p_tp_gln ,1);
160: cln_debug_pub.Add('p_org_gln - '||p_org_gln,1);
161: cln_debug_pub.Add('p_org_name - '||p_org_name,1);
162: cln_debug_pub.Add('p_duns - '||p_duns ,1);
163: cln_debug_pub.Add('p_postal_code - '||p_postal_code,1);
164: cln_debug_pub.Add('p_city - '||p_city,1);
165: cln_debug_pub.Add('p_org_status - '||p_org_status,1);
166: cln_debug_pub.Add('p_msg_count - '||p_msg_count,1);
167: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);

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

160: cln_debug_pub.Add('p_org_gln - '||p_org_gln,1);
161: cln_debug_pub.Add('p_org_name - '||p_org_name,1);
162: cln_debug_pub.Add('p_duns - '||p_duns ,1);
163: cln_debug_pub.Add('p_postal_code - '||p_postal_code,1);
164: cln_debug_pub.Add('p_city - '||p_city,1);
165: cln_debug_pub.Add('p_org_status - '||p_org_status,1);
166: cln_debug_pub.Add('p_msg_count - '||p_msg_count,1);
167: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);
168: END IF;

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

161: cln_debug_pub.Add('p_org_name - '||p_org_name,1);
162: cln_debug_pub.Add('p_duns - '||p_duns ,1);
163: cln_debug_pub.Add('p_postal_code - '||p_postal_code,1);
164: cln_debug_pub.Add('p_city - '||p_city,1);
165: cln_debug_pub.Add('p_org_status - '||p_org_status,1);
166: cln_debug_pub.Add('p_msg_count - '||p_msg_count,1);
167: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);
168: END IF;
169:

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

162: cln_debug_pub.Add('p_duns - '||p_duns ,1);
163: cln_debug_pub.Add('p_postal_code - '||p_postal_code,1);
164: cln_debug_pub.Add('p_city - '||p_city,1);
165: cln_debug_pub.Add('p_org_status - '||p_org_status,1);
166: cln_debug_pub.Add('p_msg_count - '||p_msg_count,1);
167: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);
168: END IF;
169:
170: l_msg_count := p_msg_count;

Line 167: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);

163: cln_debug_pub.Add('p_postal_code - '||p_postal_code,1);
164: cln_debug_pub.Add('p_city - '||p_city,1);
165: cln_debug_pub.Add('p_org_status - '||p_org_status,1);
166: cln_debug_pub.Add('p_msg_count - '||p_msg_count,1);
167: cln_debug_pub.Add('+++++++++++++++++++++++++++++++++++++++++++++++++++',1);
168: END IF;
169:
170: l_msg_count := p_msg_count;
171: -- Default the count to 10 if invalid value is input

Line 187: cln_debug_pub.Add('Trading Partner '||l_msg_data,4);

183: p_attr_type => 'GLN',
184: p_attr_value => p_tp_gln
185: )THEN
186: IF (l_Debug_Level <= 5) THEN
187: cln_debug_pub.Add('Trading Partner '||l_msg_data,4);
188: END IF;
189:
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;

Line 204: cln_debug_pub.Add('Organization '||l_msg_data,4);

200: p_attr_type => 'GLN',
201: p_attr_value => p_org_gln
202: )THEN
203: IF (l_Debug_Level <= 5) THEN
204: cln_debug_pub.Add('Organization '||l_msg_data,4);
205: END IF;
206:
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;

Line 221: cln_debug_pub.Add('Final p_org_status value - '||l_org_status,1);

217: END IF;
218: END IF;
219:
220: IF (l_Debug_Level <= 1) THEN
221: cln_debug_pub.Add('Final p_org_status value - '||l_org_status,1);
222: END IF;
223:
224: -- obtain a unique event-id
225: SELECT m4u_wlqid_s.NEXTVAL

Line 244: cln_debug_pub.Add('ECX_EVENT_KEY - '||l_event_key,1);

240: p_name => 'ECX_EVENT_KEY',
241: p_value => l_event_key,
242: p_parameterlist => l_event_parameters );
243: IF (l_Debug_Level <= 1) THEN
244: cln_debug_pub.Add('ECX_EVENT_KEY - '||l_event_key,1);
245: END IF;
246:
247: wf_event.AddParameterToList(
248: p_name => 'ECX_PARAMETER2',

Line 252: cln_debug_pub.Add('ECX_PARAMETER2 - Message Count - '||p_msg_count,1);

248: p_name => 'ECX_PARAMETER2',
249: p_value => l_msg_count,
250: p_parameterlist => l_event_parameters );
251: IF (l_Debug_Level <= 1) THEN
252: cln_debug_pub.Add('ECX_PARAMETER2 - Message Count - '||p_msg_count,1);
253: END IF;
254:
255:
256: wf_event.AddParameterToList(

Line 261: cln_debug_pub.Add('ECX_PARAMETER3 - TP GLN - '||p_tp_gln,1);

257: p_name => 'ECX_PARAMETER3',
258: p_value => p_tp_gln,
259: p_parameterlist => l_event_parameters );
260: IF (l_Debug_Level <= 1) THEN
261: cln_debug_pub.Add('ECX_PARAMETER3 - TP GLN - '||p_tp_gln,1);
262: END IF;
263:
264: wf_event.AddParameterToList(
265: p_name => 'ECX_PARAMETER5',

Line 269: cln_debug_pub.Add('ECX_PARAMETER5 - Optional Parameters - '|| l_ptyqry_arg,1);

265: p_name => 'ECX_PARAMETER5',
266: p_value => l_ptyqry_arg,
267: p_parameterlist => l_event_parameters );
268: IF (l_Debug_Level <= 1) THEN
269: cln_debug_pub.Add('ECX_PARAMETER5 - Optional Parameters - '|| l_ptyqry_arg,1);
270: END IF;
271:
272: wf_event.AddParameterToList(
273: p_name => 'ECX_TRANSACTION_TYPE',

Line 277: cln_debug_pub.Add('ECX_TRANSACTION_TYPE - M4U',1);

273: p_name => 'ECX_TRANSACTION_TYPE',
274: p_value => 'M4U',
275: p_parameterlist => l_event_parameters );
276: IF (l_Debug_Level <= 1) THEN
277: cln_debug_pub.Add('ECX_TRANSACTION_TYPE - M4U',1);
278: END IF;
279:
280: wf_event.AddParameterToList(
281: p_name => 'ECX_TRANSACTION_SUBTYPE',

Line 285: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE - PARTYQRY',1);

281: p_name => 'ECX_TRANSACTION_SUBTYPE',
282: p_value => 'PARTYQRY',
283: p_parameterlist => l_event_parameters );
284: IF (l_Debug_Level <= 1) THEN
285: cln_debug_pub.Add('ECX_TRANSACTION_SUBTYPE - PARTYQRY',1);
286: END IF;
287:
288: wf_event.AddParameterToList(
289: p_name => 'ECX_DOCUMENT_ID',

Line 293: cln_debug_pub.Add('ECX_DOCUMENT_ID - '||l_event_key,1);

289: p_name => 'ECX_DOCUMENT_ID',
290: p_value => l_event_key,
291: p_parameterlist => l_event_parameters );
292: IF (l_Debug_Level <= 1) THEN
293: cln_debug_pub.Add('ECX_DOCUMENT_ID - '||l_event_key,1);
294: END IF;
295:
296:
297: wf_event.AddParameterToList(

Line 302: cln_debug_pub.Add('M4U_CLN_COLL_TYPE - M4U_PARTY_QUERY',1);

298: p_name => 'M4U_CLN_COLL_TYPE',
299: p_value => 'M4U_PARTY_QUERY',
300: p_parameterlist => l_event_parameters );
301: IF (l_Debug_Level <= 1) THEN
302: cln_debug_pub.Add('M4U_CLN_COLL_TYPE - M4U_PARTY_QUERY',1);
303: END IF;
304:
305: wf_event.AddParameterToList(
306: p_name => 'M4U_CLN_DOC_TYPE',

Line 310: cln_debug_pub.Add('M4U_CLN_DOC_TYPE - M4U_PARTY_QUERY',1);

306: p_name => 'M4U_CLN_DOC_TYPE',
307: p_value => 'M4U_PARTY_QUERY',
308: p_parameterlist => l_event_parameters );
309: IF (l_Debug_Level <= 1) THEN
310: cln_debug_pub.Add('M4U_CLN_DOC_TYPE - M4U_PARTY_QUERY',1);
311: END IF;
312:
313: wf_event.AddParameterToList(
314: p_name => 'M4U_DOC_NO',

Line 318: cln_debug_pub.Add('M4U_DOC_NO - '||l_event_key,1);

314: p_name => 'M4U_DOC_NO',
315: p_value => l_event_key,
316: p_parameterlist => l_event_parameters );
317: IF (l_Debug_Level <= 1) THEN
318: cln_debug_pub.Add('M4U_DOC_NO - '||l_event_key,1);
319: END IF;
320:
321: wf_event.AddParameterToList(
322: p_name => 'ATTRIBUTE1',

Line 326: cln_debug_pub.Add('ATTRIBUTE1 - '||m4u_ucc_utils.g_host_gln,1);

322: p_name => 'ATTRIBUTE1',
323: p_value => m4u_ucc_utils.g_host_gln,
324: p_parameterlist => l_event_parameters );
325: IF (l_Debug_Level <= 1) THEN
326: cln_debug_pub.Add('ATTRIBUTE1 - '||m4u_ucc_utils.g_host_gln,1);
327: END IF;
328:
329: wf_event.AddParameterToList(
330: p_name => 'ATTRIBUTE5',

Line 334: cln_debug_pub.Add('ATTRIBUTE5 - '||m4u_ucc_utils.g_supp_gln,1);

330: p_name => 'ATTRIBUTE5',
331: p_value => m4u_ucc_utils.g_supp_gln,
332: p_parameterlist => l_event_parameters );
333: IF (l_Debug_Level <= 1) THEN
334: cln_debug_pub.Add('ATTRIBUTE5 - '||m4u_ucc_utils.g_supp_gln,1);
335: END IF;
336:
337:
338: wf_event.AddParameterToList(

Line 343: cln_debug_pub.Add('ATTRIBUTE12 - '||l_event_key,1);

339: p_name => 'ATTRIBUTE12',
340: p_value => l_event_key,
341: p_parameterlist => l_event_parameters );
342: IF (l_Debug_Level <= 1) THEN
343: cln_debug_pub.Add('ATTRIBUTE12 - '||l_event_key,1);
344: END IF;
345:
346:
347: wf_event.AddParameterToList(

Line 352: cln_debug_pub.Add('ATTRIBUTE14 - '||l_org_status,1);

348: p_name => 'ATTRIBUTE14',
349: p_value => l_org_status,
350: p_parameterlist => l_event_parameters );
351: IF (l_Debug_Level <= 1) THEN
352: cln_debug_pub.Add('ATTRIBUTE14 - '||l_org_status,1);
353: END IF;
354:
355:
356: -- set event parameters, end

Line 359: cln_debug_pub.Add('-- Raising Event oracle.apps.m4u.outboundwf.generate -- ',1);

355:
356: -- set event parameters, end
357:
358: IF (l_Debug_Level <= 1) THEN
359: cln_debug_pub.Add('-- Raising Event oracle.apps.m4u.outboundwf.generate -- ',1);
360: cln_debug_pub.Add('p_event_key - '||l_event_key ,1);
361: END IF;
362:
363:

Line 360: cln_debug_pub.Add('p_event_key - '||l_event_key ,1);

356: -- set event parameters, end
357:
358: IF (l_Debug_Level <= 1) THEN
359: cln_debug_pub.Add('-- Raising Event oracle.apps.m4u.outboundwf.generate -- ',1);
360: cln_debug_pub.Add('p_event_key - '||l_event_key ,1);
361: END IF;
362:
363:
364: -- raise event to trigger outbound wlq generation WF

Line 376: cln_debug_pub.Add('Event oracle.apps.m4u.outboundwf.generate raised',1);

372: x_errbuf := 'Successful';
373:
374:
375: IF (l_Debug_Level <= 1) THEN
376: cln_debug_pub.Add('Event oracle.apps.m4u.outboundwf.generate raised',1);
377: END IF;
378:
379: IF (l_Debug_Level <= 2) THEN
380: cln_debug_pub.Add('------- Exiting raise_partyqry_event API/normal --------- ',2);

Line 380: cln_debug_pub.Add('------- Exiting raise_partyqry_event API/normal --------- ',2);

376: cln_debug_pub.Add('Event oracle.apps.m4u.outboundwf.generate raised',1);
377: END IF;
378:
379: IF (l_Debug_Level <= 2) THEN
380: cln_debug_pub.Add('------- Exiting raise_partyqry_event API/normal --------- ',2);
381: END IF;
382:
383:
384: -- Exception Handling

Line 391: cln_debug_pub.Add('Details: '||l_msg_data,4);

387: x_retcode := 2 ;
388: x_errbuf := l_msg_data;
389:
390: IF (l_Debug_Level <= 5) THEN
391: cln_debug_pub.Add('Details: '||l_msg_data,4);
392: cln_debug_pub.Add('------- Exiting raise_partyqry_event API :Error--------- ',2);
393: END IF;
394:
395: WHEN OTHERS THEN

Line 392: cln_debug_pub.Add('------- Exiting raise_partyqry_event API :Error--------- ',2);

388: x_errbuf := l_msg_data;
389:
390: IF (l_Debug_Level <= 5) THEN
391: cln_debug_pub.Add('Details: '||l_msg_data,4);
392: cln_debug_pub.Add('------- Exiting raise_partyqry_event API :Error--------- ',2);
393: END IF;
394:
395: WHEN OTHERS THEN
396: x_retcode := 2 ;

Line 408: cln_debug_pub.Add(x_errbuf, 5);

404:
405:
406:
407: IF (l_Debug_Level <= 5) THEN
408: cln_debug_pub.Add(x_errbuf, 5);
409: cln_debug_pub.Add('Details - '||FND_MESSAGE.GET , 5);
410: cln_debug_pub.Add('------- Exiting raise_partyqry_event API :Other Error --------- ',2);
411: END IF;
412:

Line 409: cln_debug_pub.Add('Details - '||FND_MESSAGE.GET , 5);

405:
406:
407: IF (l_Debug_Level <= 5) THEN
408: cln_debug_pub.Add(x_errbuf, 5);
409: cln_debug_pub.Add('Details - '||FND_MESSAGE.GET , 5);
410: cln_debug_pub.Add('------- Exiting raise_partyqry_event API :Other Error --------- ',2);
411: END IF;
412:
413: END raise_partyqry_event;

Line 410: cln_debug_pub.Add('------- Exiting raise_partyqry_event API :Other Error --------- ',2);

406:
407: IF (l_Debug_Level <= 5) THEN
408: cln_debug_pub.Add(x_errbuf, 5);
409: cln_debug_pub.Add('Details - '||FND_MESSAGE.GET , 5);
410: cln_debug_pub.Add('------- Exiting raise_partyqry_event API :Other Error --------- ',2);
411: END IF;
412:
413: END raise_partyqry_event;
414:

Line 485: cln_debug_pub.Add('Entering m4u_party_query.process_resp_org_data' ,1);

481: l_event_name := 'oracle.apps.cln.ch.collaboration.addmessage';
482: l_event_parameters := wf_parameter_list_t();
483:
484: IF (l_Debug_Level <= 2) THEN
485: cln_debug_pub.Add('Entering m4u_party_query.process_resp_org_data' ,1);
486: END IF;
487:
488: -- Parameters received
489: IF (l_Debug_Level <= 1) THEN

Line 490: cln_debug_pub.Add('---- m4u_party_query.process_resp_org_data -- ' ,1);

486: END IF;
487:
488: -- Parameters received
489: IF (l_Debug_Level <= 1) THEN
490: cln_debug_pub.Add('---- m4u_party_query.process_resp_org_data -- ' ,1);
491: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
492: cln_debug_pub.Add('p_org_name - '||p_org_name ,1);
493: cln_debug_pub.Add('p_short_name - '||p_short_name ,1);
494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);

Line 491: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);

487:
488: -- Parameters received
489: IF (l_Debug_Level <= 1) THEN
490: cln_debug_pub.Add('---- m4u_party_query.process_resp_org_data -- ' ,1);
491: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
492: cln_debug_pub.Add('p_org_name - '||p_org_name ,1);
493: cln_debug_pub.Add('p_short_name - '||p_short_name ,1);
494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);
495: cln_debug_pub.Add('p_contact - '||p_contact ,1);

Line 492: cln_debug_pub.Add('p_org_name - '||p_org_name ,1);

488: -- Parameters received
489: IF (l_Debug_Level <= 1) THEN
490: cln_debug_pub.Add('---- m4u_party_query.process_resp_org_data -- ' ,1);
491: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
492: cln_debug_pub.Add('p_org_name - '||p_org_name ,1);
493: cln_debug_pub.Add('p_short_name - '||p_short_name ,1);
494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);
495: cln_debug_pub.Add('p_contact - '||p_contact ,1);
496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);

Line 493: cln_debug_pub.Add('p_short_name - '||p_short_name ,1);

489: IF (l_Debug_Level <= 1) THEN
490: cln_debug_pub.Add('---- m4u_party_query.process_resp_org_data -- ' ,1);
491: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
492: cln_debug_pub.Add('p_org_name - '||p_org_name ,1);
493: cln_debug_pub.Add('p_short_name - '||p_short_name ,1);
494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);
495: cln_debug_pub.Add('p_contact - '||p_contact ,1);
496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);
497: cln_debug_pub.Add('p_role - '||p_role ,1);

Line 494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);

490: cln_debug_pub.Add('---- m4u_party_query.process_resp_org_data -- ' ,1);
491: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
492: cln_debug_pub.Add('p_org_name - '||p_org_name ,1);
493: cln_debug_pub.Add('p_short_name - '||p_short_name ,1);
494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);
495: cln_debug_pub.Add('p_contact - '||p_contact ,1);
496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);
497: cln_debug_pub.Add('p_role - '||p_role ,1);
498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);

Line 495: cln_debug_pub.Add('p_contact - '||p_contact ,1);

491: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
492: cln_debug_pub.Add('p_org_name - '||p_org_name ,1);
493: cln_debug_pub.Add('p_short_name - '||p_short_name ,1);
494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);
495: cln_debug_pub.Add('p_contact - '||p_contact ,1);
496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);
497: cln_debug_pub.Add('p_role - '||p_role ,1);
498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);
499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);

Line 496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);

492: cln_debug_pub.Add('p_org_name - '||p_org_name ,1);
493: cln_debug_pub.Add('p_short_name - '||p_short_name ,1);
494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);
495: cln_debug_pub.Add('p_contact - '||p_contact ,1);
496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);
497: cln_debug_pub.Add('p_role - '||p_role ,1);
498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);
499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);
500: cln_debug_pub.Add('p_city - '||p_city ,1);

Line 497: cln_debug_pub.Add('p_role - '||p_role ,1);

493: cln_debug_pub.Add('p_short_name - '||p_short_name ,1);
494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);
495: cln_debug_pub.Add('p_contact - '||p_contact ,1);
496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);
497: cln_debug_pub.Add('p_role - '||p_role ,1);
498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);
499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);
500: cln_debug_pub.Add('p_city - '||p_city ,1);
501: cln_debug_pub.Add('p_state - '||p_state ,1);

Line 498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);

494: cln_debug_pub.Add('p_org_type - '||p_org_type ,1);
495: cln_debug_pub.Add('p_contact - '||p_contact ,1);
496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);
497: cln_debug_pub.Add('p_role - '||p_role ,1);
498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);
499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);
500: cln_debug_pub.Add('p_city - '||p_city ,1);
501: cln_debug_pub.Add('p_state - '||p_state ,1);
502: cln_debug_pub.Add('p_zip - '||p_zip ,1);

Line 499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);

495: cln_debug_pub.Add('p_contact - '||p_contact ,1);
496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);
497: cln_debug_pub.Add('p_role - '||p_role ,1);
498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);
499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);
500: cln_debug_pub.Add('p_city - '||p_city ,1);
501: cln_debug_pub.Add('p_state - '||p_state ,1);
502: cln_debug_pub.Add('p_zip - '||p_zip ,1);
503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);

Line 500: cln_debug_pub.Add('p_city - '||p_city ,1);

496: cln_debug_pub.Add('p_org_status - '||p_org_status ,1);
497: cln_debug_pub.Add('p_role - '||p_role ,1);
498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);
499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);
500: cln_debug_pub.Add('p_city - '||p_city ,1);
501: cln_debug_pub.Add('p_state - '||p_state ,1);
502: cln_debug_pub.Add('p_zip - '||p_zip ,1);
503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);
504: cln_debug_pub.Add('p_phone - '||p_phone ,1);

Line 501: cln_debug_pub.Add('p_state - '||p_state ,1);

497: cln_debug_pub.Add('p_role - '||p_role ,1);
498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);
499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);
500: cln_debug_pub.Add('p_city - '||p_city ,1);
501: cln_debug_pub.Add('p_state - '||p_state ,1);
502: cln_debug_pub.Add('p_zip - '||p_zip ,1);
503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);
504: cln_debug_pub.Add('p_phone - '||p_phone ,1);
505: cln_debug_pub.Add('p_fax - '||p_fax ,1);

Line 502: cln_debug_pub.Add('p_zip - '||p_zip ,1);

498: cln_debug_pub.Add('p_addr1 - '||p_addr1 ,1);
499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);
500: cln_debug_pub.Add('p_city - '||p_city ,1);
501: cln_debug_pub.Add('p_state - '||p_state ,1);
502: cln_debug_pub.Add('p_zip - '||p_zip ,1);
503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);
504: cln_debug_pub.Add('p_phone - '||p_phone ,1);
505: cln_debug_pub.Add('p_fax - '||p_fax ,1);
506: cln_debug_pub.Add('p_email - '||p_email ,1);

Line 503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);

499: cln_debug_pub.Add('p_addr2 - '||p_addr2 ,1);
500: cln_debug_pub.Add('p_city - '||p_city ,1);
501: cln_debug_pub.Add('p_state - '||p_state ,1);
502: cln_debug_pub.Add('p_zip - '||p_zip ,1);
503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);
504: cln_debug_pub.Add('p_phone - '||p_phone ,1);
505: cln_debug_pub.Add('p_fax - '||p_fax ,1);
506: cln_debug_pub.Add('p_email - '||p_email ,1);
507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);

Line 504: cln_debug_pub.Add('p_phone - '||p_phone ,1);

500: cln_debug_pub.Add('p_city - '||p_city ,1);
501: cln_debug_pub.Add('p_state - '||p_state ,1);
502: cln_debug_pub.Add('p_zip - '||p_zip ,1);
503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);
504: cln_debug_pub.Add('p_phone - '||p_phone ,1);
505: cln_debug_pub.Add('p_fax - '||p_fax ,1);
506: cln_debug_pub.Add('p_email - '||p_email ,1);
507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);
508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);

Line 505: cln_debug_pub.Add('p_fax - '||p_fax ,1);

501: cln_debug_pub.Add('p_state - '||p_state ,1);
502: cln_debug_pub.Add('p_zip - '||p_zip ,1);
503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);
504: cln_debug_pub.Add('p_phone - '||p_phone ,1);
505: cln_debug_pub.Add('p_fax - '||p_fax ,1);
506: cln_debug_pub.Add('p_email - '||p_email ,1);
507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);
508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
509: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);

Line 506: cln_debug_pub.Add('p_email - '||p_email ,1);

502: cln_debug_pub.Add('p_zip - '||p_zip ,1);
503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);
504: cln_debug_pub.Add('p_phone - '||p_phone ,1);
505: cln_debug_pub.Add('p_fax - '||p_fax ,1);
506: cln_debug_pub.Add('p_email - '||p_email ,1);
507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);
508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
509: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
510: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);

Line 507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);

503: cln_debug_pub.Add('p_country_code - '||p_country_code ,1);
504: cln_debug_pub.Add('p_phone - '||p_phone ,1);
505: cln_debug_pub.Add('p_fax - '||p_fax ,1);
506: cln_debug_pub.Add('p_email - '||p_email ,1);
507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);
508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
509: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
510: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
511: cln_debug_pub.Add('p_collab_dtl_id - '||p_collab_dtl_id);

Line 508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);

504: cln_debug_pub.Add('p_phone - '||p_phone ,1);
505: cln_debug_pub.Add('p_fax - '||p_fax ,1);
506: cln_debug_pub.Add('p_email - '||p_email ,1);
507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);
508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
509: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
510: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
511: cln_debug_pub.Add('p_collab_dtl_id - '||p_collab_dtl_id);
512: cln_debug_pub.Add('-------------------------------------------' ,1);

Line 509: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);

505: cln_debug_pub.Add('p_fax - '||p_fax ,1);
506: cln_debug_pub.Add('p_email - '||p_email ,1);
507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);
508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
509: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
510: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
511: cln_debug_pub.Add('p_collab_dtl_id - '||p_collab_dtl_id);
512: cln_debug_pub.Add('-------------------------------------------' ,1);
513: END IF;

Line 510: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);

506: cln_debug_pub.Add('p_email - '||p_email ,1);
507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);
508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
509: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
510: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
511: cln_debug_pub.Add('p_collab_dtl_id - '||p_collab_dtl_id);
512: cln_debug_pub.Add('-------------------------------------------' ,1);
513: END IF;
514:

Line 511: cln_debug_pub.Add('p_collab_dtl_id - '||p_collab_dtl_id);

507: cln_debug_pub.Add('p_party_links - '||p_party_links ,1);
508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
509: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
510: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
511: cln_debug_pub.Add('p_collab_dtl_id - '||p_collab_dtl_id);
512: cln_debug_pub.Add('-------------------------------------------' ,1);
513: END IF;
514:
515: -- Check for the collaboration ID based on the collaboration detail ID and get the

Line 512: cln_debug_pub.Add('-------------------------------------------' ,1);

508: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
509: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
510: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
511: cln_debug_pub.Add('p_collab_dtl_id - '||p_collab_dtl_id);
512: cln_debug_pub.Add('-------------------------------------------' ,1);
513: END IF;
514:
515: -- Check for the collaboration ID based on the collaboration detail ID and get the
516: -- attribute 14 value. If the value is set and is AC, that means only active organizations

Line 520: cln_debug_pub.Add('Checking for the value of attribute14 for org status' ,1);

516: -- attribute 14 value. If the value is set and is AC, that means only active organizations
517: -- are desired in the display.
518:
519: IF (l_Debug_Level <= 1) THEN
520: cln_debug_pub.Add('Checking for the value of attribute14 for org status' ,1);
521: END IF;
522:
523: SELECT attribute14
524: INTO l_org_status_db

Line 531: cln_debug_pub.Add('Organization Status required '||l_org_status_db ,1);

527: FROM CLN_COLL_HIST_DTL
528: WHERE collaboration_dtl_id = p_collab_dtl_id);
529:
530: IF (l_Debug_Level <= 1) THEN
531: cln_debug_pub.Add('Organization Status required '||l_org_status_db ,1);
532: END IF;
533:
534: -- if the database value for status is AC and the incoming
535: -- payload carries organization details with status as IN, return

Line 579: cln_debug_pub.Add('Raised - ' || l_event_name || ', key - ' || l_event_key,2);

575: p_parameters => l_event_parameters
576: );
577:
578: IF (l_Debug_Level <= 2) THEN
579: cln_debug_pub.Add('Raised - ' || l_event_name || ', key - ' || l_event_key,2);
580: END IF;
581:
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583: x_msg_data := 'SUCCESS';

Line 586: cln_debug_pub.Add('Exiting m4u_party_query.process_resp_org_data - Normal' ,1);

582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583: x_msg_data := 'SUCCESS';
584:
585: IF (l_Debug_Level <= 2) THEN
586: cln_debug_pub.Add('Exiting m4u_party_query.process_resp_org_data - Normal' ,1);
587: END IF;
588:
589: EXCEPTION
590: WHEN OTHERS THEN

Line 602: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);

598:
599: x_msg_data := ' ' || FND_MESSAGE.GET || ' , ';
600:
601: IF (l_debug_level <= 5) THEN
602: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
603: END IF;
604:
605: IF (l_debug_level <= 2) THEN
606: cln_debug_pub.add('Exiting m4u_party_query.process_resp_org_data - exception',2);

Line 606: cln_debug_pub.add('Exiting m4u_party_query.process_resp_org_data - exception',2);

602: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
603: END IF;
604:
605: IF (l_debug_level <= 2) THEN
606: cln_debug_pub.add('Exiting m4u_party_query.process_resp_org_data - exception',2);
607: cln_debug_pub.add('=========================================================',2);
608: END IF;
609:
610: END process_resp_org_data;

Line 607: cln_debug_pub.add('=========================================================',2);

603: END IF;
604:
605: IF (l_debug_level <= 2) THEN
606: cln_debug_pub.add('Exiting m4u_party_query.process_resp_org_data - exception',2);
607: cln_debug_pub.add('=========================================================',2);
608: END IF;
609:
610: END process_resp_org_data;
611:

Line 646: cln_debug_pub.Add('Entering m4u_party_query.process_party_links' ,1);

642: l_error_msg VARCHAR2(1000);
643: BEGIN
644:
645: IF (l_Debug_Level <= 2) THEN
646: cln_debug_pub.Add('Entering m4u_party_query.process_party_links' ,1);
647: END IF;
648:
649:
650:

Line 653: cln_debug_pub.Add('---- m4u_party_query.proces_party_links-- ' ,1);

649:
650:
651: -- Parameters received
652: IF (l_Debug_Level <= 1) THEN
653: cln_debug_pub.Add('---- m4u_party_query.proces_party_links-- ' ,1);
654: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
655: cln_debug_pub.Add('p_linked_gln - '||p_linked_gln ,1);
656: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
657: cln_debug_pub.Add('p_collab_id - '||p_collab_id ,1);

Line 654: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);

650:
651: -- Parameters received
652: IF (l_Debug_Level <= 1) THEN
653: cln_debug_pub.Add('---- m4u_party_query.proces_party_links-- ' ,1);
654: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
655: cln_debug_pub.Add('p_linked_gln - '||p_linked_gln ,1);
656: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
657: cln_debug_pub.Add('p_collab_id - '||p_collab_id ,1);
658: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);

Line 655: cln_debug_pub.Add('p_linked_gln - '||p_linked_gln ,1);

651: -- Parameters received
652: IF (l_Debug_Level <= 1) THEN
653: cln_debug_pub.Add('---- m4u_party_query.proces_party_links-- ' ,1);
654: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
655: cln_debug_pub.Add('p_linked_gln - '||p_linked_gln ,1);
656: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
657: cln_debug_pub.Add('p_collab_id - '||p_collab_id ,1);
658: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
659: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);

Line 656: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);

652: IF (l_Debug_Level <= 1) THEN
653: cln_debug_pub.Add('---- m4u_party_query.proces_party_links-- ' ,1);
654: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
655: cln_debug_pub.Add('p_linked_gln - '||p_linked_gln ,1);
656: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
657: cln_debug_pub.Add('p_collab_id - '||p_collab_id ,1);
658: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
659: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
660: cln_debug_pub.Add('-------------------------------------------' ,1);

Line 657: cln_debug_pub.Add('p_collab_id - '||p_collab_id ,1);

653: cln_debug_pub.Add('---- m4u_party_query.proces_party_links-- ' ,1);
654: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
655: cln_debug_pub.Add('p_linked_gln - '||p_linked_gln ,1);
656: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
657: cln_debug_pub.Add('p_collab_id - '||p_collab_id ,1);
658: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
659: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
660: cln_debug_pub.Add('-------------------------------------------' ,1);
661: END IF;

Line 658: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);

654: cln_debug_pub.Add('p_org_gln - '||p_org_gln ,1);
655: cln_debug_pub.Add('p_linked_gln - '||p_linked_gln ,1);
656: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
657: cln_debug_pub.Add('p_collab_id - '||p_collab_id ,1);
658: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
659: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
660: cln_debug_pub.Add('-------------------------------------------' ,1);
661: END IF;
662:

Line 659: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);

655: cln_debug_pub.Add('p_linked_gln - '||p_linked_gln ,1);
656: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
657: cln_debug_pub.Add('p_collab_id - '||p_collab_id ,1);
658: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
659: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
660: cln_debug_pub.Add('-------------------------------------------' ,1);
661: END IF;
662:
663: /* NO PROCESSING/UPDATE DEFINED */

Line 660: cln_debug_pub.Add('-------------------------------------------' ,1);

656: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
657: cln_debug_pub.Add('p_collab_id - '||p_collab_id ,1);
658: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
659: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
660: cln_debug_pub.Add('-------------------------------------------' ,1);
661: END IF;
662:
663: /* NO PROCESSING/UPDATE DEFINED */
664: /* IN-FUTURE THIS CAN BE EXTENDED */

Line 670: cln_debug_pub.Add('Exiting m4u_party_query.process_party_links - Normal' ,1);

666: x_return_status := FND_API.G_RET_STS_SUCCESS;
667: x_msg_data := 'SUCCESS';
668:
669: IF (l_Debug_Level <= 2) THEN
670: cln_debug_pub.Add('Exiting m4u_party_query.process_party_links - Normal' ,1);
671: END IF;
672:
673: EXCEPTION
674: WHEN OTHERS THEN

Line 687: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);

683: x_msg_data := ' ' || FND_MESSAGE.GET || ' , ';
684:
685:
686: IF (l_debug_level <= 5) THEN
687: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
688: END IF;
689:
690: IF (l_debug_level <= 2) THEN
691: cln_debug_pub.add('Exiting m4u_party_query.process_party_links - exception',2);

Line 691: cln_debug_pub.add('Exiting m4u_party_query.process_party_links - exception',2);

687: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
688: END IF;
689:
690: IF (l_debug_level <= 2) THEN
691: cln_debug_pub.add('Exiting m4u_party_query.process_party_links - exception',2);
692: cln_debug_pub.add('=======================================================',2);
693: END IF;
694:
695: END process_party_links;

Line 692: cln_debug_pub.add('=======================================================',2);

688: END IF;
689:
690: IF (l_debug_level <= 2) THEN
691: cln_debug_pub.add('Exiting m4u_party_query.process_party_links - exception',2);
692: cln_debug_pub.add('=======================================================',2);
693: END IF;
694:
695: END process_party_links;
696:

Line 735: cln_debug_pub.Add('---- m4u_party_query.proces_resp_doc ---- ' ,1);

731: BEGIN
732:
733: -- Parameters received
734: IF (l_Debug_Level <= 1) THEN
735: cln_debug_pub.Add('---- m4u_party_query.proces_resp_doc ---- ' ,1);
736: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
737: cln_debug_pub.Add('p_query_success_flag - '||p_query_success_flag ,1);
738: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
739: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);

Line 736: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);

732:
733: -- Parameters received
734: IF (l_Debug_Level <= 1) THEN
735: cln_debug_pub.Add('---- m4u_party_query.proces_resp_doc ---- ' ,1);
736: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
737: cln_debug_pub.Add('p_query_success_flag - '||p_query_success_flag ,1);
738: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
739: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
740: cln_debug_pub.Add('p_doc_status - '||p_doc_status ,1);

Line 737: cln_debug_pub.Add('p_query_success_flag - '||p_query_success_flag ,1);

733: -- Parameters received
734: IF (l_Debug_Level <= 1) THEN
735: cln_debug_pub.Add('---- m4u_party_query.proces_resp_doc ---- ' ,1);
736: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
737: cln_debug_pub.Add('p_query_success_flag - '||p_query_success_flag ,1);
738: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
739: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
740: cln_debug_pub.Add('p_doc_status - '||p_doc_status ,1);
741: cln_debug_pub.Add('-------------------------------------------' ,1);

Line 738: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);

734: IF (l_Debug_Level <= 1) THEN
735: cln_debug_pub.Add('---- m4u_party_query.proces_resp_doc ---- ' ,1);
736: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
737: cln_debug_pub.Add('p_query_success_flag - '||p_query_success_flag ,1);
738: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
739: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
740: cln_debug_pub.Add('p_doc_status - '||p_doc_status ,1);
741: cln_debug_pub.Add('-------------------------------------------' ,1);
742: END IF;

Line 739: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);

735: cln_debug_pub.Add('---- m4u_party_query.proces_resp_doc ---- ' ,1);
736: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
737: cln_debug_pub.Add('p_query_success_flag - '||p_query_success_flag ,1);
738: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
739: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
740: cln_debug_pub.Add('p_doc_status - '||p_doc_status ,1);
741: cln_debug_pub.Add('-------------------------------------------' ,1);
742: END IF;
743:

Line 740: cln_debug_pub.Add('p_doc_status - '||p_doc_status ,1);

736: cln_debug_pub.Add('p_party_query_id - '||p_party_query_id ,1);
737: cln_debug_pub.Add('p_query_success_flag - '||p_query_success_flag ,1);
738: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
739: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
740: cln_debug_pub.Add('p_doc_status - '||p_doc_status ,1);
741: cln_debug_pub.Add('-------------------------------------------' ,1);
742: END IF;
743:
744:

Line 741: cln_debug_pub.Add('-------------------------------------------' ,1);

737: cln_debug_pub.Add('p_query_success_flag - '||p_query_success_flag ,1);
738: cln_debug_pub.Add('p_ucc_doc_unique_id - '||p_ucc_doc_unique_id ,1);
739: cln_debug_pub.Add('p_xmlg_internal_control_no - '||p_xmlg_internal_control_no ,1);
740: cln_debug_pub.Add('p_doc_status - '||p_doc_status ,1);
741: cln_debug_pub.Add('-------------------------------------------' ,1);
742: END IF;
743:
744:
745: -- set CLN Disposition, CLN Coll Status, CLN Doc status, CLN Message Text

Line 765: cln_debug_pub.Add('-- Update collaboration parameters set -',1);

761:
762:
763:
764: IF (l_Debug_Level <= 1) THEN
765: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
766: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
767: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
768: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
769: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);

Line 766: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);

762:
763:
764: IF (l_Debug_Level <= 1) THEN
765: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
766: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
767: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
768: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
769: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
770: cln_debug_pub.Add('---------------------------------------' ,1);

Line 767: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);

763:
764: IF (l_Debug_Level <= 1) THEN
765: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
766: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
767: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
768: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
769: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
770: cln_debug_pub.Add('---------------------------------------' ,1);
771: END IF;

Line 768: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);

764: IF (l_Debug_Level <= 1) THEN
765: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
766: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
767: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
768: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
769: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
770: cln_debug_pub.Add('---------------------------------------' ,1);
771: END IF;
772:

Line 769: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);

765: cln_debug_pub.Add('-- Update collaboration parameters set -',1);
766: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
767: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
768: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
769: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
770: cln_debug_pub.Add('---------------------------------------' ,1);
771: END IF;
772:
773:

Line 770: cln_debug_pub.Add('---------------------------------------' ,1);

766: cln_debug_pub.Add('Disposition - '|| l_disposition ,1);
767: cln_debug_pub.Add('Collaboration Status - '|| l_coll_status ,1);
768: cln_debug_pub.Add('Document Status - '|| l_doc_status ,1);
769: cln_debug_pub.Add('FND Message - '|| l_fnd_msg ,1);
770: cln_debug_pub.Add('---------------------------------------' ,1);
771: END IF;
772:
773:
774:

Line 803: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);

799: x_dtl_coll_id => x_collab_detail_id );
800:
801:
802: IF (l_Debug_Level <= 1) THEN
803: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);
804: cln_debug_pub.Add('Collab Detail Id - '|| x_collab_detail_id ,1);
805: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);
806: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);
807: END IF;

Line 804: cln_debug_pub.Add('Collab Detail Id - '|| x_collab_detail_id ,1);

800:
801:
802: IF (l_Debug_Level <= 1) THEN
803: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);
804: cln_debug_pub.Add('Collab Detail Id - '|| x_collab_detail_id ,1);
805: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);
806: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);
807: END IF;
808:

Line 805: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);

801:
802: IF (l_Debug_Level <= 1) THEN
803: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);
804: cln_debug_pub.Add('Collab Detail Id - '|| x_collab_detail_id ,1);
805: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);
806: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);
807: END IF;
808:
809:

Line 806: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);

802: IF (l_Debug_Level <= 1) THEN
803: cln_debug_pub.Add('-- Update Collab API returns Values -' ,1);
804: cln_debug_pub.Add('Collab Detail Id - '|| x_collab_detail_id ,1);
805: cln_debug_pub.Add('CLN API Return Status - '|| x_return_status ,1);
806: cln_debug_pub.Add('CLN return msg data - '|| x_msg_data ,1);
807: END IF;
808:
809:
810: IF (l_Debug_Level <= 2) THEN

Line 811: cln_debug_pub.Add('Exiting - m4u_party_query.process_resp_doc Normal',2);

807: END IF;
808:
809:
810: IF (l_Debug_Level <= 2) THEN
811: cln_debug_pub.Add('Exiting - m4u_party_query.process_resp_doc Normal',2);
812: END IF;
813:
814:
815: EXCEPTION

Line 829: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);

825: x_msg_data := ' ' || FND_MESSAGE.GET || ' , ';
826:
827:
828: IF (l_debug_level <= 5) THEN
829: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
830: END IF;
831:
832: IF (l_debug_level <= 2) THEN
833: cln_debug_pub.add('Exiting m4u_party_query.process_resp_doc - exception',2);

Line 833: cln_debug_pub.add('Exiting m4u_party_query.process_resp_doc - exception',2);

829: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
830: END IF;
831:
832: IF (l_debug_level <= 2) THEN
833: cln_debug_pub.add('Exiting m4u_party_query.process_resp_doc - exception',2);
834: cln_debug_pub.add('====================================================',2);
835: END IF;
836:
837: END process_resp_doc;

Line 834: cln_debug_pub.add('====================================================',2);

830: END IF;
831:
832: IF (l_debug_level <= 2) THEN
833: cln_debug_pub.add('Exiting m4u_party_query.process_resp_doc - exception',2);
834: cln_debug_pub.add('====================================================',2);
835: END IF;
836:
837: END process_resp_doc;
838: