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_MISC_TRANS_PVT dependencies on OKL_API

Line 96: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

92: l_dist_tbl TABV_TBL_TYPE;
93: l_aetv_rec OKL_ACCT_EVENT_PUB.AETV_REC_TYPE;
94: i NUMBER := 0;
95: l_api_version NUMBER := 1.0;
96: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
97: l_msg_count NUMBER := 0;
98: l_msg_data VARCHAR2(2000);
99: l_id NUMBER;
100: l_aet_id NUMBER;

Line 118: x_return_status := OKL_API.G_RET_STS_SUCCESS;

114:
115:
116: BEGIN
117:
118: x_return_status := OKL_API.G_RET_STS_SUCCESS;
119:
120: IF (p_flag = 'DIST') THEN
121:
122: OPEN dist_csr(p_source_id, p_source_table);

Line 262: x_return_status := OKL_API.G_RET_STS_SUCCESS;

258: l_sum_txl_amt NUMBER := 0;
259:
260: BEGIN
261:
262: x_return_status := OKL_API.G_RET_STS_SUCCESS;
263:
264: -- Fetch trx amount
265: FOR trx_amt_rec IN trx_amt_csr (p_tclv_rec.TCN_ID) LOOP
266: l_trx_amt := NVL(trx_amt_rec.AMOUNT, 0);

Line 290: x_return_status := OKL_API.G_RET_STS_ERROR;

286:
287: -- Return Error status if sum of trx line amount is greater than trx amount.
288:
289: IF (l_sum_txl_amt + NVL(p_tclv_rec.AMOUNT, 0) )> l_trx_amt THEN
290: x_return_status := OKL_API.G_RET_STS_ERROR;
291: END IF;
292:
293: END Validate_Amount;
294:

Line 323: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

319: l_api_name CONSTANT VARCHAR2(40) := 'CREATE_MISC_DSTR_LINE';
320: l_api_version CONSTANT NUMBER := 1.0;
321: l_tab_api_version CONSTANT NUMBER := 1.0;
322:
323: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
324: l_msg_count NUMBER := 0;
325: l_msg_data VARCHAR2(2000);
326: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
327:

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

322:
323: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
324: l_msg_count NUMBER := 0;
325: l_msg_data VARCHAR2(2000);
326: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
327:
328: l_tclv_rec_in TCLV_REC_TYPE ;
329: l_tclv_rec_out TCLV_REC_TYPE;
330: l_tabv_tbl OKL_TRNS_ACC_DSTRS_PUB.TABV_TBL_TYPE;

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

343:
344:
345: BEGIN
346:
347: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
348: G_PKG_NAME,
349: p_init_msg_list,
350: l_api_version,
351: p_api_version,

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

350: l_api_version,
351: p_api_version,
352: '_PVT',
353: x_return_status);
354: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
356: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
357: RAISE OKL_API.G_EXCEPTION_ERROR;
358: END IF;

Line 355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

351: p_api_version,
352: '_PVT',
353: x_return_status);
354: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
356: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
357: RAISE OKL_API.G_EXCEPTION_ERROR;
358: END IF;
359:

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

352: '_PVT',
353: x_return_status);
354: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
356: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
357: RAISE OKL_API.G_EXCEPTION_ERROR;
358: END IF;
359:
360: l_tclv_rec_in := p_tclv_rec;

Line 357: RAISE OKL_API.G_EXCEPTION_ERROR;

353: x_return_status);
354: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
356: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
357: RAISE OKL_API.G_EXCEPTION_ERROR;
358: END IF;
359:
360: l_tclv_rec_in := p_tclv_rec;
361:

Line 368: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

364: CLOSE tcn_csr;
365:
366: IF (l_tsu_code = 'CANCELED') THEN
367:
368: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
369: p_msg_name => 'OKL_TRX_CANCELED');
370:
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372:

Line 371: RAISE OKL_API.G_EXCEPTION_ERROR;

