DBA Data[Home] [Help]

APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on IGF_AP_GEN

Line 3007: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');

3003: OPEN c_get_message('IGS_GE_ASK_DEL_REC');
3004: FETCH c_get_message INTO l_delete_flag_prmpt;
3005: CLOSE c_get_message;
3006:
3007: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3008: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3009: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
3010: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
3011: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);

Line 3008: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');

3004: FETCH c_get_message INTO l_delete_flag_prmpt;
3005: CLOSE c_get_message;
3006:
3007: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3008: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3009: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
3010: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
3011: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
3012: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');

Line 3009: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');

3005: CLOSE c_get_message;
3006:
3007: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3008: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3009: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
3010: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
3011: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
3012: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
3013:

Line 3010: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');

3006:
3007: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3008: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3009: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
3010: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
3011: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
3012: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
3013:
3014: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

Line 3011: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);

3007: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3008: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3009: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
3010: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
3011: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
3012: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
3013:
3014: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3015: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');

Line 3012: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');

3008: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3009: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
3010: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
3011: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
3012: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
3013:
3014: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
3015: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
3016: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

Line 5950: l_ret_profile:=igf_ap_gen.check_profile;

5946:
5947: -- Log input params
5948: log_input_params( p_batch_id, l_alternate_code , p_del_int);
5949:
5950: l_ret_profile:=igf_ap_gen.check_profile;
5951: IF l_ret_profile <> 'Y' THEN
5952: -- check if country code is not'US' AND does not participate in financial aidprogram THEN
5953: -- write into the log file and exit process
5954: fnd_file.put(fnd_file.log,c_lkup_values_err_rec.meaning ||' ');

Line 6007: l_batch_valid := igf_ap_gen.check_batch ( p_batch_id, 'PROFILE') ;

6003: END IF ; -- awd ye open or legacy detail chk
6004: END IF ; -- award year invalid check
6005: CLOSE c_get_stat ;
6006: -- check validity of batch
6007: l_batch_valid := igf_ap_gen.check_batch ( p_batch_id, 'PROFILE') ;
6008:
6009: IF p_css_import <> 'Y' THEN
6010: IF NVL(l_batch_valid,'N') <> 'Y' THEN
6011: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');

Line 6078: igf_ap_gen.check_person ( lv_person_number,l_ci_cal_type,l_ci_sequence_number,lv_person_id,lv_fa_base_id );

6074: lv_person_id := NULL;
6075: l_value := NULL;
6076: IF NVL(p_css_import,'N') <> 'Y' THEN
6077: lv_person_number:=c_int_data_rec.person_number;
6078: igf_ap_gen.check_person ( lv_person_number,l_ci_cal_type,l_ci_sequence_number,lv_person_id,lv_fa_base_id );
6079: ELSE
6080: lv_ssn := remove_spl_chr(c_int_data_rec.social_security_num) ;
6081: IF lv_ssn is NOT NULL THEN
6082: OPEN c_get_person_id(lv_ssn);