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_VAR_INT_FLOAT_FACTOR_PVT dependencies on OKL_VARIABLE_INTEREST_PVT

Line 79: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_FLOAT_FACTOR using following parameters : ');

75: ------------------------------------------------------------
76:
77: x_return_status := OKL_API.G_RET_STS_SUCCESS;
78:
79: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_FLOAT_FACTOR using following parameters : ');
80: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID : '|| p_contract_id);
81: OKL_VARIABLE_INTEREST_PVT.print_debug('g_contract_id : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
82: OKL_VARIABLE_INTEREST_PVT.print_debug('From date : '|| p_from_date);
83: OKL_VARIABLE_INTEREST_PVT.print_Debug('To date : '|| p_to_date);

Line 80: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID : '|| p_contract_id);

76:
77: x_return_status := OKL_API.G_RET_STS_SUCCESS;
78:
79: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_FLOAT_FACTOR using following parameters : ');
80: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID : '|| p_contract_id);
81: OKL_VARIABLE_INTEREST_PVT.print_debug('g_contract_id : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
82: OKL_VARIABLE_INTEREST_PVT.print_debug('From date : '|| p_from_date);
83: OKL_VARIABLE_INTEREST_PVT.print_Debug('To date : '|| p_to_date);
84:

Line 81: OKL_VARIABLE_INTEREST_PVT.print_debug('g_contract_id : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);

77: x_return_status := OKL_API.G_RET_STS_SUCCESS;
78:
79: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_FLOAT_FACTOR using following parameters : ');
80: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID : '|| p_contract_id);
81: OKL_VARIABLE_INTEREST_PVT.print_debug('g_contract_id : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
82: OKL_VARIABLE_INTEREST_PVT.print_debug('From date : '|| p_from_date);
83: OKL_VARIABLE_INTEREST_PVT.print_Debug('To date : '|| p_to_date);
84:
85: OKL_VARIABLE_INTEREST_PVT.print_debug ('G_CALCULATION_FORMULA_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);

Line 82: OKL_VARIABLE_INTEREST_PVT.print_debug('From date : '|| p_from_date);

78:
79: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_FLOAT_FACTOR using following parameters : ');
80: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID : '|| p_contract_id);
81: OKL_VARIABLE_INTEREST_PVT.print_debug('g_contract_id : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
82: OKL_VARIABLE_INTEREST_PVT.print_debug('From date : '|| p_from_date);
83: OKL_VARIABLE_INTEREST_PVT.print_Debug('To date : '|| p_to_date);
84:
85: OKL_VARIABLE_INTEREST_PVT.print_debug ('G_CALCULATION_FORMULA_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
86:

Line 83: OKL_VARIABLE_INTEREST_PVT.print_Debug('To date : '|| p_to_date);

79: OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure VARIABLE_INTEREST_FLOAT_FACTOR using following parameters : ');
80: OKL_VARIABLE_INTEREST_PVT.print_debug('contract ID : '|| p_contract_id);
81: OKL_VARIABLE_INTEREST_PVT.print_debug('g_contract_id : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
82: OKL_VARIABLE_INTEREST_PVT.print_debug('From date : '|| p_from_date);
83: OKL_VARIABLE_INTEREST_PVT.print_Debug('To date : '|| p_to_date);
84:
85: OKL_VARIABLE_INTEREST_PVT.print_debug ('G_CALCULATION_FORMULA_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
86:
87: OPEN formula_name_csr (OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);

Line 85: OKL_VARIABLE_INTEREST_PVT.print_debug ('G_CALCULATION_FORMULA_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);

81: OKL_VARIABLE_INTEREST_PVT.print_debug('g_contract_id : '|| OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID);
82: OKL_VARIABLE_INTEREST_PVT.print_debug('From date : '|| p_from_date);
83: OKL_VARIABLE_INTEREST_PVT.print_Debug('To date : '|| p_to_date);
84:
85: OKL_VARIABLE_INTEREST_PVT.print_debug ('G_CALCULATION_FORMULA_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
86:
87: OPEN formula_name_csr (OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
88: FETCH formula_name_csr INTO l_formula_name;
89: IF (formula_name_csr%NOTFOUND) THEN

Line 87: OPEN formula_name_csr (OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);

83: OKL_VARIABLE_INTEREST_PVT.print_Debug('To date : '|| p_to_date);
84:
85: OKL_VARIABLE_INTEREST_PVT.print_debug ('G_CALCULATION_FORMULA_ID : '|| OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
86:
87: OPEN formula_name_csr (OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
88: FETCH formula_name_csr INTO l_formula_name;
89: IF (formula_name_csr%NOTFOUND) THEN
90: CLOSE formula_name_csr;
91: OKL_VARIABLE_INTEREST_PVT.Print_Debug( 'Unable to find formula for formula id :' || OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);

Line 91: OKL_VARIABLE_INTEREST_PVT.Print_Debug( 'Unable to find formula for formula id :' || OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);

87: OPEN formula_name_csr (OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
88: FETCH formula_name_csr INTO l_formula_name;
89: IF (formula_name_csr%NOTFOUND) THEN
90: CLOSE formula_name_csr;
91: OKL_VARIABLE_INTEREST_PVT.Print_Debug( 'Unable to find formula for formula id :' || OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
92: OKL_VARIABLE_INTEREST_PVT.print_error_message('Interest Params cursor did not return any records for formula ID: '|| OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
93: RAISE var_int_float_factor_failed;
94: END IF;
95: CLOSE formula_name_csr;

Line 92: OKL_VARIABLE_INTEREST_PVT.print_error_message('Interest Params cursor did not return any records for formula ID: '|| OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);

88: FETCH formula_name_csr INTO l_formula_name;
89: IF (formula_name_csr%NOTFOUND) THEN
90: CLOSE formula_name_csr;
91: OKL_VARIABLE_INTEREST_PVT.Print_Debug( 'Unable to find formula for formula id :' || OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
92: OKL_VARIABLE_INTEREST_PVT.print_error_message('Interest Params cursor did not return any records for formula ID: '|| OKL_VARIABLE_INTEREST_PVT.G_CALCULATION_FORMULA_ID);
93: RAISE var_int_float_factor_failed;
94: END IF;
95: CLOSE formula_name_csr;
96:

Line 97: OKL_VARIABLE_INTEREST_PVT.Print_Debug( 'Formula Name : '|| l_formula_name);

93: RAISE var_int_float_factor_failed;
94: END IF;
95: CLOSE formula_name_csr;
96:
97: OKL_VARIABLE_INTEREST_PVT.Print_Debug( 'Formula Name : '|| l_formula_name);
98:
99: FOR current_stream IN asset_billed_streams_csr (p_contract_id, p_from_date, p_to_date)
100: LOOP
101: l_line_id := current_stream.kle_id;

Line 105: OKL_VARIABLE_INTEREST_PVT.Print_debug( 'line id : '|| l_line_id);

101: l_line_id := current_stream.kle_id;
102: l_invoice_amt := 0;
103: l_stream_element_date := current_stream.stream_element_date;
104:
105: OKL_VARIABLE_INTEREST_PVT.Print_debug( 'line id : '|| l_line_id);
106: OKL_VARIABLE_INTEREST_PVT.Print_debug('Stream Element Date: '|| l_stream_element_date);
107:
108: Okl_Execute_Formula_Pub.G_ADDITIONAL_PARAMETERS(1).NAME := 'DUE_DATE';
109: Okl_Execute_Formula_Pub.G_ADDITIONAL_PARAMETERS(1).VALUE := l_stream_element_date;

Line 106: OKL_VARIABLE_INTEREST_PVT.Print_debug('Stream Element Date: '|| l_stream_element_date);

102: l_invoice_amt := 0;
103: l_stream_element_date := current_stream.stream_element_date;
104:
105: OKL_VARIABLE_INTEREST_PVT.Print_debug( 'line id : '|| l_line_id);
106: OKL_VARIABLE_INTEREST_PVT.Print_debug('Stream Element Date: '|| l_stream_element_date);
107:
108: Okl_Execute_Formula_Pub.G_ADDITIONAL_PARAMETERS(1).NAME := 'DUE_DATE';
109: Okl_Execute_Formula_Pub.G_ADDITIONAL_PARAMETERS(1).VALUE := l_stream_element_date;
110:

Line 125: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');

121: x_value => l_invoice_amt
122: );
123:
124: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
125: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');
126: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
127: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
128: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');
129: RAISE var_int_float_factor_failed;

Line 128: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');

124: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
125: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');
126: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
127: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
128: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');
129: RAISE var_int_float_factor_failed;
130: END IF;
131:
132: OKL_VARIABLE_INTEREST_PVT.Print_debug ('Formula executed successfully');

Line 132: OKL_VARIABLE_INTEREST_PVT.Print_debug ('Formula executed successfully');

128: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');
129: RAISE var_int_float_factor_failed;
130: END IF;
131:
132: OKL_VARIABLE_INTEREST_PVT.Print_debug ('Formula executed successfully');
133: OKL_VARIABLE_INTEREST_PVT.Print_debug (' Invoice Amount : '|| l_invoice_amt);
134:
135: l_stream_type_purpose := 'FLOAT_FACTOR_ADJUSTMENT';
136:

Line 133: OKL_VARIABLE_INTEREST_PVT.Print_debug (' Invoice Amount : '|| l_invoice_amt);

129: RAISE var_int_float_factor_failed;
130: END IF;
131:
132: OKL_VARIABLE_INTEREST_PVT.Print_debug ('Formula executed successfully');
133: OKL_VARIABLE_INTEREST_PVT.Print_debug (' Invoice Amount : '|| l_invoice_amt);
134:
135: l_stream_type_purpose := 'FLOAT_FACTOR_ADJUSTMENT';
136:
137: IF (l_invoice_amt <> 0) THEN

Line 154: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');

150: p_parent_strm_element_id => NULL,
151: x_invoice_id => l_invoice_id,
152: x_stream_element_id => l_stream_element_id);
153: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
154: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
155: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
157: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
158: RAISE var_int_float_factor_failed;

Line 157: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');

153: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
154: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
155: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
156: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
157: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
158: RAISE var_int_float_factor_failed;
159: END IF;
160: END IF;
161:

Line 182: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception var_int_float_factor_failed raised in procedure VARIABLE_INTEREST_FLOAT_FACTOR');

178: END LOOP;
179:
180: EXCEPTION
181: WHEN var_int_float_factor_failed THEN
182: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception var_int_float_factor_failed raised in procedure VARIABLE_INTEREST_FLOAT_FACTOR');
183: x_return_status := OKL_API.G_RET_STS_ERROR;
184: WHEN OTHERS THEN
185: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure VARIABLE_INTEREST_FLOAT_FACTOR');
186: Okl_Api.SET_MESSAGE(

Line 185: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure VARIABLE_INTEREST_FLOAT_FACTOR');

181: WHEN var_int_float_factor_failed THEN
182: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception var_int_float_factor_failed raised in procedure VARIABLE_INTEREST_FLOAT_FACTOR');
183: x_return_status := OKL_API.G_RET_STS_ERROR;
184: WHEN OTHERS THEN
185: OKL_VARIABLE_INTEREST_PVT.print_error_message('Exception raised in procedure VARIABLE_INTEREST_FLOAT_FACTOR');
186: Okl_Api.SET_MESSAGE(
187: p_app_name => G_APP_NAME,
188: p_msg_name => G_UNEXPECTED_ERROR,
189: p_token1 => G_SQLCODE_TOKEN,

Line 232: l_from_date := nvl(p_last_interest_cal_date,OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE);

228: ------------------------------------------------------------
229: -- Start processing
230: ------------------------------------------------------------
231:
232: l_from_date := nvl(p_last_interest_cal_date,OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_START_DATE);
233: l_to_date := nvl(p_to_date, trunc(SYSDATE));
234: --change on 15 Nov 2005 by pgomes for bug fix 4740293
235: --considering print lead days for obtaining end date of range
236: IF (l_to_date > trunc(SYSDATE) + p_print_lead_days) THEN

Line 240: OKL_VARIABLE_INTEREST_PVT.print_debug ('contract id : '|| p_contract_id );

236: IF (l_to_date > trunc(SYSDATE) + p_print_lead_days) THEN
237: l_to_date := trunc(SYSDATE) + p_print_lead_days;
238: END IF;
239:
240: OKL_VARIABLE_INTEREST_PVT.print_debug ('contract id : '|| p_contract_id );
241: OKL_VARIABLE_INTEREST_PVT.print_debug ('From Date : '|| l_from_date );
242: OKL_VARIABLE_INTEREST_PVT.print_debug ('To Date : '|| l_to_date);
243:
244: variable_interest_float_factor(

Line 241: OKL_VARIABLE_INTEREST_PVT.print_debug ('From Date : '|| l_from_date );

237: l_to_date := trunc(SYSDATE) + p_print_lead_days;
238: END IF;
239:
240: OKL_VARIABLE_INTEREST_PVT.print_debug ('contract id : '|| p_contract_id );
241: OKL_VARIABLE_INTEREST_PVT.print_debug ('From Date : '|| l_from_date );
242: OKL_VARIABLE_INTEREST_PVT.print_debug ('To Date : '|| l_to_date);
243:
244: variable_interest_float_factor(
245: p_api_version => 1.0,

Line 242: OKL_VARIABLE_INTEREST_PVT.print_debug ('To Date : '|| l_to_date);

238: END IF;
239:
240: OKL_VARIABLE_INTEREST_PVT.print_debug ('contract id : '|| p_contract_id );
241: OKL_VARIABLE_INTEREST_PVT.print_debug ('From Date : '|| l_from_date );
242: OKL_VARIABLE_INTEREST_PVT.print_debug ('To Date : '|| l_to_date);
243:
244: variable_interest_float_factor(
245: p_api_version => 1.0,
246: p_init_msg_list => OKL_API.G_TRUE,

Line 255: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INTEREST_FLOAT_FACTOR');

251: p_from_date => l_from_date,
252: p_to_date => l_to_date);
253:
254: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
255: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INTEREST_FLOAT_FACTOR');
256: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
257: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
258: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_FLOAT_FACTOR');
259: RAISE process_int_float_fctr_failed;

Line 258: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_FLOAT_FACTOR');

254: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
255: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INTEREST_FLOAT_FACTOR');
256: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
257: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
258: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_FLOAT_FACTOR');
259: RAISE process_int_float_fctr_failed;
260: END IF;
261:
262: OKL_VARIABLE_INTEREST_PVT.print_debug('Variable interest calculation completed successfully for contract id : '|| p_contract_id);

Line 262: OKL_VARIABLE_INTEREST_PVT.print_debug('Variable interest calculation completed successfully for contract id : '|| p_contract_id);

258: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_FLOAT_FACTOR');
259: RAISE process_int_float_fctr_failed;
260: END IF;
261:
262: OKL_VARIABLE_INTEREST_PVT.print_debug('Variable interest calculation completed successfully for contract id : '|| p_contract_id);
263:
264: EXCEPTION
265:
266: WHEN process_int_float_fctr_failed THEN

Line 267: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception process_int_float_fctr_failed raised in procedure PROCESS_INTEREST_FLOAT_FACTOR');

263:
264: EXCEPTION
265:
266: WHEN process_int_float_fctr_failed THEN
267: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception process_int_float_fctr_failed raised in procedure PROCESS_INTEREST_FLOAT_FACTOR');
268: x_return_status := OKL_API.G_RET_STS_ERROR;
269: WHEN OTHERS THEN
270: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure PROCESS_INTEREST_FLOAT_FACTOR');
271: Okl_Api.SET_MESSAGE(

Line 270: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure PROCESS_INTEREST_FLOAT_FACTOR');

266: WHEN process_int_float_fctr_failed THEN
267: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception process_int_float_fctr_failed raised in procedure PROCESS_INTEREST_FLOAT_FACTOR');
268: x_return_status := OKL_API.G_RET_STS_ERROR;
269: WHEN OTHERS THEN
270: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure PROCESS_INTEREST_FLOAT_FACTOR');
271: Okl_Api.SET_MESSAGE(
272: p_app_name => G_APP_NAME,
273: p_msg_name => G_UNEXPECTED_ERROR,
274: p_token1 => G_SQLCODE_TOKEN,