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

Line 49: x_base.object_version_number := OKL_API.G_MISS_NUM;

45: x_base OUT NOCOPY ppydv_rec_type,
46: x_evg OUT NOCOPY ppydv_rec_type) IS
47: BEGIN
48: --base record population
49: x_base.object_version_number := OKL_API.G_MISS_NUM;
50: x_base.created_by := OKL_API.G_MISS_NUM;
51: x_base.creation_date := OKL_API.G_MISS_DATE;
52: x_base.last_updated_by := OKL_API.G_MISS_NUM;
53: x_base.last_update_date := OKL_API.G_MISS_DATE;

Line 50: x_base.created_by := OKL_API.G_MISS_NUM;

46: x_evg OUT NOCOPY ppydv_rec_type) IS
47: BEGIN
48: --base record population
49: x_base.object_version_number := OKL_API.G_MISS_NUM;
50: x_base.created_by := OKL_API.G_MISS_NUM;
51: x_base.creation_date := OKL_API.G_MISS_DATE;
52: x_base.last_updated_by := OKL_API.G_MISS_NUM;
53: x_base.last_update_date := OKL_API.G_MISS_DATE;
54: x_base.last_update_login := OKL_API.G_MISS_NUM;

Line 51: x_base.creation_date := OKL_API.G_MISS_DATE;

47: BEGIN
48: --base record population
49: x_base.object_version_number := OKL_API.G_MISS_NUM;
50: x_base.created_by := OKL_API.G_MISS_NUM;
51: x_base.creation_date := OKL_API.G_MISS_DATE;
52: x_base.last_updated_by := OKL_API.G_MISS_NUM;
53: x_base.last_update_date := OKL_API.G_MISS_DATE;
54: x_base.last_update_login := OKL_API.G_MISS_NUM;
55: x_base.id := p_from.b_payment_dtls_id;

Line 52: x_base.last_updated_by := OKL_API.G_MISS_NUM;

48: --base record population
49: x_base.object_version_number := OKL_API.G_MISS_NUM;
50: x_base.created_by := OKL_API.G_MISS_NUM;
51: x_base.creation_date := OKL_API.G_MISS_DATE;
52: x_base.last_updated_by := OKL_API.G_MISS_NUM;
53: x_base.last_update_date := OKL_API.G_MISS_DATE;
54: x_base.last_update_login := OKL_API.G_MISS_NUM;
55: x_base.id := p_from.b_payment_dtls_id;
56: x_base.cpl_id := p_from.b_cpl_id;

Line 53: x_base.last_update_date := OKL_API.G_MISS_DATE;

49: x_base.object_version_number := OKL_API.G_MISS_NUM;
50: x_base.created_by := OKL_API.G_MISS_NUM;
51: x_base.creation_date := OKL_API.G_MISS_DATE;
52: x_base.last_updated_by := OKL_API.G_MISS_NUM;
53: x_base.last_update_date := OKL_API.G_MISS_DATE;
54: x_base.last_update_login := OKL_API.G_MISS_NUM;
55: x_base.id := p_from.b_payment_dtls_id;
56: x_base.cpl_id := p_from.b_cpl_id;
57: x_base.pay_site_id := p_from.b_pay_site_id;

Line 54: x_base.last_update_login := OKL_API.G_MISS_NUM;

50: x_base.created_by := OKL_API.G_MISS_NUM;
51: x_base.creation_date := OKL_API.G_MISS_DATE;
52: x_base.last_updated_by := OKL_API.G_MISS_NUM;
53: x_base.last_update_date := OKL_API.G_MISS_DATE;
54: x_base.last_update_login := OKL_API.G_MISS_NUM;
55: x_base.id := p_from.b_payment_dtls_id;
56: x_base.cpl_id := p_from.b_cpl_id;
57: x_base.pay_site_id := p_from.b_pay_site_id;
58: x_base.pay_group_code := p_from.b_pay_group_code;

Line 74: x_evg.object_version_number := OKL_API.G_MISS_NUM;

70: x_base.processing_fee_fixed_amount := p_from.b_processing_fee_fixed_amount;
71: x_base.processing_fee_percent := p_from.b_processing_fee_percent;
72: --x_base.processing_fee_formula := p_from.b_processing_fee_formula;
73: -- evergreen record population
74: x_evg.object_version_number := OKL_API.G_MISS_NUM;
75: x_evg.created_by := OKL_API.G_MISS_NUM;
76: x_evg.creation_date := OKL_API.G_MISS_DATE;
77: x_evg.last_updated_by := OKL_API.G_MISS_NUM;
78: x_evg.last_update_date := OKL_API.G_MISS_DATE;

Line 75: x_evg.created_by := OKL_API.G_MISS_NUM;

71: x_base.processing_fee_percent := p_from.b_processing_fee_percent;
72: --x_base.processing_fee_formula := p_from.b_processing_fee_formula;
73: -- evergreen record population
74: x_evg.object_version_number := OKL_API.G_MISS_NUM;
75: x_evg.created_by := OKL_API.G_MISS_NUM;
76: x_evg.creation_date := OKL_API.G_MISS_DATE;
77: x_evg.last_updated_by := OKL_API.G_MISS_NUM;
78: x_evg.last_update_date := OKL_API.G_MISS_DATE;
79: x_evg.last_update_login := OKL_API.G_MISS_NUM;

Line 76: x_evg.creation_date := OKL_API.G_MISS_DATE;

72: --x_base.processing_fee_formula := p_from.b_processing_fee_formula;
73: -- evergreen record population
74: x_evg.object_version_number := OKL_API.G_MISS_NUM;
75: x_evg.created_by := OKL_API.G_MISS_NUM;
76: x_evg.creation_date := OKL_API.G_MISS_DATE;
77: x_evg.last_updated_by := OKL_API.G_MISS_NUM;
78: x_evg.last_update_date := OKL_API.G_MISS_DATE;
79: x_evg.last_update_login := OKL_API.G_MISS_NUM;
80: x_evg.id := p_from.e_payment_dtls_id;

Line 77: x_evg.last_updated_by := OKL_API.G_MISS_NUM;

73: -- evergreen record population
74: x_evg.object_version_number := OKL_API.G_MISS_NUM;
75: x_evg.created_by := OKL_API.G_MISS_NUM;
76: x_evg.creation_date := OKL_API.G_MISS_DATE;
77: x_evg.last_updated_by := OKL_API.G_MISS_NUM;
78: x_evg.last_update_date := OKL_API.G_MISS_DATE;
79: x_evg.last_update_login := OKL_API.G_MISS_NUM;
80: x_evg.id := p_from.e_payment_dtls_id;
81: x_evg.cpl_id := p_from.e_cpl_id;

Line 78: x_evg.last_update_date := OKL_API.G_MISS_DATE;

74: x_evg.object_version_number := OKL_API.G_MISS_NUM;
75: x_evg.created_by := OKL_API.G_MISS_NUM;
76: x_evg.creation_date := OKL_API.G_MISS_DATE;
77: x_evg.last_updated_by := OKL_API.G_MISS_NUM;
78: x_evg.last_update_date := OKL_API.G_MISS_DATE;
79: x_evg.last_update_login := OKL_API.G_MISS_NUM;
80: x_evg.id := p_from.e_payment_dtls_id;
81: x_evg.cpl_id := p_from.e_cpl_id;
82: x_evg.pay_site_id := p_from.e_pay_site_id;

Line 79: x_evg.last_update_login := OKL_API.G_MISS_NUM;

75: x_evg.created_by := OKL_API.G_MISS_NUM;
76: x_evg.creation_date := OKL_API.G_MISS_DATE;
77: x_evg.last_updated_by := OKL_API.G_MISS_NUM;
78: x_evg.last_update_date := OKL_API.G_MISS_DATE;
79: x_evg.last_update_login := OKL_API.G_MISS_NUM;
80: x_evg.id := p_from.e_payment_dtls_id;
81: x_evg.cpl_id := p_from.e_cpl_id;
82: x_evg.pay_site_id := p_from.e_pay_site_id;
83: x_evg.pay_group_code := p_from.e_pay_group_code;

Line 173: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

169: x_msg_count => x_msg_count,
170: x_msg_data => x_msg_data,
171: p_ppydv_tbl => l_ppydv_tbl);
172:
173: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
174: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
176: raise OKL_API.G_EXCEPTION_ERROR;
177: End If;

Line 174: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

170: x_msg_data => x_msg_data,
171: p_ppydv_tbl => l_ppydv_tbl);
172:
173: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
174: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
176: raise OKL_API.G_EXCEPTION_ERROR;
177: End If;
178: l_ppydv_tbl.DELETE;

Line 175: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

171: p_ppydv_tbl => l_ppydv_tbl);
172:
173: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
174: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
176: raise OKL_API.G_EXCEPTION_ERROR;
177: End If;
178: l_ppydv_tbl.DELETE;
179: END IF;

Line 176: raise OKL_API.G_EXCEPTION_ERROR;

172:
173: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
174: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
176: raise OKL_API.G_EXCEPTION_ERROR;
177: End If;
178: l_ppydv_tbl.DELETE;
179: END IF;
180:

Line 205: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

201: x_msg_data => x_msg_data,
202: p_cplv_rec => l_cplv_rec,
203: p_kplv_rec => l_kplv_rec);
204:
205: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
206: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
208: raise OKL_API.G_EXCEPTION_ERROR;
209: End If;

Line 206: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

202: p_cplv_rec => l_cplv_rec,
203: p_kplv_rec => l_kplv_rec);
204:
205: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
206: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
208: raise OKL_API.G_EXCEPTION_ERROR;
209: End If;
210: END IF;

Line 207: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

203: p_kplv_rec => l_kplv_rec);
204:
205: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
206: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
208: raise OKL_API.G_EXCEPTION_ERROR;
209: End If;
210: END IF;
211:

Line 208: raise OKL_API.G_EXCEPTION_ERROR;

204:
205: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
206: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
208: raise OKL_API.G_EXCEPTION_ERROR;
209: End If;
210: END IF;
211:
212: OKC_API.END_ACTIVITY (x_msg_count

Line 321: If( l_base_create AND l_base.payment_hdr_id IS NOT NULL AND (l_base.id IS NULL OR l_base.id = OKL_API.G_MISS_NUM) ) Then

317: OR l_base.processing_fee_fixed_amount IS NOT NULL
318: OR l_base.processing_fee_percent IS NOT NULL;
319:
320:
321: If( l_base_create AND l_base.payment_hdr_id IS NOT NULL AND (l_base.id IS NULL OR l_base.id = OKL_API.G_MISS_NUM) ) Then
322: okl_party_payments_pvt.create_party_payment_dtls(
323: p_api_version => p_api_version,
324: p_init_msg_list => p_init_msg_list,
325: x_return_status => l_return_status,

Line 508: IF (NVL(l_chk_rebook_chr,OKL_API.G_MISS_CHAR) = OKL_API.G_TRUE) THEN

504:
505: --Bug# 4884423
506: -- Update of Payout Basis is not allowed during Rebook
507: l_chk_rebook_chr := OKL_LLA_UTIL_PVT.check_rebook_contract(p_chr_id => l_passthru_rec.dnz_chr_id);
508: IF (NVL(l_chk_rebook_chr,OKL_API.G_MISS_CHAR) = OKL_API.G_TRUE) THEN
509:
510: OPEN l_cle_csr(p_cle_id => l_passthru_rec.cle_id);
511: FETCH l_cle_csr INTO l_cle_rec;
512: CLOSE l_cle_csr;

Line 518: l_base_payout_basis_upd := OKL_API.G_FALSE;

514: -- Validation required for only existing fee lines, not
515: -- for newly added fee lines
516: IF (l_cle_rec.orig_system_id1 IS NOT NULL) THEN
517:
518: l_base_payout_basis_upd := OKL_API.G_FALSE;
519: l_evgn_payout_basis_upd := OKL_API.G_FALSE;
520:
521: --Bug# 8652738: Modifications to compare payout basis with value in original contract
522: IF ((l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM )

Line 519: l_evgn_payout_basis_upd := OKL_API.G_FALSE;

515: -- for newly added fee lines
516: IF (l_cle_rec.orig_system_id1 IS NOT NULL) THEN
517:
518: l_base_payout_basis_upd := OKL_API.G_FALSE;
519: l_evgn_payout_basis_upd := OKL_API.G_FALSE;
520:
521: --Bug# 8652738: Modifications to compare payout basis with value in original contract
522: IF ((l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM )
523: AND l_passthru_rec.payout_basis IS NOT NULL) THEN

Line 522: IF ((l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM )

518: l_base_payout_basis_upd := OKL_API.G_FALSE;
519: l_evgn_payout_basis_upd := OKL_API.G_FALSE;
520:
521: --Bug# 8652738: Modifications to compare payout basis with value in original contract
522: IF ((l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM )
523: AND l_passthru_rec.payout_basis IS NOT NULL) THEN
524: l_base_payout_basis_upd := OKL_API.G_FALSE;
525:
526: ELSIF NOT (l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM)

Line 524: l_base_payout_basis_upd := OKL_API.G_FALSE;

520:
521: --Bug# 8652738: Modifications to compare payout basis with value in original contract
522: IF ((l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM )
523: AND l_passthru_rec.payout_basis IS NOT NULL) THEN
524: l_base_payout_basis_upd := OKL_API.G_FALSE;
525:
526: ELSIF NOT (l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM)
527: THEN
528:

Line 526: ELSIF NOT (l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM)

522: IF ((l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM )
523: AND l_passthru_rec.payout_basis IS NOT NULL) THEN
524: l_base_payout_basis_upd := OKL_API.G_FALSE;
525:
526: ELSIF NOT (l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM)
527: THEN
528:
529: FOR l_old_passthru_rec IN l_old_passthru_csr(p_cle_id => l_cle_rec.orig_system_id1,
530: p_passthru_term => 'BASE') LOOP

Line 531: IF (NVL(l_old_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR) <>

527: THEN
528:
529: FOR l_old_passthru_rec IN l_old_passthru_csr(p_cle_id => l_cle_rec.orig_system_id1,
530: p_passthru_term => 'BASE') LOOP
531: IF (NVL(l_old_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR) <>
532: NVL(l_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR)) THEN
533:
534: l_base_payout_basis_upd := OKL_API.G_TRUE;
535:

Line 532: NVL(l_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR)) THEN

528:
529: FOR l_old_passthru_rec IN l_old_passthru_csr(p_cle_id => l_cle_rec.orig_system_id1,
530: p_passthru_term => 'BASE') LOOP
531: IF (NVL(l_old_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR) <>
532: NVL(l_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR)) THEN
533:
534: l_base_payout_basis_upd := OKL_API.G_TRUE;
535:
536: END IF;

Line 534: l_base_payout_basis_upd := OKL_API.G_TRUE;

530: p_passthru_term => 'BASE') LOOP
531: IF (NVL(l_old_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR) <>
532: NVL(l_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR)) THEN
533:
534: l_base_payout_basis_upd := OKL_API.G_TRUE;
535:
536: END IF;
537: END LOOP;
538: END IF;

Line 540: IF (l_base_payout_basis_upd = OKL_API.G_TRUE) THEN

536: END IF;
537: END LOOP;
538: END IF;
539:
540: IF (l_base_payout_basis_upd = OKL_API.G_TRUE) THEN
541: OKL_API.set_message(p_app_name => G_APP_NAME,
542: p_msg_name => 'OKL_LA_RBK_BASE_PYT_BS_UPD');
543: RAISE OKL_API.G_EXCEPTION_ERROR;
544: END IF;

Line 541: OKL_API.set_message(p_app_name => G_APP_NAME,

537: END LOOP;
538: END IF;
539:
540: IF (l_base_payout_basis_upd = OKL_API.G_TRUE) THEN
541: OKL_API.set_message(p_app_name => G_APP_NAME,
542: p_msg_name => 'OKL_LA_RBK_BASE_PYT_BS_UPD');
543: RAISE OKL_API.G_EXCEPTION_ERROR;
544: END IF;
545:

Line 543: RAISE OKL_API.G_EXCEPTION_ERROR;

539:
540: IF (l_base_payout_basis_upd = OKL_API.G_TRUE) THEN
541: OKL_API.set_message(p_app_name => G_APP_NAME,
542: p_msg_name => 'OKL_LA_RBK_BASE_PYT_BS_UPD');
543: RAISE OKL_API.G_EXCEPTION_ERROR;
544: END IF;
545:
546: --Bug# 8652738: Modifications to compare payout basis with value in original contract
547: IF ((l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM )

Line 547: IF ((l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM )

543: RAISE OKL_API.G_EXCEPTION_ERROR;
544: END IF;
545:
546: --Bug# 8652738: Modifications to compare payout basis with value in original contract
547: IF ((l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM )
548: AND l_passthru_rec.evergreen_payout_basis IS NOT NULL) THEN
549: l_evgn_payout_basis_upd := OKL_API.G_FALSE;
550:
551: ELSIF NOT (l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM)

Line 549: l_evgn_payout_basis_upd := OKL_API.G_FALSE;

545:
546: --Bug# 8652738: Modifications to compare payout basis with value in original contract
547: IF ((l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM )
548: AND l_passthru_rec.evergreen_payout_basis IS NOT NULL) THEN
549: l_evgn_payout_basis_upd := OKL_API.G_FALSE;
550:
551: ELSIF NOT (l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM)
552: THEN
553: FOR l_old_passthru_rec IN l_old_passthru_csr(p_cle_id => l_cle_rec.orig_system_id1,

Line 551: ELSIF NOT (l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM)

547: IF ((l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM )
548: AND l_passthru_rec.evergreen_payout_basis IS NOT NULL) THEN
549: l_evgn_payout_basis_upd := OKL_API.G_FALSE;
550:
551: ELSIF NOT (l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM)
552: THEN
553: FOR l_old_passthru_rec IN l_old_passthru_csr(p_cle_id => l_cle_rec.orig_system_id1,
554: p_passthru_term => 'EVERGREEN') LOOP
555: IF (NVL(l_old_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR) <>

Line 555: IF (NVL(l_old_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR) <>

551: ELSIF NOT (l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM)
552: THEN
553: FOR l_old_passthru_rec IN l_old_passthru_csr(p_cle_id => l_cle_rec.orig_system_id1,
554: p_passthru_term => 'EVERGREEN') LOOP
555: IF (NVL(l_old_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR) <>
556: NVL(l_passthru_rec.evergreen_payout_basis,OKL_API.G_MISS_CHAR)) THEN
557:
558: l_evgn_payout_basis_upd := OKL_API.G_TRUE;
559:

Line 556: NVL(l_passthru_rec.evergreen_payout_basis,OKL_API.G_MISS_CHAR)) THEN

552: THEN
553: FOR l_old_passthru_rec IN l_old_passthru_csr(p_cle_id => l_cle_rec.orig_system_id1,
554: p_passthru_term => 'EVERGREEN') LOOP
555: IF (NVL(l_old_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR) <>
556: NVL(l_passthru_rec.evergreen_payout_basis,OKL_API.G_MISS_CHAR)) THEN
557:
558: l_evgn_payout_basis_upd := OKL_API.G_TRUE;
559:
560: END IF;

Line 558: l_evgn_payout_basis_upd := OKL_API.G_TRUE;

554: p_passthru_term => 'EVERGREEN') LOOP
555: IF (NVL(l_old_passthru_rec.payout_basis,OKL_API.G_MISS_CHAR) <>
556: NVL(l_passthru_rec.evergreen_payout_basis,OKL_API.G_MISS_CHAR)) THEN
557:
558: l_evgn_payout_basis_upd := OKL_API.G_TRUE;
559:
560: END IF;
561: END LOOP;
562: END IF;

Line 564: IF (l_evgn_payout_basis_upd = OKL_API.G_TRUE) THEN

560: END IF;
561: END LOOP;
562: END IF;
563:
564: IF (l_evgn_payout_basis_upd = OKL_API.G_TRUE) THEN
565: OKL_API.set_message(p_app_name => G_APP_NAME,
566: p_msg_name => 'OKL_LA_RBK_EVGN_PYT_BS_UPD');
567: RAISE OKL_API.G_EXCEPTION_ERROR;
568: END IF;

Line 565: OKL_API.set_message(p_app_name => G_APP_NAME,

561: END LOOP;
562: END IF;
563:
564: IF (l_evgn_payout_basis_upd = OKL_API.G_TRUE) THEN
565: OKL_API.set_message(p_app_name => G_APP_NAME,
566: p_msg_name => 'OKL_LA_RBK_EVGN_PYT_BS_UPD');
567: RAISE OKL_API.G_EXCEPTION_ERROR;
568: END IF;
569: END IF;

Line 567: RAISE OKL_API.G_EXCEPTION_ERROR;

563:
564: IF (l_evgn_payout_basis_upd = OKL_API.G_TRUE) THEN
565: OKL_API.set_message(p_app_name => G_APP_NAME,
566: p_msg_name => 'OKL_LA_RBK_EVGN_PYT_BS_UPD');
567: RAISE OKL_API.G_EXCEPTION_ERROR;
568: END IF;
569: END IF;
570: END IF;
571: --Bug# 4884423

Line 577: If ( (l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM )

573: ------------------------------------------------------------------
574: --Create base and evergreen if we are actually in Create mode
575: ------------------------------------------------------------------
576: --create payment header base term
577: If ( (l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM )
578: AND l_passthru_rec.payout_basis IS NOT NULL) Then
579:
580: l_pphv_rec.dnz_chr_id := l_passthru_rec.dnz_chr_id;
581: l_pphv_rec.cle_id := l_passthru_rec.cle_id;

Line 611: If ( (l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM )

607: End If;
608: End If;
609:
610: --create payment header evergreen term
611: If ( (l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM )
612: AND l_passthru_rec.evergreen_payout_basis IS NOT NULL) Then
613: --AND l_passthru_rec.evergreen_eligible_yn = 'Y') Then
614: --create payment header evergreen term
615: l_pphv_evg_rec.dnz_chr_id := l_passthru_rec.dnz_chr_id;

Line 650: If NOT (l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM) Then

646: ------------------------------------------------------------------
647: --Update base and evergreen if we are actually in update mode
648: ------------------------------------------------------------------
649: --Update base
650: If NOT (l_passthru_rec.base_id IS NULL OR l_passthru_rec.base_id = OKL_API.G_MISS_NUM) Then
651: --l_pphv_rec.id := l_party_payment_rec.id;
652: l_pphv_rec.id := l_passthru_rec.base_id;
653: l_pphv_rec.passthru_term := 'BASE';
654: l_pphv_rec.dnz_chr_id := l_passthru_rec.dnz_chr_id;

Line 682: If NOT (l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM) Then

678: raise OKC_API.G_EXCEPTION_ERROR;
679: End If;
680: End If;
681: --Update evergreen
682: If NOT (l_passthru_rec.evergreen_id IS NULL OR l_passthru_rec.evergreen_id = OKL_API.G_MISS_NUM) Then
683: --l_pphv_rec.id := l_party_payment_rec.id;
684: l_pphv_rec.id := l_passthru_rec.evergreen_id;
685: l_pphv_rec.passthru_term := 'EVERGREEN';
686: l_pphv_rec.dnz_chr_id := l_passthru_rec.dnz_chr_id;

Line 896: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

892: p_parameters => l_parameter_list);
893:
894: EXCEPTION
895: WHEN OTHERS THEN
896: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
898: END raise_business_event;
899:
900: /*

Line 897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

893:
894: EXCEPTION
895: WHEN OTHERS THEN
896: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
898: END raise_business_event;
899:
900: /*
901: -- vthiruva, 09/01/2004

Line 1683: IF (p_fee_types_rec.fee_purpose_code is not null AND p_fee_types_rec.fee_purpose_code <> OKL_API.G_MISS_CHAR) THEN

1679: If ( p_fee_types_rec.fee_type = G_FT_CAPITALIZED or
1680: p_fee_types_rec.fee_type = G_FT_FINANCED
1681: ) Then
1682:
1683: IF (p_fee_types_rec.fee_purpose_code is not null AND p_fee_types_rec.fee_purpose_code <> OKL_API.G_MISS_CHAR) THEN
1684:
1685: l_fee_purpose_code := null;
1686: open l_fee_purpose_csr(p_fee_types_rec.fee_purpose_code);
1687: fetch l_fee_purpose_csr into l_fee_purpose_code;

Line 2051: If( NVL(l_is_investor,0) <> 1 AND (p_fee_types_rec.line_id is null or p_fee_types_rec.line_id = OKL_API.G_MISS_NUM) and

2047:
2048: -- sales tax changes
2049: --Bug# 6917539: Investor agreement validation causes regression issues
2050: -- for contracts as NULL value is not handled
2051: If( NVL(l_is_investor,0) <> 1 AND (p_fee_types_rec.line_id is null or p_fee_types_rec.line_id = OKL_API.G_MISS_NUM) and
2052: (p_fee_types_rec.fee_type = G_FT_CAPITALIZED OR p_fee_types_rec.fee_type = G_FT_FINANCED)
2053: OR (p_fee_types_rec.fee_type = G_FT_ABSORBED AND p_fee_types_rec.fee_purpose_code
2054: <> OKL_API.G_MISS_CHAR AND p_fee_types_rec.fee_purpose_code = 'RVI') ) Then
2055: x_klev_rec.fee_purpose_code := p_fee_types_rec.fee_purpose_code;

Line 2054: <> OKL_API.G_MISS_CHAR AND p_fee_types_rec.fee_purpose_code = 'RVI') ) Then

2050: -- for contracts as NULL value is not handled
2051: If( NVL(l_is_investor,0) <> 1 AND (p_fee_types_rec.line_id is null or p_fee_types_rec.line_id = OKL_API.G_MISS_NUM) and
2052: (p_fee_types_rec.fee_type = G_FT_CAPITALIZED OR p_fee_types_rec.fee_type = G_FT_FINANCED)
2053: OR (p_fee_types_rec.fee_type = G_FT_ABSORBED AND p_fee_types_rec.fee_purpose_code
2054: <> OKL_API.G_MISS_CHAR AND p_fee_types_rec.fee_purpose_code = 'RVI') ) Then
2055: x_klev_rec.fee_purpose_code := p_fee_types_rec.fee_purpose_code;
2056: End If;
2057:
2058: --Bug# 4558486

Line 2577: If ( (NVL(l_clev_rec.start_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND

2573: --Bug# 4721428
2574: For fee_subline_rec In fee_subline_csr(p_cle_id => l_clev_rec.id,
2575: p_chr_id => l_clev_rec.dnz_chr_id) Loop
2576:
2577: If ( (NVL(l_clev_rec.start_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND
2578: fee_subline_rec.start_date <> l_clev_rec.start_date) OR
2579: (NVL(l_clev_rec.end_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND
2580: fee_subline_rec.end_date <> l_clev_rec.end_date) ) Then
2581:

Line 2579: (NVL(l_clev_rec.end_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND

2575: p_chr_id => l_clev_rec.dnz_chr_id) Loop
2576:
2577: If ( (NVL(l_clev_rec.start_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND
2578: fee_subline_rec.start_date <> l_clev_rec.start_date) OR
2579: (NVL(l_clev_rec.end_date,OKL_API.G_MISS_DATE) <> OKL_API.G_MISS_DATE AND
2580: fee_subline_rec.end_date <> l_clev_rec.end_date) ) Then
2581:
2582: l_sub_clev_rec.id := fee_subline_rec.id;
2583: l_sub_klev_rec.id := fee_subline_rec.id;

Line 2599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

2595: x_clev_rec => x_sub_clev_rec,
2596: x_klev_rec => x_sub_klev_rec
2597: );
2598:
2599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2601: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2602: RAISE OKL_API.G_EXCEPTION_ERROR;
2603: END IF;

Line 2600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2596: x_klev_rec => x_sub_klev_rec
2597: );
2598:
2599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2601: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2602: RAISE OKL_API.G_EXCEPTION_ERROR;
2603: END IF;
2604: End If;

Line 2601: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

2597: );
2598:
2599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2601: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2602: RAISE OKL_API.G_EXCEPTION_ERROR;
2603: END IF;
2604: End If;
2605: End Loop;

Line 2602: RAISE OKL_API.G_EXCEPTION_ERROR;

2598:
2599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
2600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2601: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
2602: RAISE OKL_API.G_EXCEPTION_ERROR;
2603: END IF;
2604: End If;
2605: End Loop;
2606: --Bug# 4721428

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

2858: x_msg_count => x_msg_count,
2859: x_msg_data => x_msg_data,
2860: p_cle_id => lp_fee_types_rec.line_id);
2861:
2862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2865: RAISE OKL_API.G_EXCEPTION_ERROR;
2866: END IF;

Line 2863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2859: x_msg_data => x_msg_data,
2860: p_cle_id => lp_fee_types_rec.line_id);
2861:
2862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2865: RAISE OKL_API.G_EXCEPTION_ERROR;
2866: END IF;
2867: --Bug# 4959361

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

2860: p_cle_id => lp_fee_types_rec.line_id);
2861:
2862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2865: RAISE OKL_API.G_EXCEPTION_ERROR;
2866: END IF;
2867: --Bug# 4959361
2868:

Line 2865: RAISE OKL_API.G_EXCEPTION_ERROR;

2861:
2862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2865: RAISE OKL_API.G_EXCEPTION_ERROR;
2866: END IF;
2867: --Bug# 4959361
2868:
2869: OKL_MAINTAIN_FEE_PVT.validate_fee_type(

Line 2887: If (l_chk_rebook_chr = OKL_API.G_TRUE and lp_fee_types_rec.fee_type = G_FT_ROLLOVER) Then

2883: End If;
2884:
2885: --Bug# 4899328
2886: l_chk_rebook_chr := OKL_LLA_UTIL_PVT.check_rebook_contract(p_chr_id => lp_fee_types_rec.dnz_chr_id);
2887: If (l_chk_rebook_chr = OKL_API.G_TRUE and lp_fee_types_rec.fee_type = G_FT_ROLLOVER) Then
2888:
2889: For l_line_rec In l_line_csr(p_cle_id => lp_fee_types_rec.line_id) Loop
2890:
2891: If (l_line_rec.orig_system_id1 IS NOT NULL And

Line 2894: OKL_API.set_message(p_app_name => G_APP_NAME,

2890:
2891: If (l_line_rec.orig_system_id1 IS NOT NULL And
2892: l_line_rec.qte_id <> lp_fee_types_rec.qte_id) Then
2893:
2894: OKL_API.set_message(p_app_name => G_APP_NAME,
2895: p_msg_name => 'OKL_LA_RBK_ROLL_QT_UPDATE');
2896: RAISE OKL_API.G_EXCEPTION_ERROR;
2897:
2898: End If;

Line 2896: RAISE OKL_API.G_EXCEPTION_ERROR;

2892: l_line_rec.qte_id <> lp_fee_types_rec.qte_id) Then
2893:
2894: OKL_API.set_message(p_app_name => G_APP_NAME,
2895: p_msg_name => 'OKL_LA_RBK_ROLL_QT_UPDATE');
2896: RAISE OKL_API.G_EXCEPTION_ERROR;
2897:
2898: End If;
2899: End Loop;
2900: End If;

Line 2979: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

2975: x_msg_data => x_msg_data,
2976: p_chr_id => lx_clev_rec.dnz_chr_id,
2977: p_cle_id => lx_clev_rec.id);
2978:
2979: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2980: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2981: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2982: raise OKL_API.G_EXCEPTION_ERROR;
2983: End If;

Line 2980: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2976: p_chr_id => lx_clev_rec.dnz_chr_id,
2977: p_cle_id => lx_clev_rec.id);
2978:
2979: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2980: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2981: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2982: raise OKL_API.G_EXCEPTION_ERROR;
2983: End If;
2984:

Line 2981: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

2977: p_cle_id => lx_clev_rec.id);
2978:
2979: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2980: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2981: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2982: raise OKL_API.G_EXCEPTION_ERROR;
2983: End If;
2984:
2985: END IF;

Line 2982: raise OKL_API.G_EXCEPTION_ERROR;

2978:
2979: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2980: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2981: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2982: raise OKL_API.G_EXCEPTION_ERROR;
2983: End If;
2984:
2985: END IF;
2986: -- Bug# 6438785

Line 3203: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,

3199:
3200: IF(( l_fee_purpose_code is not null) and (l_fee_purpose_code <> OKC_API.G_MISS_CHAR) and (l_fee_purpose_code = 'RVI')) Then
3201: IF (p_fee_types_rec.fee_purpose_code is not null) and (p_fee_types_rec.fee_purpose_code <> 'RVI_DUMMY') THEN
3202: x_return_status := OKC_API.g_ret_sts_error;
3203: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,
3204: p_msg_name => 'OKL_LA_RVI_DELETE_NOT_ALLOWED');
3205:
3206: RAISE OKC_API.G_EXCEPTION_ERROR;
3207: End If;

Line 3362: IF(OKL_LLA_UTIL_PVT.is_lease_contract(l_chr_id)= OKL_API.G_TRUE)THEN

3358: -- vthiruva, 09/01/2004
3359: -- START, Code change to enable Business Event
3360: */
3361: --raise the business event for remove fee if its a lease contract
3362: IF(OKL_LLA_UTIL_PVT.is_lease_contract(l_chr_id)= OKL_API.G_TRUE)THEN
3363: raise_business_event(p_api_version => p_api_version,
3364: p_init_msg_list => p_init_msg_list,
3365: x_return_status => x_return_status,
3366: x_msg_count => x_msg_count,

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

3368: p_chr_id => l_chr_id,
3369: p_fee_line_id => l_line_id,
3370: p_event_name => G_WF_EVT_FEE_REMOVED);
3371:
3372: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3375: RAISE OKL_API.G_EXCEPTION_ERROR;
3376: END IF;

Line 3373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3369: p_fee_line_id => l_line_id,
3370: p_event_name => G_WF_EVT_FEE_REMOVED);
3371:
3372: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3375: RAISE OKL_API.G_EXCEPTION_ERROR;
3376: END IF;
3377: END IF;

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

3370: p_event_name => G_WF_EVT_FEE_REMOVED);
3371:
3372: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3375: RAISE OKL_API.G_EXCEPTION_ERROR;
3376: END IF;
3377: END IF;
3378: /*

Line 3375: RAISE OKL_API.G_EXCEPTION_ERROR;

3371:
3372: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3373: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3374: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3375: RAISE OKL_API.G_EXCEPTION_ERROR;
3376: END IF;
3377: END IF;
3378: /*
3379: -- vthiruva, 09/01/2004

Line 4010: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

4006:
4007: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_ROLLOVER_FEELINE';
4008: l_api_version CONSTANT NUMBER := 1.0;
4009:
4010: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4011:
4012: l_not_found BOOLEAN := FALSE;
4013: l_amt NUMBER;
4014: l_found VARCHAR2(1);

Line 4179: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4175:
4176: BEGIN
4177:
4178: IF (NOT p_for_qa_check) THEN
4179: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4180: END IF;
4181: /*
4182: x_return_status := OKL_API.START_ACTIVITY(
4183: p_api_name => l_api_name,

Line 4182: x_return_status := OKL_API.START_ACTIVITY(

4178: IF (NOT p_for_qa_check) THEN
4179: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4180: END IF;
4181: /*
4182: x_return_status := OKL_API.START_ACTIVITY(
4183: p_api_name => l_api_name,
4184: p_pkg_name => g_pkg_name,
4185: p_init_msg_list => p_init_msg_list,
4186: l_api_version => l_api_version,

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

4188: p_api_type => G_API_TYPE,
4189: x_return_status => x_return_status);
4190:
4191: -- check if activity started successfully
4192: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4193: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4194: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4195: raise OKL_API.G_EXCEPTION_ERROR;
4196: END IF;

Line 4193: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4189: x_return_status => x_return_status);
4190:
4191: -- check if activity started successfully
4192: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4193: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4194: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4195: raise OKL_API.G_EXCEPTION_ERROR;
4196: END IF;
4197: */

Line 4194: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

4190:
4191: -- check if activity started successfully
4192: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4193: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4194: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4195: raise OKL_API.G_EXCEPTION_ERROR;
4196: END IF;
4197: */
4198:

Line 4195: raise OKL_API.G_EXCEPTION_ERROR;

4191: -- check if activity started successfully
4192: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4193: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4194: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4195: raise OKL_API.G_EXCEPTION_ERROR;
4196: END IF;
4197: */
4198:
4199: /* check if it is a mass rebook contract */

Line 4241: x_return_status := OKL_API.G_RET_STS_ERROR;

4237: l_not_found := l_cust_accnt_csr%NOTFOUND;
4238: CLOSE l_cust_accnt_csr;
4239:
4240: IF( l_not_found ) THEN
4241: x_return_status := OKL_API.G_RET_STS_ERROR;
4242: l_not_found := NULL;
4243: l_found := NULL;
4244: OKL_API.set_message(
4245: p_app_name => G_APP_NAME,

Line 4244: OKL_API.set_message(

4240: IF( l_not_found ) THEN
4241: x_return_status := OKL_API.G_RET_STS_ERROR;
4242: l_not_found := NULL;
4243: l_found := NULL;
4244: OKL_API.set_message(
4245: p_app_name => G_APP_NAME,
4246: p_msg_name => 'OKL_LLA_RQ_CUST_NO_MATCH',
4247: p_token1 => 'CONTRACT_NUMBER',
4248: p_token1_value => l_k_num,

Line 4255: RAISE OKL_API.G_EXCEPTION_ERROR;

4251: p_token3 => 'FEE_LINE',
4252: p_token3_value => l_fee_name);
4253:
4254: IF (NOT p_for_qa_check) THEN
4255: RAISE OKL_API.G_EXCEPTION_ERROR;
4256: END IF;
4257: END IF;
4258:
4259: /* Check if the Currency Code on the current Contract

Line 4268: x_return_status := OKL_API.G_RET_STS_ERROR;

4264: l_not_found := l_curr_code_csr%NOTFOUND;
4265: CLOSE l_curr_code_csr;
4266:
4267: IF( l_not_found ) THEN
4268: x_return_status := OKL_API.G_RET_STS_ERROR;
4269: l_not_found := NULL;
4270: l_found := NULL;
4271: OKL_API.set_message(
4272: p_app_name => G_APP_NAME,

Line 4271: OKL_API.set_message(

4267: IF( l_not_found ) THEN
4268: x_return_status := OKL_API.G_RET_STS_ERROR;
4269: l_not_found := NULL;
4270: l_found := NULL;
4271: OKL_API.set_message(
4272: p_app_name => G_APP_NAME,
4273: p_msg_name => 'OKL_LLA_RQ_CURR_NO_MATCH',
4274: p_token1 => 'CONTRACT_NUMBER',
4275: p_token1_value => l_k_num,

Line 4282: RAISE OKL_API.G_EXCEPTION_ERROR;

4278: p_token3 => 'FEE_LINE',
4279: p_token3_value => l_fee_name);
4280:
4281: IF (NOT p_for_qa_check) THEN
4282: RAISE OKL_API.G_EXCEPTION_ERROR;
4283: END IF;
4284: END IF;
4285:
4286:

Line 4309: x_return_status := OKL_API.G_RET_STS_ERROR;

4305: l_not_found := l_qts_code_csr%NOTFOUND;
4306: CLOSE l_qts_code_csr;
4307:
4308: IF( l_not_found ) THEN
4309: x_return_status := OKL_API.G_RET_STS_ERROR;
4310: l_not_found := NULL;
4311: l_found := NULL;
4312: OKL_API.set_message(
4313: p_app_name => G_APP_NAME,

Line 4312: OKL_API.set_message(

4308: IF( l_not_found ) THEN
4309: x_return_status := OKL_API.G_RET_STS_ERROR;
4310: l_not_found := NULL;
4311: l_found := NULL;
4312: OKL_API.set_message(
4313: p_app_name => G_APP_NAME,
4314: p_msg_name => 'OKL_LLA_RQ_STS_NOT_APPROVED',
4315: p_token1 => 'QUOTE_NUMBER',
4316: p_token1_value => l_q_num,

Line 4321: RAISE OKL_API.G_EXCEPTION_ERROR;

4317: p_token2 => 'FEE_LINE',
4318: p_token2_value => l_fee_name);
4319:
4320: IF (NOT p_for_qa_check) THEN
4321: RAISE OKL_API.G_EXCEPTION_ERROR;
4322: END IF;
4323: END IF;
4324:
4325: END IF;

Line 4335: x_return_status := OKL_API.G_RET_STS_ERROR;

4331: l_not_found := l_con_yn_csr%NOTFOUND;
4332: CLOSE l_con_yn_csr;
4333:
4334: IF( l_not_found ) THEN
4335: x_return_status := OKL_API.G_RET_STS_ERROR;
4336: l_not_found := NULL;
4337: l_found := NULL;
4338: OKL_API.set_message(
4339: p_app_name => G_APP_NAME,

Line 4338: OKL_API.set_message(

4334: IF( l_not_found ) THEN
4335: x_return_status := OKL_API.G_RET_STS_ERROR;
4336: l_not_found := NULL;
4337: l_found := NULL;
4338: OKL_API.set_message(
4339: p_app_name => G_APP_NAME,
4340: p_msg_name => 'OKL_LLA_RQ_CON_FLG_NOT_Y',
4341: p_token1 => 'QUOTE_NUMBER',
4342: p_token1_value => l_q_num);

Line 4345: RAISE OKL_API.G_EXCEPTION_ERROR;

4341: p_token1 => 'QUOTE_NUMBER',
4342: p_token1_value => l_q_num);
4343:
4344: IF ( NOT p_for_qa_check) THEN
4345: RAISE OKL_API.G_EXCEPTION_ERROR;
4346: END IF;
4347: END IF;
4348:
4349: /* Check if the Quote Type is either TER_ROLL_PURCHASE or

Line 4358: x_return_status := OKL_API.G_RET_STS_ERROR;

4354: l_not_found := l_qte_typ_csr%NOTFOUND;
4355: CLOSE l_qte_typ_csr;
4356:
4357: IF( l_not_found ) THEN
4358: x_return_status := OKL_API.G_RET_STS_ERROR;
4359: l_not_found := NULL;
4360: l_found := NULL;
4361: OKL_API.set_message(
4362: p_app_name => G_APP_NAME,

Line 4361: OKL_API.set_message(

4357: IF( l_not_found ) THEN
4358: x_return_status := OKL_API.G_RET_STS_ERROR;
4359: l_not_found := NULL;
4360: l_found := NULL;
4361: OKL_API.set_message(
4362: p_app_name => G_APP_NAME,
4363: p_msg_name => 'OKL_LLA_RQ_TYP_NOT_CORRECT',
4364: p_token1 => 'QUOTE_NUMBER',
4365: p_token1_value => l_q_num);

Line 4368: RAISE OKL_API.G_EXCEPTION_ERROR;

4364: p_token1 => 'QUOTE_NUMBER',
4365: p_token1_value => l_q_num);
4366:
4367: IF ( NOT p_for_qa_check) THEN
4368: RAISE OKL_API.G_EXCEPTION_ERROR;
4369: END IF;
4370: END IF;
4371:
4372: /* Check if the Rollover Fee Start date is between Quote

Line 4381: x_return_status := OKL_API.G_RET_STS_ERROR;

4377: l_not_found := l_rq_fee_check_csr%NOTFOUND;
4378: CLOSE l_rq_fee_check_csr;
4379:
4380: IF( l_not_found ) THEN
4381: x_return_status := OKL_API.G_RET_STS_ERROR;
4382: l_not_found := NULL;
4383: l_found := NULL;
4384: OKL_API.set_message(
4385: p_app_name => G_APP_NAME,

Line 4384: OKL_API.set_message(

4380: IF( l_not_found ) THEN
4381: x_return_status := OKL_API.G_RET_STS_ERROR;
4382: l_not_found := NULL;
4383: l_found := NULL;
4384: OKL_API.set_message(
4385: p_app_name => G_APP_NAME,
4386: p_msg_name => 'OKL_LLA_RQ_FEE_NOT_CORRECT',
4387: p_token1 => 'FEE_LINE',
4388: p_token1_value => l_fee_name,

Line 4393: RAISE OKL_API.G_EXCEPTION_ERROR;

4389: p_token2 => 'QUOTE_NUMBER',
4390: p_token2_value => l_q_num);
4391:
4392: IF (NOT p_for_qa_check) THEN
4393: RAISE OKL_API.G_EXCEPTION_ERROR;
4394: END IF;
4395: END IF;
4396:
4397: /* Check if the Rollover Quote Amount is equal to

Line 4406: x_return_status := OKL_API.G_RET_STS_ERROR;

4402: l_not_found := l_rq_amt_check_csr%NOTFOUND;
4403: CLOSE l_rq_amt_check_csr;
4404:
4405: IF( l_not_found ) THEN
4406: x_return_status := OKL_API.G_RET_STS_ERROR;
4407: OKL_API.set_message(
4408: p_app_name => G_APP_NAME,
4409: p_msg_name => 'OKL_LLA_RQ_AMT_NOT_EQUAL',
4410: p_token1 => 'FEE_LINE',

Line 4407: OKL_API.set_message(

4403: CLOSE l_rq_amt_check_csr;
4404:
4405: IF( l_not_found ) THEN
4406: x_return_status := OKL_API.G_RET_STS_ERROR;
4407: OKL_API.set_message(
4408: p_app_name => G_APP_NAME,
4409: p_msg_name => 'OKL_LLA_RQ_AMT_NOT_EQUAL',
4410: p_token1 => 'FEE_LINE',
4411: p_token1_value => l_fee_name,

Line 4416: RAISE OKL_API.G_EXCEPTION_ERROR;

4412: p_token2 => 'QUOTE_NUMBER',
4413: p_token2_value => l_q_num);
4414:
4415: IF ( NOT p_for_qa_check) THEN
4416: RAISE OKL_API.G_EXCEPTION_ERROR;
4417: END IF;
4418: END IF;
4419:
4420:

Line 4423: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4419:
4420:
4421: EXCEPTION
4422:
4423: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4424: x_return_status := OKL_API.G_RET_STS_ERROR;
4425:
4426:
4427: IF l_con_qte_csr%ISOPEN THEN

Line 4424: x_return_status := OKL_API.G_RET_STS_ERROR;

4420:
4421: EXCEPTION
4422:
4423: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4424: x_return_status := OKL_API.G_RET_STS_ERROR;
4425:
4426:
4427: IF l_con_qte_csr%ISOPEN THEN
4428: CLOSE l_con_qte_csr;

Line 4463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4459: IF l_rq_amt_check_csr%ISOPEN THEN
4460: CLOSE l_rq_amt_check_csr;
4461: END IF;
4462:
4463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4464: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4465:
4466:
4467: IF l_con_qte_csr%ISOPEN THEN

Line 4464: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

4460: CLOSE l_rq_amt_check_csr;
4461: END IF;
4462:
4463: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4464: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4465:
4466:
4467: IF l_con_qte_csr%ISOPEN THEN
4468: CLOSE l_con_qte_csr;

Line 4542: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4538: IF l_rq_amt_check_csr%ISOPEN THEN
4539: CLOSE l_rq_amt_check_csr;
4540: END IF;
4541:
4542: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4543: p_api_name => l_api_name,
4544: p_pkg_name => g_pkg_name,
4545: p_exc_name => 'OTHERS',
4546: x_msg_count => x_msg_count,

Line 4797: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4793: close l_orig_src_code_csr;
4794:
4795: If(l_orig_src_code = 'OKL_SPLIT' OR l_orig_src_code = 'OKL_RELEASE') Then
4796: x_rem_amt := 0;
4797: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4798: return;
4799: End If;
4800:
4801: open l_rq_fee_lns_bkg_csr(p_chr_id);

Line 4808: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4804:
4805: -- check whether rollover quote and cleditline exists
4806: If(l_qte_id is null OR l_qte_id = OKC_API.G_MISS_NUM) Then
4807: x_rem_amt := 0;
4808: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4809: return;
4810: End If;
4811:
4812: -- check whether creditline exists

Line 4817: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4813: l_cl_id := OKL_CREDIT_PUB.get_creditline_by_chrid(p_chr_id);
4814:
4815: If(l_cl_id is null OR l_cl_id = OKC_API.G_MISS_NUM) Then
4816: x_rem_amt := 0;
4817: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4818: return;
4819: End If;
4820:
4821: -- get the remaining amount

Line 4935: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4931: l_release_contract_yn VARCHAR2(1);
4932:
4933: BEGIN
4934:
4935: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4936:
4937: SELECT NVL(amount, 0)
4938: INTO l_line_amount
4939: FROM okl_k_lines

Line 4953: OKL_API.SET_MESSAGE(p_app_name => g_app_name

4949:
4950: l_line_amount := l_line_amount - NVL(l_term_sub_lines_amt,0);
4951:
4952: IF l_line_amount < 0 THEN
4953: OKL_API.SET_MESSAGE(p_app_name => g_app_name
4954: ,p_msg_name => 'OKL_LA_NEGATIVE_COV_AST_AMT'
4955: ,p_token1 => 'AMOUNT'
4956: ,p_token1_value => TO_CHAR(NVL(l_term_sub_lines_amt,0)));
4957: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 4957: RAISE OKL_API.G_EXCEPTION_ERROR;

4953: OKL_API.SET_MESSAGE(p_app_name => g_app_name
4954: ,p_msg_name => 'OKL_LA_NEGATIVE_COV_AST_AMT'
4955: ,p_token1 => 'AMOUNT'
4956: ,p_token1_value => TO_CHAR(NVL(l_term_sub_lines_amt,0)));
4957: RAISE OKL_API.G_EXCEPTION_ERROR;
4958: END IF;
4959:
4960: SELECT currency_code
4961: INTO l_currency_code

Line 4969: l_release_contract_yn := okl_api.g_false;

4965: l_link_asset_tbl := p_link_asset_tbl;
4966:
4967: IF (l_link_asset_tbl.COUNT > 0) THEN
4968:
4969: l_release_contract_yn := okl_api.g_false;
4970: l_release_contract_yn := okl_lla_util_pvt.check_release_contract(p_chr_id => p_chr_id);
4971:
4972: ------------------------------------------------------------------
4973: -- 1. Loop through to get OEC total of all assets being associated

Line 4980: If l_release_contract_yn = okl_api.g_true then

4976:
4977: IF l_link_asset_tbl.EXISTS(i) THEN
4978:
4979: --Bug# 4631549
4980: If l_release_contract_yn = okl_api.g_true then
4981: SELECT NVL(expected_asset_cost, 0)
4982: INTO l_asset_oec
4983: FROM okl_k_lines
4984: WHERE id = l_link_asset_tbl(i).fin_asset_id;

Line 5017: If l_release_contract_yn = okl_api.g_true then

5013: ELSE
5014:
5015: -- LLA APIs ensure asset OEC and line amount are rounded
5016: --Bug# 4631549
5017: If l_release_contract_yn = okl_api.g_true then
5018: SELECT NVL(expected_asset_cost, 0)
5019: INTO l_asset_oec
5020: FROM okl_k_lines
5021: WHERE id = l_link_asset_tbl(i).fin_asset_id;

Line 5171: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

5167: x_msg_data => x_msg_data,
5168: p_line_item_tbl => l_create_line_item_tbl,
5169: x_line_item_tbl => lx_line_item_tbl);
5170:
5171: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5173: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5174: RAISE OKL_API.G_EXCEPTION_ERROR;
5175: END IF;

Line 5172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5168: p_line_item_tbl => l_create_line_item_tbl,
5169: x_line_item_tbl => lx_line_item_tbl);
5170:
5171: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5173: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5174: RAISE OKL_API.G_EXCEPTION_ERROR;
5175: END IF;
5176:

Line 5173: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

5169: x_line_item_tbl => lx_line_item_tbl);
5170:
5171: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5173: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5174: RAISE OKL_API.G_EXCEPTION_ERROR;
5175: END IF;
5176:
5177: END IF;

Line 5174: RAISE OKL_API.G_EXCEPTION_ERROR;

5170:
5171: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5173: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5174: RAISE OKL_API.G_EXCEPTION_ERROR;
5175: END IF;
5176:
5177: END IF;
5178:

Line 5189: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

5185: x_msg_data => x_msg_data,
5186: p_line_item_tbl => l_update_line_item_tbl,
5187: x_line_item_tbl => lx_line_item_tbl);
5188:
5189: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5190: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5191: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5192: RAISE OKL_API.G_EXCEPTION_ERROR;
5193: END IF;

Line 5190: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5186: p_line_item_tbl => l_update_line_item_tbl,
5187: x_line_item_tbl => lx_line_item_tbl);
5188:
5189: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5190: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5191: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5192: RAISE OKL_API.G_EXCEPTION_ERROR;
5193: END IF;
5194:

Line 5191: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

5187: x_line_item_tbl => lx_line_item_tbl);
5188:
5189: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5190: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5191: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5192: RAISE OKL_API.G_EXCEPTION_ERROR;
5193: END IF;
5194:
5195: END IF;

Line 5192: RAISE OKL_API.G_EXCEPTION_ERROR;

5188:
5189: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5190: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5191: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
5192: RAISE OKL_API.G_EXCEPTION_ERROR;
5193: END IF;
5194:
5195: END IF;
5196:

Line 5201: WHEN OKL_API.G_EXCEPTION_ERROR THEN

5197: END IF;
5198:
5199: EXCEPTION
5200:
5201: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5202:
5203: x_return_status := OKL_API.G_RET_STS_ERROR;
5204:
5205: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 5203: x_return_status := OKL_API.G_RET_STS_ERROR;

5199: EXCEPTION
5200:
5201: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5202:
5203: x_return_status := OKL_API.G_RET_STS_ERROR;
5204:
5205: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5206:
5207: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 5205: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5201: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5202:
5203: x_return_status := OKL_API.G_RET_STS_ERROR;
5204:
5205: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5206:
5207: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
5208:
5209: WHEN OTHERS THEN

Line 5207: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

5203: x_return_status := OKL_API.G_RET_STS_ERROR;
5204:
5205: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5206:
5207: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
5208:
5209: WHEN OTHERS THEN
5210:
5211: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 5211: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

5207: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
5208:
5209: WHEN OTHERS THEN
5210:
5211: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
5212:
5213: END create_update_link_assets;
5214: --Bug# 4899328
5215:

Line 5346: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

5342: x_return_status => x_return_status,
5343: x_msg_count => x_msg_count,
5344: x_msg_data => x_msg_data);
5345:
5346: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5348: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
5349: RAISE OKL_API.G_EXCEPTION_ERROR;
5350: END IF;

Line 5347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5343: x_msg_count => x_msg_count,
5344: x_msg_data => x_msg_data);
5345:
5346: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5348: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
5349: RAISE OKL_API.G_EXCEPTION_ERROR;
5350: END IF;
5351:

Line 5348: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

5344: x_msg_data => x_msg_data);
5345:
5346: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5348: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
5349: RAISE OKL_API.G_EXCEPTION_ERROR;
5350: END IF;
5351:
5352: END IF;

Line 5349: RAISE OKL_API.G_EXCEPTION_ERROR;

5345:
5346: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
5347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5348: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
5349: RAISE OKL_API.G_EXCEPTION_ERROR;
5350: END IF;
5351:
5352: END IF;
5353: --Bug# 4899328: End

Line 5474: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

5470: FROM okc_k_items_v
5471: WHERE cle_id = fee_line_id;
5472:
5473:
5474: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5475: l_api_name VARCHAR2(200) := 'process_rvi_stream';
5476:
5477: l_fee_types_rec fee_types_rec_type := p_fee_types_rec;
5478: l_line_id okc_k_lines_b.id%type;

Line 5531: x_return_status := OKL_API.G_RET_STS_SUCCESS;

5527: raise OKC_API.G_EXCEPTION_ERROR;
5528: End If;
5529:
5530: -- initialize return variables
5531: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5532: -- added for bug 4524091
5533:
5534: open get_k_details_csr (l_chr_id);
5535: fetch get_k_details_csr into l_start_date, l_end_date,l_orig_system_source_code,l_orig_chr_id;

Line 5541: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,

5537:
5538: --Bug# 8652738: Support of RVI T and C added during rebook
5539: /*if ((l_orig_system_source_code is not null) and (l_orig_system_source_code = 'OKL_REBOOK')) then
5540: -- not allowed to change RVI in T and C during rebook.
5541: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,
5542: p_msg_name => 'OKL_RVI_STRM_CANNOT_CHANGED');
5543: RAISE OKC_API.G_EXCEPTION_ERROR;
5544: end if;*/
5545: -- end 4524091

Line 5583: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,

5579: -- p_check_box_value1 := 'Y';
5580: if (l_check_box_val = 'Y') then
5581: if ((l_price_engine is not null) and (l_price_engine = 'INTERNAL' ))THEN
5582: -- not allowed for internal stream generation
5583: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,
5584: p_msg_name => 'OKL_LA_RVI_NO_ISG');
5585: RAISE OKC_API.G_EXCEPTION_ERROR;
5586: elsif ((l_price_engine is not null) and (l_price_engine = 'EXTERNAL' ))THEN
5587: -- it is external stream generation

Line 5590: if ((p_fee_types_rec.item_id1 is null) or (p_fee_types_rec.item_id1 = OKL_API.G_MISS_CHAR)) THEN

5586: elsif ((l_price_engine is not null) and (l_price_engine = 'EXTERNAL' ))THEN
5587: -- it is external stream generation
5588:
5589:
5590: if ((p_fee_types_rec.item_id1 is null) or (p_fee_types_rec.item_id1 = OKL_API.G_MISS_CHAR)) THEN
5591: -- throw error message stm name is manditory
5592: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,
5593: p_msg_name => 'OKL_RVI_STREAM_REQD');
5594: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 5592: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,

5588:
5589:
5590: if ((p_fee_types_rec.item_id1 is null) or (p_fee_types_rec.item_id1 = OKL_API.G_MISS_CHAR)) THEN
5591: -- throw error message stm name is manditory
5592: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,
5593: p_msg_name => 'OKL_RVI_STREAM_REQD');
5594: RAISE OKC_API.G_EXCEPTION_ERROR;
5595: end if;
5596:

Line 5597: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN

5593: p_msg_name => 'OKL_RVI_STREAM_REQD');
5594: RAISE OKC_API.G_EXCEPTION_ERROR;
5595: end if;
5596:
5597: if ((l_strm_id IS NOT NULL) AND (l_strm_id <> OKL_API.G_MISS_NUM)) THEN
5598:
5599: open get_okc_k_items_csr (l_fee_line_id);
5600: fetch get_okc_k_items_csr into l_cim_id;
5601: close get_okc_k_items_csr;

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

5625: p_fee_types_rec => l_fee_types_rec,
5626: x_fee_types_rec => x_fee_types_rec);
5627:
5628:
5629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
5632: RAISE OKC_API.G_EXCEPTION_ERROR;
5633: END IF;

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

5627:
5628:
5629: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5630: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
5631: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
5632: RAISE OKC_API.G_EXCEPTION_ERROR;
5633: END IF;
5634:
5635: ELSIF (p_fee_types_rec.item_id1 IS NOT NULL) THEN

Line 5680: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

5676: fetch get_rvi_check_value_csr into l_orig_check_box_value;
5677: close get_rvi_check_value_csr;
5678:
5679: IF (NVL(l_orig_check_box_value,'N') <> l_check_box_val) THEN
5680: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
5681: p_msg_name => 'OKL_LA_RVI_UPD_NOT_ALLOWED');
5682: RAISE OKC_API.G_EXCEPTION_ERROR;
5683: END IF;
5684:

Line 5714: elsif ((p_fee_types_rec.item_id1 IS NOT null) AND (p_fee_types_rec.item_id1 <> OKL_API.G_MISS_CHAR)) then

5710: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
5711: RAISE OKC_API.G_EXCEPTION_ERROR;
5712: END IF;
5713:
5714: elsif ((p_fee_types_rec.item_id1 IS NOT null) AND (p_fee_types_rec.item_id1 <> OKL_API.G_MISS_CHAR)) then
5715: -- throw error message check box has to be checkd
5716: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,
5717: p_msg_name => 'OKL_RVI_CHECK_BOX_REQD');
5718: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 5716: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,

5712: END IF;
5713:
5714: elsif ((p_fee_types_rec.item_id1 IS NOT null) AND (p_fee_types_rec.item_id1 <> OKL_API.G_MISS_CHAR)) then
5715: -- throw error message check box has to be checkd
5716: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,
5717: p_msg_name => 'OKL_RVI_CHECK_BOX_REQD');
5718: RAISE OKC_API.G_EXCEPTION_ERROR;
5719: end if;
5720:

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

5794: p_kpl_rec IN party_rec_type,
5795: x_kpl_rec OUT NOCOPY party_rec_type
5796: ) AS
5797:
5798: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5799: l_api_name CONSTANT varchar2(30) := 'create_party';
5800: l_api_version CONSTANT NUMBER := 1.0;
5801:
5802: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 5808: x_return_status := OKL_API.G_RET_STS_SUCCESS;

5804: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5805: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5806:
5807: Begin
5808: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5809: -- Call start_activity to create savepoint, check compatibility
5810: -- and initialize message list
5811: x_return_status := OKL_API.START_ACTIVITY (
5812: l_api_name

Line 5811: x_return_status := OKL_API.START_ACTIVITY (

5807: Begin
5808: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5809: -- Call start_activity to create savepoint, check compatibility
5810: -- and initialize message list
5811: x_return_status := OKL_API.START_ACTIVITY (
5812: l_api_name
5813: ,p_init_msg_list
5814: ,'_PVT'
5815: ,x_return_status);

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

5813: ,p_init_msg_list
5814: ,'_PVT'
5815: ,x_return_status);
5816: -- Check if activity started successfully
5817: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5819: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5820: RAISE OKL_API.G_EXCEPTION_ERROR;
5821: END IF;

Line 5818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5814: ,'_PVT'
5815: ,x_return_status);
5816: -- Check if activity started successfully
5817: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5819: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5820: RAISE OKL_API.G_EXCEPTION_ERROR;
5821: END IF;
5822:

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

5815: ,x_return_status);
5816: -- Check if activity started successfully
5817: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5819: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5820: RAISE OKL_API.G_EXCEPTION_ERROR;
5821: END IF;
5822:
5823: lp_cplv_rec.id := p_kpl_rec.id;

Line 5820: RAISE OKL_API.G_EXCEPTION_ERROR;

5816: -- Check if activity started successfully
5817: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5819: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5820: RAISE OKL_API.G_EXCEPTION_ERROR;
5821: END IF;
5822:
5823: lp_cplv_rec.id := p_kpl_rec.id;
5824: lp_cplv_rec.object1_id1 := p_kpl_rec.object1_id1;

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

5861: x_kplv_rec => lx_kplv_rec);
5862:
5863: x_kpl_rec.id := lx_cplv_rec.id;
5864:
5865: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5867: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5868: RAISE OKL_API.G_EXCEPTION_ERROR;
5869: END IF;

Line 5866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5862:
5863: x_kpl_rec.id := lx_cplv_rec.id;
5864:
5865: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5867: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5868: RAISE OKL_API.G_EXCEPTION_ERROR;
5869: END IF;
5870:

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

5863: x_kpl_rec.id := lx_cplv_rec.id;
5864:
5865: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5867: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5868: RAISE OKL_API.G_EXCEPTION_ERROR;
5869: END IF;
5870:
5871: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 5868: RAISE OKL_API.G_EXCEPTION_ERROR;

5864:
5865: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5867: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5868: RAISE OKL_API.G_EXCEPTION_ERROR;
5869: END IF;
5870:
5871: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
5872:

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

5867: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5868: RAISE OKL_API.G_EXCEPTION_ERROR;
5869: END IF;
5870:
5871: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
5872:
5873: EXCEPTION
5874: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5875: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 5874: WHEN OKL_API.G_EXCEPTION_ERROR THEN

5870:
5871: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
5872:
5873: EXCEPTION
5874: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5875: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5876: l_api_name,
5877: G_PKG_NAME,
5878: 'OKL_API.G_RET_STS_ERROR',

Line 5875: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

5871: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
5872:
5873: EXCEPTION
5874: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5875: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5876: l_api_name,
5877: G_PKG_NAME,
5878: 'OKL_API.G_RET_STS_ERROR',
5879: x_msg_count,

Line 5878: 'OKL_API.G_RET_STS_ERROR',

5874: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5875: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5876: l_api_name,
5877: G_PKG_NAME,
5878: 'OKL_API.G_RET_STS_ERROR',
5879: x_msg_count,
5880: x_msg_data,
5881: '_PVT');
5882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 5882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5878: 'OKL_API.G_RET_STS_ERROR',
5879: x_msg_count,
5880: x_msg_data,
5881: '_PVT');
5882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5883: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
5884: l_api_name,
5885: G_PKG_NAME,
5886: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 5883: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

5879: x_msg_count,
5880: x_msg_data,
5881: '_PVT');
5882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5883: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
5884: l_api_name,
5885: G_PKG_NAME,
5886: 'OKL_API.G_RET_STS_UNEXP_ERROR',
5887: x_msg_count,

Line 5886: 'OKL_API.G_RET_STS_UNEXP_ERROR',

5882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5883: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
5884: l_api_name,
5885: G_PKG_NAME,
5886: 'OKL_API.G_RET_STS_UNEXP_ERROR',
5887: x_msg_count,
5888: x_msg_data,
5889: '_PVT');
5890: WHEN OTHERS THEN

Line 5891: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

5887: x_msg_count,
5888: x_msg_data,
5889: '_PVT');
5890: WHEN OTHERS THEN
5891: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
5892: l_api_name,
5893: G_PKG_NAME,
5894: 'OTHERS',
5895: x_msg_count,

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

5907: p_kpl_rec IN party_rec_type,
5908: x_kpl_rec OUT NOCOPY party_rec_type
5909: ) AS
5910:
5911: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
5912: l_api_name CONSTANT varchar2(30) := 'update_party';
5913: l_api_version CONSTANT NUMBER := 1.0;
5914:
5915: lp_cplv_rec OKL_OKC_MIGRATION_PVT.cplv_rec_type;

Line 5921: x_return_status := OKL_API.G_RET_STS_SUCCESS;

5917: lp_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5918: lx_kplv_rec okl_k_party_roles_pvt.kplv_rec_type;
5919:
5920: Begin
5921: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5922: -- Call start_activity to create savepoint, check compatibility
5923: -- and initialize message list
5924: x_return_status := OKL_API.START_ACTIVITY (
5925: l_api_name

Line 5924: x_return_status := OKL_API.START_ACTIVITY (

5920: Begin
5921: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5922: -- Call start_activity to create savepoint, check compatibility
5923: -- and initialize message list
5924: x_return_status := OKL_API.START_ACTIVITY (
5925: l_api_name
5926: ,p_init_msg_list
5927: ,'_PVT'
5928: ,x_return_status);

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

5926: ,p_init_msg_list
5927: ,'_PVT'
5928: ,x_return_status);
5929: -- Check if activity started successfully
5930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5933: RAISE OKL_API.G_EXCEPTION_ERROR;
5934: END IF;

Line 5931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5927: ,'_PVT'
5928: ,x_return_status);
5929: -- Check if activity started successfully
5930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5933: RAISE OKL_API.G_EXCEPTION_ERROR;
5934: END IF;
5935:

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

5928: ,x_return_status);
5929: -- Check if activity started successfully
5930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5933: RAISE OKL_API.G_EXCEPTION_ERROR;
5934: END IF;
5935:
5936: lp_cplv_rec.id := p_kpl_rec.id;

Line 5933: RAISE OKL_API.G_EXCEPTION_ERROR;

5929: -- Check if activity started successfully
5930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5933: RAISE OKL_API.G_EXCEPTION_ERROR;
5934: END IF;
5935:
5936: lp_cplv_rec.id := p_kpl_rec.id;
5937: lp_cplv_rec.object1_id1 := p_kpl_rec.object1_id1;

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

5970:
5971:
5972: x_kpl_rec.id := lx_cplv_rec.id;
5973:
5974: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5977: RAISE OKL_API.G_EXCEPTION_ERROR;
5978: END IF;

Line 5975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5971:
5972: x_kpl_rec.id := lx_cplv_rec.id;
5973:
5974: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5977: RAISE OKL_API.G_EXCEPTION_ERROR;
5978: END IF;
5979:

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

5972: x_kpl_rec.id := lx_cplv_rec.id;
5973:
5974: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5977: RAISE OKL_API.G_EXCEPTION_ERROR;
5978: END IF;
5979:
5980: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );

Line 5977: RAISE OKL_API.G_EXCEPTION_ERROR;

5973:
5974: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5975: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5977: RAISE OKL_API.G_EXCEPTION_ERROR;
5978: END IF;
5979:
5980: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
5981:

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

5976: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5977: RAISE OKL_API.G_EXCEPTION_ERROR;
5978: END IF;
5979:
5980: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
5981:
5982: EXCEPTION
5983: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5984: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 5983: WHEN OKL_API.G_EXCEPTION_ERROR THEN

5979:
5980: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
5981:
5982: EXCEPTION
5983: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5984: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5985: l_api_name,
5986: G_PKG_NAME,
5987: 'OKL_API.G_RET_STS_ERROR',

Line 5984: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

5980: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
5981:
5982: EXCEPTION
5983: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5984: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5985: l_api_name,
5986: G_PKG_NAME,
5987: 'OKL_API.G_RET_STS_ERROR',
5988: x_msg_count,

Line 5987: 'OKL_API.G_RET_STS_ERROR',

5983: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5984: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5985: l_api_name,
5986: G_PKG_NAME,
5987: 'OKL_API.G_RET_STS_ERROR',
5988: x_msg_count,
5989: x_msg_data,
5990: '_PVT');
5991: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 5991: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5987: 'OKL_API.G_RET_STS_ERROR',
5988: x_msg_count,
5989: x_msg_data,
5990: '_PVT');
5991: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5992: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
5993: l_api_name,
5994: G_PKG_NAME,
5995: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 5992: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

5988: x_msg_count,
5989: x_msg_data,
5990: '_PVT');
5991: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5992: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
5993: l_api_name,
5994: G_PKG_NAME,
5995: 'OKL_API.G_RET_STS_UNEXP_ERROR',
5996: x_msg_count,

Line 5995: 'OKL_API.G_RET_STS_UNEXP_ERROR',

5991: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5992: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
5993: l_api_name,
5994: G_PKG_NAME,
5995: 'OKL_API.G_RET_STS_UNEXP_ERROR',
5996: x_msg_count,
5997: x_msg_data,
5998: '_PVT');
5999: WHEN OTHERS THEN

Line 6000: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

5996: x_msg_count,
5997: x_msg_data,
5998: '_PVT');
5999: WHEN OTHERS THEN
6000: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
6001: l_api_name,
6002: G_PKG_NAME,
6003: 'OTHERS',
6004: x_msg_count,