DBA Data[Home] [Help]

APPS.JTF_IH_IEC_PVT dependencies on FND_API

Line 200: l_Commit := NVL(x_Commit,FND_API.G_FALSE);

196: -- Perf fix for literal Usage
197: l_ao_update_pending_perf := 'N';
198:
199: l_Hard_Close := NVL(p_Hard_Close,'N');
200: l_Commit := NVL(x_Commit,FND_API.G_FALSE);
201:
202: SAVEPOINT close_ao_call;
203: -- Get current ao_update_pending and soft_closed values for current Media_Id
204: --

Line 243: p_init_msg_list => FND_API.G_TRUE,

239: --
240: IF l_Hard_Close = 'Y' OR l_soft_closed = 'Y' THEN
241: JTF_IH_PUB.close_mediaitem(
242: p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_TRUE,
244: p_commit => l_Commit,
245: p_resp_appl_id => fnd_global.resp_appl_id,
246: p_resp_id => fnd_global.resp_id,
247: p_user_id => fnd_global.user_id,

Line 257: p_init_msg_list => FND_API.G_TRUE,

253: );
254: ELSE
255: JTF_IH_PUB.update_mediaitem(
256: p_api_version => 1.0,
257: p_init_msg_list => FND_API.G_TRUE,
258: p_commit => l_Commit,
259: p_resp_appl_id => fnd_global.resp_appl_id,
260: p_resp_id => fnd_global.resp_id,
261: p_user_id => fnd_global.user_id,

Line 270: RAISE fnd_api.g_exc_error;

266: p_media_rec => p_Media
267: );
268: END IF;
269: IF x_return_status <> 'S' THEN
270: RAISE fnd_api.g_exc_error;
271: END IF;
272:
273: IF l_Commit = FND_API.G_TRUE THEN
274: COMMIT WORK;

Line 273: IF l_Commit = FND_API.G_TRUE THEN

269: IF x_return_status <> 'S' THEN
270: RAISE fnd_api.g_exc_error;
271: END IF;
272:
273: IF l_Commit = FND_API.G_TRUE THEN
274: COMMIT WORK;
275: END IF;
276:
277: EXCEPTION

Line 278: WHEN fnd_api.g_exc_error THEN

274: COMMIT WORK;
275: END IF;
276:
277: EXCEPTION
278: WHEN fnd_api.g_exc_error THEN
279: ROLLBACK TO close_ao_call;
280: x_return_status := fnd_api.g_ret_sts_error;
281: fnd_msg_pub.count_and_get
282: ( p_count => x_msg_count,

Line 280: x_return_status := fnd_api.g_ret_sts_error;

276:
277: EXCEPTION
278: WHEN fnd_api.g_exc_error THEN
279: ROLLBACK TO close_ao_call;
280: x_return_status := fnd_api.g_ret_sts_error;
281: fnd_msg_pub.count_and_get
282: ( p_count => x_msg_count,
283: p_data => x_msg_data );
284: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');

Line 288: x_return_status := fnd_api.g_ret_sts_unexp_error;

284: x_msg_data := FND_MSG_PUB.Get(p_msg_index => x_msg_count, p_encoded=>'F');
285:
286: WHEN OTHERS THEN
287: ROLLBACK TO close_ao_call;
288: x_return_status := fnd_api.g_ret_sts_unexp_error;
289: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
290: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
291: END IF;
292: fnd_msg_pub.count_and_get(p_count => x_msg_count,