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

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

108:
109: BEGIN
110:
111: if gv_debug_flag then
112: fnd_file.put_line(fnd_file.log, 'Start CMN.funct_curr_legal. pn_vat_rep_entity_id:'||pn_vat_rep_entity_id
113: ||', pv_period_name:'||pv_period_name||', pn_period_year:'||pn_period_year);
114: end if;
115:
116: IF lc_funct_curr_legal%ISOPEN THEN

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

133: CLOSE lc_get_le_id;
134:
135: EXCEPTION
136: WHEN NO_DATA_FOUND THEN
137: FND_FILE.PUT_LINE(FND_FILE.LOG,' No Header Information found in JG table. '|| SUBSTR(SQLERRM,1,200));
138: WHEN OTHERS THEN
139: RAISE;
140: END funct_curr_legal;
141:

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

175:
176: BEGIN
177:
178: if gv_debug_flag then
179: fnd_file.put_line(fnd_file.log, 'Start CMN.tax_registration. pn_vat_rep_entity_id:'||pn_vat_rep_entity_id
180: ||', pv_period_name:'||pv_period_name||', pn_period_year:'||pn_period_year||', pv_source:'||pv_source);
181: end if;
182:
183: IF lc_tax_registration%ISOPEN THEN

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

196: ,pv_period_name
197: ,pv_source); */
198:
199: if gv_debug_flag then
200: fnd_file.put_line(fnd_file.log, 'End CMN.tax_registration. x_tax_registration:'||x_tax_registration
201: ||', x_period_start_date:'||x_period_start_date||', x_period_end_date:'||x_period_end_date);
202: end if;
203:
204: EXCEPTION

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

202: end if;
203:
204: EXCEPTION
205: WHEN NO_DATA_FOUND THEN
206: FND_FILE.PUT_LINE(FND_FILE.LOG,'No TRN Period Details found in JG table.'||SUBSTR(SQLERRM,1,200));
207: WHEN OTHERS THEN
208: RAISE;
209: END tax_registration;
210:

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

331:
332: BEGIN
333:
334: if gv_debug_flag then
335: fnd_file.put_line(fnd_file.log, 'Start CMN.company_detail. pn_legal_entity_id:'||pn_legal_entity_id);
336: end if;
337:
338: -- Added for GLOB-006
339: IF p_vat_reporting_entity_id is null THEN -- NONEMEAVAT REPORT

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

347: AND xetbp.MAIN_ESTABLISHMENT_FLAG = 'Y'
348: AND xetbp.LEGAL_ENTITY_ID = pn_legal_entity_id;
349: EXCEPTION
350: WHEN NO_DATA_FOUND THEN
351: FND_FILE.PUT_LINE(FND_FILE.LOG,'No VAT registration_number found. '||SUBSTR(SQLERRM,1,200));
352: WHEN OTHERS THEN
353: RAISE;
354: END;
355: ELSE -- EMEAVAT REPORT

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

368: )
369: );
370: EXCEPTION
371: WHEN NO_DATA_FOUND THEN
372: FND_FILE.PUT_LINE(FND_FILE.LOG,'No VAT registration_number found. '||SUBSTR(SQLERRM,1,200));
373: WHEN OTHERS THEN
374: RAISE;
375: END;
376: END IF;

Line 412: 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);

408: CLOSE lc_commercial_num;
409:
410:
411: if gv_debug_flag then
412: 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);
413: end if;
414:
415: EXCEPTION
416: WHEN NO_DATA_FOUND THEN

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

413: end if;
414:
415: EXCEPTION
416: WHEN NO_DATA_FOUND THEN
417: FND_FILE.PUT_LINE(FND_FILE.LOG,'No LE Company Information found. '||SUBSTR(SQLERRM,1,200));
418: WHEN OTHERS THEN
419: RAISE;
420: END company_detail;
421:

Line 457: fnd_file.put_line(fnd_file.log,

453:
454: BEGIN
455:
456: if gv_debug_flag then
457: fnd_file.put_line(fnd_file.log,
458: 'Start CMN.get_entities_configuration_dtl. pn_vat_rep_entity_id:'
459: ||p_vat_rep_entity_id
460: );
461: end if;

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

474: ,x_entity_identifier;
475: CLOSE lc_get_entities_config_details;
476:
477: if gv_debug_flag then
478: fnd_file.put_line(fnd_file.log, 'End CMN.get_entities_configuration_dtl. x_calendar_name:'||x_calendar_name
479: ||', x_enable_register_flag:'||x_enable_register_flag||', x_enable_report_seq_flag:'||x_enable_report_seq_flag
480: ||', x_enable_alloc_flag:'||x_enable_alloc_flag||', x_enable_annual_alloc_flag:'||x_enable_annual_alloc_flag
481: ||', x_threshold_amt:'|| x_threshold_amt);
482: end if;

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

482: end if;
483:
484: EXCEPTION
485: WHEN NO_DATA_FOUND THEN
486: FND_FILE.PUT_LINE(FND_FILE.LOG,'This VAT reporting entity does not exists.'||SUBSTR(SQLERRM,1,200));
487: WHEN OTHERS THEN
488: RAISE;
489: END get_entities_configuration_dtl;
490:

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

506: RETURN l_country_code;
507:
508: EXCEPTION
509: WHEN OTHERS THEN
510: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in getting country code'||SUBSTR(SQLERRM,1,200));
511: RETURN NULL;
512: END get_legal_entity_country_code;
513:
514: FUNCTION get_amt_tot (

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

555: RETURN l_amt;
556:
557: EXCEPTION
558: WHEN OTHERS THEN
559: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exception in getting invoice_amount'||SUBSTR(SQLERRM,1,200));
560: Return NULL;
561:
562: END get_amt_tot;
563: