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

APPS.OKL_REVERSAL_PVT dependencies on OKL_API

Line 255: x_return_status := OKL_API.G_RET_STS_SUCCESS;

251:
252: BEGIN
253:
254:
255: x_return_status := OKL_API.G_RET_STS_SUCCESS;
256:
257: -- Validate Source id and Source Table
258:
259:

Line 260: IF (p_source_table IS NULL OR p_source_table = OKL_API.G_MISS_CHAR) THEN

256:
257: -- Validate Source id and Source Table
258:
259:
260: IF (p_source_table IS NULL OR p_source_table = OKL_API.G_MISS_CHAR) THEN
261: OKL_API.SET_MESSAGE(p_app_name => g_app_name
262: ,p_msg_name => g_required_value
263: ,p_token1 => g_col_name_token
264: ,p_token1_value => 'source_table');

Line 261: OKL_API.SET_MESSAGE(p_app_name => g_app_name

257: -- Validate Source id and Source Table
258:
259:
260: IF (p_source_table IS NULL OR p_source_table = OKL_API.G_MISS_CHAR) THEN
261: OKL_API.SET_MESSAGE(p_app_name => g_app_name
262: ,p_msg_name => g_required_value
263: ,p_token1 => g_col_name_token
264: ,p_token1_value => 'source_table');
265: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 265: x_return_status := OKL_API.G_RET_STS_ERROR;

261: OKL_API.SET_MESSAGE(p_app_name => g_app_name
262: ,p_msg_name => g_required_value
263: ,p_token1 => g_col_name_token
264: ,p_token1_value => 'source_table');
265: x_return_status := OKL_API.G_RET_STS_ERROR;
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;
268:
269: IF (p_source_id IS NULL OR p_source_id = OKL_API.G_MISS_NUM) THEN

Line 266: RAISE OKL_API.G_EXCEPTION_ERROR;

262: ,p_msg_name => g_required_value
263: ,p_token1 => g_col_name_token
264: ,p_token1_value => 'source_table');
265: x_return_status := OKL_API.G_RET_STS_ERROR;
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;
268:
269: IF (p_source_id IS NULL OR p_source_id = OKL_API.G_MISS_NUM) THEN
270: OKL_API.SET_MESSAGE(p_app_name => g_app_name

Line 269: IF (p_source_id IS NULL OR p_source_id = OKL_API.G_MISS_NUM) THEN

265: x_return_status := OKL_API.G_RET_STS_ERROR;
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;
268:
269: IF (p_source_id IS NULL OR p_source_id = OKL_API.G_MISS_NUM) THEN
270: OKL_API.SET_MESSAGE(p_app_name => g_app_name
271: ,p_msg_name => g_required_value
272: ,p_token1 => g_col_name_token
273: ,p_token1_value => 'source_id');

Line 270: OKL_API.SET_MESSAGE(p_app_name => g_app_name

266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;
268:
269: IF (p_source_id IS NULL OR p_source_id = OKL_API.G_MISS_NUM) THEN
270: OKL_API.SET_MESSAGE(p_app_name => g_app_name
271: ,p_msg_name => g_required_value
272: ,p_token1 => g_col_name_token
273: ,p_token1_value => 'source_id');
274: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 274: x_return_status := OKL_API.G_RET_STS_ERROR;

270: OKL_API.SET_MESSAGE(p_app_name => g_app_name
271: ,p_msg_name => g_required_value
272: ,p_token1 => g_col_name_token
273: ,p_token1_value => 'source_id');
274: x_return_status := OKL_API.G_RET_STS_ERROR;
275: RAISE OKL_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278: IF (p_acct_date IS NULL OR p_acct_date = OKL_API.G_MISS_DATE) THEN

Line 275: RAISE OKL_API.G_EXCEPTION_ERROR;

271: ,p_msg_name => g_required_value
272: ,p_token1 => g_col_name_token
273: ,p_token1_value => 'source_id');
274: x_return_status := OKL_API.G_RET_STS_ERROR;
275: RAISE OKL_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278: IF (p_acct_date IS NULL OR p_acct_date = OKL_API.G_MISS_DATE) THEN
279: OKL_API.SET_MESSAGE(p_app_name => g_app_name

Line 278: IF (p_acct_date IS NULL OR p_acct_date = OKL_API.G_MISS_DATE) THEN

274: x_return_status := OKL_API.G_RET_STS_ERROR;
275: RAISE OKL_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278: IF (p_acct_date IS NULL OR p_acct_date = OKL_API.G_MISS_DATE) THEN
279: OKL_API.SET_MESSAGE(p_app_name => g_app_name
280: ,p_msg_name => g_required_value
281: ,p_token1 => g_col_name_token
282: ,p_token1_value => 'acct_date');

Line 279: OKL_API.SET_MESSAGE(p_app_name => g_app_name

275: RAISE OKL_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278: IF (p_acct_date IS NULL OR p_acct_date = OKL_API.G_MISS_DATE) THEN
279: OKL_API.SET_MESSAGE(p_app_name => g_app_name
280: ,p_msg_name => g_required_value
281: ,p_token1 => g_col_name_token
282: ,p_token1_value => 'acct_date');
283: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 283: x_return_status := OKL_API.G_RET_STS_ERROR;

279: OKL_API.SET_MESSAGE(p_app_name => g_app_name
280: ,p_msg_name => g_required_value
281: ,p_token1 => g_col_name_token
282: ,p_token1_value => 'acct_date');
283: x_return_status := OKL_API.G_RET_STS_ERROR;
284: RAISE OKL_API.G_EXCEPTION_ERROR;
285: END IF;
286:
287: l_validate_flag :=

Line 284: RAISE OKL_API.G_EXCEPTION_ERROR;

280: ,p_msg_name => g_required_value
281: ,p_token1 => g_col_name_token
282: ,p_token1_value => 'acct_date');
283: x_return_status := OKL_API.G_RET_STS_ERROR;
284: RAISE OKL_API.G_EXCEPTION_ERROR;
285: END IF;
286:
287: l_validate_flag :=
288: OKL_ACCOUNTING_UTIL.VALIDATE_SOURCE_ID_TABLE(p_source_id => p_source_Id,

Line 291: IF (l_validate_flag = OKL_API.G_FALSE) THEN

287: l_validate_flag :=
288: OKL_ACCOUNTING_UTIL.VALIDATE_SOURCE_ID_TABLE(p_source_id => p_source_Id,
289: p_source_table => p_source_table);
290:
291: IF (l_validate_flag = OKL_API.G_FALSE) THEN
292: OKL_API.set_message(p_app_name => G_APP_NAME,
293: p_msg_name => 'OKL_INVALID_SOURCE_TBL_ID');
294:
295: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 292: OKL_API.set_message(p_app_name => G_APP_NAME,

288: OKL_ACCOUNTING_UTIL.VALIDATE_SOURCE_ID_TABLE(p_source_id => p_source_Id,
289: p_source_table => p_source_table);
290:
291: IF (l_validate_flag = OKL_API.G_FALSE) THEN
292: OKL_API.set_message(p_app_name => G_APP_NAME,
293: p_msg_name => 'OKL_INVALID_SOURCE_TBL_ID');
294:
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296:

Line 295: RAISE OKL_API.G_EXCEPTION_ERROR;

291: IF (l_validate_flag = OKL_API.G_FALSE) THEN
292: OKL_API.set_message(p_app_name => G_APP_NAME,
293: p_msg_name => 'OKL_INVALID_SOURCE_TBL_ID');
294:
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296:
297: END IF;
298:
299:

Line 306: OKL_API.set_message(p_app_name => G_APP_NAME,

302: p_start_date => l_start_date,
303: p_end_date => l_end_date);
304:
305: IF (l_period_name IS NULL) THEN
306: OKL_API.set_message(p_app_name => G_APP_NAME,
307: p_msg_name => 'OKL_ACCT_PERD_NOT_FOUND',
308: p_token1 => 'ACCT_DATE',
309: p_token1_value => p_acct_date);
310: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 310: RAISE OKL_API.G_EXCEPTION_ERROR;

306: OKL_API.set_message(p_app_name => G_APP_NAME,
307: p_msg_name => 'OKL_ACCT_PERD_NOT_FOUND',
308: p_token1 => 'ACCT_DATE',
309: p_token1_value => p_acct_date);
310: RAISE OKL_API.G_EXCEPTION_ERROR;
311: END IF;
312:
313: l_period_status := OKL_ACCOUNTING_UTIL.get_okl_period_status(l_period_name);
314:

Line 316: OKL_API.set_message(p_app_name => G_APP_NAME,

312:
313: l_period_status := OKL_ACCOUNTING_UTIL.get_okl_period_status(l_period_name);
314:
315: IF (l_period_status NOT IN ('O','F')) THEN
316: OKL_API.set_message(p_app_name => G_APP_NAME,
317: p_msg_name => 'OKL_PERD_INVALID_STATUS',
318: p_token1 => 'PERIOD',
319: p_token1_value => l_period_name);
320:

Line 321: RAISE OKL_API.G_EXCEPTION_ERROR;

317: p_msg_name => 'OKL_PERD_INVALID_STATUS',
318: p_token1 => 'PERIOD',
319: p_token1_value => l_period_name);
320:
321: RAISE OKL_API.G_EXCEPTION_ERROR;
322: END IF;
323:
324: -- If the selected event is already reversed earlier then Abort the processing
325:

Line 329: OKL_API.set_message(p_app_name => G_APP_NAME,

325:
326: OPEN check_dist_csr;
327: FETCH check_dist_csr INTO l_dummy_var;
328: IF (check_dist_csr%FOUND) THEN
329: OKL_API.set_message(p_app_name => G_APP_NAME,
330: p_msg_name => 'OKL_TXN_ALREADY_REVERSED');
331:
332: CLOSE check_dist_csr;
333: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 333: RAISE OKL_API.G_EXCEPTION_ERROR;

329: OKL_API.set_message(p_app_name => G_APP_NAME,
330: p_msg_name => 'OKL_TXN_ALREADY_REVERSED');
331:
332: CLOSE check_dist_csr;
333: RAISE OKL_API.G_EXCEPTION_ERROR;
334: END IF;
335: CLOSE check_dist_csr;
336:
337:

Line 342: OKL_API.set_message(p_app_name => G_APP_NAME,

338: OPEN dist_csr;
339: FETCH dist_csr INTO dist_rec;
340: IF (dist_csr%NOTFOUND) THEN
341: -- Santonyr on 14-Feb-2003 Fixed bug 2804913
342: OKL_API.set_message(p_app_name => G_APP_NAME,
343: p_msg_name => 'OKL_DIST_NOT_FOUND');
344: CLOSE dist_csr;
345: RAISE OKL_API.G_EXCEPTION_ERROR;
346: END IF;

Line 345: RAISE OKL_API.G_EXCEPTION_ERROR;

341: -- Santonyr on 14-Feb-2003 Fixed bug 2804913
342: OKL_API.set_message(p_app_name => G_APP_NAME,
343: p_msg_name => 'OKL_DIST_NOT_FOUND');
344: CLOSE dist_csr;
345: RAISE OKL_API.G_EXCEPTION_ERROR;
346: END IF;
347:
348: -- SLA uptake changes .. start
349: l_event_id := NULL;

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

386: ,p_action_type => 'REVERSE'
387: ,x_event_id => l_exist_event_id
388: ,x_event_date => l_exist_event_date);
389:
390: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
391: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
392: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
393: RAISE OKL_API.G_EXCEPTION_ERROR;
394: END IF;

Line 391: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

387: ,x_event_id => l_exist_event_id
388: ,x_event_date => l_exist_event_date);
389:
390: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
391: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
392: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
393: RAISE OKL_API.G_EXCEPTION_ERROR;
394: END IF;
395:

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

388: ,x_event_date => l_exist_event_date);
389:
390: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
391: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
392: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
393: RAISE OKL_API.G_EXCEPTION_ERROR;
394: END IF;
395:
396: l_accounting_event_id := l_exist_event_id;

Line 393: RAISE OKL_API.G_EXCEPTION_ERROR;

389:
390: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
391: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
392: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
393: RAISE OKL_API.G_EXCEPTION_ERROR;
394: END IF;
395:
396: l_accounting_event_id := l_exist_event_id;
397:

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

410: ,p_action_type => 'REVERSE'
411: ,p_representation_code => l_gl_short_name
412: );
413:
414: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;

Line 415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

411: ,p_representation_code => l_gl_short_name
412: );
413:
414: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:

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

412: );
413:
414: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:
420: l_accounting_event_id := l_event_id;

Line 417: RAISE OKL_API.G_EXCEPTION_ERROR;

413:
414: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:
420: l_accounting_event_id := l_event_id;
421:

Line 524: WHEN OKL_API.G_EXCEPTION_ERROR THEN

520: x_return_status := l_return_status;
521:
522: EXCEPTION
523:
524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
525:
526: x_return_status := OKL_API.G_RET_STS_ERROR;
527:
528: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 526: x_return_status := OKL_API.G_RET_STS_ERROR;

522: EXCEPTION
523:
524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
525:
526: x_return_status := OKL_API.G_RET_STS_ERROR;
527:
528: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
529:
530: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 528: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
525:
526: x_return_status := OKL_API.G_RET_STS_ERROR;
527:
528: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
529:
530: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
531:
532: WHEN OTHERS THEN

Line 530: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

526: x_return_status := OKL_API.G_RET_STS_ERROR;
527:
528: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
529:
530: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
531:
532: WHEN OTHERS THEN
533:
534: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 534: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

530: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
531:
532: WHEN OTHERS THEN
533:
534: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
535:
536:
537: END REVERSE_ENTRIES;
538:

Line 553: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

549: IS
550:
551: l_api_version CONSTANT NUMBER := 1;
552: l_api_name CONSTANT VARCHAR2(30) := 'REVERSE_ENTRIES';
553: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
554: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
555: i NUMBER := 0;
556: l_msg_count NUMBER := 0;
557: l_msg_data VARCHAR2(2000);

Line 554: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

550:
551: l_api_version CONSTANT NUMBER := 1;
552: l_api_name CONSTANT VARCHAR2(30) := 'REVERSE_ENTRIES';
553: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
554: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
555: i NUMBER := 0;
556: l_msg_count NUMBER := 0;
557: l_msg_data VARCHAR2(2000);
558:

Line 569: p_init_msg_list => OKL_API.G_FALSE,

565:
566: LOOP
567:
568: REVERSE_ENTRIES(p_api_version => 1.0,
569: p_init_msg_list => OKL_API.G_FALSE,
570: x_return_status => l_return_status,
571: x_msg_count => l_msg_count,
572: x_msg_data => l_msg_data,
573: p_source_id => p_source_id_tbl(i),

Line 577: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

573: p_source_id => p_source_id_tbl(i),
574: p_source_table => p_source_table,
575: p_acct_date => p_acct_date);
576:
577: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
578: IF (l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
579: l_overall_status := l_return_status;
580: END IF;
581: END IF;

Line 578: IF (l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

574: p_source_table => p_source_table,
575: p_acct_date => p_acct_date);
576:
577: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
578: IF (l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
579: l_overall_status := l_return_status;
580: END IF;
581: END IF;
582:

Line 613: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

609: IS
610:
611: l_api_version CONSTANT NUMBER := 1.0;
612: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_PERIOD_REVERSAL';
613: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
614: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;
615: l_msg_count NUMBER;
616: l_msg_data VARCHAR2(2000);
617:

Line 614: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;

610:
611: l_api_version CONSTANT NUMBER := 1.0;
612: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_PERIOD_REVERSAL';
613: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
614: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;
615: l_msg_count NUMBER;
616: l_msg_data VARCHAR2(2000);
617:
618: BEGIN

Line 620: x_return_status := OKL_API.G_RET_STS_SUCCESS;

616: l_msg_data VARCHAR2(2000);
617:
618: BEGIN
619:
620: x_return_status := OKL_API.G_RET_STS_SUCCESS;
621:
622: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
623: G_PKG_NAME,
624: p_init_msg_list,

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

618: BEGIN
619:
620: x_return_status := OKL_API.G_RET_STS_SUCCESS;
621:
622: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
623: G_PKG_NAME,
624: p_init_msg_list,
625: l_api_version,
626: p_api_version,

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

625: l_api_version,
626: p_api_version,
627: '_PVT',
628: x_return_status);
629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;

Line 630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

626: p_api_version,
627: '_PVT',
628: x_return_status);
629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;
634:

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

627: '_PVT',
628: x_return_status);
629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;
634:
635: -- check for period name before submitting the request.

Line 632: RAISE OKL_API.G_EXCEPTION_ERROR;

628: x_return_status);
629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;
634:
635: -- check for period name before submitting the request.
636: IF (p_period IS NULL) OR (p_period = Okl_Api.G_MISS_CHAR) THEN

Line 636: IF (p_period IS NULL) OR (p_period = Okl_Api.G_MISS_CHAR) THEN

632: RAISE OKL_API.G_EXCEPTION_ERROR;
633: END IF;
634:
635: -- check for period name before submitting the request.
636: IF (p_period IS NULL) OR (p_period = Okl_Api.G_MISS_CHAR) THEN
637: Okc_Api.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Period Name');
638: RAISE Okl_Api.G_EXCEPTION_ERROR;
639: END IF;
640:

Line 638: RAISE Okl_Api.G_EXCEPTION_ERROR;

634:
635: -- check for period name before submitting the request.
636: IF (p_period IS NULL) OR (p_period = Okl_Api.G_MISS_CHAR) THEN
637: Okc_Api.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Period Name');
638: RAISE Okl_Api.G_EXCEPTION_ERROR;
639: END IF;
640:
641: -- Submit Concurrent Program Request for interest calculation
642:

Line 655: RAISE okl_api.g_exception_error;

651: Okc_Api.set_message(p_app_name => 'OFA',
652: p_msg_name => 'FA_DEPRN_TAX_ERROR',
653: p_token1 => 'REQUEST_ID',
654: p_token1_value => x_request_id);
655: RAISE okl_api.g_exception_error;
656:
657: END IF;
658:
659: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 659: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

655: RAISE okl_api.g_exception_error;
656:
657: END IF;
658:
659: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
660:
661: EXCEPTION
662:
663: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 663: WHEN OKL_API.G_EXCEPTION_ERROR THEN

659: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
660:
661: EXCEPTION
662:
663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
664: x_return_status := OKL_API.HANDLE_EXCEPTIONS
665: (
666: l_api_name,
667: G_PKG_NAME,

Line 664: x_return_status := OKL_API.HANDLE_EXCEPTIONS

660:
661: EXCEPTION
662:
663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
664: x_return_status := OKL_API.HANDLE_EXCEPTIONS
665: (
666: l_api_name,
667: G_PKG_NAME,
668: 'OKL_API.G_RET_STS_ERROR',

Line 668: 'OKL_API.G_RET_STS_ERROR',

664: x_return_status := OKL_API.HANDLE_EXCEPTIONS
665: (
666: l_api_name,
667: G_PKG_NAME,
668: 'OKL_API.G_RET_STS_ERROR',
669: x_msg_count,
670: x_msg_data,
671: '_PVT'
672: );

Line 673: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

669: x_msg_count,
670: x_msg_data,
671: '_PVT'
672: );
673: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
674: x_return_status := OKL_API.HANDLE_EXCEPTIONS
675: (
676: l_api_name,
677: G_PKG_NAME,

Line 674: x_return_status := OKL_API.HANDLE_EXCEPTIONS

670: x_msg_data,
671: '_PVT'
672: );
673: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
674: x_return_status := OKL_API.HANDLE_EXCEPTIONS
675: (
676: l_api_name,
677: G_PKG_NAME,
678: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 678: 'OKL_API.G_RET_STS_UNEXP_ERROR',

674: x_return_status := OKL_API.HANDLE_EXCEPTIONS
675: (
676: l_api_name,
677: G_PKG_NAME,
678: 'OKL_API.G_RET_STS_UNEXP_ERROR',
679: x_msg_count,
680: x_msg_data,
681: '_PVT'
682: );

Line 684: x_return_status := OKL_API.HANDLE_EXCEPTIONS

680: x_msg_data,
681: '_PVT'
682: );
683: WHEN OTHERS THEN
684: x_return_status := OKL_API.HANDLE_EXCEPTIONS
685: (
686: l_api_name,
687: G_PKG_NAME,
688: 'OTHERS',