DBA Data[Home] [Help]

APPS.IGF_SL_DL_CHG_FLD_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 98: app_exception.raise_exception;

94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: IF ( get_uk2_for_validation (
102: new_references.dl_version,

Line 109: app_exception.raise_exception;

105: )
106: ) THEN
107: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
112: END check_uniqueness;
113:

Line 279: app_exception.raise_exception;

275: )
276: ) THEN
277: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: END IF;
281: check_uniqueness;
282: ELSIF (p_action = 'UPDATE') THEN
283: -- Call all the procedures related to Before Update.

Line 293: app_exception.raise_exception;

289: )
290: ) THEN
291: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
292: igs_ge_msg_stack.add;
293: app_exception.raise_exception;
294: END IF;
295: check_uniqueness;
296: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
297: check_uniqueness;

Line 349: app_exception.raise_exception;

345: END IF;
346: ELSE
347: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: END IF;
351:
352: SELECT igf_sl_dl_chg_fld_s.NEXTVAL into x_dchg_id FROM DUAL;
353:

Line 446: app_exception.raise_exception;

442: IF (c1%notfound) THEN
443: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
444: igs_ge_msg_stack.add;
445: CLOSE c1;
446: app_exception.raise_exception;
447: RETURN;
448: END IF;
449: CLOSE c1;
450:

Line 462: app_exception.raise_exception;

458: NULL;
459: ELSE
460: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
461: igs_ge_msg_stack.add;
462: app_exception.raise_exception;
463: END IF;
464:
465: RETURN;
466:

Line 511: app_exception.raise_exception;

507: END IF;
508: ELSE
509: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
510: igs_ge_msg_stack.add;
511: app_exception.raise_exception;
512: END IF;
513:
514: before_dml(
515: p_action => 'UPDATE',