DBA Data[Home] [Help]

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_FI_GEN_GL

Line 448: g_v_label_tax_year := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',

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',

Line 450: g_v_label_person := 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',

Line 452: g_v_label_persgrp := 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',

Line 454: g_v_label_override_excl := 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',

Line 456: g_v_label_file_addr := 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',

Line 458: g_v_label_test_run := 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:

Line 460: g_v_label_stdnt_name := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',

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');

Line 463: g_v_label_name_control := 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');
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',

Line 465: g_v_label_tin := 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',

Line 467: g_v_label_val_status := 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',

Line 469: g_v_label_err_desc := 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',

Line 471: g_v_label_correct_ret := 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',

Line 473: g_v_label_box2 := 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',

Line 475: g_v_label_box3 := 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',

Line 477: g_v_label_box4 := 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',

Line 479: g_v_label_box5 := 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',

Line 481: g_v_label_box6 := 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',

Line 483: g_v_label_box8 := 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',

Line 485: g_v_label_box9 := 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;

Line 487: g_v_label_boxval := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX',

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,

Line 593: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_override_excl));

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:

Line 596: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_file_addr_correction));

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,

Line 599: igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_test_run));

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:

Line 2755: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_1098T_STATUS_CODE',

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));

Line 2758: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_1098T_ERR_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)));

Line 2761: igs_fi_gen_gl.get_lkp_meaning('YES_NO',

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,

Line 3102: l_n_box2 := igs_fi_gen_gl.get_formatted_amount(l_n_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:

Line 3103: l_n_box3 := igs_fi_gen_gl.get_formatted_amount(l_n_box3);

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

Line 3104: l_n_box4 := igs_fi_gen_gl.get_formatted_amount(l_n_box4);

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,

Line 3105: l_n_box5 := igs_fi_gen_gl.get_formatted_amount(l_n_box5);

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,