APPS.JTF_TASK_OBJECT_MIGRATION_PUB dependencies on FND_API

Line 5: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

1: PACKAGE BODY JTF_TASK_OBJECT_MIGRATION_PUB AS
2: /* $Header: jtfptkjb.pls 115.0 2003/04/08 23:42:10 cjang noship $ */
3:
4: PROCEDURE update_object_name(p_object_code IN VARCHAR2
5: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
7: ,x_msg_count OUT NOCOPY NUMBER
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: ,x_return_status OUT NOCOPY VARCHAR2)

Line 6: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

2: /* $Header: jtfptkjb.pls 115.0 2003/04/08 23:42:10 cjang noship $ */
3:
4: PROCEDURE update_object_name(p_object_code IN VARCHAR2
5: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
6: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
7: ,x_msg_count OUT NOCOPY NUMBER
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: ,x_return_status OUT NOCOPY VARCHAR2)
10: IS

Line 25: x_return_status := fnd_api.g_ret_sts_success;

21: l_stmt VARCHAR2(1000);
22:
23: BEGIN
24: SAVEPOINT update_object_name_pub;
25: x_return_status := fnd_api.g_ret_sts_success;
26:
27: IF fnd_api.to_boolean (p_init_msg_list)
28: THEN
29: fnd_msg_pub.initialize;

Line 27: IF fnd_api.to_boolean (p_init_msg_list)

23: BEGIN
24: SAVEPOINT update_object_name_pub;
25: x_return_status := fnd_api.g_ret_sts_success;
26:
27: IF fnd_api.to_boolean (p_init_msg_list)
28: THEN
29: fnd_msg_pub.initialize;
30: END IF;
31:

Line 44: RAISE fnd_api.g_exc_unexpected_error;

40: THEN
41: fnd_message.set_name ('JTF', 'JTF_TASK_OBJECT_NOT_FOUND');
42: fnd_message.set_token ('OBJECT_NAME', p_object_code);
43: fnd_msg_pub.add;
44: RAISE fnd_api.g_exc_unexpected_error;
45: END IF;
46:
47: IF l_where_clause IS NOT NULL THEN
48: l_where_clause := l_where_clause || ' AND ';

Line 70: IF fnd_api.to_boolean (p_commit)

66: l_id_column||' = object_id) '||
67: ' WHERE object_type_code = '''||p_object_code||'''';
68: EXECUTE IMMEDIATE l_stmt;
69:
70: IF fnd_api.to_boolean (p_commit)
71: THEN
72: COMMIT WORK;
73: END IF;
74:

Line 76: WHEN fnd_api.g_exc_unexpected_error THEN

72: COMMIT WORK;
73: END IF;
74:
75: EXCEPTION
76: WHEN fnd_api.g_exc_unexpected_error THEN
77: ROLLBACK TO update_object_name_pub;
78: x_return_status := fnd_api.g_ret_sts_unexp_error;
79: IF c_object%ISOPEN
80: THEN

Line 78: x_return_status := fnd_api.g_ret_sts_unexp_error;

74:
75: EXCEPTION
76: WHEN fnd_api.g_exc_unexpected_error THEN
77: ROLLBACK TO update_object_name_pub;
78: x_return_status := fnd_api.g_ret_sts_unexp_error;
79: IF c_object%ISOPEN
80: THEN
81: CLOSE c_object;
82: END IF;

Line 89: x_return_status := fnd_api.g_ret_sts_unexp_error;

85: ,p_data => x_msg_data
86: );
87: WHEN OTHERS THEN
88: ROLLBACK TO update_object_name_pub;
89: x_return_status := fnd_api.g_ret_sts_unexp_error;
90: IF c_object%ISOPEN
91: THEN
92: CLOSE c_object;
93: END IF;