[Home] [Help]
54: l_msg_data VARCHAR2(2000);
55: --
56: BEGIN
57: --------------------Initialize ----------------------------------
58: -- Standard Start of API savepoint
59: SAVEPOINT Assign_Sch_Visit_Spaces;
60: -- Check if API is called in debug mode. If yes, enable debug.
61: IF G_DEBUG='Y' THEN
62: Ahl_Debug_Pub.enable_debug;
64: -- Debug info.
65: IF G_DEBUG='Y' THEN
66: Ahl_Debug_Pub.debug( 'enter ahl_ltp_space_assign_pub.Assign Sch Visit Spaces','+SPANT+');
67: END IF;
68: -- Standard call to check for call compatibility.
69: IF Fnd_Api.to_boolean(p_init_msg_list)
70: THEN
71: Fnd_Msg_Pub.initialize;
72: END IF;
133: END IF;
134: --
135: END LOOP;
136: --
137: --Standard check to count messages
138: l_msg_count := Fnd_Msg_Pub.count_msg;
139:
140: IF l_msg_count > 0 THEN
141: X_msg_count := l_msg_count;
158: x_msg_count => l_msg_count,
159: x_msg_data => l_msg_data);
160: END IF; -- Visit ID
161: ------------------------End of Body---------------------------------------
162: --Standard check to count messages
163: l_msg_count := Fnd_Msg_Pub.count_msg;
164:
165: IF l_msg_count > 0 THEN
166: X_msg_count := l_msg_count;
167: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
168: RAISE Fnd_Api.G_EXC_ERROR;
169: END IF;
170:
171: --Standard check for commit
172: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
173: COMMIT;
174: END IF;
175: -- Debug info
261: l_msg_data VARCHAR2(2000);
262: --
263: BEGIN
264: --------------------Initialize ----------------------------------
265: -- Standard Start of API savepoint
266: SAVEPOINT schedule_visit;
267: -- Check if API is called in debug mode. If yes, enable debug.
268: IF G_DEBUG='Y' THEN
269: Ahl_Debug_Pub.enable_debug;
271: -- Debug info.
272: IF G_DEBUG='Y' THEN
273: Ahl_Debug_Pub.debug( 'enter ahl_ltp_space_assign_pub.Schedule Visit','+SPANT+');
274: END IF;
275: -- Standard call to check for call compatibility.
276: IF Fnd_Api.to_boolean(p_init_msg_list)
277: THEN
278: Fnd_Msg_Pub.initialize;
279: END IF;
300: x_msg_data => l_msg_data);
301: END IF;
302:
303: ------------------------End of Body---------------------------------------
304: --Standard check to count messages
305: l_msg_count := Fnd_Msg_Pub.count_msg;
306:
307: IF l_msg_count > 0 THEN
308: X_msg_count := l_msg_count;
309: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
310: RAISE Fnd_Api.G_EXC_ERROR;
311: END IF;
312:
313: --Standard check for commit
314: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
315: COMMIT;
316: END IF;
317: -- Debug info
405: l_msg_data VARCHAR2(2000);
406: --
407: BEGIN
408: --------------------Initialize ----------------------------------
409: -- Standard Start of API savepoint
410: SAVEPOINT unschedule_visit;
411: -- Check if API is called in debug mode. If yes, enable debug.
412: IF G_DEBUG='Y' THEN
413: Ahl_Debug_Pub.enable_debug;
415: -- Debug info.
416: IF G_DEBUG='Y' THEN
417: Ahl_Debug_Pub.debug( 'enter ahl_ltp_space_assign_pub.Unschedule Visit','+SPANT+');
418: END IF;
419: -- Standard call to check for call compatibility.
420: IF Fnd_Api.to_boolean(p_init_msg_list)
421: THEN
422: Fnd_Msg_Pub.initialize;
423: END IF;
444: x_msg_data => l_msg_data);
445: END IF;
446:
447: ------------------------End of Body---------------------------------------
448: --Standard check to count messages
449: l_msg_count := Fnd_Msg_Pub.count_msg;
450:
451: IF l_msg_count > 0 THEN
452: X_msg_count := l_msg_count;
453: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
454: RAISE Fnd_Api.G_EXC_ERROR;
455: END IF;
456:
457: --Standard check for commit
458: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
459: COMMIT;
460: END IF;
461: -- Debug info