DBA Data[Home] [Help]

APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;
54:

Line 429: App_Exception.Raise_Exception;

425:
426: IF l_acad_message IS NOT NULL THEN
427: Fnd_Message.Set_Name ('IGS',l_acad_message );
428: IGS_GE_MSG_STACK.ADD;
429: App_Exception.Raise_Exception;
430: END IF;
431:
432: --
433: -- Get Enrollment Category, Commencement Type and Enrollemnt Method

Line 471: app_exception.raise_exception;

467: p_message => l_message);
468: IF l_message IS NOT NULL THEN
469: fnd_message.set_name ('IGS', l_message);
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472: END IF;
473: l_min_upd_credit_cp := l_upd_credit_cp;
474: -- The Four parameters p_enrollment_category, p_comm_type, p_method_type, p_min_credit_point
475: -- added in the below function call, as part of Enrl Elgbl and Validation Build. Bug#2616692

Line 493: App_Exception.Raise_Exception;

489: p_calling_obj => 'JOB'
490: ) AND l_message = 'IGS_SS_DENY_MIN_CP_REACHED' THEN
491: Fnd_Message.Set_Name ('IGS',l_message );
492: IGS_GE_MSG_STACK.ADD;
493: App_Exception.Raise_Exception;
494: END IF;
495:
496: l_message := NULL;
497: l_deny_warn_max_cp := igs_ss_enr_details.get_notification(

Line 509: app_exception.raise_exception;

505: p_message => l_message);
506: IF l_message IS NOT NULL THEN
507: fnd_message.set_name ('IGS', l_message);
508: igs_ge_msg_stack.add;
509: app_exception.raise_exception;
510: END IF;
511: IF l_deny_warn_max_cp ='DENY' AND NOT igs_en_elgbl_program.eval_max_cp (
512: p_person_id => cur_sua_def_var_rec.person_id,
513: p_load_calendar_type => l_cur_step_cal_rec.cal_type,

Line 524: App_Exception.Raise_Exception;

520: p_upd_cp => l_upd_credit_cp,
521: p_calling_obj => 'JOB') THEN
522: Fnd_Message.Set_Name ('IGS',l_message );
523: IGS_GE_MSG_STACK.ADD;
524: App_Exception.Raise_Exception;
525: END IF;
526: --------------------------------------------------------------------------------------------------------------------------------------------
527: l_message := NULL;
528: l_deny_warn_reenroll := igs_ss_enr_details.get_notification(

Line 540: app_exception.raise_exception;

536: p_message => l_message);
537: IF l_message IS NOT NULL THEN
538: fnd_message.set_name ('IGS', l_message);
539: igs_ge_msg_stack.add;
540: app_exception.raise_exception;
541: END IF;
542: IF l_deny_warn_reenroll ='DENY' AND NOT igs_en_elgbl_unit.eval_unit_reenroll (
543: p_person_id => cur_sua_def_var_rec.person_id,
544: p_load_cal_type => l_cur_step_cal_rec.cal_type,

Line 556: App_Exception.Raise_Exception;

552: p_val_level => 'CREDIT_POINT',
553: p_calling_obj => 'JOB') THEN
554: Fnd_Message.Set_Name ('IGS',l_message );
555: IGS_GE_MSG_STACK.ADD;
556: App_Exception.Raise_Exception;
557: END IF;
558:
559: -- smaddali added the check that message <> IGS_EN_OVERRIDE_EFTSU_VALUES for EN317 build
560: -- because credit approval can be provided even for a unit which doesnt allow overriding of cp

Line 572: App_Exception.Raise_Exception;

568: p_uoo_id => cur_sua_def_var_rec.uoo_id,
569: p_no_assessment_ind => 'N' ) AND l_message <> 'IGS_EN_OVERRIDE_EFTSU_VALUES' THEN
570: Fnd_Message.Set_Name ('IGS',l_message );
571: IGS_GE_MSG_STACK.ADD;
572: App_Exception.Raise_Exception;
573: END IF;
574:
575: -- bmerugu added for 4433428
576: l_message := NULL;

Line 590: app_exception.raise_exception;

586: ) ;
587: IF l_message IS NOT NULL THEN
588: fnd_message.set_name ('IGS', l_message);
589: igs_ge_msg_stack.add;
590: app_exception.raise_exception;
591: END IF;
592:
593: l_message := NULL;
594: l_deny_warn_cross_loc := igs_ss_enr_details.get_notification(

Line 607: app_exception.raise_exception;

603: ) ;
604: IF l_message IS NOT NULL THEN
605: fnd_message.set_name ('IGS', l_message);
606: igs_ge_msg_stack.add;
607: app_exception.raise_exception;
608: END IF;
609:
610: l_message := NULL;
611: l_deny_warn_cross_mod := igs_ss_enr_details.get_notification(

Line 624: app_exception.raise_exception;

620: ) ;
621: IF l_message IS NOT NULL THEN
622: fnd_message.set_name ('IGS', l_message);
623: igs_ge_msg_stack.add;
624: app_exception.raise_exception;
625: END IF;
626:
627: l_message := NULL;
628: l_deny_warn_cross_fac := igs_ss_enr_details.get_notification(

Line 641: app_exception.raise_exception;

637: ) ;
638: IF l_message IS NOT NULL THEN
639: fnd_message.set_name ('IGS', l_message);
640: igs_ge_msg_stack.add;
641: app_exception.raise_exception;
642: END IF;
643:
644: IF l_deny_warn_att_type ='DENY' THEN
645: -- bmerugu added for 4433428

Line 764: App_Exception.Raise_Exception;

760: p_calling_obj => 'JOB' ) THEN
761:
762: Fnd_Message.Set_Name ('IGS',l_message );
763: IGS_GE_MSG_STACK.ADD;
764: App_Exception.Raise_Exception;
765: END IF ;
766:
767: l_message := NULL;
768: IF l_deny_warn_cross_fac ='DENY' AND NOT igs_en_elgbl_program.eval_cross_validation (

Line 782: App_Exception.Raise_Exception;

778: p_eligibility_step_type => cst_crossfac,
779: p_calling_obj => 'JOB' ) THEN
780: Fnd_Message.Set_Name ('IGS',l_message );
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
783: END IF ;
784:
785: l_message := NULL;
786: IF l_deny_warn_cross_mod ='DENY' AND NOT igs_en_elgbl_program.eval_cross_validation (

Line 801: App_Exception.Raise_Exception;

797: p_calling_obj => 'JOB' ) THEN
798:
799: Fnd_Message.Set_Name ('IGS',l_message );
800: IGS_GE_MSG_STACK.ADD;
801: App_Exception.Raise_Exception;
802: END IF ;
803:
804: l_message := NULL;
805: IF l_deny_warn_cross_loc ='DENY' AND NOT igs_en_elgbl_program.eval_cross_validation (

Line 820: App_Exception.Raise_Exception;

816: p_calling_obj => 'JOB') THEN
817:
818: Fnd_Message.Set_Name ('IGS',l_message );
819: IGS_GE_MSG_STACK.ADD;
820: App_Exception.Raise_Exception;
821: END IF ;
822:
823: END LOOP loop_sua_rec;
824:

Line 939: app_exception.raise_exception;

935: )
936: ) THEN
937: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
938: igs_ge_msg_stack.add;
939: app_exception.raise_exception;
940: END IF;
941:
942: END check_uniqueness;
943:

Line 990: app_exception.raise_exception;

986: new_references.elgb_ovr_step_id
987: ) THEN
988: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
989: igs_ge_msg_stack.add;
990: app_exception.raise_exception;
991: END IF;
992:
993: IF (old_references.uoo_id = new_references.uoo_id) OR
994: (new_references.uoo_id IS NULL) OR (new_references.uoo_id = -1 ) THEN

Line 1001: app_exception.raise_exception;

997: new_references.uoo_id
998: ) THEN
999: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1000: igs_ge_msg_stack.add;
1001: app_exception.raise_exception;
1002: END IF;
1003:
1004: IF (((old_references.unit_cd = new_references.unit_cd) AND
1005: (old_references.version_number = new_references.version_number)) OR

Line 1015: app_exception.raise_exception;

1011: new_references.version_number
1012: ) THEN
1013: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1014: igs_ge_msg_stack.add;
1015: app_exception.raise_exception;
1016: END IF;
1017:
1018: END check_parent_existance;
1019:

Line 1049: app_exception.raise_exception;

1045: IF (cur_rowid%FOUND) THEN
1046: CLOSE cur_rowid;
1047: fnd_message.set_name ('IGS', 'IGS_EN_ELGB_STEP_UNIT_FK');
1048: igs_ge_msg_stack.add;
1049: app_exception.raise_exception;
1050: RETURN;
1051: END IF;
1052: CLOSE cur_rowid;
1053:

Line 1085: app_exception.raise_exception;

1081: IF (cur_rowid%FOUND) THEN
1082: CLOSE cur_rowid;
1083: fnd_message.set_name ('IGS', 'IGS_EN_EOS_UOO_FK');
1084: igs_ge_msg_stack.add;
1085: app_exception.raise_exception;
1086: RETURN;
1087: END IF;
1088: CLOSE cur_rowid;
1089:

Line 1123: app_exception.raise_exception;

1119: IF (cur_rowid%FOUND) THEN
1120: CLOSE cur_rowid;
1121: fnd_message.set_name ('IGS', 'IGS_EN_EOS_UV_FK');
1122: igs_ge_msg_stack.add;
1123: app_exception.raise_exception;
1124: RETURN;
1125: END IF;
1126: CLOSE cur_rowid;
1127:

Line 1258: app_exception.raise_exception;

1254: )
1255: ) THEN
1256: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1257: igs_ge_msg_stack.add;
1258: app_exception.raise_exception;
1259: END IF;
1260: check_uniqueness;
1261: check_parent_existance ;
1262: ELSIF (p_action = 'UPDATE') THEN

Line 1274: app_exception.raise_exception;

1270: )
1271: ) THEN
1272: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1273: igs_ge_msg_stack.add;
1274: app_exception.raise_exception;
1275: END IF;
1276: check_uniqueness;
1277: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
1278: check_uniqueness;

Line 1344: app_exception.raise_exception;

1340: ELSE
1341: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1342: fnd_message.set_token ('ROUTINE', 'IGS_EN_ELGB_OVR_UOO_PKG.INSERT_ROW');
1343: igs_ge_msg_stack.add;
1344: app_exception.raise_exception;
1345: END IF;
1346:
1347: x_elgb_ovr_step_uoo_id := NULL;
1348:

Line 1442: app_exception.raise_exception;

1438: IF (c1%notfound) THEN
1439: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1440: igs_ge_msg_stack.add;
1441: CLOSE c1;
1442: app_exception.raise_exception;
1443: RETURN;
1444: END IF;
1445: CLOSE c1;
1446:

Line 1458: app_exception.raise_exception;

1454: NULL;
1455: ELSE
1456: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1457: igs_ge_msg_stack.add;
1458: app_exception.raise_exception;
1459: END IF;
1460:
1461: RETURN;
1462:

Line 1508: app_exception.raise_exception;

1504: ELSE
1505: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1506: fnd_message.set_token ('ROUTINE', 'IGS_EN_ELGB_OVR_UOO_PKG.UPDATE_ROW');
1507: igs_ge_msg_stack.add;
1508: app_exception.raise_exception;
1509: END IF;
1510:
1511:
1512: