DBA Data[Home] [Help]

APPS.JTF_IH_PVT dependencies on FND_API

Line 33: x_return_status := fnd_api.g_ret_sts_success;

29: -- DBMS_OUTPUT.ENABLE(1000000);
30: -- DBMS_OUTPUT.PUT_LINE('---------------create_interaction: validate version---------------');
31:
32: -- Initialize API return status to success
33: x_return_status := fnd_api.g_ret_sts_success;
34:
35: SELECT jtf.jtf_ih_media_items_s1.NEXTVAL INTO l_media.media_id FROM dual;
36:
37: JTF_IH_PUB.Create_MediaItem(1.0,'T','T',p_resp_appl_id,p_resp_id,p_user_id,p_login_id,

Line 66: WHEN fnd_api.g_exc_error THEN

62: fnd_msg_pub.count_and_get
63: ( p_count => x_msg_count,
64: p_data => x_msg_data );
65: EXCEPTION
66: WHEN fnd_api.g_exc_error THEN
67: ROLLBACK TO create_interaction_pub;
68: x_return_status := fnd_api.g_ret_sts_error;
69: fnd_msg_pub.count_and_get
70: ( p_count => x_msg_count,

Line 68: x_return_status := fnd_api.g_ret_sts_error;

64: p_data => x_msg_data );
65: EXCEPTION
66: WHEN fnd_api.g_exc_error THEN
67: ROLLBACK TO create_interaction_pub;
68: x_return_status := fnd_api.g_ret_sts_error;
69: fnd_msg_pub.count_and_get
70: ( p_count => x_msg_count,
71: p_data => x_msg_data );
72: WHEN fnd_api.g_exc_unexpected_error THEN

Line 72: WHEN fnd_api.g_exc_unexpected_error THEN

68: x_return_status := fnd_api.g_ret_sts_error;
69: fnd_msg_pub.count_and_get
70: ( p_count => x_msg_count,
71: p_data => x_msg_data );
72: WHEN fnd_api.g_exc_unexpected_error THEN
73: ROLLBACK TO create_interaction_pub;
74: x_return_status := fnd_api.g_ret_sts_unexp_error;
75: fnd_msg_pub.count_and_get
76: ( p_count => x_msg_count,

Line 74: x_return_status := fnd_api.g_ret_sts_unexp_error;

70: ( p_count => x_msg_count,
71: p_data => x_msg_data );
72: WHEN fnd_api.g_exc_unexpected_error THEN
73: ROLLBACK TO create_interaction_pub;
74: x_return_status := fnd_api.g_ret_sts_unexp_error;
75: fnd_msg_pub.count_and_get
76: ( p_count => x_msg_count,
77: p_data => x_msg_data );
78: WHEN OTHERS THEN

Line 80: x_return_status := fnd_api.g_ret_sts_unexp_error;

76: ( p_count => x_msg_count,
77: p_data => x_msg_data );
78: WHEN OTHERS THEN
79: ROLLBACK TO create_interaction_pub;
80: x_return_status := fnd_api.g_ret_sts_unexp_error;
81: fnd_msg_pub.count_and_get
82: ( p_count => x_msg_count,
83: p_data => x_msg_data );
84: