APPS.OKL_SGT_PVT dependencies on OKC_API

Line 484: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'jtot_object1_code');

480: l_row_not_found := jtot_object_csr%NOTFOUND;
481: CLOSE jtot_object_csr ;
482:
483: IF l_row_not_found THEN
484: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'jtot_object1_code');
485: x_return_status := OKC_API.G_RET_STS_ERROR;
486: END IF;
487: EXCEPTION
488: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 485: x_return_status := OKC_API.G_RET_STS_ERROR;

481: CLOSE jtot_object_csr ;
482:
483: IF l_row_not_found THEN
484: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'jtot_object1_code');
485: x_return_status := OKC_API.G_RET_STS_ERROR;
486: END IF;
487: EXCEPTION
488: WHEN G_EXCEPTION_HALT_VALIDATION THEN
489: null;

Line 554: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'object1_id1');

550: OPEN stream_type_csr (l_stream_type);
551: FETCH stream_type_csr INTO l_stream_type_class;
552: l_row_not_found := stream_type_csr%NOTFOUND;
553: IF l_row_not_found THEN
554: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'object1_id1');
555: x_return_status := OKC_API.G_RET_STS_ERROR;
556: ELSE
557: IF l_stream_type_class <> 'SUBSIDY' THEN
558: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 555: x_return_status := OKC_API.G_RET_STS_ERROR;

551: FETCH stream_type_csr INTO l_stream_type_class;
552: l_row_not_found := stream_type_csr%NOTFOUND;
553: IF l_row_not_found THEN
554: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'object1_id1');
555: x_return_status := OKC_API.G_RET_STS_ERROR;
556: ELSE
557: IF l_stream_type_class <> 'SUBSIDY' THEN
558: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
559: p_msg_name => 'OKL_ASSOC_STREAM_TYPE');

Line 560: x_return_status := OKC_API.G_RET_STS_ERROR;

556: ELSE
557: IF l_stream_type_class <> 'SUBSIDY' THEN
558: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
559: p_msg_name => 'OKL_ASSOC_STREAM_TYPE');
560: x_return_status := OKC_API.G_RET_STS_ERROR;
561: ELSE
562: x_return_status := OKL_API.G_RET_STS_SUCCESS;
563: END IF;
564: END IF;

Line 571: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'jtot_object1_code');

567: FETCH jtot_object_csr INTO l_select_id;
568: l_row_not_found := jtot_object_csr%NOTFOUND;
569: CLOSE jtot_object_csr ;
570: IF l_row_not_found THEN
571: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'jtot_object1_code');
572: x_return_status := OKC_API.G_RET_STS_ERROR;
573: ELSE
574: l_cursor := DBMS_SQL.OPEN_CURSOR;
575: IF (is_number(l_select_id)) THEN

Line 572: x_return_status := OKC_API.G_RET_STS_ERROR;

568: l_row_not_found := jtot_object_csr%NOTFOUND;
569: CLOSE jtot_object_csr ;
570: IF l_row_not_found THEN
571: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'jtot_object1_code');
572: x_return_status := OKC_API.G_RET_STS_ERROR;
573: ELSE
574: l_cursor := DBMS_SQL.OPEN_CURSOR;
575: IF (is_number(l_select_id)) THEN
576: DBMS_SQL.PARSE(l_cursor, 'select '|| l_select_id ||' from '|| p_jtot_object1_code || ' where ' || l_select_id || ' = ' || to_number(p_object1_id1), DBMS_SQL.V7);

Line 583: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'object1_id1');

579: END IF;
580: DBMS_SQL.DEFINE_COLUMN_CHAR(l_cursor, 1, l_id, 200);
581: l_rows := DBMS_SQL.EXECUTE(l_cursor);
582: IF DBMS_SQL.FETCH_ROWS(l_cursor) = 0 then
583: Okc_Api.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'object1_id1');
584: x_return_status := OKL_API.G_RET_STS_ERROR;
585: END IF;
586: END IF;
587: END IF;

Line 1500: l_return_status := OKC_API.G_RET_STS_ERROR;

1496: p_token1_value => l_token1_value,
1497: p_token2 => 'ORACLEVALUE_PROMPT', -- Bug Number: 3992148
1498: p_token2_value => l_token2_value);
1499: END IF;
1500: l_return_status := OKC_API.G_RET_STS_ERROR;
1501: END IF;
1502: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1503: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1504: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN