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_BULK_ORDER_PVT dependencies on FND_FILE

Line 335: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Headers is (sec) '||((l_end_time-l_start_time)/100));

331: IF l_debug_level > 0 Then
332: SELECT hsecs INTO l_end_time from v$timer;
333: end if;
334:
335: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Headers is (sec) '||((l_end_time-l_start_time)/100));
336:
337: IF G_HEADER_REC.HEADER_ID.COUNT = 0 THEN
338: IF l_debug_level > 0 THEN
339: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;

Line 373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Headers Entity validation is (sec) '||((l_end_time-l_start_time)/100));

369: SELECT hsecs INTO l_end_time from v$timer;
370: end if;
371:
372:
373: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Headers Entity validation is (sec) '||((l_end_time-l_start_time)/100));
374:
375:
376: -------------------------------------------------------------------
377: -- Insert Messages into DB from above processing call

Line 400: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Save Messages is (sec) '||((l_end_time-l_start_time)/100));

396: IF l_debug_level > 0 Then
397: SELECT hsecs INTO l_end_time from v$timer;
398: end if;
399:
400: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Save Messages is (sec) '||((l_end_time-l_start_time)/100));
401:
402:
403: ------------------------------------------------------------
404: -- Update Headers Interface table for invalid headers.

Line 421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Process_Invalid_Records is (sec) '||((l_end_time-l_start_time)/100));

417: IF l_debug_level > 0 Then
418: SELECT hsecs INTO l_end_time from v$timer;
419: end if;
420:
421: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Process_Invalid_Records is (sec) '||((l_end_time-l_start_time)/100));
422:
423: IF p_validate_only = 'Y' THEN
424: RETURN;
425: END IF;

Line 447: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Create Sales Credits is (sec) '

443: IF l_debug_level > 0 Then
444: SELECT hsecs INTO l_end_time from v$timer;
445: end if;
446:
447: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Create Sales Credits is (sec) '
448: ||((l_end_time-l_start_time)/100));
449:
450: EXCEPTION
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 504: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Lines is (sec) '||((l_end_time-l_start_time)/100));

500: -- is enabled, as hsec is used for logging only when debug is enabled.
501: SELECT hsecs INTO l_end_time from v$timer;
502: END IF;
503:
504: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Lines is (sec) '||((l_end_time-l_start_time)/100));
505:
506: IF G_LINE_REC.LINE_ID.COUNT = 0 THEN
507: IF l_debug_level > 0 THEN
508: oe_debug_pub.add( 'NO LINES IN THIS BATCH , EXIT!' ) ;

Line 542: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Entity Validation is (sec) '||((l_end_time-l_start_time)/100));

538: IF l_debug_level > 0 Then
539: SELECT hsecs INTO l_end_time from v$timer;
540: end if;
541:
542: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Entity Validation is (sec) '||((l_end_time-l_start_time)/100));
543:
544:
545: -- Insert Messages
546: IF l_debug_level > 0 THEN

Line 568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Process_Invalid Records for lines is (sec) '||((l_end_time-l_start_time)/100));

564: IF l_debug_level > 0 Then
565: SELECT hsecs INTO l_end_time from v$timer;
566: end if;
567:
568: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Process_Invalid Records for lines is (sec) '||((l_end_time-l_start_time)/100));
569:
570: -------------------------------------------------------------------
571: -- Create Line Sales Credits
572: -------------------------------------------------------------------

Line 590: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Create Line Sales Credits is (sec) '

586: IF l_debug_level > 0 Then
587: SELECT hsecs INTO l_end_time from v$timer;
588: end if;
589:
590: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Create Line Sales Credits is (sec) '
591: ||((l_end_time-l_start_time)/100));
592:
593: EXCEPTION
594: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in MTL_SALES_ORDERS creates is (sec) '

669: SELECT hsecs INTO l_end_time from v$timer;
670: end if;
671:
672:
673: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in MTL_SALES_ORDERS creates is (sec) '
674: ||((l_end_time-l_start_time)/100));
675:
676:
677: -------------------------------------------------------------------

Line 707: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Scheduling is (sec) '

703: IF l_debug_level > 0 Then
704: SELECT hsecs INTO l_end_time from v$timer;
705: end if;
706:
707: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Scheduling is (sec) '
708: ||((l_end_time-l_start_time)/100));
709:
710: END IF;
711:

Line 760: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in HVOP Pricing is (sec) '

756: SELECT hsecs INTO l_end_time from v$timer;
757: end if;
758:
759:
760: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in HVOP Pricing is (sec) '
761: ||((l_end_time-l_start_time)/100));
762:
763: END IF;
764: --PIB

Line 776: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Tax is (sec) '

772: /*TAX ER Commented the call to calculate_tax as the call is happening twice */
773: -- OE_Bulk_Tax_Util.Calculate_Tax(p_post_insert => FALSE); --TAX ER
774: select hsecs into l_end_time from v$timer;
775:
776: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Tax is (sec) '
777: ||((l_end_time-l_start_time)/100));
778:
779: IF G_ERROR_COUNT < G_ERROR_REC.order_source_id.COUNT THEN
780: Process_Invalid_Records;

Line 812: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_headers is (sec) '||((l_end_time-l_start_time)/100));

