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_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.22 2008/03/20 10:30:07 rnahata 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 79: AHL_DEBUG_PUB.enable_debug;

75: -- Standard Start of API savepoint
76: SAVEPOINT unschedule_visit;
77: -- Check if API is called in debug mode. If yes, enable debug.
78: IF G_DEBUG='Y' THEN
79: AHL_DEBUG_PUB.enable_debug;
80: END IF;
81: -- Debug info.
82: IF G_DEBUG='Y' THEN
83: AHL_DEBUG_PUB.debug( 'enter AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');

Line 83: AHL_DEBUG_PUB.debug( 'enter AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');

79: AHL_DEBUG_PUB.enable_debug;
80: END IF;
81: -- Debug info.
82: IF G_DEBUG='Y' THEN
83: AHL_DEBUG_PUB.debug( 'enter AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
84: END IF;
85: -- Standard call to check for call compatibility.
86: IF FND_API.to_boolean(p_init_msg_list)
87: THEN

Line 159: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );

155: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
156: p_count => x_msg_count,
157: p_data => x_msg_data);
158: IF G_DEBUG='Y' THEN
159: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
160: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
161: -- Check if API is called in debug mode. If yes, disable debug.
162: AHL_DEBUG_PUB.disable_debug;
163: END IF;

Line 160: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');

156: p_count => x_msg_count,
157: p_data => x_msg_data);
158: IF G_DEBUG='Y' THEN
159: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
160: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
161: -- Check if API is called in debug mode. If yes, disable debug.
162: AHL_DEBUG_PUB.disable_debug;
163: END IF;
164: WHEN FND_API.G_EXC_ERROR THEN

Line 162: AHL_DEBUG_PUB.disable_debug;

158: IF G_DEBUG='Y' THEN
159: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data, 'ERROR' );
160: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
161: -- Check if API is called in debug mode. If yes, disable debug.
162: AHL_DEBUG_PUB.disable_debug;
163: END IF;
164: WHEN FND_API.G_EXC_ERROR THEN
165: ROLLBACK TO unschedule_visit;
166: X_return_status := FND_API.G_RET_STS_ERROR;

Line 172: AHL_DEBUG_PUB.log_app_messages (

168: p_count => x_msg_count,
169: p_data => X_msg_data);
170: IF G_DEBUG='Y' THEN
171: -- Debug info.
172: AHL_DEBUG_PUB.log_app_messages (
173: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
174: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
175: -- Check if API is called in debug mode. If yes, disable debug.
176: AHL_DEBUG_PUB.disable_debug;

Line 174: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');

170: IF G_DEBUG='Y' THEN
171: -- Debug info.
172: AHL_DEBUG_PUB.log_app_messages (
173: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
174: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
175: -- Check if API is called in debug mode. If yes, disable debug.
176: AHL_DEBUG_PUB.disable_debug;
177: END IF;
178: WHEN OTHERS THEN

Line 176: AHL_DEBUG_PUB.disable_debug;

172: AHL_DEBUG_PUB.log_app_messages (
173: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
174: AHL_DEBUG_PUB.debug( 'AHL_LTP_REQST_MATRL_PVT.Unschedule_Visit_Materials','+SPANT+');
175: -- Check if API is called in debug mode. If yes, disable debug.
176: AHL_DEBUG_PUB.disable_debug;
177: END IF;
178: WHEN OTHERS THEN
179: ROLLBACK TO unschedule_visit;
180: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 192: AHL_DEBUG_PUB.log_app_messages (

188: p_count => x_msg_count,
189: p_data => X_msg_data);
190: IF G_DEBUG='Y' THEN
191: -- Debug info.
192: AHL_DEBUG_PUB.log_app_messages (
193: x_msg_count, x_msg_data, 'SQL ERROR' );
194: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule_Visit_Materials','+SPANT+');
195: -- Check if API is called in debug mode. If yes, disable debug.
196: AHL_DEBUG_PUB.disable_debug;

Line 194: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule_Visit_Materials','+SPANT+');

190: IF G_DEBUG='Y' THEN
191: -- Debug info.
192: AHL_DEBUG_PUB.log_app_messages (
193: x_msg_count, x_msg_data, 'SQL ERROR' );
194: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule_Visit_Materials','+SPANT+');
195: -- Check if API is called in debug mode. If yes, disable debug.
196: AHL_DEBUG_PUB.disable_debug;
197: END IF;
198: END Unschedule_Visit_Materials;

Line 196: AHL_DEBUG_PUB.disable_debug;

192: AHL_DEBUG_PUB.log_app_messages (
193: x_msg_count, x_msg_data, 'SQL ERROR' );
194: AHL_DEBUG_PUB.debug( 'ahl_ltp_space_assign_pvt.Unschedule_Visit_Materials','+SPANT+');
195: -- Check if API is called in debug mode. If yes, disable debug.
196: AHL_DEBUG_PUB.disable_debug;
197: END IF;
198: END Unschedule_Visit_Materials;
199:
200:

Line 2015: AHL_DEBUG_PUB.enable_debug;

2011: -- Standard Start of API savepoint
2012: SAVEPOINT Unschedule_Task_Items;
2013: -- Check if API is called in debug mode. If yes, enable debug.
2014: IF G_DEBUG='Y' THEN
2015: AHL_DEBUG_PUB.enable_debug;
2016: END IF;
2017: -- Debug info.
2018: IF G_DEBUG='Y' THEN
2019: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');

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

2015: AHL_DEBUG_PUB.enable_debug;
2016: END IF;
2017: -- Debug info.
2018: IF G_DEBUG='Y' THEN
2019: AHL_DEBUG_PUB.debug( 'enter ahl_ltp_reqst_matrl_pvt Unchedule Task Items ','+MAATP+');
2020: END IF;
2021: -- Standard call to check for call compatibility.
2022: IF FND_API.to_boolean(p_init_msg_list)
2023: THEN

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

2076: COMMIT;
2077: END IF;
2078: -- Debug info
2079: IF G_DEBUG='Y' THEN
2080: Ahl_Debug_Pub.debug( 'End of private api Unschedule Task Items ','+MAMRP+');
2081: -- Check if API is called in debug mode. If yes, disable debug.
2082: Ahl_Debug_Pub.disable_debug;
2083: --
2084: END IF;

Line 2082: Ahl_Debug_Pub.disable_debug;

2078: -- Debug info
2079: IF G_DEBUG='Y' THEN
2080: Ahl_Debug_Pub.debug( 'End of private api Unschedule Task Items ','+MAMRP+');
2081: -- Check if API is called in debug mode. If yes, disable debug.
2082: Ahl_Debug_Pub.disable_debug;
2083: --
2084: END IF;
2085: EXCEPTION
2086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2094: AHL_DEBUG_PUB.log_app_messages (

2090: p_count => x_msg_count,
2091: p_data => x_msg_data);
2092: IF G_DEBUG='Y' THEN
2093:
2094: AHL_DEBUG_PUB.log_app_messages (
2095: x_msg_count, x_msg_data, 'ERROR' );
2096: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');
2097: -- Check if API is called in debug mode. If yes, disable debug.
2098: AHL_DEBUG_PUB.disable_debug;

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

2092: IF G_DEBUG='Y' THEN
2093:
2094: AHL_DEBUG_PUB.log_app_messages (
2095: x_msg_count, x_msg_data, 'ERROR' );
2096: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');
2097: -- Check if API is called in debug mode. If yes, disable debug.
2098: AHL_DEBUG_PUB.disable_debug;
2099: END IF;
2100:

Line 2098: AHL_DEBUG_PUB.disable_debug;

2094: AHL_DEBUG_PUB.log_app_messages (
2095: x_msg_count, x_msg_data, 'ERROR' );
2096: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items ','+MAMRP+');
2097: -- Check if API is called in debug mode. If yes, disable debug.
2098: AHL_DEBUG_PUB.disable_debug;
2099: END IF;
2100:
2101: WHEN FND_API.G_EXC_ERROR THEN
2102: ROLLBACK TO search_schedule_materials;

Line 2110: AHL_DEBUG_PUB.log_app_messages (

2106: p_data => X_msg_data);
2107: IF G_DEBUG='Y' THEN
2108:
2109: -- Debug info.
2110: AHL_DEBUG_PUB.log_app_messages (
2111: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2112: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');
2113: -- Check if API is called in debug mode. If yes, disable debug.
2114: AHL_DEBUG_PUB.disable_debug;

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

2108:
2109: -- Debug info.
2110: AHL_DEBUG_PUB.log_app_messages (
2111: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2112: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');
2113: -- Check if API is called in debug mode. If yes, disable debug.
2114: AHL_DEBUG_PUB.disable_debug;
2115: END IF;
2116:

Line 2114: AHL_DEBUG_PUB.disable_debug;

2110: AHL_DEBUG_PUB.log_app_messages (
2111: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
2112: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MAMRP+');
2113: -- Check if API is called in debug mode. If yes, disable debug.
2114: AHL_DEBUG_PUB.disable_debug;
2115: END IF;
2116:
2117: WHEN OTHERS THEN
2118: ROLLBACK TO Unschedule_Task_Items;

Line 2132: AHL_DEBUG_PUB.log_app_messages (

2128: p_data => X_msg_data);
2129: IF G_DEBUG='Y' THEN
2130:
2131: -- Debug info.
2132: AHL_DEBUG_PUB.log_app_messages (
2133: x_msg_count, x_msg_data, 'SQL ERROR' );
2134: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');
2135: -- Check if API is called in debug mode. If yes, disable debug.
2136: AHL_DEBUG_PUB.disable_debug;

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

2130:
2131: -- Debug info.
2132: AHL_DEBUG_PUB.log_app_messages (
2133: x_msg_count, x_msg_data, 'SQL ERROR' );
2134: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');
2135: -- Check if API is called in debug mode. If yes, disable debug.
2136: AHL_DEBUG_PUB.disable_debug;
2137: END IF;
2138:

Line 2136: AHL_DEBUG_PUB.disable_debug;

2132: AHL_DEBUG_PUB.log_app_messages (
2133: x_msg_count, x_msg_data, 'SQL ERROR' );
2134: AHL_DEBUG_PUB.debug( 'ahl_ltp_reqst_matrl_pvt. Unschedule Task Items','+MTMRP+');
2135: -- Check if API is called in debug mode. If yes, disable debug.
2136: AHL_DEBUG_PUB.disable_debug;
2137: END IF;
2138:
2139: END Unschedule_visit_Task_Items;
2140: --