DBA Data[Home] [Help]

APPS.JG_ZZ_COMMON_PKG dependencies on FND_FILE

Line 123: fnd_file.put_line(fnd_file.log, 'Start CMN.funct_curr_legal. pn_vat_rep_entity_id:'||pn_vat_rep_entity_id

119:
120: BEGIN
121:
122: if gv_debug_flag then
123: fnd_file.put_line(fnd_file.log, 'Start CMN.funct_curr_legal. pn_vat_rep_entity_id:'||pn_vat_rep_entity_id
124: ||', pv_period_name:'||pv_period_name||', pn_period_year:'||pn_period_year);
125: end if;
126:
127: IF lc_funct_curr_legal%ISOPEN THEN

Line 148: FND_FILE.PUT_LINE(FND_FILE.LOG,' No Header Information found in JG table. '|| SUBSTR(SQLERRM,1,200));

144: CLOSE lc_get_le_id;
145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: FND_FILE.PUT_LINE(FND_FILE.LOG,' No Header Information found in JG table. '|| SUBSTR(SQLERRM,1,200));
149: WHEN OTHERS THEN
150: RAISE;
151: END funct_curr_legal;
152:

Line 190: fnd_file.put_line(fnd_file.log, 'Start CMN.tax_registration. pn_vat_rep_entity_id:'||pn_vat_rep_entity_id

186:
187: BEGIN
188:
189: if gv_debug_flag then
190: fnd_file.put_line(fnd_file.log, 'Start CMN.tax_registration. pn_vat_rep_entity_id:'||pn_vat_rep_entity_id
191: ||', pv_period_name:'||pv_period_name||', pn_period_year:'||pn_period_year||', pv_source:'||pv_source);
192: end if;
193:
194: IF lc_tax_registration%ISOPEN THEN

Line 211: fnd_file.put_line(fnd_file.log, 'End CMN.tax_registration. x_tax_registration:'||x_tax_registration

207: ,pv_period_name
208: ,pv_source); */
209:
210: if gv_debug_flag then
211: fnd_file.put_line(fnd_file.log, 'End CMN.tax_registration. x_tax_registration:'||x_tax_registration
212: ||', x_period_start_date:'||x_period_start_date||', x_period_end_date:'||x_period_end_date);
213: end if;
214:
215: EXCEPTION

Line 217: FND_FILE.PUT_LINE(FND_FILE.LOG,'No TRN Period Details found in JG table.'||SUBSTR(SQLERRM,1,200));

213: end if;
214:
215: EXCEPTION
216: WHEN NO_DATA_FOUND THEN
217: FND_FILE.PUT_LINE(FND_FILE.LOG,'No TRN Period Details found in JG table.'||SUBSTR(SQLERRM,1,200));
218: WHEN OTHERS THEN
219: RAISE;
220: END tax_registration;
221:

Line 346: fnd_file.put_line(fnd_file.log, 'Start CMN.company_detail. pn_legal_entity_id:'||pn_legal_entity_id);

342:
343: BEGIN
344:
345: if gv_debug_flag then
346: fnd_file.put_line(fnd_file.log, 'Start CMN.company_detail. pn_legal_entity_id:'||pn_legal_entity_id);
347: end if;
348:
349: -- Added for GLOB-006
350: IF p_vat_reporting_entity_id is null THEN -- NONEMEAVAT REPORT

Line 363: FND_FILE.PUT_LINE(FND_FILE.LOG,'No VAT registration_number found. '||SUBSTR(SQLERRM,1,200));

359: AND xetbp.LEGAL_ENTITY_ID = pn_legal_entity_id
360: AND trunc(sysdate) BETWEEN trunc(nvl(xetbp.main_effective_from, sysdate)) AND trunc(nvl(xetbp.main_effective_to, sysdate));
361: EXCEPTION
362: WHEN NO_DATA_FOUND THEN
363: FND_FILE.PUT_LINE(FND_FILE.LOG,'No VAT registration_number found. '||SUBSTR(SQLERRM,1,200));
364: WHEN OTHERS THEN
365: RAISE;
366: END;
367: ELSE -- EMEAVAT REPORT

Line 384: FND_FILE.PUT_LINE(FND_FILE.LOG,'No VAT registration_number found. '||SUBSTR(SQLERRM,1,200));

380: )
381: );
382: EXCEPTION
383: WHEN NO_DATA_FOUND THEN
384: FND_FILE.PUT_LINE(FND_FILE.LOG,'No VAT registration_number found. '||SUBSTR(SQLERRM,1,200));
385: WHEN OTHERS THEN
386: RAISE;
387: END;
388: END IF;

Line 424: fnd_file.put_line(fnd_file.log, 'Start CMN.company_detail. x_company_name:'||x_company_name||', ln_party_id:'||ln_party_id||', x_registration_number:'||x_registration_number);

420: CLOSE lc_commercial_num;
421:
422:
423: if gv_debug_flag then
424: fnd_file.put_line(fnd_file.log, 'Start CMN.company_detail. x_company_name:'||x_company_name||', ln_party_id:'||ln_party_id||', x_registration_number:'||x_registration_number);
425: end if;
426:
427: EXCEPTION
428: WHEN NO_DATA_FOUND THEN

Line 429: FND_FILE.PUT_LINE(FND_FILE.LOG,'No LE Company Information found. '||SUBSTR(SQLERRM,1,200));

425: end if;
426:
427: EXCEPTION
428: WHEN NO_DATA_FOUND THEN
429: FND_FILE.PUT_LINE(FND_FILE.LOG,'No LE Company Information found. '||SUBSTR(SQLERRM,1,200));
430: WHEN OTHERS THEN
431: RAISE;
432: END company_detail;
433:

Line 469: fnd_file.put_line(fnd_file.log,

465:
466: BEGIN
467:
468: if gv_debug_flag then
469: fnd_file.put_line(fnd_file.log,
470: 'Start CMN.get_entities_configuration_dtl. pn_vat_rep_entity_id:'
471: ||p_vat_rep_entity_id
472: );
473: end if;

Line 490: fnd_file.put_line(fnd_file.log, 'End CMN.get_entities_configuration_dtl. x_calendar_name:'||x_calendar_name

486: ,x_entity_identifier;
487: CLOSE lc_get_entities_config_details;
488:
489: if gv_debug_flag then
490: fnd_file.put_line(fnd_file.log, 'End CMN.get_entities_configuration_dtl. x_calendar_name:'||x_calendar_name
491: ||', x_enable_register_flag:'||x_enable_register_flag||', x_enable_report_seq_flag:'||x_enable_report_seq_flag
492: ||', x_enable_alloc_flag:'||x_enable_alloc_flag||', x_enable_annual_alloc_flag:'||x_enable_annual_alloc_flag
493: ||', x_threshold_amt:'|| x_threshold_amt);
494: end if;

Line 498: FND_FILE.PUT_LINE(FND_FILE.LOG,'This VAT reporting entity does not exists.'||SUBSTR(SQLERRM,1,200));

494: end if;
495:
496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN
498: FND_FILE.PUT_LINE(FND_FILE.LOG,'This VAT reporting entity does not exists.'||SUBSTR(SQLERRM,1,200));
499: WHEN OTHERS THEN
500: RAISE;
501: END get_entities_configuration_dtl;
502:

Line 522: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in getting country code'||SUBSTR(SQLERRM,1,200));

518: RETURN l_country_code;
519:
520: EXCEPTION
521: WHEN OTHERS THEN
522: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in getting country code'||SUBSTR(SQLERRM,1,200));
523: RETURN NULL;
524: END get_legal_entity_country_code;
525:
526: FUNCTION get_amt_tot (

Line 571: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in getting invoice_amount'||SUBSTR(SQLERRM,1,200));

567: RETURN l_amt;
568:
569: EXCEPTION
570: WHEN OTHERS THEN
571: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in getting invoice_amount'||SUBSTR(SQLERRM,1,200));
572: Return NULL;
573:
574: END get_amt_tot;
575: