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;
112: new_references.coa_code,
113: new_references.ci_cal_type,
114: new_references.ci_sequence_number
115: ) THEN
116: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
117: igs_ge_msg_stack.add;
118: app_exception.raise_exception;
119: END IF;
120:
123: NULL;
124: ELSIF NOT igf_aw_item_pkg.get_pk_for_validation (
125: new_references.item_code
126: ) 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:
222: OPEN cur_rowid;
223: FETCH cur_rowid INTO lv_rowid;
224: IF (cur_rowid%FOUND) THEN
225: CLOSE cur_rowid;
226: fnd_message.set_name ('IGF', 'IGF_AW_COAGI_COAG_FK');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: RETURN;
230: END IF;
257: OPEN cur_rowid;
258: FETCH cur_rowid INTO lv_rowid;
259: IF (cur_rowid%FOUND) THEN
260: CLOSE cur_rowid;
261: fnd_message.set_name ('IGF', 'IGF_AW_COAGI_AWITEM_FK');
262: igs_ge_msg_stack.add;
263: app_exception.raise_exception;
264: RETURN;
265: END IF;
331: new_references.ci_sequence_number,
332: new_references.item_code
333: )
334: ) THEN
335: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339: check_parent_existance;
348: new_references.ci_sequence_number,
349: new_references.item_code
350: )
351: ) THEN
352: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END IF;
356: ELSIF (p_action = 'VALIDATE_DELETE') THEN
412: IF (x_last_update_login IS NULL) THEN
413: x_last_update_login := -1;
414: END IF;
415: ELSE
416: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
417: igs_ge_msg_stack.add;
418: app_exception.raise_exception;
419: END IF;
420:
532:
533: OPEN c1;
534: FETCH c1 INTO tlinfo;
535: IF (c1%notfound) THEN
536: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
537: igs_ge_msg_stack.add;
538: CLOSE c1;
539: app_exception.raise_exception;
540: RETURN;
557: (tlinfo.lock_flag = x_lock_flag)
558: ) THEN
559: NULL;
560: ELSE
561: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
562: igs_ge_msg_stack.add;
563: app_exception.raise_exception;
564: END IF;
565:
612: IF (x_last_update_login IS NULL) THEN
613: x_last_update_login := -1;
614: END IF;
615: ELSE
616: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
617: igs_ge_msg_stack.add;
618: app_exception.raise_exception;
619: END IF;
620: