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.JG_ZZ_JOURNAL_AR_PKG dependencies on FND_FILE

Line 89: fnd_file.put_line(fnd_file.log,'**********************************************************');

85:
86: BEGIN
87:
88: IF p_report_name = 'JEITARSV' THEN
89: fnd_file.put_line(fnd_file.log,'**********************************************************');
90: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
91: fnd_file.put_line(fnd_file.log,'**********************************************************');
92: fnd_file.put_line(fnd_file.log,'');
93: fnd_file.put_line(fnd_file.log,'Report Parameters');

Line 90: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');

86: BEGIN
87:
88: IF p_report_name = 'JEITARSV' THEN
89: fnd_file.put_line(fnd_file.log,'**********************************************************');
90: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
91: fnd_file.put_line(fnd_file.log,'**********************************************************');
92: fnd_file.put_line(fnd_file.log,'');
93: fnd_file.put_line(fnd_file.log,'Report Parameters');
94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);

Line 91: fnd_file.put_line(fnd_file.log,'**********************************************************');

87:
88: IF p_report_name = 'JEITARSV' THEN
89: fnd_file.put_line(fnd_file.log,'**********************************************************');
90: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
91: fnd_file.put_line(fnd_file.log,'**********************************************************');
92: fnd_file.put_line(fnd_file.log,'');
93: fnd_file.put_line(fnd_file.log,'Report Parameters');
94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);

Line 92: fnd_file.put_line(fnd_file.log,'');

88: IF p_report_name = 'JEITARSV' THEN
89: fnd_file.put_line(fnd_file.log,'**********************************************************');
90: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
91: fnd_file.put_line(fnd_file.log,'**********************************************************');
92: fnd_file.put_line(fnd_file.log,'');
93: fnd_file.put_line(fnd_file.log,'Report Parameters');
94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
96: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);

Line 93: fnd_file.put_line(fnd_file.log,'Report Parameters');

89: fnd_file.put_line(fnd_file.log,'**********************************************************');
90: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
91: fnd_file.put_line(fnd_file.log,'**********************************************************');
92: fnd_file.put_line(fnd_file.log,'');
93: fnd_file.put_line(fnd_file.log,'Report Parameters');
94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
96: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
97: fnd_file.put_line(fnd_file.log,'**********************************************************');

Line 94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);

90: fnd_file.put_line(fnd_file.log,'Italian Receivables Sales VAT Register');
91: fnd_file.put_line(fnd_file.log,'**********************************************************');
92: fnd_file.put_line(fnd_file.log,'');
93: fnd_file.put_line(fnd_file.log,'Report Parameters');
94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
96: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
97: fnd_file.put_line(fnd_file.log,'**********************************************************');
98: fnd_file.put_line(fnd_file.log,'');

Line 95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);

91: fnd_file.put_line(fnd_file.log,'**********************************************************');
92: fnd_file.put_line(fnd_file.log,'');
93: fnd_file.put_line(fnd_file.log,'Report Parameters');
94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
96: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
97: fnd_file.put_line(fnd_file.log,'**********************************************************');
98: fnd_file.put_line(fnd_file.log,'');
99: fnd_file.put_line(fnd_file.log,'');

Line 96: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);

92: fnd_file.put_line(fnd_file.log,'');
93: fnd_file.put_line(fnd_file.log,'Report Parameters');
94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
96: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
97: fnd_file.put_line(fnd_file.log,'**********************************************************');
98: fnd_file.put_line(fnd_file.log,'');
99: fnd_file.put_line(fnd_file.log,'');
100:

Line 97: fnd_file.put_line(fnd_file.log,'**********************************************************');

93: fnd_file.put_line(fnd_file.log,'Report Parameters');
94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
96: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
97: fnd_file.put_line(fnd_file.log,'**********************************************************');
98: fnd_file.put_line(fnd_file.log,'');
99: fnd_file.put_line(fnd_file.log,'');
100:
101: BEGIN

Line 98: fnd_file.put_line(fnd_file.log,'');

94: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
96: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
97: fnd_file.put_line(fnd_file.log,'**********************************************************');
98: fnd_file.put_line(fnd_file.log,'');
99: fnd_file.put_line(fnd_file.log,'');
100:
101: BEGIN
102:

Line 99: fnd_file.put_line(fnd_file.log,'');

95: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
96: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
97: fnd_file.put_line(fnd_file.log,'**********************************************************');
98: fnd_file.put_line(fnd_file.log,'');
99: fnd_file.put_line(fnd_file.log,'');
100:
101: BEGIN
102:
103: SELECT register_name

Line 124: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger, while fetching the VAT Register name. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

120: AND jzvr.vat_register_id = p_vat_register_id
121: AND jzvr.register_type = 'SALES_VAT' ;
122: EXCEPTION
123: WHEN OTHERS THEN
124: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger, while fetching the VAT Register name. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
125: raise;
126: RETURN(FALSE);
127: END;
128:

Line 132: fnd_file.put_line(fnd_file.log,'**********************************************************');

128:
129: END IF;
130:
131: IF p_report_name = 'JEITRDVR' THEN
132: fnd_file.put_line(fnd_file.log,'**********************************************************');
133: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
134: fnd_file.put_line(fnd_file.log,'**********************************************************');
135: fnd_file.put_line(fnd_file.log,'');
136: fnd_file.put_line(fnd_file.log,'Report Parameters');

Line 133: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');

129: END IF;
130:
131: IF p_report_name = 'JEITRDVR' THEN
132: fnd_file.put_line(fnd_file.log,'**********************************************************');
133: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
134: fnd_file.put_line(fnd_file.log,'**********************************************************');
135: fnd_file.put_line(fnd_file.log,'');
136: fnd_file.put_line(fnd_file.log,'Report Parameters');
137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);

Line 134: fnd_file.put_line(fnd_file.log,'**********************************************************');

130:
131: IF p_report_name = 'JEITRDVR' THEN
132: fnd_file.put_line(fnd_file.log,'**********************************************************');
133: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
134: fnd_file.put_line(fnd_file.log,'**********************************************************');
135: fnd_file.put_line(fnd_file.log,'');
136: fnd_file.put_line(fnd_file.log,'Report Parameters');
137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);

Line 135: fnd_file.put_line(fnd_file.log,'');

131: IF p_report_name = 'JEITRDVR' THEN
132: fnd_file.put_line(fnd_file.log,'**********************************************************');
133: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
134: fnd_file.put_line(fnd_file.log,'**********************************************************');
135: fnd_file.put_line(fnd_file.log,'');
136: fnd_file.put_line(fnd_file.log,'Report Parameters');
137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
139: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);

Line 136: fnd_file.put_line(fnd_file.log,'Report Parameters');

132: fnd_file.put_line(fnd_file.log,'**********************************************************');
133: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
134: fnd_file.put_line(fnd_file.log,'**********************************************************');
135: fnd_file.put_line(fnd_file.log,'');
136: fnd_file.put_line(fnd_file.log,'Report Parameters');
137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
139: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
140: fnd_file.put_line(fnd_file.log,'**********************************************************');

Line 137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);

133: fnd_file.put_line(fnd_file.log,'Italian Receivables Deferred VAT Register');
134: fnd_file.put_line(fnd_file.log,'**********************************************************');
135: fnd_file.put_line(fnd_file.log,'');
136: fnd_file.put_line(fnd_file.log,'Report Parameters');
137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
139: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
140: fnd_file.put_line(fnd_file.log,'**********************************************************');
141: fnd_file.put_line(fnd_file.log,'');

Line 138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);

134: fnd_file.put_line(fnd_file.log,'**********************************************************');
135: fnd_file.put_line(fnd_file.log,'');
136: fnd_file.put_line(fnd_file.log,'Report Parameters');
137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
139: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
140: fnd_file.put_line(fnd_file.log,'**********************************************************');
141: fnd_file.put_line(fnd_file.log,'');
142: fnd_file.put_line(fnd_file.log,'');

Line 139: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);

135: fnd_file.put_line(fnd_file.log,'');
136: fnd_file.put_line(fnd_file.log,'Report Parameters');
137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
139: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
140: fnd_file.put_line(fnd_file.log,'**********************************************************');
141: fnd_file.put_line(fnd_file.log,'');
142: fnd_file.put_line(fnd_file.log,'');
143:

Line 140: fnd_file.put_line(fnd_file.log,'**********************************************************');

136: fnd_file.put_line(fnd_file.log,'Report Parameters');
137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
139: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
140: fnd_file.put_line(fnd_file.log,'**********************************************************');
141: fnd_file.put_line(fnd_file.log,'');
142: fnd_file.put_line(fnd_file.log,'');
143:
144: BEGIN

Line 141: fnd_file.put_line(fnd_file.log,'');

137: fnd_file.put_line(fnd_file.log,'Tax Registraion Number : '||p_vat_rep_entity_id);
138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
139: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
140: fnd_file.put_line(fnd_file.log,'**********************************************************');
141: fnd_file.put_line(fnd_file.log,'');
142: fnd_file.put_line(fnd_file.log,'');
143:
144: BEGIN
145:

Line 142: fnd_file.put_line(fnd_file.log,'');

138: fnd_file.put_line(fnd_file.log,'Tax Calendar Year : '||p_period);
139: fnd_file.put_line(fnd_file.log,'VAT Register Id : '||p_vat_register_id);
140: fnd_file.put_line(fnd_file.log,'**********************************************************');
141: fnd_file.put_line(fnd_file.log,'');
142: fnd_file.put_line(fnd_file.log,'');
143:
144: BEGIN
145:
146: SELECT register_name

Line 168: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger, while fetching the VAT Register name. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

164: AND jzvr.register_type = 'DEFERRED_VAT';
165:
166: EXCEPTION
167: WHEN OTHERS THEN
168: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger, while fetching the VAT Register name. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
169: raise;
170: RETURN(FALSE);
171: END;
172:

Line 175: fnd_file.put_line(fnd_file.log,'before Report Trigger');

171: END;
172:
173: END IF;
174:
175: fnd_file.put_line(fnd_file.log,'before Report Trigger');
176: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
177: ,x_rep_entity_name => l_legal_entity_name
178: ,x_legal_entity_id => l_legal_entity_id
179: ,x_taxpayer_id => l_tax_payer_id

Line 182: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');

178: ,x_legal_entity_id => l_legal_entity_id
179: ,x_taxpayer_id => l_tax_payer_id
180: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
181: ,pv_period_name => p_period);
182: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
183: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
184: ,x_period_start_date => l_period_start_date
185: ,x_period_end_date => l_period_end_date
186: ,x_status => l_reporting_status

Line 190: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');

186: ,x_status => l_reporting_status
187: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
188: ,pv_period_name => p_period
189: ,pv_source => 'ALL');
190: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
191: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
192: ,x_registration_number => l_registration_num
193: ,x_country => l_country
194: ,x_address1 => l_address_line_1

Line 246: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);

242: ,pv_source => NULL
243: ,pv_report_name => p_report_name);
244: END IF;
245:
246: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);
247: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
248:
249: IF P_REPORT_NAME = 'JEESRRVR' THEN
250: IF P_SEQUENCE = 'Y' THEN

Line 247: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);

243: ,pv_report_name => p_report_name);
244: END IF;
245:
246: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'||P_REPORT_NAME);
247: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
248:
249: IF P_REPORT_NAME = 'JEESRRVR' THEN
250: IF P_SEQUENCE = 'Y' THEN
251: BEGIN

Line 308: fnd_file.put_line(fnd_file.log,'l_sequence_start :'||l_sequence_start);

304: AND trunc(l_period_start_date,'YYYY') <= all
305: (select trx_date from jg_zz_vat_trx_details A
306: where A.trx_id = JZVTD.trx_id );
307:
308: fnd_file.put_line(fnd_file.log,'l_sequence_start :'||l_sequence_start);
309:
310: EXCEPTION
311: WHEN NO_DATA_FOUND THEN
312: l_sequence_start := 0;

Line 314: fnd_file.put_line(fnd_file.log,'An error occured while calculating the l_sequence_start. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

310: EXCEPTION
311: WHEN NO_DATA_FOUND THEN
312: l_sequence_start := 0;
313: WHEN OTHERS THEN
314: fnd_file.put_line(fnd_file.log,'An error occured while calculating the l_sequence_start. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
315: END;
316: ELSE
317: l_sequence_start := 0;
318: END IF;

Line 378: fnd_file.put_line(fnd_file.log,'Calling jebedv07');

374: ,l_vat_reg_num
375: );
376:
377: IF P_REPORT_NAME = 'JEBEDV07' THEN
378: fnd_file.put_line(fnd_file.log,'Calling jebedv07');
379: jebedv07(p_vat_rep_entity_id => p_vat_rep_entity_id
380: ,p_period => p_period
381: ,p_document_sequence_name_from => p_document_sequence_name_from
382: ,p_document_sequence_name_to => p_document_sequence_name_to

Line 387: fnd_file.put_line(fnd_file.log,'After Calling jebedv07');

383: ,p_customer_name_from => p_customer_name_from
384: ,p_customer_name_to => p_customer_name_to
385: ,p_detail_summary => p_detail_summary
386: ,x_err_msg => l_err_msg);
387: fnd_file.put_line(fnd_file.log,'After Calling jebedv07');
388: ELSIF P_REPORT_NAME = 'JEITARSV' THEN
389: fnd_file.put_line(fnd_file.log,'Calling jeitarsv');
390: jeitarsv(p_vat_rep_entity_id => p_vat_rep_entity_id
391: ,p_period => p_period

Line 389: fnd_file.put_line(fnd_file.log,'Calling jeitarsv');

385: ,p_detail_summary => p_detail_summary
386: ,x_err_msg => l_err_msg);
387: fnd_file.put_line(fnd_file.log,'After Calling jebedv07');
388: ELSIF P_REPORT_NAME = 'JEITARSV' THEN
389: fnd_file.put_line(fnd_file.log,'Calling jeitarsv');
390: jeitarsv(p_vat_rep_entity_id => p_vat_rep_entity_id
391: ,p_period => p_period
392: ,p_vat_register_id => p_vat_register_id
393: ,x_err_msg => l_err_msg);

Line 394: fnd_file.put_line(fnd_file.log,'After Calling jeitarsv');

390: jeitarsv(p_vat_rep_entity_id => p_vat_rep_entity_id
391: ,p_period => p_period
392: ,p_vat_register_id => p_vat_register_id
393: ,x_err_msg => l_err_msg);
394: fnd_file.put_line(fnd_file.log,'After Calling jeitarsv');
395: ELSIF P_REPORT_NAME = 'JEITRDVR' THEN
396: fnd_file.put_line(fnd_file.log,'Calling jeitrdvr');
397: jeitrdvr(p_vat_rep_entity_id => p_vat_rep_entity_id
398: ,p_period => p_period

Line 396: fnd_file.put_line(fnd_file.log,'Calling jeitrdvr');

392: ,p_vat_register_id => p_vat_register_id
393: ,x_err_msg => l_err_msg);
394: fnd_file.put_line(fnd_file.log,'After Calling jeitarsv');
395: ELSIF P_REPORT_NAME = 'JEITRDVR' THEN
396: fnd_file.put_line(fnd_file.log,'Calling jeitrdvr');
397: jeitrdvr(p_vat_rep_entity_id => p_vat_rep_entity_id
398: ,p_period => p_period
399: ,p_vat_register_id => p_vat_register_id
400: ,x_err_msg => l_err_msg);

Line 401: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');

397: jeitrdvr(p_vat_rep_entity_id => p_vat_rep_entity_id
398: ,p_period => p_period
399: ,p_vat_register_id => p_vat_register_id
400: ,x_err_msg => l_err_msg);
401: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');
402: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
403: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
404: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
405: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);

Line 403: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');

399: ,p_vat_register_id => p_vat_register_id
400: ,x_err_msg => l_err_msg);
401: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');
402: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
403: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
404: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
405: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
406: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);

Line 404: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');

400: ,x_err_msg => l_err_msg);
401: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');
402: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
403: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
404: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
405: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
406: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
408: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );

Line 405: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);

401: fnd_file.put_line(fnd_file.log,'After Calling jeitrdvr');
402: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
403: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
404: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
405: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
406: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
408: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
409: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);

Line 406: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);

402: ELSIF P_REPORT_NAME = 'JEESRRVR' THEN
403: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
404: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
405: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
406: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
408: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
409: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
410: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );

Line 407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);

403: fnd_file.put_line(fnd_file.log,'Calling jeesrrvr');
404: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
405: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
406: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
408: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
409: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
410: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
411: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);

Line 408: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );

404: fnd_file.put_line(fnd_file.log,'--PARAMETERS--');
405: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
406: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
408: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
409: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
410: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
411: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
412:

Line 409: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);

405: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'||P_VAT_REP_ENTITY_ID);
406: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
408: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
409: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
410: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
411: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
412:
413: jeesrrvr(p_vat_rep_entity_id => p_vat_rep_entity_id

Line 410: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );

406: fnd_file.put_line(fnd_file.log,'P_PERIOD :'||P_PERIOD);
407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
408: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
409: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
410: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
411: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
412:
413: jeesrrvr(p_vat_rep_entity_id => p_vat_rep_entity_id
414: ,p_period => p_period

Line 411: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);

407: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'||P_TAX_TYPE);
408: fnd_file.put_line(fnd_file.log,'P_TAX_REGISTER_TYPE :'||P_TAX_REGISTER_TYPE );
409: fnd_file.put_line(fnd_file.log,'P_CHART_OF_ACCOUNT_ID :'||P_CHART_OF_ACCOUNT_ID);
410: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'||P_BALANCING_SEGMENT );
411: fnd_file.put_line(fnd_file.log,'P_SEQUENCE :'||P_SEQUENCE);
412:
413: jeesrrvr(p_vat_rep_entity_id => p_vat_rep_entity_id
414: ,p_period => p_period
415: ,p_tax_type => p_tax_type

Line 419: fnd_file.put_line(fnd_file.log,'After Calling jeesrrvr');

415: ,p_tax_type => p_tax_type
416: ,p_tax_register_type => p_tax_register_type
417: ,p_sequence => p_sequence
418: ,x_err_msg => l_err_msg);
419: fnd_file.put_line(fnd_file.log,'After Calling jeesrrvr');
420: ELSIF (P_REPORT_NAME = 'JOURNAL-AR' OR P_REPORT_NAME IS NOT NULL) THEN
421: fnd_file.put_line(fnd_file.log,'Calling journal_ar');
422: NULL;
423: fnd_file.put_line(fnd_file.log,'After Calling journal_ar');

Line 421: fnd_file.put_line(fnd_file.log,'Calling journal_ar');

417: ,p_sequence => p_sequence
418: ,x_err_msg => l_err_msg);
419: fnd_file.put_line(fnd_file.log,'After Calling jeesrrvr');
420: ELSIF (P_REPORT_NAME = 'JOURNAL-AR' OR P_REPORT_NAME IS NOT NULL) THEN
421: fnd_file.put_line(fnd_file.log,'Calling journal_ar');
422: NULL;
423: fnd_file.put_line(fnd_file.log,'After Calling journal_ar');
424: END IF;
425: RETURN (TRUE);

Line 423: fnd_file.put_line(fnd_file.log,'After Calling journal_ar');

419: fnd_file.put_line(fnd_file.log,'After Calling jeesrrvr');
420: ELSIF (P_REPORT_NAME = 'JOURNAL-AR' OR P_REPORT_NAME IS NOT NULL) THEN
421: fnd_file.put_line(fnd_file.log,'Calling journal_ar');
422: NULL;
423: fnd_file.put_line(fnd_file.log,'After Calling journal_ar');
424: END IF;
425: RETURN (TRUE);
426: EXCEPTION
427: WHEN OTHERS THEN

Line 428: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

424: END IF;
425: RETURN (TRUE);
426: EXCEPTION
427: WHEN OTHERS THEN
428: fnd_file.put_line(fnd_file.log,'An error occured in the before report trigger. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
429: raise;
430: RETURN(FALSE);
431: END beforeReport;
432:

Line 638: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEBEDV07. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

634: END LOOP;
635:
636: EXCEPTION
637: WHEN OTHERS THEN
638: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEBEDV07. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
639: END jebedv07;
640:
641: --
642: -- +======================================================================+

Line 810: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEITARSV. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

806: END IF;
807:
808: EXCEPTION
809: WHEN OTHERS THEN
810: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEITARSV. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
811: END jeitarsv;
812:
813:
814: --

Line 989: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEITRDVR. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

985: END IF;
986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEITRDVR. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
990: END jeitrdvr;
991:
992:
993: --

Line 1100: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEESRRVR. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);

1096:
1097:
1098: EXCEPTION
1099: WHEN OTHERS THEN
1100: fnd_file.put_line(fnd_file.log,'An error occured in the Procedure JEESRRVR. Exception : ' || SUBSTR(SQLERRM,1,200) || SQLCODE);
1101: END jeesrrvr;
1102:
1103: FUNCTION get_sequence_number RETURN NUMBER IS
1104: l_start_seq NUMBER;