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

Line 111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Initialize_Request Error :'||substr(sqlerrm,1,200));

107: G_RTRIM_IFACE_DATA := p_rtrim_data;
108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Initialize_Request Error :'||substr(sqlerrm,1,200));
112: OE_BULK_MSG_PUB.Add_Exc_Msg
113: ( G_PKG_NAME
114: , 'Initialize_Request'
115: );

Line 172: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load Hold Sources is (sec) '

168: IF l_debug_level > 0 THEN
169: SELECT hsecs INTO l_end_time from v$timer;
170: END IF;
171:
172: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Load Hold Sources is (sec) '
173: ||((l_end_time-l_start_time)/100));
174:
175: EXCEPTION
176: WHEN OTHERS THEN

Line 177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Initialize_Batch Error :'||substr(sqlerrm,1,200));

173: ||((l_end_time-l_start_time)/100));
174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Initialize_Batch Error :'||substr(sqlerrm,1,200));
178: OE_BULK_MSG_PUB.Add_Exc_Msg
179: ( G_PKG_NAME
180: , 'Initialize_Batch'
181: );

Line 583: fnd_file.put_line(FND_FILE.OUTPUT, '');

579: -----------------------------------------------------------
580: -- Log Output file
581: -----------------------------------------------------------
582:
583: fnd_file.put_line(FND_FILE.OUTPUT, '');
584: fnd_file.put_line(FND_FILE.OUTPUT, 'BULK Order Import Concurrent Program');
585: fnd_file.put_line(FND_FILE.OUTPUT, '');
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);

Line 584: fnd_file.put_line(FND_FILE.OUTPUT, 'BULK Order Import Concurrent Program');

580: -- Log Output file
581: -----------------------------------------------------------
582:
583: fnd_file.put_line(FND_FILE.OUTPUT, '');
584: fnd_file.put_line(FND_FILE.OUTPUT, 'BULK Order Import Concurrent Program');
585: fnd_file.put_line(FND_FILE.OUTPUT, '');
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);

Line 585: fnd_file.put_line(FND_FILE.OUTPUT, '');

581: -----------------------------------------------------------
582:
583: fnd_file.put_line(FND_FILE.OUTPUT, '');
584: fnd_file.put_line(FND_FILE.OUTPUT, 'BULK Order Import Concurrent Program');
585: fnd_file.put_line(FND_FILE.OUTPUT, '');
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);

Line 586: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');

582:
583: fnd_file.put_line(FND_FILE.OUTPUT, '');
584: fnd_file.put_line(FND_FILE.OUTPUT, 'BULK Order Import Concurrent Program');
585: fnd_file.put_line(FND_FILE.OUTPUT, '');
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);
590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);

Line 587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);

583: fnd_file.put_line(FND_FILE.OUTPUT, '');
584: fnd_file.put_line(FND_FILE.OUTPUT, 'BULK Order Import Concurrent Program');
585: fnd_file.put_line(FND_FILE.OUTPUT, '');
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);
590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);

Line 588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);

584: fnd_file.put_line(FND_FILE.OUTPUT, 'BULK Order Import Concurrent Program');
585: fnd_file.put_line(FND_FILE.OUTPUT, '');
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);
590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);

Line 589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);

585: fnd_file.put_line(FND_FILE.OUTPUT, '');
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);
590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Recs With No Org: '|| p_process_recs_with_no_org );

Line 590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);

586: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);
590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Recs With No Org: '|| p_process_recs_with_no_org );
594: fnd_file.put_line(FND_FILE.OUTPUT, '');

Line 591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);

587: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| p_validate_only);
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);
590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Recs With No Org: '|| p_process_recs_with_no_org );
594: fnd_file.put_line(FND_FILE.OUTPUT, '');
595: fnd_file.put_line(FND_FILE.OUTPUT,'Process Configurations '||P_PROCESS_CONFIGURATIONS);

Line 592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);

588: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Desc Flex: '|| p_validate_desc_flex);
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);
590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Recs With No Org: '|| p_process_recs_with_no_org );
594: fnd_file.put_line(FND_FILE.OUTPUT, '');
595: fnd_file.put_line(FND_FILE.OUTPUT,'Process Configurations '||P_PROCESS_CONFIGURATIONS);
596: fnd_file.put_line(FND_FILE.OUTPUT, ' Process Tax ' || p_process_tax );

Line 593: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Recs With No Org: '|| p_process_recs_with_no_org );

589: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| p_order_source_id);
590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Recs With No Org: '|| p_process_recs_with_no_org );
594: fnd_file.put_line(FND_FILE.OUTPUT, '');
595: fnd_file.put_line(FND_FILE.OUTPUT,'Process Configurations '||P_PROCESS_CONFIGURATIONS);
596: fnd_file.put_line(FND_FILE.OUTPUT, ' Process Tax ' || p_process_tax );
597:

Line 594: fnd_file.put_line(FND_FILE.OUTPUT, '');

590: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| p_orig_sys_document_ref);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Recs With No Org: '|| p_process_recs_with_no_org );
594: fnd_file.put_line(FND_FILE.OUTPUT, '');
595: fnd_file.put_line(FND_FILE.OUTPUT,'Process Configurations '||P_PROCESS_CONFIGURATIONS);
596: fnd_file.put_line(FND_FILE.OUTPUT, ' Process Tax ' || p_process_tax );
597:
598:

Line 595: fnd_file.put_line(FND_FILE.OUTPUT,'Process Configurations '||P_PROCESS_CONFIGURATIONS);

591: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Recs With No Org: '|| p_process_recs_with_no_org );
594: fnd_file.put_line(FND_FILE.OUTPUT, '');
595: fnd_file.put_line(FND_FILE.OUTPUT,'Process Configurations '||P_PROCESS_CONFIGURATIONS);
596: fnd_file.put_line(FND_FILE.OUTPUT, ' Process Tax ' || p_process_tax );
597:
598:
599: -----------------------------------------------------------

Line 596: fnd_file.put_line(FND_FILE.OUTPUT, ' Process Tax ' || p_process_tax );

592: fnd_file.put_line(FND_FILE.OUTPUT, 'Defaulting Mode: '|| p_defaulting_mode);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Recs With No Org: '|| p_process_recs_with_no_org );
594: fnd_file.put_line(FND_FILE.OUTPUT, '');
595: fnd_file.put_line(FND_FILE.OUTPUT,'Process Configurations '||P_PROCESS_CONFIGURATIONS);
596: fnd_file.put_line(FND_FILE.OUTPUT, ' Process Tax ' || p_process_tax );
597:
598:
599: -----------------------------------------------------------
600: -- Setting Debug Mode and File

Line 603: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug Level: '||nvl(p_debug_level,0));

599: -----------------------------------------------------------
600: -- Setting Debug Mode and File
601: -----------------------------------------------------------
602:
603: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug Level: '||nvl(p_debug_level,0));
604:
605: IF nvl(p_debug_level, 0) > 0 THEN
606: FND_PROFILE.PUT('ONT_DEBUG_LEVEL',p_debug_level);
607: --moved this stmt in if loop for bug 3747791

Line 619: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));

615: -----------------------------------------------------------
616:
617: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);
618:
619: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
620:
621:
622: If p_operating_unit IS NOT NULL Then
623: MO_GLOBAL.set_policy_context('S',p_operating_unit);

Line 631: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '|| to_char(p_operating_unit));

627: If p_debug_level > 0 Then
628: oe_debug_pub.add('Default Org Id '||l_default_org_id);
629: End If;
630:
631: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '|| to_char(p_operating_unit));
632: fnd_file.put_line(FND_FILE.OUTPUT, '');
633:
634: l_req_data := fnd_conc_global.request_data;
635: if (l_req_data is not null) then

Line 632: fnd_file.put_line(FND_FILE.OUTPUT, '');

628: oe_debug_pub.add('Default Org Id '||l_default_org_id);
629: End If;
630:
631: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '|| to_char(p_operating_unit));
632: fnd_file.put_line(FND_FILE.OUTPUT, '');
633:
634: l_req_data := fnd_conc_global.request_data;
635: if (l_req_data is not null) then
636: l_req_data_counter := to_number(l_req_data);

Line 656: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);

652: WHERE organization_id = ca_enabled_rec.org_id ;
653:
654: FND_MESSAGE.SET_NAME('ONT','ONT_BULK_NOT_SUPP_ACCEPTANCE');
655: FND_MESSAGE.SET_TOKEN('OU','''' || l_oper_unit_name || '''');
656: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);
657:
658: EXCEPTION
659: WHEN OTHERS THEN
660: NULL ;

Line 847: fnd_file.put_line(FND_FILE.OUTPUT,'No more orders to process');

843: END IF;
844:
845: EXCEPTION
846: WHEN NO_DATA_FOUND THEN
847: fnd_file.put_line(FND_FILE.OUTPUT,'No more orders to process');
848: fnd_file.put_line(FND_FILE.OUTPUT,'Not spawning any child processes');
849: RETURN;
850:
851: WHEN OTHERS THEN

Line 848: fnd_file.put_line(FND_FILE.OUTPUT,'Not spawning any child processes');

844:
845: EXCEPTION
846: WHEN NO_DATA_FOUND THEN
847: fnd_file.put_line(FND_FILE.OUTPUT,'No more orders to process');
848: fnd_file.put_line(FND_FILE.OUTPUT,'Not spawning any child processes');
849: RETURN;
850:
851: WHEN OTHERS THEN
852: fnd_file.put_line(FND_FILE.OUTPUT,'SOME OTHER ERROR IN SQL STATEMENT');

Line 852: fnd_file.put_line(FND_FILE.OUTPUT,'SOME OTHER ERROR IN SQL STATEMENT');

848: fnd_file.put_line(FND_FILE.OUTPUT,'Not spawning any child processes');
849: RETURN;
850:
851: WHEN OTHERS THEN
852: fnd_file.put_line(FND_FILE.OUTPUT,'SOME OTHER ERROR IN SQL STATEMENT');
853: RETURN;
854: END;
855:
856:

Line 883: fnd_file.put_line(FND_FILE.OUTPUT, 'Child Request ID: '||l_new_request_id);

879: , p_validate_desc_flex, p_defaulting_mode , p_debug_level
880: , 0,
881: p_batch_size,p_rtrim_data,p_process_recs_with_no_org,p_process_tax,
882: p_process_configurations, p_dummy, p_validate_configurations, p_schedule_configurations);
883: fnd_file.put_line(FND_FILE.OUTPUT, 'Child Request ID: '||l_new_request_id);
884: IF (l_new_request_id = 0) THEN
885: fnd_file.put_line(FND_FILE.OUTPUT,'Error in submitting child request');
886: errbuf := FND_MESSAGE.GET;
887: retcode := 2;

Line 885: fnd_file.put_line(FND_FILE.OUTPUT,'Error in submitting child request');

881: p_batch_size,p_rtrim_data,p_process_recs_with_no_org,p_process_tax,
882: p_process_configurations, p_dummy, p_validate_configurations, p_schedule_configurations);
883: fnd_file.put_line(FND_FILE.OUTPUT, 'Child Request ID: '||l_new_request_id);
884: IF (l_new_request_id = 0) THEN
885: fnd_file.put_line(FND_FILE.OUTPUT,'Error in submitting child request');
886: errbuf := FND_MESSAGE.GET;
887: retcode := 2;
888: RETURN;
889: END IF;

Line 896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time for submit REQUESTs :'||to_char((v_end-v_start)/100));

892:
893: END LOOP;
894:
895: v_end := DBMS_UTILITY.GET_TIME;
896: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time for submit REQUESTs :'||to_char((v_end-v_start)/100));
897:
898: -----------------------------------------------------------
899: -- BULK Populate Orders Table - l_order_rec
900: -----------------------------------------------------------

Line 919: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;

915: , l_order_rec.org_id
916: ;
917: CLOSE c_lines_per_order;
918: v_end := DBMS_UTILITY.GET_TIME;
919: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
920: Elsif p_process_recs_with_no_org = 'Y' Then
921: v_start := DBMS_UTILITY.GET_TIME;
922: If p_debug_level > 0 Then
923: oe_debug_pub.add('here1');

Line 936: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;

932: , l_order_rec.org_id
933: ;
934: CLOSE c_lines_per_order_2;
935: v_end := DBMS_UTILITY.GET_TIME;
936: FND_FILE.PUT_LINE(FND_FILE.LOG,'TIME FOR BULK COLLECT:'||TO_CHAR ( ( V_END-V_START ) /100 ) ) ;
937: End If;
938: -----------------------------------------------------------
939: -- Assign request_id (instance) AND batch_id to the orders
940: -----------------------------------------------------------

Line 963: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_order_rec.order_source_id(l_index))

959:
960: IF l_num_lines > p_batch_size THEN
961:
962:
963: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_order_rec.order_source_id(l_index))
964: ||'/'||l_order_rec.orig_sys_document_ref(l_index));
965: fnd_file.put_line(FND_FILE.OUTPUT,'This order cannot be processed in this batch.'||
966: ' Order Size is > '||to_char(p_batch_size));
967:

Line 965: fnd_file.put_line(FND_FILE.OUTPUT,'This order cannot be processed in this batch.'||

961:
962:
963: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_order_rec.order_source_id(l_index))
964: ||'/'||l_order_rec.orig_sys_document_ref(l_index));
965: fnd_file.put_line(FND_FILE.OUTPUT,'This order cannot be processed in this batch.'||
966: ' Order Size is > '||to_char(p_batch_size));
967:
968:
969: -- Assign parent import program's request id. Without this, infinite

Line 1062: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time to ASSIGN IDs :'||to_char((v_end-v_start)/100));

1058: l_index := l_index + 1;
1059:
1060: END LOOP; -- End of loop over Orders table - l_order_rec
1061: v_end := DBMS_UTILITY.GET_TIME;
1062: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time to ASSIGN IDs :'||to_char((v_end-v_start)/100));
1063:
1064:
1065: --------------------------------------------------------------
1066: -- BULK UPDATE Request_ID and Batch_ID on headers iface table

Line 1151: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time to BULK UPDATE:'||to_char((v_end-v_start)/100));

1147:
1148: END LOOP;
1149:
1150: v_end := DBMS_UTILITY.GET_TIME;
1151: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time to BULK UPDATE:'||to_char((v_end-v_start)/100));
1152:
1153: COMMIT;
1154:
1155: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',

Line 1264: -- fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);

1260: -----------------------------------------------------------
1261: --IF OE_SYS_PARAMETERS.VALUE('ENABLE_FULFILLMENT_ACCEPTANCE',G_ORG_ID) = 'Y'
1262: --THEN
1263: -- FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_ACCEPTANCE');
1264: -- fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET);
1265: -- retcode := 2;
1266: -- RETURN;
1267: -- END IF;
1268:

Line 1321: fnd_file.put_line(FND_FILE.LOG,'Batch id: '|| to_char(l_batch_id)||

1317:
1318: G_ERROR_ORDERS := l_error_orders + l_batch_orders;
1319:
1320: l_count_batch_failure := l_count_batch_failure + 1;
1321: fnd_file.put_line(FND_FILE.LOG,'Batch id: '|| to_char(l_batch_id)||
1322: ' Status : Unexpected Error (all orders failed to import)'
1323: );
1324:
1325: ELSE

Line 1335: fnd_file.put_line(FND_FILE.LOG,'Batch ID: '|| to_char(l_batch_id)||

1331: p_batch_id => l_batch_id,
1332: p_validate_only => p_validate_only,
1333: x_return_status => l_return_status
1334: );
1335: fnd_file.put_line(FND_FILE.LOG,'Batch ID: '|| to_char(l_batch_id)||
1336: ' Status : Processed (orders could have failures due to validation errors)'
1337: );
1338: END IF;
1339:

Line 1358: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total time is (sec) '

1354: IF p_debug_level > 0 THEN
1355: SELECT hsecs INTO l_end_total_time from v$timer;
1356: END IF;
1357:
1358: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total time is (sec) '
1359: ||((l_end_total_time-l_start_total_time)/100));
1360:
1361: fnd_file.put_line(FND_FILE.OUTPUT,'No. of batches found: ' ||
1362: l_count_batch);

Line 1361: fnd_file.put_line(FND_FILE.OUTPUT,'No. of batches found: ' ||

1357:
1358: FND_FILE.PUT_LINE(FND_FILE.LOG,'Total time is (sec) '
1359: ||((l_end_total_time-l_start_total_time)/100));
1360:
1361: fnd_file.put_line(FND_FILE.OUTPUT,'No. of batches found: ' ||
1362: l_count_batch);
1363: fnd_file.put_line(FND_FILE.OUTPUT,'');
1364:
1365:

Line 1363: fnd_file.put_line(FND_FILE.OUTPUT,'');

1359: ||((l_end_total_time-l_start_total_time)/100));
1360:
1361: fnd_file.put_line(FND_FILE.OUTPUT,'No. of batches found: ' ||
1362: l_count_batch);
1363: fnd_file.put_line(FND_FILE.OUTPUT,'');
1364:
1365:
1366: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Processed across All Batches :'||
1367: to_char(G_BOOKED_ORDERS + G_ENTERED_ORDERS + G_ERROR_ORDERS));

Line 1366: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Processed across All Batches :'||

1362: l_count_batch);
1363: fnd_file.put_line(FND_FILE.OUTPUT,'');
1364:
1365:
1366: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Processed across All Batches :'||
1367: to_char(G_BOOKED_ORDERS + G_ENTERED_ORDERS + G_ERROR_ORDERS));
1368: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Booked Orders: '||
1369: to_char(G_BOOKED_ORDERS));
1370: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Entered Orders: ' ||

Line 1368: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Booked Orders: '||

1364:
1365:
1366: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Processed across All Batches :'||
1367: to_char(G_BOOKED_ORDERS + G_ENTERED_ORDERS + G_ERROR_ORDERS));
1368: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Booked Orders: '||
1369: to_char(G_BOOKED_ORDERS));
1370: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Entered Orders: ' ||
1371: to_char(G_ENTERED_ORDERS));
1372: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Failed: ' ||

Line 1370: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Entered Orders: ' ||

1366: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Processed across All Batches :'||
1367: to_char(G_BOOKED_ORDERS + G_ENTERED_ORDERS + G_ERROR_ORDERS));
1368: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Booked Orders: '||
1369: to_char(G_BOOKED_ORDERS));
1370: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Entered Orders: ' ||
1371: to_char(G_ENTERED_ORDERS));
1372: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Failed: ' ||
1373: to_char(G_ERROR_ORDERS));
1374:

Line 1372: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Failed: ' ||

1368: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Booked Orders: '||
1369: to_char(G_BOOKED_ORDERS));
1370: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Entered Orders: ' ||
1371: to_char(G_ENTERED_ORDERS));
1372: fnd_file.put_line(FND_FILE.OUTPUT,'No. of Orders Failed: ' ||
1373: to_char(G_ERROR_ORDERS));
1374:
1375: -----------------------------------------------------------
1376: -- Messages

Line 1379: fnd_file.put_line(FND_FILE.OUTPUT,'');

1375: -----------------------------------------------------------
1376: -- Messages
1377: -----------------------------------------------------------
1378:
1379: fnd_file.put_line(FND_FILE.OUTPUT,'');
1380: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
1381: OPEN l_msg_cursor;
1382: LOOP
1383: FETCH l_msg_cursor

Line 1380: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');

1376: -- Messages
1377: -----------------------------------------------------------
1378:
1379: fnd_file.put_line(FND_FILE.OUTPUT,'');
1380: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
1381: OPEN l_msg_cursor;
1382: LOOP
1383: FETCH l_msg_cursor
1384: INTO l_order_source_id

Line 1391: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_order_source_id)

1387: , l_orig_sys_line_ref
1388: , l_message_text;
1389: EXIT WHEN l_msg_cursor%NOTFOUND;
1390:
1391: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_order_source_id)
1392: ||'/'||l_orig_sys_document_ref
1393: ||'/'||l_change_sequence
1394: ||'/'||l_orig_sys_line_ref
1395: ||' '||l_message_text);

Line 1396: fnd_file.put_line(FND_FILE.OUTPUT,'');

1392: ||'/'||l_orig_sys_document_ref
1393: ||'/'||l_change_sequence
1394: ||'/'||l_orig_sys_line_ref
1395: ||' '||l_message_text);
1396: fnd_file.put_line(FND_FILE.OUTPUT,'');
1397: END LOOP;
1398:
1399: END IF; -- End if for l_num_instances
1400:

Line 1404: fnd_file.put_line(FND_FILE.OUTPUT, 'End of BULK Order Import Concurrent Program');

1400:
1401: -----------------------------------------------------------
1402: -- End of Order_Import_Conc_Pgm
1403: -----------------------------------------------------------
1404: fnd_file.put_line(FND_FILE.OUTPUT, 'End of BULK Order Import Concurrent Program');
1405:
1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: retcode := 2;

Line 1409: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error '||substr(sqlerrm,1,200));

1405:
1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: retcode := 2;
1409: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error '||substr(sqlerrm,1,200));
1410: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches imported: '||
1411: l_count_batch_success);
1412: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches failed: ' ||
1413: l_count_batch_failure);

Line 1410: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches imported: '||

1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: retcode := 2;
1409: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error '||substr(sqlerrm,1,200));
1410: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches imported: '||
1411: l_count_batch_success);
1412: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches failed: ' ||
1413: l_count_batch_failure);
1414: fnd_file.put_line(FND_FILE.OUTPUT,'');

Line 1412: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches failed: ' ||

1408: retcode := 2;
1409: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error '||substr(sqlerrm,1,200));
1410: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches imported: '||
1411: l_count_batch_success);
1412: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches failed: ' ||
1413: l_count_batch_failure);
1414: fnd_file.put_line(FND_FILE.OUTPUT,'');
1415: END ORDER_IMPORT_CONC_PGM;
1416:

Line 1414: fnd_file.put_line(FND_FILE.OUTPUT,'');

1410: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches imported: '||
1411: l_count_batch_success);
1412: fnd_file.put_line(FND_FILE.OUTPUT,'no. of batches failed: ' ||
1413: l_count_batch_failure);
1414: fnd_file.put_line(FND_FILE.OUTPUT,'');
1415: END ORDER_IMPORT_CONC_PGM;
1416:
1417:
1418: END OE_BULK_ORDER_IMPORT_PVT;