DBA Data[Home] [Help]

APPS.IGF_AW_PACKAGING dependencies on IGF_AW_GEN_005

Line 5971: IF igf_aw_gen_005.get_stud_hold_effect( 'A', l_person_id, l_fund_ld.fund_code ) = 'F' THEN

5967:
5968: END IF;
5969:
5970: -- Check whether the fund can be awarded to the Person, if not skip the fund
5971: IF igf_aw_gen_005.get_stud_hold_effect( 'A', l_person_id, l_fund_ld.fund_code ) = 'F' THEN
5972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'after c_remv_funds cursor loop,igf_aw_gen_005.get_stud_hold_effect(A,'||l_person_id||','||l_fund_ld.fund_code||'=F');
5974: END IF;
5975: fnd_message.set_name('IGF','IGF_AW_AWD_FUND_HOLD_FAIL');

Line 5973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'after c_remv_funds cursor loop,igf_aw_gen_005.get_stud_hold_effect(A,'||l_person_id||','||l_fund_ld.fund_code||'=F');

5969:
5970: -- Check whether the fund can be awarded to the Person, if not skip the fund
5971: IF igf_aw_gen_005.get_stud_hold_effect( 'A', l_person_id, l_fund_ld.fund_code ) = 'F' THEN
5972: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5973: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,'after c_remv_funds cursor loop,igf_aw_gen_005.get_stud_hold_effect(A,'||l_person_id||','||l_fund_ld.fund_code||'=F');
5974: END IF;
5975: fnd_message.set_name('IGF','IGF_AW_AWD_FUND_HOLD_FAIL');
5976: fnd_message.set_token('FUND',l_fund_ld.fund_code);
5977: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 7760: IF igf_aw_gen_005.validate_student_efc(l_base_id,g_awd_prd) = 'F' THEN

7756:
7757:
7758: -- Check for the valid EFC of the student. If no valid EFC, show message and stop processing
7759: IF g_sf_packaging <> 'T' THEN
7760: IF igf_aw_gen_005.validate_student_efc(l_base_id,g_awd_prd) = 'F' THEN
7761: fnd_message.set_name('IGF','IGF_AW_NO_VALID_EFC');
7762: fnd_message.set_token('STDNT', l_pers_num );
7763: fnd_file.put_line(fnd_file.log,fnd_message.get);
7764: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 7849: IF igf_aw_gen_005.get_stud_hold_effect('A', l_fabase.person_id, NULL ) = 'F' THEN

7845: FETCH c_fabase INTO l_fabase;
7846: EXIT WHEN c_fabase%NOTFOUND;
7847:
7848: -- Check whether are there any package hold are present at the student level, if not continue the packaging
7849: IF igf_aw_gen_005.get_stud_hold_effect('A', l_fabase.person_id, NULL ) = 'F' THEN
7850: fnd_message.set_name('IGF','IGF_AW_AWD_PACK_HOLD_FAIL');
7851: fnd_file.put_line(fnd_file.log,fnd_message.get);
7852: CLOSE c_fabase;
7853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 7854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'igf_aw_gen_005.get_stud_hold_effect(A,'||l_fabase.person_id||',NULL=F');

7850: fnd_message.set_name('IGF','IGF_AW_AWD_PACK_HOLD_FAIL');
7851: fnd_file.put_line(fnd_file.log,fnd_message.get);
7852: CLOSE c_fabase;
7853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
7854: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'igf_aw_gen_005.get_stud_hold_effect(A,'||l_fabase.person_id||',NULL=F');
7855: END IF;
7856: RETURN;
7857: END IF;
7858: