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_RES_PVT dependencies on OKC_API

Line 222: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

218: FUNCTION Validate_Attributes (
219: p_res_rec IN okl_res_rec
220: ) RETURN VARCHAR2 IS
221: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_attributes';
222: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
223: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
224: BEGIN
225: -- ***
226: -- resi_cat_object_id

Line 279: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

275:
276: FUNCTION Validate_Record (
277: p_res_rec IN okl_res_rec
278: ) RETURN VARCHAR2 IS
279: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
280: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
281: BEGIN
282: RETURN (x_return_status);
283: END Validate_Record;

Line 290: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

286: -- Procedure insert_row_v
287: --------------------------------------------------------------------------------
288: PROCEDURE insert_row(
289: p_api_version IN NUMBER ,
290: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
291: x_return_status OUT NOCOPY VARCHAR2,
292: x_msg_count OUT NOCOPY NUMBER,
293: x_msg_data OUT NOCOPY VARCHAR2,
294: p_res_rec IN okl_res_rec,

Line 321: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

317: FUNCTION Set_Attributes(
318: p_res_rec IN okl_res_rec,
319: x_res_rec OUT NOCOPY okl_res_rec
320: ) RETURN VARCHAR2 IS
321: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
322: BEGIN
323: x_res_rec := p_res_rec;
324: RETURN (l_return_status);
325: END Set_Attributes;

Line 327: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

323: x_res_rec := p_res_rec;
324: RETURN (l_return_status);
325: END Set_Attributes;
326: BEGIN
327: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
328: G_PKG_NAME,
329: p_init_msg_list,
330: l_api_version,
331: p_api_version,

Line 335: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

331: p_api_version,
332: '_PVT',
333: x_return_status);
334: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
336: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
337: RAISE OKC_API.G_EXCEPTION_ERROR;
338: END IF;
339:

Line 337: RAISE OKC_API.G_EXCEPTION_ERROR;

333: x_return_status);
334: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
336: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
337: RAISE OKC_API.G_EXCEPTION_ERROR;
338: END IF;
339:
340: l_res_rec:=null_out_defaults(p_res_rec);
341: -- Set Primary key value

Line 346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

342: l_res_rec.RESI_CAT_OBJECT_ID := get_seq_id;
343: --Setting Item Attributes
344: l_return_status:=Set_Attributes(l_res_rec,l_def_res_rec);
345: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
348: RAISE OKC_API.G_EXCEPTION_ERROR;
349: END IF;
350: l_def_res_rec := fill_who_columns(l_def_res_rec);

Line 348: RAISE OKC_API.G_EXCEPTION_ERROR;

344: l_return_status:=Set_Attributes(l_res_rec,l_def_res_rec);
345: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
348: RAISE OKC_API.G_EXCEPTION_ERROR;
349: END IF;
350: l_def_res_rec := fill_who_columns(l_def_res_rec);
351:
352: l_return_status := Validate_Attributes(l_def_res_rec);

Line 354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

350: l_def_res_rec := fill_who_columns(l_def_res_rec);
351:
352: l_return_status := Validate_Attributes(l_def_res_rec);
353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
356: RAISE OKC_API.G_EXCEPTION_ERROR;
357: END IF;
358: l_return_status := Validate_Record(l_def_res_rec);

Line 356: RAISE OKC_API.G_EXCEPTION_ERROR;

352: l_return_status := Validate_Attributes(l_def_res_rec);
353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
356: RAISE OKC_API.G_EXCEPTION_ERROR;
357: END IF;
358: l_return_status := Validate_Record(l_def_res_rec);
359: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

