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

Line 50: cln_debug_pub.Add('----- Entering GET_CUST_ACCT_ID API ------- ',2);

46:
47: BEGIN
48:
49: IF (l_Debug_Level <= 2) THEN
50: cln_debug_pub.Add('----- Entering GET_CUST_ACCT_ID API ------- ',2);
51: END IF;
52:
53: SELECT hca.cust_account_id cust_account_id
54: INTO l_cust_acct_id

Line 59: cln_debug_pub.Add('Customer Account ID '||l_cust_acct_id,2);

55: FROM hz_cust_accounts hca
56: WHERE hca.party_id = CLN_SYNCITEM_PKG.GET_PARTY_ID();
57:
58: IF (l_Debug_Level <= 2) THEN
59: cln_debug_pub.Add('Customer Account ID '||l_cust_acct_id,2);
60: cln_debug_pub.Add('----- Entering GET_CUST_ACCT_ID API ------- ',2);
61: END IF;
62:
63: RETURN l_cust_acct_id;

Line 60: cln_debug_pub.Add('----- Entering GET_CUST_ACCT_ID API ------- ',2);

56: WHERE hca.party_id = CLN_SYNCITEM_PKG.GET_PARTY_ID();
57:
58: IF (l_Debug_Level <= 2) THEN
59: cln_debug_pub.Add('Customer Account ID '||l_cust_acct_id,2);
60: cln_debug_pub.Add('----- Entering GET_CUST_ACCT_ID API ------- ',2);
61: END IF;
62:
63: RETURN l_cust_acct_id;
64:

Line 68: cln_debug_pub.Add('Unable to find the customer details',1);

64:
65: EXCEPTION
66: WHEN NO_DATA_FOUND THEN
67: IF (l_Debug_Level <= 1) THEN
68: cln_debug_pub.Add('Unable to find the customer details',1);
69: END IF;
70: END;
71:
72:

Line 94: cln_debug_pub.Add('----- Entering SET_PARTY_ID API ------- ',2);

90:
91: BEGIN
92:
93: IF (l_Debug_Level <= 2) THEN
94: cln_debug_pub.Add('----- Entering SET_PARTY_ID API ------- ',2);
95: END IF;
96:
97: g_party_id := p_tp_party_id;
98:

Line 100: cln_debug_pub.Add('----- Party Id set as '||g_party_id,1);

96:
97: g_party_id := p_tp_party_id;
98:
99: IF (l_Debug_Level <= 2) THEN
100: cln_debug_pub.Add('----- Party Id set as '||g_party_id,1);
101: cln_debug_pub.Add('----- Exting SET_PARTY_ID API ------- ',2);
102: END IF;
103:
104: END;

Line 101: cln_debug_pub.Add('----- Exting SET_PARTY_ID API ------- ',2);

97: g_party_id := p_tp_party_id;
98:
99: IF (l_Debug_Level <= 2) THEN
100: cln_debug_pub.Add('----- Party Id set as '||g_party_id,1);
101: cln_debug_pub.Add('----- Exting SET_PARTY_ID API ------- ',2);
102: END IF;
103:
104: END;
105:

Line 219: cln_debug_pub.Add('----- Entering Raise_Syncitem_Event API ------- ',2);

215:
216: BEGIN
217:
218: IF (l_Debug_Level <= 2) THEN
219: cln_debug_pub.Add('----- Entering Raise_Syncitem_Event API ------- ',2);
220: END IF;
221:
222:
223: -- Initialize API return status to success

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

225:
226:
227: -- Parameters received from the concurrrent program
228: IF (l_Debug_Level <= 1) THEN
229: cln_debug_pub.Add('== PARAMETERS RECEIVED FROM CONCURRENT PROGRAM== ',1);
230: cln_debug_pub.Add('Trading Partner Header ID - '||p_tp_header_id,1);
231: cln_debug_pub.Add('Inventory Org ID - '||p_inventory_org_id,1);
232: cln_debug_pub.Add('Category Set ID - '||p_category_set_id,1);
233: cln_debug_pub.Add('Category ID - '||p_category_id,1);

Line 230: cln_debug_pub.Add('Trading Partner Header ID - '||p_tp_header_id,1);

226:
227: -- Parameters received from the concurrrent program
228: IF (l_Debug_Level <= 1) THEN
229: cln_debug_pub.Add('== PARAMETERS RECEIVED FROM CONCURRENT PROGRAM== ',1);
230: cln_debug_pub.Add('Trading Partner Header ID - '||p_tp_header_id,1);
231: cln_debug_pub.Add('Inventory Org ID - '||p_inventory_org_id,1);
232: cln_debug_pub.Add('Category Set ID - '||p_category_set_id,1);
233: cln_debug_pub.Add('Category ID - '||p_category_id,1);
234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);

Line 231: cln_debug_pub.Add('Inventory Org ID - '||p_inventory_org_id,1);

227: -- Parameters received from the concurrrent program
228: IF (l_Debug_Level <= 1) THEN
229: cln_debug_pub.Add('== PARAMETERS RECEIVED FROM CONCURRENT PROGRAM== ',1);
230: cln_debug_pub.Add('Trading Partner Header ID - '||p_tp_header_id,1);
231: cln_debug_pub.Add('Inventory Org ID - '||p_inventory_org_id,1);
232: cln_debug_pub.Add('Category Set ID - '||p_category_set_id,1);
233: cln_debug_pub.Add('Category ID - '||p_category_id,1);
234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);
235: cln_debug_pub.Add('Item Status - '||p_item_status,1);

Line 232: cln_debug_pub.Add('Category Set ID - '||p_category_set_id,1);

228: IF (l_Debug_Level <= 1) THEN
229: cln_debug_pub.Add('== PARAMETERS RECEIVED FROM CONCURRENT PROGRAM== ',1);
230: cln_debug_pub.Add('Trading Partner Header ID - '||p_tp_header_id,1);
231: cln_debug_pub.Add('Inventory Org ID - '||p_inventory_org_id,1);
232: cln_debug_pub.Add('Category Set ID - '||p_category_set_id,1);
233: cln_debug_pub.Add('Category ID - '||p_category_id,1);
234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);
235: cln_debug_pub.Add('Item Status - '||p_item_status,1);
236: cln_debug_pub.Add('From Items [Concatenated Segment] - '||p_from_items,1);

Line 233: cln_debug_pub.Add('Category ID - '||p_category_id,1);

229: cln_debug_pub.Add('== PARAMETERS RECEIVED FROM CONCURRENT PROGRAM== ',1);
230: cln_debug_pub.Add('Trading Partner Header ID - '||p_tp_header_id,1);
231: cln_debug_pub.Add('Inventory Org ID - '||p_inventory_org_id,1);
232: cln_debug_pub.Add('Category Set ID - '||p_category_set_id,1);
233: cln_debug_pub.Add('Category ID - '||p_category_id,1);
234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);
235: cln_debug_pub.Add('Item Status - '||p_item_status,1);
236: cln_debug_pub.Add('From Items [Concatenated Segment] - '||p_from_items,1);
237: cln_debug_pub.Add('To Items [Concatenated Segment] - '||p_to_items,1);

Line 234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);

230: cln_debug_pub.Add('Trading Partner Header ID - '||p_tp_header_id,1);
231: cln_debug_pub.Add('Inventory Org ID - '||p_inventory_org_id,1);
232: cln_debug_pub.Add('Category Set ID - '||p_category_set_id,1);
233: cln_debug_pub.Add('Category ID - '||p_category_id,1);
234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);
235: cln_debug_pub.Add('Item Status - '||p_item_status,1);
236: cln_debug_pub.Add('From Items [Concatenated Segment] - '||p_from_items,1);
237: cln_debug_pub.Add('To Items [Concatenated Segment] - '||p_to_items,1);
238: cln_debug_pub.Add('Number Of Items /Message - '||p_numitems_per_payload,1);

Line 235: cln_debug_pub.Add('Item Status - '||p_item_status,1);

231: cln_debug_pub.Add('Inventory Org ID - '||p_inventory_org_id,1);
232: cln_debug_pub.Add('Category Set ID - '||p_category_set_id,1);
233: cln_debug_pub.Add('Category ID - '||p_category_id,1);
234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);
235: cln_debug_pub.Add('Item Status - '||p_item_status,1);
236: cln_debug_pub.Add('From Items [Concatenated Segment] - '||p_from_items,1);
237: cln_debug_pub.Add('To Items [Concatenated Segment] - '||p_to_items,1);
238: cln_debug_pub.Add('Number Of Items /Message - '||p_numitems_per_payload,1);
239: cln_debug_pub.Add('=================================================',1);

Line 236: cln_debug_pub.Add('From Items [Concatenated Segment] - '||p_from_items,1);

232: cln_debug_pub.Add('Category Set ID - '||p_category_set_id,1);
233: cln_debug_pub.Add('Category ID - '||p_category_id,1);
234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);
235: cln_debug_pub.Add('Item Status - '||p_item_status,1);
236: cln_debug_pub.Add('From Items [Concatenated Segment] - '||p_from_items,1);
237: cln_debug_pub.Add('To Items [Concatenated Segment] - '||p_to_items,1);
238: cln_debug_pub.Add('Number Of Items /Message - '||p_numitems_per_payload,1);
239: cln_debug_pub.Add('=================================================',1);
240: END IF;

Line 237: cln_debug_pub.Add('To Items [Concatenated Segment] - '||p_to_items,1);

233: cln_debug_pub.Add('Category ID - '||p_category_id,1);
234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);
235: cln_debug_pub.Add('Item Status - '||p_item_status,1);
236: cln_debug_pub.Add('From Items [Concatenated Segment] - '||p_from_items,1);
237: cln_debug_pub.Add('To Items [Concatenated Segment] - '||p_to_items,1);
238: cln_debug_pub.Add('Number Of Items /Message - '||p_numitems_per_payload,1);
239: cln_debug_pub.Add('=================================================',1);
240: END IF;
241:

Line 238: cln_debug_pub.Add('Number Of Items /Message - '||p_numitems_per_payload,1);

234: cln_debug_pub.Add('Catalog Category ID - '||p_catalog_category_id,1);
235: cln_debug_pub.Add('Item Status - '||p_item_status,1);
236: cln_debug_pub.Add('From Items [Concatenated Segment] - '||p_from_items,1);
237: cln_debug_pub.Add('To Items [Concatenated Segment] - '||p_to_items,1);
238: cln_debug_pub.Add('Number Of Items /Message - '||p_numitems_per_payload,1);
239: cln_debug_pub.Add('=================================================',1);
240: END IF;
241:
242:

Line 239: cln_debug_pub.Add('=================================================',1);

235: cln_debug_pub.Add('Item Status - '||p_item_status,1);
236: cln_debug_pub.Add('From Items [Concatenated Segment] - '||p_from_items,1);
237: cln_debug_pub.Add('To Items [Concatenated Segment] - '||p_to_items,1);
238: cln_debug_pub.Add('Number Of Items /Message - '||p_numitems_per_payload,1);
239: cln_debug_pub.Add('=================================================',1);
240: END IF;
241:
242:
243: -- Getting Trading Partner Details

Line 245: cln_debug_pub.Add('Getting Trading Partner Details Using Tp_Header_Id',1);

241:
242:
243: -- Getting Trading Partner Details
244: IF (l_Debug_Level <= 1) THEN
245: cln_debug_pub.Add('Getting Trading Partner Details Using Tp_Header_Id',1);
246: END IF;
247:
248: BEGIN
249:

Line 265: cln_debug_pub.Add('Unable to find the set up details for the trading partner',1);

261: WHEN NO_DATA_FOUND THEN
262: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_FOUND');
263: l_msg_data := FND_MESSAGE.GET;
264: IF (l_Debug_Level <= 1) THEN
265: cln_debug_pub.Add('Unable to find the set up details for the trading partner',1);
266: END IF;
267:
268: RAISE FND_API.G_EXC_ERROR;
269: WHEN TOO_MANY_ROWS THEN

Line 273: cln_debug_pub.Add('More then one row found for the same trading partner set up',1);

269: WHEN TOO_MANY_ROWS THEN
270: FND_MESSAGE.SET_NAME('CLN','CLN_CH_TP_DETAILS_NOT_UNIQUE');
271: l_msg_data := FND_MESSAGE.GET;
272: IF (l_Debug_Level <= 1) THEN
273: cln_debug_pub.Add('More then one row found for the same trading partner set up',1);
274: END IF;
275:
276: RAISE FND_API.G_EXC_ERROR;
277: END;

Line 280: cln_debug_pub.Add('======== Trading Partner Details Found =========',1);

