DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_ORGS_PUB dependencies on FND_MSG_PUB

Line 65: fnd_msg_pub.initialize;

61: RAISE fnd_api.g_exc_unexpected_error;
62: END IF;
63:
64: IF fnd_api.to_boolean(p_init_msg_list) THEN
65: fnd_msg_pub.initialize;
66: END IF;
67:
68: /* Call the private API to do validations and data processing */
69: JTF_RS_GROUP_ORGS_PVT.create_group_org

Line 104: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

100: IF fnd_api.to_boolean(p_commit) THEN
101: COMMIT WORK;
102: END IF;
103:
104: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
105:
106: EXCEPTION
107:
108: WHEN fnd_api.g_exc_unexpected_error THEN

Line 111: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

107:
108: WHEN fnd_api.g_exc_unexpected_error THEN
109: ROLLBACK TO sp_create_group_org;
110: x_return_status := fnd_api.g_ret_sts_unexp_error;
111: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
112:
113: WHEN OTHERS THEN
114: ROLLBACK TO sp_create_group_org;
115: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 119: FND_MSG_PUB.add;

115: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
116: fnd_message.set_token('P_SQLCODE',SQLCODE);
117: fnd_message.set_token('P_SQLERRM',SQLERRM);
118: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
119: FND_MSG_PUB.add;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
122:
123: END create_group_org;

Line 121: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

117: fnd_message.set_token('P_SQLERRM',SQLERRM);
118: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
119: FND_MSG_PUB.add;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
122:
123: END create_group_org;
124:
125: /* Procedure to update the Resource Group to HR Org mapping Attributes

Line 170: fnd_msg_pub.initialize;

166: RAISE fnd_api.g_exc_unexpected_error;
167: END IF;
168:
169: IF fnd_api.to_boolean(p_init_msg_list) THEN
170: fnd_msg_pub.initialize;
171: END IF;
172:
173: /* Call the private API to do validations and data processing */
174: JTF_RS_GROUP_ORGS_PVT.update_group_org

Line 210: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

206: IF fnd_api.to_boolean(p_commit) THEN
207: COMMIT WORK;
208: END IF;
209:
210: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
211:
212: EXCEPTION
213:
214: WHEN fnd_api.g_exc_unexpected_error THEN

Line 217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

213:
214: WHEN fnd_api.g_exc_unexpected_error THEN
215: ROLLBACK TO sp_update_group_org;
216: x_return_status := fnd_api.g_ret_sts_unexp_error;
217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
218:
219: WHEN OTHERS THEN
220: ROLLBACK TO sp_update_group_org;
221: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 225: FND_MSG_PUB.add;

221: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
222: fnd_message.set_token('P_SQLCODE',SQLCODE);
223: fnd_message.set_token('P_SQLERRM',SQLERRM);
224: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
225: FND_MSG_PUB.add;
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
228:
229: END update_group_org;

Line 227: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

223: fnd_message.set_token('P_SQLERRM',SQLERRM);
224: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
225: FND_MSG_PUB.add;
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
228:
229: END update_group_org;
230:
231: /* Procedure to delete resource group - HR Org mapping */

Line 259: fnd_msg_pub.initialize;

255: RAISE fnd_api.g_exc_unexpected_error;
256: END IF;
257:
258: IF fnd_api.to_boolean(p_init_msg_list) THEN
259: fnd_msg_pub.initialize;
260: END IF;
261:
262: /* Call the private API to do validations and data processing */
263: JTF_RS_GROUP_ORGS_PVT.delete_group_org

Line 283: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

279: IF fnd_api.to_boolean(p_commit) THEN
280: COMMIT WORK;
281: END IF;
282:
283: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
284:
285: EXCEPTION
286:
287: WHEN fnd_api.g_exc_unexpected_error THEN

Line 290: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

286:
287: WHEN fnd_api.g_exc_unexpected_error THEN
288: ROLLBACK TO sp_delete_group_org;
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
291:
292: WHEN OTHERS THEN
293: ROLLBACK TO sp_delete_group_org;
294: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 298: FND_MSG_PUB.add;

294: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
295: fnd_message.set_token('P_SQLCODE',SQLCODE);
296: fnd_message.set_token('P_SQLERRM',SQLERRM);
297: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
298: FND_MSG_PUB.add;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
301:
302: END delete_group_org;

Line 300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

296: fnd_message.set_token('P_SQLERRM',SQLERRM);
297: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
298: FND_MSG_PUB.add;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
301:
302: END delete_group_org;
303:
304: END JTF_RS_GROUP_ORGS_PUB;