35: -- END SCHANDRU INVERES
36: BEGIN
37:
38: /* Initialize API return status to success */
39: x_Status := FND_API.G_RET_STS_SUCCESS;
40:
41:
42: print_debug(' In Grade Update Package - Before Updating record ') ;
43:
152:
153: --COMMIT ;-- SCHANDRU INVERES
154:
155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: -- BEGIN SCHANDRU INVERES
158: if ( p_update_from_mobile = 'Y') then
159: ROLLBACK TO Insert_GradeUpdate_PVT;
160: end if;
158: if ( p_update_from_mobile = 'Y') then
159: ROLLBACK TO Insert_GradeUpdate_PVT;
160: end if;
161: -- END SCHANDRU INVERES
162: x_Status := FND_API.G_RET_STS_ERROR;
163: x_Message := SQLERRM ;
164: print_debug(' In Grade Update Package - Encountered exec error ') ;
165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
162: x_Status := FND_API.G_RET_STS_ERROR;
163: x_Message := SQLERRM ;
164: print_debug(' In Grade Update Package - Encountered exec error ') ;
165:
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: -- BEGIN SCHANDRU INVERES
168: if ( p_update_from_mobile = 'Y') then
169: ROLLBACK TO Insert_GradeUpdate_PVT;
170: end if;
169: ROLLBACK TO Insert_GradeUpdate_PVT;
170: end if;
171: -- END SCHANDRU INVERES
172:
173: x_Status := FND_API.G_RET_STS_ERROR;
174: x_Message := SQLERRM ;
175: print_debug(' In Grade Update Package - Encountered unexpected error ') ;
176: WHEN OTHERS THEN
177: -- BEGIN SCHANDRU INVERES
179: ROLLBACK TO Insert_GradeUpdate_PVT;
180: end if;
181: -- END SCHANDRU INVERES
182:
183: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
184: X_Message := SQLERRM ;
185: print_debug(' In Grade Update Package - Encountered other error ') ;
186:
187: END UPDATE_GRADE ;