DBA Data[Home] [Help]

APPS.IGS_EN_VAL_ENCMB dependencies on IGS_EN_VAL_ENCMB

Line 1: PACKAGE BODY IGS_EN_VAL_ENCMB AS

1: PACKAGE BODY IGS_EN_VAL_ENCMB AS
2: /* $Header: IGSEN37B.pls 120.1 2006/05/18 11:32:31 amuthu noship $ */
3:
4: /*------------------------------------------------------------------------------+
5: | Copyright (c) 1994, 1996 Oracle Corp. Redwood Shores, California, USA |

Line 10: | PL/SQL body for package: IGS_EN_VAL_ENCMB |

6: | All rights reserved. |
7: +==============================================================================+
8: | |
9: | DESCRIPTION |
10: | PL/SQL body for package: IGS_EN_VAL_ENCMB |
11: | |
12: | |
13: | HISTORY |
14: | Who When What |

Line 60: IF IGS_EN_VAL_ENCMB.enrp_val_excld_prsn(

56: p_message_name := null;
57: RETURN TRUE;
58: END IF;
59: --Validate for an exclusion from the university
60: IF IGS_EN_VAL_ENCMB.enrp_val_excld_prsn(
61: p_person_id,
62: p_course_cd,
63: p_effective_dt,
64: p_message_name) = FALSE THEN

Line 96: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_excld_unit');

92: END;
93: EXCEPTION
94: WHEN OTHERS THEN
95: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
96: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_excld_unit');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99:
100:

Line 274: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_excld_prsn');

270: /*
271: EXCEPTION
272: WHEN OTHERS THEN
273: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
274: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_excld_prsn');
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception;
277: */
278: END enrp_val_excld_prsn;

Line 325: IF NOT IGS_EN_VAL_ENCMB.enrp_val_excld_prsn(

321: RETURN TRUE;
322: END IF;
323: -- Validate for an exclusion from the university.
324: -- Invoke existing function to perform this check.
325: IF NOT IGS_EN_VAL_ENCMB.enrp_val_excld_prsn(
326: p_person_id,
327: NULL,
328: p_effective_dt,
329: v_message_name) THEN

Line 383: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_excld_crs');

379: /*
380: EXCEPTION
381: WHEN OTHERS THEN
382: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
383: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_excld_crs');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386:
387: */

Line 434: IF IGS_EN_VAL_ENCMB.enrp_val_excld_prsn(

430: p_message_name := null;
431: RETURN TRUE;
432: END IF;
433: --Validate for an exclusion from the university
434: IF IGS_EN_VAL_ENCMB.enrp_val_excld_prsn(
435: p_person_id,
436: p_course_cd,
437: p_effective_dt,
438: p_message_name) = FALSE THEN

Line 470: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_excld_us');

466: END;
467: EXCEPTION
468: WHEN OTHERS THEN
469: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
470: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_excld_us');
471: IGS_GE_MSG_STACK.ADD;
472: App_Exception.Raise_Exception;
473:
474:

Line 558: IF IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (

554: RETURN TRUE;
555: END IF;
556:
557: -- Validate for an exclusion from the university.
558: IF IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (
559: p_person_id,
560: p_course_cd,
561: p_effective_dt,
562: p_message_name) = FALSE THEN

Line 726: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_rqrd_units');

722: END;
723: EXCEPTION
724: WHEN OTHERS THEN
725: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
726: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_rqrd_units');
727: IGS_GE_MSG_STACK.ADD;
728: App_Exception.Raise_Exception;
729:
730:

Line 792: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,

788: END IF;
789: END IF;
790: -- validate for an exclusion from the university -
791: -- invoke and existing function to perform this check
792: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,
793: p_course_cd,
794: p_effective_dt,
795: p_message_name) = FALSE) THEN
796: RETURN FALSE;

Line 845: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_rstrct_atyp');

841: RETURN TRUE;
842: EXCEPTION
843: WHEN OTHERS THEN
844: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
845: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_rstrct_atyp');
846: IGS_GE_MSG_STACK.ADD;
847: App_Exception.Raise_Exception;
848:
849:

Line 961: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,

957: END IF;
958: END IF;
959: -- validate for an exclusion from the university -
960: -- invoke and existing function to perform this check
961: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,
962: p_course_cd,
963: p_effective_dt,
964: v_message_name) = FALSE) THEN
965: p_message_name := v_message_name;

Line 1068: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_rstrct_cp');

1064: END IF;
1065: EXCEPTION
1066: WHEN OTHERS THEN
1067: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1068: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_rstrct_cp');
1069: IGS_GE_MSG_STACK.ADD;
1070: App_Exception.Raise_Exception;
1071:
1072:

Line 1131: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,

1127: END IF;
1128: END IF;
1129: -- validate for an exclusion from the university -
1130: -- invoke and existing function to perform this check
1131: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,
1132: p_course_cd,
1133: p_effective_dt,
1134: p_message_name) = FALSE) THEN
1135: RETURN FALSE;

Line 1178: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_crsmtrl');

1174: RETURN TRUE;
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1178: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_crsmtrl');
1179: IGS_GE_MSG_STACK.ADD;
1180: App_Exception.Raise_Exception;
1181:
1182:

Line 1241: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,

1237: END IF;
1238: END IF;
1239: -- validate for an exclusion from the university -
1240: -- invoke and existing function to perform this check
1241: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,
1242: p_course_cd,
1243: p_effective_dt,
1244: p_message_name) = FALSE) THEN
1245: RETURN FALSE;

Line 1288: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_grd');

1284: RETURN TRUE;
1285: EXCEPTION
1286: WHEN OTHERS THEN
1287: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1288: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_grd');
1289: IGS_GE_MSG_STACK.ADD;
1290: App_Exception.Raise_Exception;
1291:
1292:

Line 1351: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,

1347: END IF;
1348: END IF;
1349: -- validate for an exclusion from the university -
1350: -- invoke and existing function to perform this check
1351: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,
1352: p_course_cd,
1353: p_effective_dt,
1354: p_message_name) = FALSE) THEN
1355: RETURN FALSE;

Line 1398: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_id_card');

1394: RETURN TRUE;
1395: EXCEPTION
1396: WHEN OTHERS THEN
1397: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1398: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_id_card');
1399: IGS_GE_MSG_STACK.ADD;
1400: App_Exception.Raise_Exception;
1401:
1402:

Line 1462: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,

1458: END IF;
1459: END IF;
1460: -- validate for an exclusion from the university -
1461: -- invoke and existing function to perform this check
1462: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,
1463: p_course_cd,
1464: p_effective_dt,
1465: p_message_name) = FALSE) THEN
1466: RETURN FALSE;

Line 1509: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_inf_bth');

1505: RETURN TRUE;
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1509: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_inf_bth');
1510:
1511: IGS_GE_MSG_STACK.ADD;
1512: App_Exception.Raise_Exception;
1513:

Line 1573: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,

1569: END IF;
1570: END IF;
1571: -- validate for an exclusion from the university -
1572: -- invoke and existing function to perform this check
1573: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,
1574: p_course_cd,
1575: p_effective_dt,
1576: p_message_name) = FALSE) THEN
1577: RETURN FALSE;

Line 1620: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_result');

1616: RETURN TRUE;
1617: EXCEPTION
1618: WHEN OTHERS THEN
1619: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1620: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_result');
1621: IGS_GE_MSG_STACK.ADD;
1622: App_Exception.Raise_Exception;
1623:
1624: END;

Line 1682: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,

1678: END IF;
1679: END IF;
1680: -- validate for an exclusion from the university -
1681: -- invoke and existing function to perform this check
1682: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,
1683: p_course_cd,
1684: p_effective_dt,
1685: p_message_name) = FALSE) THEN
1686: RETURN FALSE;

Line 1729: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_sys_cor');

1725: RETURN TRUE;
1726: EXCEPTION
1727: WHEN OTHERS THEN
1728: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1729: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_sys_cor');
1730: IGS_GE_MSG_STACK.ADD;
1731: App_Exception.Raise_Exception;
1732:
1733:

Line 1792: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,

1788: END IF;
1789: END IF;
1790: -- validate for an exclusion from the university -
1791: -- invoke and existing function to perform this check
1792: IF (IGS_EN_VAL_ENCMB.enrp_val_excld_prsn (p_person_id,
1793: p_course_cd,
1794: p_effective_dt,
1795: p_message_name) = FALSE) THEN
1796: RETURN FALSE;

Line 1839: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_trscrpt');

1835: RETURN TRUE;
1836: EXCEPTION
1837: WHEN OTHERS THEN
1838: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
1839: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_blk_trscrpt');
1840: IGS_GE_MSG_STACK.ADD;
1841: App_Exception.Raise_Exception;
1842:
1843:

Line 1942: IF(IGS_EN_VAL_ENCMB.ENRP_VAL_RSTRCT_CP(

1938: END IF;
1939:
1940: -- call the routine to check whether the student
1941: -- IGS_PS_COURSE attempt has a credit point restriction
1942: IF(IGS_EN_VAL_ENCMB.ENRP_VAL_RSTRCT_CP(
1943: p_person_id,
1944: p_course_cd,
1945: l_effective_dt,
1946: v_rstrct_le_cp_value,

Line 1985: ELSIF(IGS_EN_VAL_ENCMB.ENRP_VAL_RSTRCT_ATYP(

1981: END IF; --NVL(v_period_cp, 0)
1982:
1983: -- call the routine to check whether the student IGS_PS_COURSE
1984: -- attempt has a restricted attendance type
1985: ELSIF(IGS_EN_VAL_ENCMB.ENRP_VAL_RSTRCT_ATYP(
1986: p_person_id,
1987: p_course_cd,
1988: l_effective_dt,
1989: v_restricted_attendance_type,

Line 2022: IF(IGS_EN_VAL_ENCMB.ENRP_VAL_RQRD_UNITS(

2018:
2019: -- check whether there is an outstanding encumbrance
2020: -- for a required IGS_PS_UNIT
2021:
2022: IF(IGS_EN_VAL_ENCMB.ENRP_VAL_RQRD_UNITS(
2023: p_person_id,
2024: p_course_cd,
2025: l_effective_dt,
2026: v_message_name,

Line 2044: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_enr_encmbf 2');

2040: END IF;
2041: EXCEPTION
2042: WHEN OTHERS THEN
2043: Fnd_Message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXP');
2044: FND_MESSAGE.SET_TOKEN('NAME', 'IGS_EN_VAL_ENCMB.enrp_val_enr_encmbf 2');
2045: IGS_GE_MSG_STACK.ADD;
2046: App_Exception.Raise_Exception;
2047: END;
2048: END enrp_val_enr_encmb;

Line 2050: END IGS_EN_VAL_ENCMB;

2046: App_Exception.Raise_Exception;
2047: END;
2048: END enrp_val_enr_encmb;
2049:
2050: END IGS_EN_VAL_ENCMB;