APPS.PA_MERGE_PKG dependencies on FND_API

Line 24: x_return_status := fnd_api.g_ret_sts_error;

20: -- ready to merge Project entities. So if a party_id referenced in projects
21: -- is merged, we reject it. This API will be enhanced immediately after
22: -- 11.5.9 to support the merge.
23:
24: x_return_status := fnd_api.g_ret_sts_error;
25:
26: fnd_message.set_name ('PA', 'PA_REJECT_MERGE');
27: FND_MSG_PUB.add;
28:

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS;

39: p_batch_party_id IN NUMBER,
40: x_return_status OUT NOCOPY VARCHAR2)
41: IS
42: BEGIN
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44:
45: IF (p_from_fk_id <> p_to_fk_id) THEN
46: UPDATE pa_control_items
47: SET owner_id = p_to_fk_id

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: p_batch_party_id IN NUMBER,
64: x_return_status OUT NOCOPY VARCHAR2)
65: IS
66: BEGIN
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: IF (p_from_fk_id <> p_to_fk_id) THEN
70: UPDATE pa_control_items
71: SET last_modified_by_id = p_to_fk_id

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87: p_batch_party_id IN NUMBER,
88: x_return_status OUT NOCOPY VARCHAR2)
89: IS
90: BEGIN
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: IF (p_from_fk_id <> p_to_fk_id) THEN
94: UPDATE pa_control_items
95: SET closed_by_id = p_to_fk_id

Line 115: x_return_status := FND_API.G_RET_STS_SUCCESS;

111: p_batch_party_id IN NUMBER,
112: x_return_status OUT NOCOPY VARCHAR2)
113: IS
114: BEGIN
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:
117: IF (p_from_fk_id <> p_to_fk_id) THEN
118: UPDATE pa_ci_actions
119: SET assigned_to = p_to_fk_id

Line 140: x_return_status := FND_API.G_RET_STS_SUCCESS;

136: x_return_status OUT NOCOPY VARCHAR2)
137: IS
138: l_dummy NUMBER;
139: BEGIN
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141:
142: IF (p_from_fk_id <> p_to_fk_id) THEN
143: UPDATE pa_ci_impacts
144: SET implemented_by = p_to_fk_id

Line 165: x_return_status := FND_API.G_RET_STS_SUCCESS;

161: x_return_status OUT NOCOPY VARCHAR2)
162: IS
163: l_dummy NUMBER;
164: BEGIN
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: IF (p_from_fk_id <> p_to_fk_id) THEN
168: BEGIN
169: --Looking for a grant from PA for the party being merged

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: AND g.grantee_key = 'HZ_PARTY:'||p_from_fk_id
177: AND ROWNUM = 1;
178:
179: --Veto if grant is found for the same party, because grants are not yet merged
180: x_return_status := FND_API.G_RET_STS_ERROR;
181:
182: FND_MESSAGE.SET_NAME('PA', 'PA_REJECT_MERGE');
183: FND_MSG_PUB.add;
184:

Line 204: x_return_status := FND_API.G_RET_STS_SUCCESS;

200: p_to_resource_id IN NUMBER,
201: x_return_status OUT NOCOPY VARCHAR2)
202: IS
203: BEGIN
204: x_return_status := FND_API.G_RET_STS_SUCCESS;
205:
206: IF (p_from_resource_id <> p_to_resource_id) THEN
207: UPDATE pa_project_parties
208: SET resource_id = p_to_resource_id