DBA Data[Home] [Help]

APPS.INV_GRADE_PKG dependencies on FND_API

Line 67: x_Status := FND_API.G_RET_STS_SUCCESS;

63: --Global Lot ER End
64: BEGIN
65:
66: /* Initialize API return status to success */
67: x_Status := FND_API.G_RET_STS_SUCCESS;
68:
69:
70: print_debug(' In Grade Update Package - Before Updating record ') ;
71:

Line 328: WHEN FND_API.G_EXC_ERROR THEN

324:
325: --COMMIT ;-- SCHANDRU INVERES
326:
327: EXCEPTION
328: WHEN FND_API.G_EXC_ERROR THEN
329: -- BEGIN SCHANDRU INVERES
330: if ( p_update_from_mobile = 'Y') then
331: ROLLBACK TO Insert_GradeUpdate_PVT;
332: end if;

Line 334: x_Status := FND_API.G_RET_STS_ERROR;

330: if ( p_update_from_mobile = 'Y') then
331: ROLLBACK TO Insert_GradeUpdate_PVT;
332: end if;
333: -- END SCHANDRU INVERES
334: x_Status := FND_API.G_RET_STS_ERROR;
335: x_Message := SQLERRM ;
336: print_debug(' In Grade Update Package - Encountered exec error ') ;
337:
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

334: x_Status := FND_API.G_RET_STS_ERROR;
335: x_Message := SQLERRM ;
336: print_debug(' In Grade Update Package - Encountered exec error ') ;
337:
338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
339: -- BEGIN SCHANDRU INVERES
340: if ( p_update_from_mobile = 'Y') then
341: ROLLBACK TO Insert_GradeUpdate_PVT;
342: end if;

Line 345: x_Status := FND_API.G_RET_STS_ERROR;

341: ROLLBACK TO Insert_GradeUpdate_PVT;
342: end if;
343: -- END SCHANDRU INVERES
344:
345: x_Status := FND_API.G_RET_STS_ERROR;
346: x_Message := SQLERRM ;
347: print_debug(' In Grade Update Package - Encountered unexpected error ') ;
348: WHEN OTHERS THEN
349: -- BEGIN SCHANDRU INVERES

Line 355: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;

351: ROLLBACK TO Insert_GradeUpdate_PVT;
352: end if;
353: -- END SCHANDRU INVERES
354:
355: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
356: X_Message := SQLERRM ;
357: print_debug(' In Grade Update Package - Encountered other error ') ;
358:
359: END UPDATE_GRADE ;