[Home] [Help]
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;
67: CLOSE cur_old_ref_values;
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:
129: END check_parent_existance;
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;
197: CLOSE cur_rowid;
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;
284: ELSIF (p_action = 'UPDATE') THEN
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;
298:
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:
381: SELECT igf_sl_dl_pnote_s_p_all_s.NEXTVAL
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;
561: END IF;
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:
592: RETURN;
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:
659: before_dml(