DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_UTL_PUB dependencies on FND_MSG_PUB

Line 166: FND_MSG_PUB.Initialize;

162: l_return_status := fnd_api.g_ret_sts_success;
163: l_count := 0;
164: IF FND_API.To_boolean(P_INIT_MSG_LIST)
165: THEN
166: FND_MSG_PUB.Initialize;
167: END IF;
168: open term_res_cur(p_resource_id);
169: fetch term_res_cur into term_res_rec;
170: if(term_res_cur%found)

Line 325: fnd_msg_pub.add;

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;
329: CLOSE res_srp_terr_dup_cur;

Line 447: fnd_msg_pub.add;

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:
451: end if; -- end of term_res_cur

Line 455: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

451: end if; -- end of term_res_cur
452:
453: close term_res_cur;
454:
455: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
456: --Bug#8915500
457: --Status in local varaible assigned to Out parameter.
458: x_return_status := l_return_status;
459:

Line 465: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

461: WHEN fnd_api.g_exc_unexpected_error
462: THEN
463: ROLLBACK TO res_save;
464: x_return_status := fnd_api.g_ret_sts_error;
465: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
466: WHEN fnd_api.g_exc_error
467: THEN
468: ROLLBACK TO res_save;
469: x_return_status := fnd_api.g_ret_sts_error;

Line 470: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

466: WHEN fnd_api.g_exc_error
467: THEN
468: ROLLBACK TO res_save;
469: x_return_status := fnd_api.g_ret_sts_error;
470: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
471:
472: WHEN OTHERS
473: THEN
474: ROLLBACK TO res_save;

Line 479: FND_MSG_PUB.add;

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;
483:

Line 481: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
483:
484: PROCEDURE add_message
485: (P_API_VERSION IN NUMBER,

Line 500: FND_MSG_PUB.Initialize;

496: l_api_name VARCHAR2(30);
497: BEGIN
498: l_api_name := 'ADD_MESSAGE';
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))

Line 512: FND_MSG_PUB.add;

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;
515:
516: EXCEPTION

Line 513: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
515:
516: EXCEPTION
517: WHEN OTHERS

Line 523: FND_MSG_PUB.add;

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:
527: END add_message ;

Line 525: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
527: END add_message ;
528:
529: /* Function to check if user has resource update access */

Line 840: FND_MSG_PUB.Initialize;

836: l_return_status := fnd_api.g_ret_sts_success;
837:
838: IF FND_API.To_boolean(P_INIT_MSG_LIST)
839: THEN
840: FND_MSG_PUB.Initialize;
841: END IF;
842:
843: OPEN term_grp_cur(p_group_id);
844: FETCH term_grp_cur into term_grp_rec;

Line 974: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

970:
971: end if; -- end of term_grp_cur
972: close term_grp_cur;
973:
974: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
975:
976: EXCEPTION
977: WHEN fnd_api.g_exc_unexpected_error
978: THEN

Line 981: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

977: WHEN fnd_api.g_exc_unexpected_error
978: THEN
979: ROLLBACK TO group_mem_roles_save;
980: x_return_status := fnd_api.g_ret_sts_error;
981: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
982: WHEN fnd_api.g_exc_error
983: THEN
984: ROLLBACK TO group_mem_roles_save;
985: x_return_status := fnd_api.g_ret_sts_error;

Line 986: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

982: WHEN fnd_api.g_exc_error
983: THEN
984: ROLLBACK TO group_mem_roles_save;
985: x_return_status := fnd_api.g_ret_sts_error;
986: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
987:
988: WHEN OTHERS
989: THEN
990: ROLLBACK TO group_mem_roles_save;

Line 995: FND_MSG_PUB.add;

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:
999: END end_date_group;

Line 997: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
999: END end_date_group;
1000:
1001: /* returns 'Y' for Yes and 'N' for No */