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_AW_GEN_003

Line 412: IF NOT igf_aw_gen_003.check_coa(p_base_id,p_awd_prd_code) THEN

408: l_tot_teach_prds NUMBER;
409: l_tot_terms NUMBER;
410:
411: BEGIN
412: IF NOT igf_aw_gen_003.check_coa(p_base_id,p_awd_prd_code) THEN
413: OPEN c_term_wcoa(p_adplans_id,p_awd_prd_code);
414: FETCH c_term_wcoa INTO l_tot_teach_prds,l_tot_terms;
415: CLOSE c_term_wcoa;
416: ELSE

Line 3972: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Flag set - updating disb num 1 with disb date delayed by NSLDS offset: ' ||l_disb_date1);

3968: FETCH c_disb INTO l_disb;
3969: CLOSE c_disb;
3970:
3971: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3972: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen_003.create_auto_disb.debug','Flag set - updating disb num 1 with disb date delayed by NSLDS offset: ' ||l_disb_date1);
3973: END IF;
3974:
3975: igf_aw_awd_disb_pkg.update_row(
3976: x_mode => 'R',

Line 5987: igf_aw_gen_003.check_common_terms(NVL(l_fund_ld.adplans_id,g_plan_id),l_base_id,l_terms);

5983: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_fund_ld.adplans_id: '||l_fund_ld.adplans_id || 'g_plan_id : '||g_plan_id);
5984: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_fund_ld.max_num_disb: '||l_fund_ld.max_num_disb);
5985: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_fund_ld.min_num_disb: '||l_fund_ld.min_num_disb);
5986: END IF;
5987: igf_aw_gen_003.check_common_terms(NVL(l_fund_ld.adplans_id,g_plan_id),l_base_id,l_terms);
5988:
5989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'l_terms:'||l_terms);
5991: END IF;

Line 6000: IF igf_aw_gen_003.check_coa(l_base_id) = FALSE AND g_sf_packaging = 'T' AND NVL(g_allow_to_exceed,'*') = 'COA' THEN

5996: in single fund packaging, the allow_to_exceed is set to COA,
5997: then load the fund if the distribution plan is not 'Match COA'
5998: else dont load the fund
5999: */
6000: IF igf_aw_gen_003.check_coa(l_base_id) = FALSE AND g_sf_packaging = 'T' AND NVL(g_allow_to_exceed,'*') = 'COA' THEN
6001: --check the distribution type
6002: check_plan(NVL(l_fund_ld.adplans_id,g_plan_id),lv_result,lv_method_code);
6003: IF lv_result = 'TRUE' AND lv_method_code = 'C' THEN
6004: lb_create_funds := FALSE;

Line 7786: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN

7782: END IF;
7783:
7784: --Cbeck if student has valid COA in multiple fund packaging.if not error out
7785:
7786: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN
7787: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');
7788: fnd_file.put_line(fnd_file.log,fnd_message.get);
7789: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7790: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'no COA for '||l_person_number.person_number);

Line 7801: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN

7797:
7798: IF g_allow_to_exceed IS NULL THEN
7799: -- If COA Value is not set, then cannot proceed further
7800: -- Log a message and exit from the Job
7801: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN
7802:
7803: --get the plan name for the token
7804: get_plan_desc(g_plan_id,lv_name,lv_desc);
7805:

Line 7817: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN

7813: END IF;
7814:
7815: ELSIF g_allow_to_exceed = 'NEED' THEN
7816:
7817: IF NOT igf_aw_gen_003.check_coa(l_base_id,g_awd_prd) THEN
7818: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');
7819: fnd_file.put_line(fnd_file.log,fnd_message.get);
7820: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7821: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'no COA for '||l_person_number.person_number ||' and allow_to_exceed=NEED');

Line 9355: IF igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN

9351:
9352: --if student has no COA defined and g_allow_to_exceed is set to 'COA' in single_fund_packaging,call the pell wrapper with cp_called_from as 'PACKAGING_DP'
9353: --else call it with 'PACKAGING' as the wrapper needs to take care of the distribution
9354:
9355: IF igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN
9356: lb_coa_defined := TRUE;
9357: ELSE
9358: lb_coa_defined := FALSE;
9359: END IF;

Line 9706: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN -- COA Check

9702: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'fund code is FLP/DLP');
9703: END IF;
9704:
9705: --if student has coa defined
9706: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN -- COA Check
9707: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9708: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'student has no COA defined');
9709: END IF;
9710: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');

Line 9747: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN --COA Check

9743: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'fund code is not FLP/DLP');
9744: END IF;
9745:
9746: --if student has coa
9747: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN --COA Check
9748: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9749: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'student has no COA defined');
9750: END IF;
9751: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');

Line 9813: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN --COA Check

9809: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9810: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'since COA can be exceeded l_aid=fund max='||l_aid);
9811: END IF;
9812: ELSE
9813: IF NOT igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN --COA Check
9814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'student has no COA defined');
9816: END IF;
9817: fnd_message.set_name('IGF','IGF_AW_PK_COA_NULL');

Line 10215: IF igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN

10211:
10212: ln_award_perct := 0;
10213: IF lv_method_code = 'M' THEN
10214:
10215: IF igf_aw_gen_003.check_coa(l_fabase.base_id,g_awd_prd) THEN
10216:
10217: FOR c_get_term_prsnt_rec IN c_get_term_prsnt(l_fund.adplans_id, l_fabase.base_id) LOOP
10218: ln_award_perct := ln_award_perct + c_get_term_prsnt_rec.ld_perct_num;
10219: END LOOP;

Line 11512: igf_aw_gen_003.get_common_perct(l_awd_grp.adplans_id,l_fabase.base_id,ln_com_perct);

11508: -- Insert a new consolidated record into the temp table.
11509: -- These are the actual awards to the inserted in the igf_aw_award and igf_aw_awd_disb
11510:
11511: ln_com_perct := 100;
11512: igf_aw_gen_003.get_common_perct(l_awd_grp.adplans_id,l_fabase.base_id,ln_com_perct);
11513:
11514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
11515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'Before inserting with FL flag in the temp, ln_com_perct : '||ln_com_perct
11516: ||' l_awd_grp.fund_id:'||l_awd_grp.fund_id

Line 12161: IF igf_aw_gen_003.check_coa(l_base_id) = FALSE AND g_sf_packaging = 'T' AND g_allow_to_exceed = 'COA' THEN

12157:
12158: /*
12159: check if the student has COA or not and set a flag specifying what cursor should be used
12160: */
12161: IF igf_aw_gen_003.check_coa(l_base_id) = FALSE AND g_sf_packaging = 'T' AND g_allow_to_exceed = 'COA' THEN
12162: IF lv_method_code IN ('M','E') THEN
12163: lb_use_wcoa_cur := TRUE;
12164: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12165: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'have to use alternate cursor for base_id:'||l_base_id||' and adplans_id:'||l_adplans_id);

Line 12193: OPEN c_auto_disb_equal(l_adplans_id,l_base_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));

12189: FETCH cur_terms_count INTO l_terms_count;
12190: CLOSE cur_terms_count;
12191:
12192: IF lb_use_wcoa_cur = FALSE THEN
12193: OPEN c_auto_disb_equal(l_adplans_id,l_base_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));
12194: FETCH c_auto_disb_equal INTO l_tp_perct;
12195: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'opened and fetched cursor c_auto_disb_equal');
12197: END IF;

Line 12200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'igf_aw_gen_003.get_plan_disb_count('||l_adplans_id||'):'||igf_aw_gen_003.get_plan_disb_count(l_adplans_id));

12196: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'opened and fetched cursor c_auto_disb_equal');
12197: END IF;
12198: ELSE
12199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'igf_aw_gen_003.get_plan_disb_count('||l_adplans_id||'):'||igf_aw_gen_003.get_plan_disb_count(l_adplans_id));
12201: END IF;
12202: OPEN c_auto_disb_equal_wcoa(l_base_id,l_adplans_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));
12203: FETCH c_auto_disb_equal_wcoa INTO l_tp_perct;
12204: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 12202: OPEN c_auto_disb_equal_wcoa(l_base_id,l_adplans_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));

12198: ELSE
12199: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12200: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'igf_aw_gen_003.get_plan_disb_count('||l_adplans_id||'):'||igf_aw_gen_003.get_plan_disb_count(l_adplans_id));
12201: END IF;
12202: OPEN c_auto_disb_equal_wcoa(l_base_id,l_adplans_id,igf_aw_gen_003.get_plan_disb_count(l_adplans_id, g_awd_prd));
12203: FETCH c_auto_disb_equal_wcoa INTO l_tp_perct;
12204: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
12205: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.get_disbursements.debug '|| g_req_id,'opened and fetched cursor c_auto_disb_equal_wcoa');
12206: END IF;