[Home] [Help]
65: FETCH cur_old_ref_values INTO old_references;
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;
142: CLOSE get_count_exp_dt;
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;
174:
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;
200: new_references.passport_number
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;
245: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation (
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:
417: new_references.passport_id
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;
439: new_references.passport_id
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
513: x_last_update_login := -1;
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(
632: WHEN OTHERS THEN
633: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
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');
719: OPEN c1;
720: FETCH c1 INTO tlinfo;
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;
756: ) THEN
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;
825: x_last_update_login := -1;
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(
902: WHERE rowid = x_rowid;
903:
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
915: WHEN OTHERS THEN
916: IF (SQLCODE = (-28115)) THEN
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');
1073: WHERE rowid = x_rowid;
1074:
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