DBA Data[Home] [Help]

APPS.OKL_ARFETCH_PUB dependencies on FND_FILE

Line 12: FND_FILE.PUT_LINE (FND_FILE.LOG,p_message);

8: IS
9: BEGIN
10:
11: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
12: FND_FILE.PUT_LINE (FND_FILE.LOG,p_message);
13:
14: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'okl_arfetch_pub',
15: p_message );
16:

Line 21: FND_FILE.PUT_LINE(FND_FILE.LOG,p_message);

17: END IF;
18:
19: okl_debug_pub.logmessage(NVL(p_message, 'NONE'));
20:
21: FND_FILE.PUT_LINE(FND_FILE.LOG,p_message);
22: --dbms_output.put_line(p_message);
23: END PRINT_TO_LOG;
24:
25:

Line 436: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Processing: Consolidated Invoice=> '||cons_inv(indx)

432: END IF; -- Lsm records found
433:
434: IF customer_trx_id_tbl.count > 0 THEN
435: FOR indx in customer_trx_id_tbl.FIRST..customer_trx_id_tbl.LAST LOOP
436: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Processing: Consolidated Invoice=> '||cons_inv(indx)
437: ||' , Stream=> '||sty_name(indx)
438: ||' ,Amount=> '||lsm_amount_tbl(indx));
439: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Fetching Assigned AR Invoice=> '||trx_number_tbl(indx));
440: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' TAX Amount is => '||tax_amount_tbl(indx));

Line 439: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Fetching Assigned AR Invoice=> '||trx_number_tbl(indx));

435: FOR indx in customer_trx_id_tbl.FIRST..customer_trx_id_tbl.LAST LOOP
436: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Processing: Consolidated Invoice=> '||cons_inv(indx)
437: ||' , Stream=> '||sty_name(indx)
438: ||' ,Amount=> '||lsm_amount_tbl(indx));
439: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Fetching Assigned AR Invoice=> '||trx_number_tbl(indx));
440: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' TAX Amount is => '||tax_amount_tbl(indx));
441: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Due Date is => '||due_date_tbl(indx));
442: END LOOP;
443: END IF;

Line 440: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' TAX Amount is => '||tax_amount_tbl(indx));

436: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'Processing: Consolidated Invoice=> '||cons_inv(indx)
437: ||' , Stream=> '||sty_name(indx)
438: ||' ,Amount=> '||lsm_amount_tbl(indx));
439: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Fetching Assigned AR Invoice=> '||trx_number_tbl(indx));
440: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' TAX Amount is => '||tax_amount_tbl(indx));
441: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Due Date is => '||due_date_tbl(indx));
442: END LOOP;
443: END IF;
444:

Line 441: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Due Date is => '||due_date_tbl(indx));

437: ||' , Stream=> '||sty_name(indx)
438: ||' ,Amount=> '||lsm_amount_tbl(indx));
439: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Fetching Assigned AR Invoice=> '||trx_number_tbl(indx));
440: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' TAX Amount is => '||tax_amount_tbl(indx));
441: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Due Date is => '||due_date_tbl(indx));
442: END LOOP;
443: END IF;
444:
445:

Line 460: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'ERROR (01): '||SQLERRM);

456: x_msg_data => x_msg_data);
457:
458: EXCEPTION
459: WHEN bulk_errors THEN
460: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'ERROR (01): '||SQLERRM);
461:
462: if sql%bulk_exceptions.count > 0 then
463: for i in 1..sql%bulk_exceptions.count loop
464: print_to_log('while fetching, error ' || i || ' occurred during '||

Line 473: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'ERROR (02): '||SQLERRM);

469: end loop;
470: end if;
471:
472: WHEN OTHERS THEN
473: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, 'ERROR (02): '||SQLERRM);
474: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
475: (
476: l_api_name,
477: 'Okl_Arfetch_Pub',

Line 503: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Starting Fetcher Program.. ');

499: lx_return_status VARCHAR2(1);
500:
501: BEGIN
502:
503: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Starting Fetcher Program.. ');
504: Okl_Arfetch_Pub.get_AR_invoice_numbers (
505: p_api_version => l_api_version,
506: p_init_msg_list => Okl_Api.G_FALSE,
507: x_return_status => lx_return_status,

Line 511: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Ending Fetcher Program.. ');

507: x_return_status => lx_return_status,
508: x_msg_count => lx_msg_count,
509: x_msg_data => errbuf
510: );
511: Fnd_File.PUT_LINE (Fnd_File.LOG, 'Ending Fetcher Program.. ');
512: IF lx_msg_count > 0 THEN
513: FOR i IN 1..lx_msg_count LOOP
514: Fnd_Msg_Pub.get (p_msg_index => i,
515: p_encoded => 'F',

Line 518: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);

514: Fnd_Msg_Pub.get (p_msg_index => i,
515: p_encoded => 'F',
516: p_data => lx_msg_data,
517: p_msg_index_out => l_msg_index_out);
518: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,TO_CHAR(i) || ': ' || lx_msg_data);
519: END LOOP;
520: END IF;
521:
522: EXCEPTION

Line 524: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);

520: END IF;
521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Error '||TO_CHAR(SQLCODE)||': '||SQLERRM);
525: END get_AR_invoice_numbers_conc;
526:
527: END Okl_Arfetch_Pub;