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)
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;
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
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;
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;
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:
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,
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))
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
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
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 ;
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 */
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;
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
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;
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;
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;
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 */