APPS.OKL_PXL_PVT dependencies on OKC_API

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

880: ----------------------------------------------------
881: PROCEDURE validate_supplier(
882: x_return_status OUT NOCOPY VARCHAR2,
883: p_asset_vendor_id IN NUMBER) IS
884: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
885: l_asset_vendor_id VARCHAR2(1);
886: l_row_not_found BOOLEAN := FALSE;
887: CURSOR c1(p_asset_vendor_id NUMBER) IS
888: SELECT '1'

Line 894: x_return_status := OKC_API.G_RET_STS_SUCCESS;

890: WHERE vendor_id = p_asset_vendor_id ;
891: BEGIN
892: IF ( p_asset_vendor_id IS NOT NULL) THEN
893: -- initialize return status
894: x_return_status := OKC_API.G_RET_STS_SUCCESS;
895: OPEN c1(p_asset_vendor_id );
896: FETCH c1 INTO l_asset_vendor_id;
897: l_row_not_found := c1%NOTFOUND;
898: CLOSE c1;

Line 900: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'asset_vendor_id');

896: FETCH c1 INTO l_asset_vendor_id;
897: l_row_not_found := c1%NOTFOUND;
898: CLOSE c1;
899: IF l_row_not_found THEN
900: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'asset_vendor_id');
901: x_return_status := OKC_API.G_RET_STS_ERROR;
902: END IF;
903: END IF;
904: EXCEPTION

Line 901: x_return_status := OKC_API.G_RET_STS_ERROR;

897: l_row_not_found := c1%NOTFOUND;
898: CLOSE c1;
899: IF l_row_not_found THEN
900: OKC_API.set_message('OKL',G_INVALID_VALUE , G_COL_NAME_TOKEN, 'asset_vendor_id');
901: x_return_status := OKC_API.G_RET_STS_ERROR;
902: END IF;
903: END IF;
904: EXCEPTION
905: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 912: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

908: NULL;
909:
910: WHEN OTHERS THEN
911: -- store SQL error message on message stack for caller
912: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
913:
914: p_msg_name => g_unexpected_error,
915: p_token1 => g_sqlcode_token,
916: p_token1_value => SQLCODE,

Line 921: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

917: p_token2 => g_sqlerrm_token,
918: p_token2_value => SQLERRM);
919:
920: -- notify caller of an UNEXPECTED error
921: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
922: END validate_supplier;
923: ---------------------------------------------------------------------------
924: -- FUNCTION Validate_Attributes
925: ---------------------------------------------------------------------------