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_TURNOVER_AR_PKG dependencies on FND_FILE

Line 55: fnd_file.put_line(fnd_file.log,p_message);

51:
52: PROCEDURE message(p_message IN VARCHAR2)
53: AS
54: BEGIN
55: fnd_file.put_line(fnd_file.log,p_message);
56: END message;
57:
58: FUNCTION beforeReport RETURN BOOLEAN
59: -- +======================================================================+

Line 170: fnd_file.put_line(fnd_file.log,'Executing jg_zz_turnover_ar_pkg.before_report');

166:
167: BEGIN
168: -- Call to Common Package
169: IF p_debug_flag = 'Y' THEN
170: fnd_file.put_line(fnd_file.log,'Executing jg_zz_turnover_ar_pkg.before_report');
171: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.funct_curr_legal');
172: END IF;
173: BEGIN
174: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr

Line 171: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.funct_curr_legal');

167: BEGIN
168: -- Call to Common Package
169: IF p_debug_flag = 'Y' THEN
170: fnd_file.put_line(fnd_file.log,'Executing jg_zz_turnover_ar_pkg.before_report');
171: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.funct_curr_legal');
172: END IF;
173: BEGIN
174: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
175: ,x_rep_entity_name => l_legal_entity_name

Line 182: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal failed with Error: '||SUBSTR(SQLERRM,1,200));

178: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
179: ,pn_period_year => p_period);
180: EXCEPTION
181: WHEN OTHERS THEN
182: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal failed with Error: '||SUBSTR(SQLERRM,1,200));
183: END;
184: IF p_debug_flag = 'Y' THEN
185: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
186: END IF;

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

181: WHEN OTHERS THEN
182: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.funct_curr_legal failed with Error: '||SUBSTR(SQLERRM,1,200));
183: END;
184: IF p_debug_flag = 'Y' THEN
185: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
186: END IF;
187: BEGIN
188: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
189: ,x_period_start_date => l_period_start_date

Line 198: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration failed with Error: '||SUBSTR(SQLERRM,1,200));

194: ,pn_period_year => p_period /*5223170*/
195: ,pv_source => 'ALL');
196: EXCEPTION
197: WHEN OTHERS THEN
198: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.tax_registration failed with Error: '||SUBSTR(SQLERRM,1,200));
199: END;
200:
201:
202: IF p_debug_flag = 'Y' THEN

Line 203: fnd_file.put_line(fnd_file.log,'Calling jg_zz_vat_rep_utlity.get_report_status');

199: END;
200:
201:
202: IF p_debug_flag = 'Y' THEN
203: fnd_file.put_line(fnd_file.log,'Calling jg_zz_vat_rep_utlity.get_report_status');
204: END IF;
205: BEGIN
206: l_reporting_status := jg_zz_vat_rep_utility.get_period_status
207: (

Line 216: fnd_file.put_line(fnd_file.log,'Executing jg_zz_vat_rep_utility.get_report_status failed with Error: '||SUBSTR(SQLERRM,1,200));

212: pv_report_name => P_REPORT_NAME
213: );
214: EXCEPTION
215: WHEN OTHERS THEN
216: fnd_file.put_line(fnd_file.log,'Executing jg_zz_vat_rep_utility.get_report_status failed with Error: '||SUBSTR(SQLERRM,1,200));
217: END;
218:
219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');

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

216: fnd_file.put_line(fnd_file.log,'Executing jg_zz_vat_rep_utility.get_report_status failed with Error: '||SUBSTR(SQLERRM,1,200));
217: END;
218:
219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
221: END IF;
222: BEGIN
223: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
224: ,x_registration_number => l_registration_num

Line 242: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail failed with Error: '||SUBSTR(SQLERRM,1,200));

238: ,p_vat_reporting_entity_id => p_vat_rep_entity_id);
239:
240: EXCEPTION
241: WHEN OTHERS THEN
242: fnd_file.put_line(fnd_file.log,'Executing jg_zz_common_pkg.company_detail failed with Error: '||SUBSTR(SQLERRM,1,200));
243: END;
244: BEGIN
245: SELECT activity_code
246: INTO l_activity_code

Line 251: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);

247: FROM xle_entity_profiles
248: WHERE legal_entity_id = l_legal_entity_id;
249: EXCEPTION
250: WHEN NO_DATA_FOUND THEN
251: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
252: WHEN OTHERS THEN
253: fnd_file.put_line(fnd_file.log,'Error While retrieving Activity Code for Legal Entity:'||l_legal_entity_id);
254: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
255: END;

Line 253: fnd_file.put_line(fnd_file.log,'Error While retrieving Activity Code for Legal Entity:'||l_legal_entity_id);

249: EXCEPTION
250: WHEN NO_DATA_FOUND THEN
251: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
252: WHEN OTHERS THEN
253: fnd_file.put_line(fnd_file.log,'Error While retrieving Activity Code for Legal Entity:'||l_legal_entity_id);
254: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
255: END;
256: BEGIN
257: SELECT hp.primary_phone_number PHONE_NUMBER

Line 254: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));

250: WHEN NO_DATA_FOUND THEN
251: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
252: WHEN OTHERS THEN
253: fnd_file.put_line(fnd_file.log,'Error While retrieving Activity Code for Legal Entity:'||l_legal_entity_id);
254: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
255: END;
256: BEGIN
257: SELECT hp.primary_phone_number PHONE_NUMBER
258: ,hp.email_address EMAIL_ADDRESS

Line 277: fnd_file.put_line(fnd_file.log,'Error While retrieving Contact information:'||l_legal_entity_id);

273: EXCEPTION
274: WHEN NO_DATA_FOUND THEN
275: NULL;
276: WHEN OTHERS THEN
277: fnd_file.put_line(fnd_file.log,'Error While retrieving Contact information:'||l_legal_entity_id);
278: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
279: END;
280:
281: INSERT INTO jg_zz_vat_trx_gt

Line 278: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));

274: WHEN NO_DATA_FOUND THEN
275: NULL;
276: WHEN OTHERS THEN
277: fnd_file.put_line(fnd_file.log,'Error While retrieving Contact information:'||l_legal_entity_id);
278: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
279: END;
280:
281: INSERT INTO jg_zz_vat_trx_gt
282: (

Line 332: fnd_file.put_line(fnd_file.log,'Legal Entity ID =>' || l_legal_entity_id);

328: ,l_email_address
329: ,'H'
330: );
331: IF p_debug_flag = 'Y' THEN
332: fnd_file.put_line(fnd_file.log,'Legal Entity ID =>' || l_legal_entity_id);
333: fnd_file.put_line(fnd_file.log,'Company Name =>' || l_company_name);
334: fnd_file.put_line(fnd_file.log,'Legal Entity Name =>' || l_company_name);
335: fnd_file.put_line(fnd_file.log,'Regiatration Number =>' || l_registration_num);
336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);

Line 333: fnd_file.put_line(fnd_file.log,'Company Name =>' || l_company_name);

329: ,'H'
330: );
331: IF p_debug_flag = 'Y' THEN
332: fnd_file.put_line(fnd_file.log,'Legal Entity ID =>' || l_legal_entity_id);
333: fnd_file.put_line(fnd_file.log,'Company Name =>' || l_company_name);
334: fnd_file.put_line(fnd_file.log,'Legal Entity Name =>' || l_company_name);
335: fnd_file.put_line(fnd_file.log,'Regiatration Number =>' || l_registration_num);
336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);
337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);

Line 334: fnd_file.put_line(fnd_file.log,'Legal Entity Name =>' || l_company_name);

330: );
331: IF p_debug_flag = 'Y' THEN
332: fnd_file.put_line(fnd_file.log,'Legal Entity ID =>' || l_legal_entity_id);
333: fnd_file.put_line(fnd_file.log,'Company Name =>' || l_company_name);
334: fnd_file.put_line(fnd_file.log,'Legal Entity Name =>' || l_company_name);
335: fnd_file.put_line(fnd_file.log,'Regiatration Number =>' || l_registration_num);
336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);
337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);
338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);

Line 335: fnd_file.put_line(fnd_file.log,'Regiatration Number =>' || l_registration_num);

331: IF p_debug_flag = 'Y' THEN
332: fnd_file.put_line(fnd_file.log,'Legal Entity ID =>' || l_legal_entity_id);
333: fnd_file.put_line(fnd_file.log,'Company Name =>' || l_company_name);
334: fnd_file.put_line(fnd_file.log,'Legal Entity Name =>' || l_company_name);
335: fnd_file.put_line(fnd_file.log,'Regiatration Number =>' || l_registration_num);
336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);
337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);
338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);
339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);

Line 336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);

332: fnd_file.put_line(fnd_file.log,'Legal Entity ID =>' || l_legal_entity_id);
333: fnd_file.put_line(fnd_file.log,'Company Name =>' || l_company_name);
334: fnd_file.put_line(fnd_file.log,'Legal Entity Name =>' || l_company_name);
335: fnd_file.put_line(fnd_file.log,'Regiatration Number =>' || l_registration_num);
336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);
337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);
338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);
339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);
340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);

Line 337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);

333: fnd_file.put_line(fnd_file.log,'Company Name =>' || l_company_name);
334: fnd_file.put_line(fnd_file.log,'Legal Entity Name =>' || l_company_name);
335: fnd_file.put_line(fnd_file.log,'Regiatration Number =>' || l_registration_num);
336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);
337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);
338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);
339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);
340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);
341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);

Line 338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);

334: fnd_file.put_line(fnd_file.log,'Legal Entity Name =>' || l_company_name);
335: fnd_file.put_line(fnd_file.log,'Regiatration Number =>' || l_registration_num);
336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);
337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);
338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);
339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);
340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);
341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);
342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);

Line 339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);

335: fnd_file.put_line(fnd_file.log,'Regiatration Number =>' || l_registration_num);
336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);
337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);
338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);
339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);
340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);
341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);
342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);
343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);

Line 340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);

336: fnd_file.put_line(fnd_file.log,'Taxpayer ID =>' || l_registration_num);
337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);
338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);
339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);
340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);
341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);
342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);
343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);
344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);

Line 341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);

337: fnd_file.put_line(fnd_file.log,'Contact Name =>' || l_contact_name);
338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);
339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);
340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);
341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);
342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);
343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);
344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);
345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);

Line 342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);

338: fnd_file.put_line(fnd_file.log,'Address Line 1 =>' || l_address_line_1);
339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);
340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);
341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);
342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);
343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);
344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);
345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);
346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);

Line 343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);

339: fnd_file.put_line(fnd_file.log,' 2 =>' || l_address_line_2);
340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);
341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);
342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);
343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);
344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);
345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);
346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);
347: fnd_file.put_line(fnd_file.log,'Reporting Status =>' || l_reporting_status);

Line 344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);

340: fnd_file.put_line(fnd_file.log,' 3 =>' || l_address_line_3);
341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);
342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);
343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);
344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);
345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);
346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);
347: fnd_file.put_line(fnd_file.log,'Reporting Status =>' || l_reporting_status);
348: fnd_file.put_line(fnd_file.log,'Period Start Date =>' || l_period_start_date);

Line 345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);

341: fnd_file.put_line(fnd_file.log,' 4 =>' || l_address_line_4);
342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);
343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);
344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);
345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);
346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);
347: fnd_file.put_line(fnd_file.log,'Reporting Status =>' || l_reporting_status);
348: fnd_file.put_line(fnd_file.log,'Period Start Date =>' || l_period_start_date);
349: fnd_file.put_line(fnd_file.log,' End Date =>' || l_period_end_date);

Line 346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);

342: fnd_file.put_line(fnd_file.log,'City =>' || l_city);
343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);
344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);
345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);
346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);
347: fnd_file.put_line(fnd_file.log,'Reporting Status =>' || l_reporting_status);
348: fnd_file.put_line(fnd_file.log,'Period Start Date =>' || l_period_start_date);
349: fnd_file.put_line(fnd_file.log,' End Date =>' || l_period_end_date);
350: fnd_file.put_line(fnd_file.log,'Email address =>' || l_email_address);

Line 347: fnd_file.put_line(fnd_file.log,'Reporting Status =>' || l_reporting_status);

