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_FILE

Line 279: fnd_file.new_line(fnd_file.log,1);

275: log_to_fnd(p_v_module => 'create_file',
276: p_v_string => ' Start of Parameter logging'
277: );
278:
279: fnd_file.new_line(fnd_file.log,1);
280: fnd_file.put(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
281: fnd_file.new_line(fnd_file.log,1);
282:
283: OPEN c_igf_aw_fund_mast (cp_n_fund_id => l_n_fund_id);

Line 280: fnd_file.put(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));

276: p_v_string => ' Start of Parameter logging'
277: );
278:
279: fnd_file.new_line(fnd_file.log,1);
280: fnd_file.put(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
281: fnd_file.new_line(fnd_file.log,1);
282:
283: OPEN c_igf_aw_fund_mast (cp_n_fund_id => l_n_fund_id);
284: FETCH c_igf_aw_fund_mast INTO rec_c_igf_aw_fund_mast;

Line 281: fnd_file.new_line(fnd_file.log,1);

277: );
278:
279: fnd_file.new_line(fnd_file.log,1);
280: fnd_file.put(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
281: fnd_file.new_line(fnd_file.log,1);
282:
283: OPEN c_igf_aw_fund_mast (cp_n_fund_id => l_n_fund_id);
284: FETCH c_igf_aw_fund_mast INTO rec_c_igf_aw_fund_mast;
285: CLOSE c_igf_aw_fund_mast;

Line 331: fnd_file.new_line(fnd_file.log,1);

327: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','SCH_NON_ED_BRANCH'),40),
328: p_v_param_val => l_v_sch_non_ed_branch
329: );
330:
331: fnd_file.new_line(fnd_file.log,1);
332: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
333: fnd_file.new_line(fnd_file.log,1);
334: log_to_fnd(p_v_module => 'create_file',
335: p_v_string => ' End of Parameter logging'

Line 332: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');

328: p_v_param_val => l_v_sch_non_ed_branch
329: );
330:
331: fnd_file.new_line(fnd_file.log,1);
332: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
333: fnd_file.new_line(fnd_file.log,1);
334: log_to_fnd(p_v_module => 'create_file',
335: p_v_string => ' End of Parameter logging'
336: );

Line 333: fnd_file.new_line(fnd_file.log,1);

329: );
330:
331: fnd_file.new_line(fnd_file.log,1);
332: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
333: fnd_file.new_line(fnd_file.log,1);
334: log_to_fnd(p_v_module => 'create_file',
335: p_v_string => ' End of Parameter logging'
336: );
337: -- parameter logging logic ends here -------------------------------------------------

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 347: fnd_file.new_line(fnd_file.log, 1);

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;
351:

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 356: fnd_file.new_line(fnd_file.log, 1);

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;
360:

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 365: fnd_file.new_line(fnd_file.log, 1);

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;
369:

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 383: fnd_file.new_line(fnd_file.log, 1);

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;
387: --Validate the Award Year Status. If the status is not open, log the message in log file and

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 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 413: fnd_file.new_line(fnd_file.log, 1);

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;
417:

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 425: fnd_file.new_line(fnd_file.log, 1);

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;
429:

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 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 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 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 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 511: fnd_file.put_line(fnd_file.log,l_v_sql);

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: );
515: retcode := 2;

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 566: fnd_file.new_line(fnd_file.log, 1);

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: );
570: END;

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 719: fnd_file.put_line(fnd_file.log, p_v_param_typ || ' : ' || p_v_param_val );

715: --Change History:
716: --Who When What
717: ------------------------------------------------------------------
718: BEGIN
719: fnd_file.put_line(fnd_file.log, p_v_param_typ || ' : ' || p_v_param_val );
720: END log_parameters;
721:
722: FUNCTION get_base_id
723: (

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 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 869: fnd_file.new_line(fnd_file.log, 1);

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:
873: -- Validate whether loan is active

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 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 885: fnd_file.new_line(fnd_file.log, 1);

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:
889: -- Validate the loan change status

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 894: fnd_file.new_line(fnd_file.log, 1);

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:
898: -- Change Record would be created only 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 908: fnd_file.new_line(fnd_file.log, 1);

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:
912: -- validate the loan processing type code

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 916: fnd_file.new_line(fnd_file.log, 1);

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:
920: -- validate the Loan Record Status

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 924: fnd_file.new_line(fnd_file.log, 1);

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:
928: -- For Release 4 processing, only 4 disbursements are allowed.

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 935: fnd_file.new_line(fnd_file.log, 1);

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;
939:

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 944: fnd_file.new_line(fnd_file.log, 1);

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:
948: --bvisvana - Bug # 4256897 - Validate the anticip_compl_date < loan end period

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 953: fnd_file.new_line(fnd_file.log, 1);

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:
957: -- returning true as all the validations are successful

Line 1090: fnd_file.new_line(fnd_file.log,1);

1086: cp_n_loan_id => p_n_loan_id
1087: )
1088: LOOP
1089: BEGIN
1090: fnd_file.new_line(fnd_file.log,1);
1091: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
1092: fnd_file.new_line(fnd_file.log,1);
1093:
1094: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40),

Line 1091: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));

1087: )
1088: LOOP
1089: BEGIN
1090: fnd_file.new_line(fnd_file.log,1);
1091: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
1092: fnd_file.new_line(fnd_file.log,1);
1093:
1094: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40),
1095: p_v_param_val => rec_c_lor_lar.loan_number

Line 1092: fnd_file.new_line(fnd_file.log,1);

1088: LOOP
1089: BEGIN
1090: fnd_file.new_line(fnd_file.log,1);
1091: fnd_file.put(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING'),40));
1092: fnd_file.new_line(fnd_file.log,1);
1093:
1094: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40),
1095: p_v_param_val => rec_c_lor_lar.loan_number
1096: );

Line 1119: fnd_file.new_line(fnd_file.log,1);

1115:
1116: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','CL_VERSION'),40),
1117: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_VERSION',rec_c_lor_lar.cl_version)
1118: );
1119: fnd_file.new_line(fnd_file.log,1);
1120:
1121: -- Assigning to record type variable
1122: l_rec_lorlar.cal_type := rec_c_lor_lar.ci_cal_type ;
1123: l_rec_lorlar.sequence_number := rec_c_lor_lar.ci_sequence_number ;

Line 1205: fnd_file.put_line(fnd_file.log, l_v_message_text);

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: );
1209: igf_sl_clchsn_dtls_pkg.update_row

Line 1931: fnd_file.put_line(fnd_file.output,l_v_chg_header_rec);

1927: ||RPAD(' ',293,' ')
1928: ||'*';
1929: l_v_chg_header_rec := UPPER(l_v_chg_header_rec);
1930: -- writing the change send header record on to output file
1931: fnd_file.put_line(fnd_file.output,l_v_chg_header_rec);
1932: log_to_fnd(p_v_module => 'sub_create_file',
1933: p_v_string => ' change send header record '||l_v_chg_header_rec
1934: );
1935: -- initializing the record counters for both @1 and @2 change send reccords for RELEASE-4

Line 1993: fnd_file.put_line(fnd_file.output,l_v_chg_01_2_rec);

1989: ||RPAD(' ',80,' ')
1990: ||'*';
1991: l_v_chg_01_2_rec := UPPER(l_v_chg_01_2_rec);
1992: -- writing the change send @1-02 record on to output file
1993: fnd_file.put_line(fnd_file.output,l_v_chg_01_2_rec);
1994: l_n_1cntr := l_n_1cntr + 1;
1995: log_to_fnd(p_v_module => 'sub_create_file',
1996: p_v_string => ' change send @1-02 record '||l_v_chg_01_2_rec
1997: );

Line 2301: fnd_file.put_line(fnd_file.output,l_v_chg_01_7_rec);

2297: ||'*';
2298:
2299: l_v_chg_01_7_rec := UPPER(l_v_chg_01_7_rec);
2300: -- writing the change send @1-07 record on to output file
2301: fnd_file.put_line(fnd_file.output,l_v_chg_01_7_rec);
2302: l_n_1cntr := l_n_1cntr + 1;
2303: log_to_fnd(p_v_module => 'sub_create_file',
2304: p_v_string => ' change send @1-07 record '||l_v_chg_01_7_rec
2305: );

Line 2365: fnd_file.put_line(fnd_file.output,l_v_chg_01_8_rec);

2361: ||'*';
2362:
2363: l_v_chg_01_8_rec := UPPER(l_v_chg_01_8_rec);
2364: -- writing the change send @1-08 record on to output file
2365: fnd_file.put_line(fnd_file.output,l_v_chg_01_8_rec);
2366: l_n_1cntr := l_n_1cntr + 1;
2367: log_to_fnd(p_v_module => 'sub_create_file',
2368: p_v_string => ' change send @1-08 record '||l_v_chg_01_8_rec
2369: );

Line 2450: fnd_file.put_line(fnd_file.output,l_v_chg_01_9_rec);

2446: ||'*';
2447:
2448: l_v_chg_01_9_rec := UPPER(l_v_chg_01_9_rec);
2449: -- writing the change send @1-09 record on to output file
2450: fnd_file.put_line(fnd_file.output,l_v_chg_01_9_rec);
2451: l_n_1cntr := l_n_1cntr + 1;
2452: log_to_fnd(p_v_module => 'sub_create_file',
2453: p_v_string => ' change send @1-09 record '||l_v_chg_01_9_rec
2454: );

Line 2533: fnd_file.put_line(fnd_file.output,l_v_chg_01_10_rec);

2529: ||'*';
2530:
2531: l_v_chg_01_10_rec := UPPER(l_v_chg_01_10_rec);
2532: -- writing the change send @1-10 record on to output file
2533: fnd_file.put_line(fnd_file.output,l_v_chg_01_10_rec);
2534: l_n_1cntr := l_n_1cntr + 1;
2535: log_to_fnd(p_v_module => 'sub_create_file',
2536: p_v_string => ' change send @1-10 record '||l_v_chg_01_10_rec
2537: );

Line 2636: fnd_file.put_line(fnd_file.output,l_v_chg_01_24_rec);

2632: ||'*';
2633:
2634: l_v_chg_01_24_rec := UPPER(l_v_chg_01_24_rec);
2635: -- writing the change send @1-24 record on to output file
2636: fnd_file.put_line(fnd_file.output,l_v_chg_01_24_rec);
2637: l_n_1cntr := l_n_1cntr + 1;
2638: log_to_fnd(p_v_module => 'sub_create_file',
2639: p_v_string => ' change send @1-24 record '||l_v_chg_01_24_rec
2640: );

Line 2916: fnd_file.put_line(fnd_file.output,l_v_chg_trailer_rec);

2912: ||RPAD(' ',336,' ')
2913: ||'*';
2914: l_v_chg_trailer_rec := UPPER(l_v_chg_trailer_rec);
2915: -- writing the change send trailer record on to output file
2916: fnd_file.put_line(fnd_file.output,l_v_chg_trailer_rec);
2917: log_to_fnd(p_v_module => 'sub_create_file',
2918: p_v_string => ' change send trailer record '||l_v_chg_trailer_rec
2919: );
2920: