APPS.IGS_PR_OU_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 99: app_exception.raise_exception;

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

Line 108: app_exception.raise_exception;

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

Line 183: app_exception.raise_exception;

179: IF (cur_rowid%FOUND) THEN
180: CLOSE cur_rowid;
181: fnd_message.set_name ('IGS', 'IGS_PR_PREF_PRO_FK');
182: igs_ge_msg_stack.add;
183: app_exception.raise_exception;
184: RETURN;
185: END IF;
186: CLOSE cur_rowid;
187:

Line 218: app_exception.raise_exception;

214: IF (cur_rowid%FOUND) THEN
215: CLOSE cur_rowid;
216: fnd_message.set_name ('IGS', 'IGS_PR_PREF_FCAT_FK');
217: igs_ge_msg_stack.add;
218: app_exception.raise_exception;
219: RETURN;
220: END IF;
221: CLOSE cur_rowid;
222:

Line 256: APP_EXCEPTION.RAISE_EXCEPTION;

252: IF c_parent%NOTFOUND THEN
253: CLOSE c_parent;
254: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
255: IGS_GE_MSG_STACK.ADD;
256: APP_EXCEPTION.RAISE_EXCEPTION;
257: END IF;
258: CLOSE c_parent;
259: ELSIF(p_action = 'UPDATE') THEN
260: IF new_references.progression_rule_cat <> old_references.progression_rule_cat OR

Line 269: APP_EXCEPTION.RAISE_EXCEPTION;

265: IF c_parent%NOTFOUND THEN
266: CLOSE c_parent;
267: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
268: IGS_GE_MSG_STACK.ADD;
269: APP_EXCEPTION.RAISE_EXCEPTION;
270: END IF;
271: CLOSE c_parent;
272: END IF;
273: END IF;

Line 327: app_exception.raise_exception;

323: )
324: ) THEN
325: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
326: igs_ge_msg_stack.add;
327: app_exception.raise_exception;
328: END IF;
329: check_parent_existance;
330: ELSIF (p_action = 'UPDATE') THEN
331: -- Call all the procedures related to Before Update.

Line 344: app_exception.raise_exception;

340: )
341: ) THEN
342: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
343: igs_ge_msg_stack.add;
344: app_exception.raise_exception;
345: END IF;
346: END IF;
347: -- anilk, bug#2784198
348: BeforeInsertUpdate(p_action);

Line 393: app_exception.raise_exception;

389: END IF;
390: ELSE
391: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395: before_dml(
396: p_action => 'INSERT',
397: x_rowid => x_rowid,

Line 467: app_exception.raise_exception;

463: IF (c1%notfound) THEN
464: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
465: igs_ge_msg_stack.add;
466: CLOSE c1;
467: app_exception.raise_exception;
468: RETURN;
469: END IF;
470: CLOSE c1;
471: