DBA Data[Home] [Help]

APPS.JTF_RS_SKILL_LEVELS_PUB dependencies on FND_MESSAGE

Line 156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

152: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
153: WHEN OTHERS
154: THEN
155: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
157: fnd_message.set_token('P_SQLCODE',SQLCODE);
158: fnd_message.set_token('P_SQLERRM',SQLERRM);
159: fnd_message.set_token('P_API_NAME', l_api_name);
160: FND_MSG_PUB.add;

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

153: WHEN OTHERS
154: THEN
155: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
157: fnd_message.set_token('P_SQLCODE',SQLCODE);
158: fnd_message.set_token('P_SQLERRM',SQLERRM);
159: fnd_message.set_token('P_API_NAME', l_api_name);
160: FND_MSG_PUB.add;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

154: THEN
155: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
157: fnd_message.set_token('P_SQLCODE',SQLCODE);
158: fnd_message.set_token('P_SQLERRM',SQLERRM);
159: fnd_message.set_token('P_API_NAME', l_api_name);
160: FND_MSG_PUB.add;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 159: fnd_message.set_token('P_API_NAME', l_api_name);

155: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
157: fnd_message.set_token('P_SQLCODE',SQLCODE);
158: fnd_message.set_token('P_SQLERRM',SQLERRM);
159: fnd_message.set_token('P_API_NAME', l_api_name);
160: FND_MSG_PUB.add;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
163:

Line 288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

284: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
285: WHEN OTHERS
286: THEN
287: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
289: fnd_message.set_token('P_SQLCODE',SQLCODE);
290: fnd_message.set_token('P_SQLERRM',SQLERRM);
291: fnd_message.set_token('P_API_NAME',l_api_name);
292: FND_MSG_PUB.add;

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

285: WHEN OTHERS
286: THEN
287: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
289: fnd_message.set_token('P_SQLCODE',SQLCODE);
290: fnd_message.set_token('P_SQLERRM',SQLERRM);
291: fnd_message.set_token('P_API_NAME',l_api_name);
292: FND_MSG_PUB.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

286: THEN
287: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
289: fnd_message.set_token('P_SQLCODE',SQLCODE);
290: fnd_message.set_token('P_SQLERRM',SQLERRM);
291: fnd_message.set_token('P_API_NAME',l_api_name);
292: FND_MSG_PUB.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 291: fnd_message.set_token('P_API_NAME',l_api_name);

287: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
289: fnd_message.set_token('P_SQLCODE',SQLCODE);
290: fnd_message.set_token('P_SQLERRM',SQLERRM);
291: fnd_message.set_token('P_API_NAME',l_api_name);
292: FND_MSG_PUB.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
295: END update_skills;

Line 375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

371: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
372: WHEN OTHERS
373: THEN
374: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
376: fnd_message.set_token('P_SQLCODE',SQLCODE);
377: fnd_message.set_token('P_SQLERRM',SQLERRM);
378: fnd_message.set_token('P_API_NAME',l_api_name);
379: FND_MSG_PUB.add;

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

372: WHEN OTHERS
373: THEN
374: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
376: fnd_message.set_token('P_SQLCODE',SQLCODE);
377: fnd_message.set_token('P_SQLERRM',SQLERRM);
378: fnd_message.set_token('P_API_NAME',l_api_name);
379: FND_MSG_PUB.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

373: THEN
374: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
376: fnd_message.set_token('P_SQLCODE',SQLCODE);
377: fnd_message.set_token('P_SQLERRM',SQLERRM);
378: fnd_message.set_token('P_API_NAME',l_api_name);
379: FND_MSG_PUB.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 378: fnd_message.set_token('P_API_NAME',l_api_name);

374: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
376: fnd_message.set_token('P_SQLCODE',SQLCODE);
377: fnd_message.set_token('P_SQLERRM',SQLERRM);
378: fnd_message.set_token('P_API_NAME',l_api_name);
379: FND_MSG_PUB.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
382: