258: x_return_status := fnd_api.g_ret_sts_success;
259:
260: IF ( p_entity_name <> 'JTF_TTY_NAMED_ACCTS' OR p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG,' Entity error');
262: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
263: fnd_message.set_token('P_ENTITY',p_entity_name);
264: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
265: FND_MSG_PUB.add;
266:
259:
260: IF ( p_entity_name <> 'JTF_TTY_NAMED_ACCTS' OR p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG,' Entity error');
262: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
263: fnd_message.set_token('P_ENTITY',p_entity_name);
264: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
265: FND_MSG_PUB.add;
266:
267: x_return_status := fnd_api.g_ret_sts_error;
260: IF ( p_entity_name <> 'JTF_TTY_NAMED_ACCTS' OR p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG,' Entity error');
262: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
263: fnd_message.set_token('P_ENTITY',p_entity_name);
264: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);
265: FND_MSG_PUB.add;
266:
267: x_return_status := fnd_api.g_ret_sts_error;
268: RAISE fnd_api.g_exc_error;
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'JTY PARTY SITE MERGE END: '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
582: RAISE;
583:
584: WHEN OTHERS THEN
585: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
586: fnd_message.set_token('P_SQLCODE', SQLCODE);
587: fnd_message.set_token('P_SQLERRM', SQLERRM);
588: fnd_message.set_token('P_API_NAME', l_api_name);
589: FND_MSG_PUB.add;
582: RAISE;
583:
584: WHEN OTHERS THEN
585: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
586: fnd_message.set_token('P_SQLCODE', SQLCODE);
587: fnd_message.set_token('P_SQLERRM', SQLERRM);
588: fnd_message.set_token('P_API_NAME', l_api_name);
589: FND_MSG_PUB.add;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
583:
584: WHEN OTHERS THEN
585: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
586: fnd_message.set_token('P_SQLCODE', SQLCODE);
587: fnd_message.set_token('P_SQLERRM', SQLERRM);
588: fnd_message.set_token('P_API_NAME', l_api_name);
589: FND_MSG_PUB.add;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: -- ROLLBACK TO TERR_NA_PARTY_MERGE_PUB;
584: WHEN OTHERS THEN
585: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
586: fnd_message.set_token('P_SQLCODE', SQLCODE);
587: fnd_message.set_token('P_SQLERRM', SQLERRM);
588: fnd_message.set_token('P_API_NAME', l_api_name);
589: FND_MSG_PUB.add;
590: x_return_status := fnd_api.g_ret_sts_unexp_error;
591: -- ROLLBACK TO TERR_NA_PARTY_MERGE_PUB;
592: FND_FILE.PUT_LINE(FND_FILE.LOG,'JTY PARTY SITE MERGE END: '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));