DBA Data[Home] [Help]

APPS.JTF_RS_ROLE_RELATE_PUB dependencies on FND_MESSAGE

Line 108: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');

104: END LOOP;
105:
106: IF l_role_resource_type = 'X'
107: THEN
108: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RL_RES_TYPE');
109: FND_MSG_PUB.add;
110: RAISE fnd_api.g_exc_error;
111: ELSE
112:

Line 132: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RR_RESOURCE');

128: ELSE
129: IF NOT(l_found)
130: --if the id is not found then raise error
131: THEN
132: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_RR_RESOURCE');
133: FND_MSG_PUB.add;
134: RAISE fnd_api.g_exc_error;
135: END IF;
136: END IF;

Line 148: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ROLE');

144: OPEN role_cur(l_role_id, l_role_code);
145: FETCH role_cur INTO role_rec;
146: IF (role_cur%NOTFOUND)
147: THEN
148: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ROLE');
149: FND_MSG_PUB.add;
150: RAISE fnd_api.g_exc_error;
151: ELSE
152: l_role_id := role_rec.role_id;

Line 157: fnd_message.set_name ('JTF', 'JTF_RS_ROLE');

153: END IF;
154: CLOSE role_cur;
155: ELSE
156: --if both role id and role code is null then raise error
157: fnd_message.set_name ('JTF', 'JTF_RS_ROLE');
158: FND_MSG_PUB.add;
159: RAISE fnd_api.g_exc_error;
160:
161: END IF;

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

226: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
227: p_data => x_msg_data);
228: WHEN OTHERS THEN
229: ROLLBACK TO ROLE_RELATE_SP;
230: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
231: fnd_message.set_token('P_SQLCODE',SQLCODE);
232: fnd_message.set_token('P_SQLERRM',SQLERRM);
233: fnd_message.set_token('P_API_NAME', l_api_name);
234: FND_MSG_PUB.add;

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

227: p_data => x_msg_data);
228: WHEN OTHERS THEN
229: ROLLBACK TO ROLE_RELATE_SP;
230: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
231: fnd_message.set_token('P_SQLCODE',SQLCODE);
232: fnd_message.set_token('P_SQLERRM',SQLERRM);
233: fnd_message.set_token('P_API_NAME', l_api_name);
234: FND_MSG_PUB.add;
235: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

228: WHEN OTHERS THEN
229: ROLLBACK TO ROLE_RELATE_SP;
230: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
231: fnd_message.set_token('P_SQLCODE',SQLCODE);
232: fnd_message.set_token('P_SQLERRM',SQLERRM);
233: fnd_message.set_token('P_API_NAME', l_api_name);
234: FND_MSG_PUB.add;
235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

229: ROLLBACK TO ROLE_RELATE_SP;
230: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
231: fnd_message.set_token('P_SQLCODE',SQLCODE);
232: fnd_message.set_token('P_SQLERRM',SQLERRM);
233: fnd_message.set_token('P_API_NAME', l_api_name);
234: FND_MSG_PUB.add;
235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
237: p_data => x_msg_data);

Line 335: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');

331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: END IF;
334: ELSE
335: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');
336: FND_MSG_PUB.add;
337: RAISE fnd_api.g_exc_error;
338: END IF;
339: END IF;

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

359: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
360: p_data => x_msg_data);
361: WHEN OTHERS THEN
362: ROLLBACK TO ROLE_RELATE_SP;
363: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
364: fnd_message.set_token('P_SQLCODE',SQLCODE);
365: fnd_message.set_token('P_SQLERRM',SQLERRM);
366: fnd_message.set_token('P_API_NAME', l_api_name);
367: FND_MSG_PUB.add;

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

360: p_data => x_msg_data);
361: WHEN OTHERS THEN
362: ROLLBACK TO ROLE_RELATE_SP;
363: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
364: fnd_message.set_token('P_SQLCODE',SQLCODE);
365: fnd_message.set_token('P_SQLERRM',SQLERRM);
366: fnd_message.set_token('P_API_NAME', l_api_name);
367: FND_MSG_PUB.add;
368: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

361: WHEN OTHERS THEN
362: ROLLBACK TO ROLE_RELATE_SP;
363: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
364: fnd_message.set_token('P_SQLCODE',SQLCODE);
365: fnd_message.set_token('P_SQLERRM',SQLERRM);
366: fnd_message.set_token('P_API_NAME', l_api_name);
367: FND_MSG_PUB.add;
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

362: ROLLBACK TO ROLE_RELATE_SP;
363: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
364: fnd_message.set_token('P_SQLCODE',SQLCODE);
365: fnd_message.set_token('P_SQLERRM',SQLERRM);
366: fnd_message.set_token('P_API_NAME', l_api_name);
367: FND_MSG_PUB.add;
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
370: p_data => x_msg_data);

Line 460: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');

456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: END IF;
458: END IF;
459: ELSE
460: fnd_message.set_name ('JTF', 'JTF_RS_OBJECT_VER_ERR');
461: FND_MSG_PUB.add;
462: RAISE fnd_api.g_exc_error;
463: END IF;
464: END IF;

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

484: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
485: p_data => x_msg_data);
486: WHEN OTHERS THEN
487: ROLLBACK TO ROLE_RELATE_SP;
488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
489: fnd_message.set_token('P_SQLCODE',SQLCODE);
490: fnd_message.set_token('P_SQLERRM',SQLERRM);
491: fnd_message.set_token('P_API_NAME', l_api_name);
492: FND_MSG_PUB.add;

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

485: p_data => x_msg_data);
486: WHEN OTHERS THEN
487: ROLLBACK TO ROLE_RELATE_SP;
488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
489: fnd_message.set_token('P_SQLCODE',SQLCODE);
490: fnd_message.set_token('P_SQLERRM',SQLERRM);
491: fnd_message.set_token('P_API_NAME', l_api_name);
492: FND_MSG_PUB.add;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

486: WHEN OTHERS THEN
487: ROLLBACK TO ROLE_RELATE_SP;
488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
489: fnd_message.set_token('P_SQLCODE',SQLCODE);
490: fnd_message.set_token('P_SQLERRM',SQLERRM);
491: fnd_message.set_token('P_API_NAME', l_api_name);
492: FND_MSG_PUB.add;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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

487: ROLLBACK TO ROLE_RELATE_SP;
488: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
489: fnd_message.set_token('P_SQLCODE',SQLCODE);
490: fnd_message.set_token('P_SQLERRM',SQLERRM);
491: fnd_message.set_token('P_API_NAME', l_api_name);
492: FND_MSG_PUB.add;
493: x_return_status := fnd_api.g_ret_sts_unexp_error;
494: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
495: p_data => x_msg_data);