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_ROUTE_PVT dependencies on AHL_DEBUG_PUB

Line 5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

1: PACKAGE BODY AHL_RM_ROUTE_PVT AS
2: /* $Header: AHLVROMB.pls 120.4.12010000.4 2008/12/29 14:20:43 bachandr ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_RM_ROUTE_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: -- constants for WHO Columns
8: -- Added by balaji as a part of Public API cleanup
9: G_LAST_UPDATE_DATE DATE := SYSDATE;

Line 2019: AHL_DEBUG_PUB.enable_debug;

2015: END IF;
2016:
2017: -- Enable Debug (optional)
2018: IF ( G_DEBUG = 'Y' ) THEN
2019: AHL_DEBUG_PUB.enable_debug;
2020: END IF;
2021:
2022: IF G_DEBUG = 'Y' THEN
2023: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

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

2019: AHL_DEBUG_PUB.enable_debug;
2020: END IF;
2021:
2022: IF G_DEBUG = 'Y' THEN
2023: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
2024: END IF;
2025:
2026: -- Generate route_id from route_number and revision_number if it is not provided.
2027: IF (p_x_route_rec.dml_operation <> 'C' AND p_x_route_rec.dml_operation <> 'c') AND

Line 2112: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after convert_values_to_ids' );

2108: END IF;
2109: --END IF;
2110:
2111: IF G_DEBUG = 'Y' THEN
2112: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after convert_values_to_ids' );
2113: END IF;
2114:
2115: /* Balaji removed it as a part of public API cleanup as this defaulting logic should not be bound by p_default value. Instead the logic is moved to DML.
2116: -- Default route attributes.

Line 2126: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_attributes' );

2122: END IF;
2123: */
2124:
2125: IF G_DEBUG = 'Y' THEN
2126: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_attributes' );
2127: END IF;
2128:
2129: -- Default missing and unchanged attributes.
2130: IF ( p_x_route_rec.dml_operation = 'U' ) THEN

Line 2143: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_unchanged_attributes / default_missing_attributes' );

2139: );
2140: END IF;
2141:
2142: IF G_DEBUG = 'Y' THEN
2143: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_unchanged_attributes / default_missing_attributes' );
2144: END IF;
2145:
2146: -- Validate all attributes (Item level validation)
2147: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

Line 2164: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_attributes' );

2160: END IF;
2161: --END IF;
2162:
2163: IF G_DEBUG = 'Y' THEN
2164: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_attributes' );
2165: END IF;
2166:
2167: -- Perform cross attribute validation and missing attribute checks (Record level validation)
2168: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

Line 2185: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_record' );

2181: END IF;
2182: --END IF;
2183:
2184: IF G_DEBUG = 'Y' THEN
2185: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_record' );
2186: END IF;
2187:
2188: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2189: l_msg_count := FND_MSG_PUB.count_msg;

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

2423: CLOSE get_concat_segs;
2424: --amsriniv. End
2425:
2426: IF G_DEBUG = 'Y' THEN
2427: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after DML operation' );
2428: END IF;
2429:
2430: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2431: l_msg_count := FND_MSG_PUB.count_msg;

Line 2452: AHL_DEBUG_PUB.disable_debug;

2448: );
2449:
2450: -- Disable debug (if enabled)
2451: IF ( G_DEBUG = 'Y' ) THEN
2452: AHL_DEBUG_PUB.disable_debug;
2453: END IF;
2454:
2455: EXCEPTION
2456:

Line 2469: AHL_DEBUG_PUB.disable_debug;

2465: );
2466:
2467: -- Disable debug (if enabled)
2468: IF ( G_DEBUG = 'Y' ) THEN
2469: AHL_DEBUG_PUB.disable_debug;
2470: END IF;
2471:
2472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2473: ROLLBACK TO process_route_PVT;

Line 2484: AHL_DEBUG_PUB.disable_debug;

2480: );
2481:
2482: -- Disable debug (if enabled)
2483: IF ( G_DEBUG = 'Y' ) THEN
2484: AHL_DEBUG_PUB.disable_debug;
2485: END IF;
2486:
2487: WHEN OTHERS THEN
2488: ROLLBACK TO process_route_PVT;

Line 2508: AHL_DEBUG_PUB.disable_debug;

2504: );
2505:
2506: -- Disable debug (if enabled)
2507: IF ( G_DEBUG = 'Y' ) THEN
2508: AHL_DEBUG_PUB.disable_debug;
2509: END IF;
2510:
2511: END process_route;
2512:

Line 2589: AHL_DEBUG_PUB.enable_debug;

2585: END IF;
2586:
2587: -- Enable Debug (optional)
2588: IF ( G_DEBUG = 'Y' ) THEN
2589: AHL_DEBUG_PUB.enable_debug;
2590: END IF;
2591:
2592: IF G_DEBUG = 'Y' THEN
2593: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

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

2589: AHL_DEBUG_PUB.enable_debug;
2590: END IF;
2591:
2592: IF G_DEBUG = 'Y' THEN
2593: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
2594: END IF;
2595:
2596: --This is to be added before calling AHL_RM_ROUTE_UTIL.validate_route_status
2597: -- Validate Application Usage

Line 2670: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting AHL_ROUTES_B and AHL_ROUTES_TL' );

2666: END IF;
2667:
2668:
2669: IF G_DEBUG = 'Y' THEN
2670: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting AHL_ROUTES_B and AHL_ROUTES_TL' );
2671: END IF;
2672:
2673: -- Delete all the associations
2674:

Line 2686: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Effectivities' );

2682: NULL;
2683: END IF;
2684:
2685: IF G_DEBUG = 'Y' THEN
2686: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Effectivities' );
2687: END IF;
2688:
2689: -- 1.Delete Material Requirements
2690: DELETE AHL_RT_OPER_MATERIALS

Line 2701: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );

2697: NULL;
2698: END IF;
2699:
2700: IF G_DEBUG = 'Y' THEN
2701: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );
2702: END IF;
2703:
2704: -- 2.Delete Resource Requirements
2705: DELETE AHL_RT_OPER_RESOURCES

Line 2716: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Resource Requirements' );

2712: NULL;
2713: END IF;
2714:
2715: IF G_DEBUG = 'Y' THEN
2716: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Resource Requirements' );
2717: END IF;
2718:
2719: -- 3.Delete Reference Documents
2720: FOR I in get_doc_associations( p_route_id ) LOOP

Line 2728: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );

2724: );
2725: END LOOP;
2726:
2727: IF G_DEBUG = 'Y' THEN
2728: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );
2729: END IF;
2730:
2731: -- 4.Delete Associated Operations
2732: DELETE AHL_ROUTE_OPERATIONS

Line 2753: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Access Panels' );

2749: NULL;
2750: END IF;
2751:
2752: IF G_DEBUG = 'Y' THEN
2753: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Access Panels' );
2754: END IF;
2755:
2756: BEGIN
2757: -- Delete the record in AHL_ROUTES_B and AHL_ROUTES_TL

Line 2773: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Associated Operations' );

2769: RAISE;
2770: END;
2771:
2772: IF G_DEBUG = 'Y' THEN
2773: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Associated Operations' );
2774: END IF;
2775:
2776: -- Perform the Commit (if requested)
2777: IF FND_API.to_boolean( p_commit ) THEN

Line 2791: AHL_DEBUG_PUB.disable_debug;

2787: );
2788:
2789: -- Disable debug (if enabled)
2790: IF ( G_DEBUG = 'Y' ) THEN
2791: AHL_DEBUG_PUB.disable_debug;
2792: END IF;
2793:
2794: EXCEPTION
2795:

Line 2808: AHL_DEBUG_PUB.disable_debug;

2804: );
2805:
2806: -- Disable debug (if enabled)
2807: IF ( G_DEBUG = 'Y' ) THEN
2808: AHL_DEBUG_PUB.disable_debug;
2809: END IF;
2810:
2811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2812: ROLLBACK TO delete_route_PVT;

Line 2823: AHL_DEBUG_PUB.disable_debug;

2819: );
2820:
2821: -- Disable debug (if enabled)
2822: IF ( G_DEBUG = 'Y' ) THEN
2823: AHL_DEBUG_PUB.disable_debug;
2824: END IF;
2825:
2826: WHEN OTHERS THEN
2827: ROLLBACK TO delete_route_PVT;

Line 2847: AHL_DEBUG_PUB.disable_debug;

2843: );
2844:
2845: -- Disable debug (if enabled)
2846: IF ( G_DEBUG = 'Y' ) THEN
2847: AHL_DEBUG_PUB.disable_debug;
2848: END IF;
2849:
2850: END delete_route;
2851:

Line 3019: AHL_DEBUG_PUB.enable_debug;

3015: END IF;
3016:
3017: -- Enable Debug (optional)
3018: IF ( G_DEBUG = 'Y' ) THEN
3019: AHL_DEBUG_PUB.enable_debug;
3020: END IF;
3021:
3022: IF ( G_DEBUG = 'Y' ) THEN
3023: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

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

3019: AHL_DEBUG_PUB.enable_debug;
3020: END IF;
3021:
3022: IF ( G_DEBUG = 'Y' ) THEN
3023: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
3024: END IF;
3025:
3026: --This is to be added before calling get_route_record()
3027: -- Validate Application Usage

Line 3767: AHL_DEBUG_PUB.disable_debug;

3763: );
3764:
3765: -- Disable debug (if enabled)
3766: IF ( G_DEBUG = 'Y' ) THEN
3767: AHL_DEBUG_PUB.disable_debug;
3768: END IF;
3769:
3770: EXCEPTION
3771:

Line 3784: AHL_DEBUG_PUB.disable_debug;

3780: );
3781:
3782: -- Disable debug (if enabled)
3783: IF ( G_DEBUG = 'Y' ) THEN
3784: AHL_DEBUG_PUB.disable_debug;
3785: END IF;
3786:
3787: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3788: ROLLBACK TO create_route_revision_PVT;

Line 3799: AHL_DEBUG_PUB.disable_debug;

3795: );
3796:
3797: -- Disable debug (if enabled)
3798: IF ( G_DEBUG = 'Y' ) THEN
3799: AHL_DEBUG_PUB.disable_debug;
3800: END IF;
3801:
3802: WHEN OTHERS THEN
3803: ROLLBACK TO create_route_revision_PVT;

Line 3823: AHL_DEBUG_PUB.disable_debug;

3819: );
3820:
3821: -- Disable debug (if enabled)
3822: IF ( G_DEBUG = 'Y' ) THEN
3823: AHL_DEBUG_PUB.disable_debug;
3824: END IF;
3825:
3826: END create_route_revision;
3827: END AHL_RM_ROUTE_PVT;