DBA Data[Home] [Help]

APPS.IGS_HE_UT_PRT_AWARD_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 93: app_exception.raise_exception;

89: 'N'
90: ) THEN
91: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
92: igs_ge_msg_stack.add;
93: app_exception.raise_exception;
94: END IF;
95:
96: IF (((old_references.award_cd = new_references.award_cd)) OR
97: ((new_references.award_cd IS NULL))) THEN

Line 104: app_exception.raise_exception;

100: new_references.award_cd
101: ) THEN
102: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
103: igs_ge_msg_stack.add;
104: app_exception.raise_exception;
105: END IF;
106:
107:
108: IF (((old_references.parent_award_cd = new_references.parent_award_cd)) OR

Line 116: app_exception.raise_exception;

112: new_references.parent_award_cd
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
119: END check_parent_existance;
120:

Line 204: app_exception.raise_exception;

200: )
201: ) THEN
202: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
203: igs_ge_msg_stack.add;
204: app_exception.raise_exception;
205: END IF;
206: check_parent_existance;
207: ELSIF (p_action = 'UPDATE') THEN
208: -- Call all the procedures related to Before Update.

Line 219: app_exception.raise_exception;

215: )
216: ) THEN
217: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: END IF;
221: END IF;
222:
223: END before_dml;

Line 266: app_exception.raise_exception;

262: ELSE
263: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
264: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRT_AWARD_PKG.INSERT_ROW');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268:
269: before_dml(
270: p_action => 'INSERT',

Line 337: app_exception.raise_exception;

333: IF (c1%notfound) THEN
334: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
335: igs_ge_msg_stack.add;
336: CLOSE c1;
337: app_exception.raise_exception;
338: RETURN;
339: END IF;
340: CLOSE c1;
341:

Line 349: app_exception.raise_exception;

345: NULL;
346: ELSE
347: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: END IF;
351:
352: RETURN;
353:

Line 396: app_exception.raise_exception;

392: ELSE
393: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
394: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRT_AWARD_PKG.UPDATE_ROW');
395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: END IF;
398:
399: before_dml(
400: p_action => 'UPDATE',