808: IF l_debug_level > 0 Then
809: SELECT hsecs INTO l_end_time from v$timer;
810: end if;
811:
812: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_headers is (sec) '||((l_end_time-l_start_time)/100));
813:
814: -- Bug 5640601 =>
815: -- Selecting hsecs from v$times is changed to execute only when debug
816: -- is enabled, as hsec is used for logging only when debug is enabled.

Line 832: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_Lines is (sec) '||((l_end_time-l_start_time)/100));

828: IF l_debug_level > 0 Then
829: SELECT hsecs INTO l_end_time from v$timer;
830: end if;
831:
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_Lines is (sec) '||((l_end_time-l_start_time)/100));
833:
834:
835: -------------------------------------------------------------------
836: -- Create Holds

Line 855: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Evaluating Holds is (sec) '

851: IF l_debug_level > 0 Then
852: SELECT hsecs INTO l_end_time from v$timer;
853: end if;
854:
855: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Evaluating Holds is (sec) '
856: ||((l_end_time-l_start_time)/100));
857:
858:
859: -------------------------------------------------------------------

Line 889: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Update DBI Logs is (sec) '

885: IF l_debug_level > 0 Then
886: SELECT hsecs INTO l_end_time from v$timer;
887: end if;
888:
889: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Update DBI Logs is (sec) '
890: ||((l_end_time-l_start_time)/100));
891:
892: END IF;
893:

Line 932: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Inserting Price Adjs is (sec) '

928: IF l_debug_level > 0 Then
929: SELECT hsecs INTO l_end_time from v$timer;
930: end if;
931:
932: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Inserting Price Adjs is (sec) '
933: ||((l_end_time-l_start_time)/100));
934:
935: END IF;
936:

Line 973: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Pricing is (sec) '

969: IF l_debug_level > 0 Then
970: SELECT hsecs INTO l_end_time from v$timer;
971: end if;
972:
973: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Pricing is (sec) '
974: ||((l_end_time-l_start_time)/100));
975:
976: ELSIF (G_CC_REQUIRED = 'Y' and l_credit_check_method = 'NEW') THEN --bug 4558078
977: OE_BULK_PRICEORDER_PVT.credit_check(OE_BULK_ORDER_PVT.G_HEADER_REC);

Line 1017: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Acknowledgments is (sec) '

1013: IF l_debug_level > 0 Then
1014: SELECT hsecs INTO l_end_time from v$timer;
1015: end if;
1016:
1017: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Acknowledgments is (sec) '
1018: ||((l_end_time-l_start_time)/100));
1019:
1020: END IF;
1021:

Line 1050: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Starting Workflows is (sec) '

1046: IF l_debug_level > 0 Then
1047: SELECT hsecs INTO l_end_time from v$timer;
1048: end if;
1049:
1050: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Starting Workflows is (sec) '
1051: ||((l_end_time-l_start_time)/100));
1052:
1053:
1054: -------------------------------------------------------------------

Line 1092: FND_FILE.PUT_LINE

1088: IF l_debug_level > 0 Then
1089: SELECT hsecs INTO l_end_time from v$timer;
1090: end if;
1091:
1092: FND_FILE.PUT_LINE
1093: (FND_FILE.LOG,'Time spent in OM to WSH Interface is (sec) '
1094: ||((l_end_time-l_start_time)/100));
1095:
1096:

Line 1093: (FND_FILE.LOG,'Time spent in OM to WSH Interface is (sec) '

1089: SELECT hsecs INTO l_end_time from v$timer;
1090: end if;
1091:
1092: FND_FILE.PUT_LINE
1093: (FND_FILE.LOG,'Time spent in OM to WSH Interface is (sec) '
1094: ||((l_end_time-l_start_time)/100));
1095:
1096:
1097: EXCEPTION

Line 1212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Pre_Process is (sec) '

1208: -- is enabled, as hsec is used for logging only when debug is enabled.
1209: IF l_debug_level > 0 Then
1210: SELECT hsecs INTO l_end_time from v$timer;
1211: end if;
1212: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Pre_Process is (sec) '
1213: ||((l_end_time-l_start_time)/100));
1214:
1215:
1216: -------------------------------------------------------------------

Line 1233: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Attribute Validation is (sec) '

1229: -- is enabled, as hsec is used for logging only when debug is enabled.
1230: IF l_debug_level > 0 Then
1231: SELECT hsecs INTO l_end_time from v$timer;
1232: end if;
1233: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Attribute Validation is (sec) '
1234: ||((l_end_time-l_start_time)/100));
1235:
1236:
1237: -------------------------------------------------------------------

Line 1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Value To ID is (sec) '

1268: -- is enabled, as hsec is used for logging only when debug is enabled.
1269: IF l_debug_level > 0 Then
1270: SELECT hsecs INTO l_end_time from v$timer;
1271: end if;
1272: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Value To ID is (sec) '
1273: ||((l_end_time-l_start_time)/100));
1274:
1275:
1276: -------------------------------------------------------------------

Line 1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in CONFIG Pre_Process is (sec) '

1303: p_use_configurator => G_CONFIGURATOR_USED,
1304: p_validate_configurations => p_validate_configurations);
1305:
1306: SELECT hsecs INTO l_end_time from v$timer;
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in CONFIG Pre_Process is (sec) '
1308: ||((l_end_time-l_start_time)/100));
1309:
1310: END IF;
1311: