[Home] [Help]
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;
90: IF ( get_uk_for_validation (
91: new_references.person_type
92: )
93: ) THEN
94: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
116: NULL;
117: ELSIF NOT igs_pe_person_types_pkg.get_pk_for_validation (
118: new_references.person_type
119: ) THEN
120: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
121: igs_ge_msg_stack.add;
122: app_exception.raise_exception;
123: END IF;
124:
127: NULL;
128: ELSIF NOT igs_ca_da_pkg.get_pk_for_validation (
129: new_references.record_open_dt_alias
130: ) THEN
131: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135:
138: NULL;
139: ELSIF NOT igs_ca_da_pkg.get_pk_for_validation (
140: new_references.record_cutoff_dt_alias
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
149: NULL;
150: ELSIF NOT igs_ca_da_pkg.get_pk_for_validation (
151: new_references.grad_sch_dt_alias
152: ) THEN
153: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
154: igs_ge_msg_stack.add;
155: app_exception.raise_exception;
156: END IF;
157:
160: NULL;
161: ELSIF NOT igs_ca_da_pkg.get_pk_for_validation (
162: new_references.upd_audit_dt_alias
163: ) THEN
164: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
165: igs_ge_msg_stack.add;
166: app_exception.raise_exception;
167: END IF;
168:
267: OPEN cur_rowid;
268: FETCH cur_rowid INTO lv_rowid;
269: IF (cur_rowid%FOUND) THEN
270: CLOSE cur_rowid;
271: fnd_message.set_name ('IGS', 'IGS_PE_UARGV_PTY_FK');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: RETURN;
275: END IF;
326: IF ( get_pk_for_validation(
327: new_references.usr_act_re_gs_id
328: )
329: ) THEN
330: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
331: igs_ge_msg_stack.add;
332: app_exception.raise_exception;
333: END IF;
334: check_uniqueness;
342: IF ( get_pk_for_validation (
343: new_references.usr_act_re_gs_id
344: )
345: ) THEN
346: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
347: igs_ge_msg_stack.add;
348: app_exception.raise_exception;
349: END IF;
350: check_uniqueness;
398: IF (x_last_update_login IS NULL) THEN
399: x_last_update_login := -1;
400: END IF;
401: ELSE
402: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
403: igs_ge_msg_stack.add;
404: app_exception.raise_exception;
405: END IF;
406:
503:
504: OPEN c1;
505: FETCH c1 INTO tlinfo;
506: IF (c1%notfound) THEN
507: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
508: igs_ge_msg_stack.add;
509: CLOSE c1;
510: app_exception.raise_exception;
511: RETURN;
520: AND ((tlinfo.upd_audit_dt_alias = x_upd_audit_dt_alias) OR ((tlinfo.upd_audit_dt_alias IS NULL) AND (X_upd_audit_dt_alias IS NULL)))
521: ) THEN
522: NULL;
523: ELSE
524: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
525: igs_ge_msg_stack.add;
526: app_exception.raise_exception;
527: END IF;
528:
569: IF (x_last_update_login IS NULL) THEN
570: x_last_update_login := -1;
571: END IF;
572: ELSE
573: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
574: igs_ge_msg_stack.add;
575: app_exception.raise_exception;
576: END IF;
577: