DBA Data[Home] [Help]

APPS.IGS_UC_REF_OFF_ABRV_PKG dependencies on APP_EXCEPTION

Line 58: app_exception.raise_exception;

54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
61: CLOSE cur_old_ref_values;
62:

Line 207: app_exception.raise_exception;

203: )
204: ) THEN
205: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: END IF;
209: ELSIF (p_action = 'VALIDATE_INSERT') THEN
210: -- Call all the procedures related to Before Insert.
211: IF ( get_pk_for_validation (

Line 217: app_exception.raise_exception;

213: )
214: ) THEN
215: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
216: igs_ge_msg_stack.add;
217: app_exception.raise_exception;
218: END IF;
219: ELSIF (p_action = 'DELETE') THEN
220: -- Call all the procedures related to Before Delete.
221: check_child_existance;

Line 284: app_exception.raise_exception;

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

Line 417: app_exception.raise_exception;

413: IF (c1%notfound) THEN
414: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
415: igs_ge_msg_stack.add;
416: CLOSE c1;
417: app_exception.raise_exception;
418: RETURN;
419: END IF;
420: CLOSE c1;
421:

Line 440: app_exception.raise_exception;

436: NULL;
437: ELSE
438: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442:
443: RETURN;
444:

Line 498: app_exception.raise_exception;

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