[Home] [Help]
1: PACKAGE BODY igs_en_gen_015 AS
2: /* $Header: IGSEN81B.pls 120.13 2006/03/14 00:43:32 smaddali ship $ */
3: --
4: --
5: -- This function is used to get the effective census date which will be used
1619: || Purpose : To Caluculate the Derived Completion Date of a Student Program Attempt
1620: || Known limitations, enhancements or remarks :
1621: || Change History :
1622: || Who When What
1623: || svanukur 10-MAY-2004 added the check to call igs_en_gen_015.enrp_get_eff_load_ci only if
1624: || a history record is found. BUG 3597429
1625: || (reverse chronological order - newest change first)
1626: */
1627:
1715: --
1716:
1717: IF l_load_cal_type IS NULL OR l_load_ci_seq_num IS NULL THEN
1718:
1719: igs_en_gen_015.enrp_get_eff_load_ci (
1720: p_person_id,
1721: p_course_cd,
1722: SYSDATE,
1723: l_acad_cal_type, -- value returned by GET_ACADEMIC_CAL
1788:
1789: --fetch the load calendar details only if a history record is found
1790:
1791: IF l_init_dt IS NOT NULL THEN
1792: igs_en_gen_015.enrp_get_eff_load_ci (
1793: p_person_id,
1794: p_course_cd,
1795: l_init_dt,
1796: l_acad_cal_type, -- value returned by GET_ACADEMIC_CAL
1847:
1848: EXCEPTION
1849: WHEN OTHERS THEN
1850: fnd_message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1851: fnd_message.Set_Token('NAME','IGS_EN_GEN_015.enrf_drv_cmpl_dt');
1852: IGS_GE_MSG_STACK.ADD;
1853: App_Exception.Raise_Exception;
1854:
1855: END enrf_drv_cmpl_dt;
1951:
1952: EXCEPTION
1953: WHEN OTHERS THEN
1954: fnd_message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
1955: fnd_message.Set_Token('NAME','IGS_EN_GEN_015.enrp_get_eff_load_ci');
1956: IGS_GE_MSG_STACK.ADD;
1957: App_Exception.Raise_Exception;
1958:
1959: END enrp_get_eff_load_ci;
1980: --Known limitations/enhancements and/or remarks:
1981: --
1982: --Change History:
1983: --Who When What
1984: --ayedubat 07-JUN-2002 The function call,Igs_En_Gen_015.get_academic_cal is replaced with
1985: -- Igs_En_Gen_002.Enrp_Get_Acad_Alt_Cd to get the academic calendar of the
1986: -- given load calendar rather than current academic calendar for the bug fix:2381603
1987: -- knaraset 27-Feb-2002 Bug- 2245062. This procedure was not considering whether the step is defined or not
1988: -- Modified the procedure to consider Approval status and step defined or not etc.
2049: l_dummy VARCHAR2(200);
2050: PROCEDURE l_call_audit_proc AS
2051: BEGIN
2052: IF p_check_audit = 'Y' THEN
2053: igs_en_gen_015.check_audit_perm_exists(p_cal_type => p_cal_type ,
2054: p_ci_sequence_number => p_ci_sequence_number ,
2055: p_person_id => p_person_id ,
2056: p_program_cd => p_program_cd ,
2057: p_uoo_id => p_uoo_id ,
2215: RETURN;
2216: END IF;
2217: -- check whether the Step is overriden or not
2218: -- if step is overriden then no need to get the special permission from the instructor
2219: IF Igs_En_Gen_015.validation_step_is_overridden ('SPL_PERM',
2220: p_cal_type,
2221: p_ci_sequence_number ,
2222: p_person_id ,
2223: p_uoo_id ,
2479: --
2480:
2481: -- check whether the Step is overriden or not
2482: -- if step is overriden then no need to get the special permission from the instructor
2483: IF Igs_En_Gen_015.validation_step_is_overridden ('AUDIT_PERM',
2484: p_cal_type,
2485: p_ci_sequence_number ,
2486: p_person_id ,
2487: p_uoo_id ,
2586: -- Get the person type
2587: l_person_type := igs_en_gen_008.enrp_get_person_type(p_course_cd);
2588:
2589: -- Get the superior academic calendar instance
2590: igs_en_gen_015.get_academic_cal
2591: (
2592: p_person_id,
2593: p_course_cd,
2594: l_acad_cal_type,
2640: -- If the unit is not a Core Unit, return TRUE. If the unit is a
2641: -- core unit and the unit step DROP_CORE is overridden for the
2642: -- student in context, return TRUE else return FALSE.
2643: IF l_core_indicator_code = 'CORE' THEN
2644: IF igs_en_gen_015.validation_step_is_overridden
2645: (
2646: 'DROP_CORE',
2647: p_term_cal,
2648: p_term_sequence_number,
2825:
2826: EXCEPTION
2827: WHEN OTHERS THEN
2828: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
2829: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_015.GET_CURR_ACAD_TERM_CAL');
2830: IGS_GE_MSG_STACK.ADD;
2831: APP_EXCEPTION.RAISE_EXCEPTION;
2832:
2833: END get_curr_acad_term_cal;
3041:
3042: EXCEPTION
3043: WHEN OTHERS THEN
3044: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
3045: FND_MESSAGE.SET_TOKEN('NAME','IGS_EN_GEN_015.GET_CURR_ACAD_TERM_CAL');
3046: IGS_GE_MSG_STACK.ADD;
3047: APP_EXCEPTION.RAISE_EXCEPTION;
3048:
3049: END get_curr_term_for_schedule;
3350:
3351: EXCEPTION
3352: WHEN OTHERS THEN
3353: fnd_message.Set_Name('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
3354: fnd_message.Set_Token('NAME','IGS_EN_GEN_015.enrp_get_eff_load_ci_poo_chg');
3355: IGS_GE_MSG_STACK.ADD;
3356: App_Exception.Raise_Exception;
3357:
3358: END enrp_get_eff_load_ci_poo_chg;
3358: END enrp_get_eff_load_ci_poo_chg;
3359:
3360:
3361:
3362: END igs_en_gen_015;