DBA Data[Home] [Help]

APPS.OKC_RULE_DEF_PVT dependencies on OKC_API

Line 96: OKC_API.SET_MESSAGE(

92: p_rgrv_rec);
93: EXCEPTION
94: WHEN G_EXCEPTION_CANNOT_DELETE THEN
95: -- store SQL error message on message stack
96: OKC_API.SET_MESSAGE(
97: p_app_name => G_APP_NAME,
98: p_msg_name => G_CANNOT_DELETE_RULE_DEF);
99: -- notify caller of an error
100: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 100: x_return_status := OKC_API.G_RET_STS_ERROR;

96: OKC_API.SET_MESSAGE(
97: p_app_name => G_APP_NAME,
98: p_msg_name => G_CANNOT_DELETE_RULE_DEF);
99: -- notify caller of an error
100: x_return_status := OKC_API.G_RET_STS_ERROR;
101: WHEN OTHERS THEN
102: -- store SQL error message on message stack
103: OKC_API.SET_MESSAGE(
104: p_app_name => G_APP_NAME,

Line 103: OKC_API.SET_MESSAGE(

99: -- notify caller of an error
100: x_return_status := OKC_API.G_RET_STS_ERROR;
101: WHEN OTHERS THEN
102: -- store SQL error message on message stack
103: OKC_API.SET_MESSAGE(
104: p_app_name => G_APP_NAME,
105: p_msg_name => G_UNEXPECTED_ERROR,
106: p_token1 => G_SQLCODE_TOKEN,
107: p_token1_value => SQLCODE,

Line 111: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

107: p_token1_value => SQLCODE,
108: p_token2 => G_SQLERRM_TOKEN,
109: p_token2_value => SQLERRM);
110: -- notify caller of an error as UNEXPETED error
111: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
112: -- verify that cursor was closed
113: IF l_rul_csr%ISOPEN THEN
114: CLOSE l_rul_csr;
115: END IF;