DBA Data[Home] [Help]

APPS.IGS_HE_UT_LVL_AWARD_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 99: app_exception.raise_exception;

95: new_references.tariff_level_cd
96: ) THEN
97: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
102: IF (((old_references.award_cd = new_references.award_cd)) OR
103: ((new_references.award_cd IS NULL))) THEN

Line 110: app_exception.raise_exception;

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

Line 209: app_exception.raise_exception;

205: )
206: ) THEN
207: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: END IF;
211: check_parent_existance;
212: ELSIF (p_action = 'UPDATE') THEN
213: -- Call all the procedures related to Before Update.

Line 225: app_exception.raise_exception;

221: )
222: ) THEN
223: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
224: igs_ge_msg_stack.add;
225: app_exception.raise_exception;
226: END IF;
227: END IF;
228:
229: END before_dml;

Line 274: app_exception.raise_exception;

270: ELSE
271: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
272: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_LVL_AWARD_PKG.INSERT_ROW');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: END IF;
276:
277: before_dml(
278: p_action => 'INSERT',

Line 354: app_exception.raise_exception;

350: IF (c1%notfound) THEN
351: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
352: igs_ge_msg_stack.add;
353: CLOSE c1;
354: app_exception.raise_exception;
355: RETURN;
356: END IF;
357: CLOSE c1;
358:

Line 367: app_exception.raise_exception;

363: NULL;
364: ELSE
365: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
366: igs_ge_msg_stack.add;
367: app_exception.raise_exception;
368: END IF;
369:
370: RETURN;
371:

Line 416: app_exception.raise_exception;

412: ELSE
413: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
414: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_LVL_AWARD_PKG.UPDATE_ROW');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418:
419: before_dml(
420: p_action => 'UPDATE',