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

Line 160: l_resolved_token := OKC_API.resolve_hdr_token(contract_rec.contract_type);

156: aname => 'CONTRACT_TYPE',
157: avalue => contract_rec.contract_type);
158:
159:
160: l_resolved_token := OKC_API.resolve_hdr_token(contract_rec.contract_type);
161:
162: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
163: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
164: 'Calling WF_ENGINE.setitemattrtext for CONTRACT_HDR_TOKEN ' || l_resolved_token);

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

1113: 'Completed OKC_REP_UTIL_PVT.add_signature_hist_record with return status: ' || l_return_status);
1114: END IF;
1115:
1116: -------------------------------------------------------
1117: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1120: RAISE OKC_API.G_EXCEPTION_ERROR;
1121: END IF;

Line 1118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1114: END IF;
1115:
1116: -------------------------------------------------------
1117: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1120: RAISE OKC_API.G_EXCEPTION_ERROR;
1121: END IF;
1122: --------------------------------------------------------

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

1115:
1116: -------------------------------------------------------
1117: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1120: RAISE OKC_API.G_EXCEPTION_ERROR;
1121: END IF;
1122: --------------------------------------------------------
1123:

Line 1120: RAISE OKC_API.G_EXCEPTION_ERROR;

1116: -------------------------------------------------------
1117: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1118: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1120: RAISE OKC_API.G_EXCEPTION_ERROR;
1121: END IF;
1122: --------------------------------------------------------
1123:
1124:

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

1153: g_module || l_api_name,
1154: 'Completed OKC_REP_UTIL_PVT.add_signature_hist_record with return status: ' || l_return_status);
1155: END IF;
1156: -------------------------------------------------------
1157: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1160: RAISE OKC_API.G_EXCEPTION_ERROR;
1161: END IF;

Line 1158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1154: 'Completed OKC_REP_UTIL_PVT.add_signature_hist_record with return status: ' || l_return_status);
1155: END IF;
1156: -------------------------------------------------------
1157: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1160: RAISE OKC_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: --------------------------------------------------------

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

1155: END IF;
1156: -------------------------------------------------------
1157: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1160: RAISE OKC_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: --------------------------------------------------------
1163: END IF;

Line 1160: RAISE OKC_API.G_EXCEPTION_ERROR;

1156: -------------------------------------------------------
1157: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1158: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1159: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1160: RAISE OKC_API.G_EXCEPTION_ERROR;
1161: END IF;
1162: --------------------------------------------------------
1163: END IF;
1164:

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

1289: g_module || l_api_name,
1290: 'Completed OKC_REP_UTIL_PVT.add_signature_hist_record with return status: ' || l_return_status);
1291: END IF;
1292: -------------------------------------------------------
1293: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1294: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1295: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1296: RAISE OKC_API.G_EXCEPTION_ERROR;
1297: END IF;

Line 1294: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1290: 'Completed OKC_REP_UTIL_PVT.add_signature_hist_record with return status: ' || l_return_status);
1291: END IF;
1292: -------------------------------------------------------
1293: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1294: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1295: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1296: RAISE OKC_API.G_EXCEPTION_ERROR;
1297: END IF;
1298: --------------------------------------------------------

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

1291: END IF;
1292: -------------------------------------------------------
1293: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1294: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1295: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1296: RAISE OKC_API.G_EXCEPTION_ERROR;
1297: END IF;
1298: --------------------------------------------------------
1299:

Line 1296: RAISE OKC_API.G_EXCEPTION_ERROR;

1292: -------------------------------------------------------
1293: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1294: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1295: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1296: RAISE OKC_API.G_EXCEPTION_ERROR;
1297: END IF;
1298: --------------------------------------------------------
1299:
1300: -- resultout := 'COMPLETE:';

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

1444: g_module || l_api_name,
1445: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1446: END IF;
1447: -----------------------------------------------------
1448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1451: RAISE OKC_API.G_EXCEPTION_ERROR;
1452: END IF;

Line 1449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1445: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1446: END IF;
1447: -----------------------------------------------------
1448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1451: RAISE OKC_API.G_EXCEPTION_ERROR;
1452: END IF;
1453: --------------------------------------------------------

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

1446: END IF;
1447: -----------------------------------------------------
1448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1451: RAISE OKC_API.G_EXCEPTION_ERROR;
1452: END IF;
1453: --------------------------------------------------------
1454:

Line 1451: RAISE OKC_API.G_EXCEPTION_ERROR;

1447: -----------------------------------------------------
1448: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1449: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1451: RAISE OKC_API.G_EXCEPTION_ERROR;
1452: END IF;
1453: --------------------------------------------------------
1454:
1455: -- Get effective dates and version of the contract.

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

1476: 'OKC_DELIVERABLE_PROCESS_PVT.version_deliverables return status is : '
1477: || l_return_status);
1478: END IF;
1479: -----------------------------------------------------
1480: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1482: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1483: RAISE OKC_API.G_EXCEPTION_ERROR;
1484: END IF;

Line 1481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1477: || l_return_status);
1478: END IF;
1479: -----------------------------------------------------
1480: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1482: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1483: RAISE OKC_API.G_EXCEPTION_ERROR;
1484: END IF;
1485: --------------------------------------------------------

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

1478: END IF;
1479: -----------------------------------------------------
1480: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1482: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1483: RAISE OKC_API.G_EXCEPTION_ERROR;
1484: END IF;
1485: --------------------------------------------------------
1486:

Line 1483: RAISE OKC_API.G_EXCEPTION_ERROR;

1479: -----------------------------------------------------
1480: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1481: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1482: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1483: RAISE OKC_API.G_EXCEPTION_ERROR;
1484: END IF;
1485: --------------------------------------------------------
1486:
1487: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1528: 'OKC_DELIVERABLE_PROCESS_PVT.activateDeliverables return status is : '
1529: || l_return_status);
1530: END IF;
1531: -----------------------------------------------------
1532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_ERROR;
1536: END IF;

Line 1533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 1535: RAISE OKC_API.G_EXCEPTION_ERROR;

1531: -----------------------------------------------------
1532: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1534: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_ERROR;
1536: END IF;
1537: --------------------------------------------------------
1538:
1539: -- Checking if we need to call deliverable's APIs for synch-ing

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

1547: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1548: G_MODULE||l_api_name,
1549: 'Invalid Contract Id: '|| l_contract_id);
1550: END IF;
1551: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1552: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
1553: p_token1 => G_CONTRACT_ID_TOKEN,
1554: p_token1_value => to_char(l_contract_id));
1555: RAISE FND_API.G_EXC_ERROR;

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

1604: 'OKC_DELIVERABLE_PROCESS_PVT.updateDeliverables return status is : '
1605: || l_return_status);
1606: END IF;
1607: -----------------------------------------------------
1608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1610: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1611: RAISE OKC_API.G_EXCEPTION_ERROR;
1612: END IF;

Line 1609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1605: || l_return_status);
1606: END IF;
1607: -----------------------------------------------------
1608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1610: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1611: RAISE OKC_API.G_EXCEPTION_ERROR;
1612: END IF;
1613: --------------------------------------------------------

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

1606: END IF;
1607: -----------------------------------------------------
1608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1610: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1611: RAISE OKC_API.G_EXCEPTION_ERROR;
1612: END IF;
1613: --------------------------------------------------------
1614: END IF; -- expiration date comparision

Line 1611: RAISE OKC_API.G_EXCEPTION_ERROR;

1607: -----------------------------------------------------
1608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1609: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1610: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1611: RAISE OKC_API.G_EXCEPTION_ERROR;
1612: END IF;
1613: --------------------------------------------------------
1614: END IF; -- expiration date comparision
1615: -- Disable prev. version deliverables

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

1633: 'OKC_DELIVERABLE_PROCESS_PVT.disableDeliverables return status is : '
1634: || l_return_status);
1635: END IF;
1636: -----------------------------------------------------
1637: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1640: RAISE OKC_API.G_EXCEPTION_ERROR;
1641: END IF;

Line 1638: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1634: || l_return_status);
1635: END IF;
1636: -----------------------------------------------------
1637: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1640: RAISE OKC_API.G_EXCEPTION_ERROR;
1641: END IF;
1642: --------------------------------------------------------

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

1635: END IF;
1636: -----------------------------------------------------
1637: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1640: RAISE OKC_API.G_EXCEPTION_ERROR;
1641: END IF;
1642: --------------------------------------------------------
1643: END IF; -- (l_sync_flag = 'Y')

Line 1640: RAISE OKC_API.G_EXCEPTION_ERROR;

1636: -----------------------------------------------------
1637: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1640: RAISE OKC_API.G_EXCEPTION_ERROR;
1641: END IF;
1642: --------------------------------------------------------
1643: END IF; -- (l_sync_flag = 'Y')
1644: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1763: g_module || l_api_name,
1764: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1765: END IF;
1766: -----------------------------------------------------
1767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1770: RAISE OKC_API.G_EXCEPTION_ERROR;
1771: END IF;

Line 1768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1764: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || l_return_status);
1765: END IF;
1766: -----------------------------------------------------
1767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1770: RAISE OKC_API.G_EXCEPTION_ERROR;
1771: END IF;
1772: --------------------------------------------------------

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

1765: END IF;
1766: -----------------------------------------------------
1767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1770: RAISE OKC_API.G_EXCEPTION_ERROR;
1771: END IF;
1772: --------------------------------------------------------
1773:

Line 1770: RAISE OKC_API.G_EXCEPTION_ERROR;

1766: -----------------------------------------------------
1767: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1768: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1769: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1770: RAISE OKC_API.G_EXCEPTION_ERROR;
1771: END IF;
1772: --------------------------------------------------------
1773:
1774: resultout := 'COMPLETE:';