160: IF p_person_id IS NULL OR
161: p_course_cd IS NULL OR
162: p_fee_cat IS NULL OR
163: p_effective_dt IS NULL THEN
164: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
167: END IF;
168:
162: p_fee_cat IS NULL OR
163: p_effective_dt IS NULL THEN
164: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception(Null, Null, fnd_message.get);
167: END IF;
168:
169: -- Find the ACTIVE fee cat fee liabilities
170:
292: END;
293:
294: EXCEPTION
295: WHEN OTHERS THEN
296: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
297: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_GEN_005.FINP_VAL_FEE_LBLTY');
298: IGS_GE_MSG_STACK.ADD;
299: lv_param_values := to_char(p_person_id)||','||
300: p_course_cd||','||p_fee_cat||','||
293:
294: EXCEPTION
295: WHEN OTHERS THEN
296: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
297: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_GEN_005.FINP_VAL_FEE_LBLTY');
298: IGS_GE_MSG_STACK.ADD;
299: lv_param_values := to_char(p_person_id)||','||
300: p_course_cd||','||p_fee_cat||','||
301: p_fee_type||','||
299: lv_param_values := to_char(p_person_id)||','||
300: p_course_cd||','||p_fee_cat||','||
301: p_fee_type||','||
302: fnd_date.date_to_displaydt(p_effective_dt);
303: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');
304: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: END finp_val_fee_lblty;
300: p_course_cd||','||p_fee_cat||','||
301: p_fee_type||','||
302: fnd_date.date_to_displaydt(p_effective_dt);
303: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');
304: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
305: IGS_GE_MSG_STACK.ADD;
306: App_Exception.Raise_Exception;
307: END finp_val_fee_lblty;
308:
831: END;
832:
833: EXCEPTION
834: WHEN OTHERS THEN
835: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
836: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_GEN_005.FINP_VAL_FEE_TRIGGER');
837: IGS_GE_MSG_STACK.ADD;
838: lv_param_values := p_fee_cat||','||
839: p_fee_cal_type||','||to_char(p_fee_ci_sequence_number)||','||
832:
833: EXCEPTION
834: WHEN OTHERS THEN
835: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
836: FND_MESSAGE.SET_TOKEN('NAME','IGS_FI_GEN_005.FINP_VAL_FEE_TRIGGER');
837: IGS_GE_MSG_STACK.ADD;
838: lv_param_values := p_fee_cat||','||
839: p_fee_cal_type||','||to_char(p_fee_ci_sequence_number)||','||
840: p_fee_type||','||p_s_fee_trigger_cat||','||
843: p_course_cd||','||to_char(p_version_number)||','||
844: p_cal_type||','||p_location_cd||','||
845: p_attendance_mode||','||p_attendance_type;
846:
847: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');
848: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
849: IGS_GE_MSG_STACK.ADD;
850: App_Exception.Raise_Exception;
851:
844: p_cal_type||','||p_location_cd||','||
845: p_attendance_mode||','||p_attendance_type;
846:
847: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PARAMETERS');
848: FND_MESSAGE.SET_TOKEN('VALUE',lv_param_values);
849: IGS_GE_MSG_STACK.ADD;
850: App_Exception.Raise_Exception;
851:
852: END finp_val_fee_trigger;
912: -- If the User is trying to run this concurrent program, then the error message
913: -- should be written to the log file that the concurrent program has been obsoleted
914: -- and cannot be run
915: retcode:=0;
916: FND_MESSAGE.Set_Name('IGS',
917: 'IGS_GE_OBSOLETE_JOB');
918: FND_FILE.Put_Line(FND_FILE.Log,
919: FND_MESSAGE.Get);
920: EXCEPTION
915: retcode:=0;
916: FND_MESSAGE.Set_Name('IGS',
917: 'IGS_GE_OBSOLETE_JOB');
918: FND_FILE.Put_Line(FND_FILE.Log,
919: FND_MESSAGE.Get);
920: EXCEPTION
921: WHEN OTHERS THEN
922: RETCODE:=2;
923: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
919: FND_MESSAGE.Get);
920: EXCEPTION
921: WHEN OTHERS THEN
922: RETCODE:=2;
923: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
924: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
925: END finp_set_pymnt_schdl;
926:
927: FUNCTION finp_get_receivables_inst RETURN IGS_FI_CONTROL.Rec_Installed%TYPE AS
947: -- If no records are found in IGS_FI_CONTROL table
948: -- exception is raised.
949: IF cur_ctrl%NOTFOUND THEN
950: CLOSE cur_ctrl;
951: FND_MESSAGE.SET_NAME('IGS','IGS_FI_SYSTEM_OPT_SETUP');
952: IGS_GE_MSG_STACK.ADD;
953: APP_EXCEPTION.RAISE_EXCEPTION;
954: END IF;
955: CLOSE cur_ctrl;