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;
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'));
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'));
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,
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);
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
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'));
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;
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'));
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'));
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,
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);
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
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'));
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;
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'));
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'));
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,
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);
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
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'));