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.IGF_SL_CL_CHG_FILE dependencies on FND_MESSAGE

Line 344: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');

340: log_to_fnd(p_v_module => 'create_file',
341: p_v_string => ' Validation of Required parameters'
342: );
343: IF p_v_award_year IS NULL THEN
344: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
345: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'));
346: fnd_file.put_line(fnd_file.log, fnd_message.get);
347: fnd_file.new_line(fnd_file.log, 1);
348: retcode := 2;

Line 345: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'));

341: p_v_string => ' Validation of Required parameters'
342: );
343: IF p_v_award_year IS NULL THEN
344: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
345: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'));
346: fnd_file.put_line(fnd_file.log, fnd_message.get);
347: fnd_file.new_line(fnd_file.log, 1);
348: retcode := 2;
349: RETURN;

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

342: );
343: IF p_v_award_year IS NULL THEN
344: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
345: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'));
346: fnd_file.put_line(fnd_file.log, fnd_message.get);
347: fnd_file.new_line(fnd_file.log, 1);
348: retcode := 2;
349: RETURN;
350: END IF;

Line 353: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');

349: RETURN;
350: END IF;
351:
352: IF l_v_media_type IS NULL THEN
353: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
354: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','MEDIA_TYPE'));
355: fnd_file.put_line(fnd_file.log, fnd_message.get);
356: fnd_file.new_line(fnd_file.log, 1);
357: retcode := 2;

Line 354: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','MEDIA_TYPE'));

350: END IF;
351:
352: IF l_v_media_type IS NULL THEN
353: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
354: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','MEDIA_TYPE'));
355: fnd_file.put_line(fnd_file.log, fnd_message.get);
356: fnd_file.new_line(fnd_file.log, 1);
357: retcode := 2;
358: RETURN;

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

351:
352: IF l_v_media_type IS NULL THEN
353: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
354: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','MEDIA_TYPE'));
355: fnd_file.put_line(fnd_file.log, fnd_message.get);
356: fnd_file.new_line(fnd_file.log, 1);
357: retcode := 2;
358: RETURN;
359: END IF;

Line 362: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');

358: RETURN;
359: END IF;
360:
361: IF l_v_school_id IS NULL THEN
362: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
363: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCHOOL_ID'));
364: fnd_file.put_line(fnd_file.log, fnd_message.get);
365: fnd_file.new_line(fnd_file.log, 1);
366: retcode := 2;

Line 363: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCHOOL_ID'));

359: END IF;
360:
361: IF l_v_school_id IS NULL THEN
362: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
363: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCHOOL_ID'));
364: fnd_file.put_line(fnd_file.log, fnd_message.get);
365: fnd_file.new_line(fnd_file.log, 1);
366: retcode := 2;
367: RETURN;

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

360:
361: IF l_v_school_id IS NULL THEN
362: fnd_message.set_name('IGF','IGF_SL_COD_REQ_PARAM');
363: fnd_message.set_token('PARAM',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCHOOL_ID'));
364: fnd_file.put_line(fnd_file.log, fnd_message.get);
365: fnd_file.new_line(fnd_file.log, 1);
366: retcode := 2;
367: RETURN;
368: END IF;

Line 381: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');

377: p_v_string => ' Start of Validation of input parameters'
378: );
379: -- Validate if the passed award year is valid or not
380: IF l_v_alt_code IS NULL THEN
381: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
382: fnd_file.put_line(fnd_file.log, fnd_message.get);
383: fnd_file.new_line(fnd_file.log, 1);
384: retcode := 2;
385: RETURN;

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

378: );
379: -- Validate if the passed award year is valid or not
380: IF l_v_alt_code IS NULL THEN
381: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
382: fnd_file.put_line(fnd_file.log, fnd_message.get);
383: fnd_file.new_line(fnd_file.log, 1);
384: retcode := 2;
385: RETURN;
386: END IF;

Line 397: fnd_message.set_name('IGF',l_v_message_name);

