DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on FND_MSG_PUB

Line 112: fnd_msg_pub.initialize;

108:
109: l_stmt_num := 30;
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: IF fnd_api.to_boolean(p_init_msg_list) THEN
112: fnd_msg_pub.initialize;
113: END IF;
114:
115: l_stmt_num := 40;
116: -- Initialize API return status to success

Line 410: fnd_msg_pub.count_and_get(

406: END IF;
407:
408: l_stmt_num := 999;
409: -- Standard call to get message count and if count is 1, get message info.
410: fnd_msg_pub.count_and_get(
411: p_encoded => fnd_api.g_false
412: ,p_count => x_msg_count
413: ,p_data => x_msg_data);
414:

Line 427: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

423:
424: WHEN fnd_api.g_exc_error THEN
425: ROLLBACK TO create_requisition_pvt;
426: x_return_status := fnd_api.g_ret_sts_error;
427: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
428: fnd_msg_pub.count_and_get(
429: p_encoded => fnd_api.g_false
430: ,p_count => x_msg_count
431: ,p_data => x_msg_data);

Line 428: fnd_msg_pub.count_and_get(

424: WHEN fnd_api.g_exc_error THEN
425: ROLLBACK TO create_requisition_pvt;
426: x_return_status := fnd_api.g_ret_sts_error;
427: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
428: fnd_msg_pub.count_and_get(
429: p_encoded => fnd_api.g_false
430: ,p_count => x_msg_count
431: ,p_data => x_msg_data);
432: WHEN fnd_api.g_exc_unexpected_error THEN

Line 435: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

431: ,p_data => x_msg_data);
432: WHEN fnd_api.g_exc_unexpected_error THEN
433: ROLLBACK TO create_requisition_pvt;
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
436: fnd_msg_pub.count_and_get(
437: p_encoded => fnd_api.g_false
438: ,p_count => x_msg_count
439: ,p_data => x_msg_data);

Line 436: fnd_msg_pub.count_and_get(

432: WHEN fnd_api.g_exc_unexpected_error THEN
433: ROLLBACK TO create_requisition_pvt;
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
436: fnd_msg_pub.count_and_get(
437: p_encoded => fnd_api.g_false
438: ,p_count => x_msg_count
439: ,p_data => x_msg_data);
440: WHEN OTHERS THEN

Line 443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);

439: ,p_data => x_msg_data);
440: WHEN OTHERS THEN
441: ROLLBACK TO create_requisition_pvt;
442: x_return_status := fnd_api.g_ret_sts_unexp_error;
443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
444: IF fnd_msg_pub.check_msg_level(
445: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
446: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
447: END IF;

Line 444: IF fnd_msg_pub.check_msg_level(

440: WHEN OTHERS THEN
441: ROLLBACK TO create_requisition_pvt;
442: x_return_status := fnd_api.g_ret_sts_unexp_error;
443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
444: IF fnd_msg_pub.check_msg_level(
445: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
446: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
447: END IF;
448:

Line 445: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

441: ROLLBACK TO create_requisition_pvt;
442: x_return_status := fnd_api.g_ret_sts_unexp_error;
443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
444: IF fnd_msg_pub.check_msg_level(
445: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
446: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
447: END IF;
448:
449: fnd_msg_pub.count_and_get(

Line 446: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

442: x_return_status := fnd_api.g_ret_sts_unexp_error;
443: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, SQLERRM);
444: IF fnd_msg_pub.check_msg_level(
445: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
446: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
447: END IF;
448:
449: fnd_msg_pub.count_and_get(
450: p_encoded => fnd_api.g_false

Line 449: fnd_msg_pub.count_and_get(

445: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
446: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
447: END IF;
448:
449: fnd_msg_pub.count_and_get(
450: p_encoded => fnd_api.g_false
451: ,p_count => x_msg_count
452: ,p_data => x_msg_data);
453:

Line 570: fnd_msg_pub.initialize;

566:
567: l_stmt_num := 30;
568: -- Initialize message list if p_init_msg_list is set to TRUE.
569: IF fnd_api.to_boolean(p_init_msg_list) THEN
570: fnd_msg_pub.initialize;
571: END IF;
572:
573: l_stmt_num := 40;
574: -- Initialize API return status to success

Line 978: fnd_msg_pub.initialize;

974:
975: l_stmt_num := 30;
976: -- Initialize message list if p_init_msg_list is set to TRUE.
977: IF fnd_api.to_boolean(p_init_msg_list) THEN
978: fnd_msg_pub.initialize;
979: END IF;
980:
981: l_stmt_num := 40;
982: -- Initialize API return status to success