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);
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;
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. */
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);
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:
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