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 1379: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1375: x_msg_count => x_msg_count,
1376: x_msg_data => x_msg_data,
1377: p_cle_id => p_line_id);
1378:
1379: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1380: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1381: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1382: RAISE OKL_API.G_EXCEPTION_ERROR;
1383: END IF;

Line 1380: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1376: x_msg_data => x_msg_data,
1377: p_cle_id => p_line_id);
1378:
1379: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1380: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1381: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1382: RAISE OKL_API.G_EXCEPTION_ERROR;
1383: END IF;
1384: END IF;

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

1377: p_cle_id => p_line_id);
1378:
1379: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1380: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1381: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1382: RAISE OKL_API.G_EXCEPTION_ERROR;
1383: END IF;
1384: END IF;
1385: END IF;

Line 1382: RAISE OKL_API.G_EXCEPTION_ERROR;

1378:
1379: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1380: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1381: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1382: RAISE OKL_API.G_EXCEPTION_ERROR;
1383: END IF;
1384: END IF;
1385: END IF;
1386: --Bug# 4959361

Line 1503: l_raise_business_event := OKL_API.G_FALSE;

1499: --
1500: -- sjalasut. added logic to raise business events when a rule group is created
1501: --
1502: -- initialize the global variables for the business events
1503: l_raise_business_event := OKL_API.G_FALSE;
1504: l_business_event_name := NULL;
1505: l_terms_id := NULL;
1506: IF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAAFLG' AND process_type = 'HEADER')THEN
1507: -- raise business event for the Liens and Title for Terms and Conditions for the Contract

Line 1509: l_raise_business_event := OKL_API.G_TRUE;

1505: l_terms_id := NULL;
1506: IF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAAFLG' AND process_type = 'HEADER')THEN
1507: -- raise business event for the Liens and Title for Terms and Conditions for the Contract
1508: -- set raise business event flag to true
1509: l_raise_business_event := OKL_API.G_TRUE;
1510: -- set the event name to be raised. this event name will vary for each rule group
1511: l_business_event_name := G_WF_EVT_CONTRACT_TERM_UPDATED;
1512: OPEN get_header_terms_id(p_chr_id, l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code);
1513: FETCH get_header_terms_id INTO l_terms_id;

Line 1521: l_raise_business_event := OKL_API.G_TRUE;

1517: END IF;
1518: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAAFLG' AND process_type = 'LINE')THEN
1519: -- raise business event for Liens Title and Registration for the Assets
1520: -- set raise business event flag to true
1521: l_raise_business_event := OKL_API.G_TRUE;
1522: -- set the event name to be raised. this event name will vary for each rule group
1523: l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
1524: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1525: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAASTX' AND process_type = 'LINE')THEN

Line 1527: l_raise_business_event := OKL_API.G_TRUE;

1523: l_business_event_name := G_WF_EVT_ASSET_FILING_UPDATED;
1524: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1525: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAASTX' AND process_type = 'LINE')THEN
1526: -- raise business event for tax, property tax updated.
1527: l_raise_business_event := OKL_API.G_TRUE;
1528: l_business_event_name := G_WF_EVT_ASSET_PROPTAX_UPDATED;
1529: wf_event.AddParameterToList(G_WF_ITM_ASSET_ID, p_line_id, l_parameter_list);
1530: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAPSTH' and process_type = 'LINE')THEN
1531: OPEN get_line_style(p_line_id);

Line 1536: l_raise_business_event := OKL_API.G_TRUE;

1532: FETCH get_line_style INTO l_line_style;
1533: CLOSE get_line_style;
1534: -- raise business event for service line update passthru
1535: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
1536: l_raise_business_event := OKL_API.G_TRUE;
1537: l_business_event_name := G_WF_EVT_SERV_PASS_UPDATED;
1538: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);
1539: -- check if the service line in context has a service contract associated with it
1540: -- if so, pass the service contract id and service contract line id as parameters

Line 1553: l_raise_business_event := OKL_API.G_TRUE;

1549: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1550: END IF;
1551: -- raise the business event for update passthrough for Fee Line
1552: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1553: l_raise_business_event := OKL_API.G_TRUE;
1554: l_business_event_name := G_WF_EVT_FEE_PASS_UPDATED;
1555: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);
1556: END IF;
1557: ELSIF(l_rgr_tbl(l_rgr_tbl.FIRST).rgd_code = 'LAFEXP' and process_type = 'LINE')THEN

Line 1563: l_raise_business_event := OKL_API.G_TRUE;

1559: FETCH get_line_style INTO l_line_style;
1560: CLOSE get_line_style;
1561: -- raise business event for service line update expense
1562: IF(l_line_style IS NOT NULL AND l_line_style = 'SOLD_SERVICE')THEN
1563: l_raise_business_event := OKL_API.G_TRUE;
1564: l_business_event_name := G_WF_EVT_SERV_FEXP_UPDATED;
1565: wf_event.AddParameterToList(G_WF_ITM_SERV_LINE_ID, p_line_id, l_parameter_list);
1566: -- check if the service line in context has a service contract associated with it
1567: -- if so, pass the service contract id and service contract line id as parameters

Line 1579: l_raise_business_event := OKL_API.G_TRUE;

1575: wf_event.AddParameterToList(G_WF_ITM_SERV_CHR_ID, l_serv_contract_id, l_parameter_list);
1576: wf_event.AddParameterToList(G_WF_ITM_SERV_CLE_ID, l_service_top_line_id, l_parameter_list);
1577: END IF;
1578: ELSIF(l_line_style IS NOT NULL AND l_line_style = 'FEE')THEN
1579: l_raise_business_event := OKL_API.G_TRUE;
1580: l_business_event_name := G_WF_EVT_FEE_EXP_UPDATED;
1581: wf_event.AddParameterToList(G_WF_ITM_FEE_LINE_ID, p_line_id, l_parameter_list);
1582: END IF;
1583: END IF;

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

1583: END IF;
1584: END IF;
1585:
1586: -- check if the business event needs to be raised
1587: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL AND
1588: OKL_LLA_UTIL_PVT.is_lease_contract(p_chr_id)= OKL_API.G_TRUE)THEN
1589: -- since contract id is called as 'CONTRACT_ID' for all the above events, it is being
1590: -- added to the parameter list here, than duplicating it in all the above if conditions
1591:

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

1584: END IF;
1585:
1586: -- check if the business event needs to be raised
1587: IF(l_raise_business_event = OKL_API.G_TRUE AND l_business_event_name IS NOT NULL AND
1588: OKL_LLA_UTIL_PVT.is_lease_contract(p_chr_id)= OKL_API.G_TRUE)THEN
1589: -- since contract id is called as 'CONTRACT_ID' for all the above events, it is being
1590: -- added to the parameter list here, than duplicating it in all the above if conditions
1591:
1592: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID, p_chr_id, l_parameter_list);

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

1597: x_msg_data => x_msg_data,
1598: p_event_name => l_business_event_name,
1599: p_event_param_list => l_parameter_list
1600: );
1601: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1603: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_ERROR;
1605: END IF;

Line 1602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1598: p_event_name => l_business_event_name,
1599: p_event_param_list => l_parameter_list
1600: );
1601: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1603: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_ERROR;
1605: END IF;
1606: END IF;

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

1599: p_event_param_list => l_parameter_list
1600: );
1601: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1603: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_ERROR;
1605: END IF;
1606: END IF;
1607:

Line 1604: RAISE OKL_API.G_EXCEPTION_ERROR;

1600: );
1601: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1603: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1604: RAISE OKL_API.G_EXCEPTION_ERROR;
1605: END IF;
1606: END IF;
1607:
1608: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

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

1604: RAISE OKL_API.G_EXCEPTION_ERROR;
1605: END IF;
1606: END IF;
1607:
1608: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1609: x_msg_data => x_msg_data);
1610:
1611:
1612: EXCEPTION

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

1699: end loop;
1700: x_rgr_tbl := lx_rgr_tbl;
1701:
1702:
1703: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1704: x_msg_data => x_msg_data);
1705:
1706: EXCEPTION
1707: when OKC_API.G_EXCEPTION_ERROR then