DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_DEBUG_PUB

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

1: PACKAGE BODY AHL_LTP_REQST_MATRL_PVT AS
2: /* $Header: AHLVRMTB.pls 120.27.12020000.2 2012/12/07 13:37:52 sareepar ship $ */
3: --
4: G_PKG_NAME VARCHAR2(30) := 'AHL_LTP_REQST_MATRL_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: ------------------------------------
8: -- Common constants and variables --
9: ------------------------------------

Line 2162: AHL_DEBUG_PUB.enable_debug;

2158: -- Standard Start of API savepoint
2159: SAVEPOINT Unschedule_Task_Items;
2160: -- Check if API is called in debug mode. If yes, enable debug.
2161: IF G_DEBUG='Y' THEN
2162: AHL_DEBUG_PUB.enable_debug;
2163: END IF;
2164: -- Debug info.
2165: IF G_DEBUG='Y' THEN
2166: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');

Line 2166: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');

2162: AHL_DEBUG_PUB.enable_debug;
2163: END IF;
2164: -- Debug info.
2165: IF G_DEBUG='Y' THEN
2166: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');
2167: END IF;
2168: -- Standard call to check for call compatibility.
2169: IF FND_API.to_boolean(p_init_msg_list)
2170: THEN

Line 2227: Ahl_Debug_Pub.debug( 'End of private api Unschedule Task Items ','+MAMRP+');

2223: COMMIT;
2224: END IF;
2225: -- Debug info
2226: IF G_DEBUG='Y' THEN
2227: Ahl_Debug_Pub.debug( 'End of private api Unschedule Task Items ','+MAMRP+');
2228: -- Check if API is called in debug mode. If yes, disable debug.
2229: Ahl_Debug_Pub.disable_debug;
2230: --
2231: END IF;

Line 2229: Ahl_Debug_Pub.disable_debug;

2225: -- Debug info
2226: IF G_DEBUG='Y' THEN
2227: Ahl_Debug_Pub.debug( 'End of private api Unschedule Task Items ','+MAMRP+');
2228: -- Check if API is called in debug mode. If yes, disable debug.
2229: Ahl_Debug_Pub.disable_debug;
2230: --
2231: END IF;
2232: EXCEPTION
2233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2241: AHL_DEBUG_PUB.log_app_messages (

2237: p_count => x_msg_count,
2238: p_data => x_msg_data);
2239: IF G_DEBUG='Y' THEN
2240:
2241: AHL_DEBUG_PUB.log_app_messages (
2242: x_msg_count, x_msg_data, 'ERROR' );
2243: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');
2244: -- Check if API is called in debug mode. If yes, disable debug.
2245: AHL_DEBUG_PUB.disable_debug;

Line 2243: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');

2239: IF G_DEBUG='Y' THEN
2240:
2241: AHL_DEBUG_PUB.log_app_messages (
2242: x_msg_count, x_msg_data, 'ERROR' );
2243: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');
2244: -- Check if API is called in debug mode. If yes, disable debug.
2245: AHL_DEBUG_PUB.disable_debug;
2246: END IF;
2247:

Line 2245: AHL_DEBUG_PUB.disable_debug;

2241: AHL_DEBUG_PUB.log_app_messages (
2242: x_msg_count, x_msg_data, 'ERROR' );
2243: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');
2244: -- Check if API is called in debug mode. If yes, disable debug.
2245: AHL_DEBUG_PUB.disable_debug;
2246: END IF;
2247:
2248: WHEN FND_API.G_EXC_ERROR THEN
2249: ROLLBACK TO search_schedule_materials;

Line 2257: AHL_DEBUG_PUB.log_app_messages (

2253: p_data => X_msg_data);
2254: IF G_DEBUG='Y' THEN
2255:
2256: -- Debug info.
2257: AHL_DEBUG_PUB.log_app_messages (
2258: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2259: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');
2260: -- Check if API is called in debug mode. If yes, disable debug.
2261: AHL_DEBUG_PUB.disable_debug;

Line 2259: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');

2255:
2256: -- Debug info.
2257: AHL_DEBUG_PUB.log_app_messages (
2258: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2259: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');
2260: -- Check if API is called in debug mode. If yes, disable debug.
2261: AHL_DEBUG_PUB.disable_debug;
2262: END IF;
2263:

Line 2261: AHL_DEBUG_PUB.disable_debug;

2257: AHL_DEBUG_PUB.log_app_messages (
2258: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2259: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');
2260: -- Check if API is called in debug mode. If yes, disable debug.
2261: AHL_DEBUG_PUB.disable_debug;
2262: END IF;
2263:
2264: WHEN OTHERS THEN
2265: ROLLBACK TO Unschedule_Task_Items;

Line 2279: AHL_DEBUG_PUB.log_app_messages (

2275: p_data => X_msg_data);
2276: IF G_DEBUG='Y' THEN
2277:
2278: -- Debug info.
2279: AHL_DEBUG_PUB.log_app_messages (
2280: x_msg_count, x_msg_data, 'SQL ERROR' );
2281: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');
2282: -- Check if API is called in debug mode. If yes, disable debug.
2283: AHL_DEBUG_PUB.disable_debug;

Line 2281: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');

2277:
2278: -- Debug info.
2279: AHL_DEBUG_PUB.log_app_messages (
2280: x_msg_count, x_msg_data, 'SQL ERROR' );
2281: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');
2282: -- Check if API is called in debug mode. If yes, disable debug.
2283: AHL_DEBUG_PUB.disable_debug;
2284: END IF;
2285:

Line 2283: AHL_DEBUG_PUB.disable_debug;

2279: AHL_DEBUG_PUB.log_app_messages (
2280: x_msg_count, x_msg_data, 'SQL ERROR' );
2281: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');
2282: -- Check if API is called in debug mode. If yes, disable debug.
2283: AHL_DEBUG_PUB.disable_debug;
2284: END IF;
2285:
2286: END Unschedule_visit_Task_Items;
2287: --