eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on FND_MESSAGE

Line 575: fnd_message.get_string('IGS',

571: BEGIN
572:
573: -- Log the parameters
574: fnd_file.put_line(fnd_file.log,
575: fnd_message.get_string('IGS',
576: 'IGS_FI_ANC_LOG_PARM'));
577: log_line(g_v_label_tax_year, p_v_tax_year_name);
578:
579: IF p_n_person_id IS NOT NULL THEN

Line 650: fnd_message.set_module(g_v_package_name||'validate_parameters');

646:
647: -- Validate if the Person ID and Person ID Group are both passed
648: IF ((p_n_person_id IS NOT NULL) AND (p_n_person_grp_id IS NOT NULL)) THEN
649: l_b_validate := FALSE;
650: fnd_message.set_module(g_v_package_name||'validate_parameters');
651: fnd_message.set_name('IGS',
652: 'IGS_FI_NO_PERS_PGRP');
653: fnd_file.put_line(fnd_file.log,
654: fnd_message.get);

Line 651: fnd_message.set_name('IGS',

647: -- Validate if the Person ID and Person ID Group are both passed
648: IF ((p_n_person_id IS NOT NULL) AND (p_n_person_grp_id IS NOT NULL)) THEN
649: l_b_validate := FALSE;
650: fnd_message.set_module(g_v_package_name||'validate_parameters');
651: fnd_message.set_name('IGS',
652: 'IGS_FI_NO_PERS_PGRP');
653: fnd_file.put_line(fnd_file.log,
654: fnd_message.get);
655: END IF;

Line 654: fnd_message.get);

650: fnd_message.set_module(g_v_package_name||'validate_parameters');
651: fnd_message.set_name('IGS',
652: 'IGS_FI_NO_PERS_PGRP');
653: fnd_file.put_line(fnd_file.log,
654: fnd_message.get);
655: END IF;
656:
657: -- Validate if neither Person ID nor Person ID Group is passed
658: IF ((p_n_person_id IS NULL) AND (p_n_person_grp_id IS NULL)) THEN

Line 659: fnd_message.set_module(g_v_package_name||'validate_parameters');

655: END IF;
656:
657: -- Validate if neither Person ID nor Person ID Group is passed
658: IF ((p_n_person_id IS NULL) AND (p_n_person_grp_id IS NULL)) THEN
659: fnd_message.set_module(g_v_package_name||'validate_parameters');
660: l_b_validate := FALSE;
661: fnd_message.set_name('IGS',
662: 'IGS_FI_PRS_PRSIDGRP_NULL');
663: fnd_file.put_line(fnd_file.log,

Line 661: fnd_message.set_name('IGS',

657: -- Validate if neither Person ID nor Person ID Group is passed
658: IF ((p_n_person_id IS NULL) AND (p_n_person_grp_id IS NULL)) THEN
659: fnd_message.set_module(g_v_package_name||'validate_parameters');
660: l_b_validate := FALSE;
661: fnd_message.set_name('IGS',
662: 'IGS_FI_PRS_PRSIDGRP_NULL');
663: fnd_file.put_line(fnd_file.log,
664: fnd_message.get);
665: END IF;

Line 664: fnd_message.get);

660: l_b_validate := FALSE;
661: fnd_message.set_name('IGS',
662: 'IGS_FI_PRS_PRSIDGRP_NULL');
663: fnd_file.put_line(fnd_file.log,
664: fnd_message.get);
665: END IF;
666:
667: -- Validate Tax Year
668: OPEN cur_1098t_setup(p_v_tax_year_name);

Line 671: fnd_message.set_module(g_v_package_name||'validate_parameters');

667: -- Validate Tax Year
668: OPEN cur_1098t_setup(p_v_tax_year_name);
669: FETCH cur_1098t_setup INTO g_rec_1098t_setup;
670: IF cur_1098t_setup%NOTFOUND THEN
671: fnd_message.set_module(g_v_package_name||'validate_parameters');
672: l_b_validate := FALSE;
673: fnd_message.set_name('IGS',
674: 'IGS_FI_INVALID_PARAMETER');
675: fnd_message.set_token('PARAMETER',

Line 673: fnd_message.set_name('IGS',

669: FETCH cur_1098t_setup INTO g_rec_1098t_setup;
670: IF cur_1098t_setup%NOTFOUND THEN
671: fnd_message.set_module(g_v_package_name||'validate_parameters');
672: l_b_validate := FALSE;
673: fnd_message.set_name('IGS',
674: 'IGS_FI_INVALID_PARAMETER');
675: fnd_message.set_token('PARAMETER',
676: g_v_label_tax_year);
677: fnd_file.put_line(fnd_file.log,

Line 675: fnd_message.set_token('PARAMETER',

671: fnd_message.set_module(g_v_package_name||'validate_parameters');
672: l_b_validate := FALSE;
673: fnd_message.set_name('IGS',
674: 'IGS_FI_INVALID_PARAMETER');
675: fnd_message.set_token('PARAMETER',
676: g_v_label_tax_year);
677: fnd_file.put_line(fnd_file.log,
678: fnd_message.get);
679: END IF;

Line 678: fnd_message.get);

674: 'IGS_FI_INVALID_PARAMETER');
675: fnd_message.set_token('PARAMETER',
676: g_v_label_tax_year);
677: fnd_file.put_line(fnd_file.log,
678: fnd_message.get);
679: END IF;
680: CLOSE cur_1098t_setup;
681:
682: -- Validate Person Id if passed

Line 687: fnd_message.set_module(g_v_package_name||'validate_parameters');

683: IF p_n_person_id IS NOT NULL THEN
684: OPEN cur_val_person_id(p_n_person_id);
685: FETCH cur_val_person_id INTO l_c_val;
686: IF cur_val_person_id%NOTFOUND THEN
687: fnd_message.set_module(g_v_package_name||'validate_parameters');
688: l_b_validate := FALSE;
689: fnd_message.set_name('IGS',
690: 'IGS_FI_INVALID_PARAMETER');
691: fnd_message.set_token('PARAMETER',

Line 689: fnd_message.set_name('IGS',

685: FETCH cur_val_person_id INTO l_c_val;
686: IF cur_val_person_id%NOTFOUND THEN
687: fnd_message.set_module(g_v_package_name||'validate_parameters');
688: l_b_validate := FALSE;
689: fnd_message.set_name('IGS',
690: 'IGS_FI_INVALID_PARAMETER');
691: fnd_message.set_token('PARAMETER',
692: g_v_label_person);
693: fnd_file.put_line(fnd_file.log,

Line 691: fnd_message.set_token('PARAMETER',

687: fnd_message.set_module(g_v_package_name||'validate_parameters');
688: l_b_validate := FALSE;
689: fnd_message.set_name('IGS',
690: 'IGS_FI_INVALID_PARAMETER');
691: fnd_message.set_token('PARAMETER',
692: g_v_label_person);
693: fnd_file.put_line(fnd_file.log,
694: fnd_message.get);
695: END IF;

Line 694: fnd_message.get);

690: 'IGS_FI_INVALID_PARAMETER');
691: fnd_message.set_token('PARAMETER',
692: g_v_label_person);
693: fnd_file.put_line(fnd_file.log,
694: fnd_message.get);
695: END IF;
696: CLOSE cur_val_person_id;
697: END IF;
698:

Line 705: fnd_message.set_module(g_v_package_name||'validate_parameters');

701: OPEN cur_val_persgrp(p_n_person_grp_id,
702: 'N');
703: FETCH cur_val_persgrp INTO l_c_val;
704: IF cur_val_persgrp%NOTFOUND THEN
705: fnd_message.set_module(g_v_package_name||'validate_parameters');
706: l_b_validate := FALSE;
707: fnd_message.set_name('IGS',
708: 'IGS_FI_INVALID_PARAMETER');
709: fnd_message.set_token('PARAMETER',

Line 707: fnd_message.set_name('IGS',

703: FETCH cur_val_persgrp INTO l_c_val;
704: IF cur_val_persgrp%NOTFOUND THEN
705: fnd_message.set_module(g_v_package_name||'validate_parameters');
706: l_b_validate := FALSE;
707: fnd_message.set_name('IGS',
708: 'IGS_FI_INVALID_PARAMETER');
709: fnd_message.set_token('PARAMETER',
710: g_v_label_persgrp);
711: fnd_file.put_line(fnd_file.log,

Line 709: fnd_message.set_token('PARAMETER',

705: fnd_message.set_module(g_v_package_name||'validate_parameters');
706: l_b_validate := FALSE;
707: fnd_message.set_name('IGS',
708: 'IGS_FI_INVALID_PARAMETER');
709: fnd_message.set_token('PARAMETER',
710: g_v_label_persgrp);
711: fnd_file.put_line(fnd_file.log,
712: fnd_message.get);
713: END IF;

Line 712: fnd_message.get);

708: 'IGS_FI_INVALID_PARAMETER');
709: fnd_message.set_token('PARAMETER',
710: g_v_label_persgrp);
711: fnd_file.put_line(fnd_file.log,
712: fnd_message.get);
713: END IF;
714: CLOSE cur_val_persgrp;
715: END IF;
716:

Line 721: fnd_message.set_module(g_v_package_name||'validate_parameters');

717: -- Validate if atleast one load period is associated to the tax year
718: OPEN cur_val_one_lps(p_v_tax_year_name);
719: FETCH cur_val_one_lps INTO l_c_val;
720: IF cur_val_one_lps%NOTFOUND THEN
721: fnd_message.set_module(g_v_package_name||'validate_parameters');
722: l_b_validate := FALSE;
723: fnd_message.set_name('IGS',
724: 'IGS_FI_1098T_NO_LPS');
725: fnd_message.set_token('TAX_YEAR_NAME',

Line 723: fnd_message.set_name('IGS',

719: FETCH cur_val_one_lps INTO l_c_val;
720: IF cur_val_one_lps%NOTFOUND THEN
721: fnd_message.set_module(g_v_package_name||'validate_parameters');
722: l_b_validate := FALSE;
723: fnd_message.set_name('IGS',
724: 'IGS_FI_1098T_NO_LPS');
725: fnd_message.set_token('TAX_YEAR_NAME',
726: p_v_tax_year_name);
727: fnd_file.put_line(fnd_file.log,

Line 725: fnd_message.set_token('TAX_YEAR_NAME',

721: fnd_message.set_module(g_v_package_name||'validate_parameters');
722: l_b_validate := FALSE;
723: fnd_message.set_name('IGS',
724: 'IGS_FI_1098T_NO_LPS');
725: fnd_message.set_token('TAX_YEAR_NAME',
726: p_v_tax_year_name);
727: fnd_file.put_line(fnd_file.log,
728: fnd_message.get);
729: END IF;

Line 728: fnd_message.get);

724: 'IGS_FI_1098T_NO_LPS');
725: fnd_message.set_token('TAX_YEAR_NAME',
726: p_v_tax_year_name);
727: fnd_file.put_line(fnd_file.log,
728: fnd_message.get);
729: END IF;
730: CLOSE cur_val_one_lps;
731:
732: -- Validate if atleast one Fee Type is associated with the tax year

Line 736: fnd_message.set_module(g_v_package_name||'validate_parameters');

732: -- Validate if atleast one Fee Type is associated with the tax year
733: OPEN cur_val_one_ft(p_v_tax_year_name);
734: FETCH cur_val_one_ft INTO l_c_val;
735: IF cur_val_one_ft%NOTFOUND THEN
736: fnd_message.set_module(g_v_package_name||'validate_parameters');
737: l_b_validate := FALSE;
738: fnd_message.set_name('IGS',
739: 'IGS_FI_1098T_NO_FTS');
740: fnd_message.set_token('TAX_YEAR_NAME',

Line 738: fnd_message.set_name('IGS',

734: FETCH cur_val_one_ft INTO l_c_val;
735: IF cur_val_one_ft%NOTFOUND THEN
736: fnd_message.set_module(g_v_package_name||'validate_parameters');
737: l_b_validate := FALSE;
738: fnd_message.set_name('IGS',
739: 'IGS_FI_1098T_NO_FTS');
740: fnd_message.set_token('TAX_YEAR_NAME',
741: p_v_tax_year_name);
742: fnd_file.put_line(fnd_file.log,

Line 740: fnd_message.set_token('TAX_YEAR_NAME',

736: fnd_message.set_module(g_v_package_name||'validate_parameters');
737: l_b_validate := FALSE;
738: fnd_message.set_name('IGS',
739: 'IGS_FI_1098T_NO_FTS');
740: fnd_message.set_token('TAX_YEAR_NAME',
741: p_v_tax_year_name);
742: fnd_file.put_line(fnd_file.log,
743: fnd_message.get);
744: END IF;

Line 743: fnd_message.get);

739: 'IGS_FI_1098T_NO_FTS');
740: fnd_message.set_token('TAX_YEAR_NAME',
741: p_v_tax_year_name);
742: fnd_file.put_line(fnd_file.log,
743: fnd_message.get);
744: END IF;
745: CLOSE cur_val_one_ft;
746:
747: IF p_v_override_excl NOT IN ('Y','N') THEN

Line 748: fnd_message.set_module(g_v_package_name||'validate_parameters');

744: END IF;
745: CLOSE cur_val_one_ft;
746:
747: IF p_v_override_excl NOT IN ('Y','N') THEN
748: fnd_message.set_module(g_v_package_name||'validate_parameters');
749: l_b_validate := FALSE;
750: fnd_message.set_name('IGS',
751: 'IGS_FI_INVALID_PARAMETER');
752: fnd_message.set_token('PARAMETER',

Line 750: fnd_message.set_name('IGS',

746:
747: IF p_v_override_excl NOT IN ('Y','N') THEN
748: fnd_message.set_module(g_v_package_name||'validate_parameters');
749: l_b_validate := FALSE;
750: fnd_message.set_name('IGS',
751: 'IGS_FI_INVALID_PARAMETER');
752: fnd_message.set_token('PARAMETER',
753: g_v_label_override_excl);
754: fnd_file.put_line(fnd_file.log,

Line 752: fnd_message.set_token('PARAMETER',

748: fnd_message.set_module(g_v_package_name||'validate_parameters');
749: l_b_validate := FALSE;
750: fnd_message.set_name('IGS',
751: 'IGS_FI_INVALID_PARAMETER');
752: fnd_message.set_token('PARAMETER',
753: g_v_label_override_excl);
754: fnd_file.put_line(fnd_file.log,
755: fnd_message.get);
756: END IF;

Line 755: fnd_message.get);

751: 'IGS_FI_INVALID_PARAMETER');
752: fnd_message.set_token('PARAMETER',
753: g_v_label_override_excl);
754: fnd_file.put_line(fnd_file.log,
755: fnd_message.get);
756: END IF;
757:
758: IF p_v_file_addr_correction NOT IN ('Y','N') THEN
759: fnd_message.set_module(g_v_package_name||'validate_parameters');

Line 759: fnd_message.set_module(g_v_package_name||'validate_parameters');

755: fnd_message.get);
756: END IF;
757:
758: IF p_v_file_addr_correction NOT IN ('Y','N') THEN
759: fnd_message.set_module(g_v_package_name||'validate_parameters');
760: l_b_validate := FALSE;
761: fnd_message.set_name('IGS',
762: 'IGS_FI_INVALID_PARAMETER');
763: fnd_message.set_token('PARAMETER',

Line 761: fnd_message.set_name('IGS',

757:
758: IF p_v_file_addr_correction NOT IN ('Y','N') THEN
759: fnd_message.set_module(g_v_package_name||'validate_parameters');
760: l_b_validate := FALSE;
761: fnd_message.set_name('IGS',
762: 'IGS_FI_INVALID_PARAMETER');
763: fnd_message.set_token('PARAMETER',
764: g_v_label_file_addr);
765: fnd_file.put_line(fnd_file.log,

Line 763: fnd_message.set_token('PARAMETER',

759: fnd_message.set_module(g_v_package_name||'validate_parameters');
760: l_b_validate := FALSE;
761: fnd_message.set_name('IGS',
762: 'IGS_FI_INVALID_PARAMETER');
763: fnd_message.set_token('PARAMETER',
764: g_v_label_file_addr);
765: fnd_file.put_line(fnd_file.log,
766: fnd_message.get);
767: END IF;

Line 766: fnd_message.get);

762: 'IGS_FI_INVALID_PARAMETER');
763: fnd_message.set_token('PARAMETER',
764: g_v_label_file_addr);
765: fnd_file.put_line(fnd_file.log,
766: fnd_message.get);
767: END IF;
768:
769: IF p_v_test_run NOT IN ('Y','N') THEN
770: fnd_message.set_module(g_v_package_name||'validate_parameters');

Line 770: fnd_message.set_module(g_v_package_name||'validate_parameters');

766: fnd_message.get);
767: END IF;
768:
769: IF p_v_test_run NOT IN ('Y','N') THEN
770: fnd_message.set_module(g_v_package_name||'validate_parameters');
771: l_b_validate := FALSE;
772: fnd_message.set_name('IGS',
773: 'IGS_FI_INVALID_PARAMETER');
774: fnd_message.set_token('PARAMETER',

Line 772: fnd_message.set_name('IGS',

768:
769: IF p_v_test_run NOT IN ('Y','N') THEN
770: fnd_message.set_module(g_v_package_name||'validate_parameters');
771: l_b_validate := FALSE;
772: fnd_message.set_name('IGS',
773: 'IGS_FI_INVALID_PARAMETER');
774: fnd_message.set_token('PARAMETER',
775: g_v_label_test_run);
776: fnd_file.put_line(fnd_file.log,

Line 774: fnd_message.set_token('PARAMETER',

770: fnd_message.set_module(g_v_package_name||'validate_parameters');
771: l_b_validate := FALSE;
772: fnd_message.set_name('IGS',
773: 'IGS_FI_INVALID_PARAMETER');
774: fnd_message.set_token('PARAMETER',
775: g_v_label_test_run);
776: fnd_file.put_line(fnd_file.log,
777: fnd_message.get);
778: END IF;

Line 777: fnd_message.get);

773: 'IGS_FI_INVALID_PARAMETER');
774: fnd_message.set_token('PARAMETER',
775: g_v_label_test_run);
776: fnd_file.put_line(fnd_file.log,
777: fnd_message.get);
778: END IF;
779:
780: RETURN l_b_validate;
781: END validate_params;

Line 1010: fnd_message.set_name('IGS',

1006: p_ret_ci_sequence_number => l_n_load_ci_seq,
1007: p_message_name => l_v_message_name);
1008:
1009: IF l_v_message_name IS NOT NULL THEN
1010: fnd_message.set_name('IGS',
1011: l_v_message_name);
1012: fnd_message.set_module(g_v_package_name||'box236_credits');
1013: fnd_file.put_line(fnd_file.log,
1014: fnd_message.get);

Line 1012: fnd_message.set_module(g_v_package_name||'box236_credits');

1008:
1009: IF l_v_message_name IS NOT NULL THEN
1010: fnd_message.set_name('IGS',
1011: l_v_message_name);
1012: fnd_message.set_module(g_v_package_name||'box236_credits');
1013: fnd_file.put_line(fnd_file.log,
1014: fnd_message.get);
1015: l_b_process_credit := FALSE;
1016: END IF;

Line 1014: fnd_message.get);

1010: fnd_message.set_name('IGS',
1011: l_v_message_name);
1012: fnd_message.set_module(g_v_package_name||'box236_credits');
1013: fnd_file.put_line(fnd_file.log,
1014: fnd_message.get);
1015: l_b_process_credit := FALSE;
1016: END IF;
1017: END IF;
1018:

Line 1259: fnd_message.set_module(g_v_package_name||'box236_charges');

1255: p_ret_ci_sequence_number => l_n_load_ci_seq,
1256: p_message_name => l_v_message_name);
1257: IF l_v_message_name IS NOT NULL THEN
1258: l_b_prc_chg := FALSE;
1259: fnd_message.set_module(g_v_package_name||'box236_charges');
1260: fnd_message.set_name('IGS',
1261: l_v_message_name);
1262: fnd_file.put_line(fnd_file.log,
1263: fnd_message.get);

Line 1260: fnd_message.set_name('IGS',

1256: p_message_name => l_v_message_name);
1257: IF l_v_message_name IS NOT NULL THEN
1258: l_b_prc_chg := FALSE;
1259: fnd_message.set_module(g_v_package_name||'box236_charges');
1260: fnd_message.set_name('IGS',
1261: l_v_message_name);
1262: fnd_file.put_line(fnd_file.log,
1263: fnd_message.get);
1264: END IF;

Line 1263: fnd_message.get);

1259: fnd_message.set_module(g_v_package_name||'box236_charges');
1260: fnd_message.set_name('IGS',
1261: l_v_message_name);
1262: fnd_file.put_line(fnd_file.log,
1263: fnd_message.get);
1264: END IF;
1265: END IF;
1266:
1267: -- Check for the Prior Load Period

Line 2407: fnd_message.set_name('IGS',

2403: l_v_correction_code := '2';
2404: END IF;
2405:
2406: IF NOT l_b_correction_record THEN
2407: fnd_message.set_name('IGS',
2408: 'IGS_FI_1098T_REC_NOT_CREATED');
2409: fnd_file.put_line(fnd_file.log,
2410: fnd_message.get);
2411: log_to_fnd(p_v_module => 'insert_1098t_data',

Line 2410: fnd_message.get);

2406: IF NOT l_b_correction_record THEN
2407: fnd_message.set_name('IGS',
2408: 'IGS_FI_1098T_REC_NOT_CREATED');
2409: fnd_file.put_line(fnd_file.log,
2410: fnd_message.get);
2411: log_to_fnd(p_v_module => 'insert_1098t_data',
2412: p_v_string => 'Correction Record does not need to be created. Hence exiting from this procedure');
2413: RETURN;
2414: END IF;

Line 2783: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_INV_NOT_FILE'));

2779:
2780: -- If the 1098T transaction has invalid address error code then
2781: -- log the message to the log file
2782: IF l_v_error_code = 'INVALID_ADD' THEN
2783: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGS','IGS_FI_INV_NOT_FILE'));
2784: END IF;
2785:
2786: -- If the name control is invalid, then log the message
2787: IF l_v_val_name_ctrl = 'N' THEN

Line 2788: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGS','IGS_FI_INVALID_NAME_CTRL'));

2784: END IF;
2785:
2786: -- If the name control is invalid, then log the message
2787: IF l_v_val_name_ctrl = 'N' THEN
2788: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGS','IGS_FI_INVALID_NAME_CTRL'));
2789: END IF;
2790: END IF;
2791: END insert_1098t_data;
2792:

Line 2909: fnd_message.set_module(g_v_package_name||'extract_data_main');

2905: CLOSE cur_chk_rec_exists;
2906:
2907: IF NOT l_b_new_run THEN
2908: IF l_rec_1098t_data.override_flag = 'Y' THEN
2909: fnd_message.set_module(g_v_package_name||'extract_data_main');
2910: fnd_message.set_name('IGS',
2911: 'IGS_FI_1098T_STU_OVERRIDDEN');
2912: fnd_message.set_token('TAX_YEAR_NAME',
2913: p_v_tax_year_name);

Line 2910: fnd_message.set_name('IGS',

2906:
2907: IF NOT l_b_new_run THEN
2908: IF l_rec_1098t_data.override_flag = 'Y' THEN
2909: fnd_message.set_module(g_v_package_name||'extract_data_main');
2910: fnd_message.set_name('IGS',
2911: 'IGS_FI_1098T_STU_OVERRIDDEN');
2912: fnd_message.set_token('TAX_YEAR_NAME',
2913: p_v_tax_year_name);
2914: fnd_file.put_line(fnd_file.log,

Line 2912: fnd_message.set_token('TAX_YEAR_NAME',

2908: IF l_rec_1098t_data.override_flag = 'Y' THEN
2909: fnd_message.set_module(g_v_package_name||'extract_data_main');
2910: fnd_message.set_name('IGS',
2911: 'IGS_FI_1098T_STU_OVERRIDDEN');
2912: fnd_message.set_token('TAX_YEAR_NAME',
2913: p_v_tax_year_name);
2914: fnd_file.put_line(fnd_file.log,
2915: fnd_message.get);
2916: RETURN;

Line 2915: fnd_message.get);

2911: 'IGS_FI_1098T_STU_OVERRIDDEN');
2912: fnd_message.set_token('TAX_YEAR_NAME',
2913: p_v_tax_year_name);
2914: fnd_file.put_line(fnd_file.log,
2915: fnd_message.get);
2916: RETURN;
2917: END IF;
2918: END IF;
2919:

Line 2935: fnd_message.set_module(g_v_package_name||'extract_data_main');

2931: FETCH cur_non_res_alien INTO l_var;
2932: CLOSE cur_non_res_alien;
2933:
2934: IF l_var IS NOT NULL THEN
2935: fnd_message.set_module(g_v_package_name||'extract_data_main');
2936: fnd_message.set_name('IGS',
2937: 'IGS_FI_1098T_STU_EXCL_ALIEN');
2938: fnd_file.put_line(fnd_file.log,
2939: fnd_message.get);

Line 2936: fnd_message.set_name('IGS',

2932: CLOSE cur_non_res_alien;
2933:
2934: IF l_var IS NOT NULL THEN
2935: fnd_message.set_module(g_v_package_name||'extract_data_main');
2936: fnd_message.set_name('IGS',
2937: 'IGS_FI_1098T_STU_EXCL_ALIEN');
2938: fnd_file.put_line(fnd_file.log,
2939: fnd_message.get);
2940: RETURN;

Line 2939: fnd_message.get);

2935: fnd_message.set_module(g_v_package_name||'extract_data_main');
2936: fnd_message.set_name('IGS',
2937: 'IGS_FI_1098T_STU_EXCL_ALIEN');
2938: fnd_file.put_line(fnd_file.log,
2939: fnd_message.get);
2940: RETURN;
2941: END IF;
2942: END IF;
2943: END IF;

Line 2976: fnd_message.set_module(g_v_package_name||'extract_data_main');

2972: -- Check if the Non Zero credits global variable has been set to FALSE
2973: -- If yes, then log message and return
2974: IF g_b_chg_crd_found THEN
2975: IF NOT g_b_non_zero_credits_flag THEN
2976: fnd_message.set_module(g_v_package_name||'extract_data_main');
2977: fnd_message.set_name('IGS',
2978: 'IGS_FI_1098T_STU_EXCL_COURSE');
2979: fnd_file.put_line(fnd_file.log,
2980: fnd_message.get);

Line 2977: fnd_message.set_name('IGS',

2973: -- If yes, then log message and return
2974: IF g_b_chg_crd_found THEN
2975: IF NOT g_b_non_zero_credits_flag THEN
2976: fnd_message.set_module(g_v_package_name||'extract_data_main');
2977: fnd_message.set_name('IGS',
2978: 'IGS_FI_1098T_STU_EXCL_COURSE');
2979: fnd_file.put_line(fnd_file.log,
2980: fnd_message.get);
2981: RETURN;

Line 2980: fnd_message.get);

2976: fnd_message.set_module(g_v_package_name||'extract_data_main');
2977: fnd_message.set_name('IGS',
2978: 'IGS_FI_1098T_STU_EXCL_COURSE');
2979: fnd_file.put_line(fnd_file.log,
2980: fnd_message.get);
2981: RETURN;
2982: END IF;
2983: END IF;
2984: END IF;

Line 3057: fnd_message.set_module(g_v_package_name||'extract_data_main');

3053: END IF;
3054:
3055: -- If all box2,3,4 and 5 are 0, then no record needs to be created
3056: IF l_n_box4 = 0 AND l_n_box5 = 0 AND l_n_box2 = 0 AND l_n_box3 = 0 THEN
3057: fnd_message.set_module(g_v_package_name||'extract_data_main');
3058: fnd_message.set_name('IGS',
3059: 'IGS_FI_1098T_BOX_ZERO');
3060: fnd_file.put_line(fnd_file.log,
3061: fnd_message.get);

Line 3058: fnd_message.set_name('IGS',

3054:
3055: -- If all box2,3,4 and 5 are 0, then no record needs to be created
3056: IF l_n_box4 = 0 AND l_n_box5 = 0 AND l_n_box2 = 0 AND l_n_box3 = 0 THEN
3057: fnd_message.set_module(g_v_package_name||'extract_data_main');
3058: fnd_message.set_name('IGS',
3059: 'IGS_FI_1098T_BOX_ZERO');
3060: fnd_file.put_line(fnd_file.log,
3061: fnd_message.get);
3062: RETURN;

Line 3061: fnd_message.get);

3057: fnd_message.set_module(g_v_package_name||'extract_data_main');
3058: fnd_message.set_name('IGS',
3059: 'IGS_FI_1098T_BOX_ZERO');
3060: fnd_file.put_line(fnd_file.log,
3061: fnd_message.get);
3062: RETURN;
3063: END IF;
3064:
3065: -- If the override Exclusions parameter is set to No and

Line 3076: fnd_message.set_module(g_v_package_name||'extract_data_main');

3072:
3073: -- If there are no records existing in the 1098T table
3074: -- then log the message and return
3075: IF l_b_new_run THEN
3076: fnd_message.set_module(g_v_package_name||'extract_data_main');
3077: fnd_message.set_name('IGS',
3078: 'IGS_FI_1098T_STU_EXCL_WAIVE');
3079: fnd_file.put_line(fnd_file.log,
3080: fnd_message.get);

Line 3077: fnd_message.set_name('IGS',

3073: -- If there are no records existing in the 1098T table
3074: -- then log the message and return
3075: IF l_b_new_run THEN
3076: fnd_message.set_module(g_v_package_name||'extract_data_main');
3077: fnd_message.set_name('IGS',
3078: 'IGS_FI_1098T_STU_EXCL_WAIVE');
3079: fnd_file.put_line(fnd_file.log,
3080: fnd_message.get);
3081: RETURN;

Line 3080: fnd_message.get);

3076: fnd_message.set_module(g_v_package_name||'extract_data_main');
3077: fnd_message.set_name('IGS',
3078: 'IGS_FI_1098T_STU_EXCL_WAIVE');
3079: fnd_file.put_line(fnd_file.log,
3080: fnd_message.get);
3081: RETURN;
3082: ELSE
3083: -- Else check for IRS filed flag. If it is set to N, then validation status
3084: -- is Do Not Report

Line 3188: fnd_message.set_module(g_v_package_name||'extract_data');

3184: EXCEPTION
3185: WHEN OTHERS THEN
3186: retcode := 2;
3187: ROLLBACK TO SAVEPOINT SP_EXTRACT_1098T_DATA;
3188: fnd_message.set_module(g_v_package_name||'extract_data');
3189: fnd_file.put_line(fnd_file.log,
3190: sqlerrm);
3191: END;
3192: ELSE

Line 3227: fnd_message.set_module(g_v_package_name||'extract_data');

3223: EXCEPTION
3224: WHEN OTHERS THEN
3225: retcode := 1;
3226: ROLLBACK TO SP_EXTRACT_MAIN;
3227: fnd_message.set_module(g_v_package_name||'extract_data');
3228: fnd_file.put_line(fnd_file.log,
3229: sqlerrm);
3230: END;
3231: END LOOP;

Line 3238: fnd_message.set_name('IGS',

3234:
3235: -- If the Test Run is Yes, then rollback the transactions else commit
3236: IF p_v_test_run = 'Y' THEN
3237: ROLLBACK TO SP_EXTRACT_1098T_DATA;
3238: fnd_message.set_name('IGS',
3239: 'IGS_FI_PRC_TEST_RUN');
3240: fnd_file.put_line(fnd_file.log,
3241: fnd_message.get);
3242: ELSE

Line 3241: fnd_message.get);

3237: ROLLBACK TO SP_EXTRACT_1098T_DATA;
3238: fnd_message.set_name('IGS',
3239: 'IGS_FI_PRC_TEST_RUN');
3240: fnd_file.put_line(fnd_file.log,
3241: fnd_message.get);
3242: ELSE
3243: COMMIT;
3244: END IF;
3245:

Line 3250: fnd_message.set_module(g_v_package_name||'extract');

3246: EXCEPTION
3247: WHEN e_resource_busy THEN
3248: ROLLBACK TO SP_EXTRACT_1098T_DATA;
3249: retcode := 2;
3250: fnd_message.set_module(g_v_package_name||'extract');
3251: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');
3252: fnd_file.put_line(fnd_file.log,fnd_message.get());
3253: fnd_file.new_line(fnd_file.log);
3254: WHEN OTHERS THEN

Line 3251: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');

3247: WHEN e_resource_busy THEN
3248: ROLLBACK TO SP_EXTRACT_1098T_DATA;
3249: retcode := 2;
3250: fnd_message.set_module(g_v_package_name||'extract');
3251: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');
3252: fnd_file.put_line(fnd_file.log,fnd_message.get());
3253: fnd_file.new_line(fnd_file.log);
3254: WHEN OTHERS THEN
3255: retcode := 2;

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

3248: ROLLBACK TO SP_EXTRACT_1098T_DATA;
3249: retcode := 2;
3250: fnd_message.set_module(g_v_package_name||'extract');
3251: fnd_message.set_name('IGS','IGS_FI_RFND_REC_LOCK');
3252: fnd_file.put_line(fnd_file.log,fnd_message.get());
3253: fnd_file.new_line(fnd_file.log);
3254: WHEN OTHERS THEN
3255: retcode := 2;
3256: ROLLBACK TO SP_EXTRACT_1098T_DATA;

Line 3257: fnd_message.set_module(g_v_package_name||'extract');

3253: fnd_file.new_line(fnd_file.log);
3254: WHEN OTHERS THEN
3255: retcode := 2;
3256: ROLLBACK TO SP_EXTRACT_1098T_DATA;
3257: fnd_message.set_module(g_v_package_name||'extract');
3258: igs_ge_msg_stack.conc_exception_hndl;
3259: fnd_file.put_line(fnd_file.log, fnd_message.get || ' - ' || SQLERRM);
3260: END extract;
3261: END igs_fi_1098t_extract_data;

Line 3259: fnd_file.put_line(fnd_file.log, fnd_message.get || ' - ' || SQLERRM);

3255: retcode := 2;
3256: ROLLBACK TO SP_EXTRACT_1098T_DATA;
3257: fnd_message.set_module(g_v_package_name||'extract');
3258: igs_ge_msg_stack.conc_exception_hndl;
3259: fnd_file.put_line(fnd_file.log, fnd_message.get || ' - ' || SQLERRM);
3260: END extract;
3261: END igs_fi_1098t_extract_data;