DBA Data[Home] [Help]

APPS.OKL_GENERATE_STREAMS_PUB dependencies on OKL_API

Line 21: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

17: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
18: l_api_name VARCHAR2(31) := 'GENERATE_STREAMS';
19: l_api_version NUMBER := 1;
20: BEGIN
21: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
22: p_pkg_name => G_PKG_NAME,
23: p_init_msg_list => p_init_msg_list,
24: l_api_version => l_api_version,
25: p_api_version => p_api_version,

Line 54: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

50: END IF;
51:
52:
53:
54: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
55: x_msg_data => x_msg_data);
56: x_return_status := l_return_status;
57:
58: EXCEPTION

Line 60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

56: x_return_status := l_return_status;
57:
58: EXCEPTION
59: WHEN G_EXCEPTION_ERROR THEN
60: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
61: p_pkg_name => G_PKG_NAME,
62: p_exc_name => G_EXC_NAME_RET_STS_ERR,
63: x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data,

Line 67: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

63: x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data,
65: p_api_type => G_API_TYPE);
66: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
67: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
68: p_pkg_name => G_PKG_NAME,
69: p_exc_name => G_EXC_NAME_RET_STS_UNEXP_ERR,
70: x_msg_count => x_msg_count,
71: x_msg_data => x_msg_data,

Line 74: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

70: x_msg_count => x_msg_count,
71: x_msg_data => x_msg_data,
72: p_api_type => G_API_TYPE);
73: WHEN OTHERS THEN
74: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
75: p_pkg_name => G_PKG_NAME,
76: p_exc_name => G_EXC_NAME_OTHERS,
77: x_msg_count => x_msg_count,
78: x_msg_data => x_msg_data,

Line 101: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

97: l_api_name VARCHAR2(31) := 'POPULATE_HEADER_DATA';
98: l_api_version NUMBER := 1;
99: BEGIN
100: --dbms_output.put_line('inside gen stream pub');
101: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
102: p_pkg_name => G_PKG_NAME,
103: p_init_msg_list => p_init_msg_list,
104: l_api_version => l_api_version,
105: p_api_version => p_api_version,

Line 133: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

129: END IF;
130: --dbms_output.put_line('back from gen stream pvt' || l_return_status);
131:
132:
133: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
134: x_msg_data => x_msg_data);
135: x_return_status := l_return_status;
136:
137: EXCEPTION

Line 139: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

135: x_return_status := l_return_status;
136:
137: EXCEPTION
138: WHEN G_EXCEPTION_ERROR THEN
139: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
140: p_pkg_name => G_PKG_NAME,
141: p_exc_name => G_EXC_NAME_RET_STS_ERR,
142: x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data,

Line 146: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

142: x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data,
144: p_api_type => G_API_TYPE);
145: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
146: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
147: p_pkg_name => G_PKG_NAME,
148: p_exc_name => G_EXC_NAME_RET_STS_UNEXP_ERR,
149: x_msg_count => x_msg_count,
150: x_msg_data => x_msg_data,

Line 153: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

149: x_msg_count => x_msg_count,
150: x_msg_data => x_msg_data,
151: p_api_type => G_API_TYPE);
152: WHEN OTHERS THEN
153: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
154: p_pkg_name => G_PKG_NAME,
155: p_exc_name => G_EXC_NAME_OTHERS,
156: x_msg_count => x_msg_count,
157: x_msg_data => x_msg_data,

Line 179: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

175: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
176: l_api_name VARCHAR2(31) := 'INVOKE_PRICING_ENGINE';
177: l_api_version NUMBER := 1;
178: BEGIN
179: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
180: p_pkg_name => G_PKG_NAME,
181: p_init_msg_list => p_init_msg_list,
182: l_api_version => l_api_version,
183: p_api_version => p_api_version,

Line 211: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

207: END IF;
208:
209:
210:
211: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
212: x_msg_data => x_msg_data);
213: x_return_status := l_return_status;
214:
215: EXCEPTION

Line 217: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

213: x_return_status := l_return_status;
214:
215: EXCEPTION
216: WHEN G_EXCEPTION_ERROR THEN
217: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
218: p_pkg_name => G_PKG_NAME,
219: p_exc_name => G_EXC_NAME_RET_STS_ERR,
220: x_msg_count => x_msg_count,
221: x_msg_data => x_msg_data,

Line 224: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

220: x_msg_count => x_msg_count,
221: x_msg_data => x_msg_data,
222: p_api_type => G_API_TYPE);
223: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
224: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
225: p_pkg_name => G_PKG_NAME,
226: p_exc_name => G_EXC_NAME_RET_STS_UNEXP_ERR,
227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,

Line 231: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,
229: p_api_type => G_API_TYPE);
230: WHEN OTHERS THEN
231: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
232: p_pkg_name => G_PKG_NAME,
233: p_exc_name => G_EXC_NAME_OTHERS,
234: x_msg_count => x_msg_count,
235: x_msg_data => x_msg_data,