[Home] [Help]
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;
50: Close cur_old_ref_values;
51:
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
112: /* Partial rollover is now handled
113: -- Set rollover inclusion indicator to 'N', this functionality is
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
127: IF new_references.course_cd IS NOT NULL THEN
128: IF IGS_AD_VAL_APCOOD.admp_val_apcood_co(
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;
142: -- Validate admission period date course offering option components
143: IF IGS_AD_VAL_APCOOD.admp_val_apcood_opt(
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;
160:
161:
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 (
187: new_references.adm_cal_type,
188: new_references.adm_ci_sequence_number,
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;
206: END AfterRowInsertUpdate2;
207:
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;
254:
255: IF upper(column_name) = 'ADM_CAL_TYPE' OR
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;
264:
265: IF upper(column_name) = 'ADMISSION_CAT' OR
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;
274:
275: IF upper(column_name) = 'S_ADMISSION_PROCESS_TYPE' OR
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;
284:
285: IF upper(column_name) = 'COURSE_CD' OR
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;
294:
295: IF upper(column_name) = 'ACAD_CAL_TYPE' OR
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;
304:
305: IF upper(column_name) = 'LOCATION_CD' OR
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;
314:
315: IF upper(column_name) = 'ATTENDANCE_MODE' OR
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;
324:
325: IF upper(column_name) = 'ATTENDANCE_TYPE' OR
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;
334:
335: IF upper(column_name) = 'ADM_CI_SEQUENCE_NUMBER' OR
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;
344:
345: IF upper(column_name) = 'DAI_SEQUENCE_NUMBER' OR
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;
354:
355: IF upper(column_name) = 'SEQUENCE_NUMBER' OR
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;
364:
365: IF upper(column_name) = 'VERSION_NUMBER' OR
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;
383:
384: END Check_Constraints;
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;
401:
402: IF (((old_references.adm_cal_type = new_references.adm_cal_type) AND
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;
420:
421: IF (((old_references.adm_cal_type = new_references.adm_cal_type) AND
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;
443:
444: IF (((old_references.attendance_type = new_references.attendance_type)) OR
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;
456:
457: IF (((old_references.course_cd = new_references.course_cd) AND
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;
475:
476: IF (((old_references.dt_alias = new_references.dt_alias) AND
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:
497: END IF;
498:
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;
511:
512: IF (((old_references.s_admission_process_type = new_references.s_admission_process_type)) OR
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;
525:
526: END Check_Parent_Existance;
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;
587: Close cur_rowid;
588:
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;
617: Close cur_rowid;
618:
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;
649: Close cur_rowid;
650:
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;
675: Close cur_rowid;
676:
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;
705: Close cur_rowid;
706:
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;
737: Close cur_rowid;
738:
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;
763: Close cur_rowid;
764:
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;
789: Close cur_rowid;
790:
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;
858: Check_Parent_Existance;
859: ELSIF (p_action = 'UPDATE') THEN
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;
881: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
882: Check_Constraints;
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',
950: x_rowid =>X_ROWID,
951: x_adm_cal_type => X_ADM_CAL_TYPE,
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;
1068: close c1;
1069:
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;
1100: end LOCK_ROW;
1101:
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:
1143: Before_DML(p_action =>'UPDATE',
1144: x_rowid =>X_ROWID,