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

Line 840: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

836: -- End of Comments
837: ---------------------------------------------------------------------------
838: PROCEDURE crt_lseapp_thrdprt_ins(
839: p_api_version IN NUMBER,
840: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
841: x_return_status OUT NOCOPY VARCHAR2,
842: x_msg_count OUT NOCOPY NUMBER,
843: x_msg_data OUT NOCOPY VARCHAR2,
844: p_ipyv_rec IN ipyv_rec_type,

Line 856: l_return_status := OKL_API.G_RET_STS_SUCCESS;

852: -- Record/Table Type Declarations
853: l_ipyv_rec ipyv_rec_type;
854: lx_ipyv_rec ipyv_rec_type;
855: BEGIN
856: l_return_status := OKL_API.G_RET_STS_SUCCESS;
857: L_MODULE := 'OKL.PLSQL.OKL_INS_QUOTE_PUB.CRT_LSEAPP_THRDPRT_INS';
858:
859: -- check for logging on PROCEDURE level
860: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');

Line 867: l_return_status := OKL_API.START_ACTIVITY(

863: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
864:
865: -- call START_ACTIVITY to create savepoint, check compatibility
866: -- and initialize message list
867: l_return_status := OKL_API.START_ACTIVITY(
868: p_api_name => l_api_name
869: ,p_pkg_name => G_PKG_NAME
870: ,p_init_msg_list => p_init_msg_list
871: ,l_api_version => l_api_version

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

873: ,p_api_type => G_API_TYPE
874: ,x_return_status => l_return_status);
875:
876: -- check if activity started successfully
877: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;

Line 878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

874: ,x_return_status => l_return_status);
875:
876: -- check if activity started successfully
877: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: l_ipyv_rec := p_ipyv_rec;

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

875:
876: -- check if activity started successfully
877: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: l_ipyv_rec := p_ipyv_rec;
883:

Line 880: RAISE OKL_API.G_EXCEPTION_ERROR;

876: -- check if activity started successfully
877: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
879: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
880: RAISE OKL_API.G_EXCEPTION_ERROR;
881: END IF;
882: l_ipyv_rec := p_ipyv_rec;
883:
884: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)

Line 894: ,OKL_API.G_FALSE

890: END IF;
891:
892: OKL_INS_QUOTE_PVT.crt_lseapp_thrdprt_ins(
893: l_api_version
894: ,OKL_API.G_FALSE
895: ,l_return_status
896: ,x_msg_count
897: ,x_msg_data
898: ,l_ipyv_rec

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

913: ,L_MODULE || ' Result of OKL_INS_QUOTE_PVT.CRT_LSEAPP_THRDPRT_INS'
914: ,'l_return_status ' || l_return_status);
915: END IF; -- end of statement level debug
916:
917: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
918: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
920: RAISE OKL_API.G_EXCEPTION_ERROR;
921: END IF;

Line 918: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

914: ,'l_return_status ' || l_return_status);
915: END IF; -- end of statement level debug
916:
917: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
918: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
920: RAISE OKL_API.G_EXCEPTION_ERROR;
921: END IF;
922:

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

915: END IF; -- end of statement level debug
916:
917: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
918: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
920: RAISE OKL_API.G_EXCEPTION_ERROR;
921: END IF;
922:
923: --Assign value to OUT variables

Line 920: RAISE OKL_API.G_EXCEPTION_ERROR;

916:
917: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
918: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
920: RAISE OKL_API.G_EXCEPTION_ERROR;
921: END IF;
922:
923: --Assign value to OUT variables
924: x_return_status := l_return_status ;

Line 927: WHEN OKL_API.G_EXCEPTION_ERROR THEN

923: --Assign value to OUT variables
924: x_return_status := l_return_status ;
925: x_ipyv_rec := lx_ipyv_rec ;
926: EXCEPTION
927: WHEN OKL_API.G_EXCEPTION_ERROR THEN
928: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
929: p_api_name => l_api_name,
930: p_pkg_name => G_PKG_NAME,
931: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 928: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

924: x_return_status := l_return_status ;
925: x_ipyv_rec := lx_ipyv_rec ;
926: EXCEPTION
927: WHEN OKL_API.G_EXCEPTION_ERROR THEN
928: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
929: p_api_name => l_api_name,
930: p_pkg_name => G_PKG_NAME,
931: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
932: x_msg_count => x_msg_count,

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

927: WHEN OKL_API.G_EXCEPTION_ERROR THEN
928: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
929: p_api_name => l_api_name,
930: p_pkg_name => G_PKG_NAME,
931: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
932: x_msg_count => x_msg_count,
933: x_msg_data => x_msg_data,
934: p_api_type => G_API_TYPE);
935:

Line 936: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

932: x_msg_count => x_msg_count,
933: x_msg_data => x_msg_data,
934: p_api_type => G_API_TYPE);
935:
936: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
937: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
938: p_api_name => l_api_name,
939: p_pkg_name => G_PKG_NAME,
940: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 937: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

933: x_msg_data => x_msg_data,
934: p_api_type => G_API_TYPE);
935:
936: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
937: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
938: p_api_name => l_api_name,
939: p_pkg_name => G_PKG_NAME,
940: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
941: x_msg_count => x_msg_count,

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

936: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
937: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
938: p_api_name => l_api_name,
939: p_pkg_name => G_PKG_NAME,
940: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
941: x_msg_count => x_msg_count,
942: x_msg_data => x_msg_data,
943: p_api_type => G_API_TYPE);
944:

Line 946: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

942: x_msg_data => x_msg_data,
943: p_api_type => G_API_TYPE);
944:
945: WHEN OTHERS THEN
946: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
947: p_api_name => l_api_name,
948: p_pkg_name => G_PKG_NAME,
949: p_exc_name => 'OTHERS',
950: x_msg_count => x_msg_count,

Line 970: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

966: -- End of Comments
967: ---------------------------------------------------------------------------
968: PROCEDURE lseapp_thrdprty_to_ctrct(
969: p_api_version IN NUMBER,
970: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
971: x_return_status OUT NOCOPY VARCHAR2,
972: x_msg_count OUT NOCOPY NUMBER,
973: x_msg_data OUT NOCOPY VARCHAR2,
974: p_lakhr_id IN NUMBER,

Line 986: l_return_status := OKL_API.G_RET_STS_SUCCESS;

982: -- Record/Table Type Declarations
983: l_lakhr_id NUMBER;
984: lx_ipyv_rec ipyv_rec_type;
985: BEGIN
986: l_return_status := OKL_API.G_RET_STS_SUCCESS;
987: L_MODULE := 'OKL.PLSQL.OKL_INS_QUOTE_PUB.LSEAPP_THRDPRTY_TO_CTRCT';
988:
989: -- check for logging on PROCEDURE level
990: L_DEBUG_ENABLED := NVL(OKL_DEBUG_PUB.CHECK_LOG_ENABLED, 'N');

Line 997: l_return_status := OKL_API.START_ACTIVITY(

993: IS_DEBUG_STATEMENT_ON := NVL(OKL_DEBUG_PUB.CHECK_LOG_ON(L_MODULE, FND_LOG.LEVEL_STATEMENT), FALSE);
994:
995: -- call START_ACTIVITY to create savepoint, check compatibility
996: -- and initialize message list
997: l_return_status := OKL_API.START_ACTIVITY(
998: p_api_name => l_api_name
999: ,p_pkg_name => G_PKG_NAME
1000: ,p_init_msg_list => p_init_msg_list
1001: ,l_api_version => l_api_version

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

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

Line 1008: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1004: ,x_return_status => l_return_status);
1005:
1006: -- check if activity started successfully
1007: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1008: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1009: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1010: RAISE OKL_API.G_EXCEPTION_ERROR;
1011: END IF;
1012: l_lakhr_id := p_lakhr_id;

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

1005:
1006: -- check if activity started successfully
1007: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1008: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1009: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1010: RAISE OKL_API.G_EXCEPTION_ERROR;
1011: END IF;
1012: l_lakhr_id := p_lakhr_id;
1013:

Line 1010: RAISE OKL_API.G_EXCEPTION_ERROR;

1006: -- check if activity started successfully
1007: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1008: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1009: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1010: RAISE OKL_API.G_EXCEPTION_ERROR;
1011: END IF;
1012: l_lakhr_id := p_lakhr_id;
1013:
1014: IF(L_DEBUG_ENABLED = 'Y' AND IS_DEBUG_PROCEDURE_ON)

Line 1024: ,OKL_API.G_FALSE

1020: END IF;
1021:
1022: OKL_INS_QUOTE_PVT.lseapp_thrdprty_to_ctrct(
1023: l_api_version
1024: ,OKL_API.G_FALSE
1025: ,l_return_status
1026: ,x_msg_count
1027: ,x_msg_data
1028: ,l_lakhr_id

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

1043: ,L_MODULE || ' Result of OKL_INS_QUOTE_PVT.LSEAPP_THRDPRTY_TO_CTRCT'
1044: ,'l_return_status ' || l_return_status);
1045: END IF; -- end of statement level debug
1046:
1047: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1048: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
1050: RAISE OKL_API.G_EXCEPTION_ERROR;
1051: END IF;

Line 1048: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1044: ,'l_return_status ' || l_return_status);
1045: END IF; -- end of statement level debug
1046:
1047: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1048: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
1050: RAISE OKL_API.G_EXCEPTION_ERROR;
1051: END IF;
1052:

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

1045: END IF; -- end of statement level debug
1046:
1047: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1048: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
1050: RAISE OKL_API.G_EXCEPTION_ERROR;
1051: END IF;
1052:
1053: --Assign value to OUT variables

Line 1050: RAISE OKL_API.G_EXCEPTION_ERROR;

1046:
1047: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1048: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR)THEN
1050: RAISE OKL_API.G_EXCEPTION_ERROR;
1051: END IF;
1052:
1053: --Assign value to OUT variables
1054: x_return_status := l_return_status ;

Line 1057: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1053: --Assign value to OUT variables
1054: x_return_status := l_return_status ;
1055: x_ipyv_rec := lx_ipyv_rec ;
1056: EXCEPTION
1057: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1058: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1059: p_api_name => l_api_name,
1060: p_pkg_name => G_PKG_NAME,
1061: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1058: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1054: x_return_status := l_return_status ;
1055: x_ipyv_rec := lx_ipyv_rec ;
1056: EXCEPTION
1057: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1058: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1059: p_api_name => l_api_name,
1060: p_pkg_name => G_PKG_NAME,
1061: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1062: x_msg_count => x_msg_count,

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

1057: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1058: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1059: p_api_name => l_api_name,
1060: p_pkg_name => G_PKG_NAME,
1061: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1062: x_msg_count => x_msg_count,
1063: x_msg_data => x_msg_data,
1064: p_api_type => G_API_TYPE);
1065:

Line 1066: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1062: x_msg_count => x_msg_count,
1063: x_msg_data => x_msg_data,
1064: p_api_type => G_API_TYPE);
1065:
1066: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1068: p_api_name => l_api_name,
1069: p_pkg_name => G_PKG_NAME,
1070: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1063: x_msg_data => x_msg_data,
1064: p_api_type => G_API_TYPE);
1065:
1066: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1068: p_api_name => l_api_name,
1069: p_pkg_name => G_PKG_NAME,
1070: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1071: x_msg_count => x_msg_count,

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

1066: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1067: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1068: p_api_name => l_api_name,
1069: p_pkg_name => G_PKG_NAME,
1070: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1071: x_msg_count => x_msg_count,
1072: x_msg_data => x_msg_data,
1073: p_api_type => G_API_TYPE);
1074:

Line 1076: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1072: x_msg_data => x_msg_data,
1073: p_api_type => G_API_TYPE);
1074:
1075: WHEN OTHERS THEN
1076: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1077: p_api_name => l_api_name,
1078: p_pkg_name => G_PKG_NAME,
1079: p_exc_name => 'OTHERS',
1080: x_msg_count => x_msg_count,