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_GEN_004 dependencies on FND_FILE

Line 345: FND_FILE.Put_Line(FND_FILE.Log,

341: -- tries to run this program then an error message should be logged into the log
342: -- file that the concurrent program is obsolete and should not be run.
343: FND_MESSAGE.Set_Name('IGS',
344: 'IGS_GE_OBSOLETE_JOB');
345: FND_FILE.Put_Line(FND_FILE.Log,
346: FND_MESSAGE.Get);
347: EXCEPTION
348: WHEN OTHERS THEN
349: RETCODE:=2;

Line 370: FND_FILE.Put_Line(FND_FILE.Log,

366: -- tries to run this program then an error message should be logged into the log
367: -- file that the concurrent program is obsolete and should not be run.
368: FND_MESSAGE.Set_Name('IGS',
369: 'IGS_GE_OBSOLETE_JOB');
370: FND_FILE.Put_Line(FND_FILE.Log,
371: FND_MESSAGE.Get);
372: EXCEPTION
373: WHEN OTHERS THEN
374: RETCODE:=2;

Line 432: fnd_file.put_line (fnd_file.log, ' ');

428: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
429: p_v_message_name => l_v_message_name );
430: IF l_v_manage_accounts IS NULL THEN
431: fnd_message.set_name ( 'IGS', l_v_message_name );
432: fnd_file.put_line (fnd_file.log, ' ');
433: fnd_file.put_line (fnd_file.log, fnd_message.get);
434: fnd_file.put_line (fnd_file.log, ' ');
435: retcode :=2;
436: RETURN;

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

429: p_v_message_name => l_v_message_name );
430: IF l_v_manage_accounts IS NULL THEN
431: fnd_message.set_name ( 'IGS', l_v_message_name );
432: fnd_file.put_line (fnd_file.log, ' ');
433: fnd_file.put_line (fnd_file.log, fnd_message.get);
434: fnd_file.put_line (fnd_file.log, ' ');
435: retcode :=2;
436: RETURN;
437: END IF;

Line 434: fnd_file.put_line (fnd_file.log, ' ');

430: IF l_v_manage_accounts IS NULL THEN
431: fnd_message.set_name ( 'IGS', l_v_message_name );
432: fnd_file.put_line (fnd_file.log, ' ');
433: fnd_file.put_line (fnd_file.log, fnd_message.get);
434: fnd_file.put_line (fnd_file.log, ' ');
435: retcode :=2;
436: RETURN;
437: END IF;
438:

Line 570: fnd_file.put_line(fnd_file.log,'');

566: IF (rpt_load_cal_type <> lp_todo_ref_rec.cal_type) OR
567: (rpt_load_ci_sequence_number <> lp_todo_ref_rec.ci_sequence_number) THEN
568:
569: l_v_person_number := igs_fi_gen_008.get_party_number(p_person_id);
570: fnd_file.put_line(fnd_file.log,'');
571: fnd_file.put(fnd_file.log, l_v_person_number||': ');
572:
573: -- get FCI from LCI
574: IF (p_v_load_cal_type IS NULL AND p_n_load_ci_seq_num IS NULL ) THEN

Line 571: fnd_file.put(fnd_file.log, l_v_person_number||': ');

567: (rpt_load_ci_sequence_number <> lp_todo_ref_rec.ci_sequence_number) THEN
568:
569: l_v_person_number := igs_fi_gen_008.get_party_number(p_person_id);
570: fnd_file.put_line(fnd_file.log,'');
571: fnd_file.put(fnd_file.log, l_v_person_number||': ');
572:
573: -- get FCI from LCI
574: IF (p_v_load_cal_type IS NULL AND p_n_load_ci_seq_num IS NULL ) THEN
575: IF igs_fi_gen_001.finp_get_lfci_reln(p_cal_type => lp_todo_ref_rec.cal_type,

Line 637: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGS','IGS_FI_SUCC_TODO_REC'));

633: x_mode => 'R',
634: x_uoo_id => lp_todo_ref_rec.uoo_id
635: );
636:
637: fnd_file.put_line(fnd_file.log, fnd_message.get_string('IGS','IGS_FI_SUCC_TODO_REC'));
638:
639: END IF; -- End if for core fee asssessment routine
640: END IF; -- End if for repeat load calendar record
641:

Line 664: fnd_file.put_line(fnd_file.log,substr(sqlerrm,1,300));

660: WHEN OTHERS THEN
661: ROLLBACK;
662: l_msg_data := 'IGS_GE_UNHANDLED_EXCEPTION';
663: x_return_status := fnd_api.g_ret_sts_error;
664: fnd_file.put_line(fnd_file.log,substr(sqlerrm,1,300));
665:
666: END finp_prc_fa_ref_todo; -- end of local procedure
667:
668: BEGIN

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

679: IF(v_record_found = FALSE) THEN
680: -- Replaced IGS_GE_INVALID_VALUE with IGS_FI_INVALID_PARAMETER, Bug# 2765239
681: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER' );
682: fnd_message.set_token('PARAMETER', igs_ge_gen_004.genp_get_lookup ( 'IGS_FI_LOCKBOX', 'FEE_CAL_TYPE') );
683: fnd_file.put_line (fnd_file.log, fnd_message.get);
684: RETURN;
685: ELSE
686: v_record_found := FALSE;
687: END IF;

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

697: p_v_closing_status => l_c_closing_status,
698: p_v_message_name => v_message_name);
699: IF v_message_name IS NOT NULL THEN
700: fnd_message.set_name('IGS', v_message_name);
701: fnd_file.put_line(fnd_file.log, fnd_message.get);
702: retcode :=2;
703: RETURN;
704: ELSIF l_c_closing_status NOT IN ('O','F') THEN
705: fnd_message.set_name('IGS', 'IGS_FI_INVALID_GL_DATE');

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

703: RETURN;
704: ELSIF l_c_closing_status NOT IN ('O','F') THEN
705: fnd_message.set_name('IGS', 'IGS_FI_INVALID_GL_DATE');
706: fnd_message.set_token('GL_DATE',l_d_gl_date);
707: fnd_file.put_line (fnd_file.log, fnd_message.get);
708: retcode :=2;
709: RETURN;
710: END IF;
711: ELSE

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

709: RETURN;
710: END IF;
711: ELSE
712: fnd_message.set_name('IGS', 'IGS_UC_NO_MANDATORY_PARAMS');
713: fnd_file.put_line (fnd_file.log, fnd_message.get);
714: retcode :=2;
715: RETURN;
716: END IF;
717:

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

720: -- Added as part of Enh# 3117341, Audit Special Fees.
721: l_v_include_audit := fnd_profile.value('IGS_FI_CHARGE_AUDIT_FEES');
722: IF l_v_include_audit IS NULL THEN
723: fnd_message.set_name('IGS', 'IGS_FI_SP_FEE_NO_PROFILE');
724: fnd_file.put_line (fnd_file.log, fnd_message.get);
725: retcode :=2;
726: RETURN;
727: END IF;
728:

Line 767: fnd_file.put_line(fnd_file.log,SUBSTR(SQLERRM,1,300));

763: p_v_load_cal_type => l_v_load_cal_type,
764: p_n_load_ci_seq_num => l_n_load_ci_seq_num);
765: EXCEPTION
766: WHEN OTHERS THEN
767: fnd_file.put_line(fnd_file.log,SUBSTR(SQLERRM,1,300));
768: END;
769:
770: IF l_return_status = fnd_api.g_ret_sts_error THEN
771: -- Bug# 2734512, Added following message handling

Line 778: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

774: fnd_msg_pub.count_and_get( p_count => l_n_msg_count,
775: p_data => l_v_msg_data);
776: IF l_n_msg_count = 1 THEN
777: fnd_message.set_encoded(l_v_msg_data);
778: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
779: ELSIF l_n_msg_count > 1 THEN
780: FOR l_var IN 1 .. l_n_msg_count LOOP
781: fnd_message.set_encoded(fnd_msg_pub.get);
782: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

Line 782: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

778: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
779: ELSIF l_n_msg_count > 1 THEN
780: FOR l_var IN 1 .. l_n_msg_count LOOP
781: fnd_message.set_encoded(fnd_msg_pub.get);
782: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
783: END LOOP;
784: END IF;
785: END IF;
786: END IF;

Line 811: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION'));

807: x_logical_delete_dt => SYSDATE,
808: x_mode => 'R');
809: EXCEPTION
810: WHEN OTHERS THEN
811: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION'));
812: FND_FILE.Put_Line(FND_FILE.Log,substr(sqlerrm,1,300));
813: END;
814: -- assignment of repeat variable rpt_person_id
815: l_rpt_person_id := v_student_todo_rec.person_id;

Line 812: FND_FILE.Put_Line(FND_FILE.Log,substr(sqlerrm,1,300));

