DBA Data[Home] [Help]

APPS.IGS_PR_CS_SCHDL_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 95: app_exception.raise_exception;

91: )
92: ) THEN
93: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
98: END check_uniqueness;
99:

Line 121: app_exception.raise_exception;

117: new_references.course_type
118: ) THEN
119: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123:
124: END check_parent_existance;
125:

Line 266: app_exception.raise_exception;

262: )
263: ) THEN
264: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268: check_uniqueness;
269: check_parent_existance;
270: ELSIF (p_action = 'UPDATE') THEN

Line 285: app_exception.raise_exception;

281: )
282: ) THEN
283: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: END IF;
287: check_uniqueness;
288: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
289: check_uniqueness;

Line 342: app_exception.raise_exception;

338: END IF;
339: ELSE
340: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344:
345: SELECT igs_pr_cs_schdl_s.NEXTVAL
346: INTO x_igs_pr_cs_schdl_id

Line 436: app_exception.raise_exception;

432: IF (c1%notfound) THEN
433: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
434: igs_ge_msg_stack.add;
435: CLOSE c1;
436: app_exception.raise_exception;
437: RETURN;
438: END IF;
439: CLOSE c1;
440:

Line 451: app_exception.raise_exception;

447: NULL;
448: ELSE
449: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
450: igs_ge_msg_stack.add;
451: app_exception.raise_exception;
452: END IF;
453:
454: RETURN;
455:

Line 499: app_exception.raise_exception;

495: END IF;
496: ELSE
497: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
498: igs_ge_msg_stack.add;
499: app_exception.raise_exception;
500: END IF;
501:
502: before_dml(
503: p_action => 'UPDATE',