[Home] [Help]
378: vvutukur 23-Jan-20033 Bug#2750566.Modified the code to update the error_msg column in Interface record with appropriate message text.
379: vvutukur 06-Jan-2003 Bug#2737714.Used fnd_message.set_encoded to encode the message after charges api call,if charges api returns an error.
380: Also shown the no. of successfully imported records instead of showing no. of records processsed from interface table.
381: pathipat 20-NOV-2002 Enh#2584986 - GL Interface build
382: 1. Removed override account columns from calls to insert_row of IGS_FI_IMP_CHGS and
383: IGS_FI_IMPCHGS_LINES and update_row of IGS_FI_ANC_INT.
384: Also removed the corresponding validations and local variables.
385: 2. Removed ext_attribute columns from calls to insert_row of IGS_FI_IMPCHGS_LINES
386: 3. Removed cursor cur_currency and its usage. Derived local currency using generic
412: l_person_number igs_pe_person.person_number%TYPE;
413:
414: -- Variables of type NUMBER
415: l_diff_amount igs_fi_inv_int.invoice_amount_due%TYPE;
416: l_import_charges_id igs_fi_imp_chgs.import_charges_id%TYPE;
417: l_impchgs_lines_id igs_fi_impchgs_lines.impchg_lines_id%TYPE;
418: l_ancillary_chg_rate igs_fi_anc_rates.ancillary_chg_rate%TYPE;
419: l_rec_cntr NUMBER(10);
420:
493: cp_fee_ci_sequence_number IGS_FI_F_TYP_CA_INST.Fee_Ci_Sequence_Number%TYPE,
494: cp_fee_type IGS_FI_F_TYP_CA_INST.Fee_Type%TYPE,
495: cp_transaction_type VARCHAR2) IS
496: SELECT import_charges_id
497: FROM igs_fi_imp_chgs
498: WHERE person_id = cp_person_id
499: AND fee_cal_type = cp_fee_cal_type
500: AND fee_ci_sequence_number = cp_fee_ci_sequence_number
501: AND fee_type = cp_fee_type
548: l_person_number := Get_Person_Number(p_person_id);
549: END IF;
550:
551: -- Removed usage of lookup_desc, instead used generic function to get the lookup description
552: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
553: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
554: p_v_lookup_code => 'PERSON')
555: );
556: fnd_message.set_token('PARM_CODE',l_person_number);
555: );
556: fnd_message.set_token('PARM_CODE',l_person_number);
557: fnd_file.put_line(fnd_file.log,fnd_message.get);
558:
559: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
560: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
561: p_v_lookup_code => 'PERSON_ID_TYPE')
562: );
563: fnd_message.set_token('PARM_CODE',p_person_id_type);
562: );
563: fnd_message.set_token('PARM_CODE',p_person_id_type);
564: fnd_file.put_line(fnd_file.log,fnd_message.get);
565:
566: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
567: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
568: p_v_lookup_code => 'ALTERNATE_PERSON_ID')
569: );
570: fnd_message.set_token('PARM_CODE',p_api_person_id);
569: );
570: fnd_message.set_token('PARM_CODE',p_api_person_id);
571: fnd_file.put_line(fnd_file.log,fnd_message.get);
572:
573: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
574: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
575: p_v_lookup_code => 'FEE_TYPE')
576: );
577: fnd_message.set_token('PARM_CODE',p_fee_type);
576: );
577: fnd_message.set_token('PARM_CODE',p_fee_type);
578: fnd_file.put_line(fnd_file.log,fnd_message.get);
579:
580: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
581: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
582: p_v_lookup_code => 'FEE_CAL_TYPE')
583: );
584: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
809: l_import_charges_id := NULL;
810: l_rowid := NULL;
811:
812: -- Call the TBH for creating a record in the Import Charges Table
813: igs_fi_imp_chgs_pkg.Insert_Row( x_rowid => l_rowid,
814: x_import_charges_id => l_import_charges_id,
815: x_person_id => l_person_id,
816: x_fee_type => ancrec.fee_type,
817: x_fee_cal_type => ancrec.fee_cal_type,