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_AM_PROCESS_ASSET_TRX_PVT dependencies on OKC_API

Line 90: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

86:
87: fnd_file.new_line(fnd_file.log,2);
88: fnd_file.new_line(fnd_file.output,2);
89:
90: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
91: fnd_file.put_line(fnd_file.log, 'FA ADJUSTMENTS Failed, None of the transactions got processed');
92: fnd_file.put_line(fnd_file.output, 'FA ADJUSTMENTS Failed, None of the transactions got processed');
93: END IF;
94:

Line 363: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

359:
360: -- SECHAWLA 19-FEB-04 3439647 : End New Declarations
361:
362:
363: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
364: l_api_name CONSTANT VARCHAR2(30) := 'process_transactions';
365:
366: l_trans_rec FA_API_TYPES.trans_rec_type;
367:

Line 448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

444: p_api_version,
445: '_PVT',
446: x_return_status);
447:
448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
451: RAISE OKC_API.G_EXCEPTION_ERROR;
452: END IF;

Line 449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

445: '_PVT',
446: x_return_status);
447:
448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
451: RAISE OKC_API.G_EXCEPTION_ERROR;
452: END IF;
453:

Line 450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

446: x_return_status);
447:
448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
451: RAISE OKC_API.G_EXCEPTION_ERROR;
452: END IF;
453:
454:

Line 451: RAISE OKC_API.G_EXCEPTION_ERROR;

447:
448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
451: RAISE OKC_API.G_EXCEPTION_ERROR;
452: END IF;
453:
454:
455:

Line 470: l_transaction_status := OKC_API.G_RET_STS_SUCCESS;

466: -- Fetch the Operating Unit for the Concurrent Program
467: l_org_id := mo_global.get_current_org_id();
468: -- Bug 6459571: End
469: FOR l_distinctasset_rec IN l_distinctasset_csr(l_sysdate, l_org_id) LOOP
470: l_transaction_status := OKC_API.G_RET_STS_SUCCESS;
471: l_trx_count := 0;
472: l_trxassets_tbl := l_trxassets_empty_tbl;
473: l_pos := 0;
474:

Line 483: --l_transaction_status := OKC_API.G_RET_STS_SUCCESS;

479:
480: -- loop thru all the transactions in the OKL tables and process them in FA
481: FOR l_assettrx_rec IN l_assettrx_csr(l_sysdate, l_distinctasset_rec.asset_number) LOOP
482:
483: --l_transaction_status := OKC_API.G_RET_STS_SUCCESS;
484: l_total_count := l_total_count + 1;
485: l_trx_count := l_trx_count + 1;
486:
487: /*-- initialize all the structures to null values

Line 523: OKC_API.set_message( p_app_name => 'OKL',

519: OPEN l_dealtype_csr(l_assettrx_rec.kle_id);
520: FETCH l_dealtype_csr INTO l_chr_id, l_deal_type, l_contract_number;
521: IF l_dealtype_csr%NOTFOUND OR l_deal_type IS NULL OR l_deal_type = OKL_API.G_MISS_CHAR THEN
522: -- Can not find deal type for asset ASSET_NUMBER.
523: OKC_API.set_message( p_app_name => 'OKL',
524: p_msg_name => 'OKL_AM_DEAL_TYPE_NOT_FOUND',
525: p_token1 => 'ASSET_NUMBER',
526: p_token1_value => l_assettrx_rec.asset_number);
527:

Line 528: l_transaction_status := OKC_API.G_RET_STS_ERROR;

524: p_msg_name => 'OKL_AM_DEAL_TYPE_NOT_FOUND',
525: p_token1 => 'ASSET_NUMBER',
526: p_token1_value => l_assettrx_rec.asset_number);
527:
528: l_transaction_status := OKC_API.G_RET_STS_ERROR;
529: ELSE
530:
531: IF l_assettrx_rec.asset_book IS NULL OR l_assettrx_rec.asset_book = OKL_API.G_MISS_CHAR THEN
532: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER as FIELD is missing.

Line 533: OKC_API.set_message( p_app_name => 'OKL',

529: ELSE
530:
531: IF l_assettrx_rec.asset_book IS NULL OR l_assettrx_rec.asset_book = OKL_API.G_MISS_CHAR THEN
532: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER as FIELD is missing.
533: OKC_API.set_message( p_app_name => 'OKL',
534: p_msg_name => 'OKL_AM_NO_ASSET_BOOK',
535: p_token1 => 'TRX_TYPE',
536: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
537: p_token2 => 'ASSET_NUMBER',

Line 542: l_transaction_status := OKC_API.G_RET_STS_ERROR;

538: p_token2_value => l_assettrx_rec.asset_number,
539: p_token3 => 'FIELD',
540: p_token3_value => 'Asset Book');
541:
542: l_transaction_status := OKC_API.G_RET_STS_ERROR;
543: -- SECHAWLA 06-MAY-04 3578894 Added new tas types 'AUD','AUS' to following condition
544: ELSIF (l_assettrx_rec.tas_type IN ('AMT','AUD','AUS')) AND (l_assettrx_rec.depreciate_yn IS NULL OR
545: l_assettrx_rec.depreciate_yn = OKL_API.G_MISS_CHAR) THEN
546: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as depreciate (Y/N) flag is missing.

Line 547: OKC_API.set_message( p_app_name => 'OKL',

543: -- SECHAWLA 06-MAY-04 3578894 Added new tas types 'AUD','AUS' to following condition
544: ELSIF (l_assettrx_rec.tas_type IN ('AMT','AUD','AUS')) AND (l_assettrx_rec.depreciate_yn IS NULL OR
545: l_assettrx_rec.depreciate_yn = OKL_API.G_MISS_CHAR) THEN
546: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as depreciate (Y/N) flag is missing.
547: OKC_API.set_message( p_app_name => 'OKL',
548: p_msg_name => 'OKL_AM_DATA_REQUIRED',
549: p_token1 => 'TRX_TYPE',
550: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
551: p_token2 => 'ASSET_NUMBER',

Line 558: l_transaction_status := OKC_API.G_RET_STS_ERROR;

554: p_token3_value => l_assettrx_rec.asset_book,
555: p_token4 => 'FIELD',
556: p_token4_value => 'Depreciate (Y/N) flag');
557:
558: l_transaction_status := OKC_API.G_RET_STS_ERROR;
559: ELSIF l_assettrx_rec.dnz_asset_id IS NULL OR l_assettrx_rec.dnz_asset_id = OKL_API.G_MISS_NUM THEN
560: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as Asset ID
561: -- is missing.
562: OKC_API.set_message( p_app_name => 'OKL',

Line 562: OKC_API.set_message( p_app_name => 'OKL',

558: l_transaction_status := OKC_API.G_RET_STS_ERROR;
559: ELSIF l_assettrx_rec.dnz_asset_id IS NULL OR l_assettrx_rec.dnz_asset_id = OKL_API.G_MISS_NUM THEN
560: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as Asset ID
561: -- is missing.
562: OKC_API.set_message( p_app_name => 'OKL',
563: p_msg_name => 'OKL_AM_DATA_REQUIRED',
564: p_token1 => 'TRX_TYPE',
565: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
566: p_token2 => 'ASSET_NUMBER',

Line 573: l_transaction_status := OKC_API.G_RET_STS_ERROR;

569: p_token3_value => l_assettrx_rec.asset_book,
570: p_token4 => 'FIELD',
571: p_token4_value => 'Asset ID');
572:
573: l_transaction_status := OKC_API.G_RET_STS_ERROR;
574:
575: ELSE
576:
577: OPEN l_facostsv_csr(l_assettrx_rec.asset_number, l_assettrx_rec.asset_book);

Line 599: OKC_API.set_message( p_app_name => 'OKL',

595: ELSIF (l_fa_life_in_months IS NULL AND l_fa_deprn_rate IS NULL) THEN
596:
597: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as Cost / salvage Value
598: -- is missing.
599: OKC_API.set_message( p_app_name => 'OKL',
600: p_msg_name => 'OKL_AM_DATA_REQUIRED',
601: p_token1 => 'TRX_TYPE',
602: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
603: p_token2 => 'ASSET_NUMBER',

Line 641: p_init_msg_list => OKC_API.G_FALSE,

637: --l_asset_fin_rec_adj.contract_id := FND_API.G_MISS_NUM;
638:
639: fa_adjustment_pub.do_adjustment(
640: p_api_version => p_api_version,
641: p_init_msg_list => OKC_API.G_FALSE,
642: p_commit => FND_API.G_FALSE,
643: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
644: p_calling_fn => NULL,
645: x_return_status => l_return_status,

Line 660: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

656: x_asset_deprn_rec_new => l_asset_deprn_rec_new,
657: x_asset_deprn_mrc_tbl_new => l_asset_deprn_mrc_tbl_new,
658: p_group_reclass_options_rec => l_group_reclass_options_rec);
659:
660: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
661:
662: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
663: OKC_API.set_message( p_app_name => 'OKL',
664: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',

Line 663: OKC_API.set_message( p_app_name => 'OKL',

659:
660: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
661:
662: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
663: OKC_API.set_message( p_app_name => 'OKL',
664: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',
665: p_token1 => 'TRX_TYPE',
666: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
667: p_token2 => 'ASSET_NUMBER',

Line 690: p_init_msg_list => okc_api.g_false,

686: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
687: l_fxlv_rec.asset_book_type_name := l_assettrx_rec.asset_book;
688: --call api
689: okl_sla_acc_sources_pvt.populate_sources(p_api_version => p_api_version,
690: p_init_msg_list => okc_api.g_false,
691: p_fxhv_rec => l_fxhv_rec,
692: p_fxlv_rec => l_fxlv_rec,
693: x_return_status => x_return_status,
694: x_msg_count => x_msg_count,

Line 697: IF (x_return_status = okc_api.g_ret_sts_unexp_error)

693: x_return_status => x_return_status,
694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data);
696:
697: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
698: THEN
699: RAISE okl_api.g_exception_unexpected_error;
700: ELSIF (x_return_status = okc_api.g_ret_sts_error)
701: THEN

Line 700: ELSIF (x_return_status = okc_api.g_ret_sts_error)

696:
697: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
698: THEN
699: RAISE okl_api.g_exception_unexpected_error;
700: ELSIF (x_return_status = okc_api.g_ret_sts_error)
701: THEN
702: RAISE okl_api.g_exception_error;
703: END IF;
704: --akrangan populate sources cr end

Line 711: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

707: p_book_type_code => l_assettrx_rec.asset_book,
708: x_return_status => l_return_status,
709: x_fa_trx_date => l_fa_trx_date);
710:
711: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
712: l_transaction_status := l_return_status;
713: END IF;
714:
715: END IF;

Line 754: p_init_msg_list => OKC_API.G_FALSE,

750: l_trans_rec.transaction_date_entered := l_assettrx_rec.date_trans_occurred;
751: -- Bug 6965689 end
752: fa_adjustment_pub.do_adjustment(
753: p_api_version => p_api_version,
754: p_init_msg_list => OKC_API.G_FALSE,
755: p_commit => FND_API.G_FALSE,
756: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
757: p_calling_fn => NULL,
758: x_return_status => l_return_status,

Line 773: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

769: x_asset_deprn_rec_new => l_asset_deprn_rec_new,
770: x_asset_deprn_mrc_tbl_new => l_asset_deprn_mrc_tbl_new,
771: p_group_reclass_options_rec => l_group_reclass_options_rec);
772:
773: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
774:
775: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
776: OKC_API.set_message( p_app_name => 'OKL',
777: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',

Line 776: OKC_API.set_message( p_app_name => 'OKL',

772:
773: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
774:
775: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
776: OKC_API.set_message( p_app_name => 'OKL',
777: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',
778: p_token1 => 'TRX_TYPE',
779: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
780: p_token2 => 'ASSET_NUMBER', -- SECHAWLA Bug # 2701440 : Added token2 value

Line 805: p_init_msg_list => okc_api.g_false,

801: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
802: l_fxlv_rec.asset_book_type_name := l_assettrx_rec.asset_book;
803: --call api
804: okl_sla_acc_sources_pvt.populate_sources(p_api_version => p_api_version,
805: p_init_msg_list => okc_api.g_false,
806: p_fxhv_rec => l_fxhv_rec,
807: p_fxlv_rec => l_fxlv_rec,
808: x_return_status => x_return_status,
809: x_msg_count => x_msg_count,

Line 812: IF (x_return_status = okc_api.g_ret_sts_unexp_error)

808: x_return_status => x_return_status,
809: x_msg_count => x_msg_count,
810: x_msg_data => x_msg_data);
811:
812: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
813: THEN
814: RAISE okl_api.g_exception_unexpected_error;
815: ELSIF (x_return_status = okc_api.g_ret_sts_error)
816: THEN

Line 815: ELSIF (x_return_status = okc_api.g_ret_sts_error)

811:
812: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
813: THEN
814: RAISE okl_api.g_exception_unexpected_error;
815: ELSIF (x_return_status = okc_api.g_ret_sts_error)
816: THEN
817: RAISE okl_api.g_exception_error;
818: END IF;
819: --akrangan populate sources cr changes end

Line 826: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

822: p_book_type_code => l_assettrx_rec.asset_book,
823: x_return_status => l_return_status,
824: x_fa_trx_date => l_fa_trx_date);
825:
826: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
827: l_transaction_status := l_return_status;
828: END IF;
829: END IF;
830:

Line 849: OKC_API.set_message( p_app_name => 'OKL',

845: ) THEN
846:
847: IF l_assettrx_rec.deprn_method IS NULL OR l_assettrx_rec.deprn_method = OKL_APi.G_MISS_CHAR THEN
848: -- Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as FIELD is missing.
849: OKC_API.set_message( p_app_name => 'OKL',
850: p_msg_name => 'OKL_AM_DATA_REQUIRED',
851: p_token1 => 'TRX_TYPE',
852: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
853: p_token2 => 'ASSET_NUMBER',

Line 859: l_transaction_status := OKC_API.G_RET_STS_ERROR;

855: p_token3 => 'ASSET_BOOK',
856: p_token3_value => l_assettrx_rec.asset_book,
857: p_token4 => 'FIELD',
858: p_token4_value => 'Depreciation Method');
859: l_transaction_status := OKC_API.G_RET_STS_ERROR;
860: ELSIF ( (l_assettrx_rec.life_in_months IS NULL OR l_assettrx_rec.life_in_months = OKL_APi.G_MISS_NUM)
861: AND --SECHAWLA 28-MAY-04 3645574 : Added deprn_rate check
862: (l_assettrx_rec.deprn_rate IS NULL OR l_assettrx_rec.deprn_rate = OKL_APi.G_MISS_NUM)
863: ) THEN

Line 865: OKC_API.set_message( p_app_name => 'OKL',

861: AND --SECHAWLA 28-MAY-04 3645574 : Added deprn_rate check
862: (l_assettrx_rec.deprn_rate IS NULL OR l_assettrx_rec.deprn_rate = OKL_APi.G_MISS_NUM)
863: ) THEN
864: -- Can not process transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as FIELD is missing.
865: OKC_API.set_message( p_app_name => 'OKL',
866: p_msg_name => 'OKL_AM_DATA_REQUIRED',
867: p_token1 => 'TRX_TYPE',
868: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
869: p_token2 => 'ASSET_NUMBER',

Line 875: l_transaction_status := OKC_API.G_RET_STS_ERROR;

871: p_token3 => 'ASSET_BOOK',
872: p_token3_value => l_assettrx_rec.asset_book,
873: p_token4 => 'FIELD',
874: p_token4_value => 'Life In Months / Depreciation Rate'); --SECHAWLA 28-MAY-04 3645574 : Added deprn_rate
875: l_transaction_status := OKC_API.G_RET_STS_ERROR;
876:
877: ELSIF l_assettrx_rec.salvage_value IS NULL OR l_assettrx_rec.salvage_value = OKL_APi.G_MISS_NUM THEN
878: -- Can not process transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as FIELD is missing.
879: OKC_API.set_message( p_app_name => 'OKL',

Line 879: OKC_API.set_message( p_app_name => 'OKL',

875: l_transaction_status := OKC_API.G_RET_STS_ERROR;
876:
877: ELSIF l_assettrx_rec.salvage_value IS NULL OR l_assettrx_rec.salvage_value = OKL_APi.G_MISS_NUM THEN
878: -- Can not process transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as FIELD is missing.
879: OKC_API.set_message( p_app_name => 'OKL',
880: p_msg_name => 'OKL_AM_DATA_REQUIRED',
881: p_token1 => 'TRX_TYPE',
882: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
883: p_token2 => 'ASSET_NUMBER',

Line 889: l_transaction_status := OKC_API.G_RET_STS_ERROR;

885: p_token3 => 'ASSET_BOOK',
886: p_token3_value => l_assettrx_rec.asset_book,
887: p_token4 => 'FIELD',
888: p_token4_value => 'Salvage Value');
889: l_transaction_status := OKC_API.G_RET_STS_ERROR;
890:
891: ELSE
892: -- sgorantl 27-mar-06 5097643: changes made by kbbhavsa for bug 4717511 has been reversed
893: l_dep_cost := l_assettrx_rec.depreciation_cost; -- sgorantl 27-mar-06 5097643

Line 981: p_init_msg_list => OKC_API.G_FALSE,

977:
978: l_asset_hdr_rec.book_type_code := l_assettrx_rec.asset_book;
979: fa_adjustment_pub.do_adjustment(
980: p_api_version => p_api_version,
981: p_init_msg_list => OKC_API.G_FALSE,
982: p_commit => FND_API.G_FALSE,
983: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
984: p_calling_fn => NULL,
985: x_return_status => l_return_status,

Line 1001: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

997: x_asset_deprn_mrc_tbl_new => l_asset_deprn_mrc_tbl_new,
998: p_group_reclass_options_rec => l_group_reclass_options_rec);
999:
1000:
1001: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1002: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
1003:
1004: OKC_API.set_message( p_app_name => 'OKL',
1005: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',

Line 1004: OKC_API.set_message( p_app_name => 'OKL',

1000:
1001: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1002: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
1003:
1004: OKC_API.set_message( p_app_name => 'OKL',
1005: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',
1006: p_token1 => 'TRX_TYPE',
1007: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
1008: p_token2 => 'ASSET_NUMBER',

Line 1033: p_init_msg_list => okc_api.g_false,

1029: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
1030: l_fxlv_rec.asset_book_type_name := l_assettrx_rec.asset_book;
1031: --call api
1032: okl_sla_acc_sources_pvt.populate_sources(p_api_version => p_api_version,
1033: p_init_msg_list => okc_api.g_false,
1034: p_fxhv_rec => l_fxhv_rec,
1035: p_fxlv_rec => l_fxlv_rec,
1036: x_return_status => x_return_status,
1037: x_msg_count => x_msg_count,

Line 1040: IF (x_return_status = okc_api.g_ret_sts_unexp_error)

1036: x_return_status => x_return_status,
1037: x_msg_count => x_msg_count,
1038: x_msg_data => x_msg_data);
1039:
1040: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
1041: THEN
1042: RAISE okl_api.g_exception_unexpected_error;
1043: ELSIF (x_return_status = okc_api.g_ret_sts_error)
1044: THEN

Line 1043: ELSIF (x_return_status = okc_api.g_ret_sts_error)

1039:
1040: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
1041: THEN
1042: RAISE okl_api.g_exception_unexpected_error;
1043: ELSIF (x_return_status = okc_api.g_ret_sts_error)
1044: THEN
1045: RAISE okl_api.g_exception_error;
1046: END IF;
1047: --akrangan populate sources cr changes end

Line 1054: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1050: p_book_type_code => l_assettrx_rec.asset_book,
1051: x_return_status => l_return_status,
1052: x_fa_trx_date => l_fa_trx_date);
1053:
1054: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1055: l_transaction_status := l_return_status;
1056: END IF;
1057: END IF;
1058: END IF;

Line 1093: p_init_msg_list => OKC_API.G_FALSE,

1089:
1090: l_asset_hdr_rec.book_type_code := l_assettrx_rec.asset_book;
1091: fa_adjustment_pub.do_adjustment(
1092: p_api_version => p_api_version,
1093: p_init_msg_list => OKC_API.G_FALSE,
1094: p_commit => FND_API.G_FALSE,
1095: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1096: p_calling_fn => NULL,
1097: x_return_status => l_return_status,

Line 1113: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1109: x_asset_deprn_mrc_tbl_new => l_asset_deprn_mrc_tbl_new,
1110: p_group_reclass_options_rec => l_group_reclass_options_rec);
1111:
1112:
1113: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1114: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
1115:
1116: OKC_API.set_message( p_app_name => 'OKL',
1117: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',

Line 1116: OKC_API.set_message( p_app_name => 'OKL',

1112:
1113: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1114: -- Error processing TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER in book BOOK.
1115:
1116: OKC_API.set_message( p_app_name => 'OKL',
1117: p_msg_name => 'OKL_AM_AMT_TRANS_FAILED',
1118: p_token1 => 'TRX_TYPE',
1119: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
1120: p_token2 => 'ASSET_NUMBER',

Line 1146: p_init_msg_list => okc_api.g_false,

1142: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
1143: l_fxlv_rec.asset_book_type_name := l_assettrx_rec.asset_book;
1144: --call api
1145: okl_sla_acc_sources_pvt.populate_sources(p_api_version => p_api_version,
1146: p_init_msg_list => okc_api.g_false,
1147: p_fxhv_rec => l_fxhv_rec,
1148: p_fxlv_rec => l_fxlv_rec,
1149: x_return_status => x_return_status,
1150: x_msg_count => x_msg_count,

Line 1153: IF (x_return_status = okc_api.g_ret_sts_unexp_error)

1149: x_return_status => x_return_status,
1150: x_msg_count => x_msg_count,
1151: x_msg_data => x_msg_data);
1152:
1153: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
1154: THEN
1155: RAISE okl_api.g_exception_unexpected_error;
1156: ELSIF (x_return_status = okc_api.g_ret_sts_error)
1157: THEN

Line 1156: ELSIF (x_return_status = okc_api.g_ret_sts_error)

1152:
1153: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
1154: THEN
1155: RAISE okl_api.g_exception_unexpected_error;
1156: ELSIF (x_return_status = okc_api.g_ret_sts_error)
1157: THEN
1158: RAISE okl_api.g_exception_error;
1159: END IF;
1160: --akrangan populate sources cr changes end

Line 1167: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1163: p_book_type_code => l_assettrx_rec.asset_book,
1164: x_return_status => l_return_status,
1165: x_fa_trx_date => l_fa_trx_date);
1166:
1167: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1168: l_transaction_status := l_return_status;
1169: END IF;
1170: END IF;
1171:

Line 1194: p_init_msg_list => OKC_API.G_FALSE,

1190: lp_tlpv_rec.FA_TRX_DATE := l_fa_trx_date;
1191:
1192: OKL_TXL_ASSETS_PUB.update_txl_asset_Def(
1193: p_api_version => p_api_version,
1194: p_init_msg_list => OKC_API.G_FALSE,
1195: x_return_status => l_return_status,
1196: x_msg_count => x_msg_count,
1197: x_msg_data => x_msg_data,
1198: p_tlpv_rec => lp_tlpv_rec,

Line 1201: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1197: x_msg_data => x_msg_data,
1198: p_tlpv_rec => lp_tlpv_rec,
1199: x_tlpv_rec => lx_tlpv_rec);
1200:
1201: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1202: -- Error updating Fixed Assets transaction date on TRX_TYPE transaction for asset ASSET_NUMBER in book BOOK.
1203: OKC_API.set_message( p_app_name => 'OKL',
1204: p_msg_name => 'OKL_AM_FA_DT_UPD_ERR',
1205: p_token1 => 'TRX_TYPE',

Line 1203: OKC_API.set_message( p_app_name => 'OKL',

1199: x_tlpv_rec => lx_tlpv_rec);
1200:
1201: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1202: -- Error updating Fixed Assets transaction date on TRX_TYPE transaction for asset ASSET_NUMBER in book BOOK.
1203: OKC_API.set_message( p_app_name => 'OKL',
1204: p_msg_name => 'OKL_AM_FA_DT_UPD_ERR',
1205: p_token1 => 'TRX_TYPE',
1206: p_token1_value => l_assettrx_rec.TAS_TYPE_MEANING,
1207: p_token2 => 'ASSET_NUMBER',

Line 1231: l_update_status := OKC_API.G_RET_STS_SUCCESS;

1227:
1228: ----------
1229:
1230:
1231: l_update_status := OKC_API.G_RET_STS_SUCCESS;
1232:
1233: IF l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN -- all the trasnsactions for this asset were successful
1234: IF l_trxassets_tbl.COUNT > 0 THEN
1235: j := l_trxassets_tbl.FIRST;

Line 1233: IF l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN -- all the trasnsactions for this asset were successful

1229:
1230:
1231: l_update_status := OKC_API.G_RET_STS_SUCCESS;
1232:
1233: IF l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN -- all the trasnsactions for this asset were successful
1234: IF l_trxassets_tbl.COUNT > 0 THEN
1235: j := l_trxassets_tbl.FIRST;
1236: LOOP
1237:

Line 1243: p_init_msg_list => OKC_API.G_FALSE,

1239: lp_thpv_rec.id := l_trxassets_tbl(j).id;
1240: lp_thpv_rec.tsu_code := 'PROCESSED';
1241: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
1242: p_api_version => p_api_version,
1243: p_init_msg_list => OKC_API.G_FALSE,
1244: x_return_status => l_return_status,
1245: x_msg_count => x_msg_count,
1246: x_msg_data => x_msg_data,
1247: p_thpv_rec => lp_thpv_rec,

Line 1250: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1246: x_msg_data => x_msg_data,
1247: p_thpv_rec => lp_thpv_rec,
1248: x_thpv_rec => lx_thpv_rec);
1249:
1250: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1251: -- TRX_TYPE Transaction status STATUS could not be updated in OKL for asset ASSET_NUMBER and book ASSET_BOOK.
1252: OKC_API.set_message( p_app_name => 'OKL',
1253: p_msg_name => 'OKL_AM_TRXASSET_UPD_FAILED',
1254: p_token1 => 'TRX_TYPE',

Line 1252: OKC_API.set_message( p_app_name => 'OKL',

1248: x_thpv_rec => lx_thpv_rec);
1249:
1250: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1251: -- TRX_TYPE Transaction status STATUS could not be updated in OKL for asset ASSET_NUMBER and book ASSET_BOOK.
1252: OKC_API.set_message( p_app_name => 'OKL',
1253: p_msg_name => 'OKL_AM_TRXASSET_UPD_FAILED',
1254: p_token1 => 'TRX_TYPE',
1255: p_token1_value => l_trxassets_tbl(j).tas_type_meaning,
1256: p_token2 => 'STATUS',

Line 1263: l_update_status := OKC_API.G_RET_STS_ERROR;

1259: p_token3_value => l_trxassets_tbl(j).asset_number,
1260: p_token4 => 'ASSET_BOOK',
1261: p_token4_value => l_trxassets_tbl(j).asset_book);
1262:
1263: l_update_status := OKC_API.G_RET_STS_ERROR;
1264:
1265: END IF;
1266:
1267: EXIT WHEN (j = l_trxassets_tbl.LAST);

Line 1271: IF l_update_status = OKC_API.G_RET_STS_SUCCESS THEN -- trx status updated successfully for all the transactions for this asset

1267: EXIT WHEN (j = l_trxassets_tbl.LAST);
1268: j := l_trxassets_tbl.NEXT(j);
1269: END LOOP;
1270:
1271: IF l_update_status = OKC_API.G_RET_STS_SUCCESS THEN -- trx status updated successfully for all the transactions for this asset
1272: COMMIT; -- it will commit changes in FA and also in OKL (trx status update)
1273: -- off-lease trx have been updated for asset ASSET_NUMBER in Fixed Assets.
1274: OKC_API.set_message( p_app_name => 'OKL',
1275: p_msg_name => 'OKL_AM_FA_UPD_DONE',

Line 1274: OKC_API.set_message( p_app_name => 'OKL',

1270:
1271: IF l_update_status = OKC_API.G_RET_STS_SUCCESS THEN -- trx status updated successfully for all the transactions for this asset
1272: COMMIT; -- it will commit changes in FA and also in OKL (trx status update)
1273: -- off-lease trx have been updated for asset ASSET_NUMBER in Fixed Assets.
1274: OKC_API.set_message( p_app_name => 'OKL',
1275: p_msg_name => 'OKL_AM_FA_UPD_DONE',
1276: p_token1 => 'ASSET_NUMBER',
1277: p_token1_value => l_distinctasset_rec.asset_number);
1278:

Line 1285: OKC_API.set_message( p_app_name => 'OKL',

1281: ROLLBACK TO asset_updates; -- This will rollback FA changes and also OKL changes (trx status update, incase status was chnaged
1282: -- to PROCESSED for some of the transactions
1283: -- The transactions will stay in ENTERED status
1284: -- Off-Lease trasnactions were not processed for asset ASSET_NUMBER in Fixed Assets.
1285: OKC_API.set_message( p_app_name => 'OKL',
1286: p_msg_name => 'OKL_AM_FA_UPD_NOT_DONE',
1287: p_token1 => 'ASSET_NUMBER',
1288: p_token1_value => l_distinctasset_rec.asset_number);
1289: END IF;

Line 1294: ELSE -- IF l_transaction_status <> OKC_API.G_RET_STS_SUCCESS THEN

1290:
1291: END IF; --IF l_trxassets_tbl.COUNT > 0 THEN
1292:
1293:
1294: ELSE -- IF l_transaction_status <> OKC_API.G_RET_STS_SUCCESS THEN
1295: -- one or more transactions errored out for this asset
1296:
1297: -- First rollback FA changes and then update trx status to ERROR
1298: ROLLBACK TO asset_updates;

Line 1300: OKC_API.set_message( p_app_name => 'OKL',

1296:
1297: -- First rollback FA changes and then update trx status to ERROR
1298: ROLLBACK TO asset_updates;
1299: -- Off-Lease trasnactions were not processed for asset ASSET_NUMBER in Fixed Assets.
1300: OKC_API.set_message( p_app_name => 'OKL',
1301: p_msg_name => 'OKL_AM_FA_UPD_NOT_DONE',
1302: p_token1 => 'ASSET_NUMBER',
1303: p_token1_value => l_distinctasset_rec.asset_number);
1304:

Line 1317: p_init_msg_list => OKC_API.G_FALSE,

1313: lp_thpv_rec.id := l_trxassets_tbl(j).id;
1314: lp_thpv_rec.tsu_code := 'ERROR';
1315: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
1316: p_api_version => p_api_version,
1317: p_init_msg_list => OKC_API.G_FALSE,
1318: x_return_status => l_return_status,
1319: x_msg_count => x_msg_count,
1320: x_msg_data => x_msg_data,
1321: p_thpv_rec => lp_thpv_rec,

Line 1324: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1320: x_msg_data => x_msg_data,
1321: p_thpv_rec => lp_thpv_rec,
1322: x_thpv_rec => lx_thpv_rec);
1323:
1324: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1325:
1326: -- TRX_TYPE Transaction status STATUS could not be updated in OKL for asset ASSET_NUMBER and book ASSET_BOOK.
1327: OKC_API.set_message( p_app_name => 'OKL',
1328: p_msg_name => 'OKL_AM_TRXASSET_UPD_FAILED',

Line 1327: OKC_API.set_message( p_app_name => 'OKL',

1323:
1324: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1325:
1326: -- TRX_TYPE Transaction status STATUS could not be updated in OKL for asset ASSET_NUMBER and book ASSET_BOOK.
1327: OKC_API.set_message( p_app_name => 'OKL',
1328: p_msg_name => 'OKL_AM_TRXASSET_UPD_FAILED',
1329: p_token1 => 'TRX_TYPE',
1330: p_token1_value => l_trxassets_tbl(j).tas_type_meaning,
1331: p_token2 => 'STATUS',

Line 1337: l_update_status := OKC_API.G_RET_STS_ERROR;

1333: p_token3 => 'ASSET_NUMBER',
1334: p_token3_value => l_trxassets_tbl(j).asset_number,
1335: p_token4 => 'ASSET_BOOK',
1336: p_token4_value => l_trxassets_tbl(j).asset_book);
1337: l_update_status := OKC_API.G_RET_STS_ERROR;
1338: END IF;
1339:
1340: EXIT WHEN (j = l_trxassets_tbl.LAST);
1341: j := l_trxassets_tbl.NEXT(j);

Line 1344: IF l_update_status = OKC_API.G_RET_STS_SUCCESS THEN -- trx status updated succesfully to 'ERROR' for all trx for this asset

1340: EXIT WHEN (j = l_trxassets_tbl.LAST);
1341: j := l_trxassets_tbl.NEXT(j);
1342: END LOOP;
1343:
1344: IF l_update_status = OKC_API.G_RET_STS_SUCCESS THEN -- trx status updated succesfully to 'ERROR' for all trx for this asset
1345: COMMIT; -- commit the trx status upadte to ERROR
1346: ELSE -- trx status could not be updated to ERROR for one or more transactions
1347: ROLLBACK to trx_status_update; -- trx status will remain ENTERED (fa trx have already been rolled back)
1348: END IF;

Line 1353: END IF; -- IF l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN

1349: END IF; --IF l_trxassets_tbl.COUNT > 0 THEN
1350: END;
1351:
1352:
1353: END IF; -- IF l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN
1354:
1355:
1356:
1357: END; -- process amortization transactions end

Line 1362: l_transaction_status := OKC_API.G_RET_STS_SUCCESS;

1358:
1359: IF p_salvage_writedown_yn = 'Y' THEN
1360: -- SECHAWLA 06-MAY-04 3578894 : Process SVW transactions separately
1361: BEGIN -- process SVW transactions begin
1362: l_transaction_status := OKC_API.G_RET_STS_SUCCESS;
1363:
1364: -- As of now, this cursor will return only 1 row for a particulat asset. SVW transactions
1365: -- are being created only for corporate book but processed in all books
1366: FOR l_assetsvtrx_rec IN l_assetsvtrx_csr(l_sysdate, l_distinctasset_rec.asset_number) LOOP

Line 1381: OKC_API.set_message( p_app_name => 'OKL',

1377: OPEN l_dealtype_csr(l_assetsvtrx_rec.kle_id);
1378: FETCH l_dealtype_csr INTO l_chr_id, l_deal_type, l_contract_number;
1379: IF l_dealtype_csr%NOTFOUND OR l_deal_type IS NULL OR l_deal_type = OKL_API.G_MISS_CHAR THEN
1380: -- Can not find deal type for asset ASSET_NUMBER.
1381: OKC_API.set_message( p_app_name => 'OKL',
1382: p_msg_name => 'OKL_AM_DEAL_TYPE_NOT_FOUND',
1383: p_token1 => 'ASSET_NUMBER',
1384: p_token1_value => l_assetsvtrx_rec.asset_number);
1385:

Line 1386: l_transaction_status := OKC_API.G_RET_STS_ERROR;

1382: p_msg_name => 'OKL_AM_DEAL_TYPE_NOT_FOUND',
1383: p_token1 => 'ASSET_NUMBER',
1384: p_token1_value => l_assetsvtrx_rec.asset_number);
1385:
1386: l_transaction_status := OKC_API.G_RET_STS_ERROR;
1387: ELSE
1388:
1389: IF l_assetsvtrx_rec.asset_book IS NULL OR l_assetsvtrx_rec.asset_book = OKL_API.G_MISS_CHAR THEN
1390: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER as FIELD is missing.

Line 1391: OKC_API.set_message( p_app_name => 'OKL',

1387: ELSE
1388:
1389: IF l_assetsvtrx_rec.asset_book IS NULL OR l_assetsvtrx_rec.asset_book = OKL_API.G_MISS_CHAR THEN
1390: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER as FIELD is missing.
1391: OKC_API.set_message( p_app_name => 'OKL',
1392: p_msg_name => 'OKL_AM_NO_ASSET_BOOK',
1393: p_token1 => 'TRX_TYPE',
1394: p_token1_value => l_assetsvtrx_rec.TAS_TYPE_MEANING,
1395: p_token2 => 'ASSET_NUMBER',

Line 1400: l_transaction_status := OKC_API.G_RET_STS_ERROR;

1396: p_token2_value => l_assetsvtrx_rec.asset_number,
1397: p_token3 => 'FIELD',
1398: p_token3_value => 'Asset Book');
1399:
1400: l_transaction_status := OKC_API.G_RET_STS_ERROR;
1401: -- SECHAWLA 06-MAY-04 3578894 Added new tas types 'AUD','AUS' to following condition
1402:
1403:
1404:

Line 1408: OKC_API.set_message( p_app_name => 'OKL',

1404:
1405: ELSIF l_assetsvtrx_rec.dnz_asset_id IS NULL OR l_assetsvtrx_rec.dnz_asset_id = OKL_API.G_MISS_NUM THEN
1406: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as Asset ID
1407: -- is missing.
1408: OKC_API.set_message( p_app_name => 'OKL',
1409: p_msg_name => 'OKL_AM_DATA_REQUIRED',
1410: p_token1 => 'TRX_TYPE',
1411: p_token1_value => l_assetsvtrx_rec.TAS_TYPE_MEANING,
1412: p_token2 => 'ASSET_NUMBER',

Line 1419: l_transaction_status := OKC_API.G_RET_STS_ERROR;

1415: p_token3_value => l_assetsvtrx_rec.asset_book,
1416: p_token4 => 'FIELD',
1417: p_token4_value => 'Asset ID');
1418:
1419: l_transaction_status := OKC_API.G_RET_STS_ERROR;
1420:
1421: ELSE
1422:
1423: OPEN l_facostsv_csr(l_assetsvtrx_rec.asset_number, l_assetsvtrx_rec.asset_book);

Line 1431: OKC_API.set_message( p_app_name => 'OKL',

1427: IF l_facostsv_csr%NOTFOUND OR l_fa_cost IS NULL OR l_fa_salvage_value IS NULL THEN
1428: --Can not process TRX_TYPE transaction in Fixed Assets for asset ASSET_NUMBER and book ASSET_BOOK as Cost / Salvage Value
1429: -- is missing.
1430:
1431: OKC_API.set_message( p_app_name => 'OKL',
1432: p_msg_name => 'OKL_AM_DATA_REQUIRED',
1433: p_token1 => 'TRX_TYPE',
1434: p_token1_value => l_assetsvtrx_rec.TAS_TYPE_MEANING,
1435: p_token2 => 'ASSET_NUMBER',

Line 1448: OKC_API.set_message( p_app_name => 'OKL',

1444:
1445:
1446: ELSIF l_assetsvtrx_rec.salvage_value IS NULL OR l_assetsvtrx_rec.salvage_value = OKL_API.G_MISS_NUM THEN
1447: -- Can not process TRX_TYPE transaction for asset ASSET_NUMBER in Fixed Assets as FIELD is missing.
1448: OKC_API.set_message( p_app_name => 'OKL',
1449: p_msg_name => 'OKL_AM_DATA_REQUIRED',
1450: p_token1 => 'TRX_TYPE',
1451: p_token1_value => l_assetsvtrx_rec.TAS_TYPE_MEANING,
1452: p_token2 => 'ASSET_NUMBER',

Line 1460: l_transaction_status := OKC_API.G_RET_STS_ERROR;

1456: p_token4 => 'FIELD',
1457: p_token4_value => 'Salvage Value');
1458:
1459:
1460: l_transaction_status := OKC_API.G_RET_STS_ERROR;
1461: ELSE
1462:
1463: OPEN l_quotes_csr(l_assetsvtrx_rec.kle_id);
1464: FETCH l_quotes_csr INTO l_asset_number;

Line 1471: l_transaction_status := OKC_API.G_RET_STS_ERROR;

1467: OKL_API.set_message( p_app_name => 'OKL',
1468: p_msg_name => 'OKL_AM_SVW_NOT_PROCESSED',
1469: p_token1 => 'ASSET_NUMBER',
1470: p_token1_value => l_asset_number);
1471: l_transaction_status := OKC_API.G_RET_STS_ERROR;
1472:
1473: ELSE
1474:
1475:

Line 1556: p_init_msg_list => OKC_API.G_FALSE,

1552: l_asset_hdr_rec.book_type_code := l_books_tbl(i);
1553:
1554: fa_adjustment_pub.do_adjustment(
1555: p_api_version => p_api_version,
1556: p_init_msg_list => OKC_API.G_FALSE,
1557: p_commit => FND_API.G_FALSE,
1558: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1559: p_calling_fn => NULL,
1560: x_return_status => l_return_status,

Line 1577: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1573: p_group_reclass_options_rec => l_group_reclass_options_rec);
1574:
1575:
1576:
1577: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1578: -- Error processing TRX_TYPE transaction for asset ASSET_NUMBER in book BOOK.
1579: -- Salvage Value Writedown transaction was not processed for this asset in Fixed Assets.
1580: OKC_API.set_message( p_app_name => 'OKL',
1581: p_msg_name => 'OKL_AM_FSC_TRANS_FAILED',

Line 1580: OKC_API.set_message( p_app_name => 'OKL',

1576:
1577: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1578: -- Error processing TRX_TYPE transaction for asset ASSET_NUMBER in book BOOK.
1579: -- Salvage Value Writedown transaction was not processed for this asset in Fixed Assets.
1580: OKC_API.set_message( p_app_name => 'OKL',
1581: p_msg_name => 'OKL_AM_FSC_TRANS_FAILED',
1582: p_token1 => 'TRX_TYPE',
1583: p_token1_value => l_assetsvtrx_rec.TAS_TYPE_MEANING,
1584: p_token2 => 'ASSET_NUMBER',

Line 1607: p_init_msg_list => okc_api.g_false,

1603: l_fxlv_rec.fa_transaction_id := l_trans_rec.transaction_header_id;
1604: l_fxlv_rec.asset_book_type_name := l_books_tbl(i);
1605: --call api
1606: okl_sla_acc_sources_pvt.populate_sources(p_api_version => p_api_version,
1607: p_init_msg_list => okc_api.g_false,
1608: p_fxhv_rec => l_fxhv_rec,
1609: p_fxlv_rec => l_fxlv_rec,
1610: x_return_status => x_return_status,
1611: x_msg_count => x_msg_count,

Line 1614: IF (x_return_status = okc_api.g_ret_sts_unexp_error)

1610: x_return_status => x_return_status,
1611: x_msg_count => x_msg_count,
1612: x_msg_data => x_msg_data);
1613:
1614: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
1615: THEN
1616: RAISE okl_api.g_exception_unexpected_error;
1617: ELSIF (x_return_status = okc_api.g_ret_sts_error)
1618: THEN

Line 1617: ELSIF (x_return_status = okc_api.g_ret_sts_error)

1613:
1614: IF (x_return_status = okc_api.g_ret_sts_unexp_error)
1615: THEN
1616: RAISE okl_api.g_exception_unexpected_error;
1617: ELSIF (x_return_status = okc_api.g_ret_sts_error)
1618: THEN
1619: RAISE okl_api.g_exception_error;
1620: END IF;
1621: --akrangan populate sources cr ends

Line 1642: -- END IF; --IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1638: CLOSE l_facostsv_csr;
1639:
1640: END IF; --IF l_assetsvtrx_rec.asset_book IS NULL...
1641:
1642: -- END IF; --IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1643:
1644: END IF; --IF l_dealtype_csr%NOTFOUND OR l_deal_type IS NULL OR l_deal_type = OKL_API.G_MISS_CHAR THEN
1645: CLOSE l_dealtype_csr;
1646: --------------

Line 1648: IF l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN

1644: END IF; --IF l_dealtype_csr%NOTFOUND OR l_deal_type IS NULL OR l_deal_type = OKL_API.G_MISS_CHAR THEN
1645: CLOSE l_dealtype_csr;
1646: --------------
1647:
1648: IF l_transaction_status = OKC_API.G_RET_STS_SUCCESS THEN
1649: -- update the staus (tsu_code) in okl_trx_assets_v
1650: lp_thpv_rec.id := l_assetsvtrx_rec.id;
1651: lp_thpv_rec.tsu_code := 'PROCESSED';
1652: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(

Line 1654: p_init_msg_list => OKC_API.G_FALSE,

1650: lp_thpv_rec.id := l_assetsvtrx_rec.id;
1651: lp_thpv_rec.tsu_code := 'PROCESSED';
1652: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
1653: p_api_version => p_api_version,
1654: p_init_msg_list => OKC_API.G_FALSE,
1655: x_return_status => l_return_status,
1656: x_msg_count => x_msg_count,
1657: x_msg_data => x_msg_data,
1658: p_thpv_rec => lp_thpv_rec,

Line 1661: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1657: x_msg_data => x_msg_data,
1658: p_thpv_rec => lp_thpv_rec,
1659: x_thpv_rec => lx_thpv_rec);
1660:
1661: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1662: -- Transaction status STATUS could not be updated in OKL for asset ASSET_NUMBER
1663: OKC_API.set_message( p_app_name => 'OKL',
1664: p_msg_name => 'OKL_AM_TRXASSET_UPD_FAILED',
1665: p_token1 => 'TRX_TYPE',

Line 1663: OKC_API.set_message( p_app_name => 'OKL',

1659: x_thpv_rec => lx_thpv_rec);
1660:
1661: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1662: -- Transaction status STATUS could not be updated in OKL for asset ASSET_NUMBER
1663: OKC_API.set_message( p_app_name => 'OKL',
1664: p_msg_name => 'OKL_AM_TRXASSET_UPD_FAILED',
1665: p_token1 => 'TRX_TYPE',
1666: p_token1_value => l_assetsvtrx_rec.TAS_TYPE_MEANING,
1667: p_token2 => 'STATUS',

Line 1676: OKC_API.set_message( p_app_name => 'OKL',

1672: p_token4_value => l_assetsvtrx_rec.asset_book);
1673: ELSE
1674: l_process_count := l_process_count + 1;
1675: -- Asset Details have been updated for asset ASSET_NUMBER in Fixed Assets.
1676: OKC_API.set_message( p_app_name => 'OKL',
1677: --p_msg_name => 'OKL_AM_FA_UPD_DONE',
1678: p_msg_name => 'OKL_AM_SV_FA_UPD_DONE', -- SECHAWLA 06-MAY-04 3578894: Changed msg
1679: p_token1 => 'ASSET_NUMBER',
1680: p_token1_value => l_assetsvtrx_rec.asset_number);

Line 1688: p_init_msg_list => OKC_API.G_FALSE,

1684: lp_thpv_rec.id := l_assetsvtrx_rec.id;
1685: lp_thpv_rec.tsu_code := 'ERROR';
1686: OKL_TRX_ASSETS_PUB.update_trx_ass_h_def(
1687: p_api_version => p_api_version,
1688: p_init_msg_list => OKC_API.G_FALSE,
1689: x_return_status => l_return_status,
1690: x_msg_count => x_msg_count,
1691: x_msg_data => x_msg_data,
1692: p_thpv_rec => lp_thpv_rec,

Line 1695: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1691: x_msg_data => x_msg_data,
1692: p_thpv_rec => lp_thpv_rec,
1693: x_thpv_rec => lx_thpv_rec);
1694:
1695: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1696: -- Transaction status STATUS could not be updated in OKL for asset ASSET_NUMBER
1697: OKC_API.set_message( p_app_name => 'OKL',
1698: p_msg_name => 'OKL_AM_TRXASSET_UPD_FAILED',
1699: p_token1 => 'TRX_TYPE',

Line 1697: OKC_API.set_message( p_app_name => 'OKL',

1693: x_thpv_rec => lx_thpv_rec);
1694:
1695: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1696: -- Transaction status STATUS could not be updated in OKL for asset ASSET_NUMBER
1697: OKC_API.set_message( p_app_name => 'OKL',
1698: p_msg_name => 'OKL_AM_TRXASSET_UPD_FAILED',
1699: p_token1 => 'TRX_TYPE',
1700: p_token1_value => l_assetsvtrx_rec.TAS_TYPE_MEANING,
1701: p_token2 => 'STATUS',

Line 1727: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1723: x_total_count := l_total_count;
1724: x_processed_count := l_process_count;
1725: x_error_count := l_total_count - l_process_count;
1726:
1727: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1728:
1729: EXCEPTION
1730:
1731: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1731: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1727: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1728:
1729: EXCEPTION
1730:
1731: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1732:
1733: IF l_distinctasset_csr%ISOPEN THEN
1734: CLOSE l_distinctasset_csr;
1735: END IF;

Line 1764: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1760: CLOSE l_dealtype_csr;
1761: END IF;
1762:
1763:
1764: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1765: (
1766: l_api_name,
1767: G_PKG_NAME,
1768: 'OKC_API.G_RET_STS_ERROR',

Line 1768: 'OKC_API.G_RET_STS_ERROR',

1764: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1765: (
1766: l_api_name,
1767: G_PKG_NAME,
1768: 'OKC_API.G_RET_STS_ERROR',
1769: x_msg_count,
1770: x_msg_data,
1771: '_PVT'
1772: );

Line 1773: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1769: x_msg_count,
1770: x_msg_data,
1771: '_PVT'
1772: );
1773: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1774:
1775: IF l_distinctasset_csr%ISOPEN THEN
1776: CLOSE l_distinctasset_csr;
1777: END IF;

Line 1806: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1802: IF l_dealtype_csr%ISOPEN THEN
1803: CLOSE l_dealtype_csr;
1804: END IF;
1805:
1806: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1807: (
1808: l_api_name,
1809: G_PKG_NAME,
1810: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1810: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1806: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1807: (
1808: l_api_name,
1809: G_PKG_NAME,
1810: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1811: x_msg_count,
1812: x_msg_data,
1813: '_PVT'
1814: );

Line 1847: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1843: IF l_dealtype_csr%ISOPEN THEN
1844: CLOSE l_dealtype_csr;
1845: END IF;
1846:
1847: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1848: (
1849: l_api_name,
1850: G_PKG_NAME,
1851: 'OTHERS',