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 459: FND_MESSAGE.SET_NAME('SQLAP','AP_DISTS_NO_OPEN_FUT_PERIOD');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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