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 FND_GLOBAL

Line 25: Removed local_fnd_global

21: File name changed to jai_ar_etcs_prc.plb
22: Removed the Hard Coded values and replaced them with the
23: constants jai_constants.ar_cash_tax_confirmed and jai_constants.trx_type_inv_comp
24: 2. 14/05/2007 bduvarag for bug#5631784. File Version 120.1
25: Removed local_fnd_global
26:
27: 3. 26.06.2007 sacsethi for bug 6153881 file version 120.2
28:
29: Problem - R12RUP03-ST1:UNABLE TO RUN TCS RETURN REPORTS

Line 326: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)

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)
330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

Line 327: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

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)
330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
331: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

Line 328: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

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)
330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
331: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

Line 329: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

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)
330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
331: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

Line 330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

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)
330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
331: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

Line 331: ||' tax_authority_id ->'||v_req.tax_authority_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)
330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
331: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

Line 332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_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)
330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
331: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

Line 333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

329: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
331: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

Line 334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

330: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
331: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

Line 335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

331: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

Line 336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

332: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

Line 337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

333: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

Line 338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

334: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

Line 339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

335: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

Line 340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

336: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
344: ||' Period ->'||p_period||fnd_global.local_chr(10)

Line 341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

337: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
344: ||' Period ->'||p_period||fnd_global.local_chr(10)
345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/

Line 342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

338: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
344: ||' Period ->'||p_period||fnd_global.local_chr(10)
345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/
346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/

Line 343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

339: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
344: ||' Period ->'||p_period||fnd_global.local_chr(10)
345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/
346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/

Line 344: ||' Period ->'||p_period||fnd_global.local_chr(10)

340: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
344: ||' Period ->'||p_period||fnd_global.local_chr(10)
345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/
346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/

Line 345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/

341: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
344: ||' Period ->'||p_period||fnd_global.local_chr(10)
345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/
346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/

Line 346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/

342: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
344: ||' Period ->'||p_period||fnd_global.local_chr(10)
345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/
346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
350: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/

Line 347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/

343: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
344: ||' Period ->'||p_period||fnd_global.local_chr(10)
345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/
346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
350: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
351: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)

Line 348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/

344: ||' Period ->'||p_period||fnd_global.local_chr(10)
345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/
346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
350: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
351: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
352: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)

Line 349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/

345: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10) /* Bug 12597773*/
346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
350: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
351: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
352: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
353: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)

Line 350: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/

346: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
350: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
351: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
352: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
353: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
354: );

Line 351: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)

347: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
350: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
351: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
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:

Line 352: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)

348: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
350: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
351: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
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,

Line 353: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)

349: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
350: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
351: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
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 ||

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 2110: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)

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)
2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

Line 2111: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)

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)
2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2115: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

Line 2112: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)

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)
2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2115: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

Line 2113: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

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)
2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2115: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

Line 2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

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)
2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2115: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

Line 2115: ||' tax_authority_id ->'||v_req.tax_authority_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)
2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2115: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

Line 2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_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)
2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2115: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

Line 2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

2113: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2115: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

Line 2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

2114: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2115: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

Line 2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

2115: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

Line 2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

2116: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2124: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

Line 2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

2117: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2124: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2125: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

Line 2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

2118: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2124: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2125: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2126: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

Line 2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

2119: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2124: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2125: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2126: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2127: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

Line 2124: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

2120: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2124: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2125: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2126: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2127: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2128: );

Line 2125: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

2121: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2124: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2125: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2126: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2127: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2128: );
2129:

Line 2126: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

2122: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2124: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2125: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2126: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2127: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2128: );
2129:
2130:

Line 2127: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

2123: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2124: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2125: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2126: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
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,

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 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 2429: fnd_global.user_id ,

2425: p_collection_code ,
2426: jrt.tax_rate ,
2427: jrt.exempted_flag ,
2428: jrc.issue_date ,
2429: fnd_global.user_id ,
2430: sysdate ,
2431: fnd_global.user_id ,
2432: sysdate ,
2433: fnd_global.login_id

Line 2431: fnd_global.user_id ,

2427: jrt.exempted_flag ,
2428: jrc.issue_date ,
2429: fnd_global.user_id ,
2430: sysdate ,
2431: fnd_global.user_id ,
2432: sysdate ,
2433: fnd_global.login_id
2434: from
2435: jai_ap_rgm_payments jrp,

Line 2433: fnd_global.login_id

2429: fnd_global.user_id ,
2430: sysdate ,
2431: fnd_global.user_id ,
2432: sysdate ,
2433: fnd_global.login_id
2434: from
2435: jai_ap_rgm_payments jrp,
2436: jai_rgm_refs_all jra,
2437: jai_rgm_taxes jrt,

Line 3245: fnd_global.user_id , sysdate , fnd_global.user_id , sysdate ,fnd_global.login_id -- Date 28/06/2007 by sacsethi for bug 6157120

3241: p_seller_name, p_seller_state, p_addrChangedSinceLastRet,
3242: --p_collector_status, /*Bug 8880543 - Commented Deductor Status for eTDS/eTCS FVU Changes*/
3243: p_persRespForCollection, p_desgOfPersResponsible, p_Start_Date,
3244: p_End_Date, p_file_path, p_filename ,
3245: fnd_global.user_id , sysdate , fnd_global.user_id , sysdate ,fnd_global.login_id -- Date 28/06/2007 by sacsethi for bug 6157120
3246: );
3247:
3248: -- Fetching the Pan Number based on TAN
3249: OPEN c_pan_number(p_organization_id);

Line 4056: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)

4052: pv_end_date DATE DEFAULT fnd_date.canonical_to_date(p_end_date);
4053:
4054: BEGIN
4055:
4056: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4057: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4058: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)

Line 4057: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)

4053:
4054: BEGIN
4055:
4056: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4057: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4058: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)

Line 4058: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)

4054: BEGIN
4055:
4056: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4057: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4058: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)

Line 4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)

4055:
4056: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4057: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4058: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)

Line 4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)

4056: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4057: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4058: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)

Line 4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)

4057: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4058: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)

Line 4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)

4058: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)

Line 4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)

4059: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)

Line 4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)

4060: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)

Line 4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)

4061: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)

Line 4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)

4062: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4070: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)

Line 4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)

4063: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4070: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4071: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)

Line 4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)

4064: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4070: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4071: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4072: ||' filename ->'||p_filename||fnd_global.local_chr(10)

Line 4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)

4065: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4070: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4071: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4072: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4073: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)

Line 4070: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)

4066: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4070: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4071: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4072: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4073: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)
4074: ) ;

Line 4071: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)

4067: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4070: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4071: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4072: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4073: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)
4074: ) ;
4075:

Line 4072: ||' filename ->'||p_filename||fnd_global.local_chr(10)

4068: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4070: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4071: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4072: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4073: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)
4074: ) ;
4075:
4076:

Line 4073: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)

4069: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4070: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4071: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4072: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4073: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)
4074: ) ;
4075:
4076:
4077: generate_etcs_returns

Line 4142: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)

4138: pv_end_date DATE DEFAULT fnd_date.canonical_to_date(p_end_date);
4139:
4140: BEGIN
4141:
4142: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4143: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4144: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4146: ||' Period ->'||p_period||fnd_global.local_chr(10)

Line 4143: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)

4139:
4140: BEGIN
4141:
4142: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4143: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4144: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4146: ||' Period ->'||p_period||fnd_global.local_chr(10)
4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)

Line 4144: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)

4140: BEGIN
4141:
4142: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4143: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4144: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4146: ||' Period ->'||p_period||fnd_global.local_chr(10)
4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)

Line 4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)

4141:
4142: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4143: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4144: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4146: ||' Period ->'||p_period||fnd_global.local_chr(10)
4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)

Line 4146: ||' Period ->'||p_period||fnd_global.local_chr(10)

4142: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
4143: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4144: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4146: ||' Period ->'||p_period||fnd_global.local_chr(10)
4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)

Line 4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)

4143: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
4144: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4146: ||' Period ->'||p_period||fnd_global.local_chr(10)
4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)

Line 4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)

4144: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4146: ||' Period ->'||p_period||fnd_global.local_chr(10)
4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)

Line 4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)

4145: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
4146: ||' Period ->'||p_period||fnd_global.local_chr(10)
4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/

Line 4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)

4146: ||' Period ->'||p_period||fnd_global.local_chr(10)
4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/
4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)

Line 4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)

4147: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/
4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)

Line 4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)

4148: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/
4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)

Line 4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /Bug 8880543 - Commented for eTDS/eTCS FVU Changes/

4149: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/
4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/

Line 4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)

4150: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/
4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/

Line 4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)

4151: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/
4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/

Line 4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)

4152: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/
4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/

Line 4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/

4153: --||' collector_status ->'||p_collector_status||fnd_global.local_chr(10) /*Bug 8880543 - Commented for eTDS/eTCS FVU Changes*/
4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/

Line 4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/

4154: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)

Line 4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/

4155: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)

Line 4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/

4156: --||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)

Line 4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/

4157: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10) /* Bug 12597773*/
4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)

Line 4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)

4158: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10) /* Bug 12597773*/
4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)

Line 4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)

4159: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10) /* Bug 12597773*/
4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4167: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)

Line 4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)

4160: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10) /* Bug 12597773*/
4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4167: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4168: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)

Line 4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)

4161: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10) /* Bug 12597773*/
4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4167: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4168: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4169: ||' filename ->'||p_filename||fnd_global.local_chr(10)

Line 4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)

4162: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4167: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4168: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4169: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4170: ||' Action ->'||p_action||fnd_global.local_chr(10)

Line 4167: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)

4163: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4167: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4168: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4169: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4170: ||' Action ->'||p_action||fnd_global.local_chr(10)
4171: ) ;

Line 4168: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)

4164: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4167: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4168: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4169: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4170: ||' Action ->'||p_action||fnd_global.local_chr(10)
4171: ) ;
4172:

Line 4169: ||' filename ->'||p_filename||fnd_global.local_chr(10)

4165: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4167: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4168: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4169: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4170: ||' Action ->'||p_action||fnd_global.local_chr(10)
4171: ) ;
4172:
4173:

Line 4170: ||' Action ->'||p_action||fnd_global.local_chr(10)

4166: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
4167: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
4168: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
4169: ||' filename ->'||p_filename||fnd_global.local_chr(10)
4170: ||' Action ->'||p_action||fnd_global.local_chr(10)
4171: ) ;
4172:
4173:
4174: generate_etcs_returns