393: p_v_message_name => l_v_message_name
394: );
395: IF l_v_message_name IS NOT NULL THEN
396: IF l_v_message_name = 'IGF_SP_INVALID_AWD_YR_STATUS' THEN
397: fnd_message.set_name('IGF',l_v_message_name);
398: ELSE
399: fnd_message.set_name('IGS',l_v_message_name);
400: END IF;
401: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 399: fnd_message.set_name('IGS',l_v_message_name);

395: IF l_v_message_name IS NOT NULL THEN
396: IF l_v_message_name = 'IGF_SP_INVALID_AWD_YR_STATUS' THEN
397: fnd_message.set_name('IGF',l_v_message_name);
398: ELSE
399: fnd_message.set_name('IGS',l_v_message_name);
400: END IF;
401: fnd_file.put_line(fnd_file.log,fnd_message.get);
402: retcode := 2;
403: RETURN;

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

397: fnd_message.set_name('IGF',l_v_message_name);
398: ELSE
399: fnd_message.set_name('IGS',l_v_message_name);
400: END IF;
401: fnd_file.put_line(fnd_file.log,fnd_message.get);
402: retcode := 2;
403: RETURN;
404: END IF;
405:

Line 409: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');

405:
406: -- person id and person group id are mutually exclusive. Hence if both are
407: -- provided error out of the process
408: IF l_n_person_id_grp IS NOT NULL AND l_n_base_id IS NOT NULL THEN
409: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
412: fnd_file.put_line(fnd_file.log, fnd_message.get);
413: fnd_file.new_line(fnd_file.log, 1);

Line 410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));

406: -- person id and person group id are mutually exclusive. Hence if both are
407: -- provided error out of the process
408: IF l_n_person_id_grp IS NOT NULL AND l_n_base_id IS NOT NULL THEN
409: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
412: fnd_file.put_line(fnd_file.log, fnd_message.get);
413: fnd_file.new_line(fnd_file.log, 1);
414: retcode := 2;

Line 411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));

407: -- provided error out of the process
408: IF l_n_person_id_grp IS NOT NULL AND l_n_base_id IS NOT NULL THEN
409: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
412: fnd_file.put_line(fnd_file.log, fnd_message.get);
413: fnd_file.new_line(fnd_file.log, 1);
414: retcode := 2;
415: RETURN;

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

408: IF l_n_person_id_grp IS NOT NULL AND l_n_base_id IS NOT NULL THEN
409: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
412: fnd_file.put_line(fnd_file.log, fnd_message.get);
413: fnd_file.new_line(fnd_file.log, 1);
414: retcode := 2;
415: RETURN;
416: END IF;

Line 421: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');

417:
418: -- loan id and person group id are mutually exclusive. Hence if both are
419: -- provided error out of the process
420: IF l_n_person_id_grp IS NOT NULL AND l_n_loan_id IS NOT NULL THEN
421: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
422: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
423: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
424: fnd_file.put_line(fnd_file.log, fnd_message.get);
425: fnd_file.new_line(fnd_file.log, 1);

Line 422: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));

418: -- loan id and person group id are mutually exclusive. Hence if both are
419: -- provided error out of the process
420: IF l_n_person_id_grp IS NOT NULL AND l_n_loan_id IS NOT NULL THEN
421: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
422: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
423: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
424: fnd_file.put_line(fnd_file.log, fnd_message.get);
425: fnd_file.new_line(fnd_file.log, 1);
426: retcode := 2;

Line 423: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));

419: -- provided error out of the process
420: IF l_n_person_id_grp IS NOT NULL AND l_n_loan_id IS NOT NULL THEN
421: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
422: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
423: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
424: fnd_file.put_line(fnd_file.log, fnd_message.get);
425: fnd_file.new_line(fnd_file.log, 1);
426: retcode := 2;
427: RETURN;

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

420: IF l_n_person_id_grp IS NOT NULL AND l_n_loan_id IS NOT NULL THEN
421: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
422: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
423: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
424: fnd_file.put_line(fnd_file.log, fnd_message.get);
425: fnd_file.new_line(fnd_file.log, 1);
426: retcode := 2;
427: RETURN;
428: END IF;

Line 433: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

429:
430: -- validate if the person group if passed is a valid person group
431: IF l_n_person_id_grp IS NOT NULL THEN
432: IF l_v_group_cd IS NULL THEN
433: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
434: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
435: fnd_file.put_line(fnd_file.log, fnd_message.get);
436: retcode := 2;
437: RETURN;

Line 434: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));

430: -- validate if the person group if passed is a valid person group
431: IF l_n_person_id_grp IS NOT NULL THEN
432: IF l_v_group_cd IS NULL THEN
433: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
434: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
435: fnd_file.put_line(fnd_file.log, fnd_message.get);
436: retcode := 2;
437: RETURN;
438: END IF;

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

431: IF l_n_person_id_grp IS NOT NULL THEN
432: IF l_v_group_cd IS NULL THEN
433: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
434: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
435: fnd_file.put_line(fnd_file.log, fnd_message.get);
436: retcode := 2;
437: RETURN;
438: END IF;
439: END IF;

Line 450: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

446: );
447:
448: FETCH c_aw_lookups_view INTO l_v_meaning;
449: IF c_aw_lookups_view%NOTFOUND THEN
450: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
451: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','MEDIA_TYPE'));
452: fnd_file.put_line(fnd_file.log, fnd_message.get);
453: retcode := 2;
454: RETURN;

Line 451: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','MEDIA_TYPE'));

447:
448: FETCH c_aw_lookups_view INTO l_v_meaning;
449: IF c_aw_lookups_view%NOTFOUND THEN
450: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
451: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','MEDIA_TYPE'));
452: fnd_file.put_line(fnd_file.log, fnd_message.get);
453: retcode := 2;
454: RETURN;
455: END IF;

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

448: FETCH c_aw_lookups_view INTO l_v_meaning;
449: IF c_aw_lookups_view%NOTFOUND THEN
450: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
451: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','MEDIA_TYPE'));
452: fnd_file.put_line(fnd_file.log, fnd_message.get);
453: retcode := 2;
454: RETURN;
455: END IF;
456: CLOSE c_aw_lookups_view;

Line 463: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

459: OPEN c_school_codes (cp_v_school_id => l_v_school_id);
460: FETCH c_school_codes INTO rec_c_school_codes;
461: IF c_school_codes%NOTFOUND THEN
462: CLOSE c_school_codes;
463: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
464: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCHOOL_ID'));
465: fnd_file.put_line(fnd_file.log, fnd_message.get);
466: retcode := 2;
467: RETURN;

Line 464: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCHOOL_ID'));

460: FETCH c_school_codes INTO rec_c_school_codes;
461: IF c_school_codes%NOTFOUND THEN
462: CLOSE c_school_codes;
463: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
464: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCHOOL_ID'));
465: fnd_file.put_line(fnd_file.log, fnd_message.get);
466: retcode := 2;
467: RETURN;
468: END IF;

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

461: IF c_school_codes%NOTFOUND THEN
462: CLOSE c_school_codes;
463: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
464: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCHOOL_ID'));
465: fnd_file.put_line(fnd_file.log, fnd_message.get);
466: retcode := 2;
467: RETURN;
468: END IF;
469: CLOSE c_school_codes;

Line 480: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

476: );
477: FETCH c_sch_non_ed_branch INTO l_c_flag;
478: IF c_sch_non_ed_branch%NOTFOUND THEN
479: CLOSE c_sch_non_ed_branch;
480: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
481: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCH_NON_ED_BRANCH'));
482: fnd_file.put_line(fnd_file.log, fnd_message.get);
483: retcode := 2;
484: RETURN;

Line 481: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCH_NON_ED_BRANCH'));

