96: WHEN OTHERS THEN
97: ROLLBACK TO Insert_PAccesses_Row;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99:
100: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
101: THEN
102: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
103: END IF;
104: END Insert_Row;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99:
100: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
101: THEN
102: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
103: END IF;
104: END Insert_Row;
105:
106: -- ========================================================
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: ROLLBACK TO Update_TAccesses_Row;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166:
167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
168: THEN
169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
170: END IF;
171:
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166:
167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
168: THEN
169: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
170: END IF;
171:
172: WHEN OTHERS THEN
173: ROLLBACK TO Update_TAccesses_Row;
172: WHEN OTHERS THEN
173: ROLLBACK TO Update_TAccesses_Row;
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175:
176: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
179: END IF;
180:
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175:
176: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
177: THEN
178: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
179: END IF;
180:
181: END Update_Row;
182:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO Delete_TAccesses_Row;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225:
226: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
229: END IF;
230: WHEN OTHERS THEN
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225:
226: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
227: THEN
228: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
229: END IF;
230: WHEN OTHERS THEN
231: ROLLBACK TO Delete_TAccesses_Row;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: WHEN OTHERS THEN
231: ROLLBACK TO Delete_TAccesses_Row;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233:
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238:
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233:
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238:
239: END Delete_Row ;
240:
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: ROLLBACK TO Lock_TAccesses_Row;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290:
291: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
292: THEN
293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
294: END IF;
295: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290:
291: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
292: THEN
293: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
294: END IF;
295: WHEN OTHERS THEN
296: ROLLBACK TO Lock_TAccesses_Row;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: WHEN OTHERS THEN
296: ROLLBACK TO Lock_TAccesses_Row;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298:
299: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
302: END IF;
303:
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298:
299: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
300: THEN
301: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
302: END IF;
303:
304: END Lock_Row;
305: