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 1247: AHL_DEBUG_PUB.enable_debug;

1243: FND_MSG_PUB.initialize;
1244: END IF;
1245:
1246: IF G_DEBUG = 'Y' THEN
1247: AHL_DEBUG_PUB.enable_debug;
1248: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );
1249: END IF;
1250:
1251:

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

1244: END IF;
1245:
1246: IF G_DEBUG = 'Y' THEN
1247: AHL_DEBUG_PUB.enable_debug;
1248: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : Begin API' );
1249: END IF;
1250:
1251:
1252: --This is to be added before calling validate_api_inputs()

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

1319: END LOOP;
1320: --END IF;
1321:
1322: IF G_DEBUG = 'Y' THEN
1323: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after convert_values_to_ids' );
1324: END IF;
1325:
1326: -- Default rt_oper_resource attributes.
1327: /* Removed as a part of public API cleanup in 11510+.

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

1337: END IF;
1338: */
1339:
1340: IF G_DEBUG = 'Y' THEN
1341: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_attributes' );
1342: END IF;
1343:
1344: -- Validate all attributes (Item level validation)
1345: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

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

1362: END LOOP;
1363: --END IF;
1364:
1365: IF G_DEBUG = 'Y' THEN
1366: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_attributes' );
1367: END IF;
1368:
1369: -- Default missing and unchanged attributes.
1370: FOR i IN 1..p_x_rt_oper_resource_tbl.count LOOP

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

1381: END IF;
1382: END LOOP;
1383:
1384: IF G_DEBUG = 'Y' THEN
1385: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after default_unchanged_attributes / default_missing_attributes' );
1386: END IF;
1387:
1388: -- Perform cross attribute validation and missing attribute checks (Record level validation)
1389: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

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

1408: END LOOP;
1409: --END IF;
1410:
1411: IF G_DEBUG = 'Y' THEN
1412: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_record' );
1413: END IF;
1414:
1415: IF G_DEBUG='Y' THEN
1416: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');

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

1412: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_record' );
1413: END IF;
1414:
1415: IF G_DEBUG='Y' THEN
1416: AHL_DEBUG_PUB.debug( 'Starting updating parent route/operation');
1417: END IF;
1418:
1419: IF ( p_association_type_code = 'OPERATION')
1420: THEN

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

1418:
1419: IF ( p_association_type_code = 'OPERATION')
1420: THEN
1421: IF G_DEBUG='Y' THEN
1422: AHL_DEBUG_PUB.debug( 'p_association_type_code = OPERATION');
1423: END IF;
1424:
1425: AHL_RM_ROUTE_UTIL.validate_operation_status
1426: (

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

1449:
1450: ELSIF ( p_association_type_code = 'ROUTE')
1451: THEN
1452: IF G_DEBUG='Y' THEN
1453: AHL_DEBUG_PUB.debug( 'p_association_type_code = ROUTE');
1454: END IF;
1455: -- Check if the Route is existing and in Draft status
1456: AHL_RM_ROUTE_UTIL.validate_route_status
1457: (

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

1670: END IF;
1671: END LOOP;
1672:
1673: IF G_DEBUG = 'Y' THEN
1674: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after DML operation' );
1675: END IF;
1676:
1677: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1678: l_msg_count := FND_MSG_PUB.count_msg;

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

1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: END IF;
1698:
1699: IF G_DEBUG = 'Y' THEN
1700: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME1 || ' : after validate_records' );
1701: END IF;
1702:
1703: -- Bug # 7644260 (FP for ER # 6998882) -- start
1704: OPEN get_min_sch_seq( p_object_id, p_association_type_code );

Line 1731: AHL_DEBUG_PUB.disable_debug;

1727: );
1728:
1729: -- Disable debug (if enabled)
1730: IF G_DEBUG = 'Y' THEN
1731: AHL_DEBUG_PUB.disable_debug;
1732: END IF;
1733: EXCEPTION
1734: WHEN FND_API.G_EXC_ERROR THEN
1735: ROLLBACK TO process_rt_oper_resource_PVT;

Line 1746: AHL_DEBUG_PUB.disable_debug;

1742: );
1743:
1744: -- Disable debug (if enabled)
1745: IF G_DEBUG = 'Y' THEN
1746: AHL_DEBUG_PUB.disable_debug;
1747: END IF;
1748:
1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: ROLLBACK TO process_rt_oper_resource_PVT;

Line 1761: AHL_DEBUG_PUB.disable_debug;

1757: );
1758:
1759: -- Disable debug (if enabled)
1760: IF G_DEBUG = 'Y' THEN
1761: AHL_DEBUG_PUB.disable_debug;
1762: END IF;
1763:
1764: WHEN OTHERS THEN
1765: ROLLBACK TO process_rt_oper_resource_PVT;

Line 1785: AHL_DEBUG_PUB.disable_debug;

1781: );
1782:
1783: -- Disable debug (if enabled)
1784: IF G_DEBUG = 'Y' THEN
1785: AHL_DEBUG_PUB.disable_debug;
1786: END IF;
1787:
1788: END process_rt_oper_resource;
1789:

Line 2180: AHL_DEBUG_PUB.enable_debug;

2176: FND_MSG_PUB.initialize;
2177: END IF;
2178:
2179: IF G_DEBUG = 'Y' THEN
2180: AHL_DEBUG_PUB.enable_debug;
2181: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.'||l_api_name||': Begin API' );
2182: END IF;
2183:
2184:

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

2177: END IF;
2178:
2179: IF G_DEBUG = 'Y' THEN
2180: AHL_DEBUG_PUB.enable_debug;
2181: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.'||l_api_name||': Begin API' );
2182: END IF;
2183:
2184:
2185: -- Convert Values into Ids.

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

2199: END IF;
2200: --END IF;
2201:
2202: IF G_DEBUG = 'Y' THEN
2203: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after convert_costing_values_to_ids' );
2204: END IF;
2205:
2206: OPEN get_object_rec ( p_x_rt_oper_cost_rec.RT_OPER_RESOURCE_ID ) ;
2207: FETCH get_object_rec INTO

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

2280: p_x_rt_oper_cost_rec -- IN OUT
2281: );
2282:
2283: IF G_DEBUG = 'Y' THEN
2284: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_costing_unchanged' );
2285: END IF;
2286:
2287: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2288: l_msg_count := FND_MSG_PUB.count_msg;

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

2309: --to change the status of Approval rejected Routes/perations to Draft if costing parameters are updated.
2310: IF ( l_association_type_code = 'OPERATION')
2311: THEN
2312: IF G_DEBUG='Y' THEN
2313: AHL_DEBUG_PUB.debug( 'l_association_type_code = OPERATION');
2314: END IF;
2315:
2316: -- Check if the Route is existing and in Draft status
2317: AHL_RM_ROUTE_UTIL.validate_operation_status

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

2342:
2343: ELSIF ( l_association_type_code = 'ROUTE')
2344: THEN
2345: IF G_DEBUG='Y' THEN
2346: AHL_DEBUG_PUB.debug( 'l_association_type_code = ROUTE');
2347: END IF;
2348:
2349: AHL_RM_ROUTE_UTIL.validate_ApplnUsage
2350: (

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

2419: -- Set OUT values
2420: p_x_rt_oper_cost_rec.object_version_number := p_x_rt_oper_cost_rec.object_version_number + 1;
2421:
2422: IF G_DEBUG = 'Y' THEN
2423: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after DML operation' );
2424: END IF;
2425:
2426: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2427: l_msg_count := FND_MSG_PUB.count_msg;

Line 2448: AHL_DEBUG_PUB.disable_debug;

2444: );
2445:
2446: -- Disable debug (if enabled)
2447: IF G_DEBUG = 'Y' THEN
2448: AHL_DEBUG_PUB.disable_debug;
2449: END IF;
2450:
2451: EXCEPTION
2452: WHEN FND_API.G_EXC_ERROR THEN

Line 2464: AHL_DEBUG_PUB.disable_debug;

2460: );
2461:
2462: -- Disable debug (if enabled)
2463: IF G_DEBUG = 'Y' THEN
2464: AHL_DEBUG_PUB.disable_debug;
2465: END IF;
2466:
2467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2468: ROLLBACK TO define_cost_parameter_pvt;

Line 2479: AHL_DEBUG_PUB.disable_debug;

2475: );
2476:
2477: -- Disable debug (if enabled)
2478: IF G_DEBUG = 'Y' THEN
2479: AHL_DEBUG_PUB.disable_debug;
2480: END IF;
2481:
2482: WHEN OTHERS THEN
2483: ROLLBACK TO define_cost_parameter_pvt;

Line 2503: AHL_DEBUG_PUB.disable_debug;

2499: );
2500:
2501: -- Disable debug (if enabled)
2502: IF G_DEBUG = 'Y' THEN
2503: AHL_DEBUG_PUB.disable_debug;
2504: END IF;
2505:
2506: END define_cost_parameter;
2507:

Line 3258: AHL_DEBUG_PUB.enable_debug;

3254: FND_MSG_PUB.initialize;
3255: END IF;
3256:
3257: IF G_DEBUG = 'Y' THEN
3258: AHL_DEBUG_PUB.enable_debug;
3259: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : Begin API' );
3260: END IF;
3261:
3262: -- Validate all the inputs of the API

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

3255: END IF;
3256:
3257: IF G_DEBUG = 'Y' THEN
3258: AHL_DEBUG_PUB.enable_debug;
3259: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : Begin API' );
3260: END IF;
3261:
3262: -- Validate all the inputs of the API
3263: validate_alt_api_inputs

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

3300: END LOOP;
3301: --END IF;
3302:
3303: IF G_DEBUG = 'Y' THEN
3304: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after convert_values_to_ids' );
3305: END IF;
3306:
3307: /* Removing the procedure call as a part of public API cleanup in 11510+
3308: -- Default rt_oper_resource attributes.

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

3318: END IF;
3319: */
3320:
3321: IF G_DEBUG = 'Y' THEN
3322: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after default_attributes' );
3323: END IF;
3324:
3325: -- Validate all attributes (Item level validation)
3326: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

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

3341: END LOOP;
3342: --END IF;
3343:
3344: IF G_DEBUG = 'Y' THEN
3345: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after validate_attributes' );
3346: END IF;
3347:
3348: -- Default missing and unchanged attributes.
3349: FOR i IN 1..p_x_alt_resource_tbl.count LOOP

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

3360: END IF;
3361: END LOOP;
3362:
3363: IF G_DEBUG = 'Y' THEN
3364: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after default_unchanged_attributes / default_missing_attributes' );
3365: END IF;
3366:
3367: -- Perform cross attribute validation and missing attribute checks (Record level validation)
3368: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

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

3386: END LOOP;
3387: --END IF;
3388:
3389: IF G_DEBUG = 'Y' THEN
3390: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after validate_record' );
3391: END IF;
3392:
3393: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
3394: l_msg_count := FND_MSG_PUB.count_msg;

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

3558: END IF;
3559: END LOOP;
3560:
3561: IF G_DEBUG = 'Y' THEN
3562: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after DML operation' );
3563: END IF;
3564:
3565: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
3566: l_msg_count := FND_MSG_PUB.count_msg;

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

3583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3584: END IF;
3585:
3586: IF G_DEBUG = 'Y' THEN
3587: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME3 || ' : after validate_records' );
3588: END IF;
3589:
3590: -- Perform the Commit (if requested)
3591: IF FND_API.to_boolean( p_commit ) THEN

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: EXCEPTION
3609: WHEN FND_API.G_EXC_ERROR THEN

Line 3621: AHL_DEBUG_PUB.disable_debug;

3617: );
3618:
3619: -- Disable debug (if enabled)
3620: IF G_DEBUG = 'Y' THEN
3621: AHL_DEBUG_PUB.disable_debug;
3622: END IF;
3623:
3624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3625: ROLLBACK TO PROCESS_ALTERNATE_RESOURCE_PVT;

Line 3636: AHL_DEBUG_PUB.disable_debug;

3632: );
3633:
3634: -- Disable debug (if enabled)
3635: IF G_DEBUG = 'Y' THEN
3636: AHL_DEBUG_PUB.disable_debug;
3637: END IF;
3638:
3639: WHEN OTHERS THEN
3640: ROLLBACK TO PROCESS_ALTERNATE_RESOURCE_PVT;

Line 3660: AHL_DEBUG_PUB.disable_debug;

3656: );
3657:
3658: -- Disable debug (if enabled)
3659: IF G_DEBUG = 'Y' THEN
3660: AHL_DEBUG_PUB.disable_debug;
3661: END IF;
3662:
3663: END PROCESS_ALTERNATE_RESOURCE;
3664: