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

Line 877: p_init_msg_list => Okl_Api.G_FALSE,

873: -- Get SLH Rule from OLD Contract
874: --
875: Okl_Rule_Apis_Pvt.Get_Contract_Rules(
876: p_api_version => 1.0,
877: p_init_msg_list => Okl_Api.G_FALSE,
878: p_rgpv_rec => l_old_rgpv_rec,
879: p_rdf_code => 'LASLH',
880: x_return_status => x_return_status,
881: x_msg_count => x_msg_count,

Line 1048: RAISE Okl_Api.G_EXCEPTION_ERROR;

1044: p_old_rgp_id => l_old_lalevl_id,
1045: p_new_rgp_id => l_new_lalevl_id
1046: );
1047: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1048: RAISE Okl_Api.G_EXCEPTION_ERROR;
1049: END IF;
1050: END LOOP;
1051:
1052: EXCEPTION

Line 1124: RAISE OKL_API.G_EXCEPTION_ERROR;

1120: p_old_rgp_id => l_old_lalevl_id,
1121: p_new_rgp_id => l_new_lalevl_id
1122: );
1123: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1124: RAISE OKL_API.G_EXCEPTION_ERROR;
1125: END IF;
1126: END LOOP;
1127:
1128: EXCEPTION

Line 1493: RAISE OKL_API.G_EXCEPTION_ERROR;

1489: p_new_chr_id => l_chr_id
1490: );
1491:
1492: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1493: RAISE OKL_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:
1496: END LOOP;
1497: CLOSE new_c_lines;

Line 3553: l_value VARCHAR2(1) := OKL_API.G_FALSE;

3549: x_new_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
3550: x_new_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3551: l_old_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3552: l_new_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
3553: l_value VARCHAR2(1) := OKL_API.G_FALSE;
3554:
3555: CURSOR l_source_k_num_crs IS
3556: SELECT contract_number
3557: FROM okc_k_headers_b

Line 3602: IF(l_value = OKL_API.G_TRUE) THEN

3598: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3599: RAISE OKC_API.G_EXCEPTION_ERROR;
3600: END IF;
3601:
3602: IF(l_value = OKL_API.G_TRUE) THEN
3603: OKC_API.SET_MESSAGE( p_app_name => g_app_name
3604: , p_msg_name => 'OKL_LLA_CONTRACT_SECU_ERROR'
3605: );
3606: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4227: --IF (l_check= OKL_API.G_TRUE) THEN

4223:
4224: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
4225: -- Raise the event if it is a new Contract
4226: --l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);
4227: --IF (l_check= OKL_API.G_TRUE) THEN
4228: IF (p_source_code = 'new') THEN
4229: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
4230:
4231: OKL_WF_PVT.raise_event (p_api_version => p_api_version,

Line 4243: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

4239: END IF;
4240:
4241: EXCEPTION
4242: WHEN OTHERS THEN
4243: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4245: END raise_business_event;
4246:
4247:

Line 4244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4240:
4241: EXCEPTION
4242: WHEN OTHERS THEN
4243: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4244: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4245: END raise_business_event;
4246:
4247:
4248: /*

Line 4533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

4529: -- Code change to enable Business Event
4530: */
4531: raise_business_event(p_chr_id => x_chr_id
4532: ,x_return_status => x_return_status);
4533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4536: RAISE OKL_API.G_EXCEPTION_ERROR;
4537: END IF;

Line 4534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4530: */
4531: raise_business_event(p_chr_id => x_chr_id
4532: ,x_return_status => x_return_status);
4533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4536: RAISE OKL_API.G_EXCEPTION_ERROR;
4537: END IF;
4538:

Line 4535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

4531: raise_business_event(p_chr_id => x_chr_id
4532: ,x_return_status => x_return_status);
4533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4536: RAISE OKL_API.G_EXCEPTION_ERROR;
4537: END IF;
4538:
4539: /*

Line 4536: RAISE OKL_API.G_EXCEPTION_ERROR;

4532: ,x_return_status => x_return_status);
4533: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4535: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4536: RAISE OKL_API.G_EXCEPTION_ERROR;
4537: END IF;
4538:
4539: /*
4540: -- mvasudev, 08/17/2004

Line 4862: --IF (l_check= OKL_API.G_TRUE) THEN

4858:
4859: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
4860: -- Raise the event if it is a new Contract
4861: --l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);
4862: --IF (l_check= OKL_API.G_TRUE) THEN
4863: IF (p_source_code = 'new') THEN
4864: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
4865:
4866: OKL_WF_PVT.raise_event (p_api_version => p_api_version,

Line 4878: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

4874: END IF;
4875:
4876: EXCEPTION
4877: WHEN OTHERS THEN
4878: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4879: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4880: END raise_business_event;
4881:
4882:

Line 4879: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4875:
4876: EXCEPTION
4877: WHEN OTHERS THEN
4878: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4879: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4880: END raise_business_event;
4881:
4882:
4883: /*

Line 5354: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

5350: -- Code change to enable Business Event
5351: */
5352: raise_business_event(p_chr_id => x_chr_id
5353: ,x_return_status => x_return_status);
5354: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5357: RAISE OKL_API.G_EXCEPTION_ERROR;
5358: END IF;

Line 5355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5351: */
5352: raise_business_event(p_chr_id => x_chr_id
5353: ,x_return_status => x_return_status);
5354: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5357: RAISE OKL_API.G_EXCEPTION_ERROR;
5358: END IF;
5359:

Line 5356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

5352: raise_business_event(p_chr_id => x_chr_id
5353: ,x_return_status => x_return_status);
5354: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5357: RAISE OKL_API.G_EXCEPTION_ERROR;
5358: END IF;
5359:
5360: /*

Line 5357: RAISE OKL_API.G_EXCEPTION_ERROR;

5353: ,x_return_status => x_return_status);
5354: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5357: RAISE OKL_API.G_EXCEPTION_ERROR;
5358: END IF;
5359:
5360: /*
5361: -- mvasudev, 08/17/2004

Line 6664: IF (l_check= OKL_API.G_TRUE) THEN

6660:
6661: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
6662: -- Raise the event if it is a new Contract
6663: l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);
6664: IF (l_check= OKL_API.G_TRUE) THEN
6665: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
6666:
6667: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
6668: p_init_msg_list => p_init_msg_list,

Line 6679: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

6675: END IF;
6676:
6677: EXCEPTION
6678: WHEN OTHERS THEN
6679: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
6680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6681: END raise_business_event;
6682:
6683: /*

Line 6680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

6676:
6677: EXCEPTION
6678: WHEN OTHERS THEN
6679: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
6680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6681: END raise_business_event;
6682:
6683: /*
6684: -- mvasudev, 08/17/2004

Line 7999: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

7995: -- Code change to enable Business Event
7996: */
7997: raise_business_event(p_chr_id => p_durv_rec.chr_id
7998: ,x_return_status => x_return_status);
7999: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8000: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8001: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8002: RAISE OKL_API.G_EXCEPTION_ERROR;
8003: END IF;

Line 8000: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7996: */
7997: raise_business_event(p_chr_id => p_durv_rec.chr_id
7998: ,x_return_status => x_return_status);
7999: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8000: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8001: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8002: RAISE OKL_API.G_EXCEPTION_ERROR;
8003: END IF;
8004:

Line 8001: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

7997: raise_business_event(p_chr_id => p_durv_rec.chr_id
7998: ,x_return_status => x_return_status);
7999: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8000: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8001: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8002: RAISE OKL_API.G_EXCEPTION_ERROR;
8003: END IF;
8004:
8005: /*

Line 8002: RAISE OKL_API.G_EXCEPTION_ERROR;

7998: ,x_return_status => x_return_status);
7999: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8000: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8001: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8002: RAISE OKL_API.G_EXCEPTION_ERROR;
8003: END IF;
8004:
8005: /*
8006: -- mvasudev, 08/17/2004

Line 8348: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

8344:
8345:
8346: Procedure confirm_cancel_contract
8347: (p_api_version IN NUMBER,
8348: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8349: x_return_status OUT NOCOPY VARCHAR2,
8350: x_msg_count OUT NOCOPY NUMBER,
8351: x_msg_data OUT NOCOPY VARCHAR2,
8352: p_contract_id IN NUMBER,

Line 8355: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

8351: x_msg_data OUT NOCOPY VARCHAR2,
8352: p_contract_id IN NUMBER,
8353: p_contract_number IN VARCHAR2) AS
8354:
8355: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8356: l_api_name CONSTANT varchar2(30) := 'confirm_cancel_contract';
8357: l_api_version CONSTANT NUMBER := 1.0;
8358:
8359: Begin

Line 8360: x_return_status := OKL_API.G_RET_STS_SUCCESS;

8356: l_api_name CONSTANT varchar2(30) := 'confirm_cancel_contract';
8357: l_api_version CONSTANT NUMBER := 1.0;
8358:
8359: Begin
8360: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8361: -- Call start_activity to create savepoint, check compatibility
8362: -- and initialize message list
8363: x_return_status := OKL_API.START_ACTIVITY (
8364: l_api_name

Line 8363: x_return_status := OKL_API.START_ACTIVITY (

8359: Begin
8360: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8361: -- Call start_activity to create savepoint, check compatibility
8362: -- and initialize message list
8363: x_return_status := OKL_API.START_ACTIVITY (
8364: l_api_name
8365: ,p_init_msg_list
8366: ,'_PVT'
8367: ,x_return_status);

Line 8369: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

8365: ,p_init_msg_list
8366: ,'_PVT'
8367: ,x_return_status);
8368: -- Check if activity started successfully
8369: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8372: RAISE OKL_API.G_EXCEPTION_ERROR;
8373: END IF;

Line 8370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8366: ,'_PVT'
8367: ,x_return_status);
8368: -- Check if activity started successfully
8369: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8372: RAISE OKL_API.G_EXCEPTION_ERROR;
8373: END IF;
8374:

Line 8371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

8367: ,x_return_status);
8368: -- Check if activity started successfully
8369: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8372: RAISE OKL_API.G_EXCEPTION_ERROR;
8373: END IF;
8374:
8375: okl_maintain_contract_pvt.confirm_cancel_contract(

Line 8372: RAISE OKL_API.G_EXCEPTION_ERROR;

8368: -- Check if activity started successfully
8369: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8372: RAISE OKL_API.G_EXCEPTION_ERROR;
8373: END IF;
8374:
8375: okl_maintain_contract_pvt.confirm_cancel_contract(
8376: p_api_version => p_api_version,

Line 8384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

8380: x_msg_data => x_msg_data,
8381: p_contract_id => p_contract_id,
8382: p_new_contract_number => p_contract_number);
8383:
8384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8387: RAISE OKL_API.G_EXCEPTION_ERROR;
8388: END IF;

Line 8385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8381: p_contract_id => p_contract_id,
8382: p_new_contract_number => p_contract_number);
8383:
8384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8387: RAISE OKL_API.G_EXCEPTION_ERROR;
8388: END IF;
8389:

Line 8386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

8382: p_new_contract_number => p_contract_number);
8383:
8384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8387: RAISE OKL_API.G_EXCEPTION_ERROR;
8388: END IF;
8389:
8390: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 8387: RAISE OKL_API.G_EXCEPTION_ERROR;

8383:
8384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8387: RAISE OKL_API.G_EXCEPTION_ERROR;
8388: END IF;
8389:
8390: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8391:

Line 8390: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

8386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8387: RAISE OKL_API.G_EXCEPTION_ERROR;
8388: END IF;
8389:
8390: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8391:
8392: EXCEPTION
8393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 8393: WHEN OKL_API.G_EXCEPTION_ERROR THEN

8389:
8390: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8391:
8392: EXCEPTION
8393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8395: l_api_name,
8396: G_PKG_NAME,
8397: 'OKL_API.G_RET_STS_ERROR',

Line 8394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8390: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8391:
8392: EXCEPTION
8393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8395: l_api_name,
8396: G_PKG_NAME,
8397: 'OKL_API.G_RET_STS_ERROR',
8398: x_msg_count,

Line 8397: 'OKL_API.G_RET_STS_ERROR',

8393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8394: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8395: l_api_name,
8396: G_PKG_NAME,
8397: 'OKL_API.G_RET_STS_ERROR',
8398: x_msg_count,
8399: x_msg_data,
8400: '_PVT');
8401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 8401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

8397: 'OKL_API.G_RET_STS_ERROR',
8398: x_msg_count,
8399: x_msg_data,
8400: '_PVT');
8401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8402: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8403: l_api_name,
8404: G_PKG_NAME,
8405: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 8402: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

8398: x_msg_count,
8399: x_msg_data,
8400: '_PVT');
8401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8402: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8403: l_api_name,
8404: G_PKG_NAME,
8405: 'OKL_API.G_RET_STS_UNEXP_ERROR',
8406: x_msg_count,

Line 8405: 'OKL_API.G_RET_STS_UNEXP_ERROR',

8401: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8402: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8403: l_api_name,
8404: G_PKG_NAME,
8405: 'OKL_API.G_RET_STS_UNEXP_ERROR',
8406: x_msg_count,
8407: x_msg_data,
8408: '_PVT');
8409: WHEN OTHERS THEN

Line 8410: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

8406: x_msg_count,
8407: x_msg_data,
8408: '_PVT');
8409: WHEN OTHERS THEN
8410: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8411: l_api_name,
8412: G_PKG_NAME,
8413: 'OTHERS',
8414: x_msg_count,

Line 8430: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

8426: p_kpl_rec IN party_rec_type,
8427: x_kpl_rec OUT NOCOPY party_rec_type
8428: ) AS
8429:
8430: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8431: l_api_name CONSTANT varchar2(30) := 'create_party';
8432: l_api_version CONSTANT NUMBER := 1.0;
8433:
8434: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 8440: x_return_status := OKL_API.G_RET_STS_SUCCESS;

8436: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8437: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8438:
8439: Begin
8440: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8441: -- Call start_activity to create savepoint, check compatibility
8442: -- and initialize message list
8443: x_return_status := OKL_API.START_ACTIVITY (
8444: l_api_name

Line 8443: x_return_status := OKL_API.START_ACTIVITY (

8439: Begin
8440: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8441: -- Call start_activity to create savepoint, check compatibility
8442: -- and initialize message list
8443: x_return_status := OKL_API.START_ACTIVITY (
8444: l_api_name
8445: ,p_init_msg_list
8446: ,'_PVT'
8447: ,x_return_status);

Line 8449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

8445: ,p_init_msg_list
8446: ,'_PVT'
8447: ,x_return_status);
8448: -- Check if activity started successfully
8449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8452: RAISE OKL_API.G_EXCEPTION_ERROR;
8453: END IF;

Line 8450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8446: ,'_PVT'
8447: ,x_return_status);
8448: -- Check if activity started successfully
8449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8452: RAISE OKL_API.G_EXCEPTION_ERROR;
8453: END IF;
8454:

Line 8451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

8447: ,x_return_status);
8448: -- Check if activity started successfully
8449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8452: RAISE OKL_API.G_EXCEPTION_ERROR;
8453: END IF;
8454:
8455: lp_cplv_rec.id := p_kpl_rec.id;

Line 8452: RAISE OKL_API.G_EXCEPTION_ERROR;

8448: -- Check if activity started successfully
8449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8452: RAISE OKL_API.G_EXCEPTION_ERROR;
8453: END IF;
8454:
8455: lp_cplv_rec.id := p_kpl_rec.id;
8456: lp_cplv_rec.object1_id1 := p_kpl_rec.object1_id1;

Line 8497: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

8493: x_kplv_rec => lx_kplv_rec);
8494:
8495: x_kpl_rec.id := lx_cplv_rec.id;
8496:
8497: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8499: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8500: RAISE OKL_API.G_EXCEPTION_ERROR;
8501: END IF;

Line 8498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8494:
8495: x_kpl_rec.id := lx_cplv_rec.id;
8496:
8497: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8499: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8500: RAISE OKL_API.G_EXCEPTION_ERROR;
8501: END IF;
8502:

Line 8499: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

8495: x_kpl_rec.id := lx_cplv_rec.id;
8496:
8497: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8499: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8500: RAISE OKL_API.G_EXCEPTION_ERROR;
8501: END IF;
8502:
8503: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 8500: RAISE OKL_API.G_EXCEPTION_ERROR;

8496:
8497: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8498: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8499: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8500: RAISE OKL_API.G_EXCEPTION_ERROR;
8501: END IF;
8502:
8503: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8504:

Line 8503: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

8499: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8500: RAISE OKL_API.G_EXCEPTION_ERROR;
8501: END IF;
8502:
8503: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8504:
8505: EXCEPTION
8506: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8507: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 8506: WHEN OKL_API.G_EXCEPTION_ERROR THEN

8502:
8503: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8504:
8505: EXCEPTION
8506: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8507: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8508: l_api_name,
8509: G_PKG_NAME,
8510: 'OKL_API.G_RET_STS_ERROR',

Line 8507: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8503: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8504:
8505: EXCEPTION
8506: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8507: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8508: l_api_name,
8509: G_PKG_NAME,
8510: 'OKL_API.G_RET_STS_ERROR',
8511: x_msg_count,

Line 8510: 'OKL_API.G_RET_STS_ERROR',

8506: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8507: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8508: l_api_name,
8509: G_PKG_NAME,
8510: 'OKL_API.G_RET_STS_ERROR',
8511: x_msg_count,
8512: x_msg_data,
8513: '_PVT');
8514: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 8514: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

8510: 'OKL_API.G_RET_STS_ERROR',
8511: x_msg_count,
8512: x_msg_data,
8513: '_PVT');
8514: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8516: l_api_name,
8517: G_PKG_NAME,
8518: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 8515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

8511: x_msg_count,
8512: x_msg_data,
8513: '_PVT');
8514: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8516: l_api_name,
8517: G_PKG_NAME,
8518: 'OKL_API.G_RET_STS_UNEXP_ERROR',
8519: x_msg_count,

Line 8518: 'OKL_API.G_RET_STS_UNEXP_ERROR',

8514: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8515: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8516: l_api_name,
8517: G_PKG_NAME,
8518: 'OKL_API.G_RET_STS_UNEXP_ERROR',
8519: x_msg_count,
8520: x_msg_data,
8521: '_PVT');
8522: WHEN OTHERS THEN

Line 8523: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

8519: x_msg_count,
8520: x_msg_data,
8521: '_PVT');
8522: WHEN OTHERS THEN
8523: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8524: l_api_name,
8525: G_PKG_NAME,
8526: 'OTHERS',
8527: x_msg_count,

Line 8543: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

8539: p_kpl_rec IN party_rec_type,
8540: x_kpl_rec OUT NOCOPY party_rec_type
8541: ) AS
8542:
8543: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8544: l_api_name CONSTANT varchar2(30) := 'update_party';
8545: l_api_version CONSTANT NUMBER := 1.0;
8546:
8547: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 8553: x_return_status := OKL_API.G_RET_STS_SUCCESS;

8549: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8550: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8551:
8552: Begin
8553: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8554: -- Call start_activity to create savepoint, check compatibility
8555: -- and initialize message list
8556: x_return_status := OKL_API.START_ACTIVITY (
8557: l_api_name

Line 8556: x_return_status := OKL_API.START_ACTIVITY (

8552: Begin
8553: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8554: -- Call start_activity to create savepoint, check compatibility
8555: -- and initialize message list
8556: x_return_status := OKL_API.START_ACTIVITY (
8557: l_api_name
8558: ,p_init_msg_list
8559: ,'_PVT'
8560: ,x_return_status);

Line 8562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

8558: ,p_init_msg_list
8559: ,'_PVT'
8560: ,x_return_status);
8561: -- Check if activity started successfully
8562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8565: RAISE OKL_API.G_EXCEPTION_ERROR;
8566: END IF;

Line 8563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8559: ,'_PVT'
8560: ,x_return_status);
8561: -- Check if activity started successfully
8562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8565: RAISE OKL_API.G_EXCEPTION_ERROR;
8566: END IF;
8567:

Line 8564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

8560: ,x_return_status);
8561: -- Check if activity started successfully
8562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8565: RAISE OKL_API.G_EXCEPTION_ERROR;
8566: END IF;
8567:
8568: lp_cplv_rec.id := p_kpl_rec.id;

Line 8565: RAISE OKL_API.G_EXCEPTION_ERROR;

8561: -- Check if activity started successfully
8562: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8563: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8564: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8565: RAISE OKL_API.G_EXCEPTION_ERROR;
8566: END IF;
8567:
8568: lp_cplv_rec.id := p_kpl_rec.id;
8569: lp_cplv_rec.object1_id1 := p_kpl_rec.object1_id1;

Line 8606: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

8602:
8603:
8604: x_kpl_rec.id := lx_cplv_rec.id;
8605:
8606: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8607: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8608: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8609: RAISE OKL_API.G_EXCEPTION_ERROR;
8610: END IF;

Line 8607: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8603:
8604: x_kpl_rec.id := lx_cplv_rec.id;
8605:
8606: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8607: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8608: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8609: RAISE OKL_API.G_EXCEPTION_ERROR;
8610: END IF;
8611:

Line 8608: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

8604: x_kpl_rec.id := lx_cplv_rec.id;
8605:
8606: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8607: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8608: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8609: RAISE OKL_API.G_EXCEPTION_ERROR;
8610: END IF;
8611:
8612: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 8609: RAISE OKL_API.G_EXCEPTION_ERROR;

8605:
8606: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8607: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8608: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8609: RAISE OKL_API.G_EXCEPTION_ERROR;
8610: END IF;
8611:
8612: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8613:

Line 8612: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

8608: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8609: RAISE OKL_API.G_EXCEPTION_ERROR;
8610: END IF;
8611:
8612: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8613:
8614: EXCEPTION
8615: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8616: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 8615: WHEN OKL_API.G_EXCEPTION_ERROR THEN

8611:
8612: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8613:
8614: EXCEPTION
8615: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8616: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8617: l_api_name,
8618: G_PKG_NAME,
8619: 'OKL_API.G_RET_STS_ERROR',

Line 8616: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8612: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8613:
8614: EXCEPTION
8615: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8616: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8617: l_api_name,
8618: G_PKG_NAME,
8619: 'OKL_API.G_RET_STS_ERROR',
8620: x_msg_count,

Line 8619: 'OKL_API.G_RET_STS_ERROR',

8615: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8616: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8617: l_api_name,
8618: G_PKG_NAME,
8619: 'OKL_API.G_RET_STS_ERROR',
8620: x_msg_count,
8621: x_msg_data,
8622: '_PVT');
8623: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 8623: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

8619: 'OKL_API.G_RET_STS_ERROR',
8620: x_msg_count,
8621: x_msg_data,
8622: '_PVT');
8623: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8624: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8625: l_api_name,
8626: G_PKG_NAME,
8627: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 8624: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

8620: x_msg_count,
8621: x_msg_data,
8622: '_PVT');
8623: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8624: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8625: l_api_name,
8626: G_PKG_NAME,
8627: 'OKL_API.G_RET_STS_UNEXP_ERROR',
8628: x_msg_count,

Line 8627: 'OKL_API.G_RET_STS_UNEXP_ERROR',

8623: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8624: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8625: l_api_name,
8626: G_PKG_NAME,
8627: 'OKL_API.G_RET_STS_UNEXP_ERROR',
8628: x_msg_count,
8629: x_msg_data,
8630: '_PVT');
8631: WHEN OTHERS THEN

Line 8632: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

8628: x_msg_count,
8629: x_msg_data,
8630: '_PVT');
8631: WHEN OTHERS THEN
8632: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8633: l_api_name,
8634: G_PKG_NAME,
8635: 'OTHERS',
8636: x_msg_count,