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_API

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

27: p_to_date IN DATE) IS
28:
29: l_api_version CONSTANT NUMBER := 1.0;
30: l_api_name CONSTANT VARCHAR2(30) := 'VARIABLE_INTEREST_FLOAT_FACTOR';
31: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
32: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
33: l_invoice_amt NUMBER := 0;
34: l_formula_id OKL_FORMULAE_V.id%TYPE;
35: l_formula_name OKL_FORMULAE_V.name%TYPE;

Line 77: x_return_status := OKL_API.G_RET_STS_SUCCESS;

73: ------------------------------------------------------------
74: -- Start processing
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);

Line 114: p_init_msg_list => OKL_API.G_TRUE,

110:
111: -- Apply FLoat factor formula
112: Okl_Execute_Formula_Pub.EXECUTE(
113: p_api_version => p_api_version,
114: p_init_msg_list => OKL_API.G_TRUE,
115: x_return_status => x_return_status,
116: x_msg_count => x_msg_count,
117: x_msg_data => x_msg_data,
118: p_formula_name => l_formula_name,

Line 124: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

120: p_line_id => l_line_id,
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');

Line 126: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
130: END IF;

Line 127: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
130: END IF;
131:

Line 149: p_create_invoice_flag => OKL_API.G_TRUE,

145: p_line_id => l_line_id,
146: p_amount => l_invoice_amt,
147: p_due_date => l_stream_element_date,
148: p_stream_type_purpose => l_stream_type_purpose,
149: p_create_invoice_flag => OKL_API.G_TRUE,
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

Line 153: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

149: p_create_invoice_flag => OKL_API.G_TRUE,
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');

Line 155: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
159: END IF;

Line 156: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
159: END IF;
160: END IF;

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

166: x_msg_count => x_msg_count,
167: x_msg_data => x_msg_data,
168: p_contract_id => p_contract_id,
169: p_last_interest_cal_date => l_stream_element_date);
170: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
173: RAISE OKL_API.G_EXCEPTION_ERROR;
174: END IF;

Line 171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

167: x_msg_data => x_msg_data,
168: p_contract_id => p_contract_id,
169: p_last_interest_cal_date => l_stream_element_date);
170: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
173: RAISE OKL_API.G_EXCEPTION_ERROR;
174: END IF;
175:

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

168: p_contract_id => p_contract_id,
169: p_last_interest_cal_date => l_stream_element_date);
170: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
173: RAISE OKL_API.G_EXCEPTION_ERROR;
174: END IF;
175:
176: COMMIT;

Line 173: RAISE OKL_API.G_EXCEPTION_ERROR;

169: p_last_interest_cal_date => l_stream_element_date);
170: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
172: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
173: RAISE OKL_API.G_EXCEPTION_ERROR;
174: END IF;
175:
176: COMMIT;
177:

Line 183: x_return_status := OKL_API.G_RET_STS_ERROR;

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(
187: p_app_name => G_APP_NAME,

Line 186: Okl_Api.SET_MESSAGE(

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,
190: p_token1_value => SQLCODE,

Line 194: x_return_status := OKL_API.G_RET_STS_ERROR;

190: p_token1_value => SQLCODE,
191: p_token2 => G_SQLERRM_TOKEN,
192: p_token2_value => SQLERRM);
193:
194: x_return_status := OKL_API.G_RET_STS_ERROR;
195:
196: END variable_interest_float_factor;
197:
198: -----------------------------------------------------------------

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

214: ------------------------------------------------------------
215:
216: l_api_version CONSTANT NUMBER := 1.0;
217: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_INTEREST_FLOAT_FACTOR';
218: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
219: l_msg_data VARCHAR2(2000);
220:
221: l_from_date DATE;
222: l_to_date DATE;

Line 246: p_init_msg_list => OKL_API.G_TRUE,

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,
247: x_return_status => x_return_status,
248: x_msg_count => x_msg_count,
249: x_msg_data => x_msg_data,
250: p_contract_id => p_contract_id,

Line 254: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

250: p_contract_id => p_contract_id,
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');

Line 256: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;
260: END IF;

Line 257: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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;
260: END IF;
261:

Line 268: x_return_status := OKL_API.G_RET_STS_ERROR;

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(
272: p_app_name => G_APP_NAME,

Line 271: Okl_Api.SET_MESSAGE(

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,
275: p_token1_value => SQLCODE,

Line 278: x_return_status := OKL_API.G_RET_STS_ERROR;

274: p_token1 => G_SQLCODE_TOKEN,
275: p_token1_value => SQLCODE,
276: p_token2 => G_SQLERRM_TOKEN,
277: p_token2_value => SQLERRM);
278: x_return_status := OKL_API.G_RET_STS_ERROR;
279:
280: END process_interest_float_factor;
281: END;