38: WHERE party_id = p_from_fk_id;
39:
40: EXCEPTION
41: WHEN OTHERS THEN
42: FND_MESSAGE.SET_NAME('OKE', 'OKE_CONTRACTS_UNEXPECTED_ERROR');
43: FND_MESSAGE.SET_TOKEN('SQLcode', SQLCODE);
44: FND_MESSAGE.SET_TOKEN('SQLerrm', SQLERRM);
45: FND_MSG_PUB.add;
46: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
39:
40: EXCEPTION
41: WHEN OTHERS THEN
42: FND_MESSAGE.SET_NAME('OKE', 'OKE_CONTRACTS_UNEXPECTED_ERROR');
43: FND_MESSAGE.SET_TOKEN('SQLcode', SQLCODE);
44: FND_MESSAGE.SET_TOKEN('SQLerrm', SQLERRM);
45: FND_MSG_PUB.add;
46: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
47:
40: EXCEPTION
41: WHEN OTHERS THEN
42: FND_MESSAGE.SET_NAME('OKE', 'OKE_CONTRACTS_UNEXPECTED_ERROR');
43: FND_MESSAGE.SET_TOKEN('SQLcode', SQLCODE);
44: FND_MESSAGE.SET_TOKEN('SQLerrm', SQLERRM);
45: FND_MSG_PUB.add;
46: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
47:
48: END pool_party_merge;
83: WHERE k_party_id = p_from_fk_id;
84:
85: EXCEPTION
86: WHEN OTHERS THEN
87: FND_MESSAGE.SET_NAME('OKE', 'OKE_CONTRACTS_UNEXPECTED_ERROR');
88: FND_MESSAGE.SET_TOKEN('SQLcode', SQLCODE);
89: FND_MESSAGE.SET_TOKEN('SQLerrm', SQLERRM);
90: FND_MSG_PUB.add;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
84:
85: EXCEPTION
86: WHEN OTHERS THEN
87: FND_MESSAGE.SET_NAME('OKE', 'OKE_CONTRACTS_UNEXPECTED_ERROR');
88: FND_MESSAGE.SET_TOKEN('SQLcode', SQLCODE);
89: FND_MESSAGE.SET_TOKEN('SQLerrm', SQLERRM);
90: FND_MSG_PUB.add;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92:
85: EXCEPTION
86: WHEN OTHERS THEN
87: FND_MESSAGE.SET_NAME('OKE', 'OKE_CONTRACTS_UNEXPECTED_ERROR');
88: FND_MESSAGE.SET_TOKEN('SQLcode', SQLCODE);
89: FND_MESSAGE.SET_TOKEN('SQLerrm', SQLERRM);
90: FND_MSG_PUB.add;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92:
93: END funding_party_merge;
128: WHERE k_party_id = p_from_fk_id;
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: FND_MESSAGE.SET_NAME('OKE', 'OKE_CONTRACTS_UNEXPECTED_ERROR');
133: FND_MESSAGE.SET_TOKEN('SQLcode', SQLCODE);
134: FND_MESSAGE.SET_TOKEN('SQLerrm', SQLERRM);
135: FND_MSG_PUB.add;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: FND_MESSAGE.SET_NAME('OKE', 'OKE_CONTRACTS_UNEXPECTED_ERROR');
133: FND_MESSAGE.SET_TOKEN('SQLcode', SQLCODE);
134: FND_MESSAGE.SET_TOKEN('SQLerrm', SQLERRM);
135: FND_MSG_PUB.add;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137:
130: EXCEPTION
131: WHEN OTHERS THEN
132: FND_MESSAGE.SET_NAME('OKE', 'OKE_CONTRACTS_UNEXPECTED_ERROR');
133: FND_MESSAGE.SET_TOKEN('SQLcode', SQLCODE);
134: FND_MESSAGE.SET_TOKEN('SQLerrm', SQLERRM);
135: FND_MSG_PUB.add;
136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
137:
138: END funding_party_h_merge;