DBA Data[Home] [Help]

APPS.CSI_PARTY_MERGE_PKG dependencies on CSI_PARTY_MERGE_PKG

Line 1: PACKAGE BODY CSI_PARTY_MERGE_PKG AS

1: PACKAGE BODY CSI_PARTY_MERGE_PKG AS
2: /* $Header: csipymgb.pls 120.3 2010/05/27 18:14:50 devijay ship $ */
3:
4: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSI_PARTY_MERGE_PKG';
5: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;

Line 4: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSI_PARTY_MERGE_PKG';

1: PACKAGE BODY CSI_PARTY_MERGE_PKG AS
2: /* $Header: csipymgb.pls 120.3 2010/05/27 18:14:50 devijay ship $ */
3:
4: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSI_PARTY_MERGE_PKG';
5: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
6: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.LOGIN_ID;
7:
8: PROCEDURE CSI_ITEM_INSTANCES_MERGE(

Line 56: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');

52: txn_type_not_found_error EXCEPTION;
53: RESOURCE_BUSY EXCEPTION;
54: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
55: BEGIN
56: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
57:
58: csi_t_gen_utility_pvt.g_debug_level := 10;
59: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csipartymeg',
60: p_file_segment2 => TO_CHAR(SYSDATE, 'mmddyy'));

Line 62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');

58: csi_t_gen_utility_pvt.g_debug_level := 10;
59: csi_t_gen_utility_pvt.build_file_name( p_file_segment1 => 'csipartymeg',
60: p_file_segment2 => TO_CHAR(SYSDATE, 'mmddyy'));
61:
62: csi_t_gen_utility_pvt.ADD('InsideCSI_PARTY_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE ');
63: csi_t_gen_utility_pvt.ADD('Entity_name '|| p_entity_name);
64: csi_t_gen_utility_pvt.ADD ('From ID '||p_from_id);
65: csi_t_gen_utility_pvt.ADD('From FK ID '|| p_from_fk_id);
66: csi_t_gen_utility_pvt.ADD(' To FK ID'||p_to_fk_id);

Line 401: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');

397:
398: RESOURCE_BUSY EXCEPTION;
399: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
400: BEGIN
401: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');
402:
403: csi_t_gen_utility_pvt.ADD('Inside CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE');
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 403: csi_t_gen_utility_pvt.ADD('Inside CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE');

399: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
400: BEGIN
401: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE()+');
402:
403: csi_t_gen_utility_pvt.ADD('Inside CSI_PARTY_MERGE_PKG.CSI_I_PARTIES_MERGE');
404:
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406:
407: begin

Line 647: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');

643: RESOURCE_BUSY EXCEPTION;
644: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
645:
646: BEGIN
647: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
648:
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650:
651: begin

Line 963: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');

959: RESOURCE_BUSY EXCEPTION;
960: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
961:
962: BEGIN
963: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
964:
965: x_return_status := FND_API.G_RET_STS_SUCCESS;
966:
967: begin

Line 1116: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_PARTY_DETAILS_MERGE()+');

1112:
1113: RESOURCE_BUSY EXCEPTION;
1114: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1115: BEGIN
1116: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_PARTY_DETAILS_MERGE()+');
1117:
1118: x_return_status := FND_API.G_RET_STS_SUCCESS;
1119:
1120: begin

Line 1243: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_LINE_DETAILS_MERGE()+');

1239:
1240: RESOURCE_BUSY EXCEPTION;
1241: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1242: BEGIN
1243: arp_message.set_line('CSI_PARTY_MERGE_PKG.CSI_T_TXN_LINE_DETAILS_MERGE()+');
1244:
1245: x_return_status := FND_API.G_RET_STS_SUCCESS;
1246:
1247: select merge_reason_code

Line 1306: END CSI_PARTY_MERGE_PKG;

1302: END;
1303: END IF;
1304: END CSI_T_TXN_LINE_DETAILS_MERGE;
1305:
1306: END CSI_PARTY_MERGE_PKG;