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 824: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

820: GROUP BY l.contract_line_id,
821: l.stream_type_id;
822: --ansethur 01-MAR-2007 Added for R12 B Billing Architecture End Changes
823: l_tqlv_rec tqlv_rec_type;
824: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
825: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
826: l_total NUMBER := 0;
827: l_seq NUMBER := NVL (px_tqlv_tbl.LAST, 0);
828:

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

821: l.stream_type_id;
822: --ansethur 01-MAR-2007 Added for R12 B Billing Architecture End Changes
823: l_tqlv_rec tqlv_rec_type;
824: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
825: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
826: l_total NUMBER := 0;
827: l_seq NUMBER := NVL (px_tqlv_tbl.LAST, 0);
828:
829: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'process_outstanding_balances';

Line 918: OKL_API.SET_MESSAGE (

914: || sqlcode || ' , SQLERRM : ' || sqlerrm);
915: END IF;
916:
917: -- store SQL error message on message stack for caller
918: OKL_API.SET_MESSAGE (
919: p_app_name => G_APP_NAME
920: ,p_msg_name => G_UNEXPECTED_ERROR
921: ,p_token1 => G_SQLCODE_TOKEN
922: ,p_token1_value => sqlcode

Line 927: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

923: ,p_token2 => G_SQLERRM_TOKEN
924: ,p_token2_value => sqlerrm);
925:
926: -- notify caller of an UNEXPECTED error
927: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
928:
929: END process_outstanding_balances;
930:
931:

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

947: px_tqlv_tbl IN OUT NOCOPY tqlv_tbl_type,
948: x_operand_total OUT NOCOPY NUMBER,
949: x_return_status OUT NOCOPY VARCHAR2) IS
950:
951: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
952: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
953: l_operand_total NUMBER;
954:
955: -- Some styles are processed by a designated routine.

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

948: x_operand_total OUT NOCOPY NUMBER,
949: x_return_status OUT NOCOPY VARCHAR2) IS
950:
951: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
952: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
953: l_operand_total NUMBER;
954:
955: -- Some styles are processed by a designated routine.
956: -- All other styles are included into Unbilled Receivables

Line 1033: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1029: x_return_status => l_return_status);
1030:
1031: END IF;
1032:
1033: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1034: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1035: l_overall_status := l_return_status;
1036: END IF;
1037: END IF;

Line 1034: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1030:
1031: END IF;
1032:
1033: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1034: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1035: l_overall_status := l_return_status;
1036: END IF;
1037: END IF;
1038:

Line 1055: OKL_API.SET_MESSAGE (

1051: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1052: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1053: END IF;
1054: -- store SQL error message on message stack for caller
1055: OKL_API.SET_MESSAGE (
1056: p_app_name => G_APP_NAME
1057: ,p_msg_name => G_UNEXPECTED_ERROR
1058: ,p_token1 => G_SQLCODE_TOKEN
1059: ,p_token1_value => sqlcode

Line 1064: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1060: ,p_token2 => G_SQLERRM_TOKEN
1061: ,p_token2_value => sqlerrm);
1062:
1063: -- notify caller of an UNEXPECTED error
1064: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1065:
1066: END calc_stream_type_operand;
1067:
1068: