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 V$TIMER

Line 281: SELECT hsecs INTO l_start_time from v$timer;

277: -- Bug 5640601 =>
278: -- Selecting hsecs from v$times is changed to execute only when debug
279: -- is enabled, as hsec is used for logging only when debug is enabled.
280: IF l_debug_level > 0 Then
281: SELECT hsecs INTO l_start_time from v$timer;
282: end if;
283:
284: OE_Bulk_Header_Util.Load_Headers
285: (p_batch_id => p_batch_id

Line 292: SELECT hsecs INTO l_end_time from v$timer;

288: -- Bug 5640601 =>
289: -- Selecting hsecs from v$times is changed to execute only when debug
290: -- is enabled, as hsec is used for logging only when debug is enabled.
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:

Line 312: SELECT hsecs INTO l_start_time from v$timer;

308: -- Bug 5640601 =>
309: -- Selecting hsecs from v$times is changed to execute only when debug
310: -- is enabled, as hsec is used for logging only when debug is enabled.
311: IF l_debug_level > 0 Then
312: SELECT hsecs INTO l_start_time from v$timer;
313: end if;
314:
315: OE_Bulk_Process_Header.Entity
316: (p_header_rec => G_HEADER_REC

Line 329: SELECT hsecs INTO l_end_time from v$timer;

325: -- Bug 5640601 =>
326: -- Selecting hsecs from v$times is changed to execute only when debug
327: -- is enabled, as hsec is used for logging only when debug is enabled.
328: IF l_debug_level > 0 Then
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));

Line 348: SELECT hsecs INTO l_start_time from v$timer;

344: -- Bug 5640601 =>
345: -- Selecting hsecs from v$times is changed to execute only when debug
346: -- is enabled, as hsec is used for logging only when debug is enabled.
347: IF l_debug_level > 0 Then
348: SELECT hsecs INTO l_start_time from v$timer;
349: end if;
350:
351: OE_Bulk_Msg_PUB.Save_Messages(G_REQUEST_ID);
352:

Line 357: SELECT hsecs INTO l_end_time from v$timer;

353: -- Bug 5640601 =>
354: -- Selecting hsecs from v$times is changed to execute only when debug
355: -- is enabled, as hsec is used for logging only when debug is enabled.
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:

Line 370: SELECT hsecs INTO l_start_time from v$timer;

366: -- Bug 5640601 =>
367: -- Selecting hsecs from v$times is changed to execute only when debug
368: -- is enabled, as hsec is used for logging only when debug is enabled.
369: IF l_debug_level > 0 Then
370: SELECT hsecs INTO l_start_time from v$timer;
371: end if;
372: Process_Invalid_Records;
373:
374: -- Bug 5640601 =>

Line 378: SELECT hsecs INTO l_end_time from v$timer;

374: -- Bug 5640601 =>
375: -- Selecting hsecs from v$times is changed to execute only when debug
376: -- is enabled, as hsec is used for logging only when debug is enabled.
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:

Line 395: SELECT hsecs INTO l_start_time from v$timer;

391: -- Bug 5640601 =>
392: -- Selecting hsecs from v$times is changed to execute only when debug
393: -- is enabled, as hsec is used for logging only when debug is enabled.
394: IF l_debug_level > 0 Then
395: SELECT hsecs INTO l_start_time from v$timer;
396: end if;
397:
398: OE_Bulk_Header_Util.Create_Header_Scredits(l_header_scredit_rec);
399:

Line 404: SELECT hsecs INTO l_end_time from v$timer;

400: -- Bug 5640601 =>
401: -- Selecting hsecs from v$times is changed to execute only when debug
402: -- is enabled, as hsec is used for logging only when debug is enabled.
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));

Line 447: SELECT hsecs INTO l_start_time from v$timer;

443: -- Bug 5640601 =>
444: -- Selecting hsecs from v$times is changed to execute only when debug
445: -- is enabled, as hsec is used for logging only when debug is enabled.
446: IF l_debug_level > 0 Then
447: SELECT hsecs INTO l_start_time from v$timer;
448: end if;
449: oe_debug_pub.add( 'Process Tax :'|| p_process_tax,1);
450:
451: OE_Bulk_Line_Util.Load_Lines

Line 461: SELECT hsecs INTO l_end_time from v$timer;

457:
458: -- Bug 5640601 =>
459: -- Selecting hsecs from v$times is changed to execute only when debug
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:

Line 478: SELECT hsecs INTO l_start_time from v$timer;

474: -- Bug 5640601 =>
475: -- Selecting hsecs from v$times is changed to execute only when debug
476: -- is enabled, as hsec is used for logging only when debug is enabled.
477: IF l_debug_level > 0 Then
478: SELECT hsecs INTO l_start_time from v$timer;
479: end if;
480:
481:
482: OE_Bulk_Process_Line.Entity

Line 499: SELECT hsecs INTO l_end_time from v$timer;

495: -- Bug 5640601 =>
496: -- Selecting hsecs from v$times is changed to execute only when debug
497: -- is enabled, as hsec is used for logging only when debug is enabled.
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:

Line 516: SELECT hsecs INTO l_start_time from v$timer;

512: -- Bug 5640601 =>
513: -- Selecting hsecs from v$times is changed to execute only when debug
514: -- is enabled, as hsec is used for logging only when debug is enabled.
515: IF l_debug_level > 0 Then
516: SELECT hsecs INTO l_start_time from v$timer;
517: end if;
518:
519: Process_Invalid_Records;
520:

Line 525: SELECT hsecs INTO l_end_time from v$timer;

521: -- Bug 5640601 =>
522: -- Selecting hsecs from v$times is changed to execute only when debug
523: -- is enabled, as hsec is used for logging only when debug is enabled.
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:

Line 538: SELECT hsecs INTO l_start_time from v$timer;

534: -- Bug 5640601 =>
535: -- Selecting hsecs from v$times is changed to execute only when debug
536: -- is enabled, as hsec is used for logging only when debug is enabled.
537: IF l_debug_level > 0 Then
538: SELECT hsecs INTO l_start_time from v$timer;
539: end if;
540:
541: OE_Bulk_Line_Util.Create_Line_Scredits(l_line_scredit_rec);
542:

Line 547: SELECT hsecs INTO l_end_time from v$timer;

543: -- Bug 5640601 =>
544: -- Selecting hsecs from v$times is changed to execute only when debug
545: -- is enabled, as hsec is used for logging only when debug is enabled.
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));

Line 607: SELECT hsecs INTO l_start_time from v$timer;

603: -- Bug 5640601 =>
604: -- Selecting hsecs from v$times is changed to execute only when debug
605: -- is enabled, as hsec is used for logging only when debug is enabled.
606: IF l_debug_level > 0 Then
607: SELECT hsecs INTO l_start_time from v$timer;
608: end if;
609:
610: INV_SalesOrder.Create_MTL_Sales_Orders_Bulk
611: (p_api_version_number => 1.0

Line 629: SELECT hsecs INTO l_end_time from v$timer;

625: -- Bug 5640601 =>
626: -- Selecting hsecs from v$times is changed to execute only when debug
627: -- is enabled, as hsec is used for logging only when debug is enabled.
628: IF l_debug_level > 0 Then
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) '

Line 647: SELECT hsecs INTO l_start_time from v$timer;

643: -- Bug 5640601 =>
644: -- Selecting hsecs from v$times is changed to execute only when debug
645: -- is enabled, as hsec is used for logging only when debug is enabled.
646: IF l_debug_level > 0 Then
647: SELECT hsecs INTO l_start_time from v$timer;
648: end if;
649:
650: OE_Bulk_Schedule_Util.Schedule_Orders
651: (p_line_rec => OE_BULK_ORDER_PVT.G_LINE_REC

Line 664: SELECT hsecs INTO l_end_time from v$timer;

660: -- Bug 5640601 =>
661: -- Selecting hsecs from v$times is changed to execute only when debug
662: -- is enabled, as hsec is used for logging only when debug is enabled.
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));

Line 684: SELECT hsecs INTO l_start_time from v$timer;

680: -- Bug 5640601 =>
681: -- Selecting hsecs from v$times is changed to execute only when debug
682: -- is enabled, as hsec is used for logging only when debug is enabled.
683: IF l_debug_level > 0 Then
684: SELECT hsecs INTO l_start_time from v$timer;
685: end if;
686:
687: IF G_PRICING_NEEDED = 'Y' AND QP_UTIL_PUB.Hvop_Pricing_Setup = 'Y'
688: AND NOT G_CATCHWEIGHT THEN --bug 3798477

Line 716: SELECT hsecs INTO l_end_time from v$timer;

712: -- Bug 5640601 =>
713: -- Selecting hsecs from v$times is changed to execute only when debug
714: -- is enabled, as hsec is used for logging only when debug is enabled.
715: IF l_debug_level > 0 Then
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) '

Line 730: select hsecs into l_start_time from v$timer;

726:
727: -- added for HVOP TAX project
728: IF p_process_tax = 'Y' AND
729: G_PRICING_NEEDED = 'N' THEN
730: select hsecs into l_start_time from v$timer;
731:
732: OE_Bulk_Tax_Util.Calculate_Tax(p_post_insert => FALSE);
733: select hsecs into l_end_time from v$timer;
734:

Line 733: select hsecs into l_end_time from v$timer;

729: G_PRICING_NEEDED = 'N' THEN
730: select hsecs into l_start_time from v$timer;
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:

Line 756: SELECT hsecs INTO l_start_time from v$timer;

752: -- Bug 5640601 =>
753: -- Selecting hsecs from v$times is changed to execute only when debug
754: -- is enabled, as hsec is used for logging only when debug is enabled.
755: IF l_debug_level > 0 Then
756: SELECT hsecs INTO l_start_time from v$timer;
757: end if;
758:
759: OE_Bulk_Header_Util.Insert_Headers
760: ( p_header_rec => G_HEADER_REC

Line 768: SELECT hsecs INTO l_end_time from v$timer;

764: -- Bug 5640601 =>
765: -- Selecting hsecs from v$times is changed to execute only when debug
766: -- is enabled, as hsec is used for logging only when debug is enabled.
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:

Line 777: SELECT hsecs INTO l_start_time from v$timer;

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.
776: IF l_debug_level > 0 Then
777: SELECT hsecs INTO l_start_time from v$timer;
778: end if;
779:
780: OE_Bulk_Line_Util.Insert_Lines
781: ( p_line_rec => G_LINE_REC

Line 788: SELECT hsecs INTO l_end_time from v$timer;

784: -- Bug 5640601 =>
785: -- Selecting hsecs from v$times is changed to execute only when debug
786: -- is enabled, as hsec is used for logging only when debug is enabled.
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:

Line 802: SELECT hsecs INTO l_start_time from v$timer;

798: -- Bug 5640601 =>
799: -- Selecting hsecs from v$times is changed to execute only when debug
800: -- is enabled, as hsec is used for logging only when debug is enabled.
801: IF l_debug_level > 0 Then
802: SELECT hsecs INTO l_start_time from v$timer;
803: end if;
804:
805: OE_Bulk_Holds_Pvt.Create_Holds;
806:

Line 811: SELECT hsecs INTO l_end_time from v$timer;

807: -- Bug 5640601 =>
808: -- Selecting hsecs from v$times is changed to execute only when debug
809: -- is enabled, as hsec is used for logging only when debug is enabled.
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));

Line 828: SELECT hsecs INTO l_start_time from v$timer;

824: -- Bug 5640601 =>
825: -- Selecting hsecs from v$times is changed to execute only when debug
826: -- is enabled, as hsec is used for logging only when debug is enabled.
827: IF l_debug_level > 0 Then
828: SELECT hsecs INTO l_start_time from v$timer;
829: end if;
830:
831: Update_DBI_Log(p_line_rec => G_LINE_REC
832: ,x_return_status => l_return_status

Line 845: SELECT hsecs INTO l_end_time from v$timer;

841: -- Bug 5640601 =>
842: -- Selecting hsecs from v$times is changed to execute only when debug
843: -- is enabled, as hsec is used for logging only when debug is enabled.
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));

Line 875: SELECT hsecs INTO l_start_time from v$timer;

871: -- Bug 5640601 =>
872: -- Selecting hsecs from v$times is changed to execute only when debug
873: -- is enabled, as hsec is used for logging only when debug is enabled.
874: IF l_debug_level > 0 Then
875: SELECT hsecs INTO l_start_time from v$timer;
876: end if;
877:
878: OE_Bulk_Price_Pvt.Insert_Adjustments(p_batch_id, l_return_status);
879:

Line 888: SELECT hsecs INTO l_end_time from v$timer;

884: -- Bug 5640601 =>
885: -- Selecting hsecs from v$times is changed to execute only when debug
886: -- is enabled, as hsec is used for logging only when debug is enabled.
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));

Line 904: SELECT hsecs INTO l_start_time from v$timer;

900: -- Bug 5640601 =>
901: -- Selecting hsecs from v$times is changed to execute only when debug
902: -- is enabled, as hsec is used for logging only when debug is enabled.
903: IF l_debug_level > 0 Then
904: SELECT hsecs INTO l_start_time from v$timer;
905: end if;
906:
907: OE_Bulk_Price_Pvt.Price_Orders
908: (p_header_rec => G_HEADER_REC

Line 929: SELECT hsecs INTO l_end_time from v$timer;

925: -- Bug 5640601 =>
926: -- Selecting hsecs from v$times is changed to execute only when debug
927: -- is enabled, as hsec is used for logging only when debug is enabled.
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));

Line 960: SELECT hsecs INTO l_start_time from v$timer;

956: -- Bug 5640601 =>
957: -- Selecting hsecs from v$times is changed to execute only when debug
958: -- is enabled, as hsec is used for logging only when debug is enabled.
959: IF l_debug_level > 0 Then
960: SELECT hsecs INTO l_start_time from v$timer;
961: end if;
962:
963: OE_Bulk_Ack_Pvt.Process_Acknowledgments(p_batch_id, l_return_status);
964:

Line 973: SELECT hsecs INTO l_end_time from v$timer;

969: -- Bug 5640601 =>
970: -- Selecting hsecs from v$times is changed to execute only when debug
971: -- is enabled, as hsec is used for logging only when debug is enabled.
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));

Line 990: SELECT hsecs INTO l_start_time from v$timer;

986: -- Bug 5640601 =>
987: -- Selecting hsecs from v$times is changed to execute only when debug
988: -- is enabled, as hsec is used for logging only when debug is enabled.
989: IF l_debug_level > 0 Then
990: SELECT hsecs INTO l_start_time from v$timer;
991: end if;
992:
993: OE_Bulk_WF_Util.Start_Flows(p_header_rec => G_HEADER_REC
994: ,p_line_rec => G_LINE_REC

Line 1006: SELECT hsecs INTO l_end_time from v$timer;

1002: -- Bug 5640601 =>
1003: -- Selecting hsecs from v$times is changed to execute only when debug
1004: -- is enabled, as hsec is used for logging only when debug is enabled.
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));

Line 1022: SELECT hsecs INTO l_start_time from v$timer;

1018: -- Bug 5640601 =>
1019: -- Selecting hsecs from v$times is changed to execute only when debug
1020: -- is enabled, as hsec is used for logging only when debug is enabled.
1021: IF l_debug_level > 0 Then
1022: SELECT hsecs INTO l_start_time from v$timer;
1023: end if;
1024:
1025: IF G_LINE_REC.shipping_eligible_flag.COUNT > 0 THEN
1026:

Line 1048: SELECT hsecs INTO l_end_time from v$timer;

1044: -- Bug 5640601 =>
1045: -- Selecting hsecs from v$times is changed to execute only when debug
1046: -- is enabled, as hsec is used for logging only when debug is enabled.
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) '

Line 1162: SELECT hsecs INTO l_start_time from v$timer;

1158: -- Bug 5640601 =>
1159: -- Selecting hsecs from v$times is changed to execute only when debug
1160: -- is enabled, as hsec is used for logging only when debug is enabled.
1161: IF l_debug_level > 0 Then
1162: SELECT hsecs INTO l_start_time from v$timer;
1163: end if;
1164: OE_BULK_VALIDATE.Pre_Process(p_batch_id);
1165: -- Bug 5640601 =>
1166: -- Selecting hsecs from v$times is changed to execute only when debug

Line 1169: SELECT hsecs INTO l_end_time from v$timer;

1165: -- Bug 5640601 =>
1166: -- Selecting hsecs from v$times is changed to execute only when debug
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:

Line 1183: SELECT hsecs INTO l_start_time from v$timer;

1179: -- Bug 5640601 =>
1180: -- Selecting hsecs from v$times is changed to execute only when debug
1181: -- is enabled, as hsec is used for logging only when debug is enabled.
1182: IF l_debug_level > 0 Then
1183: SELECT hsecs INTO l_start_time from v$timer;
1184: end if;
1185: OE_BULK_VALIDATE.Attributes(p_batch_id, l_adjustments_exist);
1186: -- Bug 5640601 =>
1187: -- Selecting hsecs from v$times is changed to execute only when debug

Line 1190: SELECT hsecs INTO l_end_time from v$timer;

1186: -- Bug 5640601 =>
1187: -- Selecting hsecs from v$times is changed to execute only when debug
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:

Line 1204: SELECT hsecs INTO l_start_time from v$timer;

1200: -- Bug 5640601 =>
1201: -- Selecting hsecs from v$times is changed to execute only when debug
1202: -- is enabled, as hsec is used for logging only when debug is enabled.
1203: IF l_debug_level > 0 Then
1204: SELECT hsecs INTO l_start_time from v$timer;
1205: end if;
1206:
1207: -- Value to ID for Header Attributes
1208:

Line 1229: SELECT hsecs INTO l_end_time from v$timer;

1225: -- Bug 5640601 =>
1226: -- Selecting hsecs from v$times is changed to execute only when debug
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:

Line 1257: SELECT hsecs INTO l_start_time from v$timer;

1253: IF l_debug_level > 0 THEN
1254: oe_debug_pub.add( 'CALLING OE_BULK_CONFIG_UTIL.Pre_Process ' ) ;
1255: END IF;
1256:
1257: SELECT hsecs INTO l_start_time from v$timer;
1258:
1259: OE_BULK_CONFIG_UTIL.Pre_Process
1260: (p_batch_id => p_batch_id,
1261: p_validate_only => p_validate_only,

Line 1265: SELECT hsecs INTO l_end_time from v$timer;

1261: p_validate_only => p_validate_only,
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;