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

Line 109: x_return_status := OKC_API.G_RET_STS_SUCCESS;

105: END IF;
106: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
107: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
108: END IF;
109: x_return_status := OKC_API.G_RET_STS_SUCCESS;
110:
111: OPEN rebook_csr(p_rebook_reason_code);
112: FETCH rebook_csr INTO l_dummy;
113: IF rebook_csr%NOTFOUND THEN

Line 128: x_return_status := OKC_API.G_RET_STS_ERROR;

124: G_INVALID_VALUE,
125: 'COL_NAME',
126: 'REBOOK REASON'
127: );
128: x_return_status := OKC_API.G_RET_STS_ERROR;
129:
130: END validate_rebook_reason;
131:
132: ------------------------------------------------------------------------------

Line 184: x_return_status := OKC_API.G_RET_STS_SUCCESS;

180: END IF;
181: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
182: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
183: END IF;
184: x_return_status := OKC_API.G_RET_STS_SUCCESS;
185:
186: OPEN con_header_csr(p_chr_id);
187: FETCH con_header_csr INTO l_currency_code,
188: l_org_id;

Line 271: x_return_status := OKC_API.G_RET_STS_ERROR;

267: IF con_header_csr%ISOPEN THEN
268: CLOSE con_header_csr;
269: END IF;
270:
271: x_return_status := OKC_API.G_RET_STS_ERROR;
272:
273: WHEN OTHERS THEN
274: okl_api.set_message(
275: G_APP_NAME,

Line 282: x_return_status := OKC_API.G_RET_STS_ERROR;

278: SQLCODE,
279: 'OKL_SQLERRM',
280: SQLERRM || ': '||G_PKG_NAME||'.'||l_proc_name
281: );
282: x_return_status := OKC_API.G_RET_STS_ERROR;
283:
284: END populate_transaction_rec;
285:
286: ------------------------------------------------------------------------------

Line 340: x_return_status := OKC_API.G_RET_STS_SUCCESS;

336: IF (G_DEBUG_ENABLED = 'Y') THEN
337: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
338: END IF;
339:
340: x_return_status := OKC_API.G_RET_STS_SUCCESS;
341: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
342: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
343: END IF;
344: -- call START_ACTIVITY to create savepoint, check compatibility

Line 346: x_return_status := OKC_API.START_ACTIVITY(

342: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
343: END IF;
344: -- call START_ACTIVITY to create savepoint, check compatibility
345: -- and initialize message list
346: x_return_status := OKC_API.START_ACTIVITY(
347: p_api_name => l_api_name,
348: p_pkg_name => G_PKG_NAME,
349: p_init_msg_list => p_init_msg_list,
350: l_api_version => l_api_version,

Line 356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

352: p_api_type => G_API_TYPE,
353: x_return_status => x_return_status);
354:
355: -- check if activity started successfully
356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
359: RAISE OKC_API.G_EXCEPTION_ERROR;
360: END IF;

Line 357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

353: x_return_status => x_return_status);
354:
355: -- check if activity started successfully
356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
359: RAISE OKC_API.G_EXCEPTION_ERROR;
360: END IF;
361:

Line 358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

354:
355: -- check if activity started successfully
356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
359: RAISE OKC_API.G_EXCEPTION_ERROR;
360: END IF;
361:
362: FOR trx_rec IN trx_csr(p_chr_id)

Line 359: RAISE OKC_API.G_EXCEPTION_ERROR;

355: -- check if activity started successfully
356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
359: RAISE OKC_API.G_EXCEPTION_ERROR;
360: END IF;
361:
362: FOR trx_rec IN trx_csr(p_chr_id)
363: LOOP

Line 378: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

374: p_tcnv_rec => l_tcnv_rec,
375: x_tcnv_rec => lx_tcnv_rec
376: );
377:
378: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
379: RAISE Okc_Api.G_EXCEPTION_ERROR;
380: END IF;
381:
382: IF (trx_rec.representation_type IS NULL --upgrade case, only 1 record will exist

Line 379: RAISE Okc_Api.G_EXCEPTION_ERROR;

375: x_tcnv_rec => lx_tcnv_rec
376: );
377:
378: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
379: RAISE Okc_Api.G_EXCEPTION_ERROR;
380: END IF;
381:
382: IF (trx_rec.representation_type IS NULL --upgrade case, only 1 record will exist
383: OR

Line 396: WHEN OKC_API.G_EXCEPTION_ERROR THEN

392: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
393: x_msg_data => x_msg_data);
394:
395: EXCEPTION
396: WHEN OKC_API.G_EXCEPTION_ERROR THEN
397: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
398: p_api_name => l_api_name,
399: p_pkg_name => G_PKG_NAME,
400: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 397: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

393: x_msg_data => x_msg_data);
394:
395: EXCEPTION
396: WHEN OKC_API.G_EXCEPTION_ERROR THEN
397: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
398: p_api_name => l_api_name,
399: p_pkg_name => G_PKG_NAME,
400: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
401: x_msg_count => x_msg_count,

Line 400: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

396: WHEN OKC_API.G_EXCEPTION_ERROR THEN
397: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
398: p_api_name => l_api_name,
399: p_pkg_name => G_PKG_NAME,
400: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
401: x_msg_count => x_msg_count,
402: x_msg_data => x_msg_data,
403: p_api_type => G_API_TYPE);
404:

Line 405: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

401: x_msg_count => x_msg_count,
402: x_msg_data => x_msg_data,
403: p_api_type => G_API_TYPE);
404:
405: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
406: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
407: p_api_name => l_api_name,
408: p_pkg_name => G_PKG_NAME,
409: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 406: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

402: x_msg_data => x_msg_data,
403: p_api_type => G_API_TYPE);
404:
405: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
406: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
407: p_api_name => l_api_name,
408: p_pkg_name => G_PKG_NAME,
409: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
410: x_msg_count => x_msg_count,

Line 409: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

405: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
406: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
407: p_api_name => l_api_name,
408: p_pkg_name => G_PKG_NAME,
409: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
410: x_msg_count => x_msg_count,
411: x_msg_data => x_msg_data,
412: p_api_type => G_API_TYPE);
413:

Line 415: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

411: x_msg_data => x_msg_data,
412: p_api_type => G_API_TYPE);
413:
414: WHEN OTHERS THEN
415: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
416: p_api_name => l_api_name,
417: p_pkg_name => G_PKG_NAME,
418: p_exc_name => 'OTHERS',
419: x_msg_count => x_msg_count,

Line 462: p_init_msg_list => OKC_API.G_FALSE,

458: END IF;
459:
460: okl_securitization_pvt.check_khr_securitized(
461: p_api_version => 1.0,
462: p_init_msg_list => OKC_API.G_FALSE,
463: x_return_status => x_return_status,
464: x_msg_count => x_msg_count,
465: x_msg_data => x_msg_data,
466: p_khr_id => p_chr_id,

Line 486: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

482: RETURN;
483:
484: EXCEPTION
485: WHEN OTHERS THEN
486: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
487: p_api_name => l_api_name,
488: p_pkg_name => G_PKG_NAME,
489: p_exc_name => 'OTHERS',
490: x_msg_count => x_msg_count,

Line 563: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

559: RETURN;
560:
561: EXCEPTION
562: WHEN OTHERS THEN
563: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
564: p_api_name => l_api_name,
565: p_pkg_name => G_PKG_NAME,
566: p_exc_name => 'OTHERS',
567: x_msg_count => x_msg_count,

Line 685: x_return_status := OKC_API.G_RET_STS_SUCCESS;

681:
682:
683: BEGIN -- main process begins here
684:
685: x_return_status := OKC_API.G_RET_STS_SUCCESS;
686: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
687: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
688: END IF;
689: -- call START_ACTIVITY to create savepoint, check compatibility

Line 691: x_return_status := OKC_API.START_ACTIVITY(

687: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
688: END IF;
689: -- call START_ACTIVITY to create savepoint, check compatibility
690: -- and initialize message list
691: x_return_status := OKC_API.START_ACTIVITY(
692: p_api_name => l_api_name,
693: p_pkg_name => G_PKG_NAME,
694: p_init_msg_list => p_init_msg_list,
695: l_api_version => l_api_version,

Line 701: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

697: p_api_type => G_API_TYPE,
698: x_return_status => x_return_status);
699:
700: -- check if activity started successfully
701: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
702: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
703: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
704: RAISE OKC_API.G_EXCEPTION_ERROR;
705: END IF;

Line 702: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

698: x_return_status => x_return_status);
699:
700: -- check if activity started successfully
701: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
702: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
703: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
704: RAISE OKC_API.G_EXCEPTION_ERROR;
705: END IF;
706:

Line 703: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

699:
700: -- check if activity started successfully
701: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
702: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
703: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
704: RAISE OKC_API.G_EXCEPTION_ERROR;
705: END IF;
706:
707: IF (p_trx_type NOT IN ('REBOOK','SPLIT')) THEN

Line 704: RAISE OKC_API.G_EXCEPTION_ERROR;

700: -- check if activity started successfully
701: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
702: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
703: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
704: RAISE OKC_API.G_EXCEPTION_ERROR;
705: END IF;
706:
707: IF (p_trx_type NOT IN ('REBOOK','SPLIT')) THEN
708: okl_api.set_message(

Line 714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

710: G_LLA_INVALID_TRX_TYPE,
711: 'TRX_TYPE',
712: p_trx_type
713: );
714: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
715: END IF;
716:
717: IF (p_trx_type = 'SPLIT') THEN
718: --

Line 732: RAISE OKC_API.G_EXCEPTION_ERROR;

728: p_trx_date => p_trx_date
729: );
730:
731: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
732: RAISE OKC_API.G_EXCEPTION_ERROR;
733: END IF;
734: END IF;
735:
736: IF (p_trx_type = 'REBOOK') THEN

Line 757: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

753: 'CONTRACT_NUMBER',
754: l_contract_number
755: );
756:
757: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
758: END IF;
759: --akrangan end
760: validate_rebook_reason(
761: x_return_status => x_return_status,

Line 767: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

763: x_msg_data => x_msg_data,
764: p_rebook_reason_code => p_reason_code
765: );
766:
767: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
769: END IF;
770: END IF;
771:

Line 768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

764: p_rebook_reason_code => p_reason_code
765: );
766:
767: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
769: END IF;
770: END IF;
771:
772: --

Line 780: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

776: okl_api.set_message(
777: G_APP_NAME,
778: G_LLA_MISSING_TRX_DATE
779: );
780: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
781: END IF;
782:
783: --
784: -- Transaction date should be within contract effectivity

Line 809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

805: l_con_start_date,
806: 'END_DATE',
807: l_con_end_date
808: );
809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
810: END IF;
811:
812: /* Bug 4766555 : Code commented here and moved to
813: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - Start

Line 824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

820: , x_msg_count => x_msg_count
821: , x_msg_data => x_msg_data
822: , p_chr_id => p_chr_id
823: , p_rebook_date => p_trx_date);
824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
827: RAISE OKC_API.G_EXCEPTION_ERROR;
828: END IF;

Line 825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

821: , x_msg_data => x_msg_data
822: , p_chr_id => p_chr_id
823: , p_rebook_date => p_trx_date);
824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
827: RAISE OKC_API.G_EXCEPTION_ERROR;
828: END IF;
829: END IF; -- end of check for rebook transaction

Line 826: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

822: , p_chr_id => p_chr_id
823: , p_rebook_date => p_trx_date);
824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
827: RAISE OKC_API.G_EXCEPTION_ERROR;
828: END IF;
829: END IF; -- end of check for rebook transaction
830: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - End

Line 827: RAISE OKC_API.G_EXCEPTION_ERROR;

823: , p_rebook_date => p_trx_date);
824: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
827: RAISE OKC_API.G_EXCEPTION_ERROR;
828: END IF;
829: END IF; -- end of check for rebook transaction
830: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - End
831: */

