DBA Data[Home] [Help]

APPS.OKL_SETUP_STRMS_TRANS_PVT dependencies on OKL_API

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

16: i NUMBER;
17: l_sgnv_tbl sgnv_tbl_type;
18: lx_sgnv_tbl sgnv_tbl_type;
19: BEGIN
20: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
21: p_pkg_name => 'OKL_SETUP_STRMS_TRANS_PVT',
22: p_init_msg_list => p_init_msg_list,
23: l_api_version => l_api_version,
24: p_api_version => p_api_version,

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

46: RAISE G_EXCEPTION_ERROR;
47: END IF;
48:
49:
50: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
51: x_msg_data => x_msg_data);
52:
53: x_return_status := l_return_status;
54:

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

53: x_return_status := l_return_status;
54:
55: EXCEPTION
56: WHEN G_EXCEPTION_ERROR THEN
57: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
58: p_pkg_name => G_PKG_NAME,
59: p_exc_name => G_EXC_NAME_ERROR,
60: x_msg_count => x_msg_count,
61: x_msg_data => x_msg_data,

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

60: x_msg_count => x_msg_count,
61: x_msg_data => x_msg_data,
62: p_api_type => '_PVT');
63: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
64: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
65: p_pkg_name => G_PKG_NAME,
66: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
67: x_msg_count => x_msg_count,
68: x_msg_data => x_msg_data,

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

67: x_msg_count => x_msg_count,
68: x_msg_data => x_msg_data,
69: p_api_type => '_PVT');
70: WHEN OTHERS THEN
71: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
72: p_pkg_name => G_PKG_NAME,
73: p_exc_name => G_EXC_NAME_OTHERS,
74: x_msg_count => x_msg_count,
75: x_msg_data => x_msg_data,

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

90: i NUMBER;
91: l_sgnv_tbl sgnv_tbl_type;
92: lx_sgnv_tbl sgnv_tbl_type;
93: BEGIN
94: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
95: p_pkg_name => 'OKL_SETUP_STRMS_TRANS_PVT',
96: p_init_msg_list => p_init_msg_list,
97: l_api_version => l_api_version,
98: p_api_version => p_api_version,

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

119: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
120: RAISE G_EXCEPTION_ERROR;
121: END IF;
122:
123: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
124: x_msg_data => x_msg_data);
125:
126: x_return_status := l_return_status;
127:

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

126: x_return_status := l_return_status;
127:
128: EXCEPTION
129: WHEN G_EXCEPTION_ERROR THEN
130: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
131: p_pkg_name => G_PKG_NAME,
132: p_exc_name => G_EXC_NAME_ERROR,
133: x_msg_count=> x_msg_count,
134: x_msg_data => x_msg_data,

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

133: x_msg_count=> x_msg_count,
134: x_msg_data => x_msg_data,
135: p_api_type => '_PVT');
136: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
137: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
138: p_pkg_name => G_PKG_NAME,
139: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
140: x_msg_count => x_msg_count,
141: x_msg_data => x_msg_data,

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

141: x_msg_data => x_msg_data,
142: p_api_type => '_PVT');
143:
144: WHEN OTHERS THEN
145: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
146: p_pkg_name => G_PKG_NAME,
147: p_exc_name => G_EXC_NAME_OTHERS,
148: x_msg_count => x_msg_count,
149: x_msg_data => x_msg_data,

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

162: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
163: i NUMBER;
164: l_sgnv_tbl sgnv_tbl_type;
165: BEGIN
166: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
167: p_pkg_name => 'OKL_SETUP_STRMS_TRANS_PVT',
168: p_init_msg_list => p_init_msg_list,
169: l_api_version => l_api_version,
170: p_api_version => p_api_version,

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

189: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
190: RAISE G_EXCEPTION_ERROR;
191: END IF;
192:
193: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
194: x_msg_data => x_msg_data);
195:
196: x_return_status := l_return_status;
197:

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

196: x_return_status := l_return_status;
197:
198: EXCEPTION
199: WHEN G_EXCEPTION_ERROR THEN
200: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
201: p_pkg_name => G_PKG_NAME,
202: p_exc_name => G_EXC_NAME_ERROR,
203: x_msg_count=> x_msg_count,
204: x_msg_data => x_msg_data,

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

203: x_msg_count=> x_msg_count,
204: x_msg_data => x_msg_data,
205: p_api_type => '_PVT');
206: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
207: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
208: p_pkg_name => G_PKG_NAME,
209: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
210: x_msg_count => x_msg_count,
211: x_msg_data => x_msg_data,

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

210: x_msg_count => x_msg_count,
211: x_msg_data => x_msg_data,
212: p_api_type => '_PVT');
213: WHEN OTHERS THEN
214: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
215: p_pkg_name => G_PKG_NAME,
216: p_exc_name => G_EXC_NAME_OTHERS,
217: x_msg_count => x_msg_count,
218: x_msg_data => x_msg_data,