[Home] [Help]
112: Obsoletion of SPONSOR_CD
113: SCHODAVA 28-NOV-2001 Enh # 2122257
114: (SFCR015 : Change In Fee Category)
115: Changed the call to
116: IGS_FI_VAL_FAS.finp_val_fas_ass_ind function.
117: Added the params fee_cal_type
118: and fee_ci_sequence_number
119: (reverse chronological order - newest change first)
120: ***************************************************************/
129: BEGIN
130: -- Validate Fee Assessment can be created.
131: /* IF p_inserting THEN
132: -- Validate current date not greater than Retrospective assessment period.
133: IF IGS_FI_VAL_FAS.finp_val_fas_retro (
134: new_references.fee_type,
135: new_references.fee_cal_type,
136: new_references.fee_ci_sequence_number,
137: new_references.fee_cat,
145: IF p_inserting OR
146: (p_updating AND (new_references.course_cd <> old_references.course_cd OR
147: new_references.fee_cat <> old_references.fee_cat)) THEN
148: -- Validate that IGS_PS_COURSE code can be specified.
149: IF IGS_FI_VAL_FAS.finp_val_fas_create (
150: new_references.fee_type,
151: new_references.fee_cat,
152: new_references.course_cd,
153: v_message_name) = FALSE THEN
158: -- Validate that course code can be specified.
159: -- Enh # 2122257 (SFCR015 : Change In Fee Category)
160: -- Changed the call to this function.
161: -- Added params fee_cal_type and fee_ci_sequence_number
162: IF IGS_FI_VAL_FAS.finp_val_fas_ass_ind (
163: new_references.person_id,
164: new_references.course_cd,
165: new_references.fee_cat,
166: new_references.effective_dt,
181: ELSIF c_sft%NOTFOUND THEN
182: CLOSE c_sft;
183: IF p_inserting OR
184: (new_references.effective_dt <> old_references.effective_dt) THEN
185: IF IGS_FI_VAL_FAS.finp_val_fas_eff_dt (
186: new_references.fee_type,
187: new_references.fee_cal_type,
188: new_references.fee_ci_sequence_number,
189: new_references.fee_cat,
197: END IF;
198: END IF; -- For External System Fee Type NOT FOUND
199: IF p_inserting OR p_updating THEN
200: -- Validate that course code is fee assessable for manual entries.
201: IF IGS_FI_VAL_FAS.finp_val_fas_com (
202: new_references.s_transaction_type,
203: new_references.comments,
204: v_message_name) = FALSE THEN
205: Fnd_Message.Set_Name('IGS',v_message_name);
208: END IF;
209: END IF;
210: IF p_updating THEN
211: -- Validate the columns being changed are allowed to be
212: IF IGS_FI_VAL_FAS.finp_val_fas_upd (
213: new_references.person_id,
214: old_references.person_id,
215: new_references.transaction_id,
216: old_references.transaction_id,