APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKL_API

Line 33: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

Line 45: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 46: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 149: l_init_msg_list := Okl_Api.g_false;

145: -- check for logging on STATEMENT level
146: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
147:
148: l_api_version := 1.0;
149: l_init_msg_list := Okl_Api.g_false;
150: l_msg_count := 0;
151: l_conv_rate := 0;
152: l_round_amount := 0;
153: l_amount := 0;

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

152: l_round_amount := 0;
153: l_amount := 0;
154: l_conv_date := TRUNC(SYSDATE);
155:
156: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
157: G_PKG_NAME,
158: l_init_msg_list,
159: l_api_version,
160: l_api_version,

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

160: l_api_version,
161: '_PVT',
162: l_return_status);
163:
164: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
167: RAISE OKL_API.G_EXCEPTION_ERROR;
168: END IF;

Line 165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

161: '_PVT',
162: l_return_status);
163:
164: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
167: RAISE OKL_API.G_EXCEPTION_ERROR;
168: END IF;
169:

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

162: l_return_status);
163:
164: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
167: RAISE OKL_API.G_EXCEPTION_ERROR;
168: END IF;
169:
170: IF(p_conv_date is null) THEN

Line 167: RAISE OKL_API.G_EXCEPTION_ERROR;

163:
164: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
167: RAISE OKL_API.G_EXCEPTION_ERROR;
168: END IF;
169:
170: IF(p_conv_date is null) THEN
171: l_conv_date := TRUNC(SYSDATE);

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

201:
202: IF(l_conv_rate IS NULL OR l_conv_rate <= 0)THEN
203: return -1;
204: END IF;
205: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
208: RAISE OKL_API.G_EXCEPTION_ERROR;
209: END IF;

Line 206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

202: IF(l_conv_rate IS NULL OR l_conv_rate <= 0)THEN
203: return -1;
204: END IF;
205: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
208: RAISE OKL_API.G_EXCEPTION_ERROR;
209: END IF;
210: -- calculate the amount in terms of the required currency, by multiplying the rate with the given amount.

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

203: return -1;
204: END IF;
205: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
208: RAISE OKL_API.G_EXCEPTION_ERROR;
209: END IF;
210: -- calculate the amount in terms of the required currency, by multiplying the rate with the given amount.
211: x_conv_rate := l_conv_rate;

Line 208: RAISE OKL_API.G_EXCEPTION_ERROR;

204: END IF;
205: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
208: RAISE OKL_API.G_EXCEPTION_ERROR;
209: END IF;
210: -- calculate the amount in terms of the required currency, by multiplying the rate with the given amount.
211: x_conv_rate := l_conv_rate;
212: l_amount := NVL(p_amount,0) * l_conv_rate;

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

226: 'l_amount '||l_amount||' l_round_amount '||l_round_amount
227: );
228: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
229:
230: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;

Line 231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

227: );
228: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
229:
230: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235: ELSE

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

228: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
229:
230: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235: ELSE
236: l_round_amount := NVL(p_amount,0);

Line 233: RAISE OKL_API.G_EXCEPTION_ERROR;

229:
230: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235: ELSE
236: l_round_amount := NVL(p_amount,0);
237: x_conv_rate := 1;

Line 239: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

235: ELSE
236: l_round_amount := NVL(p_amount,0);
237: x_conv_rate := 1;
238: END IF;
239: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
240: RETURN l_round_amount;
241: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
242: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call currency_conversion');
243: END IF;

Line 246: WHEN OKL_API.G_EXCEPTION_ERROR THEN

242: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call currency_conversion');
243: END IF;
244:
245: EXCEPTION
246: WHEN OKL_API.G_EXCEPTION_ERROR THEN
247: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
248: p_api_name => l_api_name,
249: p_pkg_name => G_PKG_NAME,
250: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 247: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

243: END IF;
244:
245: EXCEPTION
246: WHEN OKL_API.G_EXCEPTION_ERROR THEN
247: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
248: p_api_name => l_api_name,
249: p_pkg_name => G_PKG_NAME,
250: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
251: x_msg_count => l_msg_count,

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

246: WHEN OKL_API.G_EXCEPTION_ERROR THEN
247: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
248: p_api_name => l_api_name,
249: p_pkg_name => G_PKG_NAME,
250: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
251: x_msg_count => l_msg_count,
252: x_msg_data => l_msg_data,
253: p_api_type => g_api_type);
254:

Line 255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

251: x_msg_count => l_msg_count,
252: x_msg_data => l_msg_data,
253: p_api_type => g_api_type);
254:
255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
256: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
257: p_api_name => l_api_name,
258: p_pkg_name => G_PKG_NAME,
259: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 256: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

252: x_msg_data => l_msg_data,
253: p_api_type => g_api_type);
254:
255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
256: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
257: p_api_name => l_api_name,
258: p_pkg_name => G_PKG_NAME,
259: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
260: x_msg_count => l_msg_count,

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

255: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
256: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
257: p_api_name => l_api_name,
258: p_pkg_name => G_PKG_NAME,
259: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
260: x_msg_count => l_msg_count,
261: x_msg_data => l_msg_data,
262: p_api_type => g_api_type);
263:

Line 265: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

261: x_msg_data => l_msg_data,
262: p_api_type => g_api_type);
263:
264: WHEN OTHERS THEN
265: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
266: p_api_name => l_api_name,
267: p_pkg_name => G_PKG_NAME,
268: p_exc_name => 'OTHERS',
269: x_msg_count => l_msg_count,

Line 334: l_init_msg_list := Okl_Api.g_false;

330: -- check for logging on STATEMENT level
331: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
332:
333: l_api_version := 1.0;
334: l_init_msg_list := Okl_Api.g_false;
335: l_msg_count := 0;
336: l_total_budget := 0;
337: l_amount := 0;
338: l_conv_rate := 0;

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

336: l_total_budget := 0;
337: l_amount := 0;
338: l_conv_rate := 0;
339:
340: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
341: G_PKG_NAME,
342: l_init_msg_list,
343: l_api_version,
344: l_api_version,

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

344: l_api_version,
345: '_PVT',
346: l_return_status);
347:
348: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
350: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
351: RAISE OKL_API.G_EXCEPTION_ERROR;
352: END IF;

Line 349: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

345: '_PVT',
346: l_return_status);
347:
348: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
350: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
351: RAISE OKL_API.G_EXCEPTION_ERROR;
352: END IF;
353:

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

346: l_return_status);
347:
348: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
350: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
351: RAISE OKL_API.G_EXCEPTION_ERROR;
352: END IF;
353:
354: l_total_budget := 0;

Line 351: RAISE OKL_API.G_EXCEPTION_ERROR;

347:
348: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
350: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
351: RAISE OKL_API.G_EXCEPTION_ERROR;
352: END IF;
353:
354: l_total_budget := 0;
355: -- Get the total budgets for the subsidy pool till the p_input_date specified.

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

389: );
390: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
391:
392: END LOOP;
393: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
394: x_return_status := l_return_status;
395: x_msg_data := l_msg_data;
396: x_msg_count := l_msg_count;
397: RETURN l_total_budget;

Line 405: x_return_status := OKL_API.HANDLE_EXCEPTIONS

401: END IF;
402:
403: EXCEPTION
404: WHEN G_EXCEPTION_HALT_VALIDATION THEN
405: x_return_status := OKL_API.HANDLE_EXCEPTIONS
406: (
407: l_api_name,
408: G_PKG_NAME,
409: 'OKL_API.G_RET_STS_ERROR',

Line 409: 'OKL_API.G_RET_STS_ERROR',

405: x_return_status := OKL_API.HANDLE_EXCEPTIONS
406: (
407: l_api_name,
408: G_PKG_NAME,
409: 'OKL_API.G_RET_STS_ERROR',
410: x_msg_count,
411: x_msg_data,
412: '_PVT'
413: );

Line 415: WHEN OKL_API.G_EXCEPTION_ERROR THEN

411: x_msg_data,
412: '_PVT'
413: );
414:
415: WHEN OKL_API.G_EXCEPTION_ERROR THEN
416: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
417: p_api_name => l_api_name,
418: p_pkg_name => G_PKG_NAME,
419: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 416: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

412: '_PVT'
413: );
414:
415: WHEN OKL_API.G_EXCEPTION_ERROR THEN
416: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
417: p_api_name => l_api_name,
418: p_pkg_name => G_PKG_NAME,
419: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
420: x_msg_count => x_msg_count,

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

415: WHEN OKL_API.G_EXCEPTION_ERROR THEN
416: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
417: p_api_name => l_api_name,
418: p_pkg_name => G_PKG_NAME,
419: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
420: x_msg_count => x_msg_count,
421: x_msg_data => x_msg_data,
422: p_api_type => g_api_type);
423:

Line 424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

420: x_msg_count => x_msg_count,
421: x_msg_data => x_msg_data,
422: p_api_type => g_api_type);
423:
424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
425: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
426: p_api_name => l_api_name,
427: p_pkg_name => G_PKG_NAME,
428: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 425: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

421: x_msg_data => x_msg_data,
422: p_api_type => g_api_type);
423:
424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
425: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
426: p_api_name => l_api_name,
427: p_pkg_name => G_PKG_NAME,
428: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
429: x_msg_count => x_msg_count,

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

424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
425: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
426: p_api_name => l_api_name,
427: p_pkg_name => G_PKG_NAME,
428: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
429: x_msg_count => x_msg_count,
430: x_msg_data => x_msg_data,
431: p_api_type => g_api_type);
432:

Line 434: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

430: x_msg_data => x_msg_data,
431: p_api_type => g_api_type);
432:
433: WHEN OTHERS THEN
434: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
435: p_api_name => l_api_name,
436: p_pkg_name => G_PKG_NAME,
437: p_exc_name => 'OTHERS',
438: x_msg_count => x_msg_count,

Line 509: l_init_msg_list := Okl_Api.g_false;

505: -- check for logging on STATEMENT level
506: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
507:
508: l_api_version := 1.0;
509: l_init_msg_list := Okl_Api.g_false;
510: l_msg_count := 0;
511: l_trx_amount := 0;
512: l_amount := 0;
513: l_conv_rate := 0;

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

511: l_trx_amount := 0;
512: l_amount := 0;
513: l_conv_rate := 0;
514:
515: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
516: G_PKG_NAME,
517: l_init_msg_list,
518: l_api_version,
519: l_api_version,

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

519: l_api_version,
520: '_PVT',
521: l_return_status);
522:
523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
526: RAISE OKL_API.G_EXCEPTION_ERROR;
527: END IF;

Line 524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

520: '_PVT',
521: l_return_status);
522:
523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
526: RAISE OKL_API.G_EXCEPTION_ERROR;
527: END IF;
528:

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

521: l_return_status);
522:
523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
526: RAISE OKL_API.G_EXCEPTION_ERROR;
527: END IF;
528:
529: l_trx_amount := 0;

Line 526: RAISE OKL_API.G_EXCEPTION_ERROR;

522:
523: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
525: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
526: RAISE OKL_API.G_EXCEPTION_ERROR;
527: END IF;
528:
529: l_trx_amount := 0;
530: -- Calculate the total transactions for the given subsidy pool uptill the p_input_date.

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

570: );
571: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
572:
573: END LOOP;
574: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
575: x_return_status := l_return_status;
576: x_msg_data := l_msg_data;
577: x_msg_count := l_msg_count;
578: RETURN l_trx_amount;

Line 584: x_return_status := OKL_API.HANDLE_EXCEPTIONS

580: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call transaction_amount');
581: END IF;
582: EXCEPTION
583: WHEN G_EXCEPTION_HALT_VALIDATION THEN
584: x_return_status := OKL_API.HANDLE_EXCEPTIONS
585: (
586: l_api_name,
587: G_PKG_NAME,
588: 'OKL_API.G_RET_STS_ERROR',

Line 588: 'OKL_API.G_RET_STS_ERROR',

584: x_return_status := OKL_API.HANDLE_EXCEPTIONS
585: (
586: l_api_name,
587: G_PKG_NAME,
588: 'OKL_API.G_RET_STS_ERROR',
589: x_msg_count,
590: x_msg_data,
591: '_PVT'
592: );

Line 594: WHEN OKL_API.G_EXCEPTION_ERROR THEN

590: x_msg_data,
591: '_PVT'
592: );
593:
594: WHEN OKL_API.G_EXCEPTION_ERROR THEN
595: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
596: p_api_name => l_api_name,
597: p_pkg_name => G_PKG_NAME,
598: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 595: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

591: '_PVT'
592: );
593:
594: WHEN OKL_API.G_EXCEPTION_ERROR THEN
595: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
596: p_api_name => l_api_name,
597: p_pkg_name => G_PKG_NAME,
598: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
599: x_msg_count => x_msg_count,

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

594: WHEN OKL_API.G_EXCEPTION_ERROR THEN
595: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
596: p_api_name => l_api_name,
597: p_pkg_name => G_PKG_NAME,
598: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
599: x_msg_count => x_msg_count,
600: x_msg_data => x_msg_data,
601: p_api_type => g_api_type);
602:

Line 603: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

599: x_msg_count => x_msg_count,
600: x_msg_data => x_msg_data,
601: p_api_type => g_api_type);
602:
603: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
604: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
605: p_api_name => l_api_name,
606: p_pkg_name => G_PKG_NAME,
607: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 604: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

600: x_msg_data => x_msg_data,
601: p_api_type => g_api_type);
602:
603: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
604: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
605: p_api_name => l_api_name,
606: p_pkg_name => G_PKG_NAME,
607: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
608: x_msg_count => x_msg_count,

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

603: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
604: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
605: p_api_name => l_api_name,
606: p_pkg_name => G_PKG_NAME,
607: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
608: x_msg_count => x_msg_count,
609: x_msg_data => x_msg_data,
610: p_api_type => g_api_type);
611:

Line 613: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

609: x_msg_data => x_msg_data,
610: p_api_type => g_api_type);
611:
612: WHEN OTHERS THEN
613: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
614: p_api_name => l_api_name,
615: p_pkg_name => G_PKG_NAME,
616: p_exc_name => 'OTHERS',
617: x_msg_count => x_msg_count,

Line 744: l_init_msg_list := Okl_Api.g_false;

740: -- check for logging on STATEMENT level
741: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
742:
743: l_api_version := 1.0;
744: l_init_msg_list := Okl_Api.g_false;
745: l_msg_count := 0;
746: l_total_budget := 0;
747: l_budget := 0;
748: l_trx_amount := 0;

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

750: l_remaining_balance := 0;
751: l_conv_rate := 0;
752: l_reporting_limit := p_pool_rec.reporting_pool_limit;
753:
754: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
755: G_PKG_NAME,
756: l_init_msg_list,
757: l_api_version,
758: l_api_version,

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

758: l_api_version,
759: '_PVT',
760: l_return_status);
761:
762: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
763: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
764: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
765: RAISE OKL_API.G_EXCEPTION_ERROR;
766: END IF;

Line 763: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

759: '_PVT',
760: l_return_status);
761:
762: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
763: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
764: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
765: RAISE OKL_API.G_EXCEPTION_ERROR;
766: END IF;
767:

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

760: l_return_status);
761:
762: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
763: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
764: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
765: RAISE OKL_API.G_EXCEPTION_ERROR;
766: END IF;
767:
768: -- Parent pool header with the parent pool name.

Line 765: RAISE OKL_API.G_EXCEPTION_ERROR;

761:
762: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
763: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
764: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
765: RAISE OKL_API.G_EXCEPTION_ERROR;
766: END IF;
767:
768: -- Parent pool header with the parent pool name.
769: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

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

810: l_return_status,
811: l_msg_count,
812: l_msg_data
813: );
814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_ERROR;
818: END IF;

Line 815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

811: l_msg_count,
812: l_msg_data
813: );
814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_ERROR;
818: END IF;
819: l_total_budget := l_total_budget + l_budget;

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

812: l_msg_data
813: );
814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_ERROR;
818: END IF;
819: l_total_budget := l_total_budget + l_budget;
820: l_trx_amt := transaction_amount( each_row.id,

Line 817: RAISE OKL_API.G_EXCEPTION_ERROR;

813: );
814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKL_API.G_EXCEPTION_ERROR;
818: END IF;
819: l_total_budget := l_total_budget + l_budget;
820: l_trx_amt := transaction_amount( each_row.id,
821: p_input_date,

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

825: l_return_status,
826: l_msg_count,
827: l_msg_data
828: );
829: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;

Line 830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

826: l_msg_count,
827: l_msg_data
828: );
829: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
834: l_trx_amount := l_trx_amount + l_trx_amt;

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

827: l_msg_data
828: );
829: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
834: l_trx_amount := l_trx_amount + l_trx_amt;
835: END LOOP;

Line 832: RAISE OKL_API.G_EXCEPTION_ERROR;

828: );
829: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
834: l_trx_amount := l_trx_amount + l_trx_amt;
835: END LOOP;
836: -- if subsidy pool type is budget, simply calculate the total budgets and remaining balance.

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

843: l_return_status,
844: l_msg_count,
845: l_msg_data
846: );
847: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
849: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
850: RAISE OKL_API.G_EXCEPTION_ERROR;
851: END IF;

Line 848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

844: l_msg_count,
845: l_msg_data
846: );
847: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
849: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
850: RAISE OKL_API.G_EXCEPTION_ERROR;
851: END IF;
852: l_total_budget := l_budget;

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

845: l_msg_data
846: );
847: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
849: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
850: RAISE OKL_API.G_EXCEPTION_ERROR;
851: END IF;
852: l_total_budget := l_budget;
853: l_trx_amt := transaction_amount( p_pool_rec.id,

Line 850: RAISE OKL_API.G_EXCEPTION_ERROR;

846: );
847: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
848: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
849: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
850: RAISE OKL_API.G_EXCEPTION_ERROR;
851: END IF;
852: l_total_budget := l_budget;
853: l_trx_amt := transaction_amount( p_pool_rec.id,
854: p_input_date,

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

858: l_return_status,
859: l_msg_count,
860: l_msg_data
861: );
862: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;

Line 863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

859: l_msg_count,
860: l_msg_data
861: );
862: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867: l_trx_amount := l_trx_amt;

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

860: l_msg_data
861: );
862: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867: l_trx_amount := l_trx_amt;
868: END IF;

Line 865: RAISE OKL_API.G_EXCEPTION_ERROR;

861: );
862: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
865: RAISE OKL_API.G_EXCEPTION_ERROR;
866: END IF;
867: l_trx_amount := l_trx_amt;
868: END IF;
869: l_remaining_balance := l_total_budget - l_trx_amount;

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

886: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_total_budget,p_to_currency_code),l_Budget_len,'DATA')||' '||
887: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));
888: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
889:
890: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
891: x_return_status := l_return_status;
892: x_msg_data := l_msg_data;
893: x_msg_count := l_msg_count;
894:

Line 901: x_return_status := OKL_API.HANDLE_EXCEPTIONS

897: END IF;
898:
899: EXCEPTION
900: WHEN G_EXCEPTION_HALT_VALIDATION THEN
901: x_return_status := OKL_API.HANDLE_EXCEPTIONS
902: (
903: l_api_name,
904: G_PKG_NAME,
905: 'OKL_API.G_RET_STS_ERROR',

Line 905: 'OKL_API.G_RET_STS_ERROR',

901: x_return_status := OKL_API.HANDLE_EXCEPTIONS
902: (
903: l_api_name,
904: G_PKG_NAME,
905: 'OKL_API.G_RET_STS_ERROR',
906: x_msg_count,
907: x_msg_data,
908: '_PVT'
909: );

Line 911: WHEN OKL_API.G_EXCEPTION_ERROR THEN

907: x_msg_data,
908: '_PVT'
909: );
910:
911: WHEN OKL_API.G_EXCEPTION_ERROR THEN
912: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
913: p_api_name => l_api_name,
914: p_pkg_name => G_PKG_NAME,
915: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 912: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

908: '_PVT'
909: );
910:
911: WHEN OKL_API.G_EXCEPTION_ERROR THEN
912: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
913: p_api_name => l_api_name,
914: p_pkg_name => G_PKG_NAME,
915: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
916: x_msg_count => x_msg_count,

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

911: WHEN OKL_API.G_EXCEPTION_ERROR THEN
912: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
913: p_api_name => l_api_name,
914: p_pkg_name => G_PKG_NAME,
915: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
916: x_msg_count => x_msg_count,
917: x_msg_data => x_msg_data,
918: p_api_type => g_api_type);
919:

Line 920: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

916: x_msg_count => x_msg_count,
917: x_msg_data => x_msg_data,
918: p_api_type => g_api_type);
919:
920: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
921: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
922: p_api_name => l_api_name,
923: p_pkg_name => G_PKG_NAME,
924: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 921: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

917: x_msg_data => x_msg_data,
918: p_api_type => g_api_type);
919:
920: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
921: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
922: p_api_name => l_api_name,
923: p_pkg_name => G_PKG_NAME,
924: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
925: x_msg_count => x_msg_count,

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

920: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
921: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
922: p_api_name => l_api_name,
923: p_pkg_name => G_PKG_NAME,
924: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
925: x_msg_count => x_msg_count,
926: x_msg_data => x_msg_data,
927: p_api_type => g_api_type);
928:

Line 930: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

926: x_msg_data => x_msg_data,
927: p_api_type => g_api_type);
928:
929: WHEN OTHERS THEN
930: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
931: p_api_name => l_api_name,
932: p_pkg_name => G_PKG_NAME,
933: p_exc_name => 'OTHERS',
934: x_msg_count => x_msg_count,

Line 1065: l_init_msg_list := Okl_Api.g_false;

1061: -- check for logging on STATEMENT level
1062: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1063:
1064: l_api_version := 1.0;
1065: l_init_msg_list := Okl_Api.g_false;
1066: l_msg_count := 0;
1067: l_total_budget := 0;
1068: l_budget := 0;
1069: l_trx_amount := 0;

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

1071: l_remaining_balance := 0;
1072: l_conv_rate := 0;
1073: i := 0;
1074:
1075: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
1076: G_PKG_NAME,
1077: l_init_msg_list,
1078: l_api_version,
1079: l_api_version,

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

1079: l_api_version,
1080: '_PVT',
1081: l_return_status);
1082:
1083: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1086: RAISE OKL_API.G_EXCEPTION_ERROR;
1087: END IF;

Line 1084: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1080: '_PVT',
1081: l_return_status);
1082:
1083: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1086: RAISE OKL_API.G_EXCEPTION_ERROR;
1087: END IF;
1088:

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

1081: l_return_status);
1082:
1083: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1086: RAISE OKL_API.G_EXCEPTION_ERROR;
1087: END IF;
1088:
1089: -- Print child header.

Line 1086: RAISE OKL_API.G_EXCEPTION_ERROR;

1082:
1083: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1084: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1085: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1086: RAISE OKL_API.G_EXCEPTION_ERROR;
1087: END IF;
1088:
1089: -- Print child header.
1090: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

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

1117: l_return_status,
1118: l_msg_count,
1119: l_msg_data
1120: );
1121: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1124: RAISE OKL_API.G_EXCEPTION_ERROR;
1125: END IF;

Line 1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1118: l_msg_count,
1119: l_msg_data
1120: );
1121: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1124: RAISE OKL_API.G_EXCEPTION_ERROR;
1125: END IF;
1126: l_total_budget := l_total_budget + l_budget;

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

1119: l_msg_data
1120: );
1121: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1124: RAISE OKL_API.G_EXCEPTION_ERROR;
1125: END IF;
1126: l_total_budget := l_total_budget + l_budget;
1127: l_trx_amt := transaction_amount( each_row.id,

Line 1124: RAISE OKL_API.G_EXCEPTION_ERROR;

1120: );
1121: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1124: RAISE OKL_API.G_EXCEPTION_ERROR;
1125: END IF;
1126: l_total_budget := l_total_budget + l_budget;
1127: l_trx_amt := transaction_amount( each_row.id,
1128: p_input_date,

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

1132: l_return_status,
1133: l_msg_count,
1134: l_msg_data
1135: );
1136: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1138: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1139: RAISE OKL_API.G_EXCEPTION_ERROR;
1140: END IF;

