[Home] [Help]
50: FETCH cur_old_ref_values INTO old_references;
51: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
52: CLOSE cur_old_ref_values;
53: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
54: igs_ge_msg_stack.add;
55: app_exception.raise_exception;
56: RETURN;
57: END IF;
58: CLOSE cur_old_ref_values;
104: ELSIF NOT igs_fi_fee_type_pkg.get_pk_for_validation (
105: new_references.processing_fee_type
106: ) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
112: IF (((old_references.installment_period_code = new_references.installment_period_code )) OR
114: NULL;
115: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation ('IGS_FI_INSTALLMENT_PERIOD', new_references.installment_period_code
116: ) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:
122: END check_parent_existance;
214: new_references.payment_plan_name
215: )
216: ) THEN
217: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: END IF;
221: check_parent_existance;
222: ELSIF (p_action = 'UPDATE') THEN
228: new_references.payment_plan_name
229: )
230: ) THEN
231: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: END IF;
235: END IF;
236:
284: END IF;
285: ELSE
286: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
287: fnd_message.set_token ('ROUTINE', 'IGS_FI_PP_TEMPLATES_PKG.INSERT_ROW');
288: igs_ge_msg_stack.add;
289: app_exception.raise_exception;
290: END IF;
291:
292: before_dml(
395: OPEN c1;
396: FETCH c1 INTO tlinfo;
397: IF (c1%notfound) THEN
398: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
399: igs_ge_msg_stack.add;
400: CLOSE c1;
401: app_exception.raise_exception;
402: RETURN;
403: END IF;
417: ) THEN
418: NULL;
419: ELSE
420: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
421: igs_ge_msg_stack.add;
422: app_exception.raise_exception;
423: END IF;
424:
425: RETURN;
472: END IF;
473: ELSE
474: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
475: fnd_message.set_token ('ROUTINE', 'IGS_FI_PP_TEMPLATES_PKG.UPDATE_ROW');
476: igs_ge_msg_stack.add;
477: app_exception.raise_exception;
478: END IF;
479:
480: before_dml(