DBA Data[Home] [Help]

APPS.AHL_OSP_QUERIES_PVT dependencies on FND_PROFILE

Line 11: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');

7: G_EMPTY_WO_IDS_TABLE AHL_OSP_QUERIES_PVT.work_id_tbl_type;
8:
9: G_VENDOR_DEPT_CLASS_CODE CONSTANT VARCHAR2(30) := 'Vendor';
10:
11: --G_DEBUG VARCHAR2(1):=FND_PROFILE.VALUE('AHL_API_FILE_DEBUG_ON');
12: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
13: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_OSP_QUERIES_PVT';
14:
15:

Line 1784: l_org_id := FND_PROFILE.VALUE('ORG_ID');

1780: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Function');
1782: END IF;
1783:
1784: l_org_id := FND_PROFILE.VALUE('ORG_ID');
1785: IF (p_work_order_id IS NOT NULL) THEN
1786: IF (p_work_order_ids IS NOT NULL AND p_work_order_ids.COUNT > 0) THEN
1787: -- Cannot provide values in both the parameters of this function
1788: RAISE TOO_MANY_ROWS;