DBA Data[Home] [Help]

APPS.ITG_BOAPI_WRAPPERS dependencies on ITG_BOAPI_WRAPPERS

Line 1: PACKAGE BODY ITG_BOAPI_Wrappers AS

1: PACKAGE BODY ITG_BOAPI_Wrappers AS
2: /* ARCS: $Header: itgwrapb.pls 120.7 2006/08/24 06:06:01 pvaddana noship $
3: * CVS: itgwrapb.pls,v 1.52 2003/05/30 00:49:39 klai Exp
4: */
5: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

Line 1090: END ITG_BOAPI_Wrappers;

1086: END Sync_UOM_ALL;
1087:
1088: BEGIN
1089: g_active := 0;
1090: END ITG_BOAPI_Wrappers;