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_EER1_PKG dependencies on UTL_FILE

Line 153: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W',32767);

149: IS
150:
151: BEGIN
152:
153: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W',32767);
154:
155: v_utl_file_dir := p_directory;
156: v_utl_file_name := p_filename;
157:

Line 155: v_utl_file_dir := p_directory;

151: BEGIN
152:
153: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W',32767);
154:
155: v_utl_file_dir := p_directory;
156: v_utl_file_name := p_filename;
157:
158: END openFile;
159:

Line 156: v_utl_file_name := p_filename;

152:
153: v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W',32767);
154:
155: v_utl_file_dir := p_directory;
156: v_utl_file_name := p_filename;
157:
158: END openFile;
159:
160: -- Procedure to close the file

Line 165: UTL_FILE.fclose(v_filehandle);

161:
162: PROCEDURE closeFile
163: IS
164: BEGIN
165: UTL_FILE.fclose(v_filehandle);
166: END closeFile;
167:
168:
169: -- Procedure to Create the CETH header in the file

Line 174: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;

170:
171: PROCEDURE create_ceth_header
172: IS
173: BEGIN
174: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
175:
176: UTL_FILE.PUT_LINE(v_filehandle,
177: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
178: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 176: UTL_FILE.PUT_LINE(v_filehandle,

172: IS
173: BEGIN
174: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
175:
176: UTL_FILE.PUT_LINE(v_filehandle,
177: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
178: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
179: LPAD('Reg No', sq_len_15, v_quart_pad) || v_pad_char ||
180: LPAD('YM', sq_len_6, v_quart_pad) || v_pad_char ||

Line 248: UTL_FILE.PUT_LINE(v_filehandle,

244: LPAD('DP EDUCES', sq_len_15, v_quart_pad) || v_pad_char ||
245: LPAD('PA EC', sq_len_7, v_quart_pad)
246: );
247:
248: UTL_FILE.PUT_LINE(v_filehandle,
249: LPAD(v_underline_char, sq_len_50, v_underline_char) || v_pad_char ||
250: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
251: LPAD(v_underline_char, sq_len_15, v_underline_char) || v_pad_char ||
252: LPAD(v_underline_char, sq_len_6, v_underline_char) || v_pad_char ||

Line 326: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;

322: -- Procedure to create DUTY PAID headers
323:
324: PROCEDURE create_duty_header IS
325: BEGIN
326: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
327:
328: UTL_FILE.PUT_LINE(v_filehandle,
329: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
330: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 328: UTL_FILE.PUT_LINE(v_filehandle,

324: PROCEDURE create_duty_header IS
325: BEGIN
326: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
327:
328: UTL_FILE.PUT_LINE(v_filehandle,
329: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
330: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
331: LPAD('Reg No', sq_len_15, v_quart_pad) || v_pad_char ||
332: LPAD('YM', sq_len_6, v_quart_pad) || v_pad_char ||

Line 387: UTL_FILE.PUT_LINE(v_filehandle,

383: LPAD('DP CR ADET', sq_len_15, v_quart_pad) || v_pad_char ||
384: LPAD('DP CU ADET', sq_len_15, v_quart_pad)
385: );
386:
387: UTL_FILE.PUT_LINE(v_filehandle,
388: LPAD(v_underline_char, sq_len_50, v_underline_char) || v_pad_char ||
389: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
390: LPAD(v_underline_char, sq_len_15, v_underline_char) || v_pad_char ||
391: LPAD(v_underline_char, sq_len_6, v_underline_char) || v_pad_char ||

Line 453: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;

449:
450: PROCEDURE create_input_header
451: IS
452: BEGIN
453: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
454:
455: UTL_FILE.PUT_LINE(v_filehandle,
456: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
457: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 455: UTL_FILE.PUT_LINE(v_filehandle,

451: IS
452: BEGIN
453: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
454:
455: UTL_FILE.PUT_LINE(v_filehandle,
456: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
457: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
458: LPAD('Reg No', sq_len_15, v_quart_pad) || v_pad_char ||
459: LPAD('YM', sq_len_6, v_quart_pad) || v_pad_char ||

Line 470: UTL_FILE.PUT_LINE(v_filehandle,

466: LPAD('NOTF', sq_len_8, v_quart_pad) || v_pad_char ||
467: LPAD('NOTF SNO', sq_len_10, v_quart_pad)
468: );
469:
470: UTL_FILE.PUT_LINE(v_filehandle,
471: LPAD(v_underline_char, sq_len_50, v_underline_char) || v_pad_char ||
472: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
473: LPAD(v_underline_char, sq_len_15, v_underline_char) || v_pad_char ||
474: LPAD(v_underline_char, sq_len_6, v_underline_char) || v_pad_char ||

Line 492: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;

488:
489: PROCEDURE create_cenvat_header
490: IS
491: BEGIN
492: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
493:
494: UTL_FILE.PUT_LINE(v_filehandle,
495: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
496: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 494: UTL_FILE.PUT_LINE(v_filehandle,

490: IS
491: BEGIN
492: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
493:
494: UTL_FILE.PUT_LINE(v_filehandle,
495: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
496: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
497: LPAD('Reg No', sq_len_15, v_quart_pad) || v_pad_char ||
498: LPAD('YM', sq_len_6, v_quart_pad) || v_pad_char ||

Line 583: UTL_FILE.PUT_LINE(v_filehandle,

579: LPAD('CR UDS STEC', sq_len_12, v_quart_pad) || v_pad_char ||
580: LPAD('CL BAL STEC', sq_len_12, v_quart_pad)
581: );
582:
583: UTL_FILE.PUT_LINE(v_filehandle,
584: LPAD(v_underline_char, sq_len_50, v_underline_char) || v_pad_char ||
585: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
586: LPAD(v_underline_char, sq_len_15, v_underline_char) || v_pad_char ||
587: LPAD(v_underline_char, sq_len_6, v_underline_char) || v_pad_char ||

Line 679: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;

675:
676: PROCEDURE create_payment_header
677: IS
678: BEGIN
679: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
680:
681: UTL_FILE.PUT_LINE(v_filehandle,
682: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
683: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 681: UTL_FILE.PUT_LINE(v_filehandle,

677: IS
678: BEGIN
679: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
680:
681: UTL_FILE.PUT_LINE(v_filehandle,
682: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
683: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
684: LPAD('Reg No', sq_len_15, v_quart_pad) || v_pad_char ||
685: LPAD('YM', sq_len_6, v_quart_pad) || v_pad_char ||

Line 724: UTL_FILE.PUT_LINE(v_filehandle,

720: LPAD('MIS SRCNO', sq_len_40, v_quart_pad) || v_pad_char ||
721: LPAD('MIS SDT', sq_len_10, v_quart_pad)
722: );
723:
724: UTL_FILE.PUT_LINE(v_filehandle,
725: LPAD(v_underline_char, sq_len_50, v_underline_char) || v_pad_char ||
726: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
727: LPAD(v_underline_char, sq_len_15, v_underline_char) || v_pad_char ||
728: LPAD(v_underline_char, sq_len_6, v_underline_char) || v_pad_char ||

Line 774: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;

770: -- Procedure to create SELF ASSESSMENT MEMORANDUM headers
771:
772: PROCEDURE create_sam_header IS
773: BEGIN
774: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
775:
776: UTL_FILE.PUT_LINE(v_filehandle,
777: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
778: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 776: UTL_FILE.PUT_LINE(v_filehandle,

772: PROCEDURE create_sam_header IS
773: BEGIN
774: UTL_FILE.PUT_LINE(v_filehandle, ' ' ) ;
775:
776: UTL_FILE.PUT_LINE(v_filehandle,
777: LPAD('Record Header', sq_len_50, v_quart_pad) || v_pad_char ||
778: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
779: LPAD('Reg No', sq_len_15, v_quart_pad) || v_pad_char ||
780: LPAD('YM', sq_len_6, v_quart_pad) || v_pad_char ||

Line 802: UTL_FILE.PUT_LINE(v_filehandle,

798: LPAD('NAME AUTH SIGN', sq_len_40, v_quart_pad)
799: );
800:
801:
802: UTL_FILE.PUT_LINE(v_filehandle,
803: LPAD(v_underline_char, sq_len_50, v_underline_char) || v_pad_char ||
804: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
805: LPAD(v_underline_char, sq_len_15, v_underline_char) || v_pad_char ||
806: LPAD(v_underline_char, sq_len_6, v_underline_char) || v_pad_char ||

Line 996: UTL_FILE.PUT_LINE(v_filehandle,p_str);

992: p_str := p_str || format_action( p_duty_payable_edu_cess ,sq_len_15, p_action);
993: p_str := p_str || format_action( p_pa_no_edu_cess ,sq_len_7, p_action, lv_last_flag);
994:
995:
996: UTL_FILE.PUT_LINE(v_filehandle,p_str);
997: p_str:= NULL;
998:
999: END create_ceth_details;
1000:

Line 1120: UTL_FILE.PUT_LINE(v_filehandle,p_str);

1116: p_str := p_str || format_action( p_duty_paid_total_ade ,sq_len_15, p_action);
1117: p_str := p_str || format_action( p_duty_paid_credit_adet ,sq_len_15, p_action);
1118: p_str := p_str || format_action( p_duty_paid_current_adet ,sq_len_15, p_action, lv_last_flag);
1119:
1120: UTL_FILE.PUT_LINE(v_filehandle,p_str);
1121: p_str:= NULL;
1122:
1123: END create_duty_paid_details;
1124:

Line 1156: UTL_FILE.PUT_LINE(v_filehandle,p_str);

1152: p_str := p_str || format_action( p_notf_no ,sq_len_8, p_action);
1153: p_str := p_str || format_action( p_notf_sno ,sq_len_10, p_action, lv_last_flag);
1154:
1155:
1156: UTL_FILE.PUT_LINE(v_filehandle,p_str);
1157: p_str:= NULL;
1158:
1159: END create_input_details;
1160:

Line 1341: UTL_FILE.PUT_LINE(v_filehandle,p_str);

1337: p_str := p_str || format_action( p_clos_bal_st_edu_cess ,sq_len_12, p_action, lv_last_flag);
1338:
1339:
1340:
1341: UTL_FILE.PUT_LINE(v_filehandle,p_str);
1342: p_str:= NULL;
1343:
1344: END create_cenvat_details;
1345:

Line 1434: UTL_FILE.PUT_LINE(v_filehandle,p_str);

1430: p_str := p_str || format_action( p_misc_source_no ,sq_len_40, p_action);
1431: p_str := p_str || format_action( to_char(p_misc_source_date, 'DD/MM/YYYY') ,sq_len_10, p_action, lv_last_flag);
1432:
1433:
1434: UTL_FILE.PUT_LINE(v_filehandle,p_str);
1435: p_str:= NULL;
1436:
1437: END create_payment_details;
1438:

Line 1491: UTL_FILE.PUT_LINE(v_filehandle,p_str);

1487: p_str := p_str || format_action( to_char(p_date_filing,'DD/MM/YYYY') ,sq_len_10, p_action);
1488: p_str := p_str || format_action( p_name_auth_sign ,sq_len_40, p_action, lv_last_flag);
1489:
1490:
1491: UTL_FILE.PUT_LINE(v_filehandle,p_str);
1492: p_str:= NULL;
1493:
1494: END create_sam_details;
1495: