58: END IF;
59:
60: -- Initialize message list if p_init_msg_list is set to TRUE
61: IF fnd_api.to_boolean(p_init_msg_list) THEN
62: fnd_msg_pub.initialize;
63: END IF;
64:
65: -- Initialize API return status to success
66: x_return_status := fnd_api.g_ret_sts_success;
118: COMMIT WORK;
119: END IF;
120:
121: -- Standard call to get message count and if count is 1, get message info
122: fnd_msg_pub.count_and_get( p_count => x_msg_count
123: , p_data => x_msg_data );
124:
125: EXCEPTION
126: WHEN fnd_api.g_exc_error THEN
125: EXCEPTION
126: WHEN fnd_api.g_exc_error THEN
127: ROLLBACK TO make_entries_avail_pub;
128: x_return_status := fnd_api.g_ret_sts_error;
129: fnd_msg_pub.count_and_get( p_count => x_msg_count
130: , p_data => x_msg_data );
131: WHEN fnd_api.g_exc_unexpected_error THEN
132: ROLLBACK TO make_entries_avail_pub;
133: x_return_status := fnd_api.g_ret_sts_unexp_error;
130: , p_data => x_msg_data );
131: WHEN fnd_api.g_exc_unexpected_error THEN
132: ROLLBACK TO make_entries_avail_pub;
133: x_return_status := fnd_api.g_ret_sts_unexp_error;
134: fnd_msg_pub.count_and_get( p_count => x_msg_count
135: , p_data => x_msg_data );
136: WHEN OTHERS THEN
137: ROLLBACK TO make_entries_avail_pub;
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
135: , p_data => x_msg_data );
136: WHEN OTHERS THEN
137: ROLLBACK TO make_entries_avail_pub;
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
141: END IF;
142: fnd_msg_pub.count_and_get( p_count => x_msg_count
143: , p_data => x_msg_data );
136: WHEN OTHERS THEN
137: ROLLBACK TO make_entries_avail_pub;
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
141: END IF;
142: fnd_msg_pub.count_and_get( p_count => x_msg_count
143: , p_data => x_msg_data );
144:
138: x_return_status := fnd_api.g_ret_sts_unexp_error;
139: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
140: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
141: END IF;
142: fnd_msg_pub.count_and_get( p_count => x_msg_count
143: , p_data => x_msg_data );
144:
145: END MakeListEntriesAvailable;
146:
196: END IF;
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE
199: IF fnd_api.to_boolean(p_init_msg_list) THEN
200: fnd_msg_pub.initialize;
201: END IF;
202:
203: -- Initialize API return status to success
204: x_return_status := fnd_api.g_ret_sts_success;
258: COMMIT WORK;
259: END IF;
260:
261: -- Standard call to get message count and if count is 1, get message info
262: fnd_msg_pub.count_and_get( p_count => x_msg_count
263: , p_data => x_msg_data );
264:
265: EXCEPTION
266: WHEN fnd_api.g_exc_error THEN
265: EXCEPTION
266: WHEN fnd_api.g_exc_error THEN
267: ROLLBACK TO make_entries_avail_pub;
268: x_return_status := fnd_api.g_ret_sts_error;
269: fnd_msg_pub.count_and_get( p_count => x_msg_count
270: , p_data => x_msg_data );
271: WHEN fnd_api.g_exc_unexpected_error THEN
272: ROLLBACK TO make_entries_avail_pub;
273: x_return_status := fnd_api.g_ret_sts_unexp_error;
270: , p_data => x_msg_data );
271: WHEN fnd_api.g_exc_unexpected_error THEN
272: ROLLBACK TO make_entries_avail_pub;
273: x_return_status := fnd_api.g_ret_sts_unexp_error;
274: fnd_msg_pub.count_and_get( p_count => x_msg_count
275: , p_data => x_msg_data );
276: WHEN OTHERS THEN
277: ROLLBACK TO make_entries_avail_pub;
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: , p_data => x_msg_data );
276: WHEN OTHERS THEN
277: ROLLBACK TO make_entries_avail_pub;
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282: fnd_msg_pub.count_and_get( p_count => x_msg_count
283: , p_data => x_msg_data );
276: WHEN OTHERS THEN
277: ROLLBACK TO make_entries_avail_pub;
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282: fnd_msg_pub.count_and_get( p_count => x_msg_count
283: , p_data => x_msg_data );
284:
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282: fnd_msg_pub.count_and_get( p_count => x_msg_count
283: , p_data => x_msg_data );
284:
285: END MakeListEntriesAvailable;
286: