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.OE_CUST_MERGE dependencies on OE_CUST_MERGE

Line 1: PACKAGE BODY OE_CUST_MERGE AS

1: PACKAGE BODY OE_CUST_MERGE AS
2: /* $Header: OEXCMOEB.pls 120.17.12020000.2 2012/07/03 09:49:11 amallik ship $ */
3:
4: /*---------------------------- PRIVATE VARIABLES ----------------------------*/
5:

Line 191: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS H

187: H.INVOICE_TO_ORG_ID, H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
188: H.SOLD_TO_SITE_USE_ID, H.END_CUSTOMER_SITE_USE_ID,
189: H.END_CUSTOMER_ID,'N',M1.CUSTOMER_MERGE_ID
190: FROM
191: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS H
192: WHERE H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
193: AND M1.PROCESS_FLAG='N'
194: AND M1.REQUEST_ID = req_id
195: AND M1.SET_NUMBER = set_num

Line 263: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS H

259: H.INVOICE_TO_ORG_ID, H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
260: H.SOLD_TO_SITE_USE_ID, H.END_CUSTOMER_SITE_USE_ID,
261: H.END_CUSTOMER_ID,'N',M1.CUSTOMER_MERGE_ID
262: FROM
263: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS H
264: WHERE H.END_CUSTOMER_ID= M1.DUPLICATE_ID
265: AND M1.PROCESS_FLAG='N'
266: AND M1.REQUEST_ID = req_id
267: AND M1.SET_NUMBER = set_num;

Line 303: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers()+' );

299: l_global_count number :=0;
300:
301: BEGIN
302:
303: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers()+' );
304:
305: IF (process_mode = 'LOCK') THEN
306:
307: -- try to open table for update, if it fails the exception will

Line 337: INSERT INTO OE_CUST_MERGES_GTT(duplicate_id,request_id,set_number,process_flag,customer_merge_id)

333:
334: -- GTT insertion , bug 8883694 ,9349882 ,9558975
335: IF l_run_parallel_query = 'N' THEN
336: ----bug 8883694,9349882 Inserting unique duplicate_id into GTT for a request .
337: INSERT INTO OE_CUST_MERGES_GTT(duplicate_id,request_id,set_number,process_flag,customer_merge_id)
338: SELECT duplicate_id,request_id,set_number,process_flag, customer_merge_id
339: FROM RA_CUSTOMER_MERGES M1
340: WHERE M1.PROCESS_FLAG='N'
341: AND M1.REQUEST_ID = req_id

Line 475: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers():3' );

471:
472:
473: end loop;
474: end if;
475: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers():3' );
476: --insert audit information for customer merge
477: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
478: IF hdr_header_id_tab.COUNT <> 0 THEN
479: forall i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST

Line 613: arp_message.set_line( ' END OE_CUST_MERGE.OE_Merge_Headers()-' );

609:
610: arp_message.set_line(' header_id_tab_count for hdr='||dbi_header_header_id_tab.COUNT);
611: arp_message.set_line(' update_date_tab_count for hdr='||dbi_header_update_date_tab.COUNT);
612:
613: arp_message.set_line( ' END OE_CUST_MERGE.OE_Merge_Headers()-' );
614:
615:
616: EXCEPTION
617: when others then

Line 618: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Headers-' );

614:
615:
616: EXCEPTION
617: when others then
618: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Headers-' );
619: raise;
620:
621: END OE_Merge_Headers;
622:

Line 785: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

781: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
782: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
783: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
784: FROM
785: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
786: WHERE HIST.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
787: AND M1.PROCESS_FLAG='N'
788: AND M1.REQUEST_ID = req_id
789: AND M1.SET_NUMBER = set_num

Line 857: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

853: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
854: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
855: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
856: FROM
857: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
858: WHERE HIST.END_CUSTOMER_ID= M1.DUPLICATE_ID
859: AND M1.PROCESS_FLAG='N'
860: AND M1.REQUEST_ID = req_id
861: AND M1.SET_NUMBER = set_num

Line 880: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_HEADER_History()+' );

876: customer_site_id_tab num_table_binary_int;
877:
878: BEGIN
879:
880: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_HEADER_History()+' );
881:
882: IF (process_mode = 'LOCK') THEN
883:
884: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

Line 1038: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );

1034:
1035: END IF;
1036: customer_id_tab.DELETE;
1037: customer_site_id_tab.DELETE;
1038: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );
1039:
1040: EXCEPTION
1041: when others then
1042: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );

Line 1042: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );

1038: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );
1039:
1040: EXCEPTION
1041: when others then
1042: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );
1043: raise;
1044:
1045: END OE_MERGE_HEADER_HISTORY; -- 3196900
1046:

Line 1128: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()+' );

1124: and m.set_number = set_num)
1125: for update nowait;
1126:
1127: BEGIN
1128: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()+' );
1129:
1130: -- both customer and site level
1131:
1132: IF( process_mode = 'LOCK' ) THEN

Line 1363: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );

1359: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1360:
1361: END IF;
1362:
1363: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );
1364:
1365: EXCEPTION
1366: When others then
1367: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );

Line 1367: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );

1363: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );
1364:
1365: EXCEPTION
1366: When others then
1367: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );
1368: raise;
1369:
1370: END OE_Merge_Header_History; */
1371:

Line 1433: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE()+' );

1429:
1430:
1431:
1432: BEGIN
1433: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE()+' );
1434:
1435: -- both customer and site level
1436:
1437: IF( process_mode = 'LOCK' ) THEN

Line 1571: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE()-' );

1567: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1568:
1569: END IF;
1570:
1571: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE()-' );
1572:
1573: EXCEPTION
1574: When others then
1575: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE-' );

Line 1575: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE-' );

1571: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE()-' );
1572:
1573: EXCEPTION
1574: When others then
1575: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE-' );
1576: raise;
1577:
1578: END OE_Merge_Headers_IFACE;
1579:

Line 1686: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_ACKS()+' );

1682:
1683: l_profile_val VARCHAR2(30);
1684:
1685: BEGIN
1686: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_ACKS()+' );
1687:
1688: /* both customer and site level */
1689:
1690: IF( process_mode = 'LOCK' ) THEN

Line 2218: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_ACKS()-' );

2214: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
2215:
2216: END IF;
2217:
2218: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_ACKS()-' );
2219:
2220: EXCEPTION
2221: When others then
2222: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_ACKS-' );

Line 2222: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_ACKS-' );

2218: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_ACKS()-' );
2219:
2220: EXCEPTION
2221: When others then
2222: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_ACKS-' );
2223: raise;
2224:
2225: END OE_Merge_Header_ACKS;
2226:

Line 2430: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES L

2426: L.LINE_ID , L.HEADER_ID, L.LAST_UPDATE_DATE, L.LINE_ID,
2427: 'Y', SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID,
2428: DELIVER_TO_ORG_ID, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID,'N', M1.CUSTOMER_MERGE_ID
2429: FROM
2430: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES L
2431: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
2432: AND M1.PROCESS_FLAG='N'
2433: AND M1.REQUEST_ID = req_id
2434: AND M1.SET_NUMBER = set_num

Line 2496: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES L

2492: L.LINE_ID , L.HEADER_ID, L.LAST_UPDATE_DATE, L.LINE_ID,
2493: 'Y', SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID,
2494: DELIVER_TO_ORG_ID, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID, 'N',M1.CUSTOMER_MERGE_ID
2495: FROM
2496: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES L
2497: WHERE L.END_CUSTOMER_ID= M1.DUPLICATE_ID
2498: AND M1.PROCESS_FLAG='N'
2499: AND M1.REQUEST_ID = req_id
2500: AND M1.SET_NUMBER = set_num;

Line 2538: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines()+' );

2534: l_global_count number :=0;
2535:
2536: BEGIN
2537:
2538: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines()+' );
2539:
2540: IF (process_mode = 'LOCK') THEN
2541:
2542: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

Line 2567: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines():1' );

2563:
2564: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2565: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2566:
2567: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines():1' );
2568: -- Bug 7379750
2569: IF l_run_parallel_query = 'Y' THEN
2570: OPEN merge_lines_2;
2571: ELSE

Line 2826: arp_message.set_line( ' END OE_CUST_MERGE.OE_Merge_Lines()-' );

2822: arp_message.set_line(' line_hdr_id_count='||dbi_line_header_id_tab.COUNT);
2823: arp_message.set_line(' line_line__id_count='||dbi_line_line_id_tab.COUNT);
2824: arp_message.set_line(' line_date_count='||dbi_line_update_date_tab.COUNT);
2825: arp_message.set_line(' line_status_count='||dbi_line_status_tab.COUNT);
2826: arp_message.set_line( ' END OE_CUST_MERGE.OE_Merge_Lines()-' );
2827:
2828: EXCEPTION
2829: when others then
2830: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines-' );

Line 2830: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines-' );

2826: arp_message.set_line( ' END OE_CUST_MERGE.OE_Merge_Lines()-' );
2827:
2828: EXCEPTION
2829: when others then
2830: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines-' );
2831: raise;
2832:
2833: END OE_Merge_Lines;
2834:

Line 2992: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN

2988: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_ORG_ID,
2989: L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.END_CUSTOMER_SITE_USE_ID,
2990: L.END_CUSTOMER_ID
2991: FROM
2992: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN
2993: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
2994: AND M1.PROCESS_FLAG='N'
2995: AND M1.REQUEST_ID = req_id
2996: AND M1.SET_NUMBER = set_num

Line 3058: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN

3054: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_ORG_ID,
3055: L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.END_CUSTOMER_SITE_USE_ID,
3056: L.END_CUSTOMER_ID
3057: FROM
3058: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN
3059: WHERE L.END_CUSTOMER_ID= M1.DUPLICATE_ID
3060: AND M1.PROCESS_FLAG='N'
3061: AND M1.REQUEST_ID = req_id
3062: AND M1.SET_NUMBER = set_num

Line 3080: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_History()+' );

3076: customer_site_id_tab num_table_binary_int;
3077:
3078: BEGIN
3079:
3080: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_History()+' );
3081:
3082: IF (process_mode = 'LOCK') THEN
3083:
3084: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

Line 3238: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_History()-' );

3234:
3235: END IF;
3236: customer_id_tab.DELETE;
3237: customer_site_id_tab.DELETE;
3238: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_History()-' );
3239:
3240: EXCEPTION
3241: when others then
3242: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_History-' );

Line 3242: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_History-' );

3238: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_History()-' );
3239:
3240: EXCEPTION
3241: when others then
3242: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_History-' );
3243: raise;
3244:
3245: END OE_Merge_Lines_History;
3246:

Line 3306: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE()+' );

3302: and m.set_number = set_num)
3303: for update nowait;
3304:
3305: BEGIN
3306: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE()+' );
3307:
3308: -- both customer and site level
3309:
3310: IF( process_mode = 'LOCK' ) THEN

Line 3441: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE()-' );

3437: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3438:
3439: END IF;
3440:
3441: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE()-' );
3442:
3443: EXCEPTION
3444: When others then
3445: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE-' );

Line 3445: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE-' );

3441: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE()-' );
3442:
3443: EXCEPTION
3444: When others then
3445: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE-' );
3446: raise;
3447:
3448: END OE_Merge_Lines_IFACE;
3449:

Line 3555: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Line_ACKS()+' );

3551:
3552: l_profile_val VARCHAR2(30);
3553:
3554: BEGIN
3555: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Line_ACKS()+' );
3556:
3557: /* both customer and site level */
3558:
3559: IF( process_mode = 'LOCK' ) THEN

Line 4096: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Line_ACKS()-' );

4092: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4093:
4094: END IF;
4095:
4096: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Line_ACKS()-' );
4097:
4098: EXCEPTION
4099: When others then
4100: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Line_ACKS-' );

Line 4100: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Line_ACKS-' );

4096: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Line_ACKS()-' );
4097:
4098: EXCEPTION
4099: When others then
4100: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Line_ACKS-' );
4101: raise;
4102:
4103: END OE_Merge_Line_ACKS;
4104: -----------------------------------------------------------------

Line 4126: arp_message.set_line( 'OE_CUST_MERGE.Merge()+' );

4122: sql_stmnt varchar2(200);
4123:
4124: BEGIN
4125:
4126: arp_message.set_line( 'OE_CUST_MERGE.Merge()+' );
4127: -- sql_stmnt := 'Alter Session set hash_area_size=61440000';
4128: -- EXECUTE IMMEDIATE sql_stmnt;
4129: --Changed for Bug#12313696 start
4130: --l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');

Line 4135: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);

4131: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N');
4132: --Changed for Bug#12313696 end
4133:
4134: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
4135: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
4136: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
4137: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
4138: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);

Line 4136: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);

4132: --Changed for Bug#12313696 end
4133:
4134: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
4135: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
4136: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
4137: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
4138: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
4140: -- drop ship are po line location id and not site ids of accounts

Line 4137: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);

4133:
4134: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
4135: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
4136: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
4137: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
4138: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
4140: -- drop ship are po line location id and not site ids of accounts
4141: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);

Line 4138: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);

4134: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
4135: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
4136: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
4137: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
4138: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
4140: -- drop ship are po line location id and not site ids of accounts
4141: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
4142: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);

Line 4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);

4135: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
4136: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
4137: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
4138: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
4140: -- drop ship are po line location id and not site ids of accounts
4141: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
4142: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
4143: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);

Line 4141: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);

4137: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
4138: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
4140: -- drop ship are po line location id and not site ids of accounts
4141: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
4142: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
4143: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
4144: arp_message.set_line( 'OE_CUST_MERGE.Merge()-' );
4145:

Line 4142: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);

4138: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
4140: -- drop ship are po line location id and not site ids of accounts
4141: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
4142: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
4143: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
4144: arp_message.set_line( 'OE_CUST_MERGE.Merge()-' );
4145:
4146: /* this part will be calling other internal procedures */

Line 4143: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);

4139: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
4140: -- drop ship are po line location id and not site ids of accounts
4141: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
4142: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
4143: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
4144: arp_message.set_line( 'OE_CUST_MERGE.Merge()-' );
4145:
4146: /* this part will be calling other internal procedures */
4147:

Line 4144: arp_message.set_line( 'OE_CUST_MERGE.Merge()-' );

4140: -- drop ship are po line location id and not site ids of accounts
4141: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
4142: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
4143: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
4144: arp_message.set_line( 'OE_CUST_MERGE.Merge()-' );
4145:
4146: /* this part will be calling other internal procedures */
4147:
4148: EXCEPTION

Line 4150: arp_message.set_error( 'OE_CUST_MERGE.Merge-' );

4146: /* this part will be calling other internal procedures */
4147:
4148: EXCEPTION
4149: When others then
4150: arp_message.set_error( 'OE_CUST_MERGE.Merge-' );
4151: raise;
4152:
4153:
4154: END Merge;

Line 4198: arp_message.set_line( 'OE_CUST_MERGE.OE_Attachment_Merge()+' );

4194:
4195: l_profile_val VARCHAR2(30);
4196:
4197: BEGIN
4198: arp_message.set_line( 'OE_CUST_MERGE.OE_Attachment_Merge()+' );
4199:
4200: /*-----------------------------+
4201: | OE_ATTACHMENTS_RULE_ELEMENTS|
4202: +-----------------------------*/

Line 4432: arp_message.set_line( 'OE_CUST_MERGE.OE_Attachment_Merge()-' );

4428: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4429:
4430: END IF;
4431:
4432: arp_message.set_line( 'OE_CUST_MERGE.OE_Attachment_Merge()-' );
4433:
4434:
4435: EXCEPTION
4436: when others then

Line 4437: arp_message.set_line( 'OE_CUST_MERGE.OE_Attachment_Merge' );

4433:
4434:
4435: EXCEPTION
4436: when others then
4437: arp_message.set_line( 'OE_CUST_MERGE.OE_Attachment_Merge' );
4438: raise;
4439:
4440:
4441: END OE_Attachment_Merge;

Line 4540: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge()+' );

4536:
4537: l_profile_val VARCHAR2(30);
4538:
4539: BEGIN
4540: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge()+' );
4541:
4542: /*-----------------------------+
4543: | OE_DEF_CONDN_ELEMS|
4544: +-----------------------------*/

Line 5136: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge()-' );

5132:
5133:
5134: END IF;
5135:
5136: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge()-' );
5137:
5138:
5139: EXCEPTION
5140: when others then

Line 5141: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge' );

5137:
5138:
5139: EXCEPTION
5140: when others then
5141: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge' );
5142: raise;
5143:
5144:
5145:

Line 5200: arp_message.set_line( 'OE_CUST_MERGE.Constraints_Merge()+' );

5196:
5197: l_profile_val VARCHAR2(30);
5198:
5199: BEGIN
5200: arp_message.set_line( 'OE_CUST_MERGE.Constraints_Merge()+' );
5201:
5202: /*-----------------------------+
5203: | oe_pc_vtmplt_cols|
5204: +-----------------------------*/

Line 5507: arp_message.set_line( 'OE_CUST_MERGE.OE_Constraints_Merge()-' );

5503: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5504:
5505: END IF;
5506:
5507: arp_message.set_line( 'OE_CUST_MERGE.OE_Constraints_Merge()-' );
5508:
5509:
5510: EXCEPTION
5511: when others then

Line 5512: arp_message.set_line( 'OE_CUST_MERGE.OE_Constraints_Merge' );

5508:
5509:
5510: EXCEPTION
5511: when others then
5512: arp_message.set_line( 'OE_CUST_MERGE.OE_Constraints_Merge' );
5513: raise;
5514:
5515: END OE_Constraints_Merge;
5516:

Line 5563: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge()+' );

5559: l_profile_val VARCHAR2(30);
5560:
5561: BEGIN
5562:
5563: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge()+' );
5564: /*-----------------------------+
5565: | OE_HOLD_SOURCES |
5566: +-----------------------------*/
5567: /* both customer and site level */

Line 5799: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge()-' );

5795: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5796:
5797: END IF;
5798:
5799: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge()-' );
5800:
5801:
5802: EXCEPTION
5803: when others then

Line 5804: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge' );

5800:
5801:
5802: EXCEPTION
5803: when others then
5804: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge' );
5805: raise;
5806:
5807: END OE_Hold_Merge;
5808:

Line 5827: arp_message.set_line( 'OE_CUST_MERGE.OE_Drop_SHip_Merge()+' );

5823:
5824: l_profile_val VARCHAR2(30);
5825:
5826: BEGIN
5827: arp_message.set_line( 'OE_CUST_MERGE.OE_Drop_SHip_Merge()+' );
5828:
5829: /* both customer and site level */
5830:
5831: IF( process_mode = 'LOCK' ) THEN

Line 5908: arp_message.set_line( 'OE_CUST_MERGE.OE_Drop_SHip_Merge()-' );

5904: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5905:
5906: END IF;
5907:
5908: arp_message.set_line( 'OE_CUST_MERGE.OE_Drop_SHip_Merge()-' );
5909:
5910: EXCEPTION
5911: When others then
5912: arp_message.set_error( 'OE_CUST_MERGE.OE_Drop_SHip_Merge-' );

Line 5912: arp_message.set_error( 'OE_CUST_MERGE.OE_Drop_SHip_Merge-' );

5908: arp_message.set_line( 'OE_CUST_MERGE.OE_Drop_SHip_Merge()-' );
5909:
5910: EXCEPTION
5911: When others then
5912: arp_message.set_error( 'OE_CUST_MERGE.OE_Drop_SHip_Merge-' );
5913: raise;
5914:
5915: END OE_Drop_Ship_Merge;
5916:

Line 5946: arp_message.set_line( 'OE_CUST_MERGE.OE_ship_tolerance_merge()+' );

5942:
5943: l_profile_val VARCHAR2(30);
5944:
5945: BEGIN
5946: arp_message.set_line( 'OE_CUST_MERGE.OE_ship_tolerance_merge()+' );
5947:
5948: /* both customer and site level */
5949:
5950: IF( process_mode = 'LOCK' ) THEN

Line 6094: arp_message.set_line( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge()-' );

6090: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
6091:
6092: END IF;
6093:
6094: arp_message.set_line( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge()-' );
6095:
6096: EXCEPTION
6097: When others then
6098: arp_message.set_error( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge-' );

Line 6098: arp_message.set_error( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge-' );

6094: arp_message.set_line( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge()-' );
6095:
6096: EXCEPTION
6097: When others then
6098: arp_message.set_error( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge-' );
6099: raise;
6100:
6101: END OE_Ship_Tolerance_Merge;
6102:

Line 6157: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()+' );

6153: l_profile_val VARCHAR2(30);
6154:
6155: BEGIN
6156:
6157: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()+' );
6158:
6159: IF (process_mode = 'LOCK') THEN
6160:
6161: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

Line 6268: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );

6264: CLOSE sets_merge_2_np;
6265: END IF;
6266:
6267: END IF;
6268: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );
6269:
6270: EXCEPTION
6271: when others then
6272: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );

Line 6272: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );

6268: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );
6269:
6270: EXCEPTION
6271: when others then
6272: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );
6273: raise;
6274:
6275: END OE_Sets_merge;
6276:

Line 6346: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()+' );

6342: l_profile_val varchar2(30);
6343:
6344: BEGIN
6345:
6346: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()+' );
6347: IF (process_mode = 'LOCK') THEN
6348:
6349: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
6350: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );

Line 6437: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()-' );

6433:
6434: CLOSE c1_2;
6435:
6436: END IF;
6437: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()-' );
6438:
6439: EXCEPTION
6440: when others then
6441: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs-' );

Line 6441: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs-' );

6437: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()-' );
6438:
6439: EXCEPTION
6440: when others then
6441: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs-' );
6442: raise;
6443:
6444: END OE_Merge_Price_Adj_Attribs;
6445:

Line 6572: OE_CUST_MERGES_GTT M1, OE_BLANKET_HEADERS H

6568: H.HEADER_ID, H.SOLD_TO_ORG_ID, H.INVOICE_TO_ORG_ID,
6569: H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
6570: H.SOLD_TO_SITE_USE_ID, M1.CUSTOMER_MERGE_ID
6571: FROM
6572: OE_CUST_MERGES_GTT M1, OE_BLANKET_HEADERS H
6573: WHERE H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
6574: AND M1.PROCESS_FLAG='N'
6575: AND M1.REQUEST_ID = req_id
6576: AND M1.SET_NUMBER = set_num

Line 6643: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers()+' );

6639:
6640: l_profile_val VARCHAR2(30);
6641: BEGIN
6642:
6643: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers()+' );
6644:
6645: IF (process_mode = 'LOCK') THEN
6646:
6647: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

Line 6856: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers()-' );

6852:
6853: END IF;
6854: customer_id_tab.DELETE;
6855: customer_site_id_tab.DELETE;
6856: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers()-' );
6857:
6858: EXCEPTION
6859: when others then
6860: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers-' );

Line 6860: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers-' );

6856: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers()-' );
6857:
6858: EXCEPTION
6859: when others then
6860: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers-' );
6861: raise;
6862:
6863: END OE_Merge_Blanket_Headers;
6864:

Line 6950: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist()+' );

6946:
6947: l_profile_val VARCHAR2(30);
6948:
6949: BEGIN
6950: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist()+' );
6951:
6952: -- both customer and site level
6953:
6954: IF( process_mode = 'LOCK' ) THEN

Line 7326: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist()-' );

7322: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
7323:
7324: END IF;
7325:
7326: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist()-' );
7327:
7328: EXCEPTION
7329: When others then
7330: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist-' );

Line 7330: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist-' );

7326: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist()-' );
7327:
7328: EXCEPTION
7329: When others then
7330: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist-' );
7331: raise;
7332:
7333: END OE_Merge_Blkt_Hdrs_Hist;
7334:

Line 7461: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES L

7457: INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID,
7458: INTMED_SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID,
7459: M1.CUSTOMER_MERGE_ID
7460: FROM
7461: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES L
7462: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
7463: AND M1.PROCESS_FLAG='N'
7464: AND M1.REQUEST_ID = req_id
7465: AND M1.SET_NUMBER = set_num

Line 7539: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines()+' );

7535: customer_site_id_tab num_table_binary_int;
7536:
7537: BEGIN
7538:
7539: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines()+' );
7540:
7541: IF (process_mode = 'LOCK') THEN
7542:
7543: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

Line 7748: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines()-' );

7744: END IF;
7745: END IF;
7746: customer_id_tab.DELETE;
7747: customer_site_id_tab.DELETE;
7748: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines()-' );
7749:
7750: EXCEPTION
7751: when others then
7752: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines-' );

Line 7752: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines-' );

7748: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines()-' );
7749:
7750: EXCEPTION
7751: when others then
7752: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines-' );
7753: raise;
7754:
7755: END OE_Merge_Blanket_Lines;
7756:

Line 7891: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

7887: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID,
7888: L.SHIP_TO_ORG_ID, L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID,
7889: L.VERSION_NUMBER, M1.CUSTOMER_MERGE_ID
7890: FROM
7891: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7892: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
7893: AND M1.PROCESS_FLAG='N'
7894: AND M1.REQUEST_ID = req_id
7895: AND M1.SET_NUMBER = set_num

Line 7967: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist()+' );

7963: l_profile_val VARCHAR2(30);
7964:
7965: BEGIN
7966:
7967: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist()+' );
7968:
7969: IF (process_mode = 'LOCK') THEN
7970:
7971: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

Line 8181: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist()-' );

8177:
8178: END IF;
8179: customer_id_tab.DELETE;
8180: customer_site_id_tab.DELETE;
8181: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist()-' );
8182:
8183: EXCEPTION
8184: when others then
8185: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist-' );

Line 8185: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist-' );

8181: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist()-' );
8182:
8183: EXCEPTION
8184: when others then
8185: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist-' );
8186: raise;
8187:
8188: END OE_Merge_Blkt_Lines_Hist;
8189:

Line 8218: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()+' );

8214:
8215: l_profile_val VARCHAR2(30);
8216:
8217: BEGIN
8218: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()+' );
8219: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110510' THEN
8220: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()-' );
8221: Return;
8222: END IF;

Line 8220: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()-' );

8216:
8217: BEGIN
8218: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()+' );
8219: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110510' THEN
8220: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()-' );
8221: Return;
8222: END IF;
8223:
8224: -- both customer and site level

Line 8315: arp_message.set_line( 'OE_CUST_MERGE. OE_Merge_OI_Tracking()-' );

8311: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
8312:
8313: END IF;
8314:
8315: arp_message.set_line( 'OE_CUST_MERGE. OE_Merge_OI_Tracking()-' );
8316:
8317: EXCEPTION
8318: When others then
8319: arp_message.set_error( 'OE_CUST_MERGE. OE_Merge_OI_Tracking-' );

Line 8319: arp_message.set_error( 'OE_CUST_MERGE. OE_Merge_OI_Tracking-' );

8315: arp_message.set_line( 'OE_CUST_MERGE. OE_Merge_OI_Tracking()-' );
8316:
8317: EXCEPTION
8318: When others then
8319: arp_message.set_error( 'OE_CUST_MERGE. OE_Merge_OI_Tracking-' );
8320: raise;
8321:
8322: END OE_Merge_OI_Tracking;
8323:

Line 8333: arp_message.set_line( 'OE_CUST_MERGE.OE_Order_Merge()+' );

8329: )
8330: IS
8331:
8332: BEGIN
8333: arp_message.set_line( 'OE_CUST_MERGE.OE_Order_Merge()+' );
8334:
8335: OE_Merge_Headers(Req_Id, Set_Num, Process_Mode);
8336: OE_Merge_Lines(Req_Id, Set_Num, Process_Mode);
8337: OE_Merge_Header_History(Req_Id, Set_Num, Process_Mode);

Line 8352: arp_message.set_line( 'OE_CUST_MERGE.Order_Merge()-' );

8348: OE_Merge_OI_Tracking (Req_Id, Set_Num, Process_Mode);
8349: arp_message.set_line( 'calling dbi now...' );
8350: oe_update_dbi_log();
8351: OE_Update_Credit_Hold_Flag(); --ER 3095805
8352: arp_message.set_line( 'OE_CUST_MERGE.Order_Merge()-' );
8353:
8354: EXCEPTION
8355: When others then
8356: arp_message.set_error( 'OE_CUST_MERGE.OE_Order_Merge-' );

Line 8356: arp_message.set_error( 'OE_CUST_MERGE.OE_Order_Merge-' );

8352: arp_message.set_line( 'OE_CUST_MERGE.Order_Merge()-' );
8353:
8354: EXCEPTION
8355: When others then
8356: arp_message.set_error( 'OE_CUST_MERGE.OE_Order_Merge-' );
8357: raise;
8358:
8359: END OE_Order_Merge;
8360:

Line 8522: oe_debug_pub.add('when others oe_cust_merge.update_dbi_log'||SQLERRM||

8518: arp_message.set_line(' End Update DBI');
8519:
8520: EXCEPTION
8521: WHEN OTHERS THEN
8522: oe_debug_pub.add('when others oe_cust_merge.update_dbi_log'||SQLERRM||
8523: SQLCODE);
8524:
8525: END oe_update_dbi_log;
8526:

Line 8569: END OE_CUST_MERGE;

8565:
8566: END OE_Update_Credit_Hold_Flag;
8567: --ER 3095805 End
8568:
8569: END OE_CUST_MERGE;