356: RAISE OKC_API.G_EXCEPTION_ERROR;
357: END IF;
358: l_return_status := Validate_Record(l_def_res_rec);
359: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
361: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
362: RAISE OKC_API.G_EXCEPTION_ERROR;
363: END IF;
364: INSERT INTO OKL_FE_RESI_CAT_OBJECTS(

Line 362: RAISE OKC_API.G_EXCEPTION_ERROR;

358: l_return_status := Validate_Record(l_def_res_rec);
359: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
361: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
362: RAISE OKC_API.G_EXCEPTION_ERROR;
363: END IF;
364: INSERT INTO OKL_FE_RESI_CAT_OBJECTS(
365: RESI_CAT_OBJECT_ID,
366: OBJECT_VERSION_NUMBER,

Line 392: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

388: l_def_res_rec.CATEGORY_ID,
389: l_def_res_rec.CATEGORY_SET_ID);
390: --Set OUT Values
391: x_res_rec:= l_def_res_rec;
392: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
393:
394: EXCEPTION
395: WHEN G_EXCEPTION_HALT_VALIDATION then
396: -- No action necessary. Validation can continue to next attribute/column

Line 399: WHEN OKC_API.G_EXCEPTION_ERROR THEN

395: WHEN G_EXCEPTION_HALT_VALIDATION then
396: -- No action necessary. Validation can continue to next attribute/column
397: null;
398:
399: WHEN OKC_API.G_EXCEPTION_ERROR THEN
400: x_return_status := OKL_API.HANDLE_EXCEPTIONS
401: (
402: l_api_name,
403: G_PKG_NAME,

Line 410: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

406: x_msg_data,
407: '_PVT'
408: );
409:
410: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
411: x_return_status := OKL_API.HANDLE_EXCEPTIONS
412: (
413: l_api_name,
414: G_PKG_NAME,

Line 437: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

433: -- Procedure insert_row_tbl
434: --------------------------------------------------------------------------------
435: PROCEDURE insert_row(
436: p_api_version IN NUMBER ,
437: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
438: x_return_status OUT NOCOPY VARCHAR2,
439: x_msg_count OUT NOCOPY NUMBER,
440: x_msg_data OUT NOCOPY VARCHAR2,
441: p_res_tbl IN okl_res_tbl,

Line 449: OKC_API.init_msg_list(p_init_msg_list);

445: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
446: i NUMBER:=0;
447: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
448: BEGIN
449: OKC_API.init_msg_list(p_init_msg_list);
450: -- Make sure PL/SQL table has records in it before passing
451: IF (p_res_tbl.COUNT > 0) THEN
452: i := p_res_tbl.FIRST;
453: LOOP

Line 455: p_init_msg_list => OKC_API.G_FALSE,

451: IF (p_res_tbl.COUNT > 0) THEN
452: i := p_res_tbl.FIRST;
453: LOOP
454: insert_row (p_api_version => p_api_version,
455: p_init_msg_list => OKC_API.G_FALSE,
456: x_return_status => x_return_status,
457: x_msg_count => x_msg_count,
458: x_msg_data => x_msg_data,
459: p_res_rec => p_res_tbl(i),

Line 461: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

457: x_msg_count => x_msg_count,
458: x_msg_data => x_msg_data,
459: p_res_rec => p_res_tbl(i),
460: x_res_rec => x_res_tbl(i));
461: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
462: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
463: l_overall_status := x_return_status;
464: END IF;
465: END IF;

Line 462: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

458: x_msg_data => x_msg_data,
459: p_res_rec => p_res_tbl(i),
460: x_res_rec => x_res_tbl(i));
461: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
462: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
463: l_overall_status := x_return_status;
464: END IF;
465: END IF;
466:

Line 478: WHEN OKC_API.G_EXCEPTION_ERROR THEN

474: WHEN G_EXCEPTION_HALT_VALIDATION then
475: -- No action necessary. Validation can continue to next attribute/column
476: null;
477:
478: WHEN OKC_API.G_EXCEPTION_ERROR THEN
479: x_return_status := OKL_API.HANDLE_EXCEPTIONS
480: (
481: l_api_name,
482: G_PKG_NAME,

Line 489: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

485: x_msg_data,
486: '_PVT'
487: );
488:
489: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
490: x_return_status := OKL_API.HANDLE_EXCEPTIONS
491: (
492: l_api_name,
493: G_PKG_NAME,

Line 518: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

514: -- lock_row (REC)
515: -----------------
516: PROCEDURE lock_row(
517: p_api_version IN NUMBER,
518: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
519: x_return_status OUT NOCOPY VARCHAR2,
520: x_msg_count OUT NOCOPY NUMBER,
521: x_msg_data OUT NOCOPY VARCHAR2,
522: p_def_res_rec IN okl_res_rec) IS

Line 560: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

556: WHEN E_Resource_Busy THEN
557: IF (lock_csr%ISOPEN) THEN
558: CLOSE lock_csr;
559: END IF;
560: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
561: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
562: END;
563:
564: IF ( l_row_notfound ) THEN

Line 571: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

567: lc_row_notfound := lchk_csr%NOTFOUND;
568: CLOSE lchk_csr;
569: END IF;
570: IF (lc_row_notfound) THEN
571: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
572: RAISE OKC_API.G_EXCEPTION_ERROR;
573: ELSIF lc_object_version_number > p_def_res_rec.object_version_number THEN
574: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
575: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 572: RAISE OKC_API.G_EXCEPTION_ERROR;

568: CLOSE lchk_csr;
569: END IF;
570: IF (lc_row_notfound) THEN
571: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
572: RAISE OKC_API.G_EXCEPTION_ERROR;
573: ELSIF lc_object_version_number > p_def_res_rec.object_version_number THEN
574: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
575: RAISE OKC_API.G_EXCEPTION_ERROR;
576: ELSIF lc_object_version_number <> p_def_res_rec.object_version_number THEN

Line 574: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

570: IF (lc_row_notfound) THEN
571: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
572: RAISE OKC_API.G_EXCEPTION_ERROR;
573: ELSIF lc_object_version_number > p_def_res_rec.object_version_number THEN
574: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
575: RAISE OKC_API.G_EXCEPTION_ERROR;
576: ELSIF lc_object_version_number <> p_def_res_rec.object_version_number THEN
577: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
578: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 575: RAISE OKC_API.G_EXCEPTION_ERROR;

571: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
572: RAISE OKC_API.G_EXCEPTION_ERROR;
573: ELSIF lc_object_version_number > p_def_res_rec.object_version_number THEN
574: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
575: RAISE OKC_API.G_EXCEPTION_ERROR;
576: ELSIF lc_object_version_number <> p_def_res_rec.object_version_number THEN
577: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
578: RAISE OKC_API.G_EXCEPTION_ERROR;
579: ELSIF lc_object_version_number = -1 THEN

Line 577: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

573: ELSIF lc_object_version_number > p_def_res_rec.object_version_number THEN
574: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
575: RAISE OKC_API.G_EXCEPTION_ERROR;
576: ELSIF lc_object_version_number <> p_def_res_rec.object_version_number THEN
577: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
578: RAISE OKC_API.G_EXCEPTION_ERROR;
579: ELSIF lc_object_version_number = -1 THEN
580: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
581: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 578: RAISE OKC_API.G_EXCEPTION_ERROR;

574: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
575: RAISE OKC_API.G_EXCEPTION_ERROR;
576: ELSIF lc_object_version_number <> p_def_res_rec.object_version_number THEN
577: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
578: RAISE OKC_API.G_EXCEPTION_ERROR;
579: ELSIF lc_object_version_number = -1 THEN
580: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
581: RAISE OKC_API.G_EXCEPTION_ERROR;
582: END IF;

Line 580: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

576: ELSIF lc_object_version_number <> p_def_res_rec.object_version_number THEN
577: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
578: RAISE OKC_API.G_EXCEPTION_ERROR;
579: ELSIF lc_object_version_number = -1 THEN
580: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
581: RAISE OKC_API.G_EXCEPTION_ERROR;
582: END IF;
583:
584: x_return_status := l_return_status;

Line 581: RAISE OKC_API.G_EXCEPTION_ERROR;

577: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
578: RAISE OKC_API.G_EXCEPTION_ERROR;
579: ELSIF lc_object_version_number = -1 THEN
580: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
581: RAISE OKC_API.G_EXCEPTION_ERROR;
582: END IF;
583:
584: x_return_status := l_return_status;
585:

Line 617: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

613: -- lock_row (TBL)
614: -----------------
615: PROCEDURE lock_row(
616: p_api_version IN NUMBER,
617: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
618: x_return_status OUT NOCOPY VARCHAR2,
619: x_msg_count OUT NOCOPY NUMBER,
620: x_msg_data OUT NOCOPY VARCHAR2,
621: okl_res_tbl IN okl_res_tbl) IS

Line 691: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

687: -- Procedure update_row
688: --------------------------------------------------------------------------------
689: PROCEDURE update_row(
690: p_api_version IN NUMBER ,
691: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
692: x_return_status OUT NOCOPY VARCHAR2,
693: x_msg_count OUT NOCOPY NUMBER,
694: x_msg_data OUT NOCOPY VARCHAR2,
695: p_res_rec IN okl_res_rec,

Line 786: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

782: FUNCTION Set_Attributes(
783: p_res_rec IN okl_res_rec,
784: x_res_rec OUT NOCOPY okl_res_rec
785: ) RETURN VARCHAR2 IS
786: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
787: BEGIN
788: x_res_rec := p_res_rec;
789: RETURN (l_return_status);
790: END Set_Attributes;

Line 792: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

788: x_res_rec := p_res_rec;
789: RETURN (l_return_status);
790: END Set_Attributes;
791: BEGIN
792: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
793: G_PKG_NAME,
794: p_init_msg_list,
795: l_api_version,
796: p_api_version,

Line 800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 802: RAISE OKC_API.G_EXCEPTION_ERROR;

798: x_return_status);
799: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
802: RAISE OKC_API.G_EXCEPTION_ERROR;
803: END IF;
804:
805: --Setting Item Attributes
806: l_return_status:=Set_Attributes(l_res_rec,l_def_res_rec);

Line 808: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

804:
805: --Setting Item Attributes
806: l_return_status:=Set_Attributes(l_res_rec,l_def_res_rec);
807: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
808: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
809: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
810: RAISE OKC_API.G_EXCEPTION_ERROR;
811: END IF;
812:

Line 810: RAISE OKC_API.G_EXCEPTION_ERROR;

806: l_return_status:=Set_Attributes(l_res_rec,l_def_res_rec);
807: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
808: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
809: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
810: RAISE OKC_API.G_EXCEPTION_ERROR;
811: END IF;
812:
813: l_return_status := populate_new_record(l_res_rec,l_def_res_rec);
814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

811: END IF;
812:
813: l_return_status := populate_new_record(l_res_rec,l_def_res_rec);
814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;
819:

Line 817: RAISE OKC_API.G_EXCEPTION_ERROR;

813: l_return_status := populate_new_record(l_res_rec,l_def_res_rec);
814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;
819:
820:
821: l_def_res_rec := fill_who_columns(l_def_res_rec);

Line 825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

821: l_def_res_rec := fill_who_columns(l_def_res_rec);
822:
823: l_return_status := Validate_Attributes(l_def_res_rec);
824: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
827: RAISE OKC_API.G_EXCEPTION_ERROR;
828: END IF;
829:

Line 827: RAISE OKC_API.G_EXCEPTION_ERROR;

823: l_return_status := Validate_Attributes(l_def_res_rec);
824: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
827: RAISE OKC_API.G_EXCEPTION_ERROR;
828: END IF;
829:
830: l_return_status := Validate_Record(l_def_res_rec);
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

828: END IF;
829:
830: l_return_status := Validate_Record(l_def_res_rec);
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
834: RAISE OKC_API.G_EXCEPTION_ERROR;
835: END IF;
836:

Line 834: RAISE OKC_API.G_EXCEPTION_ERROR;

830: l_return_status := Validate_Record(l_def_res_rec);
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
834: RAISE OKC_API.G_EXCEPTION_ERROR;
835: END IF;
836:
837: -- Lock the row before updating
838: lock_row(p_api_version => G_API_VERSION,

Line 869: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

865: WHERE RESI_CAT_OBJECT_ID = l_def_res_rec.RESI_CAT_OBJECT_ID;
866:
867: --Set OUT Values
868: x_res_rec:= l_def_res_rec;
869: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
870:
871: EXCEPTION
872: WHEN G_EXCEPTION_HALT_VALIDATION then
873: -- No action necessary. Validation can continue to next attribute/column

Line 876: WHEN OKC_API.G_EXCEPTION_ERROR THEN

872: WHEN G_EXCEPTION_HALT_VALIDATION then
873: -- No action necessary. Validation can continue to next attribute/column
874: null;
875:
876: WHEN OKC_API.G_EXCEPTION_ERROR THEN
877: x_return_status := OKL_API.HANDLE_EXCEPTIONS
878: (
879: l_api_name,
880: G_PKG_NAME,

Line 887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

883: x_msg_data,
884: '_PVT'
885: );
886:
887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
888: x_return_status := OKL_API.HANDLE_EXCEPTIONS
889: (
890: l_api_name,
891: G_PKG_NAME,

Line 914: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

910: -- Procedure insert_row_tbl
911: --------------------------------------------------------------------------------
912: PROCEDURE update_row(
913: p_api_version IN NUMBER ,
914: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
915: x_return_status OUT NOCOPY VARCHAR2,
916: x_msg_count OUT NOCOPY NUMBER,
917: x_msg_data OUT NOCOPY VARCHAR2,
918: p_res_tbl IN okl_res_tbl,

Line 926: OKC_API.init_msg_list(p_init_msg_list);

922: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
923: i NUMBER:=0;
924: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
925: BEGIN
926: OKC_API.init_msg_list(p_init_msg_list);
927: -- Make sure PL/SQL table has records in it before passing
928: IF (p_res_tbl.COUNT > 0) THEN
929: i := p_res_tbl.FIRST;
930: LOOP

Line 932: p_init_msg_list => OKC_API.G_FALSE,

928: IF (p_res_tbl.COUNT > 0) THEN
929: i := p_res_tbl.FIRST;
930: LOOP
931: update_row (p_api_version => p_api_version,
932: p_init_msg_list => OKC_API.G_FALSE,
933: x_return_status => x_return_status,
934: x_msg_count => x_msg_count,
935: x_msg_data => x_msg_data,
936: p_res_rec => p_res_tbl(i),

Line 938: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

934: x_msg_count => x_msg_count,
935: x_msg_data => x_msg_data,
936: p_res_rec => p_res_tbl(i),
937: x_res_rec => x_res_tbl(i));
938: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
939: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
940: l_overall_status := x_return_status;
941: END IF;
942: END IF;

Line 939: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

935: x_msg_data => x_msg_data,
936: p_res_rec => p_res_tbl(i),
937: x_res_rec => x_res_tbl(i));
938: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
939: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
940: l_overall_status := x_return_status;
941: END IF;
942: END IF;
943:

Line 955: WHEN OKC_API.G_EXCEPTION_ERROR THEN

951: WHEN G_EXCEPTION_HALT_VALIDATION then
952: -- No action necessary. Validation can continue to next attribute/column
953: null;
954:
955: WHEN OKC_API.G_EXCEPTION_ERROR THEN
956: x_return_status := OKL_API.HANDLE_EXCEPTIONS
957: (
958: l_api_name,
959: G_PKG_NAME,

Line 966: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

962: x_msg_data,
963: '_PVT'
964: );
965:
966: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
967: x_return_status := OKL_API.HANDLE_EXCEPTIONS
968: (
969: l_api_name,
970: G_PKG_NAME,

Line 993: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

989: -- Procedure delete_row
990: --------------------------------------------------------------------------------
991: PROCEDURE delete_row(
992: p_api_version IN NUMBER ,
993: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
994: x_return_status OUT NOCOPY VARCHAR2,
995: x_msg_count OUT NOCOPY NUMBER,
996: x_msg_data OUT NOCOPY VARCHAR2,
997: p_res_rec IN okl_res_rec)IS

Line 1005: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1001: l_res_rec okl_res_rec := p_res_rec;
1002: l_row_notfound BOOLEAN:=TRUE;
1003:
1004: BEGIN
1005: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1006: G_PKG_NAME,
1007: p_init_msg_list,
1008: l_api_version,
1009: p_api_version,

Line 1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1009: p_api_version,
1010: '_PVT',
1011: x_return_status);
1012: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;
1017:

Line 1015: RAISE OKC_API.G_EXCEPTION_ERROR;

1011: x_return_status);
1012: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;
1017:
1018: DELETE FROM OKL_FE_RESI_CAT_OBJECTS
1019: WHERE RESI_CAT_OBJECT_ID=l_res_rec.RESI_CAT_OBJECT_ID;

Line 1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1022: WHEN G_EXCEPTION_HALT_VALIDATION then
1023: -- No action necessary. Validation can continue to next attribute/column
1024: null;
1025:
1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,

Line 1037: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1033: x_msg_data,
1034: '_PVT'
1035: );
1036:
1037: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1038: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1039: (
1040: l_api_name,
1041: G_PKG_NAME,

Line 1065: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1061: -- Procedure delete_row_tbl
1062: --------------------------------------------------------------------------------
1063: PROCEDURE delete_row(
1064: p_api_version IN NUMBER ,
1065: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1066: x_return_status OUT NOCOPY VARCHAR2,
1067: x_msg_count OUT NOCOPY NUMBER,
1068: x_msg_data OUT NOCOPY VARCHAR2,
1069: p_res_tbl IN okl_res_tbl)IS

Line 1076: OKC_API.init_msg_list(p_init_msg_list);

1072: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1073: i NUMBER:=0;
1074: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1075: BEGIN
1076: OKC_API.init_msg_list(p_init_msg_list);
1077: -- Make sure PL/SQL table has records in it before passing
1078: IF (p_res_tbl.COUNT > 0) THEN
1079: i := p_res_tbl.FIRST;
1080: LOOP

Line 1082: p_init_msg_list => OKC_API.G_FALSE,

1078: IF (p_res_tbl.COUNT > 0) THEN
1079: i := p_res_tbl.FIRST;
1080: LOOP
1081: delete_row (p_api_version => p_api_version,
1082: p_init_msg_list => OKC_API.G_FALSE,
1083: x_return_status => x_return_status,
1084: x_msg_count => x_msg_count,
1085: x_msg_data => x_msg_data,
1086: p_res_rec => p_res_tbl(i));

Line 1087: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1083: x_return_status => x_return_status,
1084: x_msg_count => x_msg_count,
1085: x_msg_data => x_msg_data,
1086: p_res_rec => p_res_tbl(i));
1087: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1088: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1089: l_overall_status := x_return_status;
1090: END IF;
1091: END IF;

Line 1088: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

1084: x_msg_count => x_msg_count,
1085: x_msg_data => x_msg_data,
1086: p_res_rec => p_res_tbl(i));
1087: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1088: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1089: l_overall_status := x_return_status;
1090: END IF;
1091: END IF;
1092:

Line 1104: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1100: WHEN G_EXCEPTION_HALT_VALIDATION then
1101: -- No action necessary. Validation can continue to next attribute/column
1102: null;
1103:
1104: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1105: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1106: (
1107: l_api_name,
1108: G_PKG_NAME,

Line 1115: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1111: x_msg_data,
1112: '_PVT'
1113: );
1114:
1115: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1116: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1117: (
1118: l_api_name,
1119: G_PKG_NAME,