DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on FND_MESSAGE

Line 324: fnd_message.set_name ('JTF','JTF_RS_DUP_TERR');

320: res_srp_terr_rec.territory_id,
321: res_srp_terr_rec.salesrep_territory_id);
322: fetch res_srp_terr_dup_cur INTO res_srp_terr_dup_rec;
323: IF res_srp_terr_dup_cur%FOUND THEN
324: fnd_message.set_name ('JTF','JTF_RS_DUP_TERR');
325: fnd_msg_pub.add;
326: CLOSE res_srp_terr_dup_cur;
327: raise fnd_api.g_exc_error;
328: END IF;

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

441: --Bug9009376
442: --When No Data Found against Resource Id then
443: --raising an error.
444: else -- else block of term_res_cur
445: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
446: fnd_message.set_token('P_RESOURCE_ID', p_resource_id);
447: fnd_msg_pub.add;
448:
449: RAISE fnd_api.g_exc_error;

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

442: --When No Data Found against Resource Id then
443: --raising an error.
444: else -- else block of term_res_cur
445: fnd_message.set_name('JTF', 'JTF_RS_INVALID_RESOURCE');
446: fnd_message.set_token('P_RESOURCE_ID', p_resource_id);
447: fnd_msg_pub.add;
448:
449: RAISE fnd_api.g_exc_error;
450:

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

471:
472: WHEN OTHERS
473: THEN
474: ROLLBACK TO res_save;
475: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
476: fnd_message.set_token('P_SQLCODE',SQLCODE);
477: fnd_message.set_token('P_SQLERRM',SQLERRM);
478: fnd_message.set_token('P_API_NAME',l_api_name);
479: FND_MSG_PUB.add;

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

472: WHEN OTHERS
473: THEN
474: ROLLBACK TO res_save;
475: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
476: fnd_message.set_token('P_SQLCODE',SQLCODE);
477: fnd_message.set_token('P_SQLERRM',SQLERRM);
478: fnd_message.set_token('P_API_NAME',l_api_name);
479: FND_MSG_PUB.add;
480: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

473: THEN
474: ROLLBACK TO res_save;
475: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
476: fnd_message.set_token('P_SQLCODE',SQLCODE);
477: fnd_message.set_token('P_SQLERRM',SQLERRM);
478: fnd_message.set_token('P_API_NAME',l_api_name);
479: FND_MSG_PUB.add;
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
481: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

474: ROLLBACK TO res_save;
475: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
476: fnd_message.set_token('P_SQLCODE',SQLCODE);
477: fnd_message.set_token('P_SQLERRM',SQLERRM);
478: fnd_message.set_token('P_API_NAME',l_api_name);
479: FND_MSG_PUB.add;
480: x_return_status := fnd_api.g_ret_sts_unexp_error;
481: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
482: END end_date_employee;

Line 503: fnd_message.set_name ('JTF', p_message_code);

499: x_return_status := fnd_api.g_ret_sts_success;
500: FND_MSG_PUB.Initialize;
501: if(P_MESSAGE_CODE is not null)
502: then
503: fnd_message.set_name ('JTF', p_message_code);
504: if((P_TOKEN1_NAME is not null) OR (P_TOKEN1_NAME <> fnd_api.g_miss_char))
505: then
506: fnd_message.set_token (p_token1_name, p_token1_value);
507: end if;

Line 506: fnd_message.set_token (p_token1_name, p_token1_value);

502: then
503: fnd_message.set_name ('JTF', p_message_code);
504: if((P_TOKEN1_NAME is not null) OR (P_TOKEN1_NAME <> fnd_api.g_miss_char))
505: then
506: fnd_message.set_token (p_token1_name, p_token1_value);
507: end if;
508: if((P_TOKEN2_NAME is not null) OR (P_TOKEN2_NAME <> fnd_api.g_miss_char))
509: then
510: fnd_message.set_token (p_token2_name, p_token2_value);

Line 510: fnd_message.set_token (p_token2_name, p_token2_value);

506: fnd_message.set_token (p_token1_name, p_token1_value);
507: end if;
508: if((P_TOKEN2_NAME is not null) OR (P_TOKEN2_NAME <> fnd_api.g_miss_char))
509: then
510: fnd_message.set_token (p_token2_name, p_token2_value);
511: end if;
512: FND_MSG_PUB.add;
513: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
514: end if;

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

515:
516: EXCEPTION
517: WHEN OTHERS
518: THEN
519: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
520: fnd_message.set_token('P_SQLCODE',SQLCODE);
521: fnd_message.set_token('P_SQLERRM',SQLERRM);
522: fnd_message.set_token('P_API_NAME',l_api_name);
523: FND_MSG_PUB.add;

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

516: EXCEPTION
517: WHEN OTHERS
518: THEN
519: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
520: fnd_message.set_token('P_SQLCODE',SQLCODE);
521: fnd_message.set_token('P_SQLERRM',SQLERRM);
522: fnd_message.set_token('P_API_NAME',l_api_name);
523: FND_MSG_PUB.add;
524: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

517: WHEN OTHERS
518: THEN
519: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
520: fnd_message.set_token('P_SQLCODE',SQLCODE);
521: fnd_message.set_token('P_SQLERRM',SQLERRM);
522: fnd_message.set_token('P_API_NAME',l_api_name);
523: FND_MSG_PUB.add;
524: x_return_status := fnd_api.g_ret_sts_unexp_error;
525: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

518: THEN
519: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
520: fnd_message.set_token('P_SQLCODE',SQLCODE);
521: fnd_message.set_token('P_SQLERRM',SQLERRM);
522: fnd_message.set_token('P_API_NAME',l_api_name);
523: FND_MSG_PUB.add;
524: x_return_status := fnd_api.g_ret_sts_unexp_error;
525: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
526:

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

987:
988: WHEN OTHERS
989: THEN
990: ROLLBACK TO group_mem_roles_save;
991: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
992: fnd_message.set_token('P_SQLCODE',SQLCODE);
993: fnd_message.set_token('P_SQLERRM',SQLERRM);
994: fnd_message.set_token('P_API_NAME',l_api_name);
995: FND_MSG_PUB.add;

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

988: WHEN OTHERS
989: THEN
990: ROLLBACK TO group_mem_roles_save;
991: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
992: fnd_message.set_token('P_SQLCODE',SQLCODE);
993: fnd_message.set_token('P_SQLERRM',SQLERRM);
994: fnd_message.set_token('P_API_NAME',l_api_name);
995: FND_MSG_PUB.add;
996: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

989: THEN
990: ROLLBACK TO group_mem_roles_save;
991: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
992: fnd_message.set_token('P_SQLCODE',SQLCODE);
993: fnd_message.set_token('P_SQLERRM',SQLERRM);
994: fnd_message.set_token('P_API_NAME',l_api_name);
995: FND_MSG_PUB.add;
996: x_return_status := fnd_api.g_ret_sts_unexp_error;
997: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

990: ROLLBACK TO group_mem_roles_save;
991: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
992: fnd_message.set_token('P_SQLCODE',SQLCODE);
993: fnd_message.set_token('P_SQLERRM',SQLERRM);
994: fnd_message.set_token('P_API_NAME',l_api_name);
995: FND_MSG_PUB.add;
996: x_return_status := fnd_api.g_ret_sts_unexp_error;
997: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
998: