DBA Data[Home] [Help]

APPS.WMS_WP_CUSTOM_APIS_PUB dependencies on FND_API

Line 39: x_return_status := fnd_api.g_ret_sts_success;

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;
40: l_progress := '30';
41:
42: -- If the custom API is not implemented, return a value of FALSE for the output
43: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 111: WHEN FND_API.G_EXC_ERROR THEN

107: print_debug('***Exiting create_wave_lines_cust***');
108: END IF;
109:
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);

Line 113: x_return_status := fnd_api.g_ret_sts_error;

109:
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: ' ||

Line 121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

117: print_debug('Exiting create_wave_lines_cust - Execution error: ' ||
118: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
119: END IF;
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);

Line 123: x_return_status := fnd_api.g_ret_sts_unexp_error;

119: END IF;
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: ' ||

Line 133: x_return_status := fnd_api.g_ret_sts_unexp_error;

129: END IF;
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;

Line 182: x_return_status := fnd_api.g_ret_sts_success;

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;
183: l_progress := '30';
184:
185: -- If the custom API is not implemented, return a value of FALSE for the output
186: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 260: WHEN FND_API.G_EXC_ERROR THEN

256: print_debug('***Exiting Get_wave_exceptions_cust***');
257: END IF;
258:
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);

Line 262: x_return_status := fnd_api.g_ret_sts_error;

258:
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: ' ||

Line 270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

266: print_debug('Exiting Get_wave_exceptions_cust - Execution error: ' ||
267: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
268: END IF;
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);

Line 272: x_return_status := fnd_api.g_ret_sts_unexp_error;

268: END IF;
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: ' ||

Line 282: x_return_status := fnd_api.g_ret_sts_unexp_error;

278: END IF;
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;

Line 322: x_return_status := fnd_api.g_ret_sts_success;

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;
323: l_progress := '30';
324:
325: -- If the custom API is not implemented, return a value of FALSE for the output
326: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 345: WHEN FND_API.G_EXC_ERROR THEN

341: print_debug('***Exiting task_release_cust***');
342: END IF;
343:
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);

Line 347: x_return_status := fnd_api.g_ret_sts_error;

343:
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: ' ||

Line 355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

351: print_debug('Exiting task_release_cust - Execution error: ' ||
352: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
353: END IF;
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);

Line 357: x_return_status := fnd_api.g_ret_sts_unexp_error;

353: END IF;
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: ' ||

Line 367: x_return_status := fnd_api.g_ret_sts_unexp_error;

363: END IF;
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;