DBA Data[Home] [Help]

APPS.IGS_EN_SPA_AWD_AIM_PKG dependencies on FND_MESSAGE

Line 53: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

49: OPEN cur_old_ref_values;
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;

Line 238: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');

234: OPEN cur_pers_type('GRADUATE');
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:

Line 304: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');

300: OPEN cur_pers_type('FORMER_STUDENT');
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:

Line 375: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');

371: OPEN cur_pers_type('GRADUATE');
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:

Line 419: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');

415: OPEN cur_pers_type('FORMER_STUDENT');
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:

Line 491: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');

487: OPEN cur_pers_type('GRADUATE');
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:

Line 536: Fnd_Message.Set_Name ('IGS', 'IGS_EN_PERSON_TYPE_NOT_DEF');

532: OPEN cur_pers_type('FORMER_STUDENT');
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

Line 623: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

619: ELSIF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation (
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:

Line 634: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

630: NULL;
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:

Line 648: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

644: ELSIF NOT igs_as_grd_schema_pkg.get_pk_for_validation (
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:

Line 739: fnd_message.set_name ('IGS', 'IGS_EN_ESAA_SCA_FK');

735: OPEN cur_rowid;
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;

Line 778: fnd_message.set_name ('IGS', 'IGS_AS_GSG_GS_FK');

774: OPEN cur_rowid;
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;

Line 868: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

864: new_references.course_cd,
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;

Line 896: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

892: new_references.course_cd,
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;

Line 973: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

969: IF (x_last_update_login IS NULL) THEN
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:

Line 1054: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

1050:
1051: EXCEPTION
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;

Line 1055: fnd_message.set_token ('ERR_CD', SQLCODE);

1051: EXCEPTION
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

Line 1108: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

1104:
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;

Line 1124: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

1120: AND ((TRUNC(tlinfo.conferral_date) = TRUNC(x_conferral_date)) OR ((tlinfo.conferral_date IS NULL) AND (X_conferral_date IS NULL)))
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:

Line 1181: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

1177: IF (x_last_update_login IS NULL) THEN
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:

Line 1228: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1224: gs_version_number = new_references.gs_version_number
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;

Line 1247: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

1243:
1244: EXCEPTION
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;

Line 1248: fnd_message.set_token ('ERR_CD', SQLCODE);

1244: EXCEPTION
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

Line 1363: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

1359: DELETE FROM igs_en_spa_awd_aim
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;