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.ITG_BOAPI_WRAPPERS dependencies on ITG_DEBUG

Line 76: itg_debug_pub.Add('--- Entering Begin_Wrapper ---' ,2);

72:
73: FND_PROFILE.put('FND_AS_MSG_LEVEL_THRESHOLD', 0);
74:
75: IF (l_Debug_Level <= 2) THEN
76: itg_debug_pub.Add('--- Entering Begin_Wrapper ---' ,2);
77: END IF;
78:
79:
80: /* 4169685: REMOVE INSTALL DATA INSERTION FROM HR_LOCATIONS TABLE */

Line 86: itg_debug_pub.Add('Missing Trading Partner setup and/or Connector uninitialized.' ,1);

82: g_return_status := FND_API.G_RET_STS_ERROR;
83: itg_msg.incorrect_setup;
84:
85: IF (l_Debug_Level <= 1) THEN
86: itg_debug_pub.Add('Missing Trading Partner setup and/or Connector uninitialized.' ,1);
87: END IF;
88: RETURN;
89: END IF;
90:

Line 127: itg_debug_pub.Add('Calling create_collaboration ...' ,1);

123: END IF;
124:
125: BEGIN
126: IF (l_Debug_Level <= 1) THEN
127: itg_debug_pub.Add('Calling create_collaboration ...' ,1);
128: END IF;
129:
130: CLN_CH_COLLABORATION_PKG.create_collaboration(
131: x_return_status => l_return_status,

Line 170: itg_debug_pub.Add('Create CLN : ' || l_return_status || l_msg_buff , 5);

166: );
167:
168: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
169: IF (l_Debug_Level <= 5) THEN
170: itg_debug_pub.Add('Create CLN : ' || l_return_status || l_msg_buff , 5);
171: END IF;
172:
173: itg_msg.cln_failure(substr(l_msg_buff,1,255));
174: g_collaboration_id := 0;

Line 181: itg_debug_pub.Add(substr(SQLERRM,1,255), 6);

177: EXCEPTION
178: WHEN OTHERS THEN
179: g_collaboration_id := 0;
180: IF (l_Debug_Level <= 6) THEN
181: itg_debug_pub.Add(substr(SQLERRM,1,255), 6);
182: END IF;
183:
184: itg_msg.cln_failure(substr(SQLERRM,1,255));
185: itg_msg.unexpected_error('CLN collaboration creation');

Line 191: itg_debug_pub.Add('--- Exiting Begin_Wrapper ---' ,2);

187:
188: check_return_status('Begin_Wrapper', l_return_status);
189:
190: IF (l_Debug_Level <= 2) THEN
191: itg_debug_pub.Add('--- Exiting Begin_Wrapper ---' ,2);
192: END IF;
193: EXCEPTION
194: WHEN OTHERS THEN
195: check_return_status('Begin_Wrapper', FND_API.G_RET_STS_UNEXP_ERROR );

Line 197: itg_debug_pub.Add('BeginWrapper ' || SQLERRM ,6);

193: EXCEPTION
194: WHEN OTHERS THEN
195: check_return_status('Begin_Wrapper', FND_API.G_RET_STS_UNEXP_ERROR );
196: IF (l_Debug_Level <= 6) THEN
197: itg_debug_pub.Add('BeginWrapper ' || SQLERRM ,6);
198: END IF;
199:
200: g_collaboration_id := 0;
201: itg_msg.unexpected_error('CLN collaboration creation');

Line 217: itg_debug_pub.Add('--- Entering End_Wrapper ---' ,2);

213: x_return_message OUT NOCOPY VARCHAR2
214: ) IS
215: BEGIN
216: IF (l_Debug_Level <= 2) THEN
217: itg_debug_pub.Add('--- Entering End_Wrapper ---' ,2);
218: END IF;
219:
220: IF (l_Debug_Level <= 1) THEN
221: itg_debug_pub.Add('g_collaboration_id '||g_collaboration_id ,1);

Line 221: itg_debug_pub.Add('g_collaboration_id '||g_collaboration_id ,1);

217: itg_debug_pub.Add('--- Entering End_Wrapper ---' ,2);
218: END IF;
219:
220: IF (l_Debug_Level <= 1) THEN
221: itg_debug_pub.Add('g_collaboration_id '||g_collaboration_id ,1);
222: itg_debug_pub.Add('g_return_status ' ||g_return_status,1);
223: END IF;
224:
225: x_cln_id := g_collaboration_id;

Line 222: itg_debug_pub.Add('g_return_status ' ||g_return_status,1);

