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;
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;
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;
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);
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;
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))
493: then
494: fnd_message.set_token (p_token1_name, p_token1_value);
495: end if;
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))
493: then
494: fnd_message.set_token (p_token1_name, p_token1_value);
495: end if;
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);
494: fnd_message.set_token (p_token1_name, p_token1_value);
495: end if;
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
505: WHEN OTHERS
506: THEN
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;
504: EXCEPTION
505: WHEN OTHERS
506: THEN
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;
505: WHEN OTHERS
506: THEN
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);
506: THEN
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:
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;
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;
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);
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: