APPS.IGS_PR_STDNT_PR_FND_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

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

Line 100: app_exception.raise_exception;

96: new_references.spo_sequence_number
97: ) THEN
98: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:
103: IF (((old_references.fund_code = new_references.fund_code)) OR
104: ((new_references.fund_code IS NULL))) THEN

Line 109: app_exception.raise_exception;

105: NULL;
106: ELSIF NOT igf_aw_fund_cat_pkg.get_uk_for_validation ( new_references.fund_code ) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111: END check_parent_existance;
112:
113:

Line 186: app_exception.raise_exception;

182: IF (cur_rowid%FOUND) THEN
183: CLOSE cur_rowid;
184: fnd_message.set_name ('IGS', 'IGS_PR_PSEF_PRO_FK');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: RETURN;
188: END IF;
189: CLOSE cur_rowid;
190:

Line 221: app_exception.raise_exception;

217: IF (cur_rowid%FOUND) THEN
218: CLOSE cur_rowid;
219: fnd_message.set_name ('IGS', 'IGS_PR_PSEF_FCAT_FK');
220: igs_ge_msg_stack.add;
221: app_exception.raise_exception;
222: RETURN;
223: END IF;
224: CLOSE cur_rowid;
225:

Line 279: app_exception.raise_exception;

275: )
276: ) THEN
277: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: END IF;
281: check_parent_existance;
282: ELSIF (p_action = 'UPDATE') THEN
283: -- Call all the procedures related to Before Update.

Line 296: app_exception.raise_exception;

292: )
293: ) THEN
294: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
295: igs_ge_msg_stack.add;
296: app_exception.raise_exception;
297: END IF;
298: END IF;
299:
300: END before_dml;

Line 343: app_exception.raise_exception;

339: END IF;
340: ELSE
341: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
342: igs_ge_msg_stack.add;
343: app_exception.raise_exception;
344: END IF;
345:
346: before_dml(
347: p_action => 'INSERT',

Line 399: app_exception.raise_exception;

395:
396: fnd_message.set_token ('ERR_CD', SQLCODE);
397: igs_ge_msg_stack.add;
398: igs_sc_gen_001.unset_ctx('R');
399: app_exception.raise_exception;
400: ELSE
401: igs_sc_gen_001.unset_ctx('R');
402: RAISE;
403: END IF;

Line 440: app_exception.raise_exception;

436: IF (c1%notfound) THEN
437: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
438: igs_ge_msg_stack.add;
439: CLOSE c1;
440: app_exception.raise_exception;
441: RETURN;
442: END IF;
443: CLOSE c1;
444:

Line 481: app_exception.raise_exception;

477: IF (SQL%NOTFOUND) THEN
478: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
479: igs_ge_msg_stack.add;
480: igs_sc_gen_001.unset_ctx('R');
481: app_exception.raise_exception;
482: END IF;
483: IF (x_mode = 'S') THEN
484: igs_sc_gen_001.unset_ctx('R');
485: END IF;