211: debug('NOT Querying Crossdock tasks', 'query_inbound');
212: END IF;
213: END IF;
214:
215: x_return_status := fnd_api.g_ret_sts_success;
216:
217: /* set the planned_tasks record statuses if planned_tasks are queried*/
218: IF wms_plan_tasks_pvt.g_query_planned_tasks THEN
219: IF l_debug = 1 THEN
886: wms_plan_tasks_pvt.g_plans_tasks_record_count - SQL%ROWCOUNT;
887: END IF;
888:
889: EXCEPTION
890: WHEN fnd_api.g_exc_error THEN
891: x_return_status := fnd_api.g_ret_sts_error ;
892: IF l_debug = 1 THEN
893: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-error');
894: END IF;
887: END IF;
888:
889: EXCEPTION
890: WHEN fnd_api.g_exc_error THEN
891: x_return_status := fnd_api.g_ret_sts_error ;
892: IF l_debug = 1 THEN
893: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-error');
894: END IF;
895: WHEN fnd_api.g_exc_unexpected_error THEN
891: x_return_status := fnd_api.g_ret_sts_error ;
892: IF l_debug = 1 THEN
893: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-error');
894: END IF;
895: WHEN fnd_api.g_exc_unexpected_error THEN
896: x_return_status := fnd_api.g_ret_sts_unexp_error ;
897: IF l_debug = 1 THEN
898: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-unexpected error');
899: END IF;
892: IF l_debug = 1 THEN
893: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-error');
894: END IF;
895: WHEN fnd_api.g_exc_unexpected_error THEN
896: x_return_status := fnd_api.g_ret_sts_unexp_error ;
897: IF l_debug = 1 THEN
898: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-unexpected error');
899: END IF;
900: WHEN OTHERS THEN
897: IF l_debug = 1 THEN
898: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-unexpected error');
899: END IF;
900: WHEN OTHERS THEN
901: x_return_status := fnd_api.g_ret_sts_error ;
902: IF l_debug = 1 THEN
903: DEBUG(SQLERRM, 'plan_tasks.query_inbound_tasks-other error');
904: END IF;
905: