eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_HZ_REL_PKG dependencies on FND_MESSAGE

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

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

Line 282: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_AND');

278:
279: --
280: -- prepare the joint salutation
281: --
282: FND_MESSAGE.SET_NAME('IGS', 'IGS_AD_AND');
283:
284: IF rec_prime_member_detail.surname = rec_sec_member_detail.surname THEN
285: IF rec_prime_member_detail.prefix IS NULL AND rec_sec_member_detail.prefix IS NOT NULL THEN
286: lv_joint_salutation := rec_sec_member_detail.prefix||' '||rec_prime_member_detail.given_names||' '||rec_prime_member_detail.surname;

Line 295: lv_joint_salutation := rec_prime_member_detail.prefix||' '||FND_MESSAGE.GET||' '||rec_sec_member_detail.prefix||' '||rec_prime_member_detail.given_names||' '||rec_prime_member_detail.surname;

291: ELSIF rec_prime_member_detail.prefix IS NOT NULL AND rec_sec_member_detail.prefix IS NULL THEN
292: lv_joint_salutation := rec_prime_member_detail.prefix||' '||rec_prime_member_detail.given_names||' '||rec_prime_member_detail.surname;
293:
294: ELSE
295: lv_joint_salutation := rec_prime_member_detail.prefix||' '||FND_MESSAGE.GET||' '||rec_sec_member_detail.prefix||' '||rec_prime_member_detail.given_names||' '||rec_prime_member_detail.surname;
296: END IF;
297: ELSE
298: IF ( (rec_prime_member_detail.prefix IS NULL) AND (rec_prime_member_detail.given_names IS NULL) AND (rec_prime_member_detail.surname IS NULL) ) THEN
299: lv_joint_salutation := rec_sec_member_detail.prefix||' '||rec_sec_member_detail.given_names||' '||rec_sec_member_detail.surname;

Line 302: rec_prime_member_detail.surname||' '||FND_MESSAGE.GET||' '||rec_sec_member_detail.prefix||' '||

298: IF ( (rec_prime_member_detail.prefix IS NULL) AND (rec_prime_member_detail.given_names IS NULL) AND (rec_prime_member_detail.surname IS NULL) ) THEN
299: lv_joint_salutation := rec_sec_member_detail.prefix||' '||rec_sec_member_detail.given_names||' '||rec_sec_member_detail.surname;
300: ELSE
301: lv_joint_salutation := rec_prime_member_detail.prefix||' '||rec_prime_member_detail.given_names||' '||
302: rec_prime_member_detail.surname||' '||FND_MESSAGE.GET||' '||rec_sec_member_detail.prefix||' '||
303: rec_sec_member_detail.given_names||' '||rec_sec_member_detail.surname;
304: END IF;
305: END IF;
306:

Line 329: fnd_message.set_name('IGS', 'IGS_AD_NOT_BOTH_PRIM_SEC');

325: || (reverse chronological order - newest change first)
326: */
327: BEGIN
328: IF new_references.primary = 'Y' AND new_references.secondary = 'Y' THEN
329: fnd_message.set_name('IGS', 'IGS_AD_NOT_BOTH_PRIM_SEC');
330: igs_ge_msg_stack.add;
331: app_exception.raise_exception;
332: END IF;
333: END before_row_insert_update;

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

359: OPEN rel_pk;
360: FETCH rel_pk INTO l_var;
361: IF rel_pk%NOTFOUND THEN
362: CLOSE rel_pk;
363: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
364: igs_ge_msg_stack.add;
365: app_exception.raise_exception;
366: END IF;
367: CLOSE rel_pk;

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

465: new_references.relationship_id,
466: new_references.directional_flag
467: )
468: ) THEN
469: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
470: igs_ge_msg_stack.add;
471: app_exception.raise_exception;
472: END IF;
473: check_parent_existance;

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

482: new_references.relationship_id,
483: new_references.directional_flag
484: )
485: ) THEN
486: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490: before_row_insert_update;

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

578: IF (x_last_update_login IS NULL) THEN
579: x_last_update_login := -1;
580: END IF;
581: ELSE
582: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
583: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.INSERT_ROW');
584: igs_ge_msg_stack.add;
585: app_exception.raise_exception;
586: END IF;

Line 583: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.INSERT_ROW');

579: x_last_update_login := -1;
580: END IF;
581: ELSE
582: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
583: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.INSERT_ROW');
584: igs_ge_msg_stack.add;
585: app_exception.raise_exception;
586: END IF;
587:

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

696:
697: EXCEPTION
698: WHEN OTHERS THEN
699: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
700: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
701: fnd_message.set_token ('ERR_CD', SQLCODE);
702: igs_ge_msg_stack.add;
703: igs_sc_gen_001.unset_ctx('R');
704: app_exception.raise_exception;

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

697: EXCEPTION
698: WHEN OTHERS THEN
699: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
700: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
701: fnd_message.set_token ('ERR_CD', SQLCODE);
702: igs_ge_msg_stack.add;
703: igs_sc_gen_001.unset_ctx('R');
704: app_exception.raise_exception;
705: ELSE

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

753:
754: OPEN c1;
755: FETCH c1 INTO tlinfo;
756: IF (c1%notfound) THEN
757: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
758: igs_ge_msg_stack.add;
759: CLOSE c1;
760: app_exception.raise_exception;
761: RETURN;

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

774: AND ((tlinfo.emergency_contact_flag = x_emergency_contact_flag) OR ((tlinfo.emergency_contact_flag IS NULL) AND (X_emergency_contact_flag IS NULL)))
775: ) THEN
776: NULL;
777: ELSE
778: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
779: igs_ge_msg_stack.add;
780: app_exception.raise_exception;
781: END IF;
782:

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

828: IF (x_last_update_login IS NULL) THEN
829: x_last_update_login := -1;
830: END IF;
831: ELSE
832: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
833: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.UPDATE_ROW');
834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;
836: END IF;

Line 833: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.UPDATE_ROW');

829: x_last_update_login := -1;
830: END IF;
831: ELSE
832: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
833: fnd_message.set_token ('ROUTINE', 'IGS_PE_HZ_REL_PKG.UPDATE_ROW');
834: igs_ge_msg_stack.add;
835: app_exception.raise_exception;
836: END IF;
837:

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

895: WHERE rowid = x_rowid;
896: END IF;
897:
898: IF (SQL%NOTFOUND) THEN
899: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
900: igs_ge_msg_stack.add;
901: igs_sc_gen_001.unset_ctx('R');
902: app_exception.raise_exception;
903: END IF;

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

911:
912: EXCEPTION
913: WHEN OTHERS THEN
914: IF (SQLCODE = (-28115)) THEN
915: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
916: fnd_message.set_token ('ERR_CD', SQLCODE);
917: igs_ge_msg_stack.add;
918: igs_sc_gen_001.unset_ctx('R');
919: app_exception.raise_exception;

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

912: EXCEPTION
913: WHEN OTHERS THEN
914: IF (SQLCODE = (-28115)) THEN
915: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
916: fnd_message.set_token ('ERR_CD', SQLCODE);
917: igs_ge_msg_stack.add;
918: igs_sc_gen_001.unset_ctx('R');
919: app_exception.raise_exception;
920: ELSE

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

1025: DELETE FROM igs_pe_hz_rel
1026: WHERE rowid = x_rowid;
1027:
1028: IF (SQL%NOTFOUND) THEN
1029: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1030: igs_ge_msg_stack.add;
1031: igs_sc_gen_001.unset_ctx('R');
1032: app_exception.raise_exception;
1033: END IF;