DBA Data[Home] [Help]

APPS.OKC_REP_WF_PVT dependencies on OKC_API

Line 1067: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1063: g_module || l_api_name,
1064: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1065: END IF;
1066: -------------------------------------------------------
1067: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1069: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1070: RAISE OKC_API.G_EXCEPTION_ERROR;
1071: END IF;

Line 1068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1064: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1065: END IF;
1066: -------------------------------------------------------
1067: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1069: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1070: RAISE OKC_API.G_EXCEPTION_ERROR;
1071: END IF;
1072: --------------------------------------------------------

Line 1069: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1065: END IF;
1066: -------------------------------------------------------
1067: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1069: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1070: RAISE OKC_API.G_EXCEPTION_ERROR;
1071: END IF;
1072: --------------------------------------------------------
1073: l_approver_record2.approval_status := ame_util.approvedStatus;

Line 1070: RAISE OKC_API.G_EXCEPTION_ERROR;

1066: -------------------------------------------------------
1067: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1068: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1069: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1070: RAISE OKC_API.G_EXCEPTION_ERROR;
1071: END IF;
1072: --------------------------------------------------------
1073: l_approver_record2.approval_status := ame_util.approvedStatus;
1074: ame_api2.updateApprovalStatus(

Line 1109: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1105: g_module || l_api_name,
1106: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1107: END IF;
1108: -------------------------------------------------------
1109: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: END IF;

Line 1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1106: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1107: END IF;
1108: -------------------------------------------------------
1109: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: END IF;
1114: --------------------------------------------------------

Line 1111: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1107: END IF;
1108: -------------------------------------------------------
1109: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: END IF;
1114: --------------------------------------------------------
1115:

Line 1112: RAISE OKC_API.G_EXCEPTION_ERROR;

1108: -------------------------------------------------------
1109: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1112: RAISE OKC_API.G_EXCEPTION_ERROR;
1113: END IF;
1114: --------------------------------------------------------
1115:
1116: l_approver_record2.approval_status := ame_util.rejectStatus;

Line 1183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1179: g_module || l_api_name,
1180: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1181: END IF;
1182: -------------------------------------------------------
1183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1186: RAISE OKC_API.G_EXCEPTION_ERROR;
1187: END IF;

Line 1184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1180: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1181: END IF;
1182: -------------------------------------------------------
1183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1186: RAISE OKC_API.G_EXCEPTION_ERROR;
1187: END IF;
1188: --------------------------------------------------------

Line 1185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1181: END IF;
1182: -------------------------------------------------------
1183: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1184: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1186: RAISE OKC_API.G_EXCEPTION_ERROR;
1187: END IF;
1188: --------------------------------------------------------
1189: l_approver_record2.approval_status := ame_util.noResponseStatus;

Line 1186: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1420: g_module || l_api_name,
1421: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1422: END IF;
1423: -------------------------------------------------------
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;

Line 1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1421: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1422: END IF;
1423: -------------------------------------------------------
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;
1429: --------------------------------------------------------

Line 1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1422: END IF;
1423: -------------------------------------------------------
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;
1429: --------------------------------------------------------
1430: l_approver_record2.approval_status := ame_util.approvedStatus;

Line 1427: RAISE OKC_API.G_EXCEPTION_ERROR;

1423: -------------------------------------------------------
1424: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1425: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1426: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1427: RAISE OKC_API.G_EXCEPTION_ERROR;
1428: END IF;
1429: --------------------------------------------------------
1430: l_approver_record2.approval_status := ame_util.approvedStatus;
1431: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1468: g_module || l_api_name,
1469: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1470: END IF;
1471: -------------------------------------------------------
1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;

Line 1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1469: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1470: END IF;
1471: -------------------------------------------------------
1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --------------------------------------------------------

Line 1474: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1470: END IF;
1471: -------------------------------------------------------
1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --------------------------------------------------------
1478:

Line 1475: RAISE OKC_API.G_EXCEPTION_ERROR;

1471: -------------------------------------------------------
1472: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1473: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1474: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1475: RAISE OKC_API.G_EXCEPTION_ERROR;
1476: END IF;
1477: --------------------------------------------------------
1478:
1479: l_approver_record2.approval_status := ame_util.rejectStatus;

Line 1530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1526: g_module || l_api_name,
1527: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1528: END IF;
1529: -------------------------------------------------------
1530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_ERROR;
1534: END IF;

Line 1531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1527: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1528: END IF;
1529: -------------------------------------------------------
1530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_ERROR;
1534: END IF;
1535: --------------------------------------------------------

Line 1532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1528: END IF;
1529: -------------------------------------------------------
1530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_ERROR;
1534: END IF;
1535: --------------------------------------------------------
1536:

Line 1533: RAISE OKC_API.G_EXCEPTION_ERROR;

1529: -------------------------------------------------------
1530: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1531: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1532: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_ERROR;
1534: END IF;
1535: --------------------------------------------------------
1536:
1537: --for forward action

Line 1574: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1570: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1571: END IF;
1572:
1573: -------------------------------------------------------
1574: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1575: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1576: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1577: RAISE OKC_API.G_EXCEPTION_ERROR;
1578: END IF;

Line 1575: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1571: END IF;
1572:
1573: -------------------------------------------------------
1574: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1575: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1576: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1577: RAISE OKC_API.G_EXCEPTION_ERROR;
1578: END IF;
1579: --------------------------------------------------------

Line 1576: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1572:
1573: -------------------------------------------------------
1574: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1575: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1576: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1577: RAISE OKC_API.G_EXCEPTION_ERROR;
1578: END IF;
1579: --------------------------------------------------------
1580:

Line 1577: RAISE OKC_API.G_EXCEPTION_ERROR;

1573: -------------------------------------------------------
1574: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1575: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1576: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1577: RAISE OKC_API.G_EXCEPTION_ERROR;
1578: END IF;
1579: --------------------------------------------------------
1580:
1581: -- l_approver_record2.approval_status := ame_util.forwardStatus;

Line 1654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1650: g_module || l_api_name,
1651: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1652: END IF;
1653: -------------------------------------------------------
1654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1656: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1657: RAISE OKC_API.G_EXCEPTION_ERROR;
1658: END IF;

Line 1655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1651: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1652: END IF;
1653: -------------------------------------------------------
1654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1656: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1657: RAISE OKC_API.G_EXCEPTION_ERROR;
1658: END IF;
1659: --------------------------------------------------------

Line 1656: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1652: END IF;
1653: -------------------------------------------------------
1654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1656: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1657: RAISE OKC_API.G_EXCEPTION_ERROR;
1658: END IF;
1659: --------------------------------------------------------
1660: l_approver_record2.approval_status := ame_util.noResponseStatus;

Line 1657: RAISE OKC_API.G_EXCEPTION_ERROR;

1653: -------------------------------------------------------
1654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1656: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1657: RAISE OKC_API.G_EXCEPTION_ERROR;
1658: END IF;
1659: --------------------------------------------------------
1660: l_approver_record2.approval_status := ame_util.noResponseStatus;
1661:

Line 1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1720: 'Completed OKC_REP_UTIL_PVT.add_approval_hist_record with return status: ' || l_return_status);
1721: END IF;
1722:
1723: -------------------------------------------------------
1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;

