APPS.IGS_PE_RACE_PKG dependencies on APP_EXCEPTION

Line 46: app_exception.raise_exception;

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

Line 88: APP_EXCEPTION.RAISE_EXCEPTION;

84: ELSE
85: IF NOT IGS_LOOKUPS_VIEW_PKG.get_pk_for_validation('PE_RACE',new_references.race_cd) THEN
86: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
87: IGS_GE_MSG_STACK.ADD;
88: APP_EXCEPTION.RAISE_EXCEPTION;
89: END IF;
90: END IF;
91:
92: IF (((old_references.person_id = new_references.person_id)) OR

Line 100: App_Exception.Raise_Exception;

96: new_references.person_id
97: ) THEN
98: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102:
103: END check_parent_existance;
104:

Line 186: app_exception.raise_exception;

182: )
183: ) THEN
184: fnd_message.set_name('IGS','IGS_PE_RACE_DUP_EXISTS');
185: igs_ge_msg_stack.add;
186: app_exception.raise_exception;
187: END IF;
188:
189: check_parent_existance;
190:

Line 200: app_exception.raise_exception;

196: )
197: ) THEN
198: fnd_message.set_name('IGS','IGS_PE_RACE_DUP_EXISTS');
199: igs_ge_msg_stack.add;
200: app_exception.raise_exception;
201: END IF;
202: END IF;
203:
204: check_parent_existance;

Line 248: app_exception.raise_exception;

244: ELSE
245: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
246: fnd_message.set_token ('ROUTINE', 'IGS_PE_RACE_PKG.INSERT_ROW');
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: END IF;
250:
251: before_dml(
252: p_action => 'INSERT',

Line 296: app_exception.raise_exception;

292: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
293: fnd_message.set_token ('ERR_CD', SQLCODE);
294: igs_ge_msg_stack.add;
295: igs_sc_gen_001.unset_ctx('R');
296: app_exception.raise_exception;
297: ELSE
298: igs_sc_gen_001.unset_ctx('R');
299: RAISE;
300: END IF;

Line 335: app_exception.raise_exception;

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

Line 376: app_exception.raise_exception;

372: IF (SQL%NOTFOUND) THEN
373: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
374: igs_ge_msg_stack.add;
375: igs_sc_gen_001.unset_ctx('R');
376: app_exception.raise_exception;
377: END IF;
378: IF (x_mode = 'S') THEN
379: igs_sc_gen_001.unset_ctx('R');
380: END IF;