[Home] [Help]
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: Close cur_old_ref_values;
44: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
45: IGS_GE_MSG_STACK.ADD;
46: App_Exception.Raise_Exception;
47: Return;
48: END IF;
86: -- Validate the system enrolment step type
87: IF IGS_EN_VAL_ECPS.enrp_val_ecps_sest(
88: new_references.s_enrolment_step_type,
89: v_message_name) = FALSE THEN
90: fnd_message.set_name('IGS',v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: app_exception.raise_exception;
93: END IF;
94: END IF;
118:
119: IF upper(column_name) = 'ENROLMENT_CAT' OR
120: column_name is null then
121: if new_references.enrolment_cat <> upper(new_references.enrolment_cat) then
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: end if;
126: end if;
126: end if;
127: IF upper(column_name) = 'ENR_METHOD_TYPE' OR
128: column_name is null then
129: if new_references.enr_method_type <>upper(new_references.enr_method_type) then
130: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: end if;
134: end if;
135: IF upper(column_name) = 'MANDATORY_STEP_IND' OR
136: column_name is null then
137: if new_references.mandatory_step_ind <> upper(new_references.mandatory_step_ind) OR
138: new_references.mandatory_step_ind NOT IN ('Y','N') then
139: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: end if;
143: end if;
143: end if;
144: IF upper(column_name) = 'S_ENROLMENT_STEP_TYPE' OR
145: column_name is null then
146: if new_references.s_enrolment_step_type <> upper(new_references.s_enrolment_step_type) then
147: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: end if;
151: end if;
151: end if;
152: IF upper(column_name) = 'S_STUDENT_COMM_TYPE' OR
153: column_name is null then
154: if new_references.s_student_comm_type <> upper(new_references.s_student_comm_type) then
155: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: end if;
159: end if;
174: new_references.enrolment_cat,
175: new_references.s_student_comm_type,
176: new_references.enr_method_type
177: ) then
178: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: end if;
182: END IF;
188: if not IGS_LOOKUPS_VIEW_Pkg.Get_PK_For_Validation (
189: 'ENROLMENT_STEP_TYPE',
190: new_references.s_enrolment_step_type
191: ) then
192: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: end if;
196: END IF;
249: Open cur_rowid;
250: Fetch cur_rowid INTO lv_rowid;
251: IF (cur_rowid%FOUND) THEN
252: Close cur_rowid;
253: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ECPS_ECPD_FK');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: Return;
257: END IF;
275: Open cur_rowid;
276: Fetch cur_rowid INTO lv_rowid;
277: IF (cur_rowid%FOUND) THEN
278: Close cur_rowid;
279: Fnd_Message.Set_Name ('IGS', 'IGS_EN_ECPS_LKUPV_FK');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: Return;
283: END IF;
326: new_references.s_student_comm_type,
327: new_references.enr_method_type,
328: new_references.s_enrolment_step_type
329: ) then
330: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
331: IGS_GE_MSG_STACK.ADD;
332: App_Exception.Raise_Exception;
333: end if;
334: Check_constraints;
347: new_references.s_student_comm_type,
348: new_references.enr_method_type,
349: new_references.s_enrolment_step_type
350: ) then
351: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
352: IGS_GE_MSG_STACK.ADD;
353: App_Exception.Raise_Exception;
354: end if;
355: Check_constraints;
413: if X_LAST_UPDATE_LOGIN is NULL then
414: X_LAST_UPDATE_LOGIN := -1;
415: end if;
416: else
417: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
418: IGS_GE_MSG_STACK.ADD;
419: app_exception.raise_exception;
420: end if;
421: Before_DML (
493: open c1;
494: fetch c1 into tlinfo;
495: if (c1%notfound) then
496: close c1;
497: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
498: IGS_GE_MSG_STACK.ADD;
499: app_exception.raise_exception;
500: return;
501: end if;
506: AND (X_STEP_ORDER_NUM is null)))
507: ) then
508: null;
509: else
510: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
511: IGS_GE_MSG_STACK.ADD;
512: app_exception.raise_exception;
513: end if;
514: return;
540: if X_LAST_UPDATE_LOGIN is NULL then
541: X_LAST_UPDATE_LOGIN := -1;
542: end if;
543: else
544: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
545: IGS_GE_MSG_STACK.ADD;
546: app_exception.raise_exception;
547: end if;
548: Before_DML (