APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on AP_VENDOR_PARTY_MERGE_PKG

Line 1: PACKAGE BODY AP_VENDOR_PARTY_MERGE_PKG AS

1: PACKAGE BODY AP_VENDOR_PARTY_MERGE_PKG AS
2: /* $Header: apvdmrgb.pls 120.12.12010000.4 2009/02/05 05:08:16 manjayar ship $ */
3:
4: --Global constants for logging
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_VENDOR_PARTY_MERGE_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_VENDOR_PARTY_MERGE_PKG';

1: PACKAGE BODY AP_VENDOR_PARTY_MERGE_PKG AS
2: /* $Header: apvdmrgb.pls 120.12.12010000.4 2009/02/05 05:08:16 manjayar ship $ */
3:
4: --Global constants for logging
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_VENDOR_PARTY_MERGE_PKG';
6: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
7: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
8: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
9: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 22: := 'AP.PLSQL.AP_VENDOR_PARTY_MERGE_PKG';

18: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
19: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
20: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: G_MODULE_NAME CONSTANT VARCHAR2(100)
22: := 'AP.PLSQL.AP_VENDOR_PARTY_MERGE_PKG';
23:
24: -- Bug 5641382. Added the parameter v_dup_vendor_id to the procedure
25: PROCEDURE Other_Products_VendorMerge(v_dup_vendor_id IN NUMBER DEFAULT NULL)
26: IS

Line 714: 'AP_VENDOR_PARTY_MERGE_PKG.Other_Products_VendorMerge'

710: IF FND_MSG_PUB.Check_Msg_Level
711: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
712: FND_MSG_PUB.Add_Exc_Msg
713: ( G_PKG_NAME ,
714: 'AP_VENDOR_PARTY_MERGE_PKG.Other_Products_VendorMerge'
715: );
716: END IF;
717: FND_MSG_PUB.Count_And_Get
718: ( p_count => l_msg_count,

Line 812: FND_FILE.Put_Line(FND_FILE.Log,'Start AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');

808:
809:
810: BEGIN -- TCA_Contact_Merge Procedure begin
811:
812: FND_FILE.Put_Line(FND_FILE.Log,'Start AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');
813:
814: -- For loop to fetch all contacts one by one
815: FOR contact_loop_c IN
816: ( SELECT vendor_contact_id, per_party_id, org_party_site_id, org_contact_id, party_site_id

Line 992: FND_FILE.Put_Line(FND_FILE.Log,'End AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');

988: END IF;
989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991:
992: FND_FILE.Put_Line(FND_FILE.Log,'End AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');
993:
994: END LOOP;
995:
996: COMMIT;

Line 1010: END AP_VENDOR_PARTY_MERGE_PKG;

1006: -- Bug 7297864- End
1007:
1008: END AP_TCA_Contact_Merge;
1009:
1010: END AP_VENDOR_PARTY_MERGE_PKG;