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 446: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

442: end if; -- end of term_res_cur
443:
444: close term_res_cur;
445:
446: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
447:
448: EXCEPTION
449: WHEN fnd_api.g_exc_unexpected_error
450: THEN

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

449: WHEN fnd_api.g_exc_unexpected_error
450: THEN
451: ROLLBACK TO res_save;
452: x_return_status := fnd_api.g_ret_sts_error;
453: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
454: WHEN fnd_api.g_exc_error
455: THEN
456: ROLLBACK TO res_save;
457: x_return_status := fnd_api.g_ret_sts_error;

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

454: WHEN fnd_api.g_exc_error
455: THEN
456: ROLLBACK TO res_save;
457: x_return_status := fnd_api.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
459:
460: WHEN OTHERS
461: THEN
462: ROLLBACK TO res_save;

Line 467: FND_MSG_PUB.add;

463: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
464: fnd_message.set_token('P_SQLCODE',SQLCODE);
465: fnd_message.set_token('P_SQLERRM',SQLERRM);
466: fnd_message.set_token('P_API_NAME',l_api_name);
467: FND_MSG_PUB.add;
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
470: END end_date_employee;
471:

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

465: fnd_message.set_token('P_SQLERRM',SQLERRM);
466: fnd_message.set_token('P_API_NAME',l_api_name);
467: FND_MSG_PUB.add;
468: x_return_status := fnd_api.g_ret_sts_unexp_error;
469: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
470: END end_date_employee;
471:
472: PROCEDURE add_message
473: (P_API_VERSION IN NUMBER,

Line 488: FND_MSG_PUB.Initialize;

484: l_api_name VARCHAR2(30);
485: BEGIN
486: l_api_name := 'ADD_MESSAGE';
487: x_return_status := fnd_api.g_ret_sts_success;
488: FND_MSG_PUB.Initialize;
489: if(P_MESSAGE_CODE is not null)
490: then
491: fnd_message.set_name ('JTF', p_message_code);
492: if((P_TOKEN1_NAME is not null) OR (P_TOKEN1_NAME <> fnd_api.g_miss_char))

Line 500: FND_MSG_PUB.add;

496: if((P_TOKEN2_NAME is not null) OR (P_TOKEN2_NAME <> fnd_api.g_miss_char))
497: then
498: fnd_message.set_token (p_token2_name, p_token2_value);
499: end if;
500: FND_MSG_PUB.add;
501: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
502: end if;
503:
504: EXCEPTION

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

497: then
498: fnd_message.set_token (p_token2_name, p_token2_value);
499: end if;
500: FND_MSG_PUB.add;
501: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
502: end if;
503:
504: EXCEPTION
505: WHEN OTHERS

Line 511: FND_MSG_PUB.add;

507: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
508: fnd_message.set_token('P_SQLCODE',SQLCODE);
509: fnd_message.set_token('P_SQLERRM',SQLERRM);
510: fnd_message.set_token('P_API_NAME',l_api_name);
511: FND_MSG_PUB.add;
512: x_return_status := fnd_api.g_ret_sts_unexp_error;
513: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
514:
515: END add_message ;

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

509: fnd_message.set_token('P_SQLERRM',SQLERRM);
510: fnd_message.set_token('P_API_NAME',l_api_name);
511: FND_MSG_PUB.add;
512: x_return_status := fnd_api.g_ret_sts_unexp_error;
513: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
514:
515: END add_message ;
516:
517: /* Function to check if user has resource update access */

Line 828: FND_MSG_PUB.Initialize;

824: l_return_status := fnd_api.g_ret_sts_success;
825:
826: IF FND_API.To_boolean(P_INIT_MSG_LIST)
827: THEN
828: FND_MSG_PUB.Initialize;
829: END IF;
830:
831: OPEN term_grp_cur(p_group_id);
832: FETCH term_grp_cur into term_grp_rec;

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

958:
959: end if; -- end of term_grp_cur
960: close term_grp_cur;
961:
962: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
963:
964: EXCEPTION
965: WHEN fnd_api.g_exc_unexpected_error
966: THEN

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

965: WHEN fnd_api.g_exc_unexpected_error
966: THEN
967: ROLLBACK TO group_mem_roles_save;
968: x_return_status := fnd_api.g_ret_sts_error;
969: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
970: WHEN fnd_api.g_exc_error
971: THEN
972: ROLLBACK TO group_mem_roles_save;
973: x_return_status := fnd_api.g_ret_sts_error;

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

970: WHEN fnd_api.g_exc_error
971: THEN
972: ROLLBACK TO group_mem_roles_save;
973: x_return_status := fnd_api.g_ret_sts_error;
974: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
975:
976: WHEN OTHERS
977: THEN
978: ROLLBACK TO group_mem_roles_save;

Line 983: FND_MSG_PUB.add;

979: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
980: fnd_message.set_token('P_SQLCODE',SQLCODE);
981: fnd_message.set_token('P_SQLERRM',SQLERRM);
982: fnd_message.set_token('P_API_NAME',l_api_name);
983: FND_MSG_PUB.add;
984: x_return_status := fnd_api.g_ret_sts_unexp_error;
985: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
986:
987: END end_date_group;

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

981: fnd_message.set_token('P_SQLERRM',SQLERRM);
982: fnd_message.set_token('P_API_NAME',l_api_name);
983: FND_MSG_PUB.add;
984: x_return_status := fnd_api.g_ret_sts_unexp_error;
985: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
986:
987: END end_date_group;
988:
989: /* returns 'Y' for Yes and 'N' for No */