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_PYMNT_PVT dependencies on OKL_DEBUG_PUB

Line 139: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

135: l_api_version CONSTANT NUMBER := 1;
136: l_api_name CONSTANT VARCHAR2(30) := 'get_payment_summary';
137:
138: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_payment_summary';
139: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
140: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
141: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
142: BEGIN
143:

Line 140: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

136: l_api_name CONSTANT VARCHAR2(30) := 'get_payment_summary';
137:
138: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_payment_summary';
139: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
140: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
141: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
142: BEGIN
143:
144: IF (is_debug_procedure_on) THEN

Line 141: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

137:
138: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_payment_summary';
139: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
140: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
141: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
142: BEGIN
143:
144: IF (is_debug_procedure_on) THEN
145: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 145: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

141: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
142: BEGIN
143:
144: IF (is_debug_procedure_on) THEN
145: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
146: END IF;
147:
148: --Print Input Variables
149: IF (is_debug_statement_on) THEN

Line 150: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

146: END IF;
147:
148: --Print Input Variables
149: IF (is_debug_statement_on) THEN
150: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
151: 'p_qte_id :'||p_qte_id);
152:
153: END IF;
154:

Line 211: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

207:
208: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
209:
210: IF (is_debug_procedure_on) THEN
211: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
212: END IF;
213:
214: EXCEPTION
215: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 217: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

213:
214: EXCEPTION
215: WHEN OKL_API.G_EXCEPTION_ERROR THEN
216: IF (is_debug_exception_on) THEN
217: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
218: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
219: END IF;
220:
221: IF l_pymtsummary_csr%ISOPEN THEN

Line 227: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

223: END IF;
224: x_return_status := OKL_API.G_RET_STS_ERROR;
225: WHEN OTHERS THEN
226: IF (is_debug_exception_on) THEN
227: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
228: 'EXCEPTION :'||sqlerrm);
229: END IF;
230: -- Close open cursors
231:

Line 332: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

328: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
329: l_dummy VARCHAR2(1);
330:
331: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_cash_flow_object';
332: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
333: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
334: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
335: BEGIN
336:

Line 333: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

329: l_dummy VARCHAR2(1);
330:
331: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_cash_flow_object';
332: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
333: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
334: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
335: BEGIN
336:
337: IF (is_debug_procedure_on) THEN

Line 334: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

330:
331: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_cash_flow_object';
332: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
333: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
334: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
335: BEGIN
336:
337: IF (is_debug_procedure_on) THEN
338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

334: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
335: BEGIN
336:
337: IF (is_debug_procedure_on) THEN
338: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
339: END IF;
340:
341: --Print Input Variables
342: IF (is_debug_statement_on) THEN

Line 343: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

339: END IF;
340:
341: --Print Input Variables
342: IF (is_debug_statement_on) THEN
343: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
344: 'p_obj_type_code :'||p_obj_type_code);
345: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
346: 'p_src_table :'||p_src_table);
347: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 345: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

341: --Print Input Variables
342: IF (is_debug_statement_on) THEN
343: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
344: 'p_obj_type_code :'||p_obj_type_code);
345: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
346: 'p_src_table :'||p_src_table);
347: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
348: 'p_src_id :'||p_src_id);
349: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 347: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

343: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
344: 'p_obj_type_code :'||p_obj_type_code);
345: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
346: 'p_src_table :'||p_src_table);
347: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
348: 'p_src_id :'||p_src_id);
349: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
350: 'p_base_src_id :'||p_base_src_id);
351: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 349: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

345: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
346: 'p_src_table :'||p_src_table);
347: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
348: 'p_src_id :'||p_src_id);
349: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
350: 'p_base_src_id :'||p_base_src_id);
351: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
352: 'p_sts_code :'||p_sts_code);
353: END IF;

Line 351: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

347: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
348: 'p_src_id :'||p_src_id);
349: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
350: 'p_base_src_id :'||p_base_src_id);
351: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
352: 'p_sts_code :'||p_sts_code);
353: END IF;
354:
355: -- Check if Object already exists

Line 391: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'end(-)');

387:
388: x_return_status := l_return_status;
389:
390: IF (is_debug_procedure_on) THEN
391: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'end(-)');
392: END IF;
393:
394: EXCEPTION
395: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

394: EXCEPTION
395: WHEN OKL_API.G_EXCEPTION_ERROR THEN
396:
397: IF (is_debug_exception_on) THEN
398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
399: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
400: END IF;
401:
402: IF l_cash_flow_objects_csr%ISOPEN THEN

Line 409: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

405: x_return_status := OKL_API.G_RET_STS_ERROR;
406: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
407:
408: IF (is_debug_exception_on) THEN
409: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
410: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
411: END IF;
412:
413: IF l_cash_flow_objects_csr%ISOPEN THEN

Line 420: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

416: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
417: WHEN OTHERS THEN
418:
419: IF (is_debug_exception_on) THEN
420: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
421: 'EXCEPTION :'||sqlerrm);
422: END IF;
423:
424: IF l_cash_flow_objects_csr%ISOPEN THEN

Line 516: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

512: l_amount NUMBER;
513: l_stub_amount NUMBER;
514:
515: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_cash_flows';
516: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
517: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
518: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
519: BEGIN
520:

Line 517: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

513: l_stub_amount NUMBER;
514:
515: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_cash_flows';
516: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
517: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
518: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
519: BEGIN
520:
521: IF (is_debug_procedure_on) THEN

Line 518: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

514:
515: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'create_cash_flows';
516: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
517: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
518: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
519: BEGIN
520:
521: IF (is_debug_procedure_on) THEN
522: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 522: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

518: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
519: BEGIN
520:
521: IF (is_debug_procedure_on) THEN
522: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
523: END IF;
524:
525: --Print Input Variables
526: IF (is_debug_statement_on) THEN

Line 527: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

523: END IF;
524:
525: --Print Input Variables
526: IF (is_debug_statement_on) THEN
527: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
528: 'p_cashflow_rec.p_cfo_id :'||p_cashflow_rec.p_cfo_id);
529: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
530: 'p_cashflow_rec.p_sts_code :'||p_cashflow_rec.p_sts_code);
531: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 529: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

525: --Print Input Variables
526: IF (is_debug_statement_on) THEN
527: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
528: 'p_cashflow_rec.p_cfo_id :'||p_cashflow_rec.p_cfo_id);
529: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
530: 'p_cashflow_rec.p_sts_code :'||p_cashflow_rec.p_sts_code);
531: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
532: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 531: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

527: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
528: 'p_cashflow_rec.p_cfo_id :'||p_cashflow_rec.p_cfo_id);
529: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
530: 'p_cashflow_rec.p_sts_code :'||p_cashflow_rec.p_sts_code);
531: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
532: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
534: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

529: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
530: 'p_cashflow_rec.p_sts_code :'||p_cashflow_rec.p_sts_code);
531: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
532: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
534: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
536: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
537: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

531: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
532: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
534: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
536: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
537: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
538: 'p_cashflow_rec.p_due_arrears_yn :'||p_cashflow_rec.p_due_arrears_yn);
539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 537: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

533: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
534: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
536: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
537: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
538: 'p_cashflow_rec.p_due_arrears_yn :'||p_cashflow_rec.p_due_arrears_yn);
539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
540: 'p_cashflow_rec.p_start_date :'||p_cashflow_rec.p_start_date);
541: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

535: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
536: 'p_cashflow_rec.p_sty_id :'||p_cashflow_rec.p_sty_id);
537: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
538: 'p_cashflow_rec.p_due_arrears_yn :'||p_cashflow_rec.p_due_arrears_yn);
539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
540: 'p_cashflow_rec.p_start_date :'||p_cashflow_rec.p_start_date);
541: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
542: 'p_cashflow_rec.p_advance_periods :'||p_cashflow_rec.p_advance_periods);
543: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 541: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

537: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
538: 'p_cashflow_rec.p_due_arrears_yn :'||p_cashflow_rec.p_due_arrears_yn);
539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
540: 'p_cashflow_rec.p_start_date :'||p_cashflow_rec.p_start_date);
541: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
542: 'p_cashflow_rec.p_advance_periods :'||p_cashflow_rec.p_advance_periods);
543: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
544: 'p_cashflow_rec.p_khr_id :'||p_cashflow_rec.p_khr_id);
545: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 543: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

539: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
540: 'p_cashflow_rec.p_start_date :'||p_cashflow_rec.p_start_date);
541: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
542: 'p_cashflow_rec.p_advance_periods :'||p_cashflow_rec.p_advance_periods);
543: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
544: 'p_cashflow_rec.p_khr_id :'||p_cashflow_rec.p_khr_id);
545: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
546: 'p_cashflow_rec.p_quote_id :'||p_cashflow_rec.p_quote_id);
547: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 545: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

541: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
542: 'p_cashflow_rec.p_advance_periods :'||p_cashflow_rec.p_advance_periods);
543: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
544: 'p_cashflow_rec.p_khr_id :'||p_cashflow_rec.p_khr_id);
545: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
546: 'p_cashflow_rec.p_quote_id :'||p_cashflow_rec.p_quote_id);
547: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
548: 'p_cashflow_rec.p_amount :'||p_cashflow_rec.p_amount);
549: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 547: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

543: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
544: 'p_cashflow_rec.p_khr_id :'||p_cashflow_rec.p_khr_id);
545: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
546: 'p_cashflow_rec.p_quote_id :'||p_cashflow_rec.p_quote_id);
547: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
548: 'p_cashflow_rec.p_amount :'||p_cashflow_rec.p_amount);
549: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
550: 'p_cashflow_rec.p_period_in_months :'||p_cashflow_rec.p_period_in_months);
551: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 549: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

545: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
546: 'p_cashflow_rec.p_quote_id :'||p_cashflow_rec.p_quote_id);
547: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
548: 'p_cashflow_rec.p_amount :'||p_cashflow_rec.p_amount);
549: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
550: 'p_cashflow_rec.p_period_in_months :'||p_cashflow_rec.p_period_in_months);
551: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
552: 'p_cashflow_rec.p_frequency :'||p_cashflow_rec.p_frequency);
553: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 551: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

547: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
548: 'p_cashflow_rec.p_amount :'||p_cashflow_rec.p_amount);
549: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
550: 'p_cashflow_rec.p_period_in_months :'||p_cashflow_rec.p_period_in_months);
551: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
552: 'p_cashflow_rec.p_frequency :'||p_cashflow_rec.p_frequency);
553: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
554: 'p_cashflow_rec.p_seq_num :'||p_cashflow_rec.p_seq_num);
555: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 553: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

549: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
550: 'p_cashflow_rec.p_period_in_months :'||p_cashflow_rec.p_period_in_months);
551: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
552: 'p_cashflow_rec.p_frequency :'||p_cashflow_rec.p_frequency);
553: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
554: 'p_cashflow_rec.p_seq_num :'||p_cashflow_rec.p_seq_num);
555: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
556: 'p_cashflow_rec.p_stub_days :'||p_cashflow_rec.p_stub_days);
557: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 555: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

551: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
552: 'p_cashflow_rec.p_frequency :'||p_cashflow_rec.p_frequency);
553: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
554: 'p_cashflow_rec.p_seq_num :'||p_cashflow_rec.p_seq_num);
555: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
556: 'p_cashflow_rec.p_stub_days :'||p_cashflow_rec.p_stub_days);
557: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
558: 'px_new_cash_flow :'||px_new_cash_flow);
559:

Line 557: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

553: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
554: 'p_cashflow_rec.p_seq_num :'||p_cashflow_rec.p_seq_num);
555: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
556: 'p_cashflow_rec.p_stub_days :'||p_cashflow_rec.p_stub_days);
557: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
558: 'px_new_cash_flow :'||px_new_cash_flow);
559:
560: END IF;
561:

Line 670: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

666:
667: END IF;
668: x_return_status := l_return_status;
669: IF (is_debug_procedure_on) THEN
670: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
671: END IF;
672:
673: EXCEPTION
674: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 677: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

673: EXCEPTION
674: WHEN OKL_API.G_EXCEPTION_ERROR THEN
675:
676: IF (is_debug_exception_on) THEN
677: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
678: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
679: END IF;
680:
681: IF l_cashflow_csr%ISOPEN THEN

Line 691: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

687: x_return_status := OKL_API.G_RET_STS_ERROR;
688: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
689:
690: IF (is_debug_exception_on) THEN
691: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
692: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
693: END IF;
694:
695: IF l_cashflow_csr%ISOPEN THEN

Line 705: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

701: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
702: WHEN OTHERS THEN
703:
704: IF (is_debug_exception_on) THEN
705: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
706: 'EXCEPTION :'||sqlerrm);
707: END IF;
708:
709: IF l_cashflow_csr%ISOPEN THEN

Line 892: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

888: lx_new_cash_flow VARCHAR2(1);
889:
890: l_prev_sty_id NUMBER := -99;
891: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_current_payments';
892: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
893: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
894: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
895: BEGIN
896:

Line 893: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

889:
890: l_prev_sty_id NUMBER := -99;
891: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_current_payments';
892: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
893: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
894: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
895: BEGIN
896:
897: IF (is_debug_procedure_on) THEN

Line 894: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

890: l_prev_sty_id NUMBER := -99;
891: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'get_current_payments';
892: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
893: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
894: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
895: BEGIN
896:
897: IF (is_debug_procedure_on) THEN
898: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 898: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

894: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
895: BEGIN
896:
897: IF (is_debug_procedure_on) THEN
898: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
899: END IF;
900:
901: --Print Input Variables
902: IF (is_debug_statement_on) THEN

Line 903: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

899: END IF;
900:
901: --Print Input Variables
902: IF (is_debug_statement_on) THEN
903: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
904: 'p_quote_id :'||p_quote_id);
905: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
906: 'p_khr_id :'||p_khr_id );
907:

Line 905: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

901: --Print Input Variables
902: IF (is_debug_statement_on) THEN
903: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
904: 'p_quote_id :'||p_quote_id);
905: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
906: 'p_khr_id :'||p_khr_id );
907:
908: END IF;
909:

Line 933: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

929: x_cfo_id => l_cfo_id,
930: x_return_status => l_return_status);
931:
932: IF (is_debug_statement_on) THEN
933: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
934: 'after call to create_cash_flow_object :'||l_return_status);
935: END IF;
936:
937: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 985: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

981: px_new_cash_flow => lx_new_cash_flow,
982: x_return_status => l_return_status);
983:
984: IF (is_debug_statement_on) THEN
985: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
986: 'after call to create_cash_flows :'||l_return_status);
987: END IF;
988:
989: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1037: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1033: x_cfo_id => l_cfo_id,
1034: x_return_status => l_return_status);
1035:
1036: IF (is_debug_statement_on) THEN
1037: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1038: 'after call to create_cash_flow_object :'||l_return_status);
1039: END IF;
1040:
1041:

Line 1087: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1083: px_new_cash_flow => lx_new_cash_flow,
1084: x_return_status => l_return_status);
1085:
1086: IF (is_debug_statement_on) THEN
1087: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1088: 'after call to create_cash_flows :'||l_return_status);
1089: END IF;
1090:
1091: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1127: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1123: x_cfo_id => l_cfo_id,
1124: x_return_status => l_return_status);
1125:
1126: IF (is_debug_statement_on) THEN
1127: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1128: 'after call to create_cash_flow_object :'||l_return_status);
1129: END IF;
1130: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1176: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1172: px_new_cash_flow => lx_new_cash_flow,
1173: x_return_status => l_return_status);
1174:
1175: IF (is_debug_statement_on) THEN
1176: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1177: 'after call to create_cash_flows :'||l_return_status);
1178: END IF;
1179: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1219: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1215: x_cfo_id => l_cfo_id,
1216: x_return_status => l_return_status);
1217:
1218: IF (is_debug_statement_on) THEN
1219: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1220: 'after call to create_cash_flow_object :'||l_return_status);
1221: END IF;
1222:
1223: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

Line 1268: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1264: px_new_cash_flow => lx_new_cash_flow,
1265: x_return_status => l_return_status);
1266:
1267: IF (is_debug_statement_on) THEN
1268: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1269: 'after call to create_cash_flows :'||l_return_status);
1270: END IF;
1271: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1272: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1296: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1292: p_cfov_tbl => g_cfov_tbl_type,
1293: x_cfov_tbl => gx_cfov_tbl_type);
1294:
1295: IF (is_debug_statement_on) THEN
1296: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1297: 'after call to okl_cfo_pvt.insert_row_bulk :'||l_return_status);
1298: END IF;
1299:
1300: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1315: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1311: p_qcov_tbl => g_qcov_tbl_type,
1312: x_qcov_tbl => gx_qcov_tbl_type);
1313:
1314: IF (is_debug_statement_on) THEN
1315: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1316: 'after call to okl_cfo_pvt.insert_row_bulk :'||l_return_status);
1317: END IF;
1318:
1319: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1334: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1330: p_cafv_tbl => g_cafv_tbl_type,
1331: x_cafv_tbl => gx_cafv_tbl_type);
1332:
1333: IF (is_debug_statement_on) THEN
1334: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1335: 'after call to okl_cfo_pvt.insert_row_bulk :'||l_return_status);
1336: END IF;
1337:
1338: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1353: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1349: p_cflv_tbl => g_cflv_tbl_type,
1350: x_cflv_tbl => gx_cflv_tbl_type);
1351:
1352: IF (is_debug_statement_on) THEN
1353: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1354: 'after call to okl_cfo_pvt.insert_row_bulk :'||l_return_status);
1355: END IF;
1356:
1357: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1368: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

1364: -- set the return status and out variables
1365: x_return_status := l_return_status;
1366:
1367: IF (is_debug_procedure_on) THEN
1368: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
1369: END IF;
1370: EXCEPTION
1371: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1372: IF (is_debug_exception_on) THEN

Line 1373: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

1369: END IF;
1370: EXCEPTION
1371: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1372: IF (is_debug_exception_on) THEN
1373: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
1374: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
1375: END IF;
1376:
1377:

Line 1396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

1392: END IF;
1393: x_return_status := OKL_API.G_RET_STS_ERROR;
1394: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1395: IF (is_debug_exception_on) THEN
1396: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
1397: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1398: END IF;
1399:
1400: IF l_kpayments_csr%ISOPEN THEN

Line 1417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

1413: END IF;
1414: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1415: WHEN OTHERS THEN
1416: IF (is_debug_exception_on) THEN
1417: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
1418: 'EXCEPTION :'||sqlerrm);
1419: END IF;
1420:
1421: IF l_kpayments_csr%ISOPEN THEN

Line 1564: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

1560: --SECHAWLA 20-SEP-04 3816891 : new declaration
1561: l_months_to_check_last_day NUMBER;
1562:
1563: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'calc_prop_line_payments';
1564: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1565: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1566: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1567: BEGIN
1568: IF (is_debug_procedure_on) THEN

Line 1565: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

1561: l_months_to_check_last_day NUMBER;
1562:
1563: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'calc_prop_line_payments';
1564: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1565: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1566: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1567: BEGIN
1568: IF (is_debug_procedure_on) THEN
1569: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 1566: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

1562:
1563: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'calc_prop_line_payments';
1564: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1565: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1566: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1567: BEGIN
1568: IF (is_debug_procedure_on) THEN
1569: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1570: END IF;

Line 1569: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

1565: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1566: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
1567: BEGIN
1568: IF (is_debug_procedure_on) THEN
1569: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
1570: END IF;
1571:
1572: --Print Input Variables
1573: IF (is_debug_statement_on) THEN

Line 1574: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1570: END IF;
1571:
1572: --Print Input Variables
1573: IF (is_debug_statement_on) THEN
1574: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1575: 'p_curr_cfo_id :'||p_curr_cfo_id);
1576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1577: 'p_prop_obj_type_code :'||p_prop_obj_type_code);
1578: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 1576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1572: --Print Input Variables
1573: IF (is_debug_statement_on) THEN
1574: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1575: 'p_curr_cfo_id :'||p_curr_cfo_id);
1576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1577: 'p_prop_obj_type_code :'||p_prop_obj_type_code);
1578: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1579: 'p_prop_base_source_id :'||p_prop_base_source_id);
1580: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 1578: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1574: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1575: 'p_curr_cfo_id :'||p_curr_cfo_id);
1576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1577: 'p_prop_obj_type_code :'||p_prop_obj_type_code);
1578: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1579: 'p_prop_base_source_id :'||p_prop_base_source_id);
1580: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1581: 'p_prorate_ratio :'||p_prorate_ratio);
1582: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 1580: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1577: 'p_prop_obj_type_code :'||p_prop_obj_type_code);
1578: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1579: 'p_prop_base_source_id :'||p_prop_base_source_id);
1580: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1581: 'p_prorate_ratio :'||p_prorate_ratio);
1582: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1583: 'p_date_eff_from :'||p_date_eff_from);
1584: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 1582: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1578: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1579: 'p_prop_base_source_id :'||p_prop_base_source_id);
1580: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1581: 'p_prorate_ratio :'||p_prorate_ratio);
1582: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1583: 'p_date_eff_from :'||p_date_eff_from);
1584: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1585: 'p_quote_id :'||p_quote_id);
1586: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 1584: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1580: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1581: 'p_prorate_ratio :'||p_prorate_ratio);
1582: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1583: 'p_date_eff_from :'||p_date_eff_from);
1584: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1585: 'p_quote_id :'||p_quote_id);
1586: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1587: 'p_khr_id :'||p_khr_id);
1588: END IF;

Line 1586: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1582: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1583: 'p_date_eff_from :'||p_date_eff_from);
1584: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1585: 'p_quote_id :'||p_quote_id);
1586: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1587: 'p_khr_id :'||p_khr_id);
1588: END IF;
1589:
1590: l_pymt_Count := 0;

Line 1610: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1606: x_cfo_id => l_cfo_id,
1607: x_return_status => l_return_status);
1608:
1609: IF (is_debug_statement_on) THEN
1610: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1611: 'after call to create_cash_flow_object :'||l_return_status);
1612: END IF;
1613:
1614: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1683: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1679: px_new_cash_flow => lx_new_cash_flow,
1680: x_return_status => l_return_status);
1681:
1682: IF (is_debug_statement_on) THEN
1683: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1684: 'after call to create_cash_flows:'||l_return_status);
1685: END IF;
1686:
1687: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1748: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1744: px_new_cash_flow => lx_new_cash_flow,
1745: x_return_status => l_return_status);
1746:
1747: IF (is_debug_statement_on) THEN
1748: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1749: 'after call to create_cash_flows :'||l_return_status);
1750: END IF;
1751:
1752: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1906: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

1902: px_new_cash_flow => lx_new_cash_flow,
1903: x_return_status => l_return_status);
1904:
1905: IF (is_debug_statement_on) THEN
1906: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1907: 'after call to create_cash_flows :'||l_return_status);
1908: END IF;
1909:
1910: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2011: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2007: px_new_cash_flow => lx_new_cash_flow,
2008: x_return_status => l_return_status);
2009:
2010: IF (is_debug_statement_on) THEN
2011: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2012: 'after call to create_cash_flows :'||l_return_status);
2013: END IF;
2014:
2015: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2037: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

2033:
2034: x_return_status := l_return_status;
2035:
2036: IF (is_debug_procedure_on) THEN
2037: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
2038: END IF;
2039:
2040: EXCEPTION
2041: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 2044: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

2040: EXCEPTION
2041: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2042:
2043: IF (is_debug_exception_on) THEN
2044: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
2045: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
2046: END IF;
2047:
2048: IF l_cashflows_csr%ISOPEN THEN

Line 2062: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

2058: x_return_status := OKL_API.G_RET_STS_ERROR;
2059: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2060:
2061: IF (is_debug_exception_on) THEN
2062: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
2063: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
2064: END IF;
2065:
2066: IF l_cashflows_csr%ISOPEN THEN

Line 2080: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

2076: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2077: WHEN OTHERS THEN
2078:
2079: IF (is_debug_exception_on) THEN
2080: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
2081: 'EXCEPTION :'||sqlerrm);
2082: END IF;
2083:
2084: IF l_cashflows_csr%ISOPEN THEN

Line 2235: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

2231:
2232: l_fin_asset_id NUMBER;
2233: lp_cashflow_rec cashflow_rec_type;
2234: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'calc_proposed_payments';
2235: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2236: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2237: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2238: BEGIN
2239:

Line 2236: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

2232: l_fin_asset_id NUMBER;
2233: lp_cashflow_rec cashflow_rec_type;
2234: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'calc_proposed_payments';
2235: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2236: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2237: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2238: BEGIN
2239:
2240:

Line 2237: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

2233: lp_cashflow_rec cashflow_rec_type;
2234: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'calc_proposed_payments';
2235: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
2236: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
2237: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
2238: BEGIN
2239:
2240:
2241: IF (is_debug_procedure_on) THEN

Line 2242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

2238: BEGIN
2239:
2240:
2241: IF (is_debug_procedure_on) THEN
2242: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
2243: END IF;
2244:
2245: --Print Input Variables
2246: IF (is_debug_statement_on) THEN

Line 2247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2243: END IF;
2244:
2245: --Print Input Variables
2246: IF (is_debug_statement_on) THEN
2247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2248: 'p_quote_id :'||p_quote_id);
2249: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2250: 'p_khr_id :'||p_khr_id);
2251: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 2249: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2245: --Print Input Variables
2246: IF (is_debug_statement_on) THEN
2247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2248: 'p_quote_id :'||p_quote_id);
2249: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2250: 'p_khr_id :'||p_khr_id);
2251: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2252: 'p_date_eff_from :'||p_date_eff_from);
2253: END IF;

Line 2251: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2247: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2248: 'p_quote_id :'||p_quote_id);
2249: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2250: 'p_khr_id :'||p_khr_id);
2251: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2252: 'p_date_eff_from :'||p_date_eff_from);
2253: END IF;
2254:
2255: -------------------------- Get proposed K Level payments ----------------------------------

Line 2282: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2278: x_cfo_id => l_cfo_id,
2279: x_return_status => l_return_status);
2280:
2281: IF (is_debug_statement_on) THEN
2282: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2283: 'after call to create_cash_flow_object :'||l_return_status);
2284: END IF;
2285:
2286:

Line 2332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2328: px_new_cash_flow => lx_new_cash_flow,
2329: x_return_status => l_return_status);
2330:
2331: IF (is_debug_statement_on) THEN
2332: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2333: 'after call to create_cash_flows:'||l_return_status);
2334: END IF;
2335:
2336: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2374: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2370: p_khr_id => p_khr_id ,
2371: x_return_status => l_return_status);
2372:
2373: IF (is_debug_statement_on) THEN
2374: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2375: 'after call to calc_prop_line_payments :'||l_return_status);
2376: END IF;
2377: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2378: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2404: x_cfo_id => l_cfo_id,
2405: x_return_status => l_return_status);
2406:
2407: IF (is_debug_statement_on) THEN
2408: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2409: 'after call to calc_prop_line_payments :'||l_return_status);
2410: END IF;
2411:
2412:

Line 2458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2454: px_new_cash_flow => lx_new_cash_flow,
2455: x_return_status => l_return_status);
2456:
2457: IF (is_debug_statement_on) THEN
2458: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2459: 'after call to create_cash_flows :'||l_return_status);
2460: END IF;
2461:
2462:

Line 2505: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2501: x_value => l_curr_cap_cost);
2502:
2503:
2504: IF (is_debug_statement_on) THEN
2505: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2506: 'after call to OKL_EXECUTE_FORMULA_PUB.EXECUTE :'||l_return_status);
2507: END IF;
2508:
2509: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2553: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2549: p_khr_id => p_khr_id ,
2550: x_return_status => l_return_status);
2551:
2552: IF (is_debug_statement_on) THEN
2553: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2554: 'after call to calc_prop_line_payments :'||l_return_status);
2555: END IF;
2556:
2557: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2592: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2588: x_cfo_id => l_cfo_id,
2589: x_return_status => l_return_status);
2590:
2591: IF (is_debug_statement_on) THEN
2592: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2593: 'after call to create_cash_flow_object :'||l_return_status);
2594: END IF;
2595:
2596: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2641: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2637: px_new_cash_flow => lx_new_cash_flow,
2638: x_return_status => l_return_status);
2639:
2640: IF (is_debug_statement_on) THEN
2641: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2642: 'after call to create_cash_flows :'||l_return_status);
2643: END IF;
2644:
2645:

Line 2726: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2722: p_khr_id => p_khr_id ,
2723: x_return_status => l_return_status);
2724:
2725: IF (is_debug_statement_on) THEN
2726: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2727: 'after call to calc_prop_line_payments :'||l_return_status);
2728: END IF;
2729:
2730: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2766: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2762: x_cfo_id => l_cfo_id,
2763: x_return_status => l_return_status);
2764:
2765: IF (is_debug_statement_on) THEN
2766: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2767: 'after call to create_cash_flow_object :'||l_return_status);
2768: END IF;
2769:
2770: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2811: px_new_cash_flow => lx_new_cash_flow,
2812: x_return_status => l_return_status);
2813:
2814: IF (is_debug_statement_on) THEN
2815: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2816: 'after call to create_cash_flows :'||l_return_status);
2817: END IF;
2818:
2819: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

2859: p_khr_id => p_khr_id ,
2860: x_return_status => l_return_status);
2861:
2862: IF (is_debug_statement_on) THEN
2863: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2864: 'after call to calc_prop_line_payments :'||l_return_status);
2865: END IF;
2866:
2867: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3124: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

3120: x_return_status := l_return_status;
3121: --Bug #3921591: pagarg +++ Rollover +++++++ End ++++++++++
3122:
3123: IF (is_debug_procedure_on) THEN
3124: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
3125: END IF;
3126:
3127: EXCEPTION
3128: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3131: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

3127: EXCEPTION
3128: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3129:
3130: IF (is_debug_exception_on) THEN
3131: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
3132: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3133: END IF;
3134:
3135: IF l_currpymtlines_csr%ISOPEN THEN

Line 3157: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

3153: x_return_status := OKL_API.G_RET_STS_ERROR;
3154: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3155:
3156: IF (is_debug_exception_on) THEN
3157: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
3158: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3159: END IF;
3160:
3161: IF l_currpymtlines_csr%ISOPEN THEN

Line 3183: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

3179: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3180: WHEN OTHERS THEN
3181:
3182: IF (is_debug_exception_on) THEN
3183: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
3184: 'EXCEPTION :'||sqlerrm);
3185: END IF;
3186:
3187: IF l_currpymtlines_csr%ISOPEN THEN

Line 3272: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

3268:
3269: l_khr_id NUMBER;
3270: l_date_eff_from DATE;
3271: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'calc_quote_payments';
3272: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
3273: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
3274: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
3275: BEGIN
3276:

Line 3273: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

3269: l_khr_id NUMBER;
3270: l_date_eff_from DATE;
3271: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'calc_quote_payments';
3272: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
3273: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
3274: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
3275: BEGIN
3276:
3277: IF (is_debug_procedure_on) THEN

Line 3274: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

3270: l_date_eff_from DATE;
3271: L_MODULE_NAME VARCHAR2(500) := G_MODULE_NAME||'calc_quote_payments';
3272: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
3273: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
3274: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
3275: BEGIN
3276:
3277: IF (is_debug_procedure_on) THEN
3278: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

Line 3278: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');

3274: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);
3275: BEGIN
3276:
3277: IF (is_debug_procedure_on) THEN
3278: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begin(+)');
3279: END IF;
3280:
3281:
3282: --Print Input Variables

Line 3284: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

3280:
3281:
3282: --Print Input Variables
3283: IF (is_debug_statement_on) THEN
3284: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3285: 'p_quote_id :'||p_quote_id);
3286: END IF;
3287:
3288: --Check API version, initialize message list and create savepoint.

Line 3391: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');

3387: -- end the transaction
3388: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
3389:
3390: IF (is_debug_procedure_on) THEN
3391: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'End(-)');
3392: END IF;
3393:
3394: EXCEPTION
3395: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 3398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

3394: EXCEPTION
3395: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3396:
3397: IF (is_debug_exception_on) THEN
3398: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
3399: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
3400: END IF;
3401:
3402: IF l_quotehdr_csr%ISOPEN THEN

Line 3416: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

3412: '_PVT'
3413: );
3414: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3415: IF (is_debug_exception_on) THEN
3416: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
3417: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
3418: END IF;
3419:
3420: IF l_quotehdr_csr%ISOPEN THEN

Line 3435: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,

3431: );
3432: WHEN OTHERS THEN
3433:
3434: IF (is_debug_exception_on) THEN
3435: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,L_MODULE_NAME,
3436: 'EXCEPTION :'||sqlerrm);
3437: END IF;
3438:
3439: IF l_quotehdr_csr%ISOPEN THEN