DBA Data[Home] [Help]

APPS.OKL_SETUP_STRMS_TRANS_PUB dependencies on OKL_API

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

13: l_api_version NUMBER := 1.0;
14: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
15: i NUMBER;
16: BEGIN
17: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
18: p_pkg_name => 'OKL_SETUP_STRMS_TRANS_PUB',
19: p_init_msg_list => p_init_msg_list,
20: l_api_version => l_api_version,
21: p_api_version => p_api_version,

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

44: END IF;
45:
46:
47:
48: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
49: x_msg_data => x_msg_data);
50:
51: x_return_status := l_return_status;
52:

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

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

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

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

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

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

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

86: l_api_version NUMBER := 1.0;
87: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
88: i NUMBER;
89: BEGIN
90: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
91: p_pkg_name => 'OKL_SETUP_STRMS_TRANS_PUB',
92: p_init_msg_list => p_init_msg_list,
93: l_api_version => l_api_version,
94: p_api_version => p_api_version,

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

117: END IF;
118:
119:
120:
121: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
122: x_msg_data => x_msg_data);
123:
124: x_return_status := l_return_status;
125:

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

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

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

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

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

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

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

164: l_api_version NUMBER := 1.0;
165: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
166: i NUMBER;
167: BEGIN
168: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
169: p_pkg_name => 'OKL_SETUP_STRMS_TRANS_PUB',
170: p_init_msg_list => p_init_msg_list,
171: l_api_version => l_api_version,
172: p_api_version => p_api_version,

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

194: END IF;
195:
196:
197:
198: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
199: x_msg_data => x_msg_data);
200:
201: x_return_status := l_return_status;
202:

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

201: x_return_status := l_return_status;
202:
203: EXCEPTION
204: WHEN G_EXCEPTION_ERROR THEN
205: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
206: p_pkg_name => G_PKG_NAME,
207: p_exc_name => G_EXC_NAME_ERROR,
208: x_msg_count=> x_msg_count,
209: x_msg_data => x_msg_data,

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

208: x_msg_count=> x_msg_count,
209: x_msg_data => x_msg_data,
210: p_api_type => '_PUB');
211: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
212: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
213: p_pkg_name => G_PKG_NAME,
214: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
215: x_msg_count => x_msg_count,
216: x_msg_data => x_msg_data,

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

215: x_msg_count => x_msg_count,
216: x_msg_data => x_msg_data,
217: p_api_type => '_PUB');
218: WHEN OTHERS THEN
219: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
220: p_pkg_name => G_PKG_NAME,
221: p_exc_name => G_EXC_NAME_OTHERS,
222: x_msg_count => x_msg_count,
223: x_msg_data => x_msg_data,