808: x_mode => 'R');
809: EXCEPTION
810: WHEN OTHERS THEN
811: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING ('IGS', 'IGS_GE_UNHANDLED_EXCEPTION'));
812: FND_FILE.Put_Line(FND_FILE.Log,substr(sqlerrm,1,300));
813: END;
814: -- assignment of repeat variable rpt_person_id
815: l_rpt_person_id := v_student_todo_rec.person_id;
816: ELSE

Line 828: FND_FILE.Put_Line(FND_FILE.Log,substr(sqlerrm,1,300));

824:
825: EXCEPTION
826: WHEN OTHERS THEN
827: RETCODE:=2;
828: FND_FILE.Put_Line(FND_FILE.Log,substr(sqlerrm,1,300));
829: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
830: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
831: END;
832: END finp_prc_enr_fa_todo;

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

965: l_org_id := NULL;
966: igs_ge_gen_003.set_org_id(l_org_id);
967: EXCEPTION
968: WHEN OTHERS THEN
969: fnd_file.put_line (fnd_file.log, fnd_message.get);
970: retcode :=2;
971: RETURN;
972: END;
973: retcode := 0;

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

1018: CLOSE cur_pers_grp;
1019: END IF;
1020:
1021: IF(p_trace_on IS NULL ) THEN
1022: fnd_file.new_line(fnd_file.log);
1023: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1024: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON'));
1025: fnd_file.put_line (fnd_file.log, fnd_message.get);
1026: fnd_file.new_line(fnd_file.log);

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

1021: IF(p_trace_on IS NULL ) THEN
1022: fnd_file.new_line(fnd_file.log);
1023: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1024: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON'));
1025: fnd_file.put_line (fnd_file.log, fnd_message.get);
1026: fnd_file.new_line(fnd_file.log);
1027: retcode:=2;
1028: RETURN;
1029: END IF;

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

1022: fnd_file.new_line(fnd_file.log);
1023: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1024: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON'));
1025: fnd_file.put_line (fnd_file.log, fnd_message.get);
1026: fnd_file.new_line(fnd_file.log);
1027: retcode:=2;
1028: RETURN;
1029: END IF;
1030:

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

1028: RETURN;
1029: END IF;
1030:
1031: IF( p_test_run IS NULL ) THEN
1032: fnd_file.new_line(fnd_file.log);
1033: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1034: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN'));
1035: fnd_file.put_line (fnd_file.log, fnd_message.get);
1036: retcode:=2;

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

1031: IF( p_test_run IS NULL ) THEN
1032: fnd_file.new_line(fnd_file.log);
1033: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1034: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN'));
1035: fnd_file.put_line (fnd_file.log, fnd_message.get);
1036: retcode:=2;
1037: RETURN;
1038: END IF;
1039:

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

1037: RETURN;
1038: END IF;
1039:
1040: IF( l_d_gl_date IS NULL ) THEN
1041: fnd_file.new_line(fnd_file.log);
1042: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1043: fnd_message.set_token('PARAMETER', igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'GL_DATE'));
1044: fnd_file.put_line (fnd_file.log, fnd_message.get);
1045: retcode:=2;

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

1040: IF( l_d_gl_date IS NULL ) THEN
1041: fnd_file.new_line(fnd_file.log);
1042: fnd_message.set_name('IGS', 'IGS_FI_INVALID_PARAMETER');
1043: fnd_message.set_token('PARAMETER', igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'GL_DATE'));
1044: fnd_file.put_line (fnd_file.log, fnd_message.get);
1045: retcode:=2;
1046: RETURN;
1047: END IF;
1048:

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

1130: igs_ge_msg_stack.ADD;
1131: app_exception.raise_exception(null, null, fnd_message.get);
1132: END IF;
1133:
1134: fnd_file.new_line(fnd_file.log);
1135: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RUN_COMMENT') || ': ' || p_comments);
1136: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NUM');
1137: IF l_n_person_id IS NOT NULL THEN
1138: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(l_n_person_id));

Line 1135: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RUN_COMMENT') || ': ' || p_comments);

1131: app_exception.raise_exception(null, null, fnd_message.get);
1132: END IF;
1133:
1134: fnd_file.new_line(fnd_file.log);
1135: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RUN_COMMENT') || ': ' || p_comments);
1136: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NUM');
1137: IF l_n_person_id IS NOT NULL THEN
1138: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(l_n_person_id));
1139: ELSE

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

1138: fnd_message.set_token('PERSON_NUM',igs_fi_gen_008.get_party_number(l_n_person_id));
1139: ELSE
1140: fnd_message.set_token('PERSON_NUM',l_n_person_id);
1141: END IF;
1142: fnd_file.put_line (fnd_file.log, fnd_message.get);
1143: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'PS') || ': ' || p_course_cd);
1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));
1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);
1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);

Line 1143: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'PS') || ': ' || p_course_cd);

1139: ELSE
1140: fnd_message.set_token('PERSON_NUM',l_n_person_id);
1141: END IF;
1142: fnd_file.put_line (fnd_file.log, fnd_message.get);
1143: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'PS') || ': ' || p_course_cd);
1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));
1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);
1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);
1147: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_trace_on));

Line 1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));

1140: fnd_message.set_token('PERSON_NUM',l_n_person_id);
1141: END IF;
1142: fnd_file.put_line (fnd_file.log, fnd_message.get);
1143: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'PS') || ': ' || p_course_cd);
1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));
1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);
1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);
1147: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_trace_on));
1148: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_run));

Line 1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);

1141: END IF;
1142: fnd_file.put_line (fnd_file.log, fnd_message.get);
1143: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'PS') || ': ' || p_course_cd);
1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));
1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);
1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);
1147: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_trace_on));
1148: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_run));
1149: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'PROCESS_MODE') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_PROCESS_MODE', p_process_mode));

Line 1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);

1142: fnd_file.put_line (fnd_file.log, fnd_message.get);
1143: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'PS') || ': ' || p_course_cd);
1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));
1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);
1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);
1147: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_trace_on));
1148: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_run));
1149: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'PROCESS_MODE') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_PROCESS_MODE', p_process_mode));
1150: fnd_message.set_name('IGS', 'IGS_FI_PERSON_GROUP');

Line 1147: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_trace_on));

1143: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'PS') || ': ' || p_course_cd);
1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));
1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);
1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);
1147: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_trace_on));
1148: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_run));
1149: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'PROCESS_MODE') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_PROCESS_MODE', p_process_mode));
1150: fnd_message.set_name('IGS', 'IGS_FI_PERSON_GROUP');
1151: IF l_n_person_grp_id IS NOT NULL THEN

Line 1148: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_run));

1144: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_ASS_PERIOD') || ': ' || SUBSTR(p_fee_cal,1,40));
1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);
1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);
1147: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_trace_on));
1148: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_run));
1149: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'PROCESS_MODE') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_PROCESS_MODE', p_process_mode));
1150: fnd_message.set_name('IGS', 'IGS_FI_PERSON_GROUP');
1151: IF l_n_person_grp_id IS NOT NULL THEN
1152: fnd_message.set_token('PERSON_GRP',igs_fi_gen_005.finp_get_prsid_grp_code(l_n_person_grp_id));

Line 1149: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'PROCESS_MODE') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_PROCESS_MODE', p_process_mode));

1145: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || p_fee_category);
1146: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || p_fee_type);
1147: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TRACE_ON') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_trace_on));
1148: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEST_RUN') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_test_run));
1149: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'PROCESS_MODE') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_PROCESS_MODE', p_process_mode));
1150: fnd_message.set_name('IGS', 'IGS_FI_PERSON_GROUP');
1151: IF l_n_person_grp_id IS NOT NULL THEN
1152: fnd_message.set_token('PERSON_GRP',igs_fi_gen_005.finp_get_prsid_grp_code(l_n_person_grp_id));
1153: ELSE

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

1152: fnd_message.set_token('PERSON_GRP',igs_fi_gen_005.finp_get_prsid_grp_code(l_n_person_grp_id));
1153: ELSE
1154: fnd_message.set_token('PERSON_GRP',l_n_person_grp_id);
1155: END IF;
1156: fnd_file.put_line (fnd_file.log, fnd_message.get);
1157: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CAREER') || ': ' || p_c_career);
1158: fnd_message.set_name('IGS', 'IGS_FI_GL_DATE');
1159: fnd_message.set_token('GL_DATE', TO_CHAR(l_d_gl_date, 'DD-MON-YYYY'));
1160: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 1157: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CAREER') || ': ' || p_c_career);

1153: ELSE
1154: fnd_message.set_token('PERSON_GRP',l_n_person_grp_id);
1155: END IF;
1156: fnd_file.put_line (fnd_file.log, fnd_message.get);
1157: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CAREER') || ': ' || p_c_career);
1158: fnd_message.set_name('IGS', 'IGS_FI_GL_DATE');
1159: fnd_message.set_token('GL_DATE', TO_CHAR(l_d_gl_date, 'DD-MON-YYYY'));
1160: fnd_file.put_line (fnd_file.log, fnd_message.get);
1161:

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

1156: fnd_file.put_line (fnd_file.log, fnd_message.get);
1157: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CAREER') || ': ' || p_c_career);
1158: fnd_message.set_name('IGS', 'IGS_FI_GL_DATE');
1159: fnd_message.set_token('GL_DATE', TO_CHAR(l_d_gl_date, 'DD-MON-YYYY'));
1160: fnd_file.put_line (fnd_file.log, fnd_message.get);
1161:
1162: -- case in which the person id is not provided but the person group id is provided.
1163: IF l_n_person_grp_id is NOT NULL AND l_n_person_id is NULL THEN
1164: -- Get the select query for REF CURSOR by calling igs_pe_dynamic_persid_group.igs_get_dynamic_sql

Line 1174: fnd_file.put_line( fnd_file.log, RPAD('=', '79', '=') );

1170: END IF;
1171:
1172:
1173: IF (p_trace_on = 'Y') THEN
1174: fnd_file.put_line( fnd_file.log, RPAD('=', '79', '=') );
1175: OPEN cur_fee_calc_mthd;
1176: FETCH cur_fee_calc_mthd INTO l_fee_calc_mthd_code;
1177: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CALC_MTHD') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_FEE_CALC_MTHD',l_fee_calc_mthd_code));
1178: CLOSE cur_fee_calc_mthd;

Line 1177: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CALC_MTHD') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_FEE_CALC_MTHD',l_fee_calc_mthd_code));

1173: IF (p_trace_on = 'Y') THEN
1174: fnd_file.put_line( fnd_file.log, RPAD('=', '79', '=') );
1175: OPEN cur_fee_calc_mthd;
1176: FETCH cur_fee_calc_mthd INTO l_fee_calc_mthd_code;
1177: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CALC_MTHD') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_FEE_CALC_MTHD',l_fee_calc_mthd_code));
1178: CLOSE cur_fee_calc_mthd;
1179: l_b_fci_lci := igs_fi_gen_001.finp_get_lfci_reln( l_v_fee_cal_type,
1180: l_n_fee_ci_sequence_number,
1181: 'FEE',

Line 1186: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_AS_ALL_TERM', 'TERM') || ': ' || igs_ca_gen_001.calp_get_alt_cd(l_v_load_cal_type,l_n_load_ci_sequence_number));

1182: l_v_load_cal_type,
1183: l_n_load_ci_sequence_number,
1184: l_v_message_name);
1185: IF l_b_fci_lci=TRUE THEN
1186: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_AS_ALL_TERM', 'TERM') || ': ' || igs_ca_gen_001.calp_get_alt_cd(l_v_load_cal_type,l_n_load_ci_sequence_number));
1187: END IF;
1188: fnd_file.put_line( fnd_file.log, RPAD('=', '79', '=') );
1189: END IF;
1190:

Line 1188: fnd_file.put_line( fnd_file.log, RPAD('=', '79', '=') );

1184: l_v_message_name);
1185: IF l_b_fci_lci=TRUE THEN
1186: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_AS_ALL_TERM', 'TERM') || ': ' || igs_ca_gen_001.calp_get_alt_cd(l_v_load_cal_type,l_n_load_ci_sequence_number));
1187: END IF;
1188: fnd_file.put_line( fnd_file.log, RPAD('=', '79', '=') );
1189: END IF;
1190:
1191: -- Open the REF CURSOR for above derived SQL statement ( l_dynamic_sql )
1192: OPEN c_ref_person_grp FOR l_dynamic_sql;

Line 1271: fnd_file.put_line(fnd_file.log,

1267: END IF;
1268: IF p_test_run = 'Y' THEN
1269: fnd_message.set_name('IGS',
1270: 'IGS_FI_PRC_TEST_RUN');
1271: fnd_file.put_line(fnd_file.log,
1272: fnd_message.get);
1273: END IF;
1274:
1275: RETURN;

Line 1311: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

1307:
1308: --As part of bug fix of bug #2318488 the following code has been added
1309: retcode:=0;
1310: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_OBSOLETE_JOB');
1311: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: RETCODE:=2;

Line 1341: FND_FILE.Put_Line(FND_FILE.Log,

1337: -- tries to run this program then an error message should be logged into the log
1338: -- file that the concurrent program is obsolete and should not be run.
1339: FND_MESSAGE.Set_Name('IGS',
1340: 'IGS_GE_OBSOLETE_JOB');
1341: FND_FILE.Put_Line(FND_FILE.Log,
1342: FND_MESSAGE.Get);
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: RETCODE:=2;