DBA Data[Home] [Help]

APPS.OZF_RESALE_BATCHES_PKG dependencies on FND_API

Line 121: /*IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM)

117: BEGIN
118:
119: -- Start: bug # 5997978 fixed
120: -- org id can be null at batch level but then should always be given at lines level.
121: /*IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM)
122: SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
123: INTO px_org_id
124: FROM DUAL;
125: END IF; */

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: WHERE resale_batch_id = p_resale_batch_id
446: AND object_version_number = p_object_version_number;
447:
448: IF (SQL%NOTFOUND) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451: END Update_Row;
452:
453:

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

473: BEGIN
474: DELETE FROM OZF_RESALE_BATCHES_ALL
475: WHERE RESALE_BATCH_ID = p_RESALE_BATCH_ID;
476: If (SQL%NOTFOUND) then
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: End If;
479: END Delete_Row ;
480:
481: