DBA Data[Home] [Help]

APPS.IGF_SL_DL_PRINT_MANIFEST dependencies on IGF_AW_GEN

Line 135: igf_aw_gen.set_org_id(p_org_id);

131:
132: BEGIN
133:
134: RETCODE := 0;
135: igf_aw_gen.set_org_id(p_org_id);
136:
137:
138: l_ci_cal_type := ltrim(rtrim(SUBSTR(p_award_year,1,10)));
139: l_ci_sequence_number := ltrim(rtrim(SUBSTR(p_award_year,11)));

Line 142: l_heading :=igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');

138: l_ci_cal_type := ltrim(rtrim(SUBSTR(p_award_year,1,10)));
139: l_ci_sequence_number := ltrim(rtrim(SUBSTR(p_award_year,11)));
140:
141: l_alternate_code :=igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
142: l_heading :=igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
143:
144: l_log_mesg :=igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS');
145: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
146:

Line 144: l_log_mesg :=igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS');

140:
141: l_alternate_code :=igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
142: l_heading :=igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
143:
144: l_log_mesg :=igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS');
145: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
146:
147: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CI_ALTERNATE_CODE'),80,' ') ||':'||RPAD(' ',4,' ')||l_alternate_code ;
148: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);

Line 147: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CI_ALTERNATE_CODE'),80,' ') ||':'||RPAD(' ',4,' ')||l_alternate_code ;

143:
144: l_log_mesg :=igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PARAMETER_PASS');
145: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
146:
147: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CI_ALTERNATE_CODE'),80,' ') ||':'||RPAD(' ',4,' ')||l_alternate_code ;
148: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
149:
150: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_CATG'),80,' ')||':'||RPAD(' ',4,' ')||
151: igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_loan_catg) ;

Line 150: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_CATG'),80,' ')||':'||RPAD(' ',4,' ')||

146:
147: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CI_ALTERNATE_CODE'),80,' ') ||':'||RPAD(' ',4,' ')||l_alternate_code ;
148: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
149:
150: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_CATG'),80,' ')||':'||RPAD(' ',4,' ')||
151: igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_loan_catg) ;
152: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
153:
154: --Display the Person Number for the Base ID

Line 151: igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_loan_catg) ;

147: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CI_ALTERNATE_CODE'),80,' ') ||':'||RPAD(' ',4,' ')||l_alternate_code ;
148: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
149:
150: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAN_CATG'),80,' ')||':'||RPAD(' ',4,' ')||
151: igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_loan_catg) ;
152: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
153:
154: --Display the Person Number for the Base ID
155: l_person_num :=NULL;

Line 159: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),80,' ')||':'||RPAD(' ',4,' ')||l_person_num ;

155: l_person_num :=NULL;
156: IF l_person_id IS NOT NULL THEN
157: l_person_num:=igf_gr_gen.get_per_num_oss(l_person_id);
158: END IF;
159: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),80,' ')||':'||RPAD(' ',4,' ')||l_person_num ;
160: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
161:
162: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER'),80)||':'||p_loan_number;
163: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);

Line 162: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER'),80)||':'||p_loan_number;

158: END IF;
159: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),80,' ')||':'||RPAD(' ',4,' ')||l_person_num ;
160: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
161:
162: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER'),80)||':'||p_loan_number;
163: FND_FILE.PUT_LINE(FND_FILE.LOG, l_log_mesg);
164:
165: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
166: