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_DATA_FIX dependencies on OE_CUST_MERGE_DATA_FIX

Line 1: PACKAGE BODY OE_CUST_MERGE_DATA_FIX AS

1: PACKAGE BODY OE_CUST_MERGE_DATA_FIX AS
2: /* $Header: OEXCMDFB.pls 120.0 2005/06/01 01:15:27 appldev noship $ */
3:
4: /*---------------------------- PRIVATE VARIABLES ----------------------------*/
5: g_count NUMBER := 0;

Line 71: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers()+' );

67: --
68: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
69: --
70: BEGIN
71: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers()+' );
72: IF l_debug_level > 0 THEN
73: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADERS' ) ;
74: END IF;
75:

Line 73: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADERS' ) ;

69: --
70: BEGIN
71: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers()+' );
72: IF l_debug_level > 0 THEN
73: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADERS' ) ;
74: END IF;
75:
76: /* both customer and site level */
77:

Line 247: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers()-' );

243:
244:
245: END IF;
246:
247: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers()-' );
248: IF l_debug_level > 0 THEN
249: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADERS' ) ;
250: END IF;
251:

Line 249: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADERS' ) ;

245: END IF;
246:
247: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers()-' );
248: IF l_debug_level > 0 THEN
249: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADERS' ) ;
250: END IF;
251:
252: EXCEPTION
253: When others then

Line 254: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers-' );

250: END IF;
251:
252: EXCEPTION
253: When others then
254: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers-' );
255: IF l_debug_level > 0 THEN
256: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADERS' ) ;
257: END IF;
258: IF l_debug_level > 0 THEN

Line 256: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADERS' ) ;

252: EXCEPTION
253: When others then
254: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers-' );
255: IF l_debug_level > 0 THEN
256: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADERS' ) ;
257: END IF;
258: IF l_debug_level > 0 THEN
259: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
260: END IF;

Line 325: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_History()+' );

321:
322:
323:
324: BEGIN
325: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_History()+' );
326:
327: -- both customer and site level
328:
329: IF( process_mode = 'LOCK' ) THEN

Line 464: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_History()-' );

460: -- arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
461:
462: END IF;
463:
464: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_History()-' );
465:
466: EXCEPTION
467: When others then
468: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_History-' );

Line 468: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_History-' );

464: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_History()-' );
465:
466: EXCEPTION
467: When others then
468: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_History-' );
469: raise;
470:
471: END OE_Merge_Header_History;
472:

Line 535: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers_IFACE()+' );

531:
532:
533:
534: BEGIN
535: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers_IFACE()+' );
536:
537: -- both customer and site level
538:
539: IF( process_mode = 'LOCK' ) THEN

Line 673: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers_IFACE()-' );

669: -- arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
670:
671: END IF;
672:
673: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers_IFACE()-' );
674:
675: EXCEPTION
676: When others then
677: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers_IFACE-' );

Line 677: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers_IFACE-' );

673: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers_IFACE()-' );
674:
675: EXCEPTION
676: When others then
677: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Headers_IFACE-' );
678: raise;
679:
680: END OE_Merge_Headers_IFACE;
681:

Line 750: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_ACKS()+' );

746: --
747: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
748: --
749: BEGIN
750: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_ACKS()+' );
751: IF l_debug_level > 0 THEN
752: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADER_ACKS' ) ;
753: END IF;
754:

Line 752: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADER_ACKS' ) ;

748: --
749: BEGIN
750: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_ACKS()+' );
751: IF l_debug_level > 0 THEN
752: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADER_ACKS' ) ;
753: END IF;
754:
755: /* both customer and site level */
756:

Line 929: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_ACKS()-' );

925: END IF;
926:
927: END IF;
928:
929: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_ACKS()-' );
930: IF l_debug_level > 0 THEN
931: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADER_ACKS' ) ;
932: END IF;
933:

Line 931: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADER_ACKS' ) ;

927: END IF;
928:
929: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_ACKS()-' );
930: IF l_debug_level > 0 THEN
931: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADER_ACKS' ) ;
932: END IF;
933:
934: EXCEPTION
935: When others then

Line 936: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_ACKS-' );

932: END IF;
933:
934: EXCEPTION
935: When others then
936: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_ACKS-' );
937: IF l_debug_level > 0 THEN
938: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADER_ACKS' ) ;
939: END IF;
940: IF l_debug_level > 0 THEN

Line 938: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADER_ACKS' ) ;

934: EXCEPTION
935: When others then
936: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Header_ACKS-' );
937: IF l_debug_level > 0 THEN
938: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_HEADER_ACKS' ) ;
939: END IF;
940: IF l_debug_level > 0 THEN
941: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
942: END IF;

Line 1017: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines()+' );

1013: --
1014: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1015: --
1016: BEGIN
1017: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines()+' );
1018: IF l_debug_level > 0 THEN
1019: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES' ) ;
1020: END IF;
1021:

Line 1019: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES' ) ;

1015: --
1016: BEGIN
1017: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines()+' );
1018: IF l_debug_level > 0 THEN
1019: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES' ) ;
1020: END IF;
1021:
1022: /* both customer and site level */
1023:

Line 1223: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines()-' );

1219: END IF;
1220:
1221: END IF;
1222:
1223: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines()-' );
1224: IF l_debug_level > 0 THEN
1225: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES' ) ;
1226: END IF;
1227:

Line 1225: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES' ) ;

1221: END IF;
1222:
1223: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines()-' );
1224: IF l_debug_level > 0 THEN
1225: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES' ) ;
1226: END IF;
1227:
1228: EXCEPTION
1229: When others then

Line 1230: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines-' );

1226: END IF;
1227:
1228: EXCEPTION
1229: When others then
1230: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines-' );
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES' ) ;
1233: END IF;
1234: IF l_debug_level > 0 THEN

Line 1232: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES' ) ;

1228: EXCEPTION
1229: When others then
1230: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines-' );
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES' ) ;
1233: END IF;
1234: IF l_debug_level > 0 THEN
1235: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
1236: END IF;

Line 1311: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_History()+' );

1307: --
1308: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1309: --
1310: BEGIN
1311: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_History()+' );
1312: IF l_debug_level > 0 THEN
1313: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES_HISTORY' ) ;
1314: END IF;
1315:

Line 1313: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES_HISTORY' ) ;

1309: --
1310: BEGIN
1311: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_History()+' );
1312: IF l_debug_level > 0 THEN
1313: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES_HISTORY' ) ;
1314: END IF;
1315:
1316: /* both customer and site level */
1317:

Line 1520: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_History()-' );

1516: END IF;
1517:
1518: END IF;
1519:
1520: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_History()-' );
1521: IF l_debug_level > 0 THEN
1522: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES_HISTORY' ) ;
1523: END IF;
1524:

Line 1522: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES_HISTORY' ) ;

1518: END IF;
1519:
1520: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_History()-' );
1521: IF l_debug_level > 0 THEN
1522: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES_HISTORY' ) ;
1523: END IF;
1524:
1525: EXCEPTION
1526: When others then

Line 1527: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_History-' );

1523: END IF;
1524:
1525: EXCEPTION
1526: When others then
1527: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_History-' );
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES_HISTORY' ) ;
1530: END IF;
1531: IF l_debug_level > 0 THEN

Line 1529: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES_HISTORY' ) ;

1525: EXCEPTION
1526: When others then
1527: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_History-' );
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINES_HISTORY' ) ;
1530: END IF;
1531: IF l_debug_level > 0 THEN
1532: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
1533: END IF;

Line 1596: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_IFACE()+' );

1592: and m.set_number = set_num)
1593: for update nowait;
1594:
1595: BEGIN
1596: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_IFACE()+' );
1597:
1598: -- both customer and site level
1599:
1600: IF( process_mode = 'LOCK' ) THEN

Line 1731: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_IFACE()-' );

