[Home] [Help]
93: OPEN cur_old_ref_values;
94: FETCH cur_old_ref_values INTO old_references;
95: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
96: CLOSE cur_old_ref_values;
97: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: RETURN;
101: END IF;
183:
184: IF UPPER(column_name) = 'CLOSED_IND' OR
185: column_name IS NULL THEN
186: IF NOT (new_references.closed_ind 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: END IF;
212: NULL;
213: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation (
214: new_references.fee_type
215: ) THEN
216: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
217: igs_ge_msg_stack.add;
218: app_exception.raise_exception;
219: END IF;
220:
224: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation (
225: 'IGS_FI_PLAN_TYPE',
226: new_references.plan_type
227: ) THEN
228: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: END IF;
232:
236: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation (
237: 'IGS_FI_ACCRUAL_TYPE',
238: new_references.accrual_type
239: ) THEN
240: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
241: igs_ge_msg_stack.add;
242: app_exception.raise_exception;
243: END IF;
244:
248: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation (
249: 'IGS_FI_BALANCE_TYPE',
250: new_references.balance_type
251: ) THEN
252: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
253: igs_ge_msg_stack.add;
254: app_exception.raise_exception;
255: END IF;
256:
260: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation (
261: 'IGS_FI_ACCRUAL_TYPE',
262: new_references.payment_plan_accrl_type_code
263: ) THEN
264: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268:
320: OPEN cur_chg;
321: FETCH cur_chg INTO lv_chg;
322: IF (cur_chg%FOUND) THEN
323: CLOSE cur_chg;
324: fnd_message.set_name ('IGS', 'IGS_FI_MOD_PLAN');
325: igs_ge_msg_stack.add;
326: app_exception.raise_exception;
327: RETURN;
328: END IF;
487: IF ( get_pk_for_validation(
488: new_references.plan_name
489: )
490: ) THEN
491: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
492: igs_ge_msg_stack.add;
493: app_exception.raise_exception;
494: END IF;
495: check_constraints;
503: IF ( get_pk_for_validation (
504: new_references.plan_name
505: )
506: ) THEN
507: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
508: igs_ge_msg_stack.add;
509: app_exception.raise_exception;
510: END IF;
511: check_constraints;
602: IF (x_last_update_login IS NULL) THEN
603: x_last_update_login := -1;
604: END IF;
605: ELSE
606: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610:
878:
879: OPEN c1;
880: FETCH c1 INTO tlinfo;
881: IF (c1%notfound) THEN
882: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
883: igs_ge_msg_stack.add;
884: CLOSE c1;
885: app_exception.raise_exception;
886: RETURN;
931: AND ((tlinfo.payment_plan_min_balance_amt = x_payment_plan_min_balance_amt) OR ((tlinfo.payment_plan_min_balance_amt IS NULL) AND (x_payment_plan_min_balance_amt IS NULL)))
932: ) THEN
933: NULL;
934: ELSE
935: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
936: igs_ge_msg_stack.add;
937: app_exception.raise_exception;
938: END IF;
939:
1018: IF (x_last_update_login IS NULL) THEN
1019: x_last_update_login := -1;
1020: END IF;
1021: ELSE
1022: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1023: igs_ge_msg_stack.add;
1024: app_exception.raise_exception;
1025: END IF;
1026: