DBA Data[Home] [Help]

APPS.CSI_ACCT_MERGE_PKG dependencies on CSI_ACCT_MERGE_PKG

Line 1: PACKAGE BODY CSI_ACCT_MERGE_PKG AS

1: PACKAGE BODY CSI_ACCT_MERGE_PKG AS
2: /* $Header: csiatmgb.pls 120.4 2008/05/28 08:33:20 jgootyag ship $ */
3: PROCEDURE write_to_cr_log ( p_message IN VARCHAR2);
4:
5: PROCEDURE MERGE( req_id IN NUMBER,

Line 13: arp_message.set_line('CSI_ACCT_MERGE_PKG.MERGE()+');

9: error_str VARCHAR2(3);
10: no_of_rows NUMBER;
11: BEGIN
12:
13: arp_message.set_line('CSI_ACCT_MERGE_PKG.MERGE()+');
14: /*
15: error_str := '001';
16: write_to_cr_log( ' Processing Item Instances Merge ' );
17: CSI_ITEM_INSTANCES_MERGE(req_id, set_num, process_mode);

Line 41: arp_message.set_line('CSI_ACCT_MERGE_PKG.MERGE()-');

37: CSI_T_TXN_SYSTEMS_MERGE(req_id, set_num, process_mode);
38: write_to_cr_log( ' Ending process for CSI Transaction Systems Merge ' );
39: */
40:
41: arp_message.set_line('CSI_ACCT_MERGE_PKG.MERGE()-');
42:
43: EXCEPTION
44: WHEN OTHERS THEN
45: arp_message.set_line( 'CSI_ACCT_MERGE_PKG.MERGE()-');

Line 45: arp_message.set_line( 'CSI_ACCT_MERGE_PKG.MERGE()-');

41: arp_message.set_line('CSI_ACCT_MERGE_PKG.MERGE()-');
42:
43: EXCEPTION
44: WHEN OTHERS THEN
45: arp_message.set_line( 'CSI_ACCT_MERGE_PKG.MERGE()-');
46: RAISE;
47: END MERGE;
48:
49: PROCEDURE csi_item_instances_merge( req_id IN NUMBER,

Line 53: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');

49: PROCEDURE csi_item_instances_merge( req_id IN NUMBER,
50: set_num IN NUMBER,
51: process_mode IN VARCHAR2 ) IS
52: BEGIN
53: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
54: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()-');
55: EXCEPTION
56: WHEN OTHERS THEN
57: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()');

Line 54: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()-');

50: set_num IN NUMBER,
51: process_mode IN VARCHAR2 ) IS
52: BEGIN
53: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
54: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()-');
55: EXCEPTION
56: WHEN OTHERS THEN
57: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()');
58: RAISE;

Line 57: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()');

53: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()+');
54: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()-');
55: EXCEPTION
56: WHEN OTHERS THEN
57: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_ITEM_INSTANCES_MERGE()');
58: RAISE;
59: END CSI_ITEM_INSTANCES_MERGE;
60:
61: PROCEDURE csi_ip_accounts_merge( req_id IN NUMBER,

Line 244: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()+');

240:
241: BEGIN -- {1
242:
243: error_str := '001';
244: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()+');
245:
246: IF (process_mode = 'LOCK') THEN -- {2
247:
248: error_str := '002';

Line 1405: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()-');

1401: arp_message.set_token('NUM_ROWS',to_char(l_count));
1402: arp_message.set_line( 'Done with the update of CSI_IP_ACCOUNTS' );
1403: END IF; -- } 2
1404:
1405: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()-');
1406:
1407: EXCEPTION
1408: WHEN OTHERS THEN
1409: CLOSE merged_records;

Line 1486: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');

1482: I NUMBER;
1483: v_system_history_id NUMBER;
1484: BEGIN
1485:
1486: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
1487:
1488: IF (process_mode = 'LOCK') THEN
1489:
1490: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;

Line 1810: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');

1806: CLOSE merged_records;
1807:
1808: END IF;
1809:
1810: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1811:
1812: EXCEPTION
1813: WHEN OTHERS THEN
1814: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');

Line 1814: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');

1810: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1811:
1812: EXCEPTION
1813: WHEN OTHERS THEN
1814: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1815: CLOSE merged_records;
1816: raise;
1817: END csi_systems_b_merge;
1818:

Line 1879: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()+');

1875: AND m.set_number = set_num;
1876:
1877: BEGIN
1878:
1879: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()+');
1880:
1881: IF (process_mode = 'LOCK') THEN
1882:
1883: write_to_cr_log( 'Locking the csi_t_party_accounts' );

Line 1999: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

1995: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );
1996:
1997: END IF;
1998:
1999: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2000:
2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

Line 2003: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

1999: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2000:
2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2004: CLOSE merged_records;
2005: raise;
2006: END csi_t_party_accounts_merge;
2007:

Line 2077: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');

2073: AND m.set_number = set_num;
2074:
2075: BEGIN
2076:
2077: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
2078:
2079: IF (process_mode = 'LOCK') THEN
2080: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2081:

Line 2196: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

2192: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );
2193:
2194: END IF;
2195:
2196: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2197:
2198: EXCEPTION
2199: WHEN OTHERS THEN
2200: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

Line 2200: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

2196: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2197:
2198: EXCEPTION
2199: WHEN OTHERS THEN
2200: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2201: CLOSE merged_records;
2202: raise;
2203: END csi_t_txn_systems_merge;
2204:

Line 2207: IF csi_acct_merge_pkg.g_debug_on > 0 THEN

2203: END csi_t_txn_systems_merge;
2204:
2205: PROCEDURE write_to_cr_log ( p_message IN VARCHAR2) IS
2206: BEGIN
2207: IF csi_acct_merge_pkg.g_debug_on > 0 THEN
2208: arp_message.set_line( p_message );
2209: END IF;
2210: END write_to_cr_log;
2211:

Line 2212: END CSI_ACCT_MERGE_PKG;

2208: arp_message.set_line( p_message );
2209: END IF;
2210: END write_to_cr_log;
2211:
2212: END CSI_ACCT_MERGE_PKG;