DBA Data[Home] [Help]

APPS.IGF_GR_GEN dependencies on IGF_AW_GEN

Line 155: l_ver_num := igf_aw_gen.get_ver_num(p_ci_cal_type,p_ci_sequence_number,'P');

151: BEGIN
152:
153: -- Get the Flat File Version and then Proceed
154: --
155: l_ver_num := igf_aw_gen.get_ver_num(p_ci_cal_type,p_ci_sequence_number,'P');
156: IF l_ver_num IS NOT NULL THEN
157: l_cycle_year:=SUBSTR(l_ver_num,6,4);
158: END IF;
159:

Line 957: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID') ||' ' || p_batch_id);

953: fnd_message.set_name('IGF','IGF_GR_BATCH_REJ');
954: fnd_file.put_line(fnd_file.log,fnd_message.get);
955: fnd_file.new_line(fnd_file.log,1);
956:
957: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID') ||' ' || p_batch_id);
958: fnd_file.put_line(fnd_file.log,RPAD('-',35,'-'));
959: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EDIT_CODE') || ' ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TYPE'));
960: fnd_file.put_line(fnd_file.log,RPAD('-',35,'-'));
961:

Line 959: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EDIT_CODE') || ' ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TYPE'));

955: fnd_file.new_line(fnd_file.log,1);
956:
957: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','BATCH_ID') ||' ' || p_batch_id);
958: fnd_file.put_line(fnd_file.log,RPAD('-',35,'-'));
959: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','EDIT_CODE') || ' ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','TYPE'));
960: fnd_file.put_line(fnd_file.log,RPAD('-',35,'-'));
961:
962: BEGIN
963: FOR l_cn IN 1 .. 8

Line 970: fnd_file.put_line(fnd_file.log,RPAD(l_error_code,10) || ' ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ERROR'));

966: l_error_code := NVL(SUBSTR(l_batch_rej_reason,l_count,3),'000');
967:
968: IF NVL(l_error_code,'*') <> '000' THEN
969: IF l_error_code NOT IN ('216','218','219','220','222','235','239','240') THEN
970: fnd_file.put_line(fnd_file.log,RPAD(l_error_code,10) || ' ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ERROR'));
971: IF NOT lb_error_cd THEN
972: lb_error_cd := TRUE;
973: END IF;
974: ELSE

Line 975: fnd_file.put_line(fnd_file.log,RPAD(l_error_code,10) || ' ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','WARN'));

971: IF NOT lb_error_cd THEN
972: lb_error_cd := TRUE;
973: END IF;
974: ELSE
975: fnd_file.put_line(fnd_file.log,RPAD(l_error_code,10) || ' ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','WARN'));
976: END IF;
977: END IF;
978: l_count := l_count + 3;
979: END LOOP;

Line 1003: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||' : ' || cur_get_rfms.origination_id);

999:
1000:
1001: FOR cur_get_rfms IN cur_gr_rfms(l_rfmb_id)
1002: LOOP
1003: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||' : ' || cur_get_rfms.origination_id);
1004:
1005: igf_gr_rfms_pkg.update_row(
1006: x_rowid => cur_get_rfms.row_id,
1007: x_origination_id => cur_get_rfms.origination_id,

Line 1073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||' : ' || cur_get_rfms_disb.origination_id

1069: fnd_file.new_line(fnd_file.log,1);
1070: l_disb_rfmb_id:=rfms_batch_rec.rfmb_id;
1071: FOR cur_get_rfms_disb IN cur_gr_rfms_disb ( l_disb_rfmb_id )
1072: LOOP
1073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||' : ' || cur_get_rfms_disb.origination_id
1074: ||' , '
1075: ||igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM') ||' : ' || cur_get_rfms_disb.disb_ref_num);
1076:
1077: igf_gr_rfms_disb_pkg.update_row (

Line 1075: ||igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM') ||' : ' || cur_get_rfms_disb.disb_ref_num);

1071: FOR cur_get_rfms_disb IN cur_gr_rfms_disb ( l_disb_rfmb_id )
1072: LOOP
1073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||' : ' || cur_get_rfms_disb.origination_id
1074: ||' , '
1075: ||igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM') ||' : ' || cur_get_rfms_disb.disb_ref_num);
1076:
1077: igf_gr_rfms_disb_pkg.update_row (
1078: x_rowid => cur_get_rfms_disb.row_id,
1079: x_rfmd_id => cur_get_rfms_disb.rfmd_id ,

Line 2905: p_status_desc := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',

2901:
2902: IF cur_get_pell%FOUND THEN
2903: IF get_pell_rec.orig_action_code IN ('A','C','D','E') THEN
2904: p_message := 'IGF_GR_ORIG_STAT_CHG';
2905: p_status_desc := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',
2906: get_pell_rec.orig_action_code);
2907: END IF;
2908: END IF;
2909: CLOSE cur_get_pell;