APPS.JTF_RS_UPDATE_LOCATION_PUB dependencies on FND_MSG_PUB

Line 42: FND_MSG_PUB.Initialize;

38:
39: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
40: IF FND_API.To_boolean(P_INIT_MSG_LIST)
41: THEN
42: FND_MSG_PUB.Initialize;
43: END IF;
44:
45: l_date := sysdate;
46: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 53: fnd_msg_pub.add;

49:
50: if(p_resource_id is null)
51: then
52: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
53: fnd_msg_pub.add;
54: x_return_status := fnd_api.g_ret_sts_error;
55: RAISE fnd_api.g_exc_error;
56:
57: end if;

Line 64: fnd_msg_pub.add;

60: fetch res_cur into res_rec;
61: if(res_cur%notfound)
62: then
63: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
64: fnd_msg_pub.add;
65: x_return_status := fnd_api.g_ret_sts_error;
66: close res_cur;
67: RAISE fnd_api.g_exc_error;
68: else

Line 80: fnd_msg_pub.add;

76: EXCEPTION
77: WHEN OTHERS THEN
78: x_return_status := fnd_api.g_ret_sts_unexp_error;
79: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
80: fnd_msg_pub.add;
81: RAISE fnd_api.g_exc_unexpected_error;
82: END;
83: update jtf_rs_resource_extns
84: set location = p_location,

Line 92: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

88: end if; -- end of res_cur check
89: close res_cur;
90: p_object_version_num := p_object_version_num + 1;
91:
92: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
93:
94: EXCEPTION
95: WHEN fnd_api.g_exc_unexpected_error
96: THEN

Line 98: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

94: EXCEPTION
95: WHEN fnd_api.g_exc_unexpected_error
96: THEN
97: ROLLBACK TO update_sp;
98: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
99: WHEN fnd_api.g_exc_error
100: THEN
101: ROLLBACK TO update_sp;
102: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 102: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

98: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
99: WHEN fnd_api.g_exc_error
100: THEN
101: ROLLBACK TO update_sp;
102: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
103:
104: WHEN OTHERS
105: THEN
106: ROLLBACK TO update_sp;

Line 111: FND_MSG_PUB.add;

107: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
108: fnd_message.set_token('P_SQLCODE',SQLCODE);
109: fnd_message.set_token('P_SQLERRM',SQLERRM);
110: fnd_message.set_token('P_API_NAME',l_api_name);
111: FND_MSG_PUB.add;
112: x_return_status := fnd_api.g_ret_sts_unexp_error;
113: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
114: END;
115:

Line 113: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

109: fnd_message.set_token('P_SQLERRM',SQLERRM);
110: fnd_message.set_token('P_API_NAME',l_api_name);
111: FND_MSG_PUB.add;
112: x_return_status := fnd_api.g_ret_sts_unexp_error;
113: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
114: END;
115:
116:
117: END jtf_rs_update_location_pub;