[Home] [Help]
36: -- Populate Old Values.
37: Open cur_old_ref_values;
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: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
41: IGS_GE_MSG_STACK.ADD;
42: App_Exception.Raise_Exception;
43: Close cur_old_ref_values;
44: Return;
81: new_references.result_obtained_yr,
82: new_references.score,
83: new_references.aus_scndry_edu_ass_type,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88:
89:
103: IF IGS_AD_VAL_ASE.admp_val_ase_atstate(
104: new_references.state_cd,
105: new_references.aus_scndry_edu_ass_type,
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: END IF;
119: IF IGS_AD_VAL_ASE.admp_val_ase_scstate(
120: new_references.state_cd,
121: new_references.secondary_school_cd,
122: v_message_name) = FALSE THEN
123: Fnd_Message.Set_Name('IGS',v_message_name);
124: IGS_GE_MSG_STACK.ADD;
125:
126:
127:
143: new_references.aus_scndry_edu_ass_type IS NOT NULL) THEN
144: IF IGS_AD_VAL_ASE.admp_val_aseatclosed(
145: new_references.aus_scndry_edu_ass_type,
146: v_message_name) = FALSE THEN
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;
174: new_references.candidate_number := igs_ge_number.to_num(column_value);
175: END IF;
176: IF ((UPPER (column_name) = 'SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
177: IF ((new_references.sequence_number < 1) OR (new_references.sequence_number > 9999999999)) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: END IF;
181: END IF;
182: END IF;
183: IF ((UPPER (column_name) = 'RESULT_OBTAINED_YR ') OR (column_name IS NULL)) THEN
184: IF ((new_references.result_obtained_yr < 1900) OR (new_references.result_obtained_yr > 2050)) THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: END IF;
188: END IF;
189: END IF;
190: IF ((UPPER (column_name) = 'AUS_SCNDRY_EDU_ASS_TYPE') OR (column_name IS NULL)) THEN
191: IF (new_references.aus_scndry_edu_ass_type <> UPPER (new_references.aus_scndry_edu_ass_type)) THEN
192: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
193: IGS_GE_MSG_STACK.ADD;
194: App_Exception.Raise_Exception;
195: END IF;
196: END IF;
195: END IF;
196: END IF;
197: IF ((UPPER (column_name) = 'SECONDARY_SCHOOL_CD') OR (column_name IS NULL)) THEN
198: IF (new_references.secondary_school_cd <> UPPER (new_references.secondary_school_cd)) THEN
199: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
202: END IF;
203: END IF;
204: IF ((UPPER (column_name) = 'STATE_CD') OR (column_name IS NULL)) THEN
205: IF (new_references.state_cd <> UPPER (new_references.state_cd)) THEN
206: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210: END IF;
209: END IF;
210: END IF;
211: IF ((UPPER (column_name) = 'SCORE') OR (column_name IS NULL)) THEN
212: IF ((new_references.score < 0) OR (new_references.score > 999.999)) THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: END IF;
217: END IF;
216: END IF;
217: END IF;
218: IF ((UPPER (column_name) = 'CANDIDATE_NUMBER') OR (column_name IS NULL)) THEN
219: IF ((new_references.candidate_number < 1) OR (new_references.candidate_number > 999999999999)) THEN
220: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: END IF;
235: IF NOT IGS_AD_AUSE_ED_AS_TY_PKG.Get_PK_For_Validation (
236: new_references.aus_scndry_edu_ass_type,
237: 'N'
238: ) THEN
239: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
240: IGS_GE_MSG_STACK.ADD;
241: App_Exception.Raise_Exception;
242: END IF;
243: END IF;
248: IF NOT IGS_AD_AUS_SEC_ED_SC_PKG.Get_PK_For_Validation (
249: new_references.secondary_school_cd,
250: 'N'
251: ) THEN
252: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: END IF;
260: ELSE
261: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
262: new_references.person_id
263: ) THEN
264: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
265: IGS_GE_MSG_STACK.ADD;
266: App_Exception.Raise_Exception;
267: END IF;
268: END IF;
492: Open cur_rowid;
493: Fetch cur_rowid INTO lv_rowid;
494: IF (cur_rowid%FOUND) THEN
495: Close cur_rowid;
496: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASE_ASEAT_FK');
497: IGS_GE_MSG_STACK.ADD;
498: App_Exception.Raise_Exception;
499: Return;
500: END IF;
518: Open cur_rowid;
519: Fetch cur_rowid INTO lv_rowid;
520: IF (cur_rowid%FOUND) THEN
521: Close cur_rowid;
522: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASE_ASES_FK');
523: IGS_GE_MSG_STACK.ADD;
524: App_Exception.Raise_Exception;
525: Return;
526: END IF;
544: Open cur_rowid;
545: Fetch cur_rowid INTO lv_rowid;
546: IF (cur_rowid%FOUND) THEN
547: Close cur_rowid;
548: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ASE_PE_FK');
549: IGS_GE_MSG_STACK.ADD;
550: App_Exception.Raise_Exception;
551: Return;
552: END IF;
596: IF Get_PK_For_Validation (
597: new_references.person_id,
598: new_references.sequence_number
599: ) THEN
600: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
601: IGS_GE_MSG_STACK.ADD;
602: App_Exception.Raise_Exception;
603: END IF;
604: Check_Constraints;
615: IF Get_PK_For_Validation (
616: new_references.person_id,
617: new_references.sequence_number
618: ) THEN
619: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
620: IGS_GE_MSG_STACK.ADD;
621: App_Exception.Raise_Exception;
622: END IF;
623: Check_Constraints;
685: else
686: X_PROGRAM_UPDATE_DATE := SYSDATE;
687: end if;
688: else
689: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
690: IGS_GE_MSG_STACK.ADD;
691: app_exception.raise_exception;
692: end if;
693:
787: begin
788: open c1;
789: fetch c1 into tlinfo;
790: if (c1%notfound) then
791: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
792: IGS_GE_MSG_STACK.ADD;
793: app_exception.raise_exception;
794: close c1;
795: return;
814: AND (X_SECONDARY_SCHOOL_CD is null)))
815: ) then
816: null;
817: else
818: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
819: IGS_GE_MSG_STACK.ADD;
820: app_exception.raise_exception;
821: end if;
822: return;
855: if X_LAST_UPDATE_LOGIN is NULL then
856: X_LAST_UPDATE_LOGIN := -1;
857: end if;
858: else
859: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
860: IGS_GE_MSG_STACK.ADD;
861: app_exception.raise_exception;
862: end if;
863: if (X_MODE = 'R') then