DBA Data[Home] [Help]

APPS.IGS_AD_HZ_EMP_DTL_PKG dependencies on FND_MESSAGE

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

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

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

101: ELSE
102: Open cur_rowid;
103: Fetch cur_rowid INTO lv_rowid;
104: IF (cur_rowid%NOTFOUND) THEN
105: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: Close cur_rowid;

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

169: OPEN cur_rowid;
170: FETCH cur_rowid INTO lv_rowid;
171: IF (cur_rowid%FOUND) THEN
172: CLOSE cur_rowid;
173: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: RETURN;
177: END IF;

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

231: IF ( get_pk_for_validation(
232: new_references.hz_emp_dtl_id
233: )
234: ) THEN
235: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
236: igs_ge_msg_stack.add;
237: app_exception.raise_exception;
238: END IF;
239: check_parent_existance;

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

250: IF ( get_pk_for_validation (
251: new_references.hz_emp_dtl_id
252: )
253: ) THEN
254: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258: END IF;

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

305: IF (x_last_update_login IS NULL) THEN
306: x_last_update_login := -1;
307: END IF;
308: ELSE
309: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
310: igs_ge_msg_stack.add;
311: app_exception.raise_exception;
312: END IF;
313:

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

378:
379: EXCEPTION
380: WHEN OTHERS THEN
381: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
382: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
383: fnd_message.set_token ('ERR_CD', SQLCODE);
384: igs_ge_msg_stack.add;
385: igs_sc_gen_001.unset_ctx('R');
386: app_exception.raise_exception;

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

379: EXCEPTION
380: WHEN OTHERS THEN
381: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
382: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
383: fnd_message.set_token ('ERR_CD', SQLCODE);
384: igs_ge_msg_stack.add;
385: igs_sc_gen_001.unset_ctx('R');
386: app_exception.raise_exception;
387: ELSE

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

431:
432: OPEN c1;
433: FETCH c1 INTO tlinfo;
434: IF (c1%notfound) THEN
435: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
436: igs_ge_msg_stack.add;
437: CLOSE c1;
438: app_exception.raise_exception;
439: RETURN;

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

446: AND ((tlinfo.occupational_title_code = x_occupational_title_code) OR ((tlinfo.occupational_title_code IS NULL) AND (X_occupational_title_code IS NULL)))
447: ) THEN
448: NULL;
449: ELSE
450: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
451: igs_ge_msg_stack.add;
452: app_exception.raise_exception;
453: END IF;
454:

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

497: IF (x_last_update_login IS NULL) THEN
498: x_last_update_login := -1;
499: END IF;
500: ELSE
501: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
502: igs_ge_msg_stack.add;
503: app_exception.raise_exception;
504: END IF;
505:

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

539: last_update_login = x_last_update_login
540: WHERE rowid = x_rowid;
541:
542: IF (SQL%NOTFOUND) THEN
543: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
544: igs_ge_msg_stack.add;
545: igs_sc_gen_001.unset_ctx('R');
546: app_exception.raise_exception;
547: END IF;

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

553:
554: EXCEPTION
555: WHEN OTHERS THEN
556: IF (SQLCODE = (-28115)) THEN
557: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
558: fnd_message.set_token ('ERR_CD', SQLCODE);
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;

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

554: EXCEPTION
555: WHEN OTHERS THEN
556: IF (SQLCODE = (-28115)) THEN
557: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
558: fnd_message.set_token ('ERR_CD', SQLCODE);
559: igs_ge_msg_stack.add;
560: igs_sc_gen_001.unset_ctx('R');
561: app_exception.raise_exception;
562: ELSE

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

659: DELETE FROM igs_ad_hz_emp_dtl
660: WHERE rowid = x_rowid;
661:
662: IF (SQL%NOTFOUND) THEN
663: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
664: igs_ge_msg_stack.add;
665: igs_sc_gen_001.unset_ctx('R');
666: app_exception.raise_exception;
667: END IF;