eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on AHL_DEBUG_PUB

Line 8: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');

4: G_PKG_NAME VARCHAR2(30) := 'AHL_RM_RT_OPER_RESOURCE_PVT';
5: G_API_NAME1 VARCHAR2(30) := 'PROCESS_RT_OPER_RESOURCE';
6: G_API_NAME2 VARCHAR2(30) := 'DEFINE_COST_PARAMETER';
7: G_API_NAME3 VARCHAR2(30) := 'PROCESS_ALTERNATE_RESOURCE';
8: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
9:
10: -- constants for WHO Columns
11: -- Added by balaji as a part of Public API cleanup
12: G_LAST_UPDATE_DATE DATE := SYSDATE;

Line 1205: AHL_DEBUG_PUB.enable_debug;

1201: FND_MSG_PUB.initialize;
1202: END IF;
1203:
1204: IF G_DEBUG = 'Y' THEN
1205: AHL_DEBUG_PUB.enable_debug;
1206: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );
1207: END IF;
1208:
1209:

Line 1206: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );

1202: END IF;
1203:
1204: IF G_DEBUG = 'Y' THEN
1205: AHL_DEBUG_PUB.enable_debug;
1206: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );
1207: END IF;
1208:
1209:
1210: --This is to be added before calling validate_api_inputs()

Line 1281: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after convert_values_to_ids' );

1277: END LOOP;
1278: --END IF;
1279:
1280: IF G_DEBUG = 'Y' THEN
1281: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after convert_values_to_ids' );
1282: END IF;
1283:
1284: -- Default rt_oper_resource attributes.
1285: /* Removed as a part of public API cleanup in 11510+.

Line 1299: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_attributes' );

1295: END IF;
1296: */
1297:
1298: IF G_DEBUG = 'Y' THEN
1299: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_attributes' );
1300: END IF;
1301:
1302: -- Validate all attributes (Item level validation)
1303: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

Line 1324: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_attributes' );

1320: END LOOP;
1321: --END IF;
1322:
1323: IF G_DEBUG = 'Y' THEN
1324: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_attributes' );
1325: END IF;
1326:
1327: -- Default missing and unchanged attributes.
1328: FOR i IN 1..p_x_rt_oper_resource_tbl.count LOOP

Line 1343: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_unchanged_attributes / default_missing_attributes' );

1339: END IF;
1340: END LOOP;
1341:
1342: IF G_DEBUG = 'Y' THEN
1343: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_unchanged_attributes / default_missing_attributes' );
1344: END IF;
1345:
1346: -- Perform cross attribute validation and missing attribute checks (Record level validation)
1347: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

Line 1370: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_record' );

1366: END LOOP;
1367: --END IF;
1368:
1369: IF G_DEBUG = 'Y' THEN
1370: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_record' );
1371: END IF;
1372:
1373: IF G_DEBUG='Y' THEN
1374: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');

Line 1374: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');

1370: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_record' );
1371: END IF;
1372:
1373: IF G_DEBUG='Y' THEN
1374: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');
1375: END IF;
1376:
1377: IF ( p_association_type_code = 'OPERATION')
1378: THEN

Line 1380: AHL_DEBUG_PUB.debug( 'p_association_type_code = OPERATION');

1376:
1377: IF ( p_association_type_code = 'OPERATION')
1378: THEN
1379: IF G_DEBUG='Y' THEN
1380: AHL_DEBUG_PUB.debug( 'p_association_type_code = OPERATION');
1381: END IF;
1382:
1383: AHL_RM_ROUTE_UTIL.validate_operation_status
1384: (

Line 1411: AHL_DEBUG_PUB.debug( 'p_association_type_code = ROUTE');

1407:
1408: ELSIF ( p_association_type_code = 'ROUTE')
1409: THEN
1410: IF G_DEBUG='Y' THEN
1411: AHL_DEBUG_PUB.debug( 'p_association_type_code = ROUTE');
1412: END IF;
1413: -- Check if the Route is existing and in Draft status
1414: AHL_RM_ROUTE_UTIL.validate_route_status
1415: (

Line 1632: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after DML operation' );

1628: END IF;
1629: END LOOP;
1630:
1631: IF G_DEBUG = 'Y' THEN
1632: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after DML operation' );
1633: END IF;
1634:
1635: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1636: l_msg_count := FND_MSG_PUB.count_msg;

Line 1658: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_records' );

1654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1655: END IF;
1656:
1657: IF G_DEBUG = 'Y' THEN
1658: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_records' );
1659: END IF;
1660:
1661: -- Bug # 7644260 (FP for ER # 6998882) -- start
1662: OPEN get_min_sch_seq( p_object_id, p_association_type_code );

Line 1689: AHL_DEBUG_PUB.disable_debug;

1685: );
1686:
1687: -- Disable debug (if enabled)
1688: IF G_DEBUG = 'Y' THEN
1689: AHL_DEBUG_PUB.disable_debug;
1690: END IF;
1691: EXCEPTION
1692: WHEN FND_API.G_EXC_ERROR THEN
1693: ROLLBACK TO process_rt_oper_resource_PVT;

Line 1704: AHL_DEBUG_PUB.disable_debug;

1700: );
1701:
1702: -- Disable debug (if enabled)
1703: IF G_DEBUG = 'Y' THEN
1704: AHL_DEBUG_PUB.disable_debug;
1705: END IF;
1706:
1707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1708: ROLLBACK TO process_rt_oper_resource_PVT;

Line 1719: AHL_DEBUG_PUB.disable_debug;

1715: );
1716:
1717: -- Disable debug (if enabled)
1718: IF G_DEBUG = 'Y' THEN
1719: AHL_DEBUG_PUB.disable_debug;
1720: END IF;
1721:
1722: WHEN OTHERS THEN
1723: ROLLBACK TO process_rt_oper_resource_PVT;

Line 1743: AHL_DEBUG_PUB.disable_debug;

1739: );
1740:
1741: -- Disable debug (if enabled)
1742: IF G_DEBUG = 'Y' THEN
1743: AHL_DEBUG_PUB.disable_debug;
1744: END IF;
1745:
1746: END process_rt_oper_resource;
1747:

Line 2138: AHL_DEBUG_PUB.enable_debug;

2134: FND_MSG_PUB.initialize;
2135: END IF;
2136:
2137: IF G_DEBUG = 'Y' THEN
2138: AHL_DEBUG_PUB.enable_debug;
2139: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.'||l_api_name||': Begin API' );
2140: END IF;
2141:
2142:

Line 2139: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.'||l_api_name||': Begin API' );

2135: END IF;
2136:
2137: IF G_DEBUG = 'Y' THEN
2138: AHL_DEBUG_PUB.enable_debug;
2139: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.'||l_api_name||': Begin API' );
2140: END IF;
2141:
2142:
2143: -- Convert Values into Ids.

Line 2161: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after convert_costing_values_to_ids' );

2157: END IF;
2158: --END IF;
2159:
2160: IF G_DEBUG = 'Y' THEN
2161: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after convert_costing_values_to_ids' );
2162: END IF;
2163:
2164: OPEN get_object_rec ( p_x_rt_oper_cost_rec.RT_OPER_RESOURCE_ID ) ;
2165: FETCH get_object_rec INTO

Line 2242: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_costing_unchanged' );

2238: p_x_rt_oper_cost_rec -- IN OUT
2239: );
2240:
2241: IF G_DEBUG = 'Y' THEN
2242: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_costing_unchanged' );
2243: END IF;
2244:
2245: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2246: l_msg_count := FND_MSG_PUB.count_msg;

Line 2271: AHL_DEBUG_PUB.debug( 'l_association_type_code = OPERATION');

2267: --to change the status of Approval rejected Routes/perations to Draft if costing parameters are updated.
2268: IF ( l_association_type_code = 'OPERATION')
2269: THEN
2270: IF G_DEBUG='Y' THEN
2271: AHL_DEBUG_PUB.debug( 'l_association_type_code = OPERATION');
2272: END IF;
2273:
2274: -- Check if the Route is existing and in Draft status
2275: AHL_RM_ROUTE_UTIL.validate_operation_status

Line 2304: AHL_DEBUG_PUB.debug( 'l_association_type_code = ROUTE');

2300:
2301: ELSIF ( l_association_type_code = 'ROUTE')
2302: THEN
2303: IF G_DEBUG='Y' THEN
2304: AHL_DEBUG_PUB.debug( 'l_association_type_code = ROUTE');
2305: END IF;
2306:
2307: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
2308: (

Line 2381: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after DML operation' );

2377: -- Set OUT values
2378: p_x_rt_oper_cost_rec.object_version_number := p_x_rt_oper_cost_rec.object_version_number + 1;
2379:
2380: IF G_DEBUG = 'Y' THEN
2381: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after DML operation' );
2382: END IF;
2383:
2384: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2385: l_msg_count := FND_MSG_PUB.count_msg;

Line 2406: AHL_DEBUG_PUB.disable_debug;

2402: );
2403:
2404: -- Disable debug (if enabled)
2405: IF G_DEBUG = 'Y' THEN
2406: AHL_DEBUG_PUB.disable_debug;
2407: END IF;
2408:
2409: EXCEPTION
2410: WHEN FND_API.G_EXC_ERROR THEN

Line 2422: AHL_DEBUG_PUB.disable_debug;

2418: );
2419:
2420: -- Disable debug (if enabled)
2421: IF G_DEBUG = 'Y' THEN
2422: AHL_DEBUG_PUB.disable_debug;
2423: END IF;
2424:
2425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2426: ROLLBACK TO define_cost_parameter_pvt;

Line 2437: AHL_DEBUG_PUB.disable_debug;

2433: );
2434:
2435: -- Disable debug (if enabled)
2436: IF G_DEBUG = 'Y' THEN
2437: AHL_DEBUG_PUB.disable_debug;
2438: END IF;
2439:
2440: WHEN OTHERS THEN
2441: ROLLBACK TO define_cost_parameter_pvt;

Line 2461: AHL_DEBUG_PUB.disable_debug;

2457: );
2458:
2459: -- Disable debug (if enabled)
2460: IF G_DEBUG = 'Y' THEN
2461: AHL_DEBUG_PUB.disable_debug;
2462: END IF;
2463:
2464: END define_cost_parameter;
2465:

Line 3204: AHL_DEBUG_PUB.enable_debug;

3200: FND_MSG_PUB.initialize;
3201: END IF;
3202:
3203: IF G_DEBUG = 'Y' THEN
3204: AHL_DEBUG_PUB.enable_debug;
3205: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : Begin API' );
3206: END IF;
3207:
3208: -- Validate all the inputs of the API

Line 3205: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : Begin API' );

3201: END IF;
3202:
3203: IF G_DEBUG = 'Y' THEN
3204: AHL_DEBUG_PUB.enable_debug;
3205: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : Begin API' );
3206: END IF;
3207:
3208: -- Validate all the inputs of the API
3209: validate_alt_api_inputs

Line 3250: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after convert_values_to_ids' );

3246: END LOOP;
3247: --END IF;
3248:
3249: IF G_DEBUG = 'Y' THEN
3250: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after convert_values_to_ids' );
3251: END IF;
3252:
3253: /* Removing the procedure call as a part of public API cleanup in 11510+
3254: -- Default rt_oper_resource attributes.

Line 3268: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after default_attributes' );

3264: END IF;
3265: */
3266:
3267: IF G_DEBUG = 'Y' THEN
3268: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after default_attributes' );
3269: END IF;
3270:
3271: -- Validate all attributes (Item level validation)
3272: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

Line 3291: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after validate_attributes' );

3287: END LOOP;
3288: --END IF;
3289:
3290: IF G_DEBUG = 'Y' THEN
3291: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after validate_attributes' );
3292: END IF;
3293:
3294: -- Default missing and unchanged attributes.
3295: FOR i IN 1..p_x_alt_resource_tbl.count LOOP

Line 3310: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after default_unchanged_attributes / default_missing_attributes' );

3306: END IF;
3307: END LOOP;
3308:
3309: IF G_DEBUG = 'Y' THEN
3310: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after default_unchanged_attributes / default_missing_attributes' );
3311: END IF;
3312:
3313: -- Perform cross attribute validation and missing attribute checks (Record level validation)
3314: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

Line 3336: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after validate_record' );

3332: END LOOP;
3333: --END IF;
3334:
3335: IF G_DEBUG = 'Y' THEN
3336: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after validate_record' );
3337: END IF;
3338:
3339: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
3340: l_msg_count := FND_MSG_PUB.count_msg;

Line 3507: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after DML operation' );

3503: END IF;
3504: END LOOP;
3505:
3506: IF G_DEBUG = 'Y' THEN
3507: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after DML operation' );
3508: END IF;
3509:
3510: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
3511: l_msg_count := FND_MSG_PUB.count_msg;

Line 3532: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after validate_records' );

3528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3529: END IF;
3530:
3531: IF G_DEBUG = 'Y' THEN
3532: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after validate_records' );
3533: END IF;
3534:
3535: -- Perform the Commit (if requested)
3536: IF FND_API.to_boolean( p_commit ) THEN

Line 3550: AHL_DEBUG_PUB.disable_debug;

3546: );
3547:
3548: -- Disable debug (if enabled)
3549: IF G_DEBUG = 'Y' THEN
3550: AHL_DEBUG_PUB.disable_debug;
3551: END IF;
3552:
3553: EXCEPTION
3554: WHEN FND_API.G_EXC_ERROR THEN

Line 3566: AHL_DEBUG_PUB.disable_debug;

3562: );
3563:
3564: -- Disable debug (if enabled)
3565: IF G_DEBUG = 'Y' THEN
3566: AHL_DEBUG_PUB.disable_debug;
3567: END IF;
3568:
3569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3570: ROLLBACK TO PROCESS_ALTERNATE_RESOURCE_PVT;

Line 3581: AHL_DEBUG_PUB.disable_debug;

3577: );
3578:
3579: -- Disable debug (if enabled)
3580: IF G_DEBUG = 'Y' THEN
3581: AHL_DEBUG_PUB.disable_debug;
3582: END IF;
3583:
3584: WHEN OTHERS THEN
3585: ROLLBACK TO PROCESS_ALTERNATE_RESOURCE_PVT;

Line 3605: AHL_DEBUG_PUB.disable_debug;

3601: );
3602:
3603: -- Disable debug (if enabled)
3604: IF G_DEBUG = 'Y' THEN
3605: AHL_DEBUG_PUB.disable_debug;
3606: END IF;
3607:
3608: END PROCESS_ALTERNATE_RESOURCE;
3609: