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.JE_ZZ_AUDIT_AP_PKG dependencies on FND_FILE

Line 399: fnd_file.put_line(fnd_file.log,' An error occured while extracting the LE ,Ledger and BSV for entered Reporting Identifier. Error : ' || SUBSTR(SQLERRM, 1, 200));

395: l_period_end_date := l_end_date;
396:
397: EXCEPTION
398: WHEN OTHERS THEN
399: fnd_file.put_line(fnd_file.log,' An error occured while extracting the LE ,Ledger and BSV for entered Reporting Identifier. Error : ' || SUBSTR(SQLERRM, 1, 200));
400: END;
401: END IF;
402:
403: fnd_file.put_line(fnd_file.log,'***Parameters and Locla Variables Values : ');

Line 403: fnd_file.put_line(fnd_file.log,'***Parameters and Locla Variables Values : ');

399: fnd_file.put_line(fnd_file.log,' An error occured while extracting the LE ,Ledger and BSV for entered Reporting Identifier. Error : ' || SUBSTR(SQLERRM, 1, 200));
400: END;
401: END IF;
402:
403: fnd_file.put_line(fnd_file.log,'***Parameters and Locla Variables Values : ');
404: fnd_file.put_line(fnd_file.log,'P_VAT_REPORTING_ENTITY_ID :'||P_VAT_REPORTING_ENTITY_ID );
405: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_ID :'||P_LEGAL_ENTITY_ID );
406: fnd_file.put_line(fnd_file.log,'P_LEDGER_ID :'||P_LEDGER_ID);
407: fnd_file.put_line(fnd_file.log,'P_COMPANY :'||P_COMPANY);

Line 404: fnd_file.put_line(fnd_file.log,'P_VAT_REPORTING_ENTITY_ID :'||P_VAT_REPORTING_ENTITY_ID );

400: END;
401: END IF;
402:
403: fnd_file.put_line(fnd_file.log,'***Parameters and Locla Variables Values : ');
404: fnd_file.put_line(fnd_file.log,'P_VAT_REPORTING_ENTITY_ID :'||P_VAT_REPORTING_ENTITY_ID );
405: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_ID :'||P_LEGAL_ENTITY_ID );
406: fnd_file.put_line(fnd_file.log,'P_LEDGER_ID :'||P_LEDGER_ID);
407: fnd_file.put_line(fnd_file.log,'P_COMPANY :'||P_COMPANY);
408: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);

Line 405: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_ID :'||P_LEGAL_ENTITY_ID );

401: END IF;
402:
403: fnd_file.put_line(fnd_file.log,'***Parameters and Locla Variables Values : ');
404: fnd_file.put_line(fnd_file.log,'P_VAT_REPORTING_ENTITY_ID :'||P_VAT_REPORTING_ENTITY_ID );
405: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_ID :'||P_LEGAL_ENTITY_ID );
406: fnd_file.put_line(fnd_file.log,'P_LEDGER_ID :'||P_LEDGER_ID);
407: fnd_file.put_line(fnd_file.log,'P_COMPANY :'||P_COMPANY);
408: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);
409: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);

Line 406: fnd_file.put_line(fnd_file.log,'P_LEDGER_ID :'||P_LEDGER_ID);

402:
403: fnd_file.put_line(fnd_file.log,'***Parameters and Locla Variables Values : ');
404: fnd_file.put_line(fnd_file.log,'P_VAT_REPORTING_ENTITY_ID :'||P_VAT_REPORTING_ENTITY_ID );
405: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_ID :'||P_LEGAL_ENTITY_ID );
406: fnd_file.put_line(fnd_file.log,'P_LEDGER_ID :'||P_LEDGER_ID);
407: fnd_file.put_line(fnd_file.log,'P_COMPANY :'||P_COMPANY);
408: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);
409: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);
410:

Line 407: fnd_file.put_line(fnd_file.log,'P_COMPANY :'||P_COMPANY);