Line 1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1721: END IF;
1722:
1723: -------------------------------------------------------
1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;
1729: --------------------------------------------------------

Line 1726: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

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

Line 1727: RAISE OKC_API.G_EXCEPTION_ERROR;

1723: -------------------------------------------------------
1724: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;
1729: --------------------------------------------------------
1730:
1731: -- l_approver_record2.approval_status := ame_util.forwardStatus;

Line 1891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1887: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1888: END IF;
1889:
1890: -----------------------------------------------------
1891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;

Line 1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1888: END IF;
1889:
1890: -----------------------------------------------------
1891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;
1896: --------------------------------------------------------

Line 1893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1889:
1890: -----------------------------------------------------
1891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;
1896: --------------------------------------------------------
1897:

Line 1894: RAISE OKC_API.G_EXCEPTION_ERROR;

1890: -----------------------------------------------------
1891: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1892: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1893: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1894: RAISE OKC_API.G_EXCEPTION_ERROR;
1895: END IF;
1896: --------------------------------------------------------
1897:
1898:

Line 1926: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1922: 'OKC_DELIVERABLE_PROCESS_PVT.version_deliverables return status is : '
1923: || l_return_status);
1924: END IF;
1925: -----------------------------------------------------
1926: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1929: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: END IF;

Line 1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1923: || l_return_status);
1924: END IF;
1925: -----------------------------------------------------
1926: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1929: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: --------------------------------------------------------

Line 1928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1924: END IF;
1925: -----------------------------------------------------
1926: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1929: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: --------------------------------------------------------
1932:

Line 1929: RAISE OKC_API.G_EXCEPTION_ERROR;

1925: -----------------------------------------------------
1926: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1927: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1928: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1929: RAISE OKC_API.G_EXCEPTION_ERROR;
1930: END IF;
1931: --------------------------------------------------------
1932:
1933: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1978: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1974: 'OKC_DELIVERABLE_PROCESS_PVT.activateDeliverables return status is : '
1975: || l_return_status);
1976: END IF;
1977: -----------------------------------------------------
1978: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1980: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1981: RAISE OKC_API.G_EXCEPTION_ERROR;
1982: END IF;

Line 1979: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1975: || l_return_status);
1976: END IF;
1977: -----------------------------------------------------
1978: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1980: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1981: RAISE OKC_API.G_EXCEPTION_ERROR;
1982: END IF;
1983: --------------------------------------------------------

Line 1980: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1976: END IF;
1977: -----------------------------------------------------
1978: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1980: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1981: RAISE OKC_API.G_EXCEPTION_ERROR;
1982: END IF;
1983: --------------------------------------------------------
1984:

Line 1981: RAISE OKC_API.G_EXCEPTION_ERROR;

1977: -----------------------------------------------------
1978: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1979: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1980: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1981: RAISE OKC_API.G_EXCEPTION_ERROR;
1982: END IF;
1983: --------------------------------------------------------
1984:
1985: -- Checking if we need to call deliverable's APIs for synch-ing

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

1993: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1994: G_MODULE||l_api_name,
1995: 'Invalid Contract Id: '|| l_contract_id);
1996: END IF;
1997: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1998: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
1999: p_token1 => G_CONTRACT_ID_TOKEN,
2000: p_token1_value => to_char(l_contract_id));
2001: RAISE FND_API.G_EXC_ERROR;

Line 2054: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2050: 'OKC_DELIVERABLE_PROCESS_PVT.updateDeliverables return status is : '
2051: || l_return_status);
2052: END IF;
2053: -----------------------------------------------------
2054: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_ERROR;
2058: END IF;

Line 2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2051: || l_return_status);
2052: END IF;
2053: -----------------------------------------------------
2054: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: --------------------------------------------------------

Line 2056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2052: END IF;
2053: -----------------------------------------------------
2054: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: --------------------------------------------------------
2060: END IF; -- expiration date comparision

Line 2057: RAISE OKC_API.G_EXCEPTION_ERROR;

2053: -----------------------------------------------------
2054: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: --------------------------------------------------------
2060: END IF; -- expiration date comparision
2061: -- Disable prev. version deliverables

Line 2083: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2079: 'OKC_DELIVERABLE_PROCESS_PVT.disableDeliverables return status is : '
2080: || l_return_status);
2081: END IF;
2082: -----------------------------------------------------
2083: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;

Line 2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2080: || l_return_status);
2081: END IF;
2082: -----------------------------------------------------
2083: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;
2088: --------------------------------------------------------

Line 2085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2081: END IF;
2082: -----------------------------------------------------
2083: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;
2088: --------------------------------------------------------
2089: END IF; -- (l_sync_flag = 'Y')

Line 2086: RAISE OKC_API.G_EXCEPTION_ERROR;

2082: -----------------------------------------------------
2083: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2085: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2086: RAISE OKC_API.G_EXCEPTION_ERROR;
2087: END IF;
2088: --------------------------------------------------------
2089: END IF; -- (l_sync_flag = 'Y')
2090: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2216: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2212: g_module || l_api_name,
2213: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
2214: END IF;
2215: -----------------------------------------------------
2216: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2219: RAISE OKC_API.G_EXCEPTION_ERROR;
2220: END IF;

Line 2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2213: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
2214: END IF;
2215: -----------------------------------------------------
2216: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2219: RAISE OKC_API.G_EXCEPTION_ERROR;
2220: END IF;
2221: --------------------------------------------------------

Line 2218: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2214: END IF;
2215: -----------------------------------------------------
2216: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2219: RAISE OKC_API.G_EXCEPTION_ERROR;
2220: END IF;
2221: --------------------------------------------------------
2222:

Line 2219: RAISE OKC_API.G_EXCEPTION_ERROR;

2215: -----------------------------------------------------
2216: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2219: RAISE OKC_API.G_EXCEPTION_ERROR;
2220: END IF;
2221: --------------------------------------------------------
2222:
2223: resultout := 'COMPLETE:';