DBA Data[Home] [Help]

APPS.JG_ZZ_AUDIT_AR_PKG dependencies on FND_FILE

Line 201: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Procedure FUNCT_CURR_LEGAL'); end if;

197: BEGIN
198:
199: -- Call to common pack for Header Info.
200: -- Calling this package first because, currency_code is needed for getting precision
201: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Procedure FUNCT_CURR_LEGAL'); end if;
202:
203: /* changed from JGZZ_COMMON_PKG to JG_ZZ_COMMON_PKG */
204: JG_ZZ_COMMON_PKG.funct_curr_legal(lc_curr_code -- x_func_curr_code O VARCHAR2
205: ,lc_rep_entity_name -- x_rep_entity_name O VARCHAR2

Line 221: fnd_file.put_line(fnd_file.log,'Insert JEBEVA17 Annual VAT Audit Report Info');

217:
218: IF p_report_name = 'JEBEVA17' THEN
219:
220: if gv_debug then
221: fnd_file.put_line(fnd_file.log,'Insert JEBEVA17 Annual VAT Audit Report Info');
222: end if;
223:
224: l_rec_count:=0;
225: t_total_amount := 0;

Line 275: if gv_debug then fnd_file.put_line(fnd_file.log,'Insert JECZAREX Czech Export Tax Report Info'); end if;

271: END IF;
272:
273: END LOOP;
274: ELSIF p_report_name = 'JECZAREX' THEN
275: if gv_debug then fnd_file.put_line(fnd_file.log,'Insert JECZAREX Czech Export Tax Report Info'); end if;
276:
277: l_rec_count:=0;
278: FOR r_jgczvat IN c_jgczvat
279: LOOP

Line 303: if gv_debug then fnd_file.put_line(fnd_file.log,'Insert AUDIT-AR Info'); end if;

299: ,r_jgczvat.taxable_amount
300: );
301: END LOOP;
302: ELSIF NVL(p_report_name,'AUDIT-AR') = 'AUDIT-AR' THEN
303: if gv_debug then fnd_file.put_line(fnd_file.log,'Insert AUDIT-AR Info'); end if;
304:
305: l_rec_count:=0;
306: FOR r_jgzzaudar IN c_jgzzaudar
307: LOOP

Line 353: if gv_debug then fnd_file.put_line(fnd_file.log,'Global temp table records check'); end if;

349: ,r_jgzzaudar.tax_amount
350: );
351: END LOOP;
352: END IF;
353: if gv_debug then fnd_file.put_line(fnd_file.log,'Global temp table records check'); end if;
354:
355: OPEN c_count;
356: FETCH c_count INTO p_rec_count;
357: CLOSE c_count;

Line 359: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Procedure TAX_REGISTRATION'); end if;

355: OPEN c_count;
356: FETCH c_count INTO p_rec_count;
357: CLOSE c_count;
358:
359: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Procedure TAX_REGISTRATION'); end if;
360:
361: /* changed from JGZZ_COMMON_PKG to JG_ZZ_COMMON_PKG */
362: JG_ZZ_COMMON_PKG.tax_registration(lc_tax_registration -- x_tax_registration O VARCHAR2
363: ,ld_period_start_date -- x_period_start_date O DATE

Line 372: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Procedure COMPANY_DETAIL'); end if;

368: ,p_year -- pn_period_year I NUMBER DEFAULT NULL
369: ,'AR' -- pv_source I VARCHAR2
370: );
371:
372: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Procedure COMPANY_DETAIL'); end if;
373:
374: /* changed from JGZZ_COMMON_PKG to JG_ZZ_COMMON_PKG */
375:
376: jg_zz_common_pkg.company_detail(x_company_name => lc_company_name

Line 401: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Inserting Header Info'); end if;

397: ,pv_source => NULL
398: ,pv_report_name => p_report_name);
399:
400:
401: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Inserting Header Info'); end if;
402:
403: INSERT INTO jg_zz_vat_trx_gt (jg_info_v1 -- curr_code
404: ,jg_info_v2 -- entity_name
405: ,jg_info_v3 -- taxpayer_id

Line 446: FND_FILE.PUT_LINE(FND_FILE.LOG,'No data found during Before Report Trigger');

442: RETURN (TRUE);
443: EXCEPTION
444: /*UT TEST
445: WHEN NO_DATA_FOUND THEN
446: FND_FILE.PUT_LINE(FND_FILE.LOG,'No data found during Before Report Trigger');
447: RETURN (FALSE); */
448:
449: WHEN REPORT_LIMIT_REACHED THEN
450: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of records exceeded the report limit.');

Line 450: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of records exceeded the report limit.');

446: FND_FILE.PUT_LINE(FND_FILE.LOG,'No data found during Before Report Trigger');
447: RETURN (FALSE); */
448:
449: WHEN REPORT_LIMIT_REACHED THEN
450: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of records exceeded the report limit.');
451: RETURN (FALSE);
452:
453: WHEN AMOUNT_LIMIT_REACHED THEN
454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Amount Overflow, total amount or tax has exceeded the limit.');

Line 454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Amount Overflow, total amount or tax has exceeded the limit.');

450: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of records exceeded the report limit.');
451: RETURN (FALSE);
452:
453: WHEN AMOUNT_LIMIT_REACHED THEN
454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Amount Overflow, total amount or tax has exceeded the limit.');
455: RETURN (FALSE);
456:
457: WHEN OTHERS THEN
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in beforeReport trigger of JG_ZZ_AUDIT_AR_PKG package. Error-' || SQLCODE || SUBSTR(SQLERRM,1,200));

Line 458: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in beforeReport trigger of JG_ZZ_AUDIT_AR_PKG package. Error-' || SQLCODE || SUBSTR(SQLERRM,1,200));

454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Amount Overflow, total amount or tax has exceeded the limit.');
455: RETURN (FALSE);
456:
457: WHEN OTHERS THEN
458: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in beforeReport trigger of JG_ZZ_AUDIT_AR_PKG package. Error-' || SQLCODE || SUBSTR(SQLERRM,1,200));
459: RETURN (FALSE);
460: END;
461:
462: RETURN (TRUE);