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

Line 872: fnd_file.new_line(fnd_file.log,1);

868: l_v_fee_cal_type := NULL;
869: l_n_fee_ci_sequence_number := NULL;
870: l_v_ld_cal_type := NULL;
871: l_n_ld_ci_sequence_number := NULL;
872: fnd_file.new_line(fnd_file.log,1);
873: -- To Check Whether The Person Id Is Valid If It Is Provided
874: IF (p_n_person_id IS NOT NULL) THEN
875: OPEN c_person_id(p_n_person_id);
876: FETCH c_person_id INTO l_person_id;

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

876: FETCH c_person_id INTO l_person_id;
877: IF c_person_id%NOTFOUND THEN
878: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
879: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON'));
880: fnd_file.put_line(fnd_file.log,fnd_message.get);
881: l_b_parameter_val_status := FALSE;
882: END IF;
883: CLOSE c_person_id;
884: END IF;

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

890: FETCH c_person_grp_id INTO l_person_grp_id;
891: IF c_person_grp_id%NOTFOUND THEN
892: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
893: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP'));
894: fnd_file.put_line(fnd_file.log,fnd_message.get);
895: l_b_parameter_val_status := FALSE;
896: END IF;
897: CLOSE c_person_grp_id;
898: END IF;

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

913: p_v_message_name => l_v_message_name ,
914: p_b_return_stat =>l_b_return_stat);
915: IF NOT l_b_return_stat THEN
916: fnd_message.set_name('IGS',l_v_message_name);
917: fnd_file.put_line(fnd_file.log,fnd_message.get);
918: l_b_parameter_val_status := FALSE;
919: END IF;
920: ELSE
921: -- The Message 'Invalid Fee Period Parameters Passed To The Process.' Is Logged If

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

920: ELSE
921: -- The Message 'Invalid Fee Period Parameters Passed To The Process.' Is Logged If
922: -- The Function Returns False.
923: fnd_message.set_name('IGS','IGS_FI_FCI_NOTFOUND');
924: fnd_file.put_line(fnd_file.log,fnd_message.get);
925: l_b_parameter_val_status := FALSE;
926: END IF;
927: END IF; -- end of p_v_fee_period validation
928:

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

928:
929: -- To Validate The Parameter Test Run
930: IF (p_v_test_run IS NULL) OR (p_d_gl_date IS NULL ) THEN
931: fnd_message.set_name('IGS','IGS_UC_NO_MANDATORY_PARAMS');
932: fnd_file.put_line(fnd_file.log,fnd_message.get);
933: l_b_parameter_val_status := FALSE;
934: END IF;
935:
936: IF p_v_test_run NOT IN ('Y','N') THEN

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

935:
936: IF p_v_test_run NOT IN ('Y','N') THEN
937: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
938: fnd_message.set_token('PARAMETER',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_RUN'));
939: fnd_file.put_line(fnd_file.log,fnd_message.get);
940: l_b_parameter_val_status := FALSE;
941: END IF;
942: -- To Validate The Parameter Gl Date
943:

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

946: p_v_message_name => l_v_message_name);
947: IF l_v_closing_status NOT IN ('O','F') THEN
948: fnd_message.set_name('IGS','IGS_FI_INVALID_GL_DATE');
949: fnd_message.set_token('GL_DATE',igs_ge_date.igsdate(p_d_gl_date));
950: fnd_file.put_line(fnd_file.log,fnd_message.get);
951: l_b_parameter_val_status := FALSE;
952: END IF;
953:
954: -- To Check Whether Both Person_id And Person Group Values Are Provided.

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

953:
954: -- To Check Whether Both Person_id And Person Group Values Are Provided.
955: IF (p_n_person_id IS NOT NULL) AND (p_n_person_grp_id IS NOT NULL)THEN
956: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');
957: fnd_file.put_line(fnd_file.log,fnd_message.get);
958: l_b_parameter_val_status := FALSE;
959: END IF;
960: --Assign The Values To The Out Parameters.
961: p_v_fee_cal_type :=l_v_fee_cal_type;

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

1032: l_org_id := NULL;
1033: igs_ge_gen_003.set_org_id(l_org_id);
1034: EXCEPTION
1035: WHEN OTHERS THEN
1036: fnd_file.put_line (fnd_file.log, fnd_message.get);
1037: retcode:=2;
1038: RETURN;
1039: END;
1040: retcode := 0;

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

1042: --Logging of all the Parameter to the Log File.
1043: --Logging Person Number.
1044: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1045: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||igs_fi_gen_008.get_party_number(p_n_person_id));
1046: fnd_file.put_line(fnd_file.log,fnd_message.get);
1047:
1048: --Logging Person Group.
1049: OPEN c_get_person_grp(p_n_person_grp_id);
1050: FETCH c_get_person_grp INTO l_c_get_person_grp;

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

1050: FETCH c_get_person_grp INTO l_c_get_person_grp;
1051: CLOSE c_get_person_grp;
1052: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1053: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP')||': '||l_c_get_person_grp.group_cd);
1054: fnd_file.put_line(fnd_file.log,fnd_message.get);
1055:
1056: --Logging Fee Assesment Period.
1057: OPEN c_get_alt_code_desc(cp_v_cal_type => RTRIM(SUBSTR(p_v_fee_period,1,10)),
1058: cp_n_sequence_number => TO_NUMBER(RTRIM(SUBSTR(p_v_fee_period,12))));

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

1065: IF l_c_alt_code_desc.alternate_code IS NOT NULL THEN
1066: l_v_alt_code_msg := ' ( ' || l_c_alt_code_desc.alternate_code || ' ) ';
1067: END IF;
1068: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_ASS_PERIOD')||': '||l_c_alt_code_desc.description || l_v_alt_code_msg );
1069: fnd_file.put_line(fnd_file.log,fnd_message.get);
1070: --Logging Test run.
1071: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1072: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_RUN')||': '||igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_test_run));
1073: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1069: fnd_file.put_line(fnd_file.log,fnd_message.get);
1070: --Logging Test run.
1071: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1072: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_RUN')||': '||igs_fi_gen_gl.get_lkp_meaning('YES_NO',p_v_test_run));
1073: fnd_file.put_line(fnd_file.log,fnd_message.get);
1074:
1075: --Logging GL Date.
1076: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1077: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE')||': '||igs_ge_date.igsdate(p_d_gl_date));

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

1074:
1075: --Logging GL Date.
1076: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1077: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','GL_DATE')||': '||igs_ge_date.igsdate(p_d_gl_date));
1078: fnd_file.put_line(fnd_file.log,fnd_message.get);
1079:
1080: igs_fi_com_rec_interface.chk_manage_account(p_v_manage_acc => l_v_manage_acc,
1081: p_v_message_name => l_v_message_name);
1082:

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

1081: p_v_message_name => l_v_message_name);
1082:
1083: IF l_v_manage_acc IS NULL THEN
1084: fnd_message.set_name('IGS',l_v_message_name);
1085: fnd_file.put_line(fnd_file.log,fnd_message.get);
1086: retcode := 2;
1087: RETURN;
1088: END IF;
1089: -- To Validate The Parameters And Log The Message.

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

1113: p_v_return_status => l_v_return_status);
1114: IF NOT (l_b_recs_found ) THEN
1115: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1116: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1117: fnd_file.put_line(fnd_file.log,fnd_message.get);
1118: fnd_message.set_name('IGF','IGF_AP_NO_DATA_FOUND');
1119: fnd_file.put_line(fnd_file.log,fnd_message.get);
1120: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1121: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));

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

1115: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1116: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1117: fnd_file.put_line(fnd_file.log,fnd_message.get);
1118: fnd_message.set_name('IGF','IGF_AP_NO_DATA_FOUND');
1119: fnd_file.put_line(fnd_file.log,fnd_message.get);
1120: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1121: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1122: fnd_file.put_line(fnd_file.log,fnd_message.get);
1123: END IF;

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

