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_AM_CALC_QUOTE_STREAM_PVT dependencies on OKL_API

Line 40: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

36: px_tqlv_tbl IN OUT NOCOPY tqlv_tbl_type,
37: x_return_status OUT NOCOPY VARCHAR2) IS
38:
39: l_tqlv_rec tqlv_rec_type;
40: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
41: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
42: l_formula_name VARCHAR2(150);
43: l_rule_value NUMBER;
44: l_params okl_execute_formula_pub.ctxt_val_tbl_type;

Line 41: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

37: x_return_status OUT NOCOPY VARCHAR2) IS
38:
39: l_tqlv_rec tqlv_rec_type;
40: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
41: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
42: l_formula_name VARCHAR2(150);
43: l_rule_value NUMBER;
44: l_params okl_execute_formula_pub.ctxt_val_tbl_type;
45:

Line 94: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

90: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
91: 'after call to okl_am_util_pvt.get_formula_value :'||l_return_status);
92: END IF;
93:
94: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
95: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
96: l_overall_status := l_return_status;
97: END IF;
98: END IF;

Line 95: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

91: 'after call to okl_am_util_pvt.get_formula_value :'||l_return_status);
92: END IF;
93:
94: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
95: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
96: l_overall_status := l_return_status;
97: END IF;
98: END IF;
99:

Line 105: IF l_return_status = OKL_API.G_RET_STS_SUCCESS

101: --okl_execute_formula_pub.g_additional_parameters(1).value := p_sty_id;
102: --l_tqlv_rec.amount := okl_seeded_functions_pvt.line_unbilled_streams
103: -- (p_qtev_rec.khr_id, p_cle_id);
104:
105: IF l_return_status = OKL_API.G_RET_STS_SUCCESS
106: AND l_rule_value IS NOT NULL THEN
107:
108: l_tqlv_rec.kle_id := NVL (p_asset_cle_id, p_cle_id);
109: l_tqlv_rec.sty_id := p_sty_id;

Line 133: OKL_API.SET_MESSAGE (

129: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
130: || sqlcode || ' , SQLERRM : ' || sqlerrm);
131: END IF;
132: -- store SQL error message on message stack for caller
133: OKL_API.SET_MESSAGE (
134: p_app_name => G_APP_NAME
135: ,p_msg_name => G_UNEXPECTED_ERROR
136: ,p_token1 => G_SQLCODE_TOKEN
137: ,p_token1_value => sqlcode

Line 142: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

138: ,p_token2 => G_SQLERRM_TOKEN
139: ,p_token2_value => sqlerrm);
140:
141: -- notify caller of an UNEXPECTED error
142: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
143:
144: END add_element;
145:
146:

Line 261: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

257: AND lse.id = cle.lse_id
258: AND lse.lty_code = cp_link_style
259: AND kle.id = cle.id;
260:
261: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
262: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
263: l_total NUMBER := 0;
264: l_seq NUMBER := NVL (px_tqlv_tbl.LAST, 0);
265: l_total_payment NUMBER;

Line 262: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

258: AND lse.lty_code = cp_link_style
259: AND kle.id = cle.id;
260:
261: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
262: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
263: l_total NUMBER := 0;
264: l_seq NUMBER := NVL (px_tqlv_tbl.LAST, 0);
265: l_total_payment NUMBER;
266: l_prorate_ratio NUMBER;

Line 388: OKL_API.SET_MESSAGE (

384: END IF;
385:
386:
387: -- store SQL error message on message stack for caller
388: OKL_API.SET_MESSAGE (
389: p_app_name => G_APP_NAME
390: ,p_msg_name => G_UNEXPECTED_ERROR
391: ,p_token1 => G_SQLCODE_TOKEN
392: ,p_token1_value => sqlcode

Line 397: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

393: ,p_token2 => G_SQLERRM_TOKEN
394: ,p_token2_value => sqlerrm);
395:
396: -- notify caller of an UNEXPECTED error
397: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
398:
399: END process_specific_line_style;
400:
401:

Line 566: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

562: GROUP BY stm.kle_id,
563: stm.sty_id;
564:
565: l_tqlv_rec tqlv_rec_type;
566: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
567: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
568: l_total NUMBER := 0;
569: l_seq NUMBER := NVL (px_tqlv_tbl.LAST, 0);
570:

Line 567: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

563: stm.sty_id;
564:
565: l_tqlv_rec tqlv_rec_type;
566: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
567: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
568: l_total NUMBER := 0;
569: l_seq NUMBER := NVL (px_tqlv_tbl.LAST, 0);
570:
571: -- rmunjulu bug 5005225

Line 698: OKL_API.SET_MESSAGE (

694: END IF;
695:
696:
697: -- store SQL error message on message stack for caller
698: OKL_API.SET_MESSAGE (
699: p_app_name => G_APP_NAME
700: ,p_msg_name => G_UNEXPECTED_ERROR
701: ,p_token1 => G_SQLCODE_TOKEN
702: ,p_token1_value => sqlcode

Line 707: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

703: ,p_token2 => G_SQLERRM_TOKEN
704: ,p_token2_value => sqlerrm);
705:
706: -- notify caller of an UNEXPECTED error
707: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
708:
709: END process_unbilled_receivables;
710:
711:

Line 875: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

871: GROUP BY l.contract_line_id,
872: l.stream_type_id;
873: --ansethur 01-MAR-2007 Added for R12 B Billing Architecture End Changes
874: l_tqlv_rec tqlv_rec_type;
875: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
876: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
877: l_total NUMBER := 0;
878: l_seq NUMBER := NVL (px_tqlv_tbl.LAST, 0);
879:

Line 876: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

872: l.stream_type_id;
873: --ansethur 01-MAR-2007 Added for R12 B Billing Architecture End Changes
874: l_tqlv_rec tqlv_rec_type;
875: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
876: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
877: l_total NUMBER := 0;
878: l_seq NUMBER := NVL (px_tqlv_tbl.LAST, 0);
879:
880: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'process_outstanding_balances';

Line 969: OKL_API.SET_MESSAGE (

965: || sqlcode || ' , SQLERRM : ' || sqlerrm);
966: END IF;
967:
968: -- store SQL error message on message stack for caller
969: OKL_API.SET_MESSAGE (
970: p_app_name => G_APP_NAME
971: ,p_msg_name => G_UNEXPECTED_ERROR
972: ,p_token1 => G_SQLCODE_TOKEN
973: ,p_token1_value => sqlcode

Line 978: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

974: ,p_token2 => G_SQLERRM_TOKEN
975: ,p_token2_value => sqlerrm);
976:
977: -- notify caller of an UNEXPECTED error
978: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
979:
980: END process_outstanding_balances;
981:
982:

Line 1002: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

998: px_tqlv_tbl IN OUT NOCOPY tqlv_tbl_type,
999: x_operand_total OUT NOCOPY NUMBER,
1000: x_return_status OUT NOCOPY VARCHAR2) IS
1001:
1002: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1003: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1004: l_operand_total NUMBER;
1005:
1006: -- Some styles are processed by a designated routine.

Line 1003: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

999: x_operand_total OUT NOCOPY NUMBER,
1000: x_return_status OUT NOCOPY VARCHAR2) IS
1001:
1002: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1003: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1004: l_operand_total NUMBER;
1005:
1006: -- Some styles are processed by a designated routine.
1007: -- All other styles are included into Unbilled Receivables

Line 1084: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1080: x_return_status => l_return_status);
1081:
1082: END IF;
1083:
1084: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1085: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1086: l_overall_status := l_return_status;
1087: END IF;
1088: END IF;

Line 1085: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1081:
1082: END IF;
1083:
1084: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1085: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1086: l_overall_status := l_return_status;
1087: END IF;
1088: END IF;
1089:

Line 1106: OKL_API.SET_MESSAGE (

1102: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1103: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1104: END IF;
1105: -- store SQL error message on message stack for caller
1106: OKL_API.SET_MESSAGE (
1107: p_app_name => G_APP_NAME
1108: ,p_msg_name => G_UNEXPECTED_ERROR
1109: ,p_token1 => G_SQLCODE_TOKEN
1110: ,p_token1_value => sqlcode

Line 1115: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1111: ,p_token2 => G_SQLERRM_TOKEN
1112: ,p_token2_value => sqlerrm);
1113:
1114: -- notify caller of an UNEXPECTED error
1115: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1116:
1117: END calc_stream_type_operand;
1118:
1119: