DBA Data[Home] [Help]

APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on IGS_GE_MSG_STACK

Line 49: igs_ge_msg_stack.add;

45: FETCH cur_old_ref_values INTO old_references;
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;

Line 428: IGS_GE_MSG_STACK.ADD;

424: p_message_name => l_acad_message );
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: --

Line 470: igs_ge_msg_stack.add;

466: p_person_id => cur_sua_def_var_rec.person_id,
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

Line 492: IGS_GE_MSG_STACK.ADD;

488: p_min_credit_point => l_min_credit_point,
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;

Line 508: igs_ge_msg_stack.add;

504: p_person_id => cur_sua_def_var_rec.person_id,
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,

Line 523: IGS_GE_MSG_STACK.ADD;

519: p_deny_warn => l_deny_warn_max_cp,
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;

Line 539: igs_ge_msg_stack.add;

535: p_person_id => cur_sua_def_var_rec.person_id,
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,

Line 555: IGS_GE_MSG_STACK.ADD;

551: p_upd_cp => new_references.step_override_limit - NVL(cur_sua_def_var_rec.override_enrolled_cp,l_unit_cp),
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

Line 571: IGS_GE_MSG_STACK.ADD;

567: p_message_name => l_message,
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

Line 589: igs_ge_msg_stack.add;

585: p_message => l_message
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;

Line 606: igs_ge_msg_stack.add;

602: p_message => l_message
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;

Line 623: igs_ge_msg_stack.add;

619: p_message => l_message
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;

Line 640: igs_ge_msg_stack.add;

636: p_message => l_message
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

Line 763: IGS_GE_MSG_STACK.ADD;

759: p_method_type => l_enr_meth_type,
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;

Line 781: IGS_GE_MSG_STACK.ADD;

777: p_upd_cp => NULL ,
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;

Line 800: IGS_GE_MSG_STACK.ADD;

796: p_eligibility_step_type => cst_crossmod,
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;

Line 819: IGS_GE_MSG_STACK.ADD;

815: p_eligibility_step_type => cst_crossloc,
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;

Line 938: igs_ge_msg_stack.add;

934: new_references.uoo_id
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;

Line 989: igs_ge_msg_stack.add;

985: ELSIF NOT igs_en_elgb_ovr_step_pkg.get_pk_for_validation (
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

Line 1000: igs_ge_msg_stack.add;

996: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
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

Line 1014: igs_ge_msg_stack.add;

1010: new_references.unit_cd,
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;

Line 1048: igs_ge_msg_stack.add;

1044: FETCH cur_rowid INTO lv_rowid;
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;

Line 1084: igs_ge_msg_stack.add;

1080: FETCH cur_rowid INTO lv_rowid;
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;

Line 1122: igs_ge_msg_stack.add;

1118: FETCH cur_rowid INTO lv_rowid;
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;

Line 1257: igs_ge_msg_stack.add;

1253: new_references.elgb_ovr_step_uoo_id
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 ;

Line 1273: igs_ge_msg_stack.add;

1269: new_references.elgb_ovr_step_uoo_id
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

Line 1343: igs_ge_msg_stack.add;

1339: END IF;
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;

Line 1440: igs_ge_msg_stack.add;

1436: OPEN c1;
1437: FETCH c1 INTO tlinfo;
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;

Line 1457: igs_ge_msg_stack.add;

1453: ) THEN
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;

Line 1507: igs_ge_msg_stack.add;

1503: END IF;
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: