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

Line 191: l_return_status := OKL_API.G_RET_STS_SUCCESS;

187: AND lse_id = 48;
188: l_fee_name OKL_STRM_TYPE_TL.NAME%TYPE;
189:
190: BEGIN
191: l_return_status := OKL_API.G_RET_STS_SUCCESS;
192: l_debug_enabled := okl_debug_pub.check_log_enabled;
193:
194: l_last_updated_by := FND_GLOBAL.USER_ID;
195: l_last_update_date := TRUNC(SYSDATE);

Line 210: l_return_status := okl_api.start_activity(p_api_name => l_api_name

206: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
207: ,fnd_log.level_statement);
208: -- call START_ACTIVITY to create savepoint, check compatibility
209: -- and initialize message list
210: l_return_status := okl_api.start_activity(p_api_name => l_api_name
211: ,p_pkg_name => G_PKG_NAME
212: ,p_init_msg_list => p_init_msg_list
213: ,p_api_version => p_api_version
214: ,l_api_version => l_api_version

Line 219: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

215: ,p_api_type => G_API_TYPE
216: ,x_return_status => l_return_status);
217: -- check if activity started successfully
218:
219: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
220: RAISE okl_api.g_exception_unexpected_error;
221: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
222: RAISE okl_api.g_exception_error;
223: END IF;

Line 220: RAISE okl_api.g_exception_unexpected_error;

216: ,x_return_status => l_return_status);
217: -- check if activity started successfully
218:
219: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
220: RAISE okl_api.g_exception_unexpected_error;
221: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
222: RAISE okl_api.g_exception_error;
223: END IF;
224:

Line 221: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

217: -- check if activity started successfully
218:
219: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
220: RAISE okl_api.g_exception_unexpected_error;
221: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
222: RAISE okl_api.g_exception_error;
223: END IF;
224:
225: --Update OKL_TAX_ATTR_DEFINITIONS for references of Vendor Site

Line 222: RAISE okl_api.g_exception_error;

218:
219: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
220: RAISE okl_api.g_exception_unexpected_error;
221: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
222: RAISE okl_api.g_exception_error;
223: END IF;
224:
225: --Update OKL_TAX_ATTR_DEFINITIONS for references of Vendor Site
226: UPDATE OKL_TAX_ATTR_DEFINITIONS

Line 523: OKL_API.SET_MESSAGE(

519: OPEN fee_name_csr(chk_vendor_chr_ln_rec.cle_id);
520: FETCH fee_name_csr INTO l_fee_name;
521: CLOSE fee_name_csr;
522: --Set the Error
523: OKL_API.SET_MESSAGE(
524: p_app_name => G_APP_NAME,
525: p_msg_name => 'OKL_VM_PASSTHROUGH_LINE_ERROR',
526: p_token1 => 'LINE',
527: p_token1_value => l_fee_name,

Line 531: l_return_status := OKL_API.G_RET_STS_ERROR;

527: p_token1_value => l_fee_name,
528: p_token2 => 'CONTRACT',
529: p_token2_value => chk_vendor_chr_ln_rec.contract_number);
530:
531: l_return_status := OKL_API.G_RET_STS_ERROR;
532: RAISE OKL_API.G_EXCEPTION_ERROR;
533: ELSE
534: --If there is no passthrough setup which uses both the vendors at line level
535: --then remove the party role using source vendor for the given line.

Line 532: RAISE OKL_API.G_EXCEPTION_ERROR;

528: p_token2 => 'CONTRACT',
529: p_token2_value => chk_vendor_chr_ln_rec.contract_number);
530:
531: l_return_status := OKL_API.G_RET_STS_ERROR;
532: RAISE OKL_API.G_EXCEPTION_ERROR;
533: ELSE
534: --If there is no passthrough setup which uses both the vendors at line level
535: --then remove the party role using source vendor for the given line.
536: l_kplv_rec.id := party_role_dtls_ln_rec.CPRS_CPL_ID;

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

569: ,L_MODULE || ' Result of OKL_KPL_PVT.DELETE_ROW'
570: ,'l_return_status ' || l_return_status);
571: END IF; -- end of statement level debug
572:
573: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;

Line 574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

570: ,'l_return_status ' || l_return_status);
571: END IF; -- end of statement level debug
572:
573: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;
578:

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

571: END IF; -- end of statement level debug
572:
573: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;
578:
579: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)

Line 576: RAISE OKL_API.G_EXCEPTION_ERROR;

572:
573: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;
578:
579: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)
580: THEN

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

609: ,L_MODULE || ' Result of OKC_CONTRACT_PARTY_PVT.DELETE_K_PARTY_ROLE'
610: ,'l_return_status ' || l_return_status);
611: END IF; -- end of statement level debug
612:
613: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
616: RAISE OKL_API.G_EXCEPTION_ERROR;
617: END IF;

Line 614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

610: ,'l_return_status ' || l_return_status);
611: END IF; -- end of statement level debug
612:
613: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
616: RAISE OKL_API.G_EXCEPTION_ERROR;
617: END IF;
618: END IF;

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

611: END IF; -- end of statement level debug
612:
613: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
616: RAISE OKL_API.G_EXCEPTION_ERROR;
617: END IF;
618: END IF;
619: CLOSE chk_passthrough_csr;

Line 616: RAISE OKL_API.G_EXCEPTION_ERROR;

612:
613: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
614: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
616: RAISE OKL_API.G_EXCEPTION_ERROR;
617: END IF;
618: END IF;
619: CLOSE chk_passthrough_csr;
620: END LOOP;

Line 664: OKL_API.SET_MESSAGE(

660: THEN
661: --If both the vendors are used for Passthrough setup then set the message
662: --and raise the error.
663: --Set the Error
664: OKL_API.SET_MESSAGE(
665: p_app_name => G_APP_NAME,
666: p_msg_name => 'OKL_VM_PASSTHROUGH_HDR_ERROR',
667: p_token1 => 'CONTRACT',
668: p_token1_value => chk_vendor_chr_rec.contract_number);

Line 670: l_return_status := OKL_API.G_RET_STS_ERROR;

666: p_msg_name => 'OKL_VM_PASSTHROUGH_HDR_ERROR',
667: p_token1 => 'CONTRACT',
668: p_token1_value => chk_vendor_chr_rec.contract_number);
669:
670: l_return_status := OKL_API.G_RET_STS_ERROR;
671: RAISE OKL_API.G_EXCEPTION_ERROR;
672: ELSE
673: --If there is no passthrough setup which uses both the vendors at
674: --contract level then remove the party role for source vendor

Line 671: RAISE OKL_API.G_EXCEPTION_ERROR;

667: p_token1 => 'CONTRACT',
668: p_token1_value => chk_vendor_chr_rec.contract_number);
669:
670: l_return_status := OKL_API.G_RET_STS_ERROR;
671: RAISE OKL_API.G_EXCEPTION_ERROR;
672: ELSE
673: --If there is no passthrough setup which uses both the vendors at
674: --contract level then remove the party role for source vendor
675: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)

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

705: ,L_MODULE || ' Result of OKL_JTOT_CONTACT_EXTRACT_PUB.DELETE_PARTY'
706: ,'l_return_status ' || l_return_status);
707: END IF; -- end of statement level debug
708:
709: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
711: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
712: RAISE OKL_API.G_EXCEPTION_ERROR;
713: END IF;

Line 710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

706: ,'l_return_status ' || l_return_status);
707: END IF; -- end of statement level debug
708:
709: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
711: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
712: RAISE OKL_API.G_EXCEPTION_ERROR;
713: END IF;
714: END IF;

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

707: END IF; -- end of statement level debug
708:
709: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
711: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
712: RAISE OKL_API.G_EXCEPTION_ERROR;
713: END IF;
714: END IF;
715: CLOSE chk_passthrough_csr;

Line 712: RAISE OKL_API.G_EXCEPTION_ERROR;

708:
709: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
711: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
712: RAISE OKL_API.G_EXCEPTION_ERROR;
713: END IF;
714: END IF;
715: CLOSE chk_passthrough_csr;
716: END LOOP;

Line 759: OKL_API.END_ACTIVITY(

755: AND EXISTS (SELECT ID
756: FROM OKL_K_HEADERS KHR
757: WHERE KHR.ID = CPR.DNZ_CHR_ID);
758:
759: OKL_API.END_ACTIVITY(
760: x_msg_count => p_msg_count
761: ,x_msg_data => p_msg_data);
762:
763: -- NULL is intentionally treated as false by this statement.

Line 770: okl_api.end_activity(x_msg_count => p_msg_count

766: COMMIT;
767: END IF;
768:
769: p_return_status := l_return_status;
770: okl_api.end_activity(x_msg_count => p_msg_count
771: ,x_msg_data => p_msg_data);
772:
773: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on)
774: THEN

Line 780: WHEN OKL_API.G_EXCEPTION_ERROR

776: ,l_module
777: ,'end debug okl_vendormerge_grp.merge_vendor');
778: END IF;
779: EXCEPTION
780: WHEN OKL_API.G_EXCEPTION_ERROR
781: THEN
782: IF chk_vendor_chr_csr%ISOPEN
783: THEN
784: CLOSE chk_vendor_chr_csr;

Line 806: p_return_status := OKL_API.HANDLE_EXCEPTIONS(

802: IF fee_name_csr%ISOPEN
803: THEN
804: CLOSE fee_name_csr;
805: END IF;
806: p_return_status := OKL_API.HANDLE_EXCEPTIONS(
807: p_api_name => l_api_name,
808: p_pkg_name => G_PKG_NAME,
809: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
810: x_msg_count => p_msg_count,

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

805: END IF;
806: p_return_status := OKL_API.HANDLE_EXCEPTIONS(
807: p_api_name => l_api_name,
808: p_pkg_name => G_PKG_NAME,
809: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
810: x_msg_count => p_msg_count,
811: x_msg_data => p_msg_data,
812: p_api_type => G_API_TYPE);
813: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR

Line 813: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR

809: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
810: x_msg_count => p_msg_count,
811: x_msg_data => p_msg_data,
812: p_api_type => G_API_TYPE);
813: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR
814: THEN
815: IF chk_vendor_chr_csr%ISOPEN
816: THEN
817: CLOSE chk_vendor_chr_csr;

Line 839: p_return_status := OKL_API.HANDLE_EXCEPTIONS(

835: IF fee_name_csr%ISOPEN
836: THEN
837: CLOSE fee_name_csr;
838: END IF;
839: p_return_status := OKL_API.HANDLE_EXCEPTIONS(
840: p_api_name => l_api_name,
841: p_pkg_name => G_PKG_NAME,
842: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
843: x_msg_count => p_msg_count,

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

838: END IF;
839: p_return_status := OKL_API.HANDLE_EXCEPTIONS(
840: p_api_name => l_api_name,
841: p_pkg_name => G_PKG_NAME,
842: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
843: x_msg_count => p_msg_count,
844: x_msg_data => p_msg_data,
845: p_api_type => G_API_TYPE);
846: WHEN OTHERS

Line 872: p_return_status := OKL_API.HANDLE_EXCEPTIONS(

868: IF fee_name_csr%ISOPEN
869: THEN
870: CLOSE fee_name_csr;
871: END IF;
872: p_return_status := OKL_API.HANDLE_EXCEPTIONS(
873: p_api_name => l_api_name,
874: p_pkg_name => G_PKG_NAME,
875: p_exc_name => 'OTHERS',
876: x_msg_count => p_msg_count,