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_EXECUTE_FORMULA_PVT dependencies on FND_LOG

Line 221: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

217: ORDER BY sequence_number;
218:
219: BEGIN
220: IF (G_DEBUG_ENABLED = 'Y') THEN
221: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
222: END IF;
223:
224: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
225: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In execute_function... p_dsf_id=' || p_dsf_id);

Line 225: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In execute_function... p_dsf_id=' || p_dsf_id);

221: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
222: END IF;
223:
224: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
225: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In execute_function... p_dsf_id=' || p_dsf_id);
226: END IF;
227: l_dsf_id := p_dsf_id;
228: l_contract_id := p_contract_id;
229: l_line_id := p_line_id;

Line 236: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_function_source=' || l_function_source || ' l_function_name='||l_function_name);

232: l_flag := TRUE;
233: l_function_source := l_data_src_fnctns_csr.source;
234: l_function_name := l_data_src_fnctns_csr.name;
235: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
236: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_function_source=' || l_function_source || ' l_function_name='||l_function_name);
237: END IF;
238: EXIT;
239: END LOOP;
240: IF l_flag THEN

Line 250: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'pmr_id=' || l_fnctn_prmtrs_val_tbl(i).pmr_id || ' fpr_type='||l_fnctn_prmtrs_csr.fpr_type);

246: FOR l_fnctn_prmtrs_csr IN fnctn_prmtrs_csr(cp_dsf_id => l_dsf_id)
247: LOOP
248: l_fnctn_prmtrs_val_tbl(i).pmr_id := l_fnctn_prmtrs_csr.pmr_id;
249: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
250: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'pmr_id=' || l_fnctn_prmtrs_val_tbl(i).pmr_id || ' fpr_type='||l_fnctn_prmtrs_csr.fpr_type);
251: END IF;
252:
253: IF l_fnctn_prmtrs_csr.fpr_type='STATIC' THEN
254: IF l_fnctn_prmtrs_csr.value IS NULL THEN

Line 278: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_fnctn_prmtrs_val_tbl.count='||l_fnctn_prmtrs_val_tbl.count);

274: END IF;
275: i := i+1;
276: END LOOP;
277: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
278: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_fnctn_prmtrs_val_tbl.count='||l_fnctn_prmtrs_val_tbl.count);
279: END IF;
280:
281: l_function_source2 := l_function_source;
282: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 283: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'1.l_function_source2=' || l_function_source2);

279: END IF;
280:
281: l_function_source2 := l_function_source;
282: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
283: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'1.l_function_source2=' || l_function_source2);
284: END IF;
285: IF l_line_id IS NULL THEN
286: --Changed by kthiruva for the bug 3671523 . l_contract_id and l_line_id are passed as strings
287: l_function_source := l_function_source ||'('||''''||TO_CHAR(l_contract_id)||''''||','||''''||'''';

Line 293: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_function_source=' || l_function_source);

289: --Changed by kthiruva for the bug 3671523 . l_contract_id and l_line_id are passed as strings
290: l_function_source := l_function_source ||'('||''''||TO_CHAR(l_contract_id)||''''||','||''''||TO_CHAR(l_line_id)||'''';
291: END IF;
292: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
293: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_function_source=' || l_function_source);
294: END IF;
295: --l_function_source2 := 'begin :3 := ' || l_function_source2 || '(:1, :2); end;'
296: l_function_source2 := 'begin :3 := ' || l_function_source2 || '(:1, :2';
297: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 298: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'2.l_function_source2=' || l_function_source2);

294: END IF;
295: --l_function_source2 := 'begin :3 := ' || l_function_source2 || '(:1, :2); end;'
296: l_function_source2 := 'begin :3 := ' || l_function_source2 || '(:1, :2';
297: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
298: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'2.l_function_source2=' || l_function_source2);
299: END IF;
300:
301: /*
302: IF l_line_id IS NULL THEN

Line 333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_evaluated_string=' || l_evaluated_string);

329: IF l_evaluated_string IS NULL THEN
330: RAISE FUNCTION_DATA_INVALID;
331: END IF;
332: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_evaluated_string=' || l_evaluated_string);
334: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_evaluated_string2=' || l_evaluated_string2);
335: END IF;
336:
337: -- Commented by Santonyr on 22-Oct-2003 to fix bug 3214171

Line 334: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_evaluated_string2=' || l_evaluated_string2);

330: RAISE FUNCTION_DATA_INVALID;
331: END IF;
332: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_evaluated_string=' || l_evaluated_string);
334: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_evaluated_string2=' || l_evaluated_string2);
335: END IF;
336:
337: -- Commented by Santonyr on 22-Oct-2003 to fix bug 3214171
338:

Line 516: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

512: WHERE id = cp_formula_id;
513:
514: BEGIN
515: IF (G_DEBUG_ENABLED = 'Y') THEN
516: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
517: END IF;
518:
519: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
520: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In execute_formula...');

Line 520: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In execute_formula...');

516: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
517: END IF;
518:
519: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
520: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In execute_formula...');
521: END IF;
522: l_formula_id := p_formula_id;
523: l_formula_string := p_formula_string;
524: l_contract_id := p_contract_id;

Line 542: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_operand_val_tbl('||i||').id=' || l_operand_val_tbl(i).id);

538: l_flag := TRUE;
539: l_operand_val_tbl(i).id := l_formula_operand_csr.opd_id;
540: l_operand_val_tbl(i).label := l_formula_operand_csr.label;
541: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
542: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_operand_val_tbl('||i||').id=' || l_operand_val_tbl(i).id);
543: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_operand_val_tbl('||i||').label=' || l_operand_val_tbl(i).label);
544: END IF;
545: i := i+1;
546: END LOOP;

Line 543: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_operand_val_tbl('||i||').label=' || l_operand_val_tbl(i).label);

539: l_operand_val_tbl(i).id := l_formula_operand_csr.opd_id;
540: l_operand_val_tbl(i).label := l_formula_operand_csr.label;
541: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
542: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_operand_val_tbl('||i||').id=' || l_operand_val_tbl(i).id);
543: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_operand_val_tbl('||i||').label=' || l_operand_val_tbl(i).label);
544: END IF;
545: i := i+1;
546: END LOOP;
547: IF l_flag THEN

Line 553: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_operand_val_tbl.count=' || l_operand_val_tbl.count);

549: ELSE
550: RAISE NO_FORMULA_OPERAND_FOUND;
551: END IF;
552: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
553: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_operand_val_tbl.count=' || l_operand_val_tbl.count);
554: END IF;
555: i := 1;
556: FOR i in l_operand_val_tbl.FIRST .. l_operand_val_tbl.LAST
557: LOOP

Line 563: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i=' || i || ' l_operand_name='|| l_operand_name || ' operand_type=' || l_operand_csr.opd_type);

559: LOOP
560: l_value := NULL;
561: l_operand_name := l_operand_csr.name;
562: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
563: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'i=' || i || ' l_operand_name='|| l_operand_name || ' operand_type=' || l_operand_csr.opd_type);
564: END IF;
565: IF l_operand_csr.opd_type = 'CNST' THEN
566: IF l_operand_csr.source IS NULL THEN
567: RAISE NO_CONSTANT_SPECIFIED;

Line 574: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Calling execute_function...');

570: l_operand_val_tbl(i).value := l_operand_csr.source;
571: END IF;
572: ELSIF l_operand_csr.opd_type = 'FCNT' THEN
573: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
574: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Calling execute_function...');
575: END IF;
576: execute_function(p_api_version => l_api_version
577: ,p_init_msg_list => l_init_msg_list
578: ,x_return_status => l_return_status

Line 857: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

853: AND start_date <= sysdate
854: AND (end_date IS NULL OR end_date >= sysdate);
855: BEGIN
856: IF (G_DEBUG_ENABLED = 'Y') THEN
857: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
858: END IF;
859: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
860: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In okl_execute_formula_pvt2.execute...');
861: END IF;

Line 860: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In okl_execute_formula_pvt2.execute...');

856: IF (G_DEBUG_ENABLED = 'Y') THEN
857: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
858: END IF;
859: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
860: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In okl_execute_formula_pvt2.execute...');
861: END IF;
862: l_formula_name := p_formula_name;
863: l_contract_id := p_contract_id;
864: l_line_id := p_line_id;

Line 902: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling okl_formulaevaluate_pub.eva_getparametervalues l_ctxt_parameter_tbl.count='||l_ctxt_parameter_tbl.count);

898: RAISE ERROR_IN_EVALUATE_PARAM;
899: END IF;
900: END IF;
901: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
902: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling okl_formulaevaluate_pub.eva_getparametervalues l_ctxt_parameter_tbl.count='||l_ctxt_parameter_tbl.count);
903: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Calling execute_formula...');
904: END IF;
905: execute_formula(p_api_version => l_api_version
906: ,p_init_msg_list => l_init_msg_list

Line 903: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Calling execute_formula...');

899: END IF;
900: END IF;
901: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
902: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling okl_formulaevaluate_pub.eva_getparametervalues l_ctxt_parameter_tbl.count='||l_ctxt_parameter_tbl.count);
903: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Calling execute_formula...');
904: END IF;
905: execute_formula(p_api_version => l_api_version
906: ,p_init_msg_list => l_init_msg_list
907: ,x_return_status => l_return_status

Line 1035: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1031: AND start_date <= sysdate
1032: AND (end_date IS NULL OR end_date >= sysdate);
1033: BEGIN
1034: IF (G_DEBUG_ENABLED = 'Y') THEN
1035: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1036: END IF;
1037: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1038: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In okl_execute_formula_pvt2.execute2...');
1039: END IF;

Line 1038: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In okl_execute_formula_pvt2.execute2...');

1034: IF (G_DEBUG_ENABLED = 'Y') THEN
1035: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1036: END IF;
1037: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1038: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In okl_execute_formula_pvt2.execute2...');
1039: END IF;
1040: l_formula_name := p_formula_name;
1041: l_contract_id := p_contract_id;
1042: l_line_id := p_line_id;