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

Line 27: IF ((p_rgpv_rec.rgd_code = OKL_API.G_MISS_CHAR) OR (p_rgpv_rec.rgd_code IS NULL)) THEN

23: AND id <> NVL(p_rgpv_rec.id,-1);
24:
25: BEGIN
26: -- Not null Validation for Terms and Conditions
27: IF ((p_rgpv_rec.rgd_code = OKL_API.G_MISS_CHAR) OR (p_rgpv_rec.rgd_code IS NULL)) THEN
28: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERMS_AND_COND_REQUIRED');
29: x_return_status :=okl_api.g_ret_sts_error;
30: RAISE OKL_API.G_EXCEPTION_ERROR;
31:

Line 28: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERMS_AND_COND_REQUIRED');

24:
25: BEGIN
26: -- Not null Validation for Terms and Conditions
27: IF ((p_rgpv_rec.rgd_code = OKL_API.G_MISS_CHAR) OR (p_rgpv_rec.rgd_code IS NULL)) THEN
28: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERMS_AND_COND_REQUIRED');
29: x_return_status :=okl_api.g_ret_sts_error;
30: RAISE OKL_API.G_EXCEPTION_ERROR;
31:
32: END IF;

Line 29: x_return_status :=okl_api.g_ret_sts_error;

25: BEGIN
26: -- Not null Validation for Terms and Conditions
27: IF ((p_rgpv_rec.rgd_code = OKL_API.G_MISS_CHAR) OR (p_rgpv_rec.rgd_code IS NULL)) THEN
28: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERMS_AND_COND_REQUIRED');
29: x_return_status :=okl_api.g_ret_sts_error;
30: RAISE OKL_API.G_EXCEPTION_ERROR;
31:
32: END IF;
33:

Line 30: RAISE OKL_API.G_EXCEPTION_ERROR;

26: -- Not null Validation for Terms and Conditions
27: IF ((p_rgpv_rec.rgd_code = OKL_API.G_MISS_CHAR) OR (p_rgpv_rec.rgd_code IS NULL)) THEN
28: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_TERMS_AND_COND_REQUIRED');
29: x_return_status :=okl_api.g_ret_sts_error;
30: RAISE OKL_API.G_EXCEPTION_ERROR;
31:
32: END IF;
33:
34: -- Same Terms and Condition can be attched only 1 time to the contract.

Line 51: RAISE OKL_API.G_EXCEPTION_ERROR;

47:
48: -- notify caller of an error
49: x_return_status := OKC_API.G_RET_STS_ERROR;
50: -- halt validation
51: RAISE OKL_API.G_EXCEPTION_ERROR;
52: END IF;
53: END IF;
54:
55: OKL_OKC_MIGRATION_A_PVT.insert_row(

Line 66: (p_rgpv_rec.dnz_chr_id <> OKL_API.G_MISS_NUM) THEN

62: x_rgpv_rec => x_rgpv_rec);
63:
64: -- Bug# 3477560
65: IF (p_rgpv_rec.dnz_chr_id is NOT NULL) AND
66: (p_rgpv_rec.dnz_chr_id <> OKL_API.G_MISS_NUM) THEN
67:
68: --cascade edit status on to lines
69: okl_contract_status_pub.cascade_lease_status_edit
70: (p_api_version => p_api_version,

Line 77: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

73: x_msg_count => x_msg_count,
74: x_msg_data => x_msg_data,
75: p_chr_id => p_rgpv_rec.dnz_chr_id);
76:
77: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
78: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
79: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
80: raise OKL_API.G_EXCEPTION_ERROR;
81: End If;

Line 78: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

74: x_msg_data => x_msg_data,
75: p_chr_id => p_rgpv_rec.dnz_chr_id);
76:
77: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
78: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
79: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
80: raise OKL_API.G_EXCEPTION_ERROR;
81: End If;
82: END IF;

Line 79: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

75: p_chr_id => p_rgpv_rec.dnz_chr_id);
76:
77: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
78: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
79: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
80: raise OKL_API.G_EXCEPTION_ERROR;
81: End If;
82: END IF;
83:

Line 80: raise OKL_API.G_EXCEPTION_ERROR;

76:
77: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
78: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
79: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
80: raise OKL_API.G_EXCEPTION_ERROR;
81: End If;
82: END IF;
83:
84: EXCEPTION

Line 85: WHEN OKL_API.G_EXCEPTION_ERROR THEN

81: End If;
82: END IF;
83:
84: EXCEPTION
85: WHEN OKL_API.G_EXCEPTION_ERROR THEN
86: x_return_status := OKC_API.G_RET_STS_ERROR;
87: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS
88: (p_api_name => l_api_name
89: ,p_pkg_name => G_PKG_NAME

Line 87: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS

83:
84: EXCEPTION
85: WHEN OKL_API.G_EXCEPTION_ERROR THEN
86: x_return_status := OKC_API.G_RET_STS_ERROR;
87: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS
88: (p_api_name => l_api_name
89: ,p_pkg_name => G_PKG_NAME
90: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
91: ,x_msg_count => x_msg_count

Line 90: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

86: x_return_status := OKC_API.G_RET_STS_ERROR;
87: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS
88: (p_api_name => l_api_name
89: ,p_pkg_name => G_PKG_NAME
90: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
91: ,x_msg_count => x_msg_count
92: ,x_msg_data => x_msg_data
93: ,p_api_type => '_PVT'
94: );

Line 141: -- equal to okl_api.g_miss_num

137: -- gboomina: bug fix for populating the mandatory fields that are
138: -- accidentally being nullified in the pl/sql wrapper of okl_vp_rule_pub_w
139: -- since these fields are not updatable in the ui, derive the values from the
140: -- database only when the passed in id ( rgp_id ) is not null and is also not
141: -- equal to okl_api.g_miss_num
142: -- START of code changes for bug 4723775
143: IF(p_rgpv_rec.id IS NOT NULL AND p_rgpv_rec.id <> OKL_API.G_MISS_NUM)THEN
144: OPEN csr_init_attr_column(p_rgpv_rec.id);
145: FETCH csr_init_attr_column INTO l_chr_id, l_dnz_chr_id, l_created_by, l_creation_date;

Line 143: IF(p_rgpv_rec.id IS NOT NULL AND p_rgpv_rec.id <> OKL_API.G_MISS_NUM)THEN

139: -- since these fields are not updatable in the ui, derive the values from the
140: -- database only when the passed in id ( rgp_id ) is not null and is also not
141: -- equal to okl_api.g_miss_num
142: -- START of code changes for bug 4723775
143: IF(p_rgpv_rec.id IS NOT NULL AND p_rgpv_rec.id <> OKL_API.G_MISS_NUM)THEN
144: OPEN csr_init_attr_column(p_rgpv_rec.id);
145: FETCH csr_init_attr_column INTO l_chr_id, l_dnz_chr_id, l_created_by, l_creation_date;
146: CLOSE csr_init_attr_column;
147:

Line 162: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

158: x_msg_data => x_msg_data,
159: p_rgpv_rec => l_rgpv_rec,
160: x_rgpv_rec => x_rgpv_rec);
161:
162: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
164: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
165: RAISE OKL_API.G_EXCEPTION_ERROR;
166: END IF;

Line 163: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

159: p_rgpv_rec => l_rgpv_rec,
160: x_rgpv_rec => x_rgpv_rec);
161:
162: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
164: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
165: RAISE OKL_API.G_EXCEPTION_ERROR;
166: END IF;
167: END IF;

Line 164: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

160: x_rgpv_rec => x_rgpv_rec);
161:
162: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
164: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
165: RAISE OKL_API.G_EXCEPTION_ERROR;
166: END IF;
167: END IF;
168: -- END of code changes for bug 4723775

Line 165: RAISE OKL_API.G_EXCEPTION_ERROR;

161:
162: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
164: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
165: RAISE OKL_API.G_EXCEPTION_ERROR;
166: END IF;
167: END IF;
168: -- END of code changes for bug 4723775
169:

Line 172: (x_rgpv_rec.dnz_chr_id <> OKL_API.G_MISS_NUM) THEN

168: -- END of code changes for bug 4723775
169:
170: -- Bug# 3477560
171: IF (x_rgpv_rec.dnz_chr_id is NOT NULL) AND
172: (x_rgpv_rec.dnz_chr_id <> OKL_API.G_MISS_NUM) THEN
173: --cascade edit status on to lines
174: okl_contract_status_pub.cascade_lease_status_edit
175: (p_api_version => p_api_version,
176: p_init_msg_list => p_init_msg_list,

Line 182: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

178: x_msg_count => x_msg_count,
179: x_msg_data => x_msg_data,
180: p_chr_id => x_rgpv_rec.dnz_chr_id);
181:
182: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
183: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
185: raise OKL_API.G_EXCEPTION_ERROR;
186: End If;

Line 183: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

179: x_msg_data => x_msg_data,
180: p_chr_id => x_rgpv_rec.dnz_chr_id);
181:
182: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
183: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
185: raise OKL_API.G_EXCEPTION_ERROR;
186: End If;
187: END IF;

Line 184: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

180: p_chr_id => x_rgpv_rec.dnz_chr_id);
181:
182: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
183: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
185: raise OKL_API.G_EXCEPTION_ERROR;
186: End If;
187: END IF;
188:

Line 185: raise OKL_API.G_EXCEPTION_ERROR;

181:
182: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
183: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
185: raise OKL_API.G_EXCEPTION_ERROR;
186: End If;
187: END IF;
188:
189: EXCEPTION

Line 190: WHEN OKL_API.G_EXCEPTION_ERROR THEN

186: End If;
187: END IF;
188:
189: EXCEPTION
190: WHEN OKL_API.G_EXCEPTION_ERROR THEN
191: x_return_status := OKC_API.G_RET_STS_ERROR;
192:
193: WHEN OTHERS THEN
194: -- store SQL error message on message stack

Line 241: (ln_chr_id <> OKL_API.G_MISS_NUM) THEN

237: p_rgpv_rec => p_rgpv_rec);
238:
239: -- Bug# 3477560
240: IF (ln_chr_id is NOT NULL) AND
241: (ln_chr_id <> OKL_API.G_MISS_NUM) THEN
242:
243: --cascade edit status on to lines
244: okl_contract_status_pub.cascade_lease_status_edit
245: (p_api_version => p_api_version,

Line 252: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

248: x_msg_count => x_msg_count,
249: x_msg_data => x_msg_data,
250: p_chr_id => ln_chr_id);
251:
252: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
254: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
255: raise OKL_API.G_EXCEPTION_ERROR;
256: End If;

Line 253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

249: x_msg_data => x_msg_data,
250: p_chr_id => ln_chr_id);
251:
252: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
254: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
255: raise OKL_API.G_EXCEPTION_ERROR;
256: End If;
257: END IF;

Line 254: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

250: p_chr_id => ln_chr_id);
251:
252: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
254: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
255: raise OKL_API.G_EXCEPTION_ERROR;
256: End If;
257: END IF;
258:

Line 255: raise OKL_API.G_EXCEPTION_ERROR;

251:
252: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
253: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
254: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
255: raise OKL_API.G_EXCEPTION_ERROR;
256: End If;
257: END IF;
258:
259: EXCEPTION

Line 268: WHEN OKL_API.G_EXCEPTION_ERROR THEN

264: p_msg_name => G_CANNOT_DELETE_MASTER);
265: -- notify caller of an error
266: x_return_status := OKC_API.G_RET_STS_ERROR;
267:
268: WHEN OKL_API.G_EXCEPTION_ERROR THEN
269: x_return_status := OKC_API.G_RET_STS_ERROR;
270:
271: WHEN OTHERS THEN
272: -- store SQL error message on message stack