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_AW_PACKAGING dependencies on IGF_SL_AWARD

Line 164: || Changed sequence of calling igf_sl_award.get_loan_amts and

160: || brajendr 18-Oct-2002 Bug : 2591643
161: || Modified the chk_todo_result for FA104 - To Do Enhancements
162: ||
163: || sjadhav Bug 2411031
164: || Changed sequence of calling igf_sl_award.get_loan_amts and
165: || igf_sl_roundoff_digits_pkg.gross_fees_roundoff. This is done
166: || becuase first round off disbursement gross amount should be
167: || calculated first and then net amount / fee amount etc
168: ||

Line 2546: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,

2542:
2543: -- Get the Direct and Federal/Common Loan limit Amounts
2544: IF igf_sl_gen.chk_dl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE'
2545: OR igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
2546: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,
2547: l_fmast.ci_cal_type ,
2548: l_fmast.ci_sequence_number,
2549: l_base_id,
2550: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));

Line 2550: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));

2546: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,
2547: l_fmast.ci_cal_type ,
2548: l_fmast.ci_sequence_number,
2549: l_base_id,
2550: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));
2551: END IF;
2552:
2553: -- Get the Guarantor fee % for Commonline Loans
2554: IF igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN

Line 2555: l_fee2 := igf_sl_award.get_loan_fee2( l_fmast.fed_fund_code,

2551: END IF;
2552:
2553: -- Get the Guarantor fee % for Commonline Loans
2554: IF igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
2555: l_fee2 := igf_sl_award.get_loan_fee2( l_fmast.fed_fund_code,
2556: l_fmast.ci_cal_type ,
2557: l_fmast.ci_sequence_number,
2558: l_base_id,
2559: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));

Line 2559: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));

2555: l_fee2 := igf_sl_award.get_loan_fee2( l_fmast.fed_fund_code,
2556: l_fmast.ci_cal_type ,
2557: l_fmast.ci_sequence_number,
2558: l_base_id,
2559: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));
2560: END IF;
2561:
2562: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2563: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called got loan limits');

Line 2796: l_hold_rel_ind := igf_sl_award.get_cl_hold_rel_ind(

2792:
2793: -- For LOANs, get the Hold Release Indicator which is defined at the fund level
2794: -- FA 122 Loans Enhancemnets added the l_auto_late_ind variable to get the auto_late_ind
2795: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
2796: l_hold_rel_ind := igf_sl_award.get_cl_hold_rel_ind(
2797: l_fmast.fed_fund_code,
2798: l_fmast.ci_cal_type,
2799: l_fmast.ci_sequence_number,
2800: l_base_id,

Line 2801: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)

2797: l_fmast.fed_fund_code,
2798: l_fmast.ci_cal_type,
2799: l_fmast.ci_sequence_number,
2800: l_base_id,
2801: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)
2802: );
2803: l_auto_late_ind := igf_sl_award.get_cl_auto_late_ind(
2804: l_fmast.fed_fund_code,
2805: l_fmast.ci_cal_type,

Line 2803: l_auto_late_ind := igf_sl_award.get_cl_auto_late_ind(

2799: l_fmast.ci_sequence_number,
2800: l_base_id,
2801: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)
2802: );
2803: l_auto_late_ind := igf_sl_award.get_cl_auto_late_ind(
2804: l_fmast.fed_fund_code,
2805: l_fmast.ci_cal_type,
2806: l_fmast.ci_sequence_number,
2807: l_base_id,

Line 2808: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)

2804: l_fmast.fed_fund_code,
2805: l_fmast.ci_cal_type,
2806: l_fmast.ci_sequence_number,
2807: l_base_id,
2808: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)
2809: );
2810: ELSE
2811: l_hold_rel_ind := NULL;
2812: l_auto_late_ind := NULL;

Line 2850: -- Changed sequence of calling igf_sl_award.get_loan_amts and igf_sl_roundoff_digits_pkg.gross_fees_roundoff.

2846: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2847: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
2848: END IF;
2849: -- sjadhav Bug 2411031
2850: -- Changed sequence of calling igf_sl_award.get_loan_amts and igf_sl_roundoff_digits_pkg.gross_fees_roundoff.
2851: -- This is done becuase first round off disbursement gross amount should be calculated first and then net amount / fee amount etc
2852:
2853: -- we are passing dummys here for Net and Fee amount as they will be calculated later on
2854:

Line 2867: igf_sl_award.get_loan_amts(

2863:
2864:
2865:
2866: -- This routine will return Net Amount/ Fee Amounts / Interest Rebate Amount
2867: igf_sl_award.get_loan_amts(
2868: l_fmast.ci_cal_type,
2869: l_fmast.ci_sequence_number,
2870: l_fmast.fed_fund_code,
2871: NVL(ln_db_act_gross_amt,0),

Line 2880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'after calling igf_sl_award.get_loan_amts,l_awd_disb.temp_num_val1:'||l_awd_disb.temp_num_val1);

2876:
2877: l_awd_disb.temp_num_val1 := NVL(l_net,0);
2878:
2879: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
2880: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'after calling igf_sl_award.get_loan_amts,l_awd_disb.temp_num_val1:'||l_awd_disb.temp_num_val1);
2881: END IF;
2882:
2883: -- masehgal rounding off for CL
2884: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

Line 3234: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,

3230:
3231: -- Get the Direct and Federal/Common Loan limit Amounts
3232: IF igf_sl_gen.chk_dl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE'
3233: OR igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
3234: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,
3235: l_fmast.ci_cal_type ,
3236: l_fmast.ci_sequence_number,
3237: l_base_id,
3238: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));

Line 3238: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));

3234: l_fee1 := igf_sl_award.get_loan_fee1 ( l_fmast.fed_fund_code,
3235: l_fmast.ci_cal_type ,
3236: l_fmast.ci_sequence_number,
3237: l_base_id,
3238: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));
3239: END IF;
3240:
3241: -- Get the Guarantor fee % for Commonline Loans
3242: IF igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN

Line 3243: l_fee2 := igf_sl_award.get_loan_fee2( l_fmast.fed_fund_code,

3239: END IF;
3240:
3241: -- Get the Guarantor fee % for Commonline Loans
3242: IF igf_sl_gen.chk_cl_fed_fund_code (l_fmast.fed_fund_code) = 'TRUE' THEN
3243: l_fee2 := igf_sl_award.get_loan_fee2( l_fmast.fed_fund_code,
3244: l_fmast.ci_cal_type ,
3245: l_fmast.ci_sequence_number,
3246: l_base_id,
3247: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));

Line 3247: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));

3243: l_fee2 := igf_sl_award.get_loan_fee2( l_fmast.fed_fund_code,
3244: l_fmast.ci_cal_type ,
3245: l_fmast.ci_sequence_number,
3246: l_base_id,
3247: igf_sl_award.get_alt_rel_code(l_fmast.fund_code));
3248: END IF;
3249:
3250: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3251: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'called got loan limits');

Line 3468: l_hold_rel_ind := igf_sl_award.get_cl_hold_rel_ind(

3464:
3465: -- For LOANs, get the Hold Release Indicator which is defined at the fund level
3466: -- FA 122 Loans Enhancemnets added the l_auto_late_ind variable to get the auto_late_ind
3467: IF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN
3468: l_hold_rel_ind := igf_sl_award.get_cl_hold_rel_ind(
3469: l_fmast.fed_fund_code,
3470: l_fmast.ci_cal_type,
3471: l_fmast.ci_sequence_number,
3472: l_base_id,

Line 3473: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)

3469: l_fmast.fed_fund_code,
3470: l_fmast.ci_cal_type,
3471: l_fmast.ci_sequence_number,
3472: l_base_id,
3473: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)
3474: );
3475: l_auto_late_ind := igf_sl_award.get_cl_auto_late_ind(
3476: l_fmast.fed_fund_code,
3477: l_fmast.ci_cal_type,

Line 3475: l_auto_late_ind := igf_sl_award.get_cl_auto_late_ind(

3471: l_fmast.ci_sequence_number,
3472: l_base_id,
3473: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)
3474: );
3475: l_auto_late_ind := igf_sl_award.get_cl_auto_late_ind(
3476: l_fmast.fed_fund_code,
3477: l_fmast.ci_cal_type,
3478: l_fmast.ci_sequence_number,
3479: l_base_id,

Line 3480: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)

3476: l_fmast.fed_fund_code,
3477: l_fmast.ci_cal_type,
3478: l_fmast.ci_sequence_number,
3479: l_base_id,
3480: igf_sl_award.get_alt_rel_code(l_fmast.fund_code)
3481: );
3482: ELSE
3483: l_hold_rel_ind := NULL;
3484: l_auto_late_ind := NULL;

Line 3522: -- Changed sequence of calling igf_sl_award.get_loan_amts and igf_sl_roundoff_digits_pkg.gross_fees_roundoff.

3518: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3519: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'igf_sl_gen.chk_dl_fed_fund_code('||l_fmast.fed_fund_code||')=TRUE');
3520: END IF;
3521: -- sjadhav Bug 2411031
3522: -- Changed sequence of calling igf_sl_award.get_loan_amts and igf_sl_roundoff_digits_pkg.gross_fees_roundoff.
3523: -- This is done becuase first round off disbursement gross amount should be calculated first and then net amount / fee amount etc
3524:
3525: -- we are passing dummys here for Net and Fee amount as they will be calculated later on
3526:

Line 3536: igf_sl_award.get_loan_amts(

3532: p_fee => ln_dummy_fee_1
3533: );
3534:
3535: -- This routine will return Net Amount/ Fee Amounts / Interest Rebate Amount
3536: igf_sl_award.get_loan_amts(
3537: l_fmast.ci_cal_type,
3538: l_fmast.ci_sequence_number,
3539: l_fmast.fed_fund_code,
3540: NVL(ln_db_act_gross_amt,0),

Line 3549: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'after calling igf_sl_award.get_loan_amts,l_awd_disb.temp_num_val1:'||l_awd_disb.temp_num_val1);

3545:
3546: l_awd_disb.temp_num_val1 := NVL(l_net,0);
3547:
3548: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3549: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'after calling igf_sl_award.get_loan_amts,l_awd_disb.temp_num_val1:'||l_awd_disb.temp_num_val1);
3550: END IF;
3551:
3552: -- masehgal rounding off for CL
3553: ELSIF igf_sl_gen.chk_cl_fed_fund_code(l_fmast.fed_fund_code) = 'TRUE' THEN

Line 6099: l_alt_rel_code := igf_sl_award.get_alt_rel_code(l_fund_ld.fund_code);

6095: l_alt_rel_code := NULL;
6096:
6097: -- FACR116
6098: IF get_fed_fund_code(l_fund_ld.fund_id) = 'ALT' THEN
6099: l_alt_rel_code := igf_sl_award.get_alt_rel_code(l_fund_ld.fund_code);
6100: -- get the rel_code assosiated with the fund_code and check if the set up is present
6101: IF l_alt_rel_code IS NULL THEN
6102: fnd_message.set_name('IGF','IGF_AW_PROC_FUND');
6103: fnd_message.set_token('FUND',l_fund_ld.fund_code);

Line 6111: igf_sl_award.pick_setup(l_base_id,l_ci_cal_type,l_ci_sequence_number,l_rel_code,ln_person_id,l_party_id,l_alt_rel_code);

6107: lb_create_funds := FALSE;
6108: lb_elig_funds := FALSE;
6109: ELSE
6110: -- this will ensure whether that relationship code has a set up for the context award year
6111: igf_sl_award.pick_setup(l_base_id,l_ci_cal_type,l_ci_sequence_number,l_rel_code,ln_person_id,l_party_id,l_alt_rel_code);
6112: IF l_rel_code IS NULL AND l_party_id IS NULL THEN
6113: fnd_message.set_name('IGF','IGF_AW_PROC_FUND');
6114: fnd_message.set_token('FUND',l_fund_ld.fund_code);
6115: fnd_file.put_line(fnd_file.log,fnd_message.get);