DBA Data[Home] [Help]

APPS.IGF_SL_LAR_CREATION dependencies on IGF_AW_GEN

Line 730: g_log_title := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','AWARD_ID')||' : ';

726: IF g_log_start_flag = FALSE THEN
727: fnd_file.new_line(fnd_file.log,1);
728:
729: IF g_log_title IS NULL THEN
730: g_log_title := igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','AWARD_ID')||' : ';
731: END IF;
732:
733: fnd_file.put_line(fnd_file.log, g_log_title||TO_CHAR(p_award_id));
734: g_log_start_flag := TRUE;

Line 2100: loan_title := igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING') || ' ' || igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS', 'LOAN_NUMBER') || ' :' || cur_loan_rec.loan_number;

2096: BEGIN
2097:
2098: SAVEPOINT IGFSL01B_SP2;
2099:
2100: loan_title := igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PROCESSING') || ' ' || igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS', 'LOAN_NUMBER') || ' :' || cur_loan_rec.loan_number;
2101:
2102: fnd_file.put_line(fnd_file.log, loan_title);
2103:
2104: g_adplans_id := cur_loan_rec.adplans_id;

Line 2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);

2972: l_head := 'Y';
2973: END IF;
2974:
2975: fnd_file.new_line(fnd_file.output,1);
2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);
2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);
2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);
2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);
2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);

Line 2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);

2975: fnd_file.new_line(fnd_file.output,1);
2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);
2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);
2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);
2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);
2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);
2981:
2982: -- Reassign Y that loan records are found
2983: IF l_found_loans <> 'Y' THEN

Line 2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);

2976: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','FUND_CODE'),40,' ')||': '||award_rec.fund_code||'-'||award_rec.description);
2977: fnd_file.put_line(fnd_file.output,RPAD(g_person_log,40,' ')||': '||award_rec.person_number);
2978: fnd_file.put_line(fnd_file.output,RPAD(g_award_log,40,' ')||': '||award_rec.award_id);
2979: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'),40,' ')||': '||lv_loan_number);
2980: fnd_file.put_line(fnd_file.output,RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_AMT_OFFERED'),40,' ')||': '||award_rec.accepted_amt);
2981:
2982: -- Reassign Y that loan records are found
2983: IF l_found_loans <> 'Y' THEN
2984: l_found_loans := 'Y';

Line 3117: tsailaja 15/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);

3113: Change History :
3114: Bug 2367953 Modify Parameters in Loans Process
3115: Who When What
3116: ridas 08-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in call to igf_ap_ss_pkg.get_pid
3117: tsailaja 15/Jan/2006 Bug 4947880 Added invocation of igf_aw_gen.set_org_id(NULL);
3118: bkkumar 04-04-04 FACR116 - Added a savepoint so that if the insert_lor procedures raises an
3119: exception then we have to rollback and display the appropriate message
3120: bkkumar 14-Jan-04 Bug# 3360702
3121: Passed the l_aid paramter as 0 to the check_loan_limits and also displayed the

Line 3270: igf_aw_gen.set_org_id(NULL);

3266: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
3267:
3268: BEGIN
3269:
3270: igf_aw_gen.set_org_id(NULL);
3271: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3272: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.main.debug','Start of main');
3273: END IF;
3274:

Line 3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));

3330: g_year := l_para_rec(2);
3331: fnd_file.new_line(fnd_file.log,2);
3332: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(5),50,' '));
3333: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(2),30,' ')||':'||RPAD(' ',4,' ')||g_alternate_code);
3334: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(9),30,' ')||':'||RPAD(' ',4,' ')||igf_aw_gen.lookup_desc('IGF_SL_CL_SLJ01_RUN_MODE',p_run_mode));
3335: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(3),30,' ')||':'||RPAD(' ',4,' ')||get_fund_desc(p_fund_id));
3336: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(7),30,' ')||':'||RPAD(' ',4,' ')||igf_gr_gen.get_per_num(p_base_id)); -- person nunmber
3337: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(1),30,' ')||':'||RPAD(' ',4,' ')||p_award_id);
3338: fnd_file.put_line(fnd_file.log,RPAD(l_para_rec(6),30,' ')||':'||RPAD(' ',4,' ')||get_grp_name(p_dyn_pid_grp));

Line 3410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));

3406: -- FA134
3407:
3408: IF p_dyn_pid_grp IS NOT NULL AND p_base_id IS NOT NULL THEN
3409: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
3410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
3411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
3412: fnd_file.put_line(fnd_file.log, fnd_message.get);
3413: fnd_file.new_line(fnd_file.log, 1);
3414: RETURN;

Line 3411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));

3407:
3408: IF p_dyn_pid_grp IS NOT NULL AND p_base_id IS NOT NULL THEN
3409: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
3410: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
3411: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'));
3412: fnd_file.put_line(fnd_file.log, fnd_message.get);
3413: fnd_file.new_line(fnd_file.log, 1);
3414: RETURN;
3415: END IF;

Line 3423: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));

3419: END IF;
3420:
3421: IF p_dyn_pid_grp IS NOT NULL AND p_award_id IS NOT NULL THEN
3422: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
3423: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
3424: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
3425: fnd_file.put_line(fnd_file.log, fnd_message.get);
3426: fnd_file.new_line(fnd_file.log, 1);
3427: RETURN;

Line 3424: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));

3420:
3421: IF p_dyn_pid_grp IS NOT NULL AND p_award_id IS NOT NULL THEN
3422: fnd_message.set_name('IGF','IGF_SL_COD_INV_PARAM');
3423: fnd_message.set_token('PARAM1',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_ID_GROUP'));
3424: fnd_message.set_token('PARAM2',igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_NUMBER'));
3425: fnd_file.put_line(fnd_file.log, fnd_message.get);
3426: fnd_file.new_line(fnd_file.log, 1);
3427: RETURN;
3428: END IF;