APPS.IGS_PR_INST_STA_REF_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 95: app_exception.raise_exception;

91: new_references.stat_type
92: ) THEN
93: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
98: END check_parent_existance;
99:

Line 167: app_exception.raise_exception;

163: IF (cur_rowid%FOUND) THEN
164: CLOSE cur_rowid;
165: fnd_message.set_name ('IGS', 'IGS_PR_INSTR_STTY_FK');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: RETURN;
169: END IF;
170: CLOSE cur_rowid;
171:

Line 224: app_exception.raise_exception;

220: )
221: ) THEN
222: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
223: igs_ge_msg_stack.add;
224: app_exception.raise_exception;
225: END IF;
226: check_parent_existance;
227: ELSIF (p_action = 'UPDATE') THEN
228: -- Call all the procedures related to Before Update.

Line 240: app_exception.raise_exception;

236: )
237: ) THEN
238: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
239: igs_ge_msg_stack.add;
240: app_exception.raise_exception;
241: END IF;
242: END IF;
243:
244: END before_dml;

Line 299: app_exception.raise_exception;

295: END IF;
296: ELSE
297: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
298: igs_ge_msg_stack.add;
299: app_exception.raise_exception;
300: END IF;
301:
302: before_dml(
303: p_action => 'INSERT',

Line 327: app_exception.raise_exception;

323: fnd_message.set_name ('IGS', 'IGS_PR_INCLUDE_OR_EXCLUDE');
324: fnd_message.set_token('Include_or_Exclude1',x_include_or_exclude);
325: fnd_message.set_token('Include_or_Exclude2',l_include_or_exclude);
326: igs_ge_msg_stack.add;
327: app_exception.raise_exception;
328: END IF;
329: END LOOP;
330:
331: INSERT INTO igs_pr_inst_sta_ref (

Line 397: app_exception.raise_exception;

393: IF (c1%notfound) THEN
394: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
395: igs_ge_msg_stack.add;
396: CLOSE c1;
397: app_exception.raise_exception;
398: RETURN;
399: END IF;
400: CLOSE c1;
401:

Line 409: app_exception.raise_exception;

405: NULL;
406: ELSE
407: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
408: igs_ge_msg_stack.add;
409: app_exception.raise_exception;
410: END IF;
411:
412: RETURN;
413:

Line 456: app_exception.raise_exception;

452: END IF;
453: ELSE
454: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: END IF;
458:
459: before_dml(
460: p_action => 'UPDATE',