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
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:
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);
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
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);
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
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;
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:
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(
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
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:
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
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