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_AP_TDS_ETDS_PKG dependencies on FND_GLOBAL

Line 794: fnd_global.user_id,

790: 1,
791: 1,
792: a.check_id,
793: base_invoices.invoice_date,
794: fnd_global.user_id,
795: sysdate,
796: fnd_global.user_id,
797: sysdate
798: from JAI_AP_TDS_INV_PAYMENTS a, ap_invoices_all base_invoices, ap_invoices_all tds_invoices

Line 796: fnd_global.user_id,

792: a.check_id,
793: base_invoices.invoice_date,
794: fnd_global.user_id,
795: sysdate,
796: fnd_global.user_id,
797: sysdate
798: from JAI_AP_TDS_INV_PAYMENTS a, ap_invoices_all base_invoices, ap_invoices_all tds_invoices
799: where a.parent_invoice_id = base_invoices.invoice_id
800: and a.invoice_id = tds_invoices.invoice_id

Line 881: fnd_global.user_id,

877: NULL,
878: NULL,
879: max(aia.invoice_amount),
880: max(jte.tds_vendor_classification),
881: fnd_global.user_id,
882: sysdate,
883: fnd_global.user_id,
884: sysdate
885: FROM ap_invoices_all aia,

Line 883: fnd_global.user_id,

879: max(aia.invoice_amount),
880: max(jte.tds_vendor_classification),
881: fnd_global.user_id,
882: sysdate,
883: fnd_global.user_id,
884: sysdate
885: FROM ap_invoices_all aia,
886: ap_invoice_distributions_all aida,
887: jai_ap_tds_inv_taxes jatit,

Line 977: fnd_global.user_id,

973: NULL,
974: NULL,
975: base_invoices.invoice_amount,
976: jte.tds_vendor_classification,
977: fnd_global.user_id,
978: sysdate,
979: fnd_global.user_id,
980: sysdate
981: from jai_cmn_taxes_all a, ap_invoices_all base_invoices, po_vendor_sites_all povs, \* Added by Avanija for FVU3.6 *\

Line 979: fnd_global.user_id,

975: base_invoices.invoice_amount,
976: jte.tds_vendor_classification,
977: fnd_global.user_id,
978: sysdate,
979: fnd_global.user_id,
980: sysdate
981: from jai_cmn_taxes_all a, ap_invoices_all base_invoices, po_vendor_sites_all povs, \* Added by Avanija for FVU3.6 *\
982: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte
983: where jte.vendor_id = base_invoices.vendor_id

Line 1050: fnd_global.user_id,

1046: NULL,
1047: NULL,
1048: base_invoices.invoice_amount,
1049: jte.tds_vendor_classification,
1050: fnd_global.user_id,
1051: sysdate,
1052: fnd_global.user_id,
1053: sysdate
1054: from ap_invoices_all base_invoices,

Line 1052: fnd_global.user_id,

1048: base_invoices.invoice_amount,
1049: jte.tds_vendor_classification,
1050: fnd_global.user_id,
1051: sysdate,
1052: fnd_global.user_id,
1053: sysdate
1054: from ap_invoices_all base_invoices,
1055: ap_invoice_distributions_all aida, jai_ap_tds_vendor_hdrs jte, po_vendor_sites_all povs
1056: where jte.vendor_id = base_invoices.vendor_id

Line 1177: fnd_global.user_id,

1173: NULL,
1174: NULL,
1175: aia.invoice_amount,
1176: jte.tds_vendor_classification,
1177: fnd_global.user_id,
1178: sysdate,
1179: fnd_global.user_id,
1180: sysdate
1181: FROM ap_invoices_all aia,

Line 1179: fnd_global.user_id,

1175: aia.invoice_amount,
1176: jte.tds_vendor_classification,
1177: fnd_global.user_id,
1178: sysdate,
1179: fnd_global.user_id,
1180: sysdate
1181: FROM ap_invoices_all aia,
1182: ap_invoice_distributions_all aida,
1183: jai_ap_tds_inv_taxes jatit,

Line 1277: fnd_global.user_id,

1273: NULL,
1274: NULL,
1275: aia.invoice_amount,
1276: jte.tds_vendor_classification,
1277: fnd_global.user_id,
1278: sysdate,
1279: fnd_global.user_id,
1280: sysdate
1281: FROM ap_invoices_all aia,

Line 1279: fnd_global.user_id,

1275: aia.invoice_amount,
1276: jte.tds_vendor_classification,
1277: fnd_global.user_id,
1278: sysdate,
1279: fnd_global.user_id,
1280: sysdate
1281: FROM ap_invoices_all aia,
1282: ap_invoice_distributions_all aida,
1283: jai_ap_tds_inv_taxes jatit,

Line 2075: fnd_global.user_id,

2071: 0,
2072: 0,
2073: base_invoices.invoice_amount,
2074: -- Added for bug16889298 End
2075: fnd_global.user_id,
2076: sysdate,
2077: fnd_global.user_id,
2078: sysdate
2079: from jai_ap_tds_repository a

Line 2077: fnd_global.user_id,

2073: base_invoices.invoice_amount,
2074: -- Added for bug16889298 End
2075: fnd_global.user_id,
2076: sysdate,
2077: fnd_global.user_id,
2078: sysdate
2079: from jai_ap_tds_repository a
2080: ,ap_invoices_all base_invoices
2081: ,ap_invoices_all tds_invoices

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

2629:
2630: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2631: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2632: UTL_FILE.PUT_LINE(v_filehandle,
2633: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2634: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2636: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2637: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

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

2630: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2631: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2632: UTL_FILE.PUT_LINE(v_filehandle,
2633: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2634: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2636: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2637: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2638: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

Line 2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)

2631: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2632: UTL_FILE.PUT_LINE(v_filehandle,
2633: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2634: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2636: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2637: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2638: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

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

2632: UTL_FILE.PUT_LINE(v_filehandle,
2633: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2634: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2636: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2637: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2638: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

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

2633: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2634: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2636: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2637: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2638: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2641: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

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

2634: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2636: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2637: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2638: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2641: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2642: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

Line 2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

2635: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2636: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2637: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2638: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2641: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2642: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2643: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

Line 2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

2636: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2637: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2638: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2641: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2642: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2643: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2644: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

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

2637: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2638: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2641: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2642: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2643: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2644: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2645: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

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

2638: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2641: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2642: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2643: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2644: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2645: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2646: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

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

2639: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2641: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2642: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2643: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2644: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2645: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2646: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2647: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

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

2640: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2641: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2642: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2643: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2644: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2645: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2646: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2647: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2648: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

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

2641: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2642: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2643: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2644: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2645: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2646: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2647: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2648: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2649: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

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

2642: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2643: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2644: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2645: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2646: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2647: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2648: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2649: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2650: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

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

2643: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2644: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2645: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2646: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2647: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2648: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2649: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2650: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2651: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

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

2644: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2645: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2646: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2647: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2648: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2649: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2650: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2651: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2652: );

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

2645: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2646: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2647: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2648: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2649: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2650: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2651: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2652: );
2653:

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

2646: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2647: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2648: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2649: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2650: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2651: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2652: );
2653:
2654:

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

2647: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2648: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2649: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2650: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2651: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2652: );
2653:
2654:
2655: UTL_FILE.PUT_LINE(v_filehandle,

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

2695:
2696: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2697: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2698: UTL_FILE.PUT_LINE(v_filehandle,
2699: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2700: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2702: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2703: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)

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

2696: UTL_FILE.PUT_LINE(v_filehandle, 'Input Parameters to this Request:');
2697: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2698: UTL_FILE.PUT_LINE(v_filehandle,
2699: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2700: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2702: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2703: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2704: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

Line 2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)

2697: UTL_FILE.PUT_LINE(v_filehandle, '-------------------------------------------------');
2698: UTL_FILE.PUT_LINE(v_filehandle,
2699: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2700: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2702: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2703: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2704: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

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

2698: UTL_FILE.PUT_LINE(v_filehandle,
2699: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2700: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2702: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2703: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2704: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

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

2699: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
2700: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2702: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2703: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2704: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2707: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

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

2700: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2702: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2703: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2704: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2707: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2708: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

Line 2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

2701: ||' legal_entity_id ->'||v_req.legal_entity_id||fnd_global.local_chr(10)
2702: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2703: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2704: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2707: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2708: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2709: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

Line 2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

2702: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
2703: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2704: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2707: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2708: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2709: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2710: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

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

2703: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
2704: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2707: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2708: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2709: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2710: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2711: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

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

2704: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2707: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2708: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2709: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2710: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2711: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2712: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

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

2705: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2707: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2708: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2709: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2710: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2711: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2712: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2713: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

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

2706: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
2707: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2708: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2709: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2710: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2711: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2712: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2713: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2714: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

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

2707: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
2708: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2709: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2710: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2711: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2712: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2713: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2714: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2715: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

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

2708: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
2709: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2710: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2711: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2712: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2713: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2714: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2715: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2716: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

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

2709: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
2710: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2711: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2712: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2713: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2714: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2715: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2716: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2717: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

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

2710: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
2711: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2712: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2713: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2714: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2715: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2716: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2717: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2718: ||' Period ->'||p_period||fnd_global.local_chr(10)

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

2711: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
2712: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2713: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2714: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2715: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2716: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2717: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2718: ||' Period ->'||p_period||fnd_global.local_chr(10)
2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)

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

2712: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
2713: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2714: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2715: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2716: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2717: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2718: ||' Period ->'||p_period||fnd_global.local_chr(10)
2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)
2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)

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

2713: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
2714: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2715: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2716: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2717: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2718: ||' Period ->'||p_period||fnd_global.local_chr(10)
2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)
2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)
2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)

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

2714: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
2715: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2716: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2717: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2718: ||' Period ->'||p_period||fnd_global.local_chr(10)
2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)
2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)
2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)
2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)

Line 2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)

2715: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
2716: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2717: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2718: ||' Period ->'||p_period||fnd_global.local_chr(10)
2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)
2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)
2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)
2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)
2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)

Line 2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)

2716: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
2717: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2718: ||' Period ->'||p_period||fnd_global.local_chr(10)
2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)
2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)
2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)
2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)
2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)
2724: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)

Line 2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)

2717: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
2718: ||' Period ->'||p_period||fnd_global.local_chr(10)
2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)
2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)
2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)
2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)
2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)
2724: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
2725: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)

Line 2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)

2718: ||' Period ->'||p_period||fnd_global.local_chr(10)
2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)
2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)
2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)
2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)
2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)
2724: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
2725: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
2726: ||' RespPerson''s Telephone no ->'||p_RespPers_tel_no||fnd_global.local_chr(10)

Line 2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)

2719: ||' RespPerson''s Flat No ->'||p_RespPers_Flat_no||fnd_global.local_chr(10)
2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)
2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)
2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)
2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)
2724: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
2725: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
2726: ||' RespPerson''s Telephone no ->'||p_RespPers_tel_no||fnd_global.local_chr(10)
2727: ||' RespPerson''s Email ->'||p_RespPers_email||fnd_global.local_chr(10)

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

2720: ||' RespPerson''s Premises/Bldg ->'||p_RespPers_prem_bldg||fnd_global.local_chr(10)
2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)
2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)
2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)
2724: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
2725: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
2726: ||' RespPerson''s Telephone no ->'||p_RespPers_tel_no||fnd_global.local_chr(10)
2727: ||' RespPerson''s Email ->'||p_RespPers_email||fnd_global.local_chr(10)
2728: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)

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

2721: ||' RespPerson''s Rd/St/Lane ->'||p_RespPers_rd_st_lane||fnd_global.local_chr(10)
2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)
2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)
2724: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
2725: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
2726: ||' RespPerson''s Telephone no ->'||p_RespPers_tel_no||fnd_global.local_chr(10)
2727: ||' RespPerson''s Email ->'||p_RespPers_email||fnd_global.local_chr(10)
2728: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
2729: );

Line 2726: ||' RespPerson''s Telephone no ->'||p_RespPers_tel_no||fnd_global.local_chr(10)

2722: ||' RespPerson''s Area/Loc ->'||p_RespPers_area_loc||fnd_global.local_chr(10)
2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)
2724: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
2725: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
2726: ||' RespPerson''s Telephone no ->'||p_RespPers_tel_no||fnd_global.local_chr(10)
2727: ||' RespPerson''s Email ->'||p_RespPers_email||fnd_global.local_chr(10)
2728: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
2729: );
2730:

Line 2727: ||' RespPerson''s Email ->'||p_RespPers_email||fnd_global.local_chr(10)

2723: ||' RespPerson''s Tn/Cty/Dt ->'||p_RespPers_tn_cty_dt||fnd_global.local_chr(10)
2724: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
2725: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
2726: ||' RespPerson''s Telephone no ->'||p_RespPers_tel_no||fnd_global.local_chr(10)
2727: ||' RespPerson''s Email ->'||p_RespPers_email||fnd_global.local_chr(10)
2728: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
2729: );
2730:
2731:

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

2724: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
2725: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
2726: ||' RespPerson''s Telephone no ->'||p_RespPers_tel_no||fnd_global.local_chr(10)
2727: ||' RespPerson''s Email ->'||p_RespPers_email||fnd_global.local_chr(10)
2728: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
2729: );
2730:
2731:
2732: UTL_FILE.PUT_LINE(v_filehandle,

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

2772: PROCEDURE create_bh IS
2773: BEGIN
2774:
2775: -- Batch Header
2776: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
2777: UTL_FILE.PUT_LINE(v_filehandle,
2778: LPAD('LineNo', s_line_number, v_pad_char)
2779: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
2780: ||v_pad_char||LPAD('BNo', s_batch_number, v_pad_char)

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

3144: PROCEDURE create_cd IS
3145: BEGIN
3146:
3147: -- Challan Detail
3148: UTL_FILE.PUT_LINE(v_filehandle, fnd_global.local_chr(10) );
3149: UTL_FILE.PUT_LINE(v_filehandle,
3150: LPAD('LineNo', s_line_number, v_pad_char)
3151: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
3152: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)

Line 4735: l_prg_id:=FND_GLOBAL.CONC_PROGRAM_ID;

4731: l_RespPers_tn_cty_dt varchar2(25);
4732: /* Bug 13323753 -End */
4733: BEGIN
4734:
4735: l_prg_id:=FND_GLOBAL.CONC_PROGRAM_ID;
4736: ld_challan_start_date := fnd_date.canonical_to_date(p_challan_Start_Date); --added by csahoo for bug#6158875
4737: ld_challan_end_date := fnd_date.canonical_to_date(p_challan_End_Date); --added by csahoo for bug#6158875
4738:
4739: open c_prg_name(l_prg_id);

Line 6474: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate

6470: p_persRespForDeduction, p_desgOfPersResponsible,
6471: p_challan_Start_Date, p_challan_End_Date, p_file_path, p_filename,
6472: fnd_profile.value('PROG_APPL_ID'), fnd_profile.value('CONC_PROGRAM_ID'), fnd_profile.value('CONC_LOGIN_ID'),
6473: -- added, Harshita for Bug 4866533
6474: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
6475: );
6476:
6477: FOR k IN c_organization_id(p_tan_number, p_organization_id) LOOP
6478: