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

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

131: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
132: G_MODULE || l_api_name,
133: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party because of EXCEPTION: ' || sqlerrm);
134: END IF;
135: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
136: p_msg_name => G_UNEXPECTED_ERROR,
137: p_token1 => G_SQLCODE_TOKEN,
138: p_token1_value => sqlcode,
139: p_token2 => G_SQLERRM_TOKEN,

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

264: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
265: G_MODULE || l_api_name,
266: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date because of EXCEPTION: ' || sqlerrm);
267: END IF;
268: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
269: p_msg_name => G_UNEXPECTED_ERROR,
270: p_token1 => G_SQLCODE_TOKEN,
271: p_token1_value => sqlcode,
272: p_token2 => G_SQLERRM_TOKEN,

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

428: END IF;
429: IF (contract_type_csr%ISOPEN) THEN
430: CLOSE contract_type_csr ;
431: END IF;
432: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
433: p_msg_name => G_UNEXPECTED_ERROR,
434: p_token1 => G_SQLCODE_TOKEN,
435: p_token1_value => sqlcode,
436: p_token2 => G_SQLERRM_TOKEN,

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

631: END IF;
632: IF (vendor_csr%ISOPEN) THEN
633: CLOSE vendor_csr ;
634: END IF;
635: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
636: p_msg_name => G_UNEXPECTED_ERROR,
637: p_token1 => G_SQLCODE_TOKEN,
638: p_token1_value => sqlcode,
639: p_token2 => G_SQLERRM_TOKEN,

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

926: END IF;
927: IF (employee_name_csr%ISOPEN) THEN
928: CLOSE employee_name_csr ;
929: END IF;
930: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
931: p_msg_name => G_UNEXPECTED_ERROR,
932: p_token1 => G_SQLCODE_TOKEN,
933: p_token1_value => sqlcode,
934: p_token2 => G_SQLERRM_TOKEN,

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

1093: END IF;
1094: IF (contact_role_csr%ISOPEN) THEN
1095: CLOSE contact_role_csr ;
1096: END IF;
1097: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1098: p_msg_name => G_UNEXPECTED_ERROR,
1099: p_token1 => G_SQLCODE_TOKEN,
1100: p_token1_value => sqlcode,
1101: p_token2 => G_SQLERRM_TOKEN,

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

1259: END IF;
1260: IF (risk_event_csr%ISOPEN) THEN
1261: CLOSE risk_event_csr ;
1262: END IF;
1263: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1264: p_msg_name => G_UNEXPECTED_ERROR,
1265: p_token1 => G_SQLCODE_TOKEN,
1266: p_token1_value => sqlcode,
1267: p_token2 => G_SQLERRM_TOKEN,

Line 1366: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

1362: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1363: 'Contract Id is: ' || p_contract_id);
1364: END IF;
1365: x_return_status := G_RET_STS_SUCCESS;
1366: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
1367: p_init_msg_list,
1368: '_PVT',
1369: x_return_status);
1370:

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

1367: p_init_msg_list,
1368: '_PVT',
1369: x_return_status);
1370:
1371: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1374: RAISE OKC_API.G_EXCEPTION_ERROR;
1375: END IF;

Line 1372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1368: '_PVT',
1369: x_return_status);
1370:
1371: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1374: RAISE OKC_API.G_EXCEPTION_ERROR;
1375: END IF;
1376:

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

1369: x_return_status);
1370:
1371: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1374: RAISE OKC_API.G_EXCEPTION_ERROR;
1375: END IF;
1376:
1377: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1374: RAISE OKC_API.G_EXCEPTION_ERROR;

1370:
1371: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1374: RAISE OKC_API.G_EXCEPTION_ERROR;
1375: END IF;
1376:
1377: -- Initialize message list if p_init_msg_list is set to TRUE.
1378: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

1397: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1398: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1399: 'Completed OKC_REP_QA_CHECK_PVT.check_no_exteral_party with returned status: ' || x_return_status);
1400: END IF;
1401: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;

Line 1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1398: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1399: 'Completed OKC_REP_QA_CHECK_PVT.check_no_exteral_party with returned status: ' || x_return_status);
1400: END IF;
1401: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406:

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

1399: 'Completed OKC_REP_QA_CHECK_PVT.check_no_exteral_party with returned status: ' || x_return_status);
1400: END IF;
1401: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406:
1407: -- Get effective_date column

Line 1404: RAISE OKC_API.G_EXCEPTION_ERROR;

1400: END IF;
1401: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406:
1407: -- Get effective_date column
1408: OPEN contract_csr;

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

1434: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1435: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1436: 'Completed OKC_REP_QA_CHECK_PVT.check_no_eff_date with returned status: ' || x_return_status);
1437: END IF;
1438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1440: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1441: RAISE OKC_API.G_EXCEPTION_ERROR;
1442: END IF;

Line 1439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1435: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1436: 'Completed OKC_REP_QA_CHECK_PVT.check_no_eff_date with returned status: ' || x_return_status);
1437: END IF;
1438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1440: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1441: RAISE OKC_API.G_EXCEPTION_ERROR;
1442: END IF;
1443:

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

1436: 'Completed OKC_REP_QA_CHECK_PVT.check_no_eff_date with returned status: ' || x_return_status);
1437: END IF;
1438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1440: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1441: RAISE OKC_API.G_EXCEPTION_ERROR;
1442: END IF;
1443:
1444: --Validate contract type

Line 1441: RAISE OKC_API.G_EXCEPTION_ERROR;

1437: END IF;
1438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1440: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1441: RAISE OKC_API.G_EXCEPTION_ERROR;
1442: END IF;
1443:
1444: --Validate contract type
1445: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1459: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1460: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1461: 'Completed OKC_REP_QA_CHECK_PVT.validate_contract_type with returned status: ' || x_return_status);
1462: END IF;
1463: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1465: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1466: RAISE OKC_API.G_EXCEPTION_ERROR;
1467: END IF;

Line 1464: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1460: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1461: 'Completed OKC_REP_QA_CHECK_PVT.validate_contract_type with returned status: ' || x_return_status);
1462: END IF;
1463: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1465: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1466: RAISE OKC_API.G_EXCEPTION_ERROR;
1467: END IF;
1468:

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

1461: 'Completed OKC_REP_QA_CHECK_PVT.validate_contract_type with returned status: ' || x_return_status);
1462: END IF;
1463: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1465: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1466: RAISE OKC_API.G_EXCEPTION_ERROR;
1467: END IF;
1468:
1469: -- Validate Parties

Line 1466: RAISE OKC_API.G_EXCEPTION_ERROR;

1462: END IF;
1463: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1464: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1465: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1466: RAISE OKC_API.G_EXCEPTION_ERROR;
1467: END IF;
1468:
1469: -- Validate Parties
1470: -- Loop through all the external parties and check if these are still valid.

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

1491: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1492: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1493: 'Completed OKC_REP_QA_CHECK_PVT.validate_external_party with returned status: ' || x_return_status);
1494: END IF;
1495: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1497: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1498: RAISE OKC_API.G_EXCEPTION_ERROR;
1499: END IF;

Line 1496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1492: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1493: 'Completed OKC_REP_QA_CHECK_PVT.validate_external_party with returned status: ' || x_return_status);
1494: END IF;
1495: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1497: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1498: RAISE OKC_API.G_EXCEPTION_ERROR;
1499: END IF;
1500: END LOOP;

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

1493: 'Completed OKC_REP_QA_CHECK_PVT.validate_external_party with returned status: ' || x_return_status);
1494: END IF;
1495: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1497: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1498: RAISE OKC_API.G_EXCEPTION_ERROR;
1499: END IF;
1500: END LOOP;
1501:

Line 1498: RAISE OKC_API.G_EXCEPTION_ERROR;

1494: END IF;
1495: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1496: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1497: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1498: RAISE OKC_API.G_EXCEPTION_ERROR;
1499: END IF;
1500: END LOOP;
1501:
1502: -- Validate contacts and contact roles

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

1528: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1530: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact with returned status: ' || x_return_status);
1531: END IF;
1532: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1534: ELSIF (x_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: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1530: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact with returned status: ' || x_return_status);
1531: END IF;
1532: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1534: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_ERROR;
1536: END IF;
1537:

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

1530: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact with returned status: ' || x_return_status);
1531: END IF;
1532: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1534: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_ERROR;
1536: END IF;
1537:
1538: -- Validate contact role

Line 1535: RAISE OKC_API.G_EXCEPTION_ERROR;

1531: END IF;
1532: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1533: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1534: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1535: RAISE OKC_API.G_EXCEPTION_ERROR;
1536: END IF;
1537:
1538: -- Validate contact role
1539: validate_contact_role (

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

1549: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1551: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact_role with returned status: ' || x_return_status);
1552: END IF;
1553: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;

Line 1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1550: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1551: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact_role with returned status: ' || x_return_status);
1552: END IF;
1553: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558: END LOOP;

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

1551: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact_role with returned status: ' || x_return_status);
1552: END IF;
1553: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558: END LOOP;
1559:

Line 1556: RAISE OKC_API.G_EXCEPTION_ERROR;

1552: END IF;
1553: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1556: RAISE OKC_API.G_EXCEPTION_ERROR;
1557: END IF;
1558: END LOOP;
1559:
1560:

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

1580: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1581: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1582: 'Completed OKC_REP_QA_CHECK_PVT.validate_risk_event with returned status: ' || x_return_status);
1583: END IF;
1584: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1586: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1587: RAISE OKC_API.G_EXCEPTION_ERROR;
1588: END IF;

Line 1585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1581: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1582: 'Completed OKC_REP_QA_CHECK_PVT.validate_risk_event with returned status: ' || x_return_status);
1583: END IF;
1584: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1586: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1587: RAISE OKC_API.G_EXCEPTION_ERROR;
1588: END IF;
1589: END LOOP;

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

1582: 'Completed OKC_REP_QA_CHECK_PVT.validate_risk_event with returned status: ' || x_return_status);
1583: END IF;
1584: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1586: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1587: RAISE OKC_API.G_EXCEPTION_ERROR;
1588: END IF;
1589: END LOOP;
1590:

Line 1587: RAISE OKC_API.G_EXCEPTION_ERROR;

1583: END IF;
1584: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1585: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1586: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1587: RAISE OKC_API.G_EXCEPTION_ERROR;
1588: END IF;
1589: END LOOP;
1590:
1591: -- Close all cursors.

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

1633: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1634: G_MODULE || l_api_name,
1635: 'Leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa because of EXCEPTION: ' || sqlerrm);
1636: END IF;
1637: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1638: p_msg_name => G_UNEXPECTED_ERROR,
1639: p_token1 => G_SQLCODE_TOKEN,
1640: p_token1_value => sqlcode,
1641: p_token2 => G_SQLERRM_TOKEN,

Line 1719: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

1715: 'Contract Id is: ' || p_contract_id);
1716: END IF;
1717: x_qa_return_status := G_QA_STS_SUCCESS;
1718: x_return_status := G_RET_STS_SUCCESS;
1719: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
1720: p_init_msg_list,
1721: '_PVT',
1722: x_return_status);
1723:

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

1720: p_init_msg_list,
1721: '_PVT',
1722: x_return_status);
1723:
1724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (x_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: '_PVT',
1722: x_return_status);
1723:
1724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;
1729:

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

1722: x_return_status);
1723:
1724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;
1729:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1727: RAISE OKC_API.G_EXCEPTION_ERROR;

1723:
1724: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1725: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1726: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_ERROR;
1728: END IF;
1729:
1730: -- Initialize message list if p_init_msg_list is set to TRUE.
1731: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

1740: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1741: G_MODULE||l_api_name,
1742: 'Invalid Contract Id: '|| p_contract_id);
1743: END IF;
1744: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1745: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
1746: p_token1 => G_CONTRACT_ID_TOKEN,
1747: p_token1_value => to_char(p_contract_id));
1748: RAISE FND_API.G_EXC_ERROR;

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

1779: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1780: 'Completed OKC_TERMS_QA_GRP.QA_Doc with returned status: ' || x_return_status);
1781: END IF;
1782:
1783: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1786: RAISE OKC_API.G_EXCEPTION_ERROR;
1787: END IF;

Line 1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1780: 'Completed OKC_TERMS_QA_GRP.QA_Doc with returned status: ' || x_return_status);
1781: END IF;
1782:
1783: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1786: RAISE OKC_API.G_EXCEPTION_ERROR;
1787: END IF;
1788: -- Repository Enhancement 12.1 Ends (For Validate Action)

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

1781: END IF;
1782:
1783: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1786: RAISE OKC_API.G_EXCEPTION_ERROR;
1787: END IF;
1788: -- Repository Enhancement 12.1 Ends (For Validate Action)
1789:

Line 1786: RAISE OKC_API.G_EXCEPTION_ERROR;

1782:
1783: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1785: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1786: RAISE OKC_API.G_EXCEPTION_ERROR;
1787: END IF;
1788: -- Repository Enhancement 12.1 Ends (For Validate Action)
1789:
1790: -- Make call for Repository QA check

Line 1809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1805: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1806: 'Completed OKC_REP_QA_CHECK_PVT.validate_repository_for_qa with returned status: ' || x_return_status);
1807: END IF;
1808: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1810: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1811: RAISE OKC_API.G_EXCEPTION_ERROR;
1812: END IF;
1813:

Line 1811: RAISE OKC_API.G_EXCEPTION_ERROR;

1807: END IF;
1808: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1809: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1810: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1811: RAISE OKC_API.G_EXCEPTION_ERROR;
1812: END IF;
1813:
1814: -- Make call for deliverables QA check
1815:

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

1839: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1841: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
1842: END IF;
1843: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1845: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1846: RAISE OKC_API.G_EXCEPTION_ERROR;
1847: END IF;

Line 1844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1840: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
1841: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
1842: END IF;
1843: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1845: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1846: RAISE OKC_API.G_EXCEPTION_ERROR;
1847: END IF;
1848:

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

1841: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
1842: END IF;
1843: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1845: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1846: RAISE OKC_API.G_EXCEPTION_ERROR;
1847: END IF;
1848:
1849: --------------------------------------------

Line 1846: RAISE OKC_API.G_EXCEPTION_ERROR;

1842: END IF;
1843: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1844: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1845: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1846: RAISE OKC_API.G_EXCEPTION_ERROR;
1847: END IF;
1848:
1849: --------------------------------------------
1850: -- VALIDATIONS are done for Repository and Deliverables.

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

1965: IF (contract_csr%ISOPEN) THEN
1966: CLOSE contract_csr ;
1967: END IF;
1968: x_return_status := G_RET_STS_UNEXP_ERROR;
1969: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1970: p_msg_name => G_UNEXPECTED_ERROR,
1971: p_token1 => G_SQLCODE_TOKEN,
1972: p_token1_value => sqlcode,
1973: p_token2 => G_SQLERRM_TOKEN,

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

2137: END IF;
2138:
2139: x_return_status := G_RET_STS_UNEXP_ERROR;
2140:
2141: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2142: p_msg_name => G_UNEXPECTED_ERROR,
2143: p_token1 => G_SQLCODE_TOKEN,
2144: p_token1_value => sqlcode,
2145: p_token2 => G_SQLERRM_TOKEN,