DBA Data[Home] [Help]

APPS.IGF_GR_GEN dependencies on FND_FILE

Line 952: fnd_file.new_line(fnd_file.log,1);

948:
949: IF TO_NUMBER(l_batch_rej_reason) > 0 THEN
950:
951: p_number_rec := 0;
952: fnd_file.new_line(fnd_file.log,1);
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:

Line 954: fnd_file.put_line(fnd_file.log,fnd_message.get);

950:
951: p_number_rec := 0;
952: fnd_file.new_line(fnd_file.log,1);
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,'-'));

Line 955: fnd_file.new_line(fnd_file.log,1);

951: p_number_rec := 0;
952: fnd_file.new_line(fnd_file.log,1);
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'));

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 958: fnd_file.put_line(fnd_file.log,RPAD('-',35,'-'));

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:
962: BEGIN

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 960: fnd_file.put_line(fnd_file.log,RPAD('-',35,'-'));

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
964: LOOP

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 986: fnd_file.new_line(fnd_file.log,1);

982: WHEN OTHERS THEN
983: NULL;
984:
985: END;
986: fnd_file.new_line(fnd_file.log,1);
987:
988: ----Bug #2974248
989: IF lb_error_cd THEN
990: ----Bug #2938258

Line 995: fnd_file.put_line(fnd_file.log,fnd_message.get);

991: IF p_file_type = 'GR_RFMS_ORIG' THEN
992:
993: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_ORIG_BTCH_REC');
994: fnd_message.set_token('BATCH_ID',p_batch_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: fnd_file.new_line(fnd_file.log,1);
997:
998: l_rfmb_id:=rfms_batch_rec.rfmb_id;
999:

Line 996: fnd_file.new_line(fnd_file.log,1);

992:
993: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_ORIG_BTCH_REC');
994: fnd_message.set_token('BATCH_ID',p_batch_id);
995: fnd_file.put_line(fnd_file.log,fnd_message.get);
996: fnd_file.new_line(fnd_file.log,1);
997:
998: l_rfmb_id:=rfms_batch_rec.rfmb_id;
999:
1000:

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 1068: fnd_file.put_line(fnd_file.log,fnd_message.get);

1064: ELSIF p_file_type = 'GR_RFMS_DISB_ORIG' THEN
1065:
1066: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_DISB_BTCH_REC');
1067: fnd_message.set_token('BATCH_ID',p_batch_id);
1068: fnd_file.put_line(fnd_file.log,fnd_message.get);
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

Line 1069: fnd_file.new_line(fnd_file.log,1);

1065:
1066: fnd_message.set_name('IGF','IGF_GR_RESET_REJ_DISB_BTCH_REC');
1067: fnd_message.set_token('BATCH_ID',p_batch_id);
1068: fnd_file.put_line(fnd_file.log,fnd_message.get);
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

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 (