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_DB_DISB dependencies on IGF_GR_GEN

Line 260: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));

256: fnd_file.new_line(fnd_file.log,1);
257: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| p_alt_code);
258: fnd_file.put_line(fnd_file.log, RPAD(lv_run_for,40) || ' : '|| lv_run_for_m);
259: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name_rec.group_cd);
260: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));
261: fnd_file.put_line(fnd_file.log, RPAD(lv_fund_code,40) || ' : '|| get_fund_code_rec.fund_code);
262: fnd_file.put_line(fnd_file.log, RPAD(lv_log_detail,40) || ' : '|| igf_aw_gen.lookup_desc('IGF_AP_YES_NO',p_log_det));
263:
264: fnd_file.new_line(fnd_file.log,1);

Line 1422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id('||p_base_id||'):'||igf_gr_gen.get_person_id(p_base_id));

1418: p_acad_ci_seq_num
1419: )
1420: LOOP
1421: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1422: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id('||p_base_id||'):'||igf_gr_gen.get_person_id(p_base_id));
1423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:'||get_acad_tp_rec.tp_cal_type);
1424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'||get_acad_tp_rec.tp_sequence_number);
1425: END IF;
1426: FOR get_att_rec IN cur_get_att(

Line 1427: igf_gr_gen.get_person_id(p_base_id),

1423: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:'||get_acad_tp_rec.tp_cal_type);
1424: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'||get_acad_tp_rec.tp_sequence_number);
1425: END IF;
1426: FOR get_att_rec IN cur_get_att(
1427: igf_gr_gen.get_person_id(p_base_id),
1428: p_acad_cal_type,
1429: get_acad_tp_rec.tp_cal_type,
1430: get_acad_tp_rec.tp_sequence_number
1431: )

Line 1810: igf_gr_gen.get_person_id(p_base_id));

1806:
1807: OPEN cur_fee_cls ( p_fund_id,
1808: p_fee_cal_type,
1809: p_fee_ci_sequence_number,
1810: igf_gr_gen.get_person_id(p_base_id));
1811:
1812: FETCH cur_fee_cls INTO fee_cls_rec;
1813:
1814: IF cur_fee_cls%FOUND THEN

Line 1891: igs_en_prc_load.enrp_get_inst_latt (igf_gr_gen.get_person_id(p_base_id),

1887: END IF;
1888:
1889:
1890: BEGIN
1891: igs_en_prc_load.enrp_get_inst_latt (igf_gr_gen.get_person_id(p_base_id),
1892: p_ld_cal_type,
1893: p_ld_seq_number,
1894: lv_key_att_type,
1895: l_credit_pts,

Line 2065: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));

2061: (ln_old_fund <> ln_new_fund AND ln_old_fund > 1)
2062: THEN
2063: fnd_file.new_line(fnd_file.log,1);
2064: fnd_message.set_name('IGF','IGF_DB_VERF_ENFR_RTN');
2065: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2066: fnd_message.set_token('FDESC',get_fund_desc(awd_disb_rec.fund_id));
2067: fnd_file.put_line(fnd_file.log,RPAD(' ',15) ||fnd_message.get);
2068: END IF;
2069:

Line 2151: igs_en_prc_load.enrp_clc_cp_upto_tp_start_dt(igf_gr_gen.get_person_id(awd_disb_rec.base_id),

2147: -- Min Credit Points
2148:
2149: lb_cp_result := TRUE;
2150: IF awd_disb_rec.min_credit_pts IS NOT NULL THEN
2151: igs_en_prc_load.enrp_clc_cp_upto_tp_start_dt(igf_gr_gen.get_person_id(awd_disb_rec.base_id),
2152: awd_disb_rec.ld_cal_type,
2153: awd_disb_rec.ld_sequence_number,
2154: 'Y',
2155: TRUNC(SYSDATE),

Line 2540: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));

2536: END IF;
2537: IF p_fund_id IS NULL THEN
2538: -- Add a new message having just one parameter.
2539: fnd_message.set_name('IGF','IGF_DB_NO_PLAN_REC');
2540: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));
2543: END IF;
2544: ELSE

Line 2542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));

2538: -- Add a new message having just one parameter.
2539: fnd_message.set_name('IGF','IGF_DB_NO_PLAN_REC');
2540: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2542: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));
2543: END IF;
2544: ELSE
2545: -- Add old message having two parameters.
2546: fnd_message.set_name('IGF','IGF_DB_NO_STD_FUND');

Line 2547: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));

2543: END IF;
2544: ELSE
2545: -- Add old message having two parameters.
2546: fnd_message.set_name('IGF','IGF_DB_NO_STD_FUND');
2547: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2548: fnd_message.set_token('FDESC',get_fund_desc(p_fund_id));
2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));
2551: END IF;

Line 2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));

2546: fnd_message.set_name('IGF','IGF_DB_NO_STD_FUND');
2547: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2548: fnd_message.set_token('FDESC',get_fund_desc(p_fund_id));
2549: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2550: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','no planned disbursments for '||igf_gr_gen.get_per_num(p_base_id));
2551: END IF;
2552: END IF;
2553: p_result := fnd_message.get;
2554: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||p_result);

Line 2619: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','starting processing for '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));

2615: FETCH cur_get_ver INTO get_ver_rec;
2616: CLOSE cur_get_ver;
2617:
2618: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2619: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','starting processing for '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));
2620: END IF;
2621: LOOP
2622: BEGIN
2623: -- clear message stack

Line 2655: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));

2651: (ln_old_fund <> ln_new_fund AND ln_old_fund > 1)
2652: THEN
2653: fnd_file.new_line(fnd_file.log,1);
2654: fnd_message.set_name('IGF','IGF_DB_PROCESS_STD_FUND');
2655: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_base_id));
2656: fnd_message.set_token('FDESC',get_fund_desc(awd_disb_rec.fund_id));
2657: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
2658: END IF;
2659:

Line 2742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','processing '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));

2738: --
2739: IF ln_old_fund <> ln_new_fund THEN
2740:
2741: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','processing '||igf_gr_gen.get_per_num(p_base_id)||' '||get_fund_desc(awd_disb_rec.fund_id));
2743: END IF;
2744: -- For each new fund that is visible within this scope,
2745: -- the result variables are initialized
2746:

Line 2758: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(p_base_id),awd_disb_rec.fund_code) = 'F' THEN

2754: -- Check for Academic Holds, only if con job is run
2755: --
2756:
2757: IF lv_call_from <> 'FORM' THEN
2758: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(p_base_id),awd_disb_rec.fund_code) = 'F' THEN
2759: lb_hold_result := FALSE;
2760: END IF;
2761: END IF;
2762:

Line 3082: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(awd_disb_rec.ld_cal_type,awd_disb_rec.ld_sequence_number));

3078: lb_pell_cal_result := FALSE;
3079: fnd_message.set_name('IGF','IGF_GR_PELL_DISB_FAIL');
3080: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
3081: fnd_message.set_token('CALC_AMT',p_term_aid);
3082: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(awd_disb_rec.ld_cal_type,awd_disb_rec.ld_sequence_number));
3083: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',awd_disb_rec.base_attendance_type_code));
3084: p_result := fnd_message.get;
3085: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3086:

Line 3171: igf_gr_gen.get_person_id(awd_disb_rec.base_id),

3167: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3168: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.process_student.debug','awd_disb_rec.min_credit_pts:'||awd_disb_rec.min_credit_pts);
3169: END IF;
3170: igs_en_prc_load.enrp_clc_cp_upto_tp_start_dt(
3171: igf_gr_gen.get_person_id(awd_disb_rec.base_id),
3172: awd_disb_rec.ld_cal_type,
3173: awd_disb_rec.ld_sequence_number,
3174: 'Y',
3175: get_cut_off_dt(

Line 3251: IF awd_disb_rec.disb_num = igf_gr_gen.get_min_disb_number(awd_disb_rec.award_id) THEN

3247: --
3248: IF NVL(awd_disb_rec.ver_app_stat_override,'N') = 'Y' THEN
3249: IF NVL(get_ver_rec.fed_verif_status,'N') = 'WITHOUTDOC' THEN
3250: IF NVL(awd_disb_rec.send_without_doc,'N') = 'Y' THEN
3251: IF awd_disb_rec.disb_num = igf_gr_gen.get_min_disb_number(awd_disb_rec.award_id) THEN
3252: lb_send_wdoc := TRUE;
3253: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3254: p_result := fnd_message.get;
3255: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);

Line 3309: IF awd_disb_rec.disb_num = igf_gr_gen.get_min_disb_number(awd_disb_rec.award_id) THEN

3305:
3306: IF NVL(awd_disb_rec.ver_app_stat_override,'N') = 'Y' THEN
3307: IF NVL(get_ver_rec.fed_verif_status,'N') = 'WITHOUTDOC' THEN
3308: IF NVL(awd_disb_rec.send_without_doc,'N') = 'Y' THEN
3309: IF awd_disb_rec.disb_num = igf_gr_gen.get_min_disb_number(awd_disb_rec.award_id) THEN
3310: lb_send_wdoc := TRUE;
3311: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3312: p_result := fnd_message.get;
3313: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);

Line 3365: IF awd_disb_rec.disb_num = igf_gr_gen.get_min_disb_number(awd_disb_rec.award_id) THEN

3361: --
3362: IF NVL(awd_disb_rec.ver_app_stat_override,'N') = 'Y' THEN
3363: IF NVL(get_ver_rec.fed_verif_status,'N') = 'WITHOUTDOC' THEN
3364: IF NVL(awd_disb_rec.send_without_doc,'N') = 'Y' THEN
3365: IF awd_disb_rec.disb_num = igf_gr_gen.get_min_disb_number(awd_disb_rec.award_id) THEN
3366: lb_send_wdoc := TRUE;
3367: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3368: p_result := fnd_message.get;
3369: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);

Line 3417: IF awd_disb_rec.disb_num = igf_gr_gen.get_min_disb_number(awd_disb_rec.award_id) THEN

3413:
3414: IF NVL(awd_disb_rec.ver_app_stat_override,'N') = 'Y' THEN
3415: IF NVL(get_ver_rec.fed_verif_status,'N') = 'WITHOUTDOC' THEN
3416: IF NVL(awd_disb_rec.send_without_doc,'N') = 'Y' THEN
3417: IF awd_disb_rec.disb_num = igf_gr_gen.get_min_disb_number(awd_disb_rec.award_id) THEN
3418: lb_send_wdoc := TRUE;
3419: fnd_message.set_name('IGF','IGF_DB_ALW_FIRST_VER');
3420: p_result := fnd_message.get;
3421: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);

Line 3756: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code (l_ci_cal_type,l_ci_sequence_number));

3752: END IF;
3753:
3754: fnd_file.new_line(fnd_file.log,2);
3755: fnd_message.set_name('IGF','IGF_DB_PROCESS_AWD');
3756: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code (l_ci_cal_type,l_ci_sequence_number));
3757: -- Processing Disbursements for Award Year
3758: fnd_file.put_line(fnd_file.log,fnd_message.get);
3759: fnd_file.new_line(fnd_file.log,1);
3760:

Line 3818: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(ln_base_id)) = 'F' THEN

3814: END IF;
3815: --
3816: -- Check for Academic Holds, only if con job is run
3817: --
3818: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(ln_base_id)) = 'F' THEN
3819: fnd_message.set_name('IGF','IGF_AW_DISB_FUND_HOLD_FAIL');
3820: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3821: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3822: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');

Line 3848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');

3844: fnd_message.set_token('AWD_YR',l_award_det.alternate_code);
3845: -- Person PER_NUM does not exist in FA
3846: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3847: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3848: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
3849: END IF;
3850: END IF;
3851:
3852: ELSE

Line 3868: lv_person_number := igf_gr_gen.get_per_num (p_base_id);

3864: END IF;
3865:
3866: ELSIF p_run_for ='S' AND p_base_id IS NOT NULL THEN
3867:
3868: lv_person_number := igf_gr_gen.get_per_num (p_base_id);
3869:
3870: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
3871: fnd_message.set_token('STDNT',lv_person_number);
3872: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 3881: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(p_base_id)) = 'F' THEN

3877: --
3878: -- Check for Academic Holds, only if con job is run
3879: --
3880:
3881: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(p_base_id)) = 'F' THEN
3882: fnd_message.set_name('IGF','IGF_AW_DISB_FUND_HOLD_FAIL');
3883: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3884: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3885: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');

Line 3929: lv_person_number := igf_gr_gen.get_per_num (award_std_rec.base_id);

3925: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','award_std_rec.fed_fund_code:'||award_std_rec.fed_fund_code);
3926: END IF;
3927: IF award_std_rec.fed_fund_code NOT IN ('FWS','SPNSR') THEN
3928: LOOP
3929: lv_person_number := igf_gr_gen.get_per_num (award_std_rec.base_id);
3930:
3931: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
3932: fnd_message.set_token('STDNT',lv_person_number);
3933: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 3941: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(award_std_rec.base_id)) = 'F' THEN

3937: END IF;
3938: --
3939: -- Check for Academic Holds, only if con job is run
3940: --
3941: IF igf_aw_gen_005.get_stud_hold_effect('D',igf_gr_gen.get_person_id(award_std_rec.base_id)) = 'F' THEN
3942: fnd_message.set_name('IGF','IGF_AW_DISB_FUND_HOLD_FAIL');
3943: fnd_file.put_line(fnd_file.log,RPAD(' ',10) ||fnd_message.get);
3944: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3945: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.disb_process.debug','get_stud_hold_effect returned F');