DBA Data[Home] [Help]

APPS.OKL_CAU_PVT dependencies on OKC_API

Line 393: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

389: ---------------------------------
390: PROCEDURE validate_id(
391: x_return_status OUT NOCOPY VARCHAR2,
392: p_cauv_rec IN cauv_rec_type ) IS
393: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
394: BEGIN
395: IF (p_cauv_rec.id = OKL_API.G_MISS_NUM OR
396: p_cauv_rec.id IS NULL)
397: THEN

Line 419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

415: -----------------------------------
416: PROCEDURE validate_name(
417: x_return_status OUT NOCOPY VARCHAR2,
418: p_cauv_rec IN cauv_rec_type ) IS
419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
420: BEGIN
421: IF (p_cauv_rec.name = OKL_API.G_MISS_CHAR OR
422: p_cauv_rec.name IS NULL)
423: THEN

Line 445: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

441: ----------------------------------------------------
442: PROCEDURE validate_object_version_number(
443: x_return_status OUT NOCOPY VARCHAR2,
444: p_cauv_rec IN cauv_rec_type ) IS
445: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
446: BEGIN
447: IF (p_cauv_rec.object_version_number = OKL_API.G_MISS_NUM OR
448: p_cauv_rec.object_version_number IS NULL)
449: THEN

Line 484: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

480: -- ***
481: -- id
482: -- ***
483: validate_id(l_return_status, p_cauv_rec);
484: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
485: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
486: x_return_status := l_return_status;
487: RAISE G_EXCEPTION_HALT_VALIDATION;
488: ELSE

Line 485: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

481: -- id
482: -- ***
483: validate_id(l_return_status, p_cauv_rec);
484: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
485: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
486: x_return_status := l_return_status;
487: RAISE G_EXCEPTION_HALT_VALIDATION;
488: ELSE
489: x_return_status := l_return_status;

Line 497: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

493: -- ***
494: -- name
495: -- ***
496: validate_name(x_return_status, p_cauv_rec);
497: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
499: x_return_status := l_return_status;
500: RAISE G_EXCEPTION_HALT_VALIDATION;
501: ELSE

Line 498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

494: -- name
495: -- ***
496: validate_name(x_return_status, p_cauv_rec);
497: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
498: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
499: x_return_status := l_return_status;
500: RAISE G_EXCEPTION_HALT_VALIDATION;
501: ELSE
502: x_return_status := l_return_status;

Line 510: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

506: -- ***
507: -- object_version_number
508: -- ***
509: validate_object_version_number(x_return_status, p_cauv_rec);
510: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
511: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
512: x_return_status := l_return_status;
513: RAISE G_EXCEPTION_HALT_VALIDATION;
514: ELSE

Line 511: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

507: -- object_version_number
508: -- ***
509: validate_object_version_number(x_return_status, p_cauv_rec);
510: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
511: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
512: x_return_status := l_return_status;
513: RAISE G_EXCEPTION_HALT_VALIDATION;
514: ELSE
515: x_return_status := l_return_status;