eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_POOL_BUDGET_PVT dependencies on OKL_API

Line 35: x_return_status := OKL_API.G_RET_STS_SUCCESS;

31: ) IS
32: l_event_param_list WF_PARAMETER_LIST_T;
33: BEGIN
34: l_event_param_list := p_event_param_list;
35: x_return_status := OKL_API.G_RET_STS_SUCCESS;
36:
37: OKL_WF_PVT.raise_event(p_api_version => p_api_version,
38: p_init_msg_list => p_init_msg_list,
39: x_return_status => x_return_status,

Line 46: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

42: p_event_name => p_event_name,
43: p_parameters => l_event_param_list);
44: EXCEPTION
45: WHEN OTHERS THEN
46: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: END raise_business_event;
49:
50: ---------------------------------------------------------------------------

Line 47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

43: p_parameters => l_event_param_list);
44: EXCEPTION
45: WHEN OTHERS THEN
46: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: END raise_business_event;
49:
50: ---------------------------------------------------------------------------
51: -- Procedures and Functions

Line 114: l_init_msg_list := Okl_Api.g_false;

110: END IF;
111:
112: l_budget_line_tbl := p_budget_line_tbl;
113: l_api_version := 1.0;
114: l_init_msg_list := Okl_Api.g_false;
115: l_msg_count := 0;
116:
117: SAVEPOINT create_budget_line_PVT;
118: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

Line 118: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

114: l_init_msg_list := Okl_Api.g_false;
115: l_msg_count := 0;
116:
117: SAVEPOINT create_budget_line_PVT;
118: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
119: G_PKG_NAME,
120: p_init_msg_list,
121: l_api_version,
122: p_api_version,

Line 126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

122: p_api_version,
123: '_PVT',
124: l_return_status);
125:
126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;

Line 127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

123: '_PVT',
124: l_return_status);
125:
126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;
131: -- TAPI call which inserts the budget line records in the table OKL_SUBSIDY_POOL_BUDGETS_B.

Line 128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

124: l_return_status);
125:
126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;
131: -- TAPI call which inserts the budget line records in the table OKL_SUBSIDY_POOL_BUDGETS_B.
132: okl_sib_pvt.insert_row(l_api_version,

Line 129: RAISE OKL_API.G_EXCEPTION_ERROR;

125:
126: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;
131: -- TAPI call which inserts the budget line records in the table OKL_SUBSIDY_POOL_BUDGETS_B.
132: okl_sib_pvt.insert_row(l_api_version,
133: l_init_msg_list,

Line 140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

136: l_msg_data,
137: l_budget_line_tbl,
138: x_budget_line_tbl);
139:
140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
143: RAISE OKL_API.G_EXCEPTION_ERROR;
144: END IF;

Line 141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

137: l_budget_line_tbl,
138: x_budget_line_tbl);
139:
140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
143: RAISE OKL_API.G_EXCEPTION_ERROR;
144: END IF;
145:

Line 142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

138: x_budget_line_tbl);
139:
140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
143: RAISE OKL_API.G_EXCEPTION_ERROR;
144: END IF;
145:
146: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 143: RAISE OKL_API.G_EXCEPTION_ERROR;

139:
140: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
143: RAISE OKL_API.G_EXCEPTION_ERROR;
144: END IF;
145:
146: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
147: x_return_status := l_return_status;

Line 146: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

142: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
143: RAISE OKL_API.G_EXCEPTION_ERROR;
144: END IF;
145:
146: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
147: x_return_status := l_return_status;
148: x_msg_data := l_msg_data;
149: x_msg_count := l_msg_count;
150:

Line 159: x_return_status := OKL_API.HANDLE_EXCEPTIONS

155: END IF;
156:
157: EXCEPTION
158: WHEN G_EXCEPTION_HALT_VALIDATION THEN
159: x_return_status := OKL_API.HANDLE_EXCEPTIONS
160: (
161: l_api_name,
162: G_PKG_NAME,
163: 'OKL_API.G_RET_STS_ERROR',

Line 163: 'OKL_API.G_RET_STS_ERROR',

159: x_return_status := OKL_API.HANDLE_EXCEPTIONS
160: (
161: l_api_name,
162: G_PKG_NAME,
163: 'OKL_API.G_RET_STS_ERROR',
164: x_msg_count,
165: x_msg_data,
166: '_PVT'
167: );

Line 170: WHEN OKL_API.G_EXCEPTION_ERROR THEN

166: '_PVT'
167: );
168:
169:
170: WHEN OKL_API.G_EXCEPTION_ERROR THEN
171: x_return_status := OKL_API.HANDLE_EXCEPTIONS
172: (
173: l_api_name,
174: G_PKG_NAME,

Line 171: x_return_status := OKL_API.HANDLE_EXCEPTIONS

167: );
168:
169:
170: WHEN OKL_API.G_EXCEPTION_ERROR THEN
171: x_return_status := OKL_API.HANDLE_EXCEPTIONS
172: (
173: l_api_name,
174: G_PKG_NAME,
175: 'OKL_API.G_RET_STS_ERROR',

Line 175: 'OKL_API.G_RET_STS_ERROR',

171: x_return_status := OKL_API.HANDLE_EXCEPTIONS
172: (
173: l_api_name,
174: G_PKG_NAME,
175: 'OKL_API.G_RET_STS_ERROR',
176: x_msg_count,
177: x_msg_data,
178: '_PVT'
179: );

Line 182: x_return_status := OKL_API.HANDLE_EXCEPTIONS

178: '_PVT'
179: );
180:
181: WHEN OTHERS THEN
182: x_return_status := OKL_API.HANDLE_EXCEPTIONS
183: (
184: l_api_name,
185: G_PKG_NAME,
186: 'OKL_API.G_OTHERS',

Line 186: 'OKL_API.G_OTHERS',

182: x_return_status := OKL_API.HANDLE_EXCEPTIONS
183: (
184: l_api_name,
185: G_PKG_NAME,
186: 'OKL_API.G_OTHERS',
187: x_msg_count,
188: x_msg_data,
189: '_PVT'
190: );

Line 255: l_init_msg_list := Okl_Api.g_false;

251: END IF;
252:
253: l_budget_line_tbl := p_budget_line_tbl;
254: l_api_version := 1.0;
255: l_init_msg_list := Okl_Api.g_false;
256: l_msg_count := 0;
257:
258: SAVEPOINT update_budget_line_PVT;
259: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

Line 259: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

255: l_init_msg_list := Okl_Api.g_false;
256: l_msg_count := 0;
257:
258: SAVEPOINT update_budget_line_PVT;
259: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
260: G_PKG_NAME,
261: p_init_msg_list,
262: l_api_version,
263: p_api_version,

Line 267: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

263: p_api_version,
264: '_PVT',
265: l_return_status);
266:
267: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
269: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
270: RAISE OKL_API.G_EXCEPTION_ERROR;
271: END IF;

Line 268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

264: '_PVT',
265: l_return_status);
266:
267: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
269: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
270: RAISE OKL_API.G_EXCEPTION_ERROR;
271: END IF;
272:

Line 269: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

265: l_return_status);
266:
267: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
269: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
270: RAISE OKL_API.G_EXCEPTION_ERROR;
271: END IF;
272:
273: -- TAPI call which updates the budget line records in the table OKL_SUBSIDY_POOL_BUDGETS_B.

Line 270: RAISE OKL_API.G_EXCEPTION_ERROR;

266:
267: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
269: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
270: RAISE OKL_API.G_EXCEPTION_ERROR;
271: END IF;
272:
273: -- TAPI call which updates the budget line records in the table OKL_SUBSIDY_POOL_BUDGETS_B.
274: okl_sib_pvt.update_row (l_api_version,

Line 282: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

278: l_msg_data,
279: l_budget_line_tbl,
280: x_budget_line_tbl);
281:
282: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;

Line 283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

279: l_budget_line_tbl,
280: x_budget_line_tbl);
281:
282: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287:

Line 284: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

280: x_budget_line_tbl);
281:
282: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287:
288: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 285: RAISE OKL_API.G_EXCEPTION_ERROR;

281:
282: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287:
288: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
289: x_return_status := l_return_status;

Line 288: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

284: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE OKL_API.G_EXCEPTION_ERROR;
286: END IF;
287:
288: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
289: x_return_status := l_return_status;
290: x_msg_data := l_msg_data;
291: x_msg_count := l_msg_count;
292:

Line 301: x_return_status := OKL_API.HANDLE_EXCEPTIONS

297: END IF;
298:
299: EXCEPTION
300: WHEN G_EXCEPTION_HALT_VALIDATION THEN
301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
302: (
303: l_api_name,
304: G_PKG_NAME,
305: 'OKL_API.G_RET_STS_ERROR',

Line 305: 'OKL_API.G_RET_STS_ERROR',

301: x_return_status := OKL_API.HANDLE_EXCEPTIONS
302: (
303: l_api_name,
304: G_PKG_NAME,
305: 'OKL_API.G_RET_STS_ERROR',
306: x_msg_count,
307: x_msg_data,
308: '_PVT'
309: );

Line 312: WHEN OKL_API.G_EXCEPTION_ERROR THEN

308: '_PVT'
309: );
310:
311:
312: WHEN OKL_API.G_EXCEPTION_ERROR THEN
313: x_return_status := OKL_API.HANDLE_EXCEPTIONS
314: (
315: l_api_name,
316: G_PKG_NAME,

Line 313: x_return_status := OKL_API.HANDLE_EXCEPTIONS

309: );
310:
311:
312: WHEN OKL_API.G_EXCEPTION_ERROR THEN
313: x_return_status := OKL_API.HANDLE_EXCEPTIONS
314: (
315: l_api_name,
316: G_PKG_NAME,
317: 'OKL_API.G_RET_STS_ERROR',

Line 317: 'OKL_API.G_RET_STS_ERROR',

313: x_return_status := OKL_API.HANDLE_EXCEPTIONS
314: (
315: l_api_name,
316: G_PKG_NAME,
317: 'OKL_API.G_RET_STS_ERROR',
318: x_msg_count,
319: x_msg_data,
320: '_PVT'
321: );

Line 324: x_return_status := OKL_API.HANDLE_EXCEPTIONS

320: '_PVT'
321: );
322:
323: WHEN OTHERS THEN
324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
325: (
326: l_api_name,
327: G_PKG_NAME,
328: 'OKL_API.G_OTHERS',

Line 328: 'OKL_API.G_OTHERS',

324: x_return_status := OKL_API.HANDLE_EXCEPTIONS
325: (
326: l_api_name,
327: G_PKG_NAME,
328: 'OKL_API.G_OTHERS',
329: x_msg_count,
330: x_msg_data,
331: '_PVT'
332: );

Line 431: l_init_msg_list := OKL_API.g_false;

427: END;
428: END IF;
429: l_row_found := FALSE;
430: l_api_version := 1.0;
431: l_init_msg_list := OKL_API.g_false;
432: l_msg_count := 0;
433: l_sub_pool_budget_id := p_sub_pool_budget_id;
434: l_system_date := TRUNC(SYSDATE);
435:

Line 437: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

433: l_sub_pool_budget_id := p_sub_pool_budget_id;
434: l_system_date := TRUNC(SYSDATE);
435:
436: SAVEPOINT set_decision_status_code_PVT;
437: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
438: G_PKG_NAME,
439: p_init_msg_list,
440: l_api_version,
441: p_api_version,

Line 445: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

441: p_api_version,
442: '_PVT',
443: l_return_status);
444:
445: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
446: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
447: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
448: RAISE OKL_API.G_EXCEPTION_ERROR;
449: END IF;

Line 446: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

442: '_PVT',
443: l_return_status);
444:
445: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
446: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
447: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
448: RAISE OKL_API.G_EXCEPTION_ERROR;
449: END IF;
450: -- fetch the record with the passed id and check whether the row exists.

Line 447: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

443: l_return_status);
444:
445: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
446: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
447: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
448: RAISE OKL_API.G_EXCEPTION_ERROR;
449: END IF;
450: -- fetch the record with the passed id and check whether the row exists.
451: OPEN c_get_budget_id(l_sub_pool_budget_id);

Line 448: RAISE OKL_API.G_EXCEPTION_ERROR;

444:
445: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
446: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
447: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
448: RAISE OKL_API.G_EXCEPTION_ERROR;
449: END IF;
450: -- fetch the record with the passed id and check whether the row exists.
451: OPEN c_get_budget_id(l_sub_pool_budget_id);
452: FETCH c_get_budget_id INTO l_budget_line_rec;

Line 469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

465: l_msg_count,
466: l_msg_data,
467: l_budget_line_rec,
468: x_budget_line_rec);
469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
472: RAISE OKL_API.G_EXCEPTION_ERROR;
473: END IF;

Line 470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

466: l_msg_data,
467: l_budget_line_rec,
468: x_budget_line_rec);
469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
472: RAISE OKL_API.G_EXCEPTION_ERROR;
473: END IF;
474: IF(l_budget_line_rec.decision_status_code = 'PENDING')THEN

Line 471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

467: l_budget_line_rec,
468: x_budget_line_rec);
469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
472: RAISE OKL_API.G_EXCEPTION_ERROR;
473: END IF;
474: IF(l_budget_line_rec.decision_status_code = 'PENDING')THEN
475: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.

Line 472: RAISE OKL_API.G_EXCEPTION_ERROR;

468: x_budget_line_rec);
469: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
470: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
472: RAISE OKL_API.G_EXCEPTION_ERROR;
473: END IF;
474: IF(l_budget_line_rec.decision_status_code = 'PENDING')THEN
475: -- add subsidy pool id and subsidy pool to the parameter list and raise the corresponding business event.
476: wf_event.AddParameterToList(G_WF_ITM_SUB_POOL_ID, l_budget_line_rec.subsidy_pool_id, l_parameter_list);

Line 501: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);

497: p_event_param_list => l_parameter_list
498: );
499: END IF;
500: END IF;
501: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
502: x_return_status := l_return_status;
503: x_msg_data := l_msg_data;
504: x_msg_count := l_msg_count;
505:

Line 514: x_return_status := OKL_API.HANDLE_EXCEPTIONS

510: END IF;
511:
512: EXCEPTION
513: WHEN G_EXCEPTION_HALT_VALIDATION THEN
514: x_return_status := OKL_API.HANDLE_EXCEPTIONS
515: (
516: l_api_name,
517: G_PKG_NAME,
518: 'OKL_API.G_RET_STS_ERROR',

Line 518: 'OKL_API.G_RET_STS_ERROR',

514: x_return_status := OKL_API.HANDLE_EXCEPTIONS
515: (
516: l_api_name,
517: G_PKG_NAME,
518: 'OKL_API.G_RET_STS_ERROR',
519: x_msg_count,
520: x_msg_data,
521: '_PVT'
522: );

Line 524: WHEN OKL_API.G_EXCEPTION_ERROR THEN

520: x_msg_data,
521: '_PVT'
522: );
523:
524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
525: x_return_status := OKL_API.HANDLE_EXCEPTIONS
526: (
527: l_api_name,
528: G_PKG_NAME,

Line 525: x_return_status := OKL_API.HANDLE_EXCEPTIONS

521: '_PVT'
522: );
523:
524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
525: x_return_status := OKL_API.HANDLE_EXCEPTIONS
526: (
527: l_api_name,
528: G_PKG_NAME,
529: 'OKL_API.G_RET_STS_ERROR',

Line 529: 'OKL_API.G_RET_STS_ERROR',

525: x_return_status := OKL_API.HANDLE_EXCEPTIONS
526: (
527: l_api_name,
528: G_PKG_NAME,
529: 'OKL_API.G_RET_STS_ERROR',
530: x_msg_count,
531: x_msg_data,
532: '_PVT'
533: );

Line 536: x_return_status := OKL_API.HANDLE_EXCEPTIONS

532: '_PVT'
533: );
534:
535: WHEN OTHERS THEN
536: x_return_status := OKL_API.HANDLE_EXCEPTIONS
537: (
538: l_api_name,
539: G_PKG_NAME,
540: 'OKL_API.G_OTHERS',

Line 540: 'OKL_API.G_OTHERS',

536: x_return_status := OKL_API.HANDLE_EXCEPTIONS
537: (
538: l_api_name,
539: G_PKG_NAME,
540: 'OKL_API.G_OTHERS',
541: x_msg_count,
542: x_msg_data,
543: '_PVT'
544: );

Line 594: l_return_status := OKL_API.G_RET_STS_SUCCESS;

590: BEGIN
591: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSIBB.pls call okl_sib_pvt.validate_row ');
592: END;
593: END IF;
594: l_return_status := OKL_API.G_RET_STS_SUCCESS;
595: -- call START_ACTIVITY to create savepoint, check compatibility
596: -- and initialize message list
597:
598: l_return_status := OKL_API.START_ACTIVITY(

Line 598: l_return_status := OKL_API.START_ACTIVITY(

594: l_return_status := OKL_API.G_RET_STS_SUCCESS;
595: -- call START_ACTIVITY to create savepoint, check compatibility
596: -- and initialize message list
597:
598: l_return_status := OKL_API.START_ACTIVITY(
599: p_api_name => l_api_name,
600: p_pkg_name => g_pkg_name,
601: p_init_msg_list => p_init_msg_list,
602: l_api_version => l_api_version,

Line 608: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

604: p_api_type => g_api_type,
605: x_return_status => x_return_status);
606:
607: -- check if activity started successfully
608: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
609: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
610: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
611: raise OKL_API.G_EXCEPTION_ERROR;
612: End If;

Line 609: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

605: x_return_status => x_return_status);
606:
607: -- check if activity started successfully
608: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
609: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
610: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
611: raise OKL_API.G_EXCEPTION_ERROR;
612: End If;
613:

Line 610: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then

606:
607: -- check if activity started successfully
608: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
609: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
610: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
611: raise OKL_API.G_EXCEPTION_ERROR;
612: End If;
613:
614: l_budget_line_tbl := p_budget_line_tbl;

Line 611: raise OKL_API.G_EXCEPTION_ERROR;

607: -- check if activity started successfully
608: If (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
609: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
610: Elsif (l_return_status = OKL_API.G_RET_STS_ERROR) then
611: raise OKL_API.G_EXCEPTION_ERROR;
612: End If;
613:
614: l_budget_line_tbl := p_budget_line_tbl;
615:

Line 625: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

621: x_msg_data => x_msg_data,
622: p_sibv_tbl => l_budget_line_tbl);
623:
624: -- check return status
625: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
626: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
627: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
628: raise OKL_API.G_EXCEPTION_ERROR;
629: End If;

Line 626: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

622: p_sibv_tbl => l_budget_line_tbl);
623:
624: -- check return status
625: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
626: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
627: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
628: raise OKL_API.G_EXCEPTION_ERROR;
629: End If;
630:

Line 627: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

623:
624: -- check return status
625: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
626: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
627: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
628: raise OKL_API.G_EXCEPTION_ERROR;
629: End If;
630:
631: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 628: raise OKL_API.G_EXCEPTION_ERROR;

624: -- check return status
625: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
626: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
627: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
628: raise OKL_API.G_EXCEPTION_ERROR;
629: End If;
630:
631: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
632: x_msg_data => x_msg_data);

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

627: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
628: raise OKL_API.G_EXCEPTION_ERROR;
629: End If;
630:
631: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
632: x_msg_data => x_msg_data);
633:
634: IF(IS_DEBUG_PROCEDURE_ON) THEN
635: BEGIN

Line 641: when OKL_API.G_EXCEPTION_ERROR then

637: END;
638: END IF;
639:
640: EXCEPTION
641: when OKL_API.G_EXCEPTION_ERROR then
642: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
643: p_api_name => l_api_name,
644: p_pkg_name => g_pkg_name,
645: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 642: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

638: END IF;
639:
640: EXCEPTION
641: when OKL_API.G_EXCEPTION_ERROR then
642: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
643: p_api_name => l_api_name,
644: p_pkg_name => g_pkg_name,
645: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
646: x_msg_count => x_msg_count,

Line 645: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

641: when OKL_API.G_EXCEPTION_ERROR then
642: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
643: p_api_name => l_api_name,
644: p_pkg_name => g_pkg_name,
645: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data,
648: p_api_type => g_api_type);
649:

Line 650: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

646: x_msg_count => x_msg_count,
647: x_msg_data => x_msg_data,
648: p_api_type => g_api_type);
649:
650: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
651: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
652: p_api_name => l_api_name,
653: p_pkg_name => g_pkg_name,
654: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 651: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

647: x_msg_data => x_msg_data,
648: p_api_type => g_api_type);
649:
650: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
651: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
652: p_api_name => l_api_name,
653: p_pkg_name => g_pkg_name,
654: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
655: x_msg_count => x_msg_count,

Line 654: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

650: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
651: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
652: p_api_name => l_api_name,
653: p_pkg_name => g_pkg_name,
654: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
655: x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data,
657: p_api_type => g_api_type);
658:

Line 660: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

656: x_msg_data => x_msg_data,
657: p_api_type => g_api_type);
658:
659: when OTHERS then
660: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
661: p_api_name => l_api_name,
662: p_pkg_name => g_pkg_name,
663: p_exc_name => 'OTHERS',
664: x_msg_count => x_msg_count,