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 381: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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