61: OPEN cur_old_ref_values;
62: FETCH cur_old_ref_values INTO old_references;
63: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
64: CLOSE cur_old_ref_values;
65: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
66: igs_ge_msg_stack.add;
67: app_exception.raise_exception;
68: RETURN;
69: END IF;
226: IF ( get_pk_for_validation(
227: new_references.ocr_cfig_id
228: )
229: ) THEN
230: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: END IF;
234: ELSIF (p_action = 'VALIDATE_INSERT') THEN
236: IF ( get_pk_for_validation (
237: new_references.ocr_cfig_id
238: )
239: ) THEN
240: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
241: igs_ge_msg_stack.add;
242: app_exception.raise_exception;
243: END IF;
244: END IF;
302: IF (x_last_update_login IS NULL) THEN
303: x_last_update_login := -1;
304: END IF;
305: ELSE
306: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
307: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_OCR_CFIG_PKG.INSERT_ROW');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
303: x_last_update_login := -1;
304: END IF;
305: ELSE
306: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
307: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_OCR_CFIG_PKG.INSERT_ROW');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311:
476:
477: OPEN c1;
478: FETCH c1 INTO tlinfo;
479: IF (c1%notfound) THEN
480: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
481: igs_ge_msg_stack.add;
482: CLOSE c1;
483: app_exception.raise_exception;
484: RETURN;
510: AND (tlinfo.scheduled_room_ovrd_flag = x_scheduled_room_ovrd_flag)
511: ) THEN
512: NULL;
513: ELSE
514: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
515: igs_ge_msg_stack.add;
516: app_exception.raise_exception;
517: END IF;
518:
576: IF (x_last_update_login IS NULL) THEN
577: x_last_update_login := -1;
578: END IF;
579: ELSE
580: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
581: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_OCR_CFIG_PKG.UPDATE_ROW');
582: igs_ge_msg_stack.add;
583: app_exception.raise_exception;
584: END IF;
577: x_last_update_login := -1;
578: END IF;
579: ELSE
580: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
581: fnd_message.set_token ('ROUTINE', 'IGS_PS_SCH_OCR_CFIG_PKG.UPDATE_ROW');
582: igs_ge_msg_stack.add;
583: app_exception.raise_exception;
584: END IF;
585: