DBA Data[Home] [Help]

APPS.INV_GRADE_PKG dependencies on FND_API

Line 39: x_Status := FND_API.G_RET_STS_SUCCESS;

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:

Line 156: WHEN FND_API.G_EXC_ERROR THEN

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;

Line 162: x_Status := FND_API.G_RET_STS_ERROR;

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

Line 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;

Line 173: x_Status := FND_API.G_RET_STS_ERROR;

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

Line 183: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;

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 ;