DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on INV_VALIDATE

Line 1905: l_locator inv_validate.LOCATOR;

1901: ,p_txn_action_id IN NUMBER)
1902: RETURN BOOLEAN
1903: IS
1904: l_api_name CONSTANT VARCHAR2 (30) := 'check_locator';
1905: l_locator inv_validate.LOCATOR;
1906: l_org inv_validate.org;
1907: l_item inv_validate.item;
1908: l_sub inv_validate.sub;
1909: BEGIN

Line 1906: l_org inv_validate.org;

1902: RETURN BOOLEAN
1903: IS
1904: l_api_name CONSTANT VARCHAR2 (30) := 'check_locator';
1905: l_locator inv_validate.LOCATOR;
1906: l_org inv_validate.org;
1907: l_item inv_validate.item;
1908: l_sub inv_validate.sub;
1909: BEGIN
1910: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1907: l_item inv_validate.item;

1903: IS
1904: l_api_name CONSTANT VARCHAR2 (30) := 'check_locator';
1905: l_locator inv_validate.LOCATOR;
1906: l_org inv_validate.org;
1907: l_item inv_validate.item;
1908: l_sub inv_validate.sub;
1909: BEGIN
1910: IF g_debug <= gme_debug.g_log_procedure THEN
1911: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1908: l_sub inv_validate.sub;

1904: l_api_name CONSTANT VARCHAR2 (30) := 'check_locator';
1905: l_locator inv_validate.LOCATOR;
1906: l_org inv_validate.org;
1907: l_item inv_validate.item;
1908: l_sub inv_validate.sub;
1909: BEGIN
1910: IF g_debug <= gme_debug.g_log_procedure THEN
1911: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1912: || l_api_name);

Line 1954: IF (inv_validate.check_locator (p_locator => l_locator

1950: l_item.restrict_locators_code := p_item_loc_restrict;
1951: l_sub.secondary_inventory_name := p_subinventory;
1952: l_sub.locator_type := p_sub_control;
1953:
1954: IF (inv_validate.check_locator (p_locator => l_locator
1955: ,p_org => l_org
1956: ,p_item => l_item
1957: ,p_sub => l_sub
1958: ,p_project_id => NULL

Line 1963: inv_validate.f) THEN

1959: ,p_task_id => NULL
1960: ,p_txn_action_id => p_txn_action_id
1961: ,p_is_from_locator => NULL
1962: ,p_dynamic_ok => TRUE) =
1963: inv_validate.f) THEN
1964: fnd_message.set_name ('INV', 'INV_INVALID_LOCATION');
1965: fnd_msg_pub.ADD;
1966:
1967: IF g_debug <= gme_debug.g_log_statement THEN

Line 2005: l_org inv_validate.org;

2001: ,p_restrict_subinv IN NUMBER DEFAULT NULL)
2002: RETURN BOOLEAN
2003: IS
2004: l_api_name CONSTANT VARCHAR2 (30) := 'check_subinventory';
2005: l_org inv_validate.org;
2006: l_item inv_validate.item;
2007: l_sub inv_validate.sub;
2008:
2009: CURSOR cur_item_control

Line 2006: l_item inv_validate.item;

2002: RETURN BOOLEAN
2003: IS
2004: l_api_name CONSTANT VARCHAR2 (30) := 'check_subinventory';
2005: l_org inv_validate.org;
2006: l_item inv_validate.item;
2007: l_sub inv_validate.sub;
2008:
2009: CURSOR cur_item_control
2010: IS

Line 2007: l_sub inv_validate.sub;

2003: IS
2004: l_api_name CONSTANT VARCHAR2 (30) := 'check_subinventory';
2005: l_org inv_validate.org;
2006: l_item inv_validate.item;
2007: l_sub inv_validate.sub;
2008:
2009: CURSOR cur_item_control
2010: IS
2011: SELECT restrict_subinventories_code

Line 2057: IF (inv_validate.subinventory (p_org => l_org

2053: l_item_restict_subinv := p_restrict_subinv;
2054: END IF;
2055:
2056: IF (l_item_restict_subinv = 1) THEN
2057: IF (inv_validate.subinventory (p_org => l_org
2058: ,p_item => l_item
2059: ,p_sub => l_sub) = inv_validate.f) THEN
2060: IF g_debug <= gme_debug.g_log_statement THEN
2061: gme_debug.put_line ( g_pkg_name

Line 2059: ,p_sub => l_sub) = inv_validate.f) THEN

2055:
2056: IF (l_item_restict_subinv = 1) THEN
2057: IF (inv_validate.subinventory (p_org => l_org
2058: ,p_item => l_item
2059: ,p_sub => l_sub) = inv_validate.f) THEN
2060: IF g_debug <= gme_debug.g_log_statement THEN
2061: gme_debug.put_line ( g_pkg_name
2062: || '.'
2063: || l_api_name

Line 2070: IF (inv_validate.subinventory (p_org => l_org, p_sub => l_sub) =

2066:
2067: RETURN FALSE;
2068: END IF;
2069: ELSE
2070: IF (inv_validate.subinventory (p_org => l_org, p_sub => l_sub) =
2071: inv_validate.f) THEN
2072: IF g_debug <= gme_debug.g_log_statement THEN
2073: gme_debug.put_line ( g_pkg_name
2074: || '.'

Line 2071: inv_validate.f) THEN

2067: RETURN FALSE;
2068: END IF;
2069: ELSE
2070: IF (inv_validate.subinventory (p_org => l_org, p_sub => l_sub) =
2071: inv_validate.f) THEN
2072: IF g_debug <= gme_debug.g_log_statement THEN
2073: gme_debug.put_line ( g_pkg_name
2074: || '.'
2075: || l_api_name