DBA Data[Home] [Help]

APPS.CAC_BOOKINGS_PUB dependencies on FND_MESSAGE

Line 102: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

98: );
99: WHEN OTHERS
100: THEN
101: ROLLBACK TO create_bookings_pub;
102: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
103: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
104: fnd_msg_pub.add;
105: x_return_status := fnd_api.g_ret_sts_unexp_error;
106: fnd_msg_pub.count_and_get (

Line 103: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

99: WHEN OTHERS
100: THEN
101: ROLLBACK TO create_bookings_pub;
102: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
103: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
104: fnd_msg_pub.add;
105: x_return_status := fnd_api.g_ret_sts_unexp_error;
106: fnd_msg_pub.count_and_get (
107: p_count => x_msg_count,

Line 156: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK');

152:
153: IF (l_booking_type_rec.booking_id = fnd_api.g_miss_num
154: OR l_booking_type_rec.booking_id IS NULL)
155: THEN
156: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK');
157: fnd_msg_pub.add;
158: RAISE fnd_api.g_exc_unexpected_error;
159: ELSE
160:

Line 238: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

234: );
235: WHEN OTHERS
236: THEN
237: ROLLBACK TO update_bookings_pub;
238: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
239: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
240: fnd_msg_pub.add;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_msg_pub.count_and_get (

Line 239: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

235: WHEN OTHERS
236: THEN
237: ROLLBACK TO update_bookings_pub;
238: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
239: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
240: fnd_msg_pub.add;
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_msg_pub.count_and_get (
243: p_count => x_msg_count,

Line 262: fnd_message.set_name ('CAC', 'CAC_BOOKING_NULL_START_DATE');

258: BEGIN
259: -- For booking scheduled dates are populated --'
260: IF (l_booking_type_rec.start_date IS NULL)
261: THEN
262: fnd_message.set_name ('CAC', 'CAC_BOOKING_NULL_START_DATE');
263: fnd_msg_pub.add;
264: RAISE fnd_api.g_exc_unexpected_error;
265: END IF;
266:

Line 269: fnd_message.set_name ('CAC', 'CAC_BOOKING_NULL_END_DATE');

265: END IF;
266:
267: IF (l_booking_type_rec.end_date IS NULL)
268: THEN
269: fnd_message.set_name ('CAC', 'CAC_BOOKING_NULL_END_DATE');
270: fnd_msg_pub.add;
271: RAISE fnd_api.g_exc_unexpected_error;
272: END IF;
273:

Line 290: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK_TYPE');

286: END IF;
287:
288: IF l_booking_type_rec.booking_type_id IS NULL
289: THEN
290: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK_TYPE');
291: fnd_msg_pub.add;
292: RAISE fnd_api.g_exc_unexpected_error;
293: END IF;
294:

Line 310: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK_STATUS');

306: END IF;
307:
308: IF l_booking_type_rec.booking_status_id IS NULL
309: THEN
310: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK_STATUS');
311: fnd_msg_pub.add;
312: RAISE fnd_api.g_exc_unexpected_error;
313: END IF; */
314:

Line 347: fnd_message.set_name ('CAC', 'BKG_INVALID_RESOURCE_ID');

343: -- this will be changed to validate_booking_resource ..
344:
345: IF l_booking_type_rec.resource_id IS NULL
346: THEN
347: fnd_message.set_name ('CAC', 'BKG_INVALID_RESOURCE_ID');
348: fnd_msg_pub.add;
349: RAISE fnd_api.g_exc_unexpected_error;
350: END IF;
351:

Line 354: fnd_message.set_name ('CAC', 'BKG_INVALID_RESOURCE_TYPE_CODE');

350: END IF;
351:
352: IF l_booking_type_rec.resource_type_code IS NULL
353: THEN
354: fnd_message.set_name ('CAC', 'BKG_INVALID_RESOURCE_TYPE_CODE');
355: fnd_msg_pub.add;
356: RAISE fnd_api.g_exc_unexpected_error;
357: END IF;
358:

Line 371: fnd_message.set_name ('JTF', 'BKG_INVALID_RESOURCE');

367:
368:
369: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
370: THEN
371: fnd_message.set_name ('JTF', 'BKG_INVALID_RESOURCE');
372: fnd_msg_pub.add;
373: RAISE fnd_api.g_exc_unexpected_error;
374: END IF;
375:

Line 393: fnd_message.set_name ('CAC', 'CAC_BOOKING_INVALID_TYPE');

389: -- Validate freebusytype ..
390: IF l_booking_type_rec.freebusytype NOT IN
391: ('FREE','BUSY','FREE_BUSY_TENTATIVE')
392: THEN
393: fnd_message.set_name ('CAC', 'CAC_BOOKING_INVALID_TYPE');
394: fnd_msg_pub.add;
395: RAISE fnd_api.g_exc_unexpected_error;
396: END IF;
397:

Line 444: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK');

440:
441: IF (l_task_id = fnd_api.g_miss_num)
442: OR (l_task_id IS NULL)
443: THEN
444: fnd_message.set_name ('CAC', 'CAC_BOOKING_MISSING_TASK');
445: fnd_msg_pub.add;
446: RAISE fnd_api.g_exc_unexpected_error;
447: END IF;
448:

Line 484: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

480: );
481: WHEN OTHERS
482: THEN
483: ROLLBACK TO delete_bookings_pub;
484: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
485: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
486: fnd_msg_pub.add;
487: x_return_status := fnd_api.g_ret_sts_unexp_error;
488: fnd_msg_pub.count_and_get (

Line 485: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

481: WHEN OTHERS
482: THEN
483: ROLLBACK TO delete_bookings_pub;
484: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
485: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
486: fnd_msg_pub.add;
487: x_return_status := fnd_api.g_ret_sts_unexp_error;
488: fnd_msg_pub.count_and_get (
489: p_count => x_msg_count,