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

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

1: PACKAGE BODY AHL_APPR_SPACE_CAPB_PUB AS
2: /* $Header: AHLPSPCB.pls 115.7 2003/11/04 10:43:08 rroy noship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_APPR_SPACE_CAPB_PUB';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: --
7: -----------------------------------------------------------
8: -- PACKAGE
9: -- AHL_APPR_SPACE_CAPB_PUB

Line 63: AHL_DEBUG_PUB.enable_debug;

59: -- Standard Start of API savepoint
60: SAVEPOINT process_space_capbl;
61: -- Check if API is called in debug mode. If yes, enable debug.
62: IF G_DEBUG='Y' THEN
63: AHL_DEBUG_PUB.enable_debug;
64: END IF;
65: -- Debug info.
66: IF G_DEBUG='Y' THEN
67: AHL_DEBUG_PUB.debug( 'enter ahl_appr_space_capb_pub.Process Space capbl','+SPCBL+');

Line 67: AHL_DEBUG_PUB.debug( 'enter ahl_appr_space_capb_pub.Process Space capbl','+SPCBL+');

63: AHL_DEBUG_PUB.enable_debug;
64: END IF;
65: -- Debug info.
66: IF G_DEBUG='Y' THEN
67: AHL_DEBUG_PUB.debug( 'enter ahl_appr_space_capb_pub.Process Space capbl','+SPCBL+');
68: END IF;
69: -- Standard call to check for call compatibility.
70: IF FND_API.to_boolean(p_init_msg_list)
71: THEN

Line 85: AHL_DEBUG_PUB.debug( 'api start pub');

81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
84: IF G_DEBUG='Y' THEN
85: AHL_DEBUG_PUB.debug( 'api start pub');
86: END IF;
87:
88: --------------------Start of API Body-----------------------------------
89: IF p_x_space_rec.operation_flag = 'C' THEN

Line 134: AHL_DEBUG_PUB.debug( 'inside pub id:'||p_x_space_rec.space_id);

130: --For update
131: ELSIF p_x_space_rec.operation_flag = 'U' THEN
132:
133: IF G_DEBUG='Y' THEN
134: AHL_DEBUG_PUB.debug( 'inside pub id:'||p_x_space_rec.space_id);
135: AHL_DEBUG_PUB.debug( 'inside pub name:'||p_x_space_rec.space_name);
136: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_code);
137: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_mean);
138: END IF;

Line 135: AHL_DEBUG_PUB.debug( 'inside pub name:'||p_x_space_rec.space_name);

131: ELSIF p_x_space_rec.operation_flag = 'U' THEN
132:
133: IF G_DEBUG='Y' THEN
134: AHL_DEBUG_PUB.debug( 'inside pub id:'||p_x_space_rec.space_id);
135: AHL_DEBUG_PUB.debug( 'inside pub name:'||p_x_space_rec.space_name);
136: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_code);
137: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_mean);
138: END IF;
139:

Line 136: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_code);

132:
133: IF G_DEBUG='Y' THEN
134: AHL_DEBUG_PUB.debug( 'inside pub id:'||p_x_space_rec.space_id);
135: AHL_DEBUG_PUB.debug( 'inside pub name:'||p_x_space_rec.space_name);
136: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_code);
137: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_mean);
138: END IF;
139:
140: AHL_APPR_SPACE_CAPB_PVT.UPDATE_SPACE

Line 137: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_mean);

133: IF G_DEBUG='Y' THEN
134: AHL_DEBUG_PUB.debug( 'inside pub id:'||p_x_space_rec.space_id);
135: AHL_DEBUG_PUB.debug( 'inside pub name:'||p_x_space_rec.space_name);
136: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_code);
137: AHL_DEBUG_PUB.debug( 'inside pub cate:'||p_x_space_rec.space_category_mean);
138: END IF;
139:
140: AHL_APPR_SPACE_CAPB_PVT.UPDATE_SPACE
141: (

Line 181: AHL_DEBUG_PUB.debug( 'before delete 10');

177: END IF;
178:
179: END LOOP;
180: IF G_DEBUG='Y' THEN
181: AHL_DEBUG_PUB.debug( 'before delete 10');
182: END IF;
183:
184: --For Delet
185: ELSIF p_x_space_rec.operation_flag = 'D' THEN

Line 199: AHL_DEBUG_PUB.debug( 'before delete 20');

195: x_msg_data => l_msg_data
196: );
197:
198: IF G_DEBUG='Y' THEN
199: AHL_DEBUG_PUB.debug( 'before delete 20');
200: END IF;
201:
202: ELSIF p_x_space_capbl_tbl.COUNT > 0 THEN
203: FOR i IN p_x_space_capbl_tbl.first..p_x_space_capbl_tbl.LAST

Line 231: AHL_DEBUG_PUB.debug( 'before delete capb');

227: END LOOP;
228: END IF;
229:
230: IF G_DEBUG='Y' THEN
231: AHL_DEBUG_PUB.debug( 'before delete capb');
232: END IF;
233:
234: --For delete capab
235: IF p_x_space_capbl_tbl.COUNT > 0 THEN

Line 239: AHL_DEBUG_PUB.debug( 'inside pub delete capb'||p_x_space_capbl_tbl(i).operation_flag);

235: IF p_x_space_capbl_tbl.COUNT > 0 THEN
236: FOR i IN p_x_space_capbl_tbl.first..p_x_space_capbl_tbl.LAST
237: LOOP
238: IF G_DEBUG='Y' THEN
239: AHL_DEBUG_PUB.debug( 'inside pub delete capb'||p_x_space_capbl_tbl(i).operation_flag);
240: END IF;
241:
242: IF p_x_space_capbl_tbl(i).operation_flag = 'D' THEN
243: AHL_APPR_SPACE_CAPB_PVT.DELETE_SPACE_CAPBLTS

Line 284: Ahl_Debug_Pub.debug( 'End of private api Process Space Capbl','+SPCBL+');

280: COMMIT;
281: END IF;
282: -- Debug info
283: IF G_DEBUG='Y' THEN
284: Ahl_Debug_Pub.debug( 'End of private api Process Space Capbl','+SPCBL+');
285: END IF;
286: -- Check if API is called in debug mode. If yes, disable debug.
287: IF G_DEBUG='Y' THEN
288: Ahl_Debug_Pub.disable_debug;

Line 288: Ahl_Debug_Pub.disable_debug;

284: Ahl_Debug_Pub.debug( 'End of private api Process Space Capbl','+SPCBL+');
285: END IF;
286: -- Check if API is called in debug mode. If yes, disable debug.
287: IF G_DEBUG='Y' THEN
288: Ahl_Debug_Pub.disable_debug;
289: END IF;
290:
291: EXCEPTION
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 300: AHL_DEBUG_PUB.log_app_messages (

296: p_count => x_msg_count,
297: p_data => x_msg_data);
298:
299: IF G_DEBUG='Y' THEN
300: AHL_DEBUG_PUB.log_app_messages (
301: x_msg_count, x_msg_data, 'ERROR' );
302: AHL_DEBUG_PUB.debug( 'ahl_appr_space_capb_pub.Process Space Capbl','+SPCBL+');
303: END IF;
304: -- Check if API is called in debug mode. If yes, disable debug.

Line 302: AHL_DEBUG_PUB.debug( 'ahl_appr_space_capb_pub.Process Space Capbl','+SPCBL+');

298:
299: IF G_DEBUG='Y' THEN
300: AHL_DEBUG_PUB.log_app_messages (
301: x_msg_count, x_msg_data, 'ERROR' );
302: AHL_DEBUG_PUB.debug( 'ahl_appr_space_capb_pub.Process Space Capbl','+SPCBL+');
303: END IF;
304: -- Check if API is called in debug mode. If yes, disable debug.
305: AHL_DEBUG_PUB.disable_debug;
306:

Line 305: AHL_DEBUG_PUB.disable_debug;

301: x_msg_count, x_msg_data, 'ERROR' );
302: AHL_DEBUG_PUB.debug( 'ahl_appr_space_capb_pub.Process Space Capbl','+SPCBL+');
303: END IF;
304: -- Check if API is called in debug mode. If yes, disable debug.
305: AHL_DEBUG_PUB.disable_debug;
306:
307: WHEN FND_API.G_EXC_ERROR THEN
308: ROLLBACK TO process_space_capbl;
309: X_return_status := FND_API.G_RET_STS_ERROR;

Line 315: AHL_DEBUG_PUB.log_app_messages (

311: p_count => x_msg_count,
312: p_data => X_msg_data);
313: -- Debug info.
314: IF G_DEBUG='Y' THEN
315: AHL_DEBUG_PUB.log_app_messages (
316: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
317: AHL_DEBUG_PUB.debug( 'ahl_appr_space_capb_pub.Process Space Capbl','+SPCBL+');
318: END IF;
319: -- Check if API is called in debug mode. If yes, disable debug.

Line 317: AHL_DEBUG_PUB.debug( 'ahl_appr_space_capb_pub.Process Space Capbl','+SPCBL+');

313: -- Debug info.
314: IF G_DEBUG='Y' THEN
315: AHL_DEBUG_PUB.log_app_messages (
316: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
317: AHL_DEBUG_PUB.debug( 'ahl_appr_space_capb_pub.Process Space Capbl','+SPCBL+');
318: END IF;
319: -- Check if API is called in debug mode. If yes, disable debug.
320: AHL_DEBUG_PUB.disable_debug;
321:

Line 320: AHL_DEBUG_PUB.disable_debug;

316: x_msg_count, x_msg_data, 'UNEXPECTED ERROR' );
317: AHL_DEBUG_PUB.debug( 'ahl_appr_space_capb_pub.Process Space Capbl','+SPCBL+');
318: END IF;
319: -- Check if API is called in debug mode. If yes, disable debug.
320: AHL_DEBUG_PUB.disable_debug;
321:
322: WHEN OTHERS THEN
323: ROLLBACK TO process_space_capbl;
324: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 337: AHL_DEBUG_PUB.log_app_messages (

333: p_data => X_msg_data);
334:
335: -- Debug info.
336: IF G_DEBUG='Y' THEN
337: AHL_DEBUG_PUB.log_app_messages (
338: x_msg_count, x_msg_data, 'SQL ERROR' );
339: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pub.Process Space Capbl','+SPCBL+');
340: END IF;
341: -- Check if API is called in debug mode. If yes, disable debug.

Line 339: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pub.Process Space Capbl','+SPCBL+');

335: -- Debug info.
336: IF G_DEBUG='Y' THEN
337: AHL_DEBUG_PUB.log_app_messages (
338: x_msg_count, x_msg_data, 'SQL ERROR' );
339: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pub.Process Space Capbl','+SPCBL+');
340: END IF;
341: -- Check if API is called in debug mode. If yes, disable debug.
342: AHL_DEBUG_PUB.disable_debug;
343:

Line 342: AHL_DEBUG_PUB.disable_debug;

338: x_msg_count, x_msg_data, 'SQL ERROR' );
339: AHL_DEBUG_PUB.debug( 'ahl_appr_space_unavl_pub.Process Space Capbl','+SPCBL+');
340: END IF;
341: -- Check if API is called in debug mode. If yes, disable debug.
342: AHL_DEBUG_PUB.disable_debug;
343:
344: END Process_Space_capbl;
345:
346: END AHL_APPR_SPACE_CAPB_PUB;