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.IGC_CC_COMMON_UTILS_PVT dependencies on FND_MESSAGE

Line 457: FND_MESSAGE.SET_NAME('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');

453: );
454: l_gl_date := l_open_gl_date;
455:
456: IF (l_gl_date IS NULL) THEN
457: FND_MESSAGE.SET_NAME('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');
458: APP_EXCEPTION.RAISE_EXCEPTION;
459: END IF;
460: END IF;
461:

Line 470: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

466: FROM po_headers
467: WHERE po_header_id = x_po_header_id;
468: EXCEPTION
469: WHEN OTHERS THEN
470: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
471: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
472: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
473: APP_EXCEPTION.RAISE_EXCEPTION;
474: END;

Line 471: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

467: WHERE po_header_id = x_po_header_id;
468: EXCEPTION
469: WHEN OTHERS THEN
470: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
471: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
472: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
473: APP_EXCEPTION.RAISE_EXCEPTION;
474: END;
475:

Line 472: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

468: EXCEPTION
469: WHEN OTHERS THEN
470: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
471: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
472: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
473: APP_EXCEPTION.RAISE_EXCEPTION;
474: END;
475:
476:

Line 494: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

490: /* No need to check for validation if its a PO, bug # 5687596*/
491: WHEN NO_DATA_FOUND THEN
492: RETURN TRUE;
493: WHEN OTHERS THEN
494: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
495: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
496: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
497: APP_EXCEPTION.RAISE_EXCEPTION;
498: END;

Line 495: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

491: WHEN NO_DATA_FOUND THEN
492: RETURN TRUE;
493: WHEN OTHERS THEN
494: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
495: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
496: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
497: APP_EXCEPTION.RAISE_EXCEPTION;
498: END;
499:

Line 496: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

492: RETURN TRUE;
493: WHEN OTHERS THEN
494: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
495: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
496: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
497: APP_EXCEPTION.RAISE_EXCEPTION;
498: END;
499:
500:

Line 517: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

513: FROM AP_SYSTEM_PARAMETERS)
514: AND l_gl_date BETWEEN START_DATE AND END_DATE;
515: EXCEPTION
516: WHEN OTHERS THEN
517: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
518: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
519: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
520: APP_EXCEPTION.RAISE_EXCEPTION;
521: END;

Line 518: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

514: AND l_gl_date BETWEEN START_DATE AND END_DATE;
515: EXCEPTION
516: WHEN OTHERS THEN
517: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
518: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
519: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
520: APP_EXCEPTION.RAISE_EXCEPTION;
521: END;
522:

Line 519: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

515: EXCEPTION
516: WHEN OTHERS THEN
517: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
518: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
519: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
520: APP_EXCEPTION.RAISE_EXCEPTION;
521: END;
522:
523: IF x_form_name = 'APXINWKB' THEN

Line 545: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

541: AND cc_det_pf_line_num = c_for_each_dist_in_po1.distribution_num;
542:
543: EXCEPTION
544: WHEN OTHERS THEN
545: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
546: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
547: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
548: APP_EXCEPTION.RAISE_EXCEPTION;
549: END;

Line 546: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

542:
543: EXCEPTION
544: WHEN OTHERS THEN
545: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
546: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
547: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
548: APP_EXCEPTION.RAISE_EXCEPTION;
549: END;
550:

Line 547: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

543: EXCEPTION
544: WHEN OTHERS THEN
545: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
546: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
547: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
548: APP_EXCEPTION.RAISE_EXCEPTION;
549: END;
550:
551: /* Get the fiscal year for the Payment Forecast Date */

Line 561: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

557: FROM AP_SYSTEM_PARAMETERS)
558: AND l_CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE;
559: EXCEPTION
560: WHEN OTHERS THEN
561: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
562: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
563: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
564: APP_EXCEPTION.RAISE_EXCEPTION;
565: END;

Line 562: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

558: AND l_CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE;
559: EXCEPTION
560: WHEN OTHERS THEN
561: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
562: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
563: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
564: APP_EXCEPTION.RAISE_EXCEPTION;
565: END;
566:

Line 563: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

559: EXCEPTION
560: WHEN OTHERS THEN
561: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
562: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
563: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
564: APP_EXCEPTION.RAISE_EXCEPTION;
565: END;
566:
567: /* Even if one Payment Forecast Date fiscal year does not match

Line 593: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

589: AND CC_ACCT_LINE_NUM = x_shipment_num)
590: AND CC_DET_PF_LINE_NUM = x_po_dist_num;
591: EXCEPTION
592: WHEN OTHERS THEN
593: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
594: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
595: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
596: APP_EXCEPTION.RAISE_EXCEPTION;
597: END;

Line 594: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

590: AND CC_DET_PF_LINE_NUM = x_po_dist_num;
591: EXCEPTION
592: WHEN OTHERS THEN
593: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
594: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
595: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
596: APP_EXCEPTION.RAISE_EXCEPTION;
597: END;
598:

Line 595: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

591: EXCEPTION
592: WHEN OTHERS THEN
593: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
594: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
595: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
596: APP_EXCEPTION.RAISE_EXCEPTION;
597: END;
598:
599:

Line 610: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

606: FROM AP_SYSTEM_PARAMETERS)
607: AND l_pf_date BETWEEN START_DATE AND END_DATE;
608: EXCEPTION
609: WHEN OTHERS THEN
610: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
611: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
612: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
613: APP_EXCEPTION.RAISE_EXCEPTION;
614: END;

Line 611: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

607: AND l_pf_date BETWEEN START_DATE AND END_DATE;
608: EXCEPTION
609: WHEN OTHERS THEN
610: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
611: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
612: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
613: APP_EXCEPTION.RAISE_EXCEPTION;
614: END;
615:

Line 612: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

608: EXCEPTION
609: WHEN OTHERS THEN
610: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
611: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
612: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
613: APP_EXCEPTION.RAISE_EXCEPTION;
614: END;
615:
616:

Line 661: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

657: WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
658: AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
659: EXCEPTION
660: WHEN OTHERS THEN
661: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
662: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
663: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
664: APP_EXCEPTION.RAISE_EXCEPTION;
665: END;

Line 662: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

658: AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
659: EXCEPTION
660: WHEN OTHERS THEN
661: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
662: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
663: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
664: APP_EXCEPTION.RAISE_EXCEPTION;
665: END;
666:

Line 663: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

659: EXCEPTION
660: WHEN OTHERS THEN
661: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
662: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
663: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
664: APP_EXCEPTION.RAISE_EXCEPTION;
665: END;
666:
667:

Line 677: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

673: FROM AP_SYSTEM_PARAMETERS)
674: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
675: EXCEPTION
676: WHEN OTHERS THEN
677: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
678: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
679: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
680: APP_EXCEPTION.RAISE_EXCEPTION;
681: END;

Line 678: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

674: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
675: EXCEPTION
676: WHEN OTHERS THEN
677: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
678: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
679: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
680: APP_EXCEPTION.RAISE_EXCEPTION;
681: END;
682:

Line 679: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

675: EXCEPTION
676: WHEN OTHERS THEN
677: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
678: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
679: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
680: APP_EXCEPTION.RAISE_EXCEPTION;
681: END;
682:
683: IF (l_fiscal_year_invoice = l_fiscal_year_pf) THEN

Line 714: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

710: WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
711: AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
712: EXCEPTION
713: WHEN OTHERS THEN
714: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
715: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
716: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
717: APP_EXCEPTION.RAISE_EXCEPTION;
718: END;

Line 715: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

711: AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
712: EXCEPTION
713: WHEN OTHERS THEN
714: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
715: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
716: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
717: APP_EXCEPTION.RAISE_EXCEPTION;
718: END;
719:

Line 716: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

712: EXCEPTION
713: WHEN OTHERS THEN
714: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
715: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
716: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
717: APP_EXCEPTION.RAISE_EXCEPTION;
718: END;
719:
720: BEGIN

Line 729: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

725: FROM AP_SYSTEM_PARAMETERS)
726: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
727: EXCEPTION
728: WHEN OTHERS THEN
729: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
730: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
731: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
732: APP_EXCEPTION.RAISE_EXCEPTION;
733: END;

Line 730: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

726: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
727: EXCEPTION
728: WHEN OTHERS THEN
729: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
730: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
731: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
732: APP_EXCEPTION.RAISE_EXCEPTION;
733: END;
734:

Line 731: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

727: EXCEPTION
728: WHEN OTHERS THEN
729: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
730: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
731: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
732: APP_EXCEPTION.RAISE_EXCEPTION;
733: END;
734:
735:

Line 765: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

761: WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
762: AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
763: EXCEPTION
764: WHEN OTHERS THEN
765: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
766: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
767: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
768: APP_EXCEPTION.RAISE_EXCEPTION;
769: END;

Line 766: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

762: AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
763: EXCEPTION
764: WHEN OTHERS THEN
765: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
766: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
767: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
768: APP_EXCEPTION.RAISE_EXCEPTION;
769: END;
770:

Line 767: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

763: EXCEPTION
764: WHEN OTHERS THEN
765: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
766: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
767: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
768: APP_EXCEPTION.RAISE_EXCEPTION;
769: END;
770:
771: BEGIN

Line 780: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

776: FROM AP_SYSTEM_PARAMETERS)
777: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
778: EXCEPTION
779: WHEN OTHERS THEN
780: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
781: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
782: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
783: APP_EXCEPTION.RAISE_EXCEPTION;
784: END;

Line 781: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

777: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
778: EXCEPTION
779: WHEN OTHERS THEN
780: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
781: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
782: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
783: APP_EXCEPTION.RAISE_EXCEPTION;
784: END;
785:

Line 782: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

778: EXCEPTION
779: WHEN OTHERS THEN
780: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
781: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
782: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
783: APP_EXCEPTION.RAISE_EXCEPTION;
784: END;
785:
786: IF (l_fiscal_year_invoice = l_fiscal_year_pf) THEN

Line 814: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

810: FROM po_line_locations
811: WHERE line_location_id = l_line_location_id;
812: EXCEPTION
813: WHEN OTHERS THEN
814: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
815: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
816: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
817: APP_EXCEPTION.RAISE_EXCEPTION;
818: END;

Line 815: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

811: WHERE line_location_id = l_line_location_id;
812: EXCEPTION
813: WHEN OTHERS THEN
814: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
815: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
816: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
817: APP_EXCEPTION.RAISE_EXCEPTION;
818: END;
819:

Line 816: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

812: EXCEPTION
813: WHEN OTHERS THEN
814: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
815: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
816: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
817: APP_EXCEPTION.RAISE_EXCEPTION;
818: END;
819:
820: END IF;

Line 832: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

828: WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
829: AND cc_det_pf_line_num = x_po_dist_num;
830: EXCEPTION
831: WHEN OTHERS THEN
832: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
833: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
834: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
835: APP_EXCEPTION.RAISE_EXCEPTION;
836: END;

Line 833: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

829: AND cc_det_pf_line_num = x_po_dist_num;
830: EXCEPTION
831: WHEN OTHERS THEN
832: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
833: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
834: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
835: APP_EXCEPTION.RAISE_EXCEPTION;
836: END;
837:

Line 834: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

830: EXCEPTION
831: WHEN OTHERS THEN
832: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
833: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
834: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
835: APP_EXCEPTION.RAISE_EXCEPTION;
836: END;
837:
838: BEGIN

Line 847: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');

843: FROM AP_SYSTEM_PARAMETERS)
844: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
845: EXCEPTION
846: WHEN OTHERS THEN
847: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
848: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
849: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
850: APP_EXCEPTION.RAISE_EXCEPTION;
851: END;

Line 848: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);

844: AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
845: EXCEPTION
846: WHEN OTHERS THEN
847: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
848: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
849: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
850: APP_EXCEPTION.RAISE_EXCEPTION;
851: END;
852:

Line 849: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

845: EXCEPTION
846: WHEN OTHERS THEN
847: FND_MESSAGE.SET_NAME('IGC', 'IGC_LOGGING_UNEXP_ERROR');
848: FND_MESSAGE.SET_TOKEN('CODE', SQLCODE);
849: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
850: APP_EXCEPTION.RAISE_EXCEPTION;
851: END;
852:
853: IF (l_fiscal_year_invoice = l_fiscal_year_pf) THEN