DBA Data[Home] [Help]

APPS.EAM_DEPT_APPROVERS_PVT dependencies on FND_MSG_PUB

Line 74: fnd_msg_pub.initialize;

70: END IF;
71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF fnd_api.to_boolean(p_init_msg_list) THEN
74: fnd_msg_pub.initialize;
75: END IF;
76:
77: -- Initialize API return status to success
78: x_return_status := fnd_api.g_ret_sts_success;

Line 128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

124: COMMIT WORK;
125: END IF;
126:
127: -- Standard call to get message count and if count is 1, get message info.
128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
129: EXCEPTION
130: WHEN fnd_api.g_exc_error THEN
131: ROLLBACK TO apiname_apitype;
132: x_return_status := fnd_api.g_ret_sts_error;

Line 133: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

129: EXCEPTION
130: WHEN fnd_api.g_exc_error THEN
131: ROLLBACK TO apiname_apitype;
132: x_return_status := fnd_api.g_ret_sts_error;
133: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
134: WHEN fnd_api.g_exc_unexpected_error THEN
135: ROLLBACK TO apiname_apitype;
136: x_return_status := fnd_api.g_ret_sts_unexp_error;
137: fnd_msg_pub.count_and_get(

Line 137: fnd_msg_pub.count_and_get(

133: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
134: WHEN fnd_api.g_exc_unexpected_error THEN
135: ROLLBACK TO apiname_apitype;
136: x_return_status := fnd_api.g_ret_sts_unexp_error;
137: fnd_msg_pub.count_and_get(
138: p_count => x_msg_count
139: ,p_data => x_msg_data);
140: WHEN OTHERS THEN
141: ROLLBACK TO apiname_apitype;

Line 144: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

140: WHEN OTHERS THEN
141: ROLLBACK TO apiname_apitype;
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143:
144: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
145: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
146: END IF;
147:
148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

141: ROLLBACK TO apiname_apitype;
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143:
144: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
145: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
146: END IF;
147:
148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
149: END Insert_Row;

Line 148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

144: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
145: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
146: END IF;
147:
148: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
149: END Insert_Row;
150:
151:
152: PROCEDURE LOCK_ROW(

Line 193: fnd_msg_pub.initialize;

189: END IF;
190:
191: -- Initialize message list if p_init_msg_list is set to TRUE.
192: IF fnd_api.to_boolean(p_init_msg_list) THEN
193: fnd_msg_pub.initialize;
194: END IF;
195:
196: -- Initialize API return status to success
197: x_return_status := fnd_api.g_ret_sts_success;

Line 228: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

224: COMMIT WORK;
225: END IF;
226:
227: -- Standard call to get message count and if count is 1, get message info.
228: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
229: EXCEPTION
230: WHEN fnd_api.g_exc_error THEN
231: ROLLBACK TO apiname_apitype;
232: x_return_status := fnd_api.g_ret_sts_error;

Line 233: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

229: EXCEPTION
230: WHEN fnd_api.g_exc_error THEN
231: ROLLBACK TO apiname_apitype;
232: x_return_status := fnd_api.g_ret_sts_error;
233: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
234: WHEN fnd_api.g_exc_unexpected_error THEN
235: ROLLBACK TO apiname_apitype;
236: x_return_status := fnd_api.g_ret_sts_unexp_error;
237: fnd_msg_pub.count_and_get(

Line 237: fnd_msg_pub.count_and_get(

233: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
234: WHEN fnd_api.g_exc_unexpected_error THEN
235: ROLLBACK TO apiname_apitype;
236: x_return_status := fnd_api.g_ret_sts_unexp_error;
237: fnd_msg_pub.count_and_get(
238: p_count => x_msg_count
239: ,p_data => x_msg_data);
240: WHEN OTHERS THEN
241: ROLLBACK TO apiname_apitype;

Line 244: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

240: WHEN OTHERS THEN
241: ROLLBACK TO apiname_apitype;
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243:
244: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
245: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
246: END IF;
247:
248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

241: ROLLBACK TO apiname_apitype;
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243:
244: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
245: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
246: END IF;
247:
248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
249:

Line 248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

244: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
245: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
246: END IF;
247:
248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
249:
250: END Lock_Row;
251:
252:

Line 289: fnd_msg_pub.initialize;

285: END IF;
286:
287: -- Initialize message list if p_init_msg_list is set to TRUE.
288: IF fnd_api.to_boolean(p_init_msg_list) THEN
289: fnd_msg_pub.initialize;
290: END IF;
291:
292: -- Initialize API return status to success
293: x_return_status := fnd_api.g_ret_sts_success;

Line 322: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

318: COMMIT WORK;
319: END IF;
320:
321: -- Standard call to get message count and if count is 1, get message info.
322: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
323: EXCEPTION
324: WHEN fnd_api.g_exc_error THEN
325: ROLLBACK TO apiname_apitype;
326: x_return_status := fnd_api.g_ret_sts_error;

Line 327: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

323: EXCEPTION
324: WHEN fnd_api.g_exc_error THEN
325: ROLLBACK TO apiname_apitype;
326: x_return_status := fnd_api.g_ret_sts_error;
327: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
328: WHEN fnd_api.g_exc_unexpected_error THEN
329: ROLLBACK TO apiname_apitype;
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: fnd_msg_pub.count_and_get(

Line 331: fnd_msg_pub.count_and_get(

327: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
328: WHEN fnd_api.g_exc_unexpected_error THEN
329: ROLLBACK TO apiname_apitype;
330: x_return_status := fnd_api.g_ret_sts_unexp_error;
331: fnd_msg_pub.count_and_get(
332: p_count => x_msg_count
333: ,p_data => x_msg_data);
334: WHEN OTHERS THEN
335: ROLLBACK TO apiname_apitype;

Line 338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

334: WHEN OTHERS THEN
335: ROLLBACK TO apiname_apitype;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337:
338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
339: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
340: END IF;
341:
342: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

335: ROLLBACK TO apiname_apitype;
336: x_return_status := fnd_api.g_ret_sts_unexp_error;
337:
338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
339: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
340: END IF;
341:
342: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
343:

Line 342: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

338: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
339: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
340: END IF;
341:
342: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
343:
344: END Update_Row;
345:
346: