[Home] [Help]
1: PACKAGE BODY igs_pr_gen_005 AS
2: /* $Header: IGSPR26B.pls 120.0 2005/07/05 12:13:31 appldev noship $ */
3: FUNCTION igs_pr_clc_apl_expry (
4: p_course_cd IN VARCHAR2,
5: p_version_number IN NUMBER,
24: v_stream_number igs_pr_s_prg_cal.stream_num%TYPE;
25: v_show_cause_length igs_pr_s_prg_cal.show_cause_length%TYPE;
26: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
27: BEGIN
28: IF igs_pr_gen_005.igs_pr_get_appeal_alwd (
29: p_progression_rule_cat,
30: p_pra_sequence_number,
31: p_sequence_number,
32: p_course_cd,
48: IF v_level IS NULL THEN
49: RETURN NULL;
50: ELSE
51: v_expiry_dt := TRUNC (SYSDATE) + NVL (v_appeal_length, 0);
52: v_cutoff_dt := igs_pr_gen_005.igs_pr_get_prg_dai (
53: p_course_cd,
54: p_version_number,
55: p_prg_cal_type,
56: p_prg_sequence_number,
69: END;
70: EXCEPTION
71: WHEN OTHERS THEN
72: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
73: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_CLC_APL_EXPRY');
74: igs_ge_msg_stack.ADD;
75: app_exception.raise_exception;
76: END igs_pr_clc_apl_expry;
77:
99: v_appeal_length igs_pr_s_prg_cal.appeal_length%TYPE;
100: v_expiry_dt DATE;
101: v_cutoff_dt DATE;
102: BEGIN
103: IF igs_pr_gen_005.igs_pr_get_cause_alwd (
104: p_progression_rule_cat,
105: p_pra_sequence_number,
106: p_sequence_number,
107: p_course_cd,
124: -- Could not determine from configuration structure
125: RETURN NULL;
126: ELSE
127: v_expiry_dt := TRUNC (SYSDATE) + NVL (v_show_cause_length, 0);
128: v_cutoff_dt := igs_pr_gen_005.igs_pr_get_prg_dai (
129: p_course_cd,
130: p_version_number,
131: p_prg_cal_type,
132: p_prg_sequence_number,
145: END;
146: EXCEPTION
147: WHEN OTHERS THEN
148: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
149: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_CLC_CAUSE_EXPRY');
150: igs_ge_msg_stack.ADD;
151: app_exception.raise_exception;
152: END igs_pr_clc_cause_expry;
153:
386: END;
387: EXCEPTION
388: WHEN OTHERS THEN
389: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
390: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_CLC_STDNT_COMP');
391: igs_ge_msg_stack.ADD;
392: app_exception.raise_exception;
393: END igs_pr_clc_stdnt_comp;
394:
467: END;
468: EXCEPTION
469: WHEN OTHERS THEN
470: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
471: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_APPEAL_ALWD');
472: igs_ge_msg_stack.ADD;
473: app_exception.raise_exception;
474: END igs_pr_get_appeal_alwd;
475:
548: END;
549: EXCEPTION
550: WHEN OTHERS THEN
551: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
552: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_CAUSE_ALWD');
553: igs_ge_msg_stack.ADD;
554: app_exception.raise_exception;
555: END igs_pr_get_cause_alwd;
556:
642: END;
643: EXCEPTION
644: WHEN OTHERS THEN
645: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
646: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_NUM_FAIL');
647: igs_ge_msg_stack.ADD;
648: app_exception.raise_exception;
649: END igs_pr_get_num_fail;
650:
748: END;
749: EXCEPTION
750: WHEN OTHERS THEN
751: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
752: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_PRG_DAI');
753: igs_ge_msg_stack.ADD;
754: app_exception.raise_exception;
755: END igs_pr_get_prg_dai;
756:
813: END;
814: EXCEPTION
815: WHEN OTHERS THEN
816: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
817: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_PRG_PEN_END');
818: igs_ge_msg_stack.ADD;
819: app_exception.raise_exception;
820: END igs_pr_get_prg_pen_end;
821:
957: END;
958: EXCEPTION
959: WHEN OTHERS THEN
960: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
961: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_PRG_STATUS.PRGPL_COURSE_MATCH');
962: igs_ge_msg_stack.ADD;
963: app_exception.raise_exception;
964: END prgpl_course_match;
965:
1014: END;
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1018: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_PRG_STATUS.PRGPL_COURSE_GROUP_MATCH');
1019: igs_ge_msg_stack.ADD;
1020: app_exception.raise_exception;
1021: END prgpl_course_group_match;
1022:
1094: END;
1095: EXCEPTION
1096: WHEN OTHERS THEN
1097: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1098: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_PRG_STATUS.PRGPL_DETERMINE_OUTCOME_LEVEL');
1099: igs_ge_msg_stack.ADD;
1100: app_exception.raise_exception;
1101: END prgpl_determine_outcome_level;
1102: BEGIN -- IGS_PR_get_prg_status
1157: END;
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1161: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_PRG_STATUS');
1162: igs_ge_msg_stack.ADD;
1163: app_exception.raise_exception;
1164: END igs_pr_get_prg_status;
1165:
1200: END;
1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1204: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_SCA_APPEAL');
1205: igs_ge_msg_stack.ADD;
1206: app_exception.raise_exception;
1207: END igs_pr_get_sca_appeal;
1208:
1389: END;
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1393: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_SCA_APPL');
1394: igs_ge_msg_stack.ADD;
1395: app_exception.raise_exception;
1396: END igs_pr_get_sca_appl;
1397:
1490: END;
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1494: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_SCA_CMT');
1495: igs_ge_msg_stack.ADD;
1496: app_exception.raise_exception;
1497: END igs_pr_get_sca_cmt;
1498:
1653: END;
1654: EXCEPTION
1655: WHEN OTHERS THEN
1656: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
1657: fnd_message.set_token ('NAME', 'IGS_PR_GEN_005.IGS_PR_GET_SCA_STATE');
1658: igs_ge_msg_stack.ADD;
1659: app_exception.raise_exception;
1660: END igs_pr_get_sca_state;
1661:
1711: END IF;
1712: RAISE;
1713: END;
1714: END igs_pr_get_scpm_value;
1715: END igs_pr_gen_005;