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.8.12010000.1 2008/07/25 07:46:42 appldev ship $ */
3:
4: /*---------------------------- PRIVATE VARIABLES ----------------------------*/
5:

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

189: l_global_count number :=0;
190:
191: BEGIN
192:
193: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers()+' );
194:
195: IF (process_mode = 'LOCK') THEN
196:
197: -- try to open table for update, if it fails the exception will

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

307: end if;
308:
309: end loop;
310: end if;
311: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers():3' );
312: --insert audit information for customer merge
313: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
314: IF hdr_header_id_tab.COUNT <> 0 THEN
315: forall i in hdr_header_id_tab.FIRST..hdr_header_id_tab.LAST

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

431:
432: arp_message.set_line(' header_id_tab_count for hdr='||dbi_header_header_id_tab.COUNT);
433: arp_message.set_line(' update_date_tab_count for hdr='||dbi_header_update_date_tab.COUNT);
434:
435: arp_message.set_line( ' END OE_CUST_MERGE.OE_Merge_Headers()-' );
436:
437: EXCEPTION
438: when others then
439: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Headers-' );

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

435: arp_message.set_line( ' END OE_CUST_MERGE.OE_Merge_Headers()-' );
436:
437: EXCEPTION
438: when others then
439: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Headers-' );
440: raise;
441:
442: END OE_Merge_Headers;
443:

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

611: customer_site_id_tab num_table_binary_int;
612:
613: BEGIN
614:
615: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_HEADER_History()+' );
616:
617: IF (process_mode = 'LOCK') THEN
618:
619: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

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

736:
737: END IF;
738: customer_id_tab.DELETE;
739: customer_site_id_tab.DELETE;
740: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );
741:
742: EXCEPTION
743: when others then
744: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );

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

740: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );
741:
742: EXCEPTION
743: when others then
744: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );
745: raise;
746:
747: END OE_MERGE_HEADER_HISTORY; -- 3196900
748:

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

826: and m.set_number = set_num)
827: for update nowait;
828:
829: BEGIN
830: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()+' );
831:
832: -- both customer and site level
833:
834: IF( process_mode = 'LOCK' ) THEN

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

1061: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1062:
1063: END IF;
1064:
1065: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );
1066:
1067: EXCEPTION
1068: When others then
1069: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );

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

1065: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_History()-' );
1066:
1067: EXCEPTION
1068: When others then
1069: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_History-' );
1070: raise;
1071:
1072: END OE_Merge_Header_History; */
1073:

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

1131:
1132:
1133:
1134: BEGIN
1135: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE()+' );
1136:
1137: -- both customer and site level
1138:
1139: IF( process_mode = 'LOCK' ) THEN

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

1269: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1270:
1271: END IF;
1272:
1273: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE()-' );
1274:
1275: EXCEPTION
1276: When others then
1277: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE-' );

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

1273: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE()-' );
1274:
1275: EXCEPTION
1276: When others then
1277: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Headers_IFACE-' );
1278: raise;
1279:
1280: END OE_Merge_Headers_IFACE;
1281:

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

1384:
1385: l_profile_val VARCHAR2(30);
1386:
1387: BEGIN
1388: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_ACKS()+' );
1389:
1390: /* both customer and site level */
1391:
1392: IF( process_mode = 'LOCK' ) THEN

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

1915: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1916:
1917: END IF;
1918:
1919: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_ACKS()-' );
1920:
1921: EXCEPTION
1922: When others then
1923: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_ACKS-' );

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

1919: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Header_ACKS()-' );
1920:
1921: EXCEPTION
1922: When others then
1923: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Header_ACKS-' );
1924: raise;
1925:
1926: END OE_Merge_Header_ACKS;
1927:

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

2152: l_global_count number :=0;
2153:
2154: BEGIN
2155:
2156: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines()+' );
2157:
2158: IF (process_mode = 'LOCK') THEN
2159:
2160: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

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

2180:
2181: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2182: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2183:
2184: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines():1' );
2185:
2186: OPEN merge_lines_2;
2187: LOOP
2188: FETCH merge_lines_2

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

2395: arp_message.set_line(' line_hdr_id_count='||dbi_line_header_id_tab.COUNT);
2396: arp_message.set_line(' line_line__id_count='||dbi_line_line_id_tab.COUNT);
2397: arp_message.set_line(' line_date_count='||dbi_line_update_date_tab.COUNT);
2398: arp_message.set_line(' line_status_count='||dbi_line_status_tab.COUNT);
2399: arp_message.set_line( ' END OE_CUST_MERGE.OE_Merge_Lines()-' );
2400:
2401: EXCEPTION
2402: when others then
2403: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines-' );

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

2399: arp_message.set_line( ' END OE_CUST_MERGE.OE_Merge_Lines()-' );
2400:
2401: EXCEPTION
2402: when others then
2403: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines-' );
2404: raise;
2405:
2406: END OE_Merge_Lines;
2407:

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

2571: customer_site_id_tab num_table_binary_int;
2572:
2573: BEGIN
2574:
2575: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_History()+' );
2576:
2577: IF (process_mode = 'LOCK') THEN
2578:
2579: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

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

2695:
2696: END IF;
2697: customer_id_tab.DELETE;
2698: customer_site_id_tab.DELETE;
2699: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_History()-' );
2700:
2701: EXCEPTION
2702: when others then
2703: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_History-' );

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

2699: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_History()-' );
2700:
2701: EXCEPTION
2702: when others then
2703: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_History-' );
2704: raise;
2705:
2706: END OE_Merge_Lines_History;
2707:

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

2763: and m.set_number = set_num)
2764: for update nowait;
2765:
2766: BEGIN
2767: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE()+' );
2768:
2769: -- both customer and site level
2770:
2771: IF( process_mode = 'LOCK' ) THEN

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

2898: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
2899:
2900: END IF;
2901:
2902: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE()-' );
2903:
2904: EXCEPTION
2905: When others then
2906: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE-' );

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

2902: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE()-' );
2903:
2904: EXCEPTION
2905: When others then
2906: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Lines_IFACE-' );
2907: raise;
2908:
2909: END OE_Merge_Lines_IFACE;
2910:

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

3012:
3013: l_profile_val VARCHAR2(30);
3014:
3015: BEGIN
3016: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Line_ACKS()+' );
3017:
3018: /* both customer and site level */
3019:
3020: IF( process_mode = 'LOCK' ) THEN

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

3553: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3554:
3555: END IF;
3556:
3557: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Line_ACKS()-' );
3558:
3559: EXCEPTION
3560: When others then
3561: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Line_ACKS-' );

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

3557: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Line_ACKS()-' );
3558:
3559: EXCEPTION
3560: When others then
3561: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Line_ACKS-' );
3562: raise;
3563:
3564: END OE_Merge_Line_ACKS;
3565: -----------------------------------------------------------------

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

3583: sql_stmnt varchar2(200);
3584:
3585: BEGIN
3586:
3587: arp_message.set_line( 'OE_CUST_MERGE.Merge()+' );
3588: -- sql_stmnt := 'Alter Session set hash_area_size=61440000';
3589: -- EXECUTE IMMEDIATE sql_stmnt;
3590: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');
3591: arp_message.set_line(' Dbi Profile='||l_dbi_profile);

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

3588: -- sql_stmnt := 'Alter Session set hash_area_size=61440000';
3589: -- EXECUTE IMMEDIATE sql_stmnt;
3590: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');
3591: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
3592: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
3593: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
3594: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
3595: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);

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

3589: -- EXECUTE IMMEDIATE sql_stmnt;
3590: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');
3591: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
3592: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
3593: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
3594: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
3595: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
3597: -- drop ship are po line location id and not site ids of accounts

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

3590: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');
3591: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
3592: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
3593: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
3594: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
3595: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
3597: -- drop ship are po line location id and not site ids of accounts
3598: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);

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

3591: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
3592: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
3593: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
3594: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
3595: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
3597: -- drop ship are po line location id and not site ids of accounts
3598: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
3599: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);

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

3592: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
3593: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
3594: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
3595: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
3597: -- drop ship are po line location id and not site ids of accounts
3598: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
3599: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
3600: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);

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

3594: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
3595: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
3597: -- drop ship are po line location id and not site ids of accounts
3598: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
3599: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
3600: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
3601: arp_message.set_line( 'OE_CUST_MERGE.Merge()-' );
3602:

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

3595: OE_CUST_MERGE.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
3597: -- drop ship are po line location id and not site ids of accounts
3598: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
3599: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
3600: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
3601: arp_message.set_line( 'OE_CUST_MERGE.Merge()-' );
3602:
3603: /* this part will be calling other internal procedures */

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

3596: OE_CUST_MERGE.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
3597: -- drop ship are po line location id and not site ids of accounts
3598: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
3599: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
3600: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
3601: arp_message.set_line( 'OE_CUST_MERGE.Merge()-' );
3602:
3603: /* this part will be calling other internal procedures */
3604:

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

3597: -- drop ship are po line location id and not site ids of accounts
3598: --OE_CUST_MERGE.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
3599: OE_CUST_MERGE.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
3600: OE_CUST_MERGE.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
3601: arp_message.set_line( 'OE_CUST_MERGE.Merge()-' );
3602:
3603: /* this part will be calling other internal procedures */
3604:
3605: EXCEPTION

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

3603: /* this part will be calling other internal procedures */
3604:
3605: EXCEPTION
3606: When others then
3607: arp_message.set_error( 'OE_CUST_MERGE.Merge-' );
3608: raise;
3609:
3610:
3611: END Merge;

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

3651:
3652: l_profile_val VARCHAR2(30);
3653:
3654: BEGIN
3655: arp_message.set_line( 'OE_CUST_MERGE.OE_Attachment_Merge()+' );
3656:
3657: /*-----------------------------+
3658: | OE_ATTACHMENTS_RULE_ELEMENTS|
3659: +-----------------------------*/

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

3885: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3886:
3887: END IF;
3888:
3889: arp_message.set_line( 'OE_CUST_MERGE.OE_Attachment_Merge()-' );
3890:
3891:
3892: EXCEPTION
3893: when others then

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

3890:
3891:
3892: EXCEPTION
3893: when others then
3894: arp_message.set_line( 'OE_CUST_MERGE.OE_Attachment_Merge' );
3895: raise;
3896:
3897:
3898: END OE_Attachment_Merge;

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

3993:
3994: l_profile_val VARCHAR2(30);
3995:
3996: BEGIN
3997: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge()+' );
3998:
3999: /*-----------------------------+
4000: | OE_DEF_CONDN_ELEMS|
4001: +-----------------------------*/

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

4589:
4590:
4591: END IF;
4592:
4593: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge()-' );
4594:
4595:
4596: EXCEPTION
4597: when others then

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

4594:
4595:
4596: EXCEPTION
4597: when others then
4598: arp_message.set_line( 'OE_CUST_MERGE.OE_Defaulting_Merge' );
4599: raise;
4600:
4601:
4602:

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

4653:
4654: l_profile_val VARCHAR2(30);
4655:
4656: BEGIN
4657: arp_message.set_line( 'OE_CUST_MERGE.Constraints_Merge()+' );
4658:
4659: /*-----------------------------+
4660: | oe_pc_vtmplt_cols|
4661: +-----------------------------*/

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

4960: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4961:
4962: END IF;
4963:
4964: arp_message.set_line( 'OE_CUST_MERGE.OE_Constraints_Merge()-' );
4965:
4966:
4967: EXCEPTION
4968: when others then

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

4965:
4966:
4967: EXCEPTION
4968: when others then
4969: arp_message.set_line( 'OE_CUST_MERGE.OE_Constraints_Merge' );
4970: raise;
4971:
4972: END OE_Constraints_Merge;
4973:

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

5016: l_profile_val VARCHAR2(30);
5017:
5018: BEGIN
5019:
5020: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge()+' );
5021: /*-----------------------------+
5022: | OE_HOLD_SOURCES |
5023: +-----------------------------*/
5024: /* both customer and site level */

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

5247: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5248:
5249: END IF;
5250:
5251: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge()-' );
5252:
5253:
5254: EXCEPTION
5255: when others then

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

5252:
5253:
5254: EXCEPTION
5255: when others then
5256: arp_message.set_line( 'OE_CUST_MERGE.OE_Hold_Merge' );
5257: raise;
5258:
5259: END OE_Hold_Merge;
5260:

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

5275:
5276: l_profile_val VARCHAR2(30);
5277:
5278: BEGIN
5279: arp_message.set_line( 'OE_CUST_MERGE.OE_Drop_SHip_Merge()+' );
5280:
5281: /* both customer and site level */
5282:
5283: IF( process_mode = 'LOCK' ) THEN

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

5356: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5357:
5358: END IF;
5359:
5360: arp_message.set_line( 'OE_CUST_MERGE.OE_Drop_SHip_Merge()-' );
5361:
5362: EXCEPTION
5363: When others then
5364: arp_message.set_error( 'OE_CUST_MERGE.OE_Drop_SHip_Merge-' );

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

5360: arp_message.set_line( 'OE_CUST_MERGE.OE_Drop_SHip_Merge()-' );
5361:
5362: EXCEPTION
5363: When others then
5364: arp_message.set_error( 'OE_CUST_MERGE.OE_Drop_SHip_Merge-' );
5365: raise;
5366:
5367: END OE_Drop_Ship_Merge;
5368:

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

5394:
5395: l_profile_val VARCHAR2(30);
5396:
5397: BEGIN
5398: arp_message.set_line( 'OE_CUST_MERGE.OE_ship_tolerance_merge()+' );
5399:
5400: /* both customer and site level */
5401:
5402: IF( process_mode = 'LOCK' ) THEN

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

5542: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
5543:
5544: END IF;
5545:
5546: arp_message.set_line( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge()-' );
5547:
5548: EXCEPTION
5549: When others then
5550: arp_message.set_error( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge-' );

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

5546: arp_message.set_line( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge()-' );
5547:
5548: EXCEPTION
5549: When others then
5550: arp_message.set_error( 'OE_CUST_MERGE.OE_Ship_Tolerance_Merge-' );
5551: raise;
5552:
5553: END OE_Ship_Tolerance_Merge;
5554:

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

5593: l_profile_val VARCHAR2(30);
5594:
5595: BEGIN
5596:
5597: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()+' );
5598:
5599: IF (process_mode = 'LOCK') THEN
5600:
5601: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

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

5683:
5684: CLOSE sets_merge_2;
5685:
5686: END IF;
5687: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );
5688:
5689: EXCEPTION
5690: when others then
5691: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );

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

5687: arp_message.set_line( 'OE_CUST_MERGE.OE_Sets_Merge()-' );
5688:
5689: EXCEPTION
5690: when others then
5691: arp_message.set_error( 'OE_CUST_MERGE.OE_Sets_Merge-' );
5692: raise;
5693:
5694: END OE_Sets_merge;
5695:

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

5761: l_profile_val varchar2(30);
5762:
5763: BEGIN
5764:
5765: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()+' );
5766: IF (process_mode = 'LOCK') THEN
5767:
5768: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5769: arp_message.set_token( 'TABLE_NAME', 'oe_price_adj_attribs', FALSE );

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

5852:
5853: CLOSE c1_2;
5854:
5855: END IF;
5856: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()-' );
5857:
5858: EXCEPTION
5859: when others then
5860: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs-' );

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

5856: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs()-' );
5857:
5858: EXCEPTION
5859: when others then
5860: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Price_Adj_Attribs-' );
5861: raise;
5862:
5863: END OE_Merge_Price_Adj_Attribs;
5864:

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

6001:
6002: l_profile_val VARCHAR2(30);
6003: BEGIN
6004:
6005: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers()+' );
6006:
6007: IF (process_mode = 'LOCK') THEN
6008:
6009: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

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

6183:
6184: END IF;
6185: customer_id_tab.DELETE;
6186: customer_site_id_tab.DELETE;
6187: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers()-' );
6188:
6189: EXCEPTION
6190: when others then
6191: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers-' );

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

6187: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers()-' );
6188:
6189: EXCEPTION
6190: when others then
6191: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Headers-' );
6192: raise;
6193:
6194: END OE_Merge_Blanket_Headers;
6195:

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

6277:
6278: l_profile_val VARCHAR2(30);
6279:
6280: BEGIN
6281: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist()+' );
6282:
6283: -- both customer and site level
6284:
6285: IF( process_mode = 'LOCK' ) THEN

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

6653: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
6654:
6655: END IF;
6656:
6657: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist()-' );
6658:
6659: EXCEPTION
6660: When others then
6661: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist-' );

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

6657: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist()-' );
6658:
6659: EXCEPTION
6660: When others then
6661: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Hdrs_Hist-' );
6662: raise;
6663:
6664: END OE_Merge_Blkt_Hdrs_Hist;
6665:

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

6803: customer_site_id_tab num_table_binary_int;
6804:
6805: BEGIN
6806:
6807: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines()+' );
6808:
6809: IF (process_mode = 'LOCK') THEN
6810:
6811: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

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

6978:
6979: END IF;
6980: customer_id_tab.DELETE;
6981: customer_site_id_tab.DELETE;
6982: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines()-' );
6983:
6984: EXCEPTION
6985: when others then
6986: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines-' );

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

6982: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines()-' );
6983:
6984: EXCEPTION
6985: when others then
6986: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blanket_Lines-' );
6987: raise;
6988:
6989: END OE_Merge_Blanket_Lines;
6990:

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

7138: l_profile_val VARCHAR2(30);
7139:
7140: BEGIN
7141:
7142: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist()+' );
7143:
7144: IF (process_mode = 'LOCK') THEN
7145:
7146: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');

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

7316:
7317: END IF;
7318: customer_id_tab.DELETE;
7319: customer_site_id_tab.DELETE;
7320: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist()-' );
7321:
7322: EXCEPTION
7323: when others then
7324: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist-' );

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

7320: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist()-' );
7321:
7322: EXCEPTION
7323: when others then
7324: arp_message.set_error( 'OE_CUST_MERGE.OE_Merge_Blkt_Lines_Hist-' );
7325: raise;
7326:
7327: END OE_Merge_Blkt_Lines_Hist;
7328:

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

7353:
7354: l_profile_val VARCHAR2(30);
7355:
7356: BEGIN
7357: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()+' );
7358: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110510' THEN
7359: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()-' );
7360: Return;
7361: END IF;

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

7355:
7356: BEGIN
7357: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()+' );
7358: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL < '110510' THEN
7359: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_OI_Tracking()-' );
7360: Return;
7361: END IF;
7362:
7363: -- both customer and site level

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

7450: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
7451:
7452: END IF;
7453:
7454: arp_message.set_line( 'OE_CUST_MERGE. OE_Merge_OI_Tracking()-' );
7455:
7456: EXCEPTION
7457: When others then
7458: arp_message.set_error( 'OE_CUST_MERGE. OE_Merge_OI_Tracking-' );

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

7454: arp_message.set_line( 'OE_CUST_MERGE. OE_Merge_OI_Tracking()-' );
7455:
7456: EXCEPTION
7457: When others then
7458: arp_message.set_error( 'OE_CUST_MERGE. OE_Merge_OI_Tracking-' );
7459: raise;
7460:
7461: END OE_Merge_OI_Tracking;
7462:

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

7468: )
7469: IS
7470:
7471: BEGIN
7472: arp_message.set_line( 'OE_CUST_MERGE.OE_Order_Merge()+' );
7473:
7474: OE_Merge_Headers(Req_Id, Set_Num, Process_Mode);
7475: OE_Merge_Lines(Req_Id, Set_Num, Process_Mode);
7476: OE_Merge_Header_History(Req_Id, Set_Num, Process_Mode);

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

7486: OE_Merge_Blkt_Lines_Hist(Req_Id, Set_Num, Process_Mode);
7487: OE_Merge_OI_Tracking (Req_Id, Set_Num, Process_Mode);
7488: arp_message.set_line( 'calling dbi now...' );
7489: oe_update_dbi_log();
7490: arp_message.set_line( 'OE_CUST_MERGE.Order_Merge()-' );
7491:
7492: EXCEPTION
7493: When others then
7494: arp_message.set_error( 'OE_CUST_MERGE.OE_Order_Merge-' );

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

7490: arp_message.set_line( 'OE_CUST_MERGE.Order_Merge()-' );
7491:
7492: EXCEPTION
7493: When others then
7494: arp_message.set_error( 'OE_CUST_MERGE.OE_Order_Merge-' );
7495: raise;
7496:
7497: END OE_Order_Merge;
7498:

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

7656: arp_message.set_line(' End Update DBI');
7657:
7658: EXCEPTION
7659: WHEN OTHERS THEN
7660: oe_debug_pub.add('when others oe_cust_merge.update_dbi_log'||SQLERRM||
7661: SQLCODE);
7662:
7663: END oe_update_dbi_log;
7664:

Line 7665: END OE_CUST_MERGE;

7661: SQLCODE);
7662:
7663: END oe_update_dbi_log;
7664:
7665: END OE_CUST_MERGE;