DBA Data[Home] [Help]

APPS.IGS_EN_SPA_AWD_AIM_PKG dependencies on IGS_GE_MSG_STACK

Line 54: igs_ge_msg_stack.add;

50: FETCH cur_old_ref_values INTO old_references;
51: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
52: CLOSE cur_old_ref_values;
53: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
54: igs_ge_msg_stack.add;
55: app_exception.raise_exception;
56: RETURN;
57: END IF;
58: CLOSE cur_old_ref_values;

Line 239: IGS_GE_MSG_STACK.ADD;

235: FETCH cur_pers_type INTO l_person_type;
236: CLOSE cur_pers_type;
237: IF l_person_type IS NULL THEN
238: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242:
243: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);

Line 305: IGS_GE_MSG_STACK.ADD;

301: FETCH cur_pers_type INTO l_person_type;
302: CLOSE cur_pers_type;
303: IF l_person_type IS NULL THEN
304: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: END IF;
308:
309: -- Check any active record found for this student program, with System Person Type,FORMER_STUDENT

Line 376: IGS_GE_MSG_STACK.ADD;

372: FETCH cur_pers_type INTO l_person_type;
373: CLOSE cur_pers_type;
374: IF l_person_type IS NULL THEN
375: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
376: IGS_GE_MSG_STACK.ADD;
377: App_Exception.Raise_Exception;
378: END IF;
379:
380: -- Check any active record found for this student program, with System Person Type,GRADUATE

Line 420: IGS_GE_MSG_STACK.ADD;

416: FETCH cur_pers_type INTO l_person_type;
417: CLOSE cur_pers_type;
418: IF l_person_type IS NULL THEN
419: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
420: IGS_GE_MSG_STACK.ADD;
421: App_Exception.Raise_Exception;
422: END IF;
423:
424: IF l_date = SYSDATE THEN

Line 492: IGS_GE_MSG_STACK.ADD;

488: FETCH cur_pers_type INTO l_person_type;
489: CLOSE cur_pers_type;
490: IF l_person_type IS NULL THEN
491: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
492: IGS_GE_MSG_STACK.ADD;
493: App_Exception.Raise_Exception;
494: END IF;
495:
496: OPEN cur_conf_dt(p_rowid);

Line 537: IGS_GE_MSG_STACK.ADD;

533: FETCH cur_pers_type INTO l_person_type;
534: CLOSE cur_pers_type;
535: IF l_person_type IS NULL THEN
536: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');
537: IGS_GE_MSG_STACK.ADD;
538: App_Exception.Raise_Exception;
539: END IF;
540: IF l_date = SYSDATE THEN
541: OPEN cur_typ_id_inst(cur_conf_dt_rec.PERSON_ID,cur_conf_dt_rec.COURSE_CD,l_person_type);

Line 624: igs_ge_msg_stack.add;

620: new_references.person_id,
621: new_references.course_cd
622: ) THEN
623: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
624: igs_ge_msg_stack.add;
625: app_exception.raise_exception;
626: END IF;
627:
628: IF (((old_references.award_cd = new_references.award_cd)) OR

Line 635: igs_ge_msg_stack.add;

631: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation (
632: new_references.award_cd
633: ) THEN
634: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
635: igs_ge_msg_stack.add;
636: app_exception.raise_exception;
637: END IF;
638:
639: IF (((old_references.grading_schema_cd = new_references.grading_schema_cd) AND

Line 649: igs_ge_msg_stack.add;

645: new_references.grading_schema_cd,
646: new_references.gs_version_number
647: ) THEN
648: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
649: igs_ge_msg_stack.add;
650: app_exception.raise_exception;
651: END IF;
652:
653: END check_parent_existance;

Line 740: igs_ge_msg_stack.add;

736: FETCH cur_rowid INTO lv_rowid;
737: IF (cur_rowid%FOUND) THEN
738: CLOSE cur_rowid;
739: fnd_message.set_name ('IGS', 'IGS_EN_ESAA_SCA_FK');
740: igs_ge_msg_stack.add;
741: app_exception.raise_exception;
742: RETURN;
743: END IF;
744: CLOSE cur_rowid;

Line 779: igs_ge_msg_stack.add;

775: FETCH cur_rowid INTO lv_rowid;
776: IF (cur_rowid%FOUND) THEN
777: CLOSE cur_rowid;
778: fnd_message.set_name ('IGS', 'IGS_AS_GSG_GS_FK');
779: igs_ge_msg_stack.add;
780: app_exception.raise_exception;
781: RETURN;
782: END IF;
783: CLOSE cur_rowid;

Line 869: igs_ge_msg_stack.add;

865: new_references.person_id
866: )
867: ) THEN
868: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
869: igs_ge_msg_stack.add;
870: app_exception.raise_exception;
871: END IF;
872: check_parent_existance;
873: ELSIF (p_action = 'UPDATE') THEN

Line 897: igs_ge_msg_stack.add;

893: new_references.person_id
894: )
895: ) THEN
896: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
897: igs_ge_msg_stack.add;
898: app_exception.raise_exception;
899: END IF;
900: END IF;
901:

Line 974: igs_ge_msg_stack.add;

970: x_last_update_login := -1;
971: END IF;
972: ELSE
973: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
974: igs_ge_msg_stack.add;
975: app_exception.raise_exception;
976: END IF;
977:
978: before_dml(

Line 1056: igs_ge_msg_stack.add;

1052: WHEN OTHERS THEN
1053: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1054: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1055: fnd_message.set_token ('ERR_CD', SQLCODE);
1056: igs_ge_msg_stack.add;
1057: igs_sc_gen_001.unset_ctx('R');
1058: app_exception.raise_exception;
1059: ELSE
1060: igs_sc_gen_001.unset_ctx('R');

Line 1109: igs_ge_msg_stack.add;

1105: OPEN c1;
1106: FETCH c1 INTO tlinfo;
1107: IF (c1%notfound) THEN
1108: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1109: igs_ge_msg_stack.add;
1110: CLOSE c1;
1111: app_exception.raise_exception;
1112: RETURN;
1113: END IF;

Line 1125: igs_ge_msg_stack.add;

1121: ) THEN
1122: NULL;
1123: ELSE
1124: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1125: igs_ge_msg_stack.add;
1126: app_exception.raise_exception;
1127: END IF;
1128:
1129: RETURN;

Line 1182: igs_ge_msg_stack.add;

1178: x_last_update_login := -1;
1179: END IF;
1180: ELSE
1181: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1182: igs_ge_msg_stack.add;
1183: app_exception.raise_exception;
1184: END IF;
1185:
1186: before_dml(

Line 1229: igs_ge_msg_stack.add;

1225: WHERE rowid = x_rowid;
1226:
1227: IF (SQL%NOTFOUND) THEN
1228: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1229: igs_ge_msg_stack.add;
1230: igs_sc_gen_001.unset_ctx('R');
1231: app_exception.raise_exception;
1232: END IF;
1233: IF (x_mode = 'S') THEN

Line 1249: igs_ge_msg_stack.add;

1245: WHEN OTHERS THEN
1246: IF (SQLCODE = (-28115)) THEN
1247: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1248: fnd_message.set_token ('ERR_CD', SQLCODE);
1249: igs_ge_msg_stack.add;
1250: igs_sc_gen_001.unset_ctx('R');
1251: app_exception.raise_exception;
1252: ELSE
1253: igs_sc_gen_001.unset_ctx('R');

Line 1364: igs_ge_msg_stack.add;

1360: WHERE rowid = x_rowid;
1361:
1362: IF (SQL%NOTFOUND) THEN
1363: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1364: igs_ge_msg_stack.add;
1365: igs_sc_gen_001.unset_ctx('R');
1366: app_exception.raise_exception;
1367: END IF;
1368: IF (x_mode = 'S') THEN