APPS.IGS_PS_AWD_HNR_BASE_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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

Line 110: APP_EXCEPTION.RAISE_EXCEPTION;

106: IF cur_chk_prof%FOUND THEN
107: CLOSE cur_chk_prof;
108: FND_MESSAGE.SET_NAME ('FND', 'IGS_GE_RECORD_ALREADY_EXISTS');
109: IGS_GE_MSG_STACK.ADD;
110: APP_EXCEPTION.RAISE_EXCEPTION;
111: END IF;
112: CLOSE cur_chk_prof;
113: END IF;
114: OPEN cur_chk_unk_unt_lvl;

Line 120: APP_EXCEPTION.RAISE_EXCEPTION;

116: IF cur_chk_unk_unt_lvl%FOUND THEN
117: CLOSE cur_chk_unk_unt_lvl;
118: FND_MESSAGE.SET_NAME ('FND', 'IGS_PR_AWD_UL_EXISTS');
119: IGS_GE_MSG_STACK.ADD;
120: APP_EXCEPTION.RAISE_EXCEPTION;
121: END IF;
122: CLOSE cur_chk_unk_unt_lvl;
123:
124:

Line 149: app_exception.raise_exception;

145: new_references.award_cd
146: ) THEN
147: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151:
152: IF (((old_references.unit_level = new_references.unit_level)) OR
153: ((new_references.unit_level IS NULL))) THEN

Line 160: app_exception.raise_exception;

156: new_references.unit_level
157: ) THEN
158: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: END IF;
162:
163: IF (((old_references.stat_type = new_references.stat_type) AND
164: (old_references.s_stat_element = new_references.s_stat_element)) OR

Line 174: app_exception.raise_exception;

170: new_references.s_stat_element
171: ) THEN
172: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: END IF;
176:
177: END check_parent_existance;
178:

Line 267: app_exception.raise_exception;

263: )
264: ) THEN
265: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
266: igs_ge_msg_stack.add;
267: app_exception.raise_exception;
268: END IF;
269: check_parent_existance;
270: beforeinsertupdate(x_rowid);
271: ELSIF (p_action = 'UPDATE') THEN

Line 283: app_exception.raise_exception;

279: )
280: ) THEN
281: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
282: igs_ge_msg_stack.add;
283: app_exception.raise_exception;
284: END IF;
285: beforeinsertupdate(x_rowid);
286: END IF;
287:

Line 335: app_exception.raise_exception;

331: ELSE
332: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
333: fnd_message.set_token ('ROUTINE', 'IGS_PS_AWD_HNR_BASE_PKG.INSERT_ROW');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: END IF;
337:
338: x_awd_hnr_basis_id := NULL;
339:

Line 429: app_exception.raise_exception;

425: IF (c1%notfound) THEN
426: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
427: igs_ge_msg_stack.add;
428: CLOSE c1;
429: app_exception.raise_exception;
430: RETURN;
431: END IF;
432: CLOSE c1;
433:

Line 446: app_exception.raise_exception;

442: NULL;
443: ELSE
444: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
445: igs_ge_msg_stack.add;
446: app_exception.raise_exception;
447: END IF;
448:
449: RETURN;
450:

Line 497: app_exception.raise_exception;

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