APPS.JTF_TERR_NA_MERGE_PUB dependencies on FND_API

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: x_return_status OUT NOCOPY VARCHAR2 )
181: IS
182:
183: BEGIN
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: END party_merge;
186:
187:
188: /* ---------------------------- PARTY SITE MERGE ------------------------

Line 258: x_return_status := fnd_api.g_ret_sts_success;

254: x_to_id := p_from_id;
255: RETURN;
256: END IF;
257:
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');

Line 267: x_return_status := fnd_api.g_ret_sts_error;

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;
269: END IF;
270:
271: -- dbms_output.put_line (' Inside Party Site Merge ');

Line 268: RAISE fnd_api.g_exc_error;

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;
269: END IF;
270:
271: -- dbms_output.put_line (' Inside Party Site Merge ');
272:

Line 570: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

566: AND party_site_id = p_from_fk_id;
567:
568: END IF; -- end from_na_flag = 'Y'
569:
570: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
571: RAISE fnd_api.g_exc_error;
572: END IF;
573:
574: FND_FILE.PUT_LINE(FND_FILE.LOG,'JTY PARTY SITE MERGE END: '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

Line 571: RAISE fnd_api.g_exc_error;

567:
568: END IF; -- end from_na_flag = 'Y'
569:
570: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
571: RAISE fnd_api.g_exc_error;
572: END IF;
573:
574: FND_FILE.PUT_LINE(FND_FILE.LOG,'JTY PARTY SITE MERGE END: '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
575:

Line 578: WHEN fnd_api.g_exc_error THEN

574: FND_FILE.PUT_LINE(FND_FILE.LOG,'JTY PARTY SITE MERGE END: '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
575:
576: EXCEPTION
577:
578: WHEN fnd_api.g_exc_error THEN
579: x_return_status := fnd_api.g_ret_sts_error;
580: -- ROLLBACK TO TERR_NA_PARTY_MERGE_PUB;
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'JTY PARTY SITE MERGE END: '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
582: RAISE;

Line 579: x_return_status := fnd_api.g_ret_sts_error;

575:
576: EXCEPTION
577:
578: WHEN fnd_api.g_exc_error THEN
579: x_return_status := fnd_api.g_ret_sts_error;
580: -- ROLLBACK TO TERR_NA_PARTY_MERGE_PUB;
581: FND_FILE.PUT_LINE(FND_FILE.LOG,'JTY PARTY SITE MERGE END: '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
582: RAISE;
583:

Line 590: x_return_status := fnd_api.g_ret_sts_unexp_error;

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'));
593: RAISE;
594: END party_site_merge;