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 243: RAISE fnd_api.g_exc_error;

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

Line 245: RAISE fnd_api.g_exc_unexpected_error;

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

Line 306: RAISE fnd_api.g_exc_error;

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

Line 308: RAISE fnd_api.g_exc_unexpected_error;

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

Line 343: RAISE fnd_api.g_exc_error;

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

Line 403: RAISE fnd_api.g_exc_error;

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

Line 468: RAISE fnd_api.g_exc_error;

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

Line 470: RAISE fnd_api.g_exc_unexpected_error;

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

Line 531: RAISE fnd_api.g_exc_error;

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

Line 533: RAISE fnd_api.g_exc_unexpected_error;

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

Line 567: RAISE fnd_api.g_exc_error;

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

Line 680: WHEN fnd_api.g_exc_error THEN

676: l_progress := '120';
677:
678: EXCEPTION
679:
680: WHEN fnd_api.g_exc_error THEN
681: ROLLBACK TO update_drop_loc_sp;
682:
683: x_return_status := g_ret_sts_error;
684: IF l_task_drop_loc_cur%isopen THEN