DBA Data[Home] [Help]

APPS.IGF_AP_LG_TD_IMP dependencies on IGF_AP_GEN

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

350: retcode := 0;
351: l_cal_type := LTRIM(RTRIM(SUBSTR(p_award_year,1,10)));
352: l_seq_number := TO_NUMBER(SUBSTR(p_award_year,11));
353:
354: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
355:
356: l_chk_profile := igf_ap_gen.check_profile;
357: IF l_chk_profile = 'N' THEN
358: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');

Line 356: l_chk_profile := igf_ap_gen.check_profile;

352: l_seq_number := TO_NUMBER(SUBSTR(p_award_year,11));
353:
354: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
355:
356: l_chk_profile := igf_ap_gen.check_profile;
357: IF l_chk_profile = 'N' THEN
358: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
359: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
360: RETURN;

Line 388: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'TODO');

384: add_log_table(NULL,l_error,fnd_message.get);
385: l_terminate_flag := TRUE;
386: END IF;
387:
388: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'TODO');
389: IF l_chk_batch = 'N' THEN
390: fnd_message.set_name('IGF','IGF_GR_BATCH_DOES_NOT_EXIST');
391: add_log_table(NULL,l_error,fnd_message.get);
392: l_terminate_flag := TRUE;

Line 430: igf_ap_gen.check_person(l_get_persons.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);

426: l_old_person_number := l_get_persons.person_number;
427: lv_base_id := NULL;
428: lv_person_id := NULL;
429: --HERE CALL TO THE GENERIC WRAPPER IS BEING MADE TO CHEHK THE VALIDITY OF THE PEROSN AND BASE ID
430: igf_ap_gen.check_person(l_get_persons.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
431: IF lv_person_id IS NULL THEN
432: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
433: add_log_table(l_get_persons.person_number,l_error,fnd_message.get);
434: l_person_skip_flag := TRUE;

Line 514: l_get_meaning := igf_ap_gen.get_lookup_meaning('IGF_TD_ITEM_STATUS',l_get_persons.item_status_code);

510: l_message_str := NULL;
511: l_error_flag := TRUE;
512: END IF;
513: --validation for the item status
514: l_get_meaning := igf_ap_gen.get_lookup_meaning('IGF_TD_ITEM_STATUS',l_get_persons.item_status_code);
515: IF l_get_meaning IS NULL THEN
516: fnd_message.set_name('IGF','IGF_AP_TODO_INVALID_STAT');
517: l_message_str := l_proc_item_str || ' ' || fnd_message.get;
518: add_log_table(l_get_persons.person_number,l_error,l_message_str);

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

1181: l_get_batch_desc c_get_batch_desc%ROWTYPE;
1182:
1183: BEGIN
1184:
1185: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
1186: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
1187: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
1188: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
1189:

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

1182:
1183: BEGIN
1184:
1185: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
1186: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
1187: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
1188: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
1189:
1190: OPEN c_get_batch_desc(p_batch_id);

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

1183: BEGIN
1184:
1185: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
1186: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
1187: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
1188: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
1189:
1190: OPEN c_get_batch_desc(p_batch_id);
1191: FETCH c_get_batch_desc INTO l_get_batch_desc;

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

1184:
1185: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
1186: l_batch_id := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
1187: l_award_yr := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
1188: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_del_ind);
1189:
1190: OPEN c_get_batch_desc(p_batch_id);
1191: FETCH c_get_batch_desc INTO l_get_batch_desc;
1192: CLOSE c_get_batch_desc;