DBA Data[Home] [Help]

APPS.IGS_UC_APPLICANTS_PKG dependencies on FND_MESSAGE

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

150: OPEN cur_old_ref_values;
151: FETCH cur_old_ref_values INTO old_references;
152: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
153: CLOSE cur_old_ref_values;
154: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
155: igs_ge_msg_stack.add;
156: app_exception.raise_exception;
157: RETURN;
158: END IF;

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

357: NULL;
358: ELSIF NOT igs_uc_defaults_pkg.get_pk_for_validation (
359: new_references.system_code
360: ) THEN
361: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
362: igs_ge_msg_stack.add;
363: app_exception.raise_exception;
364: END IF;
365:

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

368: NULL;
369: ELSIF NOT igs_pe_person_pkg.get_pk_for_validation (
370: new_references.oss_person_id
371: ) THEN
372: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
373: igs_ge_msg_stack.add;
374: app_exception.raise_exception;
375: END IF;
376:

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

390: BEGIN
391:
392: IF ( get_uk_for_validation(new_references.app_no)
393: ) THEN
394: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: END IF;
398:

Line 430: fnd_message.set_name ('IGS', 'IGS_UC_UCAP_UAS_FK');

426: OPEN cur_rowid;
427: FETCH cur_rowid INTO lv_rowid;
428: IF (cur_rowid%FOUND) THEN
429: CLOSE cur_rowid;
430: fnd_message.set_name ('IGS', 'IGS_UC_UCAP_UAS_FK');
431: igs_ge_msg_stack.add;
432: app_exception.raise_exception;
433: RETURN;
434: END IF;

Line 464: fnd_message.set_name ('IGS', 'IGS_UC_UCAP_PE_FK');

460: OPEN cur_rowid;
461: FETCH cur_rowid INTO lv_rowid;
462: IF (cur_rowid%FOUND) THEN
463: CLOSE cur_rowid;
464: fnd_message.set_name ('IGS', 'IGS_UC_UCAP_PE_FK');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: RETURN;
468: END IF;

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

795: IF ( get_pk_for_validation(
796: new_references.app_id
797: )
798: ) THEN
799: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
800: igs_ge_msg_stack.add;
801: app_exception.raise_exception;
802: END IF;
803: check_parent_existance;

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

814: IF ( get_pk_for_validation (
815: new_references.app_id
816: )
817: ) THEN
818: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
819: igs_ge_msg_stack.add;
820: app_exception.raise_exception;
821: END IF;
822: ELSIF (p_action = 'VALIDATE_DELETE') THEN

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

980: IF (x_last_update_login IS NULL) THEN
981: x_last_update_login := -1;
982: END IF;
983: ELSE
984: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
985: igs_ge_msg_stack.add;
986: app_exception.raise_exception;
987: END IF;
988:

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

1356:
1357: EXCEPTION
1358: WHEN OTHERS THEN
1359: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1360: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1361: fnd_message.set_token ('ERR_CD', SQLCODE);
1362: igs_ge_msg_stack.add;
1363: igs_sc_gen_001.unset_ctx('R');
1364: app_exception.raise_exception;

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

1357: EXCEPTION
1358: WHEN OTHERS THEN
1359: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1360: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1361: fnd_message.set_token ('ERR_CD', SQLCODE);
1362: igs_ge_msg_stack.add;
1363: igs_sc_gen_001.unset_ctx('R');
1364: app_exception.raise_exception;
1365: ELSE

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

1609:
1610: OPEN c1;
1611: FETCH c1 INTO tlinfo;
1612: IF (c1%notfound) THEN
1613: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1614: igs_ge_msg_stack.add;
1615: CLOSE c1;
1616: app_exception.raise_exception;
1617: RETURN;

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

1727: AND ((tlinfo.personal_id = x_personal_id ) OR (( tlinfo.personal_id IS NULL) AND ( x_personal_id IS NULL)))
1728: ) THEN
1729: NULL;
1730: ELSE
1731: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1732: igs_ge_msg_stack.add;
1733: app_exception.raise_exception;
1734: END IF;
1735:

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

1881: IF (x_last_update_login IS NULL) THEN
1882: x_last_update_login := -1;
1883: END IF;
1884: ELSE
1885: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1886: igs_ge_msg_stack.add;
1887: app_exception.raise_exception;
1888: END IF;
1889:

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

2120: personal_id = new_references.personal_id
2121: WHERE rowid = x_rowid;
2122:
2123: IF (SQL%NOTFOUND) THEN
2124: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2125: igs_ge_msg_stack.add;
2126: igs_sc_gen_001.unset_ctx('R');
2127: app_exception.raise_exception;
2128: END IF;

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

2136:
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: IF (SQLCODE = (-28115)) THEN
2140: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
2141: fnd_message.set_token ('ERR_CD', SQLCODE);
2142: igs_ge_msg_stack.add;
2143: igs_sc_gen_001.unset_ctx('R');
2144: app_exception.raise_exception;

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

2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: IF (SQLCODE = (-28115)) THEN
2140: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
2141: fnd_message.set_token ('ERR_CD', SQLCODE);
2142: igs_ge_msg_stack.add;
2143: igs_sc_gen_001.unset_ctx('R');
2144: app_exception.raise_exception;
2145: ELSE

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

2543: DELETE FROM igs_uc_applicants
2544: WHERE rowid = x_rowid;
2545:
2546: IF (SQL%NOTFOUND) THEN
2547: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
2548: igs_ge_msg_stack.add;
2549: igs_sc_gen_001.unset_ctx('R');
2550: app_exception.raise_exception;
2551: END IF;