APPS.CS_CH_PARTY_MERGE_PKG dependencies on CS_CH_PARTY_MERGE_PKG

Line 1: PACKAGE BODY CS_CH_PARTY_MERGE_PKG AS

1: PACKAGE BODY CS_CH_PARTY_MERGE_PKG AS
2: /* $Header: cschmpgb.pls 120.0 2006/02/09 16:38:32 spusegao noship $ */
3:
4: -- Start of Comments
5: -- Package name : CS_CH_PARTY_MERGE_PKG

Line 5: -- Package name : CS_CH_PARTY_MERGE_PKG

1: PACKAGE BODY CS_CH_PARTY_MERGE_PKG AS
2: /* $Header: cschmpgb.pls 120.0 2006/02/09 16:38:32 spusegao noship $ */
3:
4: -- Start of Comments
5: -- Package name : CS_CH_PARTY_MERGE_PKG
6: -- Purpose : Merges duplicate party_sites in Service tables. The
7: -- Service tables that need to be considered
8: -- are:
9: -- CS_ESTIMATE_DETAILS and CS_CHG_SUB_RESTRICTIONS.

Line 26: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CS_CH_PARTY_MERGE_PKG';

22: -- 04-28-2004 mviswana Added logic to check for duplicate active restrictions after the merge is done
23: -- Fix for Bug # 3599517
24: -- End of Comments
25:
26: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CS_CH_PARTY_MERGE_PKG';
27: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cschpmgb.pls';
28: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
29: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.CONC_LOGIN_ID;
30:

Line 74: arp_message.set_line('CS_CH_PARTY_MERGE_PKG.CS_CH_ALL_MERGE_SITE_ID()+');

70: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
71:
72: BEGIN
73:
74: arp_message.set_line('CS_CH_PARTY_MERGE_PKG.CS_CH_ALL_MERGE_SITE_ID()+');
75:
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77:
78: select merge_reason_code

Line 192: arp_message.set_line('CS_CH_PARTY_MERGE_PKG.CS_CH_ALL_MERGE_SITE_ID()+');

188: RESOURCE_BUSY EXCEPTION;
189: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
190:
191: BEGIN
192: arp_message.set_line('CS_CH_PARTY_MERGE_PKG.CS_CH_ALL_MERGE_SITE_ID()+');
193:
194: x_return_status := FND_API.G_RET_STS_SUCCESS;
195:
196: select merge_reason_code

Line 342: arp_message.set_line('CS_CH_PARTY_MERGE_PKG.CS_CHG_ALL_SETUP_PARTY()+');

338: RESOURCE_BUSY EXCEPTION;
339: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
340:
341: BEGIN
342: arp_message.set_line('CS_CH_PARTY_MERGE_PKG.CS_CHG_ALL_SETUP_PARTY()+');
343:
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345:
346:

Line 441: END CS_CH_PARTY_MERGE_PKG;

437:
438:
439:
440:
441: END CS_CH_PARTY_MERGE_PKG;