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

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

172: EXCEPTION
173:
174: WHEN OTHERS THEN
175:
176: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
177: p_msg_name => G_DB_ERROR,
178: p_token1 => G_PROG_NAME_TOKEN,
179: p_token1_value => l_prog_name,
180: p_token2 => G_SQLCODE_TOKEN,

Line 194: IF (p_id = OKL_API.G_MISS_NUM OR

190: -- PROCEDURE validate_id
191: ------------------------
192: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
193: BEGIN
194: IF (p_id = OKL_API.G_MISS_NUM OR
195: p_id IS NULL)
196: THEN
197: OKL_API.set_message(p_app_name => G_APP_NAME,
198: p_msg_name => G_COL_ERROR,

Line 197: OKL_API.set_message(p_app_name => G_APP_NAME,

193: BEGIN
194: IF (p_id = OKL_API.G_MISS_NUM OR
195: p_id IS NULL)
196: THEN
197: OKL_API.set_message(p_app_name => G_APP_NAME,
198: p_msg_name => G_COL_ERROR,
199: p_token1 => G_COL_NAME_TOKEN,
200: p_token1_value => 'id',
201: p_token2 => G_PKG_NAME_TOKEN,

Line 203: RAISE OKL_API.G_EXCEPTION_ERROR;

199: p_token1 => G_COL_NAME_TOKEN,
200: p_token1_value => 'id',
201: p_token2 => G_PKG_NAME_TOKEN,
202: p_token2_value => G_PKG_NAME);
203: RAISE OKL_API.G_EXCEPTION_ERROR;
204: END IF;
205: x_return_status := G_RET_STS_SUCCESS;
206: END validate_id;
207:

Line 213: IF (p_object_version_number = OKL_API.G_MISS_NUM OR

209: -- PROCEDURE validate_object_version_number
210: -------------------------------------------
211: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
212: BEGIN
213: IF (p_object_version_number = OKL_API.G_MISS_NUM OR
214: p_object_version_number IS NULL)
215: THEN
216: OKL_API.set_message(p_app_name => G_APP_NAME,
217: p_msg_name => G_COL_ERROR,

Line 216: OKL_API.set_message(p_app_name => G_APP_NAME,

212: BEGIN
213: IF (p_object_version_number = OKL_API.G_MISS_NUM OR
214: p_object_version_number IS NULL)
215: THEN
216: OKL_API.set_message(p_app_name => G_APP_NAME,
217: p_msg_name => G_COL_ERROR,
218: p_token1 => G_COL_NAME_TOKEN,
219: p_token1_value => 'object_version_number',
220: p_token2 => G_PKG_NAME_TOKEN,

Line 222: RAISE OKL_API.G_EXCEPTION_ERROR;

218: p_token1 => G_COL_NAME_TOKEN,
219: p_token1_value => 'object_version_number',
220: p_token2 => G_PKG_NAME_TOKEN,
221: p_token2_value => G_PKG_NAME);
222: RAISE OKL_API.G_EXCEPTION_ERROR;
223: END IF;
224: x_return_status := G_RET_STS_SUCCESS;
225: END validate_object_version_number;
226:

Line 232: IF (p_org_id = OKL_API.G_MISS_NUM OR

228: -- PROCEDURE validate_org_id
229: ----------------------------
230: PROCEDURE validate_org_id (x_return_status OUT NOCOPY VARCHAR2, p_org_id IN NUMBER) IS
231: BEGIN
232: IF (p_org_id = OKL_API.G_MISS_NUM OR
233: p_org_id IS NULL)
234: THEN
235: OKL_API.set_message(p_app_name => G_APP_NAME,
236: p_msg_name => G_COL_ERROR,

Line 235: OKL_API.set_message(p_app_name => G_APP_NAME,

231: BEGIN
232: IF (p_org_id = OKL_API.G_MISS_NUM OR
233: p_org_id IS NULL)
234: THEN
235: OKL_API.set_message(p_app_name => G_APP_NAME,
236: p_msg_name => G_COL_ERROR,
237: p_token1 => G_COL_NAME_TOKEN,
238: p_token1_value => 'org_id',
239: p_token2 => G_PKG_NAME_TOKEN,

Line 241: RAISE OKL_API.G_EXCEPTION_ERROR;

237: p_token1 => G_COL_NAME_TOKEN,
238: p_token1_value => 'org_id',
239: p_token2 => G_PKG_NAME_TOKEN,
240: p_token2_value => G_PKG_NAME);
241: RAISE OKL_API.G_EXCEPTION_ERROR;
242: END IF;
243: x_return_status := G_RET_STS_SUCCESS;
244: END validate_org_id;
245:

Line 251: IF (p_name = OKL_API.G_MISS_CHAR OR

247: -- PROCEDURE validate_name
248: --------------------------
249: PROCEDURE validate_name (x_return_status OUT NOCOPY VARCHAR2, p_name IN VARCHAR2) IS
250: BEGIN
251: IF (p_name = OKL_API.G_MISS_CHAR OR
252: p_name IS NULL)
253: THEN
254: OKL_API.set_message(p_app_name => G_APP_NAME,
255: p_msg_name => G_COL_ERROR,

Line 254: OKL_API.set_message(p_app_name => G_APP_NAME,

250: BEGIN
251: IF (p_name = OKL_API.G_MISS_CHAR OR
252: p_name IS NULL)
253: THEN
254: OKL_API.set_message(p_app_name => G_APP_NAME,
255: p_msg_name => G_COL_ERROR,
256: p_token1 => G_COL_NAME_TOKEN,
257: p_token1_value => 'name',
258: p_token2 => G_PKG_NAME_TOKEN,

Line 260: RAISE OKL_API.G_EXCEPTION_ERROR;

256: p_token1 => G_COL_NAME_TOKEN,
257: p_token1_value => 'name',
258: p_token2 => G_PKG_NAME_TOKEN,
259: p_token2_value => G_PKG_NAME);
260: RAISE OKL_API.G_EXCEPTION_ERROR;
261: END IF;
262: x_return_status := G_RET_STS_SUCCESS;
263: END validate_name;
264:

Line 270: IF (p_template_status = OKL_API.G_MISS_CHAR OR

266: -- PROCEDURE validate_template_status
267: -------------------------------------
268: PROCEDURE validate_template_status (x_return_status OUT NOCOPY VARCHAR2, p_template_status IN VARCHAR2) IS
269: BEGIN
270: IF (p_template_status = OKL_API.G_MISS_CHAR OR
271: p_template_status IS NULL)
272: THEN
273: OKL_API.set_message(p_app_name => G_APP_NAME,
274: p_msg_name => G_COL_ERROR,

Line 273: OKL_API.set_message(p_app_name => G_APP_NAME,

269: BEGIN
270: IF (p_template_status = OKL_API.G_MISS_CHAR OR
271: p_template_status IS NULL)
272: THEN
273: OKL_API.set_message(p_app_name => G_APP_NAME,
274: p_msg_name => G_COL_ERROR,
275: p_token1 => G_COL_NAME_TOKEN,
276: p_token1_value => 'template_status',
277: p_token2 => G_PKG_NAME_TOKEN,

Line 279: RAISE OKL_API.G_EXCEPTION_ERROR;

275: p_token1 => G_COL_NAME_TOKEN,
276: p_token1_value => 'template_status',
277: p_token2 => G_PKG_NAME_TOKEN,
278: p_token2_value => G_PKG_NAME);
279: RAISE OKL_API.G_EXCEPTION_ERROR;
280: END IF;
281: x_return_status := G_RET_STS_SUCCESS;
282: END validate_template_status;
283:

Line 289: IF (p_credit_review = OKL_API.G_MISS_CHAR OR

285: -- PROCEDURE validate_credit_review
286: -----------------------------------
287: PROCEDURE validate_credit_review (x_return_status OUT NOCOPY VARCHAR2, p_credit_review IN VARCHAR2) IS
288: BEGIN
289: IF (p_credit_review = OKL_API.G_MISS_CHAR OR
290: p_credit_review IS NULL)
291: THEN
292: OKL_API.set_message(p_app_name => G_APP_NAME,
293: p_msg_name => G_COL_ERROR,

Line 292: OKL_API.set_message(p_app_name => G_APP_NAME,

288: BEGIN
289: IF (p_credit_review = OKL_API.G_MISS_CHAR OR
290: p_credit_review IS NULL)
291: THEN
292: OKL_API.set_message(p_app_name => G_APP_NAME,
293: p_msg_name => G_COL_ERROR,
294: p_token1 => G_COL_NAME_TOKEN,
295: p_token1_value => 'credit_review',
296: p_token2 => G_PKG_NAME_TOKEN,

Line 298: RAISE OKL_API.G_EXCEPTION_ERROR;

294: p_token1 => G_COL_NAME_TOKEN,
295: p_token1_value => 'credit_review',
296: p_token2 => G_PKG_NAME_TOKEN,
297: p_token2_value => G_PKG_NAME);
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300: x_return_status := G_RET_STS_SUCCESS;
301: END validate_credit_review;
302:

Line 308: IF (p_cust_credit_class = OKL_API.G_MISS_CHAR OR

304: -- PROCEDURE validate_cust_credit_class
305: ---------------------------------------
306: PROCEDURE validate_cust_credit_class (x_return_status OUT NOCOPY VARCHAR2, p_cust_credit_class IN VARCHAR2) IS
307: BEGIN
308: IF (p_cust_credit_class = OKL_API.G_MISS_CHAR OR
309: p_cust_credit_class IS NULL)
310: THEN
311: OKL_API.set_message(p_app_name => G_APP_NAME,
312: p_msg_name => G_COL_ERROR,

Line 311: OKL_API.set_message(p_app_name => G_APP_NAME,

307: BEGIN
308: IF (p_cust_credit_class = OKL_API.G_MISS_CHAR OR
309: p_cust_credit_class IS NULL)
310: THEN
311: OKL_API.set_message(p_app_name => G_APP_NAME,
312: p_msg_name => G_COL_ERROR,
313: p_token1 => G_COL_NAME_TOKEN,
314: p_token1_value => 'cust_credit_class',
315: p_token2 => G_PKG_NAME_TOKEN,

Line 317: RAISE OKL_API.G_EXCEPTION_ERROR;

313: p_token1 => G_COL_NAME_TOKEN,
314: p_token1_value => 'cust_credit_class',
315: p_token2 => G_PKG_NAME_TOKEN,
316: p_token2_value => G_PKG_NAME);
317: RAISE OKL_API.G_EXCEPTION_ERROR;
318: END IF;
319: x_return_status := G_RET_STS_SUCCESS;
320: END validate_cust_credit_class;
321:

Line 363: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

359: OPEN c_chk_tmlt_number;
360: FETCH c_chk_tmlt_number INTO l_check_tmplt_number;
361: CLOSE c_chk_tmlt_number;
362: IF l_check_tmplt_number = 'x' THEN
363: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
364: p_msg_name => 'OKL_SO_LSEAPP_TMPLT_EXISTS',
365: p_token1 => 'NAME',
366: p_token1_value => p_latv_rec.name);
367: -- notify caller of an error

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

493: EXCEPTION
494:
495: WHEN OTHERS THEN
496:
497: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
498: p_msg_name => G_DB_ERROR,
499: p_token1 => G_PROG_NAME_TOKEN,
500: p_token1_value => l_prog_name,
501: p_token2 => G_SQLCODE_TOKEN,

Line 539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

535:
536: l_return_status := validate_attributes(l_latv_rec);
537:
538: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
541: RAISE OKL_API.G_EXCEPTION_ERROR;
542: END IF;
543:

Line 541: RAISE OKL_API.G_EXCEPTION_ERROR;

537:
538: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
540: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
541: RAISE OKL_API.G_EXCEPTION_ERROR;
542: END IF;
543:
544: l_return_status := validate_record(l_latv_rec);
545:

Line 547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

543:
544: l_return_status := validate_record(l_latv_rec);
545:
546: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
549: RAISE OKL_API.G_EXCEPTION_ERROR;
550: END IF;
551:

Line 549: RAISE OKL_API.G_EXCEPTION_ERROR;

545:
546: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
549: RAISE OKL_API.G_EXCEPTION_ERROR;
550: END IF;
551:
552: migrate (l_latv_rec, l_lat_rec);
553:

Line 557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

553:
554: insert_row (x_return_status => l_return_status, p_lat_rec => l_lat_rec);
555:
556: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
558: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_ERROR;
560: END IF;
561:

Line 559: RAISE OKL_API.G_EXCEPTION_ERROR;

555:
556: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
558: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_ERROR;
560: END IF;
561:
562: x_latv_rec := l_latv_rec;
563: x_return_status := l_return_status;

Line 567: WHEN OKL_API.G_EXCEPTION_ERROR THEN

563: x_return_status := l_return_status;
564:
565: EXCEPTION
566:
567: WHEN OKL_API.G_EXCEPTION_ERROR THEN
568:
569: x_return_status := G_RET_STS_ERROR;
570:
571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

567: WHEN OKL_API.G_EXCEPTION_ERROR THEN
568:
569: x_return_status := G_RET_STS_ERROR;
570:
571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
572:
573: x_return_status := G_RET_STS_UNEXP_ERROR;
574:
575: WHEN OTHERS THEN

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

573: x_return_status := G_RET_STS_UNEXP_ERROR;
574:
575: WHEN OTHERS THEN
576:
577: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
578: p_msg_name => G_DB_ERROR,
579: p_token1 => G_PROG_NAME_TOKEN,
580: p_token1_value => l_prog_name,
581: p_token2 => G_SQLCODE_TOKEN,

Line 619: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

615: p_latv_rec => p_latv_rec,
616: x_latv_rec => x_latv_rec);
617:
618: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
619: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
620: ELSIF l_return_status = G_RET_STS_ERROR THEN
621: RAISE OKL_API.G_EXCEPTION_ERROR;
622: END IF;
623:

Line 621: RAISE OKL_API.G_EXCEPTION_ERROR;

617:
618: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
619: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
620: ELSIF l_return_status = G_RET_STS_ERROR THEN
621: RAISE OKL_API.G_EXCEPTION_ERROR;
622: END IF;
623:
624: x_return_status := l_return_status;
625:

Line 628: WHEN OKL_API.G_EXCEPTION_ERROR THEN

624: x_return_status := l_return_status;
625:
626: EXCEPTION
627:
628: WHEN OKL_API.G_EXCEPTION_ERROR THEN
629:
630: x_return_status := G_RET_STS_ERROR;
631:
632: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 632: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

628: WHEN OKL_API.G_EXCEPTION_ERROR THEN
629:
630: x_return_status := G_RET_STS_ERROR;
631:
632: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
633:
634: x_return_status := G_RET_STS_UNEXP_ERROR;
635:
636: WHEN OTHERS THEN

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

634: x_return_status := G_RET_STS_UNEXP_ERROR;
635:
636: WHEN OTHERS THEN
637:
638: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
639: p_msg_name => G_DB_ERROR,
640: p_token1 => G_PROG_NAME_TOKEN,
641: p_token1_value => l_prog_name,
642: p_token2 => G_SQLCODE_TOKEN,

Line 686: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

682: p_latv_rec => p_latv_tbl(i),
683: x_latv_rec => x_latv_tbl(i));
684:
685: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
686: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
687: ELSIF l_return_status = G_RET_STS_ERROR THEN
688: RAISE OKL_API.G_EXCEPTION_ERROR;
689: END IF;
690:

Line 688: RAISE OKL_API.G_EXCEPTION_ERROR;

684:
685: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
686: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
687: ELSIF l_return_status = G_RET_STS_ERROR THEN
688: RAISE OKL_API.G_EXCEPTION_ERROR;
689: END IF;
690:
691: EXIT WHEN (i = p_latv_tbl.LAST);
692: i := p_latv_tbl.NEXT(i);

Line 708: WHEN OKL_API.G_EXCEPTION_ERROR THEN

704: x_return_status := l_return_status;
705:
706: EXCEPTION
707:
708: WHEN OKL_API.G_EXCEPTION_ERROR THEN
709:
710: x_return_status := G_RET_STS_ERROR;
711:
712: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 712: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

708: WHEN OKL_API.G_EXCEPTION_ERROR THEN
709:
710: x_return_status := G_RET_STS_ERROR;
711:
712: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
713:
714: x_return_status := G_RET_STS_UNEXP_ERROR;
715:
716: WHEN OTHERS THEN

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

714: x_return_status := G_RET_STS_UNEXP_ERROR;
715:
716: WHEN OTHERS THEN
717:
718: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
719: p_msg_name => G_DB_ERROR,
720: p_token1 => G_PROG_NAME_TOKEN,
721: p_token1_value => l_prog_name,
722: p_token2 => G_SQLCODE_TOKEN,

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

767:
768: IF (lock_csr%ISOPEN) THEN
769: CLOSE lock_csr;
770: END IF;
771: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
772: p_msg_name => G_OVN_ERROR2,
773: p_token1 => G_PROG_NAME_TOKEN,
774: p_token1_value => l_prog_name);
775: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 775: RAISE OKL_API.G_EXCEPTION_ERROR;

771: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
772: p_msg_name => G_OVN_ERROR2,
773: p_token1 => G_PROG_NAME_TOKEN,
774: p_token1_value => l_prog_name);
775: RAISE OKL_API.G_EXCEPTION_ERROR;
776: END;
777:
778: IF l_object_version_number IS NULL THEN
779:

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

782: CLOSE lchk_csr;
783:
784: IF lc_object_version_number IS NULL THEN
785:
786: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
787: p_msg_name => G_OVN_ERROR3,
788: p_token1 => G_PROG_NAME_TOKEN,
789: p_token1_value => l_prog_name);
790:

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

789: p_token1_value => l_prog_name);
790:
791: ELSIF lc_object_version_number <> p_lat_rec.object_version_number THEN
792:
793: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
794: p_msg_name => G_OVN_ERROR,
795: p_token1 => G_PROG_NAME_TOKEN,
796: p_token1_value => l_prog_name);
797:

Line 800: RAISE OKL_API.G_EXCEPTION_ERROR;

796: p_token1_value => l_prog_name);
797:
798: END IF;
799:
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801:
802: END IF;
803:
804: x_return_status := G_RET_STS_SUCCESS;

Line 808: WHEN OKL_API.G_EXCEPTION_ERROR THEN

804: x_return_status := G_RET_STS_SUCCESS;
805:
806: EXCEPTION
807:
808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
809:
810: x_return_status := G_RET_STS_ERROR;
811:
812: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 812: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

808: WHEN OKL_API.G_EXCEPTION_ERROR THEN
809:
810: x_return_status := G_RET_STS_ERROR;
811:
812: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
813:
814: x_return_status := G_RET_STS_UNEXP_ERROR;
815:
816: WHEN OTHERS THEN

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

814: x_return_status := G_RET_STS_UNEXP_ERROR;
815:
816: WHEN OTHERS THEN
817:
818: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
819: p_msg_name => G_DB_ERROR,
820: p_token1 => G_PROG_NAME_TOKEN,
821: p_token1_value => l_prog_name,
822: p_token2 => G_SQLCODE_TOKEN,

Line 844: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

840:
841: lock_row (x_return_status => l_return_status, p_lat_rec => p_lat_rec);
842:
843: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
844: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
845: ELSIF l_return_status = G_RET_STS_ERROR THEN
846: RAISE OKL_API.G_EXCEPTION_ERROR;
847: END IF;
848:

Line 846: RAISE OKL_API.G_EXCEPTION_ERROR;

842:
843: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
844: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
845: ELSIF l_return_status = G_RET_STS_ERROR THEN
846: RAISE OKL_API.G_EXCEPTION_ERROR;
847: END IF;
848:
849: UPDATE okl_leaseapp_templates
850: SET

Line 883: WHEN OKL_API.G_EXCEPTION_ERROR THEN

879: x_return_status := l_return_status;
880:
881: EXCEPTION
882:
883: WHEN OKL_API.G_EXCEPTION_ERROR THEN
884: x_return_status := G_RET_STS_ERROR;
885:
886: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
887: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 886: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

882:
883: WHEN OKL_API.G_EXCEPTION_ERROR THEN
884: x_return_status := G_RET_STS_ERROR;
885:
886: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
887: x_return_status := G_RET_STS_UNEXP_ERROR;
888:
889: WHEN OTHERS THEN
890: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

886: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
887: x_return_status := G_RET_STS_UNEXP_ERROR;
888:
889: WHEN OTHERS THEN
890: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
891: p_msg_name => G_DB_ERROR,
892: p_token1 => G_PROG_NAME_TOKEN,
893: p_token1_value => l_prog_name,
894: p_token2 => G_SQLCODE_TOKEN,

Line 933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

929: x_latv_rec := p_latv_rec;
930: l_db_latv_rec := get_rec (p_latv_rec.id, l_return_status);
931:
932: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF l_return_status = G_RET_STS_ERROR THEN
935: RAISE OKL_API.G_EXCEPTION_ERROR;
936: END IF;
937:

Line 935: RAISE OKL_API.G_EXCEPTION_ERROR;

931:
932: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
934: ELSIF l_return_status = G_RET_STS_ERROR THEN
935: RAISE OKL_API.G_EXCEPTION_ERROR;
936: END IF;
937:
938: IF x_latv_rec.attribute_category IS NULL THEN
939: x_latv_rec.attribute_category := l_db_latv_rec.attribute_category;

Line 1018: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1014: RETURN l_return_status;
1015:
1016: EXCEPTION
1017:
1018: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1019:
1020: x_return_status := G_RET_STS_ERROR;
1021:
1022: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1022: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1018: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1019:
1020: x_return_status := G_RET_STS_ERROR;
1021:
1022: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1023:
1024: x_return_status := G_RET_STS_UNEXP_ERROR;
1025:
1026: WHEN OTHERS THEN

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

1024: x_return_status := G_RET_STS_UNEXP_ERROR;
1025:
1026: WHEN OTHERS THEN
1027:
1028: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1029: p_msg_name => G_DB_ERROR,
1030: p_token1 => G_PROG_NAME_TOKEN,
1031: p_token1_value => l_prog_name,
1032: p_token2 => G_SQLCODE_TOKEN,

Line 1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1045: l_return_status := populate_new_record (p_latv_rec, l_latv_rec);
1046: l_latv_rec := null_out_defaults(l_latv_rec);
1047:
1048: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;
1053:

Line 1051: RAISE OKL_API.G_EXCEPTION_ERROR;

1047:
1048: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1050: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;
1053:
1054: l_return_status := validate_attributes (l_latv_rec);
1055:

Line 1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1053:
1054: l_return_status := validate_attributes (l_latv_rec);
1055:
1056: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;
1061:

Line 1059: RAISE OKL_API.G_EXCEPTION_ERROR;

1055:
1056: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;
1061:
1062: l_return_status := validate_record (l_latv_rec);
1063:

Line 1065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1061:
1062: l_return_status := validate_record (l_latv_rec);
1063:
1064: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1066: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_ERROR;
1068: END IF;
1069:

Line 1067: RAISE OKL_API.G_EXCEPTION_ERROR;

1063:
1064: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1065: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1066: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1067: RAISE OKL_API.G_EXCEPTION_ERROR;
1068: END IF;
1069:
1070: migrate (l_latv_rec, l_lat_rec);
1071:

Line 1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1071:
1072: update_row (x_return_status => l_return_status, p_lat_rec => l_lat_rec);
1073:
1074: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1077: RAISE OKL_API.G_EXCEPTION_ERROR;
1078: END IF;
1079:

Line 1077: RAISE OKL_API.G_EXCEPTION_ERROR;

1073:
1074: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1076: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1077: RAISE OKL_API.G_EXCEPTION_ERROR;
1078: END IF;
1079:
1080: x_return_status := l_return_status;
1081: x_latv_rec := l_latv_rec;

Line 1085: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1081: x_latv_rec := l_latv_rec;
1082:
1083: EXCEPTION
1084:
1085: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1086:
1087: x_return_status := G_RET_STS_ERROR;
1088:
1089: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1089: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1085: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1086:
1087: x_return_status := G_RET_STS_ERROR;
1088:
1089: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1090:
1091: x_return_status := G_RET_STS_UNEXP_ERROR;
1092:
1093: WHEN OTHERS THEN

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

1091: x_return_status := G_RET_STS_UNEXP_ERROR;
1092:
1093: WHEN OTHERS THEN
1094:
1095: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1096: p_msg_name => G_DB_ERROR,
1097: p_token1 => G_PROG_NAME_TOKEN,
1098: p_token1_value => l_prog_name,
1099: p_token2 => G_SQLCODE_TOKEN,

Line 1137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1133: p_latv_rec => p_latv_rec,
1134: x_latv_rec => x_latv_rec);
1135:
1136: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1138: ELSIF l_return_status = G_RET_STS_ERROR THEN
1139: RAISE OKL_API.G_EXCEPTION_ERROR;
1140: END IF;
1141:

Line 1139: RAISE OKL_API.G_EXCEPTION_ERROR;

1135:
1136: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1137: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1138: ELSIF l_return_status = G_RET_STS_ERROR THEN
1139: RAISE OKL_API.G_EXCEPTION_ERROR;
1140: END IF;
1141:
1142: x_return_status := l_return_status;
1143:

Line 1146: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1142: x_return_status := l_return_status;
1143:
1144: EXCEPTION
1145:
1146: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1147:
1148: x_return_status := G_RET_STS_ERROR;
1149:
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1146: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1147:
1148: x_return_status := G_RET_STS_ERROR;
1149:
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151:
1152: x_return_status := G_RET_STS_UNEXP_ERROR;
1153:
1154: WHEN OTHERS THEN

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

1152: x_return_status := G_RET_STS_UNEXP_ERROR;
1153:
1154: WHEN OTHERS THEN
1155:
1156: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1157: p_msg_name => G_DB_ERROR,
1158: p_token1 => G_PROG_NAME_TOKEN,
1159: p_token1_value => l_prog_name,
1160: p_token2 => G_SQLCODE_TOKEN,

Line 1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1203: p_latv_rec => p_latv_tbl(i),
1204: x_latv_rec => x_latv_tbl(i));
1205:
1206: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF l_return_status = G_RET_STS_ERROR THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;
1211:

Line 1209: RAISE OKL_API.G_EXCEPTION_ERROR;

1205:
1206: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1207: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1208: ELSIF l_return_status = G_RET_STS_ERROR THEN
1209: RAISE OKL_API.G_EXCEPTION_ERROR;
1210: END IF;
1211:
1212: EXIT WHEN (i = p_latv_tbl.LAST);
1213: i := p_latv_tbl.NEXT(i);

Line 1229: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1225: x_return_status := l_return_status;
1226:
1227: EXCEPTION
1228:
1229: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1230:
1231: x_return_status := G_RET_STS_ERROR;
1232:
1233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1229: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1230:
1231: x_return_status := G_RET_STS_ERROR;
1232:
1233: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1234:
1235: x_return_status := G_RET_STS_UNEXP_ERROR;
1236:
1237: WHEN OTHERS THEN

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

1235: x_return_status := G_RET_STS_UNEXP_ERROR;
1236:
1237: WHEN OTHERS THEN
1238:
1239: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1240: p_msg_name => G_DB_ERROR,
1241: p_token1 => G_PROG_NAME_TOKEN,
1242: p_token1_value => l_prog_name,
1243: p_token2 => G_SQLCODE_TOKEN,

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

1269: EXCEPTION
1270:
1271: WHEN OTHERS THEN
1272:
1273: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1274: p_msg_name => G_DB_ERROR,
1275: p_token1 => G_PROG_NAME_TOKEN,
1276: p_token1_value => l_prog_name,
1277: p_token2 => G_SQLCODE_TOKEN,

Line 1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1309: delete_row (x_return_status => l_return_status,
1310: p_id => p_latv_rec.id);
1311:
1312: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF l_return_status = G_RET_STS_ERROR THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317:

Line 1315: RAISE OKL_API.G_EXCEPTION_ERROR;

1311:
1312: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1314: ELSIF l_return_status = G_RET_STS_ERROR THEN
1315: RAISE OKL_API.G_EXCEPTION_ERROR;
1316: END IF;
1317:
1318: x_return_status := l_return_status;
1319:

Line 1322: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1318: x_return_status := l_return_status;
1319:
1320: EXCEPTION
1321:
1322: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1323:
1324: x_return_status := G_RET_STS_ERROR;
1325:
1326: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1326: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1322: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1323:
1324: x_return_status := G_RET_STS_ERROR;
1325:
1326: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1327:
1328: x_return_status := G_RET_STS_UNEXP_ERROR;
1329:
1330: WHEN OTHERS THEN

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

1328: x_return_status := G_RET_STS_UNEXP_ERROR;
1329:
1330: WHEN OTHERS THEN
1331:
1332: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1333: p_msg_name => G_DB_ERROR,
1334: p_token1 => G_PROG_NAME_TOKEN,
1335: p_token1_value => l_prog_name,
1336: p_token2 => G_SQLCODE_TOKEN,

Line 1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1377: delete_row (x_return_status => l_return_status,
1378: p_id => p_latv_tbl(i).id);
1379:
1380: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF l_return_status = G_RET_STS_ERROR THEN
1383: RAISE OKL_API.G_EXCEPTION_ERROR;
1384: END IF;
1385:

Line 1383: RAISE OKL_API.G_EXCEPTION_ERROR;

1379:
1380: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1382: ELSIF l_return_status = G_RET_STS_ERROR THEN
1383: RAISE OKL_API.G_EXCEPTION_ERROR;
1384: END IF;
1385:
1386: EXIT WHEN (i = p_latv_tbl.LAST);
1387: i := p_latv_tbl.NEXT(i);

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

1401: EXCEPTION
1402:
1403: WHEN OTHERS THEN
1404:
1405: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1406: p_msg_name => G_DB_ERROR,
1407: p_token1 => G_PROG_NAME_TOKEN,
1408: p_token1_value => l_prog_name,
1409: p_token2 => G_SQLCODE_TOKEN,