DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_TYPE_LVL_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 92: app_exception.raise_exception;

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

Line 215: app_exception.raise_exception;

211: )
212: ) THEN
213: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
214: igs_ge_msg_stack.add;
215: app_exception.raise_exception;
216: END IF;
217: check_uniqueness;
218: ELSIF (p_action = 'UPDATE') THEN
219: -- Call all the procedures related to Before Update.

Line 229: app_exception.raise_exception;

225: )
226: ) THEN
227: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
228: igs_ge_msg_stack.add;
229: app_exception.raise_exception;
230: END IF;
231: check_uniqueness;
232: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
233: check_uniqueness;

Line 285: app_exception.raise_exception;

281: END IF;
282: ELSE
283: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: END IF;
287:
288: SELECT igs_ps_unit_type_lvl_s.NEXTVAL
289: INTO x_unit_type_id

Line 374: app_exception.raise_exception;

370: IF (c1%notfound) THEN
371: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
372: igs_ge_msg_stack.add;
373: CLOSE c1;
374: app_exception.raise_exception;
375: RETURN;
376: END IF;
377: CLOSE c1;
378:

Line 388: app_exception.raise_exception;

384: NULL;
385: ELSE
386: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
387: igs_ge_msg_stack.add;
388: app_exception.raise_exception;
389: END IF;
390:
391: RETURN;
392:

Line 435: app_exception.raise_exception;

431: END IF;
432: ELSE
433: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
434: igs_ge_msg_stack.add;
435: app_exception.raise_exception;
436: END IF;
437:
438: before_dml(
439: p_action => 'UPDATE',