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

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

48: AND id <> p_lpov_rec.id;
49:
50:
51: l_name OKL_LATE_POLICIES_V.NAME%TYPE;
52: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
53: BEGIN
54:
55: -- Check if value passed for id
56: IF (p_lpov_rec.id IS NOT NULL AND p_lpov_rec.id <> OKC_API.G_MISS_NUM) THEN

Line 63: OKL_API.SET_MESSAGE( p_app_name => 'OKL'

59: FETCH okl_name_csr INTO l_name;
60:
61: -- id already exists, so update mode
62: IF okl_name_csr%FOUND THEN
63: OKL_API.SET_MESSAGE( p_app_name => 'OKL'
64: ,p_msg_name => 'OKL_LLA_NOT_UNIQUE'
65: ,p_token1 => 'COL_NAME'
66: ,p_token1_value => 'Late Policy Name');
67:

Line 85: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

81: IF okl_name_csr%ISOPEN THEN
82: CLOSE okl_name_csr;
83: END IF;
84:
85: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
86: ,p_msg_name => G_UNEXPECTED_ERROR
87: ,p_token1 => G_SQLCODE_TOKEN
88: ,p_token1_value => SQLCODE
89: ,p_token2 => G_SQLERRM_TOKEN

Line 91: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

87: ,p_token1 => G_SQLCODE_TOKEN
88: ,p_token1_value => SQLCODE
89: ,p_token2 => G_SQLERRM_TOKEN
90: ,p_token2_value => SQLERRM);
91: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
92: END is_unique;
93:
94: ---------------------------------------------------------------------------
95: -- PROCEDURE add_language

Line 697: IF p_lpov_rec.id = Okl_Api.G_MISS_NUM OR

693: -----------------------------
694: -- ***
695: -- id
696: -- ** Hand Coded*
697: IF p_lpov_rec.id = Okl_Api.G_MISS_NUM OR
698: p_lpov_rec.id IS NULL THEN
699: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
700: x_return_status := Okl_Api.G_RET_STS_ERROR;
701: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 699: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

695: -- id
696: -- ** Hand Coded*
697: IF p_lpov_rec.id = Okl_Api.G_MISS_NUM OR
698: p_lpov_rec.id IS NULL THEN
699: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
700: x_return_status := Okl_Api.G_RET_STS_ERROR;
701: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
702: l_return_status := x_return_status;
703: END IF;

Line 700: x_return_status := Okl_Api.G_RET_STS_ERROR;

696: -- ** Hand Coded*
697: IF p_lpov_rec.id = Okl_Api.G_MISS_NUM OR
698: p_lpov_rec.id IS NULL THEN
699: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
700: x_return_status := Okl_Api.G_RET_STS_ERROR;
701: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
702: l_return_status := x_return_status;
703: END IF;
704: -- ***

Line 701: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

697: IF p_lpov_rec.id = Okl_Api.G_MISS_NUM OR
698: p_lpov_rec.id IS NULL THEN
699: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
700: x_return_status := Okl_Api.G_RET_STS_ERROR;
701: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
702: l_return_status := x_return_status;
703: END IF;
704: -- ***
705: -- name

Line 707: ELSIF p_lpov_rec.name = Okl_Api.G_MISS_CHAR OR

703: END IF;
704: -- ***
705: -- name
706: -- ***
707: ELSIF p_lpov_rec.name = Okl_Api.G_MISS_CHAR OR
708: p_lpov_rec.name IS NULL THEN
709: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
710: x_return_status := Okl_Api.G_RET_STS_ERROR;
711: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 709: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');

705: -- name
706: -- ***
707: ELSIF p_lpov_rec.name = Okl_Api.G_MISS_CHAR OR
708: p_lpov_rec.name IS NULL THEN
709: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
710: x_return_status := Okl_Api.G_RET_STS_ERROR;
711: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
712: l_return_status := x_return_status;
713: END IF;

Line 710: x_return_status := Okl_Api.G_RET_STS_ERROR;

706: -- ***
707: ELSIF p_lpov_rec.name = Okl_Api.G_MISS_CHAR OR
708: p_lpov_rec.name IS NULL THEN
709: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
710: x_return_status := Okl_Api.G_RET_STS_ERROR;
711: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
712: l_return_status := x_return_status;
713: END IF;
714:

Line 711: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

707: ELSIF p_lpov_rec.name = Okl_Api.G_MISS_CHAR OR
708: p_lpov_rec.name IS NULL THEN
709: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
710: x_return_status := Okl_Api.G_RET_STS_ERROR;
711: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
712: l_return_status := x_return_status;
713: END IF;
714:
715: -- ***

Line 718: ELSIF p_lpov_rec.ise_id = Okl_Api.G_MISS_NUM OR

714:
715: -- ***
716: -- ise_id
717: -- ***
718: ELSIF p_lpov_rec.ise_id = Okl_Api.G_MISS_NUM OR
719: p_lpov_rec.ise_id IS NULL THEN
720: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ise_id');
721: x_return_status := Okl_Api.G_RET_STS_ERROR;
722: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 720: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ise_id');

716: -- ise_id
717: -- ***
718: ELSIF p_lpov_rec.ise_id = Okl_Api.G_MISS_NUM OR
719: p_lpov_rec.ise_id IS NULL THEN
720: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ise_id');
721: x_return_status := Okl_Api.G_RET_STS_ERROR;
722: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
723: l_return_status := x_return_status;
724: END IF;

Line 721: x_return_status := Okl_Api.G_RET_STS_ERROR;

717: -- ***
718: ELSIF p_lpov_rec.ise_id = Okl_Api.G_MISS_NUM OR
719: p_lpov_rec.ise_id IS NULL THEN
720: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ise_id');
721: x_return_status := Okl_Api.G_RET_STS_ERROR;
722: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
723: l_return_status := x_return_status;
724: END IF;
725: -- ***

Line 722: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

718: ELSIF p_lpov_rec.ise_id = Okl_Api.G_MISS_NUM OR
719: p_lpov_rec.ise_id IS NULL THEN
720: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'ise_id');
721: x_return_status := Okl_Api.G_RET_STS_ERROR;
722: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
723: l_return_status := x_return_status;
724: END IF;
725: -- ***
726: -- late_policy_type_code

Line 728: ELSIF p_lpov_rec.late_policy_type_code = Okl_Api.G_MISS_CHAR OR

724: END IF;
725: -- ***
726: -- late_policy_type_code
727: -- ***
728: ELSIF p_lpov_rec.late_policy_type_code = Okl_Api.G_MISS_CHAR OR
729: p_lpov_rec.late_policy_type_code IS NULL THEN
730: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_type_code');
731: x_return_status := Okl_Api.G_RET_STS_ERROR;
732: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 730: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_type_code');

726: -- late_policy_type_code
727: -- ***
728: ELSIF p_lpov_rec.late_policy_type_code = Okl_Api.G_MISS_CHAR OR
729: p_lpov_rec.late_policy_type_code IS NULL THEN
730: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_type_code');
731: x_return_status := Okl_Api.G_RET_STS_ERROR;
732: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
733: l_return_status := x_return_status;
734: END IF;

Line 731: x_return_status := Okl_Api.G_RET_STS_ERROR;

727: -- ***
728: ELSIF p_lpov_rec.late_policy_type_code = Okl_Api.G_MISS_CHAR OR
729: p_lpov_rec.late_policy_type_code IS NULL THEN
730: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_type_code');
731: x_return_status := Okl_Api.G_RET_STS_ERROR;
732: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
733: l_return_status := x_return_status;
734: END IF;
735: -- ***

Line 732: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

728: ELSIF p_lpov_rec.late_policy_type_code = Okl_Api.G_MISS_CHAR OR
729: p_lpov_rec.late_policy_type_code IS NULL THEN
730: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'late_policy_type_code');
731: x_return_status := Okl_Api.G_RET_STS_ERROR;
732: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
733: l_return_status := x_return_status;
734: END IF;
735: -- ***
736: -- object_version_number

Line 738: ELSIF p_lpov_rec.object_version_number = Okl_Api.G_MISS_NUM OR

734: END IF;
735: -- ***
736: -- object_version_number
737: -- ***
738: ELSIF p_lpov_rec.object_version_number = Okl_Api.G_MISS_NUM OR
739: p_lpov_rec.object_version_number IS NULL THEN
740: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
741: x_return_status := Okl_Api.G_RET_STS_ERROR;
742: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 740: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

736: -- object_version_number
737: -- ***
738: ELSIF p_lpov_rec.object_version_number = Okl_Api.G_MISS_NUM OR
739: p_lpov_rec.object_version_number IS NULL THEN
740: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
741: x_return_status := Okl_Api.G_RET_STS_ERROR;
742: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
743: l_return_status := x_return_status;
744: END IF;

Line 741: x_return_status := Okl_Api.G_RET_STS_ERROR;

737: -- ***
738: ELSIF p_lpov_rec.object_version_number = Okl_Api.G_MISS_NUM OR
739: p_lpov_rec.object_version_number IS NULL THEN
740: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
741: x_return_status := Okl_Api.G_RET_STS_ERROR;
742: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
743: l_return_status := x_return_status;
744: END IF;
745: END IF;

Line 742: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

738: ELSIF p_lpov_rec.object_version_number = Okl_Api.G_MISS_NUM OR
739: p_lpov_rec.object_version_number IS NULL THEN
740: Okl_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
741: x_return_status := Okl_Api.G_RET_STS_ERROR;
742: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
743: l_return_status := x_return_status;
744: END IF;
745: END IF;
746: RETURN(l_return_status);

Line 768: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

764: -- Validate Record for:OKL_LATE_POLICIES_V --
765: ---------------------------------------------
766: FUNCTION Validate_Record (p_lpov_rec IN lpov_rec_type)
767: RETURN VARCHAR2 IS
768: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
769: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
770: BEGIN
771: -- check uniqueness
772: is_unique(l_return_status, p_lpov_rec);

Line 769: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

765: ---------------------------------------------
766: FUNCTION Validate_Record (p_lpov_rec IN lpov_rec_type)
767: RETURN VARCHAR2 IS
768: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
769: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
770: BEGIN
771: -- check uniqueness
772: is_unique(l_return_status, p_lpov_rec);
773:

Line 775: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

771: -- check uniqueness
772: is_unique(l_return_status, p_lpov_rec);
773:
774: -- store the highest degree of error
775: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
776: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
777: x_return_status := l_return_status;
778: END IF;
779: END IF;

Line 776: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

772: is_unique(l_return_status, p_lpov_rec);
773:
774: -- store the highest degree of error
775: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
776: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
777: x_return_status := l_return_status;
778: END IF;
779: END IF;
780:

Line 786: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME

782: EXCEPTION
783: WHEN G_EXCEPTION_HALT_VALIDATION THEN
784: RETURN(l_return_status);
785: WHEN OTHERS THEN
786: Okl_Api.SET_MESSAGE( p_app_name => G_APP_NAME
787: ,p_msg_name => G_UNEXPECTED_ERROR
788: ,p_token1 => G_SQLCODE_TOKEN
789: ,p_token1_value => SQLCODE
790: ,p_token2 => G_SQLERRM_TOKEN

Line 792: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

788: ,p_token1 => G_SQLCODE_TOKEN
789: ,p_token1_value => SQLCODE
790: ,p_token2 => G_SQLERRM_TOKEN
791: ,p_token2_value => SQLERRM);
792: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
793: RETURN(l_return_status);
794: END Validate_Record;
795:
796: ---------------------------------------------------------------------------

Line 2523: IF (x_lpov_rec.object_version_number = Okl_Api.G_MISS_NUM)

2519: IF (x_lpov_rec.org_id = Okc_Api.G_MISS_NUM)
2520: THEN
2521: x_lpov_rec.org_id := l_db_lpov_rec.org_id;
2522: END IF;
2523: IF (x_lpov_rec.object_version_number = Okl_Api.G_MISS_NUM)
2524: THEN
2525: x_lpov_rec.object_version_number := l_db_lpov_rec.object_version_number;
2526: END IF;
2527: IF (x_lpov_rec.name = Okc_Api.G_MISS_CHAR)