DBA Data[Home] [Help]

APPS.IGS_UC_APPLICANTS_PKG dependencies on IGS_GE_MSG_STACK

Line 155: igs_ge_msg_stack.add;

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;
159: CLOSE cur_old_ref_values;

Line 362: igs_ge_msg_stack.add;

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:
366: IF (((old_references.oss_person_id = new_references.oss_person_id)) OR

Line 373: igs_ge_msg_stack.add;

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:
377: END check_parent_existance;

Line 395: igs_ge_msg_stack.add;

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:
399:

Line 431: igs_ge_msg_stack.add;

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;
435: CLOSE cur_rowid;

Line 465: igs_ge_msg_stack.add;

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;
469: CLOSE cur_rowid;

Line 800: igs_ge_msg_stack.add;

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;
804: check_uniqueness;

Line 819: igs_ge_msg_stack.add;

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
823: check_child_existance;

Line 985: igs_ge_msg_stack.add;

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:
989: SELECT igs_uc_applicants_s1.NEXTVAL

Line 1362: igs_ge_msg_stack.add;

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
1366: igs_sc_gen_001.unset_ctx('R');

Line 1614: igs_ge_msg_stack.add;

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;
1618: END IF;

Line 1732: igs_ge_msg_stack.add;

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:
1736: RETURN;

Line 1886: igs_ge_msg_stack.add;

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:
1890: before_dml(

Line 2125: igs_ge_msg_stack.add;

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;
2129: IF (x_mode = 'S') THEN

Line 2142: igs_ge_msg_stack.add;

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
2146: igs_sc_gen_001.unset_ctx('R');

Line 2548: igs_ge_msg_stack.add;

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;
2552: IF (x_mode = 'S') THEN