DBA Data[Home] [Help]

APPS.CSF_ACCESS_HOURS_PVT dependencies on FND_MSG_PUB

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

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;

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

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;

Line 251: 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;
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;

Line 256: 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;
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(

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

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

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

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;

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

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;

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

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(

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

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

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

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;

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

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;

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

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:

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

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

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

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;

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

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;

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

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