DBA Data[Home] [Help]

APPS.IGS_PS_USEC_ACT_TYPE_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 233: app_exception.raise_exception;

229: )
230: ) THEN
231: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: END IF;
235: check_uniqueness;
236: ELSIF (p_action = 'UPDATE') THEN
237: -- Call all the procedures related to Before Update.

Line 250: app_exception.raise_exception;

246: )
247: ) THEN
248: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
249: igs_ge_msg_stack.add;
250: app_exception.raise_exception;
251: END IF;
252: check_uniqueness;
253: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
254: check_uniqueness;

Line 308: app_exception.raise_exception;

304: END IF;
305: ELSE
306: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310:
311: SELECT igs_ps_usec_act_type_s.NEXTVAL
312: INTO x_activity_type_id

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 411: app_exception.raise_exception;

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

Line 458: app_exception.raise_exception;

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