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.OKL_RGRP_RULES_PROCESS_PVT dependencies on OKL_API

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

7: G_EXCEPTION_STOP_VALIDATION exception;
8:
9:
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RGRP_RULES_PROCESS_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13: l_api_name VARCHAR2(35) := 'RGRP_RULES_PROCESS';
14:
15: /*

Line 66: x_return_status := OKL_API.G_RET_STS_SUCCESS;

62: ) IS
63: l_contract_process VARCHAR2(20);
64: l_event_param_list WF_PARAMETER_LIST_T := p_event_param_list;
65: BEGIN
66: x_return_status := OKL_API.G_RET_STS_SUCCESS;
67:
68: -- wrapper API to get contract process. this API determines in which status the
69: -- contract in question is.
70: l_contract_process := okl_lla_util_pvt.get_contract_process(

Line 85: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

81: p_event_name => p_event_name,
82: p_parameters => l_event_param_list);
83: EXCEPTION
84: WHEN OTHERS THEN
85: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: END raise_business_event;
88:
89:

Line 86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

82: p_parameters => l_event_param_list);
83: EXCEPTION
84: WHEN OTHERS THEN
85: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
86: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
87: END raise_business_event;
88:
89:
90: PROCEDURE migrate_rec(

Line 190: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

186: END IF;
187:
188: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
189: /*
190: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
192: */
193:
194: EXCEPTION

Line 1394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1390: x_msg_count => x_msg_count,
1391: x_msg_data => x_msg_data,
1392: p_cle_id => p_line_id);
1393:
1394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1397: RAISE OKL_API.G_EXCEPTION_ERROR;
1398: END IF;

Line 1395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1391: x_msg_data => x_msg_data,
1392: p_cle_id => p_line_id);
1393:
1394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1397: RAISE OKL_API.G_EXCEPTION_ERROR;
1398: END IF;
1399: END IF;

Line 1396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1392: p_cle_id => p_line_id);
1393:
1394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1397: RAISE OKL_API.G_EXCEPTION_ERROR;
1398: END IF;
1399: END IF;
1400: END IF;

Line 1397: RAISE OKL_API.G_EXCEPTION_ERROR;

1393:
1394: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1397: RAISE OKL_API.G_EXCEPTION_ERROR;
1398: END IF;
1399: END IF;
1400: END IF;
1401: --Bug# 4959361

Line 1525: IF ( NVL(l_chk_rbk_rec.orig_system_source_code, OKL_API.G_MISS_CHAR) <> 'OKL_REBOOK' ) THEN

1521: OPEN l_chk_rbk_csr(p_chr_id => l_chr_id);
1522: FETCH l_chk_rbk_csr INTO l_chk_rbk_rec;
1523: CLOSE l_chk_rbk_csr;
1524:
1525: IF ( NVL(l_chk_rbk_rec.orig_system_source_code, OKL_API.G_MISS_CHAR) <> 'OKL_REBOOK' ) THEN
1526:
1527: if(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAHDTX') then
1528: OKL_LA_PROPERTY_TAX_PVT.sync_contract_property_tax(
1529: p_api_version => p_api_version,

Line 1550: l_raise_business_event := OKL_API.G_FALSE;

1546: --
1547: -- sjalasut. added logic to raise business events when a rule group is created
1548: --
1549: -- initialize the global variables for the business events
1550: l_raise_business_event := OKL_API.G_FALSE;
1551: l_business_event_name := NULL;
1552: l_terms_id := NULL;
1553: IF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAAFLG' AND process_type = 'HEADER')THEN
1554: -- raise business event for the Liens and Title for Terms and Conditions for the Contract

Line 1556: l_raise_business_event := OKL_API.G_TRUE;

1552: l_terms_id := NULL;
1553: IF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAAFLG' AND process_type = 'HEADER')THEN
1554: -- raise business event for the Liens and Title for Terms and Conditions for the Contract
1555: -- set raise business event flag to true
1556: l_raise_business_event := OKL_API.G_TRUE;
1557: -- set the event name to be raised. this event name will vary for each rule group
1558: l_business_event_name := G_WF_EVT_CONTRACT_TERM_UPDATED;
1559: OPEN get_header_terms_id(p_chr_id, l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code);
1560: FETCH get_header_terms_id INTO l_terms_id;

Line 1568: l_raise_business_event := OKL_API.G_TRUE;

1564: END IF;
1565: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAAFLG' AND process_type = 'LINE')THEN
1566: -- raise business event for Liens Title and Registration for the Assets
1567: -- set raise business event flag to true
1568: l_raise_business_event := OKL_API.G_TRUE;
1569: -- set the event name to be raised. this event name will vary for each rule group
1570: l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
1571: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1572: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAASTX' AND process_type = 'LINE')THEN

Line 1574: l_raise_business_event := OKL_API.G_TRUE;

1570: l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
1571: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1572: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAASTX' AND process_type = 'LINE')THEN
1573: -- raise business event for tax, property tax updated.
1574: l_raise_business_event := OKL_API.G_TRUE;
1575: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;
1576: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1577: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAPSTH' and process_type = 'LINE')THEN
1578: OPEN get_line_style(p_line_id);

Line 1583: l_raise_business_event := OKL_API.G_TRUE;

1579: FETCH get_line_style INTO l_line_style;
1580: CLOSE get_line_style;
1581: -- raise business event for service line update passthru
1582: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
1583: l_raise_business_event := OKL_API.G_TRUE;
1584: l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;
1585: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);
1586: -- check if the service line in context has a service contract associated with it
1587: -- if so, pass the service contract id and service contract line id as parameters

Line 1600: l_raise_business_event := OKL_API.G_TRUE;

1596: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1597: END IF;
1598: -- raise the business event for update passthrough for Fee Line
1599: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1600: l_raise_business_event := OKL_API.G_TRUE;
1601: l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;
1602: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);
1603: END IF;
1604: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAFEXP' and process_type = 'LINE')THEN

