[Home] [Help]
1: PACKAGE BODY igs_ad_val_acai_status AS
2: /* $Header: IGSAD24B.pls 120.8 2005/11/25 04:51:02 appldev ship $ */
3: --bug 1956374 msrinivi Removed duplicate func enrp_val_trnsfr_act 27 aug,01
4: -- Validate the IGS_AD_PS_APPL_INST.adm_entry_qual_status.
5: -- hreddych #2602077 SF Integration Added the FUNCTION admp_val_aods_update
20: BEGIN
21: -- Set the default message number
22: p_message_name := NULL;
23: -- Perform item level validations.
24: IF IGS_AD_VAL_ACAI_STATUS.admp_val_aeqs_item (
25: p_adm_entry_qual_status,
26: p_s_admission_process_type,
27: v_message_name) = FALSE THEN
28: p_message_name := v_message_name;
32: -- Get the system status values.
33: v_s_adm_entry_qual_status := IGS_AD_GEN_007.ADMP_GET_SAEQS (p_adm_entry_qual_status);
34: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);
35: -- Validate against the admission outcome status.
36: IF IGS_AD_VAL_ACAI_STATUS.admp_val_aeqs_aos (
37: v_s_adm_entry_qual_status,
38: v_s_adm_outcome_status,
39: v_message_name) = FALSE THEN
40: p_message_name := v_message_name;
46: WHEN OTHERS THEN
47: IF p_message_name <> 'IGS_GE_UNHANDLED_EXP' AND FND_MSG_PUB.Count_Msg < 1 THEN
48: p_message_name := 'IGS_GE_UNHANDLED_EXP';
49: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
50: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aeqs');
51: IGS_GE_MSG_STACK.ADD;
52: END IF;
53: App_Exception.Raise_Exception;
54:
69: BEGIN
70: -- Set the default message number
71: p_message_name := NULL;
72: -- Validate the closed indicator
73: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_aeqs_closed(
74: p_adm_entry_qual_status,
75: v_message_name) THEN
76: p_message_name := v_message_name;
77: RETURN FALSE;
194: EXCEPTION
195: WHEN OTHERS THEN
196: p_message_name := 'IGS_GE_UNHANDLED_EXP';
197: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
198: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aeqs_aos');
199: IGS_GE_MSG_STACK.ADD;
200: App_Exception.Raise_Exception;
201: END admp_val_aeqs_aos;
202: --
219: BEGIN
220: -- Set the default message number
221: p_message_name := NULL;
222: -- Perform item level validations.
223: IF IGS_AD_VAL_ACAI_STATUS.admp_val_ads_item (
224: p_adm_doc_status,
225: p_s_admission_process_type,
226: v_message_name) = FALSE THEN
227: p_message_name := v_message_name;
232: v_s_adm_doc_status := IGS_AD_GEN_007.ADMP_GET_SADS (p_adm_doc_status);
233: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);
234: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS (p_adm_cndtnl_offer_status);
235: -- Validate against the admission outcome status.
236: IF IGS_AD_VAL_ACAI_STATUS.admp_val_ads_aos (
237: v_s_adm_doc_status,
238: v_s_adm_outcome_status,
239: v_s_adm_cndtnl_offer_status,
240: p_cond_offer_doc_allowed,
248: WHEN OTHERS THEN
249: IF p_message_name <> 'IGS_GE_UNHANDLED_EXP' AND FND_MSG_PUB.Count_Msg < 1 THEN
250: p_message_name := 'IGS_GE_UNHANDLED_EXP';
251: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
252: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acai_ads');
253: IGS_GE_MSG_STACK.ADD;
254: END IF;
255: App_Exception.Raise_Exception;
256:
271: BEGIN
272: -- Set the default message number
273: p_message_name := NULL;
274: -- Validate the closed indicator
275: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_ads_closed(
276: p_adm_doc_status,
277: v_message_name) THEN
278: p_message_name := v_message_name;
279: RETURN FALSE;
424: EXCEPTION
425: WHEN OTHERS THEN
426: p_message_name := 'IGS_GE_UNHANDLED_EXP';
427: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
428: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_ads_aos');
429: IGS_GE_MSG_STACK.ADD;
430: App_Exception.Raise_Exception;
431: END admp_val_ads_aos;
432: --
457: BEGIN
458: -- Set the default message number
459: p_message_name := NULL;
460: -- Perform item level validations.
461: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_aods_item (
462: p_person_id,
463: p_admission_appl_number,
464: p_nominated_course_cd,
465: p_acai_sequence_number,
478: p_old_adm_dfrmnt_status);
479: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (
480: p_adm_offer_resp_status);
481: -- Validate against the admission offer response status.
482: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_aods_aors (
483: v_s_adm_offer_dfrmnt_status,
484: v_old_s_adm_dfrmnt_status,
485: v_s_adm_offer_resp_status,
486: v_message_name) THEN
492: END;
493: EXCEPTION
494: WHEN OTHERS THEN
495: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
496: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aods');
497: IGS_GE_MSG_STACK.ADD;
498: App_Exception.Raise_Exception;
499: END admp_val_acai_aods;
500: --
540: BEGIN
541: -- Set the default message number
542: p_message_name := NULL;
543: -- Validate the closed indicator.
544: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_aods_closed (
545: p_adm_offer_dfrmnt_status,
546: v_message_name) THEN
547: p_message_name := v_message_name;
548: RETURN FALSE;
597: END;
598: EXCEPTION
599: WHEN OTHERS THEN
600: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
601: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aods_item');
602: IGS_GE_MSG_STACK.ADD;
603: App_Exception.Raise_Exception;
604: END admp_val_aods_item;
605: --
640: END;
641: EXCEPTION
642: WHEN OTHERS THEN
643: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
644: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aods_closed');
645: IGS_GE_MSG_STACK.ADD;
646: App_Exception.Raise_Exception;
647: END admp_val_aods_closed;
648: --
704: END;
705: EXCEPTION
706: WHEN OTHERS THEN
707: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
708: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aods_aors');
709: IGS_GE_MSG_STACK.ADD;
710: App_Exception.Raise_Exception;
711: END admp_val_aods_aors;
712: --
741: BEGIN
742: -- Set the default message number
743: p_message_name := NULL;
744: -- Perform item level validations.
745: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_lafs_item (
746: p_late_adm_fee_status,
747: p_late_appl_allowed,
748: v_message_name) THEN
749: p_message_name := v_message_name;
751: END IF;
752: v_s_late_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS (
753: p_late_adm_fee_status);
754: -- Validate against the course offering option details.
755: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_lafs_coo (
756: v_s_late_adm_fee_status,
757: p_late_appl_allowed,
758: p_late_fees_required,
759: p_appl_dt,
775: p_adm_outcome_status);
776: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS (
777: p_adm_cndtnl_offer_status);
778: -- Validate against the admission outcome status.
779: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_lafs_aos (
780: v_s_late_adm_fee_status,
781: v_s_adm_outcome_status,
782: v_s_adm_cndtnl_offer_status,
783: p_cond_offer_fee_allowed,
790: END;
791: EXCEPTION
792: WHEN OTHERS THEN
793: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
794: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acai_lafs');
795: IGS_GE_MSG_STACK.ADD;
796: App_Exception.Raise_Exception;
797: END admp_val_acai_lafs;
798: --
815: BEGIN
816: -- Set the default message number
817: p_message_name := NULL;
818: -- Validate the closed indicator
819: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_afs_closed (
820: p_late_adm_fee_status,
821: v_message_name) THEN
822: p_message_name := v_message_name;
823: RETURN FALSE;
838: END;
839: EXCEPTION
840: WHEN OTHERS THEN
841: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
842: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_lafs_item');
843: IGS_GE_MSG_STACK.ADD;
844: App_Exception.Raise_Exception;
845: END admp_val_lafs_item;
846: --
876: END;
877: EXCEPTION
878: WHEN OTHERS THEN
879: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
880: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_afs_closed');
881: IGS_GE_MSG_STACK.ADD;
882: App_Exception.Raise_Exception;
883: END admp_val_afs_closed;
884: --
939: (p_attendance_type IS NULL OR
940: v_coo_rec.attendance_type = p_attendance_type) THEN
941: v_coo_match := TRUE;
942: -- Check if the app[lication is late.
943: IF IGS_AD_VAL_ACAI.admp_val_acai_late(
944: p_appl_dt,
945: p_course_cd,
946: p_crv_version_number,
947: p_acad_cal_type,
986: END;
987: EXCEPTION
988: WHEN OTHERS THEN
989: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
990: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_lafs_coo');
991: IGS_GE_MSG_STACK.ADD;
992: App_Exception.Raise_Exception;
993: END admp_val_lafs_coo;
994: --
1050: END;
1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1054: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_lafs_aos');
1055: IGS_GE_MSG_STACK.ADD;
1056: App_Exception.Raise_Exception;
1057: END admp_val_lafs_aos;
1058: --
1107: -- Set the default message number
1108: p_message_name := NULL;
1109: IF (p_called_from IN (cst_form, cst_trg_br)) THEN
1110: -- Perform item level validations.
1111: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_aors_item (
1112: p_person_id,
1113: p_admission_appl_number,
1114: p_nominated_course_cd,
1115: p_acai_sequence_number,
1144: END IF;
1145:
1146:
1147: -- Validate against the admission outcome status.
1148: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_aors_aos (
1149: v_s_adm_offer_resp_status,
1150: v_old_s_adm_offer_resp_status,
1151: v_s_adm_outcome_status,
1152: p_adm_outcome_status_auth_dt,
1158: p_adm_offer_dfrmnt_status);
1159: v_old_s_adm_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS (
1160: p_old_adm_offer_dfrmnt_status);
1161: -- Validate against the admission offer deferment status.
1162: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_aods_aors (
1163: v_s_adm_offer_dfrmnt_status,
1164: v_old_s_adm_dfrmnt_status,
1165: v_s_adm_offer_resp_status,
1166: v_message_name) THEN
1186: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS (p_adm_outcome_status);
1187: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS (p_adm_offer_resp_status);
1188: END IF;
1189: -- Validate multiple offers.
1190: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_offer_mult (
1191: p_person_id,
1192: p_admission_appl_number,
1193: p_nominated_course_cd,
1194: p_acai_sequence_number,
1209: END;
1210: EXCEPTION
1211: WHEN OTHERS THEN
1212: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1213: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aors');
1214: IGS_GE_MSG_STACK.ADD;
1215: App_Exception.Raise_Exception;
1216: END admp_val_acai_aors;
1217: --
1287: BEGIN
1288: -- Set the default message number
1289: p_message_name := NULL;
1290: -- Validate the closed indicator.
1291: IF IGS_AD_VAL_ACAI_STATUS.admp_val_aors_closed (
1292: p_adm_offer_resp_status,
1293: v_message_name) = FALSE THEN
1294: p_message_name := v_message_name;
1295: RETURN FALSE;
1407: END;
1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1411: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aors_item');
1412: IGS_GE_MSG_STACK.ADD;
1413: App_Exception.Raise_Exception;
1414: END admp_val_aors_item;
1415: --
1441: RETURN TRUE;
1442: EXCEPTION
1443: WHEN OTHERS THEN
1444: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1445: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aors_closed');
1446: IGS_GE_MSG_STACK.ADD;
1447: App_Exception.Raise_Exception;
1448: END;
1449: END admp_val_aors_closed;
1533: END;
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1537: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aors_aos');
1538: IGS_GE_MSG_STACK.ADD;
1539: App_Exception.Raise_Exception;
1540: END admp_val_aors_aos;
1541: --
1609: IF (p_called_from IN (
1610: cst_form,
1611: cst_trg_br)) THEN
1612: -- Perform item level validations
1613: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_aos_item(
1614: p_adm_outcome_status,
1615: p_old_adm_outcome_status,
1616: p_adm_fee_status,
1617: p_set_outcome_allowed,
1632: v_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_adm_fee_status);
1633: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(p_late_adm_fee_status);
1634: -- Validate against the other admission course
1635: -- application instance status values
1636: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_aos_status(
1637: v_s_adm_outcome_status,
1638: v_old_s_adm_outcome_status,
1639: v_s_adm_doc_status,
1640: v_s_adm_fee_status,
1650: END IF;
1651: v_s_adm_entry_qual_status := IGS_AD_GEN_007.ADMP_GET_SAEQS(p_adm_entry_qual_status);
1652: -- Validate the admission outcome status against
1653: -- the admission entry qualification status
1654: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_aeqs_aos(
1655: v_s_adm_entry_qual_status,
1656: v_s_adm_outcome_status,
1657: v_message_name) = FALSE) THEN
1658: p_message_name := v_message_name;
1660: END IF;
1661: v_s_adm_cndtnl_offer_status := IGS_AD_GEN_007.ADMP_GET_SACOS(p_adm_cndtnl_offer_status);
1662: -- Validate the admission outcome status
1663: -- against the admission documentation status
1664: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_ads_aos(
1665: v_s_adm_doc_status,
1666: v_s_adm_outcome_status,
1667: v_s_adm_cndtnl_offer_status,
1668: p_cond_offer_doc_allowed,
1671: RETURN FALSE;
1672: END IF;
1673: -- Validate the admission outcome status
1674: -- against the late admission fee status
1675: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_lafs_aos(
1676: v_late_s_adm_fee_status,
1677: v_s_adm_outcome_status,
1678: v_s_adm_cndtnl_offer_status,
1679: p_cond_offer_fee_allowed,
1684: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status);
1685: v_old_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_old_adm_offer_resp_status);
1686: -- Validate the admission outcome status against
1687: -- the admission offer response status
1688: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_aors_aos(
1689: v_s_adm_offer_resp_status,
1690: v_old_s_adm_offer_resp_status,
1691: v_s_adm_outcome_status,
1692: p_adm_outcome_status_auth_dt,
1705: v_s_adm_outcome_status := IGS_AD_GEN_008.ADMP_GET_SAOS(p_adm_outcome_status);
1706: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(p_adm_offer_resp_status);
1707: END IF;
1708: -- Validate the admission course application instance outcome
1709: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_acai_otcome(
1710: p_person_id,
1711: p_admission_appl_number,
1712: p_nominated_course_cd,
1713: p_acai_sequence_number,
1740: p_message_name := v_message_name;
1741: RETURN FALSE;
1742: END IF;
1743: -- Validate multiple offers
1744: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_offer_mult(
1745: p_person_id,
1746: p_admission_appl_number,
1747: p_nominated_course_cd,
1748: p_acai_sequence_number,
1765: END;
1766: EXCEPTION
1767: WHEN OTHERS THEN
1768: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1769: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aos');
1770: IGS_GE_MSG_STACK.ADD;
1771: App_Exception.Raise_Exception;
1772: END admp_val_acai_aos;
1773: --
1840: c_sap_rec c_sap%ROWTYPE;
1841: BEGIN
1842: p_message_name := NULL;
1843: -- Validate the closed indicator
1844: IF(IGS_AD_VAL_ACAI_STATUS.admp_val_aos_closed (
1845: p_adm_outcome_status,
1846: v_message_name) = FALSE) THEN
1847: p_message_name := v_message_name;
1848: RETURN FALSE;
1928: END;
1929: EXCEPTION
1930: WHEN OTHERS THEN
1931: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1932: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aos_item'|| SQLERRM);
1933: IGS_GE_MSG_STACK.ADD;
1934: App_Exception.Raise_Exception;
1935: END admp_val_aos_item;
1936: --
1962: RETURN TRUE;
1963: EXCEPTION
1964: WHEN OTHERS THEN
1965: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1966: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aos_closed');
1967: IGS_GE_MSG_STACK.ADD;
1968: App_Exception.Raise_Exception;
1969: END;
1970: END admp_val_aos_closed;
2046: END;
2047: EXCEPTION
2048: WHEN OTHERS THEN
2049: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2050: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aos_status');
2051: IGS_GE_MSG_STACK.ADD;
2052: App_Exception.Raise_Exception;
2053: END admp_val_aos_status;
2054: --
2291: END;
2292: EXCEPTION
2293: WHEN OTHERS THEN
2294: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2295: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admpl_chk_res_or_def');
2296: IGS_GE_MSG_STACK.ADD;
2297: App_Exception.Raise_Exception;
2298: END admpl_chk_res_or_def;
2299: --------------------------------------------------MAIN-------------------------
2390: -- p_adm_cal_type,
2391: -- p_adm_ci_sequence_number);
2392: v_effective_dt := TRUNC(SYSDATE);
2393: -- Perform complete check.
2394: IF NOT IGS_AD_VAL_ACAI.admp_val_offer_comp(
2395: p_person_id,
2396: p_admission_appl_number,
2397: p_nominated_course_cd,
2398: p_acai_sequence_number,
2428: -- applicant course
2429: -- is encumbered.
2430: -----------------------------------------------------------------------------
2431: IF p_check_course_encumb = 'Y' THEN
2432: IF NOT IGS_AD_VAL_ACAI.admp_val_acai_encmb(
2433: p_person_id,
2434: p_course_cd,
2435: p_adm_cal_type,
2436: p_adm_ci_sequence_number,
2456: END IF;
2457: -----------------------------------------------------------------------------
2458: -- Cannot make an offer if the course offering option is not valid.
2459: -----------------------------------------------------------------------------
2460: IF NOT IGS_AD_VAL_ACAI.admp_val_acai_cop (
2461: p_course_cd,
2462: p_crv_version_number,
2463: p_location_cd,
2464: p_attendance_mode,
2491: -----------------------------------------------------------------------------
2492: -- Cannot make an offer if the course is not valid against existing student
2493: -- course attempts.
2494: -----------------------------------------------------------------------------
2495: IF NOT IGS_AD_VAL_ACAI.admp_val_aca_sca (
2496: p_person_id,
2497: p_course_cd,
2498: p_appl_dt,
2499: p_admission_cat,
2512: -- Cannot make offer if IGS_PS_UNIT set is applicable for the admission application
2513: -- and the IGS_PS_UNIT set is invalid.
2514: -----------------------------------------------------------------------------
2515: IF p_unit_set_appl = 'Y' THEN
2516: IF NOT IGS_AD_VAL_ACAI.admp_val_acai_us (
2517: p_unit_set_cd,
2518: p_us_version_number,
2519: p_course_cd,
2520: p_crv_version_number,
2536: -- set is applicable for the application and the applicant IGS_PS_UNIT set is
2537: -- encumbered.
2538: ----------------------------------------------------------------------------
2539: IF p_check_course_encumb = 'Y' THEN
2540: IF NOT IGS_AD_VAL_ACAI.admp_val_us_encmb (
2541: p_person_id,
2542: p_course_cd,
2543: p_unit_set_cd,
2544: p_us_version_number,
2645: END;
2646: EXCEPTION
2647: WHEN OTHERS THEN
2648: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2649: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acai_otcome');
2650: IGS_GE_MSG_STACK.ADD;
2651: App_Exception.Raise_Exception;
2652: END admp_val_acai_otcome;
2653: --
2781: END;
2782: EXCEPTION
2783: WHEN OTHERS THEN
2784: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2785: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_offer_mult');
2786: IGS_GE_MSG_STACK.ADD;
2787: App_Exception.Raise_Exception;
2788: END admp_val_offer_mult;
2789: --
2878: END;
2879: EXCEPTION
2880: WHEN OTHERS THEN
2881: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2882: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_offer_x_apc');
2883: IGS_GE_MSG_STACK.ADD;
2884: App_Exception.Raise_Exception;
2885: END admp_val_offer_x_apc;
2886: --
2944: END;
2945: EXCEPTION
2946: WHEN OTHERS THEN
2947: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
2948: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aos_update');
2949: IGS_GE_MSG_STACK.ADD;
2950: App_Exception.Raise_Exception;
2951: END admp_val_aos_update;
2952: --
2977: BEGIN
2978: --set the default message number
2979: p_message_name := NULL;
2980: --Perform item level validations.
2981: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_acos_item (
2982: p_adm_cndtnl_offer_status,
2983: p_adm_fee_status,
2984: p_fees_required,
2985: p_cond_offer_assess_allowed,
3000: v_late_s_adm_fee_status := IGS_AD_GEN_008.ADMP_GET_SAFS(
3001: p_late_adm_fee_status);
3002: --Validate against the other admission course application instance status
3003: -- values.
3004: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_acos_status (
3005: v_s_adm_cndtnl_offer_status,
3006: v_old_s_adm_cndtnl_offer_stat,
3007: v_s_adm_outcome_status,
3008: v_s_adm_doc_status,
3016: END;
3017: EXCEPTION
3018: WHEN OTHERS THEN
3019: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3020: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acai_acos');
3021: IGS_GE_MSG_STACK.ADD;
3022: App_Exception.Raise_Exception;
3023: END admp_val_acai_acos;
3024: --
3046: BEGIN
3047: --set the default message number
3048: p_message_name := NULL;
3049: --validate the closed indicator
3050: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_acos_closed (
3051: p_adm_cndtnl_offer_status,
3052: v_message_name) = FALSE) THEN
3053: p_message_name := v_message_name;
3054: RETURN FALSE;
3081: END;
3082: EXCEPTION
3083: WHEN OTHERS THEN
3084: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3085: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acos_item');
3086: IGS_GE_MSG_STACK.ADD;
3087: App_Exception.Raise_Exception;
3088: END admp_val_acos_item;
3089: --
3124: END;
3125: EXCEPTION
3126: WHEN OTHERS THEN
3127: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3128: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acos_closed');
3129: IGS_GE_MSG_STACK.ADD;
3130: App_Exception.Raise_Exception;
3131: END admp_val_acos_closed;
3132: --
3218: END;
3219: EXCEPTION
3220: WHEN OTHERS THEN
3221: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3222: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acos_status');
3223: IGS_GE_MSG_STACK.ADD;
3224: App_Exception.Raise_Exception;
3225: END admp_val_acos_status;
3226:
3274: END ;
3275: EXCEPTION
3276: WHEN OTHERS THEN
3277: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3278: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_aods_update');
3279: IGS_GE_MSG_STACK.ADD;
3280: App_Exception.Raise_Exception;
3281: END admp_val_aods_update;
3282:
3297: BEGIN
3298: -- Set the default message number
3299: p_message_name := NULL;
3300: -- Perform item level validations.
3301: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_ais_item (
3302: p_appl_inst_status,
3303: p_ais_reason,
3304: v_message_name) THEN
3305: p_message_name := v_message_name;
3316: END IF;
3317:
3318:
3319: -- Validate against the admission outcome status
3320: IF NOT IGS_AD_VAL_ACAI_STATUS.admp_val_ais_aos (
3321: v_s_appl_inst_status,
3322: v_s_adm_outcome_status,
3323: v_message_name) THEN
3324: p_message_name := v_message_name;
3329: END;
3330: EXCEPTION
3331: WHEN OTHERS THEN
3332: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3333: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_acai_ais');
3334: IGS_GE_MSG_STACK.ADD;
3335: App_Exception.Raise_Exception;
3336: END admp_val_acai_ais;
3337:
3353: BEGIN
3354: -- Set the default message number
3355: p_message_name := NULL;
3356: -- Validate the closed indicator.
3357: IF (IGS_AD_VAL_ACAI_STATUS.admp_val_ais_closed (
3358: p_appl_inst_status,
3359: v_message_name)=FALSE) THEN
3360: p_message_name := v_message_name;
3361: RETURN FALSE;
3366:
3367: EXCEPTION
3368: WHEN OTHERS THEN
3369: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3370: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_ais_item');
3371: IGS_GE_MSG_STACK.ADD;
3372: App_Exception.Raise_Exception;
3373: END admp_val_ais_item;
3374:
3399: RETURN TRUE;
3400: EXCEPTION
3401: WHEN OTHERS THEN
3402: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3403: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_ais_closed');
3404: IGS_GE_MSG_STACK.ADD;
3405: App_Exception.Raise_Exception;
3406: END admp_val_ais_closed;
3407:
3427:
3428: EXCEPTION
3429: WHEN OTHERS THEN
3430: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
3431: Fnd_Message.Set_Token('NAME','IGS_AD_VAL_ACAI_STATUS.admp_val_ais_aos');
3432: IGS_GE_MSG_STACK.ADD;
3433: App_Exception.Raise_Exception;
3434: END admp_val_ais_aos;
3435:
3432: IGS_GE_MSG_STACK.ADD;
3433: App_Exception.Raise_Exception;
3434: END admp_val_ais_aos;
3435:
3436: END igs_ad_val_acai_status;