DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_HOOK dependencies on INV_MATERIAL_STATUS_HOOK

Line 1: PACKAGE BODY INV_MATERIAL_STATUS_HOOK AS

1: PACKAGE BODY INV_MATERIAL_STATUS_HOOK AS
2: /* $Header: INVMSHKB.pls 120.0.12010000.2 2009/04/27 22:51:50 musinha noship $ */
3:
4: PROCEDURE validate_rsv_matstatus (p_old_status_id IN mtl_material_statuses.status_id%TYPE,
5: p_new_status_id IN mtl_material_statuses.status_id%TYPE,

Line 18: inv_trx_util_pub.TRACE('Entered validate_rsv_matstatus', 'INV_MATERIAL_STATUS_HOOK', 9);

14: BEGIN
15:
16: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
17: IF (l_debug = 1) THEN
18: inv_trx_util_pub.TRACE('Entered validate_rsv_matstatus', 'INV_MATERIAL_STATUS_HOOK', 9);
19: IF (x_ret_status) THEN
20: inv_trx_util_pub.TRACE('return status: TRUE', 'INV_MATERIAL_STATUS_HOOK', 9);
21: ELSE
22: inv_trx_util_pub.TRACE('return status: FALSE', 'INV_MATERIAL_STATUS_HOOK', 9);

Line 20: inv_trx_util_pub.TRACE('return status: TRUE', 'INV_MATERIAL_STATUS_HOOK', 9);

16: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
17: IF (l_debug = 1) THEN
18: inv_trx_util_pub.TRACE('Entered validate_rsv_matstatus', 'INV_MATERIAL_STATUS_HOOK', 9);
19: IF (x_ret_status) THEN
20: inv_trx_util_pub.TRACE('return status: TRUE', 'INV_MATERIAL_STATUS_HOOK', 9);
21: ELSE
22: inv_trx_util_pub.TRACE('return status: FALSE', 'INV_MATERIAL_STATUS_HOOK', 9);
23: END IF;
24: END IF;

Line 22: inv_trx_util_pub.TRACE('return status: FALSE', 'INV_MATERIAL_STATUS_HOOK', 9);

18: inv_trx_util_pub.TRACE('Entered validate_rsv_matstatus', 'INV_MATERIAL_STATUS_HOOK', 9);
19: IF (x_ret_status) THEN
20: inv_trx_util_pub.TRACE('return status: TRUE', 'INV_MATERIAL_STATUS_HOOK', 9);
21: ELSE
22: inv_trx_util_pub.TRACE('return status: FALSE', 'INV_MATERIAL_STATUS_HOOK', 9);
23: END IF;
24: END IF;
25:
26: /* If a custom logic is put then set the x_ret_status accordingly. */

Line 33: inv_trx_util_pub.TRACE('return status: TRUE', 'INV_MATERIAL_STATUS_HOOK', 9);

29: ------------------------------------
30:
31: IF (l_debug = 1 ) THEN
32: IF (x_ret_status) THEN
33: inv_trx_util_pub.TRACE('return status: TRUE', 'INV_MATERIAL_STATUS_HOOK', 9);
34: ELSE
35: inv_trx_util_pub.TRACE('return status: FALSE', 'INV_MATERIAL_STATUS_HOOK', 9);
36: END IF;
37: inv_trx_util_pub.TRACE('Exiting validate_rsv_matstatus', 'INV_MATERIAL_STATUS_HOOK', 9);

Line 35: inv_trx_util_pub.TRACE('return status: FALSE', 'INV_MATERIAL_STATUS_HOOK', 9);

31: IF (l_debug = 1 ) THEN
32: IF (x_ret_status) THEN
33: inv_trx_util_pub.TRACE('return status: TRUE', 'INV_MATERIAL_STATUS_HOOK', 9);
34: ELSE
35: inv_trx_util_pub.TRACE('return status: FALSE', 'INV_MATERIAL_STATUS_HOOK', 9);
36: END IF;
37: inv_trx_util_pub.TRACE('Exiting validate_rsv_matstatus', 'INV_MATERIAL_STATUS_HOOK', 9);
38: END IF;
39:

Line 37: inv_trx_util_pub.TRACE('Exiting validate_rsv_matstatus', 'INV_MATERIAL_STATUS_HOOK', 9);

33: inv_trx_util_pub.TRACE('return status: TRUE', 'INV_MATERIAL_STATUS_HOOK', 9);
34: ELSE
35: inv_trx_util_pub.TRACE('return status: FALSE', 'INV_MATERIAL_STATUS_HOOK', 9);
36: END IF;
37: inv_trx_util_pub.TRACE('Exiting validate_rsv_matstatus', 'INV_MATERIAL_STATUS_HOOK', 9);
38: END IF;
39:
40: EXCEPTION
41: when others then

Line 45: END INV_MATERIAL_STATUS_HOOK;

41: when others then
42: null;
43: END validate_rsv_matstatus;
44:
45: END INV_MATERIAL_STATUS_HOOK;