DBA Data[Home] [Help]

APPS.CAC_BOOKINGS_PUB dependencies on FND_MSG_PUB

Line 27: fnd_msg_pub.initialize;

23: x_return_status := fnd_api.g_ret_sts_success;
24:
25: IF fnd_api.to_boolean (p_init_msg_list)
26: THEN
27: fnd_msg_pub.initialize;
28: END IF;
29:
30: IF NOT fnd_api.compatible_api_call (
31: l_api_version,

Line 89: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

85: THEN
86: COMMIT WORK;
87: END IF;
88:
89: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
90: EXCEPTION
91: WHEN fnd_api.g_exc_unexpected_error
92: THEN
93: ROLLBACK TO create_bookings_pub;

Line 95: fnd_msg_pub.count_and_get (

91: WHEN fnd_api.g_exc_unexpected_error
92: THEN
93: ROLLBACK TO create_bookings_pub;
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: fnd_msg_pub.count_and_get (
96: p_count => x_msg_count,
97: p_data => x_msg_data
98: );
99: WHEN OTHERS

Line 104: fnd_msg_pub.add;

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,
108: p_data => x_msg_data

Line 106: fnd_msg_pub.count_and_get (

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,
108: p_data => x_msg_data
109: );
110: END;

Line 137: fnd_msg_pub.initialize;

133: x_return_status := fnd_api.g_ret_sts_success;
134:
135: IF fnd_api.to_boolean (p_init_msg_list)
136: THEN
137: fnd_msg_pub.initialize;
138: END IF;
139:
140: IF NOT fnd_api.compatible_api_call (
141: l_api_version,

Line 157: fnd_msg_pub.add;

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:
161: jtf_task_utl.validate_task (

Line 225: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

221: THEN
222: COMMIT WORK;
223: END IF;
224:
225: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
226: EXCEPTION
227: WHEN fnd_api.g_exc_unexpected_error
228: THEN
229: ROLLBACK TO update_bookings_pub;

Line 231: fnd_msg_pub.count_and_get (

227: WHEN fnd_api.g_exc_unexpected_error
228: THEN
229: ROLLBACK TO update_bookings_pub;
230: x_return_status := fnd_api.g_ret_sts_unexp_error;
231: fnd_msg_pub.count_and_get (
232: p_count => x_msg_count,
233: p_data => x_msg_data
234: );
235: WHEN OTHERS

Line 240: fnd_msg_pub.add;

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,
244: p_data => x_msg_data

Line 242: fnd_msg_pub.count_and_get (

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,
244: p_data => x_msg_data
245: );
246: END;

Line 263: fnd_msg_pub.add;

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:
267: IF (l_booking_type_rec.end_date IS NULL)

Line 270: fnd_msg_pub.add;

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:
274: --Validations

Line 291: fnd_msg_pub.add;

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:
295: /* jtf_task_utl.validate_task_status (

Line 311: fnd_msg_pub.add;

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:
315: jtf_task_utl.validate_dates (

Line 348: fnd_msg_pub.add;

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:
352: IF l_booking_type_rec.resource_type_code IS NULL

Line 355: fnd_msg_pub.add;

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:
359: jtf_task_utl.validate_task_owner (

Line 372: fnd_msg_pub.add;

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:
376: -- include booking usage here,,

Line 394: fnd_msg_pub.add;

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:
398:

Line 428: fnd_msg_pub.initialize;

424: x_return_status := fnd_api.g_ret_sts_success;
425:
426: IF fnd_api.to_boolean (p_init_msg_list)
427: THEN
428: fnd_msg_pub.initialize;
429: END IF;
430:
431: IF NOT fnd_api.compatible_api_call (
432: l_api_version,

Line 445: fnd_msg_pub.add;

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:
449:

Line 471: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

467: THEN
468: COMMIT WORK;
469: END IF;
470:
471: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
472: EXCEPTION
473: WHEN fnd_api.g_exc_unexpected_error
474: THEN
475: ROLLBACK TO delete_bookings_pub;

Line 477: fnd_msg_pub.count_and_get (

473: WHEN fnd_api.g_exc_unexpected_error
474: THEN
475: ROLLBACK TO delete_bookings_pub;
476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: fnd_msg_pub.count_and_get (
478: p_count => x_msg_count,
479: p_data => x_msg_data
480: );
481: WHEN OTHERS

Line 486: fnd_msg_pub.add;

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,
490: p_data => x_msg_data

Line 488: fnd_msg_pub.count_and_get (

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,
490: p_data => x_msg_data
491: );
492: END;