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

Line 164: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

160: x_dependent_sty_name => l_sty_name);
161:
162: END IF;
163:
164: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
167: RAISE OKL_API.G_EXCEPTION_ERROR;
168: END IF;

Line 165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

161:
162: END IF;
163:
164: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
167: RAISE OKL_API.G_EXCEPTION_ERROR;
168: END IF;
169:

Line 166: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

162: END IF;
163:
164: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
167: RAISE OKL_API.G_EXCEPTION_ERROR;
168: END IF;
169:
170: i := 0;

Line 167: RAISE OKL_API.G_EXCEPTION_ERROR;

163:
164: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
167: RAISE OKL_API.G_EXCEPTION_ERROR;
168: END IF;
169:
170: i := 0;
171: FOR l_k_income IN c_k_income(p_sty_name => l_sty_name) LOOP

Line 198: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

194: x_sty_id => l_amortized_exp_id,
195: x_sty_name => l_name,
196: x_return_status => lx_return_status);
197:
198: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
201: RAISE OKL_API.G_EXCEPTION_ERROR;
202: END IF;

Line 199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

195: x_sty_name => l_name,
196: x_return_status => lx_return_status);
197:
198: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
201: RAISE OKL_API.G_EXCEPTION_ERROR;
202: END IF;
203:

Line 200: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

196: x_return_status => lx_return_status);
197:
198: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
201: RAISE OKL_API.G_EXCEPTION_ERROR;
202: END IF;
203:
204: */

Line 201: RAISE OKL_API.G_EXCEPTION_ERROR;

197:
198: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
199: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
200: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
201: RAISE OKL_API.G_EXCEPTION_ERROR;
202: END IF;
203:
204: */
205:

Line 221: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

217: x_dependent_sty_id => l_amortized_exp_id,
218: x_dependent_sty_name => l_name);
219:
220:
221: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;

Line 222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

218: x_dependent_sty_name => l_name);
219:
220:
221: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;
226:

Line 223: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

219:
220:
221: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;
226:
227: END IF;

Line 224: RAISE OKL_API.G_EXCEPTION_ERROR;

220:
221: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
223: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
224: RAISE OKL_API.G_EXCEPTION_ERROR;
225: END IF;
226:
227: END IF;
228:

Line 270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

266: p_selv_tbl => l_selv_tbl,
267: x_selv_tbl => lx_selv_tbl);
268:
269: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN
270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
271: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
272: RAISE OKL_API.G_EXCEPTION_ERROR;
273: END IF;
274:

Line 272: RAISE OKL_API.G_EXCEPTION_ERROR;

268:
269: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN
270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
271: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
272: RAISE OKL_API.G_EXCEPTION_ERROR;
273: END IF;
274:
275: l_selv_tbl.DELETE;
276: l_selv_tbl := lx_selv_tbl;

Line 289: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

285: p_selv_tbl => l_selv_tbl,
286: x_stmv_rec => lx_stmv_rec,
287: x_selv_tbl => lx_selv_tbl);
288:
289: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;

Line 290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

286: x_stmv_rec => lx_stmv_rec,
287: x_selv_tbl => lx_selv_tbl);
288:
289: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294:

Line 291: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

287: x_selv_tbl => lx_selv_tbl);
288:
289: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294:
295: l_selv_tbl.DELETE;

Line 292: RAISE OKL_API.G_EXCEPTION_ERROR;

288:
289: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294:
295: l_selv_tbl.DELETE;
296:

Line 309: WHEN OKL_API.G_EXCEPTION_ERROR THEN

305: x_return_status := G_RET_STS_SUCCESS;
306:
307: EXCEPTION
308:
309: WHEN OKL_API.G_EXCEPTION_ERROR THEN
310:
311: x_return_status := G_RET_STS_ERROR;
312:
313: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 313: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

309: WHEN OKL_API.G_EXCEPTION_ERROR THEN
310:
311: x_return_status := G_RET_STS_ERROR;
312:
313: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
314:
315: x_return_status := G_RET_STS_UNEXP_ERROR;
316:
317: WHEN OTHERS THEN

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

315: x_return_status := G_RET_STS_UNEXP_ERROR;
316:
317: WHEN OTHERS THEN
318:
319: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
320: p_msg_name => G_DB_ERROR,
321: p_token1 => G_PROG_NAME_TOKEN,
322: p_token1_value => l_prog_name,
323: p_token2 => G_SQLCODE_TOKEN,

Line 501: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

497: p_end_date => l_end_date,
498: p_arrears => 'Y',
499: x_return_status => lx_return_status);
500:
501: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
503: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;

Line 502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

498: p_arrears => 'Y',
499: x_return_status => lx_return_status);
500:
501: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
503: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;
506:

Line 503: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

499: x_return_status => lx_return_status);
500:
501: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
503: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;
506:
507: IF l_periodic_exp_id IS NULL THEN

Line 504: RAISE OKL_API.G_EXCEPTION_ERROR;

500:
501: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
503: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;
506:
507: IF l_periodic_exp_id IS NULL THEN
508:

Line 536: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

532: x_dependent_sty_name => l_sty_name);
533: END IF;
534: -- gboomina added for Bug 6763287 - End
535:
536: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
538: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
539: RAISE OKL_API.G_EXCEPTION_ERROR;
540: END IF;

Line 537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

533: END IF;
534: -- gboomina added for Bug 6763287 - End
535:
536: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
538: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
539: RAISE OKL_API.G_EXCEPTION_ERROR;
540: END IF;
541:

Line 538: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

534: -- gboomina added for Bug 6763287 - End
535:
536: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
538: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
539: RAISE OKL_API.G_EXCEPTION_ERROR;
540: END IF;
541:
542: /*

Line 539: RAISE OKL_API.G_EXCEPTION_ERROR;

535:
536: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
537: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
538: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
539: RAISE OKL_API.G_EXCEPTION_ERROR;
540: END IF;
541:
542: /*
543: okl_stream_generator_pvt.get_sty_details (p_sty_name => 'PERIODIC EXPENSE PAYABLE',

Line 548: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

544: x_sty_id => l_periodic_exp_id,
545: x_sty_name => l_sty_name,
546: x_return_status => lx_return_status);
547:
548: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;

Line 549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

545: x_sty_name => l_sty_name,
546: x_return_status => lx_return_status);
547:
548: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;
553: */

Line 550: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

546: x_return_status => lx_return_status);
547:
548: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;
553: */
554:

Line 551: RAISE OKL_API.G_EXCEPTION_ERROR;

547:
548: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
549: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
550: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;
553: */
554:
555: END IF;

Line 610: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

606: p_end_date => l_month_end,
607: p_arrears => 'Y',
608: x_return_status => lx_return_status);
609:
610: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;

Line 611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

607: p_arrears => 'Y',
608: x_return_status => lx_return_status);
609:
610: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615:

Line 612: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

608: x_return_status => lx_return_status);
609:
610: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615:
616: l_selv_tbl(i).amount := okl_accounting_util.validate_amount(p_amount => l_days * l_daily_exp,

Line 613: RAISE OKL_API.G_EXCEPTION_ERROR;

609:
610: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
611: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
612: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
613: RAISE OKL_API.G_EXCEPTION_ERROR;
614: END IF;
615:
616: l_selv_tbl(i).amount := okl_accounting_util.validate_amount(p_amount => l_days * l_daily_exp,
617: p_currency_code => p_currency_code);

Line 637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

633: p_selv_tbl => l_selv_tbl,
634: x_selv_tbl => lx_selv_tbl);
635:
636: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;
641:

Line 639: RAISE OKL_API.G_EXCEPTION_ERROR;

635:
636: IF (lx_return_status = G_RET_STS_UNEXP_ERROR) THEN
637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
638: ELSIF (lx_return_status = G_RET_STS_ERROR) THEN
639: RAISE OKL_API.G_EXCEPTION_ERROR;
640: END IF;
641:
642: l_selv_tbl.DELETE;
643: l_selv_tbl := lx_selv_tbl;

Line 655: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

651: p_selv_tbl => l_selv_tbl,
652: x_stmv_rec => lx_stmv_rec,
653: x_selv_tbl => lx_selv_tbl);
654:
655: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
656: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
658: RAISE OKL_API.G_EXCEPTION_ERROR;
659: END IF;

Line 656: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

652: x_stmv_rec => lx_stmv_rec,
653: x_selv_tbl => lx_selv_tbl);
654:
655: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
656: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
658: RAISE OKL_API.G_EXCEPTION_ERROR;
659: END IF;
660:

Line 657: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

653: x_selv_tbl => lx_selv_tbl);
654:
655: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
656: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
658: RAISE OKL_API.G_EXCEPTION_ERROR;
659: END IF;
660:
661: l_selv_tbl.DELETE;

Line 658: RAISE OKL_API.G_EXCEPTION_ERROR;

654:
655: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
656: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
657: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
658: RAISE OKL_API.G_EXCEPTION_ERROR;
659: END IF;
660:
661: l_selv_tbl.DELETE;
662:

Line 677: WHEN OKL_API.G_EXCEPTION_ERROR THEN

673: x_return_status := G_RET_STS_SUCCESS;
674:
675: EXCEPTION
676:
677: WHEN OKL_API.G_EXCEPTION_ERROR THEN
678:
679: x_return_status := G_RET_STS_ERROR;
680:
681: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 681: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

677: WHEN OKL_API.G_EXCEPTION_ERROR THEN
678:
679: x_return_status := G_RET_STS_ERROR;
680:
681: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
682:
683: x_return_status := G_RET_STS_UNEXP_ERROR;
684:
685: WHEN OTHERS THEN

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

683: x_return_status := G_RET_STS_UNEXP_ERROR;
684:
685: WHEN OTHERS THEN
686:
687: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
688: p_msg_name => G_DB_ERROR,
689: p_token1 => G_PROG_NAME_TOKEN,
690: p_token1_value => l_prog_name,
691: p_token2 => G_SQLCODE_TOKEN,

Line 740: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

736: p_end_date => l_hdr.end_date,
737: p_deal_type => p_deal_type,
738: x_return_status => lx_return_status);
739:
740: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;

Line 741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

737: p_deal_type => p_deal_type,
738: x_return_status => lx_return_status);
739:
740: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745:

Line 742: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

738: x_return_status => lx_return_status);
739:
740: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745:
746: generate_rec_exp(p_khr_id => p_khr_id,

Line 743: RAISE OKL_API.G_EXCEPTION_ERROR;

739:
740: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
741: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
742: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
743: RAISE OKL_API.G_EXCEPTION_ERROR;
744: END IF;
745:
746: generate_rec_exp(p_khr_id => p_khr_id,
747: p_deal_type => p_deal_type,

Line 752: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

748: p_purpose_code => p_purpose_code,
749: p_currency_code => l_hdr.currency_code,
750: x_return_status => lx_return_status);
751:
752: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
754: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
755: RAISE OKL_API.G_EXCEPTION_ERROR;
756: END IF;

Line 753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

749: p_currency_code => l_hdr.currency_code,
750: x_return_status => lx_return_status);
751:
752: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
754: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
755: RAISE OKL_API.G_EXCEPTION_ERROR;
756: END IF;
757:

Line 754: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN

750: x_return_status => lx_return_status);
751:
752: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
754: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
755: RAISE OKL_API.G_EXCEPTION_ERROR;
756: END IF;
757:
758: x_return_status := lx_return_status;

Line 755: RAISE OKL_API.G_EXCEPTION_ERROR;

751:
752: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
754: ELSIF lx_return_status = OKL_API.G_RET_STS_ERROR THEN
755: RAISE OKL_API.G_EXCEPTION_ERROR;
756: END IF;
757:
758: x_return_status := lx_return_status;
759:

Line 762: WHEN OKL_API.G_EXCEPTION_ERROR THEN

758: x_return_status := lx_return_status;
759:
760: EXCEPTION
761:
762: WHEN OKL_API.G_EXCEPTION_ERROR THEN
763:
764: x_return_status := G_RET_STS_ERROR;
765:
766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

762: WHEN OKL_API.G_EXCEPTION_ERROR THEN
763:
764: x_return_status := G_RET_STS_ERROR;
765:
766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
767:
768: x_return_status := G_RET_STS_UNEXP_ERROR;
769:
770: WHEN OTHERS THEN

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

768: x_return_status := G_RET_STS_UNEXP_ERROR;
769:
770: WHEN OTHERS THEN
771:
772: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
773: p_msg_name => G_DB_ERROR,
774: p_token1 => G_PROG_NAME_TOKEN,
775: p_token1_value => l_prog_name,
776: p_token2 => G_SQLCODE_TOKEN,

Line 781: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

777: p_token2_value => sqlcode,
778: p_token3 => G_SQLERRM_TOKEN,
779: p_token3_value => sqlerrm);
780:
781: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
782:
783: END generate_expense_streams;
784:
785: