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_COA_CALC dependencies on IGF_AW_GEN

Line 114: igf_aw_gen_002.get_resource_need(

110: l_resource_i_fc NUMBER;
111:
112: BEGIN
113:
114: igf_aw_gen_002.get_resource_need(
115: p_base_id,
116: l_resource_f,
117: l_resource_i,
118: l_unmet_need_f,

Line 1704: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER'),15)

1700: g_b_header := FALSE;
1701: END IF;
1702:
1703: fnd_file.new_line(fnd_file.output,1);
1704: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER'),15)
1705: ||LPAD(igf_gr_gen.get_per_num(p_base_id),15));
1706: fnd_file.new_line(fnd_file.output,1);
1707:
1708:

Line 1709: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','TERM'),30)

1705: ||LPAD(igf_gr_gen.get_per_num(p_base_id),15));
1706: fnd_file.new_line(fnd_file.output,1);
1707:
1708:
1709: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','TERM'),30)
1710: || LPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TP_TOT'),30));
1711: FOR c_out_file_rec IN c_out_file(p_base_id) LOOP
1712: fnd_file.put_line(fnd_file.output,RPAD(c_out_file_rec.term,30)
1713: ||LPAD(TO_CHAR(c_out_file_rec.amount,'FM9999999990D90'),30));

Line 1710: || LPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TP_TOT'),30));

1706: fnd_file.new_line(fnd_file.output,1);
1707:
1708:
1709: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','TERM'),30)
1710: || LPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TP_TOT'),30));
1711: FOR c_out_file_rec IN c_out_file(p_base_id) LOOP
1712: fnd_file.put_line(fnd_file.output,RPAD(c_out_file_rec.term,30)
1713: ||LPAD(TO_CHAR(c_out_file_rec.amount,'FM9999999990D90'),30));
1714: END LOOP;

Line 1720: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TOT'),30)

1716: OPEN c_total_coa(p_base_id);
1717: FETCH c_total_coa INTO c_total_coa_rec;
1718: fnd_file.new_line(fnd_file.output,1);
1719: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));
1720: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','COA_TOT'),30)
1721: ||LPAD(TO_CHAR(c_total_coa_rec.total,'FM9999999990D90'),30));
1722: CLOSE c_total_coa;
1723:
1724: fnd_file.put_line(fnd_file.output,RPAD('-',60,'-'));

Line 1871: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.process_student.debug','calling igf_aw_gen_003.updating_coa_in_fa_base');

1867: CLOSE cur_per_coa;
1868:
1869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.process_student.debug','add_coa_items_returned lv_result:'||lv_result);
1871: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.process_student.debug','calling igf_aw_gen_003.updating_coa_in_fa_base');
1872: END IF;
1873: igf_aw_gen_003.updating_coa_in_fa_base(p_base_id);
1874:
1875: IF lv_result = 'Y' AND g_coa_updated = 'Y' THEN

Line 1873: igf_aw_gen_003.updating_coa_in_fa_base(p_base_id);

1869: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1870: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.process_student.debug','add_coa_items_returned lv_result:'||lv_result);
1871: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.process_student.debug','calling igf_aw_gen_003.updating_coa_in_fa_base');
1872: END IF;
1873: igf_aw_gen_003.updating_coa_in_fa_base(p_base_id);
1874:
1875: IF lv_result = 'Y' AND g_coa_updated = 'Y' THEN
1876: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1877: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_calc.process_student.debug','calling print_output_file, and checking overaward');

Line 2004: --tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);

2000: -- Modified By : gmuralid
2001: --Change History:
2002: --Who When What
2003: --ridas 08-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in call to igf_ap_ss_pkg.get_pid
2004: --tsailaja 13/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
2005: --veramach 08-Jan-2004 FA CCR 118 COA Updates
2006: -- Added 2 new parameters p_update_coa and p_update_method
2007: -- Added validations on the 2 new parameters
2008: --------------------------------------------------------------------------------

Line 2066: igf_aw_gen.set_org_id(NULL);

2062: ln_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
2063: lv_err_msg fnd_new_messages.message_name%TYPE;
2064:
2065: BEGIN
2066: igf_aw_gen.set_org_id(NULL);
2067: retcode := 0;
2068: errbuf := NULL;
2069: g_b_header := TRUE;
2070: l_ci_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10)));

Line 2092: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));

2088: END IF;
2089:
2090: fnd_file.new_line(fnd_file.log,1);
2091:
2092: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2093: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);
2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;

Line 2093: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));

2089:
2090: fnd_file.new_line(fnd_file.log,1);
2091:
2092: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2093: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);
2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;

Line 2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);

2090: fnd_file.new_line(fnd_file.log,1);
2091:
2092: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS'));
2093: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWARD_YEAR'),60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));
2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);
2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);

Line 2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);

2094: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_AP_RULE','GROUP_CODE'),60) || p_grp_code);
2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);
2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
2100: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_COA'),60) || p_update_coa);
2101: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_METHOD'),60) || igf_aw_gen.lookup_desc('IGF_AW_COA_UPD_MTHD',p_update_method));
2102:

Line 2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));

2095: OPEN c_group_code(p_pergrp_id);
2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);
2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
2100: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_COA'),60) || p_update_coa);
2101: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_METHOD'),60) || igf_aw_gen.lookup_desc('IGF_AW_COA_UPD_MTHD',p_update_method));
2102:
2103: fnd_file.new_line(fnd_file.log,2);

Line 2100: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_COA'),60) || p_update_coa);

2096: FETCH c_group_code INTO c_grp_cd;
2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);
2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
2100: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_COA'),60) || p_update_coa);
2101: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_METHOD'),60) || igf_aw_gen.lookup_desc('IGF_AW_COA_UPD_MTHD',p_update_method));
2102:
2103: fnd_file.new_line(fnd_file.log,2);
2104: fnd_message.set_name('IGF','IGF_AW_PROCESS_COA_CAL');

Line 2101: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_METHOD'),60) || igf_aw_gen.lookup_desc('IGF_AW_COA_UPD_MTHD',p_update_method));

2097: CLOSE c_group_code;
2098: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'),60) || c_grp_cd.group_cd);
2099: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),60) || igf_gr_gen.get_per_num(p_base_id));
2100: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_COA'),60) || p_update_coa);
2101: fnd_file.put_line(fnd_file.log,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','UPDATE_METHOD'),60) || igf_aw_gen.lookup_desc('IGF_AW_COA_UPD_MTHD',p_update_method));
2102:
2103: fnd_file.new_line(fnd_file.log,2);
2104: fnd_message.set_name('IGF','IGF_AW_PROCESS_COA_CAL');
2105: fnd_file.put_line(fnd_file.log,RPAD(fnd_message.get,60) || igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number));