735:
736: l_close_status_id NUMBER;
737: l_object_version_number NUMBER;
738: BEGIN
739: -- Standard start of API savepoint
740: SAVEPOINT close_task_pub;
741:
742: -- Standard call to check for call compatibility
743: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
738: BEGIN
739: -- Standard start of API savepoint
740: SAVEPOINT close_task_pub;
741:
742: -- Standard call to check for call compatibility
743: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
744: RAISE fnd_api.g_exc_unexpected_error;
745: END IF;
746:
768: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
769: RAISE fnd_api.g_exc_unexpected_error;
770: END IF;
771:
772: -- Standard check of p_commit
773: IF fnd_api.to_boolean (p_commit) THEN
774: COMMIT WORK;
775: END IF;
776: -- Standard call to get message count and if count is 1, get message info
772: -- Standard check of p_commit
773: IF fnd_api.to_boolean (p_commit) THEN
774: COMMIT WORK;
775: END IF;
776: -- Standard call to get message count and if count is 1, get message info
777: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
778: EXCEPTION
779: WHEN fnd_api.g_exc_error THEN
780: ROLLBACK TO close_task_pub;
833: AND ta.task_id (+) = t.task_id;
834:
835: l_task_info c_task_info%ROWTYPE;
836: BEGIN
837: -- standard call to check for call compatibility
838: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
839: RAISE fnd_api.g_exc_unexpected_error;
840: END IF;
841:
890: --END IF;
891: l_idx := x_collection.NEXT (l_idx);
892: END LOOP;
893:
894: -- standard call to get message count and if count is 1, get message info
895: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
896: EXCEPTION
897: WHEN OTHERS THEN
898: x_return_status := fnd_api.g_ret_sts_unexp_error;
1433:
1434: l_task_info c_task_info%ROWTYPE;
1435: l_task_status_info c_task_status_info%ROWTYPE;
1436: BEGIN
1437: -- Standard start of API savepoint
1438: SAVEPOINT update_task_status_pub;
1439:
1440: -- Standard call to check for call compatibility
1441: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1436: BEGIN
1437: -- Standard start of API savepoint
1438: SAVEPOINT update_task_status_pub;
1439:
1440: -- Standard call to check for call compatibility
1441: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1442: RAISE fnd_api.g_exc_unexpected_error;
1443: END IF;
1444:
1513: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1514: RAISE fnd_api.g_exc_unexpected_error;
1515: END IF;
1516:
1517: -- Standard check of p_commit
1518: IF fnd_api.to_boolean (p_commit) THEN
1519: COMMIT WORK;
1520: END IF;
1521:
1575: UPDATE JTF_TASKS_TL
1576: SET rejection_message = p_reject_message
1577: WHERE task_id = p_task_id;
1578:
1579: -- Standard check of p_commit
1580: IF fnd_api.to_boolean (p_commit) THEN
1581: COMMIT WORK;
1582: END IF;
1583:
2530: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2531: RAISE fnd_api.g_exc_unexpected_error;
2532: END IF;
2533:
2534: -- Standard check of p_commit
2535: IF fnd_api.to_boolean (p_commit) THEN
2536: COMMIT WORK;
2537: END IF;
2538:
2980: END LOOP;
2981: END IF;
2982: -- end of code for the bug 6801965
2983: CLOSE c_task_list;
2984: -- Standard check of p_commit
2985: IF fnd_api.to_boolean (p_commit) THEN
2986: COMMIT WORK;
2987: END IF;
2988:
3330: RAISE fnd_api.g_exc_unexpected_error;
3331: END IF;
3332: END IF;
3333:
3334: -- Standard check of p_commit
3335: IF fnd_api.to_boolean (p_commit) THEN
3336: COMMIT WORK;
3337: END IF;
3338: EXCEPTION
3436:
3437: l_child_position := 'M';
3438: END LOOP;
3439:
3440: -- Standard check of p_commit
3441: IF fnd_api.to_boolean (p_commit) THEN
3442: COMMIT WORK;
3443: END IF;
3444: EXCEPTION
4590:
4591: i := l_cust_task_tbl.next(i);
4592: END LOOP;
4593:
4594: -- Standard check of p_commit
4595: IF fnd_api.to_boolean (p_commit) THEN
4596: COMMIT WORK;
4597: END IF;
4598:
5564: ) IS
5565: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_TASK_STATUS';
5566: l_api_version CONSTANT NUMBER := 1.0;
5567: BEGIN
5568: -- Standard start of API savepoint
5569: SAVEPOINT update_task_attr;
5570:
5571: -- Standard call to check for call compatibility
5572: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
5567: BEGIN
5568: -- Standard start of API savepoint
5569: SAVEPOINT update_task_attr;
5570:
5571: -- Standard call to check for call compatibility
5572: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
5573: RAISE fnd_api.g_exc_unexpected_error;
5574: END IF;
5575:
5619: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
5620: RAISE fnd_api.g_exc_unexpected_error;
5621: END IF;
5622:
5623: -- Standard check of p_commit
5624: IF fnd_api.to_boolean (p_commit) THEN
5625: null;
5626: END IF;
5627: