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_XPRT_RULE_PVT dependencies on FND_API

Line 569: RAISE fnd_api.g_exc_error;

565: p_msg_name => 'OKC_I_INVALID_COND_VALUE',
566: p_token1 => 'ENTITY',
567: p_token1_value => p_object_value_type
568: );
569: RAISE fnd_api.g_exc_error;
570: END IF;
571: END LOOP;
572: ELSIF p_object_value_type = 'QUESTION'
573: THEN

Line 591: RAISE fnd_api.g_exc_error;

587: p_msg_name => 'OKC_I_INVALID_COND_VALUE',
588: p_token1 => 'ENTITY',
589: p_token1_value => p_object_value_type
590: );
591: RAISE fnd_api.g_exc_error;
592: END IF;
593: END LOOP;
594: ELSIF p_object_value_type = 'CONSTANT'
595: THEN

Line 612: RAISE fnd_api.g_exc_error;

608: p_msg_name => 'OKC_I_INVALID_COND_VALUE',
609: p_token1 => 'ENTITY',
610: p_token1_value => p_object_value_type
611: );
612: RAISE fnd_api.g_exc_error;
613: END IF;
614: END LOOP;
615: ELSIF p_object_value_type = 'VARIABLE'
616: THEN

Line 631: RAISE fnd_api.g_exc_error;

627: p_msg_name => 'OKC_I_INVALID_COND_VALUE',
628: p_token1 => 'ENTITY',
629: p_token1_value => p_object_value_type
630: );
631: RAISE fnd_api.g_exc_error;
632: END IF;
633: END LOOP;
634: ELSIF p_object_value_type = 'VALUE'
635: THEN

Line 659: RAISE fnd_api.g_exc_error;

655: p_msg_name => 'OKC_I_INVALID_COND_VALUE',
656: p_token1 => 'ENTITY',
657: p_token1_value => p_object_value_type
658: );
659: RAISE fnd_api.g_exc_error;
660: END IF;
661: END LOOP;
662: END IF;
663: EXCEPTION

Line 664: WHEN fnd_api.g_exc_error

660: END IF;
661: END LOOP;
662: END IF;
663: EXCEPTION
664: WHEN fnd_api.g_exc_error
665: THEN
666: set_proc_error_message (p_proc => l_proc);
667: set_rec_num_message (p_rec_num => l_failed_rec_num);
668: RAISE;

Line 749: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);

745: l_message VARCHAR2 (2000);
746: BEGIN
747: FOR i IN 1 .. fnd_msg_pub.count_msg
748: LOOP
749: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
750:
751: IF (LENGTH (l_message) + LENGTH (Nvl(x_message,' '))) <= 2500
752: THEN
753: x_message := x_message || l_message;

Line 883: RAISE fnd_api.g_exc_error;

879: p_msg_name => l_okc_i_not_null,
880: p_token1 => l_field,
881: p_token1_value => 'ORG_ID'
882: );
883: RAISE fnd_api.g_exc_error;
884: END IF;
885:
886: IF p_rule_header_rec.intent IS NULL
887: THEN

Line 893: RAISE fnd_api.g_exc_error;

889: p_msg_name => l_okc_i_not_null,
890: p_token1 => l_field,
891: p_token1_value => 'INTENT'
892: );
893: RAISE fnd_api.g_exc_error;
894: ELSE
895: IF p_rule_header_rec.intent NOT IN ('B', 'S')
896: THEN
897: okc_api.set_message (p_app_name => g_app_name,

Line 902: RAISE fnd_api.g_exc_error;

898: p_msg_name => l_okc_i_invalid_value,
899: p_token1 => l_field,
900: p_token1_value => 'INTENT'
901: );
902: RAISE fnd_api.g_exc_error;
903: END IF;
904: END IF;
905:
906: IF p_rule_header_rec.rule_name IS NULL

Line 913: RAISE fnd_api.g_exc_error;

909: p_msg_name => l_okc_i_not_null,
910: p_token1 => l_field,
911: p_token1_value => 'RULE_NAME'
912: );
913: RAISE fnd_api.g_exc_error;
914: ELSE
915: OPEN cur_rule_name_exists (p_rule_header_rec.rule_name,
916: p_rule_header_rec.org_id
917: );

Line 929: RAISE fnd_api.g_exc_error;

925: THEN
926: okc_api.set_message (p_app_name => g_app_name,
927: p_msg_name => 'OKC_XPRT_RULE_NAME_EXISTS'
928: );
929: RAISE fnd_api.g_exc_error;
930: END IF;
931:
932: l_validate_flag := NULL;
933: END IF;

Line 942: RAISE fnd_api.g_exc_error;

938: p_msg_name => l_okc_i_not_null,
939: p_token1 => l_field,
940: p_token1_value => 'RULE_TYPE'
941: );
942: RAISE fnd_api.g_exc_error;
943: ELSE
944: -- verify the lookup from OKC_XPRT_RULE_TYPE and execlude the 'All' Type
945: IF p_rule_header_rec.rule_type NOT IN
946: (g_clause_rule_type, g_term_dev_rule_type)

Line 953: RAISE fnd_api.g_exc_error;

949: p_msg_name => l_okc_i_invalid_value,
950: p_token1 => l_field,
951: p_token1_value => 'RULE_TYPE'
952: );
953: RAISE fnd_api.g_exc_error;
954: END IF;
955: END IF;
956:
957: IF p_rule_header_rec.condition_expr_code IS NULL

Line 964: RAISE fnd_api.g_exc_error;

960: p_msg_name => l_okc_i_not_null,
961: p_token1 => l_field,
962: p_token1_value => 'CONDITION_EXPR_CODE'
963: );
964: RAISE fnd_api.g_exc_error;
965:
966: ELSE
967: -- OKC_XPRT_CONDITION_CRITERIA
968: -- ALL -> Match all Conditions => All Conditions must be true

Line 977: RAISE fnd_api.g_exc_error;

973: p_msg_name => l_okc_i_invalid_value,
974: p_token1 => l_field,
975: p_token1_value => 'CONDITION_EXPR_CODE'
976: );
977: RAISE fnd_api.g_exc_error;
978: END IF;
979: END IF;
980:
981: IF p_rule_header_rec.org_wide_flag NOT IN ('Y' , 'N') THEN

Line 987: RAISE fnd_api.g_exc_error;

983: p_msg_name => l_okc_i_invalid_value,
984: p_token1 => l_field,
985: p_token1_value => 'ORG_WIDE_FLAG'
986: );
987: RAISE fnd_api.g_exc_error;
988: END IF;
989:
990: EXCEPTION
991: WHEN fnd_api.g_exc_error

Line 991: WHEN fnd_api.g_exc_error

987: RAISE fnd_api.g_exc_error;
988: END IF;
989:
990: EXCEPTION
991: WHEN fnd_api.g_exc_error
992: THEN
993: set_proc_error_message (p_proc => l_proc);
994: RAISE;
995: WHEN OTHERS

Line 1019: RAISE fnd_api.g_exc_error;

1015: p_msg_name => l_okc_i_invalid_value,
1016: p_token1 => l_field,
1017: p_token1_value => 'ORG_ID'
1018: );
1019: RAISE fnd_api.g_exc_error;
1020: END IF;
1021:
1022: l_validate_flag := NULL;
1023:

Line 1089: WHEN fnd_api.g_exc_error

1085: )
1086: RETURNING rule_id
1087: INTO p_rule_header_rec.rule_id;
1088: EXCEPTION
1089: WHEN fnd_api.g_exc_error
1090: THEN
1091: set_proc_error_message (p_proc => l_proc);
1092: RAISE;
1093: WHEN OTHERS

Line 1257: RAISE fnd_api.g_exc_error;

1253: p_msg_name => l_okc_i_not_null,
1254: p_token1 => l_field,
1255: p_token1_value => 'RULE_ID'
1256: );
1257: RAISE fnd_api.g_exc_error;
1258: END IF;
1259:
1260: IF p_rule_condition_rec.object_type IS NULL
1261: THEN

Line 1267: RAISE fnd_api.g_exc_error;

1263: p_msg_name => l_okc_i_not_null,
1264: p_token1 => l_field,
1265: p_token1_value => 'OBJECT_TYPE'
1266: );
1267: RAISE fnd_api.g_exc_error;
1268: END IF;
1269:
1270: IF p_rule_condition_rec.object_type <> 'CLAUSE'
1271: AND p_rule_condition_rec.object_code IS NULL

Line 1278: RAISE fnd_api.g_exc_error;

1274: p_msg_name => l_okc_i_not_null,
1275: p_token1 => l_field,
1276: p_token1_value => 'OBJECT_CODE'
1277: );
1278: RAISE fnd_api.g_exc_error;
1279: END IF;
1280:
1281:
1282:

Line 1290: RAISE fnd_api.g_exc_error;

1286: p_msg_name => l_okc_i_not_null,
1287: p_token1 => l_field,
1288: p_token1_value => 'OPERATOR'
1289: );
1290: RAISE fnd_api.g_exc_error;
1291: END IF;
1292:
1293: IF p_rule_condition_rec.object_type <> 'CLAUSE'
1294: AND p_rule_condition_rec.object_value_type IS NULL

Line 1301: RAISE fnd_api.g_exc_error;

1297: p_msg_name => l_okc_i_not_null,
1298: p_token1 => l_field,
1299: p_token1_value => 'OBJECT_VALUE_TYPE'
1300: );
1301: RAISE fnd_api.g_exc_error;
1302: END IF;
1303:
1304: IF NOT (p_rule_condition_rec.rule_cond_vals_tbl.COUNT > 0)
1305: THEN

Line 1311: RAISE fnd_api.g_exc_error;

1307: p_msg_name => l_okc_i_not_null,
1308: p_token1 => l_field,
1309: p_token1_value => 'RULE_COND_VALS_TBL'
1310: );
1311: RAISE fnd_api.g_exc_error;
1312: END IF;
1313:
1314: IF l_rule_type = g_clause_rule_type
1315: AND p_rule_condition_rec.object_type NOT IN

Line 1323: RAISE fnd_api.g_exc_error;

1319: p_msg_name => l_okc_i_invalid_value,
1320: p_token1 => l_field,
1321: p_token1_value => 'OBJECT_TYPE'
1322: );
1323: RAISE fnd_api.g_exc_error;
1324: END IF;
1325:
1326: IF l_rule_type = g_term_dev_rule_type
1327: AND p_rule_condition_rec.object_type NOT IN

Line 1335: RAISE fnd_api.g_exc_error;

1331: p_msg_name => l_okc_i_invalid_value,
1332: p_token1 => l_field,
1333: p_token1_value => 'OBJECT_TYPE'
1334: );
1335: RAISE fnd_api.g_exc_error;
1336: END IF;
1337:
1338: IF p_rule_condition_rec.object_type = 'CLAUSE'
1339: THEN

Line 1362: RAISE fnd_api.g_exc_error;

1358: p_msg_name => l_okc_i_invalid_value,
1359: p_token1 => l_field,
1360: p_token1_value => 'OPERATOR'
1361: );
1362: RAISE fnd_api.g_exc_error;
1363: END IF;
1364:
1365: CLOSE c_validate_lookup;
1366:

Line 1390: RAISE fnd_api.g_exc_error;

1386: p_msg_name => l_okc_i_invalid_value,
1387: p_token1 => l_field,
1388: p_token1_value => 'OBJECT_CODE'
1389: );
1390: RAISE fnd_api.g_exc_error;
1391: END IF;
1392:
1393: get_question_details
1394: (p_question_id => TO_NUMBER

Line 1415: RAISE fnd_api.g_exc_error;

1411: p_msg_name => l_okc_i_invalid_value,
1412: p_token1 => l_field,
1413: p_token1_value => 'OPERATOR'
1414: );
1415: RAISE fnd_api.g_exc_error;
1416: END IF;
1417: ELSIF p_rule_condition_rec.object_code_datatype = 'L'
1418: THEN
1419: l_operator_lookup := 'OKC_XPRT_CHAR_OPERATOR';

Line 1442: RAISE fnd_api.g_exc_error;

