APPS.INV_VIEW_MTL_TXN dependencies on FND_API

Line 126: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

122: BEGIN
123:
124: SAVEPOINT get_desc;
125:
126: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
127:
128: IF (p_owning_tp_type IS NULL OR p_owning_tp_type=2) THEN
129: BEGIN
130: SELECT (MP.organization_code||'-'||HAOU.name)

Line 441: WHEN FND_API.G_EXC_ERROR THEN

437:
438:
439:
440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442:
443: ROLLBACK TO get_desc ;
444: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
445: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 444: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442:
443: ROLLBACK TO get_desc ;
444: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
445: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
446:
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448:

Line 447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

443: ROLLBACK TO get_desc ;
444: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
445: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
446:
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448:
449: ROLLBACK TO get_desc;
450: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
451: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 450: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

446:
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448:
449: ROLLBACK TO get_desc;
450: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
451: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
452:
453: WHEN OTHERS THEN
454:

Line 456: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

452:
453: WHEN OTHERS THEN
454:
455: ROLLBACK TO get_desc;
456: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
457: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
458: FND_MSG_PUB.ADD_EXC_MSG( 'INV_VIEW_MTL_TXN', 'GET_DESCRIPTION');
459: END IF;
460: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );