256: begin
257:
258: -- Initialize message list if p_init_msg_list is set to TRUE
259: if fnd_api.to_boolean( p_init_msg_list ) then
260: fnd_msg_pub.initialize;
261: end if;
262:
263: -- Initialize API return status to success
264: x_return_status := fnd_api.g_ret_sts_success;
277: raise fnd_api.g_exc_error;
278: end if;
279:
280: -- Standard call to get message count and if count is 1, get message info
281: fnd_msg_pub.count_and_get( p_count => x_msg_count
282: ,p_data => x_msg_data );
283:
284: exception
285: when fnd_api.g_exc_error then
283:
284: exception
285: when fnd_api.g_exc_error then
286: x_return_status := fnd_api.g_ret_sts_error;
287: fnd_msg_pub.count_and_get( p_count => x_msg_count
288: ,p_data => x_msg_data );
289:
290: when fnd_api.g_exc_unexpected_error then
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
288: ,p_data => x_msg_data );
289:
290: when fnd_api.g_exc_unexpected_error then
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: fnd_msg_pub.count_and_get( p_count => x_msg_count
293: ,p_data => x_msg_data );
294:
295: when others then
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
293: ,p_data => x_msg_data );
294:
295: when others then
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
298: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
299: end if;
300: fnd_msg_pub.count_and_get( p_count => x_msg_count
301: ,p_data => x_msg_data );
294:
295: when others then
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
298: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
299: end if;
300: fnd_msg_pub.count_and_get( p_count => x_msg_count
301: ,p_data => x_msg_data );
302:
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
298: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
299: end if;
300: fnd_msg_pub.count_and_get( p_count => x_msg_count
301: ,p_data => x_msg_data );
302:
303: end SearchForStrategy;
304:
345: begin
346:
347: -- Initialize message list if p_init_msg_list is set to TRUE
348: if fnd_api.to_boolean( p_init_msg_list ) then
349: fnd_msg_pub.initialize;
350: end if;
351:
352: -- Initialize API return status to success
353: x_return_status := fnd_api.g_ret_sts_success;
367: raise fnd_api.g_exc_error;
368: end if;
369:
370: -- Standard call to get message count and if count is 1, get message info
371: fnd_msg_pub.count_and_get( p_count => x_msg_count
372: ,p_data => x_msg_data );
373:
374: exception
375: when fnd_api.g_exc_error then
373:
374: exception
375: when fnd_api.g_exc_error then
376: x_return_status := fnd_api.g_ret_sts_error;
377: fnd_msg_pub.count_and_get( p_count => x_msg_count
378: ,p_data => x_msg_data );
379:
380: when fnd_api.g_exc_unexpected_error then
381: x_return_status := fnd_api.g_ret_sts_unexp_error;
378: ,p_data => x_msg_data );
379:
380: when fnd_api.g_exc_unexpected_error then
381: x_return_status := fnd_api.g_ret_sts_unexp_error;
382: fnd_msg_pub.count_and_get( p_count => x_msg_count
383: ,p_data => x_msg_data );
384:
385: when others then
386: x_return_status := fnd_api.g_ret_sts_unexp_error;
383: ,p_data => x_msg_data );
384:
385: when others then
386: x_return_status := fnd_api.g_ret_sts_unexp_error;
387: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
389: end if;
390: fnd_msg_pub.count_and_get( p_count => x_msg_count
391: ,p_data => x_msg_data );
384:
385: when others then
386: x_return_status := fnd_api.g_ret_sts_unexp_error;
387: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
389: end if;
390: fnd_msg_pub.count_and_get( p_count => x_msg_count
391: ,p_data => x_msg_data );
392:
386: x_return_status := fnd_api.g_ret_sts_unexp_error;
387: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
388: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
389: end if;
390: fnd_msg_pub.count_and_get( p_count => x_msg_count
391: ,p_data => x_msg_data );
392:
393: end SearchForStrategy;
394: