444: -- Initialize the different global variables
445:
446: log_to_fnd(p_v_module => 'Init',
447: p_v_string => 'Initializing variables');
448: g_v_label_tax_year := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
449: 'TAX_YEAR');
450: g_v_label_person := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
451: 'PERSON');
452: g_v_label_persgrp := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
446: log_to_fnd(p_v_module => 'Init',
447: p_v_string => 'Initializing variables');
448: g_v_label_tax_year := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
449: 'TAX_YEAR');
450: g_v_label_person := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
451: 'PERSON');
452: g_v_label_persgrp := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
453: 'PERSON_GROUP');
454: g_v_label_override_excl := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
448: g_v_label_tax_year := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
449: 'TAX_YEAR');
450: g_v_label_person := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
451: 'PERSON');
452: g_v_label_persgrp := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
453: 'PERSON_GROUP');
454: g_v_label_override_excl := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
455: 'OVERRIDE_EXCL');
456: g_v_label_file_addr := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
450: g_v_label_person := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
451: 'PERSON');
452: g_v_label_persgrp := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
453: 'PERSON_GROUP');
454: g_v_label_override_excl := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
455: 'OVERRIDE_EXCL');
456: g_v_label_file_addr := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
457: 'FILE_CORRECTION');
458: g_v_label_test_run := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
452: g_v_label_persgrp := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
453: 'PERSON_GROUP');
454: g_v_label_override_excl := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
455: 'OVERRIDE_EXCL');
456: g_v_label_file_addr := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
457: 'FILE_CORRECTION');
458: g_v_label_test_run := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
459: 'TEST_RUN');
460: g_v_label_stdnt_name := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
454: g_v_label_override_excl := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
455: 'OVERRIDE_EXCL');
456: g_v_label_file_addr := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
457: 'FILE_CORRECTION');
458: g_v_label_test_run := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
459: 'TEST_RUN');
460: g_v_label_stdnt_name := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
461: 'STUDENT_NAME');
462:
456: g_v_label_file_addr := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
457: 'FILE_CORRECTION');
458: g_v_label_test_run := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
459: 'TEST_RUN');
460: g_v_label_stdnt_name := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
461: 'STUDENT_NAME');
462:
463: g_v_label_name_control := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
464: 'NAME_CONTROL');
459: 'TEST_RUN');
460: g_v_label_stdnt_name := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
461: 'STUDENT_NAME');
462:
463: g_v_label_name_control := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
464: 'NAME_CONTROL');
465: g_v_label_tin := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
466: 'TIN');
467: g_v_label_val_status := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
461: 'STUDENT_NAME');
462:
463: g_v_label_name_control := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
464: 'NAME_CONTROL');
465: g_v_label_tin := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
466: 'TIN');
467: g_v_label_val_status := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
468: 'VAL_STATUS');
469: g_v_label_err_desc := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
463: g_v_label_name_control := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
464: 'NAME_CONTROL');
465: g_v_label_tin := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
466: 'TIN');
467: g_v_label_val_status := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
468: 'VAL_STATUS');
469: g_v_label_err_desc := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
470: 'ERR_DESC');
471: g_v_label_correct_ret := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
465: g_v_label_tin := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
466: 'TIN');
467: g_v_label_val_status := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
468: 'VAL_STATUS');
469: g_v_label_err_desc := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
470: 'ERR_DESC');
471: g_v_label_correct_ret := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
472: 'CORRECTED_RETURN');
473: g_v_label_box2 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
467: g_v_label_val_status := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
468: 'VAL_STATUS');
469: g_v_label_err_desc := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
470: 'ERR_DESC');
471: g_v_label_correct_ret := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
472: 'CORRECTED_RETURN');
473: g_v_label_box2 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
474: 'BOX2');
475: g_v_label_box3 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
469: g_v_label_err_desc := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
470: 'ERR_DESC');
471: g_v_label_correct_ret := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
472: 'CORRECTED_RETURN');
473: g_v_label_box2 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
474: 'BOX2');
475: g_v_label_box3 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
476: 'BOX3');
477: g_v_label_box4 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
471: g_v_label_correct_ret := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
472: 'CORRECTED_RETURN');
473: g_v_label_box2 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
474: 'BOX2');
475: g_v_label_box3 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
476: 'BOX3');
477: g_v_label_box4 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
478: 'BOX4');
479: g_v_label_box5 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
473: g_v_label_box2 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
474: 'BOX2');
475: g_v_label_box3 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
476: 'BOX3');
477: g_v_label_box4 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
478: 'BOX4');
479: g_v_label_box5 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
480: 'BOX5');
481: g_v_label_box6 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
475: g_v_label_box3 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
476: 'BOX3');
477: g_v_label_box4 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
478: 'BOX4');
479: g_v_label_box5 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
480: 'BOX5');
481: g_v_label_box6 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
482: 'BOX6');
483: g_v_label_box8 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
477: g_v_label_box4 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
478: 'BOX4');
479: g_v_label_box5 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
480: 'BOX5');
481: g_v_label_box6 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
482: 'BOX6');
483: g_v_label_box8 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
484: 'BOX8');
485: g_v_label_box9 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
479: g_v_label_box5 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
480: 'BOX5');
481: g_v_label_box6 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
482: 'BOX6');
483: g_v_label_box8 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
484: 'BOX8');
485: g_v_label_box9 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
486: 'BOX9');
487: g_v_label_boxval := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
481: g_v_label_box6 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
482: 'BOX6');
483: g_v_label_box8 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
484: 'BOX8');
485: g_v_label_box9 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
486: 'BOX9');
487: g_v_label_boxval := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
488: 'BOXVAL');
489: END init;
483: g_v_label_box8 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
484: 'BOX8');
485: g_v_label_box9 := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
486: 'BOX9');
487: g_v_label_boxval := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',
488: 'BOXVAL');
489: END init;
490:
491: PROCEDURE log_line(p_v_parm_name VARCHAR2,
589: END IF;
590: log_line(g_v_label_persgrp, l_v_group_cd);
591:
592: log_line(g_v_label_override_excl,
593: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_override_excl));
594:
595: log_line(g_v_label_file_addr,
596: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_file_addr_correction));
597:
592: log_line(g_v_label_override_excl,
593: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_override_excl));
594:
595: log_line(g_v_label_file_addr,
596: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_file_addr_correction));
597:
598: log_line(g_v_label_test_run,
599: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_test_run));
600: fnd_file.put_line(fnd_file.log,
595: log_line(g_v_label_file_addr,
596: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_file_addr_correction));
597:
598: log_line(g_v_label_test_run,
599: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_test_run));
600: fnd_file.put_line(fnd_file.log,
601: g_v_line_sep);
602: END log_params;
603:
2751:
2752: -- Log the details if there is a 1098T record created or updated
2753: IF l_b_txn THEN
2754: log_line(g_v_label_val_status,
2755: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_1098T_STATUS_CODE',
2756: g_v_validation_status));
2757: log_line(g_v_label_err_desc,
2758: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_1098T_ERR_CODE',
2759: l_v_error_code));
2754: log_line(g_v_label_val_status,
2755: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_1098T_STATUS_CODE',
2756: g_v_validation_status));
2757: log_line(g_v_label_err_desc,
2758: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_1098T_ERR_CODE',
2759: l_v_error_code));
2760: log_line(g_v_label_correct_ret,
2761: igs_fi_gen_gl.get_lkp_meaning('YES_NO',
2762: NVL(l_v_correction_flag,l_rec_1098t_data.correction_flag)));
2757: log_line(g_v_label_err_desc,
2758: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_1098T_ERR_CODE',
2759: l_v_error_code));
2760: log_line(g_v_label_correct_ret,
2761: igs_fi_gen_gl.get_lkp_meaning('YES_NO',
2762: NVL(l_v_correction_flag,l_rec_1098t_data.correction_flag)));
2763: fnd_file.new_line(fnd_file.log);
2764: log_line(g_v_label_boxval,null);
2765: log_line(g_v_label_box2,
3098:
3099: l_v_box9 := compute_box9(p_n_person_id => p_n_person_id,
3100: p_v_tax_year_name => p_v_tax_year_name);
3101:
3102: l_n_box2 := igs_fi_gen_gl.get_formatted_amount(l_n_box2);
3103: l_n_box3 := igs_fi_gen_gl.get_formatted_amount(l_n_box3);
3104: l_n_box4 := igs_fi_gen_gl.get_formatted_amount(l_n_box4);
3105: l_n_box5 := igs_fi_gen_gl.get_formatted_amount(l_n_box5);
3106:
3099: l_v_box9 := compute_box9(p_n_person_id => p_n_person_id,
3100: p_v_tax_year_name => p_v_tax_year_name);
3101:
3102: l_n_box2 := igs_fi_gen_gl.get_formatted_amount(l_n_box2);
3103: l_n_box3 := igs_fi_gen_gl.get_formatted_amount(l_n_box3);
3104: l_n_box4 := igs_fi_gen_gl.get_formatted_amount(l_n_box4);
3105: l_n_box5 := igs_fi_gen_gl.get_formatted_amount(l_n_box5);
3106:
3107: -- Create 1098T Transactions
3100: p_v_tax_year_name => p_v_tax_year_name);
3101:
3102: l_n_box2 := igs_fi_gen_gl.get_formatted_amount(l_n_box2);
3103: l_n_box3 := igs_fi_gen_gl.get_formatted_amount(l_n_box3);
3104: l_n_box4 := igs_fi_gen_gl.get_formatted_amount(l_n_box4);
3105: l_n_box5 := igs_fi_gen_gl.get_formatted_amount(l_n_box5);
3106:
3107: -- Create 1098T Transactions
3108: insert_1098t_data(p_v_tax_year_name => p_v_tax_year_name,
3101:
3102: l_n_box2 := igs_fi_gen_gl.get_formatted_amount(l_n_box2);
3103: l_n_box3 := igs_fi_gen_gl.get_formatted_amount(l_n_box3);
3104: l_n_box4 := igs_fi_gen_gl.get_formatted_amount(l_n_box4);
3105: l_n_box5 := igs_fi_gen_gl.get_formatted_amount(l_n_box5);
3106:
3107: -- Create 1098T Transactions
3108: insert_1098t_data(p_v_tax_year_name => p_v_tax_year_name,
3109: p_n_person_id => p_n_person_id,