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

Line 158: fnd_file.put_line(fnd_file.log,

154: -- prepare the Log file line
155: l_message := lpad(l_meaning,length(l_meaning)+p_level*3,' ')||':'||p_value;
156:
157: -- Update the concurrent manager's log file
158: fnd_file.put_line(fnd_file.log,
159: l_message);
160: END log_message;
161:
162: FUNCTION val_rfnd_lim(p_refund_amnt igs_fi_refunds.refund_amount%TYPE) RETURN BOOLEAN AS

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

443: -- person
444: -- Added logging of the error message raised by the procedure Mass Apply
445:
446: fnd_message.set_name('IGS','IGS_FI_RFND_MASS_APP_START');
447: fnd_file.put_line(fnd_file.log,fnd_message.get);
448: fnd_file.new_line(fnd_file.log,1);
449:
450: igs_fi_prc_appl.mass_apply(p_person_id => l_party_id,
451: p_person_id_grp => g_null,

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

444: -- Added logging of the error message raised by the procedure Mass Apply
445:
446: fnd_message.set_name('IGS','IGS_FI_RFND_MASS_APP_START');
447: fnd_file.put_line(fnd_file.log,fnd_message.get);
448: fnd_file.new_line(fnd_file.log,1);
449:
450: igs_fi_prc_appl.mass_apply(p_person_id => l_party_id,
451: p_person_id_grp => g_null,
452: p_credit_number => g_null,

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

453: p_credit_type_id => g_null,
454: p_credit_date_low => g_null,
455: p_credit_date_high => g_null,
456: p_d_gl_date => p_d_gl_date);
457: fnd_file.new_line(fnd_file.log,1);
458: fnd_message.set_name('IGS','IGS_FI_RFND_MASS_APP_END');
459: fnd_file.put_line(fnd_file.log,fnd_message.get);
460: fnd_file.new_line(fnd_file.log,1);
461: EXCEPTION

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

455: p_credit_date_high => g_null,
456: p_d_gl_date => p_d_gl_date);
457: fnd_file.new_line(fnd_file.log,1);
458: fnd_message.set_name('IGS','IGS_FI_RFND_MASS_APP_END');
459: fnd_file.put_line(fnd_file.log,fnd_message.get);
460: fnd_file.new_line(fnd_file.log,1);
461: EXCEPTION
462: WHEN OTHERS THEN
463: ROLLBACK TO RFND_PRC_PLUS;

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

456: p_d_gl_date => p_d_gl_date);
457: fnd_file.new_line(fnd_file.log,1);
458: fnd_message.set_name('IGS','IGS_FI_RFND_MASS_APP_END');
459: fnd_file.put_line(fnd_file.log,fnd_message.get);
460: fnd_file.new_line(fnd_file.log,1);
461: EXCEPTION
462: WHEN OTHERS THEN
463: ROLLBACK TO RFND_PRC_PLUS;
464: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

460: fnd_file.new_line(fnd_file.log,1);
461: EXCEPTION
462: WHEN OTHERS THEN
463: ROLLBACK TO RFND_PRC_PLUS;
464: fnd_file.put_line(fnd_file.log,fnd_message.get);
465: l_exception := TRUE;
466: END;
467:
468: -- If there is an error, then the procedure should exit with the status as FALSE

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

856: p_v_message_name => l_v_message_name
857: );
858: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
859: fnd_message.set_name('IGS',l_v_message_name);
860: fnd_file.put_line(fnd_file.log,fnd_message.get());
861: fnd_file.new_line(fnd_file.log);
862: retcode := 2;
863: RETURN;
864: END IF;

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

857: );
858: IF (l_v_manage_acc = 'OTHER') OR (l_v_manage_acc IS NULL) THEN
859: fnd_message.set_name('IGS',l_v_message_name);
860: fnd_file.put_line(fnd_file.log,fnd_message.get());
861: fnd_file.new_line(fnd_file.log);
862: retcode := 2;
863: RETURN;
864: END IF;
865:

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

872: refund_fee_prd.delete;
873:
874: -- Log the Input parameters
875: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');
876: fnd_file.put_line(fnd_file.log,fnd_message.get);
877:
878: l_var := NULL;
879:
880: -- If the person id is not null, then validate the Person id

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

885: l_party_number,
886: 1);
887: IF (cur_val_party%NOTFOUND AND p_person_id IS NOT NULL) THEN
888: fnd_message.set_name('IGS','IGS_FI_INVALID_PERSON_ID');
889: fnd_file.put_line(fnd_file.log,fnd_message.get);
890: l_val_parameters := FALSE;
891: END IF;
892: CLOSE cur_val_party;
893:

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

903:
904: IF (cur_pers%NOTFOUND AND p_person_id_grp IS NOT NULL) THEN
905:
906: fnd_message.set_name('IGS','IGS_FI_INVPERS_ID_GRP');
907: fnd_file.put_line(fnd_file.log,fnd_message.get);
908: l_val_parameters := FALSE;
909:
910: END IF;
911: CLOSE cur_pers;

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

912:
913: --GL Date parameter is mandatory to this concurrent job, hence it is passed as null, error out NOCOPY the job.
914: IF p_d_gl_date IS NULL THEN
915: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PARAMETER_NULL');
916: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
917: l_val_parameters := FALSE;
918: END IF;
919:
920: --Convert the parameter p_d_gl_date from VARCHAR2 to DATE datatype.

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

940: -- error out NOCOPY
941: -- IGS_FI_PRS_PRSIDGRP_NULL message replaced by IGS_FI_NO_PERS_PGRP
942: IF p_person_id IS NOT NULL AND p_person_id_grp IS NOT NULL THEN
943: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');
944: fnd_file.put_line(fnd_file.log,fnd_message.get);
945: l_val_parameters := FALSE;
946: END IF;
947:
948: --Validate the GL Date.

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

951: p_v_message_name => l_v_message_name
952: );
953: IF l_v_message_name IS NOT NULL THEN
954: FND_MESSAGE.SET_NAME('IGS',l_v_message_name);
955: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
956: l_val_parameters := FALSE;
957: END IF;
958:
959: --Error out NOCOPY the concurrent process if the GL Date is not a valid one.

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

959: --Error out NOCOPY the concurrent process if the GL Date is not a valid one.
960: IF l_v_closing_status NOT IN ('O','F') THEN
961: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_GL_DATE');
962: FND_MESSAGE.SET_TOKEN('GL_DATE',l_d_gl_date);
963: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
964: l_val_parameters := FALSE;
965: END IF;
966:
967: OPEN c_refund_cr_glccid;

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

972: -- if the function to check validity of Liability Account CCID combination returns false
973: -- log the message and errors out
974: IF NOT (igs_fi_gen_apint.chk_liability_acc(p_n_ccid => rec_c_refund_cr_glccid.refund_cr_gl_ccid)) THEN
975: fnd_message.set_name('IGS','IGS_FI_INV_ACC_LIABL');
976: fnd_file.put_line(fnd_file.log,fnd_message.get);
977: l_val_parameters := FALSE;
978: END IF;
979: END IF;
980:

Line 982: fnd_file.new_line(fnd_file.log,2);

978: END IF;
979: END IF;
980:
981:
982: fnd_file.new_line(fnd_file.log,2);
983:
984: IF NOT l_val_parameters THEN
985: retcode := 2;
986: RETURN;

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

997: -- If the Refunds Accounting procedure returns an error, then
998: -- the process should log this in the log file of the concurrent manager
999: IF NOT l_status THEN
1000: fnd_message.set_name('IGS',l_err_msg);
1001: fnd_file.put_line(fnd_file.log,fnd_message.get);
1002: app_exception.raise_exception;
1003: END IF;
1004:
1005: IF p_person_id_grp IS NOT NULL THEN

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

1054: OPEN cur_spnsr(l_n_party_id);
1055: FETCH cur_spnsr INTO l_var;
1056: IF cur_spnsr%FOUND THEN
1057: fnd_message.set_name('IGS','IGS_FI_RFND_NOT_SPNSR');
1058: fnd_file.put_line(fnd_file.log,fnd_message.get);
1059: l_party_process := FALSE;
1060: END IF;
1061: CLOSE cur_spnsr;
1062:

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

1078: g_intermit);
1079: FETCH cur_inst INTO l_var;
1080: IF cur_inst%FOUND THEN
1081: fnd_message.set_name('IGS','IGS_FI_PRG_INTERMIT');
1082: fnd_file.new_line(fnd_file.log,1);
1083: fnd_file.put_line(fnd_file.log,fnd_message.get);
1084: fnd_file.new_line(fnd_file.log,1);
1085: l_party_process:= FALSE;
1086: END IF;

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

