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.15.12020000.2 2012/12/07 13:42:21 sareepar 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 2255: AHL_DEBUG_PUB.enable_debug;

2251: END IF;
2252:
2253: -- Enable Debug (optional)
2254: IF ( G_DEBUG = 'Y' ) THEN
2255: AHL_DEBUG_PUB.enable_debug;
2256: END IF;
2257:
2258: IF G_DEBUG = 'Y' THEN
2259: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

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

2255: AHL_DEBUG_PUB.enable_debug;
2256: END IF;
2257:
2258: IF G_DEBUG = 'Y' THEN
2259: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
2260: END IF;
2261:
2262: -- pekambar added for bug # 9957794
2263: -- enigma_route_id attribute is used to differentiate the Routes created through Enigma revision report

Line 2272: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : pekambar :: enigma_route_id ' || p_x_route_rec.enigma_route_id );

2268: p_x_route_rec.enigma_route_id := NULL ;
2269: END IF;
2270:
2271: IF G_DEBUG = 'Y' THEN
2272: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : pekambar :: enigma_route_id ' || p_x_route_rec.enigma_route_id );
2273: END IF;
2274:
2275: --Enigma Phase II changes start
2276: --Dervie the enigma route source for manual routes depending on the enigma doc id.

Line 2308: AHL_DEBUG_PUB.debug('DML : N ' || ' ' || p_x_route_rec.enigma_source_code );

2304: --dml_operation ='NC' is added in Enigma Phase II.Since we have dml_operation as VARCHAR2(1),
2305: --the public wrapper AHL_ENIGMA_ROUTE_OP_PUB.Process_Route_Details passes dml_operation as 'N'.
2306: IF (p_x_route_rec.dml_operation = 'N') THEN
2307: IF G_DEBUG = 'Y' THEN
2308: AHL_DEBUG_PUB.debug('DML : N ' || ' ' || p_x_route_rec.enigma_source_code );
2309: END IF;
2310: IF(p_x_route_rec.enigma_source_code = 'AUTOMATIC') THEN
2311: UPDATE ahl_routes_b
2312: set file_id = p_x_route_rec.file_id

Line 2322: AHL_DEBUG_PUB.debug('After derivation ' || p_x_route_rec.enigma_doc_id || ' ' || p_x_route_rec.enigma_source_code );

2318: RETURN ;
2319: END IF;
2320: --End Enigma Phase II changes
2321: IF G_DEBUG = 'Y' THEN
2322: AHL_DEBUG_PUB.debug('After derivation ' || p_x_route_rec.enigma_doc_id || ' ' || p_x_route_rec.enigma_source_code );
2323: END IF;
2324: -- Enigma Phase II changes End
2325: -- Generate route_id from route_number and revision_number if it is not provided.
2326: IF (p_x_route_rec.dml_operation <> 'C' AND p_x_route_rec.dml_operation <> 'c') AND

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

2407: END IF;
2408: --END IF;
2409:
2410: IF G_DEBUG = 'Y' THEN
2411: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after convert_values_to_ids' );
2412: END IF;
2413:
2414: /* 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.
2415: -- Default route attributes.

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

2421: END IF;
2422: */
2423:
2424: IF G_DEBUG = 'Y' THEN
2425: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_attributes' );
2426: END IF;
2427:
2428: -- Default missing and unchanged attributes.
2429: IF ( p_x_route_rec.dml_operation = 'U' ) THEN

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

2439: );
2440: END IF;
2441:
2442: IF G_DEBUG = 'Y' THEN
2443: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after default_unchanged_attributes / default_missing_attributes' );
2444: END IF;
2445:
2446: -- Validate all attributes (Item level validation)
2447: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

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

2460: END IF;
2461: --END IF;
2462:
2463: IF G_DEBUG = 'Y' THEN
2464: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_attributes' );
2465: END IF;
2466:
2467: -- Perform cross attribute validation and missing attribute checks (Record level validation)
2468: -- Balaji removed p_validation_level check in 11510+ as a part of public api cleanup.

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

2481: END IF;
2482: --END IF;
2483:
2484: IF G_DEBUG = 'Y' THEN
2485: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after validate_record' );
2486: END IF;
2487:
2488: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2489: l_msg_count := FND_MSG_PUB.count_msg;

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

2742: CLOSE get_concat_segs;
2743: --amsriniv. End
2744:
2745: IF G_DEBUG = 'Y' THEN
2746: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after DML operation' );
2747: END IF;
2748:
2749: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2750: l_msg_count := FND_MSG_PUB.count_msg;

Line 2771: AHL_DEBUG_PUB.disable_debug;

2767: );
2768:
2769: -- Disable debug (if enabled)
2770: IF ( G_DEBUG = 'Y' ) THEN
2771: AHL_DEBUG_PUB.disable_debug;
2772: END IF;
2773:
2774: EXCEPTION
2775:

Line 2788: AHL_DEBUG_PUB.disable_debug;

2784: );
2785:
2786: -- Disable debug (if enabled)
2787: IF ( G_DEBUG = 'Y' ) THEN
2788: AHL_DEBUG_PUB.disable_debug;
2789: END IF;
2790:
2791: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2792: ROLLBACK TO process_route_PVT;

Line 2803: AHL_DEBUG_PUB.disable_debug;

2799: );
2800:
2801: -- Disable debug (if enabled)
2802: IF ( G_DEBUG = 'Y' ) THEN
2803: AHL_DEBUG_PUB.disable_debug;
2804: END IF;
2805:
2806: WHEN OTHERS THEN
2807: ROLLBACK TO process_route_PVT;

Line 2827: AHL_DEBUG_PUB.disable_debug;

2823: );
2824:
2825: -- Disable debug (if enabled)
2826: IF ( G_DEBUG = 'Y' ) THEN
2827: AHL_DEBUG_PUB.disable_debug;
2828: END IF;
2829:
2830: END process_route;
2831:

Line 2910: AHL_DEBUG_PUB.enable_debug;

2906: END IF;
2907:
2908: -- Enable Debug (optional)
2909: IF ( G_DEBUG = 'Y' ) THEN
2910: AHL_DEBUG_PUB.enable_debug;
2911: END IF;
2912:
2913: IF G_DEBUG = 'Y' THEN
2914: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

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

2910: AHL_DEBUG_PUB.enable_debug;
2911: END IF;
2912:
2913: IF G_DEBUG = 'Y' THEN
2914: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
2915: END IF;
2916:
2917: --This is to be added before calling AHL_RM_ROUTE_UTIL.validate_route_status
2918: -- Validate Application Usage

Line 2964: AHL_DEBUG_PUB.debug( 'Enigma Route Id ' || l_enigma_route_id );

2960: IF (p_module_type <> 'BPEL' ) THEN
2961: OPEN get_enigma_route_id;
2962: FETCH get_enigma_route_id INTO l_enigma_route_id;
2963: IF G_DEBUG = 'Y' THEN
2964: AHL_DEBUG_PUB.debug( 'Enigma Route Id ' || l_enigma_route_id );
2965: END IF;
2966: IF (get_enigma_route_id%FOUND AND l_enigma_route_id IS NOT NULL)
2967: THEN
2968: IF G_DEBUG = 'Y' THEN

Line 2969: AHL_DEBUG_PUB.debug( 'Enigma Route Id IS NOT NULL');

2965: END IF;
2966: IF (get_enigma_route_id%FOUND AND l_enigma_route_id IS NOT NULL)
2967: THEN
2968: IF G_DEBUG = 'Y' THEN
2969: AHL_DEBUG_PUB.debug( 'Enigma Route Id IS NOT NULL');
2970: END IF;
2971: FND_MESSAGE.set_name('AHL', 'AHL_RM_ROUTE_ENIG_DEL');
2972: FND_MSG_PUB.add;
2973: x_return_status := FND_API.G_RET_STS_ERROR;

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

2997: END IF;
2998:
2999:
3000: IF G_DEBUG = 'Y' THEN
3001: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting AHL_ROUTES_B and AHL_ROUTES_TL' );
3002: END IF;
3003:
3004: -- Delete all the associations
3005:

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

3013: NULL;
3014: END IF;
3015:
3016: IF G_DEBUG = 'Y' THEN
3017: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Effectivities' );
3018: END IF;
3019:
3020: -- 1.Delete Material Requirements
3021: DELETE AHL_RT_OPER_MATERIALS

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

3028: NULL;
3029: END IF;
3030:
3031: IF G_DEBUG = 'Y' THEN
3032: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Material Requirements' );
3033: END IF;
3034:
3035: -- 2.Delete Resource Requirements
3036: DELETE AHL_RT_OPER_RESOURCES

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

3043: NULL;
3044: END IF;
3045:
3046: IF G_DEBUG = 'Y' THEN
3047: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Resource Requirements' );
3048: END IF;
3049:
3050: -- 3.Delete Reference Documents
3051: FOR I in get_doc_associations( p_route_id ) LOOP

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

3055: );
3056: END LOOP;
3057:
3058: IF G_DEBUG = 'Y' THEN
3059: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Reference Documents' );
3060: END IF;
3061:
3062: -- 4.Delete Associated Operations
3063: DELETE AHL_ROUTE_OPERATIONS

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

3080: NULL;
3081: END IF;
3082:
3083: IF G_DEBUG = 'Y' THEN
3084: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Access Panels' );
3085: END IF;
3086:
3087: BEGIN
3088: -- Delete the record in AHL_ROUTES_B and AHL_ROUTES_TL

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

3100: RAISE;
3101: END;
3102:
3103: IF G_DEBUG = 'Y' THEN
3104: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : after Deleting Associated Operations' );
3105: END IF;
3106:
3107: -- Perform the Commit (if requested)
3108: IF FND_API.to_boolean( p_commit ) THEN

Line 3122: AHL_DEBUG_PUB.disable_debug;

3118: );
3119:
3120: -- Disable debug (if enabled)
3121: IF ( G_DEBUG = 'Y' ) THEN
3122: AHL_DEBUG_PUB.disable_debug;
3123: END IF;
3124:
3125: EXCEPTION
3126:

Line 3139: AHL_DEBUG_PUB.disable_debug;

3135: );
3136:
3137: -- Disable debug (if enabled)
3138: IF ( G_DEBUG = 'Y' ) THEN
3139: AHL_DEBUG_PUB.disable_debug;
3140: END IF;
3141:
3142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3143: ROLLBACK TO delete_route_PVT;

Line 3154: AHL_DEBUG_PUB.disable_debug;

3150: );
3151:
3152: -- Disable debug (if enabled)
3153: IF ( G_DEBUG = 'Y' ) THEN
3154: AHL_DEBUG_PUB.disable_debug;
3155: END IF;
3156:
3157: WHEN OTHERS THEN
3158: ROLLBACK TO delete_route_PVT;

Line 3178: AHL_DEBUG_PUB.disable_debug;

3174: );
3175:
3176: -- Disable debug (if enabled)
3177: IF ( G_DEBUG = 'Y' ) THEN
3178: AHL_DEBUG_PUB.disable_debug;
3179: END IF;
3180:
3181: END delete_route;
3182:

Line 3427: AHL_DEBUG_PUB.enable_debug;

3423: END IF;
3424:
3425: -- Enable Debug (optional)
3426: IF ( G_DEBUG = 'Y' ) THEN
3427: AHL_DEBUG_PUB.enable_debug;
3428: END IF;
3429:
3430: IF ( G_DEBUG = 'Y' ) THEN
3431: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );

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

3427: AHL_DEBUG_PUB.enable_debug;
3428: END IF;
3429:
3430: IF ( G_DEBUG = 'Y' ) THEN
3431: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Begin API' );
3432: END IF;
3433:
3434: --This is to be added before calling get_route_record()
3435: -- Validate Application Usage

Line 4332: AHL_DEBUG_PUB.disable_debug;

4328: );
4329:
4330: -- Disable debug (if enabled)
4331: IF ( G_DEBUG = 'Y' ) THEN
4332: AHL_DEBUG_PUB.disable_debug;
4333: END IF;
4334:
4335: EXCEPTION
4336:

Line 4349: AHL_DEBUG_PUB.disable_debug;

4345: );
4346:
4347: -- Disable debug (if enabled)
4348: IF ( G_DEBUG = 'Y' ) THEN
4349: AHL_DEBUG_PUB.disable_debug;
4350: END IF;
4351:
4352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4353: ROLLBACK TO create_route_revision_PVT;

Line 4364: AHL_DEBUG_PUB.disable_debug;

4360: );
4361:
4362: -- Disable debug (if enabled)
4363: IF ( G_DEBUG = 'Y' ) THEN
4364: AHL_DEBUG_PUB.disable_debug;
4365: END IF;
4366:
4367: WHEN OTHERS THEN
4368: ROLLBACK TO create_route_revision_PVT;

Line 4388: AHL_DEBUG_PUB.disable_debug;

4384: );
4385:
4386: -- Disable debug (if enabled)
4387: IF ( G_DEBUG = 'Y' ) THEN
4388: AHL_DEBUG_PUB.disable_debug;
4389: END IF;
4390:
4391: END create_route_revision;
4392: END AHL_RM_ROUTE_PVT;