DBA Data[Home] [Help]

APPS.OKL_LEASE_APP_WF dependencies on OKL_API

Line 251: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name,

247:
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name,
252: G_PKG_NAME,
253: 'OTHERS',
254: x_msg_count,
255: x_msg_data,

Line 387: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name,

383: G_WF_ITM_APP_REJECTED_HEAD,
384: l_rejected_message);
385: EXCEPTION
386: WHEN OTHERS THEN
387: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name,
388: G_PKG_NAME,
389: 'OTHERS',
390: x_msg_count,
391: x_msg_data,

Line 543: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name,

539: l_application_id);
540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name,
544: G_PKG_NAME,
545: 'OTHERS',
546: x_msg_count,
547: x_msg_data,

Line 817: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

813: resultout OUT NOCOPY VARCHAR2) IS
814: l_api_version NUMBER := 1.0;
815: l_api_name CONSTANT VARCHAR2(30) := 'handle_lat_approval';
816: l_msg_count NUMBER;
817: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
818: l_msg_data VARCHAR2(2000);
819: l_return_status VARCHAR2(1);
820:
821: l_lat_version_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE;

Line 854: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

850: , x_return_status => l_return_status
851: , x_msg_count => l_msg_count
852: , x_msg_data => l_msg_data
853: , p_lat_version_id => l_lat_version_id);
854: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
855: RAISE OKL_API.G_EXCEPTION_ERROR;
856: END IF;
857: ELSE -- if the approver has rejected, change the status of version to NEW
858:

Line 855: RAISE OKL_API.G_EXCEPTION_ERROR;

851: , x_msg_count => l_msg_count
852: , x_msg_data => l_msg_data
853: , p_lat_version_id => l_lat_version_id);
854: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
855: RAISE OKL_API.G_EXCEPTION_ERROR;
856: END IF;
857: ELSE -- if the approver has rejected, change the status of version to NEW
858:
859: OPEN c_get_ver_dtls(l_lat_version_id);

Line 873: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

869: , x_msg_count => l_msg_count
870: , x_msg_data => l_msg_data
871: , p_lavv_rec => l_lavv_rec
872: , x_lavv_rec => lx_lavv_rec);
873: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
874: RAISE OKL_API.G_EXCEPTION_ERROR;
875: END IF;
876:
877: END IF; -- end of check for approval or rejection

Line 874: RAISE OKL_API.G_EXCEPTION_ERROR;

870: , x_msg_data => l_msg_data
871: , p_lavv_rec => l_lavv_rec
872: , x_lavv_rec => lx_lavv_rec);
873: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
874: RAISE OKL_API.G_EXCEPTION_ERROR;
875: END IF;
876:
877: END IF; -- end of check for approval or rejection
878:

Line 918: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

914: resultout OUT NOCOPY VARCHAR2) IS
915: l_api_version NUMBER := 1.0;
916: l_api_name CONSTANT VARCHAR2(30) := 'handle_la_withdraw_approval';
917: l_msg_count NUMBER;
918: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
919: l_msg_data VARCHAR2(2000);
920: l_return_status VARCHAR2(1);
921:
922: lv_approval_status_ame VARCHAR2(30);

Line 947: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

943: x_msg_count => l_msg_count,
944: x_msg_data => l_msg_data,
945: p_lap_id => l_lease_app_id,
946: p_lap_status => 'WITHDRAWN');
947: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
948: RAISE OKL_API.G_EXCEPTION_ERROR;
949: END IF;
950: END IF; -- end of check for approval or rejection
951:

Line 948: RAISE OKL_API.G_EXCEPTION_ERROR;

944: x_msg_data => l_msg_data,
945: p_lap_id => l_lease_app_id,
946: p_lap_status => 'WITHDRAWN');
947: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
948: RAISE OKL_API.G_EXCEPTION_ERROR;
949: END IF;
950: END IF; -- end of check for approval or rejection
951:
952: RETURN;