APPS.RRS_PARTY_MERGE_PKG dependencies on FND_API

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS;

39: l_to_sites NUMBER;
40: l_sites_external NUMBER;
41: BEGIN
42:
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44: IF (p_from_fk_id <> p_to_fk_id) THEN
45: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
46:
47: OPEN c_sites(p_from_fk_id,'I');

Line 50: x_return_status := FND_API.G_RET_STS_ERROR;

46:
47: OPEN c_sites(p_from_fk_id,'I');
48: FETCH c_sites into l_from_sites;
49: IF ( c_sites%FOUND ) THEN
50: x_return_status := FND_API.G_RET_STS_ERROR;
51: FND_MESSAGE.SET_NAME('RRS','RRS_SITE_NO_FROM_MERGE');
52: FND_MSG_PUB.ADD;
53: END IF;
54: CLOSE c_sites;

Line 62: x_return_status := FND_API.G_RET_STS_ERROR;

58: it is done in the merge API registered by that particular product.*/
59: /*OPEN c_sites(p_to_fk_id,'I');
60: FETCH c_sites into l_to_sites;
61: IF ( c_sites%FOUND) THEN
62: x_return_status := FND_API.G_RET_STS_ERROR;
63: FND_MESSAGE.SET_NAME('RRS','RRS_SITE_NO_TO_MERGE');
64: FND_MSG_PUB.ADD;
65: END IF;
66: CLOSE c_sites;*/

Line 87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

83: EXCEPTION WHEN OTHERS THEN
84: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
85: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
86: FND_MSG_PUB.ADD;
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88:
89: END MERGE_SITE_PARTY;
90: --========================================================================
91: -- PROCEDURE :merge_le_party

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: l_from_site_num NUMBER;
125:
126: BEGIN
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: IF (p_from_fk_id <> p_to_fk_id) THEN
131: IF (p_parent_entity_name = 'HZ_PARTIES') THEN
132:

Line 151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

147: WHEN others THEN
148: FND_MESSAGE.SET_NAME('AR','HZ_API_OTHERS_EXCEP');
149: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
150: FND_MSG_PUB.ADD;
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: END MERGE_LE_PARTY;
153:
154: END RRS_PARTY_MERGE_PKG;