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

Line 766: x_return_status := OKC_API.G_RET_STS_SUCCESS;

762: okc_debug.Set_Indentation(l_proc);
763: okc_debug.log('10: Entering ',2);
764: END IF;
765:
766: x_return_status := OKC_API.G_RET_STS_SUCCESS;
767: x_status := 'TRUE';
768: IF cnl_cur%ISOPEN THEN
769: CLOSE cnl_cur;
770: END IF;

Line 906: x_return_status := OKC_API.G_RET_STS_SUCCESS;

902: x_status := 'FALSE';
903: END;
904: ---** Bug#2934909 converting execute immediate into dbms_sql ** END ** ----
905: END IF;
906: x_return_status := OKC_API.G_RET_STS_SUCCESS;
907:
908: IF (l_debug = 'Y') THEN
909: okc_debug.log('1000: Leaving ',2);
910: okc_debug.Reset_Indentation;

Line 915: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

911: END IF;
912:
913: EXCEPTION
914: WHEN OTHERS THEN
915: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
916:
917: IF (l_debug = 'Y') THEN
918: okc_debug.log('2000: Leaving ',2);
919: okc_debug.Reset_Indentation;

Line 952: 'CHAR' ,'OKC_API.G_MISS_CHAR',

948: decode(pdp.data_type,'CHAR','''',
949: 'DATE','''',NULL) prefix_param,
950: nvl(pdp.default_value,
951: decode(pdp.data_type,
952: 'CHAR' ,'OKC_API.G_MISS_CHAR',
953: 'NUMBER','OKC_API.G_MISS_NUM',
954: 'DATE' ,'OKC_API.G_MISS_DATE',
955: 'OKC_API.G_MISS_CHAR')) default_value,
956: pdp.data_type datatype,

Line 953: 'NUMBER','OKC_API.G_MISS_NUM',

949: 'DATE','''',NULL) prefix_param,
950: nvl(pdp.default_value,
951: decode(pdp.data_type,
952: 'CHAR' ,'OKC_API.G_MISS_CHAR',
953: 'NUMBER','OKC_API.G_MISS_NUM',
954: 'DATE' ,'OKC_API.G_MISS_DATE',
955: 'OKC_API.G_MISS_CHAR')) default_value,
956: pdp.data_type datatype,
957: pdp.required_yn required_yn

Line 954: 'DATE' ,'OKC_API.G_MISS_DATE',

950: nvl(pdp.default_value,
951: decode(pdp.data_type,
952: 'CHAR' ,'OKC_API.G_MISS_CHAR',
953: 'NUMBER','OKC_API.G_MISS_NUM',
954: 'DATE' ,'OKC_API.G_MISS_DATE',
955: 'OKC_API.G_MISS_CHAR')) default_value,
956: pdp.data_type datatype,
957: pdp.required_yn required_yn
958: FROM okc_outcomes_b oce,

Line 955: 'OKC_API.G_MISS_CHAR')) default_value,

951: decode(pdp.data_type,
952: 'CHAR' ,'OKC_API.G_MISS_CHAR',
953: 'NUMBER','OKC_API.G_MISS_NUM',
954: 'DATE' ,'OKC_API.G_MISS_DATE',
955: 'OKC_API.G_MISS_CHAR')) default_value,
956: pdp.data_type datatype,
957: pdp.required_yn required_yn
958: FROM okc_outcomes_b oce,
959: okc_process_defs_v pdf,

Line 1011: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1007: okc_debug.Set_Indentation(l_proc);
1008: okc_debug.log('10: Entering build outcome ',2);
1009: END IF;
1010:
1011: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1012: x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();
1013: l_msg_tab := okc_aq_pvt.msg_tab_typ();
1014: l_string := NULL;
1015: FOR i IN 1..p_cnh_tab.COUNT LOOP

Line 1124: no_param := instr(l_string,'OKC_API',1,1);

1120: okc_debug.log('10: l_string: '||l_string,2);
1121: END IF;
1122: -- if any of the parameter values are missing
1123: -- then raise exception
1124: no_param := instr(l_string,'OKC_API',1,1);
1125: IF no_param <> 0 AND
1126: oce_rec.required_yn = 'Y' THEN
1127: l_string := null;
1128: OKC_API.SET_MESSAGE(

Line 1128: OKC_API.SET_MESSAGE(

1124: no_param := instr(l_string,'OKC_API',1,1);
1125: IF no_param <> 0 AND
1126: oce_rec.required_yn = 'Y' THEN
1127: l_string := null;
1128: OKC_API.SET_MESSAGE(
1129: p_app_name => g_app_name
1130: ,p_msg_name => 'OKC_NO_PARAMS'
1131: ,p_token1 => 'PROCESS'
1132: ,p_token1_value => oce_rec.outcome

Line 1167: OKC_API.SET_MESSAGE(

1163: l_msg_tab(async_index).element_value
1164: := UPPER(oce_rec.outcome);
1165: -- if outcome name is missing then raise exception
1166: IF l_msg_tab(async_index).element_value IS NULL THEN
1167: OKC_API.SET_MESSAGE(
1168: p_app_name => g_app_name
1169: ,p_msg_name => 'OKC_INVALID_PROCESS'
1170: );
1171: END IF;

Line 1216: no_param := instr(l_string,'OKC_API',1,1);

1212: ||oce_rec.prefix_param;
1213: v_oce_id := oce_rec.oce_id;
1214: -- if any of the parameter values are missing
1215: -- then raise exception
1216: no_param := instr(l_string,'OKC_API',1,1);
1217:
1218: --Bug 3448425 IF no_param <> 0 AND
1219: IF (l_debug = 'Y') THEN
1220: okc_debug.log('1000: Build Outcome: '||l_attr_value,2);

Line 1222: IF l_attr_value like 'OKC_API.G_MISS%' AND

1218: --Bug 3448425 IF no_param <> 0 AND
1219: IF (l_debug = 'Y') THEN
1220: okc_debug.log('1000: Build Outcome: '||l_attr_value,2);
1221: END IF;
1222: IF l_attr_value like 'OKC_API.G_MISS%' AND
1223: oce_rec.required_yn = 'Y' THEN
1224: l_string := null;
1225: OKC_API.SET_MESSAGE(
1226: p_app_name => g_app_name

Line 1225: OKC_API.SET_MESSAGE(

1221: END IF;
1222: IF l_attr_value like 'OKC_API.G_MISS%' AND
1223: oce_rec.required_yn = 'Y' THEN
1224: l_string := null;
1225: OKC_API.SET_MESSAGE(
1226: p_app_name => g_app_name
1227: ,p_msg_name => 'OKC_NO_PARAMS'
1228: ,p_token1 => 'PROCESS'
1229: ,p_token1_value => oce_rec.outcome

Line 1270: ('OKC_API.G_MISS_CHAR',

1266: oce_rec.default_value));
1267: -- if any of the parameter values are missing then write message to
1268: -- okc_aqerrors table and stop further processing of that outcome
1269: IF l_msg_tab(async_index).element_value IN
1270: ('OKC_API.G_MISS_CHAR',
1271: 'OKC_API.G_MISS_NUM',
1272: 'OKC_API.G_MISS_DATE')
1273: AND oce_rec.required_yn = 'Y' THEN
1274: OKC_API.SET_MESSAGE(

Line 1271: 'OKC_API.G_MISS_NUM',

1267: -- if any of the parameter values are missing then write message to
1268: -- okc_aqerrors table and stop further processing of that outcome
1269: IF l_msg_tab(async_index).element_value IN
1270: ('OKC_API.G_MISS_CHAR',
1271: 'OKC_API.G_MISS_NUM',
1272: 'OKC_API.G_MISS_DATE')
1273: AND oce_rec.required_yn = 'Y' THEN
1274: OKC_API.SET_MESSAGE(
1275: p_app_name => g_app_name

Line 1272: 'OKC_API.G_MISS_DATE')

1268: -- okc_aqerrors table and stop further processing of that outcome
1269: IF l_msg_tab(async_index).element_value IN
1270: ('OKC_API.G_MISS_CHAR',
1271: 'OKC_API.G_MISS_NUM',
1272: 'OKC_API.G_MISS_DATE')
1273: AND oce_rec.required_yn = 'Y' THEN
1274: OKC_API.SET_MESSAGE(
1275: p_app_name => g_app_name
1276: ,p_msg_name => 'OKC_NO_PARAMS'

Line 1274: OKC_API.SET_MESSAGE(

1270: ('OKC_API.G_MISS_CHAR',
1271: 'OKC_API.G_MISS_NUM',
1272: 'OKC_API.G_MISS_DATE')
1273: AND oce_rec.required_yn = 'Y' THEN
1274: OKC_API.SET_MESSAGE(
1275: p_app_name => g_app_name
1276: ,p_msg_name => 'OKC_NO_PARAMS'
1277: ,p_token1 => 'PROCESS'
1278: ,p_token1_value => oce_rec.outcome

Line 1291: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1287: END IF;
1288: END LOOP;
1289: CLOSE oce_cur;
1290: END LOOP;
1291: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1292:
1293: IF (l_debug = 'Y') THEN
1294: okc_debug.log('1000: Leaving Build outcome ',2);
1295: okc_debug.Reset_Indentation;

Line 1300: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1296: END IF;
1297:
1298: EXCEPTION
1299: WHEN OTHERS THEN
1300: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1301:
1302: IF (l_debug = 'Y') THEN
1303: okc_debug.log('2000: Leaving Build Outcome with error: '||sqlerrm,2);
1304: okc_debug.Reset_Indentation;

Line 1339: 'CHAR' ,'OKC_API.G_MISS_CHAR',

1335: decode(pdp.data_type,'CHAR','''',
1336: 'DATE','''',NULL) prefix_param,
1337: nvl(pdp.default_value,
1338: decode(pdp.data_type,
1339: 'CHAR' ,'OKC_API.G_MISS_CHAR',
1340: 'NUMBER','OKC_API.G_MISS_NUM',
1341: 'DATE' ,'OKC_API.G_MISS_DATE',
1342: 'OKC_API.G_MISS_CHAR')) default_value,
1343: pdp.data_type datatype,

Line 1340: 'NUMBER','OKC_API.G_MISS_NUM',

1336: 'DATE','''',NULL) prefix_param,
1337: nvl(pdp.default_value,
1338: decode(pdp.data_type,
1339: 'CHAR' ,'OKC_API.G_MISS_CHAR',
1340: 'NUMBER','OKC_API.G_MISS_NUM',
1341: 'DATE' ,'OKC_API.G_MISS_DATE',
1342: 'OKC_API.G_MISS_CHAR')) default_value,
1343: pdp.data_type datatype,
1344: pdp.required_yn required_yn

Line 1341: 'DATE' ,'OKC_API.G_MISS_DATE',

1337: nvl(pdp.default_value,
1338: decode(pdp.data_type,
1339: 'CHAR' ,'OKC_API.G_MISS_CHAR',
1340: 'NUMBER','OKC_API.G_MISS_NUM',
1341: 'DATE' ,'OKC_API.G_MISS_DATE',
1342: 'OKC_API.G_MISS_CHAR')) default_value,
1343: pdp.data_type datatype,
1344: pdp.required_yn required_yn
1345: FROM okc_outcomes_b oce,

Line 1342: 'OKC_API.G_MISS_CHAR')) default_value,

1338: decode(pdp.data_type,
1339: 'CHAR' ,'OKC_API.G_MISS_CHAR',
1340: 'NUMBER','OKC_API.G_MISS_NUM',
1341: 'DATE' ,'OKC_API.G_MISS_DATE',
1342: 'OKC_API.G_MISS_CHAR')) default_value,
1343: pdp.data_type datatype,
1344: pdp.required_yn required_yn
1345: FROM okc_outcomes_b oce,
1346: okc_process_defs_v pdf,

Line 1397: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1393: IF (l_debug = 'Y') THEN
1394: okc_debug.Set_Indentation(l_proc);
1395: okc_debug.log('10: Entering build date outcome ',2);
1396: END IF;
1397: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1398: --x_sync_outcome_tab := okc_condition_eval_pvt.outcome_tab_type();
1399: l_msg_tab := okc_aq_pvt.msg_tab_typ();
1400: l_string := NULL;
1401: FOR i IN 1..p_cnh_tab.COUNT LOOP

Line 1418: p_init_msg_list => OKC_API.G_FALSE,

1414: l_corrid_rec.corrid IS NOT NULL THEN
1415: -- launch outcome
1416: OKC_OUTCOME_INIT_PVT.Launch_outcome(
1417: p_api_version => 1,
1418: p_init_msg_list => OKC_API.G_FALSE,
1419: p_corrid_rec => l_corrid_rec,
1420: p_msg_tab_typ => l_msg_tab,
1421: x_msg_count => l_msg_count,
1422: x_msg_data => l_msg_data,

Line 1453: p_init_msg_list => OKC_API.G_FALSE,

1449: l_corrid_rec.corrid IS NOT NULL THEN
1450: -- launch outcome
1451: OKC_OUTCOME_INIT_PVT.Launch_outcome(
1452: p_api_version => 1,
1453: p_init_msg_list => OKC_API.G_FALSE,
1454: p_corrid_rec => l_corrid_rec,
1455: p_msg_tab_typ => l_msg_tab,
1456: x_msg_count => l_msg_count,
1457: x_msg_data => l_msg_data,

Line 1481: OKC_API.SET_MESSAGE(

1477: l_msg_tab(async_index).element_value := UPPER(oce_rec.outcome);
1478:
1479: -- if outcome name is missing then raise exception
1480: IF l_msg_tab(async_index).element_value IS NULL THEN
1481: OKC_API.SET_MESSAGE(
1482: p_app_name => g_app_name
1483: ,p_msg_name => 'OKC_INVALID_PROCESS'
1484: );
1485: END IF;

Line 1536: ('OKC_API.G_MISS_CHAR',

1532: oce_rec.default_value));
1533: -- if any of the parameter values are missing then write message to
1534: -- okc_aqerrors table and stop further processing of that outcome
1535: IF l_msg_tab(async_index).element_value IN
1536: ('OKC_API.G_MISS_CHAR',
1537: 'OKC_API.G_MISS_NUM',
1538: 'OKC_API.G_MISS_DATE')
1539: AND oce_rec.required_yn = 'Y' THEN
1540: OKC_API.SET_MESSAGE(

Line 1537: 'OKC_API.G_MISS_NUM',

1533: -- if any of the parameter values are missing then write message to
1534: -- okc_aqerrors table and stop further processing of that outcome
1535: IF l_msg_tab(async_index).element_value IN
1536: ('OKC_API.G_MISS_CHAR',
1537: 'OKC_API.G_MISS_NUM',
1538: 'OKC_API.G_MISS_DATE')
1539: AND oce_rec.required_yn = 'Y' THEN
1540: OKC_API.SET_MESSAGE(
1541: p_app_name => g_app_name

Line 1538: 'OKC_API.G_MISS_DATE')

1534: -- okc_aqerrors table and stop further processing of that outcome
1535: IF l_msg_tab(async_index).element_value IN
1536: ('OKC_API.G_MISS_CHAR',
1537: 'OKC_API.G_MISS_NUM',
1538: 'OKC_API.G_MISS_DATE')
1539: AND oce_rec.required_yn = 'Y' THEN
1540: OKC_API.SET_MESSAGE(
1541: p_app_name => g_app_name
1542: ,p_msg_name => 'OKC_NO_PARAMS'

Line 1540: OKC_API.SET_MESSAGE(

1536: ('OKC_API.G_MISS_CHAR',
1537: 'OKC_API.G_MISS_NUM',
1538: 'OKC_API.G_MISS_DATE')
1539: AND oce_rec.required_yn = 'Y' THEN
1540: OKC_API.SET_MESSAGE(
1541: p_app_name => g_app_name
1542: ,p_msg_name => 'OKC_NO_PARAMS'
1543: ,p_token1 => 'PROCESS'
1544: ,p_token1_value => oce_rec.outcome

Line 1556: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1552: END IF;
1553: END LOOP;
1554: CLOSE oce_cur;
1555: END LOOP;
1556: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1557:
1558: IF (l_debug = 'Y') THEN
1559: okc_debug.log('1000: Leaving Build date outcome ',2);
1560: okc_debug.Reset_Indentation;

Line 1565: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1561: END IF;
1562:
1563: EXCEPTION
1564: WHEN OTHERS THEN
1565: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1566:
1567: IF (l_debug = 'Y') THEN
1568: okc_debug.log('2000: Leaving Build Date Outcome with error: '||sqlerrm,2);
1569: okc_debug.Reset_Indentation;

Line 1629: p_init_msg_list => OKC_API.G_FALSE,

1625: END LOOP;
1626:
1627: OKC_CONDITIONS_PUB.create_cond_occurs(
1628: p_api_version => l_api_version,
1629: p_init_msg_list => OKC_API.G_FALSE,
1630: x_return_status => l_return_status,
1631: x_msg_data => l_msg_data,
1632: x_msg_count => l_msg_count,
1633: p_coev_tbl => l_coev_tbl,

Line 1636: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

1632: x_msg_count => l_msg_count,
1633: p_coev_tbl => l_coev_tbl,
1634: x_coev_tbl => v_coev_tbl
1635: );
1636: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1637: OKC_API.SET_MESSAGE(
1638: p_app_name => g_app_name
1639: ,p_msg_name => 'OKC_PROCESS_FAILED'
1640: ,p_token1 => 'SOURCE'

Line 1637: OKC_API.SET_MESSAGE(

1633: p_coev_tbl => l_coev_tbl,
1634: x_coev_tbl => v_coev_tbl
1635: );
1636: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1637: OKC_API.SET_MESSAGE(
1638: p_app_name => g_app_name
1639: ,p_msg_name => 'OKC_PROCESS_FAILED'
1640: ,p_token1 => 'SOURCE'
1641: ,p_token1_value => 'Condition Evaluator'

Line 1648: IF NVL(l_return_status,'X') = OKC_API.G_RET_STS_SUCCESS AND

1644: );
1645: RAISE OKC_PROCESS_FAILED;
1646: END IF;
1647: -- call Time Resolver for all condition occurrences
1648: IF NVL(l_return_status,'X') = OKC_API.G_RET_STS_SUCCESS AND
1649: v_coev_tbl.count <> 0 THEN
1650: FOR i IN 1..v_coev_tbl.COUNT LOOP
1651: IF cnh_cur%ISOPEN THEN
1652: CLOSE cnh_cur;

Line 1659: p_init_msg_list => OKC_API.G_FALSE,

1655: FETCH cnh_cur INTO cnh_rec;
1656: IF cnh_rec.dnz_chr_id IS NOT NULL THEN
1657: OKC_TIME_RES_PUB.Res_Time_Events(
1658: p_api_version => l_api_version,
1659: p_init_msg_list => OKC_API.G_FALSE,
1660: p_cnh_id => v_coev_tbl(i).cnh_id,
1661: p_coe_id => v_coev_tbl(i).id,
1662: p_date => v_coev_tbl(i).datetime,
1663: x_return_status => l_return_status);

Line 1664: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

1660: p_cnh_id => v_coev_tbl(i).cnh_id,
1661: p_coe_id => v_coev_tbl(i).id,
1662: p_date => v_coev_tbl(i).datetime,
1663: x_return_status => l_return_status);
1664: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1665: OKC_API.SET_MESSAGE(
1666: p_app_name => g_app_name
1667: ,p_msg_name => 'OKC_PROCESS_FAILED'
1668: ,p_token1 => 'SOURCE'

Line 1665: OKC_API.SET_MESSAGE(

1661: p_coe_id => v_coev_tbl(i).id,
1662: p_date => v_coev_tbl(i).datetime,
1663: x_return_status => l_return_status);
1664: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1665: OKC_API.SET_MESSAGE(
1666: p_app_name => g_app_name
1667: ,p_msg_name => 'OKC_PROCESS_FAILED'
1668: ,p_token1 => 'SOURCE'
1669: ,p_token1_value => 'Condition Evaluator'

Line 1684: p_init_msg_list => OKC_API.G_FALSE,

1680: -- create tasks for true conditions with tracked_yn = 'Y'
1681: IF UPPER(cnh_rec.tracked_yn) = 'Y' THEN
1682: OKC_TASK_PUB.create_condition_task(
1683: p_api_version => l_api_version,
1684: p_init_msg_list => OKC_API.G_FALSE,
1685: p_cond_occr_id => v_coev_tbl(i).id,
1686: p_condition_name => cnh_rec.name,
1687: p_task_owner_id => cnh_rec.task_owner_id,
1688: p_actual_end_date => v_coev_tbl(i).datetime,

Line 1694: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

1690: x_msg_count => l_msg_count,
1691: x_msg_data => l_msg_data,
1692: x_task_id => l_task_id);
1693:
1694: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1695: OKC_API.SET_MESSAGE(
1696: p_app_name => g_app_name
1697: ,p_msg_name => 'OKC_PROCESS_FAILED'
1698: ,p_token1 => 'SOURCE'

Line 1695: OKC_API.SET_MESSAGE(

1691: x_msg_data => l_msg_data,
1692: x_task_id => l_task_id);
1693:
1694: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1695: OKC_API.SET_MESSAGE(
1696: p_app_name => g_app_name
1697: ,p_msg_name => 'OKC_PROCESS_FAILED'
1698: ,p_token1 => 'SOURCE'
1699: ,p_token1_value => 'Condition Evaluator'

Line 1712: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1708: CLOSE cnh_cur;
1709: END LOOP;
1710: END IF;
1711: x_coev_tbl := v_coev_tbl;
1712: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1713:
1714: IF (l_debug = 'Y') THEN
1715: okc_debug.log('1000: Leaving ',2);
1716: okc_debug.Reset_Indentation;

Line 1721: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1717: END IF;
1718:
1719: EXCEPTION
1720: WHEN OTHERS THEN
1721: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1722:
1723: IF (l_debug = 'Y') THEN
1724: okc_debug.log('2000: Leaving ',2);
1725: okc_debug.Reset_Indentation;

Line 1793: p_init_msg_list => OKC_API.G_FALSE,

1789: END LOOP;
1790:
1791: OKC_CONDITIONS_PUB.create_act_att_vals(
1792: p_api_version => '1',
1793: p_init_msg_list => OKC_API.G_FALSE,
1794: x_return_status => l_return_status,
1795: x_msg_data => l_msg_data,
1796: x_msg_count => l_msg_count,
1797: p_aavv_tbl => l_aavv_tbl,

Line 1800: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

1796: x_msg_count => l_msg_count,
1797: p_aavv_tbl => l_aavv_tbl,
1798: x_aavv_tbl => v_aavv_tbl
1799: );
1800: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1801: OKC_API.SET_MESSAGE(
1802: p_app_name => g_app_name
1803: ,p_msg_name => 'OKC_PROCESS_FAILED'
1804: ,p_token1 => 'SOURCE'

Line 1801: OKC_API.SET_MESSAGE(

1797: p_aavv_tbl => l_aavv_tbl,
1798: x_aavv_tbl => v_aavv_tbl
1799: );
1800: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1801: OKC_API.SET_MESSAGE(
1802: p_app_name => g_app_name
1803: ,p_msg_name => 'OKC_PROCESS_FAILED'
1804: ,p_token1 => 'SOURCE'
1805: ,p_token1_value => 'Condition Evaluator'

Line 1811: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1807: ,p_token2_value => 'Create action att values'
1808: );
1809: RAISE OKC_PROCESS_FAILED;
1810: END IF;
1811: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1812:
1813: -- bug 1757364
1814: -- addded task creation to this procedure in order to retrieve document
1815: -- source number from the action attribute values.

Line 1817: IF NVL(l_return_status,'X') = OKC_API.G_RET_STS_SUCCESS AND p_coev_tab.count <> 0 THEN

1813: -- bug 1757364
1814: -- addded task creation to this procedure in order to retrieve document
1815: -- source number from the action attribute values.
1816: --
1817: IF NVL(l_return_status,'X') = OKC_API.G_RET_STS_SUCCESS AND p_coev_tab.count <> 0 THEN
1818: FOR i IN 1..p_coev_tab.COUNT LOOP
1819: IF cnh_cur%ISOPEN THEN
1820: CLOSE cnh_cur;
1821: END IF;

Line 1829: p_init_msg_list => OKC_API.G_FALSE,

1825: -- create tasks for true conditions with tracked_yn = 'Y'
1826: IF UPPER(cnh_rec.tracked_yn) = 'Y' THEN
1827: OKC_TASK_PUB.create_condition_task(
1828: p_api_version => l_api_version,
1829: p_init_msg_list => OKC_API.G_FALSE,
1830: p_cond_occr_id => p_coev_tab(i).id,
1831: p_condition_name => cnh_rec.name,
1832: p_task_owner_id => cnh_rec.task_owner_id,
1833: p_actual_end_date => p_coev_tab(i).datetime,

Line 1839: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

1835: x_msg_count => l_msg_count,
1836: x_msg_data => l_msg_data,
1837: x_task_id => l_task_id);
1838:
1839: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1840: OKC_API.SET_MESSAGE(
1841: p_app_name => g_app_name
1842: ,p_msg_name => 'OKC_PROCESS_FAILED'
1843: ,p_token1 => 'SOURCE'

Line 1840: OKC_API.SET_MESSAGE(

1836: x_msg_data => l_msg_data,
1837: x_task_id => l_task_id);
1838:
1839: IF NVL(l_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1840: OKC_API.SET_MESSAGE(
1841: p_app_name => g_app_name
1842: ,p_msg_name => 'OKC_PROCESS_FAILED'
1843: ,p_token1 => 'SOURCE'
1844: ,p_token1_value => 'Condition Evaluator'

Line 1863: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1859: END IF;
1860:
1861: EXCEPTION
1862: WHEN OTHERS THEN
1863: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1864:
1865: IF (l_debug = 'Y') THEN
1866: okc_debug.log('2000: Leaving ',2);
1867: okc_debug.Reset_Indentation;

Line 1903: l_return_status := OKC_API.START_ACTIVITY

1899: okc_debug.Set_Indentation(l_proc);
1900: okc_debug.log('10: Entering evaluate_plan_condition',2);
1901: END IF;
1902:
1903: l_return_status := OKC_API.START_ACTIVITY
1904: (l_api_name
1905: ,p_init_msg_list
1906: ,'_PVT'
1907: ,x_return_status);

Line 1909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

1905: ,p_init_msg_list
1906: ,'_PVT'
1907: ,x_return_status);
1908:
1909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1912: RAISE OKC_API.G_EXCEPTION_ERROR;
1913: END IF;

Line 1910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1906: ,'_PVT'
1907: ,x_return_status);
1908:
1909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1912: RAISE OKC_API.G_EXCEPTION_ERROR;
1913: END IF;
1914:

Line 1911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

1907: ,x_return_status);
1908:
1909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1912: RAISE OKC_API.G_EXCEPTION_ERROR;
1913: END IF;
1914:
1915: -- evaluate the condition lines for p_cnh_id

Line 1912: RAISE OKC_API.G_EXCEPTION_ERROR;

1908:
1909: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1910: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1911: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
1912: RAISE OKC_API.G_EXCEPTION_ERROR;
1913: END IF;
1914:
1915: -- evaluate the condition lines for p_cnh_id
1916: -- and return result as TRUE or FALSE

Line 1919: ,OKC_API.G_FALSE

1915: -- evaluate the condition lines for p_cnh_id
1916: -- and return result as TRUE or FALSE
1917: evaluate_condition_lines( p_cnh_id
1918: ,p_msg_tab
1919: ,OKC_API.G_FALSE
1920: ,x_return_status
1921: ,x_msg_count
1922: ,x_msg_data
1923: ,l_status

Line 1925: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

1921: ,x_msg_count
1922: ,x_msg_data
1923: ,l_status
1924: );
1925: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1926: OKC_API.SET_MESSAGE(
1927: p_app_name => g_app_name
1928: ,p_msg_name => 'OKC_PROCESS_FAILED'
1929: ,p_token1 => 'SOURCE'

Line 1926: OKC_API.SET_MESSAGE(

1922: ,x_msg_data
1923: ,l_status
1924: );
1925: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1926: OKC_API.SET_MESSAGE(
1927: p_app_name => g_app_name
1928: ,p_msg_name => 'OKC_PROCESS_FAILED'
1929: ,p_token1 => 'SOURCE'
1930: ,p_token1_value => 'Condition Evaluator'

Line 1947: ,OKC_API.G_FALSE

1943: END IF;
1944: -- for the condition get the table of outcomes
1945: build_outcome( l_cnh_tab
1946: ,p_msg_tab
1947: ,OKC_API.G_FALSE
1948: ,x_return_status
1949: ,x_msg_count
1950: ,x_msg_data
1951: ,x_sync_outcome_tab

Line 1956: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

1952: );
1953: IF (l_debug = 'Y') THEN
1954: okc_debug.log('10: after Build Outcome ',2);
1955: END IF;
1956: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1957: OKC_API.SET_MESSAGE(
1958: p_app_name => g_app_name
1959: ,p_msg_name => 'OKC_PROCESS_FAILED'
1960: ,p_token1 => 'SOURCE'

Line 1957: OKC_API.SET_MESSAGE(

1953: IF (l_debug = 'Y') THEN
1954: okc_debug.log('10: after Build Outcome ',2);
1955: END IF;
1956: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
1957: OKC_API.SET_MESSAGE(
1958: p_app_name => g_app_name
1959: ,p_msg_name => 'OKC_PROCESS_FAILED'
1960: ,p_token1 => 'SOURCE'
1961: ,p_token1_value => 'Condition Evaluator'

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

1965: raise OKC_PROCESS_FAILED;
1966: END IF;
1967: END IF;
1968:
1969: OKC_API.END_ACTIVITY( x_msg_count,x_msg_data);
1970:
1971: IF (l_debug = 'Y') THEN
1972: okc_debug.log('1000: Leaving evaluate_plan_condition ',2);
1973: okc_debug.Reset_Indentation;

Line 1985: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1981: END IF;
1982: IF x_sync_outcome_tab.count <> 0 THEN
1983: x_sync_outcome_tab.delete;
1984: END IF;
1985: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1986: ( l_api_name,
1987: G_PKG_NAME,
1988: 'OTHERS',
1989: x_msg_count,

Line 2054: l_return_status := OKC_API.START_ACTIVITY

2050: okc_debug.Set_Indentation(l_proc);
2051: okc_debug.log('10: Entering ',2);
2052: END IF;
2053:
2054: l_return_status := OKC_API.START_ACTIVITY
2055: (l_api_name
2056: ,p_init_msg_list
2057: ,'_PVT'
2058: ,x_return_status);

Line 2060: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

2056: ,p_init_msg_list
2057: ,'_PVT'
2058: ,x_return_status);
2059:
2060: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2062: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;

Line 2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2057: ,'_PVT'
2058: ,x_return_status);
2059:
2060: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2062: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065:

Line 2062: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

2058: ,x_return_status);
2059:
2060: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2062: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065:
2066: -- initializing and extending table type variables

Line 2063: RAISE OKC_API.G_EXCEPTION_ERROR;

2059:
2060: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2062: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065:
2066: -- initializing and extending table type variables
2067: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();

Line 2090: ,OKC_API.G_FALSE

2086: -- for each condition header check if there are lines, evaluate them
2087: -- and return result as TRUE or FALSE
2088: evaluate_condition_lines( cnh_rec.id
2089: ,p_msg_tab
2090: ,OKC_API.G_FALSE
2091: ,x_return_status
2092: ,x_msg_count
2093: ,x_msg_data
2094: ,l_status

Line 2096: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2092: ,x_msg_count
2093: ,x_msg_data
2094: ,l_status
2095: );
2096: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2097: OKC_API.SET_MESSAGE(
2098: p_app_name => g_app_name
2099: ,p_msg_name => 'OKC_PROCESS_FAILED'
2100: ,p_token1 => 'SOURCE'

Line 2097: OKC_API.SET_MESSAGE(

2093: ,x_msg_data
2094: ,l_status
2095: );
2096: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2097: OKC_API.SET_MESSAGE(
2098: p_app_name => g_app_name
2099: ,p_msg_name => 'OKC_PROCESS_FAILED'
2100: ,p_token1 => 'SOURCE'
2101: ,p_token1_value => 'Condition Evaluator'

Line 2123: ,OKC_API.G_FALSE

2119: -- for each condition get the table of outcomes
2120: IF l_cnh_tab.count <> 0 THEN
2121: build_outcome( l_cnh_tab
2122: ,p_msg_tab
2123: ,OKC_API.G_FALSE
2124: ,x_return_status
2125: ,x_msg_count
2126: ,x_msg_data
2127: ,x_sync_outcome_tab

Line 2129: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2125: ,x_msg_count
2126: ,x_msg_data
2127: ,x_sync_outcome_tab
2128: );
2129: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2130: OKC_API.SET_MESSAGE(
2131: p_app_name => g_app_name
2132: ,p_msg_name => 'OKC_PROCESS_FAILED'
2133: ,p_token1 => 'SOURCE'

Line 2130: OKC_API.SET_MESSAGE(

2126: ,x_msg_data
2127: ,x_sync_outcome_tab
2128: );
2129: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2130: OKC_API.SET_MESSAGE(
2131: p_app_name => g_app_name
2132: ,p_msg_name => 'OKC_PROCESS_FAILED'
2133: ,p_token1 => 'SOURCE'
2134: ,p_token1_value => 'Condition Evaluator'

Line 2150: ,OKC_API.G_FALSE

2146: END IF;
2147: -- create condition occurrence for true conditions
2148: create_condition_occurrence ( l_cnh_tab
2149: ,l_datetime
2150: ,OKC_API.G_FALSE
2151: ,x_return_status
2152: ,x_msg_count
2153: ,x_msg_data
2154: , x_coev_tbl

Line 2156: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2152: ,x_msg_count
2153: ,x_msg_data
2154: , x_coev_tbl
2155: );
2156: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2157: OKC_API.SET_MESSAGE(
2158: p_app_name => g_app_name
2159: ,p_msg_name => 'OKC_PROCESS_FAILED'
2160: ,p_token1 => 'SOURCE'

Line 2157: OKC_API.SET_MESSAGE(

2153: ,x_msg_data
2154: , x_coev_tbl
2155: );
2156: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2157: OKC_API.SET_MESSAGE(
2158: p_app_name => g_app_name
2159: ,p_msg_name => 'OKC_PROCESS_FAILED'
2160: ,p_token1 => 'SOURCE'
2161: ,p_token1_value => 'Condition Evaluator'

Line 2169: create_action_att_values ( OKC_API.G_FALSE

2165: raise OKC_PROCESS_FAILED;
2166: END IF;
2167: l_coev_tbl := x_coev_tbl;
2168: -- create action attribute values for each condition occurrence
2169: create_action_att_values ( OKC_API.G_FALSE
2170: ,x_return_status
2171: ,x_msg_count
2172: ,x_msg_data
2173: ,p_acn_id

Line 2178: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2174: ,l_coev_tbl
2175: ,p_msg_tab
2176: ,x_aavv_tbl
2177: );
2178: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2179: OKC_API.SET_MESSAGE(
2180: p_app_name => g_app_name
2181: ,p_msg_name => 'OKC_PROCESS_FAILED'
2182: ,p_token1 => 'SOURCE'

Line 2179: OKC_API.SET_MESSAGE(

2175: ,p_msg_tab
2176: ,x_aavv_tbl
2177: );
2178: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2179: OKC_API.SET_MESSAGE(
2180: p_app_name => g_app_name
2181: ,p_msg_name => 'OKC_PROCESS_FAILED'
2182: ,p_token1 => 'SOURCE'
2183: ,p_token1_value => 'Condition Evaluator'

Line 2191: OKC_API.END_ACTIVITY( x_msg_count,

2187: raise OKC_PROCESS_FAILED;
2188: END IF;
2189: END IF;
2190:
2191: OKC_API.END_ACTIVITY( x_msg_count,
2192: x_msg_data);
2193:
2194: IF (l_debug = 'Y') THEN
2195: okc_debug.log('1000: Leaving ',2);

Line 2205: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2201: WHEN OTHERS THEN
2202: IF x_sync_outcome_tab.count <> 0 THEN
2203: x_sync_outcome_tab.delete;
2204: END IF;
2205: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2206: ( l_api_name,
2207: G_PKG_NAME,
2208: 'OTHERS',
2209: x_msg_count,

Line 2283: l_return_status := OKC_API.START_ACTIVITY

2279: okc_debug.Set_Indentation(l_proc);
2280: okc_debug.log('10: Entering ',2);
2281: END IF;
2282:
2283: l_return_status := OKC_API.START_ACTIVITY
2284: (l_api_name
2285: ,p_init_msg_list
2286: ,'_PVT'
2287: ,x_return_status);

Line 2289: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

2285: ,p_init_msg_list
2286: ,'_PVT'
2287: ,x_return_status);
2288:
2289: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2292: RAISE OKC_API.G_EXCEPTION_ERROR;
2293: END IF;

Line 2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2286: ,'_PVT'
2287: ,x_return_status);
2288:
2289: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2292: RAISE OKC_API.G_EXCEPTION_ERROR;
2293: END IF;
2294:

Line 2291: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

2287: ,x_return_status);
2288:
2289: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2292: RAISE OKC_API.G_EXCEPTION_ERROR;
2293: END IF;
2294:
2295: --Added by suma

Line 2292: RAISE OKC_API.G_EXCEPTION_ERROR;

2288:
2289: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2291: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2292: RAISE OKC_API.G_EXCEPTION_ERROR;
2293: END IF;
2294:
2295: --Added by suma
2296: --get contract id

Line 2319: ,OKC_API.G_FALSE

2315: ELSE
2316: IF cnh_rec.jtot_object_code IS NOT NULL THEN
2317: evaluate_condition_lines(cnh_rec.id
2318: ,p_msg_tab
2319: ,OKC_API.G_FALSE
2320: ,x_return_status
2321: ,x_msg_count
2322: ,x_msg_data
2323: ,l_status);

Line 2325: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN

2321: ,x_msg_count
2322: ,x_msg_data
2323: ,l_status);
2324:
2325: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN
2326: OKC_API.SET_MESSAGE(
2327: p_app_name => g_app_name
2328: ,p_msg_name => 'OKC_PROCESS_FAILED'
2329: ,p_token1 => 'SOURCE'

Line 2326: OKC_API.SET_MESSAGE(

2322: ,x_msg_data
2323: ,l_status);
2324:
2325: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN
2326: OKC_API.SET_MESSAGE(
2327: p_app_name => g_app_name
2328: ,p_msg_name => 'OKC_PROCESS_FAILED'
2329: ,p_token1 => 'SOURCE'
2330: ,p_token1_value => 'Condition Evaluator'

Line 2344: ,OKC_API.G_FALSE

2340: -- and return result as TRUE or FALSE
2341: evaluate_condition_lines(
2342: cnh_rec.id
2343: ,p_msg_tab
2344: ,OKC_API.G_FALSE
2345: ,x_return_status
2346: ,x_msg_count
2347: ,x_msg_data
2348: ,l_status);

Line 2350: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN

2346: ,x_msg_count
2347: ,x_msg_data
2348: ,l_status);
2349:
2350: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN
2351: OKC_API.SET_MESSAGE(
2352: p_app_name => g_app_name
2353: ,p_msg_name => 'OKC_PROCESS_FAILED'
2354: ,p_token1 => 'SOURCE'

Line 2351: OKC_API.SET_MESSAGE(

2347: ,x_msg_data
2348: ,l_status);
2349:
2350: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN
2351: OKC_API.SET_MESSAGE(
2352: p_app_name => g_app_name
2353: ,p_msg_name => 'OKC_PROCESS_FAILED'
2354: ,p_token1 => 'SOURCE'
2355: ,p_token1_value => 'Condition Evaluator'

Line 2365: ,OKC_API.G_FALSE

2361: END IF; -- one_time_yn
2362: ELSIF cnh_rec.counter_action_yn = 'N' THEN
2363: evaluate_condition_lines( cnh_rec.id
2364: ,p_msg_tab
2365: ,OKC_API.G_FALSE
2366: ,x_return_status
2367: ,x_msg_count
2368: ,x_msg_data
2369: ,l_status

Line 2371: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN

2367: ,x_msg_count
2368: ,x_msg_data
2369: ,l_status
2370: );
2371: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN
2372: OKC_API.SET_MESSAGE(
2373: p_app_name => g_app_name
2374: ,p_msg_name => 'OKC_PROCESS_FAILED'
2375: ,p_token1 => 'SOURCE'

Line 2372: OKC_API.SET_MESSAGE(

2368: ,x_msg_data
2369: ,l_status
2370: );
2371: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN
2372: OKC_API.SET_MESSAGE(
2373: p_app_name => g_app_name
2374: ,p_msg_name => 'OKC_PROCESS_FAILED'
2375: ,p_token1 => 'SOURCE'
2376: ,p_token1_value => 'Condition Evaluator'

Line 2400: ,OKC_API.G_FALSE

2396:
2397: IF l_cnh_tab.count <> 0 THEN
2398: build_outcome( l_cnh_tab
2399: ,p_msg_tab
2400: ,OKC_API.G_FALSE
2401: ,x_return_status
2402: ,x_msg_count
2403: ,x_msg_data
2404: ,x_sync_outcome_tab

Line 2406: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2402: ,x_msg_count
2403: ,x_msg_data
2404: ,x_sync_outcome_tab
2405: );
2406: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2407: OKC_API.SET_MESSAGE(
2408: p_app_name => g_app_name
2409: ,p_msg_name => 'OKC_PROCESS_FAILED'
2410: ,p_token1 => 'SOURCE'

Line 2407: OKC_API.SET_MESSAGE(

2403: ,x_msg_data
2404: ,x_sync_outcome_tab
2405: );
2406: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2407: OKC_API.SET_MESSAGE(
2408: p_app_name => g_app_name
2409: ,p_msg_name => 'OKC_PROCESS_FAILED'
2410: ,p_token1 => 'SOURCE'
2411: ,p_token1_value => 'Condition Evaluator'

Line 2427: ,OKC_API.G_FALSE

2423: END IF;
2424: -- create condition occurrence for true conditions
2425: create_condition_occurrence ( l_cnh_tab
2426: ,l_datetime
2427: ,OKC_API.G_FALSE
2428: ,x_return_status
2429: ,x_msg_count
2430: ,x_msg_data
2431: , x_coev_tbl

Line 2433: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2429: ,x_msg_count
2430: ,x_msg_data
2431: , x_coev_tbl
2432: );
2433: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2434: OKC_API.SET_MESSAGE(
2435: p_app_name => g_app_name
2436: ,p_msg_name => 'OKC_PROCESS_FAILED'
2437: ,p_token1 => 'SOURCE'

Line 2434: OKC_API.SET_MESSAGE(

2430: ,x_msg_data
2431: , x_coev_tbl
2432: );
2433: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2434: OKC_API.SET_MESSAGE(
2435: p_app_name => g_app_name
2436: ,p_msg_name => 'OKC_PROCESS_FAILED'
2437: ,p_token1 => 'SOURCE'
2438: ,p_token1_value => 'Condition Evaluator'

Line 2446: create_action_att_values ( OKC_API.G_FALSE

2442: raise OKC_PROCESS_FAILED;
2443: END IF;
2444: l_coev_tbl := x_coev_tbl;
2445: -- create action attribute values for each condition occurrence
2446: create_action_att_values ( OKC_API.G_FALSE
2447: ,x_return_status
2448: ,x_msg_count
2449: ,x_msg_data
2450: ,p_acn_id

Line 2455: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2451: ,l_coev_tbl
2452: ,p_msg_tab
2453: ,x_aavv_tbl
2454: );
2455: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2456: OKC_API.SET_MESSAGE(
2457: p_app_name => g_app_name
2458: ,p_msg_name => 'OKC_PROCESS_FAILED'
2459: ,p_token1 => 'SOURCE'

Line 2456: OKC_API.SET_MESSAGE(

2452: ,p_msg_tab
2453: ,x_aavv_tbl
2454: );
2455: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2456: OKC_API.SET_MESSAGE(
2457: p_app_name => g_app_name
2458: ,p_msg_name => 'OKC_PROCESS_FAILED'
2459: ,p_token1 => 'SOURCE'
2460: ,p_token1_value => 'Condition Evaluator'

Line 2467: OKC_API.END_ACTIVITY( x_msg_count,

2463: );
2464: raise OKC_PROCESS_FAILED;
2465: END IF;
2466: END IF; -- l_cnh_tab.count
2467: OKC_API.END_ACTIVITY( x_msg_count,
2468: x_msg_data);
2469:
2470: IF (l_debug = 'Y') THEN
2471: okc_debug.log('1000: Leaving ',2);

Line 2478: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2474:
2475: EXCEPTION
2476:
2477: WHEN OTHERS THEN
2478: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2479: ( l_api_name,
2480: G_PKG_NAME,
2481: 'OTHERS',
2482: x_msg_count,

Line 2542: l_return_status := OKC_API.START_ACTIVITY

2538: okc_debug.Set_Indentation(l_proc);
2539: okc_debug.log('10: Entering ',2);
2540: END IF;
2541:
2542: l_return_status := OKC_API.START_ACTIVITY
2543: (l_api_name
2544: ,p_init_msg_list
2545: ,'_PVT'
2546: ,x_return_status);

Line 2548: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

2544: ,p_init_msg_list
2545: ,'_PVT'
2546: ,x_return_status);
2547:
2548: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2551: RAISE OKC_API.G_EXCEPTION_ERROR;
2552: END IF;

Line 2549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2545: ,'_PVT'
2546: ,x_return_status);
2547:
2548: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2551: RAISE OKC_API.G_EXCEPTION_ERROR;
2552: END IF;
2553:

Line 2550: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

2546: ,x_return_status);
2547:
2548: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2551: RAISE OKC_API.G_EXCEPTION_ERROR;
2552: END IF;
2553:
2554: -- initializing and extending table type variables

Line 2551: RAISE OKC_API.G_EXCEPTION_ERROR;

2547:
2548: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
2549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2550: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
2551: RAISE OKC_API.G_EXCEPTION_ERROR;
2552: END IF;
2553:
2554: -- initializing and extending table type variables
2555: l_cnh_tab := okc_condition_eval_pvt.id_tab_type();

Line 2565: ,OKC_API.G_FALSE

2561: FETCH cnh_cur INTO cnh_rec;
2562: IF cnh_cur%FOUND THEN
2563: evaluate_condition_lines( cnh_rec.id
2564: ,p_msg_tab
2565: ,OKC_API.G_FALSE
2566: ,x_return_status
2567: ,x_msg_count
2568: ,x_msg_data
2569: ,l_status

Line 2571: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN

2567: ,x_msg_count
2568: ,x_msg_data
2569: ,l_status
2570: );
2571: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN
2572: OKC_API.SET_MESSAGE(
2573: p_app_name => g_app_name
2574: ,p_msg_name => 'OKC_PROCESS_FAILED'
2575: ,p_token1 => 'SOURCE'

Line 2572: OKC_API.SET_MESSAGE(

2568: ,x_msg_data
2569: ,l_status
2570: );
2571: IF NVL(x_return_status,'X')<>OKC_API.G_RET_STS_SUCCESS THEN
2572: OKC_API.SET_MESSAGE(
2573: p_app_name => g_app_name
2574: ,p_msg_name => 'OKC_PROCESS_FAILED'
2575: ,p_token1 => 'SOURCE'
2576: ,p_token1_value => 'Condition Evaluator'

Line 2597: ,OKC_API.G_FALSE

2593: -- for each condition get the table of outcomes
2594: IF l_cnh_tab.count <> 0 THEN
2595: build_date_outcome( l_cnh_tab
2596: ,p_msg_tab
2597: ,OKC_API.G_FALSE
2598: ,x_return_status
2599: ,x_msg_count
2600: ,x_msg_data
2601: );

Line 2602: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2598: ,x_return_status
2599: ,x_msg_count
2600: ,x_msg_data
2601: );
2602: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2603: OKC_API.SET_MESSAGE(
2604: p_app_name => g_app_name
2605: ,p_msg_name => 'OKC_PROCESS_FAILED'
2606: ,p_token1 => 'SOURCE'

Line 2603: OKC_API.SET_MESSAGE(

2599: ,x_msg_count
2600: ,x_msg_data
2601: );
2602: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2603: OKC_API.SET_MESSAGE(
2604: p_app_name => g_app_name
2605: ,p_msg_name => 'OKC_PROCESS_FAILED'
2606: ,p_token1 => 'SOURCE'
2607: ,p_token1_value => 'Condition Evaluator'

Line 2623: ,OKC_API.G_FALSE

2619: END IF;
2620: -- create condition occurrence for true conditions
2621: create_condition_occurrence ( l_cnh_tab
2622: ,l_datetime
2623: ,OKC_API.G_FALSE
2624: ,x_return_status
2625: ,x_msg_count
2626: ,x_msg_data
2627: , x_coev_tbl

Line 2629: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2625: ,x_msg_count
2626: ,x_msg_data
2627: , x_coev_tbl
2628: );
2629: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2630: OKC_API.SET_MESSAGE(
2631: p_app_name => g_app_name
2632: ,p_msg_name => 'OKC_PROCESS_FAILED'
2633: ,p_token1 => 'SOURCE'

Line 2630: OKC_API.SET_MESSAGE(

2626: ,x_msg_data
2627: , x_coev_tbl
2628: );
2629: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2630: OKC_API.SET_MESSAGE(
2631: p_app_name => g_app_name
2632: ,p_msg_name => 'OKC_PROCESS_FAILED'
2633: ,p_token1 => 'SOURCE'
2634: ,p_token1_value => 'Condition Evaluator'

Line 2643: create_action_att_values ( OKC_API.G_FALSE

2639: END IF;
2640: l_coev_tbl := x_coev_tbl;
2641: CLOSE cnh_cur;
2642: -- create action attribute values for each condition occurrence
2643: create_action_att_values ( OKC_API.G_FALSE
2644: ,x_return_status
2645: ,x_msg_count
2646: ,x_msg_data
2647: ,cnh_rec.acn_id

Line 2652: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN

2648: ,l_coev_tbl
2649: ,p_msg_tab
2650: ,x_aavv_tbl
2651: );
2652: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2653: OKC_API.SET_MESSAGE(
2654: p_app_name => g_app_name
2655: ,p_msg_name => 'OKC_PROCESS_FAILED'
2656: ,p_token1 => 'SOURCE'

Line 2653: OKC_API.SET_MESSAGE(

2649: ,p_msg_tab
2650: ,x_aavv_tbl
2651: );
2652: IF NVL(x_return_status,'X') <> OKC_API.G_RET_STS_SUCCESS THEN
2653: OKC_API.SET_MESSAGE(
2654: p_app_name => g_app_name
2655: ,p_msg_name => 'OKC_PROCESS_FAILED'
2656: ,p_token1 => 'SOURCE'
2657: ,p_token1_value => 'Condition Evaluator'

Line 2664: OKC_API.END_ACTIVITY( x_msg_count,

2660: );
2661: raise OKC_PROCESS_FAILED;
2662: END IF;
2663: END IF;
2664: OKC_API.END_ACTIVITY( x_msg_count,
2665: x_msg_data);
2666:
2667: IF (l_debug = 'Y') THEN
2668: okc_debug.log('1000: Leaving ',2);

Line 2675: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2671:
2672: EXCEPTION
2673:
2674: WHEN OTHERS THEN
2675: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2676: ( l_api_name,
2677: G_PKG_NAME,
2678: 'OTHERS',
2679: x_msg_count,