DBA Data[Home] [Help]

APPS.IGF_AW_RULE dependencies on FND_FILE

Line 136: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

132:
133:
134: /* Print the Parameters Passed */
135:
136: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass);-- -----------Parameters Passed--------------
138: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_years,35) || ' :'||l_alternate_code);
139: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GRP'),35) || ' :'||p_grp_code);
140: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l1_person_number,35) || ' :'||lv_desc);

Line 137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass);-- -----------Parameters Passed--------------

133:
134: /* Print the Parameters Passed */
135:
136: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass);-- -----------Parameters Passed--------------
138: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_years,35) || ' :'||l_alternate_code);
139: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GRP'),35) || ' :'||p_grp_code);
140: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l1_person_number,35) || ' :'||lv_desc);
141: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

Line 138: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_years,35) || ' :'||l_alternate_code);

134: /* Print the Parameters Passed */
135:
136: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass);-- -----------Parameters Passed--------------
138: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_years,35) || ' :'||l_alternate_code);
139: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GRP'),35) || ' :'||p_grp_code);
140: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l1_person_number,35) || ' :'||lv_desc);
141: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
142:

Line 139: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GRP'),35) || ' :'||p_grp_code);

135:
136: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass);-- -----------Parameters Passed--------------
138: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_years,35) || ' :'||l_alternate_code);
139: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GRP'),35) || ' :'||p_grp_code);
140: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l1_person_number,35) || ' :'||lv_desc);
141: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
142:
143: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROC_AWD');

Line 140: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l1_person_number,35) || ' :'||lv_desc);

136: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass);-- -----------Parameters Passed--------------
138: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_years,35) || ' :'||l_alternate_code);
139: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GRP'),35) || ' :'||p_grp_code);
140: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l1_person_number,35) || ' :'||lv_desc);
141: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
142:
143: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROC_AWD');
144: FND_MESSAGE.SET_TOKEN('AWD_YR',l_alternate_code);

Line 141: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

137: FND_FILE.PUT_LINE(FND_FILE.LOG,l_para_pass);-- -----------Parameters Passed--------------
138: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l_award_years,35) || ' :'||l_alternate_code);
139: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','AWD_GRP'),35) || ' :'||p_grp_code);
140: FND_FILE.PUT_LINE(FND_FILE.LOG,RPAD(l1_person_number,35) || ' :'||lv_desc);
141: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
142:
143: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROC_AWD');
144: FND_MESSAGE.SET_TOKEN('AWD_YR',l_alternate_code);
145: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 145: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

141: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
142:
143: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROC_AWD');
144: FND_MESSAGE.SET_TOKEN('AWD_YR',l_alternate_code);
145: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
146:
147: tgroup_rule(l_ci_cal_type ,
148: l_ci_sequence_NUMBER ,
149: p_pergrp_id ,

Line 286: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

282: OPEN get_grp_desc(p_pergrp_id);
283: FETCH get_grp_desc into lv_desc;
284: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PERSON_ID_GROUP');
285: FND_MESSAGE.SET_TOKEN('P_PER_GRP',lv_desc);
286: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
287: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
288: CLOSE get_grp_desc;
289: END IF;
290:

Line 287: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

283: FETCH get_grp_desc into lv_desc;
284: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PERSON_ID_GROUP');
285: FND_MESSAGE.SET_TOKEN('P_PER_GRP',lv_desc);
286: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
287: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
288: CLOSE get_grp_desc;
289: END IF;
290:
291:

Line 318: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get());

314:
315: FETCH c_stud INTO l_stud ;
316: IF c_stud%NOTFOUND AND c_stud%ROWCOUNT = 0 THEN
317: FND_MESSAGE.SET_NAME('IGF','IGF_DB_NO_PER_GRP');
318: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get());
319: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
320: CLOSE c_stud;
321: RETURN ;
322: ELSE

Line 319: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

315: FETCH c_stud INTO l_stud ;
316: IF c_stud%NOTFOUND AND c_stud%ROWCOUNT = 0 THEN
317: FND_MESSAGE.SET_NAME('IGF','IGF_DB_NO_PER_GRP');
318: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get());
319: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
320: CLOSE c_stud;
321: RETURN ;
322: ELSE
323: EXIT WHEN c_stud%notfound ;

Line 338: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get());

334:
335: FND_MESSAGE.SET_NAME('IGF','IGF_GR_LI_PER_INVALID');
336: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_stud.party_number);
337: FND_MESSAGE.SET_TOKEN('AWD_YR',l_alternate_code);
338: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get());
339: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
340:
341: ln_counter := 1;
342: END IF;

Line 339: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

335: FND_MESSAGE.SET_NAME('IGF','IGF_GR_LI_PER_INVALID');
336: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_stud.party_number);
337: FND_MESSAGE.SET_TOKEN('AWD_YR',l_alternate_code);
338: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get());
339: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
340:
341: ln_counter := 1;
342: END IF;
343: CLOSE c_get_base_id;

Line 385: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

381: IF l_check_group.target_group = p_grp_code THEN
382: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROC_GRP_CD_ALRDY_ASGND');
383: FND_MESSAGE.SET_TOKEN('GRP_CODE',p_grp_code);
384: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_person_number);
385: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
386: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
387: ELSE
388: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROCESS_GRP_CODE');
389: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_person_number);

Line 386: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

382: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROC_GRP_CD_ALRDY_ASGND');
383: FND_MESSAGE.SET_TOKEN('GRP_CODE',p_grp_code);
384: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_person_number);
385: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
386: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
387: ELSE
388: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROCESS_GRP_CODE');
389: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_person_number);
390: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 390: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

386: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
387: ELSE
388: FND_MESSAGE.SET_NAME('IGF','IGF_AW_PROCESS_GRP_CODE');
389: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_person_number);
390: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
391:
392: IF NVL(l_fabase.lock_awd_flag,'N') = 'N' THEN
393: igf_ap_fa_base_rec_pkg.update_row(
394: x_rowid => l_fabase.row_id,

Line 512: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

508:
509: FND_MESSAGE.SET_NAME('IGF','IGF_AW_GRP_ASSIGN_STUD');
510: FND_MESSAGE.SET_TOKEN('GRP_CODE',p_grp_code);
511: FND_MESSAGE.SET_TOKEN('PERSON',l_person_number);
512: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
513:
514: FND_MESSAGE.SET_NAME('IGF','IGF_AW_GRP_ASSIGN_COMP');
515: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_person_number);
516: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 516: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

512: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
513:
514: FND_MESSAGE.SET_NAME('IGF','IGF_AW_GRP_ASSIGN_COMP');
515: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_person_number);
516: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
517: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
518: ELSE
519: FND_MESSAGE.SET_NAME('IGF','IGF_AW_LOCK');
520: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

Line 517: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

513:
514: FND_MESSAGE.SET_NAME('IGF','IGF_AW_GRP_ASSIGN_COMP');
515: FND_MESSAGE.SET_TOKEN('PERSON_NUMBER',l_person_number);
516: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
517: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
518: ELSE
519: FND_MESSAGE.SET_NAME('IGF','IGF_AW_LOCK');
520: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
521: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

Line 520: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

516: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
517: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
518: ELSE
519: FND_MESSAGE.SET_NAME('IGF','IGF_AW_LOCK');
520: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
521: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
522: END IF;
523: END IF;
524:

Line 521: FND_FILE.PUT_LINE(FND_FILE.LOG,'');

517: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
518: ELSE
519: FND_MESSAGE.SET_NAME('IGF','IGF_AW_LOCK');
520: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
521: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
522: END IF;
523: END IF;
524:
525: EXIT ;

Line 548: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

544: FND_MESSAGE.SET_TOKEN('NAME','IGF_AW_RULE.tgroup_rule' || SQLERRM);
545: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
546: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_aw_rule.tgroup_rule.exception','sql error:'||SQLERRM);
547: END IF;
548: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
549:
550: END tgroup_rule ;
551: END IGF_AW_RULE;