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

98: SELECT * INTO v_req FROM JAI_AP_ETDS_REQUESTS WHERE batch_id = p_batch_id;
99: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
100: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
101: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
102: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
103: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
104: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
105: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
106: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

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

99: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
100: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
101: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
102: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
103: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
104: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
105: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
106: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
107: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

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

100: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
101: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
102: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
103: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
104: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
105: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
106: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
107: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
108: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

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

101: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
102: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
103: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
104: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
105: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
106: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
107: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
108: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
109: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

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

102: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
103: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
104: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
105: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
106: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
107: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
108: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
109: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
110: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

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

103: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
104: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
105: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
106: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
107: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
108: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
109: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
110: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
111: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

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

104: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
105: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
106: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
107: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
108: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
109: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
110: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
111: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
112: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

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

105: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
106: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
107: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
108: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
109: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
110: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
111: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
112: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
113: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

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

106: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
107: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
108: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
109: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
110: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
111: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
112: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
113: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
114: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

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

107: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
108: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
109: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
110: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
111: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
112: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
113: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
114: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
115: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

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

108: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
109: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
110: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
111: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
112: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
113: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
114: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
115: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
116: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

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

109: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
110: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
111: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
112: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
113: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
114: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
115: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
116: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
117: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

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

110: ||' collector_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
111: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
112: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
113: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
114: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
115: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
116: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
117: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
118: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

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

111: ||' collector_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
112: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
113: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
114: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
115: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
116: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
117: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
118: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
119: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

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

112: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
113: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
114: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
115: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
116: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
117: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
118: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
119: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
120: ||' Period ->'||p_period||fnd_global.local_chr(10)

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

113: ||' collector_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
114: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
115: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
116: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
117: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
118: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
119: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
120: ||' Period ->'||p_period||fnd_global.local_chr(10)
121: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)

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

114: ||' person_resp_for_collection ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
115: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
116: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
117: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
118: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
119: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
120: ||' Period ->'||p_period||fnd_global.local_chr(10)
121: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
122: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)

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

115: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
116: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
117: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
118: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
119: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
120: ||' Period ->'||p_period||fnd_global.local_chr(10)
121: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
122: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
123: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)

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

116: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
117: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
118: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
119: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
120: ||' Period ->'||p_period||fnd_global.local_chr(10)
121: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
122: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
123: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
124: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)

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

117: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
118: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
119: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
120: ||' Period ->'||p_period||fnd_global.local_chr(10)
121: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
122: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
123: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
124: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
125: );

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

118: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
119: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
120: ||' Period ->'||p_period||fnd_global.local_chr(10)
121: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
122: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
123: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
124: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
125: );
126:

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

119: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
120: ||' Period ->'||p_period||fnd_global.local_chr(10)
121: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
122: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
123: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
124: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
125: );
126:
127: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

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

120: ||' Period ->'||p_period||fnd_global.local_chr(10)
121: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
122: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
123: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
124: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
125: );
126:
127: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
128: LPAD('Line No', sq_len_9, v_quart_pad) || v_pad_char ||

Line 1592: ||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)

1588: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(p_upload_type, s_upload_type, v_pad_char)
1589: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(to_char(p_file_creation_date,'ddmmyyyy'), s_date, v_pad_date)
1590: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(p_file_sequence_number, s_file_sequence_number, v_pad_number)
1591: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_deductor_tan,' '), s_deductor_tan, v_pad_char)
1592: ||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)
1593: );
1594: END create_file_header ;
1595:
1596: PROCEDURE create_dd IS

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

1596: PROCEDURE create_dd IS
1597: BEGIN
1598:
1599: -- Deductee Detail
1600: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
1601: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1602: LPAD('LineNo', s_line_number, v_pad_char)
1603: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1604: ||v_pad_char||LPAD('B.No.', s_batch_number, v_pad_char)

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

1675:
1676: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
1677: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
1678: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1679: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1680: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1681: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1682: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1683: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)

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

1676: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, 'Input Parameters to this Request:');
1677: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
1678: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1679: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1680: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1681: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1682: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1683: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1684: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)

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

1677: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, '-------------------------------------------------');
1678: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1679: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1680: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1681: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1682: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1683: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1684: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1685: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)

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

1678: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1679: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1680: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1681: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1682: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1683: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1684: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1685: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1686: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)

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

1679: ' batch_id ->'||v_req.batch_id||fnd_global.local_chr(10)
1680: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1681: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1682: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1683: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1684: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1685: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1686: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1687: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)

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

1680: ||' request_id ->'||v_req.request_id||fnd_global.local_chr(10)
1681: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1682: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1683: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1684: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1685: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1686: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1687: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1688: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)

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

1681: ||' operating_unit_id ->'||v_req.operating_unit_id||fnd_global.local_chr(10)
1682: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1683: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1684: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1685: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1686: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1687: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1688: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1689: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)

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

1682: ||' org_tan_number ->'||v_req.org_tan_number||fnd_global.local_chr(10)
1683: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1684: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1685: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1686: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1687: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1688: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1689: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1690: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)

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

1683: ||' financial_year ->'||v_req.financial_year||fnd_global.local_chr(10)
1684: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1685: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1686: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1687: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1688: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1689: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1690: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1691: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)

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

1684: ||' tax_authority_id ->'||v_req.tax_authority_id||fnd_global.local_chr(10)
1685: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1686: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1687: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1688: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1689: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1690: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1691: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1692: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)

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

1685: ||' tax_authority_site_id ->'||v_req.tax_authority_site_id||fnd_global.local_chr(10)
1686: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1687: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1688: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1689: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1690: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1691: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1692: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1693: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)

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

1686: ||' organization_id ->'||v_req.organization_id||fnd_global.local_chr(10)
1687: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1688: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1689: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1690: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1691: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1692: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1693: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1694: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)

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

1687: ||' deductor_name ->'||v_req.deductor_name||fnd_global.local_chr(10)
1688: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1689: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1690: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1691: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1692: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1693: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1694: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1695: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)

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

1688: ||' deductor_state ->'||v_req.deductor_state||fnd_global.local_chr(10)
1689: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1690: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1691: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1692: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1693: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1694: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1695: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1696: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)

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

1689: ||' addr_changed_since_last_ret->'||v_req.addr_changed_since_last_ret||fnd_global.local_chr(10)
1690: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1691: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1692: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1693: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1694: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1695: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1696: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1697: );

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

1690: ||' deductor_status ->'||v_req.deductor_status||fnd_global.local_chr(10)
1691: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1692: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1693: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1694: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1695: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1696: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1697: );
1698:

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

1691: ||' person_resp_for_deduction ->'||v_req.person_resp_for_deduction||fnd_global.local_chr(10)
1692: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1693: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1694: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1695: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1696: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1697: );
1698:
1699:

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

1692: ||' designation_of_pers_resp ->'||v_req.designation_of_pers_resp||fnd_global.local_chr(10)
1693: ||' challan_start_date ->'||v_req.challan_start_date||fnd_global.local_chr(10)
1694: ||' challan_end_date ->'||v_req.challan_end_date||fnd_global.local_chr(10)
1695: ||' file_path ->'||v_req.file_path||fnd_global.local_chr(10)
1696: ||' filename ->'||v_req.filename||fnd_global.local_chr(10)
1697: );
1698:
1699:
1700: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,

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

1722: PROCEDURE create_cd IS
1723: BEGIN
1724:
1725: -- Challan Detail
1726: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle, fnd_global.local_chr(10) );
1727: UTL_FILE.PUT_LINE(jai_ap_tds_etds_pkg.v_filehandle,
1728: LPAD('LineNo', s_line_number, v_pad_char)
1729: ||v_pad_char||RPAD('RT', s_record_type, v_pad_char)
1730: ||v_pad_char||LPAD('B.No', s_batch_number, v_pad_char)

Line 1830: ||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)

1826: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tax_payment_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
1827: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_challan_no,' '), s_challan_no, v_pad_char)
1828: ||jai_ap_tds_etds_pkg.v_debug_pad_char||LPAD(nvl(to_char(p_tds_certificate_date, 'ddmmyyyy'),' '), s_date, v_pad_date)
1829: ||jai_ap_tds_etds_pkg.v_debug_pad_char||RPAD(nvl(p_reason_for_nDeduction,' '), s_reason_for_nDeduction, v_pad_char)
1830: ||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)
1831: );
1832:
1833: END create_deductee_detail;
1834:

Line 1998: fnd_global.user_id ,

1994: p_collection_code ,
1995: jrt.tax_rate ,
1996: jrt.exempted_flag ,
1997: jrc.issue_date ,
1998: fnd_global.user_id ,
1999: sysdate ,
2000: fnd_global.user_id ,
2001: sysdate ,
2002: fnd_global.login_id

Line 2000: fnd_global.user_id ,

1996: jrt.exempted_flag ,
1997: jrc.issue_date ,
1998: fnd_global.user_id ,
1999: sysdate ,
2000: fnd_global.user_id ,
2001: sysdate ,
2002: fnd_global.login_id
2003: from
2004: jai_ap_rgm_payments jrp,

Line 2002: fnd_global.login_id

1998: fnd_global.user_id ,
1999: sysdate ,
2000: fnd_global.user_id ,
2001: sysdate ,
2002: fnd_global.login_id
2003: from
2004: jai_ap_rgm_payments jrp,
2005: jai_rgm_refs_all jra,
2006: jai_rgm_taxes jrt,

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

2733: p_tax_authority_id, p_tax_authority_site_id, p_organization_id,
2734: p_seller_name, p_seller_state, p_addrChangedSinceLastRet, p_collector_status,
2735: p_persRespForCollection, p_desgOfPersResponsible, p_Start_Date,
2736: p_End_Date, p_file_path, p_filename ,
2737: fnd_global.user_id , sysdate , fnd_global.user_id , sysdate ,fnd_global.login_id -- Date 28/06/2007 by sacsethi for bug 6157120
2738: );
2739:
2740: -- Fetching the Pan Number based on TAN
2741: OPEN c_pan_number(p_organization_id);

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

3393: pv_end_date DATE DEFAULT fnd_date.canonical_to_date(p_end_date);
3394:
3395: BEGIN
3396:
3397: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3398: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3399: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3400: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)

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

3394:
3395: BEGIN
3396:
3397: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3398: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3399: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3400: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3402: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)

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

3395: BEGIN
3396:
3397: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3398: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3399: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3400: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3402: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3403: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)

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

3396:
3397: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3398: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3399: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3400: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3402: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3403: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3404: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)

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

3397: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3398: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3399: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3400: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3402: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3403: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3404: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3405: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)

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

3398: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3399: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3400: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3402: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3403: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3404: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3405: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3406: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)

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

3399: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3400: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3402: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3403: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3404: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3405: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3406: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3407: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)

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

3400: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3402: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3403: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3404: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3405: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3406: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3407: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3408: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)

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

3401: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3402: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3403: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3404: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3405: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3406: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3407: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3408: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3409: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)

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

3402: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3403: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3404: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3405: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3406: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3407: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3408: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3409: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3410: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)

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

3403: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3404: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3405: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3406: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3407: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3408: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3409: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3410: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3411: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)

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

3404: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3405: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3406: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3407: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3408: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3409: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3410: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3411: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3412: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)

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

3405: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3406: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3407: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3408: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3409: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3410: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3411: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3412: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3413: ||' filename ->'||p_filename||fnd_global.local_chr(10)

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

3406: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3407: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3408: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3409: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3410: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3411: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3412: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3413: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3414: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)

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

3407: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3408: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3409: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3410: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3411: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3412: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3413: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3414: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)
3415: ) ;

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

3408: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3409: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3410: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3411: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3412: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3413: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3414: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)
3415: ) ;
3416:

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

3409: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3410: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3411: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3412: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3413: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3414: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)
3415: ) ;
3416:
3417:

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

3410: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3411: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3412: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3413: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3414: ||' Generate_headers ->'||p_generate_headers||fnd_global.local_chr(10)
3415: ) ;
3416:
3417:
3418: generate_etcs_returns

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

3472: pv_end_date DATE DEFAULT fnd_date.canonical_to_date(p_end_date);
3473:
3474: BEGIN
3475:
3476: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3477: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3478: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3479: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3480: ||' Period ->'||p_period||fnd_global.local_chr(10)

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

3473:
3474: BEGIN
3475:
3476: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3477: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3478: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3479: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3480: ||' Period ->'||p_period||fnd_global.local_chr(10)
3481: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)

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

3474: BEGIN
3475:
3476: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3477: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3478: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3479: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3480: ||' Period ->'||p_period||fnd_global.local_chr(10)
3481: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3482: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)

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

3475:
3476: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3477: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3478: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3479: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3480: ||' Period ->'||p_period||fnd_global.local_chr(10)
3481: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3482: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3483: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)

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

3476: FND_FILE.put_line( FND_FILE.log, 'Parameters : ' || fnd_global.local_chr(10)
3477: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3478: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3479: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3480: ||' Period ->'||p_period||fnd_global.local_chr(10)
3481: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3482: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3483: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3484: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)

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

3477: ||' org_tan_number ->'||p_tan_number||fnd_global.local_chr(10)
3478: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3479: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3480: ||' Period ->'||p_period||fnd_global.local_chr(10)
3481: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3482: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3483: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3484: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3485: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)

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

3478: ||' Organization_id ->'||p_organization_id || fnd_global.local_chr(10)
3479: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3480: ||' Period ->'||p_period||fnd_global.local_chr(10)
3481: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3482: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3483: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3484: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3485: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3486: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)

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

3479: ||' financial_year ->'||p_fin_year||fnd_global.local_chr(10)
3480: ||' Period ->'||p_period||fnd_global.local_chr(10)
3481: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3482: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3483: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3484: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3485: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3486: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)

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

3480: ||' Period ->'||p_period||fnd_global.local_chr(10)
3481: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3482: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3483: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3484: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3485: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3486: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)
3488: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)

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

3481: ||' Collection Code ->'||p_collection_code||fnd_global.local_chr(10)
3482: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3483: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3484: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3485: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3486: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)
3488: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3489: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)

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

3482: ||' tax_authority_id ->'||p_tax_authority_id||fnd_global.local_chr(10)
3483: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3484: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3485: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3486: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)
3488: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3489: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3490: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)

Line 3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)

3483: ||' tax_authority_site_id ->'||p_tax_authority_site_id||fnd_global.local_chr(10)
3484: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3485: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3486: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)
3488: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3489: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3490: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
3491: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)

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

3484: ||' seller ->'||p_seller_name||fnd_global.local_chr(10)
3485: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3486: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)
3488: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3489: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3490: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
3491: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
3492: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)

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

3485: ||' seller state ->'||p_seller_state||fnd_global.local_chr(10)
3486: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)
3488: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3489: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3490: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
3491: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
3492: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
3493: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)

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

3486: ||' addr_changed_since_last_ret->'||p_addrChangedSinceLastRet||fnd_global.local_chr(10)
3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)
3488: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3489: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3490: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
3491: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
3492: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
3493: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
3494: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)

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

3487: ||' collector_status ->'||p_collector_status||fnd_global.local_chr(10)
3488: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3489: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3490: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
3491: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
3492: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
3493: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
3494: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3495: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)

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

3488: ||' person_resp_for_collectio ->'||p_persRespForCollection||fnd_global.local_chr(10)
3489: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3490: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
3491: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
3492: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
3493: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
3494: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3495: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3496: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)

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

3489: ||' designation_of_pers_resp ->'||p_desgOfPersResponsible||fnd_global.local_chr(10)
3490: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
3491: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
3492: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
3493: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
3494: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3495: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3496: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3497: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)

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

3490: ||' RespPerson''s Address ->'||p_RespPersAddress||fnd_global.local_chr(10)
3491: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
3492: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
3493: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
3494: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3495: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3496: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3497: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3498: ||' filename ->'||p_filename||fnd_global.local_chr(10)

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

3491: ||' RespPerson''s State ->'||p_RespPersState||fnd_global.local_chr(10)
3492: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
3493: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
3494: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3495: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3496: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3497: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3498: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3499: ||' Action ->'||p_action||fnd_global.local_chr(10)

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

3492: ||' RespPerson''s Pin ->'||p_RespPersPin||fnd_global.local_chr(10)
3493: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
3494: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3495: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3496: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3497: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3498: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3499: ||' Action ->'||p_action||fnd_global.local_chr(10)
3500: ) ;

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

3493: ||' RespPerson''s Addr Changed ->'||p_RespPersAddrChange||fnd_global.local_chr(10)
3494: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3495: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3496: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3497: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3498: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3499: ||' Action ->'||p_action||fnd_global.local_chr(10)
3500: ) ;
3501:

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

3494: ||' Start_date ->'||p_start_date||fnd_global.local_chr(10)
3495: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3496: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3497: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3498: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3499: ||' Action ->'||p_action||fnd_global.local_chr(10)
3500: ) ;
3501:
3502:

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

3495: ||' End_date ->'||p_end_date||fnd_global.local_chr(10)
3496: ||' Provvisional Rcpt No ->'||p_pro_rcpt_num_org_ret || fnd_global.local_chr(10)
3497: ||' file_path ->'||p_file_path||fnd_global.local_chr(10)
3498: ||' filename ->'||p_filename||fnd_global.local_chr(10)
3499: ||' Action ->'||p_action||fnd_global.local_chr(10)
3500: ) ;
3501:
3502:
3503: generate_etcs_returns