DBA Data[Home] [Help]

APPS.IGS_PS_FAC_ASG_TASK_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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

Line 100: app_exception.raise_exception;

96: new_references.faculty_task_type
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.fac_wl_id = new_references.fac_wl_id)) OR
104: ((new_references.fac_wl_id IS NULL))) THEN

Line 111: app_exception.raise_exception;

107: new_references.fac_wl_id
108: ) THEN
109: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_parent_existance;
115:

Line 181: app_exception.raise_exception;

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

Line 215: app_exception.raise_exception;

211: IF c_closed%FOUND THEN
212: CLOSE c_closed;
213: fnd_message.set_name('IGS','IGS_PS_FAC_TAS_TYP_CLOSED');
214: igs_ge_msg_stack.add;
215: app_exception.raise_exception;
216: END IF;
217: CLOSE c_closed;
218: ELSIF p_updating THEN
219: IF new_references.faculty_task_type <> old_references.faculty_task_type THEN

Line 226: app_exception.raise_exception;

222: IF c_closed%FOUND THEN
223: CLOSE c_closed;
224: fnd_message.set_name('IGS','IGS_PS_FAC_TAS_TYP_CLOSED');
225: igs_ge_msg_stack.add;
226: app_exception.raise_exception;
227: END IF;
228: CLOSE c_closed;
229: END IF;
230: END IF;

Line 289: app_exception.raise_exception;

285: )
286: ) THEN
287: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
288: igs_ge_msg_stack.add;
289: app_exception.raise_exception;
290: END IF;
291: check_parent_existance;
292: before_insert_update(TRUE,FALSE);
293: ELSIF (p_action = 'UPDATE') THEN

Line 306: app_exception.raise_exception;

302: )
303: ) THEN
304: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308: before_insert_update(TRUE,FALSE);
309: END IF;
310:

Line 364: app_exception.raise_exception;

360: END IF;
361: ELSE
362: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
363: igs_ge_msg_stack.add;
364: app_exception.raise_exception;
365: END IF;
366:
367: before_dml(
368: p_action => 'INSERT',

Line 463: app_exception.raise_exception;

459: IF (c1%notfound) THEN
460: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
461: igs_ge_msg_stack.add;
462: CLOSE c1;
463: app_exception.raise_exception;
464: RETURN;
465: END IF;
466: CLOSE c1;
467:

Line 479: app_exception.raise_exception;

475: NULL;
476: ELSE
477: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
478: igs_ge_msg_stack.add;
479: app_exception.raise_exception;
480: END IF;
481:
482: RETURN;
483:

Line 529: app_exception.raise_exception;

525: END IF;
526: ELSE
527: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
528: igs_ge_msg_stack.add;
529: app_exception.raise_exception;
530: END IF;
531:
532: before_dml(
533: p_action => 'UPDATE',