367:
368: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
369: p_msg_name => 'OKL_TRX_CANCELED');
370:
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372:
373: END IF;
374:
375: IF (l_tclv_rec_in.Amount IS NULL) OR

Line 376: (l_tclv_rec_in.Amount = OKL_API.G_MISS_NUM) OR

372:
373: END IF;
374:
375: IF (l_tclv_rec_in.Amount IS NULL) OR
376: (l_tclv_rec_in.Amount = OKL_API.G_MISS_NUM) OR
377: (l_tclv_rec_in.Amount = 0) THEN
378: OKL_API.SET_MESSAGE(p_app_name => 'OKC'
379: ,p_msg_name => g_required_value
380: ,p_token1 => g_col_name_token

Line 378: OKL_API.SET_MESSAGE(p_app_name => 'OKC'

374:
375: IF (l_tclv_rec_in.Amount IS NULL) OR
376: (l_tclv_rec_in.Amount = OKL_API.G_MISS_NUM) OR
377: (l_tclv_rec_in.Amount = 0) THEN
378: OKL_API.SET_MESSAGE(p_app_name => 'OKC'
379: ,p_msg_name => g_required_value
380: ,p_token1 => g_col_name_token
381: ,p_token1_value => 'AMOUNT');
382: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 382: RAISE OKL_API.G_EXCEPTION_ERROR;

378: OKL_API.SET_MESSAGE(p_app_name => 'OKC'
379: ,p_msg_name => g_required_value
380: ,p_token1 => g_col_name_token
381: ,p_token1_value => 'AMOUNT');
382: RAISE OKL_API.G_EXCEPTION_ERROR;
383: END IF;
384:
385:
386: IF (l_tclv_rec_in.ID = OKL_API.G_MISS_NUM) OR

Line 386: IF (l_tclv_rec_in.ID = OKL_API.G_MISS_NUM) OR

382: RAISE OKL_API.G_EXCEPTION_ERROR;
383: END IF;
384:
385:
386: IF (l_tclv_rec_in.ID = OKL_API.G_MISS_NUM) OR
387: (l_tclv_rec_in.ID IS NULL) THEN -- Create Mode
388:
389: l_tclv_rec_in.TCL_TYPE := 'MAE';
390:

Line 400: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

396: Validate_Amount (p_tclv_rec => l_tclv_rec_in,
397: p_mode => 'I',
398: x_return_status => l_return_status);
399:
400: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
401: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
402: p_msg_name => 'OKL_TRX_AMT_GT_LINE_AMT');
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404:

Line 401: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

397: p_mode => 'I',
398: x_return_status => l_return_status);
399:
400: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
401: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
402: p_msg_name => 'OKL_TRX_AMT_GT_LINE_AMT');
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404:
405: END IF;

Line 403: RAISE OKL_API.G_EXCEPTION_ERROR;

399:
400: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
401: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
402: p_msg_name => 'OKL_TRX_AMT_GT_LINE_AMT');
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404:
405: END IF;
406:
407:

Line 432: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

428: END;
429: END IF;
430: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines
431:
432: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
433:
434: IF (l_tclv_rec_in.AVL_ID IS NOT NULL) AND
435: (l_tclv_rec_in.AVL_ID <> OKL_API.G_MISS_NUM) THEN
436:

Line 435: (l_tclv_rec_in.AVL_ID <> OKL_API.G_MISS_NUM) THEN

431:
432: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
433:
434: IF (l_tclv_rec_in.AVL_ID IS NOT NULL) AND
435: (l_tclv_rec_in.AVL_ID <> OKL_API.G_MISS_NUM) THEN
436:
437: CREATE_DIST_LINE(p_tclv_rec => l_tclv_rec_out,
438: x_return_status => l_return_status);
439:

Line 441: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

437: CREATE_DIST_LINE(p_tclv_rec => l_tclv_rec_out,
438: x_return_status => l_return_status);
439:
440: -- SAntonyr Added to fix 2804913
441: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;
444:
445:

Line 442: RAISE OKL_API.G_EXCEPTION_ERROR;

438: x_return_status => l_return_status);
439:
440: -- SAntonyr Added to fix 2804913
441: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;
444:
445:
446: END IF;

Line 472: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

468: Validate_Amount (p_tclv_rec => l_tclv_rec_in,
469: p_mode => 'U',
470: x_return_status => l_return_status);
471:
472: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
473: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
474: p_msg_name => 'OKL_TRX_AMT_GT_LINE_AMT');
475: RAISE OKL_API.G_EXCEPTION_ERROR;
476:

Line 473: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

469: p_mode => 'U',
470: x_return_status => l_return_status);
471:
472: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
473: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
474: p_msg_name => 'OKL_TRX_AMT_GT_LINE_AMT');
475: RAISE OKL_API.G_EXCEPTION_ERROR;
476:
477: END IF;

Line 475: RAISE OKL_API.G_EXCEPTION_ERROR;

471:
472: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
473: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
474: p_msg_name => 'OKL_TRX_AMT_GT_LINE_AMT');
475: RAISE OKL_API.G_EXCEPTION_ERROR;
476:
477: END IF;
478:
479:

Line 503: IF (nvl(l_tclv_rec_in.avl_id,OKL_API.G_MISS_NUM) <> nvl(l_avl_id,OKL_API.G_MISS_NUM)) OR

499: END;
500: END IF;
501: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
502:
503: IF (nvl(l_tclv_rec_in.avl_id,OKL_API.G_MISS_NUM) <> nvl(l_avl_id,OKL_API.G_MISS_NUM)) OR
504: (nvl(l_tclv_rec_in.sty_id,OKL_API.G_MISS_NUM) <> nvl(l_sty_id,OKL_API.G_MISS_NUM)) OR
505: (nvl(l_tclv_rec_in.amount,OKL_API.G_MISS_NUM) <> nvl(l_amount,OKL_API.G_MISS_NUM)) THEN
506: -- Significant Changed
507:

Line 504: (nvl(l_tclv_rec_in.sty_id,OKL_API.G_MISS_NUM) <> nvl(l_sty_id,OKL_API.G_MISS_NUM)) OR

500: END IF;
501: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
502:
503: IF (nvl(l_tclv_rec_in.avl_id,OKL_API.G_MISS_NUM) <> nvl(l_avl_id,OKL_API.G_MISS_NUM)) OR
504: (nvl(l_tclv_rec_in.sty_id,OKL_API.G_MISS_NUM) <> nvl(l_sty_id,OKL_API.G_MISS_NUM)) OR
505: (nvl(l_tclv_rec_in.amount,OKL_API.G_MISS_NUM) <> nvl(l_amount,OKL_API.G_MISS_NUM)) THEN
506: -- Significant Changed
507:
508:

Line 505: (nvl(l_tclv_rec_in.amount,OKL_API.G_MISS_NUM) <> nvl(l_amount,OKL_API.G_MISS_NUM)) THEN

501: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
502:
503: IF (nvl(l_tclv_rec_in.avl_id,OKL_API.G_MISS_NUM) <> nvl(l_avl_id,OKL_API.G_MISS_NUM)) OR
504: (nvl(l_tclv_rec_in.sty_id,OKL_API.G_MISS_NUM) <> nvl(l_sty_id,OKL_API.G_MISS_NUM)) OR
505: (nvl(l_tclv_rec_in.amount,OKL_API.G_MISS_NUM) <> nvl(l_amount,OKL_API.G_MISS_NUM)) THEN
506: -- Significant Changed
507:
508:
509: l_check_status := CHECK_DIST(p_source_id => l_tclv_rec_in.ID,

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

515: p_source_id => l_tclv_rec_in.ID,
516: p_source_table => l_source_table,
517: x_return_status => l_return_status);
518:
519: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
520: RAISE OKL_API.G_EXCEPTION_ERROR;
521: END IF;
522:
523: END IF;

Line 520: RAISE OKL_API.G_EXCEPTION_ERROR;

516: p_source_table => l_source_table,
517: x_return_status => l_return_status);
518:
519: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
520: RAISE OKL_API.G_EXCEPTION_ERROR;
521: END IF;
522:
523: END IF;
524:

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

528: p_source_id => l_tclv_rec_in.ID,
529: p_source_table => l_source_table,
530: x_return_status => l_return_status);
531:
532: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
533: RAISE OKL_API.G_EXCEPTION_ERROR;
534: END IF;
535:
536: END IF;

Line 533: RAISE OKL_API.G_EXCEPTION_ERROR;

529: p_source_table => l_source_table,
530: x_return_status => l_return_status);
531:
532: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
533: RAISE OKL_API.G_EXCEPTION_ERROR;
534: END IF;
535:
536: END IF;
537:

Line 540: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

536: END IF;
537:
538:
539: IF (l_check_status = 3) THEN
540: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
541: p_msg_name => 'OKL_AE_GONE_TO_GL');
542: RAISE OKL_API.G_EXCEPTION_ERROR;
543: END IF;
544:

Line 542: RAISE OKL_API.G_EXCEPTION_ERROR;

538:
539: IF (l_check_status = 3) THEN
540: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
541: p_msg_name => 'OKL_AE_GONE_TO_GL');
542: RAISE OKL_API.G_EXCEPTION_ERROR;
543: END IF;
544:
545: -- Now create distributions if template is specified.
546:

Line 548: (l_tclv_rec_in.AVL_ID <> OKL_API.G_MISS_NUM)) THEN

544:
545: -- Now create distributions if template is specified.
546:
547: IF ((l_tclv_rec_in.AVL_ID IS NOT NULL) AND
548: (l_tclv_rec_in.AVL_ID <> OKL_API.G_MISS_NUM)) THEN
549:
550: CREATE_DIST_LINE(p_tclv_rec => l_tclv_rec_out,
551: x_return_status => l_return_status);
552:

Line 554: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

550: CREATE_DIST_LINE(p_tclv_rec => l_tclv_rec_out,
551: x_return_status => l_return_status);
552:
553: -- SAntonyr Added to fix 2804913
554: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
555: RAISE OKL_API.G_EXCEPTION_ERROR;
556: END IF;
557:
558: END IF;

Line 555: RAISE OKL_API.G_EXCEPTION_ERROR;

551: x_return_status => l_return_status);
552:
553: -- SAntonyr Added to fix 2804913
554: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
555: RAISE OKL_API.G_EXCEPTION_ERROR;
556: END IF;
557:
558: END IF;
559:

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

561: END IF; -- Of something significant changed
562:
563: END IF; -- Of Update Mode
564:
565: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
566:
567: x_return_status := l_return_status;
568: x_tclv_rec := l_tclv_rec_out;
569:

Line 572: WHEN OKL_API.G_EXCEPTION_ERROR THEN

568: x_tclv_rec := l_tclv_rec_out;
569:
570: EXCEPTION
571:
572: WHEN OKL_API.G_EXCEPTION_ERROR THEN
573: x_return_status := OKL_API.HANDLE_EXCEPTIONS
574: (
575: l_api_name,
576: G_PKG_NAME,

Line 573: x_return_status := OKL_API.HANDLE_EXCEPTIONS

569:
570: EXCEPTION
571:
572: WHEN OKL_API.G_EXCEPTION_ERROR THEN
573: x_return_status := OKL_API.HANDLE_EXCEPTIONS
574: (
575: l_api_name,
576: G_PKG_NAME,
577: 'OKL_API.G_RET_STS_ERROR',

Line 577: 'OKL_API.G_RET_STS_ERROR',

573: x_return_status := OKL_API.HANDLE_EXCEPTIONS
574: (
575: l_api_name,
576: G_PKG_NAME,
577: 'OKL_API.G_RET_STS_ERROR',
578: x_msg_count,
579: x_msg_data,
580: '_PVT'
581: );

Line 582: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

578: x_msg_count,
579: x_msg_data,
580: '_PVT'
581: );
582: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
583: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
584: (
585: l_api_name,
586: G_PKG_NAME,

Line 583: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

579: x_msg_data,
580: '_PVT'
581: );
582: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
583: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
584: (
585: l_api_name,
586: G_PKG_NAME,
587: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 587: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 593: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

589: x_msg_data,
590: '_PVT'
591: );
592: WHEN OTHERS THEN
593: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
594: (
595: l_api_name,
596: G_PKG_NAME,
597: 'OTHERS',

Line 714: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

710:
711: l_dist_api_version CONSTANT NUMBER := 1.0;
712: l_aes_id NUMBER;
713:
714: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
715: l_msg_count NUMBER := 0;
716: l_msg_data VARCHAR2(2000);
717: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
718: l_template_id NUMBER ;

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

713:
714: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
715: l_msg_count NUMBER := 0;
716: l_msg_data VARCHAR2(2000);
717: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
718: l_template_id NUMBER ;
719:
720: l_dist_info_rec OKL_ACCOUNT_DIST_PUB.DIST_INFO_REC_TYPE;
721: l_tmpl_identify_rec OKL_ACCOUNT_DIST_PUB.TMPL_IDENTIFY_REC_TYPE;

Line 743: OKL_API.SET_MESSAGE(p_app_name => g_app_name

739: l_currency_conversion_rate,
740: l_currency_conversion_date;
741:
742: IF (tcn_csr%NOTFOUND) THEN
743: OKL_API.SET_MESSAGE(p_app_name => g_app_name
744: ,p_msg_name => g_invalid_value
745: ,p_token1 => g_col_name_token
746: ,p_token1_value => 'TCN_ID');
747:

Line 749: RAISE OKL_API.G_EXCEPTION_ERROR;

745: ,p_token1 => g_col_name_token
746: ,p_token1_value => 'TCN_ID');
747:
748: CLOSE tcn_csr;
749: RAISE OKL_API.G_EXCEPTION_ERROR;
750: END IF;
751:
752: CLOSE tcn_csr;
753:

Line 927: l_transaction_date okl_trx_contracts.transaction_date%TYPE := okl_api.g_miss_date;

923:
924: l_tcnv_rec okl_trans_contracts_pvt.tcnv_rec_type;
925: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||' populate_jrnl_hdr ';
926:
927: l_transaction_date okl_trx_contracts.transaction_date%TYPE := okl_api.g_miss_date;
928:
929: CURSOR c_transaction_date(
930: cp_khr_id okl_trx_contracts.khr_id%TYPE,
931: cp_trx_number okl_trx_contracts.trx_number%TYPE

Line 1013: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1009: p_tcnv_rec => l_tcnv_rec,
1010: x_tcnv_rec => lx_tcnv_rec);
1011:
1012: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
1013: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1015: RAISE OKL_API.G_EXCEPTION_ERROR;
1016: END IF;
1017: -- create journal lines for the header created above

Line 1015: RAISE OKL_API.G_EXCEPTION_ERROR;

1011:
1012: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
1013: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1015: RAISE OKL_API.G_EXCEPTION_ERROR;
1016: END IF;
1017: -- create journal lines for the header created above
1018: IF(p_jrnl_line_tbl.COUNT > 0) THEN
1019: FOR i IN p_jrnl_line_tbl.FIRST .. p_jrnl_line_tbl.LAST LOOP

Line 1037: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1033: p_tclv_rec => l_tclv_rec,
1034: x_tclv_rec => lx_tclv_rec);
1035:
1036: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
1037: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1038: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1039: RAISE OKL_API.G_EXCEPTION_ERROR;
1040: END IF;
1041: END IF; -- end of exists condition

Line 1039: RAISE OKL_API.G_EXCEPTION_ERROR;

1035:
1036: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
1037: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1038: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1039: RAISE OKL_API.G_EXCEPTION_ERROR;
1040: END IF;
1041: END IF; -- end of exists condition
1042: END LOOP; -- end of journal line table loop
1043: END IF; -- end of condition check for journal lines

Line 1058: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1054: x_return_status := lx_return_status;
1055:
1056: EXCEPTION
1057:
1058: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1059: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1060: p_data => x_msg_data);
1061: x_return_status := G_RET_STS_ERROR;
1062:

Line 1063: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1059: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1060: p_data => x_msg_data);
1061: x_return_status := G_RET_STS_ERROR;
1062:
1063: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1064: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1065: p_data => x_msg_data);
1066: x_return_status := G_RET_STS_UNEXP_ERROR;
1067:

Line 1069: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1065: p_data => x_msg_data);
1066: x_return_status := G_RET_STS_UNEXP_ERROR;
1067:
1068: WHEN OTHERS THEN
1069: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1070: p_msg_name => G_DB_ERROR,
1071: p_token1 => G_PROG_NAME_TOKEN,
1072: p_token1_value => l_prog_name,
1073: p_token2 => G_SQLCODE_TOKEN,

Line 1133: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1129: p_tcnv_rec => l_tcnv_rec,
1130: x_tcnv_rec => lx_tcnv_rec);
1131:
1132: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
1133: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1135: RAISE OKL_API.G_EXCEPTION_ERROR;
1136: END IF;
1137: -- create journal lines for the header created above

Line 1135: RAISE OKL_API.G_EXCEPTION_ERROR;

1131:
1132: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
1133: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1134: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1135: RAISE OKL_API.G_EXCEPTION_ERROR;
1136: END IF;
1137: -- create journal lines for the header created above
1138: IF(p_jrnl_line_tbl.COUNT > 0) THEN
1139: FOR i IN p_jrnl_line_tbl.FIRST .. p_jrnl_line_tbl.LAST LOOP

Line 1157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1153: p_tclv_rec => l_tclv_rec,
1154: x_tclv_rec => lx_tclv_rec);
1155:
1156: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
1157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1158: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1159: RAISE OKL_API.G_EXCEPTION_ERROR;
1160: END IF;
1161: END IF; -- end of exists condition

Line 1159: RAISE OKL_API.G_EXCEPTION_ERROR;

1155:
1156: IF lx_return_status = G_RET_STS_UNEXP_ERROR THEN
1157: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1158: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1159: RAISE OKL_API.G_EXCEPTION_ERROR;
1160: END IF;
1161: END IF; -- end of exists condition
1162: END LOOP; -- end of journal line table loop
1163: END IF; -- end of condition check for journal lines

Line 1169: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1165: x_return_status := lx_return_status;
1166:
1167: EXCEPTION
1168:
1169: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1170: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1171: p_data => x_msg_data);
1172: x_return_status := G_RET_STS_ERROR;
1173:

Line 1174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1170: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1171: p_data => x_msg_data);
1172: x_return_status := G_RET_STS_ERROR;
1173:
1174: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1175: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1176: p_data => x_msg_data);
1177: x_return_status := G_RET_STS_UNEXP_ERROR;
1178:

Line 1180: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1176: p_data => x_msg_data);
1177: x_return_status := G_RET_STS_UNEXP_ERROR;
1178:
1179: WHEN OTHERS THEN
1180: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1181: p_msg_name => G_DB_ERROR,
1182: p_token1 => G_PROG_NAME_TOKEN,
1183: p_token1_value => l_prog_name,
1184: p_token2 => G_SQLCODE_TOKEN,