1727: -- arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1728:
1729: END IF;
1730:
1731: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_IFACE()-' );
1732:
1733: EXCEPTION
1734: When others then
1735: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_IFACE-' );

Line 1735: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_IFACE-' );

1731: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_IFACE()-' );
1732:
1733: EXCEPTION
1734: When others then
1735: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Lines_IFACE-' );
1736: raise;
1737:
1738: END OE_Merge_Lines_IFACE;
1739:

Line 1816: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Line_ACKS()+' );

1812: --
1813: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1814: --
1815: BEGIN
1816: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Line_ACKS()+' );
1817: IF l_debug_level > 0 THEN
1818: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINE_ACKS' ) ;
1819: END IF;
1820:

Line 1818: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINE_ACKS' ) ;

1814: --
1815: BEGIN
1816: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Line_ACKS()+' );
1817: IF l_debug_level > 0 THEN
1818: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINE_ACKS' ) ;
1819: END IF;
1820:
1821: /* both customer and site level */
1822:

Line 2024: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Line_ACKS()-' );

2020: END IF;
2021:
2022: END IF;
2023:
2024: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Line_ACKS()-' );
2025: IF l_debug_level > 0 THEN
2026: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINE_ACKS' ) ;
2027: END IF;
2028:

Line 2026: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINE_ACKS' ) ;

2022: END IF;
2023:
2024: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Line_ACKS()-' );
2025: IF l_debug_level > 0 THEN
2026: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINE_ACKS' ) ;
2027: END IF;
2028:
2029: EXCEPTION
2030: When others then

Line 2031: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Line_ACKS-' );

2027: END IF;
2028:
2029: EXCEPTION
2030: When others then
2031: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Line_ACKS-' );
2032: IF l_debug_level > 0 THEN
2033: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINE_ACKS' ) ;
2034: END IF;
2035: IF l_debug_level > 0 THEN

Line 2033: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINE_ACKS' ) ;

2029: EXCEPTION
2030: When others then
2031: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Merge_Line_ACKS-' );
2032: IF l_debug_level > 0 THEN
2033: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_MERGE_LINE_ACKS' ) ;
2034: END IF;
2035: IF l_debug_level > 0 THEN
2036: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
2037: END IF;

Line 2066: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Merg()+' );

2062: --
2063: BEGIN
2064:
2065: /* this part will be calling other internal procedures */
2066: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Merg()+' );
2067: IF l_debug_level > 0 THEN
2068: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.MERGE' ) ;
2069: END IF;
2070:

Line 2068: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.MERGE' ) ;

2064:
2065: /* this part will be calling other internal procedures */
2066: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Merg()+' );
2067: IF l_debug_level > 0 THEN
2068: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.MERGE' ) ;
2069: END IF;
2070:
2071: OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
2072: OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);

Line 2071: OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);

2067: IF l_debug_level > 0 THEN
2068: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.MERGE' ) ;
2069: END IF;
2070:
2071: OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
2072: OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
2073: OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);

Line 2072: OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);

2068: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.MERGE' ) ;
2069: END IF;
2070:
2071: OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
2072: OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
2073: OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);

Line 2073: OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);

2069: END IF;
2070:
2071: OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
2072: OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
2073: OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
2077: OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);

Line 2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);

2070:
2071: OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
2072: OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
2073: OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
2077: OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
2078: OE_CUST_MERGE_DATA_FIX.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);

Line 2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);

2071: OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
2072: OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
2073: OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
2077: OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
2078: OE_CUST_MERGE_DATA_FIX.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
2079:

Line 2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);

2072: OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
2073: OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
2077: OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
2078: OE_CUST_MERGE_DATA_FIX.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
2079:
2080: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Merg()-' );

Line 2077: OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);

2073: OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);
2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
2077: OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
2078: OE_CUST_MERGE_DATA_FIX.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
2079:
2080: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Merg()-' );
2081: IF l_debug_level > 0 THEN

Line 2078: OE_CUST_MERGE_DATA_FIX.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);

2074: OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge (Req_Id, Set_Num, Process_Mode);
2075: OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge (Req_Id, Set_Num, Process_Mode);
2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
2077: OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
2078: OE_CUST_MERGE_DATA_FIX.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
2079:
2080: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Merg()-' );
2081: IF l_debug_level > 0 THEN
2082: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.MERGE' ) ;

Line 2080: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Merg()-' );

2076: -- OE_CUST_MERGE_DATA_FIX.OE_Drop_Ship_Merge (Req_Id, Set_Num, Process_Mode);
2077: OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge (Req_Id, Set_Num, Process_Mode);
2078: OE_CUST_MERGE_DATA_FIX.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
2079:
2080: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Merg()-' );
2081: IF l_debug_level > 0 THEN
2082: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.MERGE' ) ;
2083: END IF;
2084:

Line 2082: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.MERGE' ) ;

2078: OE_CUST_MERGE_DATA_FIX.OE_Order_Merge (Req_Id, Set_Num, Process_Mode);
2079:
2080: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Merg()-' );
2081: IF l_debug_level > 0 THEN
2082: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.MERGE' ) ;
2083: END IF;
2084:
2085: EXCEPTION
2086: When others then

Line 2087: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.Merg-' );

2083: END IF;
2084:
2085: EXCEPTION
2086: When others then
2087: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.Merg-' );
2088: IF l_debug_level > 0 THEN
2089: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.MERGE' ) ;
2090: END IF;
2091: IF l_debug_level > 0 THEN

Line 2089: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.MERGE' ) ;

2085: EXCEPTION
2086: When others then
2087: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.Merg-' );
2088: IF l_debug_level > 0 THEN
2089: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.MERGE' ) ;
2090: END IF;
2091: IF l_debug_level > 0 THEN
2092: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
2093: END IF;

Line 2142: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge()+' );

2138: --
2139: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2140: --
2141: BEGIN
2142: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge()+' );
2143: IF l_debug_level > 0 THEN
2144: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_ATTACHMENT_MERGE' ) ;
2145: END IF;
2146:

Line 2144: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_ATTACHMENT_MERGE' ) ;

2140: --
2141: BEGIN
2142: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge()+' );
2143: IF l_debug_level > 0 THEN
2144: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_ATTACHMENT_MERGE' ) ;
2145: END IF;
2146:
2147: /*-----------------------------+
2148: | OE_ATTACHMENTS_RULE_ELEMENTS|

Line 2284: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge()-' );

2280: END IF;
2281:
2282: END IF;
2283:
2284: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge()-' );
2285: IF l_debug_level > 0 THEN
2286: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_ATTACHMENT_MERGE' ) ;
2287: END IF;
2288:

Line 2286: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_ATTACHMENT_MERGE' ) ;

2282: END IF;
2283:
2284: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge()-' );
2285: IF l_debug_level > 0 THEN
2286: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_ATTACHMENT_MERGE' ) ;
2287: END IF;
2288:
2289:
2290: EXCEPTION

Line 2292: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge' );

2288:
2289:
2290: EXCEPTION
2291: when others then
2292: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge' );
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_ATTACHMENT_MERGE' ) ;
2295: END IF;
2296: IF l_debug_level > 0 THEN

Line 2294: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_ATTACHMENT_MERGE' ) ;

2290: EXCEPTION
2291: when others then
2292: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Attachment_Merge' );
2293: IF l_debug_level > 0 THEN
2294: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_ATTACHMENT_MERGE' ) ;
2295: END IF;
2296: IF l_debug_level > 0 THEN
2297: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
2298: END IF;

Line 2401: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge()+' );

2397: --
2398: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2399: --
2400: BEGIN
2401: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge()+' );
2402: IF l_debug_level > 0 THEN
2403: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;
2404: END IF;
2405:

Line 2403: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;

2399: --
2400: BEGIN
2401: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge()+' );
2402: IF l_debug_level > 0 THEN
2403: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;
2404: END IF;
2405:
2406: /*-----------------------------+
2407: | OE_DEF_CONDN_ELEMS|

Line 2748: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge()-' );

2744:
2745:
2746: END IF;
2747:
2748: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge()-' );
2749: IF l_debug_level > 0 THEN
2750: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;
2751: END IF;
2752:

Line 2750: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;

2746: END IF;
2747:
2748: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge()-' );
2749: IF l_debug_level > 0 THEN
2750: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;
2751: END IF;
2752:
2753:
2754: EXCEPTION

Line 2756: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge' );

2752:
2753:
2754: EXCEPTION
2755: when others then
2756: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge' );
2757: IF l_debug_level > 0 THEN
2758: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;
2759: END IF;
2760: IF l_debug_level > 0 THEN

Line 2758: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;

2754: EXCEPTION
2755: when others then
2756: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Defaulting_Merge' );
2757: IF l_debug_level > 0 THEN
2758: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;
2759: END IF;
2760: IF l_debug_level > 0 THEN
2761: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
2762: END IF;

Line 2822: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Constraints_Merge()+' );

2818: --
2819: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2820: --
2821: BEGIN
2822: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Constraints_Merge()+' );
2823: IF l_debug_level > 0 THEN
2824: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;
2825: END IF;
2826:

Line 2824: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;

2820: --
2821: BEGIN
2822: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Constraints_Merge()+' );
2823: IF l_debug_level > 0 THEN
2824: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;
2825: END IF;
2826:
2827: /*-----------------------------+
2828: | oe_pc_vtmplt_cols|

Line 3008: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge()-' );

3004: END IF;
3005:
3006: END IF;
3007:
3008: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge()-' );
3009: IF l_debug_level > 0 THEN
3010: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;
3011: END IF;
3012:

Line 3010: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;

3006: END IF;
3007:
3008: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge()-' );
3009: IF l_debug_level > 0 THEN
3010: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;
3011: END IF;
3012:
3013:
3014: EXCEPTION

Line 3016: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge' );

3012:
3013:
3014: EXCEPTION
3015: when others then
3016: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge' );
3017: IF l_debug_level > 0 THEN
3018: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;
3019: END IF;
3020: IF l_debug_level > 0 THEN

Line 3018: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;

3014: EXCEPTION
3015: when others then
3016: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Constraints_Merge' );
3017: IF l_debug_level > 0 THEN
3018: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_CONSTRAINTS_MERGE' ) ;
3019: END IF;
3020: IF l_debug_level > 0 THEN
3021: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
3022: END IF;

Line 3075: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge()+' );

3071: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3072: --
3073: BEGIN
3074:
3075: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge()+' );
3076: IF l_debug_level > 0 THEN
3077: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_HOLD_MERGE' ) ;
3078: END IF;
3079: /*-----------------------------+

Line 3077: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_HOLD_MERGE' ) ;

3073: BEGIN
3074:
3075: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge()+' );
3076: IF l_debug_level > 0 THEN
3077: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_HOLD_MERGE' ) ;
3078: END IF;
3079: /*-----------------------------+
3080: | OE_HOLD_SOURCES |
3081: +-----------------------------*/

Line 3218: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge()-' );

3214: END IF;
3215:
3216: END IF;
3217:
3218: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge()-' );
3219: IF l_debug_level > 0 THEN
3220: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_HOLD_MERGE' ) ;
3221: END IF;
3222:

Line 3220: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_HOLD_MERGE' ) ;

3216: END IF;
3217:
3218: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge()-' );
3219: IF l_debug_level > 0 THEN
3220: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_HOLD_MERGE' ) ;
3221: END IF;
3222:
3223:
3224: EXCEPTION

Line 3226: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge' );

3222:
3223:
3224: EXCEPTION
3225: when others then
3226: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge' );
3227: IF l_debug_level > 0 THEN
3228: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_HOLD_MERGE' ) ;
3229: END IF;
3230: IF l_debug_level > 0 THEN

Line 3228: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_HOLD_MERGE' ) ;

3224: EXCEPTION
3225: when others then
3226: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Hold_Merge' );
3227: IF l_debug_level > 0 THEN
3228: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_HOLD_MERGE' ) ;
3229: END IF;
3230: IF l_debug_level > 0 THEN
3231: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
3232: END IF;

