[Home] [Help]
55: l_msg_data VARCHAR2(2000);
56: --
57: BEGIN
58: --------------------Initialize ----------------------------------
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;
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
72: FND_MSG_PUB.initialize;
73: END IF;
116: x_msg_count => l_msg_count,
117: x_msg_data => l_msg_data
118: );
119: END IF;
120: --Standard check to count messages
121: l_msg_count := Fnd_Msg_Pub.count_msg;
122:
123: IF l_msg_count > 0 THEN
124: X_msg_count := l_msg_count;
166: x_msg_count => l_msg_count,
167: x_msg_data => l_msg_data
168: );
169: END IF;
170: --Standard check to count messages
171: l_msg_count := Fnd_Msg_Pub.count_msg;
172:
173: IF l_msg_count > 0 THEN
174: X_msg_count := l_msg_count;
214: x_msg_count => l_msg_count,
215: x_msg_data => l_msg_data
216: );
217: END IF;
218: --Standard check to count messages
219: l_msg_count := Fnd_Msg_Pub.count_msg;
220:
221: IF l_msg_count > 0 THEN
222: X_msg_count := l_msg_count;
251: x_msg_count => l_msg_count,
252: x_msg_data => l_msg_data
253: );
254: END IF;
255: --Standard check to count messages
256: l_msg_count := Fnd_Msg_Pub.count_msg;
257:
258: IF l_msg_count > 0 THEN
259: X_msg_count := l_msg_count;
265: END IF;
266:
267:
268: ------------------------End of Body---------------------------------------
269: --Standard check to count messages
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
279: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
280: COMMIT;
281: END IF;
282: -- Debug info