APPS.WMS_ATF_DEST_LOCATOR dependencies on FND_API

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

91: and wahc.hook_call_id = p_hook_call_id;
92:
93: begin
94: -- ### Initialize API return status to success
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96:
97: if (l_debug = 1) then
98: trace(l_proc ||' Entering package wms_atf_dest_locator '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);
99: trace(l_proc ||' Entering procedure get_dest_locator '|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 1);

Line 147: raise fnd_api.g_exc_error;

143: trace(l_proc ||' This renders this relationship ineffective for the current run though this hook call..');
144: trace(l_proc ||' may have been valid when the operation plan was set up. ');
145: fnd_message.set_name('WMS', 'WMS_EXPIRED_HOOK_CALL_ID');
146: fnd_msg_pub.ADD;
147: raise fnd_api.g_exc_error;
148: end if;
149:
150:
151: -- ### Check if p_mode is 'Validation' and the p_locator_id is null.

Line 273: when fnd_api.g_exc_error then

269: end if;
270: close c_get_hook_call_details;
271: return;
272: exception
273: when fnd_api.g_exc_error then
274: x_return_status := fnd_api.g_ret_sts_error;
275:
276: if (l_debug = 1) then
277: trace(' Progress at the time of failure is ' || l_prog, 1);

Line 274: x_return_status := fnd_api.g_ret_sts_error;

270: close c_get_hook_call_details;
271: return;
272: exception
273: when fnd_api.g_exc_error then
274: x_return_status := fnd_api.g_ret_sts_error;
275:
276: if (l_debug = 1) then
277: trace(' Progress at the time of failure is ' || l_prog, 1);
278: trace(' Error Code, Error Message...' || sqlerrm(sqlcode), 1);