[Home] [Help]
39: -- Populate Old Values.
40: Open cur_old_ref_values;
41: Fetch cur_old_ref_values INTO old_references;
42: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
43: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
44: IGS_GE_MSG_STACK.ADD;
45: App_Exception.Raise_Exception;
46: Close cur_old_ref_values;
47: Return;
89: IF IGS_AD_VAL_SAFT.crsp_val_fs_closed(
90: new_references.funding_source,
91: v_message_name) = FALSE THEN
92: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
93: FND_MESSAGE.SET_NAME('IGS',v_message_name);
94: IGS_GE_MSG_STACK.ADD;
95: APP_EXCEPTION.RAISE_EXCEPTION;
96: END IF;
97: END IF;
103: new_references.org_unit_cd,
104: new_references.ou_start_dt,
105: v_message_name) = FALSE THEN
106: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
107: FND_MESSAGE.SET_NAME('IGS',v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: APP_EXCEPTION.RAISE_EXCEPTION;
110: END IF;
111: END IF;
115: IF IGS_AD_VAL_SAFT.crsp_val_ctg_closed(
116: new_references.course_type_group_cd,
117: v_message_name) = FALSE THEN
118: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
119: FND_MESSAGE.SET_NAME('IGS',v_message_name);
120: IGS_GE_MSG_STACK.ADD;
121: APP_EXCEPTION.RAISE_EXCEPTION;
122: END IF;
123: END IF;
127: IF IGS_AD_VAL_SIT.admp_val_itt_closed(
128: new_references.intake_target_type,
129: v_message_name) = FALSE THEN
130: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
131: FND_MESSAGE.SET_NAME('IGS',v_message_name);
132: IGS_GE_MSG_STACK.ADD;
133: APP_EXCEPTION.RAISE_EXCEPTION;
134: END IF;
135: END IF;
143: v_s_amount_type,
144: new_references.override_s_amount_type,
145: v_message_name) = FALSE THEN
146: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
147: FND_MESSAGE.SET_NAME('IGS',v_message_name);
148: IGS_GE_MSG_STACK.ADD;
149: APP_EXCEPTION.RAISE_EXCEPTION;
150: END IF;
151: END IF;
162: new_references.target,
163: new_references.max_target,
164: v_message_name) = FALSE THEN
165: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
166: FND_MESSAGE.SET_NAME('IGS',v_message_name);
167: IGS_GE_MSG_STACK.ADD;
168: APP_EXCEPTION.RAISE_EXCEPTION;
169: END IF;
170: ELSE
173: new_references.target,
174: new_references.max_target,
175: v_message_name) = FALSE THEN
176: --raise_application_error(-20000, IGS_GE_GEN_002.GENP_GET_MESSAGE(v_message_num));
177: FND_MESSAGE.SET_NAME('IGS',v_message_name);
178: IGS_GE_MSG_STACK.ADD;
179: APP_EXCEPTION.RAISE_EXCEPTION;
180: END IF;
181: END IF;
193: ELSE
194: IF NOT IGS_PS_TYPE_GRP_PKG.Get_PK_For_Validation (
195: new_references.course_type_group_cd
196: )THEN
197: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
198: IGS_GE_MSG_STACK.ADD;
199: APP_EXCEPTION.RAISE_EXCEPTION;
200: END IF;
201: END IF;
206: ELSE
207: IF NOT IGS_FI_FUND_SRC_PKG.Get_PK_For_Validation (
208: new_references.funding_source
209: )THEN
210: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
211: IGS_GE_MSG_STACK.ADD;
212: APP_EXCEPTION.RAISE_EXCEPTION;
213: END IF;
214: END IF;
222: IF NOT IGS_ST_GVT_SPSHT_CTL_PKG.Get_PK_For_Validation (
223: new_references.submission_yr,
224: new_references.submission_number
225: )THEN
226: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
227: IGS_GE_MSG_STACK.ADD;
228: APP_EXCEPTION.RAISE_EXCEPTION;
229: END IF;
230: END IF;
236: IF NOT IGS_AD_INTAK_TRG_TYP_PKG.Get_PK_For_Validation (
237: new_references.intake_target_type,
238: 'N'
239: )THEN
240: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
241: IGS_GE_MSG_STACK.ADD;
242: APP_EXCEPTION.RAISE_EXCEPTION;
243: END IF;
244: END IF;
252: IF NOT IGS_OR_UNIT_PKG.Get_PK_For_Validation (
253: new_references.org_unit_cd,
254: new_references.ou_start_dt
255: )THEN
256: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
257: IGS_GE_MSG_STACK.ADD;
258: APP_EXCEPTION.RAISE_EXCEPTION;
259: END IF;
260: END IF;
266: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
267: 'AMOUNT_TYPE',
268: new_references.override_s_amount_type
269: ) THEN
270: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: END IF;
274: END IF;
330: Open cur_rowid;
331: Fetch cur_rowid INTO lv_rowid;
332: IF (cur_rowid%FOUND) THEN
333: Close cur_rowid;
334: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFCT_CTG_FK');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: Return;
338: END IF;
356: Open cur_rowid;
357: Fetch cur_rowid INTO lv_rowid;
358: IF (cur_rowid%FOUND) THEN
359: Close cur_rowid;
360: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFCT_FS_FK');
361: IGS_GE_MSG_STACK.ADD;
362: App_Exception.Raise_Exception;
363: Return;
364: END IF;
384: Open cur_rowid;
385: Fetch cur_rowid INTO lv_rowid;
386: IF (cur_rowid%FOUND) THEN
387: Close cur_rowid;
388: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFCT_GSC_FK');
389: IGS_GE_MSG_STACK.ADD;
390: App_Exception.Raise_Exception;
391: Return;
392: END IF;
410: Open cur_rowid;
411: Fetch cur_rowid INTO lv_rowid;
412: IF (cur_rowid%FOUND) THEN
413: Close cur_rowid;
414: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFCT_ITT_FK');
415: IGS_GE_MSG_STACK.ADD;
416: App_Exception.Raise_Exception;
417: Return;
418: END IF;
438: Open cur_rowid;
439: Fetch cur_rowid INTO lv_rowid;
440: IF (cur_rowid%FOUND) THEN
441: Close cur_rowid;
442: Fnd_Message.Set_Name ('IGS', 'IGS_AD_SAFCT_OU_FK');
443: IGS_GE_MSG_STACK.ADD;
444: App_Exception.Raise_Exception;
445: Return;
446: END IF;
464: Open cur_rowid;
465: Fetch cur_rowid INTO lv_rowid;
466: IF (cur_rowid%FOUND) THEN
467: Close cur_rowid;
468: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OVR_AMT_SLV_FK');
469: IGS_GE_MSG_STACK.ADD;
470: App_Exception.Raise_Exception;
471: Return;
472: END IF;
499: END IF;
500:
501: IF upper(column_name) = 'TARGET' OR column_name IS NULL THEN
502: IF new_references.target < 00000.000 OR new_references.target > 99999.999 THEN
503: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
504: IGS_GE_MSG_STACK.ADD;
505: APP_EXCEPTION.RAISE_EXCEPTION;
506: END IF;
507: END IF;
506: END IF;
507: END IF;
508: IF upper(column_name) = 'MAX_TARGET' OR column_name IS NULL THEN
509: IF new_references.max_target < 00000.000 OR new_references.max_target > 99999.999 THEN
510: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
511: IGS_GE_MSG_STACK.ADD;
512: APP_EXCEPTION.RAISE_EXCEPTION;
513: END IF;
514: END IF;
513: END IF;
514: END IF;
515: IF upper(column_name) = 'ACTUAL_ENROLMENT' OR column_name IS NULL THEN
516: IF new_references.actual_enrolment < 00000.000 OR new_references.actual_enrolment > 99999.999 THEN
517: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
518: IGS_GE_MSG_STACK.ADD;
519: APP_EXCEPTION.RAISE_EXCEPTION;
520: END IF;
521: END IF;
520: END IF;
521: END IF;
522: IF upper(column_name) = 'FUNDING_SOURCE' OR column_name IS NULL THEN
523: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
524: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
525: IGS_GE_MSG_STACK.ADD;
526: APP_EXCEPTION.RAISE_EXCEPTION;
527: END IF;
528: END IF;
527: END IF;
528: END IF;
529: IF upper(column_name) = 'INTAKE_TARGET_TYPE' OR column_name IS NULL THEN
530: IF new_references.intake_target_type <> UPPER(new_references.intake_target_type) THEN
531: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
532: IGS_GE_MSG_STACK.ADD;
533: APP_EXCEPTION.RAISE_EXCEPTION;
534: END IF;
535: END IF;
535: END IF;
536:
537: IF upper(column_name) = 'COURSE_TYPE_GROUP_CD' OR column_name IS NULL THEN
538: IF new_references.course_type_group_cd <> UPPER(new_references.course_type_group_cd) THEN
539: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
540: IGS_GE_MSG_STACK.ADD;
541: APP_EXCEPTION.RAISE_EXCEPTION;
542: END IF;
543: END IF;
600: new_references.funding_source,
601: new_references.course_type_group_cd,
602: new_references.intake_target_type
603: )THEN
604: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
605: IGS_GE_MSG_STACK.ADD;
606: APP_EXCEPTION.RAISE_EXCEPTION;
607: END IF;
608: Check_Constraints;
625: new_references.funding_source,
626: new_references.course_type_group_cd,
627: new_references.intake_target_type
628: )THEN
629: FND_MESSAGE.SET_NAME('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
630: IGS_GE_MSG_STACK.ADD;
631: APP_EXCEPTION.RAISE_EXCEPTION;
632: END IF;
633: Check_Constraints;
692: if X_LAST_UPDATE_LOGIN is NULL then
693: X_LAST_UPDATE_LOGIN := -1;
694: end if;
695: else
696: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
697: IGS_GE_MSG_STACK.ADD;
698: app_exception.raise_exception;
699: end if;
700:
800: begin
801: open c1;
802: fetch c1 into tlinfo;
803: if (c1%notfound) then
804: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
805: IGS_GE_MSG_STACK.ADD;
806: app_exception.raise_exception;
807: close c1;
808: return;
824: AND (X_ACTUAL_ENR_EFFECTIVE_DT is null)))
825: ) then
826: null;
827: else
828: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
829: IGS_GE_MSG_STACK.ADD;
830: app_exception.raise_exception;
831: end if;
832: return;
865: if X_LAST_UPDATE_LOGIN is NULL then
866: X_LAST_UPDATE_LOGIN := -1;
867: end if;
868: else
869: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
870: IGS_GE_MSG_STACK.ADD;
871: app_exception.raise_exception;
872: end if;
873: