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

Line 154: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

150: --------------------------------------------------------------------------------
151: --local procedure to create selected option values
152: --------------------------------------------------------------------------------
153: Procedure create_slctd_popv(p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_khr_id IN NUMBER,

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

157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_khr_id IN NUMBER,
159: p_pov_id IN NUMBER
160: ) IS
161: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
162: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SLCTD_POPV';
163: l_api_version CONSTANT NUMBER := 1.0;
164:
165: l_cspv_rec OKL_CONTRACT_PROD_OPTNS_PUB.cspv_rec_type;

Line 169: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

165: l_cspv_rec OKL_CONTRACT_PROD_OPTNS_PUB.cspv_rec_type;
166: l_cspv_rec_out OKL_CONTRACT_PROD_OPTNS_PUB.cspv_rec_type;
167: Begin
168: --call start activity to set savepoint
169: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
170: p_init_msg_list,
171: '_PVT',
172: x_return_status);
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

169: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
170: p_init_msg_list,
171: '_PVT',
172: x_return_status);
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_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: p_init_msg_list,
171: '_PVT',
172: x_return_status);
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
178:

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

171: '_PVT',
172: x_return_status);
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
178:
179: --call selected options create api

Line 176: RAISE OKL_API.G_EXCEPTION_ERROR;

172: x_return_status);
173: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
174: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
175: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
176: RAISE OKL_API.G_EXCEPTION_ERROR;
177: END IF;
178:
179: --call selected options create api
180: l_cspv_rec.khr_id := p_khr_id;

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

188: x_msg_data => x_msg_data,
189: p_cspv_rec => l_cspv_rec,
190: x_cspv_rec => l_cspv_rec_out);
191:
192: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
195: RAISE OKL_API.G_EXCEPTION_ERROR;
196: END IF;

Line 193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

189: p_cspv_rec => l_cspv_rec,
190: x_cspv_rec => l_cspv_rec_out);
191:
192: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
195: RAISE OKL_API.G_EXCEPTION_ERROR;
196: END IF;
197:

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

190: x_cspv_rec => l_cspv_rec_out);
191:
192: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
195: RAISE OKL_API.G_EXCEPTION_ERROR;
196: END IF;
197:
198: -- Bug# 3477560

Line 195: RAISE OKL_API.G_EXCEPTION_ERROR;

191:
192: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
193: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
194: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
195: RAISE OKL_API.G_EXCEPTION_ERROR;
196: END IF;
197:
198: -- Bug# 3477560
199: --cascade edit status on to lines

Line 208: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data,
206: p_chr_id => p_khr_id);
207:
208: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
209: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
210: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
211: raise OKL_API.G_EXCEPTION_ERROR;
212: End If;

Line 209: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

205: x_msg_data => x_msg_data,
206: p_chr_id => p_khr_id);
207:
208: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
209: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
210: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
211: raise OKL_API.G_EXCEPTION_ERROR;
212: End If;
213:

Line 210: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

206: p_chr_id => p_khr_id);
207:
208: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
209: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
210: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
211: raise OKL_API.G_EXCEPTION_ERROR;
212: End If;
213:
214: --Call end Activity

Line 211: raise OKL_API.G_EXCEPTION_ERROR;

207:
208: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
209: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
210: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
211: raise OKL_API.G_EXCEPTION_ERROR;
212: End If;
213:
214: --Call end Activity
215: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

211: raise OKL_API.G_EXCEPTION_ERROR;
212: End If;
213:
214: --Call end Activity
215: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
216:
217: EXCEPTION
218: When OKL_API.G_EXCEPTION_ERROR Then
219: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

Line 218: When OKL_API.G_EXCEPTION_ERROR Then

214: --Call end Activity
215: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
216:
217: EXCEPTION
218: When OKL_API.G_EXCEPTION_ERROR Then
219: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
220: (
221: l_api_name,
222: G_PKG_NAME,

Line 219: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

215: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
216:
217: EXCEPTION
218: When OKL_API.G_EXCEPTION_ERROR Then
219: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
220: (
221: l_api_name,
222: G_PKG_NAME,
223: 'OKL_API.G_RET_STS_ERROR',

Line 223: 'OKL_API.G_RET_STS_ERROR',

219: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
220: (
221: l_api_name,
222: G_PKG_NAME,
223: 'OKL_API.G_RET_STS_ERROR',
224: x_msg_count,
225: x_msg_data,
226: '_PVT'
227: );

Line 228: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

224: x_msg_count,
225: x_msg_data,
226: '_PVT'
227: );
228: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
229: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
230: (
231: l_api_name,
232: G_PKG_NAME,

Line 229: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

225: x_msg_data,
226: '_PVT'
227: );
228: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
229: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
230: (
231: l_api_name,
232: G_PKG_NAME,
233: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 233: 'OKL_API.G_RET_STS_UNEXP_ERROR',

229: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
230: (
231: l_api_name,
232: G_PKG_NAME,
233: 'OKL_API.G_RET_STS_UNEXP_ERROR',
234: x_msg_count,
235: x_msg_data,
236: '_PVT'
237: );

Line 239: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

235: x_msg_data,
236: '_PVT'
237: );
238: WHEN OTHERS THEN
239: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
240: (
241: l_api_name,
242: G_PKG_NAME,
243: 'OTHERS',

Line 253: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

249: --------------------------------------------------------------------------------
250: --local api to copy the rule to contract header
251: --------------------------------------------------------------------------------
252: procedure chk_and_cpy_rul_hdr(p_api_version IN NUMBER,
253: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_khr_id IN NUMBER,

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

259: p_rgd_code IN OKL_OPT_RULES.rgr_rgd_code%TYPE,
260: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
261: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
262:
263: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
264: l_api_name CONSTANT VARCHAR2(30) := 'CHK_AND_CPY_RUL_HDR';
265: l_api_version CONSTANT NUMBER := 1.0;
266:
267: --cursor to ceck if rule group is already attched at the k hdr level

Line 296: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

292: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;
293:
294: Begin
295: --call start activity to set savepoint
296: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
297: p_init_msg_list,
298: '_PVT',
299: x_return_status);
300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

296: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
297: p_init_msg_list,
298: '_PVT',
299: x_return_status);
300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;

Line 301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

297: p_init_msg_list,
298: '_PVT',
299: x_return_status);
300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305: --check if rule group is already there on contract header

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

298: '_PVT',
299: x_return_status);
300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305: --check if rule group is already there on contract header
306: l_rgp_id := Null;

Line 303: RAISE OKL_API.G_EXCEPTION_ERROR;

299: x_return_status);
300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305: --check if rule group is already there on contract header
306: l_rgp_id := Null;
307: Open chk_rgp_csr (p_khr_id => p_khr_id,

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

322: x_msg_data => x_msg_count,
323: p_rgpv_rec => l_rgpv_rec,
324: x_rgpv_rec => l_rgpv_rec_out);
325:
326: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
329: RAISE OKL_API.G_EXCEPTION_ERROR;
330: END IF;

Line 327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

323: p_rgpv_rec => l_rgpv_rec,
324: x_rgpv_rec => l_rgpv_rec_out);
325:
326: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
329: RAISE OKL_API.G_EXCEPTION_ERROR;
330: END IF;
331:

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

324: x_rgpv_rec => l_rgpv_rec_out);
325:
326: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
329: RAISE OKL_API.G_EXCEPTION_ERROR;
330: END IF;
331:
332: --create rule

Line 329: RAISE OKL_API.G_EXCEPTION_ERROR;

325:
326: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
329: RAISE OKL_API.G_EXCEPTION_ERROR;
330: END IF;
331:
332: --create rule
333: l_rulv_rec := p_rulv_rec;

Line 335: l_rulv_rec.id := OKL_API.G_MISS_NUM; -- so that new id could be generated

331:
332: --create rule
333: l_rulv_rec := p_rulv_rec;
334:
335: l_rulv_rec.id := OKL_API.G_MISS_NUM; -- so that new id could be generated
336: l_rulv_rec.rgp_id := l_rgpv_rec_out.id;
337: l_rulv_rec.template_yn := Null; --this rule will no longer be template
338: l_rulv_rec.dnz_chr_id := p_khr_id;
339: l_rulv_rec.std_template_yn := 'N';

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

347: x_rulv_rec => l_rulv_rec_out);
348:
349: --dbms_output.put_line('rule created'||to_char(l_rulv_rec_out.id));
350:
351: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;

Line 352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

348:
349: --dbms_output.put_line('rule created'||to_char(l_rulv_rec_out.id));
350:
351: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;
356:

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

349: --dbms_output.put_line('rule created'||to_char(l_rulv_rec_out.id));
350:
351: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;
356:
357: Else

Line 354: RAISE OKL_API.G_EXCEPTION_ERROR;

350:
351: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;
356:
357: Else
358: --do not copy the rule group

Line 370: l_rulv_rec.id := OKL_API.G_MISS_NUM; -- so that new id could be generated

366: --create rule record
367: --create rule
368: l_rulv_rec := p_rulv_rec;
369:
370: l_rulv_rec.id := OKL_API.G_MISS_NUM; -- so that new id could be generated
371: l_rulv_rec.rgp_id := l_rgp_id;
372: l_rulv_rec.template_yn := Null; --this rule will no longer be template
373: l_rulv_rec.dnz_chr_id := p_khr_id;
374: l_rulv_rec.std_template_yn := 'N';

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

381: x_msg_data => x_msg_data,
382: p_rulv_rec => l_rulv_rec,
383: x_rulv_rec => l_rulv_rec_out);
384:
385: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
387: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;

Line 386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

382: p_rulv_rec => l_rulv_rec,
383: x_rulv_rec => l_rulv_rec_out);
384:
385: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
387: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;
390:

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

383: x_rulv_rec => l_rulv_rec_out);
384:
385: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
387: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;
390:
391: Else

Line 388: RAISE OKL_API.G_EXCEPTION_ERROR;

384:
385: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
386: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
387: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;
390:
391: Else
392: --rule record exists

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

397: End If;
398: close chk_rgp_csr;
399:
400: --Call end Activity
401: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
402:
403: EXCEPTION
404: When OKL_API.G_EXCEPTION_ERROR Then
405: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

Line 404: When OKL_API.G_EXCEPTION_ERROR Then

400: --Call end Activity
401: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
402:
403: EXCEPTION
404: When OKL_API.G_EXCEPTION_ERROR Then
405: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
406: (
407: l_api_name,
408: G_PKG_NAME,

Line 405: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

401: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
402:
403: EXCEPTION
404: When OKL_API.G_EXCEPTION_ERROR Then
405: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
406: (
407: l_api_name,
408: G_PKG_NAME,
409: 'OKL_API.G_RET_STS_ERROR',

Line 409: 'OKL_API.G_RET_STS_ERROR',

405: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
406: (
407: l_api_name,
408: G_PKG_NAME,
409: 'OKL_API.G_RET_STS_ERROR',
410: x_msg_count,
411: x_msg_data,
412: '_PVT'
413: );

Line 414: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

410: x_msg_count,
411: x_msg_data,
412: '_PVT'
413: );
414: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
415: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
416: (
417: l_api_name,
418: G_PKG_NAME,

Line 415: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

411: x_msg_data,
412: '_PVT'
413: );
414: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
415: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
416: (
417: l_api_name,
418: G_PKG_NAME,
419: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 419: 'OKL_API.G_RET_STS_UNEXP_ERROR',

415: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
416: (
417: l_api_name,
418: G_PKG_NAME,
419: 'OKL_API.G_RET_STS_UNEXP_ERROR',
420: x_msg_count,
421: x_msg_data,
422: '_PVT'
423: );

Line 425: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

421: x_msg_data,
422: '_PVT'
423: );
424: WHEN OTHERS THEN
425: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
426: (
427: l_api_name,
428: G_PKG_NAME,
429: 'OTHERS',

Line 439: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

435: --------------------------------------------------------------------------------
436: --local api to copy the rule to contract line
437: --------------------------------------------------------------------------------
438: procedure chk_and_cpy_rul_line(p_api_version IN NUMBER,
439: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
440: x_return_status OUT NOCOPY VARCHAR2,
441: x_msg_count OUT NOCOPY NUMBER,
442: x_msg_data OUT NOCOPY VARCHAR2,
443: p_khr_id IN NUMBER,

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

446: p_rdf_code IN OKL_OPT_RULES.rgr_rdf_code%TYPE,
447: p_lse_id IN OKL_OPT_RULES.lrg_lse_id%TYPE,
448: p_copy_or_enter_flag IN OKL_OPV_RULES.copy_or_enter_flag%TYPE) IS
449:
450: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
451: l_api_name CONSTANT VARCHAR2(30) := 'CHK_AND_CPY_RUL_LINE';
452: l_api_version CONSTANT NUMBER := 1.0;
453:
454: --cursor to check if there is a lse_id line for k

Line 500: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

496: l_rulv_rec_out OKC_RULE_PUB.rulv_rec_type;
497:
498: Begin
499: --call start activity to set savepoint
500: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
501: p_init_msg_list,
502: '_PVT',
503: x_return_status);
504: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

500: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
501: p_init_msg_list,
502: '_PVT',
503: x_return_status);
504: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;

Line 505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

501: p_init_msg_list,
502: '_PVT',
503: x_return_status);
504: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509: --check if eligble to modify line of lse lse_id exists on k hdt

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

502: '_PVT',
503: x_return_status);
504: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509: --check if eligble to modify line of lse lse_id exists on k hdt
510: l_kle_id := Null;

Line 507: RAISE OKL_API.G_EXCEPTION_ERROR;

503: x_return_status);
504: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
507: RAISE OKL_API.G_EXCEPTION_ERROR;
508: END IF;
509: --check if eligble to modify line of lse lse_id exists on k hdt
510: l_kle_id := Null;
511: Open chk_lse_csr (p_khr_id => p_khr_id,

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

537: x_msg_data => x_msg_count,
538: p_rgpv_rec => l_rgpv_rec,
539: x_rgpv_rec => l_rgpv_rec_out);
540:
541: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
542: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
543: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
544: RAISE OKL_API.G_EXCEPTION_ERROR;
545: END IF;

Line 542: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

538: p_rgpv_rec => l_rgpv_rec,
539: x_rgpv_rec => l_rgpv_rec_out);
540:
541: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
542: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
543: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
544: RAISE OKL_API.G_EXCEPTION_ERROR;
545: END IF;
546:

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

539: x_rgpv_rec => l_rgpv_rec_out);
540:
541: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
542: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
543: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
544: RAISE OKL_API.G_EXCEPTION_ERROR;
545: END IF;
546:
547: --create rule

Line 544: RAISE OKL_API.G_EXCEPTION_ERROR;

540:
541: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
542: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
543: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
544: RAISE OKL_API.G_EXCEPTION_ERROR;
545: END IF;
546:
547: --create rule
548: l_rulv_rec := p_rulv_rec;

Line 550: l_rulv_rec.id := OKL_API.G_MISS_NUM; -- so that new id could be generated

546:
547: --create rule
548: l_rulv_rec := p_rulv_rec;
549:
550: l_rulv_rec.id := OKL_API.G_MISS_NUM; -- so that new id could be generated
551: l_rulv_rec.rgp_id := l_rgpv_rec_out.id;
552: l_rulv_rec.template_yn := Null; --this rule will no longer be template
553: l_rulv_rec.dnz_chr_id := p_khr_id;
554: l_rulv_rec.std_template_yn := 'N';

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

561: x_msg_data => x_msg_data,
562: p_rulv_rec => l_rulv_rec,
563: x_rulv_rec => l_rulv_rec_out);
564:
565: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
568: RAISE OKL_API.G_EXCEPTION_ERROR;
569: END IF;

Line 566: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

562: p_rulv_rec => l_rulv_rec,
563: x_rulv_rec => l_rulv_rec_out);
564:
565: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
568: RAISE OKL_API.G_EXCEPTION_ERROR;
569: END IF;
570:

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

563: x_rulv_rec => l_rulv_rec_out);
564:
565: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
568: RAISE OKL_API.G_EXCEPTION_ERROR;
569: END IF;
570:
571: Else

Line 568: RAISE OKL_API.G_EXCEPTION_ERROR;

564:
565: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
568: RAISE OKL_API.G_EXCEPTION_ERROR;
569: END IF;
570:
571: Else
572: --do not copy the rule group

Line 584: l_rulv_rec.id := OKL_API.G_MISS_NUM; -- so that new id could be generated

580: --create rule record
581: --create rule
582: l_rulv_rec := p_rulv_rec;
583:
584: l_rulv_rec.id := OKL_API.G_MISS_NUM; -- so that new id could be generated
585: l_rulv_rec.rgp_id := l_rgp_id;
586: l_rulv_rec.template_yn := Null; --this rule will no longer be template
587: l_rulv_rec.dnz_chr_id := p_khr_id;
588: l_rulv_rec.std_template_yn := 'N';

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

595: x_msg_data => x_msg_data,
596: p_rulv_rec => l_rulv_rec,
597: x_rulv_rec => l_rulv_rec_out);
598:
599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_ERROR;
603: END IF;

Line 600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

596: p_rulv_rec => l_rulv_rec,
597: x_rulv_rec => l_rulv_rec_out);
598:
599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_ERROR;
603: END IF;
604:

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

597: x_rulv_rec => l_rulv_rec_out);
598:
599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_ERROR;
603: END IF;
604:
605: Else

Line 602: RAISE OKL_API.G_EXCEPTION_ERROR;

598:
599: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
600: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
601: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_ERROR;
603: END IF;
604:
605: Else
606: --rule record exists

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

612: close chk_rgp_csr;
613: End If;
614: Close chk_lse_csr;
615: --Call end Activity
616: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
617:
618: EXCEPTION
619: When OKL_API.G_EXCEPTION_ERROR Then
620: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

Line 619: When OKL_API.G_EXCEPTION_ERROR Then

615: --Call end Activity
616: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
617:
618: EXCEPTION
619: When OKL_API.G_EXCEPTION_ERROR Then
620: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
621: (
622: l_api_name,
623: G_PKG_NAME,

Line 620: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

616: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
617:
618: EXCEPTION
619: When OKL_API.G_EXCEPTION_ERROR Then
620: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
621: (
622: l_api_name,
623: G_PKG_NAME,
624: 'OKL_API.G_RET_STS_ERROR',

Line 624: 'OKL_API.G_RET_STS_ERROR',

620: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
621: (
622: l_api_name,
623: G_PKG_NAME,
624: 'OKL_API.G_RET_STS_ERROR',
625: x_msg_count,
626: x_msg_data,
627: '_PVT'
628: );

Line 629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

625: x_msg_count,
626: x_msg_data,
627: '_PVT'
628: );
629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
630: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
631: (
632: l_api_name,
633: G_PKG_NAME,

Line 630: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

626: x_msg_data,
627: '_PVT'
628: );
629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
630: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
631: (
632: l_api_name,
633: G_PKG_NAME,
634: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 634: 'OKL_API.G_RET_STS_UNEXP_ERROR',

630: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
631: (
632: l_api_name,
633: G_PKG_NAME,
634: 'OKL_API.G_RET_STS_UNEXP_ERROR',
635: x_msg_count,
636: x_msg_data,
637: '_PVT'
638: );

Line 640: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

636: x_msg_data,
637: '_PVT'
638: );
639: WHEN OTHERS THEN
640: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
641: (
642: l_api_name,
643: G_PKG_NAME,
644: 'OTHERS',

Line 652: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

648: );
649: End chk_and_cpy_rul_line;
650: --------------------------------------------------------------------------------
651: Procedure Copy_Product_Rules(p_api_version IN NUMBER,
652: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
653: x_return_status OUT NOCOPY VARCHAR2,
654: x_msg_count OUT NOCOPY NUMBER,
655: x_msg_data OUT NOCOPY VARCHAR2,
656: p_khr_id IN NUMBER,

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

655: x_msg_data OUT NOCOPY VARCHAR2,
656: p_khr_id IN NUMBER,
657: p_pov_id IN NUMBER) is
658:
659: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
660: l_api_name CONSTANT VARCHAR2(30) := 'COPY_PRODUCT_RULES';
661: l_api_version CONSTANT NUMBER := 1.0;
662:
663: --cursor to fetch values required from contract header

Line 797: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

793: l_no_data_found Boolean Default TRUE;
794:
795: BEGIN
796: --call start activity to set savepoint
797: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
798: p_init_msg_list,
799: '_PVT',
800: x_return_status);
801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

797: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
798: p_init_msg_list,
799: '_PVT',
800: x_return_status);
801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
803: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_ERROR;
805: END IF;

Line 802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

798: p_init_msg_list,
799: '_PVT',
800: x_return_status);
801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
803: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_ERROR;
805: END IF;
806:

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

799: '_PVT',
800: x_return_status);
801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
803: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_ERROR;
805: END IF;
806:
807: Open l_khr_csr(p_khr_id => p_khr_id);

Line 804: RAISE OKL_API.G_EXCEPTION_ERROR;

800: x_return_status);
801: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
802: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
803: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
804: RAISE OKL_API.G_EXCEPTION_ERROR;
805: END IF;
806:
807: Open l_khr_csr(p_khr_id => p_khr_id);
808: Fetch l_khr_csr into l_khr_rec;

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

825: p_khr_id => p_khr_id,
826: p_pov_id => p_pov_id
827: );
828: --dbms_output.put_line('After creating the selected product option :'||x_return_status);
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;

Line 830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

826: p_pov_id => p_pov_id
827: );
828: --dbms_output.put_line('After creating the selected product option :'||x_return_status);
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
834: End If;

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

827: );
828: --dbms_output.put_line('After creating the selected product option :'||x_return_status);
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
834: End If;
835: Close l_slctd_opt_csr;

Line 832: RAISE OKL_API.G_EXCEPTION_ERROR;

828: --dbms_output.put_line('After creating the selected product option :'||x_return_status);
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKL_API.G_EXCEPTION_ERROR;
833: END IF;
834: End If;
835: Close l_slctd_opt_csr;
836:

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

899: p_rgd_code => l_opt_ruls_khr_rec.rgr_rgd_code,
900: p_rdf_code => l_opt_ruls_khr_rec.rgr_rdf_code,
901: p_copy_or_enter_flag => l_opv_ruls_rec.Copy_or_enter_flag);
902: --dbms_output.put_line('after trying to copy rules'||x_return_status);
903: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_ERROR;
907: END IF;

Line 904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

900: p_rdf_code => l_opt_ruls_khr_rec.rgr_rdf_code,
901: p_copy_or_enter_flag => l_opv_ruls_rec.Copy_or_enter_flag);
902: --dbms_output.put_line('after trying to copy rules'||x_return_status);
903: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_ERROR;
907: END IF;
908: --End If;

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

901: p_copy_or_enter_flag => l_opv_ruls_rec.Copy_or_enter_flag);
902: --dbms_output.put_line('after trying to copy rules'||x_return_status);
903: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_ERROR;
907: END IF;
908: --End If;
909: End Loop;

Line 906: RAISE OKL_API.G_EXCEPTION_ERROR;

902: --dbms_output.put_line('after trying to copy rules'||x_return_status);
903: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_ERROR;
907: END IF;
908: --End If;
909: End Loop;
910: --dbms_output.put_line('Exiting out of l_opt_ruls_khr_csr');

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

934: p_rdf_code => l_opt_ruls_kle_rec.rgr_rdf_code,
935: p_lse_id => l_opt_ruls_kle_rec.lrg_lse_id,
936: p_copy_or_enter_flag => l_opv_ruls_rec.Copy_or_enter_flag);
937:
938: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;

Line 939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

935: p_lse_id => l_opt_ruls_kle_rec.lrg_lse_id,
936: p_copy_or_enter_flag => l_opv_ruls_rec.Copy_or_enter_flag);
937:
938: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;
943: --End If;

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

936: p_copy_or_enter_flag => l_opv_ruls_rec.Copy_or_enter_flag);
937:
938: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;
943: --End If;
944: End Loop;

Line 941: RAISE OKL_API.G_EXCEPTION_ERROR;

937:
938: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;
943: --End If;
944: End Loop;
945: --dbms_output.put_line('Exiting out of l_opt_ruls_kle_csr');

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

962: --dbms_output.put_line('Exiting out of l_khr_csr');
963: Close l_khr_csr;
964:
965: --Call end Activity
966: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
967:
968: EXCEPTION
969: When OKL_API.G_EXCEPTION_ERROR Then
970: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

Line 969: When OKL_API.G_EXCEPTION_ERROR Then

965: --Call end Activity
966: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
967:
968: EXCEPTION
969: When OKL_API.G_EXCEPTION_ERROR Then
970: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,

Line 970: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

966: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
967:
968: EXCEPTION
969: When OKL_API.G_EXCEPTION_ERROR Then
970: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,
974: 'OKL_API.G_RET_STS_ERROR',

Line 974: 'OKL_API.G_RET_STS_ERROR',

970: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,
974: 'OKL_API.G_RET_STS_ERROR',
975: x_msg_count,
976: x_msg_data,
977: '_PVT'
978: );

Line 979: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

975: x_msg_count,
976: x_msg_data,
977: '_PVT'
978: );
979: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
980: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
981: (
982: l_api_name,
983: G_PKG_NAME,

Line 980: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

976: x_msg_data,
977: '_PVT'
978: );
979: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
980: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
981: (
982: l_api_name,
983: G_PKG_NAME,
984: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 984: 'OKL_API.G_RET_STS_UNEXP_ERROR',

980: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
981: (
982: l_api_name,
983: G_PKG_NAME,
984: 'OKL_API.G_RET_STS_UNEXP_ERROR',
985: x_msg_count,
986: x_msg_data,
987: '_PVT'
988: );

Line 990: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

986: x_msg_data,
987: '_PVT'
988: );
989: WHEN OTHERS THEN
990: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
991: (
992: l_api_name,
993: G_PKG_NAME,
994: 'OTHERS',