DBA Data[Home] [Help]

APPS.OE_BULK_ORDER_PVT dependencies on FND_FILE

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

291: IF l_debug_level > 0 Then
292: SELECT hsecs INTO l_end_time from v$timer;
293: end if;
294:
295: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Headers is (sec) '||((l_end_time-l_start_time)/100));
296:
297: IF G_HEADER_REC.HEADER_ID.COUNT = 0 THEN
298: IF l_debug_level > 0 THEN
299: oe_debug_pub.add( 'NO ORDERS IN THIS BATCH , EXIT!' ) ;

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

329: SELECT hsecs INTO l_end_time from v$timer;
330: end if;
331:
332:
333: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Headers Entity validation is (sec) '||((l_end_time-l_start_time)/100));
334:
335:
336: -------------------------------------------------------------------
337: -- Insert Messages into DB from above processing call

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

356: IF l_debug_level > 0 Then
357: SELECT hsecs INTO l_end_time from v$timer;
358: end if;
359:
360: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Save Messages is (sec) '||((l_end_time-l_start_time)/100));
361:
362:
363: ------------------------------------------------------------
364: -- Update Headers Interface table for invalid headers.

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

377: IF l_debug_level > 0 Then
378: SELECT hsecs INTO l_end_time from v$timer;
379: end if;
380:
381: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Process_Invalid_Records is (sec) '||((l_end_time-l_start_time)/100));
382:
383: IF p_validate_only = 'Y' THEN
384: RETURN;
385: END IF;

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

403: IF l_debug_level > 0 Then
404: SELECT hsecs INTO l_end_time from v$timer;
405: end if;
406:
407: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Create Sales Credits is (sec) '
408: ||((l_end_time-l_start_time)/100));
409:
410: EXCEPTION
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

460: -- is enabled, as hsec is used for logging only when debug is enabled.
461: SELECT hsecs INTO l_end_time from v$timer;
462: END IF;
463:
464: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load_Lines is (sec) '||((l_end_time-l_start_time)/100));
465:
466: IF G_LINE_REC.LINE_ID.COUNT = 0 THEN
467: IF l_debug_level > 0 THEN
468: oe_debug_pub.add( 'NO LINES IN THIS BATCH , EXIT!' ) ;

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

498: IF l_debug_level > 0 Then
499: SELECT hsecs INTO l_end_time from v$timer;
500: end if;
501:
502: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Entity Validation is (sec) '||((l_end_time-l_start_time)/100));
503:
504:
505: -- Insert Messages
506: IF l_debug_level > 0 THEN

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

524: IF l_debug_level > 0 Then
525: SELECT hsecs INTO l_end_time from v$timer;
526: end if;
527:
528: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Process_Invalid Records for lines is (sec) '||((l_end_time-l_start_time)/100));
529:
530: -------------------------------------------------------------------
531: -- Create Line Sales Credits
532: -------------------------------------------------------------------

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

546: IF l_debug_level > 0 Then
547: SELECT hsecs INTO l_end_time from v$timer;
548: end if;
549:
550: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Create Line Sales Credits is (sec) '
551: ||((l_end_time-l_start_time)/100));
552:
553: EXCEPTION
554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

629: SELECT hsecs INTO l_end_time from v$timer;
630: end if;
631:
632:
633: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in MTL_SALES_ORDERS creates is (sec) '
634: ||((l_end_time-l_start_time)/100));
635:
636:
637: -------------------------------------------------------------------

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

663: IF l_debug_level > 0 Then
664: SELECT hsecs INTO l_end_time from v$timer;
665: end if;
666:
667: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Scheduling is (sec) '
668: ||((l_end_time-l_start_time)/100));
669:
670: END IF;
671:

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

716: SELECT hsecs INTO l_end_time from v$timer;
717: end if;
718:
719:
720: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in HVOP Pricing is (sec) '
721: ||((l_end_time-l_start_time)/100));
722:
723: END IF;
724: --PIB

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

731:
732: OE_Bulk_Tax_Util.Calculate_Tax(p_post_insert => FALSE);
733: select hsecs into l_end_time from v$timer;
734:
735: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Tax is (sec) '
736: ||((l_end_time-l_start_time)/100));
737:
738: IF G_ERROR_COUNT < G_ERROR_REC.order_source_id.COUNT THEN
739: Process_Invalid_Records;

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

767: IF l_debug_level > 0 Then
768: SELECT hsecs INTO l_end_time from v$timer;
769: end if;
770:
771: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_headers is (sec) '||((l_end_time-l_start_time)/100));
772:
773: -- Bug 5640601 =>
774: -- Selecting hsecs from v$times is changed to execute only when debug
775: -- is enabled, as hsec is used for logging only when debug is enabled.

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

787: IF l_debug_level > 0 Then
788: SELECT hsecs INTO l_end_time from v$timer;
789: end if;
790:
791: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_Lines is (sec) '||((l_end_time-l_start_time)/100));
792:
793:
794: -------------------------------------------------------------------
795: -- Create Holds

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

810: IF l_debug_level > 0 Then
811: SELECT hsecs INTO l_end_time from v$timer;
812: end if;
813:
814: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Evaluating Holds is (sec) '
815: ||((l_end_time-l_start_time)/100));
816:
817:
818: -------------------------------------------------------------------

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

844: IF l_debug_level > 0 Then
845: SELECT hsecs INTO l_end_time from v$timer;
846: end if;
847:
848: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Update DBI Logs is (sec) '
849: ||((l_end_time-l_start_time)/100));
850:
851: END IF;
852:

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

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

Line 932: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Pricing 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 Pricing is (sec) '
933: ||((l_end_time-l_start_time)/100));
934:
935: ELSIF (G_CC_REQUIRED = 'Y' and l_credit_check_method = 'NEW') THEN --bug 4558078
936: OE_BULK_PRICEORDER_PVT.credit_check(OE_BULK_ORDER_PVT.G_HEADER_REC);

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

972: IF l_debug_level > 0 Then
973: SELECT hsecs INTO l_end_time from v$timer;
974: end if;
975:
976: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Acknowledgments is (sec) '
977: ||((l_end_time-l_start_time)/100));
978:
979: END IF;
980:

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

1005: IF l_debug_level > 0 Then
1006: SELECT hsecs INTO l_end_time from v$timer;
1007: end if;
1008:
1009: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Starting Workflows is (sec) '
1010: ||((l_end_time-l_start_time)/100));
1011:
1012:
1013: -------------------------------------------------------------------

Line 1051: FND_FILE.PUT_LINE

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

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

1048: SELECT hsecs INTO l_end_time from v$timer;
1049: end if;
1050:
1051: FND_FILE.PUT_LINE
1052: (FND_FILE.LOG,'Time spent in OM to WSH Interface is (sec) '
1053: ||((l_end_time-l_start_time)/100));
1054:
1055:
1056: EXCEPTION

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

1167: -- is enabled, as hsec is used for logging only when debug is enabled.
1168: IF l_debug_level > 0 Then
1169: SELECT hsecs INTO l_end_time from v$timer;
1170: end if;
1171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Pre_Process is (sec) '
1172: ||((l_end_time-l_start_time)/100));
1173:
1174:
1175: -------------------------------------------------------------------

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

1188: -- is enabled, as hsec is used for logging only when debug is enabled.
1189: IF l_debug_level > 0 Then
1190: SELECT hsecs INTO l_end_time from v$timer;
1191: end if;
1192: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Attribute Validation is (sec) '
1193: ||((l_end_time-l_start_time)/100));
1194:
1195:
1196: -------------------------------------------------------------------

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

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

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

1262: p_use_configurator => G_CONFIGURATOR_USED,
1263: p_validate_configurations => p_validate_configurations);
1264:
1265: SELECT hsecs INTO l_end_time from v$timer;
1266: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in CONFIG Pre_Process is (sec) '
1267: ||((l_end_time-l_start_time)/100));
1268:
1269: END IF;
1270: