DBA Data[Home] [Help]

APPS.IGF_AP_LG_COA_IMP dependencies on IGF_AP_GEN

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

49: OPEN c_batch_desc( p_batch_num) ;
50: FETCH c_batch_desc INTO l_batch_desc, l_batch_type ;
51: CLOSE c_batch_desc ;
52:
53: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
54: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
55: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
56: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
57: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);

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

50: FETCH c_batch_desc INTO l_batch_desc, l_batch_type ;
51: CLOSE c_batch_desc ;
52:
53: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
54: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
55: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
56: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
57: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
58: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');

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

51: CLOSE c_batch_desc ;
52:
53: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
54: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
55: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
56: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
57: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
58: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
59:

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

52:
53: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
54: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
55: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
56: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
57: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
58: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
59:
60: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

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

53: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
54: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
55: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
56: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
57: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
58: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
59:
60: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
61: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');

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

54: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
55: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
56: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
57: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
58: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
59:
60: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
61: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
62: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

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

541: igf_aw_gen.set_org_id(NULL);
542: errbuf := NULL;
543: retcode := 0;
544: l_prof_set := 'N' ;
545: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
546: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
547:
548:
549: -- Check if the following profiles are set

Line 546: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');

542: errbuf := NULL;
543: retcode := 0;
544: l_prof_set := 'N' ;
545: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
546: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
547:
548:
549: -- Check if the following profiles are set
550: l_prof_set := igf_ap_gen.check_profile ;

Line 550: l_prof_set := igf_ap_gen.check_profile ;

546: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
547:
548:
549: -- Check if the following profiles are set
550: l_prof_set := igf_ap_gen.check_profile ;
551:
552: IF l_prof_set = 'Y' THEN
553: -- profiles properly set ....... proceed
554: /**************************

Line 607: l_batch_valid := igf_ap_gen.check_batch ( p_batch_num, 'COA') ;

603: END IF ; -- setup check in interface table
604: CLOSE c_chk_coa ;
605:
606: -- check validity of batch
607: l_batch_valid := igf_ap_gen.check_batch ( p_batch_num, 'COA') ;
608: IF NVL(l_batch_valid,'N') <> 'Y' THEN
609: FND_MESSAGE.SET_NAME('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
610: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
611: g_terminate_process := TRUE ;

Line 725: igf_ap_gen.check_person ( person_rec.person_number, g_ci_cal_type, g_ci_sequence_number,

721: l_old_item := NULL ;
722: l_recs_deleted := FALSE ;
723:
724: -- call procedure to check person existence and fa base rec existence
725: igf_ap_gen.check_person ( person_rec.person_number, g_ci_cal_type, g_ci_sequence_number,
726: l_person_id, l_fa_base_id) ;
727:
728: IF l_person_id IS NULL THEN
729:

Line 819: l_term_chk := igf_ap_gen.validate_cal_inst( 'LOAD', l_alternate_code, person_rec.ld_alternate_code,

815: /* End of COA Existence Check */
816: /******************************************
817: COA ITEM Instance related Checks
818: *******************************************/
819: l_term_chk := igf_ap_gen.validate_cal_inst( 'LOAD', l_alternate_code, person_rec.ld_alternate_code,
820: l_load_cal_type, l_load_seq_num) ;
821:
822: IF (l_load_cal_type IS NULL OR l_load_seq_num IS NULL) THEN
823: FND_MESSAGE.SET_NAME('IGF','IGF_AP_INVALID_TERM');