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 JAI_AP_TDS_ETDS_PKG

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 1855: jai_ap_tds_etds_pkg.check_numeric(p_challan_no, 'Check Number : ' || p_check_number || ' Challan Number is not a Numeric Value', lv_action);

1851: goto end_of_procedure ;
1852: END IF ;
1853: END IF ;
1854:
1855: jai_ap_tds_etds_pkg.check_numeric(p_challan_no, 'Check Number : ' || p_check_number || ' Challan Number is not a Numeric Value', lv_action);
1856: jai_ap_tds_etds_pkg.check_numeric(p_bank_branch_code, 'Check Number : ' || p_check_number || ' Bank Branch Code is not a Numeric Value ', lv_action);
1857:
1858: IF lv_action = 'V' THEN
1859: goto end_of_procedure ;

Line 1856: jai_ap_tds_etds_pkg.check_numeric(p_bank_branch_code, 'Check Number : ' || p_check_number || ' Bank Branch Code is not a Numeric Value ', lv_action);

1852: END IF ;
1853: END IF ;
1854:
1855: jai_ap_tds_etds_pkg.check_numeric(p_challan_no, 'Check Number : ' || p_check_number || ' Challan Number is not a Numeric Value', lv_action);
1856: jai_ap_tds_etds_pkg.check_numeric(p_bank_branch_code, 'Check Number : ' || p_check_number || ' Bank Branch Code is not a Numeric Value ', lv_action);
1857:
1858: IF lv_action = 'V' THEN
1859: goto end_of_procedure ;
1860: END IF ;

Line 1915: jai_ap_tds_etds_pkg.v_filehandle,p_line_number || v_delimeter||

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||
1919: p_collection_cnt || 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 2017: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)

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)
2020: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(to_char(p_file_creation_date,'ddmmyyyy'), s_date, v_pad_date)
2021: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_file_sequence_number, s_file_sequence_number, v_pad_number)

Line 2018: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_file_type, s_file_type, v_pad_char)

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)
2020: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(to_char(p_file_creation_date,'ddmmyyyy'), s_date, v_pad_date)
2021: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_file_sequence_number, s_file_sequence_number, v_pad_number)
2022: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductor_tan,' '), s_deductor_tan, v_pad_char)

Line 2019: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_upload_type, s_upload_type, v_pad_char)

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)
2020: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(to_char(p_file_creation_date,'ddmmyyyy'), s_date, v_pad_date)
2021: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_file_sequence_number, s_file_sequence_number, v_pad_number)
2022: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductor_tan,' '), s_deductor_tan, v_pad_char)
2023: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_number_of_batches,0), s_number_of_batches, v_pad_number)||fnd_global.local_chr(13)

Line 2020: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(to_char(p_file_creation_date,'ddmmyyyy'), s_date, v_pad_date)

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)
2020: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(to_char(p_file_creation_date,'ddmmyyyy'), s_date, v_pad_date)
2021: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_file_sequence_number, s_file_sequence_number, v_pad_number)
2022: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductor_tan,' '), s_deductor_tan, v_pad_char)
2023: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_number_of_batches,0), s_number_of_batches, v_pad_number)||fnd_global.local_chr(13)
2024: );

Line 2021: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_file_sequence_number, s_file_sequence_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)
2020: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(to_char(p_file_creation_date,'ddmmyyyy'), s_date, v_pad_date)
2021: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_file_sequence_number, s_file_sequence_number, v_pad_number)
2022: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductor_tan,' '), s_deductor_tan, v_pad_char)
2023: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_number_of_batches,0), s_number_of_batches, v_pad_number)||fnd_global.local_chr(13)
2024: );
2025: END create_file_header ;

Line 2022: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductor_tan,' '), s_deductor_tan, 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)
2020: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(to_char(p_file_creation_date,'ddmmyyyy'), s_date, v_pad_date)
2021: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_file_sequence_number, s_file_sequence_number, v_pad_number)
2022: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductor_tan,' '), s_deductor_tan, v_pad_char)
2023: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_number_of_batches,0), s_number_of_batches, v_pad_number)||fnd_global.local_chr(13)
2024: );
2025: END create_file_header ;
2026:

Line 2023: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_number_of_batches,0), s_number_of_batches, v_pad_number)||fnd_global.local_chr(13)

2019: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_upload_type, s_upload_type, v_pad_char)
2020: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(to_char(p_file_creation_date,'ddmmyyyy'), s_date, v_pad_date)
2021: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_file_sequence_number, s_file_sequence_number, v_pad_number)
2022: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductor_tan,' '), s_deductor_tan, v_pad_char)
2023: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_number_of_batches,0), s_number_of_batches, v_pad_number)||fnd_global.local_chr(13)
2024: );
2025: END create_file_header ;
2026:
2027: PROCEDURE create_dd IS

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)

Line 2234: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_record_type, s_record_type, v_pad_char)

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)
2237: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_deductee_section, s_deductee_section, v_pad_char)
2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)

Line 2235: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_batch_number, s_batch_number, v_pad_number)

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)
2237: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_deductee_section, s_deductee_section, v_pad_char)
2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)
2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, v_pad_char)

Line 2236: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_slno,0), s_deductee_slno, v_pad_number)

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)
2237: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_deductee_section, s_deductee_section, v_pad_char)
2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)
2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, v_pad_char)
2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)

Line 2237: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_deductee_section, s_deductee_section, v_pad_char)

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)
2237: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_deductee_section, s_deductee_section, v_pad_char)
2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)
2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, v_pad_char)
2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)
2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)

Line 2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)

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)
2237: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_deductee_section, s_deductee_section, v_pad_char)
2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)
2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, v_pad_char)
2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)
2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)
2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)

Line 2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, 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)
2237: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_deductee_section, s_deductee_section, v_pad_char)
2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)
2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, v_pad_char)
2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)
2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)
2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)
2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)

Line 2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)

2236: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_slno,0), s_deductee_slno, v_pad_number)
2237: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_deductee_section, s_deductee_section, v_pad_char)
2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)
2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, v_pad_char)
2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)
2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)
2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)
2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)
2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)

Line 2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)

2237: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_deductee_section, s_deductee_section, v_pad_char)
2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)
2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, v_pad_char)
2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)
2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)
2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)
2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)
2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)
2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)

Line 2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)

2238: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_code,' '), s_deductee_code, v_pad_char)
2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, v_pad_char)
2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)
2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)
2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)
2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)
2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)
2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)
2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)

Line 2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)

2239: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_pan,' '), s_deductee_pan, v_pad_char)
2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)
2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)
2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)
2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)
2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)
2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)
2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)
2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)

Line 2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)

2240: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_name,' '), s_deductee_name, v_pad_char)
2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)
2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)
2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)
2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)
2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)
2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)
2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)
2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)

Line 2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)

2241: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address1,' '), s_deductee_address1, v_pad_char)
2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)
2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)
2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)
2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)
2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)
2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)
2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)
2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)

Line 2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)

2242: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address2,' '), s_deductee_address2, v_pad_char)
2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)
2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)
2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)
2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)
2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)
2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)
2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)
2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)

Line 2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)

2243: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address3,' '), s_deductee_address3, v_pad_char)
2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)
2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)
2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)
2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)
2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)
2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)
2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)

Line 2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)

2244: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address4,' '), s_deductee_address4, v_pad_char)
2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)
2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)
2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)
2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)
2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)
2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)
2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)

Line 2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)

2245: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductee_address5,' '), s_deductee_address5, v_pad_char)
2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)
2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)
2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)
2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)
2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)
2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)
2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)

Line 2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)

2246: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_state,'0'), s_deductee_state, v_pad_number)
2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)
2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)
2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)
2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)
2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)
2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)
2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)

Line 2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)

2247: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(p_deductee_pin,0), s_deductee_pin, v_pad_number)
2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)
2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)
2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)
2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)
2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)
2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)
2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)

Line 2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)

2248: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_purchase_amount), s_payment_amount, v_pad_number)
2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)
2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)
2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)
2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)
2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)
2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)

Line 2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)

2249: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_payment_amount), s_payment_amount, v_pad_number)
2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)
2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)
2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)
2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)
2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)
2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)

Line 2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)

2250: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)
2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)
2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)
2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)
2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)
2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2258: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)

Line 2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)

2251: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_book_ent_oth , s_book_ent_oth, v_pad_char)
2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)
2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)
2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)
2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)
2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2258: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)
2259: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tds_certificate_date, 'ddmmyyyy'),' '), s_date, v_pad_date)

Line 2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)

2252: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_rate), s_tax_rate, v_pad_number)
2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)
2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)
2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)
2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2258: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)
2259: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tds_certificate_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2260: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_reason_for_nDeduction,' '), s_reason_for_nDeduction, v_pad_char)

Line 2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)

2253: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_filler6,' '), s_filler6, v_pad_char)
2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)
2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)
2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2258: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)
2259: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tds_certificate_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2260: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_reason_for_nDeduction,' '), s_reason_for_nDeduction, v_pad_char)
2261: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_filler7), s_filler, v_pad_number) || fnd_global.local_chr(13)

Line 2258: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)

2254: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_tax_deducted), s_tax_deducted, v_pad_number)
2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)
2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2258: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)
2259: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tds_certificate_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2260: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_reason_for_nDeduction,' '), s_reason_for_nDeduction, v_pad_char)
2261: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_filler7), s_filler, v_pad_number) || fnd_global.local_chr(13)
2262: );

Line 2259: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tds_certificate_date, 'ddmmyyyy'),' '), s_date, v_pad_date)

2255: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_deducted_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)
2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2258: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)
2259: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tds_certificate_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2260: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_reason_for_nDeduction,' '), s_reason_for_nDeduction, v_pad_char)
2261: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_filler7), s_filler, v_pad_number) || fnd_global.local_chr(13)
2262: );
2263:

Line 2260: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_reason_for_nDeduction,' '), s_reason_for_nDeduction, v_pad_char)

2256: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_bank_branch_code,' '), s_bank_branch_code, v_pad_char)
2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2258: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)
2259: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tds_certificate_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2260: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_reason_for_nDeduction,' '), s_reason_for_nDeduction, v_pad_char)
2261: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_filler7), s_filler, v_pad_number) || fnd_global.local_chr(13)
2262: );
2263:
2264: END create_deductee_detail;

Line 2261: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_filler7), s_filler, v_pad_number) || fnd_global.local_chr(13)

2257: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2258: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)
2259: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tds_certificate_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
2260: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_reason_for_nDeduction,' '), s_reason_for_nDeduction, v_pad_char)
2261: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(jai_ap_tds_etds_pkg.formatAmount(p_filler7), s_filler, v_pad_number) || fnd_global.local_chr(13)
2262: );
2263:
2264: END create_deductee_detail;
2265:

Line 3213: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';

3209: END IF ;
3210:
3211: IF NVL(p_action,'X') <> 'V' THEN
3212: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
3213: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
3214: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
3215: ELSE
3216: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
3217: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;

Line 3214: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;

3210:
3211: IF NVL(p_action,'X') <> 'V' THEN
3212: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
3213: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
3214: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
3215: ELSE
3216: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
3217: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;
3218: END IF;

Line 3216: jai_ap_tds_etds_pkg.v_debug_pad_char := '';

3212: IF NVL(p_generate_headers,'X') = 'Y' or NVL(p_action,'X') = 'H' THEN
3213: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
3214: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
3215: ELSE
3216: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
3217: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;
3218: END IF;
3219: END IF ;
3220:

Line 3217: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;

3213: jai_ap_tds_etds_pkg.v_debug_pad_char := ' ';
3214: jai_ap_tds_etds_pkg.v_generate_headers := TRUE;
3215: ELSE
3216: jai_ap_tds_etds_pkg.v_debug_pad_char := '';
3217: jai_ap_tds_etds_pkg.v_generate_headers := FALSE;
3218: END IF;
3219: END IF ;
3220:
3221: IF length(p_tan_number) > 10 THEN

Line 3516: jai_ap_tds_etds_pkg.create_bh;

3512:
3513: IF lv_etcs_yearly_returns = 'Y' THEN
3514:
3515: IF p_generate_headers = 'Y' THEN
3516: jai_ap_tds_etds_pkg.create_bh;
3517: END IF;
3518:
3519: jai_ap_tds_etds_pkg.create_batch_header(
3520: p_line_number => v_line_number,

Line 3519: jai_ap_tds_etds_pkg.create_batch_header(

3515: IF p_generate_headers = 'Y' THEN
3516: jai_ap_tds_etds_pkg.create_bh;
3517: END IF;
3518:
3519: jai_ap_tds_etds_pkg.create_batch_header(
3520: p_line_number => v_line_number,
3521: p_record_type => v_record_type,
3522: p_batch_number => v_batch_number,
3523: p_challan_count => v_challan_cnt,

Line 3736: jai_ap_tds_etds_pkg.create_challan_detail

3732: END IF ;
3733:
3734: IF lv_etcs_yearly_returns = 'Y' THEN
3735:
3736: jai_ap_tds_etds_pkg.create_challan_detail
3737: (
3738: p_line_number => v_line_number,
3739: p_record_type => v_record_type,
3740: p_batch_number => v_batch_number,

Line 3774: jai_ap_tds_etds_pkg.check_numeric(v_bank_branch_code, 'Check Number : ' || cd.check_number || ' Bank Branch Code is not a Numeric Value ', p_action);

3770:
3771: v_total_deposit := cd.tcs_amt + cd.surcharge_amt + cd.cess_amt;
3772: v_nil_challan_indicator := 'N' ;
3773:
3774: jai_ap_tds_etds_pkg.check_numeric(v_bank_branch_code, 'Check Number : ' || cd.check_number || ' Bank Branch Code is not a Numeric Value ', p_action);
3775:
3776: FND_FILE.put_line(FND_FILE.log, 'create challan quarterly' );
3777:
3778: IF p_action = 'H' THEN