DBA Data[Home] [Help]

APPS.JTF_TERR_NA_MERGE_PUB dependencies on FND_MESSAGE

Line 262: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');

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:

Line 263: fnd_message.set_token('P_ENTITY',p_entity_name);

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;

Line 264: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

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;

Line 585: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

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

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;

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

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;

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

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