DBA Data[Home] [Help]

APPS.IGS_PE_RACE_PKG dependencies on FND_MESSAGE

Line 44: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

40: OPEN cur_old_ref_values;
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;

Line 86: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');

82: ((new_references.race_cd IS NULL))) THEN
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;

Line 98: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

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

Line 184: fnd_message.set_name('IGS','IGS_PE_RACE_DUP_EXISTS');

180: new_references.person_id,
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:

Line 198: fnd_message.set_name('IGS','IGS_PE_RACE_DUP_EXISTS');

194: new_references.person_id,
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;

Line 245: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

241: IF (x_last_update_login IS NULL) THEN
242: x_last_update_login := -1;
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;

Line 246: fnd_message.set_token ('ROUTINE', 'IGS_PE_RACE_PKG.INSERT_ROW');

242: x_last_update_login := -1;
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:

Line 292: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');

288:
289: EXCEPTION
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;

Line 293: fnd_message.set_token ('ERR_CD', SQLCODE);

289: EXCEPTION
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

Line 332: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

328:
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;

Line 373: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

369: DELETE FROM igs_pe_race
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;