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_IP_ACCOUNTS

Line 27: CSI_IP_ACCOUNTS_MERGE(req_id, set_num, process_mode);

23: write_to_cr_log( ' Ending process for Systems All ' );
24:
25: error_str := '003';
26: write_to_cr_log( ' Processing IP Accounts Merge ' );
27: CSI_IP_ACCOUNTS_MERGE(req_id, set_num, process_mode);
28: write_to_cr_log( ' Ending process for IP Accounts Merge ' );
29:
30: error_str := '004';
31: write_to_cr_log( ' Processing Party Accounts Merge ' );

Line 61: PROCEDURE csi_ip_accounts_merge( req_id IN NUMBER,

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,
62: set_num IN NUMBER,
63: process_mode IN VARCHAR2 ) IS
64:
65: error_str VARCHAR2(3);

Line 94: CSI_IP_ACCOUNTS.IP_ACCOUNT_ID%TYPE

90:
91: INSTALL_CUSTOMER_SITE_ID_LIST CUSTOMER_SITE_ID_LIST_TYPE;
92:
93: TYPE IP_ACCOUNT_ID_LIST_TYPE IS TABLE OF
94: CSI_IP_ACCOUNTS.IP_ACCOUNT_ID%TYPE
95: INDEX BY BINARY_INTEGER;
96:
97: PRIMARY_KEY_ID_LIST IP_ACCOUNT_ID_LIST_TYPE;
98:

Line 100: CSI_IP_ACCOUNTS.PARTY_ACCOUNT_ID%TYPE

96:
97: PRIMARY_KEY_ID_LIST IP_ACCOUNT_ID_LIST_TYPE;
98:
99: TYPE PARTY_ACCT_ID_LIST_TYPE IS TABLE OF
100: CSI_IP_ACCOUNTS.PARTY_ACCOUNT_ID%TYPE
101: INDEX BY BINARY_INTEGER;
102:
103: NUM_COL1_ORIG_LIST PARTY_ACCT_ID_LIST_TYPE;
104: NUM_COL1_NEW_LIST PARTY_ACCT_ID_LIST_TYPE;

Line 124: CSI_IP_ACCOUNTS.BILL_TO_ADDRESS%TYPE

120: INDEX BY BINARY_INTEGER;
121:
122: ORG_ID_LIST ORG_ID_LIST_TYPE;
123: TYPE BILL_TO_ADDRESS_LIST_TYPE IS TABLE OF
124: CSI_IP_ACCOUNTS.BILL_TO_ADDRESS%TYPE
125: INDEX BY BINARY_INTEGER;
126:
127: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_LIST_TYPE;
128: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_LIST_TYPE;

Line 131: CSI_IP_ACCOUNTS.SHIP_TO_ADDRESS%TYPE

127: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_LIST_TYPE;
128: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_LIST_TYPE;
129:
130: TYPE SHIP_TO_ADDRESS_LIST_TYPE IS TABLE OF
131: CSI_IP_ACCOUNTS.SHIP_TO_ADDRESS%TYPE
132: INDEX BY BINARY_INTEGER;
133:
134: NUM_COL3_ORIG_LIST SHIP_TO_ADDRESS_LIST_TYPE;
135: NUM_COL3_NEW_LIST SHIP_TO_ADDRESS_LIST_TYPE;

Line 171: FROM CSI_IP_ACCOUNTS YT

167: , YT.SHIP_TO_ADDRESS
168: , CIP.INSTANCE_PARTY_ID
169: , CIP.INSTANCE_ID
170: , cii.last_vld_organization_id
171: FROM CSI_IP_ACCOUNTS YT
172: , CSI_I_PARTIES CIP
173: , CSI_ITEM_INSTANCES CII
174: , RA_CUSTOMER_MERGES M
175: WHERE (YT.BILL_TO_ADDRESS = M.DUPLICATE_SITE_ID OR

Line 194: FROM CSI_IP_ACCOUNTS YT

190: , CIP.INSTANCE_PARTY_ID
191: , CIP.INSTANCE_ID
192: , cii.last_vld_organization_id
193:
194: FROM CSI_IP_ACCOUNTS YT
195: , CSI_I_PARTIES CIP
196: , CSI_ITEM_INSTANCES CII
197: , (SELECT DISTINCT M2.CUSTOMER_MERGE_HEADER_ID
198: ,M2.DUPLICATE_ID

Line 273: csi_t_gen_utility_pvt.add('Inside csi_ip_accounts_merge');

269: csi_t_gen_utility_pvt.g_debug_level := 10;
270: csi_t_gen_utility_pvt.build_file_name(
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

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 279: csi_t_gen_utility_pvt.add('Locking the csi_ip_accounts table');

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');
280: error_str := '002';
281: write_to_cr_log( 'Locking the csi_ip_accounts table' );
282:
283: arp_message.set_name('AR','AR_LOCKING_TABLE');

Line 281: write_to_cr_log( 'Locking the csi_ip_accounts table' );

277: IF (process_mode = 'LOCK') THEN -- {2
278:
279: csi_t_gen_utility_pvt.add('Locking the csi_ip_accounts table');
280: error_str := '002';
281: write_to_cr_log( 'Locking the csi_ip_accounts table' );
282:
283: arp_message.set_name('AR','AR_LOCKING_TABLE');
284: arp_message.set_token('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);
285:

Line 284: arp_message.set_token('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);

280: error_str := '002';
281: write_to_cr_log( 'Locking the csi_ip_accounts table' );
282:
283: arp_message.set_name('AR','AR_LOCKING_TABLE');
284: arp_message.set_token('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);
285:
286: OPEN merged_records;
287: CLOSE merged_records;
288:

Line 289: write_to_cr_log( 'Done Locking the csi_ip_accounts table' );

285:
286: OPEN merged_records;
287: CLOSE merged_records;
288:
289: write_to_cr_log( 'Done Locking the csi_ip_accounts table' );
290:
291: ELSE -- } 2 {
292:
293: csi_t_gen_utility_pvt.add('CSI: Processing');

Line 299: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);

295: write_to_cr_log( l_msg_string );
296:
297: error_str := '003';
298: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
299: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_IP_ACCOUNTS',FALSE);
300: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
301:
302: error_str := '004';
303: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

Line 490: 'CSI_IP_ACCOUNTS' ,

486: )
487: VALUES
488: (
489: HZ_CUSTOMER_MERGE_LOG_s.nextval ,
490: 'CSI_IP_ACCOUNTS' ,
491: MERGE_HEADER_ID_LIST(I) ,
492: PRIMARY_KEY_ID_LIST(I) ,
493: NUM_COL1_ORIG_LIST(I) ,
494: NUM_COL1_NEW_LIST(I) ,

Line 550: -- Get the account_id from csi_ip_accounts

546: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP -- {
547: csi_t_gen_utility_pvt.add('processing next record from the cursor');
548: l_msg_string := 'CSI:------->processing next record from the cursor...';
549: write_to_cr_log( l_msg_string );
550: -- Get the account_id from csi_ip_accounts
551: error_str := '008';
552: SELECT party_account_id, bill_to_address, ship_to_address
553: INTO l_party_account_id, l_bill_to_address, l_ship_to_address
554: FROM csi_ip_accounts

Line 554: FROM csi_ip_accounts

550: -- Get the account_id from csi_ip_accounts
551: error_str := '008';
552: SELECT party_account_id, bill_to_address, ship_to_address
553: INTO l_party_account_id, l_bill_to_address, l_ship_to_address
554: FROM csi_ip_accounts
555: WHERE ip_account_id = PRIMARY_KEY_ID_LIST(I);
556:
557: l_msg_string := 'CSI : primary_key_id_list(i), l_party_account_Id , l_bill_to_address, l_ship_to_address :'
558: || to_char(primary_key_id_list(i)) || '<>'

Line 1433: arp_message.set_line( 'Done with the update of CSI_IP_ACCOUNTS' );

1429: CLOSE merged_records;
1430:
1431: arp_message.set_name('CSI','CSI_ROWS_UPDATED');
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:

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 1445: END csi_ip_accounts_merge; -- } 1

1441: l_msg_data := error_str || '-' || l_msg_data;
1442: arp_message.set_error('CRM_MERGE.CUSTOMER_PRODUCTS_MERGE', l_msg_data);
1443: csi_t_gen_utility_pvt.add('In others :'||l_msg_data||'-'||SQLERRM );
1444: RAISE;
1445: END csi_ip_accounts_merge; -- } 1
1446:
1447: PROCEDURE csi_systems_b_merge(req_id IN NUMBER,
1448: set_num IN NUMBER,
1449: process_mode IN VARCHAR2) IS