DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_ORGS_PUB dependencies on FND_MESSAGE

Line 115: fnd_message.set_name ('JTF', 'JTF_RS_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');
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;

Line 116: fnd_message.set_token('P_SQLCODE',SQLCODE);

112:
113: WHEN OTHERS THEN
114: ROLLBACK TO sp_create_group_org;
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;

Line 117: fnd_message.set_token('P_SQLERRM',SQLERRM);

113: WHEN OTHERS THEN
114: ROLLBACK TO sp_create_group_org;
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);

Line 118: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);

114: ROLLBACK TO sp_create_group_org;
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:

Line 221: fnd_message.set_name ('JTF', 'JTF_RS_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');
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;

Line 222: fnd_message.set_token('P_SQLCODE',SQLCODE);

218:
219: WHEN OTHERS THEN
220: ROLLBACK TO sp_update_group_org;
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;

Line 223: fnd_message.set_token('P_SQLERRM',SQLERRM);

219: WHEN OTHERS THEN
220: ROLLBACK TO sp_update_group_org;
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);

Line 224: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);

220: ROLLBACK TO sp_update_group_org;
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:

Line 294: fnd_message.set_name ('JTF', 'JTF_RS_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');
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;

Line 295: fnd_message.set_token('P_SQLCODE',SQLCODE);

291:
292: WHEN OTHERS THEN
293: ROLLBACK TO sp_delete_group_org;
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;

Line 296: fnd_message.set_token('P_SQLERRM',SQLERRM);

292: WHEN OTHERS THEN
293: ROLLBACK TO sp_delete_group_org;
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);

Line 297: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);

293: ROLLBACK TO sp_delete_group_org;
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: