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 463: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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;

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

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;

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

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);

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

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;

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

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;

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

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);

Line 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;

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

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;

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

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;

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

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);

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

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:

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

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;

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

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;

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

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);

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

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: