DBA Data[Home] [Help]

APPS.INV_PR_PICK_SLIP_NUMBER dependencies on FND_PROFILE

Line 67: g_trace_on NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),2);

63: g_rule_table grptabtyp;
64: g_hash_base NUMBER := 1;
65: g_hash_size NUMBER := POWER(2, 25);
66: g_pkg_name CONSTANT VARCHAR2(50) := 'INV_PR_PICK_SLIP_NUMBER';
67: g_trace_on NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),2);
68: -- For cahing the limit information for an org
69: g_prev_org_id NUMBER;
70: g_pickslip_limit NUMBER;
71:

Line 1205: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1201: PRAGMA EXCEPTION_INIT (wait_timeout_exc, -30006);
1202:
1203: BEGIN
1204: x_api_status := fnd_api.g_ret_sts_success;
1205: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1206:
1207: IF (l_debug = 1) THEN
1208: inv_log_util.trace('p_hash_string = ' || p_hash_string,
1209: 'INV_PR_PICK_SLIP_NUMBER.GEN_PARALLEL_PICK_SLIP_NUMBER', 3);