DBA Data[Home] [Help]

APPS.WMS_WP_CUSTOM_APIS_PUB dependencies on FND_MSG_PUB

Line 35: fnd_msg_pub.initialize;

31: SAVEPOINT create_wave_lines_cust_sp;
32: l_progress := '10';
33:
34: -- Initialize message list to clear any existing messages
35: fnd_msg_pub.initialize;
36: l_progress := '20';
37:
38: -- Initialize API return status to success
39: x_return_status := fnd_api.g_ret_sts_success;

Line 114: fnd_msg_pub.count_and_get(p_count => x_msg_count,

110: EXCEPTION
111: WHEN FND_API.G_EXC_ERROR THEN
112: ROLLBACK TO create_wave_lines_cust_sp;
113: x_return_status := fnd_api.g_ret_sts_error;
114: fnd_msg_pub.count_and_get(p_count => x_msg_count,
115: p_data => x_msg_data);
116: IF (l_debug = 1) THEN
117: print_debug('Exiting create_wave_lines_cust - Execution error: ' ||
118: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

Line 124: fnd_msg_pub.count_and_get(p_count => x_msg_count,

120:
121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
122: ROLLBACK TO Get_create_wave_lines_cust_sp;
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124: fnd_msg_pub.count_and_get(p_count => x_msg_count,
125: p_data => x_msg_data);
126: IF (l_debug = 1) THEN
127: print_debug('Exiting create_wave_lines_cust - Unexpected error: ' ||
128: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

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

130:
131: WHEN OTHERS THEN
132: ROLLBACK TO create_wave_lines_cust_sp;
133: x_return_status := fnd_api.g_ret_sts_unexp_error;
134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
136: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','create_wave_lines_cust');
137: END IF;
138: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 135: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

131: WHEN OTHERS THEN
132: ROLLBACK TO create_wave_lines_cust_sp;
133: x_return_status := fnd_api.g_ret_sts_unexp_error;
134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
136: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','create_wave_lines_cust');
137: END IF;
138: fnd_msg_pub.count_and_get(p_count => x_msg_count,
139: p_data => x_msg_data);

Line 136: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','create_wave_lines_cust');

132: ROLLBACK TO create_wave_lines_cust_sp;
133: x_return_status := fnd_api.g_ret_sts_unexp_error;
134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
136: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','create_wave_lines_cust');
137: END IF;
138: fnd_msg_pub.count_and_get(p_count => x_msg_count,
139: p_data => x_msg_data);
140: IF (l_debug = 1) THEN

Line 138: fnd_msg_pub.count_and_get(p_count => x_msg_count,

134: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
135: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
136: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','create_wave_lines_cust');
137: END IF;
138: fnd_msg_pub.count_and_get(p_count => x_msg_count,
139: p_data => x_msg_data);
140: IF (l_debug = 1) THEN
141: print_debug('Exiting create_wave_lines_cust - Others exception: ' ||
142: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

Line 178: fnd_msg_pub.initialize;

174: SAVEPOINT Get_wave_exceptions_cust_sp;
175: l_progress := '10';
176:
177: -- Initialize message list to clear any existing messages
178: fnd_msg_pub.initialize;
179: l_progress := '20';
180:
181: -- Initialize API return status to success
182: x_return_status := fnd_api.g_ret_sts_success;

Line 263: fnd_msg_pub.count_and_get(p_count => x_msg_count,

259: EXCEPTION
260: WHEN FND_API.G_EXC_ERROR THEN
261: ROLLBACK TO Get_wave_exceptions_cust_sp;
262: x_return_status := fnd_api.g_ret_sts_error;
263: fnd_msg_pub.count_and_get(p_count => x_msg_count,
264: p_data => x_msg_data);
265: IF (l_debug = 1) THEN
266: print_debug('Exiting Get_wave_exceptions_cust - Execution error: ' ||
267: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

Line 273: fnd_msg_pub.count_and_get(p_count => x_msg_count,

269:
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271: ROLLBACK TO Get_wave_exceptions_cust_sp;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: fnd_msg_pub.count_and_get(p_count => x_msg_count,
274: p_data => x_msg_data);
275: IF (l_debug = 1) THEN
276: print_debug('Exiting Get_wave_exceptions_cust - Unexpected error: ' ||
277: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

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

279:
280: WHEN OTHERS THEN
281: ROLLBACK TO Get_wave_exceptions_cust_sp;
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
284: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
285: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','Get_wave_exceptions_cust');
286: END IF;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 284: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

280: WHEN OTHERS THEN
281: ROLLBACK TO Get_wave_exceptions_cust_sp;
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
284: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
285: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','Get_wave_exceptions_cust');
286: END IF;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count,
288: p_data => x_msg_data);

Line 285: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','Get_wave_exceptions_cust');

281: ROLLBACK TO Get_wave_exceptions_cust_sp;
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
284: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
285: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','Get_wave_exceptions_cust');
286: END IF;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count,
288: p_data => x_msg_data);
289: IF (l_debug = 1) THEN

Line 287: fnd_msg_pub.count_and_get(p_count => x_msg_count,

283: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
284: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
285: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','Get_wave_exceptions_cust');
286: END IF;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count,
288: p_data => x_msg_data);
289: IF (l_debug = 1) THEN
290: print_debug('Exiting Get_wave_exceptions_cust - Others exception: ' ||
291: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

Line 318: fnd_msg_pub.initialize;

314: SAVEPOINT task_release_cust_sp;
315: l_progress := '10';
316:
317: -- Initialize message list to clear any existing messages
318: fnd_msg_pub.initialize;
319: l_progress := '20';
320:
321: -- Initialize API return status to success
322: x_return_status := fnd_api.g_ret_sts_success;

Line 348: fnd_msg_pub.count_and_get(p_count => x_msg_count,

344: EXCEPTION
345: WHEN FND_API.G_EXC_ERROR THEN
346: ROLLBACK TO task_release_cust_sp;
347: x_return_status := fnd_api.g_ret_sts_error;
348: fnd_msg_pub.count_and_get(p_count => x_msg_count,
349: p_data => x_msg_data);
350: IF (l_debug = 1) THEN
351: print_debug('Exiting task_release_cust - Execution error: ' ||
352: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

Line 358: fnd_msg_pub.count_and_get(p_count => x_msg_count,

354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: ROLLBACK TO task_release_cust_ap;
357: x_return_status := fnd_api.g_ret_sts_unexp_error;
358: fnd_msg_pub.count_and_get(p_count => x_msg_count,
359: p_data => x_msg_data);
360: IF (l_debug = 1) THEN
361: print_debug('Exiting task_release_cust - Unexpected error: ' ||
362: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));

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

364:
365: WHEN OTHERS THEN
366: ROLLBACK TO task_release_cust_sp;
367: x_return_status := fnd_api.g_ret_sts_unexp_error;
368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
369: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
370: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','task_release_cust');
371: END IF;
372: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 369: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

365: WHEN OTHERS THEN
366: ROLLBACK TO task_release_cust_sp;
367: x_return_status := fnd_api.g_ret_sts_unexp_error;
368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
369: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
370: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','task_release_cust');
371: END IF;
372: fnd_msg_pub.count_and_get(p_count => x_msg_count,
373: p_data => x_msg_data);

Line 370: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','task_release_cust');

366: ROLLBACK TO task_release_cust_sp;
367: x_return_status := fnd_api.g_ret_sts_unexp_error;
368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
369: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
370: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','task_release_cust');
371: END IF;
372: fnd_msg_pub.count_and_get(p_count => x_msg_count,
373: p_data => x_msg_data);
374: IF (l_debug = 1) THEN

Line 372: fnd_msg_pub.count_and_get(p_count => x_msg_count,

368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
369: --fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
370: fnd_msg_pub.add_exc_msg('wms_wp_custom_apis_pub','task_release_cust');
371: END IF;
372: fnd_msg_pub.count_and_get(p_count => x_msg_count,
373: p_data => x_msg_data);
374: IF (l_debug = 1) THEN
375: print_debug('Exiting task_release_cust - Others exception: ' ||
376: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));