47: ***************************************************************************/
48: IF (c_lock%NOTFOUND)
49: THEN
50: CLOSE c_lock;
51: fnd_message.set_name ('JTF', 'JTF_CAL_RECORD_DELETED');
52: fnd_msg_pub.add;
53: RAISE fnd_api.g_exc_unexpected_error;
54: END IF;
55:
59: ***************************************************************************/
60: CLOSE c_lock;
61: IF (l_object_version_number <> p_object_version_number)
62: THEN
63: fnd_message.set_name ('JTF', 'JTF_CAL_RECORD_CHANGED');
64: fnd_msg_pub.add;
65: RAISE fnd_api.g_exc_unexpected_error;
66: END IF;
67: END Lock_Row;
398: IF (c_item%NOTFOUND) THEN
399: IF (c_item%ISOPEN) THEN
400: CLOSE c_item;
401: END IF;
402: fnd_message.set_name ('JTF', 'JTF_CAL_INV_CAL_ITEM');
403: fnd_message.set_token ('CAL_ITEM_ID', p_itm_rec.cal_item_id);
404: fnd_msg_pub.add;
405: RAISE no_data_found;
406: END IF;
399: IF (c_item%ISOPEN) THEN
400: CLOSE c_item;
401: END IF;
402: fnd_message.set_name ('JTF', 'JTF_CAL_INV_CAL_ITEM');
403: fnd_message.set_token ('CAL_ITEM_ID', p_itm_rec.cal_item_id);
404: fnd_msg_pub.add;
405: RAISE no_data_found;
406: END IF;
407:
412: ** End date cannot be before start date
413: ***************************************************************************/
414:
415: IF (l_item_rec.START_DATE > l_item_rec.END_DATE) THEN
416: FND_MESSAGE.set_name('JTF', 'JTF_CAL_END_DATE');
417: FND_MESSAGE.set_token('P_START_DATE', to_char(l_item_rec.START_DATE, 'YYYYMMDDHH24MISS'));
418: FND_MESSAGE.set_token('P_END_DATE', to_char(l_item_rec.END_DATE, 'YYYYMMDDHH24MISS'));
419: FND_MSG_pub.ADD;
420: RAISE FND_API.g_exc_unexpected_error;
413: ***************************************************************************/
414:
415: IF (l_item_rec.START_DATE > l_item_rec.END_DATE) THEN
416: FND_MESSAGE.set_name('JTF', 'JTF_CAL_END_DATE');
417: FND_MESSAGE.set_token('P_START_DATE', to_char(l_item_rec.START_DATE, 'YYYYMMDDHH24MISS'));
418: FND_MESSAGE.set_token('P_END_DATE', to_char(l_item_rec.END_DATE, 'YYYYMMDDHH24MISS'));
419: FND_MSG_pub.ADD;
420: RAISE FND_API.g_exc_unexpected_error;
421: END IF;
414:
415: IF (l_item_rec.START_DATE > l_item_rec.END_DATE) THEN
416: FND_MESSAGE.set_name('JTF', 'JTF_CAL_END_DATE');
417: FND_MESSAGE.set_token('P_START_DATE', to_char(l_item_rec.START_DATE, 'YYYYMMDDHH24MISS'));
418: FND_MESSAGE.set_token('P_END_DATE', to_char(l_item_rec.END_DATE, 'YYYYMMDDHH24MISS'));
419: FND_MSG_pub.ADD;
420: RAISE FND_API.g_exc_unexpected_error;
421: END IF;
422: /***************************************************************************