44: RESOURCE_BUSY EXCEPTION;
45: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
46:
47: BEGIN
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49:
50: -- 1. Do all Validations
51:
52: -- Check the Merge reason. If Merge Reason is Duplicate Record then no validation is performed. Otherwise check if the resource is being used somewhere.
92: when others then
93: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARTY_MERGE_API_EXCEP');
94: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
95: FND_MSG_PUB.ADD;
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: raise;
98: end;
99: end if;
100: END mo_merge_party_site;
119: RESOURCE_BUSY EXCEPTION;
120: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
121:
122: BEGIN
123: x_return_status := FND_API.G_RET_STS_SUCCESS;
124:
125: -- 1. Do all Validations
126:
127: -- Check the Merge reason. If Merge Reason is Duplicate Record then no validation is performed. Otherwise check if the resource is being used somewhere.
167: when others then
168: FND_MESSAGE.SET_NAME('CSP', 'CSP_PARTY_MERGE_API_EXCEP');
169: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
170: FND_MSG_PUB.ADD;
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: raise;
173: end;
174: end if;
175: END pl_merge_party_site;