460: FETCH cur_fee_period INTO l_cur_fee_period;
461: CLOSE cur_fee_period;
462:
463: fnd_file.put_line(fnd_file.log,RPAD('-',77,'-'));
464: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
465: fnd_file.put_line(fnd_file.log,fnd_message.get);
466:
467: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
468: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
461: CLOSE cur_fee_period;
462:
463: fnd_file.put_line(fnd_file.log,RPAD('-',77,'-'));
464: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
465: fnd_file.put_line(fnd_file.log,fnd_message.get);
466:
467: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
468: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
469: p_v_lookup_code => 'PERSON') );
463: fnd_file.put_line(fnd_file.log,RPAD('-',77,'-'));
464: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
465: fnd_file.put_line(fnd_file.log,fnd_message.get);
466:
467: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
468: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
469: p_v_lookup_code => 'PERSON') );
470: fnd_message.set_token('PARM_CODE',l_person_number);
471: fnd_file.put_line(fnd_file.log,fnd_message.get);
464: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
465: fnd_file.put_line(fnd_file.log,fnd_message.get);
466:
467: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
468: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
469: p_v_lookup_code => 'PERSON') );
470: fnd_message.set_token('PARM_CODE',l_person_number);
471: fnd_file.put_line(fnd_file.log,fnd_message.get);
472:
466:
467: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
468: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
469: p_v_lookup_code => 'PERSON') );
470: fnd_message.set_token('PARM_CODE',l_person_number);
471: fnd_file.put_line(fnd_file.log,fnd_message.get);
472:
473:
474: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
467: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
468: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
469: p_v_lookup_code => 'PERSON') );
470: fnd_message.set_token('PARM_CODE',l_person_number);
471: fnd_file.put_line(fnd_file.log,fnd_message.get);
472:
473:
474: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
475: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
470: fnd_message.set_token('PARM_CODE',l_person_number);
471: fnd_file.put_line(fnd_file.log,fnd_message.get);
472:
473:
474: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
475: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
476: p_v_lookup_code => 'FEE_TYPE') );
477: fnd_message.set_token('PARM_CODE',p_fee_type);
478: fnd_file.put_line(fnd_file.log,fnd_message.get);
471: fnd_file.put_line(fnd_file.log,fnd_message.get);
472:
473:
474: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
475: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
476: p_v_lookup_code => 'FEE_TYPE') );
477: fnd_message.set_token('PARM_CODE',p_fee_type);
478: fnd_file.put_line(fnd_file.log,fnd_message.get);
479:
473:
474: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
475: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
476: p_v_lookup_code => 'FEE_TYPE') );
477: fnd_message.set_token('PARM_CODE',p_fee_type);
478: fnd_file.put_line(fnd_file.log,fnd_message.get);
479:
480: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
481: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
474: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
475: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
476: p_v_lookup_code => 'FEE_TYPE') );
477: fnd_message.set_token('PARM_CODE',p_fee_type);
478: fnd_file.put_line(fnd_file.log,fnd_message.get);
479:
480: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
481: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
482: p_v_lookup_code => 'FEE_CAL_TYPE') );
476: p_v_lookup_code => 'FEE_TYPE') );
477: fnd_message.set_token('PARM_CODE',p_fee_type);
478: fnd_file.put_line(fnd_file.log,fnd_message.get);
479:
480: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
481: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
482: p_v_lookup_code => 'FEE_CAL_TYPE') );
483: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
484: fnd_file.put_line(fnd_file.log,fnd_message.get);
477: fnd_message.set_token('PARM_CODE',p_fee_type);
478: fnd_file.put_line(fnd_file.log,fnd_message.get);
479:
480: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
481: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
482: p_v_lookup_code => 'FEE_CAL_TYPE') );
483: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
484: fnd_file.put_line(fnd_file.log,fnd_message.get);
485:
479:
480: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
481: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
482: p_v_lookup_code => 'FEE_CAL_TYPE') );
483: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
484: fnd_file.put_line(fnd_file.log,fnd_message.get);
485:
486: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
487: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
480: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
481: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
482: p_v_lookup_code => 'FEE_CAL_TYPE') );
483: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
484: fnd_file.put_line(fnd_file.log,fnd_message.get);
485:
486: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
487: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
488: p_v_lookup_code => 'FEE_PERIOD') );
482: p_v_lookup_code => 'FEE_CAL_TYPE') );
483: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
484: fnd_file.put_line(fnd_file.log,fnd_message.get);
485:
486: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
487: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
488: p_v_lookup_code => 'FEE_PERIOD') );
489: fnd_message.set_token('PARM_CODE',l_cur_fee_period.string);
490: fnd_file.put_line(fnd_file.log,fnd_message.get);
483: fnd_message.set_token('PARM_CODE',p_fee_cal_type);
484: fnd_file.put_line(fnd_file.log,fnd_message.get);
485:
486: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
487: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
488: p_v_lookup_code => 'FEE_PERIOD') );
489: fnd_message.set_token('PARM_CODE',l_cur_fee_period.string);
490: fnd_file.put_line(fnd_file.log,fnd_message.get);
491: fnd_file.put_line(fnd_file.log,RPAD('-',77,'-'));
485:
486: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
487: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
488: p_v_lookup_code => 'FEE_PERIOD') );
489: fnd_message.set_token('PARM_CODE',l_cur_fee_period.string);
490: fnd_file.put_line(fnd_file.log,fnd_message.get);
491: fnd_file.put_line(fnd_file.log,RPAD('-',77,'-'));
492:
493: -- Get the value of "Manage Accounts" System Option value.
486: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
487: fnd_message.set_token('PARM_TYPE',igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
488: p_v_lookup_code => 'FEE_PERIOD') );
489: fnd_message.set_token('PARM_CODE',l_cur_fee_period.string);
490: fnd_file.put_line(fnd_file.log,fnd_message.get);
491: fnd_file.put_line(fnd_file.log,RPAD('-',77,'-'));
492:
493: -- Get the value of "Manage Accounts" System Option value.
494: -- If this value is NULL then this process should error out.
494: -- If this value is NULL then this process should error out.
495: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
496: p_v_message_name => l_v_message_name );
497: IF l_v_manage_accounts IS NULL THEN
498: fnd_message.set_name ( 'IGS', l_v_message_name );
499: fnd_file.put_line(fnd_file.log,fnd_message.get);
500: RAISE l_exception;
501: END IF;
502:
495: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
496: p_v_message_name => l_v_message_name );
497: IF l_v_manage_accounts IS NULL THEN
498: fnd_message.set_name ( 'IGS', l_v_message_name );
499: fnd_file.put_line(fnd_file.log,fnd_message.get);
500: RAISE l_exception;
501: END IF;
502:
503: OPEN cur_fei ( p_person_id,
549: l_transaction_amount := l_cur_fei.transaction_amount;
550:
551: -- Used generic function to get lookup description, removed lookup_desc() function
552:
553: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
554: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
555: p_v_lookup_code => 'PERSON'));
556: fnd_message.set_token('PARM_CODE', l_person_number);
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
550:
551: -- Used generic function to get lookup description, removed lookup_desc() function
552:
553: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
554: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
555: p_v_lookup_code => 'PERSON'));
556: fnd_message.set_token('PARM_CODE', l_person_number);
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
558:
552:
553: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
554: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
555: p_v_lookup_code => 'PERSON'));
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',
553: fnd_message.set_name('IGS','IGS_FI_IMP_CHGS_PARAMETER');
554: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
555: p_v_lookup_code => 'PERSON'));
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 => 'FEE_TYPE'));
555: p_v_lookup_code => 'PERSON'));
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 => 'FEE_TYPE'));
562: fnd_message.set_token('PARM_CODE', l_cur_fei.fee_type);
563: fnd_file.put_line(fnd_file.log, fnd_message.get);
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 => 'FEE_TYPE'));
562: fnd_message.set_token('PARM_CODE', l_cur_fei.fee_type);
563: fnd_file.put_line(fnd_file.log, fnd_message.get);
564:
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 => 'FEE_TYPE'));
562: fnd_message.set_token('PARM_CODE', l_cur_fei.fee_type);
563: fnd_file.put_line(fnd_file.log, fnd_message.get);
564:
565: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
566: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
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 => 'FEE_TYPE'));
562: fnd_message.set_token('PARM_CODE', l_cur_fei.fee_type);
563: fnd_file.put_line(fnd_file.log, fnd_message.get);
564:
565: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
566: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
567: p_v_lookup_code => 'AMOUNT'));
561: p_v_lookup_code => 'FEE_TYPE'));
562: fnd_message.set_token('PARM_CODE', l_cur_fei.fee_type);
563: fnd_file.put_line(fnd_file.log, fnd_message.get);
564:
565: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
566: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
567: p_v_lookup_code => 'AMOUNT'));
568: fnd_message.set_token('PARM_CODE', l_transaction_amount);
569: fnd_file.put_line(fnd_file.log, fnd_message.get);
562: fnd_message.set_token('PARM_CODE', l_cur_fei.fee_type);
563: fnd_file.put_line(fnd_file.log, fnd_message.get);
564:
565: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
566: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
567: p_v_lookup_code => 'AMOUNT'));
568: fnd_message.set_token('PARM_CODE', l_transaction_amount);
569: fnd_file.put_line(fnd_file.log, fnd_message.get);
570:
564:
565: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
566: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
567: p_v_lookup_code => 'AMOUNT'));
568: fnd_message.set_token('PARM_CODE', l_transaction_amount);
569: fnd_file.put_line(fnd_file.log, fnd_message.get);
570:
571: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
572: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
565: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
566: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
567: p_v_lookup_code => 'AMOUNT'));
568: fnd_message.set_token('PARM_CODE', l_transaction_amount);
569: fnd_file.put_line(fnd_file.log, fnd_message.get);
570:
571: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
572: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
573: p_v_lookup_code => 'CURRENCY'));
567: p_v_lookup_code => 'AMOUNT'));
568: fnd_message.set_token('PARM_CODE', l_transaction_amount);
569: fnd_file.put_line(fnd_file.log, fnd_message.get);
570:
571: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
572: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
573: p_v_lookup_code => 'CURRENCY'));
574: -- Also changed to display currency code instead of description top accomodate error currency code also.
575: fnd_message.set_token('PARM_CODE', l_cur_fei.currency_cd);
568: fnd_message.set_token('PARM_CODE', l_transaction_amount);
569: fnd_file.put_line(fnd_file.log, fnd_message.get);
570:
571: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
572: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
573: p_v_lookup_code => 'CURRENCY'));
574: -- Also changed to display currency code instead of description top accomodate error currency code also.
575: fnd_message.set_token('PARM_CODE', l_cur_fei.currency_cd);
576: fnd_file.put_line(fnd_file.log, fnd_message.get);
571: fnd_message.set_name('IGS', 'IGS_FI_IMP_CHGS_PARAMETER');
572: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
573: p_v_lookup_code => 'CURRENCY'));
574: -- Also changed to display currency code instead of description top accomodate error currency code also.
575: fnd_message.set_token('PARM_CODE', l_cur_fei.currency_cd);
576: fnd_file.put_line(fnd_file.log, fnd_message.get);
577: fnd_file.new_line(fnd_file.log);
578:
579: -- Checking all Validations returns TRUE if all validations are passed else FALSE is returned
572: fnd_message.set_token('PARM_TYPE', igs_fi_gen_gl.get_lkp_meaning (p_v_lookup_type => 'IGS_FI_LOCKBOX',
573: p_v_lookup_code => 'CURRENCY'));
574: -- Also changed to display currency code instead of description top accomodate error currency code also.
575: fnd_message.set_token('PARM_CODE', l_cur_fei.currency_cd);
576: fnd_file.put_line(fnd_file.log, fnd_message.get);
577: fnd_file.new_line(fnd_file.log);
578:
579: -- Checking all Validations returns TRUE if all validations are passed else FALSE is returned
580: l_b_ext_val_flag := igs_fi_load_ext_chg.igs_fi_ext_val( p_person_id => l_cur_fei.person_id,
586: p_d_gl_date => l_cur_fei.gl_date,
587: p_message_name => l_error_message);
588: IF NOT l_b_ext_val_flag THEN
589: IF l_error_message = 'IGS_FI_CUR_MISMATCH' THEN
590: fnd_message.set_name('IGS', l_error_message);
591: fnd_message.set_token('CUR1',l_cur_fei.currency_cd);
592: fnd_message.set_token('CUR2',g_curr_cd);
593: ELSIF l_error_message = 'IGS_FI_INVALID_GL_DATE' THEN
594: fnd_message.set_name('IGS', l_error_message);
587: p_message_name => l_error_message);
588: IF NOT l_b_ext_val_flag THEN
589: IF l_error_message = 'IGS_FI_CUR_MISMATCH' THEN
590: fnd_message.set_name('IGS', l_error_message);
591: fnd_message.set_token('CUR1',l_cur_fei.currency_cd);
592: fnd_message.set_token('CUR2',g_curr_cd);
593: ELSIF l_error_message = 'IGS_FI_INVALID_GL_DATE' THEN
594: fnd_message.set_name('IGS', l_error_message);
595: fnd_message.set_token('GL_DATE',l_cur_fei.gl_date);
588: IF NOT l_b_ext_val_flag THEN
589: IF l_error_message = 'IGS_FI_CUR_MISMATCH' THEN
590: fnd_message.set_name('IGS', l_error_message);
591: fnd_message.set_token('CUR1',l_cur_fei.currency_cd);
592: fnd_message.set_token('CUR2',g_curr_cd);
593: ELSIF l_error_message = 'IGS_FI_INVALID_GL_DATE' THEN
594: fnd_message.set_name('IGS', l_error_message);
595: fnd_message.set_token('GL_DATE',l_cur_fei.gl_date);
596: ELSE
590: fnd_message.set_name('IGS', l_error_message);
591: fnd_message.set_token('CUR1',l_cur_fei.currency_cd);
592: fnd_message.set_token('CUR2',g_curr_cd);
593: ELSIF l_error_message = 'IGS_FI_INVALID_GL_DATE' THEN
594: fnd_message.set_name('IGS', l_error_message);
595: fnd_message.set_token('GL_DATE',l_cur_fei.gl_date);
596: ELSE
597: fnd_message.set_name('IGS', l_error_message);
598: END IF;
591: fnd_message.set_token('CUR1',l_cur_fei.currency_cd);
592: fnd_message.set_token('CUR2',g_curr_cd);
593: ELSIF l_error_message = 'IGS_FI_INVALID_GL_DATE' THEN
594: fnd_message.set_name('IGS', l_error_message);
595: fnd_message.set_token('GL_DATE',l_cur_fei.gl_date);
596: ELSE
597: fnd_message.set_name('IGS', l_error_message);
598: END IF;
599:
593: ELSIF l_error_message = 'IGS_FI_INVALID_GL_DATE' THEN
594: fnd_message.set_name('IGS', l_error_message);
595: fnd_message.set_token('GL_DATE',l_cur_fei.gl_date);
596: ELSE
597: fnd_message.set_name('IGS', l_error_message);
598: END IF;
599:
600: l_v_msg := fnd_message.get;
601: fnd_file.put_line(fnd_file.log,l_v_msg);
596: ELSE
597: fnd_message.set_name('IGS', l_error_message);
598: END IF;
599:
600: l_v_msg := fnd_message.get;
601: fnd_file.put_line(fnd_file.log,l_v_msg);
602: l_cur_fei.error_msg := l_v_msg;
603: END IF;
604:
627: p_desc_flex_name => 'IGS_FI_INVLN_INT_ALL_FLEX'
628: );
629: IF NOT l_b_dff_validate THEN
630: l_b_ext_val_flag := FALSE;
631: fnd_message.set_name('IGS','IGS_AD_INVALID_DESC_FLEX');
632: l_v_msg := fnd_message.get;
633: fnd_file.put_line(fnd_file.log,l_v_msg);
634: l_cur_fei.error_msg := l_cur_fei.error_msg||'.'||l_v_msg;
635: END IF;
628: );
629: IF NOT l_b_dff_validate THEN
630: l_b_ext_val_flag := FALSE;
631: fnd_message.set_name('IGS','IGS_AD_INVALID_DESC_FLEX');
632: l_v_msg := fnd_message.get;
633: fnd_file.put_line(fnd_file.log,l_v_msg);
634: l_cur_fei.error_msg := l_cur_fei.error_msg||'.'||l_v_msg;
635: END IF;
636:
647: END IF;
648:
649: IF NOT l_b_valid_ccid THEN
650: l_b_ext_val_flag := FALSE;
651: fnd_message.set_name('IGS','IGS_FI_INVALID_CCID');
652: l_v_msg := fnd_message.get;
653: fnd_file.put_line(fnd_file.log,l_v_msg);
654: l_cur_fei.error_msg := l_cur_fei.error_msg||'.'||l_v_msg;
655: END IF;
648:
649: IF NOT l_b_valid_ccid THEN
650: l_b_ext_val_flag := FALSE;
651: fnd_message.set_name('IGS','IGS_FI_INVALID_CCID');
652: l_v_msg := fnd_message.get;
653: fnd_file.put_line(fnd_file.log,l_v_msg);
654: l_cur_fei.error_msg := l_cur_fei.error_msg||'.'||l_v_msg;
655: END IF;
656:
692: -- Build Accounts Process will return error message name when the error type is 1
693: -- Will return message string when the error type is greater than 1
694: IF (l_v_err_string IS NOT NULL) THEN
695: IF (l_n_err_type = 1) THEN
696: fnd_message.set_name('IGS',l_v_err_string);
697: l_v_msg := fnd_message.get;
698: fnd_file.put_line(fnd_file.log,l_v_msg);
699: l_cur_fei.error_msg := l_v_msg;
700: ELSE
693: -- Will return message string when the error type is greater than 1
694: IF (l_v_err_string IS NOT NULL) THEN
695: IF (l_n_err_type = 1) THEN
696: fnd_message.set_name('IGS',l_v_err_string);
697: l_v_msg := fnd_message.get;
698: fnd_file.put_line(fnd_file.log,l_v_msg);
699: l_cur_fei.error_msg := l_v_msg;
700: ELSE
701: fnd_file.put_line(fnd_file.log, l_v_err_string);
773: x_waiver_amount => l_n_waiver_amount);
774: IF l_v_return_status <> 'S' THEN
775: l_b_ext_val_flag := FALSE;
776: IF l_n_msg_count = 1 THEN
777: fnd_message.set_encoded(l_v_msg_data);
778: l_v_msg := fnd_message.get;
779: fnd_file.put_line(fnd_file.log,l_v_msg);
780: l_cur_fei.error_msg := l_v_msg;
781: ELSE
774: IF l_v_return_status <> 'S' THEN
775: l_b_ext_val_flag := FALSE;
776: IF l_n_msg_count = 1 THEN
777: fnd_message.set_encoded(l_v_msg_data);
778: l_v_msg := fnd_message.get;
779: fnd_file.put_line(fnd_file.log,l_v_msg);
780: l_cur_fei.error_msg := l_v_msg;
781: ELSE
782: FOR l_var IN 1..l_n_msg_count LOOP
779: fnd_file.put_line(fnd_file.log,l_v_msg);
780: l_cur_fei.error_msg := l_v_msg;
781: ELSE
782: FOR l_var IN 1..l_n_msg_count LOOP
783: fnd_message.set_encoded(fnd_msg_pub.get);
784: l_v_msg := fnd_message.get;
785: fnd_file.put_line(fnd_file.log,l_v_msg);
786: l_cur_fei.error_msg := l_cur_fei.error_msg||'.'||l_v_msg;
787: END LOOP;
780: l_cur_fei.error_msg := l_v_msg;
781: ELSE
782: FOR l_var IN 1..l_n_msg_count LOOP
783: fnd_message.set_encoded(fnd_msg_pub.get);
784: l_v_msg := fnd_message.get;
785: fnd_file.put_line(fnd_file.log,l_v_msg);
786: l_cur_fei.error_msg := l_cur_fei.error_msg||'.'||l_v_msg;
787: END LOOP;
788: END IF;
868: END IF;
869: END LOOP;
870: CLOSE cur_fei;
871:
872: fnd_file.put_line(fnd_file.log,fnd_message.get_string ('IGS','IGS_GE_TOTAL_REC_PROCESSED')||TO_CHAR(l_n_record_count));
873: fnd_file.put_line(fnd_file.log,RPAD('-',77,'-'));
874:
875: EXCEPTION
876: WHEN l_exception THEN
877: retcode := 2;
878: WHEN OTHERS THEN
879: ROLLBACK;
880: retcode := 2;
881: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION')||' : '||SQLERRM;
882: igs_ge_msg_stack.add;
883: igs_ge_msg_stack.conc_exception_hndl;
884: END igs_fi_extto_imp;
885: