DBA Data[Home] [Help]

APPS.RLM_CUST_MERGE dependencies on ARP_MESSAGE

Line 33: arp_message.set_line('RLM_CUST_MERGE.Merge_RLM()+' || getTimeStamp);

29:
30: BEGIN
31: --
32:
33: arp_message.set_line('RLM_CUST_MERGE.Merge_RLM()+' || getTimeStamp);
34: --
35: --
36: IF Process_Mode <> 'LOCK'
37: THEN

Line 72: arp_message.set_line('RLM_CUST_MERGE.Merge_RLM()-' || getTimeStamp);

68: RLM_CUST_MERGE.Cust_Shipto_Terms(l_duplicateAddressIdTab, l_customerAddressIdTab, l_duplicateIdTab, l_customerIdTab, Req_Id, Set_Num, Process_Mode);
69: --
70: RLM_CUST_MERGE.Cust_Item_Terms(l_duplicateAddressIdTab, l_customerAddressIdTab, l_duplicateIdTab, l_customerIdTab, Req_Id, Set_Num, Process_Mode);
71: --
72: arp_message.set_line('RLM_CUST_MERGE.Merge_RLM()-' || getTimeStamp);
73:
74: END Merge;
75:
76:

Line 122: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Cum_Keys()+' || getTimeStamp );

118: --
119: --
120: BEGIN
121: --
122: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Cum_Keys()+' || getTimeStamp );
123: --
124: IF (process_mode = 'LOCK') THEN
125: --
126: setARMessageLockTable('RLM_CUST_ITEM_CUM_KEYS');

Line 206: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Cum_Keys()-' || getTimeStamp );

202: END IF;
203: --
204: END IF;
205: --
206: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Cum_Keys()-' || getTimeStamp );
207: --
208: EXCEPTION
209: --
210: WHEN OTHERS THEN

Line 212: arp_message.set_error('RLM_CUST_MERGE.Cust_Item_Cum_Keys');

208: EXCEPTION
209: --
210: WHEN OTHERS THEN
211: --
212: arp_message.set_error('RLM_CUST_MERGE.Cust_Item_Cum_Keys');
213: RAISE;
214: --
215: END Cust_Item_Cum_Keys;
216:

Line 266: arp_message.set_line('RLM_CUST_MERGE.Interface_Headers()+' || getTimeStamp);

262: --
263: --
264: BEGIN
265: --
266: arp_message.set_line('RLM_CUST_MERGE.Interface_Headers()+' || getTimeStamp);
267: --
268:
269: IF (process_mode = 'LOCK') THEN
270: --

Line 350: arp_message.set_line('RLM_CUST_MERGE.Interface_Headers()-' || getTimeStamp);

346: END IF;
347: --
348: END IF;
349: --
350: arp_message.set_line('RLM_CUST_MERGE.Interface_Headers()-' || getTimeStamp);
351:
352: EXCEPTION
353: --
354: WHEN OTHERS THEN

Line 356: arp_message.set_error('RLM_CUST_MERGE.Interface_Headers');

352: EXCEPTION
353: --
354: WHEN OTHERS THEN
355: --
356: arp_message.set_error('RLM_CUST_MERGE.Interface_Headers');
357: RAISE;
358: --
359: END Interface_Headers;
360:

Line 412: arp_message.set_line('RLM_CUST_MERGE.Interface_Lines()+' || getTimeStamp);

408: --
409: --
410: BEGIN
411: --
412: arp_message.set_line('RLM_CUST_MERGE.Interface_Lines()+' || getTimeStamp);
413: --
414: IF (process_mode = 'LOCK') THEN
415: --
416: setARMessageLockTable('RLM_INTERFACE_LINES');

Line 518: arp_message.set_line('RLM_CUST_MERGE.Interface_Lines()-' || getTimeStamp);

514: END IF;
515: --
516: END IF;
517: --
518: arp_message.set_line('RLM_CUST_MERGE.Interface_Lines()-' || getTimeStamp);
519: --
520: EXCEPTION
521: --
522: WHEN others THEN

