[Home] [Help]
84: l_db_val_failed := TRUE;
85: END IF;
86: -- Check whether the Domicile code exists
87: IF p_hesa_spa_stats_rec.domicile_cd IS NOT NULL THEN
88: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_DOM',
89: x_value => p_hesa_spa_stats_rec.domicile_cd) THEN
90: FND_MESSAGE.SET_NAME('IGS','IGS_HE_DOM_CD_NOT_EXIST');
91: FND_MSG_PUB.ADD;
92: l_db_val_failed := TRUE;
94: END IF;
95:
96: -- Check whether the Occupation Code exists
97: IF p_hesa_spa_stats_rec.occupation_code IS NOT NULL THEN
98: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_OCC',
99: x_value => p_hesa_spa_stats_rec.occupation_code) THEN
100: FND_MESSAGE.SET_NAME('IGS','IGS_HE_OCCUP_CD_NOT_EXIST');
101: FND_MSG_PUB.ADD;
102: l_db_val_failed := TRUE;
103: END IF;
104: END IF;
105: -- Check whether the Teaching training program ID exists
106: IF p_hesa_spa_stats_rec.teacher_train_prog_id IS NOT NULL THEN
107: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_TTCID',
108: x_value => p_hesa_spa_stats_rec.teacher_train_prog_id) THEN
109: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TEACH_TRNPRG_NEX');
110: FND_MSG_PUB.ADD;
111: l_db_val_failed := TRUE;
112: END IF;
113: END IF;
114: -- Check whether the ITT Phase exists
115: IF p_hesa_spa_stats_rec.itt_phase IS NOT NULL THEN
116: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_ITTPHSC',
117: x_value => p_hesa_spa_stats_rec.itt_phase) THEN
118: FND_MESSAGE.SET_NAME('IGS','IGS_HE_ITT_PHASE_NEX');
119: FND_MSG_PUB.ADD;
120: l_db_val_failed := TRUE;
121: END IF;
122: END IF;
123: -- Check whether the Bilingual ITT marker exists
124: IF p_hesa_spa_stats_rec.bilingual_itt_marker IS NOT NULL THEN
125: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_BITTM',
126: x_value => p_hesa_spa_stats_rec.bilingual_itt_marker) THEN
127: FND_MESSAGE.SET_NAME('IGS','IGS_HE_BILINGUAL_ITT_NEX');
128: FND_MSG_PUB.ADD;
129: l_db_val_failed := TRUE;
130: END IF;
131: END IF;
132: -- Check whether the Teaching Qualification Gain Sector exists
133: IF p_hesa_spa_stats_rec.teaching_qual_gain_sector IS NOT NULL THEN
134: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_TQSEC',
135: x_value => p_hesa_spa_stats_rec.teaching_qual_gain_sector) THEN
136: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TCH_QUAL_GSEC_NEX');
137: FND_MSG_PUB.ADD;
138: l_db_val_failed := TRUE;
139: END IF;
140: END IF;
141: -- Check whether the Teaching Qualification Gain subject 1 exists
142: IF p_hesa_spa_stats_rec.teaching_qual_gain_subj1 IS NOT NULL THEN
143: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_TQSUB123',
144: x_value => p_hesa_spa_stats_rec.teaching_qual_gain_subj1) THEN
145: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TCH_QUAL_SUB1_NEX');
146: FND_MSG_PUB.ADD;
147: l_db_val_failed := TRUE;
148: END IF;
149: END IF;
150: -- Check whether the Teaching Qualification Gain subject 2 exists
151: IF p_hesa_spa_stats_rec.teaching_qual_gain_subj2 IS NOT NULL THEN
152: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_TQSUB123',
153: x_value => p_hesa_spa_stats_rec.teaching_qual_gain_subj2) THEN
154: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TCH_QUAL_SUB2_NEX');
155: FND_MSG_PUB.ADD;
156: l_db_val_failed := TRUE;
157: END IF;
158: END IF;
159: -- Check whether the Teaching Qualification Gain subject 3 exists
160: IF p_hesa_spa_stats_rec.teaching_qual_gain_subj3 IS NOT NULL THEN
161: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_TQSUB123',
162: x_value => p_hesa_spa_stats_rec.teaching_qual_gain_subj3) THEN
163: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TCH_QUAL_SUB3_NEX');
164: FND_MSG_PUB.ADD;
165: l_db_val_failed := TRUE;
166: END IF;
167: END IF;
168: -- Check whether the Destination exists
169: IF p_hesa_spa_stats_rec.destination IS NOT NULL THEN
170: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_DEST',
171: x_value => p_hesa_spa_stats_rec.destination) THEN
172: FND_MESSAGE.SET_NAME('IGS','IGS_HE_DESTINATION_NEX');
173: FND_MSG_PUB.ADD;
174: l_db_val_failed := TRUE;
175: END IF;
176: END IF;
177: -- Check whether the ITT Program Outcome exists
178: IF p_hesa_spa_stats_rec.itt_prog_outcome IS NOT NULL THEN
179: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_OUTCOME',
180: x_value => p_hesa_spa_stats_rec.itt_prog_outcome) THEN
181: FND_MESSAGE.SET_NAME('IGS','IGS_HE_ITT_PRG_OC_NEX');
182: FND_MSG_PUB.ADD;
183: l_db_val_failed := TRUE;
184: END IF;
185: END IF;
186: -- Check whether the NHS Funding Source exists
187: IF p_hesa_spa_stats_rec.nhs_funding_source IS NOT NULL THEN
188: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_NHS_FUSRC',
189: x_value => p_hesa_spa_stats_rec.nhs_funding_source) THEN
190: FND_MESSAGE.SET_NAME('IGS','IGS_HE_NHS_FUND_SRC_NEX');
191: FND_MSG_PUB.ADD;
192: l_db_val_failed := TRUE;
193: END IF;
194: END IF;
195: -- Check whether the UFI Place exists
196: IF p_hesa_spa_stats_rec.ufi_place IS NOT NULL THEN
197: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_UFI_PLACE',
198: x_value => p_hesa_spa_stats_rec.ufi_place) THEN
199: FND_MESSAGE.SET_NAME('IGS','IGS_HE_UFI_PLACE_NEX');
200: FND_MSG_PUB.ADD;
201: l_db_val_failed := TRUE;
202: END IF;
203: END IF;
204: -- Check whether the Social Class Indicator exists
205: IF p_hesa_spa_stats_rec.social_class_ind IS NOT NULL THEN
206: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_SOC',
207: x_value => p_hesa_spa_stats_rec.social_class_ind) THEN
208: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SOCIAL_CLS_IND_NEX');
209: FND_MSG_PUB.ADD;
210: l_db_val_failed := TRUE;
211: END IF;
212: END IF;
213: -- Check whether the NHS Employer exists
214: IF p_hesa_spa_stats_rec.nhs_employer IS NOT NULL THEN
215: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_NHS_EMPLOYER',
216: x_value => p_hesa_spa_stats_rec.nhs_employer) THEN
217: FND_MESSAGE.SET_NAME('IGS','IGS_HE_NHS_EMP_NEX');
218: FND_MSG_PUB.ADD;
219: l_db_val_failed := TRUE;
271: END IF;
272:
273: -- Check whether the Qualification Aim Proportion exists
274: IF p_hesa_spa_stats_rec.qualaim_proportion IS NOT NULL THEN
275: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_PROPORTION',
276: x_value => p_hesa_spa_stats_rec.qualaim_proportion) THEN
277: FND_MESSAGE.SET_NAME('IGS','IGS_HE_QUAL_PROP_NEX');
278: FND_MSG_PUB.ADD;
279: l_db_val_failed := TRUE;
280: END IF;
281: END IF;
282: -- Check whether the Special Student exists
283: IF p_hesa_spa_stats_rec.special_student IS NOT NULL THEN
284: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_SPEC_STUD',
285: x_value => p_hesa_spa_stats_rec.special_student) THEN
286: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SPEC_STUD_NEX');
287: FND_MSG_PUB.ADD;
288: l_db_val_failed := TRUE;
289: END IF;
290: END IF;
291: -- Check whether the FE Student Marker exists
292: IF p_hesa_spa_stats_rec.fe_student_marker IS NOT NULL THEN
293: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FESTUMK',
294: x_value => p_hesa_spa_stats_rec.fe_student_marker) THEN
295: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FE_STUD_MARKER_NEX');
296: FND_MSG_PUB.ADD;
297: l_db_val_failed := TRUE;
299: END IF;
300:
301: -- Check whether the Dependants Code exists
302: IF p_hesa_spa_stats_rec.dependants_cd IS NOT NULL THEN
303: IF NOT igs_he_code_values_pkg.get_pk_for_validation(x_code_type => 'OSS_DEPEND',
304: x_value => p_hesa_spa_stats_rec.dependants_cd) THEN
305: FND_MESSAGE.SET_NAME('IGS','IGS_HE_DEP_CD_NEX');
306: FND_MSG_PUB.ADD;
307: l_db_val_failed := TRUE;
309: END IF;
310:
311: -- Check whether the Government Initiatives Code exists
312: IF p_hesa_spa_stats_rec.gov_initiatives_cd IS NOT NULL THEN
313: IF NOT igs_he_code_values_pkg.get_pk_for_validation(x_code_type => 'OSS_GOVINIT',
314: x_value => p_hesa_spa_stats_rec.gov_initiatives_cd) THEN
315: FND_MESSAGE.SET_NAME('IGS','IGS_HE_GOV_INIT_NEX');
316: FND_MSG_PUB.ADD;
317: l_db_val_failed := TRUE;
319: END IF;
320:
321: -- Check whether Eligibility for Disadvantage Uplift Indicator exists
322: IF p_hesa_spa_stats_rec.disadv_uplift_elig_cd IS NOT NULL THEN
323: IF NOT igs_he_code_values_pkg.get_pk_for_validation(x_code_type => 'OSS_ELIDISUP',
324: x_value => p_hesa_spa_stats_rec.disadv_uplift_elig_cd) THEN
325: FND_MESSAGE.SET_NAME('IGS','IGS_HE_ELIG_DIS_NEX');
326: FND_MSG_PUB.ADD;
327: l_db_val_failed := TRUE;
329: END IF;
330:
331: -- Check whether Franchise Partner Indicator exists
332: IF p_hesa_spa_stats_rec.franch_partner_cd IS NOT NULL THEN
333: IF NOT igs_he_code_values_pkg.get_pk_for_validation(x_code_type => 'OSS_FRANPART',
334: x_value => p_hesa_spa_stats_rec.franch_partner_cd) THEN
335: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FRAN_PART_NEX');
336: FND_MSG_PUB.ADD;
337: l_db_val_failed := TRUE;
339: END IF;
340:
341: -- Check whether Franchised Out Arrangement Indicator exists
342: IF p_hesa_spa_stats_rec.franch_out_arr_cd IS NOT NULL THEN
343: IF NOT igs_he_code_values_pkg.get_pk_for_validation(x_code_type => 'OSS_FROUTARR',
344: x_value => p_hesa_spa_stats_rec.franch_out_arr_cd) THEN
345: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FRAN_OUT_ARR_NEX');
346: FND_MSG_PUB.ADD;
347: l_db_val_failed := TRUE;
349: END IF;
350:
351: -- Check whether Employer Role Code exists
352: IF p_hesa_spa_stats_rec.employer_role_cd IS NOT NULL THEN
353: IF NOT igs_he_code_values_pkg.get_pk_for_validation(x_code_type => 'OSS_EMPROLE',
354: x_value => p_hesa_spa_stats_rec.employer_role_cd) THEN
355: FND_MESSAGE.SET_NAME('IGS','IGS_HE_EMP_ROLE_CD_NEX');
356: FND_MSG_PUB.ADD;
357: l_db_val_failed := TRUE;
388: END IF;
389:
390: -- Check if the Eligibility for Enhanced Funding Indicator exists
391: IF p_hesa_spa_stats_rec.enh_fund_elig_cd IS NOT NULL THEN
392: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_ELIGENFD',
393: x_value => p_hesa_spa_stats_rec.enh_fund_elig_cd) THEN
394: -- ADD excep to stack
395: FND_MESSAGE.SET_NAME('IGS','IGS_HE_ELIG_ENH_FUND_NEX');
396: FND_MSG_PUB.ADD;