Line 1610: l_raise_business_event := OKL_API.G_TRUE;

1606: FETCH get_line_style INTO l_line_style;
1607: CLOSE get_line_style;
1608: -- raise business event for service line update expense
1609: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
1610: l_raise_business_event := OKL_API.G_TRUE;
1611: l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;
1612: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);
1613: -- check if the service line in context has a service contract associated with it
1614: -- if so, pass the service contract id and service contract line id as parameters

Line 1626: l_raise_business_event := OKL_API.G_TRUE;

1622: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1623: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1624: END IF;
1625: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1626: l_raise_business_event := OKL_API.G_TRUE;
1627: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;
1628: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);
1629: END IF;
1630: END IF;

Line 1634: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL AND

1630: END IF;
1631: END IF;
1632:
1633: -- check if the business event needs to be raised
1634: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL AND
1635: OKL_LLA_UTIL_PVT.is_lease_contract(p_chr_id)= OKL_API.G_TRUE)THEN
1636: -- since contract id is called as 'CONTRACT_ID' for all the above events, it is being
1637: -- added to the parameter list here, than duplicating it in all the above if conditions
1638:

Line 1635: OKL_LLA_UTIL_PVT.is_lease_contract(p_chr_id)= OKL_API.G_TRUE)THEN

1631: END IF;
1632:
1633: -- check if the business event needs to be raised
1634: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL AND
1635: OKL_LLA_UTIL_PVT.is_lease_contract(p_chr_id)= OKL_API.G_TRUE)THEN
1636: -- since contract id is called as 'CONTRACT_ID' for all the above events, it is being
1637: -- added to the parameter list here, than duplicating it in all the above if conditions
1638:
1639: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);

Line 1648: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1644: x_msg_data => x_msg_data,
1645: p_event_name => l_business_event_name,
1646: p_event_param_list => l_parameter_list
1647: );
1648: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1650: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: END IF;

Line 1649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1645: p_event_name => l_business_event_name,
1646: p_event_param_list => l_parameter_list
1647: );
1648: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1650: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: END IF;
1653: END IF;

Line 1650: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1646: p_event_param_list => l_parameter_list
1647: );
1648: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1650: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: END IF;
1653: END IF;
1654:

Line 1651: RAISE OKL_API.G_EXCEPTION_ERROR;

1647: );
1648: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1650: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: END IF;
1653: END IF;
1654:
1655: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 1655: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1651: RAISE OKL_API.G_EXCEPTION_ERROR;
1652: END IF;
1653: END IF;
1654:
1655: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1656: x_msg_data => x_msg_data);
1657:
1658:
1659: EXCEPTION

Line 1772: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1768: end loop;
1769: x_rgr_tbl := lx_rgr_tbl;
1770:
1771:
1772: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1773: x_msg_data => x_msg_data);
1774:
1775: EXCEPTION
1776: when OKC_API.G_EXCEPTION_ERROR then