DBA Data[Home] [Help]

APPS.WMS_OP_RUNTIME_PUB_APIS dependencies on FND_API

Line 24: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;

20: g_wms_task_type_stg_move NUMBER := wms_globals.g_wms_task_type_stg_move;
21: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
22: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
23:
24: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
25: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
26: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
27:
28: PROCEDURE print_debug(p_err_msg VARCHAR2,

Line 25: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;

21: g_op_drop_lpn_no_lpn NUMBER := wms_globals.g_op_drop_lpn_no_lpn;
22: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
23:
24: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
25: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
26: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
27:
28: PROCEDURE print_debug(p_err_msg VARCHAR2,
29: p_level NUMBER)

Line 26: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;

22: g_op_drop_lpn_optional NUMBER := wms_globals.g_op_drop_lpn_optional;
23:
24: g_ret_sts_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
25: g_ret_sts_unexp_error VARCHAR2(1) := fnd_api.g_ret_sts_unexp_error;
26: g_ret_sts_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
27:
28: PROCEDURE print_debug(p_err_msg VARCHAR2,
29: p_level NUMBER)
30: IS

Line 242: RAISE fnd_api.g_exc_error;

238:
239: IF l_return_status <> g_ret_sts_success THEN
240: print_debug('Failed calling wms_mdc_pvt.suggest_to_lpn.', 4);
241: IF l_return_status = g_ret_sts_error THEN
242: RAISE fnd_api.g_exc_error;
243: ELSE
244: RAISE fnd_api.g_exc_unexpected_error;
245: END IF;
246: END IF;

Line 244: RAISE fnd_api.g_exc_unexpected_error;

240: print_debug('Failed calling wms_mdc_pvt.suggest_to_lpn.', 4);
241: IF l_return_status = g_ret_sts_error THEN
242: RAISE fnd_api.g_exc_error;
243: ELSE
244: RAISE fnd_api.g_exc_unexpected_error;
245: END IF;
246: END IF;
247:
248: ELSE

Line 305: RAISE fnd_api.g_exc_error;

301:
302: IF l_return_status <> g_ret_sts_success THEN
303: print_debug('Failed calling wms_mdc_pvt.suggest_to_lpn.', 4);
304: IF l_return_status = g_ret_sts_error THEN
305: RAISE fnd_api.g_exc_error;
306: ELSE
307: RAISE fnd_api.g_exc_unexpected_error;
308: END IF;
309: END IF;

Line 307: RAISE fnd_api.g_exc_unexpected_error;

303: print_debug('Failed calling wms_mdc_pvt.suggest_to_lpn.', 4);
304: IF l_return_status = g_ret_sts_error THEN
305: RAISE fnd_api.g_exc_error;
306: ELSE
307: RAISE fnd_api.g_exc_unexpected_error;
308: END IF;
309: END IF;
310: END IF;
311:

Line 342: RAISE fnd_api.g_exc_error;

338: IF l_return_status = 'W' THEN
339: x_return_status := l_return_status;
340: x_message := l_message;
341: ELSE
342: RAISE fnd_api.g_exc_error;
343: END IF;
344:
345: END IF;
346:

Line 402: RAISE fnd_api.g_exc_error;

398: IF l_return_status = 'W' THEN
399: x_return_status := l_return_status;
400: x_message := l_message;
401: ELSE
402: RAISE fnd_api.g_exc_error;
403: END IF;
404: ELSIF l_task_drop_loc_rec.parent_line_id IS NOT NULL THEN
405: --
406: -- Bug 4884284: Bulk pick can have multiple deliveries

Line 467: RAISE fnd_api.g_exc_error;

463:
464: IF l_return_status <> g_ret_sts_success THEN
465: print_debug('Failed calling wms_mdc_pvt.suggest_to_lpn.', 4);
466: IF l_return_status = g_ret_sts_error THEN
467: RAISE fnd_api.g_exc_error;
468: ELSE
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
471: END IF;

Line 469: RAISE fnd_api.g_exc_unexpected_error;

465: print_debug('Failed calling wms_mdc_pvt.suggest_to_lpn.', 4);
466: IF l_return_status = g_ret_sts_error THEN
467: RAISE fnd_api.g_exc_error;
468: ELSE
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
471: END IF;
472:
473: ELSE

Line 530: RAISE fnd_api.g_exc_error;

526:
527: IF l_return_status <> g_ret_sts_success THEN
528: print_debug('Failed calling wms_mdc_pvt.suggest_to_lpn.', 4);
529: IF l_return_status = g_ret_sts_error THEN
530: RAISE fnd_api.g_exc_error;
531: ELSE
532: RAISE fnd_api.g_exc_unexpected_error;
533: END IF;
534: END IF;

Line 532: RAISE fnd_api.g_exc_unexpected_error;

528: print_debug('Failed calling wms_mdc_pvt.suggest_to_lpn.', 4);
529: IF l_return_status = g_ret_sts_error THEN
530: RAISE fnd_api.g_exc_error;
531: ELSE
532: RAISE fnd_api.g_exc_unexpected_error;
533: END IF;
534: END IF;
535: END IF; -- l_delivery_id IS NOT NULL
536:

Line 566: RAISE fnd_api.g_exc_error;

562: IF l_return_status = 'W' THEN
563: x_return_status := l_return_status;
564: x_message := l_message;
565: ELSE
566: RAISE fnd_api.g_exc_error;
567: END IF;
568:
569: END IF;
570:

Line 672: WHEN fnd_api.g_exc_error THEN

668: l_progress := '120';
669:
670: EXCEPTION
671:
672: WHEN fnd_api.g_exc_error THEN
673: ROLLBACK TO update_drop_loc_sp;
674:
675: x_return_status := g_ret_sts_error;
676: IF l_task_drop_loc_cur%isopen THEN