66: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
67: CLOSE cur_old_ref_values;
68: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
69: igs_ge_msg_stack.add;
70: app_exception.raise_exception;
71: RETURN;
72: END IF;
73: CLOSE cur_old_ref_values;
74:
143: fnd_message.set_name ('IGS', 'IGS_PE_VIS_ASOC_PASS_EXP');
144: fnd_message.set_token('PASSPORT_DATE',new_references.passport_expiry_date);
145: fnd_message.set_token('VISA_DATE',l_date);
146: igs_ge_msg_stack.add;
147: app_exception.raise_exception;
148: END IF;
149: CLOSE get_count_exp_dt;
150: END beforerowupdate;
151:
175: IF l_birth_dt IS NOT NULL AND new_references.passport_expiry_date IS NOT NULL THEN
176: IF l_birth_dt > new_references.passport_expiry_date THEN
177: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_INT_DT_LT_BRDT');
178: IGS_GE_MSG_STACK.ADD;
179: APP_EXCEPTION.RAISE_EXCEPTION;
180: END IF;
181: END IF;
182: END IF;
183: END beforerowinsertupdate;
201: )
202: ) THEN
203: fnd_message.set_name ('IGS', 'IGS_PE_PASSPORT_DUP_EXISTS');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:
208: END check_uniqueness;
209:
246: new_references.person_id
247: ) THEN
248: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252:
253:
254: END Check_Parent_Existance;
418: )
419: ) THEN
420: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
421: igs_ge_msg_stack.add;
422: app_exception.raise_exception;
423: END IF;
424: beforerowinsertupdate(TRUE, FALSE);
425: check_uniqueness;
426: check_parent_existance;
440: )
441: ) THEN
442: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
443: igs_ge_msg_stack.add;
444: app_exception.raise_exception;
445: END IF;
446: check_uniqueness;
447: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
448: check_uniqueness;
514: END IF;
515: ELSE
516: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
517: igs_ge_msg_stack.add;
518: app_exception.raise_exception;
519: END IF;
520:
521: before_dml(
522: p_action => 'INSERT',
634: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
635: fnd_message.set_token ('ERR_CD', SQLCODE);
636: igs_ge_msg_stack.add;
637: igs_sc_gen_001.unset_ctx('R');
638: app_exception.raise_exception;
639: ELSE
640: igs_sc_gen_001.unset_ctx('R');
641: RAISE;
642: END IF;
721: IF (c1%notfound) THEN
722: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
723: igs_ge_msg_stack.add;
724: CLOSE c1;
725: app_exception.raise_exception;
726: RETURN;
727: END IF;
728: CLOSE c1;
729:
757: NULL;
758: ELSE
759: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
760: igs_ge_msg_stack.add;
761: app_exception.raise_exception;
762: END IF;
763:
764: RETURN;
765:
826: END IF;
827: ELSE
828: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
829: igs_ge_msg_stack.add;
830: app_exception.raise_exception;
831: END IF;
832:
833: before_dml(
834: p_action => 'UPDATE',
904: IF (SQL%NOTFOUND) THEN
905: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
906: igs_ge_msg_stack.add;
907: igs_sc_gen_001.unset_ctx('R');
908: app_exception.raise_exception;
909: END IF;
910: IF (x_mode = 'S') THEN
911: igs_sc_gen_001.unset_ctx('R');
912: END IF;
917: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
918: fnd_message.set_token ('ERR_CD', SQLCODE);
919: igs_ge_msg_stack.add;
920: igs_sc_gen_001.unset_ctx('R');
921: app_exception.raise_exception;
922: ELSE
923: igs_sc_gen_001.unset_ctx('R');
924: RAISE;
925: END IF;
1075: IF (SQL%NOTFOUND) THEN
1076: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1077: igs_ge_msg_stack.add;
1078: igs_sc_gen_001.unset_ctx('R');
1079: app_exception.raise_exception;
1080: END IF;
1081: IF (x_mode = 'S') THEN
1082: igs_sc_gen_001.unset_ctx('R');
1083: END IF;