DBA Data[Home] [Help]

APPS.OKL_UBB_WF_PVT dependencies on OKL_API

Line 16: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

12: G_WF_ITM_UBB_ASSET_ID CONSTANT VARCHAR2(15) := 'UBB_ASSET_ID';
13: G_WF_ITM_CONTRACT_PROCESS CONSTANT VARCHAR2(20) := 'CONTRACT_PROCESS';
14:
15: PROCEDURE raise_create_event (p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: p_chr_id IN NUMBER,

Line 30: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

26: l_parameter_list wf_parameter_list_t;
27: l_process VARCHAR2(20);
28: BEGIN
29:
30: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
31: p_pkg_name => G_PKG_NAME,
32: p_init_msg_list => p_init_msg_list,
33: l_api_version => l_api_version,
34: p_api_version => p_api_version,

Line 57: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

53: x_msg_data => x_msg_data,
54: p_event_name => G_WF_EVT_UBB_CREATED,
55: p_parameters => l_parameter_list);
56:
57: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
58: ,x_msg_data => x_msg_data);
59:
60: x_return_status := l_return_status;
61: EXCEPTION

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

60: x_return_status := l_return_status;
61: EXCEPTION
62: WHEN G_EXCEPTION_ERROR THEN
63:
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_ERROR,
67: x_msg_count => x_msg_count,
68: x_msg_data => x_msg_data,

Line 73: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

69: p_api_type => G_API_TYPE);
70:
71: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
72:
73: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
74: p_pkg_name => G_PKG_NAME,
75: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
76: x_msg_count => x_msg_count,
77: x_msg_data => x_msg_data,

Line 81: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

77: x_msg_data => x_msg_data,
78: p_api_type => G_API_TYPE);
79: WHEN OTHERS THEN
80:
81: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
82: p_pkg_name => G_PKG_NAME,
83: p_exc_name => G_EXC_NAME_OTHERS,
84: x_msg_count => x_msg_count,
85: x_msg_data => x_msg_data,

Line 91: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

87:
88: END raise_create_event;
89:
90: PROCEDURE raise_update_event (p_api_version IN NUMBER,
91: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_chr_id IN NUMBER,

Line 105: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

101: l_parameter_list wf_parameter_list_t;
102: l_process VARCHAR2(20);
103: BEGIN
104:
105: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
106: p_pkg_name => G_PKG_NAME,
107: p_init_msg_list => p_init_msg_list,
108: l_api_version => l_api_version,
109: p_api_version => p_api_version,

Line 132: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

128: x_msg_data => x_msg_data,
129: p_event_name => G_WF_EVT_UBB_UPDATED,
130: p_parameters => l_parameter_list);
131:
132: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
133: ,x_msg_data => x_msg_data);
134:
135: x_return_status := l_return_status;
136: EXCEPTION

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

135: x_return_status := l_return_status;
136: EXCEPTION
137: WHEN G_EXCEPTION_ERROR THEN
138:
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_ERROR,
142: x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data,

Line 148: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

144: p_api_type => G_API_TYPE);
145:
146: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
147:
148: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
149: p_pkg_name => G_PKG_NAME,
150: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
151: x_msg_count => x_msg_count,
152: x_msg_data => x_msg_data,

Line 156: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

152: x_msg_data => x_msg_data,
153: p_api_type => G_API_TYPE);
154: WHEN OTHERS THEN
155:
156: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
157: p_pkg_name => G_PKG_NAME,
158: p_exc_name => G_EXC_NAME_OTHERS,
159: x_msg_count => x_msg_count,
160: x_msg_data => x_msg_data,

Line 166: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

162:
163: END raise_update_event;
164:
165: PROCEDURE raise_delete_event (p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_chr_id IN NUMBER,

Line 180: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

176: l_parameter_list wf_parameter_list_t;
177: l_process VARCHAR2(20);
178: BEGIN
179:
180: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
181: p_pkg_name => G_PKG_NAME,
182: p_init_msg_list => p_init_msg_list,
183: l_api_version => l_api_version,
184: p_api_version => p_api_version,

Line 207: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

203: x_msg_data => x_msg_data,
204: p_event_name => G_WF_EVT_UBB_REMOVE,
205: p_parameters => l_parameter_list);
206:
207: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
208: ,x_msg_data => x_msg_data);
209:
210: x_return_status := l_return_status;
211: EXCEPTION

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

210: x_return_status := l_return_status;
211: EXCEPTION
212: WHEN G_EXCEPTION_ERROR THEN
213:
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_ERROR,
217: x_msg_count => x_msg_count,
218: x_msg_data => x_msg_data,

Line 223: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

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

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

227: x_msg_data => x_msg_data,
228: p_api_type => G_API_TYPE);
229: WHEN OTHERS THEN
230:
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,

Line 242: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

238: END raise_delete_event;
239:
240:
241: PROCEDURE raise_add_asset_event (p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,
246: p_chr_id IN NUMBER,

Line 257: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

253: l_parameter_list wf_parameter_list_t;
254: l_process VARCHAR2(20);
255: BEGIN
256:
257: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
258: p_pkg_name => G_PKG_NAME,
259: p_init_msg_list => p_init_msg_list,
260: l_api_version => l_api_version,
261: p_api_version => p_api_version,

Line 285: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

281: x_msg_data => x_msg_data,
282: p_event_name => G_WF_EVT_UBB_ADD_ASSET,
283: p_parameters => l_parameter_list);
284:
285: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
286: ,x_msg_data => x_msg_data);
287:
288: x_return_status := l_return_status;
289: EXCEPTION

Line 292: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

288: x_return_status := l_return_status;
289: EXCEPTION
290: WHEN G_EXCEPTION_ERROR THEN
291:
292: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
293: p_pkg_name => G_PKG_NAME,
294: p_exc_name => G_EXC_NAME_ERROR,
295: x_msg_count => x_msg_count,
296: x_msg_data => x_msg_data,

Line 301: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

297: p_api_type => G_API_TYPE);
298:
299: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
300:
301: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
302: p_pkg_name => G_PKG_NAME,
303: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data,

Line 309: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

305: x_msg_data => x_msg_data,
306: p_api_type => G_API_TYPE);
307: WHEN OTHERS THEN
308:
309: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
310: p_pkg_name => G_PKG_NAME,
311: p_exc_name => G_EXC_NAME_OTHERS,
312: x_msg_count => x_msg_count,
313: x_msg_data => x_msg_data,

Line 319: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

315:
316: END raise_add_asset_event;
317:
318: PROCEDURE raise_delete_asset_event (p_api_version IN NUMBER,
319: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_chr_id IN NUMBER,

Line 334: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

330: l_parameter_list wf_parameter_list_t;
331: l_process VARCHAR2(20);
332: BEGIN
333:
334: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
335: p_pkg_name => G_PKG_NAME,
336: p_init_msg_list => p_init_msg_list,
337: l_api_version => l_api_version,
338: p_api_version => p_api_version,

Line 362: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count

358: x_msg_data => x_msg_data,
359: p_event_name => G_WF_EVT_UBB_REMOVE_ASSET,
360: p_parameters => l_parameter_list);
361:
362: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count
363: ,x_msg_data => x_msg_data);
364:
365: x_return_status := l_return_status;
366: EXCEPTION

Line 369: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

365: x_return_status := l_return_status;
366: EXCEPTION
367: WHEN G_EXCEPTION_ERROR THEN
368:
369: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
370: p_pkg_name => G_PKG_NAME,
371: p_exc_name => G_EXC_NAME_ERROR,
372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data,

Line 378: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

374: p_api_type => G_API_TYPE);
375:
376: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
377:
378: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
379: p_pkg_name => G_PKG_NAME,
380: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
381: x_msg_count => x_msg_count,
382: x_msg_data => x_msg_data,

Line 386: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

382: x_msg_data => x_msg_data,
383: p_api_type => G_API_TYPE);
384: WHEN OTHERS THEN
385:
386: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
387: p_pkg_name => G_PKG_NAME,
388: p_exc_name => G_EXC_NAME_OTHERS,
389: x_msg_count => x_msg_count,
390: x_msg_data => x_msg_data,