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 FND_API

Line 40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

36: -- NOTES
37: --------------------------------------------------------------------
38: PROCEDURE Process_Space_Capbl (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43: p_module_type IN VARCHAR2 := 'JSP',
44: p_x_space_rec IN OUT NOCOPY Space_Rec,

Line 41: p_commit IN VARCHAR2 := FND_API.g_false,

37: --------------------------------------------------------------------
38: PROCEDURE Process_Space_Capbl (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43: p_module_type IN VARCHAR2 := 'JSP',
44: p_x_space_rec IN OUT NOCOPY Space_Rec,
45: p_x_space_capbl_tbl IN OUT NOCOPY Space_Capbl_Tbl,

Line 42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

38: PROCEDURE Process_Space_Capbl (
39: p_api_version IN NUMBER,
40: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
41: p_commit IN VARCHAR2 := FND_API.g_false,
42: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
43: p_module_type IN VARCHAR2 := 'JSP',
44: p_x_space_rec IN OUT NOCOPY Space_Rec,
45: p_x_space_capbl_tbl IN OUT NOCOPY Space_Capbl_Tbl,
46: x_return_status OUT NOCOPY VARCHAR2,

Line 70: IF FND_API.to_boolean(p_init_msg_list)

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
72: FND_MSG_PUB.initialize;
73: END IF;
74: -- Initialize API return status to success

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74: -- Initialize API return status to success
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
78: p_api_version,
79: l_api_name,G_PKG_NAME)

Line 77: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

73: END IF;
74: -- Initialize API return status to success
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
78: p_api_version,
79: l_api_name,G_PKG_NAME)
80: THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

77: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
78: p_api_version,
79: l_api_name,G_PKG_NAME)
80: THEN
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');

Line 125: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

121: l_msg_count := Fnd_Msg_Pub.count_msg;
122:
123: IF l_msg_count > 0 THEN
124: X_msg_count := l_msg_count;
125: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
126: RAISE Fnd_Api.G_EXC_ERROR;
127: END IF;
128:
129: END LOOP;

Line 126: RAISE Fnd_Api.G_EXC_ERROR;

122:
123: IF l_msg_count > 0 THEN
124: X_msg_count := l_msg_count;
125: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
126: RAISE Fnd_Api.G_EXC_ERROR;
127: END IF;
128:
129: END LOOP;
130: --For update

Line 175: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

171: l_msg_count := Fnd_Msg_Pub.count_msg;
172:
173: IF l_msg_count > 0 THEN
174: X_msg_count := l_msg_count;
175: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
176: RAISE Fnd_Api.G_EXC_ERROR;
177: END IF;
178:
179: END LOOP;

Line 176: RAISE Fnd_Api.G_EXC_ERROR;

172:
173: IF l_msg_count > 0 THEN
174: X_msg_count := l_msg_count;
175: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
176: RAISE Fnd_Api.G_EXC_ERROR;
177: END IF;
178:
179: END LOOP;
180: IF G_DEBUG='Y' THEN

Line 223: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

219: l_msg_count := Fnd_Msg_Pub.count_msg;
220:
221: IF l_msg_count > 0 THEN
222: X_msg_count := l_msg_count;
223: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
224: RAISE Fnd_Api.G_EXC_ERROR;
225: END IF;
226:
227: END LOOP;

Line 224: RAISE Fnd_Api.G_EXC_ERROR;

220:
221: IF l_msg_count > 0 THEN
222: X_msg_count := l_msg_count;
223: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
224: RAISE Fnd_Api.G_EXC_ERROR;
225: END IF;
226:
227: END LOOP;
228: END IF;

Line 260: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

256: l_msg_count := Fnd_Msg_Pub.count_msg;
257:
258: IF l_msg_count > 0 THEN
259: X_msg_count := l_msg_count;
260: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
261: RAISE Fnd_Api.G_EXC_ERROR;
262: END IF;
263:
264: END LOOP;

Line 261: RAISE Fnd_Api.G_EXC_ERROR;

257:
258: IF l_msg_count > 0 THEN
259: X_msg_count := l_msg_count;
260: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
261: RAISE Fnd_Api.G_EXC_ERROR;
262: END IF;
263:
264: END LOOP;
265: END IF;

Line 274: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

270: l_msg_count := Fnd_Msg_Pub.count_msg;
271:
272: IF l_msg_count > 0 THEN
273: X_msg_count := l_msg_count;
274: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
275: RAISE Fnd_Api.G_EXC_ERROR;
276: END IF;
277:
278: --Standard check for commit

Line 275: RAISE Fnd_Api.G_EXC_ERROR;

271:
272: IF l_msg_count > 0 THEN
273: X_msg_count := l_msg_count;
274: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
275: RAISE Fnd_Api.G_EXC_ERROR;
276: END IF;
277:
278: --Standard check for commit
279: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

Line 279: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN

275: RAISE Fnd_Api.G_EXC_ERROR;
276: END IF;
277:
278: --Standard check for commit
279: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
280: COMMIT;
281: END IF;
282: -- Debug info
283: IF G_DEBUG='Y' THEN

Line 292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

288: Ahl_Debug_Pub.disable_debug;
289: END IF;
290:
291: EXCEPTION
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: ROLLBACK TO process_space_capbl;
294: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
296: p_count => x_msg_count,

Line 294: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290:
291: EXCEPTION
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: ROLLBACK TO process_space_capbl;
294: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
296: p_count => x_msg_count,
297: p_data => x_msg_data);
298:

Line 295: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

291: EXCEPTION
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: ROLLBACK TO process_space_capbl;
294: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
296: p_count => x_msg_count,
297: p_data => x_msg_data);
298:
299: IF G_DEBUG='Y' THEN

Line 307: WHEN FND_API.G_EXC_ERROR THEN

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;
310: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
311: p_count => x_msg_count,

Line 309: X_return_status := FND_API.G_RET_STS_ERROR;

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;
310: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
311: p_count => x_msg_count,
312: p_data => X_msg_data);
313: -- Debug info.

Line 310: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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;
310: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
311: p_count => x_msg_count,
312: p_data => X_msg_data);
313: -- Debug info.
314: IF G_DEBUG='Y' THEN

Line 324: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
325: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: THEN
327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_SPACE_CAPB_PUB',
328: p_procedure_name => 'PROCESS_SPACE_CAPBL',

Line 331: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_APPR_SPACE_CAPB_PUB',
328: p_procedure_name => 'PROCESS_SPACE_CAPBL',
329: p_error_text => SUBSTR(SQLERRM,1,240));
330: END IF;
331: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
332: p_count => x_msg_count,
333: p_data => X_msg_data);
334:
335: -- Debug info.