eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_SUSA_LGCY_PUB dependencies on IGS_HE_CODE_VALUES_PKG

Line 112: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_HEENT',

108: END IF;
109:
110: -- Check if the New HE Entrant exists
111: IF p_hesa_susa_rec.new_he_entrant_cd IS NOT NULL THEN
112: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_HEENT',
113: x_value => p_hesa_susa_rec.new_he_entrant_cd
114: ) THEN
115: -- Add excep to stack
116: FND_MESSAGE.SET_NAME('IGS','IGS_HE_NEW_HE_ENTRN_NEX');

Line 124: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_TTA',

120: END IF;
121:
122: -- Check if the Term Time Accommodation exists
123: IF p_hesa_susa_rec.term_time_accom IS NOT NULL THEN
124: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_TTA',
125: x_value => p_hesa_susa_rec.term_time_accom
126: ) THEN
127: -- Add excep to stack
128: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TRM_ACCOMNEX');

Line 136: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_DIS_ALLOW',

132: END IF;
133:
134: -- Check if the Disability Allowance exists
135: IF p_hesa_susa_rec.disability_allow IS NOT NULL THEN
136: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_DIS_ALLOW',
137: x_value => p_hesa_susa_rec.disability_allow
138: ) THEN
139: -- Add excep to stack
140: FND_MESSAGE.SET_NAME('IGS','IGS_HE_DISB_ALLW_NEX');

Line 148: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_SUP_BAND',

144: END IF;
145:
146: -- Check if the Additional Support Band exists
147: IF p_hesa_susa_rec.additional_sup_band IS NOT NULL THEN
148: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_SUP_BAND',
149: x_value => p_hesa_susa_rec.additional_sup_band
150: ) THEN
151: -- ADD excep to stack
152: FND_MESSAGE.SET_NAME('IGS','IGS_HE_ADD_SUP_BAND_NEX');

Line 160: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_ST13',

156: END IF;
157:
158: -- Check if the SLDD discrete prov exists
159: IF p_hesa_susa_rec.sldd_discrete_prov IS NOT NULL THEN
160: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_ST13',
161: x_value => p_hesa_susa_rec.sldd_discrete_prov
162: ) THEN
163: -- Add excep to stack
164: FND_MESSAGE.SET_NAME('IGS','IGS_HE_SLDD_DISCR_NEX');

Line 172: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_MODE_TYPE',

168: END IF;
169:
170: -- Check if the Study Mode exists
171: IF p_hesa_susa_rec.study_mode IS NOT NULL THEN
172: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_MODE_TYPE',
173: x_value => p_hesa_susa_rec.study_mode
174: ) THEN
175: -- ADD excep to stack
176: FND_MESSAGE.SET_NAME('IGS','IGS_HE_STUDY_MODE_NEX');

Line 184: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_LOCSDY',

180: END IF;
181:
182: -- Check if the Study Location exists
183: IF p_hesa_susa_rec.study_location IS NOT NULL THEN
184: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_LOCSDY',
185: x_value => p_hesa_susa_rec.study_location
186: ) THEN
187: -- ADD excep to stack
188: FND_MESSAGE.SET_NAME('IGS','IGS_HE_STUDY_LOC_NEX');

Line 196: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FRAN_ACT',

192: END IF;
193:
194: -- Check if the Franchising Activity exists
195: IF p_hesa_susa_rec.franchising_activity IS NOT NULL THEN
196: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FRAN_ACT',
197: x_value => p_hesa_susa_rec.franchising_activity
198: ) THEN
199: -- ADD excep to stack
200: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FRANCH_ACT_NEX');

Line 208: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_CSTAT',

204: END IF;
205:
206: -- Check if the Completion Status exists
207: IF p_hesa_susa_rec.completion_status IS NOT NULL THEN
208: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_CSTAT',
209: x_value => p_hesa_susa_rec.completion_status
210: ) THEN
211: -- ADD excep to stack
212: FND_MESSAGE.SET_NAME('IGS','IGS_HE_COMP_STATUS_NEX');

Line 220: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_PROGRESS',

216: END IF;
217:
218: -- Check if the Good Standing Marker exists
219: IF p_hesa_susa_rec.good_stand_marker IS NOT NULL THEN
220: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_PROGRESS',
221: x_value => p_hesa_susa_rec.good_stand_marker
222: ) THEN
223: -- ADD excep to stack
224: FND_MESSAGE.SET_NAME('IGS','IGS_HE_GOOD_STAND_NEX');

Line 232: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FUNDCOMP',

228: END IF;
229:
230: -- Check if the Complete PYR Study exists
231: IF p_hesa_susa_rec.complete_pyr_study_cd IS NOT NULL THEN
232: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FUNDCOMP',
233: x_value => p_hesa_susa_rec.complete_pyr_study_cd
234: ) THEN
235: -- ADD excep to stack
236: FND_MESSAGE.SET_NAME('IGS','IGS_HE_COMP_PYR_STUDY_NEX');

Line 244: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FUND_CODE',

240: END IF;
241:
242: -- Check if the Fundability Code exists
243: IF p_hesa_susa_rec.fundability_code IS NOT NULL THEN
244: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FUND_CODE',
245: x_value => p_hesa_susa_rec.fundability_code
246: ) THEN
247: -- ADD excep to stack
248: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FUNDB_CODE_NEX');

Line 256: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FEEELIG',

252: END IF;
253:
254: -- Check if the Fee Eligibility exists
255: IF p_hesa_susa_rec.fee_eligibility IS NOT NULL THEN
256: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FEEELIG',
257: x_value => p_hesa_susa_rec.fee_eligibility
258: ) THEN
259: -- ADD excep to stack
260: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FEE_ELGBL_NEX');

Line 268: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FEEBAND',

264: END IF;
265:
266: -- Check if the Fee Band exists
267: IF p_hesa_susa_rec.fee_band IS NOT NULL THEN
268: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_FEEBAND',
269: x_value => p_hesa_susa_rec.fee_band
270: ) THEN
271: -- ADD excep to stack
272: FND_MESSAGE.SET_NAME('IGS','IGS_HE_FEE_BAND_NEX');

Line 280: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_NONPAY',

276: END IF;
277:
278: -- Check if the Non Payment Reason exists
279: IF p_hesa_susa_rec.non_payment_reason IS NOT NULL THEN
280: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_NONPAY',
281: x_value => p_hesa_susa_rec.non_payment_reason
282: ) THEN
283: -- ADD excep to stack
284: FND_MESSAGE.SET_NAME('IGS','IGS_HE_NOPAY_REASON_NEX');

Line 292: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_MSTUFEE',

288: END IF;
289:
290: -- Check if the Student Fee exists
291: IF p_hesa_susa_rec.student_fee IS NOT NULL THEN
292: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_MSTUFEE',
293: x_value => p_hesa_susa_rec.student_fee
294: ) THEN
295: -- ADD excep to stack
296: FND_MESSAGE.SET_NAME('IGS','IGS_HE_STUD_FEE_NEX');

Line 304: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_TYPEYR',

300: END IF;
301:
302: -- Check if the Type of Program Year exists
303: IF p_hesa_susa_rec.type_of_year IS NOT NULL THEN
304: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_TYPEYR',
305: x_value => p_hesa_susa_rec.type_of_year
306: ) THEN
307: -- ADD excep to stack
308: FND_MESSAGE.SET_NAME('IGS','IGS_HE_TYPE_OF_YEAR_NEX');

Line 316: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_ELIGENFD',

312: END IF;
313:
314: -- Check if the Eligibility for Enhanced Funding Indicator exists
315: IF p_hesa_susa_rec.enh_fund_elig_cd IS NOT NULL THEN
316: IF NOT igs_he_code_values_pkg.get_pk_for_validation (x_code_type => 'OSS_ELIGENFD',
317: x_value => p_hesa_susa_rec.enh_fund_elig_cd
318: ) THEN
319: -- ADD excep to stack
320: FND_MESSAGE.SET_NAME('IGS','IGS_HE_ELIG_ENH_FUND_NEX');