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

Line 276: Fnd_Message.SET_NAME ('IGS','IGS_CA_CAL_TYPE');

272:
273: p_message_name := 'IGS_EN_NO_STEP_PASSED';
274: RETURN FALSE;
275: END IF;
276: Fnd_Message.SET_NAME ('IGS','IGS_CA_CAL_TYPE');
277: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_trm_teach_cal_type_comb);
278:
279: IF p_program_cd_comb IS NOT NULL THEN
280: Fnd_Message.SET_NAME ('IGS','IGS_AD_CRS_CD');

Line 277: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_trm_teach_cal_type_comb);

273: p_message_name := 'IGS_EN_NO_STEP_PASSED';
274: RETURN FALSE;
275: END IF;
276: Fnd_Message.SET_NAME ('IGS','IGS_CA_CAL_TYPE');
277: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_trm_teach_cal_type_comb);
278:
279: IF p_program_cd_comb IS NOT NULL THEN
280: Fnd_Message.SET_NAME ('IGS','IGS_AD_CRS_CD');
281: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||p_program_cd_comb);

Line 280: Fnd_Message.SET_NAME ('IGS','IGS_AD_CRS_CD');

276: Fnd_Message.SET_NAME ('IGS','IGS_CA_CAL_TYPE');
277: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_trm_teach_cal_type_comb);
278:
279: IF p_program_cd_comb IS NOT NULL THEN
280: Fnd_Message.SET_NAME ('IGS','IGS_AD_CRS_CD');
281: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||p_program_cd_comb);
282: END IF;
283: IF p_location_cd IS NOT NULL THEN
284: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_LOC');

Line 281: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||p_program_cd_comb);

277: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_trm_teach_cal_type_comb);
278:
279: IF p_program_cd_comb IS NOT NULL THEN
280: Fnd_Message.SET_NAME ('IGS','IGS_AD_CRS_CD');
281: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||p_program_cd_comb);
282: END IF;
283: IF p_location_cd IS NOT NULL THEN
284: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_LOC');
285: Fnd_Message.Set_Token('LOC',p_location_cd);

Line 284: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_LOC');

280: Fnd_Message.SET_NAME ('IGS','IGS_AD_CRS_CD');
281: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||p_program_cd_comb);
282: END IF;
283: IF p_location_cd IS NOT NULL THEN
284: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_LOC');
285: Fnd_Message.Set_Token('LOC',p_location_cd);
286: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
287: END IF;
288: IF p_attendance_mode IS NOT NULL THEN

Line 285: Fnd_Message.Set_Token('LOC',p_location_cd);

281: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||p_program_cd_comb);
282: END IF;
283: IF p_location_cd IS NOT NULL THEN
284: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_LOC');
285: Fnd_Message.Set_Token('LOC',p_location_cd);
286: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
287: END IF;
288: IF p_attendance_mode IS NOT NULL THEN
289: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_MODE');

Line 286: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);

282: END IF;
283: IF p_location_cd IS NOT NULL THEN
284: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_LOC');
285: Fnd_Message.Set_Token('LOC',p_location_cd);
286: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
287: END IF;
288: IF p_attendance_mode IS NOT NULL THEN
289: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_MODE');
290: Fnd_Message.Set_Token('ATTMODE',p_attendance_mode);

Line 289: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_MODE');

285: Fnd_Message.Set_Token('LOC',p_location_cd);
286: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
287: END IF;
288: IF p_attendance_mode IS NOT NULL THEN
289: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_MODE');
290: Fnd_Message.Set_Token('ATTMODE',p_attendance_mode);
291: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
292: END IF;
293: IF p_attendance_type IS NOT NULL THEN

Line 290: Fnd_Message.Set_Token('ATTMODE',p_attendance_mode);

286: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
287: END IF;
288: IF p_attendance_mode IS NOT NULL THEN
289: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_MODE');
290: Fnd_Message.Set_Token('ATTMODE',p_attendance_mode);
291: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
292: END IF;
293: IF p_attendance_type IS NOT NULL THEN
294: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_TYPE');

Line 291: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);

287: END IF;
288: IF p_attendance_mode IS NOT NULL THEN
289: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_MODE');
290: Fnd_Message.Set_Token('ATTMODE',p_attendance_mode);
291: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
292: END IF;
293: IF p_attendance_type IS NOT NULL THEN
294: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_TYPE');
295: Fnd_Message.Set_Token('ATTTYPE',p_attendance_type);

Line 294: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_TYPE');

290: Fnd_Message.Set_Token('ATTMODE',p_attendance_mode);
291: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
292: END IF;
293: IF p_attendance_type IS NOT NULL THEN
294: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_TYPE');
295: Fnd_Message.Set_Token('ATTTYPE',p_attendance_type);
296: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
297: END IF;
298: IF p_unit_cd_comb IS NOT NULL THEN

Line 295: Fnd_Message.Set_Token('ATTTYPE',p_attendance_type);

291: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
292: END IF;
293: IF p_attendance_type IS NOT NULL THEN
294: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_TYPE');
295: Fnd_Message.Set_Token('ATTTYPE',p_attendance_type);
296: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
297: END IF;
298: IF p_unit_cd_comb IS NOT NULL THEN
299: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT');

Line 296: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);

292: END IF;
293: IF p_attendance_type IS NOT NULL THEN
294: Fnd_Message.SET_NAME ('IGS','IGS_AD_LG_INAP_ATT_TYPE');
295: Fnd_Message.Set_Token('ATTTYPE',p_attendance_type);
296: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
297: END IF;
298: IF p_unit_cd_comb IS NOT NULL THEN
299: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT');
300: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_cd_comb);

Line 299: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT');

295: Fnd_Message.Set_Token('ATTTYPE',p_attendance_type);
296: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
297: END IF;
298: IF p_unit_cd_comb IS NOT NULL THEN
299: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT');
300: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_cd_comb);
301: END IF;
302: IF p_unit_set_comb IS NOT NULL THEN
303: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT_SET');

Line 300: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_cd_comb);

296: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET);
297: END IF;
298: IF p_unit_cd_comb IS NOT NULL THEN
299: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT');
300: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_cd_comb);
301: END IF;
302: IF p_unit_set_comb IS NOT NULL THEN
303: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT_SET');
304: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_set_comb);

Line 303: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT_SET');

299: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT');
300: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_cd_comb);
301: END IF;
302: IF p_unit_set_comb IS NOT NULL THEN
303: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT_SET');
304: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_set_comb);
305: END IF;
306: IF p_class_standing IS NOT NULL THEN
307: Fnd_Message.SET_NAME ('IGS','IGS_EN_CLASS_STAND');

Line 304: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_set_comb);

300: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_cd_comb);
301: END IF;
302: IF p_unit_set_comb IS NOT NULL THEN
303: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT_SET');
304: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_set_comb);
305: END IF;
306: IF p_class_standing IS NOT NULL THEN
307: Fnd_Message.SET_NAME ('IGS','IGS_EN_CLASS_STAND');
308: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_class_standing);

Line 307: Fnd_Message.SET_NAME ('IGS','IGS_EN_CLASS_STAND');

303: Fnd_Message.SET_NAME ('IGS','IGS_AD_UNIT_SET');
304: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_set_comb);
305: END IF;
306: IF p_class_standing IS NOT NULL THEN
307: Fnd_Message.SET_NAME ('IGS','IGS_EN_CLASS_STAND');
308: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_class_standing);
309:
310: END IF;
311: IF p_org_unit_cd IS NOT NULL THEN

Line 308: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_class_standing);

304: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_unit_set_comb);
305: END IF;
306: IF p_class_standing IS NOT NULL THEN
307: Fnd_Message.SET_NAME ('IGS','IGS_EN_CLASS_STAND');
308: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_class_standing);
309:
310: END IF;
311: IF p_org_unit_cd IS NOT NULL THEN
312: Fnd_Message.SET_NAME ('IGS','IGS_PR_ORG_UNIT');

Line 312: Fnd_Message.SET_NAME ('IGS','IGS_PR_ORG_UNIT');

308: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': ' ||p_class_standing);
309:
310: END IF;
311: IF p_org_unit_cd IS NOT NULL THEN
312: Fnd_Message.SET_NAME ('IGS','IGS_PR_ORG_UNIT');
313: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': '||p_org_unit_cd);
314: END IF;
315: IF p_person_id_group IS NOT NULL THEN
316: OPEN cur_person_id_grp(p_person_id_group);

Line 313: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': '||p_org_unit_cd);

309:
310: END IF;
311: IF p_org_unit_cd IS NOT NULL THEN
312: Fnd_Message.SET_NAME ('IGS','IGS_PR_ORG_UNIT');
313: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': '||p_org_unit_cd);
314: END IF;
315: IF p_person_id_group IS NOT NULL THEN
316: OPEN cur_person_id_grp(p_person_id_group);
317: FETCH cur_person_id_grp INTO l_person_id_grp;

Line 319: Fnd_Message.SET_NAME ('IGS','IGS_AD_ADM_ENQ_ID_GRP');

315: IF p_person_id_group IS NOT NULL THEN
316: OPEN cur_person_id_grp(p_person_id_group);
317: FETCH cur_person_id_grp INTO l_person_id_grp;
318: CLOSE cur_person_id_grp;
319: Fnd_Message.SET_NAME ('IGS','IGS_AD_ADM_ENQ_ID_GRP');
320: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||l_person_id_grp);
321:
322: END IF;
323: IF p_person_id IS NOT NULL THEN

Line 320: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||l_person_id_grp);

316: OPEN cur_person_id_grp(p_person_id_group);
317: FETCH cur_person_id_grp INTO l_person_id_grp;
318: CLOSE cur_person_id_grp;
319: Fnd_Message.SET_NAME ('IGS','IGS_AD_ADM_ENQ_ID_GRP');
320: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||l_person_id_grp);
321:
322: END IF;
323: IF p_person_id IS NOT NULL THEN
324: OPEN cur_person_id(p_person_id);

Line 327: Fnd_Message.SET_NAME ('IGS','IGS_AD_PERSON_ID');

323: IF p_person_id IS NOT NULL THEN
324: OPEN cur_person_id(p_person_id);
325: FETCH cur_person_id INTO l_person_id;
326: CLOSE cur_person_id;
327: Fnd_Message.SET_NAME ('IGS','IGS_AD_PERSON_ID');
328: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': '||l_person_id);
329:
330: END IF;
331: IF p_program_attempt_status IS NOT NULL THEN

Line 328: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': '||l_person_id);

324: OPEN cur_person_id(p_person_id);
325: FETCH cur_person_id INTO l_person_id;
326: CLOSE cur_person_id;
327: Fnd_Message.SET_NAME ('IGS','IGS_AD_PERSON_ID');
328: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET|| ': '||l_person_id);
329:
330: END IF;
331: IF p_program_attempt_status IS NOT NULL THEN
332: -- program attempt status

Line 336: Fnd_Message.SET_NAME ('IGS','IGS_RE_ATTMPT_STATUS');

332: -- program attempt status
333: OPEN cur_step('CRS_ATTEMPT_STATUS',p_program_attempt_status);
334: FETCH cur_step INTO l_step;
335: CLOSE cur_step;
336: Fnd_Message.SET_NAME ('IGS','IGS_RE_ATTMPT_STATUS');
337: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||l_step);
338:
339: END IF;
340: IF p_person_step_1 IS NOT NULL THEN

Line 337: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||l_step);

333: OPEN cur_step('CRS_ATTEMPT_STATUS',p_program_attempt_status);
334: FETCH cur_step INTO l_step;
335: CLOSE cur_step;
336: Fnd_Message.SET_NAME ('IGS','IGS_RE_ATTMPT_STATUS');
337: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||': '||l_step);
338:
339: END IF;
340: IF p_person_step_1 IS NOT NULL THEN
341: -- person step

Line 345: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');

341: -- person step
342: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_person_step_1);
343: FETCH cur_step INTO l_step;
344: CLOSE cur_step;
345: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');
346: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
347:
348: END IF;
349: IF p_program_step_1 IS NOT NULL THEN

Line 346: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);

342: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_person_step_1);
343: FETCH cur_step INTO l_step;
344: CLOSE cur_step;
345: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');
346: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
347:
348: END IF;
349: IF p_program_step_1 IS NOT NULL THEN
350: -- program step

Line 354: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');

350: -- program step
351: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_1);
352: FETCH cur_step INTO l_step;
353: CLOSE cur_step;
354: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');
355: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
356:
357: END IF;
358:

Line 355: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);

351: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_1);
352: FETCH cur_step INTO l_step;
353: CLOSE cur_step;
354: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');
355: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
356:
357: END IF;
358:
359: IF p_over_credit_point_1 IS NOT NULL THEN

Line 360: Fnd_Message.SET_NAME('IGS', 'IGS_EN_DESIRED_LIM');

356:
357: END IF;
358:
359: IF p_over_credit_point_1 IS NOT NULL THEN
360: Fnd_Message.SET_NAME('IGS', 'IGS_EN_DESIRED_LIM');
361: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_over_credit_point_1);
362:
363: END IF;
364:

Line 361: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_over_credit_point_1);

357: END IF;
358:
359: IF p_over_credit_point_1 IS NOT NULL THEN
360: Fnd_Message.SET_NAME('IGS', 'IGS_EN_DESIRED_LIM');
361: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_over_credit_point_1);
362:
363: END IF;
364:
365: IF p_unit_step_1 IS NOT NULL THEN

Line 370: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');

366: -- unit step
367: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_1);
368: FETCH cur_step INTO l_step;
369: CLOSE cur_step;
370: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');
371: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
372:
373: END IF;
374:

Line 371: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);

367: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_1);
368: FETCH cur_step INTO l_step;
369: CLOSE cur_step;
370: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');
371: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
372:
373: END IF;
374:
375: IF p_unit_cd_1 IS NOT NULL THEN

Line 376: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

372:
373: END IF;
374:
375: IF p_unit_cd_1 IS NOT NULL THEN
376: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
377: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_cd_1);
378:
379: END IF;
380:

Line 377: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_cd_1);

373: END IF;
374:
375: IF p_unit_cd_1 IS NOT NULL THEN
376: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
377: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_cd_1);
378:
379: END IF;
380:
381: IF p_unit_section_1 IS NOT NULL THEN

Line 382: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');

378:
379: END IF;
380:
381: IF p_unit_section_1 IS NOT NULL THEN
382: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
383: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_section_1);
384:
385: END IF;
386:

Line 383: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_section_1);

379: END IF;
380:
381: IF p_unit_section_1 IS NOT NULL THEN
382: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
383: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_section_1);
384:
385: END IF;
386:
387: IF p_person_step_2 IS NOT NULL THEN

Line 391: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');

387: IF p_person_step_2 IS NOT NULL THEN
388: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_person_step_2);
389: FETCH cur_step INTO l_step;
390: CLOSE cur_step;
391: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');
392: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
393:
394: END IF;
395: IF p_program_step_2 IS NOT NULL THEN

Line 392: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);

388: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_person_step_2);
389: FETCH cur_step INTO l_step;
390: CLOSE cur_step;
391: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');
392: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
393:
394: END IF;
395: IF p_program_step_2 IS NOT NULL THEN
396: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_2);

Line 399: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');

395: IF p_program_step_2 IS NOT NULL THEN
396: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_2);
397: FETCH cur_step INTO l_step;
398: CLOSE cur_step;
399: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');
400: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
401: END IF;
402: IF p_over_credit_point_2 IS NOT NULL THEN
403: Fnd_Message.SET_NAME('IGS', 'IGS_EN_DESIRED_LIM');

Line 400: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);

396: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_2);
397: FETCH cur_step INTO l_step;
398: CLOSE cur_step;
399: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');
400: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
401: END IF;
402: IF p_over_credit_point_2 IS NOT NULL THEN
403: Fnd_Message.SET_NAME('IGS', 'IGS_EN_DESIRED_LIM');
404: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_over_credit_point_2 );

Line 403: Fnd_Message.SET_NAME('IGS', 'IGS_EN_DESIRED_LIM');

399: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');
400: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
401: END IF;
402: IF p_over_credit_point_2 IS NOT NULL THEN
403: Fnd_Message.SET_NAME('IGS', 'IGS_EN_DESIRED_LIM');
404: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_over_credit_point_2 );
405: END IF;
406:
407: IF p_unit_step_2 IS NOT NULL THEN

Line 404: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_over_credit_point_2 );

400: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
401: END IF;
402: IF p_over_credit_point_2 IS NOT NULL THEN
403: Fnd_Message.SET_NAME('IGS', 'IGS_EN_DESIRED_LIM');
404: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_over_credit_point_2 );
405: END IF;
406:
407: IF p_unit_step_2 IS NOT NULL THEN
408: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_2);

Line 411: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');

407: IF p_unit_step_2 IS NOT NULL THEN
408: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_2);
409: FETCH cur_step INTO l_step;
410: CLOSE cur_step;
411: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');
412: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
413:
414: END IF;
415:

Line 412: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);

408: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_2);
409: FETCH cur_step INTO l_step;
410: CLOSE cur_step;
411: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');
412: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
413:
414: END IF;
415:
416: IF p_unit_cd_2 IS NOT NULL THEN

Line 417: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

413:
414: END IF;
415:
416: IF p_unit_cd_2 IS NOT NULL THEN
417: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
418: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_cd_2);
419:
420: END IF;
421:

Line 418: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_cd_2);

414: END IF;
415:
416: IF p_unit_cd_2 IS NOT NULL THEN
417: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
418: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_cd_2);
419:
420: END IF;
421:
422: IF p_unit_section_2 IS NOT NULL THEN

Line 423: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');

419:
420: END IF;
421:
422: IF p_unit_section_2 IS NOT NULL THEN
423: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
424: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_section_2);
425:
426: END IF;
427:

Line 424: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_section_2);

420: END IF;
421:
422: IF p_unit_section_2 IS NOT NULL THEN
423: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
424: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_section_2);
425:
426: END IF;
427:
428:

Line 433: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');

429: IF p_person_step_3 IS NOT NULL THEN
430: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_person_step_3);
431: FETCH cur_step INTO l_step;
432: CLOSE cur_step;
433: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');
434: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
435:
436: END IF;
437: IF p_program_step_3 IS NOT NULL THEN

Line 434: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);

430: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_person_step_3);
431: FETCH cur_step INTO l_step;
432: CLOSE cur_step;
433: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');
434: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
435:
436: END IF;
437: IF p_program_step_3 IS NOT NULL THEN
438: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_3);

Line 441: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');

437: IF p_program_step_3 IS NOT NULL THEN
438: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_3);
439: FETCH cur_step INTO l_step;
440: CLOSE cur_step;
441: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');
442: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
443: END IF;
444: IF p_unit_step_3 IS NOT NULL THEN
445: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_3);

Line 442: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);

438: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_3);
439: FETCH cur_step INTO l_step;
440: CLOSE cur_step;
441: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');
442: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
443: END IF;
444: IF p_unit_step_3 IS NOT NULL THEN
445: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_3);
446: FETCH cur_step INTO l_step;

Line 448: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');

444: IF p_unit_step_3 IS NOT NULL THEN
445: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_3);
446: FETCH cur_step INTO l_step;
447: CLOSE cur_step;
448: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');
449: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
450:
451: END IF;
452: IF p_unit_cd_3 IS NOT NULL THEN

Line 449: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);

445: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_3);
446: FETCH cur_step INTO l_step;
447: CLOSE cur_step;
448: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');
449: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
450:
451: END IF;
452: IF p_unit_cd_3 IS NOT NULL THEN
453:

Line 454: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

450:
451: END IF;
452: IF p_unit_cd_3 IS NOT NULL THEN
453:
454: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
455: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_cd_3);
456:
457: END IF;
458:

Line 455: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_cd_3);

451: END IF;
452: IF p_unit_cd_3 IS NOT NULL THEN
453:
454: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
455: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_cd_3);
456:
457: END IF;
458:
459: IF p_unit_section_3 IS NOT NULL THEN

Line 461: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');

457: END IF;
458:
459: IF p_unit_section_3 IS NOT NULL THEN
460:
461: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
462: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_section_3);
463:
464: END IF;
465:

Line 462: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_section_3);

458:
459: IF p_unit_section_3 IS NOT NULL THEN
460:
461: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
462: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_section_3);
463:
464: END IF;
465:
466: IF p_person_step_4 IS NOT NULL THEN

Line 470: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');

466: IF p_person_step_4 IS NOT NULL THEN
467: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_person_step_4);
468: FETCH cur_step INTO l_step;
469: CLOSE cur_step;
470: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');
471: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
472:
473: END IF;
474: IF p_program_step_4 IS NOT NULL THEN

Line 471: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);

467: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_person_step_4);
468: FETCH cur_step INTO l_step;
469: CLOSE cur_step;
470: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_STEP');
471: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
472:
473: END IF;
474: IF p_program_step_4 IS NOT NULL THEN
475: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_4);

Line 478: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');

474: IF p_program_step_4 IS NOT NULL THEN
475: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_4);
476: FETCH cur_step INTO l_step;
477: CLOSE cur_step;
478: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');
479: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
480:
481: END IF;
482: IF p_unit_step_4 IS NOT NULL THEN

Line 479: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);

475: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_program_step_4);
476: FETCH cur_step INTO l_step;
477: CLOSE cur_step;
478: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PGM_STEP');
479: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
480:
481: END IF;
482: IF p_unit_step_4 IS NOT NULL THEN
483: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_4);

Line 486: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');

482: IF p_unit_step_4 IS NOT NULL THEN
483: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_4);
484: FETCH cur_step INTO l_step;
485: CLOSE cur_step;
486: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');
487: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
488: --
489: END IF;
490:

Line 487: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);

483: OPEN cur_step('ENROLMENT_STEP_TYPE_EXT',p_unit_step_4);
484: FETCH cur_step INTO l_step;
485: CLOSE cur_step;
486: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_STEP');
487: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
488: --
489: END IF;
490:
491: IF p_unit_cd_4 IS NOT NULL THEN

Line 492: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

488: --
489: END IF;
490:
491: IF p_unit_cd_4 IS NOT NULL THEN
492: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
493: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_cd_4);
494:
495: END IF;
496:

Line 493: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_cd_4);

489: END IF;
490:
491: IF p_unit_cd_4 IS NOT NULL THEN
492: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
493: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_cd_4);
494:
495: END IF;
496:
497: IF p_unit_section_4 IS NOT NULL THEN

Line 499: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');

495: END IF;
496:
497: IF p_unit_section_4 IS NOT NULL THEN
498:
499: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
500: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_section_4);
501:
502: END IF;
503:

Line 500: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_section_4);

496:
497: IF p_unit_section_4 IS NOT NULL THEN
498:
499: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
500: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_section_4);
501:
502: END IF;
503:
504: IF p_person_ovr_step_1 IS NOT NULL THEN

Line 509: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');

505: --Person Override Step
506: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_1);
507: FETCH cur_step INTO l_step;
508: CLOSE cur_step;
509: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');
510: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
511:
512: END IF;
513:

Line 510: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);

506: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_1);
507: FETCH cur_step INTO l_step;
508: CLOSE cur_step;
509: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');
510: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
511:
512: END IF;
513:
514: IF p_unit_ovr_step_1 IS NOT NULL THEN

Line 519: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');

515: --unit Override Step
516: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_1);
517: FETCH cur_step INTO l_step;
518: CLOSE cur_step;
519: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');
520: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
521:
522: END IF;
523: IF p_over_credit_point_3 IS NOT NULL THEN

Line 520: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);

516: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_1);
517: FETCH cur_step INTO l_step;
518: CLOSE cur_step;
519: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');
520: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||l_step);
521:
522: END IF;
523: IF p_over_credit_point_3 IS NOT NULL THEN
524:

Line 525: Fnd_Message.SET_NAME('IGS', 'IGS_EN_CRDT_LIM');

521:
522: END IF;
523: IF p_over_credit_point_3 IS NOT NULL THEN
524:
525: Fnd_Message.SET_NAME('IGS', 'IGS_EN_CRDT_LIM');
526: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '|| p_over_credit_point_3);
527:
528: END IF;
529:

Line 526: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '|| p_over_credit_point_3);

522: END IF;
523: IF p_over_credit_point_3 IS NOT NULL THEN
524:
525: Fnd_Message.SET_NAME('IGS', 'IGS_EN_CRDT_LIM');
526: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '|| p_over_credit_point_3);
527:
528: END IF;
529:
530: IF p_unit_cd_ovr_1 IS NOT NULL THEN

Line 532: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

528: END IF;
529:
530: IF p_unit_cd_ovr_1 IS NOT NULL THEN
531:
532: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
533: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_cd_ovr_1);
534:
535: END IF;
536:

Line 533: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_cd_ovr_1);

529:
530: IF p_unit_cd_ovr_1 IS NOT NULL THEN
531:
532: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
533: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_cd_ovr_1);
534:
535: END IF;
536:
537: IF p_unit_section_ovr_1 IS NOT NULL THEN

Line 539: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');

535: END IF;
536:
537: IF p_unit_section_ovr_1 IS NOT NULL THEN
538:
539: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
540: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_section_ovr_1);
541:
542: END IF;
543: IF p_person_ovr_step_2 IS NOT NULL THEN

Line 540: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_section_ovr_1);

536:
537: IF p_unit_section_ovr_1 IS NOT NULL THEN
538:
539: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
540: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 1: '||p_unit_section_ovr_1);
541:
542: END IF;
543: IF p_person_ovr_step_2 IS NOT NULL THEN
544: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_2);

Line 547: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');

543: IF p_person_ovr_step_2 IS NOT NULL THEN
544: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_2);
545: FETCH cur_step INTO l_step;
546: CLOSE cur_step;
547: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');
548: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
549:
550: END IF;
551:

Line 548: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);

544: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_2);
545: FETCH cur_step INTO l_step;
546: CLOSE cur_step;
547: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');
548: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
549:
550: END IF;
551:
552: IF p_unit_ovr_step_2 IS NOT NULL THEN

Line 556: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');

552: IF p_unit_ovr_step_2 IS NOT NULL THEN
553: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_2);
554: FETCH cur_step INTO l_step;
555: CLOSE cur_step;
556: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');
557: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
558:
559: END IF;
560:

Line 557: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);

553: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_2);
554: FETCH cur_step INTO l_step;
555: CLOSE cur_step;
556: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');
557: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||l_step);
558:
559: END IF;
560:
561:

Line 563: Fnd_Message.SET_NAME('IGS', 'IGS_EN_CRDT_LIM');

559: END IF;
560:
561:
562: IF p_over_credit_point_4 IS NOT NULL THEN
563: Fnd_Message.SET_NAME('IGS', 'IGS_EN_CRDT_LIM');
564: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_over_credit_point_4);
565:
566: END IF;
567: IF p_unit_cd_ovr_2 IS NOT NULL THEN

Line 564: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_over_credit_point_4);

560:
561:
562: IF p_over_credit_point_4 IS NOT NULL THEN
563: Fnd_Message.SET_NAME('IGS', 'IGS_EN_CRDT_LIM');
564: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_over_credit_point_4);
565:
566: END IF;
567: IF p_unit_cd_ovr_2 IS NOT NULL THEN
568:

Line 569: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

565:
566: END IF;
567: IF p_unit_cd_ovr_2 IS NOT NULL THEN
568:
569: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
570: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_cd_ovr_2 );
571:
572: END IF;
573:

Line 570: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_cd_ovr_2 );

566: END IF;
567: IF p_unit_cd_ovr_2 IS NOT NULL THEN
568:
569: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
570: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_cd_ovr_2 );
571:
572: END IF;
573:
574: IF p_unit_section_ovr_2 IS NOT NULL THEN

Line 576: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');

572: END IF;
573:
574: IF p_unit_section_ovr_2 IS NOT NULL THEN
575:
576: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
577: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_section_ovr_2 );
578: END IF;
579:
580: IF p_person_ovr_step_3 IS NOT NULL THEN

Line 577: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_section_ovr_2 );

573:
574: IF p_unit_section_ovr_2 IS NOT NULL THEN
575:
576: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
577: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 2: '||p_unit_section_ovr_2 );
578: END IF;
579:
580: IF p_person_ovr_step_3 IS NOT NULL THEN
581: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_3);

Line 584: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');

580: IF p_person_ovr_step_3 IS NOT NULL THEN
581: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_3);
582: FETCH cur_step INTO l_step;
583: CLOSE cur_step;
584: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');
585: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
586: END IF;
587:
588: IF p_unit_ovr_step_3 IS NOT NULL THEN

Line 585: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);

581: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_3);
582: FETCH cur_step INTO l_step;
583: CLOSE cur_step;
584: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');
585: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
586: END IF;
587:
588: IF p_unit_ovr_step_3 IS NOT NULL THEN
589: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_3);

Line 592: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');

588: IF p_unit_ovr_step_3 IS NOT NULL THEN
589: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_3);
590: FETCH cur_step INTO l_step;
591: CLOSE cur_step;
592: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');
593: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
594: END IF;
595:
596: IF p_unit_cd_ovr_3 IS NOT NULL THEN

Line 593: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);

589: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_3);
590: FETCH cur_step INTO l_step;
591: CLOSE cur_step;
592: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');
593: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
594: END IF;
595:
596: IF p_unit_cd_ovr_3 IS NOT NULL THEN
597: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

Line 597: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

593: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||l_step);
594: END IF;
595:
596: IF p_unit_cd_ovr_3 IS NOT NULL THEN
597: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
598: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_cd_ovr_3);
599:
600: END IF;
601:

Line 598: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_cd_ovr_3);

594: END IF;
595:
596: IF p_unit_cd_ovr_3 IS NOT NULL THEN
597: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
598: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_cd_ovr_3);
599:
600: END IF;
601:
602: IF p_unit_section_ovr_3 IS NOT NULL THEN

Line 603: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');

599:
600: END IF;
601:
602: IF p_unit_section_ovr_3 IS NOT NULL THEN
603: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
604: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_section_ovr_3);
605: END IF;
606: IF p_person_ovr_step_4 IS NOT NULL THEN
607: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_4);

Line 604: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_section_ovr_3);

600: END IF;
601:
602: IF p_unit_section_ovr_3 IS NOT NULL THEN
603: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
604: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 3: '||p_unit_section_ovr_3);
605: END IF;
606: IF p_person_ovr_step_4 IS NOT NULL THEN
607: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_4);
608: FETCH cur_step INTO l_step;

Line 610: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');

606: IF p_person_ovr_step_4 IS NOT NULL THEN
607: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_4);
608: FETCH cur_step INTO l_step;
609: CLOSE cur_step;
610: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');
611: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
612: END IF;
613:
614: IF p_unit_ovr_step_4 IS NOT NULL THEN

Line 611: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);

607: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_person_ovr_step_4);
608: FETCH cur_step INTO l_step;
609: CLOSE cur_step;
610: Fnd_Message.SET_NAME('IGS', 'IGS_EN_PER_OVR_STEP');
611: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
612: END IF;
613:
614: IF p_unit_ovr_step_4 IS NOT NULL THEN
615: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_4);

Line 618: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');

614: IF p_unit_ovr_step_4 IS NOT NULL THEN
615: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_4);
616: FETCH cur_step INTO l_step;
617: CLOSE cur_step;
618: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');
619: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
620: END IF;
621: IF p_unit_cd_ovr_4 IS NOT NULL THEN
622: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

Line 619: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);

615: OPEN cur_step('ENROLMENT_OVR_STEP_TYPE',p_unit_ovr_step_4);
616: FETCH cur_step INTO l_step;
617: CLOSE cur_step;
618: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');
619: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
620: END IF;
621: IF p_unit_cd_ovr_4 IS NOT NULL THEN
622: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
623: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_cd_ovr_4);

Line 622: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');

618: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_OVR_STEP');
619: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
620: END IF;
621: IF p_unit_cd_ovr_4 IS NOT NULL THEN
622: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
623: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_cd_ovr_4);
624:
625: END IF;
626:

Line 623: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_cd_ovr_4);

619: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||l_step);
620: END IF;
621: IF p_unit_cd_ovr_4 IS NOT NULL THEN
622: Fnd_Message.SET_NAME('IGS', 'IGS_AD_UNIT');
623: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_cd_ovr_4);
624:
625: END IF;
626:
627: IF p_unit_section_ovr_4 IS NOT NULL THEN

Line 628: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');

624:
625: END IF;
626:
627: IF p_unit_section_ovr_4 IS NOT NULL THEN
628: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
629: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_section_ovr_4);
630: END IF;
631: Fnd_File.PUT_LINE(Fnd_File.LOG,'--------------------------------------------------------------------');
632: RETURN TRUE;

Line 629: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_section_ovr_4);

625: END IF;
626:
627: IF p_unit_section_ovr_4 IS NOT NULL THEN
628: Fnd_Message.SET_NAME('IGS', 'IGS_EN_UNIT_SEC');
629: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET||' 4: '||p_unit_section_ovr_4);
630: END IF;
631: Fnd_File.PUT_LINE(Fnd_File.LOG,'--------------------------------------------------------------------');
632: RETURN TRUE;
633:

Line 812: Fnd_Message.SET_NAME ('IGS','IGS_EN_CANNOT_CREATE_STEP');

808: OPEN cur_step_meaning(p_elgb_step);
809: FETCH cur_step_meaning INTO l_step_meaning;
810: CLOSE cur_step_meaning;
811: IF p_is_teach_cal THEN
812: Fnd_Message.SET_NAME ('IGS','IGS_EN_CANNOT_CREATE_STEP');
813: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
814: RETURN;
815: END IF;-- end of IF p_is_teach_cal THEN
816:

Line 813: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);

809: FETCH cur_step_meaning INTO l_step_meaning;
810: CLOSE cur_step_meaning;
811: IF p_is_teach_cal THEN
812: Fnd_Message.SET_NAME ('IGS','IGS_EN_CANNOT_CREATE_STEP');
813: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
814: RETURN;
815: END IF;-- end of IF p_is_teach_cal THEN
816:
817:

Line 833: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');

829: x_step_override_limit => NULL,
830: x_mode => 'R');
831:
832:
833: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
834: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
835: ELSE
836: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
837: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);

Line 834: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);

830: x_mode => 'R');
831:
832:
833: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
834: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
835: ELSE
836: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
837: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
838: END IF;

Line 836: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

832:
833: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
834: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
835: ELSE
836: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
837: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
838: END IF;
839:
840: EXCEPTION

Line 837: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);

833: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
834: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
835: ELSE
836: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
837: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
838: END IF;
839:
840: EXCEPTION
841: WHEN OTHERS THEN

Line 842: l_message := Fnd_Message.GET;

838: END IF;
839:
840: EXCEPTION
841: WHEN OTHERS THEN
842: l_message := Fnd_Message.GET;
843: IF l_message IS NOT NULL THEN
844: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' ||l_message );
845: ELSE
846: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' ||SQLERRM );

Line 934: Fnd_Message.SET_NAME ('IGS','IGS_EN_CANNOT_CREATE_STEP');

930: CLOSE cur_step_meaning;
931:
932: IF p_is_teach_cal THEN
933:
934: Fnd_Message.SET_NAME ('IGS','IGS_EN_CANNOT_CREATE_STEP');
935: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
936: RETURN;
937: END IF;-- end of IF p_is_teach_cal THEN
938:

Line 935: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);

931:
932: IF p_is_teach_cal THEN
933:
934: Fnd_Message.SET_NAME ('IGS','IGS_EN_CANNOT_CREATE_STEP');
935: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
936: RETURN;
937: END IF;-- end of IF p_is_teach_cal THEN
938:
939:

Line 989: Fnd_Message.SET_NAME ('IGS','IGS_EN_AUTH_REC_NO_DATES');

985: IF l_auth_end_dt IS NULL OR l_auth_start_dt IS NULL THEN
986: --Log a warn message.
987: --modfied message name as a part of bug 5299024
988: ROLLBACK to creating_auth_rec;
989: Fnd_Message.SET_NAME ('IGS','IGS_EN_AUTH_REC_NO_DATES');
990: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || Fnd_Message.GET );
991: RETURN;
992: ELSE
993:

Line 990: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || Fnd_Message.GET );

986: --Log a warn message.
987: --modfied message name as a part of bug 5299024
988: ROLLBACK to creating_auth_rec;
989: Fnd_Message.SET_NAME ('IGS','IGS_EN_AUTH_REC_NO_DATES');
990: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || Fnd_Message.GET );
991: RETURN;
992: ELSE
993:
994: SAVEPOINT creating_auth_rec;

Line 1012: FND_MESSAGE.SET_NAME('IGS','IGS_GE_DATES_OVERLAP');

1008:
1009:
1010: IF igs_en_sevis.is_auth_records_overlap(l_person_id) THEN
1011: ROLLBACK to creating_auth_rec;
1012: FND_MESSAGE.SET_NAME('IGS','IGS_GE_DATES_OVERLAP');
1013: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || Fnd_Message.GET );
1014: RETURN;
1015: END IF;
1016:

Line 1013: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || Fnd_Message.GET );

1009:
1010: IF igs_en_sevis.is_auth_records_overlap(l_person_id) THEN
1011: ROLLBACK to creating_auth_rec;
1012: FND_MESSAGE.SET_NAME('IGS','IGS_GE_DATES_OVERLAP');
1013: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || Fnd_Message.GET );
1014: RETURN;
1015: END IF;
1016:
1017: END IF;

Line 1022: Fnd_Message.SET_NAME ('IGS','IGS_EN_SEVIS_AUTH_REQUIRED');

1018: ELSE
1019:
1020: --Log a warn message.
1021: ROLLBACK to creating_auth_rec;
1022: Fnd_Message.SET_NAME ('IGS','IGS_EN_SEVIS_AUTH_REQUIRED');
1023: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||Fnd_Message.GET );
1024: RETURN;
1025: END IF;
1026: ELSE

Line 1023: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||Fnd_Message.GET );

1019:
1020: --Log a warn message.
1021: ROLLBACK to creating_auth_rec;
1022: Fnd_Message.SET_NAME ('IGS','IGS_EN_SEVIS_AUTH_REQUIRED');
1023: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||Fnd_Message.GET );
1024: RETURN;
1025: END IF;
1026: ELSE
1027: IF FND_PROFILE.VALUE('IGS_SV_ENABLED') = 'Y' THEN

Line 1031: Fnd_Message.SET_NAME ('IGS','IGS_EN_SV_AUTH_ALREADY_EXISTS');

1027: IF FND_PROFILE.VALUE('IGS_SV_ENABLED') = 'Y' THEN
1028: OPEN c_sevis_person_type;
1029: FETCH c_sevis_person_type INTO l_sevis_person_type;
1030: IF c_sevis_person_type%FOUND THEN
1031: Fnd_Message.SET_NAME ('IGS','IGS_EN_SV_AUTH_ALREADY_EXISTS');
1032: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || Fnd_Message.GET );
1033: END IF;
1034: CLOSE c_sevis_person_type;
1035: END IF;

Line 1032: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || Fnd_Message.GET );

1028: OPEN c_sevis_person_type;
1029: FETCH c_sevis_person_type INTO l_sevis_person_type;
1030: IF c_sevis_person_type%FOUND THEN
1031: Fnd_Message.SET_NAME ('IGS','IGS_EN_SV_AUTH_ALREADY_EXISTS');
1032: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || Fnd_Message.GET );
1033: END IF;
1034: CLOSE c_sevis_person_type;
1035: END IF;
1036: END IF;

Line 1040: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');

1036: END IF;
1037: END IF;
1038:
1039:
1040: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1041: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
1042: ELSE
1043: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1044: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);

Line 1041: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);

1037: END IF;
1038:
1039:
1040: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1041: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
1042: ELSE
1043: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1044: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1045: END IF;

Line 1043: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

1039:
1040: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1041: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
1042: ELSE
1043: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1044: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1045: END IF;
1046:
1047: EXCEPTION

Line 1044: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);

1040: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1041: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' ||l_step_meaning || ' - ' || Fnd_Message.GET);
1042: ELSE
1043: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1044: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1045: END IF;
1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN

Line 1050: l_message := Fnd_Message.GET;

1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: ROLLBACK to creating_auth_rec;
1050: l_message := Fnd_Message.GET;
1051: IF l_message IS NOT NULL THEN
1052: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' ||l_message );
1053: ELSE
1054: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' ||SQLERRM );

Line 1151: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');

1147: x_uoo_id => p_uoo_id,
1148: x_step_override_limit => l_step_override_limit,
1149: x_mode => 'R');
1150:
1151: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1152: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1153: ELSE
1154: OPEN cur_get_elgb_ovr_step_id;
1155: FETCH cur_get_elgb_ovr_step_id INTO lr_cur_get_elgb_ovr_step_id;

Line 1152: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);

1148: x_step_override_limit => l_step_override_limit,
1149: x_mode => 'R');
1150:
1151: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1152: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1153: ELSE
1154: OPEN cur_get_elgb_ovr_step_id;
1155: FETCH cur_get_elgb_ovr_step_id INTO lr_cur_get_elgb_ovr_step_id;
1156: CLOSE cur_get_elgb_ovr_step_id;

Line 1170: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');

1166: x_version_number => p_version_number,
1167: x_uoo_id => p_uoo_id,
1168: x_step_override_limit => l_step_override_limit,
1169: x_mode => 'R');
1170: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1171: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1172: ELSE
1173: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1174: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);

Line 1171: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);

1167: x_uoo_id => p_uoo_id,
1168: x_step_override_limit => l_step_override_limit,
1169: x_mode => 'R');
1170: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1171: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1172: ELSE
1173: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1174: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1175: END IF;

Line 1173: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

1169: x_mode => 'R');
1170: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1171: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1172: ELSE
1173: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1174: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1175: END IF;
1176: CLOSE cur_check_override_uooid;
1177: END IF;

Line 1174: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);

1170: Fnd_Message.SET_NAME ('IGS','IGS_EN_CR_SUCCESS');
1171: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1172: ELSE
1173: Fnd_Message.SET_NAME ('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
1174: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' || Fnd_Message.GET);
1175: END IF;
1176: CLOSE cur_check_override_uooid;
1177: END IF;
1178: EXCEPTION

Line 1181: l_message := Fnd_Message.GET;

1177: END IF;
1178: EXCEPTION
1179: WHEN OTHERS THEN
1180:
1181: l_message := Fnd_Message.GET;
1182: IF l_message IS NOT NULL THEN
1183: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' ||l_message );
1184: ELSE
1185: Fnd_File.PUT_LINE(Fnd_File.LOG,' ' || l_step_meaning || ' - ' ||SQLERRM );

Line 1203: Fnd_Message.SET_NAME ('IGS','IGS_PR_PERSON_ID');

1199: OPEN cur_pers_number(p_person_id);
1200: FETCH cur_pers_number INTO l_person_number;
1201: CLOSE cur_pers_number;
1202:
1203: Fnd_Message.SET_NAME ('IGS','IGS_PR_PERSON_ID');
1204: -- log the person number into log file for whom override records are going create
1205: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET || ': ' || l_person_number );
1206:
1207: --

Line 1205: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET || ': ' || l_person_number );

1201: CLOSE cur_pers_number;
1202:
1203: Fnd_Message.SET_NAME ('IGS','IGS_PR_PERSON_ID');
1204: -- log the person number into log file for whom override records are going create
1205: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET || ': ' || l_person_number );
1206:
1207: --
1208: -- for parameter set 1
1209: IF p_person_step_1 IS NOT NULL THEN

Line 1341: Fnd_Message.SET_NAME ('IGS',l_message_name);

1337: --
1338: -- call the procedure below to log all the parameters passed to this function
1339: IF NOT enrp_log_para(l_message_name) THEN
1340: -- no steps passed in parameter to override
1341: Fnd_Message.SET_NAME ('IGS',l_message_name);
1342: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1343:
1344: retcode :=2;
1345: RETURN;

Line 1342: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );

1338: -- call the procedure below to log all the parameters passed to this function
1339: IF NOT enrp_log_para(l_message_name) THEN
1340: -- no steps passed in parameter to override
1341: Fnd_Message.SET_NAME ('IGS',l_message_name);
1342: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1343:
1344: retcode :=2;
1345: RETURN;
1346: END IF;

Line 1354: Fnd_Message.SET_NAME ('IGS',l_message_name);

1350: -- all the parameters for the container procedure will be available to the inner function
1351: --
1352: IF NOT enrp_val_para(l_message_name) THEN
1353: -- validation failed log error message
1354: Fnd_Message.SET_NAME ('IGS',l_message_name);
1355: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1356:
1357: retcode :=2;
1358: RETURN;

Line 1355: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );

1351: --
1352: IF NOT enrp_val_para(l_message_name) THEN
1353: -- validation failed log error message
1354: Fnd_Message.SET_NAME ('IGS',l_message_name);
1355: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1356:
1357: retcode :=2;
1358: RETURN;
1359: END IF;

Line 1361: Fnd_Message.SET_NAME ('IGS',l_message_name);

1357: retcode :=2;
1358: RETURN;
1359: END IF;
1360: IF l_message_name IS NOT NULL THEN
1361: Fnd_Message.SET_NAME ('IGS',l_message_name);
1362: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1363:
1364: END IF;
1365: --

Line 1362: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );

1358: RETURN;
1359: END IF;
1360: IF l_message_name IS NOT NULL THEN
1361: Fnd_Message.SET_NAME ('IGS',l_message_name);
1362: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1363:
1364: END IF;
1365: --
1366: -- loop through all the students who satisfied the cursor criteria

Line 1396: Fnd_Message.SET_NAME('IGS','IGS_EN_PERSONS_OVERRIDE');

1392: -- log the message that for the following persons override records have been created
1393:
1394: IF NOT l_record_found THEN
1395: l_record_found := TRUE;
1396: Fnd_Message.SET_NAME('IGS','IGS_EN_PERSONS_OVERRIDE');
1397: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1398:
1399: END IF;
1400:

Line 1397: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );

1393:
1394: IF NOT l_record_found THEN
1395: l_record_found := TRUE;
1396: Fnd_Message.SET_NAME('IGS','IGS_EN_PERSONS_OVERRIDE');
1397: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1398:
1399: END IF;
1400:
1401: OPEN cur_elgb_over(cur_criteria_satisfied_rec.person_id,l_cal_type,l_ci_seq_number);

Line 1429: Fnd_Message.SET_NAME('IGS','IGS_EN_NO_STDNT_FOUND');

1425: -- it retains same value and the below If condition evaluates to True and logs Message 'No Student was
1426: -- selected for the given criteria' in log file.
1427:
1428: IF NOT l_record_found THEN
1429: Fnd_Message.SET_NAME('IGS','IGS_EN_NO_STDNT_FOUND');
1430: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1431: END IF;
1432:
1433: EXCEPTION

Line 1430: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );

1426: -- selected for the given criteria' in log file.
1427:
1428: IF NOT l_record_found THEN
1429: Fnd_Message.SET_NAME('IGS','IGS_EN_NO_STDNT_FOUND');
1430: Fnd_File.PUT_LINE(Fnd_File.LOG,Fnd_Message.GET );
1431: END IF;
1432:
1433: EXCEPTION
1434: WHEN OTHERS THEN

Line 1439: ERRBUF := Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

1435:
1436: retcode:=2;
1437: Fnd_File.PUT_LINE(Fnd_File.LOG,SQLERRM);
1438:
1439: ERRBUF := Fnd_Message.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1440: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1441:
1442: END enrp_elgbl_override;
1443: