97: WHEN OTHERS THEN
98: ROLLBACK TO Insert_Chng_Partner_Row;
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100:
101: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
102: THEN
103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
104: END IF;
105:
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100:
101: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
102: THEN
103: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
104: END IF;
105:
106: END Insert_Row;
107:
170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
171: ROLLBACK TO Update_Chng_Partner_Row;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
177: END IF;
178:
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173:
174: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
177: END IF;
178:
179: WHEN OTHERS THEN
180: ROLLBACK TO Update_Chng_Partner_Row;
179: WHEN OTHERS THEN
180: ROLLBACK TO Update_Chng_Partner_Row;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
184: THEN
185: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
186: END IF;
187:
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
184: THEN
185: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
186: END IF;
187:
188: END Update_Row;
189:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO Delete_Chng_Partner_Row;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229:
230: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
233: END IF;
234:
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229:
230: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
233: END IF;
234:
235: WHEN OTHERS THEN
236: ROLLBACK TO Delete_Chng_Partner_Row;
235: WHEN OTHERS THEN
236: ROLLBACK TO Delete_Chng_Partner_Row;
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238:
239: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
242: END IF;
243:
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238:
239: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
240: THEN
241: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
242: END IF;
243:
244: END Delete_Row ;
245:
293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
294: ROLLBACK TO Lock_Chng_Partner_Row;
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296:
297: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
300: END IF;
301: WHEN OTHERS THEN
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296:
297: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
300: END IF;
301: WHEN OTHERS THEN
302: ROLLBACK TO Lock_Chng_Partner_Row;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
301: WHEN OTHERS THEN
302: ROLLBACK TO Lock_Chng_Partner_Row;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304:
305: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
306: THEN
307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
308: END IF;
309:
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304:
305: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
306: THEN
307: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
308: END IF;
309:
310: END Lock_Row;
311: