DBA Data[Home] [Help]

APPS.IGS_PE_DEPD_ACTIVE_PKG dependencies on FND_MESSAGE

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

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

Line 168: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

164: new_references.action_code,
165: new_references.effective_date
166: )
167: ) THEN
168: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
169: igs_ge_msg_stack.add;
170: app_exception.raise_exception;
171: END IF;
172: ELSIF (p_action = 'VALIDATE_INSERT') THEN

Line 180: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

176: new_references.action_code,
177: new_references.effective_date
178: )
179: ) THEN
180: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: END IF;
184: END IF;

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

225: IF (x_last_update_login IS NULL) THEN
226: x_last_update_login := -1;
227: END IF;
228: ELSE
229: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
230: igs_ge_msg_stack.add;
231: app_exception.raise_exception;
232: END IF;
233:

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

283:
284: EXCEPTION
285: WHEN OTHERS THEN
286: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
287: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
288: fnd_message.set_token ('ERR_CD', SQLCODE);
289: igs_ge_msg_stack.add;
290: igs_sc_gen_001.unset_ctx('R');
291: app_exception.raise_exception;

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

284: EXCEPTION
285: WHEN OTHERS THEN
286: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
287: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
288: fnd_message.set_token ('ERR_CD', SQLCODE);
289: igs_ge_msg_stack.add;
290: igs_sc_gen_001.unset_ctx('R');
291: app_exception.raise_exception;
292: ELSE

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

329:
330: OPEN c1;
331: FETCH c1 INTO tlinfo;
332: IF (c1%notfound) THEN
333: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
334: igs_ge_msg_stack.add;
335: CLOSE c1;
336: app_exception.raise_exception;
337: RETURN;

Line 348: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

344: AND ((tlinfo.other_reason_remarks = x_other_reason_remarks) OR ((tlinfo.other_reason_remarks IS NULL) AND (x_other_reason_remarks IS NULL )))
345: ) THEN
346: NULL;
347: ELSE
348: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352:

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

393: IF (x_last_update_login IS NULL) THEN
394: x_last_update_login := -1;
395: END IF;
396: ELSE
397: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
398: igs_ge_msg_stack.add;
399: app_exception.raise_exception;
400: END IF;
401:

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

428: other_reason_remarks = x_other_reason_remarks
429: WHERE rowid = x_rowid;
430:
431: IF (SQL%NOTFOUND) THEN
432: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
433: igs_ge_msg_stack.add;
434: igs_sc_gen_001.unset_ctx('R');
435: app_exception.raise_exception;
436: END IF;

Line 446: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');

442:
443: EXCEPTION
444: WHEN OTHERS THEN
445: IF (SQLCODE = (-28115)) THEN
446: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
447: fnd_message.set_token ('ERR_CD', SQLCODE);
448: igs_ge_msg_stack.add;
449: igs_sc_gen_001.unset_ctx('R');
450: app_exception.raise_exception;

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

443: EXCEPTION
444: WHEN OTHERS THEN
445: IF (SQLCODE = (-28115)) THEN
446: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
447: fnd_message.set_token ('ERR_CD', SQLCODE);
448: igs_ge_msg_stack.add;
449: igs_sc_gen_001.unset_ctx('R');
450: app_exception.raise_exception;
451: ELSE

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

542: DELETE FROM igs_pe_depd_active
543: WHERE rowid = x_rowid;
544:
545: IF (SQL%NOTFOUND) THEN
546: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
547: igs_ge_msg_stack.add;
548: igs_sc_gen_001.unset_ctx('R');
549: app_exception.raise_exception;
550: END IF;