DBA Data[Home] [Help]

APPS.RLM_CUST_MERGE dependencies on RLM_CUST_MERGE

Line 1: PACKAGE BODY RLM_CUST_MERGE AS

1: PACKAGE BODY RLM_CUST_MERGE AS
2: /* $Header: RLMCMRGB.pls 120.1 2005/07/17 18:24:51 rlanka noship $ */
3:
4: --
5: --

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 51: IF NOT( RLM_CUST_MERGE.IS_RLM_INSTALLED() )

47: AND set_number = Set_Num;
48: END IF;
49: --
50: --
51: IF NOT( RLM_CUST_MERGE.IS_RLM_INSTALLED() )
52: THEN
53: RETURN;
54: END IF;
55: --

Line 58: RLM_CUST_MERGE.Cust_Item_Cum_Keys(Req_Id, Set_Num, Process_Mode);

54: END IF;
55: --
56: /* Calls to other internal procedures for customer Merge */
57: --
58: RLM_CUST_MERGE.Cust_Item_Cum_Keys(Req_Id, Set_Num, Process_Mode);
59: --
60: RLM_CUST_MERGE.Interface_Lines(Req_Id, Set_Num, Process_Mode);
61: --
62: RLM_CUST_MERGE.Interface_Headers(Req_Id, Set_Num, Process_Mode);

Line 60: RLM_CUST_MERGE.Interface_Lines(Req_Id, Set_Num, Process_Mode);

56: /* Calls to other internal procedures for customer Merge */
57: --
58: RLM_CUST_MERGE.Cust_Item_Cum_Keys(Req_Id, Set_Num, Process_Mode);
59: --
60: RLM_CUST_MERGE.Interface_Lines(Req_Id, Set_Num, Process_Mode);
61: --
62: RLM_CUST_MERGE.Interface_Headers(Req_Id, Set_Num, Process_Mode);
63: --
64: RLM_CUST_MERGE.Schedule_Lines(Req_Id, Set_Num, Process_Mode);

Line 62: RLM_CUST_MERGE.Interface_Headers(Req_Id, Set_Num, Process_Mode);

58: RLM_CUST_MERGE.Cust_Item_Cum_Keys(Req_Id, Set_Num, Process_Mode);
59: --
60: RLM_CUST_MERGE.Interface_Lines(Req_Id, Set_Num, Process_Mode);
61: --
62: RLM_CUST_MERGE.Interface_Headers(Req_Id, Set_Num, Process_Mode);
63: --
64: RLM_CUST_MERGE.Schedule_Lines(Req_Id, Set_Num, Process_Mode);
65: --
66: RLM_CUST_MERGE.Schedule_Headers(Req_Id, Set_Num, Process_Mode);

Line 64: RLM_CUST_MERGE.Schedule_Lines(Req_Id, Set_Num, Process_Mode);

60: RLM_CUST_MERGE.Interface_Lines(Req_Id, Set_Num, Process_Mode);
61: --
62: RLM_CUST_MERGE.Interface_Headers(Req_Id, Set_Num, Process_Mode);
63: --
64: RLM_CUST_MERGE.Schedule_Lines(Req_Id, Set_Num, Process_Mode);
65: --
66: RLM_CUST_MERGE.Schedule_Headers(Req_Id, Set_Num, Process_Mode);
67: --
68: RLM_CUST_MERGE.Cust_Shipto_Terms(l_duplicateAddressIdTab, l_customerAddressIdTab, l_duplicateIdTab, l_customerIdTab, Req_Id, Set_Num, Process_Mode);

Line 66: RLM_CUST_MERGE.Schedule_Headers(Req_Id, Set_Num, Process_Mode);

62: RLM_CUST_MERGE.Interface_Headers(Req_Id, Set_Num, Process_Mode);
63: --
64: RLM_CUST_MERGE.Schedule_Lines(Req_Id, Set_Num, Process_Mode);
65: --
66: RLM_CUST_MERGE.Schedule_Headers(Req_Id, Set_Num, Process_Mode);
67: --
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);

Line 68: RLM_CUST_MERGE.Cust_Shipto_Terms(l_duplicateAddressIdTab, l_customerAddressIdTab, l_duplicateIdTab, l_customerIdTab, Req_Id, Set_Num, Process_Mode);

64: RLM_CUST_MERGE.Schedule_Lines(Req_Id, Set_Num, Process_Mode);
65: --
66: RLM_CUST_MERGE.Schedule_Headers(Req_Id, Set_Num, Process_Mode);
67: --
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);

Line 70: RLM_CUST_MERGE.Cust_Item_Terms(l_duplicateAddressIdTab, l_customerAddressIdTab, l_duplicateIdTab, l_customerIdTab, Req_Id, Set_Num, Process_Mode);

66: RLM_CUST_MERGE.Schedule_Headers(Req_Id, Set_Num, Process_Mode);
67: --
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;

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 2663: END RLM_CUST_MERGE;

2659: END RLM_SCHEDULE_LINES_LOG;
2660:
2661: /*2447493*/
2662:
2663: END RLM_CUST_MERGE;