Line 524: arp_message.set_error('RLM_CUST_MERGE.Interface_Lines');

520: EXCEPTION
521: --
522: WHEN others THEN
523: --
524: arp_message.set_error('RLM_CUST_MERGE.Interface_Lines');
525: RAISE;
526: --
527: END Interface_Lines;
528: /*===========================================================================

Line 575: arp_message.set_line('RLM_CUST_MERGE.Schedule_Headers()+' || getTimeStamp);

571: --
572: --
573: BEGIN
574: --
575: arp_message.set_line('RLM_CUST_MERGE.Schedule_Headers()+' || getTimeStamp);
576: --
577: IF (process_mode = 'LOCK') THEN
578: --
579: setARMessageLockTable('RLM_SCHEDULE_HEADERS');

Line 657: arp_message.set_line('RLM_CUST_MERGE.Schedule_Headers()-' || getTimeStamp);

653: END IF;
654: --
655: END IF;
656: --
657: arp_message.set_line('RLM_CUST_MERGE.Schedule_Headers()-' || getTimeStamp);
658:
659: EXCEPTION
660: --
661: WHEN others THEN

Line 663: arp_message.set_error('RLM_CUST_MERGE.Schedule_Headers');

659: EXCEPTION
660: --
661: WHEN others THEN
662: --
663: arp_message.set_error('RLM_CUST_MERGE.Schedule_Headers');
664: RAISE;
665: --
666: END Schedule_Headers;
667:

Line 720: arp_message.set_line('RLM_CUST_MERGE.Schedule_Lines()+' || getTimeStamp);

716: --
717: --
718: BEGIN
719: --
720: arp_message.set_line('RLM_CUST_MERGE.Schedule_Lines()+' || getTimeStamp);
721: --
722: IF (process_mode = 'LOCK') THEN
723: --
724: setARMessageLockTable('RLM_SCHEDULE_LINES');

Line 825: arp_message.set_line('RLM_CUST_MERGE.Schedule_Lines()-' || getTimeStamp);

821: END IF;
822: --
823: END IF;
824: --
825: arp_message.set_line('RLM_CUST_MERGE.Schedule_Lines()-' || getTimeStamp);
826: --
827: EXCEPTION
828: --
829: WHEN OTHERS THEN

Line 831: arp_message.set_error('RLM_CUST_MERGE.Schedule_Lines');

827: EXCEPTION
828: --
829: WHEN OTHERS THEN
830: --
831: arp_message.set_error('RLM_CUST_MERGE.Schedule_Lines');
832: RAISE;
833: --
834: END Schedule_Lines;
835:

Line 907: arp_message.set_line('RLM_CUST_MERGE.Cust_Shipto_Terms()+' || getTimeStamp);

903: --
904: --
905: BEGIN
906: --
907: arp_message.set_line('RLM_CUST_MERGE.Cust_Shipto_Terms()+' || getTimeStamp);
908: --
909: IF (process_mode = 'LOCK') THEN
910: --
911: setARMessageLockTable('RLM_CUST_SHIPTO_TERMS');

Line 1230: arp_message.set_line('RLM_CUST_MERGE.Cust_Shipto_Terms()-' || getTimeStamp);

1226: END IF;
1227: --
1228: END IF;
1229: --
1230: arp_message.set_line('RLM_CUST_MERGE.Cust_Shipto_Terms()-' || getTimeStamp);
1231: --
1232: EXCEPTION
1233: --
1234: WHEN others THEN

Line 1236: arp_message.set_error('RLM_CUST_MERGE.Cust_Shipto_Terms');

1232: EXCEPTION
1233: --
1234: WHEN others THEN
1235: --
1236: arp_message.set_error('RLM_CUST_MERGE.Cust_Shipto_Terms');
1237: RAISE;
1238: --
1239: END Cust_Shipto_Terms;
1240:

Line 1314: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Terms()+' || getTimeStamp);

1310: --
1311: --
1312: BEGIN
1313: --
1314: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Terms()+' || getTimeStamp);
1315: --
1316: IF (process_mode = 'LOCK') THEN
1317: --
1318: setARMessageLockTable('RLM_CUST_ITEM_TERMS');

Line 1610: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Terms()-' || getTimeStamp);

1606: END IF;
1607: --
1608: END IF;
1609: --
1610: arp_message.set_line('RLM_CUST_MERGE.Cust_Item_Terms()-' || getTimeStamp);
1611: --
1612: EXCEPTION
1613: --
1614: WHEN others THEN

Line 1616: arp_message.set_error('RLM_CUST_MERGE.Cust_Item_Terms');

1612: EXCEPTION
1613: --
1614: WHEN others THEN
1615: --
1616: arp_message.set_error('RLM_CUST_MERGE.Cust_Item_Terms');
1617: RAISE;
1618: --
1619: END Cust_Item_Terms;
1620: /*============================================================================

Line 1652: arp_message.set_name('AR','AR_UPDATING_TABLE');

1648: IS
1649: --
1650: BEGIN
1651: --
1652: arp_message.set_name('AR','AR_UPDATING_TABLE');
1653: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
1654: --
1655: EXCEPTION
1656: --

Line 1653: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);

1649: --
1650: BEGIN
1651: --
1652: arp_message.set_name('AR','AR_UPDATING_TABLE');
1653: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
1654: --
1655: EXCEPTION
1656: --
1657: WHEN OTHERS THEN

Line 1673: arp_message.set_name('AR','AR_DELETING_TABLE');

1669: IS
1670: --
1671: BEGIN
1672: --
1673: arp_message.set_name('AR','AR_DELETING_TABLE');
1674: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
1675: --
1676: EXCEPTION
1677: --

Line 1674: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);

1670: --
1671: BEGIN
1672: --
1673: arp_message.set_name('AR','AR_DELETING_TABLE');
1674: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
1675: --
1676: EXCEPTION
1677: --
1678: WHEN OTHERS THEN

Line 1694: arp_message.set_name('AR','AR_LOCKING_TABLE');

1690: IS
1691: --
1692: BEGIN
1693: --
1694: arp_message.set_name('AR','AR_LOCKING_TABLE');
1695: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
1696: --
1697: EXCEPTION
1698: --

Line 1695: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);

1691: --
1692: BEGIN
1693: --
1694: arp_message.set_name('AR','AR_LOCKING_TABLE');
1695: arp_message.set_token('TABLE_NAME', p_tableName, FALSE);
1696: --
1697: EXCEPTION
1698: --
1699: WHEN OTHERS THEN

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

1712: IS
1713: --
1714: BEGIN
1715: --
1716: arp_message.set_name('AR','AR_ROWS_UPDATED');
1717: arp_message.set_token('NUM_ROWS', to_char(p_rowCount));
1718: --
1719: EXCEPTION
1720: --

Line 1717: arp_message.set_token('NUM_ROWS', to_char(p_rowCount));

1713: --
1714: BEGIN
1715: --
1716: arp_message.set_name('AR','AR_ROWS_UPDATED');
1717: arp_message.set_token('NUM_ROWS', to_char(p_rowCount));
1718: --
1719: EXCEPTION
1720: --
1721: WHEN OTHERS THEN

Line 1814: arp_message.set_line(getMessage('RLM_INSTALL_STATUS'));

1810: RETURN TRUE;
1811: --
1812: ELSE
1813: --
1814: arp_message.set_line(getMessage('RLM_INSTALL_STATUS'));
1815: RETURN FALSE;
1816: --
1817: END IF;
1818: --

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

1886: BEGIN
1887: IF process_mode='LOCK' THEN
1888: NULL;
1889: ELSE
1890: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1891: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_CUST_ITEM_CUM_KEYS',FALSE);
1892: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1893:
1894: open merged_records;

Line 1891: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_CUST_ITEM_CUM_KEYS',FALSE);

1887: IF process_mode='LOCK' THEN
1888: NULL;
1889: ELSE
1890: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1891: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_CUST_ITEM_CUM_KEYS',FALSE);
1892: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1893:
1894: open merged_records;
1895: LOOP

Line 1978: arp_message.set_line( 'RLM_CUST_ITEM_CUM_KEYS_LOG');

1974:
1975: END IF;
1976: EXCEPTION
1977: WHEN OTHERS THEN
1978: arp_message.set_line( 'RLM_CUST_ITEM_CUM_KEYS_LOG');
1979: RAISE;
1980: END RLM_CUST_ITEM_CUM_KEYS_LOG;
1981:
1982: PROCEDURE RLM_INTERFACE_HEADERS_LOG (

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

2038: BEGIN
2039: IF process_mode='LOCK' THEN
2040: NULL;
2041: ELSE
2042: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2043: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_HEADERS',FALSE);
2044: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2045:
2046: open merged_records;

Line 2043: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_HEADERS',FALSE);

2039: IF process_mode='LOCK' THEN
2040: NULL;
2041: ELSE
2042: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2043: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_HEADERS',FALSE);
2044: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2045:
2046: open merged_records;
2047: LOOP

Line 2126: arp_message.set_line( 'RLM_INTERFACE_HEADERS_LOG');

2122: END LOOP;
2123: END IF;
2124: EXCEPTION
2125: WHEN OTHERS THEN
2126: arp_message.set_line( 'RLM_INTERFACE_HEADERS_LOG');
2127: RAISE;
2128: END RLM_INTERFACE_HEADERS_LOG;
2129:
2130:

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

2210: BEGIN
2211: IF process_mode='LOCK' THEN
2212: NULL;
2213: ELSE
2214: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2215: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_LINES',FALSE);
2216: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2217:
2218: open merged_records;

Line 2215: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_LINES',FALSE);

2211: IF process_mode='LOCK' THEN
2212: NULL;
2213: ELSE
2214: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2215: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_INTERFACE_LINES',FALSE);
2216: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2217:
2218: open merged_records;
2219: LOOP

Line 2317: arp_message.set_line( 'RLM_INTERFACE_LINES_LOG');

2313:
2314: END IF;
2315: EXCEPTION
2316: WHEN OTHERS THEN
2317: arp_message.set_line( 'RLM_INTERFACE_LINES_LOG');
2318: RAISE;
2319: END RLM_INTERFACE_LINES_LOG;
2320:
2321: PROCEDURE RLM_SCHEDULE_HEADERS_LOG (

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

2377: BEGIN
2378: IF process_mode='LOCK' THEN
2379: NULL;
2380: ELSE
2381: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2382: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_HEADERS',FALSE);
2383: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2384:
2385: open merged_records;

Line 2382: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_HEADERS',FALSE);

2378: IF process_mode='LOCK' THEN
2379: NULL;
2380: ELSE
2381: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2382: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_HEADERS',FALSE);
2383: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2384:
2385: open merged_records;
2386: LOOP

Line 2466: arp_message.set_line( 'RLM_SCHEDULE_HEADERS_LOG');

2462:
2463: END IF;
2464: EXCEPTION
2465: WHEN OTHERS THEN
2466: arp_message.set_line( 'RLM_SCHEDULE_HEADERS_LOG');
2467: RAISE;
2468: END RLM_SCHEDULE_HEADERS_LOG;
2469:
2470:

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

2550: BEGIN
2551: IF process_mode='LOCK' THEN
2552: NULL;
2553: ELSE
2554: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_LINES',FALSE);
2556: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2557:
2558: open merged_records;

Line 2555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_LINES',FALSE);

2551: IF process_mode='LOCK' THEN
2552: NULL;
2553: ELSE
2554: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','RLM_SCHEDULE_LINES',FALSE);
2556: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2557:
2558: open merged_records;
2559: LOOP

Line 2657: arp_message.set_line( 'RLM_SCHEDULE_LINES_LOG');

2653: END IF;
2654: EXCEPTION
2655:
2656: WHEN OTHERS THEN
2657: arp_message.set_line( 'RLM_SCHEDULE_LINES_LOG');
2658: RAISE;
2659: END RLM_SCHEDULE_LINES_LOG;
2660:
2661: /*2447493*/