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_UC_QUAL_DETS_IMP_PKG dependencies on FND_MESSAGE

Line 218: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_DELETE');

214: RAISE igs_uc_he_not_enabled_excep; /* user defined exception */
215: END IF;
216:
217: -- Displays log message "Deleting the existing qualifications that are imported from UCAS and not having Advanced standing details associated with it.".
218: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_DELETE');
219: fnd_file.put_line(fnd_file.log, fnd_message.get);
220: fnd_file.put_line(fnd_file.log,' ' );
221:
222: -- Deleting All the existing Qualifications Records Imported from UCAS

Line 219: fnd_file.put_line(fnd_file.log, fnd_message.get);

215: END IF;
216:
217: -- Displays log message "Deleting the existing qualifications that are imported from UCAS and not having Advanced standing details associated with it.".
218: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_DELETE');
219: fnd_file.put_line(fnd_file.log, fnd_message.get);
220: fnd_file.put_line(fnd_file.log,' ' );
221:
222: -- Deleting All the existing Qualifications Records Imported from UCAS
223: -- and creating the Qualifications from the UCAS Interface Table.

Line 258: fnd_message.set_name('IGS','IGS_UC_QUAL_ADV_DET_EXISTS');

254:
255: --If record exists then consider the Qualification as a valid otherwise its an invalid qualification which was not resent by UCAS.
256: IF l_rec_found = 'X' THEN
257: --Valid Qualification. So display appropriate message asking user's mannual review.
258: fnd_message.set_name('IGS','IGS_UC_QUAL_ADV_DET_EXISTS');
259: fnd_message.set_token('PER_NO', l_person_number);
260: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
261: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);

Line 259: fnd_message.set_token('PER_NO', l_person_number);

255: --If record exists then consider the Qualification as a valid otherwise its an invalid qualification which was not resent by UCAS.
256: IF l_rec_found = 'X' THEN
257: --Valid Qualification. So display appropriate message asking user's mannual review.
258: fnd_message.set_name('IGS','IGS_UC_QUAL_ADV_DET_EXISTS');
259: fnd_message.set_token('PER_NO', l_person_number);
260: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
261: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);

Line 260: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);

256: IF l_rec_found = 'X' THEN
257: --Valid Qualification. So display appropriate message asking user's mannual review.
258: fnd_message.set_name('IGS','IGS_UC_QUAL_ADV_DET_EXISTS');
259: fnd_message.set_token('PER_NO', l_person_number);
260: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
261: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);

Line 261: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);

257: --Valid Qualification. So display appropriate message asking user's mannual review.
258: fnd_message.set_name('IGS','IGS_UC_QUAL_ADV_DET_EXISTS');
259: fnd_message.set_token('PER_NO', l_person_number);
260: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
261: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
265: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);

Line 262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);

258: fnd_message.set_name('IGS','IGS_UC_QUAL_ADV_DET_EXISTS');
259: fnd_message.set_token('PER_NO', l_person_number);
260: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
261: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
265: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
266: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);

259: fnd_message.set_token('PER_NO', l_person_number);
260: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
261: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
265: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
266: fnd_file.put_line(fnd_file.log, fnd_message.get);
267: fnd_file.put_line(fnd_file.log,' ' );

Line 264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);

260: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
261: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
265: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
266: fnd_file.put_line(fnd_file.log, fnd_message.get);
267: fnd_file.put_line(fnd_file.log,' ' );
268: ELSE

Line 265: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);

261: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
265: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
266: fnd_file.put_line(fnd_file.log, fnd_message.get);
267: fnd_file.put_line(fnd_file.log,' ' );
268: ELSE
269: --Invalid Qualification. So display appropriate message asking user's mannual review.

Line 266: fnd_file.put_line(fnd_file.log, fnd_message.get);

262: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
263: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
264: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
265: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
266: fnd_file.put_line(fnd_file.log, fnd_message.get);
267: fnd_file.put_line(fnd_file.log,' ' );
268: ELSE
269: --Invalid Qualification. So display appropriate message asking user's mannual review.
270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');

Line 270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');

266: fnd_file.put_line(fnd_file.log, fnd_message.get);
267: fnd_file.put_line(fnd_file.log,' ' );
268: ELSE
269: --Invalid Qualification. So display appropriate message asking user's mannual review.
270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');
271: fnd_message.set_token('PER_NO', l_person_number);
272: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);

Line 271: fnd_message.set_token('PER_NO', l_person_number);

267: fnd_file.put_line(fnd_file.log,' ' );
268: ELSE
269: --Invalid Qualification. So display appropriate message asking user's mannual review.
270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');
271: fnd_message.set_token('PER_NO', l_person_number);
272: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);

Line 272: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);

268: ELSE
269: --Invalid Qualification. So display appropriate message asking user's mannual review.
270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');
271: fnd_message.set_token('PER_NO', l_person_number);
272: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);

Line 273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);

269: --Invalid Qualification. So display appropriate message asking user's mannual review.
270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');
271: fnd_message.set_token('PER_NO', l_person_number);
272: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
277: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);

Line 274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);

270: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_INVALID');
271: fnd_message.set_token('PER_NO', l_person_number);
272: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
277: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
278: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);

271: fnd_message.set_token('PER_NO', l_person_number);
272: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
277: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
278: fnd_file.put_line(fnd_file.log, fnd_message.get);
279: fnd_file.put_line(fnd_file.log,' ' );

Line 276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);

272: fnd_message.set_token('EXM_LVL', cur_del_qual_dets_rec.exam_level);
273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
277: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
278: fnd_file.put_line(fnd_file.log, fnd_message.get);
279: fnd_file.put_line(fnd_file.log,' ' );
280: END IF;

Line 277: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);

273: fnd_message.set_token('SUBJ_CD', cur_del_qual_dets_rec.subject_code);
274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
277: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
278: fnd_file.put_line(fnd_file.log, fnd_message.get);
279: fnd_file.put_line(fnd_file.log,' ' );
280: END IF;
281:

Line 278: fnd_file.put_line(fnd_file.log, fnd_message.get);

274: fnd_message.set_token('YEAR', cur_del_qual_dets_rec.year);
275: fnd_message.set_token('SITTING', cur_del_qual_dets_rec.sitting);
276: fnd_message.set_token('AWD_BDY', cur_del_qual_dets_rec.awarding_body);
277: fnd_message.set_token('EBL_RSLT',cur_del_qual_dets_rec.approved_result);
278: fnd_file.put_line(fnd_file.log, fnd_message.get);
279: fnd_file.put_line(fnd_file.log,' ' );
280: END IF;
281:
282: ELSE

Line 292: fnd_message.set_name('IGS','IGS_UC_IMP_QUAL_DETS');

288: END LOOP ;
289:
290: -- Displays log message "Importing Qualification details data from UCAS Interface table to Qualification Details table".
291: fnd_file.put_line(fnd_file.log,' ' );
292: fnd_message.set_name('IGS','IGS_UC_IMP_QUAL_DETS');
293: fnd_file.put_line(fnd_file.log, fnd_message.get);
294: fnd_file.put_line(fnd_file.log,' ' );
295:
296: /* Picking up records from igs_uc_com_ebl_subj table for Importing in to qual dets table */

Line 293: fnd_file.put_line(fnd_file.log, fnd_message.get);

289:
290: -- Displays log message "Importing Qualification details data from UCAS Interface table to Qualification Details table".
291: fnd_file.put_line(fnd_file.log,' ' );
292: fnd_message.set_name('IGS','IGS_UC_IMP_QUAL_DETS');
293: fnd_file.put_line(fnd_file.log, fnd_message.get);
294: fnd_file.put_line(fnd_file.log,' ' );
295:
296: /* Picking up records from igs_uc_com_ebl_subj table for Importing in to qual dets table */
297: FOR I IN cur_ucas_interface LOOP

Line 338: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_REC_EXISTS');

334: IF l_imported = 'Y' THEN
335:
336: --Diplays message "the record is already imported.
337: --so nothing should happen in this case i.e., not considered for import".
338: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_REC_EXISTS');
339: fnd_message.set_token('PER_NO', J.person_number);
340: fnd_message.set_token('APP_NO', J.app_no);
341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);
342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);

Line 339: fnd_message.set_token('PER_NO', J.person_number);

335:
336: --Diplays message "the record is already imported.
337: --so nothing should happen in this case i.e., not considered for import".
338: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_REC_EXISTS');
339: fnd_message.set_token('PER_NO', J.person_number);
340: fnd_message.set_token('APP_NO', J.app_no);
341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);
342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);
343: fnd_message.set_token('YEAR', I.year);

Line 340: fnd_message.set_token('APP_NO', J.app_no);

336: --Diplays message "the record is already imported.
337: --so nothing should happen in this case i.e., not considered for import".
338: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_REC_EXISTS');
339: fnd_message.set_token('PER_NO', J.person_number);
340: fnd_message.set_token('APP_NO', J.app_no);
341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);
342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);
343: fnd_message.set_token('YEAR', I.year);
344: fnd_message.set_token('SITTING', I.sitting);

Line 341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);

337: --so nothing should happen in this case i.e., not considered for import".
338: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_REC_EXISTS');
339: fnd_message.set_token('PER_NO', J.person_number);
340: fnd_message.set_token('APP_NO', J.app_no);
341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);
342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);
343: fnd_message.set_token('YEAR', I.year);
344: fnd_message.set_token('SITTING', I.sitting);
345: fnd_message.set_token('AWD_BDY', l_oss_awarding_body);

Line 342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);

338: fnd_message.set_name('IGS','IGS_UC_QUAL_DETS_REC_EXISTS');
339: fnd_message.set_token('PER_NO', J.person_number);
340: fnd_message.set_token('APP_NO', J.app_no);
341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);
342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);
343: fnd_message.set_token('YEAR', I.year);
344: fnd_message.set_token('SITTING', I.sitting);
345: fnd_message.set_token('AWD_BDY', l_oss_awarding_body);
346: fnd_message.set_token('EBL_RSLT',J.ebl_result);

Line 343: fnd_message.set_token('YEAR', I.year);

339: fnd_message.set_token('PER_NO', J.person_number);
340: fnd_message.set_token('APP_NO', J.app_no);
341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);
342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);
343: fnd_message.set_token('YEAR', I.year);
344: fnd_message.set_token('SITTING', I.sitting);
345: fnd_message.set_token('AWD_BDY', l_oss_awarding_body);
346: fnd_message.set_token('EBL_RSLT',J.ebl_result);
347: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 344: fnd_message.set_token('SITTING', I.sitting);

340: fnd_message.set_token('APP_NO', J.app_no);
341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);
342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);
343: fnd_message.set_token('YEAR', I.year);
344: fnd_message.set_token('SITTING', I.sitting);
345: fnd_message.set_token('AWD_BDY', l_oss_awarding_body);
346: fnd_message.set_token('EBL_RSLT',J.ebl_result);
347: fnd_file.put_line(fnd_file.log, fnd_message.get);
348:

Line 345: fnd_message.set_token('AWD_BDY', l_oss_awarding_body);

341: fnd_message.set_token('EXM_LVL', l_oss_exam_level);
342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);
343: fnd_message.set_token('YEAR', I.year);
344: fnd_message.set_token('SITTING', I.sitting);
345: fnd_message.set_token('AWD_BDY', l_oss_awarding_body);
346: fnd_message.set_token('EBL_RSLT',J.ebl_result);
347: fnd_file.put_line(fnd_file.log, fnd_message.get);
348:
349: ELSIF l_imported = 'N' THEN

Line 346: fnd_message.set_token('EBL_RSLT',J.ebl_result);

342: fnd_message.set_token('SUBJ_CD', l_oss_subject_code);
343: fnd_message.set_token('YEAR', I.year);
344: fnd_message.set_token('SITTING', I.sitting);
345: fnd_message.set_token('AWD_BDY', l_oss_awarding_body);
346: fnd_message.set_token('EBL_RSLT',J.ebl_result);
347: fnd_file.put_line(fnd_file.log, fnd_message.get);
348:
349: ELSIF l_imported = 'N' THEN
350:

Line 347: fnd_file.put_line(fnd_file.log, fnd_message.get);

343: fnd_message.set_token('YEAR', I.year);
344: fnd_message.set_token('SITTING', I.sitting);
345: fnd_message.set_token('AWD_BDY', l_oss_awarding_body);
346: fnd_message.set_token('EBL_RSLT',J.ebl_result);
347: fnd_file.put_line(fnd_file.log, fnd_message.get);
348:
349: ELSIF l_imported = 'N' THEN
350:
351: /* This means the record is manually entered so only the approved result should be updated */

Line 364: fnd_message.set_name('IGS','IGS_UC_ADV_STD_DET_EXISTS');

360: CLOSE cur_adv_std_exists ;
361:
362: IF l_rec_found = 'X' THEN
363: --Display a message that qualification is not updated because of advanced standing details exist.
364: fnd_message.set_name('IGS','IGS_UC_ADV_STD_DET_EXISTS');
365: fnd_message.set_token('PER_NO', J.person_number);
366: fnd_message.set_token('APP_NO', J.app_no);
367: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);

Line 365: fnd_message.set_token('PER_NO', J.person_number);

361:
362: IF l_rec_found = 'X' THEN
363: --Display a message that qualification is not updated because of advanced standing details exist.
364: fnd_message.set_name('IGS','IGS_UC_ADV_STD_DET_EXISTS');
365: fnd_message.set_token('PER_NO', J.person_number);
366: fnd_message.set_token('APP_NO', J.app_no);
367: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);

Line 366: fnd_message.set_token('APP_NO', J.app_no);

362: IF l_rec_found = 'X' THEN
363: --Display a message that qualification is not updated because of advanced standing details exist.
364: fnd_message.set_name('IGS','IGS_UC_ADV_STD_DET_EXISTS');
365: fnd_message.set_token('PER_NO', J.person_number);
366: fnd_message.set_token('APP_NO', J.app_no);
367: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);

Line 367: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);

363: --Display a message that qualification is not updated because of advanced standing details exist.
364: fnd_message.set_name('IGS','IGS_UC_ADV_STD_DET_EXISTS');
365: fnd_message.set_token('PER_NO', J.person_number);
366: fnd_message.set_token('APP_NO', J.app_no);
367: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
371: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);

Line 368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);

364: fnd_message.set_name('IGS','IGS_UC_ADV_STD_DET_EXISTS');
365: fnd_message.set_token('PER_NO', J.person_number);
366: fnd_message.set_token('APP_NO', J.app_no);
367: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
371: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
372: fnd_message.set_token('EBL_RSLT',J.ebl_result);

Line 369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);

365: fnd_message.set_token('PER_NO', J.person_number);
366: fnd_message.set_token('APP_NO', J.app_no);
367: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
371: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
372: fnd_message.set_token('EBL_RSLT',J.ebl_result);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);

366: fnd_message.set_token('APP_NO', J.app_no);
367: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
371: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
372: fnd_message.set_token('EBL_RSLT',J.ebl_result);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSE

Line 371: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);

367: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
371: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
372: fnd_message.set_token('EBL_RSLT',J.ebl_result);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSE
375: --Diplays message "Updating record".

Line 372: fnd_message.set_token('EBL_RSLT',J.ebl_result);

368: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
371: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
372: fnd_message.set_token('EBL_RSLT',J.ebl_result);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSE
375: --Diplays message "Updating record".
376: fnd_message.set_name('IGS','IGS_UC_UPD_QUAL_DETS_REC');

Line 373: fnd_file.put_line(fnd_file.log, fnd_message.get);

369: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
370: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
371: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
372: fnd_message.set_token('EBL_RSLT',J.ebl_result);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSE
375: --Diplays message "Updating record".
376: fnd_message.set_name('IGS','IGS_UC_UPD_QUAL_DETS_REC');
377: fnd_message.set_token('PER_NO', J.person_number);

Line 376: fnd_message.set_name('IGS','IGS_UC_UPD_QUAL_DETS_REC');

372: fnd_message.set_token('EBL_RSLT',J.ebl_result);
373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSE
375: --Diplays message "Updating record".
376: fnd_message.set_name('IGS','IGS_UC_UPD_QUAL_DETS_REC');
377: fnd_message.set_token('PER_NO', J.person_number);
378: fnd_message.set_token('APP_NO', J.app_no);
379: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);

Line 377: fnd_message.set_token('PER_NO', J.person_number);

373: fnd_file.put_line(fnd_file.log, fnd_message.get);
374: ELSE
375: --Diplays message "Updating record".
376: fnd_message.set_name('IGS','IGS_UC_UPD_QUAL_DETS_REC');
377: fnd_message.set_token('PER_NO', J.person_number);
378: fnd_message.set_token('APP_NO', J.app_no);
379: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);

Line 378: fnd_message.set_token('APP_NO', J.app_no);

374: ELSE
375: --Diplays message "Updating record".
376: fnd_message.set_name('IGS','IGS_UC_UPD_QUAL_DETS_REC');
377: fnd_message.set_token('PER_NO', J.person_number);
378: fnd_message.set_token('APP_NO', J.app_no);
379: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);

Line 379: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);

375: --Diplays message "Updating record".
376: fnd_message.set_name('IGS','IGS_UC_UPD_QUAL_DETS_REC');
377: fnd_message.set_token('PER_NO', J.person_number);
378: fnd_message.set_token('APP_NO', J.app_no);
379: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);

Line 380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);

376: fnd_message.set_name('IGS','IGS_UC_UPD_QUAL_DETS_REC');
377: fnd_message.set_token('PER_NO', J.person_number);
378: fnd_message.set_token('APP_NO', J.app_no);
379: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);

Line 381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);

377: fnd_message.set_token('PER_NO', J.person_number);
378: fnd_message.set_token('APP_NO', J.app_no);
379: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);
385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);

Line 382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);

378: fnd_message.set_token('APP_NO', J.app_no);
379: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);
385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);
386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);

Line 383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);

379: fnd_message.set_token('EXM_LVL', Cur_qual_dets_val.Exam_level);
380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);
385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);
386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);
387: fnd_message.set_token('EBL_RSLT',J.ebl_result);

Line 384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);

380: fnd_message.set_token('SUBJ_CD', Cur_qual_dets_val.subject_code);
381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);
385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);
386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);
387: fnd_message.set_token('EBL_RSLT',J.ebl_result);
388: fnd_message.set_token('CLM_RSLT',Cur_qual_dets_val.claimed_result);

Line 385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);

381: fnd_message.set_token('YEAR', Cur_qual_dets_val.year);
382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);
385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);
386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);
387: fnd_message.set_token('EBL_RSLT',J.ebl_result);
388: fnd_message.set_token('CLM_RSLT',Cur_qual_dets_val.claimed_result);
389: fnd_message.set_token('TARIFF', Cur_qual_dets_val.ucas_tariff);

Line 386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);

382: fnd_message.set_token('SITTING', Cur_qual_dets_val.sitting);
383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);
385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);
386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);
387: fnd_message.set_token('EBL_RSLT',J.ebl_result);
388: fnd_message.set_token('CLM_RSLT',Cur_qual_dets_val.claimed_result);
389: fnd_message.set_token('TARIFF', Cur_qual_dets_val.ucas_tariff);
390: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 387: fnd_message.set_token('EBL_RSLT',J.ebl_result);

383: fnd_message.set_token('AWD_BDY', Cur_qual_dets_val.awarding_body);
384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);
385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);
386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);
387: fnd_message.set_token('EBL_RSLT',J.ebl_result);
388: fnd_message.set_token('CLM_RSLT',Cur_qual_dets_val.claimed_result);
389: fnd_message.set_token('TARIFF', Cur_qual_dets_val.ucas_tariff);
390: fnd_file.put_line(fnd_file.log, fnd_message.get);
391:

Line 388: fnd_message.set_token('CLM_RSLT',Cur_qual_dets_val.claimed_result);

384: fnd_message.set_token('GS_CD', Cur_qual_dets_val.grading_schema_cd);
385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);
386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);
387: fnd_message.set_token('EBL_RSLT',J.ebl_result);
388: fnd_message.set_token('CLM_RSLT',Cur_qual_dets_val.claimed_result);
389: fnd_message.set_token('TARIFF', Cur_qual_dets_val.ucas_tariff);
390: fnd_file.put_line(fnd_file.log, fnd_message.get);
391:
392: IF cur_qual_dets_val.grading_schema_cd IS NOT NULL

Line 389: fnd_message.set_token('TARIFF', Cur_qual_dets_val.ucas_tariff);

385: fnd_message.set_token('GS_VER', Cur_qual_dets_val.version_number);
386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);
387: fnd_message.set_token('EBL_RSLT',J.ebl_result);
388: fnd_message.set_token('CLM_RSLT',Cur_qual_dets_val.claimed_result);
389: fnd_message.set_token('TARIFF', Cur_qual_dets_val.ucas_tariff);
390: fnd_file.put_line(fnd_file.log, fnd_message.get);
391:
392: IF cur_qual_dets_val.grading_schema_cd IS NOT NULL
393: AND cur_qual_dets_val.version_number IS NOT NULL

Line 390: fnd_file.put_line(fnd_file.log, fnd_message.get);

386: fnd_message.set_token('PRD_RSLT',Cur_qual_dets_val.predicted_result);
387: fnd_message.set_token('EBL_RSLT',J.ebl_result);
388: fnd_message.set_token('CLM_RSLT',Cur_qual_dets_val.claimed_result);
389: fnd_message.set_token('TARIFF', Cur_qual_dets_val.ucas_tariff);
390: fnd_file.put_line(fnd_file.log, fnd_message.get);
391:
392: IF cur_qual_dets_val.grading_schema_cd IS NOT NULL
393: AND cur_qual_dets_val.version_number IS NOT NULL
394: AND j.ebl_result IS NOT NULL

Line 400: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');

396: UPPER(TRIM(c_grad_sch_rec.grading_schema_cd)),
397: c_grad_sch_rec.gs_version_number,
398: UPPER(TRIM(j.claimed_result)) ) THEN
399:
400: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
401: fnd_message.set_token('GS_CD',cur_qual_dets_val.grading_schema_cd);
402: fnd_message.set_token('GS_VER',cur_qual_dets_val.version_number);
403: fnd_message.set_token('APP_RESULT',j.ebl_result);
404: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 401: fnd_message.set_token('GS_CD',cur_qual_dets_val.grading_schema_cd);

397: c_grad_sch_rec.gs_version_number,
398: UPPER(TRIM(j.claimed_result)) ) THEN
399:
400: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
401: fnd_message.set_token('GS_CD',cur_qual_dets_val.grading_schema_cd);
402: fnd_message.set_token('GS_VER',cur_qual_dets_val.version_number);
403: fnd_message.set_token('APP_RESULT',j.ebl_result);
404: fnd_file.put_line(fnd_file.log, fnd_message.get);
405: l_records_errored := NVL(l_records_errored ,0) + 1 ;

Line 402: fnd_message.set_token('GS_VER',cur_qual_dets_val.version_number);

398: UPPER(TRIM(j.claimed_result)) ) THEN
399:
400: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
401: fnd_message.set_token('GS_CD',cur_qual_dets_val.grading_schema_cd);
402: fnd_message.set_token('GS_VER',cur_qual_dets_val.version_number);
403: fnd_message.set_token('APP_RESULT',j.ebl_result);
404: fnd_file.put_line(fnd_file.log, fnd_message.get);
405: l_records_errored := NVL(l_records_errored ,0) + 1 ;
406:

Line 403: fnd_message.set_token('APP_RESULT',j.ebl_result);

399:
400: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
401: fnd_message.set_token('GS_CD',cur_qual_dets_val.grading_schema_cd);
402: fnd_message.set_token('GS_VER',cur_qual_dets_val.version_number);
403: fnd_message.set_token('APP_RESULT',j.ebl_result);
404: fnd_file.put_line(fnd_file.log, fnd_message.get);
405: l_records_errored := NVL(l_records_errored ,0) + 1 ;
406:
407: ELSE

Line 404: fnd_file.put_line(fnd_file.log, fnd_message.get);

400: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
401: fnd_message.set_token('GS_CD',cur_qual_dets_val.grading_schema_cd);
402: fnd_message.set_token('GS_VER',cur_qual_dets_val.version_number);
403: fnd_message.set_token('APP_RESULT',j.ebl_result);
404: fnd_file.put_line(fnd_file.log, fnd_message.get);
405: l_records_errored := NVL(l_records_errored ,0) + 1 ;
406:
407: ELSE
408:

Line 443: fnd_message.set_name('IGS','IGS_UC_INS_QUAL_DETS_REC');

439:
440: --smaddali 27-jun-2002 added fields grading_schema_cd , version_number, logging person_number
441: --instead of person_id and logging application number for bug 2430139
442: --Diplays message "Inserting record".
443: fnd_message.set_name('IGS','IGS_UC_INS_QUAL_DETS_REC');
444: fnd_message.set_token('PER_NO', J.person_Number);
445: fnd_message.set_token('APP_NO', J.app_no);
446: fnd_message.set_token('EXM_LVL', l_oss_exam_level||' ('||I.exam_level||') ');
447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');

Line 444: fnd_message.set_token('PER_NO', J.person_Number);

440: --smaddali 27-jun-2002 added fields grading_schema_cd , version_number, logging person_number
441: --instead of person_id and logging application number for bug 2430139
442: --Diplays message "Inserting record".
443: fnd_message.set_name('IGS','IGS_UC_INS_QUAL_DETS_REC');
444: fnd_message.set_token('PER_NO', J.person_Number);
445: fnd_message.set_token('APP_NO', J.app_no);
446: fnd_message.set_token('EXM_LVL', l_oss_exam_level||' ('||I.exam_level||') ');
447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');
448: fnd_message.set_token('YEAR', I.year);

Line 445: fnd_message.set_token('APP_NO', J.app_no);

441: --instead of person_id and logging application number for bug 2430139
442: --Diplays message "Inserting record".
443: fnd_message.set_name('IGS','IGS_UC_INS_QUAL_DETS_REC');
444: fnd_message.set_token('PER_NO', J.person_Number);
445: fnd_message.set_token('APP_NO', J.app_no);
446: fnd_message.set_token('EXM_LVL', l_oss_exam_level||' ('||I.exam_level||') ');
447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');
448: fnd_message.set_token('YEAR', I.year);
449: fnd_message.set_token('SITTING', I.sitting);

Line 446: fnd_message.set_token('EXM_LVL', l_oss_exam_level||' ('||I.exam_level||') ');

442: --Diplays message "Inserting record".
443: fnd_message.set_name('IGS','IGS_UC_INS_QUAL_DETS_REC');
444: fnd_message.set_token('PER_NO', J.person_Number);
445: fnd_message.set_token('APP_NO', J.app_no);
446: fnd_message.set_token('EXM_LVL', l_oss_exam_level||' ('||I.exam_level||') ');
447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');
448: fnd_message.set_token('YEAR', I.year);
449: fnd_message.set_token('SITTING', I.sitting);
450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');

Line 447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');

443: fnd_message.set_name('IGS','IGS_UC_INS_QUAL_DETS_REC');
444: fnd_message.set_token('PER_NO', J.person_Number);
445: fnd_message.set_token('APP_NO', J.app_no);
446: fnd_message.set_token('EXM_LVL', l_oss_exam_level||' ('||I.exam_level||') ');
447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');
448: fnd_message.set_token('YEAR', I.year);
449: fnd_message.set_token('SITTING', I.sitting);
450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');
451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);

Line 448: fnd_message.set_token('YEAR', I.year);

444: fnd_message.set_token('PER_NO', J.person_Number);
445: fnd_message.set_token('APP_NO', J.app_no);
446: fnd_message.set_token('EXM_LVL', l_oss_exam_level||' ('||I.exam_level||') ');
447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');
448: fnd_message.set_token('YEAR', I.year);
449: fnd_message.set_token('SITTING', I.sitting);
450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');
451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);
452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);

Line 449: fnd_message.set_token('SITTING', I.sitting);

445: fnd_message.set_token('APP_NO', J.app_no);
446: fnd_message.set_token('EXM_LVL', l_oss_exam_level||' ('||I.exam_level||') ');
447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');
448: fnd_message.set_token('YEAR', I.year);
449: fnd_message.set_token('SITTING', I.sitting);
450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');
451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);
452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);
453: fnd_message.set_token('EBL_RSLT',J.ebl_result);

Line 450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');

446: fnd_message.set_token('EXM_LVL', l_oss_exam_level||' ('||I.exam_level||') ');
447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');
448: fnd_message.set_token('YEAR', I.year);
449: fnd_message.set_token('SITTING', I.sitting);
450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');
451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);
452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);
453: fnd_message.set_token('EBL_RSLT',J.ebl_result);
454: fnd_message.set_token('CLM_RSLT',J.claimed_result);

Line 451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);

447: fnd_message.set_token('SUBJ_CD', l_oss_subject_code||' (' ||I.subject_code||') ');
448: fnd_message.set_token('YEAR', I.year);
449: fnd_message.set_token('SITTING', I.sitting);
450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');
451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);
452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);
453: fnd_message.set_token('EBL_RSLT',J.ebl_result);
454: fnd_message.set_token('CLM_RSLT',J.claimed_result);
455: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);

448: fnd_message.set_token('YEAR', I.year);
449: fnd_message.set_token('SITTING', I.sitting);
450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');
451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);
452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);
453: fnd_message.set_token('EBL_RSLT',J.ebl_result);
454: fnd_message.set_token('CLM_RSLT',J.claimed_result);
455: fnd_file.put_line(fnd_file.log, fnd_message.get);
456:

Line 453: fnd_message.set_token('EBL_RSLT',J.ebl_result);

449: fnd_message.set_token('SITTING', I.sitting);
450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');
451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);
452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);
453: fnd_message.set_token('EBL_RSLT',J.ebl_result);
454: fnd_message.set_token('CLM_RSLT',J.claimed_result);
455: fnd_file.put_line(fnd_file.log, fnd_message.get);
456:
457: l_rowid := NULL ;

Line 454: fnd_message.set_token('CLM_RSLT',J.claimed_result);

450: fnd_message.set_token('AWD_BDY', l_oss_awarding_body||' ('||I.Awarding_body||') ');
451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);
452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);
453: fnd_message.set_token('EBL_RSLT',J.ebl_result);
454: fnd_message.set_token('CLM_RSLT',J.claimed_result);
455: fnd_file.put_line(fnd_file.log, fnd_message.get);
456:
457: l_rowid := NULL ;
458: l_validation_status := TRUE ;

Line 455: fnd_file.put_line(fnd_file.log, fnd_message.get);

451: fnd_message.set_token('GS_CD', C_grad_sch_rec.grading_schema_cd);
452: fnd_message.set_token('GS_VER', C_grad_sch_rec.gs_version_number);
453: fnd_message.set_token('EBL_RSLT',J.ebl_result);
454: fnd_message.set_token('CLM_RSLT',J.claimed_result);
455: fnd_file.put_line(fnd_file.log, fnd_message.get);
456:
457: l_rowid := NULL ;
458: l_validation_status := TRUE ;
459:

Line 462: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');

458: l_validation_status := TRUE ;
459:
460: -- Check whether the UCAS EXam Level to OSS Award Mapping exist in the HESA Table
461: IF l_oss_exam_level IS NULL THEN
462: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
463: fnd_message.set_token('CODE',I.Exam_level);
464: fnd_message.set_token('TYPE', 'EXAM LEVEL');
465: fnd_file.put_line(fnd_file.log, fnd_message.get);
466: l_validation_status := FALSE ;

Line 463: fnd_message.set_token('CODE',I.Exam_level);

459:
460: -- Check whether the UCAS EXam Level to OSS Award Mapping exist in the HESA Table
461: IF l_oss_exam_level IS NULL THEN
462: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
463: fnd_message.set_token('CODE',I.Exam_level);
464: fnd_message.set_token('TYPE', 'EXAM LEVEL');
465: fnd_file.put_line(fnd_file.log, fnd_message.get);
466: l_validation_status := FALSE ;
467: END IF ;

Line 464: fnd_message.set_token('TYPE', 'EXAM LEVEL');

460: -- Check whether the UCAS EXam Level to OSS Award Mapping exist in the HESA Table
461: IF l_oss_exam_level IS NULL THEN
462: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
463: fnd_message.set_token('CODE',I.Exam_level);
464: fnd_message.set_token('TYPE', 'EXAM LEVEL');
465: fnd_file.put_line(fnd_file.log, fnd_message.get);
466: l_validation_status := FALSE ;
467: END IF ;
468:

Line 465: fnd_file.put_line(fnd_file.log, fnd_message.get);

461: IF l_oss_exam_level IS NULL THEN
462: fnd_message.set_name('IGS','IGS_UC_INV_MAPPING_VAL');
463: fnd_message.set_token('CODE',I.Exam_level);
464: fnd_message.set_token('TYPE', 'EXAM LEVEL');
465: fnd_file.put_line(fnd_file.log, fnd_message.get);
466: l_validation_status := FALSE ;
467: END IF ;
468:
469: -- Check whether the Grading Scema and Grade Combination exist in the Parent Table

Line 478: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');

474: UPPER(TRIM(c_grad_sch_rec.grading_schema_cd)),
475: c_grad_sch_rec.gs_version_number,
476: UPPER(TRIM(j.ebl_result)) ) THEN
477:
478: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
479: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
480: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
481: fnd_message.set_token('APP_RESULT',j.ebl_result);
482: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 479: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);

475: c_grad_sch_rec.gs_version_number,
476: UPPER(TRIM(j.ebl_result)) ) THEN
477:
478: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
479: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
480: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
481: fnd_message.set_token('APP_RESULT',j.ebl_result);
482: fnd_file.put_line(fnd_file.log, fnd_message.get);
483: l_validation_status := FALSE ;

Line 480: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);

476: UPPER(TRIM(j.ebl_result)) ) THEN
477:
478: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
479: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
480: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
481: fnd_message.set_token('APP_RESULT',j.ebl_result);
482: fnd_file.put_line(fnd_file.log, fnd_message.get);
483: l_validation_status := FALSE ;
484:

Line 481: fnd_message.set_token('APP_RESULT',j.ebl_result);

477:
478: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
479: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
480: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
481: fnd_message.set_token('APP_RESULT',j.ebl_result);
482: fnd_file.put_line(fnd_file.log, fnd_message.get);
483: l_validation_status := FALSE ;
484:
485: ELSIF c_grad_sch_rec.grading_schema_cd IS NOT NULL

Line 482: fnd_file.put_line(fnd_file.log, fnd_message.get);

478: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
479: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
480: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
481: fnd_message.set_token('APP_RESULT',j.ebl_result);
482: fnd_file.put_line(fnd_file.log, fnd_message.get);
483: l_validation_status := FALSE ;
484:
485: ELSIF c_grad_sch_rec.grading_schema_cd IS NOT NULL
486: AND c_grad_sch_rec.gs_version_number IS NOT NULL

Line 493: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');

489: UPPER(TRIM(c_grad_sch_rec.grading_schema_cd)),
490: c_grad_sch_rec.gs_version_number,
491: UPPER(TRIM(j.claimed_result)) ) THEN
492:
493: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
494: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
495: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
496: fnd_message.set_token('APP_RESULT',j.claimed_result);
497: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 494: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);

490: c_grad_sch_rec.gs_version_number,
491: UPPER(TRIM(j.claimed_result)) ) THEN
492:
493: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
494: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
495: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
496: fnd_message.set_token('APP_RESULT',j.claimed_result);
497: fnd_file.put_line(fnd_file.log, fnd_message.get);
498: l_validation_status := FALSE ;

Line 495: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);

491: UPPER(TRIM(j.claimed_result)) ) THEN
492:
493: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
494: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
495: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
496: fnd_message.set_token('APP_RESULT',j.claimed_result);
497: fnd_file.put_line(fnd_file.log, fnd_message.get);
498: l_validation_status := FALSE ;
499:

Line 496: fnd_message.set_token('APP_RESULT',j.claimed_result);

492:
493: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
494: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
495: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
496: fnd_message.set_token('APP_RESULT',j.claimed_result);
497: fnd_file.put_line(fnd_file.log, fnd_message.get);
498: l_validation_status := FALSE ;
499:
500: END IF ;

Line 497: fnd_file.put_line(fnd_file.log, fnd_message.get);

493: fnd_message.set_name('IGS','IGS_UC_GRAD_NOT_FOUND');
494: fnd_message.set_token('GS_CD',c_grad_sch_rec.grading_schema_cd);
495: fnd_message.set_token('GS_VER',c_grad_sch_rec.gs_version_number);
496: fnd_message.set_token('APP_RESULT',j.claimed_result);
497: fnd_file.put_line(fnd_file.log, fnd_message.get);
498: l_validation_status := FALSE ;
499:
500: END IF ;
501:

Line 547: fnd_message.set_name('IGS','IGS_UC_QUAL_DET_IMP_ERR');

543: IF l_mesg_data IS NOT NULL THEN
544: l_mesg_data := ' - '||l_mesg_data;
545: END IF;
546: END IF;
547: fnd_message.set_name('IGS','IGS_UC_QUAL_DET_IMP_ERR');
548: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_mesg_data);
549:
550: END; -- End of Anonymous block
551:

Line 548: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_mesg_data);

544: l_mesg_data := ' - '||l_mesg_data;
545: END IF;
546: END IF;
547: fnd_message.set_name('IGS','IGS_UC_QUAL_DET_IMP_ERR');
548: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_mesg_data);
549:
550: END; -- End of Anonymous block
551:
552: fnd_file.put_line(fnd_file.log,' ' );

Line 561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));

557: END LOOP; -- igs_uc_com_ebl_subj Records Loop
558:
559: fnd_file.put_line(fnd_file.log,' ' );
560: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));
562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');

559: fnd_file.put_line(fnd_file.log,' ' );
560: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));
562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));

Line 564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));

560: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));
562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 565: fnd_file.put_line(fnd_file.log, fnd_message.get);

561: fnd_file.put_line(fnd_file.log,SUBSTR(fnd_message.get_string('IGS','IGS_UC_INS_REC_STAT_INT'), 29, 22));
562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');

Line 566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');

562: fnd_file.put_line(fnd_file.log,RPAD('-',22,'-'));
563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));

Line 567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));

563: fnd_message.set_name('IGS','IGS_UC_DEL_REC_COUNT');
564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 568: fnd_file.put_line(fnd_file.log, fnd_message.get);

564: fnd_message.set_token('REC_CNT', NVL(l_records_deleted,0));
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');

Line 569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');

565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');
573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));

Line 570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));

566: fnd_message.set_name('IGS','IGS_UC_INS_REC_COUNT');
567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');
573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));
574: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 571: fnd_file.put_line(fnd_file.log, fnd_message.get);

567: fnd_message.set_token('REC_CNT', NVL(l_records_inserted,0));
568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');
573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));
574: fnd_file.put_line(fnd_file.log, fnd_message.get);
575: fnd_file.put_line(fnd_file.log,' ' );

Line 572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');

568: fnd_file.put_line(fnd_file.log, fnd_message.get);
569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');
573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));
574: fnd_file.put_line(fnd_file.log, fnd_message.get);
575: fnd_file.put_line(fnd_file.log,' ' );
576:

Line 573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));

569: fnd_message.set_name('IGS','IGS_UC_UPD_REC_COUNT');
570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');
573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));
574: fnd_file.put_line(fnd_file.log, fnd_message.get);
575: fnd_file.put_line(fnd_file.log,' ' );
576:
577:

Line 574: fnd_file.put_line(fnd_file.log, fnd_message.get);

570: fnd_message.set_token('REC_CNT', NVL(l_records_updated,0));
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572: fnd_message.set_name('IGS','IGS_UC_ERR_REC_COUNT');
573: fnd_message.set_token('REC_CNT', NVL(l_records_errored,0));
574: fnd_file.put_line(fnd_file.log, fnd_message.get);
575: fnd_file.put_line(fnd_file.log,' ' );
576:
577:
578: EXCEPTION

Line 581: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');

577:
578: EXCEPTION
579:
580: WHEN igs_uc_he_not_enabled_excep THEN
581: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');
582: fnd_file.put_line(fnd_file.log, fnd_message.get);
583: retcode := 2;
584: igs_ge_msg_stack.conc_exception_hndl;
585:

Line 582: fnd_file.put_line(fnd_file.log, fnd_message.get);

578: EXCEPTION
579:
580: WHEN igs_uc_he_not_enabled_excep THEN
581: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');
582: fnd_file.put_line(fnd_file.log, fnd_message.get);
583: retcode := 2;
584: igs_ge_msg_stack.conc_exception_hndl;
585:
586: WHEN OTHERS THEN

Line 588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

584: igs_ge_msg_stack.conc_exception_hndl;
585:
586: WHEN OTHERS THEN
587: ROLLBACK;
588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
589: fnd_message.set_token('NAME', 'IGS_UC_QUAL_DETS_IMP_PKG.IGS_UC_QUAL_DETS_IMP'||' - '||SQLERRM);
590: fnd_message.retrieve (Errbuf);
591: retcode := 2;
592: igs_ge_msg_stack.conc_exception_hndl;

Line 589: fnd_message.set_token('NAME', 'IGS_UC_QUAL_DETS_IMP_PKG.IGS_UC_QUAL_DETS_IMP'||' - '||SQLERRM);

585:
586: WHEN OTHERS THEN
587: ROLLBACK;
588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
589: fnd_message.set_token('NAME', 'IGS_UC_QUAL_DETS_IMP_PKG.IGS_UC_QUAL_DETS_IMP'||' - '||SQLERRM);
590: fnd_message.retrieve (Errbuf);
591: retcode := 2;
592: igs_ge_msg_stack.conc_exception_hndl;
593:

Line 590: fnd_message.retrieve (Errbuf);

586: WHEN OTHERS THEN
587: ROLLBACK;
588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
589: fnd_message.set_token('NAME', 'IGS_UC_QUAL_DETS_IMP_PKG.IGS_UC_QUAL_DETS_IMP'||' - '||SQLERRM);
590: fnd_message.retrieve (Errbuf);
591: retcode := 2;
592: igs_ge_msg_stack.conc_exception_hndl;
593:
594: END igs_uc_qual_dets_imp;