Line 846: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

842: p_trx_type => p_trx_type,
843: x_tcnv_rec => l_tcnv_rec
844: );
845:
846: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
847: RAISE OKC_API.G_EXCEPTION_ERROR;
848: END IF;
849:
850: -- Create Transaction Header only

Line 847: RAISE OKC_API.G_EXCEPTION_ERROR;

843: x_tcnv_rec => l_tcnv_rec
844: );
845:
846: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
847: RAISE OKC_API.G_EXCEPTION_ERROR;
848: END IF;
849:
850: -- Create Transaction Header only
851: okl_trx_contracts_pub.create_trx_contracts(

Line 861: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

857: p_tcnv_rec => l_tcnv_rec,
858: x_tcnv_rec => l_out_tcnv_rec
859: );
860:
861: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
862: RAISE OKC_API.G_EXCEPTION_ERROR;
863: END IF;
864:
865: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - Start

Line 862: RAISE OKC_API.G_EXCEPTION_ERROR;

858: x_tcnv_rec => l_out_tcnv_rec
859: );
860:
861: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
862: RAISE OKC_API.G_EXCEPTION_ERROR;
863: END IF;
864:
865: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - Start
866: -- apaul 4766555. Code moved here.

Line 877: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

873: , x_msg_count => x_msg_count
874: , x_msg_data => x_msg_data
875: , p_chr_id => p_chr_id
876: , p_rebook_date => p_trx_date);
877: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_ERROR;
881: END IF;

Line 878: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

874: , x_msg_data => x_msg_data
875: , p_chr_id => p_chr_id
876: , p_rebook_date => p_trx_date);
877: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_ERROR;
881: END IF;
882: END IF; -- end of check for rebook transaction

Line 879: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

875: , p_chr_id => p_chr_id
876: , p_rebook_date => p_trx_date);
877: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_ERROR;
881: END IF;
882: END IF; -- end of check for rebook transaction
883: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - End

Line 880: RAISE OKC_API.G_EXCEPTION_ERROR;

876: , p_rebook_date => p_trx_date);
877: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_ERROR;
881: END IF;
882: END IF; -- end of check for rebook transaction
883: -- smadhava Bug# 4542290 - 24-Aug-2005 - Added - End
884:

Line 908: WHEN OKC_API.G_EXCEPTION_ERROR THEN

904: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
905: x_msg_data => x_msg_data);
906:
907: EXCEPTION
908: WHEN OKC_API.G_EXCEPTION_ERROR THEN
909: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
910: p_api_name => l_api_name,
911: p_pkg_name => G_PKG_NAME,
912: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 909: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

905: x_msg_data => x_msg_data);
906:
907: EXCEPTION
908: WHEN OKC_API.G_EXCEPTION_ERROR THEN
909: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
910: p_api_name => l_api_name,
911: p_pkg_name => G_PKG_NAME,
912: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
913: x_msg_count => x_msg_count,

Line 912: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

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

Line 917: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

913: x_msg_count => x_msg_count,
914: x_msg_data => x_msg_data,
915: p_api_type => G_API_TYPE);
916:
917: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
918: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
919: p_api_name => l_api_name,
920: p_pkg_name => G_PKG_NAME,
921: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 918: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

914: x_msg_data => x_msg_data,
915: p_api_type => G_API_TYPE);
916:
917: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
918: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
919: p_api_name => l_api_name,
920: p_pkg_name => G_PKG_NAME,
921: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
922: x_msg_count => x_msg_count,

Line 921: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 927: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

923: x_msg_data => x_msg_data,
924: p_api_type => G_API_TYPE);
925:
926: WHEN OTHERS THEN
927: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
928: p_api_name => l_api_name,
929: p_pkg_name => G_PKG_NAME,
930: p_exc_name => 'OTHERS',
931: x_msg_count => x_msg_count,

Line 990: x_return_status := OKC_API.G_RET_STS_SUCCESS;

986: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
987: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'BEFORE call ....');
988: END IF;
989:
990: x_return_status := OKC_API.G_RET_STS_SUCCESS;
991: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
992: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
993: END IF;
994: -- call START_ACTIVITY to create savepoint, check compatibility

Line 996: x_return_status := OKC_API.START_ACTIVITY(

992: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
993: END IF;
994: -- call START_ACTIVITY to create savepoint, check compatibility
995: -- and initialize message list
996: x_return_status := OKC_API.START_ACTIVITY(
997: p_api_name => l_api_name,
998: p_pkg_name => G_PKG_NAME,
999: p_init_msg_list => p_init_msg_list,
1000: l_api_version => l_api_version,

Line 1006: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1002: p_api_type => G_API_TYPE,
1003: x_return_status => x_return_status);
1004:
1005: -- check if activity started successfully
1006: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1007: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1008: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1009: RAISE OKC_API.G_EXCEPTION_ERROR;
1010: END IF;

Line 1007: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1003: x_return_status => x_return_status);
1004:
1005: -- check if activity started successfully
1006: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1007: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1008: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1009: RAISE OKC_API.G_EXCEPTION_ERROR;
1010: END IF;
1011:

Line 1008: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1004:
1005: -- check if activity started successfully
1006: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1007: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1008: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1009: RAISE OKC_API.G_EXCEPTION_ERROR;
1010: END IF;
1011:
1012: LOOP

Line 1009: RAISE OKC_API.G_EXCEPTION_ERROR;

1005: -- check if activity started successfully
1006: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1007: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1008: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1009: RAISE OKC_API.G_EXCEPTION_ERROR;
1010: END IF;
1011:
1012: LOOP
1013: i := i + 1;

Line 1033: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1029: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1030: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Trx UPDATE status: '|| x_return_status);
1031: END IF;
1032:
1033: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1034: RAISE OKC_API.G_EXCEPTION_ERROR;
1035: END IF;
1036:
1037: --akrangan ebtax rebook impacts starts

Line 1034: RAISE OKC_API.G_EXCEPTION_ERROR;

1030: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Trx UPDATE status: '|| x_return_status);
1031: END IF;
1032:
1033: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1034: RAISE OKC_API.G_EXCEPTION_ERROR;
1035: END IF;
1036:
1037: --akrangan ebtax rebook impacts starts
1038: IF ( p_source_trx_id IS NULL ) AND ( p_source_trx_name IS NULL ) THEN -- called from rebook abandon UI

Line 1075: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1071: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1072: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Cancel Pre-Rebook transaction status: '|| x_return_status);
1073: END IF;
1074:
1075: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1076: RAISE Okc_Api.G_EXCEPTION_ERROR;
1077: END IF;
1078: END IF;
1079: ELSE

Line 1076: RAISE Okc_Api.G_EXCEPTION_ERROR;

1072: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Cancel Pre-Rebook transaction status: '|| x_return_status);
1073: END IF;
1074:
1075: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1076: RAISE Okc_Api.G_EXCEPTION_ERROR;
1077: END IF;
1078: END IF;
1079: ELSE
1080: -- p_source_trx_id IS NULL and p_source_trx_name IS NOT NULL

Line 1103: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1099: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Canel Document Tax status: '|| x_return_status);
1101: END IF;
1102:
1103: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1104: RAISE OKC_API.G_EXCEPTION_ERROR;
1105: END IF;
1106: END IF;
1107: --akrangan ebtax rebook impacts ends

Line 1104: RAISE OKC_API.G_EXCEPTION_ERROR;

1100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Canel Document Tax status: '|| x_return_status);
1101: END IF;
1102:
1103: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1104: RAISE OKC_API.G_EXCEPTION_ERROR;
1105: END IF;
1106: END IF;
1107: --akrangan ebtax rebook impacts ends
1108:

Line 1123: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1119: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1120: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Contract Header UPDATE status: '|| x_return_status);
1121: END IF;
1122:
1123: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1124: RAISE OKC_API.G_EXCEPTION_ERROR;
1125: END IF;
1126:
1127: okl_contract_status_pub.cascade_lease_status(

Line 1124: RAISE OKC_API.G_EXCEPTION_ERROR;

1120: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Contract Header UPDATE status: '|| x_return_status);
1121: END IF;
1122:
1123: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1124: RAISE OKC_API.G_EXCEPTION_ERROR;
1125: END IF;
1126:
1127: okl_contract_status_pub.cascade_lease_status(
1128: p_api_version => l_api_version,

Line 1139: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1135: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1136: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Contract Line UPDATE status: '|| x_return_status);
1137: END IF;
1138:
1139: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142:
1143:

Line 1140: RAISE OKC_API.G_EXCEPTION_ERROR;

1136: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Contract Line UPDATE status: '|| x_return_status);
1137: END IF;
1138:
1139: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1140: RAISE OKC_API.G_EXCEPTION_ERROR;
1141: END IF;
1142:
1143:
1144: EXIT WHEN (i >= l_rev_tbl.last);

Line 1152: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1148: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1149: x_msg_data => x_msg_data);
1150:
1151: EXCEPTION
1152: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1153: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1154: p_api_name => l_api_name,
1155: p_pkg_name => G_PKG_NAME,
1156: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1153: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1149: x_msg_data => x_msg_data);
1150:
1151: EXCEPTION
1152: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1153: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1154: p_api_name => l_api_name,
1155: p_pkg_name => G_PKG_NAME,
1156: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1157: x_msg_count => x_msg_count,

Line 1156: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1152: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1153: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1154: p_api_name => l_api_name,
1155: p_pkg_name => G_PKG_NAME,
1156: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1157: x_msg_count => x_msg_count,
1158: x_msg_data => x_msg_data,
1159: p_api_type => G_API_TYPE);
1160:

Line 1161: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1157: x_msg_count => x_msg_count,
1158: x_msg_data => x_msg_data,
1159: p_api_type => G_API_TYPE);
1160:
1161: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1162: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1163: p_api_name => l_api_name,
1164: p_pkg_name => G_PKG_NAME,
1165: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1162: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1158: x_msg_data => x_msg_data,
1159: p_api_type => G_API_TYPE);
1160:
1161: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1162: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1163: p_api_name => l_api_name,
1164: p_pkg_name => G_PKG_NAME,
1165: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1166: x_msg_count => x_msg_count,

Line 1165: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1161: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1162: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1163: p_api_name => l_api_name,
1164: p_pkg_name => G_PKG_NAME,
1165: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1166: x_msg_count => x_msg_count,
1167: x_msg_data => x_msg_data,
1168: p_api_type => G_API_TYPE);
1169:

Line 1171: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1167: x_msg_data => x_msg_data,
1168: p_api_type => G_API_TYPE);
1169:
1170: WHEN OTHERS THEN
1171: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1172: p_api_name => l_api_name,
1173: p_pkg_name => G_PKG_NAME,
1174: p_exc_name => 'OTHERS',
1175: x_msg_count => x_msg_count,

Line 1233: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1229: IF (G_DEBUG_ENABLED = 'Y') THEN
1230: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1231: END IF;
1232:
1233: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1234: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1235: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1236: END IF;
1237: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1239: x_return_status := OKC_API.START_ACTIVITY(

1235: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1236: END IF;
1237: -- call START_ACTIVITY to create savepoint, check compatibility
1238: -- and initialize message list
1239: x_return_status := OKC_API.START_ACTIVITY(
1240: p_api_name => l_api_name,
1241: p_pkg_name => G_PKG_NAME,
1242: p_init_msg_list => p_init_msg_list,
1243: l_api_version => l_api_version,

Line 1249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1245: p_api_type => G_API_TYPE,
1246: x_return_status => x_return_status);
1247:
1248: -- check if activity started successfully
1249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1252: RAISE OKC_API.G_EXCEPTION_ERROR;
1253: END IF;

Line 1250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1246: x_return_status => x_return_status);
1247:
1248: -- check if activity started successfully
1249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1252: RAISE OKC_API.G_EXCEPTION_ERROR;
1253: END IF;
1254:

Line 1251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1247:
1248: -- check if activity started successfully
1249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1252: RAISE OKC_API.G_EXCEPTION_ERROR;
1253: END IF;
1254:
1255: l_tcnv_rec := NULL;

Line 1252: RAISE OKC_API.G_EXCEPTION_ERROR;

1248: -- check if activity started successfully
1249: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1250: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1251: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1252: RAISE OKC_API.G_EXCEPTION_ERROR;
1253: END IF;
1254:
1255: l_tcnv_rec := NULL;
1256: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1263: okl_api.set_message(
1264: G_APP_NAME,
1265: G_LLA_MISSING_TRX_DATE
1266: );
1267: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1268: END IF;
1269:
1270: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1271: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Afer DATE CHECK');

Line 1335: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1331: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');
1333: END IF;
1334:
1335: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1336: RAISE OKC_API.G_EXCEPTION_ERROR;
1337: END IF;
1338:
1339: x_tcnv_rec := l_out_tcnv_rec;

Line 1336: RAISE OKC_API.G_EXCEPTION_ERROR;

1332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');
1333: END IF;
1334:
1335: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1336: RAISE OKC_API.G_EXCEPTION_ERROR;
1337: END IF;
1338:
1339: x_tcnv_rec := l_out_tcnv_rec;
1340:

Line 1357: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1353: CLOSE try_csr;
1354: END IF;
1355: x_return_status := OKL_API.G_RET_STS_ERROR;
1356:
1357: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1358: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1359: p_api_name => l_api_name,
1360: p_pkg_name => G_PKG_NAME,
1361: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1358: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1354: END IF;
1355: x_return_status := OKL_API.G_RET_STS_ERROR;
1356:
1357: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1358: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1359: p_api_name => l_api_name,
1360: p_pkg_name => G_PKG_NAME,
1361: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1362: x_msg_count => x_msg_count,

Line 1361: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1357: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1358: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1359: p_api_name => l_api_name,
1360: p_pkg_name => G_PKG_NAME,
1361: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1362: x_msg_count => x_msg_count,
1363: x_msg_data => x_msg_data,
1364: p_api_type => G_API_TYPE);
1365:

Line 1366: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1362: x_msg_count => x_msg_count,
1363: x_msg_data => x_msg_data,
1364: p_api_type => G_API_TYPE);
1365:
1366: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1367: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1368: p_api_name => l_api_name,
1369: p_pkg_name => G_PKG_NAME,
1370: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1367: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1363: x_msg_data => x_msg_data,
1364: p_api_type => G_API_TYPE);
1365:
1366: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1367: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1368: p_api_name => l_api_name,
1369: p_pkg_name => G_PKG_NAME,
1370: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1371: x_msg_count => x_msg_count,

Line 1370: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1366: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1367: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1368: p_api_name => l_api_name,
1369: p_pkg_name => G_PKG_NAME,
1370: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1371: x_msg_count => x_msg_count,
1372: x_msg_data => x_msg_data,
1373: p_api_type => G_API_TYPE);
1374:

Line 1376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1372: x_msg_data => x_msg_data,
1373: p_api_type => G_API_TYPE);
1374:
1375: WHEN OTHERS THEN
1376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1377: p_api_name => l_api_name,
1378: p_pkg_name => G_PKG_NAME,
1379: p_exc_name => 'OTHERS',
1380: x_msg_count => x_msg_count,

Line 1438: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1434: IF (G_DEBUG_ENABLED = 'Y') THEN
1435: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1436: END IF;
1437:
1438: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1439: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1440: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1441: END IF;
1442: -- call START_ACTIVITY to create savepoint, check compatibility

Line 1444: x_return_status := OKC_API.START_ACTIVITY(

1440: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1441: END IF;
1442: -- call START_ACTIVITY to create savepoint, check compatibility
1443: -- and initialize message list
1444: x_return_status := OKC_API.START_ACTIVITY(
1445: p_api_name => l_api_name,
1446: p_pkg_name => G_PKG_NAME,
1447: p_init_msg_list => p_init_msg_list,
1448: l_api_version => l_api_version,

Line 1454: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1450: p_api_type => G_API_TYPE,
1451: x_return_status => x_return_status);
1452:
1453: -- check if activity started successfully
1454: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1456: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1457: RAISE OKC_API.G_EXCEPTION_ERROR;
1458: END IF;

Line 1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1451: x_return_status => x_return_status);
1452:
1453: -- check if activity started successfully
1454: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1456: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1457: RAISE OKC_API.G_EXCEPTION_ERROR;
1458: END IF;
1459:

Line 1456: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1452:
1453: -- check if activity started successfully
1454: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1456: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1457: RAISE OKC_API.G_EXCEPTION_ERROR;
1458: END IF;
1459:
1460: l_tcnv_rec := NULL;

Line 1457: RAISE OKC_API.G_EXCEPTION_ERROR;

1453: -- check if activity started successfully
1454: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1456: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1457: RAISE OKC_API.G_EXCEPTION_ERROR;
1458: END IF;
1459:
1460: l_tcnv_rec := NULL;
1461: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1468: okl_api.set_message(
1469: G_APP_NAME,
1470: G_LLA_MISSING_TRX_DATE
1471: );
1472: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1473: END IF;
1474:
1475: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1476: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Afer DATE CHECK');

Line 1541: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1537: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');
1539: END IF;
1540:
1541: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1542: RAISE OKC_API.G_EXCEPTION_ERROR;
1543: END IF;
1544:
1545: x_tcnv_rec := l_out_tcnv_rec;

Line 1542: RAISE OKC_API.G_EXCEPTION_ERROR;

1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER calling okl_trx_contracts_pub.create_trx_contracts');
1539: END IF;
1540:
1541: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1542: RAISE OKC_API.G_EXCEPTION_ERROR;
1543: END IF;
1544:
1545: x_tcnv_rec := l_out_tcnv_rec;
1546:

Line 1563: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1559: CLOSE try_csr;
1560: END IF;
1561: x_return_status := OKL_API.G_RET_STS_ERROR;
1562:
1563: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1565: p_api_name => l_api_name,
1566: p_pkg_name => G_PKG_NAME,
1567: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1560: END IF;
1561: x_return_status := OKL_API.G_RET_STS_ERROR;
1562:
1563: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1565: p_api_name => l_api_name,
1566: p_pkg_name => G_PKG_NAME,
1567: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1568: x_msg_count => x_msg_count,

Line 1567: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1563: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1564: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1565: p_api_name => l_api_name,
1566: p_pkg_name => G_PKG_NAME,
1567: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1568: x_msg_count => x_msg_count,
1569: x_msg_data => x_msg_data,
1570: p_api_type => G_API_TYPE);
1571:

Line 1572: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1568: x_msg_count => x_msg_count,
1569: x_msg_data => x_msg_data,
1570: p_api_type => G_API_TYPE);
1571:
1572: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1573: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1574: p_api_name => l_api_name,
1575: p_pkg_name => G_PKG_NAME,
1576: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1573: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1569: x_msg_data => x_msg_data,
1570: p_api_type => G_API_TYPE);
1571:
1572: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1573: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1574: p_api_name => l_api_name,
1575: p_pkg_name => G_PKG_NAME,
1576: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1577: x_msg_count => x_msg_count,

Line 1576: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1572: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1573: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1574: p_api_name => l_api_name,
1575: p_pkg_name => G_PKG_NAME,
1576: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1577: x_msg_count => x_msg_count,
1578: x_msg_data => x_msg_data,
1579: p_api_type => G_API_TYPE);
1580:

Line 1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1578: x_msg_data => x_msg_data,
1579: p_api_type => G_API_TYPE);
1580:
1581: WHEN OTHERS THEN
1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1583: p_api_name => l_api_name,
1584: p_pkg_name => G_PKG_NAME,
1585: p_exc_name => 'OTHERS',
1586: x_msg_count => x_msg_count,