Line 1137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1133: l_msg_count,
1134: l_msg_data
1135: );
1136: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1138: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1139: RAISE OKL_API.G_EXCEPTION_ERROR;
1140: END IF;
1141: l_trx_amount := l_trx_amount + l_trx_amt;

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

1134: l_msg_data
1135: );
1136: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1138: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1139: RAISE OKL_API.G_EXCEPTION_ERROR;
1140: END IF;
1141: l_trx_amount := l_trx_amount + l_trx_amt;
1142: END LOOP;

Line 1139: RAISE OKL_API.G_EXCEPTION_ERROR;

1135: );
1136: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1138: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1139: RAISE OKL_API.G_EXCEPTION_ERROR;
1140: END IF;
1141: l_trx_amount := l_trx_amount + l_trx_amt;
1142: END LOOP;
1143: ELSE

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

1150: l_return_status,
1151: l_msg_count,
1152: l_msg_data
1153: );
1154: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1156: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1157: RAISE OKL_API.G_EXCEPTION_ERROR;
1158: END IF;

Line 1155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1151: l_msg_count,
1152: l_msg_data
1153: );
1154: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1156: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1157: RAISE OKL_API.G_EXCEPTION_ERROR;
1158: END IF;
1159: l_total_budget := l_budget;

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

1152: l_msg_data
1153: );
1154: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1156: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1157: RAISE OKL_API.G_EXCEPTION_ERROR;
1158: END IF;
1159: l_total_budget := l_budget;
1160: l_trx_amt := transaction_amount( p_pool_tbl(i).id,

Line 1157: RAISE OKL_API.G_EXCEPTION_ERROR;

1153: );
1154: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1155: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1156: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1157: RAISE OKL_API.G_EXCEPTION_ERROR;
1158: END IF;
1159: l_total_budget := l_budget;
1160: l_trx_amt := transaction_amount( p_pool_tbl(i).id,
1161: p_input_date,

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

1165: l_return_status,
1166: l_msg_count,
1167: l_msg_data
1168: );
1169: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_ERROR;
1173: END IF;

Line 1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1166: l_msg_count,
1167: l_msg_data
1168: );
1169: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_ERROR;
1173: END IF;
1174: l_trx_amount := l_trx_amt;

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

1167: l_msg_data
1168: );
1169: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_ERROR;
1173: END IF;
1174: l_trx_amount := l_trx_amt;
1175: END IF;

Line 1172: RAISE OKL_API.G_EXCEPTION_ERROR;

1168: );
1169: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1170: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1171: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_ERROR;
1173: END IF;
1174: l_trx_amount := l_trx_amt;
1175: END IF;
1176: l_remaining_balance := l_total_budget - l_trx_amount;

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

1212: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code),l_Remaining_Balance_len,'DATA'));
1213: END LOOP;
1214: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1215:
1216: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1217: x_return_status := l_return_status;
1218: x_msg_data := l_msg_data;
1219: x_msg_count := l_msg_count;
1220:

Line 1227: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1223: END IF;
1224:
1225: EXCEPTION
1226: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1227: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1228: (
1229: l_api_name,
1230: G_PKG_NAME,
1231: 'OKL_API.G_RET_STS_ERROR',

Line 1231: 'OKL_API.G_RET_STS_ERROR',

1227: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1228: (
1229: l_api_name,
1230: G_PKG_NAME,
1231: 'OKL_API.G_RET_STS_ERROR',
1232: x_msg_count,
1233: x_msg_data,
1234: '_PVT'
1235: );

Line 1237: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1233: x_msg_data,
1234: '_PVT'
1235: );
1236:
1237: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1238: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1239: p_api_name => l_api_name,
1240: p_pkg_name => G_PKG_NAME,
1241: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1238: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1234: '_PVT'
1235: );
1236:
1237: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1238: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1239: p_api_name => l_api_name,
1240: p_pkg_name => G_PKG_NAME,
1241: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1242: x_msg_count => x_msg_count,

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

1237: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1238: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1239: p_api_name => l_api_name,
1240: p_pkg_name => G_PKG_NAME,
1241: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1242: x_msg_count => x_msg_count,
1243: x_msg_data => x_msg_data,
1244: p_api_type => g_api_type);
1245:

Line 1246: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1242: x_msg_count => x_msg_count,
1243: x_msg_data => x_msg_data,
1244: p_api_type => g_api_type);
1245:
1246: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1247: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1248: p_api_name => l_api_name,
1249: p_pkg_name => G_PKG_NAME,
1250: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1247: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1243: x_msg_data => x_msg_data,
1244: p_api_type => g_api_type);
1245:
1246: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1247: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1248: p_api_name => l_api_name,
1249: p_pkg_name => G_PKG_NAME,
1250: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1251: x_msg_count => x_msg_count,

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

1246: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1247: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1248: p_api_name => l_api_name,
1249: p_pkg_name => G_PKG_NAME,
1250: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1251: x_msg_count => x_msg_count,
1252: x_msg_data => x_msg_data,
1253: p_api_type => g_api_type);
1254:

Line 1256: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1252: x_msg_data => x_msg_data,
1253: p_api_type => g_api_type);
1254:
1255: WHEN OTHERS THEN
1256: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1257: p_api_name => l_api_name,
1258: p_pkg_name => G_PKG_NAME,
1259: p_exc_name => 'OTHERS',
1260: x_msg_count => x_msg_count,

Line 1322: l_init_msg_list := Okl_Api.g_false;

1318: -- check for logging on STATEMENT level
1319: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1320:
1321: l_api_version := 1.0;
1322: l_init_msg_list := Okl_Api.g_false;
1323: l_msg_count := 0;
1324: i := 0;
1325: j := 0;
1326: k := 0;

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

1329: l_trx_amount := 0;
1330: l_remaining_balance := 0;
1331: l_sysdate := TRUNC(SYSDATE);
1332:
1333: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
1334: G_PKG_NAME,
1335: l_init_msg_list,
1336: l_api_version,
1337: l_api_version,

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

1336: l_api_version,
1337: l_api_version,
1338: '_PVT',
1339: l_return_status);
1340: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1341: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1342: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1343: RAISE OKL_API.G_EXCEPTION_ERROR;
1344: END IF;

Line 1341: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1337: l_api_version,
1338: '_PVT',
1339: l_return_status);
1340: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1341: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1342: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1343: RAISE OKL_API.G_EXCEPTION_ERROR;
1344: END IF;
1345:

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

1338: '_PVT',
1339: l_return_status);
1340: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1341: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1342: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1343: RAISE OKL_API.G_EXCEPTION_ERROR;
1344: END IF;
1345:
1346: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_date);

Line 1343: RAISE OKL_API.G_EXCEPTION_ERROR;

1339: l_return_status);
1340: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1341: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1342: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1343: RAISE OKL_API.G_EXCEPTION_ERROR;
1344: END IF;
1345:
1346: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_date);
1347:

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

1376: l_return_status,
1377: l_msg_count,
1378: l_msg_data
1379: );
1380: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1383: RAISE OKL_API.G_EXCEPTION_ERROR;
1384: END IF;

Line 1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1377: l_msg_count,
1378: l_msg_data
1379: );
1380: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1383: RAISE OKL_API.G_EXCEPTION_ERROR;
1384: END IF;
1385: END IF;

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

1378: l_msg_data
1379: );
1380: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1383: RAISE OKL_API.G_EXCEPTION_ERROR;
1384: END IF;
1385: END IF;
1386: -- Get all the child records of this parent subsidy pool.

Line 1383: RAISE OKL_API.G_EXCEPTION_ERROR;

1379: );
1380: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1383: RAISE OKL_API.G_EXCEPTION_ERROR;
1384: END IF;
1385: END IF;
1386: -- Get all the child records of this parent subsidy pool.
1387: l_subsidy_pool_tbl := get_child_record(l_pool_rec.id);

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

1403: l_return_status,
1404: l_msg_count,
1405: l_msg_data
1406: );
1407: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1408: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1409: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1410: RAISE OKL_API.G_EXCEPTION_ERROR;
1411: END IF;

Line 1408: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1404: l_msg_count,
1405: l_msg_data
1406: );
1407: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1408: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1409: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1410: RAISE OKL_API.G_EXCEPTION_ERROR;
1411: END IF;
1412: END IF;

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

1405: l_msg_data
1406: );
1407: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1408: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1409: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1410: RAISE OKL_API.G_EXCEPTION_ERROR;
1411: END IF;
1412: END IF;
1413:

Line 1410: RAISE OKL_API.G_EXCEPTION_ERROR;

1406: );
1407: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1408: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1409: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1410: RAISE OKL_API.G_EXCEPTION_ERROR;
1411: END IF;
1412: END IF;
1413:
1414: -- for all the child records, search if any further childs of these records

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

1439: l_return_status,
1440: l_msg_count,
1441: l_msg_data
1442: );
1443: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1445: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1446: RAISE OKL_API.G_EXCEPTION_ERROR;
1447: END IF;

Line 1444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1440: l_msg_count,
1441: l_msg_data
1442: );
1443: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1445: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1446: RAISE OKL_API.G_EXCEPTION_ERROR;
1447: END IF;
1448: print_child_record(l_tbl,

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

1441: l_msg_data
1442: );
1443: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1445: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1446: RAISE OKL_API.G_EXCEPTION_ERROR;
1447: END IF;
1448: print_child_record(l_tbl,
1449: l_from_date,

Line 1446: RAISE OKL_API.G_EXCEPTION_ERROR;

1442: );
1443: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1444: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1445: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1446: RAISE OKL_API.G_EXCEPTION_ERROR;
1447: END IF;
1448: print_child_record(l_tbl,
1449: l_from_date,
1450: l_pool_rec.currency_code,

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

1452: l_return_status,
1453: l_msg_count,
1454: l_msg_data
1455: );
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;

Line 1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1453: l_msg_count,
1454: l_msg_data
1455: );
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;
1461: l_count := l_subsidy_pool_tbl.count + 1;

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

1454: l_msg_data
1455: );
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;
1461: l_count := l_subsidy_pool_tbl.count + 1;
1462: -- Appending in the array if the child records are found.

Line 1459: RAISE OKL_API.G_EXCEPTION_ERROR;

1455: );
1456: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;
1461: l_count := l_subsidy_pool_tbl.count + 1;
1462: -- Appending in the array if the child records are found.
1463: FOR k IN l_tbl.first..l_tbl.last LOOP

Line 1472: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

1468: j := l_subsidy_pool_tbl.count;
1469: i := i + 1;
1470: END LOOP;
1471: END IF;
1472: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
1473:
1474: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1475: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call pool_assoc_report');
1476: END IF;

Line 1479: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1475: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call pool_assoc_report');
1476: END IF;
1477:
1478: EXCEPTION
1479: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1480: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1481: p_api_name => l_api_name,
1482: p_pkg_name => G_PKG_NAME,
1483: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1480: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1476: END IF;
1477:
1478: EXCEPTION
1479: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1480: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1481: p_api_name => l_api_name,
1482: p_pkg_name => G_PKG_NAME,
1483: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1484: x_msg_count => l_msg_count,

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

1479: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1480: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1481: p_api_name => l_api_name,
1482: p_pkg_name => G_PKG_NAME,
1483: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1484: x_msg_count => l_msg_count,
1485: x_msg_data => l_msg_data,
1486: p_api_type => g_api_type);
1487:

Line 1488: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1484: x_msg_count => l_msg_count,
1485: x_msg_data => l_msg_data,
1486: p_api_type => g_api_type);
1487:
1488: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1489: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1490: p_api_name => l_api_name,
1491: p_pkg_name => G_PKG_NAME,
1492: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1489: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

1485: x_msg_data => l_msg_data,
1486: p_api_type => g_api_type);
1487:
1488: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1489: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1490: p_api_name => l_api_name,
1491: p_pkg_name => G_PKG_NAME,
1492: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1493: x_msg_count => l_msg_count,

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

1488: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1489: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
1490: p_api_name => l_api_name,
1491: p_pkg_name => G_PKG_NAME,
1492: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1493: x_msg_count => l_msg_count,
1494: x_msg_data => l_msg_data,
1495: p_api_type => g_api_type);
1496:

Line 1580: l_init_msg_list := Okl_Api.g_false;

1576: -- check for logging on STATEMENT level
1577: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1578:
1579: l_api_version := 1.0;
1580: l_init_msg_list := Okl_Api.g_false;
1581: l_msg_count := 0;
1582: l_budget := 0;
1583: l_trx_amt := 0;
1584: l_amount := 0;

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

1583: l_trx_amt := 0;
1584: l_amount := 0;
1585: l_remaining_balance := 0;
1586:
1587: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
1588: G_PKG_NAME,
1589: l_init_msg_list,
1590: l_api_version,
1591: l_api_version,

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

1591: l_api_version,
1592: '_PVT',
1593: l_return_status);
1594:
1595: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;

Line 1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1592: '_PVT',
1593: l_return_status);
1594:
1595: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;
1600:

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

1593: l_return_status);
1594:
1595: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;
1600:
1601: -- If subsidy pool type is "Budget" then pick the values for total budgets

Line 1598: RAISE OKL_API.G_EXCEPTION_ERROR;

1594:
1595: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1596: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1597: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1598: RAISE OKL_API.G_EXCEPTION_ERROR;
1599: END IF;
1600:
1601: -- If subsidy pool type is "Budget" then pick the values for total budgets
1602: -- from the okl_subsidy_pools_b table and calculate the total transaction amount

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

1624: l_return_status,
1625: l_msg_count,
1626: l_msg_data
1627: );
1628: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1629: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1630: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1631: RAISE OKL_API.G_EXCEPTION_ERROR;
1632: END IF;

Line 1629: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1625: l_msg_count,
1626: l_msg_data
1627: );
1628: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1629: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1630: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1631: RAISE OKL_API.G_EXCEPTION_ERROR;
1632: END IF;
1633: -- calculate the total transaction amount for the subsidy pool.

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

1626: l_msg_data
1627: );
1628: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1629: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1630: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1631: RAISE OKL_API.G_EXCEPTION_ERROR;
1632: END IF;
1633: -- calculate the total transaction amount for the subsidy pool.
1634: l_trx_amt := transaction_amount( p_pool_rec.id,

Line 1631: RAISE OKL_API.G_EXCEPTION_ERROR;

1627: );
1628: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1629: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1630: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1631: RAISE OKL_API.G_EXCEPTION_ERROR;
1632: END IF;
1633: -- calculate the total transaction amount for the subsidy pool.
1634: l_trx_amt := transaction_amount( p_pool_rec.id,
1635: p_to_date,

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

1639: l_return_status,
1640: l_msg_count,
1641: l_msg_data
1642: );
1643: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1646: RAISE OKL_API.G_EXCEPTION_ERROR;
1647: END IF;

Line 1644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1640: l_msg_count,
1641: l_msg_data
1642: );
1643: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1646: RAISE OKL_API.G_EXCEPTION_ERROR;
1647: END IF;
1648: -- remaining balance for subsidy pool is total budgets minus the total transaction amount.

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

1641: l_msg_data
1642: );
1643: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1646: RAISE OKL_API.G_EXCEPTION_ERROR;
1647: END IF;
1648: -- remaining balance for subsidy pool is total budgets minus the total transaction amount.
1649: l_remaining_balance := l_budget - l_trx_amt;

Line 1646: RAISE OKL_API.G_EXCEPTION_ERROR;

1642: );
1643: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1646: RAISE OKL_API.G_EXCEPTION_ERROR;
1647: END IF;
1648: -- remaining balance for subsidy pool is total budgets minus the total transaction amount.
1649: l_remaining_balance := l_budget - l_trx_amt;
1650:

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

1694: l_return_status,
1695: l_msg_count,
1696: l_msg_data
1697: );
1698: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1701: RAISE OKL_API.G_EXCEPTION_ERROR;
1702: END IF;

Line 1699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1695: l_msg_count,
1696: l_msg_data
1697: );
1698: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1701: RAISE OKL_API.G_EXCEPTION_ERROR;
1702: END IF;
1703: l_trx_amt := l_trx_amt + l_amount;

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

1696: l_msg_data
1697: );
1698: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1701: RAISE OKL_API.G_EXCEPTION_ERROR;
1702: END IF;
1703: l_trx_amt := l_trx_amt + l_amount;
1704: END LOOP;

Line 1701: RAISE OKL_API.G_EXCEPTION_ERROR;

1697: );
1698: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1701: RAISE OKL_API.G_EXCEPTION_ERROR;
1702: END IF;
1703: l_trx_amt := l_trx_amt + l_amount;
1704: END LOOP;
1705: -- Print the subsidy pool sumaary.

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

1711: GET_PROPER_LENGTH(okl_accounting_util.format_amount(l_trx_amt,p_pool_rec.currency_code),l_trx_amt_len,'DATA'));
1712: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
1713: END IF;
1714:
1715: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1716: x_return_status := l_return_status;
1717: x_msg_data := l_msg_data;
1718: x_msg_count := l_msg_count;
1719:

Line 1726: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1722: END IF;
1723:
1724: EXCEPTION
1725: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1726: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1727: (
1728: l_api_name,
1729: G_PKG_NAME,
1730: 'OKL_API.G_RET_STS_ERROR',

Line 1730: 'OKL_API.G_RET_STS_ERROR',

1726: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1727: (
1728: l_api_name,
1729: G_PKG_NAME,
1730: 'OKL_API.G_RET_STS_ERROR',
1731: x_msg_count,
1732: x_msg_data,
1733: '_PVT'
1734: );

Line 1736: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1732: x_msg_data,
1733: '_PVT'
1734: );
1735:
1736: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1737: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1738: p_api_name => l_api_name,
1739: p_pkg_name => G_PKG_NAME,
1740: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1737: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1733: '_PVT'
1734: );
1735:
1736: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1737: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1738: p_api_name => l_api_name,
1739: p_pkg_name => G_PKG_NAME,
1740: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1741: x_msg_count => x_msg_count,

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

1736: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1737: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1738: p_api_name => l_api_name,
1739: p_pkg_name => G_PKG_NAME,
1740: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1741: x_msg_count => x_msg_count,
1742: x_msg_data => x_msg_data,
1743: p_api_type => g_api_type);
1744:

Line 1745: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1741: x_msg_count => x_msg_count,
1742: x_msg_data => x_msg_data,
1743: p_api_type => g_api_type);
1744:
1745: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1746: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1747: p_api_name => l_api_name,
1748: p_pkg_name => G_PKG_NAME,
1749: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1746: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1742: x_msg_data => x_msg_data,
1743: p_api_type => g_api_type);
1744:
1745: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1746: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1747: p_api_name => l_api_name,
1748: p_pkg_name => G_PKG_NAME,
1749: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1750: x_msg_count => x_msg_count,

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

1745: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1746: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1747: p_api_name => l_api_name,
1748: p_pkg_name => G_PKG_NAME,
1749: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1750: x_msg_count => x_msg_count,
1751: x_msg_data => x_msg_data,
1752: p_api_type => g_api_type);
1753:

Line 1755: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1751: x_msg_data => x_msg_data,
1752: p_api_type => g_api_type);
1753:
1754: WHEN OTHERS THEN
1755: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1756: p_api_name => l_api_name,
1757: p_pkg_name => G_PKG_NAME,
1758: p_exc_name => 'OTHERS',
1759: x_msg_count => x_msg_count,

Line 1911: l_init_msg_list := Okl_Api.g_false;

1907: -- check for logging on STATEMENT level
1908: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1909:
1910: l_api_version := 1.0;
1911: l_init_msg_list := Okl_Api.g_false;
1912: l_msg_count := 0;
1913: l_pool_amount := 0;
1914: l_amount := 0;
1915: l_conv_rate := 0;

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

1915: l_conv_rate := 0;
1916: l_sub_pool_amount := 0;
1917: l_trx_amount := 0;
1918:
1919: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
1920: G_PKG_NAME,
1921: l_init_msg_list,
1922: l_api_version,
1923: l_api_version,

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

1922: l_api_version,
1923: l_api_version,
1924: '_PVT',
1925: l_return_status);
1926: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1929: RAISE OKL_API.G_EXCEPTION_ERROR;
1930: END IF;

Line 1927: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1923: l_api_version,
1924: '_PVT',
1925: l_return_status);
1926: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1929: RAISE OKL_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: -- Print the transaction header.

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

1924: '_PVT',
1925: l_return_status);
1926: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1929: RAISE OKL_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: -- Print the transaction header.
1932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

Line 1929: RAISE OKL_API.G_EXCEPTION_ERROR;

1925: l_return_status);
1926: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1929: RAISE OKL_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: -- Print the transaction header.
1932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
1933: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get_string('OKL','OKL_TRANSACTION'));

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

2061: GET_PROPER_LENGTH(p_pool_currency,l_curr_len,'DATA'));
2062: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length , '-' ));
2063: END IF;
2064:
2065: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2066: x_return_status := l_return_status;
2067: x_msg_data := l_msg_data;
2068: x_msg_count := l_msg_count;
2069:

Line 2076: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2072: END IF;
2073:
2074: EXCEPTION
2075: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2076: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2077: (
2078: l_api_name,
2079: G_PKG_NAME,
2080: 'OKL_API.G_RET_STS_ERROR',

Line 2080: 'OKL_API.G_RET_STS_ERROR',

2076: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2077: (
2078: l_api_name,
2079: G_PKG_NAME,
2080: 'OKL_API.G_RET_STS_ERROR',
2081: x_msg_count,
2082: x_msg_data,
2083: '_PVT'
2084: );

Line 2086: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2082: x_msg_data,
2083: '_PVT'
2084: );
2085:
2086: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2087: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2088: p_api_name => l_api_name,
2089: p_pkg_name => G_PKG_NAME,
2090: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2087: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2083: '_PVT'
2084: );
2085:
2086: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2087: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2088: p_api_name => l_api_name,
2089: p_pkg_name => G_PKG_NAME,
2090: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2091: x_msg_count => x_msg_count,

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

2086: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2087: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2088: p_api_name => l_api_name,
2089: p_pkg_name => G_PKG_NAME,
2090: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2091: x_msg_count => x_msg_count,
2092: x_msg_data => x_msg_data,
2093: p_api_type => g_api_type);
2094:

Line 2095: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2091: x_msg_count => x_msg_count,
2092: x_msg_data => x_msg_data,
2093: p_api_type => g_api_type);
2094:
2095: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2096: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2097: p_api_name => l_api_name,
2098: p_pkg_name => G_PKG_NAME,
2099: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2096: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2092: x_msg_data => x_msg_data,
2093: p_api_type => g_api_type);
2094:
2095: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2096: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2097: p_api_name => l_api_name,
2098: p_pkg_name => G_PKG_NAME,
2099: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2100: x_msg_count => x_msg_count,

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

2095: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2096: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2097: p_api_name => l_api_name,
2098: p_pkg_name => G_PKG_NAME,
2099: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2100: x_msg_count => x_msg_count,
2101: x_msg_data => x_msg_data,
2102: p_api_type => g_api_type);
2103:

Line 2105: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2101: x_msg_data => x_msg_data,
2102: p_api_type => g_api_type);
2103:
2104: WHEN OTHERS THEN
2105: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2106: p_api_name => l_api_name,
2107: p_pkg_name => G_PKG_NAME,
2108: p_exc_name => 'OTHERS',
2109: x_msg_count => x_msg_count,

Line 2165: l_init_msg_list := Okl_Api.g_false;

2161: -- check for logging on STATEMENT level
2162: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
2163:
2164: l_api_version := 1.0;
2165: l_init_msg_list := Okl_Api.g_false;
2166: l_msg_count := 0;
2167: l_sysdate := TRUNC(SYSDATE);
2168:
2169: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

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

2165: l_init_msg_list := Okl_Api.g_false;
2166: l_msg_count := 0;
2167: l_sysdate := TRUNC(SYSDATE);
2168:
2169: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2170: G_PKG_NAME,
2171: l_init_msg_list,
2172: l_api_version,
2173: l_api_version,

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

2172: l_api_version,
2173: l_api_version,
2174: '_PVT',
2175: l_return_status);
2176: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2177: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_ERROR;
2180: END IF;

Line 2177: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2173: l_api_version,
2174: '_PVT',
2175: l_return_status);
2176: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2177: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_ERROR;
2180: END IF;
2181:

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

2174: '_PVT',
2175: l_return_status);
2176: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2177: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_from_date);

Line 2179: RAISE OKL_API.G_EXCEPTION_ERROR;

2175: l_return_status);
2176: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2177: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2178: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2179: RAISE OKL_API.G_EXCEPTION_ERROR;
2180: END IF;
2181:
2182: l_from_date:= FND_DATE.CANONICAL_TO_DATE(p_from_date);
2183: l_to_date:= FND_DATE.CANONICAL_TO_DATE(p_to_date);

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

2222: l_return_status,
2223: l_msg_count,
2224: l_msg_data
2225: );
2226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2228: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2229: RAISE OKL_API.G_EXCEPTION_ERROR;
2230: END IF;

Line 2227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2223: l_msg_count,
2224: l_msg_data
2225: );
2226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2228: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2229: RAISE OKL_API.G_EXCEPTION_ERROR;
2230: END IF;
2231: print_transaction_summary (p_pool_id,

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

2224: l_msg_data
2225: );
2226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2228: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2229: RAISE OKL_API.G_EXCEPTION_ERROR;
2230: END IF;
2231: print_transaction_summary (p_pool_id,
2232: l_from_date,

Line 2229: RAISE OKL_API.G_EXCEPTION_ERROR;

2225: );
2226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2228: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2229: RAISE OKL_API.G_EXCEPTION_ERROR;
2230: END IF;
2231: print_transaction_summary (p_pool_id,
2232: l_from_date,
2233: l_to_date,

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

2237: l_return_status,
2238: l_msg_count,
2239: l_msg_data
2240: );
2241: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2243: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;

Line 2242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2238: l_msg_count,
2239: l_msg_data
2240: );
2241: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2243: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;
2246: END IF;

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

2239: l_msg_data
2240: );
2241: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2243: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;
2246: END IF;
2247:

Line 2244: RAISE OKL_API.G_EXCEPTION_ERROR;

2240: );
2241: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2243: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;
2246: END IF;
2247:
2248: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

Line 2248: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;
2246: END IF;
2247:
2248: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
2249:
2250: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2251: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call pool_reconc_report');
2252: END IF;

Line 2255: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2251: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call pool_reconc_report');
2252: END IF;
2253:
2254: EXCEPTION
2255: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2256: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2257: p_api_name => l_api_name,
2258: p_pkg_name => G_PKG_NAME,
2259: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2256: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2252: END IF;
2253:
2254: EXCEPTION
2255: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2256: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2257: p_api_name => l_api_name,
2258: p_pkg_name => G_PKG_NAME,
2259: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2260: x_msg_count => l_msg_count,

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

2255: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2256: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2257: p_api_name => l_api_name,
2258: p_pkg_name => G_PKG_NAME,
2259: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2260: x_msg_count => l_msg_count,
2261: x_msg_data => l_msg_data,
2262: p_api_type => g_api_type);
2263:

Line 2264: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2260: x_msg_count => l_msg_count,
2261: x_msg_data => l_msg_data,
2262: p_api_type => g_api_type);
2263:
2264: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2265: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2266: p_api_name => l_api_name,
2267: p_pkg_name => G_PKG_NAME,
2268: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2265: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2261: x_msg_data => l_msg_data,
2262: p_api_type => g_api_type);
2263:
2264: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2265: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2266: p_api_name => l_api_name,
2267: p_pkg_name => G_PKG_NAME,
2268: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2269: x_msg_count => l_msg_count,

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

2264: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2265: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2266: p_api_name => l_api_name,
2267: p_pkg_name => G_PKG_NAME,
2268: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2269: x_msg_count => l_msg_count,
2270: x_msg_data => l_msg_data,
2271: p_api_type => g_api_type);
2272:

Line 2450: l_init_msg_list := Okl_Api.g_false;

2446: -- check for logging on STATEMENT level
2447: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
2448:
2449: l_api_version := 1.0;
2450: l_init_msg_list := Okl_Api.g_false;
2451: l_msg_count := 0;
2452:
2453: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2454: G_PKG_NAME,

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

2449: l_api_version := 1.0;
2450: l_init_msg_list := Okl_Api.g_false;
2451: l_msg_count := 0;
2452:
2453: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2454: G_PKG_NAME,
2455: l_init_msg_list,
2456: l_api_version,
2457: l_api_version,

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

2456: l_api_version,
2457: l_api_version,
2458: '_PVT',
2459: l_return_status);
2460: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2462: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2463: RAISE OKL_API.G_EXCEPTION_ERROR;
2464: END IF;

Line 2461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2457: l_api_version,
2458: '_PVT',
2459: l_return_status);
2460: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2462: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2463: RAISE OKL_API.G_EXCEPTION_ERROR;
2464: END IF;
2465: -- Print the subsidy pool summary header.

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

2458: '_PVT',
2459: l_return_status);
2460: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2462: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2463: RAISE OKL_API.G_EXCEPTION_ERROR;
2464: END IF;
2465: -- Print the subsidy pool summary header.
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

Line 2463: RAISE OKL_API.G_EXCEPTION_ERROR;

2459: l_return_status);
2460: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2462: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2463: RAISE OKL_API.G_EXCEPTION_ERROR;
2464: END IF;
2465: -- Print the subsidy pool summary header.
2466: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));
2467: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, RPAD(' ', l_total_length, ' ' ));

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

2500: x_msg_data => l_msg_data,
2501: p_event_name => l_event_name,
2502: p_event_param_list => l_parameter_list
2503: );
2504: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2506: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2507: RAISE OKL_API.G_EXCEPTION_ERROR;
2508: END IF;

Line 2505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2501: p_event_name => l_event_name,
2502: p_event_param_list => l_parameter_list
2503: );
2504: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2506: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2507: RAISE OKL_API.G_EXCEPTION_ERROR;
2508: END IF;
2509: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool

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

2502: p_event_param_list => l_parameter_list
2503: );
2504: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2506: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2507: RAISE OKL_API.G_EXCEPTION_ERROR;
2508: END IF;
2509: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
2510: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.

Line 2507: RAISE OKL_API.G_EXCEPTION_ERROR;

2503: );
2504: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2506: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2507: RAISE OKL_API.G_EXCEPTION_ERROR;
2508: END IF;
2509: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
2510: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.
2511: IF(each_row.effective_to_date < TRUNC(SYSDATE) AND each_row.decision_status_code <> 'EXPIRED')THEN

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

2516: l_msg_count,
2517: l_msg_data,
2518: each_row.id,
2519: l_decision_status_code);
2520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2523: RAISE OKL_API.G_EXCEPTION_ERROR;
2524: END IF;

Line 2521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2517: l_msg_data,
2518: each_row.id,
2519: l_decision_status_code);
2520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2523: RAISE OKL_API.G_EXCEPTION_ERROR;
2524: END IF;
2525: END IF;

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

2518: each_row.id,
2519: l_decision_status_code);
2520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2523: RAISE OKL_API.G_EXCEPTION_ERROR;
2524: END IF;
2525: END IF;
2526: END LOOP;

Line 2523: RAISE OKL_API.G_EXCEPTION_ERROR;

2519: l_decision_status_code);
2520: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2521: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2522: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2523: RAISE OKL_API.G_EXCEPTION_ERROR;
2524: END IF;
2525: END IF;
2526: END LOOP;
2527: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));

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

2544: x_msg_data => l_msg_data,
2545: p_event_name => l_event_name,
2546: p_event_param_list => l_parameter_list
2547: );
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;

Line 2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2545: p_event_name => l_event_name,
2546: p_event_param_list => l_parameter_list
2547: );
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool

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

2546: p_event_param_list => l_parameter_list
2547: );
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
2554: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.

Line 2551: RAISE OKL_API.G_EXCEPTION_ERROR;

2547: );
2548: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2551: RAISE OKL_API.G_EXCEPTION_ERROR;
2552: END IF;
2553: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
2554: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.
2555: IF(each_row.effective_to_date < TRUNC(SYSDATE) AND each_row.decision_status_code <> 'EXPIRED')THEN

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

2560: l_msg_count,
2561: l_msg_data,
2562: each_row.id,
2563: l_decision_status_code);
2564: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2566: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2567: RAISE OKL_API.G_EXCEPTION_ERROR;
2568: END IF;

Line 2565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2561: l_msg_data,
2562: each_row.id,
2563: l_decision_status_code);
2564: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2566: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2567: RAISE OKL_API.G_EXCEPTION_ERROR;
2568: END IF;
2569: END IF;

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

2562: each_row.id,
2563: l_decision_status_code);
2564: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2566: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2567: RAISE OKL_API.G_EXCEPTION_ERROR;
2568: END IF;
2569: END IF;
2570: END LOOP;

Line 2567: RAISE OKL_API.G_EXCEPTION_ERROR;

2563: l_decision_status_code);
2564: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2566: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2567: RAISE OKL_API.G_EXCEPTION_ERROR;
2568: END IF;
2569: END IF;
2570: END LOOP;
2571: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));

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

2588: x_msg_data => l_msg_data,
2589: p_event_name => l_event_name,
2590: p_event_param_list => l_parameter_list
2591: );
2592: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2594: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2595: RAISE OKL_API.G_EXCEPTION_ERROR;
2596: END IF;

Line 2593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2589: p_event_name => l_event_name,
2590: p_event_param_list => l_parameter_list
2591: );
2592: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2594: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2595: RAISE OKL_API.G_EXCEPTION_ERROR;
2596: END IF;
2597: END LOOP;

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

2590: p_event_param_list => l_parameter_list
2591: );
2592: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2594: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2595: RAISE OKL_API.G_EXCEPTION_ERROR;
2596: END IF;
2597: END LOOP;
2598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));

Line 2595: RAISE OKL_API.G_EXCEPTION_ERROR;

2591: );
2592: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2594: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2595: RAISE OKL_API.G_EXCEPTION_ERROR;
2596: END IF;
2597: END LOOP;
2598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
2599: ELSIF(p_days is not null) THEN

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

2616: x_msg_data => l_msg_data,
2617: p_event_name => l_event_name,
2618: p_event_param_list => l_parameter_list
2619: );
2620: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2623: RAISE OKL_API.G_EXCEPTION_ERROR;
2624: END IF;

Line 2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2617: p_event_name => l_event_name,
2618: p_event_param_list => l_parameter_list
2619: );
2620: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2623: RAISE OKL_API.G_EXCEPTION_ERROR;
2624: END IF;
2625: END LOOP;

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

2618: p_event_param_list => l_parameter_list
2619: );
2620: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2623: RAISE OKL_API.G_EXCEPTION_ERROR;
2624: END IF;
2625: END LOOP;
2626: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));

Line 2623: RAISE OKL_API.G_EXCEPTION_ERROR;

2619: );
2620: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2621: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2622: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2623: RAISE OKL_API.G_EXCEPTION_ERROR;
2624: END IF;
2625: END LOOP;
2626: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
2627: END IF;

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

2626: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('-', l_total_length+8 , '-' ));
2627: END IF;
2628: COMMIT;
2629:
2630: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
2631: x_return_status := l_return_status;
2632: x_msg_data := l_msg_data;
2633: x_msg_count := l_msg_count;
2634:

Line 2640: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2636: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call print_atlimit_detail');
2637: END IF;
2638:
2639: EXCEPTION
2640: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2641: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2642: p_api_name => l_api_name,
2643: p_pkg_name => G_PKG_NAME,
2644: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2641: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2637: END IF;
2638:
2639: EXCEPTION
2640: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2641: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2642: p_api_name => l_api_name,
2643: p_pkg_name => G_PKG_NAME,
2644: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2645: x_msg_count => x_msg_count,

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

2640: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2641: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2642: p_api_name => l_api_name,
2643: p_pkg_name => G_PKG_NAME,
2644: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2645: x_msg_count => x_msg_count,
2646: x_msg_data => x_msg_data,
2647: p_api_type => g_api_type);
2648:

Line 2649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2645: x_msg_count => x_msg_count,
2646: x_msg_data => x_msg_data,
2647: p_api_type => g_api_type);
2648:
2649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2650: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2651: p_api_name => l_api_name,
2652: p_pkg_name => G_PKG_NAME,
2653: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2650: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2646: x_msg_data => x_msg_data,
2647: p_api_type => g_api_type);
2648:
2649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2650: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2651: p_api_name => l_api_name,
2652: p_pkg_name => G_PKG_NAME,
2653: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2654: x_msg_count => x_msg_count,

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

2649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2650: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2651: p_api_name => l_api_name,
2652: p_pkg_name => G_PKG_NAME,
2653: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2654: x_msg_count => x_msg_count,
2655: x_msg_data => x_msg_data,
2656: p_api_type => g_api_type);
2657:

Line 2659: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2655: x_msg_data => x_msg_data,
2656: p_api_type => g_api_type);
2657:
2658: WHEN OTHERS THEN
2659: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2660: p_api_name => l_api_name,
2661: p_pkg_name => G_PKG_NAME,
2662: p_exc_name => 'OTHERS',
2663: x_msg_count => x_msg_count,

Line 2715: l_init_msg_list := Okl_Api.g_false;

2711: -- check for logging on STATEMENT level
2712: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
2713:
2714: l_api_version := 1.0;
2715: l_init_msg_list := Okl_Api.g_false;
2716: l_msg_count := 0;
2717:
2718: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2719: G_PKG_NAME,

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

2714: l_api_version := 1.0;
2715: l_init_msg_list := Okl_Api.g_false;
2716: l_msg_count := 0;
2717:
2718: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2719: G_PKG_NAME,
2720: l_init_msg_list,
2721: l_api_version,
2722: l_api_version,

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

2721: l_api_version,
2722: l_api_version,
2723: '_PVT',
2724: l_return_status);
2725: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_ERROR;
2729: END IF;

Line 2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2722: l_api_version,
2723: '_PVT',
2724: l_return_status);
2725: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_ERROR;
2729: END IF;
2730:

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

2723: '_PVT',
2724: l_return_status);
2725: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_ERROR;
2729: END IF;
2730:
2731: l_date:= FND_DATE.CANONICAL_TO_DATE(p_end_date);

Line 2728: RAISE OKL_API.G_EXCEPTION_ERROR;

2724: l_return_status);
2725: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_ERROR;
2729: END IF;
2730:
2731: l_date:= FND_DATE.CANONICAL_TO_DATE(p_end_date);
2732:

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

2779: p_days,
2780: l_return_status,
2781: l_msg_count,
2782: l_msg_data);
2783: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2784: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2785: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2786: RAISE OKL_API.G_EXCEPTION_ERROR;
2787: END IF;

Line 2784: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2780: l_return_status,
2781: l_msg_count,
2782: l_msg_data);
2783: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2784: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2785: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2786: RAISE OKL_API.G_EXCEPTION_ERROR;
2787: END IF;
2788: END IF;

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

2781: l_msg_count,
2782: l_msg_data);
2783: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2784: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2785: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2786: RAISE OKL_API.G_EXCEPTION_ERROR;
2787: END IF;
2788: END IF;
2789:

Line 2786: RAISE OKL_API.G_EXCEPTION_ERROR;

2782: l_msg_data);
2783: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2784: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2785: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2786: RAISE OKL_API.G_EXCEPTION_ERROR;
2787: END IF;
2788: END IF;
2789:
2790: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

Line 2790: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

2786: RAISE OKL_API.G_EXCEPTION_ERROR;
2787: END IF;
2788: END IF;
2789:
2790: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
2791:
2792: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
2793: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call pool_atlimit_report');
2794: END IF;

Line 2798: l_return_status := OKL_API.HANDLE_EXCEPTIONS

2794: END IF;
2795:
2796: EXCEPTION
2797: WHEN G_EXCEPTION_HALT_VALIDATION THEN
2798: l_return_status := OKL_API.HANDLE_EXCEPTIONS
2799: (
2800: l_api_name,
2801: G_PKG_NAME,
2802: 'OKL_API.G_RET_STS_ERROR',

Line 2802: 'OKL_API.G_RET_STS_ERROR',

2798: l_return_status := OKL_API.HANDLE_EXCEPTIONS
2799: (
2800: l_api_name,
2801: G_PKG_NAME,
2802: 'OKL_API.G_RET_STS_ERROR',
2803: l_msg_count,
2804: l_msg_data,
2805: '_PVT'
2806: );

Line 2808: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2804: l_msg_data,
2805: '_PVT'
2806: );
2807:
2808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2809: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2810: p_api_name => l_api_name,
2811: p_pkg_name => G_PKG_NAME,
2812: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2809: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2805: '_PVT'
2806: );
2807:
2808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2809: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2810: p_api_name => l_api_name,
2811: p_pkg_name => G_PKG_NAME,
2812: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2813: x_msg_count => l_msg_count,

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

2808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2809: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2810: p_api_name => l_api_name,
2811: p_pkg_name => G_PKG_NAME,
2812: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2813: x_msg_count => l_msg_count,
2814: x_msg_data => l_msg_data,
2815: p_api_type => g_api_type);
2816:

Line 2817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2813: x_msg_count => l_msg_count,
2814: x_msg_data => l_msg_data,
2815: p_api_type => g_api_type);
2816:
2817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2818: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2819: p_api_name => l_api_name,
2820: p_pkg_name => G_PKG_NAME,
2821: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2818: l_return_status := OKL_API.HANDLE_EXCEPTIONS(

2814: x_msg_data => l_msg_data,
2815: p_api_type => g_api_type);
2816:
2817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2818: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2819: p_api_name => l_api_name,
2820: p_pkg_name => G_PKG_NAME,
2821: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2822: x_msg_count => l_msg_count,

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

2817: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2818: l_return_status := OKL_API.HANDLE_EXCEPTIONS(
2819: p_api_name => l_api_name,
2820: p_pkg_name => G_PKG_NAME,
2821: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2822: x_msg_count => l_msg_count,
2823: x_msg_data => l_msg_data,
2824: p_api_type => g_api_type);
2825:

Line 2910: l_init_msg_list := Okl_Api.g_false;

2906: -- check for logging on STATEMENT level
2907: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
2908:
2909: l_api_version := 1.0;
2910: l_init_msg_list := Okl_Api.g_false;
2911: l_msg_count := 0;
2912: l_total_budget := 0;
2913: l_budget := 0;
2914: l_trx_amount := 0;

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

2920: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(0,p_to_currency_code);
2921: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(0,p_to_currency_code);
2922: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(0,p_to_currency_code);
2923:
2924: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
2925: G_PKG_NAME,
2926: l_init_msg_list,
2927: l_api_version,
2928: l_api_version,

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

2928: l_api_version,
2929: '_PVT',
2930: l_return_status);
2931:
2932: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2934: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2935: RAISE OKL_API.G_EXCEPTION_ERROR;
2936: END IF;

Line 2933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2929: '_PVT',
2930: l_return_status);
2931:
2932: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2934: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2935: RAISE OKL_API.G_EXCEPTION_ERROR;
2936: END IF;
2937:

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

2930: l_return_status);
2931:
2932: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2934: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2935: RAISE OKL_API.G_EXCEPTION_ERROR;
2936: END IF;
2937:
2938: -- Convert the reporting pool limit amount from pool currency to the pool currency.

Line 2935: RAISE OKL_API.G_EXCEPTION_ERROR;

2931:
2932: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2934: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2935: RAISE OKL_API.G_EXCEPTION_ERROR;
2936: END IF;
2937:
2938: -- Convert the reporting pool limit amount from pool currency to the pool currency.
2939: l_reporting_limit := currency_conversion(p_pool_rec.reporting_pool_limit,

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

2964: l_return_status,
2965: l_msg_count,
2966: l_msg_data
2967: );
2968: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2970: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2971: RAISE OKL_API.G_EXCEPTION_ERROR;
2972: END IF;

Line 2969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2965: l_msg_count,
2966: l_msg_data
2967: );
2968: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2970: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2971: RAISE OKL_API.G_EXCEPTION_ERROR;
2972: END IF;
2973: l_total_budget := l_total_budget + l_budget;

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

2966: l_msg_data
2967: );
2968: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2970: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2971: RAISE OKL_API.G_EXCEPTION_ERROR;
2972: END IF;
2973: l_total_budget := l_total_budget + l_budget;
2974: l_trx_amt := transaction_amount( each_row.id,

Line 2971: RAISE OKL_API.G_EXCEPTION_ERROR;

2967: );
2968: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2970: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2971: RAISE OKL_API.G_EXCEPTION_ERROR;
2972: END IF;
2973: l_total_budget := l_total_budget + l_budget;
2974: l_trx_amt := transaction_amount( each_row.id,
2975: p_input_date,

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

2979: l_return_status,
2980: l_msg_count,
2981: l_msg_data
2982: );
2983: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2985: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2986: RAISE OKL_API.G_EXCEPTION_ERROR;
2987: END IF;

Line 2984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2980: l_msg_count,
2981: l_msg_data
2982: );
2983: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2985: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2986: RAISE OKL_API.G_EXCEPTION_ERROR;
2987: END IF;
2988: l_trx_amount := l_trx_amount + l_trx_amt;

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

2981: l_msg_data
2982: );
2983: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2985: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2986: RAISE OKL_API.G_EXCEPTION_ERROR;
2987: END IF;
2988: l_trx_amount := l_trx_amount + l_trx_amt;
2989: END LOOP;

Line 2986: RAISE OKL_API.G_EXCEPTION_ERROR;

2982: );
2983: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2984: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2985: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2986: RAISE OKL_API.G_EXCEPTION_ERROR;
2987: END IF;
2988: l_trx_amount := l_trx_amount + l_trx_amt;
2989: END LOOP;
2990: -- if subsidy pool type is budget, simply calculate the total budgets and remaining balance.

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

2997: l_return_status,
2998: l_msg_count,
2999: l_msg_data
3000: );
3001: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3002: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3003: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3004: RAISE OKL_API.G_EXCEPTION_ERROR;
3005: END IF;

Line 3002: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2998: l_msg_count,
2999: l_msg_data
3000: );
3001: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3002: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3003: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3004: RAISE OKL_API.G_EXCEPTION_ERROR;
3005: END IF;
3006: l_total_budget := l_budget;

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

2999: l_msg_data
3000: );
3001: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3002: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3003: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3004: RAISE OKL_API.G_EXCEPTION_ERROR;
3005: END IF;
3006: l_total_budget := l_budget;
3007: l_trx_amt := transaction_amount( p_pool_rec.id,

Line 3004: RAISE OKL_API.G_EXCEPTION_ERROR;

3000: );
3001: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3002: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3003: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3004: RAISE OKL_API.G_EXCEPTION_ERROR;
3005: END IF;
3006: l_total_budget := l_budget;
3007: l_trx_amt := transaction_amount( p_pool_rec.id,
3008: p_input_date,

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

3012: l_return_status,
3013: l_msg_count,
3014: l_msg_data
3015: );
3016: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3017: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3018: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3019: RAISE OKL_API.G_EXCEPTION_ERROR;
3020: END IF;

Line 3017: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3013: l_msg_count,
3014: l_msg_data
3015: );
3016: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3017: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3018: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3019: RAISE OKL_API.G_EXCEPTION_ERROR;
3020: END IF;
3021: l_trx_amount := l_trx_amt;

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

3014: l_msg_data
3015: );
3016: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3017: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3018: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3019: RAISE OKL_API.G_EXCEPTION_ERROR;
3020: END IF;
3021: l_trx_amount := l_trx_amt;
3022: END IF;

Line 3019: RAISE OKL_API.G_EXCEPTION_ERROR;

3015: );
3016: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3017: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3018: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3019: RAISE OKL_API.G_EXCEPTION_ERROR;
3020: END IF;
3021: l_trx_amount := l_trx_amt;
3022: END IF;
3023: l_remaining_balance := l_total_budget - l_trx_amount;

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

3034: x_pool_dtl_rec.reporting_limit := okl_accounting_util.format_amount(l_reporting_limit,p_to_currency_code);
3035: x_pool_dtl_rec.total_budget := okl_accounting_util.format_amount(l_total_budget,p_to_currency_code);
3036: x_pool_dtl_rec.remaining_balance := okl_accounting_util.format_amount(l_remaining_balance,p_to_currency_code);
3037:
3038: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
3039: x_return_status := l_return_status;
3040: x_msg_data := l_msg_data;
3041: x_msg_count := l_msg_count;
3042:

Line 3147: l_init_msg_list := Okl_Api.g_false;

3143: -- check for logging on STATEMENT level
3144: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3145:
3146: l_api_version := 1.0;
3147: l_init_msg_list := Okl_Api.g_false;
3148: l_msg_count := 0;
3149: l_total_budget := 0;
3150: l_trx_amount := 0;
3151: l_remaining_balance := 0;

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

3150: l_trx_amount := 0;
3151: l_remaining_balance := 0;
3152: l_sysdate := TRUNC(SYSDATE);
3153:
3154: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
3155: G_PKG_NAME,
3156: l_init_msg_list,
3157: l_api_version,
3158: l_api_version,

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

3157: l_api_version,
3158: l_api_version,
3159: '_PVT',
3160: l_return_status);
3161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3164: RAISE OKL_API.G_EXCEPTION_ERROR;
3165: END IF;

Line 3162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3158: l_api_version,
3159: '_PVT',
3160: l_return_status);
3161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3164: RAISE OKL_API.G_EXCEPTION_ERROR;
3165: END IF;
3166:

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

3159: '_PVT',
3160: l_return_status);
3161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3164: RAISE OKL_API.G_EXCEPTION_ERROR;
3165: END IF;
3166:
3167: l_from_date:= FND_DATE.CANONICAL_TO_DATE(P_DATE);

Line 3164: RAISE OKL_API.G_EXCEPTION_ERROR;

3160: l_return_status);
3161: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3164: RAISE OKL_API.G_EXCEPTION_ERROR;
3165: END IF;
3166:
3167: l_from_date:= FND_DATE.CANONICAL_TO_DATE(P_DATE);
3168:

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

3193: l_input_pool_rec.currency_conversion_type,
3194: l_return_status,
3195: l_msg_count,
3196: l_msg_data);
3197: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3198: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3199: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3200: RAISE OKL_API.G_EXCEPTION_ERROR;
3201: END IF;

Line 3198: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3194: l_return_status,
3195: l_msg_count,
3196: l_msg_data);
3197: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3198: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3199: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3200: RAISE OKL_API.G_EXCEPTION_ERROR;
3201: END IF;
3202: ELSE

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

3195: l_msg_count,
3196: l_msg_data);
3197: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3198: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3199: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3200: RAISE OKL_API.G_EXCEPTION_ERROR;
3201: END IF;
3202: ELSE
3203: l_pool_rec.subsidy_pool_name := NULL;

Line 3200: RAISE OKL_API.G_EXCEPTION_ERROR;

3196: l_msg_data);
3197: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3198: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3199: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3200: RAISE OKL_API.G_EXCEPTION_ERROR;
3201: END IF;
3202: ELSE
3203: l_pool_rec.subsidy_pool_name := NULL;
3204: l_pool_rec.pool_type_code := NULL;

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

3227: l_input_pool_rec.currency_conversion_type,
3228: l_return_status,
3229: l_msg_count,
3230: l_msg_data);
3231: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3232: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3233: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3234: RAISE OKL_API.G_EXCEPTION_ERROR;
3235: END IF;

Line 3232: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3228: l_return_status,
3229: l_msg_count,
3230: l_msg_data);
3231: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3232: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3233: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3234: RAISE OKL_API.G_EXCEPTION_ERROR;
3235: END IF;
3236: ELSE

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

3229: l_msg_count,
3230: l_msg_data);
3231: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3232: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3233: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3234: RAISE OKL_API.G_EXCEPTION_ERROR;
3235: END IF;
3236: ELSE
3237: l_chld_pool_rec.subsidy_pool_name := NULL;

Line 3234: RAISE OKL_API.G_EXCEPTION_ERROR;

3230: l_msg_data);
3231: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3232: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3233: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3234: RAISE OKL_API.G_EXCEPTION_ERROR;
3235: END IF;
3236: ELSE
3237: l_chld_pool_rec.subsidy_pool_name := NULL;
3238: l_chld_pool_rec.pool_type_code := NULL;

Line 3276: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

3272: x_chld_pool_dtl_rec.remaining_balance,
3273: x_chld_pool_dtl_rec.error_message
3274: );
3275: END LOOP;
3276: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
3277:
3278: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
3279: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call XML_POOL_ASSOC_REPORT');
3280: END IF;

Line 3450: l_init_msg_list := Okl_Api.g_false;

3446: -- check for logging on STATEMENT level
3447: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3448:
3449: l_api_version := 1.0;
3450: l_init_msg_list := Okl_Api.g_false;
3451: l_msg_count := 0;
3452: l_date:= FND_DATE.CANONICAL_TO_DATE(P_END_DATE);
3453: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
3454: G_PKG_NAME,

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

3449: l_api_version := 1.0;
3450: l_init_msg_list := Okl_Api.g_false;
3451: l_msg_count := 0;
3452: l_date:= FND_DATE.CANONICAL_TO_DATE(P_END_DATE);
3453: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
3454: G_PKG_NAME,
3455: l_init_msg_list,
3456: l_api_version,
3457: l_api_version,

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

3456: l_api_version,
3457: l_api_version,
3458: '_PVT',
3459: l_return_status);
3460: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3462: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3463: RAISE OKL_API.G_EXCEPTION_ERROR;
3464: END IF;

Line 3461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3457: l_api_version,
3458: '_PVT',
3459: l_return_status);
3460: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3462: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3463: RAISE OKL_API.G_EXCEPTION_ERROR;
3464: END IF;
3465:

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

3458: '_PVT',
3459: l_return_status);
3460: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3462: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3463: RAISE OKL_API.G_EXCEPTION_ERROR;
3464: END IF;
3465:
3466:

Line 3463: RAISE OKL_API.G_EXCEPTION_ERROR;

3459: l_return_status);
3460: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3462: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3463: RAISE OKL_API.G_EXCEPTION_ERROR;
3464: END IF;
3465:
3466:
3467: -- If p_remaining is entered and p_currency is not entered or vice versa

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

3552: x_msg_data => l_msg_data,
3553: p_event_name => l_event_name,
3554: p_event_param_list => l_parameter_list
3555: );
3556: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3558: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3559: RAISE OKL_API.G_EXCEPTION_ERROR;
3560: END IF;

Line 3557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3553: p_event_name => l_event_name,
3554: p_event_param_list => l_parameter_list
3555: );
3556: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3558: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3559: RAISE OKL_API.G_EXCEPTION_ERROR;
3560: END IF;
3561: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool

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

3554: p_event_param_list => l_parameter_list
3555: );
3556: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3558: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3559: RAISE OKL_API.G_EXCEPTION_ERROR;
3560: END IF;
3561: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
3562: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.

Line 3559: RAISE OKL_API.G_EXCEPTION_ERROR;

3555: );
3556: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3558: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3559: RAISE OKL_API.G_EXCEPTION_ERROR;
3560: END IF;
3561: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
3562: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.
3563: IF(each_row.effective_to_date < TRUNC(SYSDATE) AND each_row.decision_status_code <> 'EXPIRED')THEN

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

3568: l_msg_count,
3569: l_msg_data,
3570: each_row.id,
3571: l_decision_status_code);
3572: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3574: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3575: RAISE OKL_API.G_EXCEPTION_ERROR;
3576: END IF;

Line 3573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3569: l_msg_data,
3570: each_row.id,
3571: l_decision_status_code);
3572: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3574: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3575: RAISE OKL_API.G_EXCEPTION_ERROR;
3576: END IF;
3577: END IF;

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

3570: each_row.id,
3571: l_decision_status_code);
3572: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3574: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3575: RAISE OKL_API.G_EXCEPTION_ERROR;
3576: END IF;
3577: END IF;
3578: END LOOP;

Line 3575: RAISE OKL_API.G_EXCEPTION_ERROR;

3571: l_decision_status_code);
3572: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3574: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3575: RAISE OKL_API.G_EXCEPTION_ERROR;
3576: END IF;
3577: END IF;
3578: END LOOP;
3579: ELSIF(P_REMAINING is not null) THEN

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

3606: x_msg_data => l_msg_data,
3607: p_event_name => l_event_name,
3608: p_event_param_list => l_parameter_list
3609: );
3610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3613: RAISE OKL_API.G_EXCEPTION_ERROR;
3614: END IF;

Line 3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3607: p_event_name => l_event_name,
3608: p_event_param_list => l_parameter_list
3609: );
3610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3613: RAISE OKL_API.G_EXCEPTION_ERROR;
3614: END IF;
3615: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool

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

3608: p_event_param_list => l_parameter_list
3609: );
3610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3613: RAISE OKL_API.G_EXCEPTION_ERROR;
3614: END IF;
3615: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
3616: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.

Line 3613: RAISE OKL_API.G_EXCEPTION_ERROR;

3609: );
3610: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3612: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3613: RAISE OKL_API.G_EXCEPTION_ERROR;
3614: END IF;
3615: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
3616: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.
3617: IF(each_row.effective_to_date < TRUNC(SYSDATE) AND each_row.decision_status_code <> 'EXPIRED')THEN

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

3622: l_msg_count,
3623: l_msg_data,
3624: each_row.id,
3625: l_decision_status_code);
3626: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3628: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3629: RAISE OKL_API.G_EXCEPTION_ERROR;
3630: END IF;

Line 3627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3623: l_msg_data,
3624: each_row.id,
3625: l_decision_status_code);
3626: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3628: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3629: RAISE OKL_API.G_EXCEPTION_ERROR;
3630: END IF;
3631: END IF;

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

3624: each_row.id,
3625: l_decision_status_code);
3626: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3628: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3629: RAISE OKL_API.G_EXCEPTION_ERROR;
3630: END IF;
3631: END IF;
3632: END LOOP;

Line 3629: RAISE OKL_API.G_EXCEPTION_ERROR;

3625: l_decision_status_code);
3626: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3627: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3628: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3629: RAISE OKL_API.G_EXCEPTION_ERROR;
3630: END IF;
3631: END IF;
3632: END LOOP;
3633: ELSIF(l_date is not null) THEN

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

3661: x_msg_data => l_msg_data,
3662: p_event_name => l_event_name,
3663: p_event_param_list => l_parameter_list
3664: );
3665: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3667: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3668: RAISE OKL_API.G_EXCEPTION_ERROR;
3669: END IF;

Line 3666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3662: p_event_name => l_event_name,
3663: p_event_param_list => l_parameter_list
3664: );
3665: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3667: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3668: RAISE OKL_API.G_EXCEPTION_ERROR;
3669: END IF;
3670: END LOOP;

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

3663: p_event_param_list => l_parameter_list
3664: );
3665: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3667: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3668: RAISE OKL_API.G_EXCEPTION_ERROR;
3669: END IF;
3670: END LOOP;
3671: ELSIF(P_DAYS is not null) THEN

Line 3668: RAISE OKL_API.G_EXCEPTION_ERROR;

3664: );
3665: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3666: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3667: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3668: RAISE OKL_API.G_EXCEPTION_ERROR;
3669: END IF;
3670: END LOOP;
3671: ELSIF(P_DAYS is not null) THEN
3672: FOR each_row IN c_get_days(P_DAYS) LOOP

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

3700: x_msg_data => l_msg_data,
3701: p_event_name => l_event_name,
3702: p_event_param_list => l_parameter_list
3703: );
3704: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3706: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3707: RAISE OKL_API.G_EXCEPTION_ERROR;
3708: END IF;

Line 3705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3701: p_event_name => l_event_name,
3702: p_event_param_list => l_parameter_list
3703: );
3704: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3706: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3707: RAISE OKL_API.G_EXCEPTION_ERROR;
3708: END IF;
3709: END LOOP;

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

3702: p_event_param_list => l_parameter_list
3703: );
3704: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3706: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3707: RAISE OKL_API.G_EXCEPTION_ERROR;
3708: END IF;
3709: END LOOP;
3710: END IF;

Line 3707: RAISE OKL_API.G_EXCEPTION_ERROR;

3703: );
3704: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3706: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3707: RAISE OKL_API.G_EXCEPTION_ERROR;
3708: END IF;
3709: END LOOP;
3710: END IF;
3711:

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

3710: END IF;
3711:
3712: END IF;
3713:
3714: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
3715: x_return_status := l_return_status;
3716: x_msg_data := l_msg_data;
3717: x_msg_count := l_msg_count;
3718:

Line 3798: l_init_msg_list := Okl_Api.g_false;

3794: -- check for logging on STATEMENT level
3795: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
3796:
3797: l_api_version := 1.0;
3798: l_init_msg_list := Okl_Api.g_false;
3799: l_msg_count := 0;
3800: l_budget := 0;
3801: l_trx_amt := 0;
3802: l_amount := 0;

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

3801: l_trx_amt := 0;
3802: l_amount := 0;
3803: l_remaining_balance := 0;
3804:
3805: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
3806: G_PKG_NAME,
3807: l_init_msg_list,
3808: l_api_version,
3809: l_api_version,

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

3809: l_api_version,
3810: '_PVT',
3811: l_return_status);
3812:
3813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3815: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3816: RAISE OKL_API.G_EXCEPTION_ERROR;
3817: END IF;

Line 3814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3810: '_PVT',
3811: l_return_status);
3812:
3813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3815: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3816: RAISE OKL_API.G_EXCEPTION_ERROR;
3817: END IF;
3818:

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

3811: l_return_status);
3812:
3813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3815: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3816: RAISE OKL_API.G_EXCEPTION_ERROR;
3817: END IF;
3818:
3819: -- If subsidy pool type is "Budget" then pick the values for total budgets

Line 3816: RAISE OKL_API.G_EXCEPTION_ERROR;

3812:
3813: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3815: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3816: RAISE OKL_API.G_EXCEPTION_ERROR;
3817: END IF;
3818:
3819: -- If subsidy pool type is "Budget" then pick the values for total budgets
3820: -- from the okl_subsidy_pools_b table and calculate the total transaction amount

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

3830: l_return_status,
3831: l_msg_count,
3832: l_msg_data
3833: );
3834: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3835: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3836: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3837: RAISE OKL_API.G_EXCEPTION_ERROR;
3838: END IF;

Line 3835: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3831: l_msg_count,
3832: l_msg_data
3833: );
3834: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3835: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3836: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3837: RAISE OKL_API.G_EXCEPTION_ERROR;
3838: END IF;
3839: -- calculate the total transaction amount for the subsidy pool.

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

3832: l_msg_data
3833: );
3834: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3835: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3836: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3837: RAISE OKL_API.G_EXCEPTION_ERROR;
3838: END IF;
3839: -- calculate the total transaction amount for the subsidy pool.
3840: l_trx_amt := transaction_amount( p_pool_rec.id,

Line 3837: RAISE OKL_API.G_EXCEPTION_ERROR;

3833: );
3834: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3835: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3836: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3837: RAISE OKL_API.G_EXCEPTION_ERROR;
3838: END IF;
3839: -- calculate the total transaction amount for the subsidy pool.
3840: l_trx_amt := transaction_amount( p_pool_rec.id,
3841: p_to_date,

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

3845: l_return_status,
3846: l_msg_count,
3847: l_msg_data
3848: );
3849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3852: RAISE OKL_API.G_EXCEPTION_ERROR;
3853: END IF;

Line 3850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3846: l_msg_count,
3847: l_msg_data
3848: );
3849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3852: RAISE OKL_API.G_EXCEPTION_ERROR;
3853: END IF;
3854: -- remaining balance for subsidy pool is total budgets minus the total transaction amount.

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

3847: l_msg_data
3848: );
3849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3852: RAISE OKL_API.G_EXCEPTION_ERROR;
3853: END IF;
3854: -- remaining balance for subsidy pool is total budgets minus the total transaction amount.
3855: l_remaining_balance := l_budget - l_trx_amt;

Line 3852: RAISE OKL_API.G_EXCEPTION_ERROR;

3848: );
3849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3850: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3851: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3852: RAISE OKL_API.G_EXCEPTION_ERROR;
3853: END IF;
3854: -- remaining balance for subsidy pool is total budgets minus the total transaction amount.
3855: l_remaining_balance := l_budget - l_trx_amt;
3856:

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

3899: l_return_status,
3900: l_msg_count,
3901: l_msg_data
3902: );
3903: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3905: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3906: RAISE OKL_API.G_EXCEPTION_ERROR;
3907: END IF;

Line 3904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3900: l_msg_count,
3901: l_msg_data
3902: );
3903: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3905: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3906: RAISE OKL_API.G_EXCEPTION_ERROR;
3907: END IF;
3908: l_trx_amt := l_trx_amt + l_amount;

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

3901: l_msg_data
3902: );
3903: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3905: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3906: RAISE OKL_API.G_EXCEPTION_ERROR;
3907: END IF;
3908: l_trx_amt := l_trx_amt + l_amount;
3909: END LOOP;

Line 3906: RAISE OKL_API.G_EXCEPTION_ERROR;

3902: );
3903: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3905: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
3906: RAISE OKL_API.G_EXCEPTION_ERROR;
3907: END IF;
3908: l_trx_amt := l_trx_amt + l_amount;
3909: END LOOP;
3910: -- Insert the parent pool record into the Global Temporary Table

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

3928: okl_accounting_util.format_amount(0,p_pool_rec.currency_code) -- Pool Balance
3929: );
3930: END IF;
3931:
3932: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
3933: x_return_status := l_return_status;
3934: x_msg_data := l_msg_data;
3935: x_msg_count := l_msg_count;
3936:

Line 4063: l_init_msg_list := Okl_Api.g_false;

4059: -- check for logging on STATEMENT level
4060: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
4061:
4062: l_api_version := 1.0;
4063: l_init_msg_list := Okl_Api.g_false;
4064: l_msg_count := 0;
4065: l_pool_amount := 0;
4066: l_amount := 0;
4067: l_conv_rate := 0;

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

4067: l_conv_rate := 0;
4068: l_sub_pool_amount := 0;
4069: l_trx_amount := 0;
4070:
4071: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
4072: G_PKG_NAME,
4073: l_init_msg_list,
4074: l_api_version,
4075: l_api_version,

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

4074: l_api_version,
4075: l_api_version,
4076: '_PVT',
4077: l_return_status);
4078: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4080: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4081: RAISE OKL_API.G_EXCEPTION_ERROR;
4082: END IF;

Line 4079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4075: l_api_version,
4076: '_PVT',
4077: l_return_status);
4078: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4080: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4081: RAISE OKL_API.G_EXCEPTION_ERROR;
4082: END IF;
4083:

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

4076: '_PVT',
4077: l_return_status);
4078: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4080: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4081: RAISE OKL_API.G_EXCEPTION_ERROR;
4082: END IF;
4083:
4084: IF(p_pool_type = 'BUDGET') THEN

Line 4081: RAISE OKL_API.G_EXCEPTION_ERROR;

4077: l_return_status);
4078: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4080: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4081: RAISE OKL_API.G_EXCEPTION_ERROR;
4082: END IF;
4083:
4084: IF(p_pool_type = 'BUDGET') THEN
4085: FOR each_row IN c_transaction_detail(p_pool_id,p_from_date,p_to_date) LOOP

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

4210: END IF;
4211: END LOOP;
4212: END IF;
4213:
4214: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
4215: x_return_status := l_return_status;
4216: x_msg_data := l_msg_data;
4217: x_msg_count := l_msg_count;
4218:

Line 4285: l_init_msg_list := Okl_Api.g_false;

4281: -- check for logging on STATEMENT level
4282: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
4283:
4284: l_api_version := 1.0;
4285: l_init_msg_list := Okl_Api.g_false;
4286: l_msg_count := 0;
4287: l_sysdate := TRUNC(SYSDATE);
4288:
4289: l_return_status := OKL_API.START_ACTIVITY( l_api_name,

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

4285: l_init_msg_list := Okl_Api.g_false;
4286: l_msg_count := 0;
4287: l_sysdate := TRUNC(SYSDATE);
4288:
4289: l_return_status := OKL_API.START_ACTIVITY( l_api_name,
4290: G_PKG_NAME,
4291: l_init_msg_list,
4292: l_api_version,
4293: l_api_version,

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

4292: l_api_version,
4293: l_api_version,
4294: '_PVT',
4295: l_return_status);
4296: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4298: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4299: RAISE OKL_API.G_EXCEPTION_ERROR;
4300: END IF;

Line 4297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4293: l_api_version,
4294: '_PVT',
4295: l_return_status);
4296: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4298: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4299: RAISE OKL_API.G_EXCEPTION_ERROR;
4300: END IF;
4301:

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

4294: '_PVT',
4295: l_return_status);
4296: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4298: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4299: RAISE OKL_API.G_EXCEPTION_ERROR;
4300: END IF;
4301:
4302: l_from_date:= FND_DATE.CANONICAL_TO_DATE(P_FROM_DATE);

Line 4299: RAISE OKL_API.G_EXCEPTION_ERROR;

4295: l_return_status);
4296: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4298: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4299: RAISE OKL_API.G_EXCEPTION_ERROR;
4300: END IF;
4301:
4302: l_from_date:= FND_DATE.CANONICAL_TO_DATE(P_FROM_DATE);
4303: l_to_date:= FND_DATE.CANONICAL_TO_DATE(P_TO_DATE);

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

4323: l_return_status,
4324: l_msg_count,
4325: l_msg_data
4326: );
4327: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4328: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4329: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4330: RAISE OKL_API.G_EXCEPTION_ERROR;
4331: END IF;

Line 4328: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4324: l_msg_count,
4325: l_msg_data
4326: );
4327: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4328: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4329: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4330: RAISE OKL_API.G_EXCEPTION_ERROR;
4331: END IF;
4332: xml_print_transaction_summary (P_POOL_ID,

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

4325: l_msg_data
4326: );
4327: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4328: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4329: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4330: RAISE OKL_API.G_EXCEPTION_ERROR;
4331: END IF;
4332: xml_print_transaction_summary (P_POOL_ID,
4333: l_from_date,

Line 4330: RAISE OKL_API.G_EXCEPTION_ERROR;

4326: );
4327: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4328: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4329: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4330: RAISE OKL_API.G_EXCEPTION_ERROR;
4331: END IF;
4332: xml_print_transaction_summary (P_POOL_ID,
4333: l_from_date,
4334: l_to_date,

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

4338: l_return_status,
4339: l_msg_count,
4340: l_msg_data
4341: );
4342: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4343: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4344: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4345: RAISE OKL_API.G_EXCEPTION_ERROR;
4346: END IF;

Line 4343: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4339: l_msg_count,
4340: l_msg_data
4341: );
4342: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4343: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4344: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4345: RAISE OKL_API.G_EXCEPTION_ERROR;
4346: END IF;
4347: END IF;

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

4340: l_msg_data
4341: );
4342: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4343: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4344: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4345: RAISE OKL_API.G_EXCEPTION_ERROR;
4346: END IF;
4347: END IF;
4348:

Line 4345: RAISE OKL_API.G_EXCEPTION_ERROR;

4341: );
4342: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4343: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4344: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
4345: RAISE OKL_API.G_EXCEPTION_ERROR;
4346: END IF;
4347: END IF;
4348:
4349: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

Line 4349: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);

4345: RAISE OKL_API.G_EXCEPTION_ERROR;
4346: END IF;
4347: END IF;
4348:
4349: okl_api.END_ACTIVITY(l_msg_count, l_msg_data);
4350:
4351: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
4352: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIOB.pls call XML_POOL_RECONC_REPORT');
4353: END IF;