DBA Data[Home] [Help]

APPS.IGC_CC_COMMON_UTILS_PVT dependencies on APP_EXCEPTION

Line 458: APP_EXCEPTION.RAISE_EXCEPTION;

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:
462: /* cc number is stored in the segment1 so get it */

Line 473: APP_EXCEPTION.RAISE_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:
477: /* Get the different status of the CC */

Line 497: APP_EXCEPTION.RAISE_EXCEPTION;

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:
501: /* Check whether the status of the CC is valid to be matched */

Line 520: APP_EXCEPTION.RAISE_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
524: /* Check whether it is the Match button(dist id is NULL) that is pressed or the Distribute button */

Line 548: APP_EXCEPTION.RAISE_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 */
552: BEGIN

Line 564: APP_EXCEPTION.RAISE_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
568: the fiscal year of the invoice stop processing and return false */

Line 596: APP_EXCEPTION.RAISE_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:
600: /* Get the fiscal year for the Payment Forecast Date */

Line 613: APP_EXCEPTION.RAISE_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:
617:

Line 664: APP_EXCEPTION.RAISE_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:
668: BEGIN

Line 680: APP_EXCEPTION.RAISE_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
684: l_status := TRUE;

Line 717: APP_EXCEPTION.RAISE_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
721: SELECT DISTINCT period_year

Line 732: APP_EXCEPTION.RAISE_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:
736: IF (l_fiscal_year_invoice = l_fiscal_year_pf) THEN

Line 768: APP_EXCEPTION.RAISE_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
772: SELECT DISTINCT period_year

Line 783: APP_EXCEPTION.RAISE_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
787: l_status := TRUE;

Line 817: APP_EXCEPTION.RAISE_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;
821:

Line 835: APP_EXCEPTION.RAISE_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
839: SELECT DISTINCT period_year

Line 850: APP_EXCEPTION.RAISE_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
854: l_status := TRUE;