APPS.WMS_PLAN_TASKS_PVT dependencies on FND_API

Line 239: x_return_status := fnd_api.g_ret_sts_success;

235: debug('NOT Querying Crossdock tasks', 'query_inbound');
236: END IF;
237: END IF;
238:
239: x_return_status := fnd_api.g_ret_sts_success;
240:
241: /* set the planned_tasks record statuses if planned_tasks are queried*/
242: IF wms_plan_tasks_pvt.g_query_planned_tasks THEN
243: IF l_debug = 1 THEN

Line 914: WHEN fnd_api.g_exc_error THEN

910: wms_plan_tasks_pvt.g_plans_tasks_record_count - SQL%ROWCOUNT;
911: END IF;
912:
913: EXCEPTION
914: WHEN fnd_api.g_exc_error THEN
915: x_return_status := fnd_api.g_ret_sts_error ;
916: IF l_debug = 1 THEN
917: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-error');
918: END IF;

Line 915: x_return_status := fnd_api.g_ret_sts_error ;

911: END IF;
912:
913: EXCEPTION
914: WHEN fnd_api.g_exc_error THEN
915: x_return_status := fnd_api.g_ret_sts_error ;
916: IF l_debug = 1 THEN
917: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-error');
918: END IF;
919: WHEN fnd_api.g_exc_unexpected_error THEN

Line 919: WHEN fnd_api.g_exc_unexpected_error THEN

915: x_return_status := fnd_api.g_ret_sts_error ;
916: IF l_debug = 1 THEN
917: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-error');
918: END IF;
919: WHEN fnd_api.g_exc_unexpected_error THEN
920: x_return_status := fnd_api.g_ret_sts_unexp_error ;
921: IF l_debug = 1 THEN
922: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-unexpected error');
923: END IF;

Line 920: x_return_status := fnd_api.g_ret_sts_unexp_error ;

916: IF l_debug = 1 THEN
917: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-error');
918: END IF;
919: WHEN fnd_api.g_exc_unexpected_error THEN
920: x_return_status := fnd_api.g_ret_sts_unexp_error ;
921: IF l_debug = 1 THEN
922: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-unexpected error');
923: END IF;
924: WHEN OTHERS THEN

Line 925: x_return_status := fnd_api.g_ret_sts_error ;

921: IF l_debug = 1 THEN
922: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-unexpected error');
923: END IF;
924: WHEN OTHERS THEN
925: x_return_status := fnd_api.g_ret_sts_error ;
926: IF l_debug = 1 THEN
927: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-other error');
928: END IF;
929: