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_ORDER_IMPORT_MAIN_PVT dependencies on OE_DEBUG_PUB

Line 28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

24:
25: )
26: IS
27: --
28: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
29: --
30: BEGIN
31:
32: IF l_debug_level > 0 THEN

Line 33: oe_debug_pub.add( 'BEFORE CALLING PERF STATISTICS API' ) ;

29: --
30: BEGIN
31:
32: IF l_debug_level > 0 THEN
33: oe_debug_pub.add( 'BEFORE CALLING PERF STATISTICS API' ) ;
34: END IF;
35:
36: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
37: tabname => 'OE_HEADERS_IFACE_ALL');

Line 54: oe_debug_pub.add( 'AFTER CALLING PERF STATISTICS API' ) ;

50: FND_STATS.Gather_Table_Stats(ownname => 'ONT',
51: tabname => 'OE_PAYMENTS_IFACE_ALL');
52:
53: IF l_debug_level > 0 THEN
54: oe_debug_pub.add( 'AFTER CALLING PERF STATISTICS API' ) ;
55: END IF;
56:
57: EXCEPTION
58: WHEN OTHERS THEN

Line 60: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

56:
57: EXCEPTION
58: WHEN OTHERS THEN
59: IF l_debug_level > 0 THEN
60: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
61: END IF;
62: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
63: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order_stats');
64: END IF;

Line 246: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

242: ;
243:
244:
245: --
246: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
247: --
248: BEGIN
249:
250: --MOAC set policy context for single Org

Line 258: oe_debug_pub.add( 'IMP SHIPMENTS PROFILE = '||G_IMPORT_SHIPMENTS ) ;

254:
255: fnd_profile.get('ONT_IMP_MULTIPLE_SHIPMENTS', G_IMPORT_SHIPMENTS);
256: G_IMPORT_SHIPMENTS := nvl(G_IMPORT_SHIPMENTS, 'NO');
257: IF l_debug_level > 0 THEN
258: oe_debug_pub.add( 'IMP SHIPMENTS PROFILE = '||G_IMPORT_SHIPMENTS ) ;
259: END IF;
260:
261: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
262: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);

Line 265: oe_debug_pub.add( 'DERIVED CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;

261: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
262: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
263: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
264: IF l_debug_level > 0 THEN
265: oe_debug_pub.add( 'DERIVED CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
266: END IF;
267: End If;
268:
269:

Line 318: -- OE_DEBUG_PUB.debug_on;

314: Setting Debug On
315: -----------------------------------------------------------
316: */
317: -- Removing this initialization as per change in debug package
318: -- OE_DEBUG_PUB.debug_on;
319: -- OE_DEBUG_PUB.SetDebugLevel(5);
320: -- OE_DEBUG_PUB.initialize;
321: -- If l_debug_level Is Null
322: -- Then

Line 319: -- OE_DEBUG_PUB.SetDebugLevel(5);

315: -----------------------------------------------------------
316: */
317: -- Removing this initialization as per change in debug package
318: -- OE_DEBUG_PUB.debug_on;
319: -- OE_DEBUG_PUB.SetDebugLevel(5);
320: -- OE_DEBUG_PUB.initialize;
321: -- If l_debug_level Is Null
322: -- Then
323: -- l_debug_level := to_number(nvl(fnd_profile.value('ONT_DEBUG_LEVEL'),'0'));

Line 320: -- OE_DEBUG_PUB.initialize;

316: */
317: -- Removing this initialization as per change in debug package
318: -- OE_DEBUG_PUB.debug_on;
319: -- OE_DEBUG_PUB.SetDebugLevel(5);
320: -- OE_DEBUG_PUB.initialize;
321: -- If l_debug_level Is Null
322: -- Then
323: -- l_debug_level := to_number(nvl(fnd_profile.value('ONT_DEBUG_LEVEL'),'0'));
324: -- End If;

Line 327: oe_debug_pub.add( 'AFTER SETTING DEBUG ON' ) ;

323: -- l_debug_level := to_number(nvl(fnd_profile.value('ONT_DEBUG_LEVEL'),'0'));
324: -- End If;
325:
326: IF l_debug_level > 0 THEN
327: oe_debug_pub.add( 'AFTER SETTING DEBUG ON' ) ;
328: END IF;
329:
330:
331: -----------------------------------------------------------

Line 339: l_filename := OE_DEBUG_PUB.set_debug_mode ('FILE');

335: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
336:
337: IF nvl(l_debug_level, 1) > 0 THEN
338: -- fnd_profile.put('OE_DEBUG_LOG_DIRECTORY','/sqlcom/outbound');
339: l_filename := OE_DEBUG_PUB.set_debug_mode ('FILE');
340: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
341: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
342: -- Following line moved inside because of the bug 3328608
343: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');

Line 343: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');

339: l_filename := OE_DEBUG_PUB.set_debug_mode ('FILE');
340: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
341: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
342: -- Following line moved inside because of the bug 3328608
343: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
344: END IF;
345:
346:
347:

Line 353: oe_debug_pub.add( 'BEFORE INITIALIZATION' ) ;

349: Initialization
350: -----------------------------------------------------------
351: */
352: IF l_debug_level > 0 THEN
353: oe_debug_pub.add( 'BEFORE INITIALIZATION' ) ;
354: END IF;
355: --Changes made for Bug no 5493479 start
356: /*-----------------------------------------------------------
357: Set the Context for Order Import

Line 372: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;

368: Get Concurrent Request Id
369: -----------------------------------------------------------
370: */
371: IF l_debug_level > 0 THEN
372: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;
373: oe_debug_pub.add( 'PERFORMANCE PARAMETER:' || p_perf_param);
374: END IF;
375:
376: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);

Line 373: oe_debug_pub.add( 'PERFORMANCE PARAMETER:' || p_perf_param);

369: -----------------------------------------------------------
370: */
371: IF l_debug_level > 0 THEN
372: oe_debug_pub.add( 'BEFORE GETTING REQUEST ID' ) ;
373: oe_debug_pub.add( 'PERFORMANCE PARAMETER:' || p_perf_param);
374: END IF;
375:
376: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
377:

Line 379: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;

375:
376: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
377:
378: IF l_debug_level > 0 THEN
379: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
380: END IF;
381: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
382:
383:

Line 390: oe_debug_pub.add( 'INSIDE NUM INSTANCES LOOP' ) ;

386: Sources
387: -----------------------------------------------------------
388: */
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add( 'INSIDE NUM INSTANCES LOOP' ) ;
391: oe_debug_pub.add( 'BEFORE SOURCES LOOP' ) ;
392: END IF;
393:
394: OPEN l_source_cursor;

Line 391: oe_debug_pub.add( 'BEFORE SOURCES LOOP' ) ;

387: -----------------------------------------------------------
388: */
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add( 'INSIDE NUM INSTANCES LOOP' ) ;
391: oe_debug_pub.add( 'BEFORE SOURCES LOOP' ) ;
392: END IF;
393:
394: OPEN l_source_cursor;
395: LOOP

Line 400: oe_debug_pub.add( 'SOURCE CURSOR VALUE = '||L_ORDER_SOURCE_ID ) ;

396: FETCH l_source_cursor
397: INTO l_order_source_id
398: ;
399: IF l_debug_level > 0 THEN
400: oe_debug_pub.add( 'SOURCE CURSOR VALUE = '||L_ORDER_SOURCE_ID ) ;
401: END IF;
402: EXIT WHEN l_source_cursor%NOTFOUND;
403:
404: /* -----------------------------------------------------------

Line 408: /* oe_debug_pub.add('No of orders in inf table');

404: /* -----------------------------------------------------------
405: Update Concurrent Request Ids
406: -----------------------------------------------------------
407: */
408: /* oe_debug_pub.add('No of orders in inf table');
409: SELECT COUNT(*) INTO l_ord_count
410: FROM oe_headers_iface_all
411: WHERE order_source_id = 1084
412: AND ( nvl(NULL,' ') = ' ' OR

Line 420: oe_debug_pub.add('No of ord in inf table = '||l_ord_count);

416: (nvl(NULL,' ') <> ' ' AND
417: nvl(NULL,' ') = nvl(operation_code,' ')))
418: AND request_id IS NULL
419: AND nvl(error_flag,'N') = 'N';
420: oe_debug_pub.add('No of ord in inf table = '||l_ord_count);
421: oe_debug_pub.add('before updating concurrent request id');
422: */
423:
424: UPDATE oe_headers_interface

Line 421: oe_debug_pub.add('before updating concurrent request id');

417: nvl(NULL,' ') = nvl(operation_code,' ')))
418: AND request_id IS NULL
419: AND nvl(error_flag,'N') = 'N';
420: oe_debug_pub.add('No of ord in inf table = '||l_ord_count);
421: oe_debug_pub.add('before updating concurrent request id');
422: */
423:
424: UPDATE oe_headers_interface
425: SET request_id = l_request_id

Line 495: oe_debug_pub.add( 'ROW COUNT = '||L_ROW_COUNT ) ;

491: INTO l_row_count
492: FROM oe_headers_iface_all -- MOAC
493: WHERE request_id = l_request_id;
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add( 'ROW COUNT = '||L_ROW_COUNT ) ;
496: END IF;
497:
498: IF l_row_count = 0 THEN
499: fnd_file.put_line(FND_FILE.OUTPUT,'No orders to process');

Line 521: oe_debug_pub.add( 'BATCH SIZE = '||BATCH_SIZE_ALL ) ;

517: l_mod := MOD(l_row_count,l_num_instances);
518: --batch_last := batch_size_all + MOD(l_row_count,l_num_instances);
519: END IF;
520: IF l_debug_level > 0 THEN
521: oe_debug_pub.add( 'BATCH SIZE = '||BATCH_SIZE_ALL ) ;
522: oe_debug_pub.add( 'MOD = '||L_MOD ) ;
523: END IF;
524:
525: IF l_num_instances > l_row_count THEN

Line 522: oe_debug_pub.add( 'MOD = '||L_MOD ) ;

518: --batch_last := batch_size_all + MOD(l_row_count,l_num_instances);
519: END IF;
520: IF l_debug_level > 0 THEN
521: oe_debug_pub.add( 'BATCH SIZE = '||BATCH_SIZE_ALL ) ;
522: oe_debug_pub.add( 'MOD = '||L_MOD ) ;
523: END IF;
524:
525: IF l_num_instances > l_row_count THEN
526: l_num_instances := l_row_count;

Line 530: oe_debug_pub.add( 'NUM INSTANCES = '||L_NUM_INSTANCES ) ;

526: l_num_instances := l_row_count;
527: END IF;
528:
529: IF l_debug_level > 0 THEN
530: oe_debug_pub.add( 'NUM INSTANCES = '||L_NUM_INSTANCES ) ;
531: END IF;
532: FOR loop_counter IN 1..l_num_instances LOOP
533: IF l_debug_level > 0 THEN
534: oe_debug_pub.add( 'INSIDE FOR LOOP FOR SPAWNING CHILD REQ' ) ;

Line 534: oe_debug_pub.add( 'INSIDE FOR LOOP FOR SPAWNING CHILD REQ' ) ;

530: oe_debug_pub.add( 'NUM INSTANCES = '||L_NUM_INSTANCES ) ;
531: END IF;
532: FOR loop_counter IN 1..l_num_instances LOOP
533: IF l_debug_level > 0 THEN
534: oe_debug_pub.add( 'INSIDE FOR LOOP FOR SPAWNING CHILD REQ' ) ;
535: END IF;
536: batch_size := batch_size_all;
537: x_num_instances := 0;
538: -- x_new_request_id := new_request_id;

Line 545: oe_debug_pub.add( 'CHILD REQUEST ID = '||NEW_REQUEST_ID ) ;

541: p_validate_only, p_debug_level, 0, NULL, NULL, NULL, p_perf_param,p_rtrim_data,
542: p_process_orders_with_null_org,p_default_org_id,p_validate_desc_flex);
543:
544: IF l_debug_level > 0 THEN
545: oe_debug_pub.add( 'CHILD REQUEST ID = '||NEW_REQUEST_ID ) ;
546: END IF;
547: fnd_file.put_line(FND_FILE.OUTPUT, 'Child Request ID: '||new_request_id);
548:
549: IF (new_request_id = 0) THEN

Line 558: oe_debug_pub.add( 'BEFORE UPDATING REQ ID' ) ;

554: IF loop_counter <= l_mod THEN
555: batch_size := batch_size_all + 1;
556: END IF;
557: IF l_debug_level > 0 THEN
558: oe_debug_pub.add( 'BEFORE UPDATING REQ ID' ) ;
559: oe_debug_pub.add( 'LOOP COUNT = '||LOOP_COUNTER ) ;
560: oe_debug_pub.add( 'BATCH_SIZE_ALL = '||BATCH_SIZE_ALL ) ;
561: oe_debug_pub.add( 'BATCH_SIZE = '||BATCH_SIZE ) ;
562: END IF;

Line 559: oe_debug_pub.add( 'LOOP COUNT = '||LOOP_COUNTER ) ;

555: batch_size := batch_size_all + 1;
556: END IF;
557: IF l_debug_level > 0 THEN
558: oe_debug_pub.add( 'BEFORE UPDATING REQ ID' ) ;
559: oe_debug_pub.add( 'LOOP COUNT = '||LOOP_COUNTER ) ;
560: oe_debug_pub.add( 'BATCH_SIZE_ALL = '||BATCH_SIZE_ALL ) ;
561: oe_debug_pub.add( 'BATCH_SIZE = '||BATCH_SIZE ) ;
562: END IF;
563:

Line 560: oe_debug_pub.add( 'BATCH_SIZE_ALL = '||BATCH_SIZE_ALL ) ;

556: END IF;
557: IF l_debug_level > 0 THEN
558: oe_debug_pub.add( 'BEFORE UPDATING REQ ID' ) ;
559: oe_debug_pub.add( 'LOOP COUNT = '||LOOP_COUNTER ) ;
560: oe_debug_pub.add( 'BATCH_SIZE_ALL = '||BATCH_SIZE_ALL ) ;
561: oe_debug_pub.add( 'BATCH_SIZE = '||BATCH_SIZE ) ;
562: END IF;
563:
564: IF (p_perf_param = 'Y') THEN

Line 561: oe_debug_pub.add( 'BATCH_SIZE = '||BATCH_SIZE ) ;

557: IF l_debug_level > 0 THEN
558: oe_debug_pub.add( 'BEFORE UPDATING REQ ID' ) ;
559: oe_debug_pub.add( 'LOOP COUNT = '||LOOP_COUNTER ) ;
560: oe_debug_pub.add( 'BATCH_SIZE_ALL = '||BATCH_SIZE_ALL ) ;
561: oe_debug_pub.add( 'BATCH_SIZE = '||BATCH_SIZE ) ;
562: END IF;
563:
564: IF (p_perf_param = 'Y') THEN
565: -- only update one record

Line 596: --oe_debug_pub.add('before headers loop');

592: /* -----------------------------------------------------------
593: Headers
594: -----------------------------------------------------------
595: */
596: --oe_debug_pub.add('before headers loop');
597:
598: l_count_header := 0;
599: l_count_header_success := 0;
600: l_count_header_failure := 0;

Line 605: oe_debug_pub.add( 'after goto') ;

601:
602: <>
603:
604: IF l_debug_level > 0 THEN
605: oe_debug_pub.add( 'after goto') ;
606: END IF;
607:
608: -- if profile is set to 'Y' do updates in interface table based on
609: -- customer-inclusive key information

Line 615: oe_debug_pub.add( 'customer key profile was yes') ;

611:
612: if (l_customer_key_profile = 'Y') then
613:
614: IF l_debug_level > 0 THEN
615: oe_debug_pub.add( 'customer key profile was yes') ;
616: END IF;
617:
618:
619: -- start of customer inclusive request_id updates

Line 634: oe_debug_pub.add('rows updated: ' || sql%rowcount);

630: = decode(p_perf_param, 'Y',
631: 'N', ' '); */ -- Bug 5205691
632:
633: IF l_debug_level > 0 THEN
634: oe_debug_pub.add('rows updated: ' || sql%rowcount);
635: END IF;
636:
637: COMMIT;
638:

Line 670: oe_debug_pub.add('oe payments rows updated: ' || sql%rowcount);

666: 'N', ' '); */ -- Bug 5205691
667:
668:
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add('oe payments rows updated: ' || sql%rowcount);
671: END IF;
672:
673: COMMIT;
674:

Line 778: oe_debug_pub.add('setting looped flag');

774: -- been set already
775: If p_perf_param = 'Y' then
776: If l_looped_flag = 'N' then
777: IF l_debug_level > 0 THEN
778: oe_debug_pub.add('setting looped flag');
779: END IF;
780: l_looped_flag := 'Y';
781: End If;
782: End If;

Line 785: oe_debug_pub.add('Performance Parameter: ' || p_perf_param);

781: End If;
782: End If;
783:
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add('Performance Parameter: ' || p_perf_param);
786: END IF;
787:
788: IF ( p_perf_param = 'Y') THEN
789:

Line 801: oe_debug_pub.add('Unexpected error: '||sqlerrm);

797:
798: exception
799: when others then
800: IF l_debug_level > 0 THEN
801: oe_debug_pub.add('Unexpected error: '||sqlerrm);
802: END IF;
803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
804: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
805: END IF;

Line 814: oe_debug_pub.add('first parent ' || l_pnt_request_id);

810:
811: end if;
812:
813: IF l_debug_level > 0 THEN
814: oe_debug_pub.add('first parent ' || l_pnt_request_id);
815: END IF;
816: END IF;
817:
818: --if customer_key_profile <> 'Y'

Line 963: oe_debug_pub.add( 'ORDER SOURCE ID: '|| TO_CHAR ( L_ORDER_SOURCE_ID ) ) ;

959:
960: l_count_header := l_count_header + 1;
961:
962: IF l_debug_level > 0 THEN
963: oe_debug_pub.add( 'ORDER SOURCE ID: '|| TO_CHAR ( L_ORDER_SOURCE_ID ) ) ;
964: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
965: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
966: oe_debug_pub.add( 'ORG ID: '||l_org_id);
967: oe_debug_pub.add( 'L_RETURN_STATUS: ' || L_RETURN_STATUS ) ;

Line 964: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;

960: l_count_header := l_count_header + 1;
961:
962: IF l_debug_level > 0 THEN
963: oe_debug_pub.add( 'ORDER SOURCE ID: '|| TO_CHAR ( L_ORDER_SOURCE_ID ) ) ;
964: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
965: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
966: oe_debug_pub.add( 'ORG ID: '||l_org_id);
967: oe_debug_pub.add( 'L_RETURN_STATUS: ' || L_RETURN_STATUS ) ;
968: END IF;

Line 965: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;

961:
962: IF l_debug_level > 0 THEN
963: oe_debug_pub.add( 'ORDER SOURCE ID: '|| TO_CHAR ( L_ORDER_SOURCE_ID ) ) ;
964: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
965: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
966: oe_debug_pub.add( 'ORG ID: '||l_org_id);
967: oe_debug_pub.add( 'L_RETURN_STATUS: ' || L_RETURN_STATUS ) ;
968: END IF;
969:

Line 966: oe_debug_pub.add( 'ORG ID: '||l_org_id);

962: IF l_debug_level > 0 THEN
963: oe_debug_pub.add( 'ORDER SOURCE ID: '|| TO_CHAR ( L_ORDER_SOURCE_ID ) ) ;
964: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
965: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
966: oe_debug_pub.add( 'ORG ID: '||l_org_id);
967: oe_debug_pub.add( 'L_RETURN_STATUS: ' || L_RETURN_STATUS ) ;
968: END IF;
969:
970: -- MOAC set the policy context based on the org_id

Line 967: oe_debug_pub.add( 'L_RETURN_STATUS: ' || L_RETURN_STATUS ) ;

963: oe_debug_pub.add( 'ORDER SOURCE ID: '|| TO_CHAR ( L_ORDER_SOURCE_ID ) ) ;
964: oe_debug_pub.add( 'ORIG SYS REFERENCE: '|| L_ORIG_SYS_DOCUMENT_REF ) ;
965: oe_debug_pub.add( 'CHANGE SEQUENCE: ' || L_CHANGE_SEQUENCE ) ;
966: oe_debug_pub.add( 'ORG ID: '||l_org_id);
967: oe_debug_pub.add( 'L_RETURN_STATUS: ' || L_RETURN_STATUS ) ;
968: END IF;
969:
970: -- MOAC set the policy context based on the org_id
971: If G_ORG_ID IS NULL THEN

Line 985: --oe_debug_pub.add('before calling Import_Order procedure');

981: /* -----------------------------------------------------------
982: Call Import_Order procedure
983: -----------------------------------------------------------
984: */
985: --oe_debug_pub.add('before calling Import_Order procedure');
986:
987:
988: IF l_closed_flag = 'N' THEN
989: --

Line 991: oe_debug_pub.add( 'BEFORE CALLING IMPORT_ORDER PROCEDURE' ) ;

987:
988: IF l_closed_flag = 'N' THEN
989: --
990: IF l_debug_level > 0 THEN
991: oe_debug_pub.add( 'BEFORE CALLING IMPORT_ORDER PROCEDURE' ) ;
992: oe_debug_pub.add('rtrim data ='||nvl(l_rtrim_data,'Null'));
993: END IF;
994: OE_ORDER_IMPORT_PVT.Import_Order (
995: p_request_id => l_request_id,

Line 992: oe_debug_pub.add('rtrim data ='||nvl(l_rtrim_data,'Null'));

988: IF l_closed_flag = 'N' THEN
989: --
990: IF l_debug_level > 0 THEN
991: oe_debug_pub.add( 'BEFORE CALLING IMPORT_ORDER PROCEDURE' ) ;
992: oe_debug_pub.add('rtrim data ='||nvl(l_rtrim_data,'Null'));
993: END IF;
994: OE_ORDER_IMPORT_PVT.Import_Order (
995: p_request_id => l_request_id,
996: p_order_source_id => l_order_source_id,

Line 1014: oe_debug_pub.add( 'BEFORE CALLING IMPORT_ORDER PROCEDURE FOR CLOSED' ) ;

1010:
1011: ELSE
1012: --
1013: IF l_debug_level > 0 THEN
1014: oe_debug_pub.add( 'BEFORE CALLING IMPORT_ORDER PROCEDURE FOR CLOSED' ) ;
1015: END IF;
1016: OE_CNCL_ORDER_IMPORT_PVT.Import_Order (
1017: p_request_id => l_request_id,
1018: p_order_source_id => l_order_source_id,

Line 1033: --oe_debug_pub.add('after call Import_Order l_return_status ' || l_return_status);

1029: );
1030: --
1031: END IF;
1032:
1033: --oe_debug_pub.add('after call Import_Order l_return_status ' || l_return_status);
1034: IF l_return_status = FND_API.G_RET_STS_ERROR OR
1035: l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
1036: THEN
1037: l_count_header_failure := l_count_header_failure + 1;

Line 1046: oe_debug_pub.add('after order_import for docref='|| l_orig_sys_document_ref || ' and request_id ' || l_request_id);

1042:
1043: IF (p_perf_param = 'Y') THEN
1044:
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add('after order_import for docref='|| l_orig_sys_document_ref || ' and request_id ' || l_request_id);
1047: oe_debug_pub.add('parent request_id:' || l_pnt_request_id);
1048: END IF;
1049:
1050:

Line 1047: oe_debug_pub.add('parent request_id:' || l_pnt_request_id);

1043: IF (p_perf_param = 'Y') THEN
1044:
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add('after order_import for docref='|| l_orig_sys_document_ref || ' and request_id ' || l_request_id);
1047: oe_debug_pub.add('parent request_id:' || l_pnt_request_id);
1048: END IF;
1049:
1050:
1051: begin

Line 1072: oe_debug_pub.add('rowcount:' || sql%rowcount || ' updated docref:' || l_updated_docref);

1068:
1069:
1070: if sql%rowcount > 0 then
1071: IF l_debug_level > 0 THEN
1072: oe_debug_pub.add('rowcount:' || sql%rowcount || ' updated docref:' || l_updated_docref);
1073: END IF;
1074: commit;
1075: exit;
1076: end if;

Line 1082: oe_debug_pub.add('after cursor closed');

1078: end loop;
1079:
1080: close l_request_cursor;
1081: IF l_debug_level > 0 THEN
1082: oe_debug_pub.add('after cursor closed');
1083: END IF;
1084: goto dist;
1085:
1086: exception

Line 1089: oe_debug_pub.add('In handled no data found exception');

1085:
1086: exception
1087: when no_data_found then
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add('In handled no data found exception');
1090: oe_debug_pub.add('No more records to process');
1091: END IF;
1092:
1093: EXIT;

Line 1090: oe_debug_pub.add('No more records to process');

1086: exception
1087: when no_data_found then
1088: IF l_debug_level > 0 THEN
1089: oe_debug_pub.add('In handled no data found exception');
1090: oe_debug_pub.add('No more records to process');
1091: END IF;
1092:
1093: EXIT;
1094: when others then

Line 1096: oe_debug_pub.add('others exception when attempting update' ||sqlerrm);

1092:
1093: EXIT;
1094: when others then
1095: IF l_debug_level > 0 THEN
1096: oe_debug_pub.add('others exception when attempting update' ||sqlerrm);
1097: END IF;
1098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1099: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
1100: END IF;

Line 1113: oe_debug_pub.add( 'NO. OF ORDERS FOUND: ' || L_COUNT_HEADER ) ;

1109:
1110: CLOSE l_request_cursor;
1111:
1112: IF l_debug_level > 0 THEN
1113: oe_debug_pub.add( 'NO. OF ORDERS FOUND: ' || L_COUNT_HEADER ) ;
1114: oe_debug_pub.add( 'NO. OF ORDERS IMPORTED: '|| L_COUNT_HEADER_SUCCESS ) ;
1115: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;
1116: END IF;
1117:

Line 1114: oe_debug_pub.add( 'NO. OF ORDERS IMPORTED: '|| L_COUNT_HEADER_SUCCESS ) ;

1110: CLOSE l_request_cursor;
1111:
1112: IF l_debug_level > 0 THEN
1113: oe_debug_pub.add( 'NO. OF ORDERS FOUND: ' || L_COUNT_HEADER ) ;
1114: oe_debug_pub.add( 'NO. OF ORDERS IMPORTED: '|| L_COUNT_HEADER_SUCCESS ) ;
1115: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;
1116: END IF;
1117:
1118: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||

Line 1115: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;

1111:
1112: IF l_debug_level > 0 THEN
1113: oe_debug_pub.add( 'NO. OF ORDERS FOUND: ' || L_COUNT_HEADER ) ;
1114: oe_debug_pub.add( 'NO. OF ORDERS IMPORTED: '|| L_COUNT_HEADER_SUCCESS ) ;
1115: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;
1116: END IF;
1117:
1118: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||
1119: l_count_header);

Line 1141: oe_debug_pub.add( 'BEFORE MESSAGES LOOP' ) ;

1137: Messages
1138: -----------------------------------------------------------
1139: */
1140: IF l_debug_level > 0 THEN
1141: oe_debug_pub.add( 'BEFORE MESSAGES LOOP' ) ;
1142: END IF;
1143:
1144: fnd_file.put_line(FND_FILE.OUTPUT,'');
1145: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');

Line 1173: oe_debug_pub.add( 'END OF ORDER IMPORT CONCURRENT PROGRAM' ) ;

1169: End of Order_Import_Conc_Pgm
1170: -----------------------------------------------------------
1171: */
1172: IF l_debug_level > 0 THEN
1173: oe_debug_pub.add( 'END OF ORDER IMPORT CONCURRENT PROGRAM' ) ;
1174: END IF;
1175: fnd_file.put_line(FND_FILE.OUTPUT, 'End of Order Import Concurrent Program');
1176: retcode := 0;
1177: --return;

Line 1182: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;

1178:
1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: IF l_debug_level > 0 THEN
1182: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
1183: END IF;
1184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1185: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
1186: END IF;

Line 1224: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1220:
1221: l_closed_flag VARCHAR2(1) DEFAULT 'N';
1222:
1223: --
1224: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1225: --
1226: BEGIN
1227:
1228:

Line 1232: oe_debug_pub.add( 'Setting policy context to single-org' ) ;

1228:
1229: --MOAC set policy context for single Org
1230: IF p_org_id IS NOT NULL THEN
1231: IF l_debug_level > 0 THEN
1232: oe_debug_pub.add( 'Setting policy context to single-org' ) ;
1233: END IF;
1234: MO_GLOBAL.set_policy_context('S',p_org_id);
1235: END IF;
1236:

Line 1253: oe_debug_pub.add( 'BEFORE CALLING IMPORT_ORDER PROCEDURE' ) ;

1249:
1250: IF (NVL(l_closed_flag,'N') = 'N') THEN
1251: --
1252: IF l_debug_level > 0 THEN
1253: oe_debug_pub.add( 'BEFORE CALLING IMPORT_ORDER PROCEDURE' ) ;
1254: END IF;
1255:
1256:
1257: OE_ORDER_IMPORT_PVT.Import_Order (

Line 1277: oe_debug_pub.add( 'BEFORE CALLING IMPORT_ORDER PROCEDURE FOR CLOSED' ) ;

1273:
1274: ELSE
1275: --
1276: IF l_debug_level > 0 THEN
1277: oe_debug_pub.add( 'BEFORE CALLING IMPORT_ORDER PROCEDURE FOR CLOSED' ) ;
1278: END IF;
1279:
1280:
1281: OE_CNCL_ORDER_IMPORT_PVT.Import_Order (