APPS.JTF_OBJECTS_PUB dependencies on FND_API

Line 114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

110: END jtf_obj_select_stmt;
111:
112: PROCEDURE check_syntax (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
117: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
118: p_select_details IN jtf_objects_b.select_details%TYPE

Line 115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

111:
112: PROCEDURE check_syntax (
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
115: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_select_id IN jtf_objects_b.select_id%TYPE DEFAULT NULL,
117: p_select_name IN jtf_objects_b.select_name%TYPE DEFAULT NULL,
118: p_select_details IN jtf_objects_b.select_details%TYPE
119: DEFAULT NULL,

Line 156: x_return_status := fnd_api.g_ret_sts_success;

152: l_dummy_select_details VARCHAR2(2000);
153: initialized BOOLEAN := FALSE;
154: BEGIN
155: SAVEPOINT check_syntax;
156: x_return_status := fnd_api.g_ret_sts_success;
157:
158: IF NOT fnd_api.compatible_api_call (
159: l_api_version,
160: p_api_version,

Line 158: IF NOT fnd_api.compatible_api_call (

154: BEGIN
155: SAVEPOINT check_syntax;
156: x_return_status := fnd_api.g_ret_sts_success;
157:
158: IF NOT fnd_api.compatible_api_call (
159: l_api_version,
160: p_api_version,
161: l_api_name,
162: g_pkg_name

Line 165: RAISE fnd_api.g_exc_unexpected_error;

161: l_api_name,
162: g_pkg_name
163: )
164: THEN
165: RAISE fnd_api.g_exc_unexpected_error;
166: END IF;
167:
168: IF fnd_api.to_boolean (p_init_msg_list)
169: THEN

Line 168: IF fnd_api.to_boolean (p_init_msg_list)

164: THEN
165: RAISE fnd_api.g_exc_unexpected_error;
166: END IF;
167:
168: IF fnd_api.to_boolean (p_init_msg_list)
169: THEN
170: fnd_msg_pub.initialize;
171: END IF;
172:

Line 262: IF fnd_api.to_boolean (p_commit)

258: EXECUTE IMMEDIATE x_sql_statement
259: INTO l_dummy_select_id, l_dummy_select_name, l_dummy_select_details;
260: END IF;
261:
262: IF fnd_api.to_boolean (p_commit)
263: THEN
264: COMMIT WORK;
265: END IF;
266:

Line 281: x_return_status := fnd_api.g_ret_sts_unexp_error;

277: NULL;
278: WHEN OTHERS
279: THEN
280: ROLLBACK TO check_syntax;
281: x_return_status := fnd_api.g_ret_sts_unexp_error;
282: fnd_message.set_name ('JTF', 'JTF_OBJECTS_SYNTAX_ERROR');
283: fnd_message.set_token ('P_MESSAGE_TEXT', SQLERRM);
284: fnd_msg_pub.add;
285: fnd_msg_pub.count_and_get (