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 FND_FILE

Line 66: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);

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;
65:
66: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
67:
68: END ORDER_IMPORT_STATS_CONC_PGM;
69:
70: /* -----------------------------------------------------------

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

271: /* -----------------------------------------------------------
272: Log Output file
273: -----------------------------------------------------------
274: */
275: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Import Concurrent Program');
276: fnd_file.put_line(FND_FILE.OUTPUT, '');
277: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
278: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| l_validate_only);
279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);

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

272: Log Output file
273: -----------------------------------------------------------
274: */
275: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Import Concurrent Program');
276: fnd_file.put_line(FND_FILE.OUTPUT, '');
277: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
278: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| l_validate_only);
279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);
280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);

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

273: -----------------------------------------------------------
274: */
275: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Import Concurrent Program');
276: fnd_file.put_line(FND_FILE.OUTPUT, '');
277: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
278: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| l_validate_only);
279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);
280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);
281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);

Line 278: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| l_validate_only);

274: */
275: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Import Concurrent Program');
276: fnd_file.put_line(FND_FILE.OUTPUT, '');
277: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
278: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| l_validate_only);
279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);
280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);
281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);
282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);

Line 279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);

275: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Import Concurrent Program');
276: fnd_file.put_line(FND_FILE.OUTPUT, '');
277: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
278: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| l_validate_only);
279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);
280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);
281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);
282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);
283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);

Line 280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);

276: fnd_file.put_line(FND_FILE.OUTPUT, '');
277: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
278: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| l_validate_only);
279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);
280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);
281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);
282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);
283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);
284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);

Line 281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);

277: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
278: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| l_validate_only);
279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);
280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);
281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);
282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);
283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);
284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);
285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);

Line 282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);

278: fnd_file.put_line(FND_FILE.OUTPUT, 'Validate Only: '|| l_validate_only);
279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);
280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);
281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);
282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);
283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);
284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);
285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);
286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);

Line 283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);

279: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source: '|| l_order_source);
280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);
281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);
282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);
283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);
284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);
285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);
286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);
287: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);

Line 284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);

280: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Ref: '|| l_orig_sys_document_ref);
281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);
282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);
283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);
284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);
285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);
286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);
287: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
288: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);

Line 285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);

281: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| l_sold_to_org_id);
282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);
283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);
284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);
285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);
286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);
287: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
288: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
289: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Orders With Null Org: '||p_process_orders_with_null_org);

Line 286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);

282: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org: '|| l_sold_to_org);
283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);
284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);
285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);
286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);
287: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
288: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
289: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Orders With Null Org: '||p_process_orders_with_null_org);
290: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);

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

283: fnd_file.put_line(FND_FILE.OUTPUT, 'Change Sequence: '|| l_change_sequence);
284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);
285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);
286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);
287: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
288: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
289: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Orders With Null Org: '||p_process_orders_with_null_org);
290: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
291: fnd_file.put_line(FND_FILE.OUTPUT, '');

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

284: fnd_file.put_line(FND_FILE.OUTPUT, 'Performance Parameter: '|| p_perf_param);
285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);
286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);
287: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
288: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
289: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Orders With Null Org: '||p_process_orders_with_null_org);
290: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
291: fnd_file.put_line(FND_FILE.OUTPUT, '');
292:

Line 289: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Orders With Null Org: '||p_process_orders_with_null_org);

285: fnd_file.put_line(FND_FILE.OUTPUT, 'Trim Blanks: '|| p_rtrim_data);
286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);
287: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
288: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
289: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Orders With Null Org: '||p_process_orders_with_null_org);
290: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
291: fnd_file.put_line(FND_FILE.OUTPUT, '');
292:
293: --Check if Ct is atleast on Patchset Level H

Line 290: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);

286: fnd_file.put_line(FND_FILE.OUTPUT, 'Operation: '|| l_operation_code);
287: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
288: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
289: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Orders With Null Org: '||p_process_orders_with_null_org);
290: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
291: fnd_file.put_line(FND_FILE.OUTPUT, '');
292:
293: --Check if Ct is atleast on Patchset Level H
294: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' And

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

287: fnd_file.put_line(FND_FILE.OUTPUT, 'Number of Instances: '|| p_num_instances);
288: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
289: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Orders With Null Org: '||p_process_orders_with_null_org);
290: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
291: fnd_file.put_line(FND_FILE.OUTPUT, '');
292:
293: --Check if Ct is atleast on Patchset Level H
294: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' And
295: l_order_source = '20'

Line 297: fnd_file.put_line(FND_FILE.OUTPUT, 'Cannot Import Order for Order Source XML. This functionality is available only from Pack H onwards');

293: --Check if Ct is atleast on Patchset Level H
294: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' And
295: l_order_source = '20'
296: Then
297: fnd_file.put_line(FND_FILE.OUTPUT, 'Cannot Import Order for Order Source XML. This functionality is available only from Pack H onwards');
298: fnd_file.put_line(FND_FILE.OUTPUT, 'End of Order Import Concurrent Program');
299: fnd_file.put_line(FND_FILE.OUTPUT, '');
300: Return;
301: End If;

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

294: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' And
295: l_order_source = '20'
296: Then
297: fnd_file.put_line(FND_FILE.OUTPUT, 'Cannot Import Order for Order Source XML. This functionality is available only from Pack H onwards');
298: fnd_file.put_line(FND_FILE.OUTPUT, 'End of Order Import Concurrent Program');
299: fnd_file.put_line(FND_FILE.OUTPUT, '');
300: Return;
301: End If;
302:

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

295: l_order_source = '20'
296: Then
297: fnd_file.put_line(FND_FILE.OUTPUT, 'Cannot Import Order for Order Source XML. This functionality is available only from Pack H onwards');
298: fnd_file.put_line(FND_FILE.OUTPUT, 'End of Order Import Concurrent Program');
299: fnd_file.put_line(FND_FILE.OUTPUT, '');
300: Return;
301: End If;
302:
303: --Check if Ct is atleast on Patchset Level H

Line 307: fnd_file.put_line(FND_FILE.OUTPUT, 'Cannot Import Multiple Shipments with the same Line Reference. This functionality is available only from Pack H onwards');

303: --Check if Ct is atleast on Patchset Level H
304: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' And
305: G_IMPORT_SHIPMENTS = 'YES'
306: Then
307: fnd_file.put_line(FND_FILE.OUTPUT, 'Cannot Import Multiple Shipments with the same Line Reference. This functionality is available only from Pack H onwards');
308: fnd_file.put_line(FND_FILE.OUTPUT, 'End of Order Import Concurrent Program');
309: fnd_file.put_line(FND_FILE.OUTPUT, '');
310: Return;
311: End If;

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

304: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110508' And
305: G_IMPORT_SHIPMENTS = 'YES'
306: Then
307: fnd_file.put_line(FND_FILE.OUTPUT, 'Cannot Import Multiple Shipments with the same Line Reference. This functionality is available only from Pack H onwards');
308: fnd_file.put_line(FND_FILE.OUTPUT, 'End of Order Import Concurrent Program');
309: fnd_file.put_line(FND_FILE.OUTPUT, '');
310: Return;
311: End If;
312:

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

305: G_IMPORT_SHIPMENTS = 'YES'
306: Then
307: fnd_file.put_line(FND_FILE.OUTPUT, 'Cannot Import Multiple Shipments with the same Line Reference. This functionality is available only from Pack H onwards');
308: fnd_file.put_line(FND_FILE.OUTPUT, 'End of Order Import Concurrent Program');
309: fnd_file.put_line(FND_FILE.OUTPUT, '');
310: Return;
311: End If;
312:
313: /* -----------------------------------------------------------

Line 335: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);

331: -----------------------------------------------------------
332: -- Setting Debug Mode and File
333: -----------------------------------------------------------
334:
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');

Line 340: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);

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');
344: END IF;

Line 341: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');

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');
344: END IF;
345:

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

378:
379: IF l_debug_level > 0 THEN
380: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
381: END IF;
382: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
383:
384:
385: IF l_num_instances > 0 THEN
386: /* -----------------------------------------------------------

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

496: oe_debug_pub.add( 'ROW COUNT = '||L_ROW_COUNT ) ;
497: END IF;
498:
499: IF l_row_count = 0 THEN
500: fnd_file.put_line(FND_FILE.OUTPUT,'No orders to process');
501: fnd_file.put_line(FND_FILE.OUTPUT,'Not spawning any child processes');
502: ELSE
503: -- aksingh working
504: l_req_data := fnd_conc_global.request_data;

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

497: END IF;
498:
499: IF l_row_count = 0 THEN
500: fnd_file.put_line(FND_FILE.OUTPUT,'No orders to process');
501: fnd_file.put_line(FND_FILE.OUTPUT,'Not spawning any child processes');
502: ELSE
503: -- aksingh working
504: l_req_data := fnd_conc_global.request_data;
505: if (l_req_data is not null) then

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

544:
545: IF l_debug_level > 0 THEN
546: oe_debug_pub.add( 'CHILD REQUEST ID = '||NEW_REQUEST_ID ) ;
547: END IF;
548: fnd_file.put_line(FND_FILE.OUTPUT, 'Child Request ID: '||new_request_id);
549:
550: IF (new_request_id = 0) THEN
551: fnd_file.put_line(FND_FILE.OUTPUT,'Error in submitting child request');
552: errbuf := FND_MESSAGE.GET;

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

547: END IF;
548: fnd_file.put_line(FND_FILE.OUTPUT, 'Child Request ID: '||new_request_id);
549:
550: IF (new_request_id = 0) THEN
551: fnd_file.put_line(FND_FILE.OUTPUT,'Error in submitting child request');
552: errbuf := FND_MESSAGE.GET;
553: retcode := 2;
554: ELSE
555: IF loop_counter <= l_mod THEN

Line 587: -- fnd_file.put_line(FND_FILE.OUTPUT,'No of orders imported: 0');

583: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
584: request_data => to_char(l_req_data_counter));
585: errbuf := 'Sub-Request ' || to_char(l_req_data_counter) || 'submitted!';
586: retcode := 0;
587: -- fnd_file.put_line(FND_FILE.OUTPUT,'No of orders imported: 0');
588: -- fnd_file.put_line(FND_FILE.OUTPUT,'No of orders failed: 0');
589: fnd_file.put_line(FND_FILE.OUTPUT,'');
590: END IF;
591:

Line 588: -- fnd_file.put_line(FND_FILE.OUTPUT,'No of orders failed: 0');

584: request_data => to_char(l_req_data_counter));
585: errbuf := 'Sub-Request ' || to_char(l_req_data_counter) || 'submitted!';
586: retcode := 0;
587: -- fnd_file.put_line(FND_FILE.OUTPUT,'No of orders imported: 0');
588: -- fnd_file.put_line(FND_FILE.OUTPUT,'No of orders failed: 0');
589: fnd_file.put_line(FND_FILE.OUTPUT,'');
590: END IF;
591:
592: ELSIF l_num_instances = 0 THEN

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

585: errbuf := 'Sub-Request ' || to_char(l_req_data_counter) || 'submitted!';
586: retcode := 0;
587: -- fnd_file.put_line(FND_FILE.OUTPUT,'No of orders imported: 0');
588: -- fnd_file.put_line(FND_FILE.OUTPUT,'No of orders failed: 0');
589: fnd_file.put_line(FND_FILE.OUTPUT,'');
590: END IF;
591:
592: ELSIF l_num_instances = 0 THEN
593: /* -----------------------------------------------------------

Line 807: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);

803: END IF;
804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
805: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
806: END IF;
807: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809:
810: end;
811:

Line 1102: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);

1098: END IF;
1099: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1100: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Order_Import_Conc_Pgm');
1101: END IF;
1102: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: end;
1105:
1106: END IF; -- p_perf_param was 'Y'

Line 1119: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||

1115: oe_debug_pub.add( 'NO. OF ORDERS IMPORTED: '|| L_COUNT_HEADER_SUCCESS ) ;
1116: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;
1117: END IF;
1118:
1119: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||
1120: l_count_header);
1121: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||
1122: l_count_header_success);
1123: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||

Line 1121: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||

1117: END IF;
1118:
1119: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||
1120: l_count_header);
1121: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||
1122: l_count_header_success);
1123: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||
1124: l_count_header_failure);
1125: fnd_file.put_line(FND_FILE.OUTPUT,'');

Line 1123: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||

1119: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||
1120: l_count_header);
1121: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||
1122: l_count_header_success);
1123: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||
1124: l_count_header_failure);
1125: fnd_file.put_line(FND_FILE.OUTPUT,'');
1126:
1127:

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

1121: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||
1122: l_count_header_success);
1123: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||
1124: l_count_header_failure);
1125: fnd_file.put_line(FND_FILE.OUTPUT,'');
1126:
1127:
1128: /* SELECT count(*) INTO l_count_msgs
1129: FROM oe_processing_msgs_vl

Line 1133: fnd_file.put_line(FND_FILE.OUTPUT,'No. of messages: '||l_count_msgs);

1129: FROM oe_processing_msgs_vl
1130: WHERE request_id = l_request_id;
1131:
1132: IF l_count_msgs > 0 THEN
1133: fnd_file.put_line(FND_FILE.OUTPUT,'No. of messages: '||l_count_msgs);
1134: fnd_file.put_line(FND_FILE.OUTPUT,'');
1135: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
1136: */
1137: /* -----------------------------------------------------------

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

1130: WHERE request_id = l_request_id;
1131:
1132: IF l_count_msgs > 0 THEN
1133: fnd_file.put_line(FND_FILE.OUTPUT,'No. of messages: '||l_count_msgs);
1134: fnd_file.put_line(FND_FILE.OUTPUT,'');
1135: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
1136: */
1137: /* -----------------------------------------------------------
1138: Messages

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

1131:
1132: IF l_count_msgs > 0 THEN
1133: fnd_file.put_line(FND_FILE.OUTPUT,'No. of messages: '||l_count_msgs);
1134: fnd_file.put_line(FND_FILE.OUTPUT,'');
1135: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
1136: */
1137: /* -----------------------------------------------------------
1138: Messages
1139: -----------------------------------------------------------

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

1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add( 'BEFORE MESSAGES LOOP' ) ;
1143: END IF;
1144:
1145: fnd_file.put_line(FND_FILE.OUTPUT,'');
1146: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
1147: OPEN l_msg_cursor;
1148: LOOP
1149: FETCH l_msg_cursor

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

1142: oe_debug_pub.add( 'BEFORE MESSAGES LOOP' ) ;
1143: END IF;
1144:
1145: fnd_file.put_line(FND_FILE.OUTPUT,'');
1146: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
1147: OPEN l_msg_cursor;
1148: LOOP
1149: FETCH l_msg_cursor
1150: INTO l_order_source_id

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

1154: , l_org_id --MOAC
1155: , l_message_text;
1156: EXIT WHEN l_msg_cursor%NOTFOUND;
1157:
1158: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_order_source_id)
1159: ||'/'||l_orig_sys_document_ref
1160: ||'/'||l_change_sequence
1161: ||'/'||l_org_id
1162: ||'/'||l_orig_sys_line_ref

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

1160: ||'/'||l_change_sequence
1161: ||'/'||l_org_id
1162: ||'/'||l_orig_sys_line_ref
1163: ||' '||l_message_text);
1164: fnd_file.put_line(FND_FILE.OUTPUT,'');
1165: END LOOP;
1166: -- END IF;
1167:
1168: END IF;

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

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

Line 1191: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||

1187: END IF;
1188:
1189: retcode := 2;
1190:
1191: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||
1192: l_count_header);
1193: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||
1194: l_count_header_success);
1195: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||

Line 1193: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||

1189: retcode := 2;
1190:
1191: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||
1192: l_count_header);
1193: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||
1194: l_count_header_success);
1195: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||
1196: l_count_header_failure);
1197: fnd_file.put_line(FND_FILE.OUTPUT,'');

Line 1195: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||

1191: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||
1192: l_count_header);
1193: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||
1194: l_count_header_success);
1195: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||
1196: l_count_header_failure);
1197: fnd_file.put_line(FND_FILE.OUTPUT,'');
1198:
1199: END ORDER_IMPORT_CONC_PGM;

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

1193: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders imported: '||
1194: l_count_header_success);
1195: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||
1196: l_count_header_failure);
1197: fnd_file.put_line(FND_FILE.OUTPUT,'');
1198:
1199: END ORDER_IMPORT_CONC_PGM;
1200:
1201: