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

Line 21: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_ZERO');

17:
18: BEGIN
19:
20: IF p_insurance_estimate_rec.policy_term <= 0 THEN
21: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_ZERO');
22: RAISE OKL_API.G_EXCEPTION_ERROR;
23: END IF;
24:
25: IF TRUNC(p_insurance_estimate_rec.policy_term) <> p_insurance_estimate_rec.policy_term THEN

Line 22: RAISE OKL_API.G_EXCEPTION_ERROR;

18: BEGIN
19:
20: IF p_insurance_estimate_rec.policy_term <= 0 THEN
21: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_ZERO');
22: RAISE OKL_API.G_EXCEPTION_ERROR;
23: END IF;
24:
25: IF TRUNC(p_insurance_estimate_rec.policy_term) <> p_insurance_estimate_rec.policy_term THEN
26: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');

Line 26: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');

22: RAISE OKL_API.G_EXCEPTION_ERROR;
23: END IF;
24:
25: IF TRUNC(p_insurance_estimate_rec.policy_term) <> p_insurance_estimate_rec.policy_term THEN
26: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');
27: RAISE OKL_API.G_EXCEPTION_ERROR;
28: END IF;
29:
30: IF p_insurance_estimate_rec.periodic_amount < 0 THEN

Line 27: RAISE OKL_API.G_EXCEPTION_ERROR;

23: END IF;
24:
25: IF TRUNC(p_insurance_estimate_rec.policy_term) <> p_insurance_estimate_rec.policy_term THEN
26: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');
27: RAISE OKL_API.G_EXCEPTION_ERROR;
28: END IF;
29:
30: IF p_insurance_estimate_rec.periodic_amount < 0 THEN
31: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');

Line 31: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');

27: RAISE OKL_API.G_EXCEPTION_ERROR;
28: END IF;
29:
30: IF p_insurance_estimate_rec.periodic_amount < 0 THEN
31: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');
32: RAISE OKL_API.G_EXCEPTION_ERROR;
33: END IF;
34:
35: IF p_insurance_estimate_rec.payment_frequency = 'A' THEN

Line 32: RAISE OKL_API.G_EXCEPTION_ERROR;

28: END IF;
29:
30: IF p_insurance_estimate_rec.periodic_amount < 0 THEN
31: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');
32: RAISE OKL_API.G_EXCEPTION_ERROR;
33: END IF;
34:
35: IF p_insurance_estimate_rec.payment_frequency = 'A' THEN
36: l_mpp := 12;

Line 46: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_TERM_FREQ_MISMATCH');

42: l_mpp := 1;
43: END IF;
44:
45: IF (p_insurance_estimate_rec.policy_term / l_mpp) <> TRUNC (p_insurance_estimate_rec.policy_term / l_mpp) THEN
46: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_TERM_FREQ_MISMATCH');
47: RAISE OKL_API.G_EXCEPTION_ERROR;
48: END IF;
49:
50: x_return_status := G_RET_STS_SUCCESS;

Line 47: RAISE OKL_API.G_EXCEPTION_ERROR;

43: END IF;
44:
45: IF (p_insurance_estimate_rec.policy_term / l_mpp) <> TRUNC (p_insurance_estimate_rec.policy_term / l_mpp) THEN
46: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_TERM_FREQ_MISMATCH');
47: RAISE OKL_API.G_EXCEPTION_ERROR;
48: END IF;
49:
50: x_return_status := G_RET_STS_SUCCESS;
51:

Line 54: WHEN OKL_API.G_EXCEPTION_ERROR THEN

50: x_return_status := G_RET_STS_SUCCESS;
51:
52: EXCEPTION
53:
54: WHEN OKL_API.G_EXCEPTION_ERROR THEN
55: x_return_status := G_RET_STS_ERROR;
56:
57: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
58: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 57: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

53:
54: WHEN OKL_API.G_EXCEPTION_ERROR THEN
55: x_return_status := G_RET_STS_ERROR;
56:
57: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
58: x_return_status := G_RET_STS_UNEXP_ERROR;
59:
60: WHEN OTHERS THEN
61: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 61: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

57: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
58: x_return_status := G_RET_STS_UNEXP_ERROR;
59:
60: WHEN OTHERS THEN
61: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
62: p_msg_name => G_DB_ERROR,
63: p_token1 => G_PROG_NAME_TOKEN,
64: p_token1_value => l_program_name,
65: p_token2 => G_SQLCODE_TOKEN,

Line 126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

122: ,x_quev_rec => lx_quev_rec
123: );
124:
125: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: ELSIF x_return_status = G_RET_STS_ERROR THEN
128: RAISE OKL_API.G_EXCEPTION_ERROR;
129: END IF;
130:

Line 128: RAISE OKL_API.G_EXCEPTION_ERROR;

124:
125: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
127: ELSIF x_return_status = G_RET_STS_ERROR THEN
128: RAISE OKL_API.G_EXCEPTION_ERROR;
129: END IF;
130:
131: p_insurance_estimate_rec.id := lx_quev_rec.id;
132:

Line 135: WHEN OKL_API.G_EXCEPTION_ERROR THEN

131: p_insurance_estimate_rec.id := lx_quev_rec.id;
132:
133: EXCEPTION
134:
135: WHEN OKL_API.G_EXCEPTION_ERROR THEN
136: x_return_status := G_RET_STS_ERROR;
137:
138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
139: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

134:
135: WHEN OKL_API.G_EXCEPTION_ERROR THEN
136: x_return_status := G_RET_STS_ERROR;
137:
138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
139: x_return_status := G_RET_STS_UNEXP_ERROR;
140:
141: WHEN OTHERS THEN
142: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 142: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
139: x_return_status := G_RET_STS_UNEXP_ERROR;
140:
141: WHEN OTHERS THEN
142: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
143: p_msg_name => G_DB_ERROR,
144: p_token1 => G_PROG_NAME_TOKEN,
145: p_token1_value => l_program_name,
146: p_token2 => G_SQLCODE_TOKEN,

Line 209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

205: ,x_quev_rec => lx_quev_rec
206: );
207:
208: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
210: ELSIF x_return_status = G_RET_STS_ERROR THEN
211: RAISE OKL_API.G_EXCEPTION_ERROR;
212: END IF;
213:

Line 211: RAISE OKL_API.G_EXCEPTION_ERROR;

207:
208: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
209: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
210: ELSIF x_return_status = G_RET_STS_ERROR THEN
211: RAISE OKL_API.G_EXCEPTION_ERROR;
212: END IF;
213:
214: EXCEPTION
215:

Line 216: WHEN OKL_API.G_EXCEPTION_ERROR THEN

212: END IF;
213:
214: EXCEPTION
215:
216: WHEN OKL_API.G_EXCEPTION_ERROR THEN
217: x_return_status := G_RET_STS_ERROR;
218:
219: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
220: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 219: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

215:
216: WHEN OKL_API.G_EXCEPTION_ERROR THEN
217: x_return_status := G_RET_STS_ERROR;
218:
219: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
220: x_return_status := G_RET_STS_UNEXP_ERROR;
221:
222: WHEN OTHERS THEN
223: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 223: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

219: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
220: x_return_status := G_RET_STS_UNEXP_ERROR;
221:
222: WHEN OTHERS THEN
223: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
224: p_msg_name => G_DB_ERROR,
225: p_token1 => G_PROG_NAME_TOKEN,
226: p_token1_value => l_program_name,
227: p_token2 => G_SQLCODE_TOKEN,

Line 292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

288: ,x_msg_data => x_msg_data
289: );
290:
291: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: ELSIF x_return_status = G_RET_STS_ERROR THEN
294: RAISE OKL_API.G_EXCEPTION_ERROR;
295: END IF;
296:

Line 294: RAISE OKL_API.G_EXCEPTION_ERROR;

290:
291: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
292: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
293: ELSIF x_return_status = G_RET_STS_ERROR THEN
294: RAISE OKL_API.G_EXCEPTION_ERROR;
295: END IF;
296:
297: x_return_status := G_RET_STS_SUCCESS;
298:

Line 301: WHEN OKL_API.G_EXCEPTION_ERROR THEN

297: x_return_status := G_RET_STS_SUCCESS;
298:
299: EXCEPTION
300:
301: WHEN OKL_API.G_EXCEPTION_ERROR THEN
302: x_return_status := G_RET_STS_ERROR;
303:
304: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
305: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 304: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

300:
301: WHEN OKL_API.G_EXCEPTION_ERROR THEN
302: x_return_status := G_RET_STS_ERROR;
303:
304: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
305: x_return_status := G_RET_STS_UNEXP_ERROR;
306:
307: WHEN OTHERS THEN
308: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 308: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

304: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
305: x_return_status := G_RET_STS_UNEXP_ERROR;
306:
307: WHEN OTHERS THEN
308: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
309: p_msg_name => G_DB_ERROR,
310: p_token1 => G_PROG_NAME_TOKEN,
311: p_token1_value => l_program_name,
312: p_token2 => G_SQLCODE_TOKEN,

Line 382: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

378: ,x_msg_data => x_msg_data
379: );
380:
381: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
382: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
383: ELSIF x_return_status = G_RET_STS_ERROR THEN
384: RAISE OKL_API.G_EXCEPTION_ERROR;
385: END IF;
386:

Line 384: RAISE OKL_API.G_EXCEPTION_ERROR;

380:
381: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
382: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
383: ELSIF x_return_status = G_RET_STS_ERROR THEN
384: RAISE OKL_API.G_EXCEPTION_ERROR;
385: END IF;
386:
387: x_return_status := G_RET_STS_SUCCESS;
388:

Line 391: WHEN OKL_API.G_EXCEPTION_ERROR THEN

387: x_return_status := G_RET_STS_SUCCESS;
388:
389: EXCEPTION
390:
391: WHEN OKL_API.G_EXCEPTION_ERROR THEN
392: x_return_status := G_RET_STS_ERROR;
393:
394: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
395: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 394: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

390:
391: WHEN OKL_API.G_EXCEPTION_ERROR THEN
392: x_return_status := G_RET_STS_ERROR;
393:
394: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
395: x_return_status := G_RET_STS_UNEXP_ERROR;
396:
397: WHEN OTHERS THEN
398: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 398: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

394: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
395: x_return_status := G_RET_STS_UNEXP_ERROR;
396:
397: WHEN OTHERS THEN
398: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
399: p_msg_name => G_DB_ERROR,
400: p_token1 => G_PROG_NAME_TOKEN,
401: p_token1_value => l_program_name,
402: p_token2 => G_SQLCODE_TOKEN,

Line 474: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

470: ,x_return_status => x_return_status
471: );
472:
473: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
474: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: ELSIF x_return_status = G_RET_STS_ERROR THEN
476: RAISE OKL_API.G_EXCEPTION_ERROR;
477: END IF;
478:

Line 476: RAISE OKL_API.G_EXCEPTION_ERROR;

472:
473: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
474: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
475: ELSIF x_return_status = G_RET_STS_ERROR THEN
476: RAISE OKL_API.G_EXCEPTION_ERROR;
477: END IF;
478:
479: insert_row (
480: p_insurance_estimate_rec => l_insurance_estimate_rec

Line 487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

483: ,x_msg_data => x_msg_data
484: );
485:
486: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
488: ELSIF x_return_status = G_RET_STS_ERROR THEN
489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491:

Line 489: RAISE OKL_API.G_EXCEPTION_ERROR;

485:
486: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
488: ELSIF x_return_status = G_RET_STS_ERROR THEN
489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491:
492: create_cashflow (
493: p_insurance_estimate_rec => l_insurance_estimate_rec

Line 500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

496: ,x_msg_data => x_msg_data
497: );
498:
499: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
501: ELSIF x_return_status = G_RET_STS_ERROR THEN
502: RAISE OKL_API.G_EXCEPTION_ERROR;
503: END IF;
504:

Line 502: RAISE OKL_API.G_EXCEPTION_ERROR;

498:
499: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
501: ELSIF x_return_status = G_RET_STS_ERROR THEN
502: RAISE OKL_API.G_EXCEPTION_ERROR;
503: END IF;
504:
505: x_insurance_estimate_id := l_insurance_estimate_rec.id;
506: x_return_status := G_RET_STS_SUCCESS;

Line 510: WHEN OKL_API.G_EXCEPTION_ERROR THEN

506: x_return_status := G_RET_STS_SUCCESS;
507:
508: EXCEPTION
509:
510: WHEN OKL_API.G_EXCEPTION_ERROR THEN
511:
512: IF p_transaction_control = G_TRUE THEN
513: ROLLBACK TO l_program_name;
514: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 519: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

515: END IF;
516:
517: x_return_status := G_RET_STS_ERROR;
518:
519: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
520:
521: IF p_transaction_control = G_TRUE THEN
522: ROLLBACK TO l_program_name;
523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 530: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

526: x_return_status := G_RET_STS_UNEXP_ERROR;
527:
528: WHEN OTHERS THEN
529:
530: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
531: p_msg_name => G_DB_ERROR,
532: p_token1 => G_PROG_NAME_TOKEN,
533: p_token1_value => l_api_name,
534: p_token2 => G_SQLCODE_TOKEN,

Line 605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

601: ,x_return_status => x_return_status
602: );
603:
604: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF x_return_status = G_RET_STS_ERROR THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609:

Line 607: RAISE OKL_API.G_EXCEPTION_ERROR;

603:
604: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
606: ELSIF x_return_status = G_RET_STS_ERROR THEN
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF;
609:
610: update_row (
611: p_insurance_estimate_rec => l_insurance_estimate_rec

Line 618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

614: ,x_msg_data => x_msg_data
615: );
616:
617: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF x_return_status = G_RET_STS_ERROR THEN
620: RAISE OKL_API.G_EXCEPTION_ERROR;
621: END IF;
622:

Line 620: RAISE OKL_API.G_EXCEPTION_ERROR;

616:
617: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF x_return_status = G_RET_STS_ERROR THEN
620: RAISE OKL_API.G_EXCEPTION_ERROR;
621: END IF;
622:
623: update_cashflow (
624: p_insurance_estimate_rec => l_insurance_estimate_rec

Line 631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

627: ,x_msg_data => x_msg_data
628: );
629:
630: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
632: ELSIF x_return_status = G_RET_STS_ERROR THEN
633: RAISE OKL_API.G_EXCEPTION_ERROR;
634: END IF;
635:

Line 633: RAISE OKL_API.G_EXCEPTION_ERROR;

629:
630: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
631: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
632: ELSIF x_return_status = G_RET_STS_ERROR THEN
633: RAISE OKL_API.G_EXCEPTION_ERROR;
634: END IF;
635:
636: x_return_status := G_RET_STS_SUCCESS;
637:

Line 640: WHEN OKL_API.G_EXCEPTION_ERROR THEN

636: x_return_status := G_RET_STS_SUCCESS;
637:
638: EXCEPTION
639:
640: WHEN OKL_API.G_EXCEPTION_ERROR THEN
641:
642: IF p_transaction_control = G_TRUE THEN
643: ROLLBACK TO l_program_name;
644: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

645: END IF;
646:
647: x_return_status := G_RET_STS_ERROR;
648:
649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
650:
651: IF p_transaction_control = G_TRUE THEN
652: ROLLBACK TO l_program_name;
653: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 660: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

656: x_return_status := G_RET_STS_UNEXP_ERROR;
657:
658: WHEN OTHERS THEN
659:
660: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
661: p_msg_name => G_DB_ERROR,
662: p_token1 => G_PROG_NAME_TOKEN,
663: p_token1_value => l_api_name,
664: p_token2 => G_SQLCODE_TOKEN,

Line 717: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

713: ,x_msg_data => x_msg_data
714: );
715:
716: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
717: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
718: ELSIF x_return_status = G_RET_STS_ERROR THEN
719: RAISE OKL_API.G_EXCEPTION_ERROR;
720: END IF;
721:

Line 719: RAISE OKL_API.G_EXCEPTION_ERROR;

715:
716: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
717: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
718: ELSIF x_return_status = G_RET_STS_ERROR THEN
719: RAISE OKL_API.G_EXCEPTION_ERROR;
720: END IF;
721:
722: DELETE FROM okl_insurance_estimates_tl WHERE id = p_insurance_estimate_id;
723: DELETE FROM okl_insurance_estimates_b WHERE id = p_insurance_estimate_id;

Line 729: WHEN OKL_API.G_EXCEPTION_ERROR THEN

725: x_return_status := G_RET_STS_SUCCESS;
726:
727: EXCEPTION
728:
729: WHEN OKL_API.G_EXCEPTION_ERROR THEN
730:
731: IF p_transaction_control = G_TRUE THEN
732: ROLLBACK TO l_program_name;
733: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 738: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

734: END IF;
735:
736: x_return_status := G_RET_STS_ERROR;
737:
738: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
739:
740: IF p_transaction_control = G_TRUE THEN
741: ROLLBACK TO l_program_name;
742: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 749: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

745: x_return_status := G_RET_STS_UNEXP_ERROR;
746:
747: WHEN OTHERS THEN
748:
749: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
750: p_msg_name => G_DB_ERROR,
751: p_token1 => G_PROG_NAME_TOKEN,
752: p_token1_value => l_api_name,
753: p_token2 => G_SQLCODE_TOKEN,