eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.7 2011/06/13 08:07:13 kdurgasi 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 275: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()+');

271: p_file_segment1 => 'csictmgr',
272: p_file_segment2 => to_char(sysdate, 'mmddyy'));
273: csi_t_gen_utility_pvt.add('Inside csi_ip_accounts_merge');
274: error_str := '001';
275: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()+');
276:
277: IF (process_mode = 'LOCK') THEN -- {2
278:
279: csi_t_gen_utility_pvt.add('Locking the csi_ip_accounts table');

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

1432: arp_message.set_token('NUM_ROWS',to_char(l_count));
1433: arp_message.set_line( 'Done with the update of CSI_IP_ACCOUNTS' );
1434: END IF; -- } 2
1435:
1436: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_IP_ACCOUNTS_MERGE()-');
1437:
1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: CLOSE merged_records;

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

1514: I NUMBER;
1515: v_system_history_id NUMBER;
1516: BEGIN
1517:
1518: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
1519:
1520: IF (process_mode = 'LOCK') THEN
1521:
1522: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;

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

1838: CLOSE merged_records;
1839:
1840: END IF;
1841:
1842: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1843:
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');

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

1842: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1843:
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1847: CLOSE merged_records;
1848: raise;
1849: END csi_systems_b_merge;
1850:

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

1907: AND m.set_number = set_num;
1908:
1909: BEGIN
1910:
1911: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()+');
1912:
1913: IF (process_mode = 'LOCK') THEN
1914:
1915: write_to_cr_log( 'Locking the csi_t_party_accounts' );

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

2027: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );
2028:
2029: END IF;
2030:
2031: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2032:
2033: EXCEPTION
2034: WHEN OTHERS THEN
2035: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

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

2031: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2032:
2033: EXCEPTION
2034: WHEN OTHERS THEN
2035: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2036: CLOSE merged_records;
2037: raise;
2038: END csi_t_party_accounts_merge;
2039:

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

2105: AND m.set_number = set_num;
2106:
2107: BEGIN
2108:
2109: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
2110:
2111: IF (process_mode = 'LOCK') THEN
2112: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2113:

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

2224: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );
2225:
2226: END IF;
2227:
2228: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2229:
2230: EXCEPTION
2231: WHEN OTHERS THEN
2232: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

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

2228: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2229:
2230: EXCEPTION
2231: WHEN OTHERS THEN
2232: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2233: CLOSE merged_records;
2234: raise;
2235: END csi_t_txn_systems_merge;
2236:

Line 2239: IF csi_acct_merge_pkg.g_debug_on > 0 THEN

2235: END csi_t_txn_systems_merge;
2236:
2237: PROCEDURE write_to_cr_log ( p_message IN VARCHAR2) IS
2238: BEGIN
2239: IF csi_acct_merge_pkg.g_debug_on > 0 THEN
2240: arp_message.set_line( p_message );
2241: END IF;
2242: END write_to_cr_log;
2243:

Line 2244: END CSI_ACCT_MERGE_PKG;

2240: arp_message.set_line( p_message );
2241: END IF;
2242: END write_to_cr_log;
2243:
2244: END CSI_ACCT_MERGE_PKG;