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 3550: l_value VARCHAR2(1) := OKL_API.G_FALSE;

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

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

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

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

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

Line 4240: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

4236: END IF;
4237:
4238: EXCEPTION
4239: WHEN OTHERS THEN
4240: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4242: END raise_business_event;
4243:
4244:

Line 4241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4237:
4238: EXCEPTION
4239: WHEN OTHERS THEN
4240: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4242: END raise_business_event;
4243:
4244:
4245: /*

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

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

Line 4531: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 4533: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 4875: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

4871: END IF;
4872:
4873: EXCEPTION
4874: WHEN OTHERS THEN
4875: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4877: END raise_business_event;
4878:
4879:

Line 4876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4872:
4873: EXCEPTION
4874: WHEN OTHERS THEN
4875: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4877: END raise_business_event;
4878:
4879:
4880: /*

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

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

Line 5352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 5354: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 6676: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 6677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

7986: -- Code change to enable Business Event
7987: */
7988: raise_business_event(p_chr_id => p_durv_rec.chr_id
7989: ,x_return_status => x_return_status);
7990: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7992: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7993: RAISE OKL_API.G_EXCEPTION_ERROR;
7994: END IF;

Line 7991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7987: */
7988: raise_business_event(p_chr_id => p_durv_rec.chr_id
7989: ,x_return_status => x_return_status);
7990: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7992: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7993: RAISE OKL_API.G_EXCEPTION_ERROR;
7994: END IF;
7995:

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

7988: raise_business_event(p_chr_id => p_durv_rec.chr_id
7989: ,x_return_status => x_return_status);
7990: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7992: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7993: RAISE OKL_API.G_EXCEPTION_ERROR;
7994: END IF;
7995:
7996: /*

Line 7993: RAISE OKL_API.G_EXCEPTION_ERROR;

7989: ,x_return_status => x_return_status);
7990: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7991: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7992: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7993: RAISE OKL_API.G_EXCEPTION_ERROR;
7994: END IF;
7995:
7996: /*
7997: -- mvasudev, 08/17/2004

Line 8339: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

8335:
8336:
8337: Procedure confirm_cancel_contract
8338: (p_api_version IN NUMBER,
8339: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
8340: x_return_status OUT NOCOPY VARCHAR2,
8341: x_msg_count OUT NOCOPY NUMBER,
8342: x_msg_data OUT NOCOPY VARCHAR2,
8343: p_contract_id IN NUMBER,

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

8342: x_msg_data OUT NOCOPY VARCHAR2,
8343: p_contract_id IN NUMBER,
8344: p_contract_number IN VARCHAR2) AS
8345:
8346: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8347: l_api_name CONSTANT varchar2(30) := 'confirm_cancel_contract';
8348: l_api_version CONSTANT NUMBER := 1.0;
8349:
8350: Begin

Line 8351: x_return_status := OKL_API.G_RET_STS_SUCCESS;

8347: l_api_name CONSTANT varchar2(30) := 'confirm_cancel_contract';
8348: l_api_version CONSTANT NUMBER := 1.0;
8349:
8350: Begin
8351: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8352: -- Call start_activity to create savepoint, check compatibility
8353: -- and initialize message list
8354: x_return_status := OKL_API.START_ACTIVITY (
8355: l_api_name

Line 8354: x_return_status := OKL_API.START_ACTIVITY (

8350: Begin
8351: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8352: -- Call start_activity to create savepoint, check compatibility
8353: -- and initialize message list
8354: x_return_status := OKL_API.START_ACTIVITY (
8355: l_api_name
8356: ,p_init_msg_list
8357: ,'_PVT'
8358: ,x_return_status);

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

8356: ,p_init_msg_list
8357: ,'_PVT'
8358: ,x_return_status);
8359: -- Check if activity started successfully
8360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8363: RAISE OKL_API.G_EXCEPTION_ERROR;
8364: END IF;

Line 8361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8357: ,'_PVT'
8358: ,x_return_status);
8359: -- Check if activity started successfully
8360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8363: RAISE OKL_API.G_EXCEPTION_ERROR;
8364: END IF;
8365:

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

8358: ,x_return_status);
8359: -- Check if activity started successfully
8360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8363: RAISE OKL_API.G_EXCEPTION_ERROR;
8364: END IF;
8365:
8366: okl_maintain_contract_pvt.confirm_cancel_contract(

Line 8363: RAISE OKL_API.G_EXCEPTION_ERROR;

8359: -- Check if activity started successfully
8360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8361: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8363: RAISE OKL_API.G_EXCEPTION_ERROR;
8364: END IF;
8365:
8366: okl_maintain_contract_pvt.confirm_cancel_contract(
8367: p_api_version => p_api_version,

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

8371: x_msg_data => x_msg_data,
8372: p_contract_id => p_contract_id,
8373: p_new_contract_number => p_contract_number);
8374:
8375: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8378: RAISE OKL_API.G_EXCEPTION_ERROR;
8379: END IF;

Line 8376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8372: p_contract_id => p_contract_id,
8373: p_new_contract_number => p_contract_number);
8374:
8375: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8378: RAISE OKL_API.G_EXCEPTION_ERROR;
8379: END IF;
8380:

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

8373: p_new_contract_number => p_contract_number);
8374:
8375: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8378: RAISE OKL_API.G_EXCEPTION_ERROR;
8379: END IF;
8380:
8381: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 8378: RAISE OKL_API.G_EXCEPTION_ERROR;

8374:
8375: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8378: RAISE OKL_API.G_EXCEPTION_ERROR;
8379: END IF;
8380:
8381: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8382:

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

8377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8378: RAISE OKL_API.G_EXCEPTION_ERROR;
8379: END IF;
8380:
8381: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8382:
8383: EXCEPTION
8384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 8384: WHEN OKL_API.G_EXCEPTION_ERROR THEN

8380:
8381: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8382:
8383: EXCEPTION
8384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8386: l_api_name,
8387: G_PKG_NAME,
8388: 'OKL_API.G_RET_STS_ERROR',

Line 8385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8381: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8382:
8383: EXCEPTION
8384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8386: l_api_name,
8387: G_PKG_NAME,
8388: 'OKL_API.G_RET_STS_ERROR',
8389: x_msg_count,

Line 8388: 'OKL_API.G_RET_STS_ERROR',

8384: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8385: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8386: l_api_name,
8387: G_PKG_NAME,
8388: 'OKL_API.G_RET_STS_ERROR',
8389: x_msg_count,
8390: x_msg_data,
8391: '_PVT');
8392: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 8392: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

8388: 'OKL_API.G_RET_STS_ERROR',
8389: x_msg_count,
8390: x_msg_data,
8391: '_PVT');
8392: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8393: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8394: l_api_name,
8395: G_PKG_NAME,
8396: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 8393: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

8389: x_msg_count,
8390: x_msg_data,
8391: '_PVT');
8392: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8393: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8394: l_api_name,
8395: G_PKG_NAME,
8396: 'OKL_API.G_RET_STS_UNEXP_ERROR',
8397: x_msg_count,

Line 8396: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 8401: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

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

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

8417: p_kpl_rec IN party_rec_type,
8418: x_kpl_rec OUT NOCOPY party_rec_type
8419: ) AS
8420:
8421: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8422: l_api_name CONSTANT varchar2(30) := 'create_party';
8423: l_api_version CONSTANT NUMBER := 1.0;
8424:
8425: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 8431: x_return_status := OKL_API.G_RET_STS_SUCCESS;

8427: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8428: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8429:
8430: Begin
8431: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8432: -- Call start_activity to create savepoint, check compatibility
8433: -- and initialize message list
8434: x_return_status := OKL_API.START_ACTIVITY (
8435: l_api_name

Line 8434: x_return_status := OKL_API.START_ACTIVITY (

8430: Begin
8431: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8432: -- Call start_activity to create savepoint, check compatibility
8433: -- and initialize message list
8434: x_return_status := OKL_API.START_ACTIVITY (
8435: l_api_name
8436: ,p_init_msg_list
8437: ,'_PVT'
8438: ,x_return_status);

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

8436: ,p_init_msg_list
8437: ,'_PVT'
8438: ,x_return_status);
8439: -- Check if activity started successfully
8440: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8442: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8443: RAISE OKL_API.G_EXCEPTION_ERROR;
8444: END IF;

Line 8441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8437: ,'_PVT'
8438: ,x_return_status);
8439: -- Check if activity started successfully
8440: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8442: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8443: RAISE OKL_API.G_EXCEPTION_ERROR;
8444: END IF;
8445:

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

8438: ,x_return_status);
8439: -- Check if activity started successfully
8440: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8442: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8443: RAISE OKL_API.G_EXCEPTION_ERROR;
8444: END IF;
8445:
8446: lp_cplv_rec.id := p_kpl_rec.id;

Line 8443: RAISE OKL_API.G_EXCEPTION_ERROR;

8439: -- Check if activity started successfully
8440: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8442: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8443: RAISE OKL_API.G_EXCEPTION_ERROR;
8444: END IF;
8445:
8446: lp_cplv_rec.id := p_kpl_rec.id;
8447: lp_cplv_rec.object1_id1 := p_kpl_rec.object1_id1;

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

8484: x_kplv_rec => lx_kplv_rec);
8485:
8486: x_kpl_rec.id := lx_cplv_rec.id;
8487:
8488: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8490: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8491: RAISE OKL_API.G_EXCEPTION_ERROR;
8492: END IF;

Line 8489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8485:
8486: x_kpl_rec.id := lx_cplv_rec.id;
8487:
8488: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8490: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8491: RAISE OKL_API.G_EXCEPTION_ERROR;
8492: END IF;
8493:

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

8486: x_kpl_rec.id := lx_cplv_rec.id;
8487:
8488: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8490: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8491: RAISE OKL_API.G_EXCEPTION_ERROR;
8492: END IF;
8493:
8494: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 8491: RAISE OKL_API.G_EXCEPTION_ERROR;

8487:
8488: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8489: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8490: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8491: RAISE OKL_API.G_EXCEPTION_ERROR;
8492: END IF;
8493:
8494: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8495:

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

8490: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8491: RAISE OKL_API.G_EXCEPTION_ERROR;
8492: END IF;
8493:
8494: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8495:
8496: EXCEPTION
8497: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8498: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 8497: WHEN OKL_API.G_EXCEPTION_ERROR THEN

8493:
8494: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8495:
8496: EXCEPTION
8497: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8498: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8499: l_api_name,
8500: G_PKG_NAME,
8501: 'OKL_API.G_RET_STS_ERROR',

Line 8498: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8494: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8495:
8496: EXCEPTION
8497: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8498: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8499: l_api_name,
8500: G_PKG_NAME,
8501: 'OKL_API.G_RET_STS_ERROR',
8502: x_msg_count,

Line 8501: 'OKL_API.G_RET_STS_ERROR',

8497: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8498: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8499: l_api_name,
8500: G_PKG_NAME,
8501: 'OKL_API.G_RET_STS_ERROR',
8502: x_msg_count,
8503: x_msg_data,
8504: '_PVT');
8505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 8505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

8501: 'OKL_API.G_RET_STS_ERROR',
8502: x_msg_count,
8503: x_msg_data,
8504: '_PVT');
8505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8506: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8507: l_api_name,
8508: G_PKG_NAME,
8509: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 8506: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

8502: x_msg_count,
8503: x_msg_data,
8504: '_PVT');
8505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8506: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8507: l_api_name,
8508: G_PKG_NAME,
8509: 'OKL_API.G_RET_STS_UNEXP_ERROR',
8510: x_msg_count,

Line 8509: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 8514: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

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

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

8530: p_kpl_rec IN party_rec_type,
8531: x_kpl_rec OUT NOCOPY party_rec_type
8532: ) AS
8533:
8534: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8535: l_api_name CONSTANT varchar2(30) := 'update_party';
8536: l_api_version CONSTANT NUMBER := 1.0;
8537:
8538: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 8544: x_return_status := OKL_API.G_RET_STS_SUCCESS;

8540: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8541: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
8542:
8543: Begin
8544: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8545: -- Call start_activity to create savepoint, check compatibility
8546: -- and initialize message list
8547: x_return_status := OKL_API.START_ACTIVITY (
8548: l_api_name

Line 8547: x_return_status := OKL_API.START_ACTIVITY (

8543: Begin
8544: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8545: -- Call start_activity to create savepoint, check compatibility
8546: -- and initialize message list
8547: x_return_status := OKL_API.START_ACTIVITY (
8548: l_api_name
8549: ,p_init_msg_list
8550: ,'_PVT'
8551: ,x_return_status);

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

8549: ,p_init_msg_list
8550: ,'_PVT'
8551: ,x_return_status);
8552: -- Check if activity started successfully
8553: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8555: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8556: RAISE OKL_API.G_EXCEPTION_ERROR;
8557: END IF;

Line 8554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8550: ,'_PVT'
8551: ,x_return_status);
8552: -- Check if activity started successfully
8553: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8555: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8556: RAISE OKL_API.G_EXCEPTION_ERROR;
8557: END IF;
8558:

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

8551: ,x_return_status);
8552: -- Check if activity started successfully
8553: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8555: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8556: RAISE OKL_API.G_EXCEPTION_ERROR;
8557: END IF;
8558:
8559: lp_cplv_rec.id := p_kpl_rec.id;

Line 8556: RAISE OKL_API.G_EXCEPTION_ERROR;

8552: -- Check if activity started successfully
8553: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8555: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8556: RAISE OKL_API.G_EXCEPTION_ERROR;
8557: END IF;
8558:
8559: lp_cplv_rec.id := p_kpl_rec.id;
8560: lp_cplv_rec.object1_id1 := p_kpl_rec.object1_id1;

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

8593:
8594:
8595: x_kpl_rec.id := lx_cplv_rec.id;
8596:
8597: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8599: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8600: RAISE OKL_API.G_EXCEPTION_ERROR;
8601: END IF;

Line 8598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8594:
8595: x_kpl_rec.id := lx_cplv_rec.id;
8596:
8597: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8599: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8600: RAISE OKL_API.G_EXCEPTION_ERROR;
8601: END IF;
8602:

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

8595: x_kpl_rec.id := lx_cplv_rec.id;
8596:
8597: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8599: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8600: RAISE OKL_API.G_EXCEPTION_ERROR;
8601: END IF;
8602:
8603: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 8600: RAISE OKL_API.G_EXCEPTION_ERROR;

8596:
8597: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8599: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8600: RAISE OKL_API.G_EXCEPTION_ERROR;
8601: END IF;
8602:
8603: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8604:

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

8599: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8600: RAISE OKL_API.G_EXCEPTION_ERROR;
8601: END IF;
8602:
8603: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8604:
8605: EXCEPTION
8606: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8607: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 8606: WHEN OKL_API.G_EXCEPTION_ERROR THEN

8602:
8603: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8604:
8605: EXCEPTION
8606: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8607: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8608: l_api_name,
8609: G_PKG_NAME,
8610: 'OKL_API.G_RET_STS_ERROR',

Line 8607: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8603: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
8604:
8605: EXCEPTION
8606: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8607: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8608: l_api_name,
8609: G_PKG_NAME,
8610: 'OKL_API.G_RET_STS_ERROR',
8611: x_msg_count,

Line 8610: 'OKL_API.G_RET_STS_ERROR',

8606: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8607: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8608: l_api_name,
8609: G_PKG_NAME,
8610: 'OKL_API.G_RET_STS_ERROR',
8611: x_msg_count,
8612: x_msg_data,
8613: '_PVT');
8614: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 8614: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

8610: 'OKL_API.G_RET_STS_ERROR',
8611: x_msg_count,
8612: x_msg_data,
8613: '_PVT');
8614: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8615: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8616: l_api_name,
8617: G_PKG_NAME,
8618: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 8615: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

8611: x_msg_count,
8612: x_msg_data,
8613: '_PVT');
8614: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8615: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
8616: l_api_name,
8617: G_PKG_NAME,
8618: 'OKL_API.G_RET_STS_UNEXP_ERROR',
8619: x_msg_count,

Line 8618: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 8623: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

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