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.JAI_AR_VALIDATE_DATA_PKG dependencies on UTL_FILE

Line 769: WHERE name = 'utl_file_dir';

765: CURSOR cur_utl_location
766: IS
767: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,Value,SUBSTR (value,1,INSTR(value,',') -1)) utl_location
768: FROM v$parameter
769: WHERE name = 'utl_file_dir';
770:
771: CURSOR cur_sync_il_line_tax (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE)
772: IS
773: SELECT jrctl.customer_trx_line_id,

Line 798: ln_file_hdl UTL_FILE.FILE_TYPE;

794: FROM JAI_AR_TRXS a
795: WHERE a.customer_trx_id = jtrx.customer_trx_id);
796:
797: lv_utl_location VARCHAR2(512);
798: ln_file_hdl UTL_FILE.FILE_TYPE;
799: lv_process_status VARCHAR2(2);
800: lv_process_message VARCHAR2(1000);
801:
802: rec_tot_payment_schedule cur_tot_payment_schedule%ROWTYPE;

Line 914: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_log_filename,'W');

910: lv_log_filename := 'jai_ar_recon.log';
911: lv_datafix_filename := 'jai_ar_recon_datafix.log';
912: END IF;
913:
914: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_log_filename,'W');
915: UTL_FILE.FCLOSE (ln_file_hdl);
916:
917: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_datafix_filename,'W');
918: UTL_FILE.FCLOSE (ln_file_hdl);

Line 915: UTL_FILE.FCLOSE (ln_file_hdl);

911: lv_datafix_filename := 'jai_ar_recon_datafix.log';
912: END IF;
913:
914: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_log_filename,'W');
915: UTL_FILE.FCLOSE (ln_file_hdl);
916:
917: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_datafix_filename,'W');
918: UTL_FILE.FCLOSE (ln_file_hdl);
919:

Line 917: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_datafix_filename,'W');

913:
914: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_log_filename,'W');
915: UTL_FILE.FCLOSE (ln_file_hdl);
916:
917: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_datafix_filename,'W');
918: UTL_FILE.FCLOSE (ln_file_hdl);
919:
920: ELSE
921: lv_log_filename := p_log_filename;

Line 918: UTL_FILE.FCLOSE (ln_file_hdl);

914: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_log_filename,'W');
915: UTL_FILE.FCLOSE (ln_file_hdl);
916:
917: ln_file_hdl := UTL_FILE.FOPEN (lv_utl_location, lv_datafix_filename,'W');
918: UTL_FILE.FCLOSE (ln_file_hdl);
919:
920: ELSE
921: lv_log_filename := p_log_filename;
922: lv_datafix_filename := NVL(SUBSTR(lv_log_filename,1,instr(lv_log_filename,'.',1,1)-1),lv_log_filename)||'_datafix'||substr(lv_log_filename,instr(lv_log_filename,'.',1,1));