DBA Data[Home] [Help]

APPS.IGF_AP_MK_ISIR_ACT_PKG dependencies on IGF_AP_GEN

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

933: retcode := 0;
934: l_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10)));
935: l_seq_number := TO_NUMBER(SUBSTR(p_award_year,11));
936:
937: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
938: l_chk_profile := igf_ap_gen.check_profile;
939: IF l_chk_profile = 'N' THEN
940: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
941: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

Line 938: l_chk_profile := igf_ap_gen.check_profile;

934: l_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10)));
935: l_seq_number := TO_NUMBER(SUBSTR(p_award_year,11));
936:
937: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
938: l_chk_profile := igf_ap_gen.check_profile;
939: IF l_chk_profile = 'N' THEN
940: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
941: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
942: RETURN;

Line 945: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'ISIR');

941: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
942: RETURN;
943: END IF;
944:
945: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'ISIR');
946: IF l_chk_batch = 'N' THEN
947: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
948: add_log_table_process(NULL,l_error,fnd_message.get);
949: l_terminate_flag := TRUE;

Line 996: igf_ap_gen.check_person(l_get_records.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);

992: -- here the check is there to see if the person number is repetitive so skip the person
993: IF NOT check_dup_person(l_get_records.person_number) THEN
994: lv_base_id := NULL;
995: lv_person_id := NULL;
996: igf_ap_gen.check_person(l_get_records.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
997: IF lv_person_id IS NULL THEN
998: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
999: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
1000: l_error_flag := TRUE;

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

1694: l_get_batch_desc c_get_batch_desc%ROWTYPE;
1695:
1696: BEGIN
1697:
1698: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
1699: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
1700: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
1701: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
1702:

Line 1699: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');

1695:
1696: BEGIN
1697:
1698: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
1699: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
1700: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
1701: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
1702:
1703: OPEN c_get_batch_desc(p_batch_id);

Line 1700: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');

1696: BEGIN
1697:
1698: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
1699: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
1700: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
1701: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
1702:
1703: OPEN c_get_batch_desc(p_batch_id);
1704: FETCH c_get_batch_desc INTO l_get_batch_desc;

Line 1701: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);

1697:
1698: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
1699: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
1700: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
1701: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
1702:
1703: OPEN c_get_batch_desc(p_batch_id);
1704: FETCH c_get_batch_desc INTO l_get_batch_desc;
1705: CLOSE c_get_batch_desc;