403: fnd_file.put_line(fnd_file.log,'***Parameters and Locla Variables Values : ');
404: fnd_file.put_line(fnd_file.log,'P_VAT_REPORTING_ENTITY_ID :'||P_VAT_REPORTING_ENTITY_ID );
405: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_ID :'||P_LEGAL_ENTITY_ID );
406: fnd_file.put_line(fnd_file.log,'P_LEDGER_ID :'||P_LEDGER_ID);
407: fnd_file.put_line(fnd_file.log,'P_COMPANY :'||P_COMPANY);
408: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);
409: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);
410:
411: SELECT registration_number,legal_entity_name INTO l_tax_payer_id,l_legal_entity_name

Line 408: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);

404: fnd_file.put_line(fnd_file.log,'P_VAT_REPORTING_ENTITY_ID :'||P_VAT_REPORTING_ENTITY_ID );
405: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_ID :'||P_LEGAL_ENTITY_ID );
406: fnd_file.put_line(fnd_file.log,'P_LEDGER_ID :'||P_LEDGER_ID);
407: fnd_file.put_line(fnd_file.log,'P_COMPANY :'||P_COMPANY);
408: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);
409: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);
410:
411: SELECT registration_number,legal_entity_name INTO l_tax_payer_id,l_legal_entity_name
412: FROM xle_registrations_v

Line 409: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);

405: fnd_file.put_line(fnd_file.log,'P_LEGAL_ENTITY_ID :'||P_LEGAL_ENTITY_ID );
406: fnd_file.put_line(fnd_file.log,'P_LEDGER_ID :'||P_LEDGER_ID);
407: fnd_file.put_line(fnd_file.log,'P_COMPANY :'||P_COMPANY);
408: fnd_file.put_line(fnd_file.log,'l_period_start_date :'||l_period_start_date);
409: fnd_file.put_line(fnd_file.log,'l_period_end_date :'||l_period_end_date);
410:
411: SELECT registration_number,legal_entity_name INTO l_tax_payer_id,l_legal_entity_name
412: FROM xle_registrations_v
413: WHERE legal_entity_id= P_LEGAL_ENTITY_ID

Line 417: fnd_file.put_line(fnd_file.log,'l_tax_payer_id (registration Number) :'||l_tax_payer_id);

413: WHERE legal_entity_id= P_LEGAL_ENTITY_ID
414: and legislative_category= 'INCOME_TAX'
415: and identifying = 'Y';
416:
417: fnd_file.put_line(fnd_file.log,'l_tax_payer_id (registration Number) :'||l_tax_payer_id);
418: fnd_file.put_line(fnd_file.log,'legal_entity_name :'||l_legal_entity_name );
419:
420: G_LE_ID := P_LEGAL_ENTITY_ID;
421:

Line 418: fnd_file.put_line(fnd_file.log,'legal_entity_name :'||l_legal_entity_name );

414: and legislative_category= 'INCOME_TAX'
415: and identifying = 'Y';
416:
417: fnd_file.put_line(fnd_file.log,'l_tax_payer_id (registration Number) :'||l_tax_payer_id);
418: fnd_file.put_line(fnd_file.log,'legal_entity_name :'||l_legal_entity_name );
419:
420: G_LE_ID := P_LEGAL_ENTITY_ID;
421:
422: EXCEPTION

Line 424: fnd_file.put_line(fnd_file.log,' An error occured while extracting the Tax Payer ID for a LE. Error : ' || SUBSTR(SQLERRM, 1, 200));

420: G_LE_ID := P_LEGAL_ENTITY_ID;
421:
422: EXCEPTION
423: WHEN OTHERS THEN
424: fnd_file.put_line(fnd_file.log,' An error occured while extracting the Tax Payer ID for a LE. Error : ' || SUBSTR(SQLERRM, 1, 200));
425:
426: END;
427:
428:

Line 440: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );

436: l_functcurr := c_ledger_info.currency_code;
437: l_func_curr := c_ledger_info.currency_code;
438: END LOOP;
439:
440: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );
441: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );
442: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);
443: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);
444:

Line 441: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );

437: l_func_curr := c_ledger_info.currency_code;
438: END LOOP;
439:
440: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );
441: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );
442: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);
443: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);
444:
445: ELSE

Line 442: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);

438: END LOOP;
439:
440: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );
441: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );
442: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);
443: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);
444:
445: ELSE
446: BEGIN

Line 443: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);

439:
440: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );
441: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );
442: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);
443: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);
444:
445: ELSE
446: BEGIN
447: GL_INFO.gl_get_ledger_info(P_LEDGER_ID,l_coaid,l_ledger_name,l_functcurr,errbuf);

Line 456: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );

452: RAISE INVALID_LEDGER;
453:
454: END IF;
455:
456: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );
457: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );
458: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);
459: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);
460:

Line 457: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );

453:
454: END IF;
455:
456: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );
457: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );
458: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);
459: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);
460:
461: EXCEPTION

Line 458: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);

454: END IF;
455:
456: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );
457: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );
458: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);
459: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);
460:
461: EXCEPTION
462: WHEN INVALID_LEDGER THEN

Line 459: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);

455:
456: fnd_file.put_line(fnd_file.log,'l_ledger_id :'||l_ledger_id );
457: fnd_file.put_line(fnd_file.log,'l_coaid :'||l_coaid );
458: fnd_file.put_line(fnd_file.log,'l_ledger_name :'||l_ledger_name);
459: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);
460:
461: EXCEPTION
462: WHEN INVALID_LEDGER THEN
463: fnd_file.put_line(fnd_file.log,errbuf);

Line 463: fnd_file.put_line(fnd_file.log,errbuf);

459: fnd_file.put_line(fnd_file.log,'l_functcurr :'||l_functcurr);
460:
461: EXCEPTION
462: WHEN INVALID_LEDGER THEN
463: fnd_file.put_line(fnd_file.log,errbuf);
464: END;
465: END IF;
466:
467:

Line 480: fnd_file.put_line(fnd_file.log,'l_start_date :'||l_start_date);

476: l_period_start_date := l_start_date;
477: l_period_end_date := l_end_date;
478: END LOOP;
479:
480: fnd_file.put_line(fnd_file.log,'l_start_date :'||l_start_date);
481: fnd_file.put_line(fnd_file.log,' l_end_date :'|| l_end_date );
482:
483: EXCEPTION
484: WHEN OTHERS THEN

Line 481: fnd_file.put_line(fnd_file.log,' l_end_date :'|| l_end_date );

477: l_period_end_date := l_end_date;
478: END LOOP;
479:
480: fnd_file.put_line(fnd_file.log,'l_start_date :'||l_start_date);
481: fnd_file.put_line(fnd_file.log,' l_end_date :'|| l_end_date );
482:
483: EXCEPTION
484: WHEN OTHERS THEN
485: fnd_file.put_line(fnd_file.log,' An error occured while extracting the period start and end date. Error : ' || SUBSTR(SQLERRM, 1, 200));

Line 485: fnd_file.put_line(fnd_file.log,' An error occured while extracting the period start and end date. Error : ' || SUBSTR(SQLERRM, 1, 200));

481: fnd_file.put_line(fnd_file.log,' l_end_date :'|| l_end_date );
482:
483: EXCEPTION
484: WHEN OTHERS THEN
485: fnd_file.put_line(fnd_file.log,' An error occured while extracting the period start and end date. Error : ' || SUBSTR(SQLERRM, 1, 200));
486: END;
487: END IF;
488:
489:

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

486: END;
487: END IF;
488:
489:
490: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
491: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
492: ,x_registration_number => l_registration_num
493: ,x_country => l_country
494: ,x_address1 => l_address_line_1

Line 508: fnd_file.put_line(fnd_file.log,'Company Information :');

504: ,x_vat_reg_num => l_vat_reg_num
505: ,pn_legal_entity_id => G_LE_ID
506: ,p_vat_reporting_entity_id => P_VAT_REPORTING_ENTITY_ID);
507:
508: fnd_file.put_line(fnd_file.log,'Company Information :');
509: fnd_file.put_line(fnd_file.log,'l_company_name :'||l_company_name);
510: fnd_file.put_line(fnd_file.log,'l_registration_num :'||l_registration_num);
511: fnd_file.put_line(fnd_file.log,'l_country :'||l_country);
512: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'||l_address_line_1);

Line 509: fnd_file.put_line(fnd_file.log,'l_company_name :'||l_company_name);

505: ,pn_legal_entity_id => G_LE_ID
506: ,p_vat_reporting_entity_id => P_VAT_REPORTING_ENTITY_ID);
507:
508: fnd_file.put_line(fnd_file.log,'Company Information :');
509: fnd_file.put_line(fnd_file.log,'l_company_name :'||l_company_name);
510: fnd_file.put_line(fnd_file.log,'l_registration_num :'||l_registration_num);
511: fnd_file.put_line(fnd_file.log,'l_country :'||l_country);
512: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'||l_address_line_1);
513: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'||l_address_line_3);

Line 510: fnd_file.put_line(fnd_file.log,'l_registration_num :'||l_registration_num);

506: ,p_vat_reporting_entity_id => P_VAT_REPORTING_ENTITY_ID);
507:
508: fnd_file.put_line(fnd_file.log,'Company Information :');
509: fnd_file.put_line(fnd_file.log,'l_company_name :'||l_company_name);
510: fnd_file.put_line(fnd_file.log,'l_registration_num :'||l_registration_num);
511: fnd_file.put_line(fnd_file.log,'l_country :'||l_country);
512: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'||l_address_line_1);
513: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'||l_address_line_3);
514: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'||l_address_line_4);

Line 511: fnd_file.put_line(fnd_file.log,'l_country :'||l_country);

507:
508: fnd_file.put_line(fnd_file.log,'Company Information :');
509: fnd_file.put_line(fnd_file.log,'l_company_name :'||l_company_name);
510: fnd_file.put_line(fnd_file.log,'l_registration_num :'||l_registration_num);
511: fnd_file.put_line(fnd_file.log,'l_country :'||l_country);
512: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'||l_address_line_1);
513: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'||l_address_line_3);
514: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'||l_address_line_4);
515: fnd_file.put_line(fnd_file.log,'l_city :'||l_city);

Line 512: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'||l_address_line_1);

508: fnd_file.put_line(fnd_file.log,'Company Information :');
509: fnd_file.put_line(fnd_file.log,'l_company_name :'||l_company_name);
510: fnd_file.put_line(fnd_file.log,'l_registration_num :'||l_registration_num);
511: fnd_file.put_line(fnd_file.log,'l_country :'||l_country);
512: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'||l_address_line_1);
513: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'||l_address_line_3);
514: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'||l_address_line_4);
515: fnd_file.put_line(fnd_file.log,'l_city :'||l_city);
516:

Line 513: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'||l_address_line_3);

509: fnd_file.put_line(fnd_file.log,'l_company_name :'||l_company_name);
510: fnd_file.put_line(fnd_file.log,'l_registration_num :'||l_registration_num);
511: fnd_file.put_line(fnd_file.log,'l_country :'||l_country);
512: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'||l_address_line_1);
513: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'||l_address_line_3);
514: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'||l_address_line_4);
515: fnd_file.put_line(fnd_file.log,'l_city :'||l_city);
516:
517:

Line 514: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'||l_address_line_4);

510: fnd_file.put_line(fnd_file.log,'l_registration_num :'||l_registration_num);
511: fnd_file.put_line(fnd_file.log,'l_country :'||l_country);
512: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'||l_address_line_1);
513: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'||l_address_line_3);
514: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'||l_address_line_4);
515: fnd_file.put_line(fnd_file.log,'l_city :'||l_city);
516:
517:
518:

Line 515: fnd_file.put_line(fnd_file.log,'l_city :'||l_city);

511: fnd_file.put_line(fnd_file.log,'l_country :'||l_country);
512: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'||l_address_line_1);
513: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'||l_address_line_3);
514: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'||l_address_line_4);
515: fnd_file.put_line(fnd_file.log,'l_city :'||l_city);
516:
517:
518:
519:

Line 573: fnd_file.put_line(fnd_file.log,' An error occured while extracting the legal entity information. Error : ' || SUBSTR(SQLERRM, 1, 200));

569: );
570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: fnd_file.put_line(fnd_file.log,' An error occured while extracting the legal entity information. Error : ' || SUBSTR(SQLERRM, 1, 200));
574: END;
575:
576: BEGIN
577:

Line 584: fnd_file.put_line(fnd_file.log,'l_curr_name :'||l_curr_name);

580: l_curr_name := c_curr.name;
581: g_precision := c_curr.precision;
582: END LOOP;
583:
584: fnd_file.put_line(fnd_file.log,'l_curr_name :'||l_curr_name);
585: fnd_file.put_line(fnd_file.log,'g_precision :'||g_precision);
586:
587: G_CURR_NAME := l_curr_name;
588: G_LEDGER_CURR := l_functcurr;

Line 585: fnd_file.put_line(fnd_file.log,'g_precision :'||g_precision);

581: g_precision := c_curr.precision;
582: END LOOP;
583:
584: fnd_file.put_line(fnd_file.log,'l_curr_name :'||l_curr_name);
585: fnd_file.put_line(fnd_file.log,'g_precision :'||g_precision);
586:
587: G_CURR_NAME := l_curr_name;
588: G_LEDGER_CURR := l_functcurr;
589: G_STRUCT_NUM := l_coaid;

Line 593: fnd_file.put_line(fnd_file.log,' An error occured while extracting the currency name and precision. Error : ' || SUBSTR(SQLERRM, 1, 200));

589: G_STRUCT_NUM := l_coaid;
590: G_LEDGER_NAME := l_ledger_name;
591: EXCEPTION
592: WHEN OTHERS THEN
593: fnd_file.put_line(fnd_file.log,' An error occured while extracting the currency name and precision. Error : ' || SUBSTR(SQLERRM, 1, 200));
594: END;
595:
596: BEGIN
597: FOR c_inv_less_tax IN c_inv_less_tax_flag

Line 602: fnd_file.put_line(fnd_file.log,'G_disc_isinvlesstax_flag :'||G_disc_isinvlesstax_flag);

598: LOOP
599: G_disc_isinvlesstax_flag := c_inv_less_tax.disc_is_inv_less_tax_flag;
600: END LOOP;
601:
602: fnd_file.put_line(fnd_file.log,'G_disc_isinvlesstax_flag :'||G_disc_isinvlesstax_flag);
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: fnd_file.put_line(fnd_file.log,' An error occured while extracting the discount invoice less tax flag. Error : ' || SUBSTR(SQLERRM, 1, 200));

Line 606: fnd_file.put_line(fnd_file.log,' An error occured while extracting the discount invoice less tax flag. Error : ' || SUBSTR(SQLERRM, 1, 200));

602: fnd_file.put_line(fnd_file.log,'G_disc_isinvlesstax_flag :'||G_disc_isinvlesstax_flag);
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: fnd_file.put_line(fnd_file.log,' An error occured while extracting the discount invoice less tax flag. Error : ' || SUBSTR(SQLERRM, 1, 200));
607: END;
608:
609: fnd_file.put_line(fnd_file.log,'Calling Main Fucntion ....');
610:

Line 609: fnd_file.put_line(fnd_file.log,'Calling Main Fucntion ....');

605: WHEN OTHERS THEN
606: fnd_file.put_line(fnd_file.log,' An error occured while extracting the discount invoice less tax flag. Error : ' || SUBSTR(SQLERRM, 1, 200));
607: END;
608:
609: fnd_file.put_line(fnd_file.log,'Calling Main Fucntion ....');
610:
611: IF P_CALLING_REPORT = 'JEFRTXDC' THEN
612: BEGIN
613: fnd_file.put_line(fnd_file.log,' P_CALLING_REPORT = JEFRTXDC - Ture ');

Line 613: fnd_file.put_line(fnd_file.log,' P_CALLING_REPORT = JEFRTXDC - Ture ');

609: fnd_file.put_line(fnd_file.log,'Calling Main Fucntion ....');
610:
611: IF P_CALLING_REPORT = 'JEFRTXDC' THEN
612: BEGIN
613: fnd_file.put_line(fnd_file.log,' P_CALLING_REPORT = JEFRTXDC - Ture ');
614:
615: --Query A1
616: --Bug 5337430 : Code added to pick up DEB/M invoices
617: --This logic is based on the following rules:

Line 1323: fnd_file.put_line(fnd_file.log,' An error occured while inserting and updating data to the global tmp table. Error : ' || SUBSTR(SQLERRM, 1, 200));

1319: END LOOP;
1320:
1321: EXCEPTION
1322: WHEN OTHERS THEN
1323: fnd_file.put_line(fnd_file.log,' An error occured while inserting and updating data to the global tmp table. Error : ' || SUBSTR(SQLERRM, 1, 200));
1324: END;
1325:
1326: ELSE
1327: --If calling report is not JEFRTXDC

Line 1432: fnd_file.put_line(fnd_file.log,' An error occured while inserting data into the global tmp table in the generic cursor. Error : ' || SUBSTR(SQLERRM, 1, 200));

1428: END LOOP;
1429:
1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: fnd_file.put_line(fnd_file.log,' An error occured while inserting data into the global tmp table in the generic cursor. Error : ' || SUBSTR(SQLERRM, 1, 200));
1433: END;
1434: END IF;
1435: IF (P_COMPANY IS NOT NULL) THEN
1436:

Line 1442: fnd_file.put_line(fnd_file.log,' An unexpected error occured in the before report trigger. Error : ' || SUBSTR(SQLERRM, 1, 200));

1438:
1439: END IF;
1440: EXCEPTION
1441: WHEN OTHERS THEN
1442: fnd_file.put_line(fnd_file.log,' An unexpected error occured in the before report trigger. Error : ' || SUBSTR(SQLERRM, 1, 200));
1443: RETURN FALSE;
1444: END;
1445: fnd_file.put_line(fnd_file.log,'End of the before report trigger ');
1446:

Line 1445: fnd_file.put_line(fnd_file.log,'End of the before report trigger ');

1441: WHEN OTHERS THEN
1442: fnd_file.put_line(fnd_file.log,' An unexpected error occured in the before report trigger. Error : ' || SUBSTR(SQLERRM, 1, 200));
1443: RETURN FALSE;
1444: END;
1445: fnd_file.put_line(fnd_file.log,'End of the before report trigger ');
1446:
1447: RETURN(TRUE);
1448: END;
1449:

Line 1699: fnd_file.put_line(fnd_file.log,' An error occured while calculating the payment amount. Error : ' || SUBSTR(SQLERRM, 1, 200));

1695:
1696: RETURN(l_total_payment);
1697: EXCEPTION
1698: WHEN OTHERS THEN
1699: fnd_file.put_line(fnd_file.log,' An error occured while calculating the payment amount. Error : ' || SUBSTR(SQLERRM, 1, 200));
1700: END;
1701:
1702: /*
1703: REM +======================================================================+

Line 2012: fnd_file.put_line(fnd_file.log,' An error occured while calculating the amount taxable. Error : ' || SUBSTR(SQLERRM, 1, 200));

2008: RETURN(l_taxable_amount); -- currency format this amount for use.
2009:
2010: EXCEPTION
2011: WHEN OTHERS THEN
2012: fnd_file.put_line(fnd_file.log,' An error occured while calculating the amount taxable. Error : ' || SUBSTR(SQLERRM, 1, 200));
2013: raise_application_error(-20101, NULL);
2014: END;
2015:
2016: END;

Line 2148: fnd_file.put_line(fnd_file.log,' An error occured while calculating the taxable discount amount. Error : ' || SUBSTR(SQLERRM, 1, 200));

2144: END LOOP;
2145:
2146: EXCEPTION
2147: WHEN OTHERS THEN
2148: fnd_file.put_line(fnd_file.log,' An error occured while calculating the taxable discount amount. Error : ' || SUBSTR(SQLERRM, 1, 200));
2149: l_discount_amt := 0;
2150: END;
2151: END IF;
2152:

Line 2410: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Account segment. Error : ' || SUBSTR(SQLERRM,1,200));

2406: CLOSE c_crs;
2407: RETURN l_acc_no;
2408: EXCEPTION
2409: WHEN NO_DATA_FOUND THEN
2410: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Account segment. Error : ' || SUBSTR(SQLERRM,1,200));
2411: RETURN NULL;
2412: END;
2413:
2414: /*

Line 2481: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));

2477:
2478: RETURN l_company;
2479: EXCEPTION
2480: WHEN NO_DATA_FOUND THEN
2481: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));
2482: RETURN NULL;
2483: END;
2484:
2485: /*

Line 2545: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));

2541: CLOSE c_crs;
2542: RETURN l_company;
2543: EXCEPTION
2544: WHEN NO_DATA_FOUND THEN
2545: fnd_file.put_line(fnd_file.log,' No record was returned for the GL_Balancing segment. Error : ' || SUBSTR(SQLERRM,1,200));
2546: RETURN NULL;
2547: END;
2548:
2549: END JE_ZZ_AUDIT_AP_PKG;