APPS.OKL_CFO_PVT dependencies on OKC_API

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

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

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

415: ---------------------------------------
416: PROCEDURE validate_oty_code(
417: p_cfov_rec IN cfov_rec_type,
418: x_return_status OUT NOCOPY VARCHAR2) IS
419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
420: l_dummy_var VARCHAR2(1) := '?' ;
421:
422: CURSOR okl_cfov_oty_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
423: SELECT 'x'

Line 440: OKC_API.set_message(g_app_name,

436: FETCH okl_cfov_oty_fk_csr into l_dummy_var ;
437: CLOSE okl_cfov_oty_fk_csr ;
438: -- still set to default means data was not found
439: IF ( l_dummy_var = '?' ) THEN
440: OKC_API.set_message(g_app_name,
441: g_no_parent_record,
442: g_col_name_token,
443: 'oty_code',
444: g_child_table_token ,

Line 448: l_return_status := OKC_API.G_RET_STS_ERROR;

444: g_child_table_token ,
445: 'OKL_CASH_FLOW_OBJECTS_V',
446: g_parent_table_token ,
447: 'FND_LOOKUP_VALUES');
448: l_return_status := OKC_API.G_RET_STS_ERROR;
449:
450: END IF;
451: END IF;
452: x_return_status := l_return_status;

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

466: -------------------------------------------
467: PROCEDURE validate_source_table(
468: p_cfov_rec IN cfov_rec_type,
469: x_return_status OUT NOCOPY VARCHAR2) IS
470: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
471: BEGIN
472:
473: IF (p_cfov_rec.source_table = OKL_API.G_MISS_CHAR OR p_cfov_rec.source_table IS NULL)
474: THEN

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

493: ----------------------------------------
494: PROCEDURE validate_source_id(
495: p_cfov_rec IN cfov_rec_type,
496: x_return_status OUT NOCOPY VARCHAR2) IS
497: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
498: BEGIN
499:
500: IF (p_cfov_rec.source_id = OKL_API.G_MISS_NUM OR p_cfov_rec.source_id IS NULL)
501: THEN

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

533: -- ***
534: -- id
535: -- ***
536: validate_id(p_cfov_rec, l_return_status);
537: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
538: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
539: x_return_status := l_return_status;
540: RAISE G_EXCEPTION_HALT_VALIDATION;
541: ELSE

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

534: -- id
535: -- ***
536: validate_id(p_cfov_rec, l_return_status);
537: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
538: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
539: x_return_status := l_return_status;
540: RAISE G_EXCEPTION_HALT_VALIDATION;
541: ELSE
542: x_return_status := l_return_status;

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

546: -- ***
547: -- oty_code
548: -- ***
549: validate_oty_code(p_cfov_rec, l_return_status);
550: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
551: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
552: x_return_status := l_return_status;
553: RAISE G_EXCEPTION_HALT_VALIDATION;
554: ELSE

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

547: -- oty_code
548: -- ***
549: validate_oty_code(p_cfov_rec, l_return_status);
550: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
551: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
552: x_return_status := l_return_status;
553: RAISE G_EXCEPTION_HALT_VALIDATION;
554: ELSE
555: x_return_status := l_return_status;

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

559: -- ***
560: -- source_table
561: -- ***
562: validate_source_table(p_cfov_rec, l_return_status);
563: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
564: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
565: x_return_status := l_return_status;
566: RAISE G_EXCEPTION_HALT_VALIDATION;
567: ELSE

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

560: -- source_table
561: -- ***
562: validate_source_table(p_cfov_rec, l_return_status);
563: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
564: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
565: x_return_status := l_return_status;
566: RAISE G_EXCEPTION_HALT_VALIDATION;
567: ELSE
568: x_return_status := l_return_status;

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

572: -- ***
573: -- source_id
574: -- ***
575: validate_source_id(p_cfov_rec, l_return_status);
576: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
577: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
578: x_return_status := l_return_status;
579: RAISE G_EXCEPTION_HALT_VALIDATION;
580: ELSE

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

573: -- source_id
574: -- ***
575: validate_source_id(p_cfov_rec, l_return_status);
576: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
577: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
578: x_return_status := l_return_status;
579: RAISE G_EXCEPTION_HALT_VALIDATION;
580: ELSE
581: x_return_status := l_return_status;