343: fnd_file.put_line(fnd_file.log,'Country =>' || l_country);
344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);
345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);
346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);
347: fnd_file.put_line(fnd_file.log,'Reporting Status =>' || l_reporting_status);
348: fnd_file.put_line(fnd_file.log,'Period Start Date =>' || l_period_start_date);
349: fnd_file.put_line(fnd_file.log,' End Date =>' || l_period_end_date);
350: fnd_file.put_line(fnd_file.log,'Email address =>' || l_email_address);
351: END IF;

Line 348: fnd_file.put_line(fnd_file.log,'Period Start Date =>' || l_period_start_date);

344: fnd_file.put_line(fnd_file.log,'Telephone Number =>' || l_phone_number);
345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);
346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);
347: fnd_file.put_line(fnd_file.log,'Reporting Status =>' || l_reporting_status);
348: fnd_file.put_line(fnd_file.log,'Period Start Date =>' || l_period_start_date);
349: fnd_file.put_line(fnd_file.log,' End Date =>' || l_period_end_date);
350: fnd_file.put_line(fnd_file.log,'Email address =>' || l_email_address);
351: END IF;
352: IF P_REPORT_NAME = 'JEBEVADC' OR P_REPORT_NAME = 'JEBEVA24' THEN

Line 349: fnd_file.put_line(fnd_file.log,' End Date =>' || l_period_end_date);

345: fnd_file.put_line(fnd_file.log,'Postal Code =>' || l_postal_code);
346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);
347: fnd_file.put_line(fnd_file.log,'Reporting Status =>' || l_reporting_status);
348: fnd_file.put_line(fnd_file.log,'Period Start Date =>' || l_period_start_date);
349: fnd_file.put_line(fnd_file.log,' End Date =>' || l_period_end_date);
350: fnd_file.put_line(fnd_file.log,'Email address =>' || l_email_address);
351: END IF;
352: IF P_REPORT_NAME = 'JEBEVADC' OR P_REPORT_NAME = 'JEBEVA24' THEN
353:

Line 350: fnd_file.put_line(fnd_file.log,'Email address =>' || l_email_address);

346: fnd_file.put_line(fnd_file.log,'Currency Code =>' || l_func_curr);
347: fnd_file.put_line(fnd_file.log,'Reporting Status =>' || l_reporting_status);
348: fnd_file.put_line(fnd_file.log,'Period Start Date =>' || l_period_start_date);
349: fnd_file.put_line(fnd_file.log,' End Date =>' || l_period_end_date);
350: fnd_file.put_line(fnd_file.log,'Email address =>' || l_email_address);
351: END IF;
352: IF P_REPORT_NAME = 'JEBEVADC' OR P_REPORT_NAME = 'JEBEVA24' THEN
353:
354: BEGIN

Line 361: fnd_file.put_line(fnd_file.log,'No data found while retrieving precision. Check the currency code.');

357: from fnd_currencies_vl
358: where currency_code = l_func_curr;
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: fnd_file.put_line(fnd_file.log,'No data found while retrieving precision. Check the currency code.');
362: WHEN OTHERS THEN
363: fnd_file.put_line(fnd_file.log,'Error While retrieving precision');
364: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
365: END;

Line 363: fnd_file.put_line(fnd_file.log,'Error While retrieving precision');

359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: fnd_file.put_line(fnd_file.log,'No data found while retrieving precision. Check the currency code.');
362: WHEN OTHERS THEN
363: fnd_file.put_line(fnd_file.log,'Error While retrieving precision');
364: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
365: END;
366:
367: IF P_REPORT_NAME = 'JEBEVA24' THEN

Line 364: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));

360: WHEN NO_DATA_FOUND THEN
361: fnd_file.put_line(fnd_file.log,'No data found while retrieving precision. Check the currency code.');
362: WHEN OTHERS THEN
363: fnd_file.put_line(fnd_file.log,'Error While retrieving precision');
364: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
365: END;
366:
367: IF P_REPORT_NAME = 'JEBEVA24' THEN
368: if l_func_curr = gl_currency_api.get_euro_code() then

Line 627: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt: ' || l_vat_count);

623: INTO l_vat_count
624: FROM jg_zz_vat_trx_gt
625: WHERE jg_info_v30 IS NULL;
626:
627: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt: ' || l_vat_count);
628:
629: IF l_vat_count = 0 THEN
630: RAISE NO_TRANS_RECORDS;
631: END IF;