Line 3257: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Drop_SHip_Merge()+' );

3253: --
3254: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3255: --
3256: BEGIN
3257: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Drop_SHip_Merge()+' );
3258: IF l_debug_level > 0 THEN
3259: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_DROP_SHIP_MERGE' ) ;
3260: END IF;
3261:

Line 3259: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_DROP_SHIP_MERGE' ) ;

3255: --
3256: BEGIN
3257: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Drop_SHip_Merge()+' );
3258: IF l_debug_level > 0 THEN
3259: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_DROP_SHIP_MERGE' ) ;
3260: END IF;
3261:
3262: /* both customer and site level */
3263:

Line 3311: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Drop_SHip_Merge()-' );

3307: END IF;
3308:
3309: END IF;
3310:
3311: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Drop_SHip_Merge()-' );
3312: IF l_debug_level > 0 THEN
3313: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_DROP_SHIP_MERGE' ) ;
3314: END IF;
3315:

Line 3313: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_DROP_SHIP_MERGE' ) ;

3309: END IF;
3310:
3311: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Drop_SHip_Merge()-' );
3312: IF l_debug_level > 0 THEN
3313: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_DROP_SHIP_MERGE' ) ;
3314: END IF;
3315:
3316: EXCEPTION
3317: When others then

Line 3318: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Drop_SHip_Merge-' );

3314: END IF;
3315:
3316: EXCEPTION
3317: When others then
3318: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Drop_SHip_Merge-' );
3319: IF l_debug_level > 0 THEN
3320: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_DROP_SHIP_MERGE' ) ;
3321: END IF;
3322: IF l_debug_level > 0 THEN

Line 3320: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_DROP_SHIP_MERGE' ) ;

3316: EXCEPTION
3317: When others then
3318: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Drop_SHip_Merge-' );
3319: IF l_debug_level > 0 THEN
3320: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_DROP_SHIP_MERGE' ) ;
3321: END IF;
3322: IF l_debug_level > 0 THEN
3323: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
3324: END IF;

Line 3361: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_ship_tolerance_merge()+' );

3357: --
3358: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3359: --
3360: BEGIN
3361: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_ship_tolerance_merge()+' );
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_SHIP_TOLERANCE_MERGE' ) ;
3364: END IF;
3365:

Line 3363: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_SHIP_TOLERANCE_MERGE' ) ;

3359: --
3360: BEGIN
3361: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_ship_tolerance_merge()+' );
3362: IF l_debug_level > 0 THEN
3363: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_SHIP_TOLERANCE_MERGE' ) ;
3364: END IF;
3365:
3366: /* both customer and site level */
3367:

Line 3452: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge()-' );

3448: END IF;
3449:
3450: END IF;
3451:
3452: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge()-' );
3453: IF l_debug_level > 0 THEN
3454: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_SHIP_TOLERANCE_MERGE' ) ;
3455: END IF;
3456:

Line 3454: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_SHIP_TOLERANCE_MERGE' ) ;

3450: END IF;
3451:
3452: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge()-' );
3453: IF l_debug_level > 0 THEN
3454: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_SHIP_TOLERANCE_MERGE' ) ;
3455: END IF;
3456:
3457:
3458:

Line 3461: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge-' );

3457:
3458:
3459: EXCEPTION
3460: When others then
3461: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge-' );
3462: IF l_debug_level > 0 THEN
3463: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_SHIP_TOLERANCE_MERGE' ) ;
3464: END IF;
3465: IF l_debug_level > 0 THEN

Line 3463: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_SHIP_TOLERANCE_MERGE' ) ;

3459: EXCEPTION
3460: When others then
3461: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Ship_Tolerance_Merge-' );
3462: IF l_debug_level > 0 THEN
3463: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_SHIP_TOLERANCE_MERGE' ) ;
3464: END IF;
3465: IF l_debug_level > 0 THEN
3466: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
3467: END IF;

Line 3493: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()+' );

3489: --
3490: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3491: --
3492: BEGIN
3493: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()+' );
3494: IF l_debug_level > 0 THEN
3495: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3496: END IF;
3497:

Line 3495: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;

3491: --
3492: BEGIN
3493: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()+' );
3494: IF l_debug_level > 0 THEN
3495: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3496: END IF;
3497:
3498: /* both customer and site level */
3499:

Line 3548: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()-' );

3544: END IF;
3545:
3546: END IF;
3547:
3548: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()-' );
3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3551: END IF;
3552:

Line 3550: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;

3546: END IF;
3547:
3548: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge()-' );
3549: IF l_debug_level > 0 THEN
3550: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3551: END IF;
3552:
3553: EXCEPTION
3554: when others then

Line 3555: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge-' );

3551: END IF;
3552:
3553: EXCEPTION
3554: when others then
3555: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge-' );
3556: IF l_debug_level > 0 THEN
3557: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3558: END IF;
3559: IF l_debug_level > 0 THEN

Line 3557: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;

3553: EXCEPTION
3554: when others then
3555: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Sets_Merge-' );
3556: IF l_debug_level > 0 THEN
3557: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_SETS_MERGE' ) ;
3558: END IF;
3559: IF l_debug_level > 0 THEN
3560: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
3561: END IF;

Line 3578: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Order_Merge()+' );

3574: --
3575: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3576: --
3577: BEGIN
3578: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Order_Merge()+' );
3579: IF l_debug_level > 0 THEN
3580: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_ORDER_MERGE' ) ;
3581: END IF;
3582:

Line 3580: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_ORDER_MERGE' ) ;

3576: --
3577: BEGIN
3578: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.OE_Order_Merge()+' );
3579: IF l_debug_level > 0 THEN
3580: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_ORDER_MERGE' ) ;
3581: END IF;
3582:
3583: OE_Merge_Headers(Req_Id, Set_Num, Process_Mode);
3584: OE_Merge_Lines(Req_Id, Set_Num, Process_Mode);

Line 3592: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Order_Merge()-' );

3588: -- OE_Merge_Lines_IFACE(Req_Id, Set_Num, Process_Mode); -- Interface tables need not be updated
3589: OE_Merge_Header_ACKS(Req_Id, Set_Num, Process_Mode);
3590: OE_Merge_Line_ACKS(Req_Id, Set_Num, Process_Mode);
3591:
3592: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Order_Merge()-' );
3593: IF l_debug_level > 0 THEN
3594: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_ORDER_MERGE' ) ;
3595: END IF;
3596:

Line 3594: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_ORDER_MERGE' ) ;

3590: OE_Merge_Line_ACKS(Req_Id, Set_Num, Process_Mode);
3591:
3592: -- arp_message.set_line( 'OE_CUST_MERGE_DATA_FIX.Order_Merge()-' );
3593: IF l_debug_level > 0 THEN
3594: oe_debug_pub.add( 'END OE_CUST_MERGE_DATA_FIX.OE_ORDER_MERGE' ) ;
3595: END IF;
3596:
3597: EXCEPTION
3598: When others then

Line 3599: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Order_Merge-' );

3595: END IF;
3596:
3597: EXCEPTION
3598: When others then
3599: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Order_Merge-' );
3600: IF l_debug_level > 0 THEN
3601: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_ORDER_MERGE' ) ;
3602: END IF;
3603: IF l_debug_level > 0 THEN

Line 3601: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_ORDER_MERGE' ) ;

3597: EXCEPTION
3598: When others then
3599: -- arp_message.set_error( 'OE_CUST_MERGE_DATA_FIX.OE_Order_Merge-' );
3600: IF l_debug_level > 0 THEN
3601: oe_debug_pub.add( 'ERROR IN OE_CUST_MERGE_DATA_FIX.OE_ORDER_MERGE' ) ;
3602: END IF;
3603: IF l_debug_level > 0 THEN
3604: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
3605: END IF;

Line 3627: END OE_CUST_MERGE_DATA_FIX;

3623:
3624: END OE_Workflow_Merge;
3625:
3626:
3627: END OE_CUST_MERGE_DATA_FIX;
3628: