APPS.IGS_PE_RACE_PKG dependencies on IGS_GE_MSG_STACK

Line 45: igs_ge_msg_stack.add;

41: FETCH cur_old_ref_values INTO old_references;
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;

Line 87: IGS_GE_MSG_STACK.ADD;

83: NULL;
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:

Line 99: IGS_GE_MSG_STACK.ADD;

95: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
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;

Line 185: igs_ge_msg_stack.add;

181: new_references.race_cd
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;

Line 199: igs_ge_msg_stack.add;

195: new_references.race_cd
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:

Line 247: igs_ge_msg_stack.add;

243: END IF;
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(

Line 294: igs_ge_msg_stack.add;

290: WHEN OTHERS THEN
291: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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');

Line 333: igs_ge_msg_stack.add;

329: OPEN c1;
330: FETCH c1 INTO tlinfo;
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;

Line 374: igs_ge_msg_stack.add;

370: WHERE rowid = x_rowid;
371:
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