[Home] [Help]
41: Open cur_old_ref_values;
42: Fetch cur_old_ref_values INTO old_references;
43: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
44: Close cur_old_ref_values;
45: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
46: IGS_GE_MSG_STACK.ADD;
47: App_Exception.Raise_Exception;
48: Return;
49: END IF;
103: v_start_dt,
104: v_end_dt,
105: v_alternate_code,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name('IGS',v_message_name);
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: IF p_inserting OR p_updating THEN
118: -- Validate admission period date alias
119: IF IGS_AD_VAL_APCOOD.admp_val_apcood_da(
120: new_references.dt_alias,
121: v_message_name) = FALSE THEN
122: Fnd_Message.Set_Name('IGS',v_message_name);
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: -- Validate admission period date course offering
133: new_references.s_admission_process_type,
134: new_references.adm_cal_type,
135: new_references.adm_ci_sequence_number,
136: v_message_name) = FALSE THEN
137: Fnd_Message.Set_Name('IGS',v_message_name);
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF;
151: new_references.adm_ci_sequence_number,
152: new_references.admission_cat,
153: new_references.s_admission_process_type,
154: v_message_name) = FALSE THEN
155: Fnd_Message.Set_Name('IGS',v_message_name);
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
178: new_references.dt_alias,
179: new_references.dai_sequence_number,
180: new_references.sequence_number,
181: v_message_name) = FALSE THEN
182: Fnd_Message.Set_Name('IGS',v_message_name);
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END IF;
186: IF IGS_AD_VAL_APCOOD.admp_val_apcood_link (
197: new_references.location_cd,
198: new_references.attendance_mode,
199: new_references.attendance_type,
200: v_message_name) = FALSE THEN
201: Fnd_Message.Set_Name('IGS',v_message_name);
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: END IF;
205: END IF;
245:
246: IF upper(column_name) = 'DT_ALIAS' OR
247: column_name is null Then
248: IF new_references.dt_alias <> UPPER(new_references.dt_alias) Then
249: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
255: IF upper(column_name) = 'ADM_CAL_TYPE' OR
256: column_name is null Then
257: IF new_references.adm_cal_type <>
258: UPPER(new_references.adm_cal_type) Then
259: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: END IF;
265: IF upper(column_name) = 'ADMISSION_CAT' OR
266: column_name is null Then
267: IF new_references.admission_cat <>
268: UPPER(new_references.admission_cat) Then
269: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: END IF;
275: IF upper(column_name) = 'S_ADMISSION_PROCESS_TYPE' OR
276: column_name is null Then
277: IF new_references.s_admission_process_type <>
278: UPPER(new_references.s_admission_process_type) Then
279: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: END IF;
283: END IF;
285: IF upper(column_name) = 'COURSE_CD' OR
286: column_name is null Then
287: IF new_references.course_cd <>
288: UPPER(new_references.course_cd) Then
289: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
290: IGS_GE_MSG_STACK.ADD;
291: App_Exception.Raise_Exception;
292: END IF;
293: END IF;
295: IF upper(column_name) = 'ACAD_CAL_TYPE' OR
296: column_name is null Then
297: IF new_references.acad_cal_type <>
298: UPPER(new_references.acad_cal_type) Then
299: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: END IF;
303: END IF;
305: IF upper(column_name) = 'LOCATION_CD' OR
306: column_name is null Then
307: IF new_references.location_cd <>
308: UPPER(new_references.location_cd) Then
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: END IF;
315: IF upper(column_name) = 'ATTENDANCE_MODE' OR
316: column_name is null Then
317: IF new_references.attendance_mode <>
318: UPPER(new_references.attendance_mode) Then
319: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
320: IGS_GE_MSG_STACK.ADD;
321: App_Exception.Raise_Exception;
322: END IF;
323: END IF;
325: IF upper(column_name) = 'ATTENDANCE_TYPE' OR
326: column_name is null Then
327: IF new_references.attendance_type <>
328: UPPER(new_references.attendance_type) Then
329: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: END IF;
333: END IF;
335: IF upper(column_name) = 'ADM_CI_SEQUENCE_NUMBER' OR
336: column_name is null Then
337: IF new_references.adm_ci_sequence_number < 1 OR
338: new_references.adm_ci_sequence_number > 999999 Then
339: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
340: IGS_GE_MSG_STACK.ADD;
341: App_Exception.Raise_Exception;
342: END IF;
343: END IF;
345: IF upper(column_name) = 'DAI_SEQUENCE_NUMBER' OR
346: column_name is null Then
347: IF new_references.dai_sequence_number < 1 OR
348: new_references.dai_sequence_number > 999999 Then
349: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
350: IGS_GE_MSG_STACK.ADD;
351: App_Exception.Raise_Exception;
352: END IF;
353: END IF;
355: IF upper(column_name) = 'SEQUENCE_NUMBER' OR
356: column_name is null Then
357: IF new_references.sequence_number < 1 OR
358: new_references.sequence_number > 999999 Then
359: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
360: IGS_GE_MSG_STACK.ADD;
361: App_Exception.Raise_Exception;
362: END IF;
363: END IF;
365: IF upper(column_name) = 'VERSION_NUMBER' OR
366: column_name is null Then
367: IF new_references.version_number < 1 OR
368: new_references.version_number > 999 Then
369: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
370: IGS_GE_MSG_STACK.ADD;
371: App_Exception.Raise_Exception;
372: END IF;
373: END IF;
374:
375: IF upper(column_name) = 'ROLLOVER_INCLUSION_IND' OR
376: column_name is null Then
377: IF new_references.rollover_inclusion_ind NOT IN ('Y','N') Then
378: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
379: IGS_GE_MSG_STACK.ADD;
380: App_Exception.Raise_Exception;
381: END IF;
382: END IF;
392: ELSE
393: IF NOT IGS_EN_ATD_MODE_PKG.Get_PK_For_Validation (
394: new_references.attendance_mode
395: ) THEN
396: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
397: IGS_GE_MSG_STACK.ADD;
398: App_Exception.Raise_Exception;
399: END IF;
400: END IF;
411: new_references.adm_cal_type,
412: new_references.adm_ci_sequence_number,
413: new_references.admission_cat
414: ) THEN
415: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
416: IGS_GE_MSG_STACK.ADD;
417: App_Exception.Raise_Exception;
418: END IF;
419: END IF;
434: new_references.admission_cat,
435: new_references.s_admission_process_type ,
436: 'N'
437: ) THEN
438: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
439: IGS_GE_MSG_STACK.ADD;
440: App_Exception.Raise_Exception;
441: END IF;
442: END IF;
447: ELSE
448: IF NOT IGS_EN_ATD_TYPE_PKG.Get_PK_For_Validation (
449: new_references.attendance_type
450: ) THEN
451: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
452: IGS_GE_MSG_STACK.ADD;
453: App_Exception.Raise_Exception;
454: END IF;
455: END IF;
466: new_references.course_cd,
467: new_references.version_number,
468: new_references.acad_cal_type
469: ) THEN
470: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
471: IGS_GE_MSG_STACK.ADD;
472: App_Exception.Raise_Exception;
473: END IF;
474: END IF;
488: new_references.dai_sequence_number,
489: new_references.adm_cal_type,
490: new_references.adm_ci_sequence_number
491: )THEN
492: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
493: IGS_GE_MSG_STACK.ADD;
494: App_Exception.Raise_Exception;
495: END IF;
496:
502: ELSE
503: IF NOT IGS_AD_LOCATION_PKG.Get_PK_For_Validation (
504: new_references.location_cd , 'N'
505: )THEN
506: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
507: IGS_GE_MSG_STACK.ADD;
508: App_Exception.Raise_Exception;
509: END IF;
510: END IF;
516: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
517: 'ADMISSION_PROCESS_TYPE',
518: new_references.s_admission_process_type
519: )THEN
520: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
521: IGS_GE_MSG_STACK.ADD;
522: App_Exception.Raise_Exception;
523: END IF;
524: END IF;
578: Open cur_rowid;
579: Fetch cur_rowid INTO lv_rowid;
580: IF (cur_rowid%FOUND) THEN
581: Close cur_rowid;
582: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCOOD_AM_FK');
583: IGS_GE_MSG_STACK.ADD;
584: App_Exception.Raise_Exception;
585: Return;
586: END IF;
608: Open cur_rowid;
609: Fetch cur_rowid INTO lv_rowid;
610: IF (cur_rowid%FOUND) THEN
611: Close cur_rowid;
612: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCOOD_APAC_FK');
613: IGS_GE_MSG_STACK.ADD;
614: App_Exception.Raise_Exception;
615: Return;
616: END IF;
640: Open cur_rowid;
641: Fetch cur_rowid INTO lv_rowid;
642: IF (cur_rowid%FOUND) THEN
643: Close cur_rowid;
644: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCOOD_APAPC_FK');
645: IGS_GE_MSG_STACK.ADD;
646: App_Exception.Raise_Exception;
647: Return;
648: END IF;
666: Open cur_rowid;
667: Fetch cur_rowid INTO lv_rowid;
668: IF (cur_rowid%FOUND) THEN
669: Close cur_rowid;
670: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCOOD_ATT_FK');
671: IGS_GE_MSG_STACK.ADD;
672: App_Exception.Raise_Exception;
673: Return;
674: END IF;
696: Open cur_rowid;
697: Fetch cur_rowid INTO lv_rowid;
698: IF (cur_rowid%FOUND) THEN
699: Close cur_rowid;
700: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCOOD_CO_FK');
701: IGS_GE_MSG_STACK.ADD;
702: App_Exception.Raise_Exception;
703: Return;
704: END IF;
728: Open cur_rowid;
729: Fetch cur_rowid INTO lv_rowid;
730: IF (cur_rowid%FOUND) THEN
731: Close cur_rowid;
732: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCOOD_DAI_FK');
733: IGS_GE_MSG_STACK.ADD;
734: App_Exception.Raise_Exception;
735: Return;
736: END IF;
754: Open cur_rowid;
755: Fetch cur_rowid INTO lv_rowid;
756: IF (cur_rowid%FOUND) THEN
757: Close cur_rowid;
758: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCOOD_LOC_FK');
759: IGS_GE_MSG_STACK.ADD;
760: App_Exception.Raise_Exception;
761: Return;
762: END IF;
780: Open cur_rowid;
781: Fetch cur_rowid INTO lv_rowid;
782: IF (cur_rowid%FOUND) THEN
783: Close cur_rowid;
784: Fnd_Message.Set_Name ('IGS', 'IGS_AD_APCOOD_SLV_FK');
785: IGS_GE_MSG_STACK.ADD;
786: App_Exception.Raise_Exception;
787: Return;
788: END IF;
849: new_references.dt_alias,
850: new_references.dai_sequence_number,
851: new_references.sequence_number
852: ) THEN
853: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
854: IGS_GE_MSG_STACK.ADD;
855: App_Exception.Raise_Exception;
856: END IF;
857: Check_Constraints;
872: new_references.dt_alias,
873: new_references.dai_sequence_number,
874: new_references.sequence_number
875: ) THEN
876: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
877: IGS_GE_MSG_STACK.ADD;
878: App_Exception.Raise_Exception;
879: END IF;
880: Check_Constraints;
941: if X_LAST_UPDATE_LOGIN is NULL then
942: X_LAST_UPDATE_LOGIN := -1;
943: end if;
944: else
945: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
946: IGS_GE_MSG_STACK.ADD;
947: app_exception.raise_exception;
948: end if;
949: Before_DML(p_action =>'INSERT',
1059: open c1;
1060: fetch c1 into tlinfo;
1061: if (c1%notfound) then
1062: close c1;
1063: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1064: IGS_GE_MSG_STACK.ADD;
1065: app_exception.raise_exception;
1066: return;
1067: end if;
1091: AND (tlinfo.ROLLOVER_INCLUSION_IND = X_ROLLOVER_INCLUSION_IND)
1092: ) then
1093: null;
1094: else
1095: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1096: IGS_GE_MSG_STACK.ADD;
1097: app_exception.raise_exception;
1098: end if;
1099: return;
1134: if X_LAST_UPDATE_LOGIN is NULL then
1135: X_LAST_UPDATE_LOGIN := -1;
1136: end if;
1137: else
1138: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1139: IGS_GE_MSG_STACK.ADD;
1140: app_exception.raise_exception;
1141: end if;
1142: