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.22.12020000.2 2012/07/13 19:42:51 mkmeda 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.22.12020000.2 2012/07/13 19:42:51 mkmeda 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: v_dup_vendor_site_id IN NUMBER DEFAULT NULL)

Line 307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||' AP_VENDOR_PARTY_MERGE_PKG.other_products_vendormerge: ',

303: FOR i IN l_xla_event_ids.FIRST .. l_xla_event_ids.LAST
304: LOOP
305:
306: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||' AP_VENDOR_PARTY_MERGE_PKG.other_products_vendormerge: ',
308: 'Merged event_id: '||l_xla_event_ids (i) );
309: END IF;
310:
311: END LOOP;

Line 912: 'AP_VENDOR_PARTY_MERGE_PKG.Other_Products_VendorMerge'

908: IF FND_MSG_PUB.Check_Msg_Level
909: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
910: FND_MSG_PUB.Add_Exc_Msg
911: ( G_PKG_NAME ,
912: 'AP_VENDOR_PARTY_MERGE_PKG.Other_Products_VendorMerge'
913: );
914: END IF;
915: FND_MSG_PUB.Count_And_Get
916: ( p_count => l_msg_count,

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

1009:
1010:
1011: BEGIN -- TCA_Contact_Merge Procedure begin
1012:
1013: FND_FILE.Put_Line(FND_FILE.Log,'Start AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');
1014:
1015: -- For loop to fetch all contacts one by one
1016: FOR contact_loop_c IN ( SELECT vendor_contact_id,
1017: per_party_id,

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

1576:
1577: END IF;
1578: --bug12571995 end
1579:
1580: FND_FILE.Put_Line(FND_FILE.Log,'End AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge API call');
1581:
1582: EXCEPTION
1583: WHEN FND_API.G_EXC_ERROR THEN
1584: FND_MSG_PUB.Count_And_Get

Line 1613: 'AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge'

1609: IF FND_MSG_PUB.Check_Msg_Level
1610: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1611: FND_MSG_PUB.Add_Exc_Msg
1612: ( G_PKG_NAME ,
1613: 'AP_VENDOR_PARTY_MERGE_PKG.AP_TCA_Contact_Merge'
1614: );
1615: END IF;
1616: FND_MSG_PUB.Count_And_Get
1617: ( p_count => x_msg_count,

Line 1636: END AP_VENDOR_PARTY_MERGE_PKG;

1632:
1633: /* Bug 7297864- End Bug 9639308 End */
1634: END AP_TCA_Contact_Merge;
1635:
1636: END AP_VENDOR_PARTY_MERGE_PKG;