[Home] [Help]
84: OPEN cur_old_ref_values;
85: FETCH cur_old_ref_values INTO old_references;
86: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
87: CLOSE cur_old_ref_values;
88: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
89: igs_ge_msg_stack.add;
90: app_exception.raise_exception;
91: RETURN;
92: END IF;
166: -- Added the check for accounting method not null
167: IF UPPER(column_name) = 'ACCOUNTING_METHOD' or column_name is NULL THEN
168: IF new_references.accounting_method IS NULL AND
169: new_references.accounting_method <> 'N' THEN
170: fnd_message.set_name('IGS',
171: 'IGS_FI_ACCNT_MTHD_NULL_NA');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: END IF;
176:
177: -- Added the check for refund_dt_alias as a one time initialisation field as Per Enh Bug # 2144600
178: IF ((NOT old_references.refund_dt_alias IS NULL) AND
179: (old_references.refund_dt_alias <> new_references.refund_dt_alias )) THEN
180: fnd_message.set_name('IGS','IGS_FI_REFUND_DT_ONE_TIME_SET');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: END IF;
184:
183: END IF;
184:
185: -- Added the check for planned_credits_ind not null
186: IF (( new_references.planned_credits_ind IS NOT NULL) AND ( new_references.planned_credits_ind NOT IN ('Y','N'))) THEN
187: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
188: igs_ge_msg_stack.add;
189: app_exception.raise_exception;
190: END IF;
191:
191:
192:
193: IF (new_references.currency_cd IS NULL)
194: THEN
195: fnd_message.set_name('IGS','IGS_PE_DATA_MANDATORY');
196: fnd_message.set_token('DATA_ELEMENT','CURRENCY_CD');
197: igs_ge_msg_stack.add;
198: app_exception.raise_exception;
199: END IF;
192:
193: IF (new_references.currency_cd IS NULL)
194: THEN
195: fnd_message.set_name('IGS','IGS_PE_DATA_MANDATORY');
196: fnd_message.set_token('DATA_ELEMENT','CURRENCY_CD');
197: igs_ge_msg_stack.add;
198: app_exception.raise_exception;
199: END IF;
200:
199: END IF;
200:
201: IF ((new_references.manage_accounts IS NOT NULL) AND (new_references.manage_accounts NOT IN ('STUDENT_FINANCE','OTHER'))
202: ) THEN
203: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207:
241: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation(
242: 'IGS_FI_ACCT_METHOD',
243: new_references.accounting_method
244: )THEN
245: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
246: igs_ge_msg_stack.add;
247: app_exception.raise_exception;
248: END IF;
249:
254: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation (
255: 'IGS_FI_FEE_CALC_MTHD',
256: new_references.fee_calc_mthd_code
257: ) THEN
258: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
259: igs_ge_msg_stack.add;
260: app_exception.raise_exception;
261: END IF;
262:
265: (new_references.refund_dr_account_cd IS NULL))) THEN
266: NULL;
267: ELSE
268: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.refund_dr_account_cd)) THEN
269: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
270: igs_ge_msg_stack.add;
271: app_exception.raise_exception;
272: END IF;
273: END IF;
276: (new_references.refund_cr_account_cd IS NULL))) THEN
277: NULL;
278: ELSE
279: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.refund_cr_account_cd)) THEN
280: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
281: igs_ge_msg_stack.add;
282: app_exception.raise_exception;
283: END IF;
284: END IF;
288: NULL;
289: ELSE
290: IF NOT igs_ca_da_pkg.get_pk_for_validation (
291: new_references.refund_dt_alias) THEN
292: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: END IF;
300: (new_references.rec_account_cd IS NULL)) THEN
301: NULL;
302: ELSE
303: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.rec_account_cd)) THEN
304: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308: END IF;
311: (new_references.rev_account_cd IS NULL)) THEN
312: NULL;
313: ELSE
314: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.rev_account_cd)) THEN
315: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
316: igs_ge_msg_stack.add;
317: app_exception.raise_exception;
318: END IF;
319: END IF;
322: (new_references.cash_account_cd IS NULL)) THEN
323: NULL;
324: ELSE
325: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.cash_account_cd)) THEN
326: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330: END IF;
333: (new_references.unapp_account_cd IS NULL)) THEN
334: NULL;
335: ELSE
336: IF NOT(igs_fi_acc_pkg.get_pk_for_validation(new_references.unapp_account_cd)) THEN
337: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: END IF;
341: END IF;
347: OPEN cur_rowid4;
348: FETCH cur_rowid4 INTO l_rowid4;
349: IF (cur_rowid4%NOTFOUND) THEN
350: CLOSE cur_rowid4;
351: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355: CLOSE cur_rowid4;
361: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation(
362: 'IGS_FI_REFUND_DESTINATION',
363: new_references.rfnd_destination
364: )THEN
365: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
366: igs_ge_msg_stack.add;
367: app_exception.raise_exception;
368: END IF;
369:
508: IF (p_action = 'INSERT') THEN
509: -- Call all the procedures related to Before Insert.
510: IF get_pk_for_validation(
511: new_references.rec_installed) THEN
512: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
513: igs_ge_msg_stack.add;
514: app_exception.raise_exception;
515: END IF;
516: check_constraints;
526: ELSIF (p_action = 'VALIDATE_INSERT') THEN
527: -- Call all the procedures related to Before Insert.
528: IF get_pk_for_validation (
529: new_references.rec_installed) THEN
530: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
531: igs_ge_msg_stack.add;
532: app_exception.raise_exception;
533: END IF;
534: check_constraints;
661: IF x_last_update_login IS NULL THEN
662: x_last_update_login := -1;
663: END IF;
664: ELSE
665: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
666: igs_ge_msg_stack.add;
667: app_exception.raise_exception;
668: END IF;
669:
888: BEGIN
889: OPEN c1;
890: FETCH c1 INTO tlinfo;
891: IF (c1%NOTFOUND) THEN
892: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
893: igs_ge_msg_stack.add;
894: CLOSE c1;
895: app_exception.raise_exception;
896: RETURN;
949: (tlinfo.waiver_notify_finaid_flag IS NULL AND x_waiver_notify_finaid_flag IS NULL))
950: ) THEN
951: NULL;
952: ELSE
953: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
954: igs_ge_msg_stack.add;
955: app_exception.raise_exception;
956: END IF;
957: RETURN;
1040: IF x_last_update_login IS NULL THEN
1041: x_last_update_login := -1;
1042: END IF;
1043: ELSE
1044: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1045: igs_ge_msg_stack.add;
1046: app_exception.raise_exception;
1047: END IF;
1048:
1186: OPEN cur_rowid;
1187: FETCH cur_rowid INTO lv_rowid;
1188: IF (cur_rowid%FOUND) THEN
1189: CLOSE cur_rowid;
1190: fnd_message.set_name ('IGS', 'IGS_FI_CTRL_DA_FK');
1191: igs_ge_msg_stack.add;
1192: app_exception.raise_exception;
1193: RETURN;
1194: END IF;