218: END IF;
219:
220: IF (l_Debug_Level <= 1) THEN
221: itg_debug_pub.Add('g_collaboration_id '||g_collaboration_id ,1);
222: itg_debug_pub.Add('g_return_status ' ||g_return_status,1);
223: END IF;
224:
225: x_cln_id := g_collaboration_id;
226:

Line 248: itg_debug_pub.Add('--- Exiting End_Wrapper ---' ,2);

244: g_return_message := NULL;
245: g_org := NULL; -- don't let org of prev. txn to remain in session state!
246:
247: IF (l_Debug_Level <= 2) THEN
248: itg_debug_pub.Add('--- Exiting End_Wrapper ---' ,2);
249: END IF;
250: EXCEPTION
251: WHEN OTHERS THEN
252: g_collaboration_id := NULL;

Line 257: itg_debug_pub.Add('--- Exiting End_Wrapper : ERROR---' ,2);

253: g_return_status := NULL;
254: g_return_message := NULL;
255: g_org := NULL;
256: IF (l_Debug_Level <= 2) THEN
257: itg_debug_pub.Add('--- Exiting End_Wrapper : ERROR---' ,2);
258: END IF;
259: END End_Wrapper;
260:
261:

Line 280: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Reap_Messages', 2);

276: l_text VARCHAR2(4000);
277: l_msg_data VARCHAR2(2000);
278: BEGIN
279: IF (l_Debug_Level <= 2) THEN
280: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Reap_Messages', 2);
281: END IF;
282:
283: /* g_return_message is not obtained from the FND stack */
284: /* It is based on itg_x_utils.getCBODDesc */

Line 299: itg_debug_pub.Add('l_coll_id => '||to_char(g_collaboration_id), 1);

295: l_message := 'Document processed successfully';
296: END IF;
297:
298: IF (l_Debug_Level <= 1) THEN
299: itg_debug_pub.Add('l_coll_id => '||to_char(g_collaboration_id), 1);
300: itg_debug_pub.Add('l_doctyp => '||g_doctyp, 1);
301: itg_debug_pub.Add('l_cln_status => '||NVL(l_cln_status, 'NULL'), 1);
302: itg_debug_pub.Add('l_doc_status => '||NVL(l_doc_status, 'NULL'), 1);
303: END IF;

Line 300: itg_debug_pub.Add('l_doctyp => '||g_doctyp, 1);

296: END IF;
297:
298: IF (l_Debug_Level <= 1) THEN
299: itg_debug_pub.Add('l_coll_id => '||to_char(g_collaboration_id), 1);
300: itg_debug_pub.Add('l_doctyp => '||g_doctyp, 1);
301: itg_debug_pub.Add('l_cln_status => '||NVL(l_cln_status, 'NULL'), 1);
302: itg_debug_pub.Add('l_doc_status => '||NVL(l_doc_status, 'NULL'), 1);
303: END IF;
304:

Line 301: itg_debug_pub.Add('l_cln_status => '||NVL(l_cln_status, 'NULL'), 1);

297:
298: IF (l_Debug_Level <= 1) THEN
299: itg_debug_pub.Add('l_coll_id => '||to_char(g_collaboration_id), 1);
300: itg_debug_pub.Add('l_doctyp => '||g_doctyp, 1);
301: itg_debug_pub.Add('l_cln_status => '||NVL(l_cln_status, 'NULL'), 1);
302: itg_debug_pub.Add('l_doc_status => '||NVL(l_doc_status, 'NULL'), 1);
303: END IF;
304:
305: l_status := FND_API.G_RET_STS_SUCCESS;

Line 302: itg_debug_pub.Add('l_doc_status => '||NVL(l_doc_status, 'NULL'), 1);

298: IF (l_Debug_Level <= 1) THEN
299: itg_debug_pub.Add('l_coll_id => '||to_char(g_collaboration_id), 1);
300: itg_debug_pub.Add('l_doctyp => '||g_doctyp, 1);
301: itg_debug_pub.Add('l_cln_status => '||NVL(l_cln_status, 'NULL'), 1);
302: itg_debug_pub.Add('l_doc_status => '||NVL(l_doc_status, 'NULL'), 1);
303: END IF;
304:
305: l_status := FND_API.G_RET_STS_SUCCESS;
306: l_msg_data := 'Success';

Line 346: itg_debug_pub.Add('CLN update_collaboration retsts> ' || l_status,6);

342: );
343:
344: IF nvl(l_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
345: IF (l_Debug_Level <= 6) THEN
346: itg_debug_pub.Add('CLN update_collaboration retsts> ' || l_status,6);
347: itg_debug_pub.Add('CLN update_collaboration retmsg> ' || l_msg_data,6);
348: END IF;
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: ELSE

Line 347: itg_debug_pub.Add('CLN update_collaboration retmsg> ' || l_msg_data,6);

343:
344: IF nvl(l_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
345: IF (l_Debug_Level <= 6) THEN
346: itg_debug_pub.Add('CLN update_collaboration retsts> ' || l_status,6);
347: itg_debug_pub.Add('CLN update_collaboration retmsg> ' || l_msg_data,6);
348: END IF;
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: ELSE
351: IF (l_Debug_Level <= 1) THEN

Line 352: itg_debug_pub.Add('l_dtl_id => '||NVL(to_char(l_dtl_id), 'NULL'), 1);

348: END IF;
349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
350: ELSE
351: IF (l_Debug_Level <= 1) THEN
352: itg_debug_pub.Add('l_dtl_id => '||NVL(to_char(l_dtl_id), 'NULL'), 1);
353: END IF;
354: END IF;
355:
356: /* Now loop through FND messages and add collaboration details*/

Line 367: itg_debug_pub.Add('l_text => '|| l_text ,1);

363: WHILE l_text IS NOT NULL LOOP
364: l_text := substrb(l_text,1,2000);
365:
366: IF (l_Debug_Level <= 1) THEN
367: itg_debug_pub.Add('l_text => '|| l_text ,1);
368: END IF;
369:
370: IF l_text IS NOT NULL THEN
371: l_status := FND_API.G_RET_STS_SUCCESS;

Line 387: itg_debug_pub.Add('CLN add_collab_msg retsts> ' || l_status ,6);

383: );
384:
385: IF nvl(l_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
386: IF (l_Debug_Level <= 6) THEN
387: itg_debug_pub.Add('CLN add_collab_msg retsts> ' || l_status ,6);
388: itg_debug_pub.Add('CLN add_collab_msg retmsg> ' || l_msg_data ,6);
389: END IF;
390: END IF;
391: END IF;

Line 388: itg_debug_pub.Add('CLN add_collab_msg retmsg> ' || l_msg_data ,6);

384:
385: IF nvl(l_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
386: IF (l_Debug_Level <= 6) THEN
387: itg_debug_pub.Add('CLN add_collab_msg retsts> ' || l_status ,6);
388: itg_debug_pub.Add('CLN add_collab_msg retmsg> ' || l_msg_data ,6);
389: END IF;
390: END IF;
391: END IF;
392:

Line 404: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Reap_Messages', 2);

400: /* Delete global message table*/
401: FND_MSG_PUB.Delete_Msg;
402:
403: IF (l_Debug_Level <= 2) THEN
404: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Reap_Messages', 2);
405: END IF;
406: EXCEPTION
407: WHEN OTHERS THEN
408: IF (l_Debug_Level <= 6) THEN

Line 409: itg_debug_pub.Add('Unexpceted error in reap messages - ' || SUBSTRB(SQLERRM,1,1000),6);

405: END IF;
406: EXCEPTION
407: WHEN OTHERS THEN
408: IF (l_Debug_Level <= 6) THEN
409: itg_debug_pub.Add('Unexpceted error in reap messages - ' || SUBSTRB(SQLERRM,1,1000),6);
410: END IF;
411: null;
412: END Reap_Messages;
413:

Line 434: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_FlexValue', 2);

430: l_msg_count NUMBER;
431: l_msg_data VARCHAR2(2000);
432: BEGIN
433: IF (l_Debug_Level <= 2) THEN
434: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_FlexValue', 2);
435: END IF;
436:
437: IF g_return_status = FND_API.G_RET_STS_SUCCESS AND
438: NOT ITG_OrgEff_PVT.Check_Effective(

Line 448: itg_debug_pub.Add('wSFV - Calling ITG_SyncCOAInbound_PVT.Sync_FlexValue API' ,1);

444: END IF;
445:
446: IF g_return_status = FND_API.G_RET_STS_SUCCESS THEN
447: IF (l_Debug_Level <= 1) THEN
448: itg_debug_pub.Add('wSFV - Calling ITG_SyncCOAInbound_PVT.Sync_FlexValue API' ,1);
449: END IF;
450:
451: ITG_SyncCOAInbound_PVT.Sync_FlexValue(
452: x_return_status => l_return_status,

Line 468: itg_debug_pub.Add('wSFV', 'Skipping ITG_SyncCOAInbound_PVT.Sync_FlexValue API');

464: );
465: check_return_status('Sync_FlexValue', l_return_status);
466: ELSE
467: IF (l_Debug_Level <= 1) THEN
468: itg_debug_pub.Add('wSFV', 'Skipping ITG_SyncCOAInbound_PVT.Sync_FlexValue API');
469: END IF;
470: END IF;
471:
472: IF (l_Debug_Level <= 2) THEN

Line 473: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_FlexValue', 2);

469: END IF;
470: END IF;
471:
472: IF (l_Debug_Level <= 2) THEN
473: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_FlexValue', 2);
474: END IF;
475: EXCEPTION
476: WHEN OTHERS THEN
477: ITG_Debug.msg('Unexpected error in wrapper(Flex-value sync) - ' || substr(SQLERRM,1,255),true);

Line 477: ITG_Debug.msg('Unexpected error in wrapper(Flex-value sync) - ' || substr(SQLERRM,1,255),true);

473: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_FlexValue', 2);
474: END IF;
475: EXCEPTION
476: WHEN OTHERS THEN
477: ITG_Debug.msg('Unexpected error in wrapper(Flex-value sync) - ' || substr(SQLERRM,1,255),true);
478: itg_msg.unexpected_error('Flex-value sync');
479: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: IF (l_Debug_Level <= 6) THEN
481: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_FlexValue :OTHER ERROR', 6);

Line 481: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_FlexValue :OTHER ERROR', 6);

477: ITG_Debug.msg('Unexpected error in wrapper(Flex-value sync) - ' || substr(SQLERRM,1,255),true);
478: itg_msg.unexpected_error('Flex-value sync');
479: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: IF (l_Debug_Level <= 6) THEN
481: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_FlexValue :OTHER ERROR', 6);
482: END IF;
483:
484: END Sync_FlexValue;
485:

Line 505: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Process_ExchangeRate', 2);

501: l_msg_count NUMBER;
502: l_msg_data VARCHAR2(2000);
503: BEGIN
504: IF (l_Debug_Level <= 2) THEN
505: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Process_ExchangeRate', 2);
506: END IF;
507:
508: IF g_return_status = FND_API.G_RET_STS_SUCCESS AND
509: NOT ITG_OrgEff_PVT.Check_Effective(

Line 519: itg_debug_pub.Add('wPER - Calling ITG_SyncExchInbound_PVT.Process_ExchangeRate API');

515: END IF;
516:
517: IF g_return_status = FND_API.G_RET_STS_SUCCESS THEN
518: IF (l_Debug_Level <= 1) THEN
519: itg_debug_pub.Add('wPER - Calling ITG_SyncExchInbound_PVT.Process_ExchangeRate API');
520: END IF;
521:
522: ITG_SyncExchInbound_PVT.Process_ExchangeRate(
523: x_return_status => l_return_status,

Line 539: itg_debug_pub.Add('wPER - Skipping API' ,1);

535: );
536: check_return_status('Process_ExchangeRate', l_return_status);
537: ELSE
538: IF (l_Debug_Level <= 1) THEN
539: itg_debug_pub.Add('wPER - Skipping API' ,1);
540: END IF;
541: END IF;
542:
543: IF (l_Debug_Level <= 2) THEN

Line 544: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_ExchangeRate', 2);

540: END IF;
541: END IF;
542:
543: IF (l_Debug_Level <= 2) THEN
544: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_ExchangeRate', 2);
545: END IF;
546: EXCEPTION
547: WHEN OTHERS THEN
548: ITG_Debug.msg('Unexpected error in wrapper(Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);

Line 548: ITG_Debug.msg('Unexpected error in wrapper(Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);

544: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_ExchangeRate', 2);
545: END IF;
546: EXCEPTION
547: WHEN OTHERS THEN
548: ITG_Debug.msg('Unexpected error in wrapper(Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);
549: itg_msg.unexpected_error('Exchange-rate sync');
550: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: IF (l_Debug_Level <= 6) THEN
552: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_ExchangeRate : OTHER ERROR', 6);

Line 552: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_ExchangeRate : OTHER ERROR', 6);

548: ITG_Debug.msg('Unexpected error in wrapper(Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);
549: itg_msg.unexpected_error('Exchange-rate sync');
550: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: IF (l_Debug_Level <= 6) THEN
552: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_ExchangeRate : OTHER ERROR', 6);
553: END IF;
554:
555: END Process_ExchangeRate;
556:

Line 577: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Update_PoLine', 2);

573: p_amount IN NUMBER
574: ) IS
575: BEGIN
576: IF (l_Debug_Level <= 2) THEN
577: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Update_PoLine', 2);
578: END IF;
579:
580: g_org := TO_NUMBER(p_org_id);
581:

Line 592: itg_debug_pub.Add('wUPL - Calling ITG_SyncPoInbound_PVT.Update_PoLine API' ,1);

588: END IF;
589:
590: IF g_return_status = FND_API.G_RET_STS_SUCCESS THEN
591: IF (l_Debug_Level <= 1) THEN
592: itg_debug_pub.Add('wUPL - Calling ITG_SyncPoInbound_PVT.Update_PoLine API' ,1);
593: END IF;
594:
595:
596: ITG_SyncPoInbound_PVT.Update_PoLine(

Line 611: itg_debug_pub.Add('wUPL - Skipping API' ,1);

607: );
608: check_return_status('Update_PoLine2', x_return_status);
609: ELSE
610: IF (l_Debug_Level <= 1) THEN
611: itg_debug_pub.Add('wUPL - Skipping API' ,1);
612: END IF;
613: END IF;
614:
615: IF (l_Debug_Level <= 2) THEN

Line 616: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Update_PoLine', 2);

612: END IF;
613: END IF;
614:
615: IF (l_Debug_Level <= 2) THEN
616: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Update_PoLine', 2);
617: END IF;
618:
619: EXCEPTION
620: WHEN OTHERS THEN

Line 621: ITG_Debug.msg('Unexpected error in wrapper(Purchase order sync) - ' || substr(SQLERRM,1,255),true);

617: END IF;
618:
619: EXCEPTION
620: WHEN OTHERS THEN
621: ITG_Debug.msg('Unexpected error in wrapper(Purchase order sync) - ' || substr(SQLERRM,1,255),true);
622: itg_msg.unexpected_error('Purchase order sync');
623: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: IF (l_Debug_Level <= 6) THEN
625: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Update_PoLine : OTHER ERROR', 6);

Line 625: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Update_PoLine : OTHER ERROR', 6);

621: ITG_Debug.msg('Unexpected error in wrapper(Purchase order sync) - ' || substr(SQLERRM,1,255),true);
622: itg_msg.unexpected_error('Purchase order sync');
623: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: IF (l_Debug_Level <= 6) THEN
625: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Update_PoLine : OTHER ERROR', 6);
626: END IF;
627:
628: END Update_PoLine;
629:

Line 654: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_Vendor', 2);

650: l_msg_count NUMBER;
651: l_msg_data VARCHAR2(2000);
652: BEGIN
653: IF (l_Debug_Level <= 2) THEN
654: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_Vendor', 2);
655: END IF;
656:
657: IF g_return_status = FND_API.G_RET_STS_SUCCESS AND
658: NOT ITG_OrgEff_PVT.Check_Effective(

Line 668: itg_debug_pub.Add('wSV - Calling ITG_SyncSupplierInbound_PVT.Sync_Vendor API' ,1);

664: END IF;
665:
666: IF g_return_status = FND_API.G_RET_STS_SUCCESS THEN
667: IF (l_Debug_Level <= 1) THEN
668: itg_debug_pub.Add('wSV - Calling ITG_SyncSupplierInbound_PVT.Sync_Vendor API' ,1);
669: END IF;
670:
671: g_vinfo_rec := ITG_SyncSupplierInbound_PVT.G_MISS_VINFO_REC;
672:

Line 696: itg_debug_pub.Add('wSV - Skipping API' ,1);

692: );
693: check_return_status('Sync_Vendor', l_return_status);
694: ELSE
695: IF (l_Debug_Level <= 1) THEN
696: itg_debug_pub.Add('wSV - Skipping API' ,1);
697: END IF;
698: END IF;
699:
700: IF (l_Debug_Level <= 2) THEN

Line 701: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_Vendor', 2);

697: END IF;
698: END IF;
699:
700: IF (l_Debug_Level <= 2) THEN
701: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_Vendor', 2);
702: END IF;
703:
704: EXCEPTION
705: WHEN OTHERS THEN

Line 706: ITG_Debug.msg('Unexpected error in wrapper(Vendor sync) - ' || substr(SQLERRM,1,255),true);

702: END IF;
703:
704: EXCEPTION
705: WHEN OTHERS THEN
706: ITG_Debug.msg('Unexpected error in wrapper(Vendor sync) - ' || substr(SQLERRM,1,255),true);
707: itg_msg.unexpected_error('Vendor sync');
708: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: IF (l_Debug_Level <= 6) THEN
710: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_Vendor : OTHER ERROR', 6);

Line 710: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_Vendor : OTHER ERROR', 6);

706: ITG_Debug.msg('Unexpected error in wrapper(Vendor sync) - ' || substr(SQLERRM,1,255),true);
707: itg_msg.unexpected_error('Vendor sync');
708: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709: IF (l_Debug_Level <= 6) THEN
710: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_Vendor : OTHER ERROR', 6);
711: END IF;
712:
713: END Sync_Vendor;
714:

Line 742: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_VendorSite', 2);

738: l_msg_count NUMBER;
739: l_msg_data VARCHAR2(2000);
740: BEGIN
741: IF (l_Debug_Level <= 2) THEN
742: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_VendorSite', 2);
743: END IF;
744:
745: IF g_return_status = FND_API.G_RET_STS_SUCCESS THEN
746: IF (l_Debug_Level <= 1) THEN

Line 747: itg_debug_pub.Add('wSVS - Calling ITG_SyncSupplierInbound_PVT.Sync_VendorSite API',1);

743: END IF;
744:
745: IF g_return_status = FND_API.G_RET_STS_SUCCESS THEN
746: IF (l_Debug_Level <= 1) THEN
747: itg_debug_pub.Add('wSVS - Calling ITG_SyncSupplierInbound_PVT.Sync_VendorSite API',1);
748: END IF;
749:
750: ITG_SyncSupplierInbound_PVT.Sync_VendorSite(
751: x_return_status => l_return_status,

Line 782: itg_debug_pub.Add('wSVS - Skipping API', 1);

778: g_process_vendor_contact := true;
779: END IF;
780: ELSE
781: IF (l_Debug_Level <= 1) THEN
782: itg_debug_pub.Add('wSVS - Skipping API', 1);
783: END IF;
784: END IF;
785:
786: IF (l_Debug_Level <= 2) THEN

Line 787: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_VendorSite', 2);

783: END IF;
784: END IF;
785:
786: IF (l_Debug_Level <= 2) THEN
787: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_VendorSite', 2);
788: END IF;
789:
790: EXCEPTION
791: WHEN OTHERS THEN

Line 792: ITG_Debug.msg('Unexpected error in wrapper(Vendor-site sync) - ' || substr(SQLERRM,1,255),true);

788: END IF;
789:
790: EXCEPTION
791: WHEN OTHERS THEN
792: ITG_Debug.msg('Unexpected error in wrapper(Vendor-site sync) - ' || substr(SQLERRM,1,255),true);
793: itg_msg.unexpected_error('Vendor-site sync');
794: g_process_vendor_contact := false;
795:
796: IF (l_Debug_Level <= 6) THEN

Line 797: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_VendorSite : OTHER ERROR', 6);

793: itg_msg.unexpected_error('Vendor-site sync');
794: g_process_vendor_contact := false;
795:
796: IF (l_Debug_Level <= 6) THEN
797: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_VendorSite : OTHER ERROR', 6);
798: END IF;
799:
800: END Sync_VendorSite;
801:

Line 818: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_VendorContact', 2);

814: l_msg_count NUMBER;
815: l_msg_data VARCHAR2(2000);
816: BEGIN
817: IF (l_Debug_Level <= 2) THEN
818: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_VendorContact', 2);
819: END IF;
820:
821: IF g_return_status = FND_API.G_RET_STS_SUCCESS and g_process_vendor_contact THEN
822: IF (l_Debug_Level <= 1) THEN

Line 823: itg_debug_pub.Add('wSVC - Calling ITG_SyncSupplierInbound_PVT.Sync_VendorContact API', 1);

819: END IF;
820:
821: IF g_return_status = FND_API.G_RET_STS_SUCCESS and g_process_vendor_contact THEN
822: IF (l_Debug_Level <= 1) THEN
823: itg_debug_pub.Add('wSVC - Calling ITG_SyncSupplierInbound_PVT.Sync_VendorContact API', 1);
824: END IF;
825:
826: ITG_SyncSupplierInbound_PVT.Sync_VendorContact(
827: x_return_status => l_return_status,

Line 842: itg_debug_pub.Add('wSVC - Skipping ITG_SyncSupplierInbound_PVT.Sync_VendorContact API' ,1);

838:
839: --do not check return status since vendor sync is success
840: ELSE
841: IF (l_Debug_Level <= 1) THEN
842: itg_debug_pub.Add('wSVC - Skipping ITG_SyncSupplierInbound_PVT.Sync_VendorContact API' ,1);
843: END IF;
844: END IF;
845:
846: IF (l_Debug_Level <= 2) THEN

Line 847: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_VendorContact', 2);

843: END IF;
844: END IF;
845:
846: IF (l_Debug_Level <= 2) THEN
847: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_VendorContact', 2);
848: END IF;
849:
850: EXCEPTION
851: WHEN OTHERS THEN

Line 852: ITG_Debug.msg('Unexpected error in wrapper(Vendor-contact sync) - ' || substr(SQLERRM,1,255),true);

848: END IF;
849:
850: EXCEPTION
851: WHEN OTHERS THEN
852: ITG_Debug.msg('Unexpected error in wrapper(Vendor-contact sync) - ' || substr(SQLERRM,1,255),true);
853: itg_msg.unexpected_error('Vendor-contact sync');
854: g_process_vendor_contact := false;
855:
856: IF (l_Debug_Level <= 6) THEN

Line 857: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_VendorContact : OTHER ERROR', 6);

853: itg_msg.unexpected_error('Vendor-contact sync');
854: g_process_vendor_contact := false;
855:
856: IF (l_Debug_Level <= 6) THEN
857: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_VendorContact : OTHER ERROR', 6);
858: END IF;
859:
860: END Sync_VendorContact;
861:

Line 884: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_Item', 2);

880: l_msg_count NUMBER;
881: l_msg_data VARCHAR2(2000);
882: BEGIN
883: IF (l_Debug_Level <= 2) THEN
884: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_Item', 2);
885: END IF;
886:
887: g_org := p_org_id;
888: IF g_return_status = FND_API.G_RET_STS_SUCCESS AND

Line 899: itg_debug_pub.Add('wSI - Calling ITG_SyncItemInbound_PVT.Sync_Item API' ,1);

895: END IF;
896:
897: IF g_return_status = FND_API.G_RET_STS_SUCCESS THEN
898: IF (l_Debug_Level <= 1) THEN
899: itg_debug_pub.Add('wSI - Calling ITG_SyncItemInbound_PVT.Sync_Item API' ,1);
900: END IF;
901:
902:
903: ITG_SyncItemInbound_PVT.Sync_Item(

Line 923: itg_debug_pub.Add('wSI - Skipping API' ,1);

919: );
920: check_return_status('Sync_Item', l_return_status);
921: ELSE
922: IF (l_Debug_Level <= 1) THEN
923: itg_debug_pub.Add('wSI - Skipping API' ,1);
924: END IF;
925: END IF;
926:
927: IF (l_Debug_Level <= 2) THEN

Line 928: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_Item', 2);

924: END IF;
925: END IF;
926:
927: IF (l_Debug_Level <= 2) THEN
928: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_Item', 2);
929: END IF;
930:
931: EXCEPTION
932: WHEN OTHERS THEN

Line 933: ITG_Debug.msg('Unexpected error in wrapper(Item sync) - ' || substr(SQLERRM,1,255),true);

929: END IF;
930:
931: EXCEPTION
932: WHEN OTHERS THEN
933: ITG_Debug.msg('Unexpected error in wrapper(Item sync) - ' || substr(SQLERRM,1,255),true);
934: itg_msg.unexpected_error('Item sync');
935: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936:
937: IF (l_Debug_Level <= 6) THEN

Line 938: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_Item : OTHER ERROR', 6);

934: itg_msg.unexpected_error('Item sync');
935: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936:
937: IF (l_Debug_Level <= 6) THEN
938: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_Item : OTHER ERROR', 6);
939: END IF;
940: END Sync_Item;
941:
942:

Line 954: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Process_PoNumber', 2);

950: l_msg_count NUMBER;
951: l_msg_data VARCHAR2(2000);
952: BEGIN
953: IF (l_Debug_Level <= 2) THEN
954: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Process_PoNumber', 2);
955: END IF;
956:
957: g_org := p_org;
958: IF g_return_status = FND_API.G_RET_STS_SUCCESS AND

Line 970: itg_debug_pub.Add('wPPN - Calling API' ,1);

966:
967:
968: IF g_return_status = FND_API.G_RET_STS_SUCCESS THEN
969: IF (l_Debug_Level <= 1) THEN
970: itg_debug_pub.Add('wPPN - Calling API' ,1);
971: END IF;
972:
973: ITG_SyncFieldInbound_PVT.Process_PoNumber(
974: x_return_status => l_return_status,

Line 986: itg_debug_pub.Add('wPPN - Skipping API' ,1);

982: );
983: check_return_status('Process_PoNumber', l_return_status);
984: ELSE
985: IF (l_Debug_Level <= 1) THEN
986: itg_debug_pub.Add('wPPN - Skipping API' ,1);
987: END IF;
988: END IF;
989:
990: IF (l_Debug_Level <= 2) THEN

Line 991: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_PoNumber', 2);

987: END IF;
988: END IF;
989:
990: IF (l_Debug_Level <= 2) THEN
991: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_PoNumber', 2);
992: END IF;
993: EXCEPTION
994: WHEN OTHERS THEN
995: ITG_Debug.msg('Unexpected error in wrapper(Field sync) - ' || substr(SQLERRM,1,255),true);

Line 995: ITG_Debug.msg('Unexpected error in wrapper(Field sync) - ' || substr(SQLERRM,1,255),true);

991: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_PoNumber', 2);
992: END IF;
993: EXCEPTION
994: WHEN OTHERS THEN
995: ITG_Debug.msg('Unexpected error in wrapper(Field sync) - ' || substr(SQLERRM,1,255),true);
996: itg_msg.unexpected_error('Field sync');
997: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998:
999: IF (l_Debug_Level <= 6) THEN

Line 1000: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_PoNumber : OTHER ERROR', 6);

996: itg_msg.unexpected_error('Field sync');
997: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
998:
999: IF (l_Debug_Level <= 6) THEN
1000: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Process_PoNumber : OTHER ERROR', 6);
1001: END IF;
1002: END Process_PoNumber;
1003:
1004:

Line 1030: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_UOM_ALL', 2);

1026: l_msg_data VARCHAR2(2000);
1027:
1028: BEGIN
1029: IF (l_Debug_Level <= 2) THEN
1030: itg_debug_pub.Add('Entering ITG_BOAPI_Wrappers.Sync_UOM_ALL', 2);
1031: END IF;
1032:
1033: IF NOT ITG_OrgEff_PVT.Check_Effective(
1034: p_organization_id => g_org,

Line 1044: itg_debug_pub.Add('wSUA - Calling ITG_SyncUOMInbound_PVT.Sync_UOM_All API' ,1);

1040: END IF;
1041:
1042: IF g_return_status = FND_API.G_RET_STS_SUCCESS THEN
1043: IF (l_Debug_Level <= 1) THEN
1044: itg_debug_pub.Add('wSUA - Calling ITG_SyncUOMInbound_PVT.Sync_UOM_All API' ,1);
1045: END IF;
1046:
1047: ITG_SyncUOMInbound_PVT.Sync_UOM_All(
1048: x_return_status => l_return_status,

Line 1070: itg_debug_pub.Add('wSUA - Skipping ITG_SyncUOMInbound_PVT.Sync_UOM_All API' ,1);

1066: );
1067: check_return_status('Sync_UOM_ALL', l_return_status);
1068: ELSE
1069: IF (l_Debug_Level <= 1) THEN
1070: itg_debug_pub.Add('wSUA - Skipping ITG_SyncUOMInbound_PVT.Sync_UOM_All API' ,1);
1071: END IF;
1072: END IF;
1073:
1074: IF (l_Debug_Level <= 2) THEN

Line 1075: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_UOM_ALL', 2);

1071: END IF;
1072: END IF;
1073:
1074: IF (l_Debug_Level <= 2) THEN
1075: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_UOM_ALL', 2);
1076: END IF;
1077: EXCEPTION
1078: WHEN OTHERS THEN
1079: ITG_Debug.msg('Unexpected error in wrapper(UOM sync) - ' || substr(SQLERRM,1,255),true);

Line 1079: ITG_Debug.msg('Unexpected error in wrapper(UOM sync) - ' || substr(SQLERRM,1,255),true);

1075: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_UOM_ALL', 2);
1076: END IF;
1077: EXCEPTION
1078: WHEN OTHERS THEN
1079: ITG_Debug.msg('Unexpected error in wrapper(UOM sync) - ' || substr(SQLERRM,1,255),true);
1080: itg_msg.unexpected_error('UOM sync');
1081: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1082:
1083: IF (l_Debug_Level <= 6) THEN

Line 1084: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_UOM_ALL : OTHER ERROR', 6);

1080: itg_msg.unexpected_error('UOM sync');
1081: g_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1082:
1083: IF (l_Debug_Level <= 6) THEN
1084: itg_debug_pub.Add('Exiting ITG_BOAPI_Wrappers.Sync_UOM_ALL : OTHER ERROR', 6);
1085: END IF;
1086: END Sync_UOM_ALL;
1087:
1088: BEGIN