[Home] [Help]
51: OPEN cur_old_ref_values;
52: FETCH cur_old_ref_values INTO old_references;
53: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
54: CLOSE cur_old_ref_values;
55: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: RETURN;
59: END IF;
114: NULL;
115: ELSIF NOT igf_aw_fund_mast_pkg.get_pk_for_validation (
116: new_references.fund_id
117: ) THEN
118: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
119: igs_ge_msg_stack.add;
120: app_exception.raise_exception;
121: END IF;
122:
123: IF ((old_references.adplans_id = new_references.adplans_id)) OR
124: ((new_references.adplans_id IS NULL)) THEN
125: NULL;
126: ELSIF NOT igf_aw_awd_dist_plans_pkg.get_pk_for_validation(new_references.adplans_id) THEN
127: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
128: igs_ge_msg_stack.add;
129: app_exception.raise_exception;
130: END IF;
131:
197: OPEN cur_rowid;
198: FETCH cur_rowid INTO lv_rowid;
199: IF (cur_rowid%FOUND) THEN
200: CLOSE cur_rowid;
201: fnd_message.set_name ('IGF', 'IGF_AW_FMDET_FMAST_FK');
202: igs_ge_msg_stack.add;
203: app_exception.raise_exception;
204: RETURN;
205: END IF;
235: OPEN cur_rowid;
236: FETCH cur_rowid INTO lv_rowid;
237: IF (cur_rowid%FOUND) THEN
238: CLOSE cur_rowid;
239: fnd_message.set_name ('IGF', 'IGF_AW_FMDET_ADPLANS_FK');
240: igs_ge_msg_stack.add;
241: app_exception.raise_exception;
242: RETURN;
243: END IF;
273: OPEN cur_rowid;
274: FETCH cur_rowid INTO lv_rowid;
275: IF (cur_rowid%FOUND) THEN
276: CLOSE cur_rowid;
277: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: RETURN;
281: END IF;
347: new_references.ci_sequence_number,
348: new_references.seq_no
349: )
350: ) THEN
351: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355: check_parent_existance;
364: new_references.ci_sequence_number,
365: new_references.seq_no
366: )
367: ) THEN
368: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: END IF;
372: END IF;
428: IF (x_last_update_login IS NULL) THEN
429: x_last_update_login := -1;
430: END IF;
431: ELSE
432: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
433: igs_ge_msg_stack.add;
434: app_exception.raise_exception;
435: END IF;
436:
547:
548: OPEN c1;
549: FETCH c1 INTO tlinfo;
550: IF (c1%notfound) THEN
551: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
552: igs_ge_msg_stack.add;
553: CLOSE c1;
554: app_exception.raise_exception;
555: RETURN;
564: AND ((tlinfo.adplans_id = x_adplans_id) OR ((tlinfo.adplans_id IS NULL) AND (x_adplans_id IS NULL)))
565: AND ((tlinfo.lock_award_flag = x_lock_award_flag) OR (tlinfo.lock_award_flag IS NULL)) ) THEN
566: NULL;
567: ELSE
568: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
569: igs_ge_msg_stack.add;
570: app_exception.raise_exception;
571: END IF;
572:
620: IF (x_last_update_login IS NULL) THEN
621: x_last_update_login := -1;
622: END IF;
623: ELSE
624: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
625: igs_ge_msg_stack.add;
626: app_exception.raise_exception;
627: END IF;
628: