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

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

268: EXCEPTION
269:
270: WHEN OTHERS THEN
271:
272: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
273: p_msg_name => G_DB_ERROR,
274: p_token1 => G_PROG_NAME_TOKEN,
275: p_token1_value => l_prog_name,
276: p_token2 => G_SQLCODE_TOKEN,

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

288: ------------------------
289: PROCEDURE validate_id (x_return_status OUT NOCOPY VARCHAR2, p_id IN NUMBER) IS
290: BEGIN
291: IF p_id IS NULL 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 => 'id',
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 => 'id',
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_id;
302:

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

306: -------------------------------------------
307: PROCEDURE validate_object_version_number (x_return_status OUT NOCOPY VARCHAR2, p_object_version_number IN NUMBER) IS
308: BEGIN
309: IF p_object_version_number IS NULL THEN
310: OKL_API.set_message(p_app_name => G_APP_NAME,
311: p_msg_name => G_COL_ERROR,
312: p_token1 => G_COL_NAME_TOKEN,
313: p_token1_value => 'object_version_number',
314: p_token2 => G_PKG_NAME_TOKEN,

Line 316: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 334: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 352: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 370: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

538: EXCEPTION
539:
540: WHEN OTHERS THEN
541:
542: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
543: p_msg_name => G_DB_ERROR,
544: p_token1 => G_PROG_NAME_TOKEN,
545: p_token1_value => l_prog_name,
546: p_token2 => G_SQLCODE_TOKEN,

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

613: EXCEPTION
614:
615: WHEN OTHERS THEN
616:
617: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
618: p_msg_name => G_DB_ERROR,
619: p_token1 => G_PROG_NAME_TOKEN,
620: p_token1_value => l_prog_name,
621: p_token2 => G_SQLCODE_TOKEN,

Line 660: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

656:
657: l_return_status := validate_attributes(l_asov_rec);
658:
659: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
660: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
661: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
662: RAISE OKL_API.G_EXCEPTION_ERROR;
663: END IF;
664:

Line 662: RAISE OKL_API.G_EXCEPTION_ERROR;

658:
659: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
660: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
661: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
662: RAISE OKL_API.G_EXCEPTION_ERROR;
663: END IF;
664:
665: l_return_status := validate_record(l_asov_rec);
666:

Line 668: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

664:
665: l_return_status := validate_record(l_asov_rec);
666:
667: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
669: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
670: RAISE OKL_API.G_EXCEPTION_ERROR;
671: END IF;
672:

Line 670: RAISE OKL_API.G_EXCEPTION_ERROR;

666:
667: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
669: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
670: RAISE OKL_API.G_EXCEPTION_ERROR;
671: END IF;
672:
673: migrate (l_asov_rec, l_aso_rec);
674: migrate (l_asov_rec, l_asotl_rec);

Line 679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

675:
676: insert_row (x_return_status => l_return_status, p_aso_rec => l_aso_rec);
677:
678: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
680: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
681: RAISE OKL_API.G_EXCEPTION_ERROR;
682: END IF;
683:

Line 681: RAISE OKL_API.G_EXCEPTION_ERROR;

677:
678: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
680: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
681: RAISE OKL_API.G_EXCEPTION_ERROR;
682: END IF;
683:
684: insert_row (x_return_status => l_return_status, p_asotl_rec => l_asotl_rec);
685:

Line 687: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

683:
684: insert_row (x_return_status => l_return_status, p_asotl_rec => l_asotl_rec);
685:
686: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
688: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
689: RAISE OKL_API.G_EXCEPTION_ERROR;
690: END IF;
691:

Line 689: RAISE OKL_API.G_EXCEPTION_ERROR;

685:
686: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
687: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
688: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
689: RAISE OKL_API.G_EXCEPTION_ERROR;
690: END IF;
691:
692: x_asov_rec := l_asov_rec;
693: x_return_status := l_return_status;

Line 697: WHEN OKL_API.G_EXCEPTION_ERROR THEN

693: x_return_status := l_return_status;
694:
695: EXCEPTION
696:
697: WHEN OKL_API.G_EXCEPTION_ERROR THEN
698:
699: x_return_status := G_RET_STS_ERROR;
700:
701: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 701: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

697: WHEN OKL_API.G_EXCEPTION_ERROR THEN
698:
699: x_return_status := G_RET_STS_ERROR;
700:
701: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
702:
703: x_return_status := G_RET_STS_UNEXP_ERROR;
704:
705: WHEN OTHERS THEN

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

703: x_return_status := G_RET_STS_UNEXP_ERROR;
704:
705: WHEN OTHERS THEN
706:
707: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
708: p_msg_name => G_DB_ERROR,
709: p_token1 => G_PROG_NAME_TOKEN,
710: p_token1_value => l_prog_name,
711: p_token2 => G_SQLCODE_TOKEN,

Line 750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

746: p_asov_rec => p_asov_rec,
747: x_asov_rec => x_asov_rec);
748:
749: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF l_return_status = G_RET_STS_ERROR THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;
754:

Line 752: RAISE OKL_API.G_EXCEPTION_ERROR;

748:
749: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
750: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
751: ELSIF l_return_status = G_RET_STS_ERROR THEN
752: RAISE OKL_API.G_EXCEPTION_ERROR;
753: END IF;
754:
755: x_return_status := l_return_status;
756:

Line 759: WHEN OKL_API.G_EXCEPTION_ERROR THEN

755: x_return_status := l_return_status;
756:
757: EXCEPTION
758:
759: WHEN OKL_API.G_EXCEPTION_ERROR THEN
760:
761: x_return_status := G_RET_STS_ERROR;
762:
763: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 763: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

759: WHEN OKL_API.G_EXCEPTION_ERROR THEN
760:
761: x_return_status := G_RET_STS_ERROR;
762:
763: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
764:
765: x_return_status := G_RET_STS_UNEXP_ERROR;
766:
767: WHEN OTHERS THEN

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

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

Line 818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

814: p_asov_rec => p_asov_tbl(i),
815: x_asov_rec => x_asov_tbl(i));
816:
817: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
819: ELSIF l_return_status = G_RET_STS_ERROR THEN
820: RAISE OKL_API.G_EXCEPTION_ERROR;
821: END IF;
822:

Line 820: RAISE OKL_API.G_EXCEPTION_ERROR;

816:
817: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
818: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
819: ELSIF l_return_status = G_RET_STS_ERROR THEN
820: RAISE OKL_API.G_EXCEPTION_ERROR;
821: END IF;
822:
823: EXIT WHEN (i = p_asov_tbl.LAST);
824: i := p_asov_tbl.NEXT(i);

Line 840: WHEN OKL_API.G_EXCEPTION_ERROR THEN

836: x_return_status := l_return_status;
837:
838: EXCEPTION
839:
840: WHEN OKL_API.G_EXCEPTION_ERROR THEN
841:
842: x_return_status := G_RET_STS_ERROR;
843:
844: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 844: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

840: WHEN OKL_API.G_EXCEPTION_ERROR THEN
841:
842: x_return_status := G_RET_STS_ERROR;
843:
844: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
845:
846: x_return_status := G_RET_STS_UNEXP_ERROR;
847:
848: WHEN OTHERS THEN

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

846: x_return_status := G_RET_STS_UNEXP_ERROR;
847:
848: WHEN OTHERS THEN
849:
850: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
851: p_msg_name => G_DB_ERROR,
852: p_token1 => G_PROG_NAME_TOKEN,
853: p_token1_value => l_prog_name,
854: p_token2 => G_SQLCODE_TOKEN,

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

900:
901: IF (lock_csr%ISOPEN) THEN
902: CLOSE lock_csr;
903: END IF;
904: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
905: p_msg_name => G_OVN_ERROR2,
906: p_token1 => G_PROG_NAME_TOKEN,
907: p_token1_value => l_prog_name);
908: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 908: RAISE OKL_API.G_EXCEPTION_ERROR;

904: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
905: p_msg_name => G_OVN_ERROR2,
906: p_token1 => G_PROG_NAME_TOKEN,
907: p_token1_value => l_prog_name);
908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END;
910:
911: IF l_object_version_number IS NULL THEN
912:

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

915: CLOSE lchk_csr;
916:
917: IF lc_object_version_number IS NULL THEN
918:
919: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
920: p_msg_name => G_OVN_ERROR3,
921: p_token1 => G_PROG_NAME_TOKEN,
922: p_token1_value => l_prog_name);
923:

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

922: p_token1_value => l_prog_name);
923:
924: ELSIF lc_object_version_number <> p_aso_rec.object_version_number THEN
925:
926: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
927: p_msg_name => G_OVN_ERROR,
928: p_token1 => G_PROG_NAME_TOKEN,
929: p_token1_value => l_prog_name);
930:

Line 933: RAISE OKL_API.G_EXCEPTION_ERROR;

929: p_token1_value => l_prog_name);
930:
931: END IF;
932:
933: RAISE OKL_API.G_EXCEPTION_ERROR;
934:
935: END IF;
936:
937: x_return_status := G_RET_STS_SUCCESS;

Line 941: WHEN OKL_API.G_EXCEPTION_ERROR THEN

937: x_return_status := G_RET_STS_SUCCESS;
938:
939: EXCEPTION
940:
941: WHEN OKL_API.G_EXCEPTION_ERROR THEN
942:
943: x_return_status := G_RET_STS_ERROR;
944:
945: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 945: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

941: WHEN OKL_API.G_EXCEPTION_ERROR THEN
942:
943: x_return_status := G_RET_STS_ERROR;
944:
945: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
946:
947: x_return_status := G_RET_STS_UNEXP_ERROR;
948:
949: WHEN OTHERS THEN

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

947: x_return_status := G_RET_STS_UNEXP_ERROR;
948:
949: WHEN OTHERS THEN
950:
951: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
952: p_msg_name => G_DB_ERROR,
953: p_token1 => G_PROG_NAME_TOKEN,
954: p_token1_value => l_prog_name,
955: p_token2 => G_SQLCODE_TOKEN,

Line 981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

977:
978: lock_row (x_return_status => l_return_status, p_aso_rec => p_aso_rec);
979:
980: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
982: ELSIF l_return_status = G_RET_STS_ERROR THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: END IF;
985:

Line 983: RAISE OKL_API.G_EXCEPTION_ERROR;

979:
980: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
982: ELSIF l_return_status = G_RET_STS_ERROR THEN
983: RAISE OKL_API.G_EXCEPTION_ERROR;
984: END IF;
985:
986: UPDATE okl_asset_components_b
987: SET

Line 1020: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1016: x_return_status := l_return_status;
1017:
1018: EXCEPTION
1019:
1020: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1021: x_return_status := G_RET_STS_ERROR;
1022:
1023: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1024: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1023: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1019:
1020: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1021: x_return_status := G_RET_STS_ERROR;
1022:
1023: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1024: x_return_status := G_RET_STS_UNEXP_ERROR;
1025:
1026: WHEN OTHERS THEN
1027: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

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

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

1071: EXCEPTION
1072:
1073: WHEN OTHERS THEN
1074:
1075: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1076: p_msg_name => G_DB_ERROR,
1077: p_token1 => G_PROG_NAME_TOKEN,
1078: p_token1_value => l_prog_name,
1079: p_token2 => G_SQLCODE_TOKEN,

Line 1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1118: x_asov_rec := p_asov_rec;
1119: l_db_asov_rec := get_rec (p_asov_rec.id, l_return_status);
1120:
1121: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF l_return_status = G_RET_STS_ERROR THEN
1124: RAISE OKL_API.G_EXCEPTION_ERROR;
1125: END IF;
1126:

Line 1124: RAISE OKL_API.G_EXCEPTION_ERROR;

1120:
1121: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1123: ELSIF l_return_status = G_RET_STS_ERROR THEN
1124: RAISE OKL_API.G_EXCEPTION_ERROR;
1125: END IF;
1126:
1127: IF x_asov_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1128: x_asov_rec.attribute_category := l_db_asov_rec.attribute_category;

Line 1216: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1212: RETURN l_return_status;
1213:
1214: EXCEPTION
1215:
1216: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1217:
1218: x_return_status := G_RET_STS_ERROR;
1219:
1220: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1220: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1216: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1217:
1218: x_return_status := G_RET_STS_ERROR;
1219:
1220: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1221:
1222: x_return_status := G_RET_STS_UNEXP_ERROR;
1223:
1224: WHEN OTHERS THEN

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

1222: x_return_status := G_RET_STS_UNEXP_ERROR;
1223:
1224: WHEN OTHERS THEN
1225:
1226: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1227: p_msg_name => G_DB_ERROR,
1228: p_token1 => G_PROG_NAME_TOKEN,
1229: p_token1_value => l_prog_name,
1230: p_token2 => G_SQLCODE_TOKEN,

Line 1246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1242:
1243: l_return_status := populate_new_record (p_asov_rec, l_asov_rec);
1244:
1245: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1247: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1248: RAISE OKL_API.G_EXCEPTION_ERROR;
1249: END IF;
1250:

Line 1248: RAISE OKL_API.G_EXCEPTION_ERROR;

1244:
1245: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1247: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1248: RAISE OKL_API.G_EXCEPTION_ERROR;
1249: END IF;
1250:
1251: l_return_status := validate_attributes (l_asov_rec);
1252:

Line 1254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1250:
1251: l_return_status := validate_attributes (l_asov_rec);
1252:
1253: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1255: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1256: RAISE OKL_API.G_EXCEPTION_ERROR;
1257: END IF;
1258:

Line 1256: RAISE OKL_API.G_EXCEPTION_ERROR;

1252:
1253: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1255: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1256: RAISE OKL_API.G_EXCEPTION_ERROR;
1257: END IF;
1258:
1259: l_return_status := validate_record (l_asov_rec);
1260:

Line 1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1258:
1259: l_return_status := validate_record (l_asov_rec);
1260:
1261: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1263: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1264: RAISE OKL_API.G_EXCEPTION_ERROR;
1265: END IF;
1266:

Line 1264: RAISE OKL_API.G_EXCEPTION_ERROR;

1260:
1261: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1262: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1263: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1264: RAISE OKL_API.G_EXCEPTION_ERROR;
1265: END IF;
1266:
1267: migrate (l_asov_rec, l_aso_rec);
1268: migrate (l_asov_rec, l_asotl_rec);

Line 1273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1269:
1270: update_row (x_return_status => l_return_status, p_aso_rec => l_aso_rec);
1271:
1272: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1275: RAISE OKL_API.G_EXCEPTION_ERROR;
1276: END IF;
1277:

Line 1275: RAISE OKL_API.G_EXCEPTION_ERROR;

1271:
1272: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1275: RAISE OKL_API.G_EXCEPTION_ERROR;
1276: END IF;
1277:
1278: update_row (x_return_status => l_return_status, p_asotl_rec => l_asotl_rec);
1279:

Line 1281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1277:
1278: update_row (x_return_status => l_return_status, p_asotl_rec => l_asotl_rec);
1279:
1280: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1282: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1283: RAISE OKL_API.G_EXCEPTION_ERROR;
1284: END IF;
1285:

Line 1283: RAISE OKL_API.G_EXCEPTION_ERROR;

1279:
1280: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1281: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1282: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
1283: RAISE OKL_API.G_EXCEPTION_ERROR;
1284: END IF;
1285:
1286: x_return_status := l_return_status;
1287: x_asov_rec := l_asov_rec;

Line 1291: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1287: x_asov_rec := l_asov_rec;
1288:
1289: EXCEPTION
1290:
1291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1292:
1293: x_return_status := G_RET_STS_ERROR;
1294:
1295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1291: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1292:
1293: x_return_status := G_RET_STS_ERROR;
1294:
1295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1296:
1297: x_return_status := G_RET_STS_UNEXP_ERROR;
1298:
1299: WHEN OTHERS THEN

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

1297: x_return_status := G_RET_STS_UNEXP_ERROR;
1298:
1299: WHEN OTHERS THEN
1300:
1301: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1302: p_msg_name => G_DB_ERROR,
1303: p_token1 => G_PROG_NAME_TOKEN,
1304: p_token1_value => l_prog_name,
1305: p_token2 => G_SQLCODE_TOKEN,

Line 1344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1340: p_asov_rec => p_asov_rec,
1341: x_asov_rec => x_asov_rec);
1342:
1343: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF l_return_status = G_RET_STS_ERROR THEN
1346: RAISE OKL_API.G_EXCEPTION_ERROR;
1347: END IF;
1348:

Line 1346: RAISE OKL_API.G_EXCEPTION_ERROR;

1342:
1343: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1344: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF l_return_status = G_RET_STS_ERROR THEN
1346: RAISE OKL_API.G_EXCEPTION_ERROR;
1347: END IF;
1348:
1349: x_return_status := l_return_status;
1350:

Line 1353: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1349: x_return_status := l_return_status;
1350:
1351: EXCEPTION
1352:
1353: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1354:
1355: x_return_status := G_RET_STS_ERROR;
1356:
1357: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1357: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1353: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1354:
1355: x_return_status := G_RET_STS_ERROR;
1356:
1357: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1358:
1359: x_return_status := G_RET_STS_UNEXP_ERROR;
1360:
1361: WHEN OTHERS THEN

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

1359: x_return_status := G_RET_STS_UNEXP_ERROR;
1360:
1361: WHEN OTHERS THEN
1362:
1363: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1364: p_msg_name => G_DB_ERROR,
1365: p_token1 => G_PROG_NAME_TOKEN,
1366: p_token1_value => l_prog_name,
1367: p_token2 => G_SQLCODE_TOKEN,

Line 1415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1411: p_asov_rec => p_asov_tbl(i),
1412: x_asov_rec => x_asov_tbl(i));
1413:
1414: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1416: ELSIF l_return_status = G_RET_STS_ERROR THEN
1417: RAISE OKL_API.G_EXCEPTION_ERROR;
1418: END IF;
1419:

Line 1417: RAISE OKL_API.G_EXCEPTION_ERROR;

1413:
1414: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1416: ELSIF l_return_status = G_RET_STS_ERROR THEN
1417: RAISE OKL_API.G_EXCEPTION_ERROR;
1418: END IF;
1419:
1420: EXIT WHEN (i = p_asov_tbl.LAST);
1421: i := p_asov_tbl.NEXT(i);

Line 1437: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1433: x_return_status := l_return_status;
1434:
1435: EXCEPTION
1436:
1437: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1438:
1439: x_return_status := G_RET_STS_ERROR;
1440:
1441: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1441: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1437: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1438:
1439: x_return_status := G_RET_STS_ERROR;
1440:
1441: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1442:
1443: x_return_status := G_RET_STS_UNEXP_ERROR;
1444:
1445: WHEN OTHERS THEN

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

1443: x_return_status := G_RET_STS_UNEXP_ERROR;
1444:
1445: WHEN OTHERS THEN
1446:
1447: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1448: p_msg_name => G_DB_ERROR,
1449: p_token1 => G_PROG_NAME_TOKEN,
1450: p_token1_value => l_prog_name,
1451: p_token2 => G_SQLCODE_TOKEN,

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

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

Line 1524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1520: delete_row (x_return_status => l_return_status,
1521: p_id => p_asov_rec.id);
1522:
1523: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: ELSIF l_return_status = G_RET_STS_ERROR THEN
1526: RAISE OKL_API.G_EXCEPTION_ERROR;
1527: END IF;
1528:

Line 1526: RAISE OKL_API.G_EXCEPTION_ERROR;

1522:
1523: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: ELSIF l_return_status = G_RET_STS_ERROR THEN
1526: RAISE OKL_API.G_EXCEPTION_ERROR;
1527: END IF;
1528:
1529: x_return_status := l_return_status;
1530:

Line 1533: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1529: x_return_status := l_return_status;
1530:
1531: EXCEPTION
1532:
1533: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1534:
1535: x_return_status := G_RET_STS_ERROR;
1536:
1537: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1537: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1533: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1534:
1535: x_return_status := G_RET_STS_ERROR;
1536:
1537: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1538:
1539: x_return_status := G_RET_STS_UNEXP_ERROR;
1540:
1541: WHEN OTHERS THEN

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

1539: x_return_status := G_RET_STS_UNEXP_ERROR;
1540:
1541: WHEN OTHERS THEN
1542:
1543: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1544: p_msg_name => G_DB_ERROR,
1545: p_token1 => G_PROG_NAME_TOKEN,
1546: p_token1_value => l_prog_name,
1547: p_token2 => G_SQLCODE_TOKEN,

Line 1593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1589: delete_row (x_return_status => l_return_status,
1590: p_id => p_asov_tbl(i).id);
1591:
1592: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF l_return_status = G_RET_STS_ERROR THEN
1595: RAISE OKL_API.G_EXCEPTION_ERROR;
1596: END IF;
1597:

Line 1595: RAISE OKL_API.G_EXCEPTION_ERROR;

1591:
1592: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1593: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1594: ELSIF l_return_status = G_RET_STS_ERROR THEN
1595: RAISE OKL_API.G_EXCEPTION_ERROR;
1596: END IF;
1597:
1598: EXIT WHEN (i = p_asov_tbl.LAST);
1599: i := p_asov_tbl.NEXT(i);

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

1613: EXCEPTION
1614:
1615: WHEN OTHERS THEN
1616:
1617: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1618: p_msg_name => G_DB_ERROR,
1619: p_token1 => G_PROG_NAME_TOKEN,
1620: p_token1_value => l_prog_name,
1621: p_token2 => G_SQLCODE_TOKEN,