DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_MEMBERS_PUB dependencies on FND_MESSAGE

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

176:
177: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
178:
179: ROLLBACK TO create_resource_member_pub;
180: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
181: fnd_message.set_token('P_SQLCODE',SQLCODE);
182: fnd_message.set_token('P_SQLERRM',SQLERRM);
183: fnd_message.set_token('P_API_NAME',l_api_name);
184: FND_MSG_PUB.add;

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

177: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
178:
179: ROLLBACK TO create_resource_member_pub;
180: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
181: fnd_message.set_token('P_SQLCODE',SQLCODE);
182: fnd_message.set_token('P_SQLERRM',SQLERRM);
183: fnd_message.set_token('P_API_NAME',l_api_name);
184: FND_MSG_PUB.add;
185:

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

178:
179: ROLLBACK TO create_resource_member_pub;
180: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
181: fnd_message.set_token('P_SQLCODE',SQLCODE);
182: fnd_message.set_token('P_SQLERRM',SQLERRM);
183: fnd_message.set_token('P_API_NAME',l_api_name);
184: FND_MSG_PUB.add;
185:
186: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

179: ROLLBACK TO create_resource_member_pub;
180: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
181: fnd_message.set_token('P_SQLCODE',SQLCODE);
182: fnd_message.set_token('P_SQLERRM',SQLERRM);
183: fnd_message.set_token('P_API_NAME',l_api_name);
184: FND_MSG_PUB.add;
185:
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187:

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

352:
353: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
354:
355: ROLLBACK TO update_resource_member_pub;
356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
357: fnd_message.set_token('P_SQLCODE',SQLCODE);
358: fnd_message.set_token('P_SQLERRM',SQLERRM);
359: fnd_message.set_token('P_API_NAME',l_api_name);
360: FND_MSG_PUB.add;

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

353: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
354:
355: ROLLBACK TO update_resource_member_pub;
356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
357: fnd_message.set_token('P_SQLCODE',SQLCODE);
358: fnd_message.set_token('P_SQLERRM',SQLERRM);
359: fnd_message.set_token('P_API_NAME',l_api_name);
360: FND_MSG_PUB.add;
361:

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

354:
355: ROLLBACK TO update_resource_member_pub;
356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
357: fnd_message.set_token('P_SQLCODE',SQLCODE);
358: fnd_message.set_token('P_SQLERRM',SQLERRM);
359: fnd_message.set_token('P_API_NAME',l_api_name);
360: FND_MSG_PUB.add;
361:
362: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

355: ROLLBACK TO update_resource_member_pub;
356: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
357: fnd_message.set_token('P_SQLCODE',SQLCODE);
358: fnd_message.set_token('P_SQLERRM',SQLERRM);
359: fnd_message.set_token('P_API_NAME',l_api_name);
360: FND_MSG_PUB.add;
361:
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363:

Line 465: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');

461:
462: IF p_resource_id IS NULL AND p_resource_number is NULL THEN
463:
464:
465: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
466: fnd_msg_pub.add;
467:
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: RAISE fnd_api.g_exc_unexpected_error;

Line 482: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');

478: IF c_resource_id%NOTFOUND THEN
479:
480: -- dbms_output.put_line('Invalid or Inactive Resource');
481:
482: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
483: fnd_message.set_token('P_RESOURCE_ID', p_resource_id);
484: fnd_msg_pub.add;
485:
486: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 483: fnd_message.set_token('P_RESOURCE_ID', p_resource_id);

479:
480: -- dbms_output.put_line('Invalid or Inactive Resource');
481:
482: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
483: fnd_message.set_token('P_RESOURCE_ID', p_resource_id);
484: fnd_msg_pub.add;
485:
486: x_return_status := fnd_api.g_ret_sts_unexp_error;
487: RAISE fnd_api.g_exc_unexpected_error;

Line 502: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');

498:
499: IF c_resource_number%NOTFOUND THEN
500:
501:
502: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');
503: fnd_message.set_token('P_RESOURCE_NUMBER', p_resource_number);
504: fnd_msg_pub.add;
505:
506: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 503: fnd_message.set_token('P_RESOURCE_NUMBER', p_resource_number);

499: IF c_resource_number%NOTFOUND THEN
500:
501:
502: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE_NUMBER');
503: fnd_message.set_token('P_RESOURCE_NUMBER', p_resource_number);
504: fnd_msg_pub.add;
505:
506: x_return_status := fnd_api.g_ret_sts_unexp_error;
507: RAISE fnd_api.g_exc_unexpected_error;

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

571:
572: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
573:
574: ROLLBACK TO delete_resource_member_pub;
575: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
576: fnd_message.set_token('P_SQLCODE',SQLCODE);
577: fnd_message.set_token('P_SQLERRM',SQLERRM);
578: fnd_message.set_token('P_API_NAME',l_api_name);
579: FND_MSG_PUB.add;

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

572: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
573:
574: ROLLBACK TO delete_resource_member_pub;
575: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
576: fnd_message.set_token('P_SQLCODE',SQLCODE);
577: fnd_message.set_token('P_SQLERRM',SQLERRM);
578: fnd_message.set_token('P_API_NAME',l_api_name);
579: FND_MSG_PUB.add;
580:

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

573:
574: ROLLBACK TO delete_resource_member_pub;
575: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
576: fnd_message.set_token('P_SQLCODE',SQLCODE);
577: fnd_message.set_token('P_SQLERRM',SQLERRM);
578: fnd_message.set_token('P_API_NAME',l_api_name);
579: FND_MSG_PUB.add;
580:
581: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

574: ROLLBACK TO delete_resource_member_pub;
575: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
576: fnd_message.set_token('P_SQLCODE',SQLCODE);
577: fnd_message.set_token('P_SQLERRM',SQLERRM);
578: fnd_message.set_token('P_API_NAME',l_api_name);
579: FND_MSG_PUB.add;
580:
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
582: