DBA Data[Home] [Help]

APPS.JG_ZZ_AUDIT_AR_PKG dependencies on FND_FILE

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

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

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

212:
213: IF p_report_name = 'JEBEVA17' THEN
214:
215: if gv_debug then
216: fnd_file.put_line(fnd_file.log,'Insert JEBEVA17 Annual VAT Audit Report Info');
217: end if;
218:
219: l_rec_count:=0;
220: t_total_amount := 0;

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

266: END IF;
267:
268: END LOOP;
269: ELSIF p_report_name = 'JECZAREX' THEN
270: if gv_debug then fnd_file.put_line(fnd_file.log,'Insert JECZAREX Czech Export Tax Report Info'); end if;
271:
272: l_rec_count:=0;
273: FOR r_jgczvat IN c_jgczvat
274: LOOP

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

294: ,r_jgczvat.taxable_amount
295: );
296: END LOOP;
297: ELSIF NVL(p_report_name,'AUDIT-AR') = 'AUDIT-AR' THEN
298: if gv_debug then fnd_file.put_line(fnd_file.log,'Insert AUDIT-AR Info'); end if;
299:
300: l_rec_count:=0;
301: FOR r_jgzzaudar IN c_jgzzaudar
302: LOOP

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

344: ,r_jgzzaudar.tax_amount
345: );
346: END LOOP;
347: END IF;
348: if gv_debug then fnd_file.put_line(fnd_file.log,'Global temp table records check'); end if;
349:
350: OPEN c_count;
351: FETCH c_count INTO p_rec_count;
352: CLOSE c_count;

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

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

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

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

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

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

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

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

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

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

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

445: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of records exceeded the report limit.');
446: RETURN (FALSE);
447:
448: WHEN AMOUNT_LIMIT_REACHED THEN
449: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Amount Overflow, total amount or tax has exceeded the limit.');
450: RETURN (FALSE);
451:
452: WHEN OTHERS THEN
453: 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 453: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in beforeReport trigger of JG_ZZ_AUDIT_AR_PKG package. Error-' || SQLCODE || SUBSTR(SQLERRM,1,200));

449: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Amount Overflow, total amount or tax has exceeded the limit.');
450: RETURN (FALSE);
451:
452: WHEN OTHERS THEN
453: 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: RETURN (FALSE);
455: END;
456:
457: RETURN (TRUE);