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

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

141: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
142: g_module || l_api_name,
143: 'Leaving delete_contract_usages because of EXCEPTION: ' || sqlerrm);
144: END IF;
145: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
146: p_msg_name => G_UNEXPECTED_ERROR,
147: p_token1 => G_SQLCODE_TOKEN,
148: p_token1_value => sqlcode,
149: p_token2 => G_SQLERRM_TOKEN,

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

682: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
683: g_module || l_api_name,
684: 'Leaving delete_contract because of EXCEPTION: ' || sqlerrm);
685: END IF;
686: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
687: p_msg_name => G_UNEXPECTED_ERROR,
688: p_token1 => G_SQLCODE_TOKEN,
689: p_token1_value => sqlcode,
690: p_token2 => G_SQLERRM_TOKEN,

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

1386: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1387: g_module || l_api_name,
1388: 'Leaving delete_contract because of EXCEPTION: ' || sqlerrm);
1389: END IF;
1390: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1391: p_msg_name => G_UNEXPECTED_ERROR,
1392: p_token1 => G_SQLCODE_TOKEN,
1393: p_token1_value => sqlcode,
1394: p_token2 => G_SQLERRM_TOKEN,

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

1409: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1410: g_module || l_api_name,
1411: 'Leaving delete_contract because of EXCEPTION: ' || sqlerrm);
1412: END IF;
1413: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1414: p_msg_name => G_UNEXPECTED_ERROR,
1415: p_token1 => G_SQLCODE_TOKEN,
1416: p_token1_value => sqlcode,
1417: p_token2 => G_SQLERRM_TOKEN,

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

1431: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1432: g_module || l_api_name,
1433: 'Leaving delete_contract because of EXCEPTION: ' || sqlerrm);
1434: END IF;
1435: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1436: p_msg_name => G_UNEXPECTED_ERROR,
1437: p_token1 => G_SQLCODE_TOKEN,
1438: p_token1_value => sqlcode,
1439: p_token2 => G_SQLERRM_TOKEN,

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

1610: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
1611: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
1612: END IF;
1613:
1614: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1615: p_msg_name => G_UNEXPECTED_ERROR,
1616: p_token1 => G_SQLCODE_TOKEN,
1617: p_token1_value => sqlcode,
1618: p_token2 => G_SQLERRM_TOKEN,

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

1759: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1760: g_module || l_api_name,
1761: 'Leaving create_new_contract_version because of EXCEPTION: ' || sqlerrm);
1762: END IF;
1763: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1764: p_msg_name => G_UNEXPECTED_ERROR,
1765: p_token1 => G_SQLCODE_TOKEN,
1766: p_token1_value => sqlcode,
1767: p_token2 => G_SQLERRM_TOKEN,

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

1913: G_MODULE||l_api_name,
1914: 'Invalid Business Document Id: '|| p_document_rec.business_document_id);
1915:
1916: END IF;
1917: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1918: p_msg_name => G_INVALID_BUS_DOC_ID_MSG,
1919: p_token1 => 'BUS_DOC_ID',
1920: p_token1_value => to_char(p_document_rec.business_document_id));
1921: RAISE FND_API.G_EXC_ERROR;

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

1930: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1931: G_MODULE||l_api_name,
1932: 'Invalid Contract Id: '|| l_contract_id);
1933: END IF;
1934: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1935: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
1936: p_token1 => 'CONTRACT_ID',
1937: p_token1_value => to_char(l_contract_id));
1938: RAISE FND_API.G_EXC_ERROR;

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

1957: || x_return_status);
1958: END IF;
1959:
1960: -----------------------------------------------------
1961: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1962: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1963: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1964: RAISE OKC_API.G_EXCEPTION_ERROR;
1965: END IF;

Line 1962: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1958: END IF;
1959:
1960: -----------------------------------------------------
1961: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1962: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1963: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1964: RAISE OKC_API.G_EXCEPTION_ERROR;
1965: END IF;
1966: -----------------------------------------------------

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

1959:
1960: -----------------------------------------------------
1961: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1962: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1963: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1964: RAISE OKC_API.G_EXCEPTION_ERROR;
1965: END IF;
1966: -----------------------------------------------------
1967:

Line 1964: RAISE OKC_API.G_EXCEPTION_ERROR;

1960: -----------------------------------------------------
1961: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1962: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1963: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1964: RAISE OKC_API.G_EXCEPTION_ERROR;
1965: END IF;
1966: -----------------------------------------------------
1967:
1968: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1986: g_module || l_api_name,
1987: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
1988: END IF;
1989: -----------------------------------------------------
1990: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1993: RAISE OKC_API.G_EXCEPTION_ERROR;
1994: END IF;

Line 1991: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1987: 'Completed OKC_REP_UTIL_PVT.change_contract_status with return status: ' || x_return_status);
1988: END IF;
1989: -----------------------------------------------------
1990: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1993: RAISE OKC_API.G_EXCEPTION_ERROR;
1994: END IF;
1995: ------------------------------------------------------

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

1988: END IF;
1989: -----------------------------------------------------
1990: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1993: RAISE OKC_API.G_EXCEPTION_ERROR;
1994: END IF;
1995: ------------------------------------------------------
1996:

Line 1993: RAISE OKC_API.G_EXCEPTION_ERROR;

1989: -----------------------------------------------------
1990: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1993: RAISE OKC_API.G_EXCEPTION_ERROR;
1994: END IF;
1995: ------------------------------------------------------
1996:
1997: -- We need to first version the deliverables

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

2015: 'OKC_DELIVERABLE_PROCESS_PVT.version_deliverables return status is : '
2016: || x_return_status);
2017: END IF;
2018: -----------------------------------------------------
2019: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2021: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2022: RAISE OKC_API.G_EXCEPTION_ERROR;
2023: END IF;

Line 2020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2016: || x_return_status);
2017: END IF;
2018: -----------------------------------------------------
2019: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2021: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2022: RAISE OKC_API.G_EXCEPTION_ERROR;
2023: END IF;
2024: --------------------------------------------------------

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

2017: END IF;
2018: -----------------------------------------------------
2019: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2021: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2022: RAISE OKC_API.G_EXCEPTION_ERROR;
2023: END IF;
2024: --------------------------------------------------------
2025:

Line 2022: RAISE OKC_API.G_EXCEPTION_ERROR;

2018: -----------------------------------------------------
2019: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2021: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2022: RAISE OKC_API.G_EXCEPTION_ERROR;
2023: END IF;
2024: --------------------------------------------------------
2025:
2026: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2068: 'OKC_DELIVERABLE_PROCESS_PVT.activateDeliverables return status is : '
2069: || x_return_status);
2070: END IF;
2071: -----------------------------------------------------
2072: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2074: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2075: RAISE OKC_API.G_EXCEPTION_ERROR;
2076: END IF;

Line 2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2069: || x_return_status);
2070: END IF;
2071: -----------------------------------------------------
2072: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2074: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2075: RAISE OKC_API.G_EXCEPTION_ERROR;
2076: END IF;
2077: --------------------------------------------------------

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

2070: END IF;
2071: -----------------------------------------------------
2072: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2074: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2075: RAISE OKC_API.G_EXCEPTION_ERROR;
2076: END IF;
2077: --------------------------------------------------------
2078:

Line 2075: RAISE OKC_API.G_EXCEPTION_ERROR;

2071: -----------------------------------------------------
2072: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2073: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2074: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2075: RAISE OKC_API.G_EXCEPTION_ERROR;
2076: END IF;
2077: --------------------------------------------------------
2078:
2079: -- Checking if we need to call deliverable's APIs for synch-ing

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

2110: 'OKC_DELIVERABLE_PROCESS_PVT.updateDeliverables return status is : '
2111: || x_return_status);
2112: END IF;
2113: -----------------------------------------------------
2114: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2116: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2117: RAISE OKC_API.G_EXCEPTION_ERROR;
2118: END IF;

Line 2115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2111: || x_return_status);
2112: END IF;
2113: -----------------------------------------------------
2114: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2116: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2117: RAISE OKC_API.G_EXCEPTION_ERROR;
2118: END IF;
2119: --------------------------------------------------------

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

2112: END IF;
2113: -----------------------------------------------------
2114: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2116: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2117: RAISE OKC_API.G_EXCEPTION_ERROR;
2118: END IF;
2119: --------------------------------------------------------
2120: END IF; -- expiration date comparision

Line 2117: RAISE OKC_API.G_EXCEPTION_ERROR;

2113: -----------------------------------------------------
2114: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2115: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2116: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2117: RAISE OKC_API.G_EXCEPTION_ERROR;
2118: END IF;
2119: --------------------------------------------------------
2120: END IF; -- expiration date comparision
2121:

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

2140: 'OKC_DELIVERABLE_PROCESS_PVT.disableDeliverables return status is : '
2141: || x_return_status);
2142: END IF;
2143: -----------------------------------------------------
2144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2147: RAISE OKC_API.G_EXCEPTION_ERROR;
2148: END IF;

Line 2145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2141: || x_return_status);
2142: END IF;
2143: -----------------------------------------------------
2144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2147: RAISE OKC_API.G_EXCEPTION_ERROR;
2148: END IF;
2149: --------------------------------------------------------

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

2142: END IF;
2143: -----------------------------------------------------
2144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2147: RAISE OKC_API.G_EXCEPTION_ERROR;
2148: END IF;
2149: --------------------------------------------------------
2150: --END IF; -- (l_sync_flag = 'Y')

Line 2147: RAISE OKC_API.G_EXCEPTION_ERROR;

2143: -----------------------------------------------------
2144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2147: RAISE OKC_API.G_EXCEPTION_ERROR;
2148: END IF;
2149: --------------------------------------------------------
2150: --END IF; -- (l_sync_flag = 'Y')
2151:

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

2219: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2220: g_module || l_api_name,
2221: 'Leaving sign_contract because of EXCEPTION: ' || sqlerrm);
2222: END IF;
2223: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2224: p_msg_name => G_UNEXPECTED_ERROR,
2225: p_token1 => G_SQLCODE_TOKEN,
2226: p_token1_value => sqlcode,
2227: p_token2 => G_SQLERRM_TOKEN,

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

2424: 'OKC_REP_CONTRACT_IMP_PVT.delete_contract return status is : '
2425: || x_return_status);
2426: END IF;
2427: -----------------------------------------------------
2428: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2431: RAISE OKC_API.G_EXCEPTION_ERROR;
2432: END IF;

Line 2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2425: || x_return_status);
2426: END IF;
2427: -----------------------------------------------------
2428: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2431: RAISE OKC_API.G_EXCEPTION_ERROR;
2432: END IF;
2433: --------------------------------------------------------

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

2426: END IF;
2427: -----------------------------------------------------
2428: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2431: RAISE OKC_API.G_EXCEPTION_ERROR;
2432: END IF;
2433: --------------------------------------------------------
2434:

Line 2431: RAISE OKC_API.G_EXCEPTION_ERROR;

2427: -----------------------------------------------------
2428: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2431: RAISE OKC_API.G_EXCEPTION_ERROR;
2432: END IF;
2433: --------------------------------------------------------
2434:
2435: delete_contract_usages(p_api_version => p_api_version,

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

2446: || x_return_status);
2447: END IF;
2448:
2449: -----------------------------------------------------
2450: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2451: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2452: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2453: RAISE OKC_API.G_EXCEPTION_ERROR;
2454: END IF;

Line 2451: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2447: END IF;
2448:
2449: -----------------------------------------------------
2450: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2451: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2452: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2453: RAISE OKC_API.G_EXCEPTION_ERROR;
2454: END IF;
2455: --------------------------------------------------------

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

2448:
2449: -----------------------------------------------------
2450: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2451: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2452: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2453: RAISE OKC_API.G_EXCEPTION_ERROR;
2454: END IF;
2455: --------------------------------------------------------
2456:

Line 2453: RAISE OKC_API.G_EXCEPTION_ERROR;

2449: -----------------------------------------------------
2450: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2451: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2452: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2453: RAISE OKC_API.G_EXCEPTION_ERROR;
2454: END IF;
2455: --------------------------------------------------------
2456:
2457: ELSE

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

2470: || x_return_status);
2471: END IF;
2472:
2473: -----------------------------------------------------
2474: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2475: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2476: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2477: RAISE OKC_API.G_EXCEPTION_ERROR;
2478: END IF;

Line 2475: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2471: END IF;
2472:
2473: -----------------------------------------------------
2474: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2475: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2476: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2477: RAISE OKC_API.G_EXCEPTION_ERROR;
2478: END IF;
2479: --------------------------------------------------------

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

2472:
2473: -----------------------------------------------------
2474: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2475: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2476: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2477: RAISE OKC_API.G_EXCEPTION_ERROR;
2478: END IF;
2479: --------------------------------------------------------
2480:

Line 2477: RAISE OKC_API.G_EXCEPTION_ERROR;

2473: -----------------------------------------------------
2474: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2475: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2476: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2477: RAISE OKC_API.G_EXCEPTION_ERROR;
2478: END IF;
2479: --------------------------------------------------------
2480:
2481: END IF;

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

2494: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2495: g_module || l_api_name,
2496: 'Leaving delete_contract because of EXCEPTION: ' || sqlerrm);
2497: END IF;
2498: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2499: p_msg_name => G_UNEXPECTED_ERROR,
2500: p_token1 => G_SQLCODE_TOKEN,
2501: p_token1_value => sqlcode,
2502: p_token2 => G_SQLERRM_TOKEN,

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

2572: || x_return_status);
2573: END IF;
2574:
2575: -----------------------------------------------------
2576: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2578: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2579: RAISE OKC_API.G_EXCEPTION_ERROR;
2580: END IF;

Line 2577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2573: END IF;
2574:
2575: -----------------------------------------------------
2576: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2578: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2579: RAISE OKC_API.G_EXCEPTION_ERROR;
2580: END IF;
2581: --------------------------------------------------------

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

2574:
2575: -----------------------------------------------------
2576: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2578: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2579: RAISE OKC_API.G_EXCEPTION_ERROR;
2580: END IF;
2581: --------------------------------------------------------
2582: --Change Contract status TO CANCELLED

Line 2579: RAISE OKC_API.G_EXCEPTION_ERROR;

2575: -----------------------------------------------------
2576: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2577: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2578: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2579: RAISE OKC_API.G_EXCEPTION_ERROR;
2580: END IF;
2581: --------------------------------------------------------
2582: --Change Contract status TO CANCELLED
2583: UPDATE okc_rep_contracts_all

Line 2598: l_resolved_msg_name := OKC_API.resolve_message('OKC_IMP_INVALID_STATUS',l_contract_type);

2594: END IF;
2595:
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597:
2598: l_resolved_msg_name := OKC_API.resolve_message('OKC_IMP_INVALID_STATUS',l_contract_type);
2599: l_resolved_token := OKC_API.resolve_hdr_token(l_contract_type);
2600:
2601: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2602: p_msg_name => l_resolved_msg_name,

Line 2599: l_resolved_token := OKC_API.resolve_hdr_token(l_contract_type);

2595:
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597:
2598: l_resolved_msg_name := OKC_API.resolve_message('OKC_IMP_INVALID_STATUS',l_contract_type);
2599: l_resolved_token := OKC_API.resolve_hdr_token(l_contract_type);
2600:
2601: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2602: p_msg_name => l_resolved_msg_name,
2603: p_token1 => 'HDR_TOKEN',

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

2597:
2598: l_resolved_msg_name := OKC_API.resolve_message('OKC_IMP_INVALID_STATUS',l_contract_type);
2599: l_resolved_token := OKC_API.resolve_hdr_token(l_contract_type);
2600:
2601: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2602: p_msg_name => l_resolved_msg_name,
2603: p_token1 => 'HDR_TOKEN',
2604: p_token1_value => l_resolved_token);
2605:

Line 2606: RAISE OKC_API.G_EXCEPTION_ERROR;

2602: p_msg_name => l_resolved_msg_name,
2603: p_token1 => 'HDR_TOKEN',
2604: p_token1_value => l_resolved_token);
2605:
2606: RAISE OKC_API.G_EXCEPTION_ERROR;
2607:
2608: END IF;
2609:
2610: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2636: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2637: g_module || l_api_name,
2638: 'Leaving cancel_contract because of EXCEPTION: ' || sqlerrm);
2639: END IF;
2640: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2641: p_msg_name => G_UNEXPECTED_ERROR,
2642: p_token1 => G_SQLCODE_TOKEN,
2643: p_token1_value => sqlcode,
2644: p_token2 => G_SQLERRM_TOKEN,

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

2774: || x_return_status);
2775: END IF;
2776:
2777: -----------------------------------------------------
2778: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2779: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2780: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2781: RAISE OKC_API.G_EXCEPTION_ERROR;
2782: END IF;

Line 2779: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2775: END IF;
2776:
2777: -----------------------------------------------------
2778: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2779: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2780: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2781: RAISE OKC_API.G_EXCEPTION_ERROR;
2782: END IF;
2783: --------------------------------------------------------

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

2776:
2777: -----------------------------------------------------
2778: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2779: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2780: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2781: RAISE OKC_API.G_EXCEPTION_ERROR;
2782: END IF;
2783: --------------------------------------------------------
2784:

Line 2781: RAISE OKC_API.G_EXCEPTION_ERROR;

2777: -----------------------------------------------------
2778: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2779: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2780: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2781: RAISE OKC_API.G_EXCEPTION_ERROR;
2782: END IF;
2783: --------------------------------------------------------
2784:
2785: END LOOP;

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

2815: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2816: g_module || l_api_name,
2817: 'Leaving cancel_contract because of EXCEPTION: ' || sqlerrm);
2818: END IF;
2819: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2820: p_msg_name => G_UNEXPECTED_ERROR,
2821: p_token1 => G_SQLCODE_TOKEN,
2822: p_token1_value => sqlcode,
2823: p_token2 => G_SQLERRM_TOKEN,