APPS.EAM_ASSET_SEARCH_PVT dependencies on FND_MSG_PUB

Line 116: fnd_msg_pub.initialize;

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

Line 134: fnd_msg_pub.add;

130: OR p_search_set_id <= 0 OR p_search_set_id IS NULL) THEN
131:
132: fnd_message.set_name('EAM', 'EAM_INPUT_PARAMS_NULL');
133: fnd_message.set_token('EAM_DEBUG',l_full_name||'('||l_stmt_num||')');
134: fnd_msg_pub.add;
135: l_sql_stmt := NULL;
136: RAISE fnd_api.g_exc_error;
137: END IF;
138:

Line 250: fnd_msg_pub.count_and_get(

246: END IF;
247:
248: l_stmt_num := 999;
249: -- Standard call to get message count and if count is 1, get message info.
250: fnd_msg_pub.count_and_get(
251: p_encoded => fnd_api.g_false
252: ,p_count => x_msg_count
253: ,p_data => x_msg_data);
254:

Line 261: fnd_msg_pub.count_and_get(

257: WHEN fnd_api.g_exc_error THEN
258: ROLLBACK TO build_search_sql_pvt;
259: x_return_status := fnd_api.g_ret_sts_error;
260: x_sql_stmt := l_sql_stmt;
261: fnd_msg_pub.count_and_get(
262: p_encoded => fnd_api.g_false
263: ,p_count => x_msg_count
264: ,p_data => x_msg_data);
265: WHEN fnd_api.g_exc_unexpected_error THEN

Line 269: fnd_msg_pub.count_and_get(

265: WHEN fnd_api.g_exc_unexpected_error THEN
266: ROLLBACK TO build_search_sql_pvt;
267: x_return_status := fnd_api.g_ret_sts_unexp_error;
268: x_sql_stmt := l_sql_stmt;
269: fnd_msg_pub.count_and_get(
270: p_encoded => fnd_api.g_false
271: ,p_count => x_msg_count
272: ,p_data => x_msg_data);
273: WHEN OTHERS THEN

Line 278: IF fnd_msg_pub.check_msg_level(

274: ROLLBACK TO build_search_sql_pvt;
275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276: x_sql_stmt := l_sql_stmt;
277:
278: IF fnd_msg_pub.check_msg_level(
279: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
281: END IF;
282:

Line 279: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

275: x_return_status := fnd_api.g_ret_sts_unexp_error;
276: x_sql_stmt := l_sql_stmt;
277:
278: IF fnd_msg_pub.check_msg_level(
279: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
281: END IF;
282:
283: fnd_msg_pub.count_and_get(

Line 280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

276: x_sql_stmt := l_sql_stmt;
277:
278: IF fnd_msg_pub.check_msg_level(
279: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
281: END IF;
282:
283: fnd_msg_pub.count_and_get(
284: p_encoded => fnd_api.g_false

Line 283: fnd_msg_pub.count_and_get(

279: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
280: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
281: END IF;
282:
283: fnd_msg_pub.count_and_get(
284: p_encoded => fnd_api.g_false
285: ,p_count => x_msg_count
286: ,p_data => x_msg_data);
287:

Line 346: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');

342: AND fdfcu.end_user_column_name = p_end_user_column_name;
343: EXCEPTION
344: WHEN OTHERS THEN
345: l_application_column_name := NULL;
346: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
347: RETURN l_application_column_name;
348: END;
349:
350: RETURN l_application_column_name;