477: FETCH c_sch_non_ed_branch INTO l_c_flag;
478: IF c_sch_non_ed_branch%NOTFOUND THEN
479: CLOSE c_sch_non_ed_branch;
480: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
481: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCH_NON_ED_BRANCH'));
482: fnd_file.put_line(fnd_file.log, fnd_message.get);
483: retcode := 2;
484: RETURN;
485: END IF;

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

478: IF c_sch_non_ed_branch%NOTFOUND THEN
479: CLOSE c_sch_non_ed_branch;
480: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
481: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCH_NON_ED_BRANCH'));
482: fnd_file.put_line(fnd_file.log, fnd_message.get);
483: retcode := 2;
484: RETURN;
485: END IF;
486: CLOSE c_sch_non_ed_branch;

Line 509: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');

505:
506: --If the sql returned is invalid.. then,
507: IF l_v_status <> 'S' THEN
508: --Log the error message and stop processing.
509: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
510: fnd_file.put_line(fnd_file.log,fnd_message.get);
511: fnd_file.put_line(fnd_file.log,l_v_sql);
512: log_to_fnd(p_v_module => ' Procedure create_file',
513: p_v_string => ' igs_pe_dynamic_persid_group.get_dynamic_sql call out returned an error status'

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

506: --If the sql returned is invalid.. then,
507: IF l_v_status <> 'S' THEN
508: --Log the error message and stop processing.
509: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
510: fnd_file.put_line(fnd_file.log,fnd_message.get);
511: fnd_file.put_line(fnd_file.log,l_v_sql);
512: log_to_fnd(p_v_module => ' Procedure create_file',
513: p_v_string => ' igs_pe_dynamic_persid_group.get_dynamic_sql call out returned an error status'
514: );

Line 564: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');

560: p_n_loan_id => l_n_loan_id
561: );
562: EXCEPTION
563: WHEN e_skip THEN
564: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_file.new_line(fnd_file.log, 1);
567: log_to_fnd(p_v_module => ' Procedure create_file',
568: p_v_string => ' No Base id found for person id '||l_n_person_id

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

561: );
562: EXCEPTION
563: WHEN e_skip THEN
564: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');
565: fnd_file.put_line(fnd_file.log, fnd_message.get);
566: fnd_file.new_line(fnd_file.log, 1);
567: log_to_fnd(p_v_module => ' Procedure create_file',
568: p_v_string => ' No Base id found for person id '||l_n_person_id
569: );

Line 646: fnd_message.set_name('IGF','IGF_SL_CL_ORIG_REQ_FAIL');

642: '', '', '', '', '', '', '', '', '', '');
643: l_n_ctr_recip := NVL(l_n_ctr_recip,0) + 1;
644: IF l_n_request_id = 0 THEN
645: -- On Failure of Concurrent Request
646: fnd_message.set_name('IGF','IGF_SL_CL_ORIG_REQ_FAIL');
647: igs_ge_msg_stack.add;
648: log_to_fnd(p_v_module => 'create_file',
649: p_v_string => 'Concurrent request failed for relationship code '||rec_c_recip_dtls.relationship_cd
650: );

Line 653: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');

649: p_v_string => 'Concurrent request failed for relationship code '||rec_c_recip_dtls.relationship_cd
650: );
651: app_exception.raise_exception;
652: END IF;
653: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
654: fnd_file.put_line(fnd_file.log, fnd_message.get || l_n_ctr_recip );
655:
656: log_to_fnd(p_v_module => 'create_file',
657: p_v_string => 'Concurrent request successfully executed for relationship code '||rec_c_recip_dtls.relationship_cd

Line 654: fnd_file.put_line(fnd_file.log, fnd_message.get || l_n_ctr_recip );

650: );
651: app_exception.raise_exception;
652: END IF;
653: fnd_message.set_name('IGS','IGS_GE_TOTAL_REC_PROCESSED');
654: fnd_file.put_line(fnd_file.log, fnd_message.get || l_n_ctr_recip );
655:
656: log_to_fnd(p_v_module => 'create_file',
657: p_v_string => 'Concurrent request successfully executed for relationship code '||rec_c_recip_dtls.relationship_cd
658: );

Line 668: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

664: log_to_fnd(p_v_module => 'create_file',
665: p_v_string => ' when others exception handler '||SQLERRM
666: );
667: retcode := 2;
668: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
669: igs_ge_msg_stack.conc_exception_hndl;
670: END create_file;
671:
672: PROCEDURE log_to_fnd ( p_v_module IN VARCHAR2,

Line 854: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');

850: l_rec_lorlar := p_rec_lorlar;
851:
852: -- Verify if the fund is dicontinued or not
853: IF l_rec_lorlar.discontinue_fund = 'Y' THEN
854: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
855: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_TYPE'));
856: fnd_file.put_line(fnd_file.log, fnd_message.get);
857: RETURN FALSE;
858: END IF;

Line 855: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_TYPE'));

851:
852: -- Verify if the fund is dicontinued or not
853: IF l_rec_lorlar.discontinue_fund = 'Y' THEN
854: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
855: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_TYPE'));
856: fnd_file.put_line(fnd_file.log, fnd_message.get);
857: RETURN FALSE;
858: END IF;
859:

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

852: -- Verify if the fund is dicontinued or not
853: IF l_rec_lorlar.discontinue_fund = 'Y' THEN
854: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
855: fnd_message.set_token('PARAMETER',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_TYPE'));
856: fnd_file.put_line(fnd_file.log, fnd_message.get);
857: RETURN FALSE;
858: END IF;
859:
860: -- Loan Type is required for Change Loan Processing. Following are valid Loan Types -

Line 867: fnd_message.set_name('IGF','IGF_SL_CL_CHG_LOANT_REQD');

863: -- SF=Subsidized Federal Stafford loan
864: -- SU=Unsubsidized Federal Stafford loan
865: -- tsailaja -FA 163 -Bug 5337555
866: IF l_rec_lorlar.fed_fund_code NOT IN ('FLS','FLU','FLP','ALT','GPLUSFL') THEN
867: fnd_message.set_name('IGF','IGF_SL_CL_CHG_LOANT_REQD');
868: fnd_file.put_line(fnd_file.log, fnd_message.get);
869: fnd_file.new_line(fnd_file.log, 1);
870: RETURN FALSE;
871: END IF;

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

864: -- SU=Unsubsidized Federal Stafford loan
865: -- tsailaja -FA 163 -Bug 5337555
866: IF l_rec_lorlar.fed_fund_code NOT IN ('FLS','FLU','FLP','ALT','GPLUSFL') THEN
867: fnd_message.set_name('IGF','IGF_SL_CL_CHG_LOANT_REQD');
868: fnd_file.put_line(fnd_file.log, fnd_message.get);
869: fnd_file.new_line(fnd_file.log, 1);
870: RETURN FALSE;
871: END IF;
872:

Line 875: fnd_message.set_name('IGS','IGF_SL_CL_LOAN_INACTIVE');

871: END IF;
872:
873: -- Validate whether loan is active
874: IF l_rec_lorlar.loan_active <> 'Y' THEN
875: fnd_message.set_name('IGS','IGF_SL_CL_LOAN_INACTIVE');
876: fnd_message.set_token('LOAN_NUMBER',l_rec_lorlar.loan_number);
877: fnd_file.put_line(fnd_file.log, fnd_message.get);
878: RETURN FALSE;
879: END IF;

Line 876: fnd_message.set_token('LOAN_NUMBER',l_rec_lorlar.loan_number);

872:
873: -- Validate whether loan is active
874: IF l_rec_lorlar.loan_active <> 'Y' THEN
875: fnd_message.set_name('IGS','IGF_SL_CL_LOAN_INACTIVE');
876: fnd_message.set_token('LOAN_NUMBER',l_rec_lorlar.loan_number);
877: fnd_file.put_line(fnd_file.log, fnd_message.get);
878: RETURN FALSE;
879: END IF;
880:

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

873: -- Validate whether loan is active
874: IF l_rec_lorlar.loan_active <> 'Y' THEN
875: fnd_message.set_name('IGS','IGF_SL_CL_LOAN_INACTIVE');
876: fnd_message.set_token('LOAN_NUMBER',l_rec_lorlar.loan_number);
877: fnd_file.put_line(fnd_file.log, fnd_message.get);
878: RETURN FALSE;
879: END IF;
880:
881: -- validate the loan status

Line 883: fnd_message.set_name('IGF','IGF_SL_CL_INV_LOAN_STAT');

879: END IF;
880:
881: -- validate the loan status
882: IF l_rec_lorlar.loan_status <> 'A' THEN
883: fnd_message.set_name('IGF','IGF_SL_CL_INV_LOAN_STAT');
884: fnd_file.put_line(fnd_file.log, fnd_message.get);
885: fnd_file.new_line(fnd_file.log, 1);
886: RETURN FALSE;
887: END IF;

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

880:
881: -- validate the loan status
882: IF l_rec_lorlar.loan_status <> 'A' THEN
883: fnd_message.set_name('IGF','IGF_SL_CL_INV_LOAN_STAT');
884: fnd_file.put_line(fnd_file.log, fnd_message.get);
885: fnd_file.new_line(fnd_file.log, 1);
886: RETURN FALSE;
887: END IF;
888:

Line 892: fnd_message.set_name('IGF','IGF_SL_INV_LOAN_CHG_STATUS');

888:
889: -- Validate the loan change status
890: -- loan change status should be ready to send
891: IF (l_rec_lorlar.loan_chg_status <> 'G') THEN
892: fnd_message.set_name('IGF','IGF_SL_INV_LOAN_CHG_STATUS');
893: fnd_file.put_line(fnd_file.log, fnd_message.get);
894: fnd_file.new_line(fnd_file.log, 1);
895: RETURN FALSE;
896: END IF;

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

889: -- Validate the loan change status
890: -- loan change status should be ready to send
891: IF (l_rec_lorlar.loan_chg_status <> 'G') THEN
892: fnd_message.set_name('IGF','IGF_SL_INV_LOAN_CHG_STATUS');
893: fnd_file.put_line(fnd_file.log, fnd_message.get);
894: fnd_file.new_line(fnd_file.log, 1);
895: RETURN FALSE;
896: END IF;
897:

Line 906: fnd_message.set_name('IGF','IGF_SL_CL_INV_CL_VER');

902: -- Processing Type Code is GP or GO
903:
904: -- vaildate the cl version code
905: IF (l_rec_lorlar.cl_version <> 'RELEASE-4') THEN
906: fnd_message.set_name('IGF','IGF_SL_CL_INV_CL_VER');
907: fnd_file.put_line(fnd_file.log, fnd_message.get);
908: fnd_file.new_line(fnd_file.log, 1);
909: RETURN FALSE;
910: END IF;

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

903:
904: -- vaildate the cl version code
905: IF (l_rec_lorlar.cl_version <> 'RELEASE-4') THEN
906: fnd_message.set_name('IGF','IGF_SL_CL_INV_CL_VER');
907: fnd_file.put_line(fnd_file.log, fnd_message.get);
908: fnd_file.new_line(fnd_file.log, 1);
909: RETURN FALSE;
910: END IF;
911:

Line 914: fnd_message.set_name('IGF','IGF_SL_CL_RESP_INVLID_PRC');

910: END IF;
911:
912: -- validate the loan processing type code
913: IF (l_rec_lorlar.prc_type_code NOT IN ('GO','GP')) THEN
914: fnd_message.set_name('IGF','IGF_SL_CL_RESP_INVLID_PRC');
915: fnd_file.put_line(fnd_file.log, fnd_message.get);
916: fnd_file.new_line(fnd_file.log, 1);
917: RETURN FALSE;
918: END IF;

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

911:
912: -- validate the loan processing type code
913: IF (l_rec_lorlar.prc_type_code NOT IN ('GO','GP')) THEN
914: fnd_message.set_name('IGF','IGF_SL_CL_RESP_INVLID_PRC');
915: fnd_file.put_line(fnd_file.log, fnd_message.get);
916: fnd_file.new_line(fnd_file.log, 1);
917: RETURN FALSE;
918: END IF;
919:

Line 922: fnd_message.set_name('IGF','IGF_SL_CL_INV_LAR_REC_STAT');

918: END IF;
919:
920: -- validate the Loan Record Status
921: IF l_rec_lorlar.cl_rec_status NOT IN ('B','G') THEN
922: fnd_message.set_name('IGF','IGF_SL_CL_INV_LAR_REC_STAT');
923: fnd_file.put_line(fnd_file.log, fnd_message.get);
924: fnd_file.new_line(fnd_file.log, 1);
925: RETURN FALSE;
926: END IF;

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

919:
920: -- validate the Loan Record Status
921: IF l_rec_lorlar.cl_rec_status NOT IN ('B','G') THEN
922: fnd_message.set_name('IGF','IGF_SL_CL_INV_LAR_REC_STAT');
923: fnd_file.put_line(fnd_file.log, fnd_message.get);
924: fnd_file.new_line(fnd_file.log, 1);
925: RETURN FALSE;
926: END IF;
927:

Line 933: fnd_message.set_name('IGF','IGF_SL_CL4_DISB_EXCEED');

929: OPEN c_nof_awd_disb ( cp_n_award_id => l_rec_lorlar.award_id);
930: FETCH c_nof_awd_disb INTO l_n_disb_cnt;
931: IF c_nof_awd_disb%FOUND THEN
932: CLOSE c_nof_awd_disb;
933: fnd_message.set_name('IGF','IGF_SL_CL4_DISB_EXCEED');
934: fnd_file.put_line(fnd_file.log, fnd_message.get);
935: fnd_file.new_line(fnd_file.log, 1);
936: RETURN FALSE;
937: END IF;

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

930: FETCH c_nof_awd_disb INTO l_n_disb_cnt;
931: IF c_nof_awd_disb%FOUND THEN
932: CLOSE c_nof_awd_disb;
933: fnd_message.set_name('IGF','IGF_SL_CL4_DISB_EXCEED');
934: fnd_file.put_line(fnd_file.log, fnd_message.get);
935: fnd_file.new_line(fnd_file.log, 1);
936: RETURN FALSE;
937: END IF;
938: CLOSE c_nof_awd_disb;

Line 942: fnd_message.set_name('IGF','IGF_SL_CL_CERT_AFTER_END');

938: CLOSE c_nof_awd_disb;
939:
940: --bvisvana - Validate the School certification date > loan end period
941: IF l_rec_lorlar.sch_cert_date > l_rec_lorlar.loan_per_end_date THEN
942: fnd_message.set_name('IGF','IGF_SL_CL_CERT_AFTER_END');
943: fnd_file.put_line(fnd_file.log, fnd_message.get);
944: fnd_file.new_line(fnd_file.log, 1);
945: RETURN FALSE;
946: END IF;

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

939:
940: --bvisvana - Validate the School certification date > loan end period
941: IF l_rec_lorlar.sch_cert_date > l_rec_lorlar.loan_per_end_date THEN
942: fnd_message.set_name('IGF','IGF_SL_CL_CERT_AFTER_END');
943: fnd_file.put_line(fnd_file.log, fnd_message.get);
944: fnd_file.new_line(fnd_file.log, 1);
945: RETURN FALSE;
946: END IF;
947:

Line 950: fnd_message.set_name('IGF','IGF_SL_CHECK_COMPLDATE');

946: END IF;
947:
948: --bvisvana - Bug # 4256897 - Validate the anticip_compl_date < loan end period
949: IF l_rec_lorlar.anticip_compl_date < l_rec_lorlar.loan_per_end_date THEN
950: fnd_message.set_name('IGF','IGF_SL_CHECK_COMPLDATE');
951: fnd_message.set_token('VALUE', ' ' || l_rec_lorlar.loan_per_end_date);
952: fnd_file.put_line(fnd_file.log, fnd_message.get);
953: fnd_file.new_line(fnd_file.log, 1);
954: RETURN FALSE;

Line 951: fnd_message.set_token('VALUE', ' ' || l_rec_lorlar.loan_per_end_date);

947:
948: --bvisvana - Bug # 4256897 - Validate the anticip_compl_date < loan end period
949: IF l_rec_lorlar.anticip_compl_date < l_rec_lorlar.loan_per_end_date THEN
950: fnd_message.set_name('IGF','IGF_SL_CHECK_COMPLDATE');
951: fnd_message.set_token('VALUE', ' ' || l_rec_lorlar.loan_per_end_date);
952: fnd_file.put_line(fnd_file.log, fnd_message.get);
953: fnd_file.new_line(fnd_file.log, 1);
954: RETURN FALSE;
955: END IF;

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

948: --bvisvana - Bug # 4256897 - Validate the anticip_compl_date < loan end period
949: IF l_rec_lorlar.anticip_compl_date < l_rec_lorlar.loan_per_end_date THEN
950: fnd_message.set_name('IGF','IGF_SL_CHECK_COMPLDATE');
951: fnd_message.set_token('VALUE', ' ' || l_rec_lorlar.loan_per_end_date);
952: fnd_file.put_line(fnd_file.log, fnd_message.get);
953: fnd_file.new_line(fnd_file.log, 1);
954: RETURN FALSE;
955: END IF;
956:

Line 1196: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);

1192: p_v_string => ' validation of the Change record failed for Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id
1193: );
1194: -- substring of the out bound parameter l_v_message_name is carried
1195: -- out since it can expect either IGS OR IGF message
1196: fnd_message.set_name(SUBSTR(l_v_message_name,1,3),l_v_message_name);
1197: igf_sl_cl_chg_prc.parse_tokens(
1198: p_t_message_tokens => l_t_message_tokens);
1199: /*
1200: FOR token_counter IN l_t_message_tokens.FIRST..l_t_message_tokens.LAST LOOP

Line 1201: fnd_message.set_token(l_t_message_tokens(token_counter).token_name, l_t_message_tokens(token_counter).token_value);

1197: igf_sl_cl_chg_prc.parse_tokens(
1198: p_t_message_tokens => l_t_message_tokens);
1199: /*
1200: FOR token_counter IN l_t_message_tokens.FIRST..l_t_message_tokens.LAST LOOP
1201: fnd_message.set_token(l_t_message_tokens(token_counter).token_name, l_t_message_tokens(token_counter).token_value);
1202: END LOOP;
1203: */
1204: l_v_message_text := fnd_message.get;
1205: fnd_file.put_line(fnd_file.log, l_v_message_text);

Line 1204: l_v_message_text := fnd_message.get;

1200: FOR token_counter IN l_t_message_tokens.FIRST..l_t_message_tokens.LAST LOOP
1201: fnd_message.set_token(l_t_message_tokens(token_counter).token_name, l_t_message_tokens(token_counter).token_value);
1202: END LOOP;
1203: */
1204: l_v_message_text := fnd_message.get;
1205: fnd_file.put_line(fnd_file.log, l_v_message_text);
1206: log_to_fnd(p_v_module => 'identify_clchsn_dtls',
1207: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
1208: );

Line 2929: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

2925: log_to_fnd(p_v_module => 'sub_create_file',
2926: p_v_string => ' when others exception handler ' ||SQLERRM
2927: );
2928: retcode := 2;
2929: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
2930: igs_ge_msg_stack.conc_exception_hndl;
2931: END sub_create_file;
2932:
2933: PROCEDURE proc_update_clchsn_dtls_rec(p_v_loan_number IN igf_sl_loans.loan_number%TYPE ,