[Home] [Help]
38: Fetch cur_old_ref_values INTO old_references;
39: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
40: Close cur_old_ref_values;
41: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
42: IGS_GE_MSG_STACK.ADD;
43: App_Exception.Raise_Exception;
44: Return;
45: END IF;
46: Close cur_old_ref_values;
83: IF IGS_AD_VAL_OSE.admp_val_oseq_closed(
84: new_references.os_scndry_edu_qualification,
85: v_message_name) = FALSE THEN
86: Fnd_Message.Set_Name('IGS',v_message_name);
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
91: -- Validate Overseas Secondary Education Qualification IGS_PE_COUNTRY_CD.
98: new_references.os_scndry_edu_qualification,
99: new_references.country_cd,
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name('IGS',v_message_name);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106:
131:
132: IF upper(Column_Name) = 'OS_SCNDRY_EDU_QUALIFICATION' OR Column_Name IS NULL THEN
133: IF new_references.os_scndry_edu_qualification <> UPPER(new_references.os_scndry_edu_qualification) THEN
134: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: END IF;
139: IF upper(Column_Name) = 'RESULT' OR Column_Name IS NULL THEN
138: END IF;
139: IF upper(Column_Name) = 'RESULT' OR Column_Name IS NULL THEN
140: IF new_references.result <> UPPER(new_references.result) THEN
141: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146: IF upper(Column_Name) = 'SCHOOL_NAME' OR Column_Name IS NULL THEN
145: END IF;
146: IF upper(Column_Name) = 'SCHOOL_NAME' OR Column_Name IS NULL THEN
147: IF new_references.school_name <> UPPER(new_references.school_name) THEN
148: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152: END IF;
153: IF upper(Column_Name) = 'COUNTRY_CD' OR Column_Name IS NULL THEN
152: END IF;
153: IF upper(Column_Name) = 'COUNTRY_CD' OR Column_Name IS NULL THEN
154: IF new_references.country_cd <> UPPER(new_references.country_cd) 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;
160: IF upper(Column_Name) = 'SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
159: END IF;
160: IF upper(Column_Name) = 'SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
161: IF new_references.sequence_number < 1 OR new_references.sequence_number > 999999 THEN
162: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166: END IF;
167: IF upper(Column_Name) = 'RESULT_OBTAINED_YR' OR Column_Name IS NULL THEN
166: END IF;
167: IF upper(Column_Name) = 'RESULT_OBTAINED_YR' OR Column_Name IS NULL THEN
168: IF new_references.result_obtained_yr < 1900 OR new_references.result_obtained_yr > 2050 THEN
169: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:
184: IF NOT IGS_PE_COUNTRY_CD_PKG.Get_PK_For_Validation (
185: new_references.country_cd
186: ) THEN
187: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;
192:
198: new_references.os_scndry_edu_qualification,
199: 'N'
200: ) THEN
201: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: END IF;
205: END IF;
206:
211: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
212: new_references.person_id
213: ) THEN
214: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
215: IGS_GE_MSG_STACK.ADD;
216: App_Exception.Raise_Exception;
217: END IF;
218: END IF;
219:
274: Fetch cur_rowid INTO lv_rowid;
275: IF (cur_rowid%FOUND) THEN
276: Close cur_rowid;
277: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OSE_CNC_FK');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: Return;
281: END IF;
282: Close cur_rowid;
300: Fetch cur_rowid INTO lv_rowid;
301: IF (cur_rowid%FOUND) THEN
302: Close cur_rowid;
303: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OSE_OSEQ_FK');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: Return;
307: END IF;
308: Close cur_rowid;
326: Fetch cur_rowid INTO lv_rowid;
327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_AD_OSE_PE_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;
334: Close cur_rowid;
380: new_references.person_id,
381: new_references.sequence_number
382: ) THEN
383: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: END IF;
387: Check_Constraints;
388: Check_Parent_Existance;
396: new_references.person_id,
397: new_references.sequence_number
398: ) THEN
399: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
400: IGS_GE_MSG_STACK.ADD;
401: App_Exception.Raise_Exception;
402: END IF;
403: Check_Constraints;
404: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
454: X_LAST_UPDATE_LOGIN := -1;
455: end if;
456: else
457: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
458: IGS_GE_MSG_STACK.ADD;
459: app_exception.raise_exception;
460: end if;
461:
462:
555: fetch c1 into tlinfo;
556: if (c1%notfound) then
557: close c1;
558: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
559: IGS_GE_MSG_STACK.ADD;
560: app_exception.raise_exception;
561: return;
562: end if;
563: close c1;
584: ) then
585: null;
586: else
587: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
588: IGS_GE_MSG_STACK.ADD;
589: app_exception.raise_exception;
590: end if;
591: return;
592: end LOCK_ROW;
622: X_LAST_UPDATE_LOGIN := -1;
623: end if;
624: else
625: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
626: IGS_GE_MSG_STACK.ADD;
627: app_exception.raise_exception;
628: end if;
629:
630: Before_DML(