DBA Data[Home] [Help]

APPS.OKL_CONTRACT_APP_WF dependencies on OKL_API

Line 26: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

22: x_return_status => lx_return_status,
23: x_msg_count => lx_msg_count,
24: x_msg_data => lx_msg_data);
25:
26: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
27: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
28: ELSIF lx_return_status = G_RET_STS_ERROR THEN
29: RAISE OKL_API.G_EXCEPTION_ERROR;
30: END IF;

Line 27: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

23: x_msg_count => lx_msg_count,
24: x_msg_data => lx_msg_data);
25:
26: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
27: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
28: ELSIF lx_return_status = G_RET_STS_ERROR THEN
29: RAISE OKL_API.G_EXCEPTION_ERROR;
30: END IF;
31:

Line 29: RAISE OKL_API.G_EXCEPTION_ERROR;

25:
26: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
27: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
28: ELSIF lx_return_status = G_RET_STS_ERROR THEN
29: RAISE OKL_API.G_EXCEPTION_ERROR;
30: END IF;
31:
32: okl_contract_status_pub.cascade_lease_status(p_api_version => G_API_VERSION,
33: p_init_msg_list => G_FALSE,

Line 39: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

35: x_return_status => lx_return_status,
36: x_msg_count => lx_msg_count,
37: x_msg_data => lx_msg_data);
38:
39: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
40: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
41: ELSIF lx_return_status = G_RET_STS_ERROR THEN
42: RAISE OKL_API.G_EXCEPTION_ERROR;
43: END IF;

Line 40: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

36: x_msg_count => lx_msg_count,
37: x_msg_data => lx_msg_data);
38:
39: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
40: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
41: ELSIF lx_return_status = G_RET_STS_ERROR THEN
42: RAISE OKL_API.G_EXCEPTION_ERROR;
43: END IF;
44:

Line 42: RAISE OKL_API.G_EXCEPTION_ERROR;

38:
39: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
40: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
41: ELSIF lx_return_status = G_RET_STS_ERROR THEN
42: RAISE OKL_API.G_EXCEPTION_ERROR;
43: END IF;
44:
45: x_return_status := lx_return_status;
46:

Line 50: WHEN OKL_API.G_EXCEPTION_ERROR THEN

46:
47:
48: EXCEPTION
49:
50: WHEN OKL_API.G_EXCEPTION_ERROR THEN
51:
52: x_return_status := G_RET_STS_ERROR;
53:
54: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 54: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

50: WHEN OKL_API.G_EXCEPTION_ERROR THEN
51:
52: x_return_status := G_RET_STS_ERROR;
53:
54: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
55:
56: x_return_status := G_RET_STS_UNEXP_ERROR;
57:
58: WHEN OTHERS THEN

Line 60: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

56: x_return_status := G_RET_STS_UNEXP_ERROR;
57:
58: WHEN OTHERS THEN
59:
60: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
61: p_msg_name => G_UNEXPECTED_ERROR,
62: p_token1 => G_SQLCODE_TOKEN,
63: p_token1_value => sqlcode,
64: p_token2 => G_SQLERRM_TOKEN,

Line 113: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

109: EXCEPTION
110:
111: WHEN OTHERS THEN
112:
113: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
114: p_msg_name => G_UNEXPECTED_ERROR,
115: p_token1 => G_SQLCODE_TOKEN,
116: p_token1_value => sqlcode,
117: p_token2 => G_SQLERRM_TOKEN,

Line 175: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

171: x_return_status => lx_return_status);
172:
173: --DBMS_OUTPUT.PUT_LINE('Back from l_change_k_status '||lx_return_status);
174:
175: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF lx_return_status = G_RET_STS_ERROR THEN
178: RAISE OKL_API.G_EXCEPTION_ERROR;
179: END IF;

Line 176: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

172:
173: --DBMS_OUTPUT.PUT_LINE('Back from l_change_k_status '||lx_return_status);
174:
175: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF lx_return_status = G_RET_STS_ERROR THEN
178: RAISE OKL_API.G_EXCEPTION_ERROR;
179: END IF;
180:

Line 178: RAISE OKL_API.G_EXCEPTION_ERROR;

174:
175: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
176: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
177: ELSIF lx_return_status = G_RET_STS_ERROR THEN
178: RAISE OKL_API.G_EXCEPTION_ERROR;
179: END IF;
180:
181: resultout := 'COMPLETE:';
182: RETURN;

Line 199: WHEN OKL_API.G_EXCEPTION_ERROR THEN

195: END IF;
196:
197: EXCEPTION
198:
199: WHEN OKL_API.G_EXCEPTION_ERROR THEN
200:
201: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
202: RAISE;
203:

Line 204: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

200:
201: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
202: RAISE;
203:
204: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
205:
206: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
207: RAISE;
208:

Line 211: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

207: RAISE;
208:
209: WHEN OTHERS THEN
210:
211: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
212: p_msg_name => G_UNEXPECTED_ERROR,
213: p_token1 => G_SQLCODE_TOKEN,
214: p_token1_value => sqlcode,
215: p_token2 => G_SQLERRM_TOKEN,