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.OKC_UDA_TEMPLATES_UTIL dependencies on OKC_API

Line 775: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

771: 'EGO_EXT_FWK_PUB.Create_Association return status is: '
772: || x_return_status);
773: END IF;
774: -------------------------------------------------------
775: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;

Line 776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

772: || x_return_status);
773: END IF;
774: -------------------------------------------------------
775: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;
780: --------------------------------------------------------

Line 777: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

773: END IF;
774: -------------------------------------------------------
775: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;
780: --------------------------------------------------------
781:

Line 778: RAISE OKC_API.G_EXCEPTION_ERROR;

774: -------------------------------------------------------
775: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
776: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
777: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
778: RAISE OKC_API.G_EXCEPTION_ERROR;
779: END IF;
780: --------------------------------------------------------
781:
782:

Line 802: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

798: 'copy_uda_actions return status is: '
799: || x_return_status);
800: END IF;
801: -------------------------------------------------------
802: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
804: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
805: RAISE OKC_API.G_EXCEPTION_ERROR;
806: END IF;

Line 803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

799: || x_return_status);
800: END IF;
801: -------------------------------------------------------
802: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
804: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
805: RAISE OKC_API.G_EXCEPTION_ERROR;
806: END IF;
807: --------------------------------------------------------

Line 804: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

800: END IF;
801: -------------------------------------------------------
802: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
804: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
805: RAISE OKC_API.G_EXCEPTION_ERROR;
806: END IF;
807: --------------------------------------------------------
808:

Line 805: RAISE OKC_API.G_EXCEPTION_ERROR;

801: -------------------------------------------------------
802: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
804: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
805: RAISE OKC_API.G_EXCEPTION_ERROR;
806: END IF;
807: --------------------------------------------------------
808:
809:

Line 847: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

843: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
844: g_module || l_api_name || '.exception',
845: 'Leaving copy_associations because of EXCEPTION: ' || sqlerrm);
846: END IF;
847: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
848: p_msg_name => G_UNEXPECTED_ERROR,
849: p_token1 => G_SQLCODE_TOKEN,
850: p_token1_value => sqlcode,
851: p_token2 => G_SQLERRM_TOKEN,

Line 956: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

952: 'EGO_EXT_FWK_PUB.Create_Action return status is: '
953: || x_return_status);
954: END IF;
955: -------------------------------------------------------
956: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
958: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
959: RAISE OKC_API.G_EXCEPTION_ERROR;
960: END IF;

Line 957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

953: || x_return_status);
954: END IF;
955: -------------------------------------------------------
956: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
958: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
959: RAISE OKC_API.G_EXCEPTION_ERROR;
960: END IF;
961: --------------------------------------------------------

Line 958: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

954: END IF;
955: -------------------------------------------------------
956: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
958: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
959: RAISE OKC_API.G_EXCEPTION_ERROR;
960: END IF;
961: --------------------------------------------------------
962:

Line 959: RAISE OKC_API.G_EXCEPTION_ERROR;

955: -------------------------------------------------------
956: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
957: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
958: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
959: RAISE OKC_API.G_EXCEPTION_ERROR;
960: END IF;
961: --------------------------------------------------------
962:
963:

Line 992: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

988: 'EGO_EXT_FWK_PUB.Create_Action_Display return status is: '
989: || x_return_status);
990: END IF;
991: -------------------------------------------------------
992: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
995: RAISE OKC_API.G_EXCEPTION_ERROR;
996: END IF;

Line 993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

989: || x_return_status);
990: END IF;
991: -------------------------------------------------------
992: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
995: RAISE OKC_API.G_EXCEPTION_ERROR;
996: END IF;
997: --------------------------------------------------------

Line 994: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

990: END IF;
991: -------------------------------------------------------
992: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
995: RAISE OKC_API.G_EXCEPTION_ERROR;
996: END IF;
997: --------------------------------------------------------
998:

Line 995: RAISE OKC_API.G_EXCEPTION_ERROR;

991: -------------------------------------------------------
992: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
993: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
994: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
995: RAISE OKC_API.G_EXCEPTION_ERROR;
996: END IF;
997: --------------------------------------------------------
998:
999:

Line 1035: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1031: 'EGO_EXT_FWK_PUB.Create_Mapping return status is: '
1032: || x_return_status);
1033: END IF;
1034: -------------------------------------------------------
1035: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;

Line 1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1032: || x_return_status);
1033: END IF;
1034: -------------------------------------------------------
1035: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: --------------------------------------------------------

Line 1037: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1033: END IF;
1034: -------------------------------------------------------
1035: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: --------------------------------------------------------
1041:

Line 1038: RAISE OKC_API.G_EXCEPTION_ERROR;

1034: -------------------------------------------------------
1035: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: --------------------------------------------------------
1041:
1042: END LOOP;

Line 1091: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1087: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1088: g_module || l_api_name || '.exception',
1089: 'Leaving copy_uda_actions because of EXCEPTION: ' || sqlerrm);
1090: END IF;
1091: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1092: p_msg_name => G_UNEXPECTED_ERROR,
1093: p_token1 => G_SQLCODE_TOKEN,
1094: p_token1_value => sqlcode,
1095: p_token2 => G_SQLERRM_TOKEN,

Line 1184: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1180: 'EGO_EXT_FWK_PUB.Create_Page return status is: '
1181: || x_return_status);
1182: END IF;
1183: -------------------------------------------------------
1184: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1186: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_ERROR;
1188: END IF;

Line 1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1181: || x_return_status);
1182: END IF;
1183: -------------------------------------------------------
1184: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1186: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_ERROR;
1188: END IF;
1189: --------------------------------------------------------

Line 1186: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1182: END IF;
1183: -------------------------------------------------------
1184: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1186: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_ERROR;
1188: END IF;
1189: --------------------------------------------------------
1190:

Line 1187: RAISE OKC_API.G_EXCEPTION_ERROR;

1183: -------------------------------------------------------
1184: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1185: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1186: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1187: RAISE OKC_API.G_EXCEPTION_ERROR;
1188: END IF;
1189: --------------------------------------------------------
1190:
1191: FOR c_get_page_entries_csr_rec IN c_get_page_entries_csr(c_get_pages_csr_rec.page_id) LOOP

Line 1226: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1222: 'EGO_EXT_FWK_PUB.Create_Page_Entry return status is: '
1223: || x_return_status);
1224: END IF;
1225: -------------------------------------------------------
1226: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1227: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1229: RAISE OKC_API.G_EXCEPTION_ERROR;
1230: END IF;

Line 1227: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1223: || x_return_status);
1224: END IF;
1225: -------------------------------------------------------
1226: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1227: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1229: RAISE OKC_API.G_EXCEPTION_ERROR;
1230: END IF;
1231: --------------------------------------------------------

Line 1228: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1224: END IF;
1225: -------------------------------------------------------
1226: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1227: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1229: RAISE OKC_API.G_EXCEPTION_ERROR;
1230: END IF;
1231: --------------------------------------------------------
1232:

Line 1229: RAISE OKC_API.G_EXCEPTION_ERROR;

1225: -------------------------------------------------------
1226: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1227: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1228: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1229: RAISE OKC_API.G_EXCEPTION_ERROR;
1230: END IF;
1231: --------------------------------------------------------
1232:
1233: END LOOP;

Line 1272: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1268: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1269: g_module || l_api_name || '.exception',
1270: 'Leaving copy_pages because of EXCEPTION: ' || sqlerrm);
1271: END IF;
1272: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1273: p_msg_name => G_UNEXPECTED_ERROR,
1274: p_token1 => G_SQLCODE_TOKEN,
1275: p_token1_value => sqlcode,
1276: p_token2 => G_SQLERRM_TOKEN,

Line 1373: RAISE OKC_API.G_EXCEPTION_ERROR;

