[Home] [Help]
473: -- FALSE and the messages type is DENY
474: -- At the end if the messages is not null then type is
475: -- being set as WARN
476: --svanukur 04-dec-2003 Passing the load calendar details to the procedure
477: -- IGS_EN_VAL_ENCMB.enrp_val_enr_encmb as part of holds bug 3227399
478: --stutta 11-Feb-2004 Added new parameter p_enrolled_dt, passing the same to
479: -- enrol_cart_unit
480: -------------------------------------------------------------------------------------
481:
657: lv_message_name := NULL;
658: lv_message_name2 :=NULL;
659:
660:
661: IF IGS_EN_VAL_ENCMB.enrp_val_enr_encmb(p_person_id,
662: p_program_cd ,
663: p_load_cal_type,
664: p_load_ci_sequence_number,
665: lv_message_name,
973: ayedubat 3-JUL-2002 1.Changed the dynamic sql creation of the cursor,c_ref_cur_inst to conside the 'WAITLISTED' unit attempt status
974: 2.Added a validation to check the existence of records in the table,lData before
975: looping through the records while doing the prereq validations for the bug fix:2443876
976: svanukur 04-dec-2003 Passing the load calendar details to the procedure
977: IGS_EN_VAL_ENCMB.enrp_val_enr_encmb as part of holds bug 3227399
978: ptandon 16-Feb-2004 Added Exception handling section and handled the exception NO_AUSL_RECORD_FOUND to
979: return a meaningful error message. Bug# 3418087.
980: stutta 16-Nov-2004 Validate coreq/prereq rules for all sua before drop operation so as to suppress the rules
981: which failed even before the drop. Bug # 3926541
1492: p_calling_obj => 'JOB') THEN
1493:
1494: -- validate the holds when droping an unit, pmarada, 2385096
1495:
1496: IF NOT IGS_EN_VAL_ENCMB.enrp_val_enr_encmb(p_person_id,
1497: p_program_cd ,
1498: p_load_cal_type,
1499: p_load_sequence_number,
1500: lv_message_name,
1526: p_sub_unit => l_sub_unit);
1527:
1528: -- validate the holds when droping an unit, pmarada, 2385096
1529:
1530: IF NOT IGS_EN_VAL_ENCMB.enrp_val_enr_encmb(p_person_id,
1531: p_program_cd ,
1532: p_load_cal_type,
1533: p_load_sequence_number,
1534: lv_message_name,
3017: p_min_credit_point => l_total_credit_points,
3018: p_calling_obj => 'JOB') THEN
3019: -- validate the holds when droping an unit, pmarada, 2385096
3020:
3021: IF NOT IGS_EN_VAL_ENCMB.enrp_val_enr_encmb( p_person_id,
3022: p_program_cd ,
3023: p_load_cal_type,
3024: p_load_sequence_number,
3025: lv_message_name,
3068: END IF;
3069: -- validate the holds when droping an unit, pmarada, 2385096
3070:
3071: IF p_ovrrd_drop ='N' THEN
3072: IF NOT IGS_EN_VAL_ENCMB.enrp_val_enr_encmb(p_person_id,
3073: p_program_cd ,
3074: p_load_cal_type,
3075: p_load_sequence_number,
3076: lv_message_name,