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.QP_BULK_LOADER_PUB dependencies on FND_FILE

Line 51: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug On: '||G_QP_DEBUG);

47: G_QP_ENABLE_DUP_LINE_CHECK :=p_enable_dup_ln_check;
48: write_log('Duplicate Line Check: '||p_enable_dup_ln_check);
49:
50: G_QP_DEBUG := p_debug_on;
51: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Debug On: '||G_QP_DEBUG);
52: FND_PROFILE.GET('QP_BATCH_SIZE_FOR_BULK_IMPORT',g_qp_batch_size); --bug no. 9652756 - profile name was wrong
53: if g_qp_batch_size is NULL or g_qp_batch_size < 1 then
54: g_qp_batch_size := 1000;
55: end if;

Line 60: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------Processing Price List Entity--------');

56: write_log('Batch Size: '||to_char(g_qp_batch_size));
57:
58: IF p_entity = 'PRL' THEN
59:
60: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------Processing Price List Entity--------');
61:
62: load_lists
63: ( err_buff=>err_buff
64: ,retcode=>retcode

Line 73: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Only Price List Entity processing allowed');

69: ,p_no_of_threads=>p_no_of_threads
70: ,p_spawned_request=>p_spawned_request
71: ,p_request_id =>p_request_id);
72: ELSE
73: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Only Price List Entity processing allowed');
74: END IF;
75:
76: END LOAD_PRICING_DATA;
77:

Line 377: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the header process 2 (sec):' ||(l_end_time - l_start_time)/100);

373: CLEAN_UP_CODE(l_request_id);
374:
375: select hsecs into l_end_time from v$timer;
376: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
377: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the header process 2 (sec):' ||(l_end_time - l_start_time)/100);
378: Return;
379: ELSE -- ( l_req_data IS NULL)
380: write_log( 'First Call');
381: l_req_data_counter:=1;

Line 387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------Bulk Pricelist Data Loader---------');

383: END IF; -- ( l_req_data IS NOT NULL)
384:
385: ---- Header Started
386:
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------Bulk Pricelist Data Loader---------');
388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Paremeters');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Entity Name: '||p_entity_name);
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Id: '||p_process_id);
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Type:'||p_process_type);

Line 388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Paremeters');

384:
385: ---- Header Started
386:
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------Bulk Pricelist Data Loader---------');
388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Paremeters');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Entity Name: '||p_entity_name);
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Id: '||p_process_id);
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Type:'||p_process_type);
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);

Line 389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Entity Name: '||p_entity_name);

385: ---- Header Started
386:
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------Bulk Pricelist Data Loader---------');
388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Paremeters');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Entity Name: '||p_entity_name);
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Id: '||p_process_id);
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Type:'||p_process_type);
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Threads: '||p_no_of_threads);

Line 390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Id: '||p_process_id);

386:
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------Bulk Pricelist Data Loader---------');
388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Paremeters');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Entity Name: '||p_entity_name);
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Id: '||p_process_id);
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Type:'||p_process_type);
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Threads: '||p_no_of_threads);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------');

Line 391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Type:'||p_process_type);

387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'-----------Bulk Pricelist Data Loader---------');
388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Paremeters');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Entity Name: '||p_entity_name);
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Id: '||p_process_id);
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Type:'||p_process_type);
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Threads: '||p_no_of_threads);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------');
395:

Line 392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);

388: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Paremeters');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Entity Name: '||p_entity_name);
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Id: '||p_process_id);
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Type:'||p_process_type);
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Threads: '||p_no_of_threads);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------');
395:
396: select hsecs into l_start_time from v$timer;

Line 393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Threads: '||p_no_of_threads);

389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Entity Name: '||p_entity_name);
390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Id: '||p_process_id);
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Type:'||p_process_type);
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Threads: '||p_no_of_threads);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------');
395:
396: select hsecs into l_start_time from v$timer;
397: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));

Line 394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------');

390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Id: '||p_process_id);
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Type:'||p_process_type);
392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Process Parent: '||p_process_parent);
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Threads: '||p_no_of_threads);
394: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------------------------');
395:
396: select hsecs into l_start_time from v$timer;
397: write_log( 'Start time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
398:

Line 3509: FND_FILE.put_line(FND_FILE.OUTPUT, 'Error in spawning child process');

3505: write_log( 'Child '||I||' request_id: '||l_new_request_id);
3506:
3507: IF l_new_request_id=0
3508: THEN
3509: FND_FILE.put_line(FND_FILE.OUTPUT, 'Error in spawning child process');
3510: retcode := 2;
3511: err_buff := FND_MESSAGE.GET;
3512: Return;
3513: ELSE

Line 3542: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the header process 1 (sec):' ||(l_end_time - l_start_time)/100);

3538: END LOOP;
3539:
3540: select hsecs into l_end_time from v$timer;
3541: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
3542: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the header process 1 (sec):' ||(l_end_time - l_start_time)/100);
3543:
3544: --Parents waits untill all the threads complete
3545: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
3546: request_data =>to_char(l_req_data_counter));

Line 4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Lines: '||l_suc_line);

4714: AND process_status_flag IS NULL;
4715:
4716: purge(l_request_id);
4717:
4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Lines: '||l_suc_line);
4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Lines: '||l_err_line);
4720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Pricing Attr: '||l_suc_pr_attr);
4721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Pricing Attr: '||l_err_pr_attr);
4722: ERRORS_TO_OUTPUT(l_request_id);

Line 4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Lines: '||l_err_line);

4715:
4716: purge(l_request_id);
4717:
4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Lines: '||l_suc_line);
4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Lines: '||l_err_line);
4720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Pricing Attr: '||l_suc_pr_attr);
4721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Pricing Attr: '||l_err_pr_attr);
4722: ERRORS_TO_OUTPUT(l_request_id);
4723:

Line 4720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Pricing Attr: '||l_suc_pr_attr);

4716: purge(l_request_id);
4717:
4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Lines: '||l_suc_line);
4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Lines: '||l_err_line);
4720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Pricing Attr: '||l_suc_pr_attr);
4721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Pricing Attr: '||l_err_pr_attr);
4722: ERRORS_TO_OUTPUT(l_request_id);
4723:
4724: select hsecs into l_end_time from v$timer;

Line 4721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Pricing Attr: '||l_err_pr_attr);

4717:
4718: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Lines: '||l_suc_line);
4719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Lines: '||l_err_line);
4720: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Successfully Processed Pricing Attr: '||l_suc_pr_attr);
4721: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'Number Of Errored Pricing Attr: '||l_err_pr_attr);
4722: ERRORS_TO_OUTPUT(l_request_id);
4723:
4724: select hsecs into l_end_time from v$timer;
4725: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));

Line 4726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);

4722: ERRORS_TO_OUTPUT(l_request_id);
4723:
4724: select hsecs into l_end_time from v$timer;
4725: write_log( 'End time :'||to_char(sysdate,'MM/DD/YYYY:HH:MM:SS'));
4726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Time taken for the line process (sec):' ||(l_end_time - l_start_time)/100);
4727:
4728: END IF;
4729:
4730: EXCEPTION

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

7168: l_ORIG_SYS_HEADER_REF VARCHAR2(50);
7169: l_ORIG_SYS_QUALIFIER_REF VARCHAR2(50);
7170:
7171: BEGIN
7172: fnd_file.put_line(FND_FILE.OUTPUT,'');
7173: fnd_file.put_line(FND_FILE.OUTPUT,'Error Details');
7174: fnd_file.put_line(FND_FILE.OUTPUT,'');
7175: OPEN c_errors;
7176: LOOP

Line 7173: fnd_file.put_line(FND_FILE.OUTPUT,'Error Details');

7169: l_ORIG_SYS_QUALIFIER_REF VARCHAR2(50);
7170:
7171: BEGIN
7172: fnd_file.put_line(FND_FILE.OUTPUT,'');
7173: fnd_file.put_line(FND_FILE.OUTPUT,'Error Details');
7174: fnd_file.put_line(FND_FILE.OUTPUT,'');
7175: OPEN c_errors;
7176: LOOP
7177: FETCH c_errors

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

7170:
7171: BEGIN
7172: fnd_file.put_line(FND_FILE.OUTPUT,'');
7173: fnd_file.put_line(FND_FILE.OUTPUT,'Error Details');
7174: fnd_file.put_line(FND_FILE.OUTPUT,'');
7175: OPEN c_errors;
7176: LOOP
7177: FETCH c_errors
7178: INTO l_request_id,

Line 7189: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)

7185: l_error_message;
7186:
7187: EXIT WHEN c_errors%NOTFOUND;
7188: if l_table_name = 'QP_INTERFACE_LIST_HEADERS' then
7189: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)
7190: ||'/'||l_entity_type
7191: ||'/'||l_table_name
7192: ||'/'||l_orig_sys_header_ref
7193: ||' '||l_error_message);

Line 7195: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)

7191: ||'/'||l_table_name
7192: ||'/'||l_orig_sys_header_ref
7193: ||' '||l_error_message);
7194: elsif l_table_name = 'QP_INTERFACE_LIST_LINES' then
7195: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)
7196: ||'/'||l_entity_type
7197: ||'/'||l_table_name
7198: ||'/'||l_orig_sys_header_ref
7199: ||'/'||l_orig_sys_line_ref

Line 7202: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)

7198: ||'/'||l_orig_sys_header_ref
7199: ||'/'||l_orig_sys_line_ref
7200: ||' '||l_error_message);
7201: elsif l_table_name = 'QP_INTERFACE_LIST_QUALIFIERS' then
7202: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)
7203: ||'/'||l_entity_type
7204: ||'/'||l_table_name
7205: ||'/'||l_orig_sys_header_ref
7206: ||'/'||l_orig_sys_qualifier_ref

Line 7209: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)

7205: ||'/'||l_orig_sys_header_ref
7206: ||'/'||l_orig_sys_qualifier_ref
7207: ||' '||l_error_message);
7208: elsif l_table_name = 'QP_INTERFACE_LIST_PRICING_ATTRIBS' then
7209: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)
7210: ||'/'||l_entity_type
7211: ||'/'||l_table_name
7212: ||'/'||l_orig_sys_header_ref
7213: ||'/'||l_orig_sys_line_ref

Line 7217: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)

7213: ||'/'||l_orig_sys_line_ref
7214: ||'/'||l_orig_sys_pricing_attr_ref
7215: ||' '||l_error_message);
7216: else
7217: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_request_id)
7218: ||'/'||l_entity_type
7219: ||'/'||l_table_name
7220: ||'/'||l_orig_sys_header_ref
7221: ||'/'||l_orig_sys_qualifier_ref

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

7223: ||'/'||l_orig_sys_pricing_attr_ref
7224: ||' '||l_error_message);
7225:
7226: end if;
7227: fnd_file.put_line(FND_FILE.OUTPUT,'');
7228: END LOOP;
7229: END;
7230:
7231: PROCEDURE PURGE

Line 7315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Headers: '||l_suc_head);

7311: and process_status_flag IS NULL;
7312:
7313: purge(l_request_id);
7314:
7315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Headers: '||l_suc_head);
7316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Headers: '||l_err_head);
7317: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Qualifiers: '||l_suc_qual);
7318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Qualifiers: '||l_err_qual);
7319: ERRORS_TO_OUTPUT(l_request_id);

Line 7316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Headers: '||l_err_head);

7312:
7313: purge(l_request_id);
7314:
7315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Headers: '||l_suc_head);
7316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Headers: '||l_err_head);
7317: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Qualifiers: '||l_suc_qual);
7318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Qualifiers: '||l_err_qual);
7319: ERRORS_TO_OUTPUT(l_request_id);
7320: END;

Line 7317: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Qualifiers: '||l_suc_qual);

7313: purge(l_request_id);
7314:
7315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Headers: '||l_suc_head);
7316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Headers: '||l_err_head);
7317: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Qualifiers: '||l_suc_qual);
7318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Qualifiers: '||l_err_qual);
7319: ERRORS_TO_OUTPUT(l_request_id);
7320: END;
7321:

Line 7318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Qualifiers: '||l_err_qual);

7314:
7315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Headers: '||l_suc_head);
7316: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Headers: '||l_err_head);
7317: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of succesfully Processed Qualifiers: '||l_suc_qual);
7318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Number Of Errored Qualifiers: '||l_err_qual);
7319: ERRORS_TO_OUTPUT(l_request_id);
7320: END;
7321:
7322: PROCEDURE write_log(log_text VARCHAR2)

Line 7326: FND_FILE.PUT_LINE(FND_FILE.LOG, log_text);

7322: PROCEDURE write_log(log_text VARCHAR2)
7323: IS
7324: BEGIN
7325: IF G_QP_DEBUG = 'Y' THEN
7326: FND_FILE.PUT_LINE(FND_FILE.LOG, log_text);
7327: END IF;
7328: END;
7329:
7330: END QP_BULK_LOADER_PUB;