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_MESSAGE

Line 446: fnd_message.set_name('IGS','IGS_FI_RFND_MASS_APP_START');

442: -- Call the procedure for the Mass Application of all the credits and the charges for the
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,

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 458: fnd_message.set_name('IGS','IGS_FI_RFND_MASS_APP_END');

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
462: WHEN OTHERS THEN

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 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 531: fnd_message.set_name('IGS',

527: RETURN;
528: END IF;
529:
530: -- Get the reason for the creation of refund transaction from the message
531: fnd_message.set_name('IGS',
532: 'IGS_FI_REFUND_REASON_PLUS');
533: l_reason := fnd_message.get;
534:
535: SAVEPOINT REFUNDS;

Line 533: l_reason := fnd_message.get;

529:
530: -- Get the reason for the creation of refund transaction from the message
531: fnd_message.set_name('IGS',
532: 'IGS_FI_REFUND_REASON_PLUS');
533: l_reason := fnd_message.get;
534:
535: SAVEPOINT REFUNDS;
536:
537: l_rowid := NULL;

Line 859: fnd_message.set_name('IGS',l_v_message_name);

855: igs_fi_com_rec_interface.chk_manage_account( p_v_manage_acc => l_v_manage_acc,
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;

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 875: fnd_message.set_name('IGS','IGS_FI_ANC_LOG_PARM');

871: refund_calc.delete;
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:

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 888: fnd_message.set_name('IGS','IGS_FI_INVALID_PERSON_ID');

884: 'PERSON',
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;

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 906: fnd_message.set_name('IGS','IGS_FI_INVPERS_ID_GRP');

902: 1);
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;

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 915: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PARAMETER_NULL');

911: CLOSE cur_pers;
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:

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 943: fnd_message.set_name('IGS','IGS_FI_NO_PERS_PGRP');

939: -- If the Person Id and the Person id Group are passed, then the process should
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:

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 954: FND_MESSAGE.SET_NAME('IGS',l_v_message_name);

950: p_v_closing_status => l_v_closing_status,
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:

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 961: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_GL_DATE');

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

Line 962: FND_MESSAGE.SET_TOKEN('GL_DATE',l_d_gl_date);

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

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 975: fnd_message.set_name('IGS','IGS_FI_INV_ACC_LIABL');

971: IF rec_c_refund_cr_glccid.refund_cr_gl_ccid IS NOT NULL THEN
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;

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 1000: fnd_message.set_name('IGS',l_err_msg);

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

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 1057: fnd_message.set_name('IGS','IGS_FI_RFND_NOT_SPNSR');

1053: -- refunds for the next person
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;

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 1081: fnd_message.set_name('IGS','IGS_FI_PRG_INTERMIT');

1077: OPEN cur_inst(l_n_party_id,
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;

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 1098: fnd_message.set_name('IGS','IGS_FI_STDNT_NOT_ACTIVE');

1094: FETCH cur_crs INTO l_var;
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;

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 1134: fnd_message.set_name('IGS','IGS_FI_PP_RFND_WARN');

1130: p_v_act_plan_name => l_v_act_plan_name
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;

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 1172: fnd_message.set_name('IGS',

1168:
1169: -- If the Borrower's Determination process results in an error, then
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

Line 1175: fnd_message.get);

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
1179: -- if the borrower determination is ON ACCOUNT, then log this in the log file of the

Line 1182: fnd_message.set_name('IGS',

1178: -- if the borrower determination procedure returns success, then validate the determination
1179: -- if the borrower determination is ON ACCOUNT, then log this in the log file of the
1180: -- concurrent manager and no refunds need to be processed for this
1181: IF l_determination = g_on_acc THEN
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,

Line 1184: fnd_message.set_token('CRD_NUM',

1180: -- concurrent manager and no refunds need to be processed for this
1181: IF l_determination = g_on_acc THEN
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

Line 1187: fnd_message.get);

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.
1191: -- Hence, this should be logged in the log file of the concurrent manager

Line 1192: fnd_message.set_name('IGS',

1188: ELSE
1189:
1190: -- else this credit record has had errors when the PLUS loan process tried to process it.
1191: -- Hence, this should be logged in the log file of the concurrent manager
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,

Line 1194: fnd_message.set_token('CREDIT_NUMBER',

1190: -- else this credit record has had errors when the PLUS loan process tried to process it.
1191: -- Hence, this should be logged in the log file of the concurrent manager
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;

Line 1197: fnd_message.get);

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
1201: l_fee_cal_type := reccrd.fee_cal_type;

Line 1225: fnd_message.set_name('IGS','IGS_FI_REFUND_FTCI');

1221: log_message(g_msg_lkp,
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

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 1360: fnd_message.set_name('IGS',

1356: l_fee_ci_sequence_number) THEN
1357:
1358: -- If the function returns true, then this fee period should not be processed for refunds as it is still
1359: -- in the Add Drop period
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,

Line 1362: fnd_message.set_token('FEE_PRD',

1358: -- If the function returns true, then this fee period should not be processed for refunds as it is still
1359: -- in the Add Drop period
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;

Line 1365: fnd_message.get);

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;
1369: ELSIF ((l_process_flag) AND (l_fa_received = FALSE)) THEN

Line 1376: fnd_message.set_name('IGS',

1372: -- the Add Drop period is there for the Fee Calendar Instance
1373: IF ((p_add_drop IS NOT NULL) AND (p_add_drop = 'ALL')) THEN
1374: IF IGS_FI_GEN_REFUNDS.Val_Add_Drop(l_fee_cal_type,
1375: l_fee_ci_sequence_number) THEN
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,

Line 1378: fnd_message.set_token('FEE_PRD',

1374: IF IGS_FI_GEN_REFUNDS.Val_Add_Drop(l_fee_cal_type,
1375: l_fee_ci_sequence_number) THEN
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:

Line 1381: fnd_message.get);

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
1385: l_process_flag := FALSE;

Line 1398: fnd_message.set_name('IGS',

1394: -- call the function val_rfnd_lim to validate if the refund amount is within the Tolerance
1395: -- limits. If the refund amount is not within the Tolerance limits then refunds should not be
1396: -- processed and the log file of the concurrent manager should be updated appropriately
1397: IF NOT val_rfnd_lim(l_rfnd_amnt) THEN
1398: fnd_message.set_name('IGS',
1399: 'IGS_FI_TOL_LIM_DEFIED');
1400: fnd_message.set_token('REF_AMOUNT',
1401: To_Char(l_rfnd_amnt));
1402: fnd_message.set_token('HIGH_LIM',

Line 1400: fnd_message.set_token('REF_AMOUNT',

1396: -- processed and the log file of the concurrent manager should be updated appropriately
1397: IF NOT val_rfnd_lim(l_rfnd_amnt) THEN
1398: fnd_message.set_name('IGS',
1399: 'IGS_FI_TOL_LIM_DEFIED');
1400: fnd_message.set_token('REF_AMOUNT',
1401: To_Char(l_rfnd_amnt));
1402: fnd_message.set_token('HIGH_LIM',
1403: To_Char(g_amnt_high));
1404: fnd_message.set_token('LOW_LIM',

Line 1402: fnd_message.set_token('HIGH_LIM',

1398: fnd_message.set_name('IGS',
1399: 'IGS_FI_TOL_LIM_DEFIED');
1400: fnd_message.set_token('REF_AMOUNT',
1401: To_Char(l_rfnd_amnt));
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,

Line 1404: fnd_message.set_token('LOW_LIM',

1400: fnd_message.set_token('REF_AMOUNT',
1401: To_Char(l_rfnd_amnt));
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,

Line 1409: fnd_message.get);

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

Line 1418: fnd_message.set_name('IGS',

1414: -- Call the Refunds table handler for creating a record in the Refunds table
1415: l_rowid := g_null;
1416: l_refund_id := g_null;
1417: l_invoice_id := g_null;
1418: fnd_message.set_name('IGS',
1419: 'IGS_FI_REFUND_REASON_BATCH');
1420: l_reason := fnd_message.get;
1421:
1422: SAVEPOINT REFUNDS;

Line 1420: l_reason := fnd_message.get;

1416: l_refund_id := g_null;
1417: l_invoice_id := g_null;
1418: fnd_message.set_name('IGS',
1419: 'IGS_FI_REFUND_REASON_BATCH');
1420: l_reason := fnd_message.get;
1421:
1422: SAVEPOINT REFUNDS;
1423: BEGIN
1424: l_exception_flag := FALSE;

Line 1551: fnd_message.set_name('IGS',

1547:
1548: -- If the Applications procedure returns an error message, then this should be logged to the log file
1549: -- of the concurrent manager
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,' '));

Line 1553: l_msg_text := fnd_message.get;

1549: -- of the concurrent manager
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;

Line 1588: fnd_message.set_name('IGS',

1584:
1585: -- If an exception happens, then log the message in the log file of the
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;

Line 1591: fnd_message.get||sqlerrm);

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;
1595: END LOOP;

Line 1601: fnd_message.set_name('IGS','IGS_FI_RFND_PRC_NULL');

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

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 1606: fnd_message.set_name('IGS','IGS_FI_NO_RFND_EXCESS_AMT');

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');
1607: fnd_file.put_line(fnd_file.log, fnd_message.get);
1608: END IF;
1609: ELSE
1610:

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 1614: fnd_message.set_name('IGS',

1610:
1611: -- This means that the holds of STOPREFUNDS exist for the person and no automatic refund
1612: -- processing needs to be done for the Person
1613: IF l_hld_exsts THEN
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,

Line 1616: fnd_message.set_token('PARTY_NUM',

1612: -- processing needs to be done for the Person
1613: IF l_hld_exsts THEN
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;

Line 1619: fnd_message.get);

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

Line 1633: fnd_message.set_name('IGS',

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

Line 1636: fnd_message.get);

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
1640: retcode := 2;

Line 1643: fnd_message.set_name('IGS',

1639: WHEN OTHERS THEN
1640: retcode := 2;
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,

Line 1646: fnd_message.get);

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;
1650: END process_batch;