[Home] [Help]
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;
102: CLOSE cur_old_ref_values;
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;
192:
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:
221: IF (((old_references.plan_type = new_references.plan_type)) OR
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:
233: IF (((old_references.accrual_type = new_references.accrual_type)) OR
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:
245: IF (((old_references.balance_type = new_references.balance_type)) OR
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:
257: IF (((old_references.payment_plan_accrl_type_code = new_references.payment_plan_accrl_type_code)) OR
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:
269: END check_parent_existance;
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;
329: CLOSE cur_chg;
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;
496: check_parent_existance;
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;
512: ELSIF (p_action = 'VALIDATE_UPDATE') 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:
611: before_dml(
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;
887: END IF;
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:
940: RETURN;
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:
1027: before_dml(