276: RAISE FND_API.G_EXC_ERROR;
277: END;
278:
279: IF (l_Debug_Level <= 1) THEN
280: cln_debug_pub.Add('======== Trading Partner Details Found =========',1);
281: cln_debug_pub.Add('Trading Partner Type - '||l_tr_partner_type,1);
282: cln_debug_pub.Add('Trading Partner ID - '||l_tr_partner_id,1);
283: cln_debug_pub.Add('Trading Partner Site - '||l_tr_partner_site,1);
284: cln_debug_pub.Add('Trading Partner Name - '||l_party_name,1);

Line 281: cln_debug_pub.Add('Trading Partner Type - '||l_tr_partner_type,1);

277: END;
278:
279: IF (l_Debug_Level <= 1) THEN
280: cln_debug_pub.Add('======== Trading Partner Details Found =========',1);
281: cln_debug_pub.Add('Trading Partner Type - '||l_tr_partner_type,1);
282: cln_debug_pub.Add('Trading Partner ID - '||l_tr_partner_id,1);
283: cln_debug_pub.Add('Trading Partner Site - '||l_tr_partner_site,1);
284: cln_debug_pub.Add('Trading Partner Name - '||l_party_name,1);
285: END IF;

Line 282: cln_debug_pub.Add('Trading Partner ID - '||l_tr_partner_id,1);

278:
279: IF (l_Debug_Level <= 1) THEN
280: cln_debug_pub.Add('======== Trading Partner Details Found =========',1);
281: cln_debug_pub.Add('Trading Partner Type - '||l_tr_partner_type,1);
282: cln_debug_pub.Add('Trading Partner ID - '||l_tr_partner_id,1);
283: cln_debug_pub.Add('Trading Partner Site - '||l_tr_partner_site,1);
284: cln_debug_pub.Add('Trading Partner Name - '||l_party_name,1);
285: END IF;
286:

Line 283: cln_debug_pub.Add('Trading Partner Site - '||l_tr_partner_site,1);

279: IF (l_Debug_Level <= 1) THEN
280: cln_debug_pub.Add('======== Trading Partner Details Found =========',1);
281: cln_debug_pub.Add('Trading Partner Type - '||l_tr_partner_type,1);
282: cln_debug_pub.Add('Trading Partner ID - '||l_tr_partner_id,1);
283: cln_debug_pub.Add('Trading Partner Site - '||l_tr_partner_site,1);
284: cln_debug_pub.Add('Trading Partner Name - '||l_party_name,1);
285: END IF;
286:
287:

Line 284: cln_debug_pub.Add('Trading Partner Name - '||l_party_name,1);

280: cln_debug_pub.Add('======== Trading Partner Details Found =========',1);
281: cln_debug_pub.Add('Trading Partner Type - '||l_tr_partner_type,1);
282: cln_debug_pub.Add('Trading Partner ID - '||l_tr_partner_id,1);
283: cln_debug_pub.Add('Trading Partner Site - '||l_tr_partner_site,1);
284: cln_debug_pub.Add('Trading Partner Name - '||l_party_name,1);
285: END IF;
286:
287:
288: -- Defaulting based on some business logic

Line 296: cln_debug_pub.Add('Checking for the users choice ....',1);

292:
293:
294: BEGIN
295: IF (l_Debug_Level <= 1) THEN
296: cln_debug_pub.Add('Checking for the users choice ....',1);
297: END IF;
298:
299:
300: l_profile_value := fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY');

Line 303: cln_debug_pub.Add('profile value for - CLN_ITEM_SEND_CUST_XREF_ONLY -'||l_profile_value,1);

299:
300: l_profile_value := fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY');
301:
302: IF (l_Debug_Level <= 1) THEN
303: cln_debug_pub.Add('profile value for - CLN_ITEM_SEND_CUST_XREF_ONLY -'||l_profile_value,1);
304: END IF;
305:
306: -- Modified the query below due to performance hit. Bug #4946778
307:

Line 372: cln_debug_pub.Add('No records found for the user input',1);

368: WHEN NO_DATA_FOUND THEN
369: FND_MESSAGE.SET_NAME('CLN','CLN_CH_NO_ROW_SELECTED');
370: l_msg_data := FND_MESSAGE.GET;
371: IF (l_Debug_Level <= 1) THEN
372: cln_debug_pub.Add('No records found for the user input',1);
373: END IF;
374:
375: RAISE FND_API.G_EXC_ERROR;
376: END;

Line 379: cln_debug_pub.Add('User input seems valid.....',1);

375: RAISE FND_API.G_EXC_ERROR;
376: END;
377:
378: IF (l_Debug_Level <= 1) THEN
379: cln_debug_pub.Add('User input seems valid.....',1);
380: END IF;
381:
382: -- Get the document creation date as canonical date
383: SELECT sysdate into l_date from dual;

Line 387: cln_debug_pub.Add('Canonical Date set as - '||l_canonical_date,1);

383: SELECT sysdate into l_date from dual;
384: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
385:
386: IF (l_Debug_Level <= 1) THEN
387: cln_debug_pub.Add('Canonical Date set as - '||l_canonical_date,1);
388: END IF;
389:
390:
391: -- Generic attribute list for generic outbound workflow

Line 479: cln_debug_pub.Add('Workflow event- oracle.apps.cln.common.xml.out', 1);

475:
476:
477: IF(p_numitems_per_payload IS NULL ) THEN
478: IF (l_Debug_Level <= 1) THEN
479: cln_debug_pub.Add('Workflow event- oracle.apps.cln.common.xml.out', 1);
480: END IF;
481:
482:
483: -- create unique key

Line 488: cln_debug_pub.Add('Event Key set as - '||l_event_key,1);

484: SELECT CLN_SYNCITEM_S.nextval into l_syncitem_seq from dual;
485: l_event_key := to_char(p_tp_header_id) || '.' || to_char(l_syncitem_seq);
486:
487: IF (l_Debug_Level <= 1) THEN
488: cln_debug_pub.Add('Event Key set as - '||l_event_key,1);
489: END IF;
490:
491: wf_event.AddParameterToList(p_name => 'ECX_DOCUMENT_ID',
492: p_value => l_event_key,

Line 504: cln_debug_pub.Add('raising event as - oracle.apps.cln.common.xml.out',1);

500: p_value => l_event_key,
501: p_parameterlist => l_genwf_cln_parameter_list);
502:
503: IF (l_Debug_Level <= 1) THEN
504: cln_debug_pub.Add('raising event as - oracle.apps.cln.common.xml.out',1);
505: END IF;
506:
507: -- raise event for send show shipment document
508: wf_event.raise(p_event_name => 'oracle.apps.cln.common.xml.out',

Line 529: cln_debug_pub.Add('Counter set as - '||l_counter,1);

525: LOOP -- begin of xml documents generation
526: l_counter := 1; -- reset counter
527:
528: IF (l_Debug_Level <= 1) THEN
529: cln_debug_pub.Add('Counter set as - '||l_counter,1);
530: END IF;
531:
532: -- extract first item
533: FETCH c_ItemsToSend INTO l_from_items;

Line 537: cln_debug_pub.Add('start item of the message found as - '||l_from_items,1);

533: FETCH c_ItemsToSend INTO l_from_items;
534: EXIT WHEN c_ItemsToSend%NOTFOUND;
535:
536: IF (l_Debug_Level <= 1) THEN
537: cln_debug_pub.Add('start item of the message found as - '||l_from_items,1);
538: END IF;
539:
540: l_to_items := l_from_items; -- jst incase this is the last item
541:

Line 547: cln_debug_pub.Add('intermediatory end item of the message found as - '||l_to_items,1);

543: FETCH c_ItemsToSend INTO l_to_items; -- extract last item number
544: EXIT WHEN c_ItemsToSend%NOTFOUND; -- if we reached the end, then just send out what's left
545:
546: IF (l_Debug_Level <= 1) THEN
547: cln_debug_pub.Add('intermediatory end item of the message found as - '||l_to_items,1);
548: END IF;
549:
550: l_counter := l_counter + 1;
551:

Line 553: cln_debug_pub.Add('Counter value raised to - '||l_counter,1);

549:
550: l_counter := l_counter + 1;
551:
552: IF (l_Debug_Level <= 1) THEN
553: cln_debug_pub.Add('Counter value raised to - '||l_counter,1);
554: END IF;
555: END LOOP;
556:
557: IF (l_Debug_Level <= 1) THEN

Line 558: cln_debug_pub.Add('end item of the message found as - '||l_to_items,1);

554: END IF;
555: END LOOP;
556:
557: IF (l_Debug_Level <= 1) THEN
558: cln_debug_pub.Add('end item of the message found as - '||l_to_items,1);
559: END IF;
560:
561: -- create unique key
562: SELECT CLN_SYNCITEM_S.nextval INTO l_syncitem_seq FROM dual;

Line 567: cln_debug_pub.Add('Event Key set as - '||l_event_key,1);

563: l_event_key := to_char(p_tp_header_id) || '.' || to_char(l_syncitem_seq);
564:
565:
566: IF (l_Debug_Level <= 1) THEN
567: cln_debug_pub.Add('Event Key set as - '||l_event_key,1);
568: END IF;
569:
570: -- setting the generic workflow parameters
571: wf_event.AddParameterToList(p_name => 'MAP_PARAMETER6',

Line 592: cln_debug_pub.Add('raising event as - oracle.apps.cln.common.xml.out',1);

588: p_value => l_event_key,
589: p_parameterlist => l_genwf_cln_parameter_list);
590:
591: IF (l_Debug_Level <= 1) THEN
592: cln_debug_pub.Add('raising event as - oracle.apps.cln.common.xml.out',1);
593: END IF;
594:
595: -- raise event for send show shipment document
596: wf_event.raise(p_event_name => 'oracle.apps.cln.common.xml.out',

Line 601: cln_debug_pub.Add('....Event Raised...',1);

597: p_event_key => l_event_key,
598: p_parameters => l_genwf_cln_parameter_list);
599:
600: IF (l_Debug_Level <= 1) THEN
601: cln_debug_pub.Add('....Event Raised...',1);
602: END IF;
603: END LOOP;
604:
605: CLOSE c_ItemsToSend;

Line 614: cln_debug_pub.Add(l_msg_data,1);

610: errbuf := 'Successful';
611:
612: -- check the error message
613: IF (l_Debug_Level <= 1) THEN
614: cln_debug_pub.Add(l_msg_data,1);
615: END IF;
616:
617: IF (l_Debug_Level <= 2) THEN
618: cln_debug_pub.Add('------- Exiting Raise_Syncitem_Event API --------- ',2);

Line 618: cln_debug_pub.Add('------- Exiting Raise_Syncitem_Event API --------- ',2);

614: cln_debug_pub.Add(l_msg_data,1);
615: END IF;
616:
617: IF (l_Debug_Level <= 2) THEN
618: cln_debug_pub.Add('------- Exiting Raise_Syncitem_Event API --------- ',2);
619: END IF;
620:
621: -- Exception Handling
622: EXCEPTION

Line 628: cln_debug_pub.Add(l_msg_data,4);

624: WHEN FND_API.G_EXC_ERROR THEN
625: retcode := 2 ;
626: errbuf := l_msg_data;
627: IF (l_Debug_Level <= 5) THEN
628: cln_debug_pub.Add(l_msg_data,4);
629: cln_debug_pub.Add('------- Exiting Raise_Syncitem_Event API with error --------- ',2);
630: END IF;
631:
632:

Line 629: cln_debug_pub.Add('------- Exiting Raise_Syncitem_Event API with error --------- ',2);

625: retcode := 2 ;
626: errbuf := l_msg_data;
627: IF (l_Debug_Level <= 5) THEN
628: cln_debug_pub.Add(l_msg_data,4);
629: cln_debug_pub.Add('------- Exiting Raise_Syncitem_Event API with error --------- ',2);
630: END IF;
631:
632:
633: WHEN OTHERS THEN

Line 643: cln_debug_pub.Add(l_msg_data,6);

639: FND_MESSAGE.SET_TOKEN('ERRORMSG',l_error_msg);
640: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
641: errbuf := l_msg_data;
642: IF (l_Debug_Level <= 5) THEN
643: cln_debug_pub.Add(l_msg_data,6);
644: cln_debug_pub.Add('------- Exiting Raise_Syncitem_Event API with an unexpected error --------- ',2);
645: END IF;
646:
647:

Line 644: cln_debug_pub.Add('------- Exiting Raise_Syncitem_Event API with an unexpected error --------- ',2);

640: l_msg_data :='Unexpected Error -'||l_error_code||' : '||l_error_msg;
641: errbuf := l_msg_data;
642: IF (l_Debug_Level <= 5) THEN
643: cln_debug_pub.Add(l_msg_data,6);
644: cln_debug_pub.Add('------- Exiting Raise_Syncitem_Event API with an unexpected error --------- ',2);
645: END IF;
646:
647:
648: END Raise_Syncitem_Event;

Line 728: cln_debug_pub.Add('Failure point ' || x_progress, 1);

724: l_create_cln_parameter_list := wf_parameter_list_t();
725:
726: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Entered Procedure';
727: if (l_debug_level <= 1) then
728: cln_debug_pub.Add('Failure point ' || x_progress, 1);
729: end if;
730:
731: -- get organization ID
732: select FND_PROFILE.VALUE('ORG_ID')

Line 758: cln_debug_pub.Add('Failure point ' || x_progress, 1);

754: where eth.tp_header_id = l_tp_header_id;
755:
756: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Initialized procedure parameters';
757: if (l_debug_level <= 1) then
758: cln_debug_pub.Add('Failure point ' || x_progress, 1);
759: end if;
760:
761: -- XML Setup Check
762: ecx_document.isDeliveryRequired(

Line 773: cln_debug_pub.Add('Failure point ' || x_progress, 1);

769: errmsg => errmsg);
770:
771: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : XML Setup Check Done';
772: if (l_debug_level <= 1) then
773: cln_debug_pub.Add('Failure point ' || x_progress, 1);
774: end if;
775:
776: -- Decision on action depending on XML Setup Check
777: if NOT(result) then -- XML not setup

Line 781: cln_debug_pub.Add('Failure point ' || x_progress, 1);

777: if NOT(result) then -- XML not setup
778:
779: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : XML Setup does not exist';
780: if (l_debug_level <= 1) then
781: cln_debug_pub.Add('Failure point ' || x_progress, 1);
782: end if;
783: else
784: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : XML Setup exists';
785: if (l_debug_level <= 1) then

Line 786: cln_debug_pub.Add('Failure point ' || x_progress, 1);

782: end if;
783: else
784: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : XML Setup exists';
785: if (l_debug_level <= 1) then
786: cln_debug_pub.Add('Failure point ' || x_progress, 1);
787: end if;
788:
789: -- create unique key
790: SELECT CLN_SYNCITEM_S.nextval into l_syncitem_seq from dual;

Line 798: cln_debug_pub.Add('Failure point ' || x_progress, 1);

794: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
795:
796: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Unique key created';
797: if (l_debug_level <= 1) then
798: cln_debug_pub.Add('Failure point ' || x_progress, 1);
799: end if;
800:
801: -- add parameters to list for create collaboration event
802: wf_event.AddParameterToList(p_name => 'XMLG_INTERNAL_TXN_TYPE',

Line 835: cln_debug_pub.Add('Failure point ' || x_progress, 1);

831: p_parameterlist => l_create_cln_parameter_list);
832:
833: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Create Event Parameters Setup';
834: if (l_debug_level <= 1) then
835: cln_debug_pub.Add('Failure point ' || x_progress, 1);
836: end if;
837:
838: -- raise create collaboration event
839: wf_event.raise(p_event_name => l_create_cln_event,

Line 845: cln_debug_pub.Add('Failure point ' || x_progress, 1);

841: p_parameters => l_create_cln_parameter_list);
842:
843: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Create Event Raised';
844: if (l_debug_level <= 1) then
845: cln_debug_pub.Add('Failure point ' || x_progress, 1);
846: end if;
847:
848: -- add parameters to list for send sync item document
849: wf_event.AddParameterToList(p_name => 'ECX_TRANSACTION_TYPE',

Line 924: cln_debug_pub.Add('Failure point ' || x_progress, 1);

920: p_parameterlist => l_send_syit_parameter_list);
921:
922: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Initialize Send Document Parameters';
923: if (l_debug_level <= 1) then
924: cln_debug_pub.Add('Failure point ' || x_progress, 1);
925: end if;
926:
927: -- raise event for send show shipment document
928: wf_event.raise(p_event_name => l_send_shsp_event,

Line 934: cln_debug_pub.Add('Failure point ' || x_progress, 1);

930: p_parameters => l_send_syit_parameter_list);
931:
932: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Send Document Event Raised';
933: if (l_debug_level <= 1) then
934: cln_debug_pub.Add('Failure point ' || x_progress, 1);
935: end if;
936: end if;
937:
938: END LOOP;

Line 946: cln_debug_pub.Add('Failure point ' || x_progress, 1);

942:
943: -- Reached Here. Successful execution.
944: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : Exiting Procedure';
945: if (l_debug_level <= 1) then
946: cln_debug_pub.Add('Failure point ' || x_progress, 1);
947: end if;
948:
949: resultout := 'COMPLETE:T';
950: EXCEPTION

Line 955: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);

951: WHEN OTHERS THEN
952: l_error_code := SQLCODE;
953: l_error_msg := SQLERRM;
954: if (l_debug_level <= 1) then
955: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);
956: end if;
957:
958: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : ERROR';
959: if (l_debug_level <= 1) then

Line 960: cln_debug_pub.Add('Failure point ' || x_progress, 1);

956: end if;
957:
958: x_progress := 'CLN_SYNCITEM_PKG.Send_Syncitem_Delete : ERROR';
959: if (l_debug_level <= 1) then
960: cln_debug_pub.Add('Failure point ' || x_progress, 1);
961: end if;
962: END Send_Syncitem_Delete;
963:
964:

Line 1013: cln_debug_pub.Add('Failure point ' || x_progress, 1);

1009: resultout := 'COMPLETE:T';
1010: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
1011: x_progress := 'CLN_SYNCITEM_PKG.Archive_Deleted_Items : Entered Procedure';
1012: if (l_debug_level <= 1) then
1013: cln_debug_pub.Add('Failure point ' || x_progress, 1);
1014: end if;
1015:
1016:
1017:

Line 1032: cln_debug_pub.Add('Failure point ' || x_progress, 1);

1028:
1029: -- Reached Here. Successful execution.
1030: x_progress := 'CLN_SYNCITEM_PKG.Archive_Deleted_Items : Exiting Procedure';
1031: if (l_debug_level <= 1) then
1032: cln_debug_pub.Add('Failure point ' || x_progress, 1);
1033: end if;
1034:
1035: EXCEPTION
1036:

Line 1041: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);

1037: WHEN OTHERS THEN
1038: l_error_code := SQLCODE;
1039: l_error_msg := SQLERRM;
1040: if (l_debug_level <= 1) then
1041: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);
1042: end if;
1043:
1044: x_progress := 'CLN_SYNCITEM_PKG.Archive_Deleted_Items : ERROR';
1045: if (l_debug_level <= 1) then

Line 1046: cln_debug_pub.Add('Failure point ' || x_progress, 1);

1042: end if;
1043:
1044: x_progress := 'CLN_SYNCITEM_PKG.Archive_Deleted_Items : ERROR';
1045: if (l_debug_level <= 1) then
1046: cln_debug_pub.Add('Failure point ' || x_progress, 1);
1047: end if;
1048: resultout := 'COMPLETE:F';
1049: END Archive_Deleted_Items;
1050:

Line 1082: cln_debug_pub.Add('Failure point ' || x_progress, 1);

1078: /******
1079: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
1080: x_progress := 'CLN_SYNCITEM_PKG.Delete_Archived_Items : Entered Procedure';
1081: if (l_debug_level <= 1) then
1082: cln_debug_pub.Add('Failure point ' || x_progress, 1);
1083: end if;
1084:
1085: -- Retrieve Activity Attributes
1086: p_inventory_item_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'INVENTORY_ITEM_ID');

Line 1095: cln_debug_pub.Add('Failure point ' || x_progress, 1);

1091:
1092: -- Reached Here. Successful execution.
1093: x_progress := 'CLN_SYNCITEM_PKG.Delete_Archived_Items : Exiting Procedure';
1094: if (l_debug_level <= 1) then
1095: cln_debug_pub.Add('Failure point ' || x_progress, 1);
1096: end if;
1097: ******/
1098: resultout := 'COMPLETE:T';
1099: EXCEPTION

Line 1104: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);

1100: WHEN OTHERS THEN
1101: l_error_code := SQLCODE;
1102: l_error_msg := SQLERRM;
1103: if (l_debug_level <= 1) then
1104: cln_debug_pub.Add('Exception ' || ':' || l_error_code || ':' || l_error_msg, 1);
1105: end if;
1106:
1107: x_progress := 'CLN_SYNCITEM_PKG.Delete_Archived_Items : ERROR';
1108: if (l_debug_level <= 1) then

Line 1109: cln_debug_pub.Add('Failure point ' || x_progress, 1);

1105: end if;
1106:
1107: x_progress := 'CLN_SYNCITEM_PKG.Delete_Archived_Items : ERROR';
1108: if (l_debug_level <= 1) then
1109: cln_debug_pub.Add('Failure point ' || x_progress, 1);
1110: end if;
1111: END Delete_Archived_Items;
1112:
1113: END CLN_SYNCITEM_PKG;