DBA Data[Home] [Help]

APPS.AHL_PRD_UTIL_PKG dependencies on FND_LOG

Line 17: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;

13: ------------------------------------------------------------------------------------------------
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_UTIL_PKG';
15: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
16:
17: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
18: l_log_statement NUMBER := FND_LOG.level_statement;
19: l_log_procedure NUMBER := FND_LOG.level_procedure;
20: ------------------------------------------------------------------------------------------------
21:

Line 18: l_log_statement NUMBER := FND_LOG.level_statement;

14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_UTIL_PKG';
15: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
16:
17: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
18: l_log_statement NUMBER := FND_LOG.level_statement;
19: l_log_procedure NUMBER := FND_LOG.level_procedure;
20: ------------------------------------------------------------------------------------------------
21:
22: --Validates locator for a given organization. Also if subinventory is provided then chekcs if the loctaor belongs to the

Line 19: l_log_procedure NUMBER := FND_LOG.level_procedure;

15: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
16:
17: l_log_current_level NUMBER := FND_LOG.g_current_runtime_level;
18: l_log_statement NUMBER := FND_LOG.level_statement;
19: l_log_procedure NUMBER := FND_LOG.level_procedure;
20: ------------------------------------------------------------------------------------------------
21:
22: --Validates locator for a given organization. Also if subinventory is provided then chekcs if the loctaor belongs to the
23: -- subinventory.

Line 1795: FND_LOG.string(l_log_statement, l_full_name, 'Invalid input parameters provided.');

1791: RETURN l_rt_oper_resource_rec.resource_name;
1792: ELSIF (get_rt_oper_resource_csr%NOTFOUND) THEN
1793: CLOSE get_rt_oper_resource_csr;
1794: IF (l_log_statement >= l_log_current_level) THEN
1795: FND_LOG.string(l_log_statement, l_full_name, 'Invalid input parameters provided.');
1796: END IF;
1797: RETURN NULL;
1798: END IF;
1799:

Line 1801: FND_LOG.string(l_log_statement, l_full_name, 'Passed BOM resource was directly added in Production.');

1797: RETURN NULL;
1798: END IF;
1799:
1800: IF (l_log_statement >= l_log_current_level) THEN
1801: FND_LOG.string(l_log_statement, l_full_name, 'Passed BOM resource was directly added in Production.');
1802: END IF;
1803:
1804: /* Since, BOM resource was added directly in Production, search all the CMRO resources that
1805: * contain this BOM resource with specified organization and department if any, and return any one of them.

Line 1817: FND_LOG.string(l_log_statement, l_full_name, 'No CMRO resource exists corresponding to passed BOM resource, organization and department.');

1813: CLOSE derive_cmro_rsr_csr;
1814: RETURN l_aso_resource_name;
1815: ELSE
1816: IF (l_log_statement >= l_log_current_level) THEN
1817: FND_LOG.string(l_log_statement, l_full_name, 'No CMRO resource exists corresponding to passed BOM resource, organization and department.');
1818: END IF;
1819: CLOSE derive_cmro_rsr_csr;
1820: RETURN NULL;
1821: END IF;