DBA Data[Home] [Help]

APPS.CSF_ACCESS_HOURS_PVT dependencies on FND_MSG_PUB

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

237: IF fnd_api.to_boolean(p_commit) THEN
238: commit work;
239: END IF;
240:
241: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
242: EXCEPTION
243:
244: WHEN fnd_api.g_exc_error then
245: ROLLBACK TO create_access_hours_pub;

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

245: ROLLBACK TO create_access_hours_pub;
246: x_return_status :=fnd_api.g_ret_sts_error;
247: /*x_msg_count := l_msg_count;
248: x_msg_data := l_msg_data;*/
249: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
250:
251: When fnd_api.g_exc_unexpected_error then
252: Rollback TO create_access_hours_pvt;
253: x_return_status:= fnd_api.g_ret_sts_unexp_error;

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

250:
251: When fnd_api.g_exc_unexpected_error then
252: Rollback TO create_access_hours_pvt;
253: x_return_status:= fnd_api.g_ret_sts_unexp_error;
254: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
255:
256: When others then
257: Rollback TO create_access_hours_pvt;
258: x_return_status:= fnd_api.g_ret_sts_unexp_error;

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

255:
256: When others then
257: Rollback TO create_access_hours_pvt;
258: x_return_status:= fnd_api.g_ret_sts_unexp_error;
259: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
260:
261: End CREATE_ACCESS_HOURS;
262:
263: PROCEDURE Update_Access_Hours(

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

384: -- Standard check of p_commit
385: IF fnd_api.to_boolean(p_commit) THEN
386: commit work;
387: END IF;
388: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
389:
390: EXCEPTION
391:
392: WHEN fnd_api.g_exc_error then

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

393: --ROLLBACK TO delete_access_hours_pub;
394: x_return_status :=fnd_api.g_ret_sts_error;
395: /*x_msg_count := l_msg_count;
396: x_msg_data := l_msg_data;*/
397: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
398:
399: WHEN fnd_api.g_exc_unexpected_error then
400: --ROLLBACK TO delete_access_hours_pub;
401: x_return_status :=fnd_api.g_ret_sts_unexp_error;

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

400: --ROLLBACK TO delete_access_hours_pub;
401: x_return_status :=fnd_api.g_ret_sts_unexp_error;
402: /*x_msg_count := l_msg_count;
403: x_msg_data := l_msg_data;*/
404: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
405:
406: WHEN OTHERS then
407: --ROLLBACK TO delete_access_hours_pub;
408: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

407: --ROLLBACK TO delete_access_hours_pub;
408: x_return_status := fnd_api.g_ret_sts_unexp_error;
409: /*x_msg_count := l_msg_count;
410: x_msg_data := l_msg_data;*/
411: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
412:
413: END Update_Access_Hours;
414:
415: PROCEDURE Delete_Access_Hours(

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

446: IF fnd_api.to_boolean(p_commit) THEN
447: commit work;
448: END IF;
449:
450: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
451:
452: EXCEPTION
453:
454: WHEN fnd_api.g_exc_error then

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

455: --ROLLBACK TO delete_access_hours_pub;
456: x_return_status := fnd_api.g_ret_sts_error;
457: /*x_msg_count := l_msg_count;
458: x_msg_data := l_msg_data;*/
459: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
460:
461: WHEN fnd_api.g_exc_unexpected_error then
462: --ROLLBACK TO delete_access_hours_pub;
463: x_return_status :=fnd_api.g_ret_sts_unexp_error;

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

462: --ROLLBACK TO delete_access_hours_pub;
463: x_return_status :=fnd_api.g_ret_sts_unexp_error;
464: /*x_msg_count := l_msg_count;
465: x_msg_data := l_msg_data;*/
466: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
467:
468: WHEN OTHERS then
469: --ROLLBACK TO delete_access_hours_pub;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

469: --ROLLBACK TO delete_access_hours_pub;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471: /*x_msg_count := l_msg_count;
472: x_msg_data := l_msg_data;*/
473: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
474:
475: END Delete_Access_Hours;
476:
477:

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

520: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
521: app_exception.raise_exception;
522: end if;
523:
524: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
525:
526: EXCEPTION
527:
528: WHEN fnd_api.g_exc_error then

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

529: --ROLLBACK TO delete_access_hours_pub;
530: x_return_status :=fnd_api.g_ret_sts_error;
531: /*x_msg_count := l_msg_count;
532: x_msg_data := l_msg_data;*/
533: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
534:
535: WHEN fnd_api.g_exc_unexpected_error then
536: --ROLLBACK TO delete_access_hours_pub;
537: x_return_status :=fnd_api.g_ret_sts_unexp_error;

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

536: --ROLLBACK TO delete_access_hours_pub;
537: x_return_status :=fnd_api.g_ret_sts_unexp_error;
538: /*x_msg_count := l_msg_count;
539: x_msg_data := l_msg_data;*/
540: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
541:
542: WHEN OTHERS then
543: --ROLLBACK TO delete_access_hours_pub;
544: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

543: --ROLLBACK TO delete_access_hours_pub;
544: x_return_status := fnd_api.g_ret_sts_unexp_error;
545: /*x_msg_count := l_msg_count;
546: x_msg_data := l_msg_data;*/
547: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
548: END lock_Access_Hours;
549:
550:
551: BEGIN