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 ARP_MESSAGE

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 283: arp_message.set_name('AR','AR_LOCKING_TABLE');

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:
286: OPEN merged_records;
287: CLOSE merged_records;

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 298: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

294: l_msg_string := 'CSI:Processing';
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';

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 1388: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

1384: x_msg_count => l_msg_count,
1385: x_msg_data => l_msg_data);
1386: write_to_cr_log( 'return status :'||l_return_status);
1387: csi_t_gen_utility_pvt.add('return status :'||l_return_status);
1388: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1389: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','return_status'||l_return_status,FALSE);
1390: IF l_return_status <> 'S' Then
1391: write_to_cr_log( 'Msg Count : '||to_char(l_msg_count));
1392: FOR l_msg_ctr in 1..l_msg_count LOOP

Line 1389: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','return_status'||l_return_status,FALSE);

1385: x_msg_data => l_msg_data);
1386: write_to_cr_log( 'return status :'||l_return_status);
1387: csi_t_gen_utility_pvt.add('return status :'||l_return_status);
1388: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1389: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','return_status'||l_return_status,FALSE);
1390: IF l_return_status <> 'S' Then
1391: write_to_cr_log( 'Msg Count : '||to_char(l_msg_count));
1392: FOR l_msg_ctr in 1..l_msg_count LOOP
1393: fnd_msg_pub.get ( l_msg_ctr, FND_API.G_FALSE, l_msg_data, l_msg_dummy );

Line 1431: arp_message.set_name('CSI','CSI_ROWS_UPDATED');

1427: END LOOP; -- } 3 merge records Loop
1428:
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:

Line 1432: arp_message.set_token('NUM_ROWS',to_char(l_count));

1428:
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()-');

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 1442: arp_message.set_error('CRM_MERGE.CUSTOMER_PRODUCTS_MERGE', l_msg_data);

1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: CLOSE merged_records;
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:

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 1525: arp_message.set_name('AR','AR_LOCKING_TABLE');

1521:
1522: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;
1523:
1524: write_to_cr_log( 'Locking the csi_systems_b table' );
1525: arp_message.set_name('AR','AR_LOCKING_TABLE');
1526: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1527:
1528: OPEN merged_records;
1529: CLOSE merged_records;

Line 1526: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);

1522: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;
1523:
1524: write_to_cr_log( 'Locking the csi_systems_b table' );
1525: arp_message.set_name('AR','AR_LOCKING_TABLE');
1526: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1527:
1528: OPEN merged_records;
1529: CLOSE merged_records;
1530:

Line 1537: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

1533: ELSE
1534:
1535: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );
1536:
1537: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1538: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1539: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1540: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1541:

Line 1538: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);

1534:
1535: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );
1536:
1537: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1538: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1539: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1540: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1541:
1542: OPEN merged_records;

Line 1833: arp_message.set_token('NUM_ROWS',to_char(no_of_rows));

1829: EXIT;
1830: END IF;
1831:
1832: no_of_rows := sql%rowcount;
1833: arp_message.set_token('NUM_ROWS',to_char(no_of_rows));
1834: arp_message.set_line( 'Done with the insert of systems history' );
1835:
1836: END LOOP; -- } End merged records loop
1837:

Line 1834: arp_message.set_line( 'Done with the insert of systems history' );

1830: END IF;
1831:
1832: no_of_rows := sql%rowcount;
1833: arp_message.set_token('NUM_ROWS',to_char(no_of_rows));
1834: arp_message.set_line( 'Done with the insert of systems history' );
1835:
1836: END LOOP; -- } End merged records loop
1837:
1838: CLOSE merged_records;

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 1917: arp_message.set_name('AR','AR_LOCKING_TABLE');

1913: IF (process_mode = 'LOCK') THEN
1914:
1915: write_to_cr_log( 'Locking the csi_t_party_accounts' );
1916:
1917: arp_message.set_name('AR','AR_LOCKING_TABLE');
1918: arp_message.set_token('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1919:
1920: OPEN merged_records;
1921: CLOSE merged_records;

Line 1918: arp_message.set_token('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);

1914:
1915: write_to_cr_log( 'Locking the csi_t_party_accounts' );
1916:
1917: arp_message.set_name('AR','AR_LOCKING_TABLE');
1918: arp_message.set_token('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1919:
1920: OPEN merged_records;
1921: CLOSE merged_records;
1922:

Line 1927: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

1923: write_to_cr_log( 'Done Locking the csi_t_party_accounts' );
1924: ELSE
1925: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1926:
1927: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1928: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1929: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1930: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1931:

Line 1928: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);

1924: ELSE
1925: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1926:
1927: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1928: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1929: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1930: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1931:
1932: OPEN merged_records;

Line 2025: arp_message.set_name('AR','AR_ROWS_UPDATED');

2021: END LOOP;
2022:
2023: CLOSE merged_records;
2024:
2025: arp_message.set_name('AR','AR_ROWS_UPDATED');
2026: arp_message.set_token('NUM_ROWS',to_char(l_count));
2027: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );
2028:
2029: END IF;

Line 2026: arp_message.set_token('NUM_ROWS',to_char(l_count));

2022:
2023: CLOSE merged_records;
2024:
2025: arp_message.set_name('AR','AR_ROWS_UPDATED');
2026: arp_message.set_token('NUM_ROWS',to_char(l_count));
2027: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );
2028:
2029: END IF;
2030:

Line 2027: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );

2023: CLOSE merged_records;
2024:
2025: arp_message.set_name('AR','AR_ROWS_UPDATED');
2026: arp_message.set_token('NUM_ROWS',to_char(l_count));
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()-');

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 2114: arp_message.set_name('AR','AR_LOCKING_TABLE');

2110:
2111: IF (process_mode = 'LOCK') THEN
2112: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2113:
2114: arp_message.set_name('AR','AR_LOCKING_TABLE');
2115: arp_message.set_token('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2116:
2117: OPEN merged_records;
2118: CLOSE merged_records;

Line 2115: arp_message.set_token('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);

2111: IF (process_mode = 'LOCK') THEN
2112: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2113:
2114: arp_message.set_name('AR','AR_LOCKING_TABLE');
2115: arp_message.set_token('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2116:
2117: OPEN merged_records;
2118: CLOSE merged_records;
2119:

Line 2122: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

2118: CLOSE merged_records;
2119:
2120: write_to_cr_log( 'Done Locking the CSI_T_TXN_SYSTEMS table' );
2121: ELSE
2122: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2123: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2124: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2125: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2126:

Line 2123: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);

2119:
2120: write_to_cr_log( 'Done Locking the CSI_T_TXN_SYSTEMS table' );
2121: ELSE
2122: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2123: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2124: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2125: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2126:
2127: OPEN merged_records;

Line 2222: arp_message.set_name('AR','AR_ROWS_UPDATED');

2218: END LOOP;
2219:
2220: CLOSE merged_records;
2221:
2222: arp_message.set_name('AR','AR_ROWS_UPDATED');
2223: arp_message.set_token('NUM_ROWS',to_char(l_count));
2224: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );
2225:
2226: END IF;

Line 2223: arp_message.set_token('NUM_ROWS',to_char(l_count));

2219:
2220: CLOSE merged_records;
2221:
2222: arp_message.set_name('AR','AR_ROWS_UPDATED');
2223: arp_message.set_token('NUM_ROWS',to_char(l_count));
2224: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );
2225:
2226: END IF;
2227:

Line 2224: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );

2220: CLOSE merged_records;
2221:
2222: arp_message.set_name('AR','AR_ROWS_UPDATED');
2223: arp_message.set_token('NUM_ROWS',to_char(l_count));
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()-');

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 2240: arp_message.set_line( p_message );

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:
2244: END CSI_ACCT_MERGE_PKG;