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_FILE

Line 503: fnd_file.put_line(fnd_file.log,

499: Change History
500: Who When What
501: ***************************************************************** */
502: BEGIN
503: fnd_file.put_line(fnd_file.log,
504: p_v_parm_name||' : '||p_v_parm_value);
505: END log_line;
506:
507: FUNCTION chk_non_credit_course(p_n_person_id igs_pe_person_base_v.person_id%TYPE,

Line 574: fnd_file.put_line(fnd_file.log,

570: l_v_group_cd igs_pe_persid_group_all.group_cd%TYPE;
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:

Line 600: fnd_file.put_line(fnd_file.log,

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:
604: FUNCTION validate_params(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

Line 653: fnd_file.put_line(fnd_file.log,

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;
656:
657: -- Validate if neither Person ID nor Person ID Group is passed

Line 663: fnd_file.put_line(fnd_file.log,

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;
666:
667: -- Validate Tax Year

Line 677: fnd_file.put_line(fnd_file.log,

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;
680: CLOSE cur_1098t_setup;
681:

Line 693: fnd_file.put_line(fnd_file.log,

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;
696: CLOSE cur_val_person_id;
697: END IF;

Line 711: fnd_file.put_line(fnd_file.log,

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;
714: CLOSE cur_val_persgrp;
715: END IF;

Line 727: fnd_file.put_line(fnd_file.log,

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;
730: CLOSE cur_val_one_lps;
731:

Line 742: fnd_file.put_line(fnd_file.log,

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;
745: CLOSE cur_val_one_ft;
746:

Line 754: fnd_file.put_line(fnd_file.log,

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;
757:
758: IF p_v_file_addr_correction NOT IN ('Y','N') THEN

Line 765: fnd_file.put_line(fnd_file.log,

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;
768:
769: IF p_v_test_run NOT IN ('Y','N') THEN

Line 776: fnd_file.put_line(fnd_file.log,

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;
779:
780: RETURN l_b_validate;

Line 1013: fnd_file.put_line(fnd_file.log,

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;
1017: END IF;

Line 1262: fnd_file.put_line(fnd_file.log,

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;
1265: END IF;
1266:

Line 2259: fnd_file.new_line(fnd_file.log);

2255:
2256: log_line(g_v_label_tin,
2257: l_v_api_pers_id);
2258:
2259: fnd_file.new_line(fnd_file.log);
2260:
2261: IF NOT l_b_rec_exists THEN
2262:
2263: -- If there are no records existing, then create a new record in the 1098T Extract table

Line 2409: fnd_file.put_line(fnd_file.log,

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',
2412: p_v_string => 'Correction Record does not need to be created. Hence exiting from this procedure');
2413: RETURN;

Line 2763: fnd_file.new_line(fnd_file.log);

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,
2766: p_n_box2);
2767: log_line(g_v_label_box3,

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 2888: fnd_file.new_line(fnd_file.log);

2884: CLOSE cur_pers_dtl;
2885:
2886: l_v_full_name := l_rec_pers_dtl.last_name||' '||l_rec_pers_dtl.first_name;
2887:
2888: fnd_file.new_line(fnd_file.log);
2889:
2890: fnd_file.put_line(fnd_file.log,
2891: g_v_line_sep);
2892: log_line(g_v_label_person,

Line 2890: fnd_file.put_line(fnd_file.log,

2886: l_v_full_name := l_rec_pers_dtl.last_name||' '||l_rec_pers_dtl.first_name;
2887:
2888: fnd_file.new_line(fnd_file.log);
2889:
2890: fnd_file.put_line(fnd_file.log,
2891: g_v_line_sep);
2892: log_line(g_v_label_person,
2893: l_rec_pers_dtl.person_number);
2894: log_line(g_v_label_stdnt_name,

Line 2914: fnd_file.put_line(fnd_file.log,

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;
2917: END IF;
2918: END IF;

Line 2938: fnd_file.put_line(fnd_file.log,

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;
2941: END IF;
2942: END IF;

Line 2979: fnd_file.put_line(fnd_file.log,

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;
2982: END IF;
2983: END IF;

Line 3060: fnd_file.put_line(fnd_file.log,

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;
3063: END IF;
3064:

Line 3079: fnd_file.put_line(fnd_file.log,

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;
3082: ELSE
3083: -- Else check for IRS filed flag. If it is set to N, then validation status

Line 3189: fnd_file.put_line(fnd_file.log,

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
3193:

Line 3202: fnd_file.put_line(fnd_file.log, l_v_stmnt);

3198: p_status => l_v_status,
3199: p_group_type => lv_group_type);
3200:
3201: IF l_v_status <> 'S' THEN
3202: fnd_file.put_line(fnd_file.log, l_v_stmnt);
3203: retcode := 2;
3204: RETURN;
3205: END IF;
3206:

Line 3228: fnd_file.put_line(fnd_file.log,

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;
3232: CLOSE cur_per_grp;

Line 3240: fnd_file.put_line(fnd_file.log,

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
3243: COMMIT;
3244: END IF;

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 3253: fnd_file.new_line(fnd_file.log);

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;
3257: fnd_message.set_module(g_v_package_name||'extract');

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;