58: OPEN cur_old_ref_values;
59: FETCH cur_old_ref_values INTO old_references;
60: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
61: CLOSE cur_old_ref_values;
62: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
63: igs_ge_msg_stack.add;
64: app_exception.raise_exception;
65: RETURN;
66: END IF;
120: NULL;
121: ELSIF NOT igf_sl_loans_pkg.get_pk_for_validation (
122: new_references.loan_id
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
188: OPEN cur_rowid;
189: FETCH cur_rowid INTO lv_rowid;
190: IF (cur_rowid%FOUND) THEN
191: CLOSE cur_rowid;
192: fnd_message.set_name ('IGF', 'IGF_SL_PNSP_LAR_FK');
193: igs_ge_msg_stack.add;
194: app_exception.raise_exception;
195: RETURN;
196: END IF;
275: IF ( get_pk_for_validation(
276: new_references.pnsp_id
277: )
278: ) THEN
279: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
280: igs_ge_msg_stack.add;
281: app_exception.raise_exception;
282: END IF;
283: check_parent_existance;
289: IF ( get_pk_for_validation (
290: new_references.pnsp_id
291: )
292: ) THEN
293: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297: END IF;
372: ELSE
373: x_program_update_date := SYSDATE;
374: END IF;
375: ELSE
376: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
377: igs_ge_msg_stack.add;
378: app_exception.raise_exception;
379: END IF;
380:
552:
553: OPEN c1;
554: FETCH c1 INTO tlinfo;
555: IF (c1%notfound) THEN
556: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
557: igs_ge_msg_stack.add;
558: CLOSE c1;
559: app_exception.raise_exception;
560: RETURN;
583: AND ((tlinfo.status = x_status) OR ((tlinfo.status IS NULL) AND (X_status IS NULL)))
584: ) THEN
585: NULL;
586: ELSE
587: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
588: igs_ge_msg_stack.add;
589: app_exception.raise_exception;
590: END IF;
591:
650: IF (x_last_update_login IS NULL) THEN
651: x_last_update_login := -1;
652: END IF;
653: ELSE
654: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
655: igs_ge_msg_stack.add;
656: app_exception.raise_exception;
657: END IF;
658: