[Home] [Help]
56: Open cur_old_ref_values;
57: Fetch cur_old_ref_values INTO old_references;
58: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
59: Close cur_old_ref_values;
60: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
61: IGS_GE_MSG_STACK.ADD;
62: App_Exception.Raise_Exception;
63: Return;
64: END IF;
125: IF IGS_EN_VAL_SCHO.enrp_val_scho_insert (
126: new_references.person_id,
127: new_references.course_cd,
128: v_message_name) = FALSE THEN
129: fnd_message.set_name('IGS',v_message_name);
130: IGS_GE_MSG_STACK.ADD;
131: app_exception.raise_exception;
132:
133: END IF;
140: old_references.person_id,
141: old_references.course_cd,
142: old_references.start_dt,
143: v_message_name) = FALSE THEN
144: fnd_message.set_name('IGS',v_message_name);
145: IGS_GE_MSG_STACK.ADD;
146: app_exception.raise_exception;
147: END IF;
148: END IF;
160: NVL(new_references.nz_citizen_not_res_ind, 'NULL') ) THEN
161: IF IGS_EN_VAL_SCHO.enrp_val_scho_update (
162: old_references.start_dt,
163: v_message_name) = FALSE THEN
164: fnd_message.set_name('IGS',v_message_name);
165: IGS_GE_MSG_STACK.ADD;
166: app_exception.raise_exception;
167: END IF;
168: END IF;
181: IF igs_ad_val_edtl.genp_val_strt_end_dt (
182: new_references.start_dt,
183: new_references.end_dt,
184: v_message_name) = FALSE THEN
185: fnd_message.set_name('IGS',v_message_name);
186: IGS_GE_MSG_STACK.ADD;
187: app_exception.raise_exception;
188: END IF;
189: END IF;
199: new_references.start_dt,
200: new_references.end_dt,
201: new_references.hecs_payment_option,
202: v_message_name) = FALSE THEN
203: fnd_message.set_name('IGS',v_message_name);
204: IGS_GE_MSG_STACK.ADD;
205: app_exception.raise_exception;
206: END IF;
207: END IF;
210: NVL(new_references.hecs_payment_option, 'NULL') THEN
211: IF IGS_EN_VAL_SCHO.enrp_val_hpo_closed (
212: new_references.hecs_payment_option,
213: v_message_name) = FALSE THEN
214: fnd_message.set_name('IGS',v_message_name);
215: IGS_GE_MSG_STACK.ADD;
216: app_exception.raise_exception;
217: END IF;
218: END IF;
220: IF IGS_EN_VAL_SCHO.enrp_val_tfn_invalid (
221: new_references.tax_file_number,
222: new_references.tax_file_invalid_dt,
223: v_message_name) = FALSE THEN
224: fnd_message.set_name('IGS',v_message_name);
225: IGS_GE_MSG_STACK.ADD;
226: app_exception.raise_exception;
227: END IF;
228: -- Validate TAX FILE NUMBER CERTIFICATE NUMBER.
230: new_references.tax_file_number,
231: new_references.tax_file_invalid_dt,
232: new_references.tax_file_certificate_number,
233: v_message_name) = FALSE THEN
234: fnd_message.set_name('IGS',v_message_name);
235: IGS_GE_MSG_STACK.ADD;
236: app_exception.raise_exception;
237: END IF;
238: -- Validate the VISA INDICATORS.
249: new_references.nz_citizen_ind,
250: new_references.nz_citizen_less2yr_ind,
251: new_references.nz_citizen_not_res_ind,
252: v_message_name) = FALSE THEN
253: fnd_message.set_name('IGS',v_message_name);
254: IGS_GE_MSG_STACK.ADD;
255: app_exception.raise_exception;
256: END IF;
257: END IF;
267: new_references.hecs_payment_option,
268: v_message_name,
269: v_return_type) = FALSE THEN
270: IF v_return_type = cst_error THEN
271: fnd_message.set_name('IGS',v_message_name);
272: IGS_GE_MSG_STACK.ADD;
273: app_exception.raise_exception;
274: END IF;
275: END IF;
285: new_references.hecs_payment_option,
286: v_message_name,
287: v_return_type) = FALSE THEN
288: IF v_return_type = cst_error THEN
289: fnd_message.set_name('IGS',v_message_name);
290: IGS_GE_MSG_STACK.ADD;
291: app_exception.raise_exception;
292: END IF;
293: END IF;
312: NULL,
313: v_message_name,
314: v_return_type) = FALSE THEN
315: IF v_return_type = cst_error THEN
316: fnd_message.set_name('IGS',v_message_name);
317: IGS_GE_MSG_STACK.ADD;
318: app_exception.raise_exception;
319: END IF;
320: END IF;
338: NULL,
339: v_message_name,
340: v_return_type) = FALSE THEN
341: IF v_return_type = cst_error THEN
342: fnd_message.set_name('IGS',v_message_name);
343: IGS_GE_MSG_STACK.ADD;
344: app_exception.raise_exception;
345: END IF;
346: END IF;
365: NULL,
366: v_message_name,
367: v_return_type) = FALSE THEN
368: IF v_return_type = cst_error THEN
369: fnd_message.set_name('IGS',v_message_name);
370: IGS_GE_MSG_STACK.ADD;
371: app_exception.raise_exception;
372: END IF;
373: END IF;
401: NULL,
402: v_message_name,
403: v_return_type) = FALSE THEN
404: IF v_return_type = cst_error THEN
405: fnd_message.set_name('IGS',v_message_name);
406: IGS_GE_MSG_STACK.ADD;
407: app_exception.raise_exception;
408: END IF;
409: END IF;
432: NULL,
433: v_message_name,
434: v_return_type) = FALSE THEN
435: IF v_return_type = cst_error THEN
436: fnd_message.set_name('IGS',v_message_name);
437: IGS_GE_MSG_STACK.ADD;
438: app_exception.raise_exception;
439: END IF;
440: END IF;
472: NULL,
473: v_message_name,
474: v_return_type) = FALSE THEN
475: IF v_return_type = cst_error THEN
476: fnd_message.set_name('IGS',v_message_name);
477: IGS_GE_MSG_STACK.ADD;
478: app_exception.raise_exception;
479: END IF;
480: END IF;
503: NULL,
504: v_message_name,
505: v_return_type) = FALSE THEN
506: IF v_return_type = cst_error THEN
507: fnd_message.set_name('IGS',v_message_name);
508: IGS_GE_MSG_STACK.ADD;
509: app_exception.raise_exception;
510: END IF;
511: END IF;
592: New_References.person_id,
593: New_References.course_cd,
594: New_References.start_dt,
595: v_message_name) = FALSE THEN
596: fnd_message.set_name('IGS',v_message_name);
597: IGS_GE_MSG_STACK.ADD;
598: app_exception.raise_exception;
599: END IF;
600: END IF;
604: New_References.course_cd,
605: New_References.start_dt,
606: New_References.end_dt,
607: v_message_name) = FALSE THEN
608: fnd_message.set_name('IGS',v_message_name);
609: IGS_GE_MSG_STACK.ADD;
610: app_exception.raise_exception;
611: END IF;
612: -- Validate TAX FILE NUMBER.
617: New_References.tax_file_number,
618: v_message_name,
619: v_return_type) = FALSE THEN
620: IF v_return_type = cst_error THEN
621: fnd_message.set_name('IGS',v_message_name);
622: IGS_GE_MSG_STACK.ADD;
623: app_exception.raise_exception;
624: END IF;
625: END IF;
637: New_References.differential_hecs_ind,
638: v_message_name,
639: v_return_type) = FALSE THEN
640: IF v_return_type = cst_error THEN
641: fnd_message.set_name('IGS',v_message_name);
642: IGS_GE_MSG_STACK.ADD;
643: app_exception.raise_exception;
644: END IF;
645: END IF;
681: if upper(column_name) = 'DIFFERENTIAL_HECS_IND' OR
682: column_name is null then
683: if new_references.differential_hecs_ind not IN ('Y','N') OR
684: new_references.differential_hecs_ind <> upper(new_references.differential_hecs_ind) then
685: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
686: IGS_GE_MSG_STACK.ADD;
687: App_Exception.Raise_Exception;
688: end if;
689: end if;
690: if upper(column_name) = 'OUTSIDE_AUS_RES_IND' OR
691: column_name is null then
692: if new_references.outside_aus_res_ind not IN ('Y','N') OR
693: new_references.outside_aus_res_ind <> upper(new_references.outside_aus_res_ind) then
694: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
695: IGS_GE_MSG_STACK.ADD;
696: App_Exception.Raise_Exception;
697: end if;
698: end if;
699: if upper(column_name) = 'NZ_CITIZEN_IND' OR
700: column_name is null then
701: if new_references.nz_citizen_ind not IN ('Y','N') OR
702: new_references.nz_citizen_ind <> upper(new_references.nz_citizen_ind) then
703: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
704: IGS_GE_MSG_STACK.ADD;
705: App_Exception.Raise_Exception;
706: end if;
707: end if;
708: if upper(column_name) = 'NZ_CITIZEN_LESS2YR_IND' OR
709: column_name is null then
710: if new_references.nz_citizen_less2yr_ind not IN ('Y','N') OR
711: new_references.nz_citizen_less2yr_ind <> upper(new_references.nz_citizen_less2yr_ind) then
712: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
713: IGS_GE_MSG_STACK.ADD;
714: App_Exception.Raise_Exception;
715: end if;
716: end if;
717: if upper(column_name) = 'NZ_CITIZEN_NOT_RES_IND' OR
718: column_name is null then
719: if new_references.nz_citizen_not_res_ind not IN ('Y','N') OR
720: new_references.nz_citizen_not_res_ind <> upper(new_references.nz_citizen_not_res_ind) then
721: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
722: IGS_GE_MSG_STACK.ADD;
723: App_Exception.Raise_Exception;
724: end if;
725: end if;
726: if upper(column_name) = 'SAFETY_NET_IND' OR
727: column_name is null then
728: if new_references.safety_net_ind not IN ('Y','N') OR
729: new_references.safety_net_ind <> upper(new_references.safety_net_ind) then
730: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
731: IGS_GE_MSG_STACK.ADD;
732: App_Exception.Raise_Exception;
733: end if;
734: end if;
735: if upper(column_name) = 'TAX_FILE_CERTIFICATE_NUMBER' OR
736: column_name is null then
737: if new_references.tax_file_certificate_number < 0 OR
738: new_references.tax_file_certificate_number > 9999999999 then
739: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
740: IGS_GE_MSG_STACK.ADD;
741: App_Exception.Raise_Exception;
742: end if;
743: end if;
743: end if;
744: if upper(column_name) = 'COURSE_CD' OR
745: column_name is null then
746: if new_references.course_cd <> upper(new_references.course_cd) then
747: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
748: IGS_GE_MSG_STACK.ADD;
749: App_Exception.Raise_Exception;
750: end if;
751: end if;
752: if upper(column_name) = 'DIFF_HECS_IND_UPDATE_WHO' OR
753: column_name is null then
754: if new_references.diff_hecs_ind_update_who <>
755: upper(new_references.diff_hecs_ind_update_who) then
756: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
757: IGS_GE_MSG_STACK.ADD;
758: App_Exception.Raise_Exception;
759: end if;
760: end if;
760: end if;
761: if upper(column_name) = 'HECS_PAYMENT_OPTION' OR
762: column_name is null then
763: if new_references.hecs_payment_option <>upper(new_references.hecs_payment_option) then
764: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
765: IGS_GE_MSG_STACK.ADD;
766: App_Exception.Raise_Exception;
767: end if;
768: end if;
776: ELSE
777: IF NOT IGS_FI_HECS_PAY_OPTN_PKG.Get_PK_For_Validation (
778: new_references.hecs_payment_option
779: )then
780: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
781: IGS_GE_MSG_STACK.ADD;
782: App_Exception.Raise_Exception;
783: end if;
784: END IF;
792: IF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (
793: new_references.person_id,
794: new_references.course_cd
795: )then
796: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
797: IGS_GE_MSG_STACK.ADD;
798: App_Exception.Raise_Exception;
799: end if;
800: END IF;
847: Open cur_rowid;
848: Fetch cur_rowid INTO lv_rowid;
849: IF (cur_rowid%FOUND) THEN
850: Close cur_rowid;
851: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SCHO_HPO_FK');
852: IGS_GE_MSG_STACK.ADD;
853: App_Exception.Raise_Exception;
854: Return;
855: END IF;
875: Open cur_rowid;
876: Fetch cur_rowid INTO lv_rowid;
877: IF (cur_rowid%FOUND) THEN
878: Close cur_rowid;
879: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SCHO_SCA_FK');
880: IGS_GE_MSG_STACK.ADD;
881: App_Exception.Raise_Exception;
882: Return;
883: END IF;
949: new_references.person_id,
950: new_references.course_cd,
951: new_references.start_dt
952: ) then
953: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
954: IGS_GE_MSG_STACK.ADD;
955: App_Exception.Raise_Exception;
956: end if;
957: Check_constraints;
969: new_references.person_id,
970: new_references.course_cd,
971: new_references.start_dt
972: ) then
973: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
974: IGS_GE_MSG_STACK.ADD;
975: App_Exception.Raise_Exception;
976: end if;
977: Check_constraints;
1071: X_PROGRAM_UPDATE_DATE := SYSDATE;
1072: end if;
1073:
1074: else
1075: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1076: IGS_GE_MSG_STACK.ADD;
1077: app_exception.raise_exception;
1078: end if;
1079:
1224: open c1;
1225: fetch c1 into tlinfo;
1226: if (c1%notfound) then
1227: close c1;
1228: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1229: IGS_GE_MSG_STACK.ADD;
1230: app_exception.raise_exception;
1231: return;
1232: end if;
1265: AND (X_DIFF_HECS_IND_UPDATE_COMMENT is null)))
1266: ) then
1267: null;
1268: else
1269: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1270: IGS_GE_MSG_STACK.ADD;
1271: app_exception.raise_exception;
1272: end if;
1273: return;
1318: if X_LAST_UPDATE_LOGIN is NULL then
1319: X_LAST_UPDATE_LOGIN := -1;
1320: end if;
1321: else
1322: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1323: IGS_GE_MSG_STACK.ADD;
1324: app_exception.raise_exception;
1325: end if;
1326: