234: IF fnd_api.to_boolean(p_commit) THEN
235: commit work;
236: END IF;
237:
238: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
239: EXCEPTION
240:
241: WHEN fnd_api.g_exc_error then
242: ROLLBACK TO create_access_hours_pub;
242: ROLLBACK TO create_access_hours_pub;
243: x_return_status :=fnd_api.g_ret_sts_error;
244: /*x_msg_count := l_msg_count;
245: x_msg_data := l_msg_data;*/
246: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
247:
248: When fnd_api.g_exc_unexpected_error then
249: Rollback TO create_access_hours_pvt;
250: x_return_status:= fnd_api.g_ret_sts_unexp_error;
247:
248: When fnd_api.g_exc_unexpected_error then
249: Rollback TO create_access_hours_pvt;
250: x_return_status:= fnd_api.g_ret_sts_unexp_error;
251: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
252:
253: When others then
254: Rollback TO create_access_hours_pvt;
255: x_return_status:= fnd_api.g_ret_sts_unexp_error;
252:
253: When others then
254: Rollback TO create_access_hours_pvt;
255: x_return_status:= fnd_api.g_ret_sts_unexp_error;
256: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
257:
258: End CREATE_ACCESS_HOURS;
259:
260: PROCEDURE Update_Access_Hours(
379: -- Standard check of p_commit
380: IF fnd_api.to_boolean(p_commit) THEN
381: commit work;
382: END IF;
383: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
384:
385: EXCEPTION
386:
387: WHEN fnd_api.g_exc_error then
388: --ROLLBACK TO delete_access_hours_pub;
389: x_return_status :=fnd_api.g_ret_sts_error;
390: /*x_msg_count := l_msg_count;
391: x_msg_data := l_msg_data;*/
392: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
393:
394: WHEN fnd_api.g_exc_unexpected_error then
395: --ROLLBACK TO delete_access_hours_pub;
396: x_return_status :=fnd_api.g_ret_sts_unexp_error;
395: --ROLLBACK TO delete_access_hours_pub;
396: x_return_status :=fnd_api.g_ret_sts_unexp_error;
397: /*x_msg_count := l_msg_count;
398: x_msg_data := l_msg_data;*/
399: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
400:
401: WHEN OTHERS then
402: --ROLLBACK TO delete_access_hours_pub;
403: x_return_status := fnd_api.g_ret_sts_unexp_error;
402: --ROLLBACK TO delete_access_hours_pub;
403: x_return_status := fnd_api.g_ret_sts_unexp_error;
404: /*x_msg_count := l_msg_count;
405: x_msg_data := l_msg_data;*/
406: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
407:
408: END Update_Access_Hours;
409:
410: PROCEDURE Delete_Access_Hours(
441: IF fnd_api.to_boolean(p_commit) THEN
442: commit work;
443: END IF;
444:
445: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
446:
447: EXCEPTION
448:
449: WHEN fnd_api.g_exc_error then
450: --ROLLBACK TO delete_access_hours_pub;
451: x_return_status := fnd_api.g_ret_sts_error;
452: /*x_msg_count := l_msg_count;
453: x_msg_data := l_msg_data;*/
454: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
455:
456: WHEN fnd_api.g_exc_unexpected_error then
457: --ROLLBACK TO delete_access_hours_pub;
458: x_return_status :=fnd_api.g_ret_sts_unexp_error;
457: --ROLLBACK TO delete_access_hours_pub;
458: x_return_status :=fnd_api.g_ret_sts_unexp_error;
459: /*x_msg_count := l_msg_count;
460: x_msg_data := l_msg_data;*/
461: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
462:
463: WHEN OTHERS then
464: --ROLLBACK TO delete_access_hours_pub;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
464: --ROLLBACK TO delete_access_hours_pub;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;
466: /*x_msg_count := l_msg_count;
467: x_msg_data := l_msg_data;*/
468: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
469:
470: END Delete_Access_Hours;
471:
472:
515: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
516: app_exception.raise_exception;
517: end if;
518:
519: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
520:
521: EXCEPTION
522:
523: WHEN fnd_api.g_exc_error then
524: --ROLLBACK TO delete_access_hours_pub;
525: x_return_status :=fnd_api.g_ret_sts_error;
526: /*x_msg_count := l_msg_count;
527: x_msg_data := l_msg_data;*/
528: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
529:
530: WHEN fnd_api.g_exc_unexpected_error then
531: --ROLLBACK TO delete_access_hours_pub;
532: x_return_status :=fnd_api.g_ret_sts_unexp_error;
531: --ROLLBACK TO delete_access_hours_pub;
532: x_return_status :=fnd_api.g_ret_sts_unexp_error;
533: /*x_msg_count := l_msg_count;
534: x_msg_data := l_msg_data;*/
535: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
536:
537: WHEN OTHERS then
538: --ROLLBACK TO delete_access_hours_pub;
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
538: --ROLLBACK TO delete_access_hours_pub;
539: x_return_status := fnd_api.g_ret_sts_unexp_error;
540: /*x_msg_count := l_msg_count;
541: x_msg_data := l_msg_data;*/
542: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
543: END lock_Access_Hours;
544:
545:
546: BEGIN