DBA Data[Home] [Help]

APPS.OZF_RESALE_BATCHES_PKG dependencies on FND_API

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

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

Line 443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

439: WHERE resale_batch_id = p_resale_batch_id
440: AND object_version_number = p_object_version_number;
441:
442: IF (SQL%NOTFOUND) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;
445: END Update_Row;
446:
447:

Line 471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

467: BEGIN
468: DELETE FROM OZF_RESALE_BATCHES_ALL
469: WHERE RESALE_BATCH_ID = p_RESALE_BATCH_ID;
470: If (SQL%NOTFOUND) then
471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
472: End If;
473: END Delete_Row ;
474:
475: