DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on STANDARD

Line 739: -- Standard start of API savepoint

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

Line 742: -- Standard call to check for call compatibility

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:

Line 772: -- Standard check of p_commit

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

Line 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;

Line 837: -- standard call to check for call compatibility

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:

Line 894: -- standard call to get message count and if count is 1, get message info

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;

Line 1437: -- Standard start of API savepoint

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

Line 1440: -- Standard call to check for call compatibility

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:

Line 1517: -- Standard check of p_commit

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:

Line 1579: -- Standard check of p_commit

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:

Line 2534: -- Standard check of p_commit

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:

Line 2984: -- Standard check of p_commit

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:

Line 3334: -- Standard check of p_commit

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

Line 3440: -- Standard check of p_commit

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

Line 4594: -- Standard check of p_commit

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:

Line 5568: -- Standard start of API savepoint

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

Line 5571: -- Standard call to check for call compatibility

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:

Line 5623: -- Standard check of p_commit

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: