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_WF_PVT dependencies on FND_API

Line 23: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

19:
20: ------------------------------------------------------------------------------
21: -- GLOBAL CONSTANTS
22: ------------------------------------------------------------------------------
23: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
24: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
25:
26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 24: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

20: ------------------------------------------------------------------------------
21: -- GLOBAL CONSTANTS
22: ------------------------------------------------------------------------------
23: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
24: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
25:
26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
28: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

22: ------------------------------------------------------------------------------
23: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
24: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
25:
26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
28: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
29:
30: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 27: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

23: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
24: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
25:
26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
28: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
29:
30: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
31: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 28: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

24: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
25:
26: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
27: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
28: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
29:
30: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
31: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
32: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 1052: p_init_msg_list => FND_API.G_FALSE,

1048: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1049: END IF;
1050: OKC_REP_UTIL_PVT.add_approval_hist_record(
1051: p_api_version => 1.0,
1052: p_init_msg_list => FND_API.G_FALSE,
1053: p_contract_id => l_contract_id,
1054: p_contract_version => l_contract_version,
1055: p_action_code => G_STATUS_APPROVED,
1056: p_user_id => notif_rec.user_id,

Line 1094: p_init_msg_list => FND_API.G_FALSE,

1090: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1091: END IF;
1092: OKC_REP_UTIL_PVT.add_approval_hist_record(
1093: p_api_version => 1.0,
1094: p_init_msg_list => FND_API.G_FALSE,
1095: p_contract_id => l_contract_id,
1096: p_contract_version => l_contract_version,
1097: p_action_code => G_STATUS_REJECTED,
1098: p_user_id => notif_rec.user_id,

Line 1168: p_init_msg_list => FND_API.G_FALSE,

1164: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1165: END IF;
1166: OKC_REP_UTIL_PVT.add_approval_hist_record(
1167: p_api_version => 1.0,
1168: p_init_msg_list => FND_API.G_FALSE,
1169: p_contract_id => l_contract_id,
1170: p_contract_version => l_contract_version,
1171: p_action_code => G_STATUS_TIMEOUT,
1172: p_user_id => notif_rec.user_id,

Line 1409: p_init_msg_list => FND_API.G_FALSE,

1405: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1406: END IF;
1407: OKC_REP_UTIL_PVT.add_approval_hist_record(
1408: p_api_version => 1.0,
1409: p_init_msg_list => FND_API.G_FALSE,
1410: p_contract_id => l_contract_id,
1411: p_contract_version => l_contract_version,
1412: p_action_code => G_STATUS_APPROVED,
1413: p_user_id => notif_rec.user_id,

Line 1457: p_init_msg_list => FND_API.G_FALSE,

1453: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1454: END IF;
1455: OKC_REP_UTIL_PVT.add_approval_hist_record(
1456: p_api_version => 1.0,
1457: p_init_msg_list => FND_API.G_FALSE,
1458: p_contract_id => l_contract_id,
1459: p_contract_version => l_contract_version,
1460: p_action_code => G_STATUS_REJECTED,
1461: p_user_id => notif_rec.user_id,

Line 1515: p_init_msg_list => FND_API.G_FALSE,

1511:
1512:
1513: OKC_REP_UTIL_PVT.add_approval_hist_record(
1514: p_api_version => 1.0,
1515: p_init_msg_list => FND_API.G_FALSE,
1516: p_contract_id => l_contract_id,
1517: p_contract_version => l_contract_version,
1518: p_action_code => G_STATUS_APPROVED,
1519: p_user_id => notif_rec.user_id,

Line 1558: p_init_msg_list => FND_API.G_FALSE,

1554: END IF;
1555: l_action_code:= G_WF_APPROVE_FORWARD;
1556: OKC_REP_UTIL_PVT.add_approval_hist_record(
1557: p_api_version => 1.0,
1558: p_init_msg_list => FND_API.G_FALSE,
1559: p_contract_id => l_contract_id,
1560: p_contract_version => l_contract_version,
1561: p_action_code => l_action_code,
1562: p_user_id => notif_rec.user_id,

Line 1639: p_init_msg_list => FND_API.G_FALSE,

1635: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1636: END IF;
1637: OKC_REP_UTIL_PVT.add_approval_hist_record(
1638: p_api_version => 1.0,
1639: p_init_msg_list => FND_API.G_FALSE,
1640: p_contract_id => l_contract_id,
1641: p_contract_version => l_contract_version,
1642: p_action_code => G_STATUS_TIMEOUT,
1643: p_user_id => notif_rec.user_id,

Line 1708: p_init_msg_list => FND_API.G_FALSE,

1704: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1705: END IF;
1706: OKC_REP_UTIL_PVT.add_approval_hist_record(
1707: p_api_version => 1.0,
1708: p_init_msg_list => FND_API.G_FALSE,
1709: p_contract_id => l_contract_id,
1710: p_contract_version => l_contract_version,
1711: p_action_code => l_action_code,
1712: p_user_id => notif_rec.user_id,

Line 1875: p_init_msg_list => FND_API.G_FALSE,

1871: END IF;
1872: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
1873: OKC_REP_UTIL_PVT.change_contract_status(
1874: p_api_version => 1.0,
1875: p_init_msg_list => FND_API.G_FALSE,
1876: p_contract_id => l_contract_id,
1877: p_contract_version => l_contract_version,
1878: p_status_code => G_STATUS_APPROVED,
1879: p_user_id => fnd_global.user_id,

Line 1912: p_init_msg_list => FND_API.G_FALSE,

1908: 'Calling OKC_DELIVERABLE_PROCESS_PVT.version_deliverables');
1909: END IF;
1910: OKC_DELIVERABLE_PROCESS_PVT.version_deliverables (
1911: p_api_version => 1.0,
1912: p_init_msg_list => FND_API.G_FALSE,
1913: p_doc_id => l_contract_id,
1914: p_doc_version => contract_rec.contract_version_num,
1915: p_doc_type => contract_rec.contract_type,
1916: x_return_status => l_return_status,

Line 1940: l_sync_flag := FND_API.G_FALSE;

1936: || contract_rec.latest_signed_ver_number);
1937: END IF;
1938: -- Now we need to activate deliverables
1939: if (contract_rec.latest_signed_ver_number IS NULL) THEN
1940: l_sync_flag := FND_API.G_FALSE;
1941: ELSE
1942: l_sync_flag := FND_API.G_TRUE;
1943: END IF;
1944:

Line 1942: l_sync_flag := FND_API.G_TRUE;

1938: -- Now we need to activate deliverables
1939: if (contract_rec.latest_signed_ver_number IS NULL) THEN
1940: l_sync_flag := FND_API.G_FALSE;
1941: ELSE
1942: l_sync_flag := FND_API.G_TRUE;
1943: END IF;
1944:
1945: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1946: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1959: p_init_msg_list => FND_API.G_FALSE,

1955: END IF;
1956:
1957: OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables (
1958: p_api_version => 1.0,
1959: p_init_msg_list => FND_API.G_FALSE,
1960: p_commit => FND_API.G_FALSE,
1961: p_bus_doc_id => l_contract_id,
1962: p_bus_doc_type => contract_rec.contract_type,
1963: p_bus_doc_version => contract_rec.contract_version_num,

Line 1960: p_commit => FND_API.G_FALSE,

1956:
1957: OKC_MANAGE_DELIVERABLES_GRP.activateDeliverables (
1958: p_api_version => 1.0,
1959: p_init_msg_list => FND_API.G_FALSE,
1960: p_commit => FND_API.G_FALSE,
1961: p_bus_doc_id => l_contract_id,
1962: p_bus_doc_type => contract_rec.contract_type,
1963: p_bus_doc_version => contract_rec.contract_version_num,
1964: p_event_code => G_CONTRACT_EFFECTIVE_EVENT,

Line 1986: IF (l_sync_flag = FND_API.G_TRUE) THEN

1982: END IF;
1983: --------------------------------------------------------
1984:
1985: -- Checking if we need to call deliverable's APIs for synch-ing
1986: IF (l_sync_flag = FND_API.G_TRUE) THEN
1987: -- Get the previous signed contract's expiration date
1988: -- Get effective dates and version of the contract.
1989: OPEN arch_contract_csr(contract_rec.latest_signed_ver_number,l_contract_id);
1990: FETCH arch_contract_csr INTO arch_contract_rec;

Line 2001: RAISE FND_API.G_EXC_ERROR;

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;
2002: -- RAISE NO_DATA_FOUND;
2003: END IF;
2004: l_prev_signed_effective_date := arch_contract_rec.contract_effective_date;
2005: l_prev_signed_expiration_date := arch_contract_rec.contract_expiration_date;

Line 2024: l_expiration_date_matches_flag := FND_API.G_TRUE;

2020: -- If last signed version's expiration date is different from the current version's expiration date
2021: -- we need to call deliverables API for synching previous signed deliverables.
2022: -- This logic is executed to handle the null date scenarios
2023: IF (trunc(l_prev_signed_expiration_date)=trunc(contract_rec.contract_expiration_date)) THEN
2024: l_expiration_date_matches_flag := FND_API.G_TRUE;
2025: END IF;
2026:
2027: IF (trunc(l_prev_signed_effective_date)=trunc(contract_rec.contract_effective_date)) THEN
2028: l_effective_date_matches_flag := FND_API.G_TRUE;

Line 2028: l_effective_date_matches_flag := FND_API.G_TRUE;

2024: l_expiration_date_matches_flag := FND_API.G_TRUE;
2025: END IF;
2026:
2027: IF (trunc(l_prev_signed_effective_date)=trunc(contract_rec.contract_effective_date)) THEN
2028: l_effective_date_matches_flag := FND_API.G_TRUE;
2029: END IF;
2030:
2031: IF ((l_expiration_date_matches_flag = FND_API.G_FALSE ) OR (l_effective_date_matches_flag = FND_API.G_FALSE)) THEN
2032: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2031: IF ((l_expiration_date_matches_flag = FND_API.G_FALSE ) OR (l_effective_date_matches_flag = FND_API.G_FALSE)) THEN

2027: IF (trunc(l_prev_signed_effective_date)=trunc(contract_rec.contract_effective_date)) THEN
2028: l_effective_date_matches_flag := FND_API.G_TRUE;
2029: END IF;
2030:
2031: IF ((l_expiration_date_matches_flag = FND_API.G_FALSE ) OR (l_effective_date_matches_flag = FND_API.G_FALSE)) THEN
2032: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2033: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2034: 'Calling OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
2035: END IF;

Line 2038: p_init_msg_list => FND_API.G_FALSE,

2034: 'Calling OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
2035: END IF;
2036: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (
2037: p_api_version => 1.0,
2038: p_init_msg_list => FND_API.G_FALSE,
2039: p_commit => FND_API.G_FALSE,
2040: p_bus_doc_id => l_contract_id,
2041: p_bus_doc_type => contract_rec.contract_type,
2042: p_bus_doc_version => contract_rec.contract_version_num,

Line 2039: p_commit => FND_API.G_FALSE,

2035: END IF;
2036: OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (
2037: p_api_version => 1.0,
2038: p_init_msg_list => FND_API.G_FALSE,
2039: p_commit => FND_API.G_FALSE,
2040: p_bus_doc_id => l_contract_id,
2041: p_bus_doc_type => contract_rec.contract_type,
2042: p_bus_doc_version => contract_rec.contract_version_num,
2043: p_bus_doc_date_events_tbl => l_update_event_tbl,

Line 2068: p_init_msg_list => FND_API.G_FALSE,

2064: 'Calling OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables');
2065: END IF;
2066: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (
2067: p_api_version => 1.0,
2068: p_init_msg_list => FND_API.G_FALSE,
2069: p_commit => FND_API.G_FALSE,
2070: p_bus_doc_id => l_contract_id,
2071: p_bus_doc_type => contract_rec.contract_type,
2072: p_bus_doc_version => contract_rec.latest_signed_ver_number,

Line 2069: p_commit => FND_API.G_FALSE,

2065: END IF;
2066: OKC_MANAGE_DELIVERABLES_GRP.disableDeliverables (
2067: p_api_version => 1.0,
2068: p_init_msg_list => FND_API.G_FALSE,
2069: p_commit => FND_API.G_FALSE,
2070: p_bus_doc_id => l_contract_id,
2071: p_bus_doc_type => contract_rec.contract_type,
2072: p_bus_doc_version => contract_rec.latest_signed_ver_number,
2073: x_msg_data => l_msg_data,

Line 2201: p_init_msg_list => FND_API.G_FALSE,

2197:
2198: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
2199: OKC_REP_UTIL_PVT.change_contract_status(
2200: p_api_version => 1.0,
2201: p_init_msg_list => FND_API.G_FALSE,
2202: p_contract_id => l_contract_id,
2203: p_contract_version => l_contract_version,
2204: p_status_code => G_STATUS_REJECTED,
2205: p_user_id => fnd_global.user_id,