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

Line 294: jai_ap_tds_etds_pkg.v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 2000);

290: ) IS
291:
292: BEGIN
293:
294: jai_ap_tds_etds_pkg.v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 2000);
295: jai_ap_tds_etds_pkg.v_utl_file_dir := p_directory;
296: jai_ap_tds_etds_pkg.v_utl_file_name := p_filename;
297:
298: END openFile;

Line 295: jai_ap_tds_etds_pkg.v_utl_file_dir := p_directory;

291:
292: BEGIN
293:
294: jai_ap_tds_etds_pkg.v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 2000);
295: jai_ap_tds_etds_pkg.v_utl_file_dir := p_directory;
296: jai_ap_tds_etds_pkg.v_utl_file_name := p_filename;
297:
298: END openFile;
299:

Line 296: jai_ap_tds_etds_pkg.v_utl_file_name := p_filename;

292: BEGIN
293:
294: jai_ap_tds_etds_pkg.v_filehandle := UTL_FILE.fopen(p_directory, p_filename, 'W', 2000);
295: jai_ap_tds_etds_pkg.v_utl_file_dir := p_directory;
296: jai_ap_tds_etds_pkg.v_utl_file_name := p_filename;
297:
298: END openFile;
299:
300: PROCEDURE closeFile IS

Line 302: UTL_FILE.fclose(jai_ap_tds_etds_pkg.v_filehandle);

298: END openFile;
299:
300: PROCEDURE closeFile IS
301: BEGIN
302: UTL_FILE.fclose(jai_ap_tds_etds_pkg.v_filehandle);
303: END closeFile;
304:
305: -- Date Population procedures for ETCS Quarterly Returns
306: PROCEDURE create_quarterly_fh(

Line 323: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');

319: v_req JAI_AP_ETDS_REQUESTS%rowtype;
320: BEGIN
321:
322: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
323: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
324: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
325: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
326: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
327: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

Line 324: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');

320: BEGIN
321:
322: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
323: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
324: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
325: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
326: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
327: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
328: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

Line 325: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

321:
322: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
323: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
324: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
325: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
326: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
327: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
328: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
329: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

Line 356: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

352: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
353: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
354: );
355:
356: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
357: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
358: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
359: LPAD('FT', sq_len_4, v_quart_pad) || v_pad_char ||
360: LPAD('UT', sq_len_2, v_quart_pad) || v_pad_char ||

Line 375: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

371: LPAD('SH', sq_len_2, v_quart_pad) || v_pad_char ||
372: LPAD('SV', sq_len_2, v_quart_pad) || v_pad_char ||
373: LPAD('SH', sq_len_2, v_quart_pad) );
374:
375: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
376: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
377: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
378: LPAD(v_underline_char, sq_len_4, v_underline_char) || v_pad_char ||
379: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||

Line 399: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;

395:
396: PROCEDURE create_quarterly_bh
397: IS
398: BEGIN
399: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
400: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
401: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
402: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
403: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||

Line 400: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

396: PROCEDURE create_quarterly_bh
397: IS
398: BEGIN
399: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
400: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
401: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
402: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
403: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||
404: LPAD('ChallCnt', sq_len_9, v_quart_pad) || v_pad_char ||

Line 466: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

462: LPAD('DDORgNo', sq_len_10, v_quart_pad) || v_pad_char ||
463: /*Bug 8880543 - Added for eTDS/eTCS FVU Changes - End*/
464: LPAD('RH', sq_len_2, v_quart_pad) );
465:
466: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
467: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
468: LPAD(v_underline_char, sq_len_2, v_underline_char) || v_pad_char ||
469: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||
470: LPAD(v_underline_char, sq_len_9, v_underline_char) || v_pad_char ||

Line 537: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;

533:
534: PROCEDURE create_quarterly_cd
535: IS
536: BEGIN
537: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
538: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
539: LPAD('Line No', sq_len_9 , v_quart_pad) || v_pad_char ||
540: LPAD('RT', sq_len_2 , v_quart_pad) || v_pad_char ||
541: LPAD('Batch No', sq_len_9 , v_quart_pad) || v_pad_char ||

Line 538: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

534: PROCEDURE create_quarterly_cd
535: IS
536: BEGIN
537: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
538: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
539: LPAD('Line No', sq_len_9 , v_quart_pad) || v_pad_char ||
540: LPAD('RT', sq_len_2 , v_quart_pad) || v_pad_char ||
541: LPAD('Batch No', sq_len_9 , v_quart_pad) || v_pad_char ||
542: LPAD('Chall No', sq_len_9 , v_quart_pad) || v_pad_char ||

Line 580: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

576: LPAD('Remarks', sq_len_14 , v_quart_pad) || v_pad_char ||
577: LPAD('RH', sq_len_2 , v_quart_pad)
578: );
579:
580: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
581: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
582: LPAD(v_underline_char , sq_len_2 , v_underline_char) || v_pad_char ||
583: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
584: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||

Line 626: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;

622: END create_quarterly_cd;
623:
624: PROCEDURE create_quarterly_dd IS
625: BEGIN
626: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
627: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
628: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
629: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
630: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||

Line 627: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

623:
624: PROCEDURE create_quarterly_dd IS
625: BEGIN
626: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, ' ' ) ;
627: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
628: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||
629: LPAD('RT', sq_len_2, v_quart_pad) || v_pad_char ||
630: LPAD('Batch No', sq_len_9, v_quart_pad) || v_pad_char ||
631: LPAD('ChallNo', sq_len_9, v_quart_pad) || v_pad_char ||

Line 663: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

659: LPAD('Remarks 3', sq_len_14, v_quart_pad) || v_pad_char ||
660: LPAD('RH', sq_len_2, v_quart_pad)
661: );
662:
663: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
664: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
665: LPAD(v_underline_char , sq_len_2 , v_underline_char) || v_pad_char ||
666: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||
667: LPAD(v_underline_char , sq_len_9 , v_underline_char) || v_pad_char ||

Line 901: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,

897: )
898: IS
899: BEGIN
900: IF p_generate_headers = 'N' THEN
901: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,
902: p_line_number || v_delimeter ||
903: upper(p_record_type) || v_delimeter ||
904: p_batch_number || v_delimeter ||
905: p_dh_challan_recNo || v_delimeter ||

Line 937: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

933: p_remarks3 || v_delimeter ||
934: p_dh_recHash
935: );
936: ELSE
937: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
938: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
939: LPAD(upper(p_record_type) , sq_len_2, v_quart_pad) || v_pad_char ||
940: LPAD(p_batch_number , sq_len_9, v_quart_pad) || v_pad_char ||
941: LPAD(p_dh_challan_recNo , sq_len_9, v_quart_pad) || v_pad_char ||

Line 1144: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1140: ) IS
1141: BEGIN
1142: IF p_generate_headers = 'N' THEN
1143:
1144: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1145: p_line_number || v_delimeter||
1146: upper(p_record_type) || v_delimeter||
1147: upper(p_file_type) || v_delimeter||
1148: upper(p_upload_type) || v_delimeter||

Line 1164: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

1160: p_fh_scmVersion || v_delimeter||
1161: p_fh_scmHash || v_delimeter||
1162: p_fh_consFileHash); /*FVU 3.4*/
1163: ELSE
1164: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1165: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
1166: LPAD( upper(p_record_type) , sq_len_2, v_quart_pad) || v_pad_char ||
1167: LPAD(upper(p_file_type) , sq_len_4, v_quart_pad) || v_pad_char ||
1168: LPAD(upper(p_upload_type) , sq_len_2, v_quart_pad) || v_pad_char ||

Line 1556: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle, p_line_number || v_delimeter||

1552: IS
1553: BEGIN
1554:
1555: IF p_generate_headers = 'N' THEN
1556: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle, p_line_number || v_delimeter||
1557: upper(p_record_type) || v_delimeter||
1558: p_batch_number || v_delimeter||
1559: p_challan_count || v_delimeter||
1560: upper(p_form_number) || v_delimeter||

Line 1621: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,

1617: p_ddo_registration_no || v_delimeter||
1618: /*Bug 8880543 - Added for eTDS/eTCS FVU Changes - End*/
1619: p_recHash ) ;
1620: ELSE
1621: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,
1622: LPAD(p_line_number, sq_len_9 , v_quart_pad) || v_pad_char ||
1623: LPAD(upper(p_record_type) , sq_len_2 , v_quart_pad) || v_pad_char ||
1624: LPAD(p_batch_number, sq_len_9 , v_quart_pad) || v_pad_char ||
1625: LPAD(p_challan_count, sq_len_9 , v_quart_pad) || v_pad_char ||

Line 1914: UTL_FILE.PUT_LINE(

1910: )
1911: IS
1912: BEGIN
1913: IF p_generate_headers = 'N' THEN
1914: UTL_FILE.PUT_LINE(
1915: jai_ap_tds_etds_pkg.v_filehandle,p_line_number || v_delimeter||
1916: upper(p_record_type) || v_delimeter||
1917: p_batch_number || v_delimeter||
1918: p_challan_dtl_slno || v_delimeter||

Line 1955: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,

1951: p_book_entry || v_delimeter||
1952: p_remarks || v_delimeter||
1953: p_ch_recHash ) ;
1954: ELSE
1955: UTL_FILE.PUT_LINE( jai_ap_tds_etds_pkg.v_filehandle,
1956: LPAD(p_line_number , sq_len_9, v_quart_pad) || v_pad_char ||
1957: LPAD(upper(p_record_type) , sq_len_2, v_quart_pad) || v_pad_char ||
1958: LPAD(p_batch_number , sq_len_9, v_quart_pad) || v_pad_char ||
1959: LPAD(p_challan_dtl_slno , sq_len_9, v_quart_pad) || v_pad_char ||

Line 2015: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

2011: ) IS
2012:
2013: BEGIN
2014:
2015: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2016: LPAD(p_line_number, s_line_number, v_pad_number)
2017: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
2018: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_file_type, s_file_type, v_pad_char)
2019: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_upload_type, s_upload_type, v_pad_char)

Line 2031: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );

2027: PROCEDURE create_dd IS
2028: BEGIN
2029:
2030: -- Deductee Detail
2031: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
2032: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2033: LPAD('LineNo', s_line_number, v_pad_char)
2034: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
2035: ||v_pad_char||LPAD('B.No.', s_batch_number, v_pad_char)

Line 2032: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

2028: BEGIN
2029:
2030: -- Deductee Detail
2031: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
2032: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2033: LPAD('LineNo', s_line_number, v_pad_char)
2034: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
2035: ||v_pad_char||LPAD('B.No.', s_batch_number, v_pad_char)
2036: ||v_pad_char||LPAD('DSlNo', s_deductee_slno, v_pad_char)

Line 2065: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

2061: ||v_pad_char||LPAD('Filler5', s_filler, v_pad_char)
2062: );
2063:
2064:
2065: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2066: LPAD(v_underline_char, s_line_number, v_underline_char)
2067: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
2068: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
2069: ||v_pad_char||LPAD(v_underline_char, s_deductee_slno, v_underline_char)

Line 2107: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');

2103:
2104: -- File Header
2105: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2106:
2107: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
2108: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
2109: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2110: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2111: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

Line 2108: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');

2104: -- File Header
2105: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2106:
2107: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
2108: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
2109: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2110: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2111: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2112: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

Line 2109: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

2105: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
2106:
2107: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
2108: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
2109: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2110: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2111: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2112: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2113: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

Line 2131: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

2127: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2128: );
2129:
2130:
2131: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2132: LPAD('LineNo', s_line_number, v_pad_char)
2133: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
2134: ||v_pad_char||RPAD('FT', s_file_type, v_pad_char)
2135: ||v_pad_char||RPAD('UT', s_upload_type, v_pad_char)

Line 2141: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

2137: ||v_pad_char||LPAD('FSeqNo', s_file_sequence_number, v_pad_char)
2138: ||v_pad_char||RPAD('Org Tan', s_deductor_tan, v_pad_char)
2139: ||v_pad_char||LPAD('NoOfBatches', s_number_of_batches, v_pad_char)
2140: );
2141: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2142: LPAD(v_underline_char, s_line_number, v_underline_char)
2143: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
2144: ||v_pad_char||RPAD(v_underline_char, s_file_type, v_underline_char)
2145: ||v_pad_char||RPAD(v_underline_char, s_upload_type, v_underline_char)

Line 2157: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );

2153: PROCEDURE create_cd IS
2154: BEGIN
2155:
2156: -- Challan Detail
2157: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
2158: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2159: LPAD('LineNo', s_line_number, v_pad_char)
2160: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
2161: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)

Line 2158: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

2154: BEGIN
2155:
2156: -- Challan Detail
2157: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
2158: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2159: LPAD('LineNo', s_line_number, v_pad_char)
2160: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
2161: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)
2162: ||v_pad_char||LPAD('CSlNo', s_challan_slno, v_pad_char)

Line 2177: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

2173: ||v_pad_char||RPAD('Chal.Num.', s_challan_no, v_pad_char)
2174: ||v_pad_char||RPAD('TBE ', s_tds_dep_book_ent , v_pad_char)
2175: ||v_pad_char||RPAD('C', s_filler4 , v_pad_char)
2176: );
2177: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2178: LPAD(v_underline_char, s_line_number, v_underline_char)
2179: ||v_pad_char||RPAD(v_underline_char, s_record_type, v_underline_char)
2180: ||v_pad_char||LPAD(v_underline_char, s_batch_number, v_underline_char)
2181: ||v_pad_char||LPAD(v_underline_char, s_challan_slno, v_underline_char)

Line 2232: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

2228: ) IS
2229:
2230: BEGIN
2231:
2232: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
2233: LPAD(p_line_number, s_line_number, v_pad_number)
2234: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)
2235: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_batch_number, s_batch_number, v_pad_number)
2236: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_slno,0), s_deductee_slno, v_pad_number)