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

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

303: EXCEPTION
304:
305: WHEN OTHERS THEN
306:
307: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
308: p_msg_name => G_DB_ERROR,
309: p_token1 => G_PROG_NAME_TOKEN,
310: p_token1_value => l_prog_name,
311: p_token2 => G_SQLCODE_TOKEN,

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

323: ------------------------
324: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
325: BEGIN
326: IF p_id IS NULL THEN
327: OKL_API.set_message(p_app_name => G_APP_NAME,
328: p_msg_name => G_COL_ERROR,
329: p_token1 => G_COL_NAME_TOKEN,
330: p_token1_value => 'id',
331: p_token2 => G_PKG_NAME_TOKEN,

Line 333: RAISE OKL_API.G_EXCEPTION_ERROR;

329: p_token1 => G_COL_NAME_TOKEN,
330: p_token1_value => 'id',
331: p_token2 => G_PKG_NAME_TOKEN,
332: p_token2_value => G_PKG_NAME);
333: RAISE OKL_API.G_EXCEPTION_ERROR;
334: END IF;
335: x_return_status := G_RET_STS_SUCCESS;
336: END validate_id;
337:

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

341: -------------------------------------------
342: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
343: BEGIN
344: IF p_object_version_number IS NULL THEN
345: OKL_API.set_message(p_app_name => G_APP_NAME,
346: p_msg_name => G_COL_ERROR,
347: p_token1 => G_COL_NAME_TOKEN,
348: p_token1_value => 'object_version_number',
349: p_token2 => G_PKG_NAME_TOKEN,

Line 351: RAISE OKL_API.G_EXCEPTION_ERROR;

347: p_token1 => G_COL_NAME_TOKEN,
348: p_token1_value => 'object_version_number',
349: p_token2 => G_PKG_NAME_TOKEN,
350: p_token2_value => G_PKG_NAME);
351: RAISE OKL_API.G_EXCEPTION_ERROR;
352: END IF;
353: x_return_status := G_RET_STS_SUCCESS;
354: END validate_object_version_number;
355:

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

359: -----------------------------------------
360: PROCEDURE validate_parent_object_code (x_return_status OUT NOCOPY VARCHAR2, p_parent_object_code IN VARCHAR2) IS
361: BEGIN
362: IF p_parent_object_code IS NULL THEN
363: OKL_API.set_message(p_app_name => G_APP_NAME,
364: p_msg_name => G_COL_ERROR,
365: p_token1 => G_COL_NAME_TOKEN,
366: p_token1_value => 'parent_object_code',
367: p_token2 => G_PKG_NAME_TOKEN,

Line 369: RAISE OKL_API.G_EXCEPTION_ERROR;

365: p_token1 => G_COL_NAME_TOKEN,
366: p_token1_value => 'parent_object_code',
367: p_token2 => G_PKG_NAME_TOKEN,
368: p_token2_value => G_PKG_NAME);
369: RAISE OKL_API.G_EXCEPTION_ERROR;
370: END IF;
371: x_return_status := G_RET_STS_SUCCESS;
372: END validate_parent_object_code;
373:

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

377: -----------------------------------------
378: PROCEDURE validate_parent_object_id (x_return_status OUT NOCOPY VARCHAR2, p_parent_object_id IN NUMBER) IS
379: BEGIN
380: IF p_parent_object_id IS NULL THEN
381: OKL_API.set_message(p_app_name => G_APP_NAME,
382: p_msg_name => G_COL_ERROR,
383: p_token1 => G_COL_NAME_TOKEN,
384: p_token1_value => 'parent_object_id',
385: p_token2 => G_PKG_NAME_TOKEN,

Line 387: RAISE OKL_API.G_EXCEPTION_ERROR;

383: p_token1 => G_COL_NAME_TOKEN,
384: p_token1_value => 'parent_object_id',
385: p_token2 => G_PKG_NAME_TOKEN,
386: p_token2_value => G_PKG_NAME);
387: RAISE OKL_API.G_EXCEPTION_ERROR;
388: END IF;
389: x_return_status := G_RET_STS_SUCCESS;
390: END validate_parent_object_id;
391:

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

401:
402: l_already_exists VARCHAR2(3) := 'N';
403: BEGIN
404: IF p_asset_number IS NULL THEN
405: OKL_API.set_message(p_app_name => G_APP_NAME,
406: p_msg_name => G_COL_ERROR,
407: p_token1 => G_COL_NAME_TOKEN,
408: p_token1_value => 'asset_number',
409: p_token2 => G_PKG_NAME_TOKEN,

Line 411: RAISE OKL_API.G_EXCEPTION_ERROR;

407: p_token1 => G_COL_NAME_TOKEN,
408: p_token1_value => 'asset_number',
409: p_token2 => G_PKG_NAME_TOKEN,
410: p_token2_value => G_PKG_NAME);
411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;
413: OPEN c_ast_num(p_asset_number);
414: FETCH c_ast_num INTO l_already_exists;
415: CLOSE c_ast_num;

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

414: FETCH c_ast_num INTO l_already_exists;
415: CLOSE c_ast_num;
416:
417: IF l_already_exists ='Y' THEN
418: OKL_API.set_message(p_app_name => G_APP_NAME,
419: p_msg_name => 'OKL_ASSET_EXISTS',
420: p_token1 => 'ASSET_NUM',
421: p_token1_value => p_asset_number);
422: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 422: RAISE OKL_API.G_EXCEPTION_ERROR;

418: OKL_API.set_message(p_app_name => G_APP_NAME,
419: p_msg_name => 'OKL_ASSET_EXISTS',
420: p_token1 => 'ASSET_NUM',
421: p_token1_value => p_asset_number);
422: RAISE OKL_API.G_EXCEPTION_ERROR;
423: END IF;
424: x_return_status := G_RET_STS_SUCCESS;
425: END validate_asset_number;
426:

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

430: -----------------------------------------
431: PROCEDURE validate_install_site_id (x_return_status OUT NOCOPY VARCHAR2, p_install_site_id IN NUMBER) IS
432: BEGIN
433: IF p_install_site_id IS NULL THEN
434: OKL_API.set_message(p_app_name => G_APP_NAME,
435: p_msg_name => G_COL_ERROR,
436: p_token1 => G_COL_NAME_TOKEN,
437: p_token1_value => 'install_site_id',
438: p_token2 => G_PKG_NAME_TOKEN,

Line 440: RAISE OKL_API.G_EXCEPTION_ERROR;

436: p_token1 => G_COL_NAME_TOKEN,
437: p_token1_value => 'install_site_id',
438: p_token2 => G_PKG_NAME_TOKEN,
439: p_token2_value => G_PKG_NAME);
440: RAISE OKL_API.G_EXCEPTION_ERROR;
441: END IF;
442: x_return_status := G_RET_STS_SUCCESS;
443: END validate_install_site_id;
444:

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

630: EXCEPTION
631:
632: WHEN OTHERS THEN
633:
634: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
635: p_msg_name => G_DB_ERROR,
636: p_token1 => G_PROG_NAME_TOKEN,
637: p_token1_value => l_prog_name,
638: p_token2 => G_SQLCODE_TOKEN,

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

705: EXCEPTION
706:
707: WHEN OTHERS THEN
708:
709: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
710: p_msg_name => G_DB_ERROR,
711: p_token1 => G_PROG_NAME_TOKEN,
712: p_token1_value => l_prog_name,
713: p_token2 => G_SQLCODE_TOKEN,

Line 754: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

750:
751: l_return_status := validate_attributes(l_assv_rec);
752:
753: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
754: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
755: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
756: RAISE OKL_API.G_EXCEPTION_ERROR;
757: END IF;
758:

Line 756: RAISE OKL_API.G_EXCEPTION_ERROR;

752:
753: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
754: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
755: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
756: RAISE OKL_API.G_EXCEPTION_ERROR;
757: END IF;
758:
759: l_return_status := validate_record(l_assv_rec);
760:

Line 762: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

758:
759: l_return_status := validate_record(l_assv_rec);
760:
761: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
762: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
764: RAISE OKL_API.G_EXCEPTION_ERROR;
765: END IF;
766:

Line 764: RAISE OKL_API.G_EXCEPTION_ERROR;

760:
761: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
762: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
763: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
764: RAISE OKL_API.G_EXCEPTION_ERROR;
765: END IF;
766:
767: migrate (l_assv_rec, l_ass_rec);
768: migrate (l_assv_rec, l_asstl_rec);

Line 773: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

769:
770: insert_row (x_return_status => l_return_status, p_ass_rec => l_ass_rec);
771:
772: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
773: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
774: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
775: RAISE OKL_API.G_EXCEPTION_ERROR;
776: END IF;
777:

Line 775: RAISE OKL_API.G_EXCEPTION_ERROR;

771:
772: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
773: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
774: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
775: RAISE OKL_API.G_EXCEPTION_ERROR;
776: END IF;
777:
778: insert_row (x_return_status => l_return_status, p_asstl_rec => l_asstl_rec);
779:

Line 781: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

777:
778: insert_row (x_return_status => l_return_status, p_asstl_rec => l_asstl_rec);
779:
780: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
781: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
782: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
783: RAISE OKL_API.G_EXCEPTION_ERROR;
784: END IF;
785:

Line 783: RAISE OKL_API.G_EXCEPTION_ERROR;

779:
780: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
781: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
782: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
783: RAISE OKL_API.G_EXCEPTION_ERROR;
784: END IF;
785:
786: x_assv_rec := l_assv_rec;
787: x_return_status := l_return_status;

Line 791: WHEN OKL_API.G_EXCEPTION_ERROR THEN

787: x_return_status := l_return_status;
788:
789: EXCEPTION
790:
791: WHEN OKL_API.G_EXCEPTION_ERROR THEN
792:
793: x_return_status := G_RET_STS_ERROR;
794:
795: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 795: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

791: WHEN OKL_API.G_EXCEPTION_ERROR THEN
792:
793: x_return_status := G_RET_STS_ERROR;
794:
795: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
796:
797: x_return_status := G_RET_STS_UNEXP_ERROR;
798:
799: WHEN OTHERS THEN

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

797: x_return_status := G_RET_STS_UNEXP_ERROR;
798:
799: WHEN OTHERS THEN
800:
801: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
802: p_msg_name => G_DB_ERROR,
803: p_token1 => G_PROG_NAME_TOKEN,
804: p_token1_value => l_prog_name,
805: p_token2 => G_SQLCODE_TOKEN,

Line 844: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

840: p_assv_rec => p_assv_rec,
841: x_assv_rec => x_assv_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: x_return_status := l_return_status;
850:

Line 853: WHEN OKL_API.G_EXCEPTION_ERROR THEN

849: x_return_status := l_return_status;
850:
851: EXCEPTION
852:
853: WHEN OKL_API.G_EXCEPTION_ERROR THEN
854:
855: x_return_status := G_RET_STS_ERROR;
856:
857: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 857: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

853: WHEN OKL_API.G_EXCEPTION_ERROR THEN
854:
855: x_return_status := G_RET_STS_ERROR;
856:
857: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
858:
859: x_return_status := G_RET_STS_UNEXP_ERROR;
860:
861: WHEN OTHERS THEN

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

859: x_return_status := G_RET_STS_UNEXP_ERROR;
860:
861: WHEN OTHERS THEN
862:
863: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
864: p_msg_name => G_DB_ERROR,
865: p_token1 => G_PROG_NAME_TOKEN,
866: p_token1_value => l_prog_name,
867: p_token2 => G_SQLCODE_TOKEN,

Line 912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

908: p_assv_rec => p_assv_tbl(i),
909: x_assv_rec => x_assv_tbl(i));
910:
911: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
913: ELSIF l_return_status = G_RET_STS_ERROR THEN
914: RAISE OKL_API.G_EXCEPTION_ERROR;
915: END IF;
916:

Line 914: RAISE OKL_API.G_EXCEPTION_ERROR;

910:
911: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
913: ELSIF l_return_status = G_RET_STS_ERROR THEN
914: RAISE OKL_API.G_EXCEPTION_ERROR;
915: END IF;
916:
917: EXIT WHEN (i = p_assv_tbl.LAST);
918: i := p_assv_tbl.NEXT(i);

Line 934: WHEN OKL_API.G_EXCEPTION_ERROR THEN

930: x_return_status := l_return_status;
931:
932: EXCEPTION
933:
934: WHEN OKL_API.G_EXCEPTION_ERROR THEN
935:
936: x_return_status := G_RET_STS_ERROR;
937:
938: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 938: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

934: WHEN OKL_API.G_EXCEPTION_ERROR THEN
935:
936: x_return_status := G_RET_STS_ERROR;
937:
938: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
939:
940: x_return_status := G_RET_STS_UNEXP_ERROR;
941:
942: WHEN OTHERS THEN

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

940: x_return_status := G_RET_STS_UNEXP_ERROR;
941:
942: WHEN OTHERS THEN
943:
944: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
945: p_msg_name => G_DB_ERROR,
946: p_token1 => G_PROG_NAME_TOKEN,
947: p_token1_value => l_prog_name,
948: p_token2 => G_SQLCODE_TOKEN,

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

994:
995: IF (lock_csr%ISOPEN) THEN
996: CLOSE lock_csr;
997: END IF;
998: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
999: p_msg_name => G_OVN_ERROR2,
1000: p_token1 => G_PROG_NAME_TOKEN,
1001: p_token1_value => l_prog_name);
1002: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1002: RAISE OKL_API.G_EXCEPTION_ERROR;

998: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
999: p_msg_name => G_OVN_ERROR2,
1000: p_token1 => G_PROG_NAME_TOKEN,
1001: p_token1_value => l_prog_name);
1002: RAISE OKL_API.G_EXCEPTION_ERROR;
1003: END;
1004:
1005: IF l_object_version_number IS NULL THEN
1006:

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

1009: CLOSE lchk_csr;
1010:
1011: IF lc_object_version_number IS NULL THEN
1012:
1013: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1014: p_msg_name => G_OVN_ERROR3,
1015: p_token1 => G_PROG_NAME_TOKEN,
1016: p_token1_value => l_prog_name);
1017:

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

1016: p_token1_value => l_prog_name);
1017:
1018: ELSIF lc_object_version_number <> p_ass_rec.object_version_number THEN
1019:
1020: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1021: p_msg_name => G_OVN_ERROR,
1022: p_token1 => G_PROG_NAME_TOKEN,
1023: p_token1_value => l_prog_name);
1024:

Line 1027: RAISE OKL_API.G_EXCEPTION_ERROR;

1023: p_token1_value => l_prog_name);
1024:
1025: END IF;
1026:
1027: RAISE OKL_API.G_EXCEPTION_ERROR;
1028:
1029: END IF;
1030:
1031: x_return_status := G_RET_STS_SUCCESS;

Line 1035: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1031: x_return_status := G_RET_STS_SUCCESS;
1032:
1033: EXCEPTION
1034:
1035: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1036:
1037: x_return_status := G_RET_STS_ERROR;
1038:
1039: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1039: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1035: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1036:
1037: x_return_status := G_RET_STS_ERROR;
1038:
1039: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1040:
1041: x_return_status := G_RET_STS_UNEXP_ERROR;
1042:
1043: WHEN OTHERS THEN

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

1041: x_return_status := G_RET_STS_UNEXP_ERROR;
1042:
1043: WHEN OTHERS THEN
1044:
1045: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1046: p_msg_name => G_DB_ERROR,
1047: p_token1 => G_PROG_NAME_TOKEN,
1048: p_token1_value => l_prog_name,
1049: p_token2 => G_SQLCODE_TOKEN,

Line 1075: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1071:
1072: lock_row (x_return_status => l_return_status, p_ass_rec => p_ass_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: UPDATE okl_assets_b
1081: SET

Line 1121: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1117: x_return_status := l_return_status;
1118:
1119: EXCEPTION
1120:
1121: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1122: x_return_status := G_RET_STS_ERROR;
1123:
1124: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1125: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1124: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1120:
1121: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1122: x_return_status := G_RET_STS_ERROR;
1123:
1124: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1125: x_return_status := G_RET_STS_UNEXP_ERROR;
1126:
1127: WHEN OTHERS THEN
1128: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1124: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1125: x_return_status := G_RET_STS_UNEXP_ERROR;
1126:
1127: WHEN OTHERS THEN
1128: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1129: p_msg_name => G_DB_ERROR,
1130: p_token1 => G_PROG_NAME_TOKEN,
1131: p_token1_value => l_prog_name,
1132: p_token2 => G_SQLCODE_TOKEN,

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

1172: EXCEPTION
1173:
1174: WHEN OTHERS THEN
1175:
1176: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1177: p_msg_name => G_DB_ERROR,
1178: p_token1 => G_PROG_NAME_TOKEN,
1179: p_token1_value => l_prog_name,
1180: p_token2 => G_SQLCODE_TOKEN,

Line 1221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1217: x_assv_rec := p_assv_rec;
1218: l_db_assv_rec := get_rec (p_assv_rec.id, l_return_status);
1219:
1220: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1222: ELSIF l_return_status = G_RET_STS_ERROR THEN
1223: RAISE OKL_API.G_EXCEPTION_ERROR;
1224: END IF;
1225:

Line 1223: RAISE OKL_API.G_EXCEPTION_ERROR;

1219:
1220: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1221: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1222: ELSIF l_return_status = G_RET_STS_ERROR THEN
1223: RAISE OKL_API.G_EXCEPTION_ERROR;
1224: END IF;
1225:
1226: IF x_assv_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1227: x_assv_rec.attribute_category := l_db_assv_rec.attribute_category;

Line 1336: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1332: RETURN l_return_status;
1333:
1334: EXCEPTION
1335:
1336: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1337:
1338: x_return_status := G_RET_STS_ERROR;
1339:
1340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1336: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1337:
1338: x_return_status := G_RET_STS_ERROR;
1339:
1340: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1341:
1342: x_return_status := G_RET_STS_UNEXP_ERROR;
1343:
1344: WHEN OTHERS THEN

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

1342: x_return_status := G_RET_STS_UNEXP_ERROR;
1343:
1344: WHEN OTHERS THEN
1345:
1346: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1347: p_msg_name => G_DB_ERROR,
1348: p_token1 => G_PROG_NAME_TOKEN,
1349: p_token1_value => l_prog_name,
1350: p_token2 => G_SQLCODE_TOKEN,

Line 1366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1362:
1363: l_return_status := populate_new_record (p_assv_rec, l_assv_rec);
1364:
1365: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1367: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1368: RAISE OKL_API.G_EXCEPTION_ERROR;
1369: END IF;
1370:

Line 1368: RAISE OKL_API.G_EXCEPTION_ERROR;

1364:
1365: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1366: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1367: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1368: RAISE OKL_API.G_EXCEPTION_ERROR;
1369: END IF;
1370:
1371: -- Bug 7004288
1372: /*l_return_status := validate_attributes (l_assv_rec);

Line 1375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1371: -- Bug 7004288
1372: /*l_return_status := validate_attributes (l_assv_rec);
1373:
1374: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1376: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_ERROR;
1378: END IF;
1379:

Line 1377: RAISE OKL_API.G_EXCEPTION_ERROR;

1373:
1374: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1375: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1376: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_ERROR;
1378: END IF;
1379:
1380: l_return_status := validate_record (l_assv_rec);
1381:

Line 1383: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1379:
1380: l_return_status := validate_record (l_assv_rec);
1381:
1382: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1383: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1384: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1385: RAISE OKL_API.G_EXCEPTION_ERROR;
1386: END IF;*/
1387:

Line 1385: RAISE OKL_API.G_EXCEPTION_ERROR;

1381:
1382: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1383: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1384: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1385: RAISE OKL_API.G_EXCEPTION_ERROR;
1386: END IF;*/
1387:
1388: migrate (l_assv_rec, l_ass_rec);
1389: migrate (l_assv_rec, l_asstl_rec);

Line 1394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1390:
1391: update_row (x_return_status => l_return_status, p_ass_rec => l_ass_rec);
1392:
1393: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1395: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1396: RAISE OKL_API.G_EXCEPTION_ERROR;
1397: END IF;
1398:

Line 1396: RAISE OKL_API.G_EXCEPTION_ERROR;

1392:
1393: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1395: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1396: RAISE OKL_API.G_EXCEPTION_ERROR;
1397: END IF;
1398:
1399: update_row (x_return_status => l_return_status, p_asstl_rec => l_asstl_rec);
1400:

Line 1402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1398:
1399: update_row (x_return_status => l_return_status, p_asstl_rec => l_asstl_rec);
1400:
1401: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1404: RAISE OKL_API.G_EXCEPTION_ERROR;
1405: END IF;
1406:

Line 1404: RAISE OKL_API.G_EXCEPTION_ERROR;

1400:
1401: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1404: RAISE OKL_API.G_EXCEPTION_ERROR;
1405: END IF;
1406:
1407: x_return_status := l_return_status;
1408: x_assv_rec := l_assv_rec;

Line 1412: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1408: x_assv_rec := l_assv_rec;
1409:
1410: EXCEPTION
1411:
1412: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1413:
1414: x_return_status := G_RET_STS_ERROR;
1415:
1416: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1416: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1412: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1413:
1414: x_return_status := G_RET_STS_ERROR;
1415:
1416: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1417:
1418: x_return_status := G_RET_STS_UNEXP_ERROR;
1419:
1420: WHEN OTHERS THEN

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

1418: x_return_status := G_RET_STS_UNEXP_ERROR;
1419:
1420: WHEN OTHERS THEN
1421:
1422: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1423: p_msg_name => G_DB_ERROR,
1424: p_token1 => G_PROG_NAME_TOKEN,
1425: p_token1_value => l_prog_name,
1426: p_token2 => G_SQLCODE_TOKEN,

Line 1465: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1461: p_assv_rec => p_assv_rec,
1462: x_assv_rec => x_assv_rec);
1463:
1464: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1465: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF l_return_status = G_RET_STS_ERROR THEN
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: END IF;
1469:

Line 1467: RAISE OKL_API.G_EXCEPTION_ERROR;

1463:
1464: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1465: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF l_return_status = G_RET_STS_ERROR THEN
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: END IF;
1469:
1470: x_return_status := l_return_status;
1471:

Line 1474: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1470: x_return_status := l_return_status;
1471:
1472: EXCEPTION
1473:
1474: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1475:
1476: x_return_status := G_RET_STS_ERROR;
1477:
1478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1474: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1475:
1476: x_return_status := G_RET_STS_ERROR;
1477:
1478: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1479:
1480: x_return_status := G_RET_STS_UNEXP_ERROR;
1481:
1482: WHEN OTHERS THEN

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

1480: x_return_status := G_RET_STS_UNEXP_ERROR;
1481:
1482: WHEN OTHERS THEN
1483:
1484: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1485: p_msg_name => G_DB_ERROR,
1486: p_token1 => G_PROG_NAME_TOKEN,
1487: p_token1_value => l_prog_name,
1488: p_token2 => G_SQLCODE_TOKEN,

Line 1536: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1532: p_assv_rec => p_assv_tbl(i),
1533: x_assv_rec => x_assv_tbl(i));
1534:
1535: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1536: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1537: ELSIF l_return_status = G_RET_STS_ERROR THEN
1538: RAISE OKL_API.G_EXCEPTION_ERROR;
1539: END IF;
1540:

Line 1538: RAISE OKL_API.G_EXCEPTION_ERROR;

1534:
1535: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1536: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1537: ELSIF l_return_status = G_RET_STS_ERROR THEN
1538: RAISE OKL_API.G_EXCEPTION_ERROR;
1539: END IF;
1540:
1541: EXIT WHEN (i = p_assv_tbl.LAST);
1542: i := p_assv_tbl.NEXT(i);

Line 1558: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1554: x_return_status := l_return_status;
1555:
1556: EXCEPTION
1557:
1558: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1559:
1560: x_return_status := G_RET_STS_ERROR;
1561:
1562: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1562: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1558: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1559:
1560: x_return_status := G_RET_STS_ERROR;
1561:
1562: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1563:
1564: x_return_status := G_RET_STS_UNEXP_ERROR;
1565:
1566: WHEN OTHERS THEN

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

1564: x_return_status := G_RET_STS_UNEXP_ERROR;
1565:
1566: WHEN OTHERS THEN
1567:
1568: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1569: p_msg_name => G_DB_ERROR,
1570: p_token1 => G_PROG_NAME_TOKEN,
1571: p_token1_value => l_prog_name,
1572: p_token2 => G_SQLCODE_TOKEN,

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

1600: EXCEPTION
1601:
1602: WHEN OTHERS THEN
1603:
1604: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1605: p_msg_name => G_DB_ERROR,
1606: p_token1 => G_PROG_NAME_TOKEN,
1607: p_token1_value => l_prog_name,
1608: p_token2 => G_SQLCODE_TOKEN,

Line 1645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1641: delete_row (x_return_status => l_return_status,
1642: p_id => p_assv_rec.id);
1643:
1644: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF l_return_status = G_RET_STS_ERROR THEN
1647: RAISE OKL_API.G_EXCEPTION_ERROR;
1648: END IF;
1649:

Line 1647: RAISE OKL_API.G_EXCEPTION_ERROR;

1643:
1644: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF l_return_status = G_RET_STS_ERROR THEN
1647: RAISE OKL_API.G_EXCEPTION_ERROR;
1648: END IF;
1649:
1650: x_return_status := l_return_status;
1651:

Line 1654: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1650: x_return_status := l_return_status;
1651:
1652: EXCEPTION
1653:
1654: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1655:
1656: x_return_status := G_RET_STS_ERROR;
1657:
1658: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1658: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1654: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1655:
1656: x_return_status := G_RET_STS_ERROR;
1657:
1658: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1659:
1660: x_return_status := G_RET_STS_UNEXP_ERROR;
1661:
1662: WHEN OTHERS THEN

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

1660: x_return_status := G_RET_STS_UNEXP_ERROR;
1661:
1662: WHEN OTHERS THEN
1663:
1664: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1665: p_msg_name => G_DB_ERROR,
1666: p_token1 => G_PROG_NAME_TOKEN,
1667: p_token1_value => l_prog_name,
1668: p_token2 => G_SQLCODE_TOKEN,

Line 1714: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1710: delete_row (x_return_status => l_return_status,
1711: p_id => p_assv_tbl(i).id);
1712:
1713: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1714: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF l_return_status = G_RET_STS_ERROR THEN
1716: RAISE OKL_API.G_EXCEPTION_ERROR;
1717: END IF;
1718:

Line 1716: RAISE OKL_API.G_EXCEPTION_ERROR;

1712:
1713: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1714: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1715: ELSIF l_return_status = G_RET_STS_ERROR THEN
1716: RAISE OKL_API.G_EXCEPTION_ERROR;
1717: END IF;
1718:
1719: EXIT WHEN (i = p_assv_tbl.LAST);
1720: i := p_assv_tbl.NEXT(i);

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

1734: EXCEPTION
1735:
1736: WHEN OTHERS THEN
1737:
1738: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1739: p_msg_name => G_DB_ERROR,
1740: p_token1 => G_PROG_NAME_TOKEN,
1741: p_token1_value => l_prog_name,
1742: p_token2 => G_SQLCODE_TOKEN,