DBA Data[Home] [Help]

APPS.IGS_EN_TIMESLOT_RSLT_PKG dependencies on APP_EXCEPTION

Line 43: app_exception.raise_exception;

39: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
40: CLOSE cur_old_ref_values;
41: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
42: igs_ge_msg_stack.add;
43: app_exception.raise_exception;
44: RETURN;
45: END IF;
46: CLOSE cur_old_ref_values;
47: -- Populate New Values.

Line 83: app_exception.raise_exception;

79: new_references.igs_en_timeslot_para_id
80: ) THEN
81: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
82: igs_ge_msg_stack.add;
83: app_exception.raise_exception;
84: END IF;
85: END check_parent_existance;
86: FUNCTION get_pk_for_validation (
87: x_igs_en_timeslot_rslt_id IN NUMBER

Line 139: app_exception.raise_exception;

135: IF (cur_rowid%FOUND) THEN
136: CLOSE cur_rowid;
137: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: RETURN;
141: END IF;
142: CLOSE cur_rowid;
143: END get_fk_igs_en_timeslot_para;

Line 191: app_exception.raise_exception;

187: )
188: ) THEN
189: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: END IF;
193: check_parent_existance;
194: ELSIF (p_action = 'UPDATE') THEN
195: -- Call all the procedures related to Before Update.

Line 205: app_exception.raise_exception;

201: )
202: ) THEN
203: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207: END IF;
208: END before_dml;
209: PROCEDURE insert_row (

Line 266: app_exception.raise_exception;

262: END IF;
263: ELSE
264: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268: SELECT igs_en_timeslot_rslt_s.NEXTVAL INTO x_igs_en_timeslot_rslt_id FROM DUAL;
269: before_dml(
270: p_action => 'INSERT',

Line 356: app_exception.raise_exception;

352: IF (c1%notfound) THEN
353: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
354: igs_ge_msg_stack.add;
355: CLOSE c1;
356: app_exception.raise_exception;
357: RETURN;
358: END IF;
359: CLOSE c1;
360:

Line 371: app_exception.raise_exception;

367: NULL;
368: ELSE
369: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: RETURN;
374: END lock_row;
375: PROCEDURE update_row (

Line 417: app_exception.raise_exception;

413: END IF;
414: ELSE
415: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
416: igs_ge_msg_stack.add;
417: app_exception.raise_exception;
418: END IF;
419: before_dml(
420: p_action => 'UPDATE',
421: x_rowid => x_rowid,