1118: fnd_message.set_name('IGF','IGF_AP_NO_DATA_FOUND');
1119: fnd_file.put_line(fnd_file.log,fnd_message.get);
1120: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1121: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1122: fnd_file.put_line(fnd_file.log,fnd_message.get);
1123: END IF;
1124:
1125: IF l_v_return_status = 'W' THEN
1126: retcode := 1;

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

1133:
1134: IF l_v_status <> 'S' THEN
1135: --Log the error message and stop the processing.
1136: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1137: fnd_file.put_line(fnd_file.log,fnd_message.get);
1138: retcode := 2;
1139: RETURN;
1140: END IF;
1141: OPEN c_ref_person_grp FOR l_dynamic_sql;

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

1163: CLOSE c_ref_person_grp;
1164: IF NOT (l_b_person_grp_data_found) THEN
1165: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1166: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1167: fnd_file.put_line(fnd_file.log,fnd_message.get);
1168: fnd_message.set_name('IGF','IGF_AP_NO_DATA_FOUND');
1169: fnd_file.put_line(fnd_file.log,fnd_message.get);
1170: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1171: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));

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

1165: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1166: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1167: fnd_file.put_line(fnd_file.log,fnd_message.get);
1168: fnd_message.set_name('IGF','IGF_AP_NO_DATA_FOUND');
1169: fnd_file.put_line(fnd_file.log,fnd_message.get);
1170: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1171: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1172: fnd_file.put_line(fnd_file.log,fnd_message.get);
1173: END IF;

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

1168: fnd_message.set_name('IGF','IGF_AP_NO_DATA_FOUND');
1169: fnd_file.put_line(fnd_file.log,fnd_message.get);
1170: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1171: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1172: fnd_file.put_line(fnd_file.log,fnd_message.get);
1173: END IF;
1174: END IF; -- End Of Person Group id based derivation
1175: --To Log The Message If The Process Is A Test Run .
1176: IF p_v_test_run = 'Y' THEN

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

1174: END IF; -- End Of Person Group id based derivation
1175: --To Log The Message If The Process Is A Test Run .
1176: IF p_v_test_run = 'Y' THEN
1177: fnd_message.set_name('IGS','IGS_FI_PRC_TEST_RUN');
1178: fnd_file.put_line(fnd_file.log,fnd_message.get);
1179: END IF;
1180: ELSE
1181: retcode :=2;
1182: END IF;

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

1212: l_unit_section VARCHAR2(4000);
1213: BEGIN
1214: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1215: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||p_v_person_number);
1216: fnd_file.put_line(fnd_file.log,fnd_message.get);
1217: --To Log The Fee Assesment Period.
1218: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1219: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_ASS_PERIOD')||': '||p_v_fee_period);
1220: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1216: fnd_file.put_line(fnd_file.log,fnd_message.get);
1217: --To Log The Fee Assesment Period.
1218: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1219: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_ASS_PERIOD')||': '||p_v_fee_period);
1220: fnd_file.put_line(fnd_file.log,fnd_message.get);
1221: -- To Log The Unit Section .
1222: l_unit_section := igs_fi_gen_apint.get_unit_section_desc( p_n_uoo_id =>p_uooid,
1223: p_v_unit_cd =>NULL,
1224: p_n_version_number =>NULL,

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

1227: p_v_location_cd =>NULL,
1228: p_v_unit_class =>NULL );
1229: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1230: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','USEC')||': '||l_unit_section);
1231: fnd_file.put_line(fnd_file.log,fnd_message.get);
1232: -- To Log The Message
1233: fnd_message.set_name('IGS',p_v_message_name);
1234: fnd_file.put_line(fnd_file.log,fnd_message.get);
1235: -- Logging of Separator

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

1230: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','USEC')||': '||l_unit_section);
1231: fnd_file.put_line(fnd_file.log,fnd_message.get);
1232: -- To Log The Message
1233: fnd_message.set_name('IGS',p_v_message_name);
1234: fnd_file.put_line(fnd_file.log,fnd_message.get);
1235: -- Logging of Separator
1236: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1237: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1238: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1234: fnd_file.put_line(fnd_file.log,fnd_message.get);
1235: -- Logging of Separator
1236: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1237: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1238: fnd_file.put_line(fnd_file.log,fnd_message.get);
1239: END log_error_message;
1240:
1241: PROCEDURE process_special_fees(p_n_person_id IN PLS_INTEGER,
1242: p_v_fee_cal_type IN VARCHAR2,

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

1484: END IF; -- End if of Check For The L_return_status
1485: -- Code To Unravel The Message Stack And Put It In The Log File.
1486: IF l_n_msg_count = 1 THEN
1487: fnd_message.set_encoded(l_v_msg_data);
1488: fnd_file.put_line(fnd_file.log,fnd_message.get);
1489: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1490: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1491: fnd_file.put_line(fnd_file.log,fnd_message.get);
1492: ELSIF l_n_msg_count <> 0 THEN

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

1487: fnd_message.set_encoded(l_v_msg_data);
1488: fnd_file.put_line(fnd_file.log,fnd_message.get);
1489: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1490: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1491: fnd_file.put_line(fnd_file.log,fnd_message.get);
1492: ELSIF l_n_msg_count <> 0 THEN
1493: FOR l_count IN 1 .. l_n_msg_count LOOP
1494: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
1495: fnd_message.set_encoded(l_msg);

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

1492: ELSIF l_n_msg_count <> 0 THEN
1493: FOR l_count IN 1 .. l_n_msg_count LOOP
1494: l_msg := fnd_msg_pub.get(p_msg_index => l_count, p_encoded => 'T');
1495: fnd_message.set_encoded(l_msg);
1496: fnd_file.put_line(fnd_file.log,fnd_message.get);
1497: END LOOP;
1498: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1499: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1500: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1496: fnd_file.put_line(fnd_file.log,fnd_message.get);
1497: END LOOP;
1498: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1499: fnd_message.set_token('END_DATE',RPAD(g_v_seperator,77,g_v_seperator));
1500: fnd_file.put_line(fnd_file.log,fnd_message.get);
1501: END IF;
1502: END IF; --end if of l_b_rel_exists
1503: END IF;
1504: END LOOP; -- End Loop Of Cursor c_get_todo_ref_recs

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

1535: EXCEPTION
1536: WHEN e_lock_exception THEN
1537: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1538: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||l_v_person_number);
1539: fnd_file.put_line(fnd_file.log,fnd_message.get);
1540: fnd_message.set_name('IGS', 'IGS_FI_RFND_REC_LOCK');
1541: fnd_file.put_line(fnd_file.log,fnd_message.get);
1542: fnd_file.new_line(fnd_file.log);
1543: -- Set status to 'Warning'

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

1537: fnd_message.set_name('IGS','IGS_FI_END_DATE');
1538: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||l_v_person_number);
1539: fnd_file.put_line(fnd_file.log,fnd_message.get);
1540: fnd_message.set_name('IGS', 'IGS_FI_RFND_REC_LOCK');
1541: fnd_file.put_line(fnd_file.log,fnd_message.get);
1542: fnd_file.new_line(fnd_file.log);
1543: -- Set status to 'Warning'
1544: p_v_return_status := 'W';
1545: WHEN OTHERS THEN

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

1538: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON')||': '||l_v_person_number);
1539: fnd_file.put_line(fnd_file.log,fnd_message.get);
1540: fnd_message.set_name('IGS', 'IGS_FI_RFND_REC_LOCK');
1541: fnd_file.put_line(fnd_file.log,fnd_message.get);
1542: fnd_file.new_line(fnd_file.log);
1543: -- Set status to 'Warning'
1544: p_v_return_status := 'W';
1545: WHEN OTHERS THEN
1546: fnd_Message.Set_Name ('IGS', 'IGS_GE_UNHANDLED_EXP');