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 73: WHEN OKL_API.G_EXCEPTION_ERROR THEN

69: x_return_status := G_RET_STS_SUCCESS;
70:
71: EXCEPTION
72:
73: WHEN OKL_API.G_EXCEPTION_ERROR THEN
74: x_return_status := G_RET_STS_ERROR;
75:
76: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
77: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 76: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

72:
73: WHEN OKL_API.G_EXCEPTION_ERROR THEN
74: x_return_status := G_RET_STS_ERROR;
75:
76: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
77: x_return_status := G_RET_STS_UNEXP_ERROR;
78:
79: WHEN OTHERS THEN
80: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

76: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
77: x_return_status := G_RET_STS_UNEXP_ERROR;
78:
79: WHEN OTHERS THEN
80: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
81: p_msg_name => G_DB_ERROR,
82: p_token1 => G_PROG_NAME_TOKEN,
83: p_token1_value => l_program_name,
84: p_token2 => G_SQLCODE_TOKEN,

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

108:
109: BEGIN
110:
111: IF p_insurance_estimate_rec.policy_term <= 0 THEN
112: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_ZERO');
113: RAISE OKL_API.G_EXCEPTION_ERROR;
114: END IF;
115:
116: IF TRUNC(p_insurance_estimate_rec.policy_term) <> p_insurance_estimate_rec.policy_term THEN

Line 113: RAISE OKL_API.G_EXCEPTION_ERROR;

109: BEGIN
110:
111: IF p_insurance_estimate_rec.policy_term <= 0 THEN
112: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_ZERO');
113: RAISE OKL_API.G_EXCEPTION_ERROR;
114: END IF;
115:
116: IF TRUNC(p_insurance_estimate_rec.policy_term) <> p_insurance_estimate_rec.policy_term THEN
117: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');

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

113: RAISE OKL_API.G_EXCEPTION_ERROR;
114: END IF;
115:
116: IF TRUNC(p_insurance_estimate_rec.policy_term) <> p_insurance_estimate_rec.policy_term THEN
117: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: END IF;
120:
121: IF p_insurance_estimate_rec.periodic_amount < 0 THEN

Line 118: RAISE OKL_API.G_EXCEPTION_ERROR;

114: END IF;
115:
116: IF TRUNC(p_insurance_estimate_rec.policy_term) <> p_insurance_estimate_rec.policy_term THEN
117: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: END IF;
120:
121: IF p_insurance_estimate_rec.periodic_amount < 0 THEN
122: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');

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

118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: END IF;
120:
121: IF p_insurance_estimate_rec.periodic_amount < 0 THEN
122: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: END IF;
125:
126: IF p_insurance_estimate_rec.payment_frequency = 'A' THEN

Line 123: RAISE OKL_API.G_EXCEPTION_ERROR;

119: END IF;
120:
121: IF p_insurance_estimate_rec.periodic_amount < 0 THEN
122: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: END IF;
125:
126: IF p_insurance_estimate_rec.payment_frequency = 'A' THEN
127: l_mpp := 12;

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

133: l_mpp := 1;
134: END IF;
135:
136: IF (p_insurance_estimate_rec.policy_term / l_mpp) <> TRUNC (p_insurance_estimate_rec.policy_term / l_mpp) THEN
137: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_TERM_FREQ_MISMATCH');
138: RAISE OKL_API.G_EXCEPTION_ERROR;
139: END IF;
140:
141: x_return_status := G_RET_STS_SUCCESS;

Line 138: RAISE OKL_API.G_EXCEPTION_ERROR;

134: END IF;
135:
136: IF (p_insurance_estimate_rec.policy_term / l_mpp) <> TRUNC (p_insurance_estimate_rec.policy_term / l_mpp) THEN
137: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_TERM_FREQ_MISMATCH');
138: RAISE OKL_API.G_EXCEPTION_ERROR;
139: END IF;
140:
141: x_return_status := G_RET_STS_SUCCESS;
142:

Line 145: WHEN OKL_API.G_EXCEPTION_ERROR THEN

141: x_return_status := G_RET_STS_SUCCESS;
142:
143: EXCEPTION
144:
145: WHEN OKL_API.G_EXCEPTION_ERROR THEN
146: x_return_status := G_RET_STS_ERROR;
147:
148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
149: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

144:
145: WHEN OKL_API.G_EXCEPTION_ERROR THEN
146: x_return_status := G_RET_STS_ERROR;
147:
148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
149: x_return_status := G_RET_STS_UNEXP_ERROR;
150:
151: WHEN OTHERS THEN
152: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

148: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
149: x_return_status := G_RET_STS_UNEXP_ERROR;
150:
151: WHEN OTHERS THEN
152: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
153: p_msg_name => G_DB_ERROR,
154: p_token1 => G_PROG_NAME_TOKEN,
155: p_token1_value => l_program_name,
156: p_token2 => G_SQLCODE_TOKEN,

Line 217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

213: ,x_quev_rec => lx_quev_rec
214: );
215:
216: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
218: ELSIF x_return_status = G_RET_STS_ERROR THEN
219: RAISE OKL_API.G_EXCEPTION_ERROR;
220: END IF;
221:

Line 219: RAISE OKL_API.G_EXCEPTION_ERROR;

215:
216: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
218: ELSIF x_return_status = G_RET_STS_ERROR THEN
219: RAISE OKL_API.G_EXCEPTION_ERROR;
220: END IF;
221:
222: p_insurance_estimate_rec.id := lx_quev_rec.id;
223:

Line 226: WHEN OKL_API.G_EXCEPTION_ERROR THEN

222: p_insurance_estimate_rec.id := lx_quev_rec.id;
223:
224: EXCEPTION
225:
226: WHEN OKL_API.G_EXCEPTION_ERROR THEN
227: x_return_status := G_RET_STS_ERROR;
228:
229: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
230: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 229: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

225:
226: WHEN OKL_API.G_EXCEPTION_ERROR THEN
227: x_return_status := G_RET_STS_ERROR;
228:
229: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
230: x_return_status := G_RET_STS_UNEXP_ERROR;
231:
232: WHEN OTHERS THEN
233: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

229: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
230: x_return_status := G_RET_STS_UNEXP_ERROR;
231:
232: WHEN OTHERS THEN
233: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
234: p_msg_name => G_DB_ERROR,
235: p_token1 => G_PROG_NAME_TOKEN,
236: p_token1_value => l_program_name,
237: p_token2 => G_SQLCODE_TOKEN,

Line 300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

296: ,x_quev_rec => lx_quev_rec
297: );
298:
299: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF x_return_status = G_RET_STS_ERROR THEN
302: RAISE OKL_API.G_EXCEPTION_ERROR;
303: END IF;
304:

Line 302: RAISE OKL_API.G_EXCEPTION_ERROR;

298:
299: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF x_return_status = G_RET_STS_ERROR THEN
302: RAISE OKL_API.G_EXCEPTION_ERROR;
303: END IF;
304:
305: EXCEPTION
306:

Line 307: WHEN OKL_API.G_EXCEPTION_ERROR THEN

303: END IF;
304:
305: EXCEPTION
306:
307: WHEN OKL_API.G_EXCEPTION_ERROR THEN
308: x_return_status := G_RET_STS_ERROR;
309:
310: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
311: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 310: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

306:
307: WHEN OKL_API.G_EXCEPTION_ERROR THEN
308: x_return_status := G_RET_STS_ERROR;
309:
310: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
311: x_return_status := G_RET_STS_UNEXP_ERROR;
312:
313: WHEN OTHERS THEN
314: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

310: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
311: x_return_status := G_RET_STS_UNEXP_ERROR;
312:
313: WHEN OTHERS THEN
314: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
315: p_msg_name => G_DB_ERROR,
316: p_token1 => G_PROG_NAME_TOKEN,
317: p_token1_value => l_program_name,
318: p_token2 => G_SQLCODE_TOKEN,

Line 383: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 385: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 392: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 395: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

Line 473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 475: RAISE OKL_API.G_EXCEPTION_ERROR;

471:
472: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
474: ELSIF x_return_status = G_RET_STS_ERROR THEN
475: RAISE OKL_API.G_EXCEPTION_ERROR;
476: END IF;
477:
478: x_return_status := G_RET_STS_SUCCESS;
479:

Line 482: WHEN OKL_API.G_EXCEPTION_ERROR THEN

478: x_return_status := G_RET_STS_SUCCESS;
479:
480: EXCEPTION
481:
482: WHEN OKL_API.G_EXCEPTION_ERROR THEN
483: x_return_status := G_RET_STS_ERROR;
484:
485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
486: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

481:
482: WHEN OKL_API.G_EXCEPTION_ERROR THEN
483: x_return_status := G_RET_STS_ERROR;
484:
485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
486: x_return_status := G_RET_STS_UNEXP_ERROR;
487:
488: WHEN OTHERS THEN
489: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

485: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
486: x_return_status := G_RET_STS_UNEXP_ERROR;
487:
488: WHEN OTHERS THEN
489: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
490: p_msg_name => G_DB_ERROR,
491: p_token1 => G_PROG_NAME_TOKEN,
492: p_token1_value => l_program_name,
493: p_token2 => G_SQLCODE_TOKEN,

Line 565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 567: RAISE OKL_API.G_EXCEPTION_ERROR;

563:
564: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
565: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
566: ELSIF x_return_status = G_RET_STS_ERROR THEN
567: RAISE OKL_API.G_EXCEPTION_ERROR;
568: END IF;
569:
570: insert_row (
571: p_insurance_estimate_rec => l_insurance_estimate_rec

Line 578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

574: ,x_msg_data => x_msg_data
575: );
576:
577: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
579: ELSIF x_return_status = G_RET_STS_ERROR THEN
580: RAISE OKL_API.G_EXCEPTION_ERROR;
581: END IF;
582:

Line 580: RAISE OKL_API.G_EXCEPTION_ERROR;

576:
577: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
579: ELSIF x_return_status = G_RET_STS_ERROR THEN
580: RAISE OKL_API.G_EXCEPTION_ERROR;
581: END IF;
582:
583: create_cashflow (
584: p_insurance_estimate_rec => l_insurance_estimate_rec

Line 591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

587: ,x_msg_data => x_msg_data
588: );
589:
590: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
592: ELSIF x_return_status = G_RET_STS_ERROR THEN
593: RAISE OKL_API.G_EXCEPTION_ERROR;
594: END IF;
595:

Line 593: RAISE OKL_API.G_EXCEPTION_ERROR;

589:
590: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
592: ELSIF x_return_status = G_RET_STS_ERROR THEN
593: RAISE OKL_API.G_EXCEPTION_ERROR;
594: END IF;
595:
596: x_insurance_estimate_id := l_insurance_estimate_rec.id;
597: x_return_status := G_RET_STS_SUCCESS;

Line 601: WHEN OKL_API.G_EXCEPTION_ERROR THEN

597: x_return_status := G_RET_STS_SUCCESS;
598:
599: EXCEPTION
600:
601: WHEN OKL_API.G_EXCEPTION_ERROR THEN
602:
603: IF p_transaction_control = G_TRUE THEN
604: ROLLBACK TO l_program_name;
605: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

606: END IF;
607:
608: x_return_status := G_RET_STS_ERROR;
609:
610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
611:
612: IF p_transaction_control = G_TRUE THEN
613: ROLLBACK TO l_program_name;
614: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

617: x_return_status := G_RET_STS_UNEXP_ERROR;
618:
619: WHEN OTHERS THEN
620:
621: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
622: p_msg_name => G_DB_ERROR,
623: p_token1 => G_PROG_NAME_TOKEN,
624: p_token1_value => l_api_name,
625: p_token2 => G_SQLCODE_TOKEN,

Line 696: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

692: ,x_return_status => x_return_status
693: );
694:
695: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
696: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
697: ELSIF x_return_status = G_RET_STS_ERROR THEN
698: RAISE OKL_API.G_EXCEPTION_ERROR;
699: END IF;
700:

Line 698: RAISE OKL_API.G_EXCEPTION_ERROR;

694:
695: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
696: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
697: ELSIF x_return_status = G_RET_STS_ERROR THEN
698: RAISE OKL_API.G_EXCEPTION_ERROR;
699: END IF;
700:
701: update_row (
702: p_insurance_estimate_rec => l_insurance_estimate_rec

Line 709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

705: ,x_msg_data => x_msg_data
706: );
707:
708: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF x_return_status = G_RET_STS_ERROR THEN
711: RAISE OKL_API.G_EXCEPTION_ERROR;
712: END IF;
713:

Line 711: RAISE OKL_API.G_EXCEPTION_ERROR;

707:
708: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
710: ELSIF x_return_status = G_RET_STS_ERROR THEN
711: RAISE OKL_API.G_EXCEPTION_ERROR;
712: END IF;
713:
714: update_cashflow (
715: p_insurance_estimate_rec => l_insurance_estimate_rec

Line 722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

718: ,x_msg_data => x_msg_data
719: );
720:
721: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
723: ELSIF x_return_status = G_RET_STS_ERROR THEN
724: RAISE OKL_API.G_EXCEPTION_ERROR;
725: END IF;
726:

Line 724: RAISE OKL_API.G_EXCEPTION_ERROR;

720:
721: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
722: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
723: ELSIF x_return_status = G_RET_STS_ERROR THEN
724: RAISE OKL_API.G_EXCEPTION_ERROR;
725: END IF;
726:
727: x_return_status := G_RET_STS_SUCCESS;
728:

Line 731: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

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

Line 808: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

804: ,x_msg_data => x_msg_data
805: );
806:
807: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
808: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
809: ELSIF x_return_status = G_RET_STS_ERROR THEN
810: RAISE OKL_API.G_EXCEPTION_ERROR;
811: END IF;
812:

Line 810: RAISE OKL_API.G_EXCEPTION_ERROR;

806:
807: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
808: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
809: ELSIF x_return_status = G_RET_STS_ERROR THEN
810: RAISE OKL_API.G_EXCEPTION_ERROR;
811: END IF;
812:
813: DELETE FROM okl_insurance_estimates_tl WHERE id = p_insurance_estimate_id;
814: DELETE FROM okl_insurance_estimates_b WHERE id = p_insurance_estimate_id;

Line 820: WHEN OKL_API.G_EXCEPTION_ERROR THEN

816: x_return_status := G_RET_STS_SUCCESS;
817:
818: EXCEPTION
819:
820: WHEN OKL_API.G_EXCEPTION_ERROR THEN
821:
822: IF p_transaction_control = G_TRUE THEN
823: ROLLBACK TO l_program_name;
824: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

825: END IF;
826:
827: x_return_status := G_RET_STS_ERROR;
828:
829: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
830:
831: IF p_transaction_control = G_TRUE THEN
832: ROLLBACK TO l_program_name;
833: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

836: x_return_status := G_RET_STS_UNEXP_ERROR;
837:
838: WHEN OTHERS THEN
839:
840: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
841: p_msg_name => G_DB_ERROR,
842: p_token1 => G_PROG_NAME_TOKEN,
843: p_token1_value => l_api_name,
844: p_token2 => G_SQLCODE_TOKEN,

Line 897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

893: ,x_l_ins_est_rec => l_ins_est_rec
894: ,x_return_status => x_return_status);
895:
896: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
898: ELSIF x_return_status = G_RET_STS_ERROR THEN
899: RAISE OKL_API.G_EXCEPTION_ERROR;
900: END IF;
901:

Line 899: RAISE OKL_API.G_EXCEPTION_ERROR;

895:
896: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
898: ELSIF x_return_status = G_RET_STS_ERROR THEN
899: RAISE OKL_API.G_EXCEPTION_ERROR;
900: END IF;
901:
902: l_ins_est_rec.lease_quote_id := p_target_quote_id ;
903:

Line 918: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

914: ,x_quev_rec => lx_ins_est_rec
915: );
916:
917: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
918: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF x_return_status = G_RET_STS_ERROR THEN
920: RAISE OKL_API.G_EXCEPTION_ERROR;
921: END IF;
922:

Line 920: RAISE OKL_API.G_EXCEPTION_ERROR;

916:
917: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
918: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
919: ELSIF x_return_status = G_RET_STS_ERROR THEN
920: RAISE OKL_API.G_EXCEPTION_ERROR;
921: END IF;
922:
923: x_insurance_est_id := lx_ins_est_rec.id;
924:

Line 940: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

936: ,x_msg_count => x_msg_count
937: ,x_msg_data => x_msg_data );
938:
939: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
940: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
941: ELSIF x_return_status = G_RET_STS_ERROR THEN
942: RAISE OKL_API.G_EXCEPTION_ERROR;
943: END IF;
944:

Line 942: RAISE OKL_API.G_EXCEPTION_ERROR;

938:
939: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
940: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
941: ELSIF x_return_status = G_RET_STS_ERROR THEN
942: RAISE OKL_API.G_EXCEPTION_ERROR;
943: END IF;
944:
945: x_return_status := G_RET_STS_SUCCESS;
946:

Line 949: WHEN OKL_API.G_EXCEPTION_ERROR THEN

945: x_return_status := G_RET_STS_SUCCESS;
946:
947: EXCEPTION
948:
949: WHEN OKL_API.G_EXCEPTION_ERROR THEN
950:
951: IF p_transaction_control = G_TRUE THEN
952: ROLLBACK TO l_program_name;
953: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 958: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

954: END IF;
955:
956: x_return_status := G_RET_STS_ERROR;
957:
958: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
959:
960: IF p_transaction_control = G_TRUE THEN
961: ROLLBACK TO l_program_name;
962: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

965: x_return_status := G_RET_STS_UNEXP_ERROR;
966:
967: WHEN OTHERS THEN
968:
969: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
970: p_msg_name => G_DB_ERROR,
971: p_token1 => G_PROG_NAME_TOKEN,
972: p_token1_value => l_api_name,
973: p_token2 => G_SQLCODE_TOKEN,