1079: FETCH cur_inst INTO l_var;
1080: IF cur_inst%FOUND THEN
1081: fnd_message.set_name('IGS','IGS_FI_PRG_INTERMIT');
1082: fnd_file.new_line(fnd_file.log,1);
1083: fnd_file.put_line(fnd_file.log,fnd_message.get);
1084: fnd_file.new_line(fnd_file.log,1);
1085: l_party_process:= FALSE;
1086: END IF;
1087: CLOSE cur_inst;

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

1080: IF cur_inst%FOUND THEN
1081: fnd_message.set_name('IGS','IGS_FI_PRG_INTERMIT');
1082: fnd_file.new_line(fnd_file.log,1);
1083: fnd_file.put_line(fnd_file.log,fnd_message.get);
1084: fnd_file.new_line(fnd_file.log,1);
1085: l_party_process:= FALSE;
1086: END IF;
1087: CLOSE cur_inst;
1088:

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

1095:
1096: -- If there are none, then refunds should not be processed for the student
1097: IF cur_crs%NOTFOUND THEN
1098: fnd_message.set_name('IGS','IGS_FI_STDNT_NOT_ACTIVE');
1099: fnd_file.new_line(fnd_file.log,1);
1100: fnd_file.put_line(fnd_file.log,fnd_message.get);
1101: fnd_file.new_line(fnd_file.log,1);
1102: l_party_process:= FALSE;
1103: END IF;

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

1096: -- If there are none, then refunds should not be processed for the student
1097: IF cur_crs%NOTFOUND THEN
1098: fnd_message.set_name('IGS','IGS_FI_STDNT_NOT_ACTIVE');
1099: fnd_file.new_line(fnd_file.log,1);
1100: fnd_file.put_line(fnd_file.log,fnd_message.get);
1101: fnd_file.new_line(fnd_file.log,1);
1102: l_party_process:= FALSE;
1103: END IF;
1104: CLOSE cur_crs;

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

1097: IF cur_crs%NOTFOUND THEN
1098: fnd_message.set_name('IGS','IGS_FI_STDNT_NOT_ACTIVE');
1099: fnd_file.new_line(fnd_file.log,1);
1100: fnd_file.put_line(fnd_file.log,fnd_message.get);
1101: fnd_file.new_line(fnd_file.log,1);
1102: l_party_process:= FALSE;
1103: END IF;
1104: CLOSE cur_crs;
1105: END IF;

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

1131: );
1132:
1133: IF l_v_act_plan_name IS NOT NULL THEN
1134: fnd_message.set_name('IGS','IGS_FI_PP_RFND_WARN');
1135: fnd_file.new_line(fnd_file.log,1);
1136: fnd_file.put_line(fnd_file.log,fnd_message.get);
1137: fnd_file.new_line(fnd_file.log,1);
1138: retcode := 1;
1139: END IF;

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

1132:
1133: IF l_v_act_plan_name IS NOT NULL THEN
1134: fnd_message.set_name('IGS','IGS_FI_PP_RFND_WARN');
1135: fnd_file.new_line(fnd_file.log,1);
1136: fnd_file.put_line(fnd_file.log,fnd_message.get);
1137: fnd_file.new_line(fnd_file.log,1);
1138: retcode := 1;
1139: END IF;
1140:

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

1133: IF l_v_act_plan_name IS NOT NULL THEN
1134: fnd_message.set_name('IGS','IGS_FI_PP_RFND_WARN');
1135: fnd_file.new_line(fnd_file.log,1);
1136: fnd_file.put_line(fnd_file.log,fnd_message.get);
1137: fnd_file.new_line(fnd_file.log,1);
1138: retcode := 1;
1139: END IF;
1140:
1141: l_rec_found := FALSE;

Line 1174: fnd_file.put_line(fnd_file.log,

1170: -- this error message should be logged in the log file of the concurrent manager.
1171: IF NOT l_status THEN
1172: fnd_message.set_name('IGS',
1173: l_err_msg);
1174: fnd_file.put_line(fnd_file.log,
1175: fnd_message.get);
1176: ELSE
1177:
1178: -- if the borrower determination procedure returns success, then validate the determination

Line 1186: fnd_file.put_line(fnd_file.log,

1182: fnd_message.set_name('IGS',
1183: 'IGS_FI_RFND_CRD_ACC');
1184: fnd_message.set_token('CRD_NUM',
1185: reccrd.credit_number);
1186: fnd_file.put_line(fnd_file.log,
1187: fnd_message.get);
1188: ELSE
1189:
1190: -- else this credit record has had errors when the PLUS loan process tried to process it.

Line 1196: fnd_file.put_line(fnd_file.log,

1192: fnd_message.set_name('IGS',
1193: 'IGS_FI_RFND_CRD_PLUS');
1194: fnd_message.set_token('CREDIT_NUMBER',
1195: reccrd.credit_number);
1196: fnd_file.put_line(fnd_file.log,
1197: fnd_message.get);
1198: END IF;
1199: END IF;
1200: ELSE

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

1222: 'CREDIT_NUMBER',
1223: reccrd.credit_number,
1224: 1);
1225: fnd_message.set_name('IGS','IGS_FI_REFUND_FTCI');
1226: fnd_file.put_line(fnd_file.log,fnd_message.get);
1227: l_fee_prd := NULL;
1228: fnd_file.put_line(fnd_file.log,fnd_message.get);
1229: ELSE
1230:

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

1224: 1);
1225: fnd_message.set_name('IGS','IGS_FI_REFUND_FTCI');
1226: fnd_file.put_line(fnd_file.log,fnd_message.get);
1227: l_fee_prd := NULL;
1228: fnd_file.put_line(fnd_file.log,fnd_message.get);
1229: ELSE
1230:
1231: -- Else this should be added to the PL/SQL table for the Refunds processing
1232: l_rfnd_cntr := l_rfnd_cntr + 1;

Line 1364: fnd_file.put_line(fnd_file.log,

1360: fnd_message.set_name('IGS',
1361: 'IGS_FI_ADD_DROP');
1362: fnd_message.set_token('FEE_PRD',
1363: l_fee_prd.fee_prd);
1364: fnd_file.put_line(fnd_file.log,
1365: fnd_message.get);
1366: l_process_flag := FALSE;
1367: END IF;
1368: END IF;

Line 1380: fnd_file.put_line(fnd_file.log,

1376: fnd_message.set_name('IGS',
1377: 'IGS_FI_ADD_DROP');
1378: fnd_message.set_token('FEE_PRD',
1379: l_fee_prd.fee_prd);
1380: fnd_file.put_line(fnd_file.log,
1381: fnd_message.get);
1382:
1383: -- If the Add Drop period is valid, then set the l_process_flag to FALSE
1384: -- Based on this l_process_flag, the refunds are processed

Line 1406: fnd_file.new_line(fnd_file.log,

1402: fnd_message.set_token('HIGH_LIM',
1403: To_Char(g_amnt_high));
1404: fnd_message.set_token('LOW_LIM',
1405: To_Char(g_amnt_low));
1406: fnd_file.new_line(fnd_file.log,
1407: 1);
1408: fnd_file.put_line(fnd_file.log,
1409: fnd_message.get);
1410: fnd_file.new_line(fnd_file.log,

Line 1408: fnd_file.put_line(fnd_file.log,

1404: fnd_message.set_token('LOW_LIM',
1405: To_Char(g_amnt_low));
1406: fnd_file.new_line(fnd_file.log,
1407: 1);
1408: fnd_file.put_line(fnd_file.log,
1409: fnd_message.get);
1410: fnd_file.new_line(fnd_file.log,
1411: 1);
1412: ELSE

Line 1410: fnd_file.new_line(fnd_file.log,

1406: fnd_file.new_line(fnd_file.log,
1407: 1);
1408: fnd_file.put_line(fnd_file.log,
1409: fnd_message.get);
1410: fnd_file.new_line(fnd_file.log,
1411: 1);
1412: ELSE
1413:
1414: -- Call the Refunds table handler for creating a record in the Refunds table

Line 1554: fnd_file.put_line(fnd_file.log,

1550: IF NOT l_status THEN
1551: fnd_message.set_name('IGS',
1552: l_err_msg);
1553: l_msg_text := fnd_message.get;
1554: fnd_file.put_line(fnd_file.log,
1555: lpad(l_msg_text,length(l_msg_text)+6,' '));
1556: app_exception.raise_exception;
1557: END IF;
1558: l_unapp_amount := NULL;

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

1563: l_cr_ccid := NULL;
1564:
1565: END IF;
1566: END LOOP;
1567: fnd_file.new_line(fnd_file.log);
1568: EXCEPTION
1569: WHEN OTHERS THEN
1570:
1571: -- If an error happens, then log the error message in the log file and rollback to

Line 1573: fnd_file.put_line(fnd_file.log,

1569: WHEN OTHERS THEN
1570:
1571: -- If an error happens, then log the error message in the log file and rollback to
1572: -- the save point of Refunds
1573: fnd_file.put_line(fnd_file.log,
1574: sqlerrm);
1575: ROLLBACK TO REFUNDS;
1576: l_msg_count := FND_MSG_PUB.Count_Msg;
1577: FOR l_msg_cntr IN 1..l_msg_count LOOP

Line 1578: fnd_file.put_line(fnd_file.log,

1574: sqlerrm);
1575: ROLLBACK TO REFUNDS;
1576: l_msg_count := FND_MSG_PUB.Count_Msg;
1577: FOR l_msg_cntr IN 1..l_msg_count LOOP
1578: fnd_file.put_line(fnd_file.log,
1579: fnd_msg_pub.get(p_msg_index => l_msg_cntr,
1580: p_encoded => 'T'));
1581: END LOOP;
1582: l_exception_flag := TRUE;

Line 1590: fnd_file.put_line(fnd_file.log,

1586: -- Concurrent Manager
1587: IF l_exception_flag THEN
1588: fnd_message.set_name('IGS',
1589: 'IGS_FI_REFUND_ERR');
1590: fnd_file.put_line(fnd_file.log,
1591: fnd_message.get||sqlerrm);
1592: END IF;
1593: END IF;
1594: END IF;

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

1598: -- If no credits have been found for processing then
1599: -- log the message in the log file of the concurrent manager
1600: IF (NOT l_party_process) THEN
1601: fnd_message.set_name('IGS','IGS_FI_RFND_PRC_NULL');
1602: fnd_file.put_line(fnd_file.log, fnd_message.get);
1603: END IF;
1604:
1605: IF (NOT l_rec_found) THEN
1606: fnd_message.set_name('IGS','IGS_FI_NO_RFND_EXCESS_AMT');

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

1603: END IF;
1604:
1605: IF (NOT l_rec_found) THEN
1606: fnd_message.set_name('IGS','IGS_FI_NO_RFND_EXCESS_AMT');
1607: fnd_file.put_line(fnd_file.log, fnd_message.get);
1608: END IF;
1609: ELSE
1610:
1611: -- This means that the holds of STOPREFUNDS exist for the person and no automatic refund

Line 1618: fnd_file.put_line(fnd_file.log,

1614: fnd_message.set_name('IGS',
1615: 'IGS_FI_RFND_HLD_EXSTS');
1616: fnd_message.set_token('PARTY_NUM',
1617: l_party_number);
1618: fnd_file.put_line(fnd_file.log,
1619: fnd_message.get);
1620: END IF;
1621: END IF;
1622: END LOOP;

Line 1635: fnd_file.put_line(fnd_file.log,

1631: EXCEPTION
1632: WHEN e_resource_busy THEN
1633: fnd_message.set_name('IGS',
1634: 'IGS_FI_RFND_REC_LOCK');
1635: fnd_file.put_line(fnd_file.log,
1636: fnd_message.get);
1637: ROLLBACK TO RFND_PRC_BATCH;
1638: retcode := 2;
1639: WHEN OTHERS THEN

Line 1645: fnd_file.put_line(fnd_file.log,

1641: errbuf := 'IGS_GE_UNHANDLED_EXCEPTION';
1642: ROLLBACK TO RFND_PRC_BATCH;
1643: fnd_message.set_name('IGS',
1644: 'IGS_GE_UNHANDLED_EXCEPTION');
1645: fnd_file.put_line(fnd_file.log,
1646: fnd_message.get);
1647: fnd_file.put_line(fnd_file.log,
1648: sqlerrm);
1649: igs_ge_msg_stack.conc_exception_hndl;

Line 1647: fnd_file.put_line(fnd_file.log,

1643: fnd_message.set_name('IGS',
1644: 'IGS_GE_UNHANDLED_EXCEPTION');
1645: fnd_file.put_line(fnd_file.log,
1646: fnd_message.get);
1647: fnd_file.put_line(fnd_file.log,
1648: sqlerrm);
1649: igs_ge_msg_stack.conc_exception_hndl;
1650: END process_batch;
1651: