145: WHERE ACTIVITY_ASSOCIATION_ID = P_ACTIVITY_ASSOCIATION_ID;
146:
147: BEGIN
148:
149: -- Standard Start of API savepoint
150: SAVEPOINT insert_row;
151:
152: -- Standard call to check for call compatibility.
153: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
148:
149: -- Standard Start of API savepoint
150: SAVEPOINT insert_row;
151:
152: -- Standard call to check for call compatibility.
153: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
154: RAISE fnd_api.g_exc_unexpected_error;
155: END IF;
156:
275: end if;
276: CLOSE C;
277:
278: -- End of API body.
279: -- Standard check of p_commit.
280: IF fnd_api.to_boolean(p_commit) THEN
281: COMMIT WORK;
282: END IF;
283:
280: IF fnd_api.to_boolean(p_commit) THEN
281: COMMIT WORK;
282: END IF;
283:
284: -- Standard call to get message count and if count is 1, get message info.
285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO insert_row;
365: Recinfo C%ROWTYPE;
366:
367: BEGIN
368:
369: -- Standard Start of API savepoint
370: SAVEPOINT lock_row;
371:
372: -- Standard call to check for call compatibility.
373: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
368:
369: -- Standard Start of API savepoint
370: SAVEPOINT lock_row;
371:
372: -- Standard call to check for call compatibility.
373: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
374: RAISE fnd_api.g_exc_unexpected_error;
375: END IF;
376:
477: APP_EXCEPTION.Raise_Exception;
478: end if;
479:
480: -- End of API body.
481: -- Standard check of p_commit.
482: IF fnd_api.to_boolean(p_commit) THEN
483: COMMIT WORK;
484: END IF;
485:
482: IF fnd_api.to_boolean(p_commit) THEN
483: COMMIT WORK;
484: END IF;
485:
486: -- Standard call to get message count and if count is 1, get message info.
487: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
488: EXCEPTION
489: WHEN fnd_api.g_exc_error THEN
490: ROLLBACK TO lock_row;
562: l_api_version CONSTANT NUMBER := 1.0;
563: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
564: l_object_type NUMBER;
565: BEGIN
566: -- Standard Start of API savepoint
567: SAVEPOINT update_row;
568:
569: -- Standard call to check for call compatibility.
570: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
565: BEGIN
566: -- Standard Start of API savepoint
567: SAVEPOINT update_row;
568:
569: -- Standard call to check for call compatibility.
570: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
571: RAISE fnd_api.g_exc_unexpected_error;
572: END IF;
573:
647: RAISE fnd_api.g_exc_error;
648: END IF;
649:
650: -- End of API body.
651: -- Standard check of p_commit.
652: IF fnd_api.to_boolean(p_commit) THEN
653: COMMIT WORK;
654: END IF;
655:
652: IF fnd_api.to_boolean(p_commit) THEN
653: COMMIT WORK;
654: END IF;
655:
656: -- Standard call to get message count and if count is 1, get message info.
657: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
658: EXCEPTION
659: WHEN fnd_api.g_exc_error THEN
660: ROLLBACK TO update_row;