APPS.OKL_QCO_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_qcov_rec IN qcov_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:
396: IF (p_qcov_rec.id = OKL_API.G_MISS_NUM OR p_qcov_rec.id IS NULL) 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_qte_id(
417: p_qcov_rec IN qcov_rec_type,
418: x_return_status OUT NOCOPY VARCHAR2) IS
419: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
420:
421: l_dummy_var VARCHAR2(1) := '?' ;
422: l_dummy_req_var VARCHAR2(1) := '?' ;
423: CURSOR okl_qcov_qtev_fk_csr (p_id IN NUMBER) IS

Line 456: OKC_API.set_message(g_app_name,

452: CLOSE okl_qcov_trxv_fk_csr ;
453:
454: IF ( l_dummy_req_var = '?' ) THEN
455:
456: OKC_API.set_message(g_app_name,
457: g_no_parent_record,
458: g_col_name_token,
459: 'qte_id',
460: g_child_table_token ,

Line 464: l_return_status := OKC_API.G_RET_STS_ERROR;

460: g_child_table_token ,
461: 'OKL_TRX_QTE_CF_OBJECTS_V',
462: g_parent_table_token ,
463: 'OKL_TRX_QUOTES_V OR OKL_TRX_REQUESTS');
464: l_return_status := OKC_API.G_RET_STS_ERROR;
465: END IF;
466:
467: END IF;
468:

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

486: -------------------------------------
487: PROCEDURE validate_cfo_id(
488: p_qcov_rec IN qcov_rec_type,
489: x_return_status OUT NOCOPY VARCHAR2) IS
490: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
491:
492: l_dummy_var VARCHAR2(1) := '?' ;
493: CURSOR okl_qcov_cfov_fk_csr (p_id IN NUMBER) IS
494: SELECT 'x'

Line 511: OKC_API.set_message(g_app_name,

507: FETCH okl_qcov_cfov_fk_csr into l_dummy_var ;
508: CLOSE okl_qcov_cfov_fk_csr ;
509: -- still set to default means data was not found
510: IF ( l_dummy_var = '?' ) THEN
511: OKC_API.set_message(g_app_name,
512: g_no_parent_record,
513: g_col_name_token,
514: 'cfo_id',
515: g_child_table_token ,

Line 519: l_return_status := OKC_API.G_RET_STS_ERROR;

515: g_child_table_token ,
516: 'OKL_TRX_QTE_CF_OBJECTS_V',
517: g_parent_table_token ,
518: 'OKL_CASH_FLOW_OBJECTS_V');
519: l_return_status := OKC_API.G_RET_STS_ERROR;
520:
521: END IF;
522:
523: END IF;

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

538: ---------------------------------------------
539: PROCEDURE validate_base_source_id(
540: p_qcov_rec IN qcov_rec_type,
541: x_return_status OUT NOCOPY VARCHAR2) IS
542: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
543: BEGIN
544:
545: IF (p_qcov_rec.base_source_id = OKL_API.G_MISS_NUM OR p_qcov_rec.base_source_id IS NULL)
546: THEN

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

564: ----------------------------------------------------
565: PROCEDURE validate_object_version_number(
566: p_qcov_rec IN qcov_rec_type,
567: x_return_status OUT NOCOPY VARCHAR2) IS
568: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
569: BEGIN
570:
571: IF (p_qcov_rec.object_version_number = OKL_API.G_MISS_NUM OR p_qcov_rec.object_version_number IS NULL)
572: THEN

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

604: -- ***
605: -- id
606: -- ***
607: validate_id(p_qcov_rec, l_return_status);
608: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
610: x_return_status := l_return_status;
611: RAISE G_EXCEPTION_HALT_VALIDATION;
612: ELSE

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

605: -- id
606: -- ***
607: validate_id(p_qcov_rec, l_return_status);
608: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
610: x_return_status := l_return_status;
611: RAISE G_EXCEPTION_HALT_VALIDATION;
612: ELSE
613: x_return_status := l_return_status;

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

617: -- ***
618: -- qte_id
619: -- ***
620: validate_qte_id(p_qcov_rec, l_return_status);
621: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
622: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
623: x_return_status := l_return_status;
624: RAISE G_EXCEPTION_HALT_VALIDATION;
625: ELSE

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

618: -- qte_id
619: -- ***
620: validate_qte_id(p_qcov_rec, l_return_status);
621: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
622: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
623: x_return_status := l_return_status;
624: RAISE G_EXCEPTION_HALT_VALIDATION;
625: ELSE
626: x_return_status := l_return_status;

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

630: -- ***
631: -- cfo_id
632: -- ***
633: validate_cfo_id(p_qcov_rec, l_return_status);
634: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
636: x_return_status := l_return_status;
637: RAISE G_EXCEPTION_HALT_VALIDATION;
638: ELSE

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

631: -- cfo_id
632: -- ***
633: validate_cfo_id(p_qcov_rec, l_return_status);
634: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
635: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
636: x_return_status := l_return_status;
637: RAISE G_EXCEPTION_HALT_VALIDATION;
638: ELSE
639: x_return_status := l_return_status;

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

643: -- ***
644: -- base_source_id
645: -- ***
646: validate_base_source_id(p_qcov_rec, l_return_status);
647: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
648: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
649: x_return_status := l_return_status;
650: RAISE G_EXCEPTION_HALT_VALIDATION;
651: ELSE

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

644: -- base_source_id
645: -- ***
646: validate_base_source_id(p_qcov_rec, l_return_status);
647: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
648: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
649: x_return_status := l_return_status;
650: RAISE G_EXCEPTION_HALT_VALIDATION;
651: ELSE
652: x_return_status := l_return_status;

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

656: -- ***
657: -- object_version_number
658: -- ***
659: validate_object_version_number(p_qcov_rec, l_return_status);
660: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
661: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
662: x_return_status := l_return_status;
663: RAISE G_EXCEPTION_HALT_VALIDATION;
664: ELSE

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

657: -- object_version_number
658: -- ***
659: validate_object_version_number(p_qcov_rec, l_return_status);
660: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
661: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
662: x_return_status := l_return_status;
663: RAISE G_EXCEPTION_HALT_VALIDATION;
664: ELSE
665: x_return_status := l_return_status;