1369: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1370: 'l_object_id is null ');
1371: END IF;
1372:
1373: RAISE OKC_API.G_EXCEPTION_ERROR;
1374: END IF;
1375:
1376: --We have to send uda_template_id as classification_code to ego API's
1377: -- classification_code is varchar2 field.

Line 1401: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1397: 'copy_associations return status is: '
1398: || x_return_status);
1399: END IF;
1400: -------------------------------------------------------
1401: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;

Line 1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1398: || x_return_status);
1399: END IF;
1400: -------------------------------------------------------
1401: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: --------------------------------------------------------

Line 1403: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1399: END IF;
1400: -------------------------------------------------------
1401: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: --------------------------------------------------------
1407:

Line 1404: RAISE OKC_API.G_EXCEPTION_ERROR;

1400: -------------------------------------------------------
1401: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: --------------------------------------------------------
1407:
1408: --copy pages

Line 1428: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1424: 'copy_pages return status is: '
1425: || x_return_status);
1426: END IF;
1427: -------------------------------------------------------
1428: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1430: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1431: RAISE OKC_API.G_EXCEPTION_ERROR;
1432: END IF;

Line 1429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1425: || x_return_status);
1426: END IF;
1427: -------------------------------------------------------
1428: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1430: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1431: RAISE OKC_API.G_EXCEPTION_ERROR;
1432: END IF;
1433: --------------------------------------------------------

Line 1430: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1426: END IF;
1427: -------------------------------------------------------
1428: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1430: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1431: RAISE OKC_API.G_EXCEPTION_ERROR;
1432: END IF;
1433: --------------------------------------------------------
1434:

Line 1431: RAISE OKC_API.G_EXCEPTION_ERROR;

1427: -------------------------------------------------------
1428: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1430: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1431: RAISE OKC_API.G_EXCEPTION_ERROR;
1432: END IF;
1433: --------------------------------------------------------
1434:
1435:

Line 1475: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1471: g_module || l_api_name || '.exception',
1472: 'Leaving copy_template_details because of EXCEPTION: ' || sqlerrm);
1473: END IF;
1474: ROLLBACK TO copy_temp_details_PVT;
1475: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1476: p_msg_name => G_UNEXPECTED_ERROR,
1477: p_token1 => G_SQLCODE_TOKEN,
1478: p_token1_value => sqlcode,
1479: p_token2 => G_SQLERRM_TOKEN,

Line 1582: RAISE OKC_API.G_EXCEPTION_ERROR;

1578: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1579: 'Invalid template Id: ' );
1580: END IF;
1581:
1582: RAISE OKC_API.G_EXCEPTION_ERROR;
1583: END IF;
1584: CLOSE c_get_object_id;
1585:
1586: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1613: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1609: 'EGO_EXT_FWK_PUB.DELETE_PAGE return status is: '
1610: || x_return_status);
1611: END IF;
1612: -------------------------------------------------------
1613: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1615: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1616: RAISE OKC_API.G_EXCEPTION_ERROR;
1617: END IF;

Line 1614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1610: || x_return_status);
1611: END IF;
1612: -------------------------------------------------------
1613: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1615: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1616: RAISE OKC_API.G_EXCEPTION_ERROR;
1617: END IF;
1618: --------------------------------------------------------

Line 1615: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1611: END IF;
1612: -------------------------------------------------------
1613: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1615: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1616: RAISE OKC_API.G_EXCEPTION_ERROR;
1617: END IF;
1618: --------------------------------------------------------
1619:

Line 1616: RAISE OKC_API.G_EXCEPTION_ERROR;

1612: -------------------------------------------------------
1613: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1614: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1615: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1616: RAISE OKC_API.G_EXCEPTION_ERROR;
1617: END IF;
1618: --------------------------------------------------------
1619:
1620: END LOOP;

Line 1644: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1640: ' ego_ext_fwk_pub.Delete_Association return status is: '
1641: || x_return_status);
1642: END IF;
1643: -------------------------------------------------------
1644: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1647: RAISE OKC_API.G_EXCEPTION_ERROR;
1648: END IF;

Line 1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1641: || x_return_status);
1642: END IF;
1643: -------------------------------------------------------
1644: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1647: RAISE OKC_API.G_EXCEPTION_ERROR;
1648: END IF;
1649: --------------------------------------------------------

Line 1646: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1642: END IF;
1643: -------------------------------------------------------
1644: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1647: RAISE OKC_API.G_EXCEPTION_ERROR;
1648: END IF;
1649: --------------------------------------------------------
1650:

Line 1647: RAISE OKC_API.G_EXCEPTION_ERROR;

1643: -------------------------------------------------------
1644: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1646: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1647: RAISE OKC_API.G_EXCEPTION_ERROR;
1648: END IF;
1649: --------------------------------------------------------
1650:
1651: -- if deleting associations is successful, proceed to delete actions

Line 1672: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1668: ' ego_ext_fwk_pub.Delete_Action return status is: '
1669: || x_return_status);
1670: END IF;
1671: -------------------------------------------------------
1672: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1673: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1674: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1675: RAISE OKC_API.G_EXCEPTION_ERROR;
1676: END IF;

Line 1673: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1669: || x_return_status);
1670: END IF;
1671: -------------------------------------------------------
1672: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1673: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1674: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1675: RAISE OKC_API.G_EXCEPTION_ERROR;
1676: END IF;
1677: --------------------------------------------------------

Line 1674: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1670: END IF;
1671: -------------------------------------------------------
1672: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1673: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1674: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1675: RAISE OKC_API.G_EXCEPTION_ERROR;
1676: END IF;
1677: --------------------------------------------------------
1678:

Line 1675: RAISE OKC_API.G_EXCEPTION_ERROR;

1671: -------------------------------------------------------
1672: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1673: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1674: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1675: RAISE OKC_API.G_EXCEPTION_ERROR;
1676: END IF;
1677: --------------------------------------------------------
1678:
1679: IF (x_return_status = 'S' ) THEN

Line 1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1694: ' ego_ext_fwk_pub.Delete_Action_Display return status is: '
1695: || x_return_status);
1696: END IF;
1697: -------------------------------------------------------
1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1701: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: END IF;

Line 1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1695: || x_return_status);
1696: END IF;
1697: -------------------------------------------------------
1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1701: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: END IF;
1703: --------------------------------------------------------

Line 1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1696: END IF;
1697: -------------------------------------------------------
1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1701: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: END IF;
1703: --------------------------------------------------------
1704:

Line 1701: RAISE OKC_API.G_EXCEPTION_ERROR;

1697: -------------------------------------------------------
1698: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1699: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1700: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1701: RAISE OKC_API.G_EXCEPTION_ERROR;
1702: END IF;
1703: --------------------------------------------------------
1704:
1705:

Line 1726: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1722: ' ego_ext_fwk_pub.Delete_Action_Display return status is: '
1723: || x_return_status);
1724: END IF;
1725: -------------------------------------------------------
1726: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;

Line 1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1723: || x_return_status);
1724: END IF;
1725: -------------------------------------------------------
1726: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: --------------------------------------------------------

Line 1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1724: END IF;
1725: -------------------------------------------------------
1726: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: --------------------------------------------------------
1732:

Line 1729: RAISE OKC_API.G_EXCEPTION_ERROR;

1725: -------------------------------------------------------
1726: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: --------------------------------------------------------
1732:
1733: END IF;

Line 1778: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1774: g_module || l_api_name || '.exception',
1775: 'Leaving delete_temp_details because of EXCEPTION: ' || sqlerrm);
1776: END IF;
1777: ROLLBACK TO del_temp_details_PVT;
1778: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1779: p_msg_name => G_UNEXPECTED_ERROR,
1780: p_token1 => G_SQLCODE_TOKEN,
1781: p_token1_value => sqlcode,
1782: p_token2 => G_SQLERRM_TOKEN,