DBA Data[Home] [Help]

APPS.IGS_AD_HZ_ACAD_HIST_PKG dependencies on APP_EXCEPTION

Line 91: app_exception.raise_exception;

87: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
88: CLOSE cur_old_ref_values;
89: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
90: igs_ge_msg_stack.add;
91: app_exception.raise_exception;
92: RETURN;
93: END IF;
94: CLOSE cur_old_ref_values;
95:

Line 188: App_Exception.Raise_Exception;

184: Column_Name IS NULL THEN
185: IF NOT (new_references.transcript_required in ('Y','N')) THEN
186: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: END IF;*/
191:
192: END Check_Constraints;

Line 221: App_Exception.Raise_Exception;

217: Fetch cur_rowid INTO lv_rowid;
218: IF (cur_rowid%NOTFOUND) THEN
219: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: END IF;
223: Close cur_rowid;
224:
225: END IF;

Line 292: app_exception.raise_exception;

288: IF (cur_rowid%FOUND) THEN
289: CLOSE cur_rowid;
290: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
291: igs_ge_msg_stack.add;
292: app_exception.raise_exception;
293: RETURN;
294: END IF;
295: CLOSE cur_rowid;
296:

Line 430: app_exception.raise_exception;

426: )
427: ) THEN
428: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
429: igs_ge_msg_stack.add;
430: app_exception.raise_exception;
431: END IF;
432: Check_Constraints;
433: check_parent_existance;
434: ELSIF (p_action = 'UPDATE') THEN

Line 450: app_exception.raise_exception;

446: )
447: ) THEN
448: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
449: igs_ge_msg_stack.add;
450: app_exception.raise_exception;
451: END IF;
452: Check_Constraints;
453: END IF;
454:

Line 562: app_exception.raise_exception;

558: END IF;
559: ELSE
560: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
561: igs_ge_msg_stack.add;
562: app_exception.raise_exception;
563: END IF;
564:
565: X_HZ_ACAD_HIST_ID := -1;
566: before_dml(

Line 754: app_exception.raise_exception;

750: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
751: fnd_message.set_token ('ERR_CD', SQLCODE);
752: igs_ge_msg_stack.add;
753: igs_sc_gen_001.unset_ctx('R');
754: app_exception.raise_exception;
755: ELSE
756: igs_sc_gen_001.unset_ctx('R');
757: RAISE;
758: END IF;

Line 881: app_exception.raise_exception;

877: IF (c1%notfound) THEN
878: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
879: igs_ge_msg_stack.add;
880: CLOSE c1;
881: app_exception.raise_exception;
882: RETURN;
883: END IF;
884: CLOSE c1;
885:

Line 936: app_exception.raise_exception;

932: NULL;
933: ELSE
934: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
935: igs_ge_msg_stack.add;
936: app_exception.raise_exception;
937: END IF;
938:
939: RETURN;
940:

Line 1043: app_exception.raise_exception;

1039: END IF;
1040: ELSE
1041: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1042: igs_ge_msg_stack.add;
1043: app_exception.raise_exception;
1044: END IF;
1045:
1046: before_dml(
1047: p_action => 'UPDATE',

Line 1162: app_exception.raise_exception;

1158: IF (SQL%NOTFOUND) THEN
1159: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1160: igs_ge_msg_stack.add;
1161: igs_sc_gen_001.unset_ctx('R');
1162: app_exception.raise_exception;
1163: END IF;
1164: IF (x_mode = 'S') THEN
1165: igs_sc_gen_001.unset_ctx('R');
1166: END IF;

Line 1177: app_exception.raise_exception;

1173: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1174: fnd_message.set_token ('ERR_CD', SQLCODE);
1175: igs_ge_msg_stack.add;
1176: igs_sc_gen_001.unset_ctx('R');
1177: app_exception.raise_exception;
1178: ELSE
1179: igs_sc_gen_001.unset_ctx('R');
1180: RAISE;
1181: END IF;

Line 1393: app_exception.raise_exception;

1389: IF (SQL%NOTFOUND) THEN
1390: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1391: igs_ge_msg_stack.add;
1392: igs_sc_gen_001.unset_ctx('R');
1393: app_exception.raise_exception;
1394: END IF;
1395: IF (x_mode = 'S') THEN
1396: igs_sc_gen_001.unset_ctx('R');
1397: END IF;