1438: p_msg_name => l_okc_i_invalid_value,
1439: p_token1 => l_field,
1440: p_token1_value => 'OPERATOR'
1441: );
1442: RAISE fnd_api.g_exc_error;
1443: END IF;
1444:
1445: CLOSE c_validate_lookup;
1446: END IF;

Line 1456: RAISE fnd_api.g_exc_error;

1452: p_msg_name => l_okc_i_invalid_value,
1453: p_token1 => l_field,
1454: p_token1_value => 'OBJECT_VALUE_TYPE'
1455: );
1456: RAISE fnd_api.g_exc_error;
1457: END IF;
1458:
1459: IF p_rule_condition_rec.object_type <> 'CLAUSE'
1460: AND p_rule_condition_rec.object_code_datatype IS NULL

Line 1467: RAISE fnd_api.g_exc_error;

1463: p_msg_name => l_okc_i_not_null,
1464: p_token1 => l_field,
1465: p_token1_value => 'OBJECT_CODE_DATATYPE'
1466: );
1467: RAISE fnd_api.g_exc_error;
1468: END IF;
1469:
1470: validate_rule_condn_val_tbl
1471: (p_object_value_type => p_rule_condition_rec.object_value_type,

Line 1494: RAISE fnd_api.g_exc_error;

1490: p_msg_name => l_okc_i_invalid_value,
1491: p_token1 => l_field,
1492: p_token1_value => 'OBJECT_CODE'
1493: );
1494: RAISE fnd_api.g_exc_error;
1495: END IF;
1496:
1497: p_rule_condition_rec.object_code_datatype := x_variable_datatype;
1498: p_rule_condition_rec.object_value_set_name := x_value_set_name;

Line 1522: RAISE fnd_api.g_exc_error;

1518: p_msg_name => l_okc_i_invalid_value,
1519: p_token1 => l_field,
1520: p_token1_value => 'OPERATOR'
1521: );
1522: RAISE fnd_api.g_exc_error;
1523: END IF;
1524:
1525: CLOSE c_validate_lookup;
1526:

Line 1535: RAISE fnd_api.g_exc_error;

1531: p_msg_name => l_okc_i_invalid_value,
1532: p_token1 => l_field,
1533: p_token1_value => 'OBJECT_VALUE_TYPE'
1534: );
1535: RAISE fnd_api.g_exc_error;
1536: END IF;
1537:
1538:
1539:

Line 1635: RAISE fnd_api.g_exc_error;

1631: p_msg_name => 'OKC_I_RULE_NO_MATCH',
1632: p_token1 => 'ENTITY',
1633: p_token1_value => 'CONDITION'
1634: );
1635: RAISE fnd_api.g_exc_error;
1636: END IF;
1637:
1638: p_rule_condition_tbl (i).rule_id := g_rule_id;
1639: create_rule_condition

Line 1712: RAISE fnd_api.g_exc_error;

1708: p_msg_name => l_okc_i_not_null,
1709: p_token1 => l_field,
1710: p_token1_value => 'RULE_ID'
1711: );
1712: RAISE fnd_api.g_exc_error;
1713: END IF;
1714:
1715: IF p_rule_outcome_rec.object_type IS NULL
1716: THEN

Line 1722: RAISE fnd_api.g_exc_error;

1718: p_msg_name => l_okc_i_not_null,
1719: p_token1 => l_field,
1720: p_token1_value => 'OBJECT_TYPE'
1721: );
1722: RAISE fnd_api.g_exc_error;
1723: ELSE
1724: IF p_rule_outcome_rec.object_type NOT IN ('QUESTION', 'CLAUSE')
1725: THEN
1726: okc_api.set_message (p_app_name => g_app_name,

Line 1731: RAISE fnd_api.g_exc_error;

1727: p_msg_name => l_okc_i_invalid_value,
1728: p_token1 => l_field,
1729: p_token1_value => 'OBJECT_TYPE'
1730: );
1731: RAISE fnd_api.g_exc_error;
1732: END IF;
1733: END IF;
1734:
1735: IF p_rule_outcome_rec.object_value_id IS NULL

Line 1742: RAISE fnd_api.g_exc_error;

1738: p_msg_name => l_okc_i_not_null,
1739: p_token1 => l_field,
1740: p_token1_value => 'OBJECT_VALUE_ID'
1741: );
1742: RAISE fnd_api.g_exc_error;
1743: END IF;
1744:
1745: IF is_valid_rule (p_rule_id => p_rule_outcome_rec.rule_id) <> 'Y'
1746: THEN

Line 1752: RAISE fnd_api.g_exc_error;

1748: p_msg_name => l_okc_i_invalid_value,
1749: p_token1 => l_field,
1750: p_token1_value => 'RULE_ID'
1751: );
1752: RAISE fnd_api.g_exc_error;
1753: END IF;
1754:
1755: IF g_rule_type <> g_clause_rule_type
1756: THEN

Line 1762: RAISE fnd_api.g_exc_error;

1758: p_msg_name => l_okc_i_invalid_value,
1759: p_token1 => l_field,
1760: p_token1_value => 'RULE_TYPE'
1761: );
1762: RAISE fnd_api.g_exc_error;
1763: END IF;
1764:
1765: IF is_valid_outcome
1766: (p_rule_id => p_rule_outcome_rec.rule_id,

Line 1776: RAISE fnd_api.g_exc_error;

1772: p_msg_name => l_okc_i_invalid_value,
1773: p_token1 => l_field,
1774: p_token1_value => 'OUTCOME'
1775: );
1776: RAISE fnd_api.g_exc_error;
1777: END IF;
1778:
1779: IF is_duplicate_outcome
1780: (p_rule_id => p_rule_outcome_rec.rule_id,

Line 1791: RAISE fnd_api.g_exc_error;

1787: p_msg_name => l_okc_i_invalid_value,
1788: p_token1 => l_field,
1789: p_token1_value => 'OUTCOME'
1790: );
1791: RAISE fnd_api.g_exc_error;
1792: END IF;
1793: /* RWA Changes Start */
1794: IF p_rule_outcome_rec.mandatory_yn IS NOT NULL
1795: AND p_rule_outcome_rec.mandatory_yn NOT IN ('Y','N') THEN

Line 1802: RAISE fnd_api.g_exc_error;

1798: p_msg_name => l_okc_i_invalid_value,
1799: p_token1 => l_field,
1800: p_token1_value => 'MANDATORY_YN'
1801: );
1802: RAISE fnd_api.g_exc_error;
1803: END IF;
1804:
1805: IF p_rule_outcome_rec.mandatory_rwa IS NOT NULL
1806: AND isValidLookup('OKC_CLAUSE_RWA', p_rule_outcome_rec.mandatory_rwa) = 'N' THEN

Line 1813: RAISE fnd_api.g_exc_error;

1809: p_msg_name => l_okc_i_invalid_value,
1810: p_token1 => l_field,
1811: p_token1_value => 'MANDATORY_RWA'
1812: );
1813: RAISE fnd_api.g_exc_error;
1814: END IF;
1815:
1816: /* RWA Changes End */
1817:

Line 1882: RAISE fnd_api.g_exc_error;

1878: p_msg_name => 'OKC_I_RULE_NO_MATCH',
1879: p_token1 => 'ENTITY',
1880: p_token1_value => 'OUTCOME'
1881: );
1882: RAISE fnd_api.g_exc_error;
1883: END IF;
1884:
1885: p_rule_outcome_tbl (i).rule_id := g_rule_id;
1886: create_rule_outcome (p_rule_outcome_rec => p_rule_outcome_tbl

Line 1920: RAISE fnd_api.g_exc_error;

1916: p_msg_name => 'OKC_I_RULE_NO_MATCH',
1917: p_token1 => 'ENTITY',
1918: p_token1_value => 'TEMPLATE_RULE'
1919: );
1920: RAISE fnd_api.g_exc_error;
1921: END IF;
1922:
1923: create_template_rules
1924: (p_template_rules_rec => p_template_rules_tbl

Line 1985: RAISE fnd_api.g_exc_error;

1981: p_msg_name => l_okc_i_not_null,
1982: p_token1 => l_field,
1983: p_token1_value => 'TEMPLATE_ID'
1984: );
1985: RAISE fnd_api.g_exc_error;
1986: ELSE
1987: OPEN cur_val_template;
1988:
1989: FETCH cur_val_template

Line 2001: RAISE fnd_api.g_exc_error;

1997: p_msg_name => l_okc_i_invalid_value,
1998: p_token1 => l_field,
1999: p_token1_value => 'OUTCOME'
2000: );
2001: RAISE fnd_api.g_exc_error;
2002: END IF;
2003:
2004: l_val_flag := NULL;
2005: END IF;

Line 2019: RAISE fnd_api.g_exc_error;

2015: THEN
2016: okc_api.set_message (p_app_name => g_app_name,
2017: p_msg_name => 'OKC_XPRT_DUPLICATE_TMPL_ASSIGN'
2018: );
2019: RAISE fnd_api.g_exc_error;
2020: END IF;
2021:
2022: -- Insert
2023: INSERT INTO okc_xprt_template_rules

Line 2160: RAISE fnd_api.g_exc_error;

2156: p_msg_name => l_okc_i_not_null,
2157: p_token1 => l_field,
2158: p_token1_value => 'RULE_NAME'
2159: );
2160: RAISE fnd_api.g_exc_error;
2161: ELSE
2162: IF p_rule_header_rec.rule_name <> p_db_rule_header.rule_name
2163: THEN
2164: OPEN cur_rule_name_exists (p_rule_header_rec.rule_name,

Line 2179: RAISE fnd_api.g_exc_error;

2175: okc_api.set_message
2176: (p_app_name => g_app_name,
2177: p_msg_name => 'OKC_XPRT_RULE_NAME_EXISTS'
2178: );
2179: RAISE fnd_api.g_exc_error;
2180: END IF;
2181: END IF;
2182: END IF;
2183:

Line 2190: RAISE fnd_api.g_exc_error;

2186: p_msg_name => l_okc_i_invalid_value,
2187: p_token1 => l_field,
2188: p_token1_value => 'ORG_WIDE_FLAG'
2189: );
2190: RAISE fnd_api.g_exc_error;
2191: END IF;
2192:
2193: IF p_rule_header_rec.condition_expr_code NOT IN ('ALL', 'ANY')
2194: THEN

Line 2200: RAISE fnd_api.g_exc_error;

2196: p_msg_name => l_okc_i_invalid_value,
2197: p_token1 => l_field,
2198: p_token1_value => 'CONDITION_EXPR_CODE'
2199: );
2200: RAISE fnd_api.g_exc_error;
2201: END IF;
2202:
2203: EXCEPTION
2204: WHEN OTHERS

Line 2270: RAISE fnd_api.g_exc_error;

2266: p_msg_name => l_okc_i_invalid_value,
2267: p_token1 => l_field,
2268: p_token1_value => 'RULE_ID'
2269: );
2270: RAISE fnd_api.g_exc_error;
2271: END;
2272:
2273: -- If status is Active(Pending), Disable (Pending), Disabled then do not allow update to the
2274: -- Rule.

Line 2287: RAISE fnd_api.g_exc_error;

2283: p_msg_name => 'OKC_I_RULE_STS_NO_UPD',
2284: p_token1 => 'STATUS',
2285: p_token1_value => l_rule_header_row.status_code
2286: );
2287: RAISE fnd_api.g_exc_error;
2288: END IF;
2289:
2290: l_progress := '030';
2291:

Line 2307: RAISE fnd_api.g_exc_error;

2303: p_token1_value => l_rule_header_row.status_code,
2304: p_token2 => 'FIELD',
2305: p_token2_value => 'ORG_ID'
2306: );
2307: RAISE fnd_api.g_exc_error;
2308: END IF;
2309:
2310: l_progress := '040';
2311:

Line 2327: RAISE fnd_api.g_exc_error;

2323: p_token1_value => l_rule_header_row.status_code,
2324: p_token2 => 'FIELD',
2325: p_token2_value => 'INTENT'
2326: );
2327: RAISE fnd_api.g_exc_error;
2328: END IF;
2329:
2330: l_progress := '050';
2331:

Line 2347: RAISE fnd_api.g_exc_error;

2343: p_token1_value => l_rule_header_row.status_code,
2344: p_token2 => 'FIELD',
2345: p_token2_value => 'RULE_TYPE'
2346: );
2347: RAISE fnd_api.g_exc_error;
2348: END IF;
2349:
2350: l_progress := '060';
2351:

Line 2362: RAISE fnd_api.g_exc_error;

2358: -- You can not change Status
2359: okc_api.set_message (p_app_name => g_app_name,
2360: p_msg_name => 'OKC_I_RULE_STS_CHANGE'
2361: );
2362: RAISE fnd_api.g_exc_error;
2363: END IF;
2364:
2365: l_progress := '070';
2366:

Line 2396: RAISE fnd_api.g_exc_error;

2392: p_token1_value => l_rule_header_row.status_code,
2393: p_token2 => 'FIELD',
2394: p_token2_value => 'RULE_NAME'
2395: );
2396: RAISE fnd_api.g_exc_error;
2397: END IF;
2398:
2399: l_progress := '085';
2400:

Line 2416: RAISE fnd_api.g_exc_error;

2412: p_token1_value => l_rule_header_row.status_code,
2413: p_token2 => 'FIELD',
2414: p_token2_value => 'ORG_WIDE_FLAG'
2415: );
2416: RAISE fnd_api.g_exc_error;
2417: END IF;
2418: END IF;
2419:
2420: l_progress := '100';

Line 2508: RAISE fnd_api.g_exc_error;

2504: p_rule_rec.status := g_ret_sts_error;
2505: okc_api.set_message (p_app_name => g_app_name,
2506: p_msg_name => 'OKC_XPRT_RULE_INCOMPLETE'
2507: );
2508: RAISE fnd_api.g_exc_error;
2509: END IF;
2510: ELSIF l_rule_type = g_term_dev_rule_type
2511: THEN
2512: IF NOT ((p_rule_rec.rule_condition_tbl.COUNT > 0))

Line 2519: RAISE fnd_api.g_exc_error;

2515: okc_api.set_message
2516: (p_app_name => g_app_name,
2517: p_msg_name => 'OKC_XPRT_POLICYRULE_INCOMPLETE'
2518: );
2519: RAISE fnd_api.g_exc_error;
2520: END IF;
2521: ELSE
2522: p_rule_rec.status := g_ret_sts_error;
2523: okc_api.set_message (p_app_name => g_app_name,

Line 2528: RAISE fnd_api.g_exc_error;

2524: p_msg_name => l_okc_i_invalid_value,
2525: p_token1 => l_field,
2526: p_token1_value => 'RULE_TYPE'
2527: );
2528: RAISE fnd_api.g_exc_error;
2529: END IF;
2530:
2531: -- PRE VALIDATION END
2532: BEGIN

Line 2586: RAISE fnd_api.g_exc_error;

2582:
2583: IF validaterulecondition (g_rule_id) = 'N'
2584: THEN
2585: p_rule_rec.status := g_ret_sts_error;
2586: RAISE fnd_api.g_exc_error;
2587: END IF;
2588: END IF;
2589:
2590: IF NVL (p_rule_rec.rule_header_rec.org_wide_flag, 'X') <> 'Y'

Line 2675: RAISE fnd_api.g_exc_error;

2671:
2672: IF validaterulecondition (g_rule_id) = 'N'
2673: THEN
2674: p_rule_rec.status := g_ret_sts_error;
2675: RAISE fnd_api.g_exc_error;
2676: END IF;
2677:
2678: -- Need to check whether Rule Header, condition and out come exists
2679: p_rule_rec.status := g_ret_sts_success;

Line 2729: RAISE fnd_api.g_exc_error;

2725: p_msg_name => 'OKC_I_RULE_STS_NO_UPD',
2726: p_token1 => 'STATUS',
2727: p_token1_value => g_rule_status_code
2728: );
2729: RAISE fnd_api.g_exc_error;
2730: END IF;
2731:
2732: -- Check validity of input conditions
2733: IF p_rule_child_entities_rec.rule_condition_id_tbl.COUNT > 0

Line 2788: RAISE fnd_api.g_exc_error;

2784: p_rule_child_entities_rec.status := g_ret_sts_error;
2785: okc_api.set_message (p_app_name => g_app_name,
2786: p_msg_name => 'OKC_XPRT_RULE_INCOMPLETE'
2787: );
2788: RAISE fnd_api.g_exc_error;
2789: END IF;
2790: END IF;
2791:
2792: -- Check validity of input Outcomes and delete

Line 2841: RAISE fnd_api.g_exc_error;

2837: p_rule_child_entities_rec.status := g_ret_sts_error;
2838: okc_api.set_message (p_app_name => g_app_name,
2839: p_msg_name => 'OKC_XPRT_RULE_INCOMPLETE'
2840: );
2841: RAISE fnd_api.g_exc_error;
2842: END IF;
2843: END IF;
2844:
2845: -- Check validity of template rules

Line 2905: p_commit IN VARCHAR2 := fnd_api.g_false

2901: -- PUBLIC PROCEDURES --
2902: -------------------------------
2903: PROCEDURE create_rule (
2904: p_rule_tbl IN OUT NOCOPY rule_tbl_type,
2905: p_commit IN VARCHAR2 := fnd_api.g_false
2906: )
2907: IS
2908: l_success_count NUMBER := 0;
2909: l_error_count NUMBER := 0;

Line 2929: IF fnd_api.to_boolean (p_commit)

2925: IF p_rule_tbl (i).status = g_ret_sts_success
2926: THEN
2927: l_success_count := l_success_count + 1;
2928:
2929: IF fnd_api.to_boolean (p_commit)
2930: THEN
2931: COMMIT;
2932: END IF;
2933: ELSE

Line 2938: WHEN fnd_api.g_exc_error

2934: l_error_count := l_error_count + 1;
2935: ROLLBACK TO create_rule_sp;
2936: END IF;
2937: EXCEPTION
2938: WHEN fnd_api.g_exc_error
2939: THEN
2940: p_rule_tbl (i).status := g_ret_sts_error;
2941: set_proc_error_message (p_proc => l_proc);
2942: set_rec_num_message (p_rec_num => l_failed_rec_num);

Line 2975: p_commit IN VARCHAR2 := fnd_api.g_false

2971: END create_rule;
2972:
2973: PROCEDURE update_rule (
2974: p_rule_tbl IN OUT NOCOPY rule_tbl_type,
2975: p_commit IN VARCHAR2 := fnd_api.g_false
2976: )
2977: IS
2978: l_success_count NUMBER := 0;
2979: l_error_count NUMBER := 0;

Line 2998: IF fnd_api.to_boolean (p_commit)

2994: IF p_rule_tbl (i).status = g_ret_sts_success
2995: THEN
2996: l_success_count := l_success_count + 1;
2997:
2998: IF fnd_api.to_boolean (p_commit)
2999: THEN
3000: COMMIT;
3001: END IF;
3002: ELSE

Line 3007: WHEN fnd_api.g_exc_error

3003: l_error_count := l_error_count + 1;
3004: ROLLBACK TO update_rule_sp;
3005: END IF;
3006: EXCEPTION
3007: WHEN fnd_api.g_exc_error
3008: THEN
3009: p_rule_tbl (i).status := g_ret_sts_error;
3010: set_proc_error_message (p_proc => l_proc);
3011: set_rec_num_message (p_rec_num => l_failed_rec_num);

Line 3044: p_commit IN VARCHAR2 := fnd_api.g_false

3040: END update_rule;
3041:
3042: PROCEDURE delete_rule_child_entities (
3043: p_rule_child_entities_tbl IN OUT NOCOPY rule_child_entities_tbl_type,
3044: p_commit IN VARCHAR2 := fnd_api.g_false
3045: )
3046: IS
3047: l_success_count NUMBER := 0;
3048: l_error_count NUMBER := 0;

Line 3071: IF fnd_api.to_boolean (p_commit)

3067: IF p_rule_child_entities_tbl (i).status = g_ret_sts_success
3068: THEN
3069: l_success_count := l_success_count + 1;
3070:
3071: IF fnd_api.to_boolean (p_commit)
3072: THEN
3073: COMMIT;
3074: END IF;
3075: ELSE