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_GR_PELL dependencies on IGF_GR_PELL

Line 1: PACKAGE BODY IGF_GR_PELL AS

1: PACKAGE BODY IGF_GR_PELL AS
2: /* $Header: IGFGR01B.pls 120.0 2005/06/02 15:55:36 appldev noship $ */
3:
4: --
5: ------------------------------------------------------------------------

Line 124: -- igf_gr_pell_setup

120: -- Pre-requisites
121: -- The following tables have to be populated before calling this process
122: -- igf_fa_base_rec
123: -- igf_aw_fund_mast
124: -- igf_gr_pell_setup
125: --
126: -- The pell calculation routine is called from packaging,igfgr004,igfgr005,igfaw016
127: --
128:

Line 320: l_pell_setup igf_gr_pell_setup_all%ROWTYPE;

316:
317:
318: get_awd_rec cur_get_awd%ROWTYPE;
319:
320: l_pell_setup igf_gr_pell_setup_all%ROWTYPE;
321: l_rfms_rec igf_gr_rfms%ROWTYPE ;
322: l_rfmsd_rec igf_gr_rfms_disb%ROWTYPE ;
323:
324: lv_row_id VARCHAR2(25);

Line 412: l_program_cd igf_gr_pell_setup_all.course_cd%TYPE;

408: l_return_status VARCHAR2(1);
409: l_return_mesg_text VARCHAR2(2000);
410: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
411: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
412: l_program_cd igf_gr_pell_setup_all.course_cd%TYPE;
413: l_program_version igf_gr_pell_setup_all.version_number%TYPE;
414: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
415:
416: BEGIN

Line 413: l_program_version igf_gr_pell_setup_all.version_number%TYPE;

409: l_return_mesg_text VARCHAR2(2000);
410: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
411: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
412: l_program_cd igf_gr_pell_setup_all.course_cd%TYPE;
413: l_program_version igf_gr_pell_setup_all.version_number%TYPE;
414: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
415:
416: BEGIN
417:

Line 475: fnd_message.set_name('IGF','IGF_GR_PELL_ALREADY_EXISTS');

471: --
472: -- Create RFMS Record only if there is no existing Record
473: --
474: IF cur_chk_orig%FOUND THEN
475: fnd_message.set_name('IGF','IGF_GR_PELL_ALREADY_EXISTS');
476: fnd_file.put_line(fnd_file.log,fnd_message.get);
477: CLOSE cur_chk_orig;
478: RAISE MY_EXP;
479: ELSE

Line 488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell.rfms_load_rec.debug','Key Program > Course cd>' || l_program_cd || ' Version >' || TO_CHAR(l_program_version) );

484: cp_course_cd => l_program_cd,
485: cp_version_number => l_program_version
486: );
487: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell.rfms_load_rec.debug','Key Program > Course cd>' || l_program_cd || ' Version >' || TO_CHAR(l_program_version) );
489: END IF;
490:
491: -- Get Pell Setup Details
492: igf_gr_pell_calc.get_pell_setup(cp_base_id => l_award.base_id,

Line 492: igf_gr_pell_calc.get_pell_setup(cp_base_id => l_award.base_id,

488: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_pell.rfms_load_rec.debug','Key Program > Course cd>' || l_program_cd || ' Version >' || TO_CHAR(l_program_version) );
489: END IF;
490:
491: -- Get Pell Setup Details
492: igf_gr_pell_calc.get_pell_setup(cp_base_id => l_award.base_id,
493: cp_course_cd => l_program_cd,
494: cp_version_number => l_program_version,
495: cp_cal_type => l_fa_base.ci_cal_type,
496: cp_sequence_number => l_fa_base.ci_sequence_number ,

Line 589: igf_gr_pell.generate_origination_id( l_fa_base.base_id,

585:
586: IF (l_cod_year_flag) THEN -- Full Student
587:
588: -- Pass Attending Entity ID COD-XML processing year
589: igf_gr_pell.generate_origination_id( l_fa_base.base_id,
590: l_attend_entity_id,
591: l_origination_id,
592: l_error );
593: ELSE -- phase-in award year

Line 595: igf_gr_pell.generate_origination_id( l_fa_base.base_id,

591: l_origination_id,
592: l_error );
593: ELSE -- phase-in award year
594: -- Pass Attending Pell ID
595: igf_gr_pell.generate_origination_id( l_fa_base.base_id,
596: l_attend_pell_id,
597: l_origination_id,
598: l_error );
599: END IF;

Line 665: igf_gr_pell_calc.calc_ft_max_pell(cp_base_id => l_rfms_rec.base_id,

661: ELSE
662: l_rfms_rec.pell_amount := NVL(l_award.accepted_amt,0);
663: END IF;
664:
665: igf_gr_pell_calc.calc_ft_max_pell(cp_base_id => l_rfms_rec.base_id,
666: cp_cal_type => l_rfms_rec.ci_cal_type,
667: cp_sequence_number => l_rfms_rec.ci_sequence_number,
668: cp_flag => 'FULL_TIME',
669: cp_aid => l_pell_amt,

Line 942: fnd_message.set_token('NAME','IGF_GR_PELL.RFMS_LOAD_REC');

938:
939: EXCEPTION
940: WHEN OTHERS THEN
941: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
942: fnd_message.set_token('NAME','IGF_GR_PELL.RFMS_LOAD_REC');
943: fnd_file.put_line(fnd_file.log,SQLERRM);
944: igs_ge_msg_stack.add;
945: app_exception.raise_exception;
946: END rfms_load_rec ;

Line 1101: fnd_message.set_token('NAME','IGF_GR_PELL.GENERATE_ORIGINATION_ID' ||' '||SQLERRM);

1097: EXCEPTION
1098:
1099: WHEN OTHERS THEN
1100: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1101: fnd_message.set_token('NAME','IGF_GR_PELL.GENERATE_ORIGINATION_ID' ||' '||SQLERRM);
1102: igs_ge_msg_stack.add;
1103: app_exception.raise_exception;
1104:
1105: END generate_origination_id;

Line 1159: END igf_gr_pell;

1155: EXCEPTION WHEN OTHERS THEN
1156: RETURN NULL;
1157: END get_enrollment_date;
1158:
1159: END igf_gr_pell;