43: OPEN cur_old_ref_values;
44: FETCH cur_old_ref_values INTO old_references;
45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
90: new_references.unit_cd,
91: new_references.version_number
92: )
93: ) THEN
94: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
116: NULL;
117: ELSIF NOT igf_sp_prg_pkg.get_pk_for_validation (
118: new_references.fee_cls_prg_id
119: ) THEN
120: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
121: igs_ge_msg_stack.add;
122: app_exception.raise_exception;
123: END IF;
124:
130: ELSIF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (
131: new_references.unit_cd,
132: new_references.version_number
133: ) THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
237: OPEN cur_rowid;
238: FETCH cur_rowid INTO lv_rowid;
239: IF (cur_rowid%FOUND) THEN
240: CLOSE cur_rowid;
241: fnd_message.set_name ('IGF', 'IGF_SP_SFCLU_SFCLP_FK');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: RETURN;
245: END IF;
274: OPEN cur_rowid;
275: FETCH cur_rowid INTO lv_rowid;
276: IF (cur_rowid%FOUND) THEN
277: CLOSE cur_rowid;
278: fnd_message.set_name ('IGF', 'IGF_SP_SFCLU_UV_FK');
279: igs_ge_msg_stack.add;
280: app_exception.raise_exception;
281: RETURN;
282: END IF;
333: IF ( get_pk_for_validation(
334: new_references.fee_cls_unit_id
335: )
336: ) THEN
337: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: END IF;
341: check_uniqueness;
349: IF ( get_pk_for_validation (
350: new_references.fee_cls_unit_id
351: )
352: ) THEN
353: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357: check_uniqueness;
404: IF (x_last_update_login IS NULL) THEN
405: x_last_update_login := -1;
406: END IF;
407: ELSE
408: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412:
501:
502: OPEN c1;
503: FETCH c1 INTO tlinfo;
504: IF (c1%notfound) THEN
505: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
506: igs_ge_msg_stack.add;
507: CLOSE c1;
508: app_exception.raise_exception;
509: RETURN;
517: AND (tlinfo.max_amount = x_max_amount)
518: ) THEN
519: NULL;
520: ELSE
521: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
522: igs_ge_msg_stack.add;
523: app_exception.raise_exception;
524: END IF;
525:
565: IF (x_last_update_login IS NULL) THEN
566: x_last_update_login := -1;
567: END IF;
568: ELSE
569: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573: