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_EC_EVALUATE_PVT dependencies on FND_NUMBER

Line 503: l_numval1 := fnd_number.canonical_to_number(p_value1);

499: okl_debug_pub.log_debug(fnd_log.level_procedure
500: ,l_module
501: ,'begin debug OKLRECUB.pls.pls call validate_trade_in_value');
502: END IF;
503: l_numval1 := fnd_number.canonical_to_number(p_value1);
504: l_numval2 := fnd_number.canonical_to_number(p_value2);
505:
506: IF (p_trade_in_value >= l_numval1 AND p_trade_in_value <= l_numval2) THEN
507: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 504: l_numval2 := fnd_number.canonical_to_number(p_value2);

500: ,l_module
501: ,'begin debug OKLRECUB.pls.pls call validate_trade_in_value');
502: END IF;
503: l_numval1 := fnd_number.canonical_to_number(p_value1);
504: l_numval2 := fnd_number.canonical_to_number(p_value2);
505:
506: IF (p_trade_in_value >= l_numval1 AND p_trade_in_value <= l_numval2) THEN
507: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
508: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 906: l_numval1 := fnd_number.canonical_to_number(p_value1);

902: okl_debug_pub.log_debug(fnd_log.level_procedure
903: ,l_module
904: ,'begin debug OKLRECUB.pls.pls call validate_deal_size');
905: END IF;
906: l_numval1 := fnd_number.canonical_to_number(p_value1);
907: l_numval2 := fnd_number.canonical_to_number(p_value2);
908:
909: IF (p_deal_size >= l_numval1 AND p_deal_size <= l_numval2) THEN
910: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 907: l_numval2 := fnd_number.canonical_to_number(p_value2);

903: ,l_module
904: ,'begin debug OKLRECUB.pls.pls call validate_deal_size');
905: END IF;
906: l_numval1 := fnd_number.canonical_to_number(p_value1);
907: l_numval2 := fnd_number.canonical_to_number(p_value2);
908:
909: IF (p_deal_size >= l_numval1 AND p_deal_size <= l_numval2) THEN
910: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
911: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1110: l_numval1 := fnd_number.canonical_to_number(p_value1);

1106: -- check for logging on STATEMENT level
1107:
1108: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1109: ,fnd_log.level_statement);
1110: l_numval1 := fnd_number.canonical_to_number(p_value1);
1111: l_numval2 := fnd_number.canonical_to_number(p_value2);
1112:
1113: IF (p_deal_size >= l_numval1 AND p_deal_size <= l_numval2) THEN
1114: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1111: l_numval2 := fnd_number.canonical_to_number(p_value2);

1107:
1108: is_debug_statement_on := okl_debug_pub.check_log_on(l_module
1109: ,fnd_log.level_statement);
1110: l_numval1 := fnd_number.canonical_to_number(p_value1);
1111: l_numval2 := fnd_number.canonical_to_number(p_value2);
1112:
1113: IF (p_deal_size >= l_numval1 AND p_deal_size <= l_numval2) THEN
1114: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1115: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 1320: l_formatted_amt := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)

1316: END IF;
1317: IF p_okl_ec_rec.validation_mode = 'QA' THEN
1318: l_index := p_okl_ec_rec.qa_result_tbl.COUNT + 1;
1319: IF fun_ret = 0 THEN
1320: l_formatted_amt := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)
1321: ,p_okl_ec_rec.currency_code);
1322: p_okl_ec_rec.qa_result_tbl(l_index).message := get_msg_single(ec_tbl(i).ec_name
1323: ,l_operator_code
1324: ,l_formatted_amt

Line 1452: l_formatted_amt1 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)

1448: END IF;
1449: IF p_okl_ec_rec.validation_mode = 'QA' THEN
1450: l_index := p_okl_ec_rec.qa_result_tbl.COUNT + 1;
1451: IF fun_ret = 0 THEN
1452: l_formatted_amt1 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)
1453: ,p_okl_ec_rec.currency_code);
1454: l_formatted_amt2 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value2)
1455: ,p_okl_ec_rec.currency_code);
1456: p_okl_ec_rec.qa_result_tbl(l_index).message := get_msg_range(ec_tbl(i).ec_name

Line 1454: l_formatted_amt2 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value2)

1450: l_index := p_okl_ec_rec.qa_result_tbl.COUNT + 1;
1451: IF fun_ret = 0 THEN
1452: l_formatted_amt1 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)
1453: ,p_okl_ec_rec.currency_code);
1454: l_formatted_amt2 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value2)
1455: ,p_okl_ec_rec.currency_code);
1456: p_okl_ec_rec.qa_result_tbl(l_index).message := get_msg_range(ec_tbl(i).ec_name
1457: ,l_formatted_amt1
1458: ,l_formatted_amt2

Line 1526: l_formatted_amt := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)

1522: END IF;
1523: IF p_okl_ec_rec.validation_mode = 'QA' THEN
1524: l_index := p_okl_ec_rec.qa_result_tbl.COUNT + 1;
1525: IF fun_ret = 0 THEN
1526: l_formatted_amt := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)
1527: ,p_okl_ec_rec.currency_code);
1528: p_okl_ec_rec.qa_result_tbl(l_index).message := get_msg_single(ec_tbl(i).ec_name
1529: ,l_operator_code
1530: ,l_formatted_amt

Line 1560: l_num_value_tbl(k) := fnd_number.canonical_to_number(ec_val_rec.crit_cat_value2);

1556: ,'dd-mm-yyyy')))
1557: AND (p_okl_ec_rec.item_table.COUNT > 0)) THEN
1558: k := 1;
1559: FOR ec_val_rec IN get_ec_values(ec_tbl(i).criteria_id) LOOP
1560: l_num_value_tbl(k) := fnd_number.canonical_to_number(ec_val_rec.crit_cat_value2);
1561: k := k + 1;
1562: END LOOP;
1563:
1564: --this validate function will return either 1 or 0 only

Line 1624: l_num_value_tbl(k) := fnd_number.canonical_to_number(ec_val_rec.crit_cat_value2);

1620: ,'dd-mm-yyyy')))
1621: AND (p_okl_ec_rec.item_categories_table.COUNT > 0)) THEN
1622: k := 1;
1623: FOR ec_val_rec IN get_ec_values(ec_tbl(i).criteria_id) LOOP
1624: l_num_value_tbl(k) := fnd_number.canonical_to_number(ec_val_rec.crit_cat_value2);
1625: k := k + 1;
1626: END LOOP;
1627:
1628: --this validate function will return either 1 or 0 only

Line 1688: l_num_value_tbl(k) := fnd_number.canonical_to_number(ec_val_rec.crit_cat_value2);

1684: ,'dd-mm-yyyy')))
1685: AND (p_okl_ec_rec.term IS NOT NULL)) THEN
1686: k := 1;
1687: FOR ec_val_rec IN get_ec_values(ec_tbl(i).criteria_id) LOOP
1688: l_num_value_tbl(k) := fnd_number.canonical_to_number(ec_val_rec.crit_cat_value2);
1689:
1690: --dbms_output.put_line('l_num_value_tbl(k) = '||l_num_value_tbl(k));
1691:
1692: k := k + 1;

Line 1858: l_formatted_amt1 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)

1854: END IF;
1855: IF p_okl_ec_rec.validation_mode = 'QA' THEN
1856: l_index := p_okl_ec_rec.qa_result_tbl.COUNT + 1;
1857: IF fun_ret = 0 THEN
1858: l_formatted_amt1 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)
1859: ,p_okl_ec_rec.currency_code);
1860: l_formatted_amt2 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value2)
1861: ,p_okl_ec_rec.currency_code);
1862: p_okl_ec_rec.qa_result_tbl(l_index).message := get_msg_range(ec_tbl(i).ec_name

Line 1860: l_formatted_amt2 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value2)

1856: l_index := p_okl_ec_rec.qa_result_tbl.COUNT + 1;
1857: IF fun_ret = 0 THEN
1858: l_formatted_amt1 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value1)
1859: ,p_okl_ec_rec.currency_code);
1860: l_formatted_amt2 := okl_accounting_util.format_amount(fnd_number.canonical_to_number(l_value2)
1861: ,p_okl_ec_rec.currency_code);
1862: p_okl_ec_rec.qa_result_tbl(l_index).message := get_msg_range(ec_tbl(i).ec_name
1863: ,l_formatted_amt1
1864: ,l_formatted_amt2

Line 2230: l_num_value_tbl(k) := fnd_number.canonical_to_number(ac_val_rec.crit_cat_value1);

2226: ,'dd-mm-yyyy')))
2227: AND (p_okl_ac_rec.term IS NOT NULL)) THEN
2228: k := 1;
2229: FOR ac_val_rec IN get_ac_values(ac_tbl(i).criteria_id) LOOP
2230: l_num_value_tbl(k) := fnd_number.canonical_to_number(ac_val_rec.crit_cat_value1);
2231: l_adjustment_factors_tbl(k) := ac_val_rec.adjustment_factor;
2232:
2233: --dbms_output.put_line('l_num_value_tbl(k) = '||l_num_value_tbl(k));
2234:

Line 2528: l_ec1_numval1 := fnd_number.canonical_to_number(l_ec1_value1);

2524: IF ec1_tbl(i).data_type_code = 'NUMBER' THEN
2525:
2526: --dbms_output.put_line('datatype = number ');
2527:
2528: l_ec1_numval1 := fnd_number.canonical_to_number(l_ec1_value1);
2529: l_ec1_numval2 := fnd_number.canonical_to_number(l_ec1_value2);
2530: l_ec2_numval1 := fnd_number.canonical_to_number(l_ec2_value1);
2531: l_ec2_numval2 := fnd_number.canonical_to_number(l_ec2_value2);
2532:

Line 2529: l_ec1_numval2 := fnd_number.canonical_to_number(l_ec1_value2);

2525:
2526: --dbms_output.put_line('datatype = number ');
2527:
2528: l_ec1_numval1 := fnd_number.canonical_to_number(l_ec1_value1);
2529: l_ec1_numval2 := fnd_number.canonical_to_number(l_ec1_value2);
2530: l_ec2_numval1 := fnd_number.canonical_to_number(l_ec2_value1);
2531: l_ec2_numval2 := fnd_number.canonical_to_number(l_ec2_value2);
2532:
2533: --dbms_output.put_line(' l_ec1_numval1= '||l_ec1_numval1);

Line 2530: l_ec2_numval1 := fnd_number.canonical_to_number(l_ec2_value1);

2526: --dbms_output.put_line('datatype = number ');
2527:
2528: l_ec1_numval1 := fnd_number.canonical_to_number(l_ec1_value1);
2529: l_ec1_numval2 := fnd_number.canonical_to_number(l_ec1_value2);
2530: l_ec2_numval1 := fnd_number.canonical_to_number(l_ec2_value1);
2531: l_ec2_numval2 := fnd_number.canonical_to_number(l_ec2_value2);
2532:
2533: --dbms_output.put_line(' l_ec1_numval1= '||l_ec1_numval1);
2534: --dbms_output.put_line(' l_ec1_numval2= '||l_ec1_numval2);

Line 2531: l_ec2_numval2 := fnd_number.canonical_to_number(l_ec2_value2);

2527:
2528: l_ec1_numval1 := fnd_number.canonical_to_number(l_ec1_value1);
2529: l_ec1_numval2 := fnd_number.canonical_to_number(l_ec1_value2);
2530: l_ec2_numval1 := fnd_number.canonical_to_number(l_ec2_value1);
2531: l_ec2_numval2 := fnd_number.canonical_to_number(l_ec2_value2);
2532:
2533: --dbms_output.put_line(' l_ec1_numval1= '||l_ec1_numval1);
2534: --dbms_output.put_line(' l_ec1_numval2= '||l_ec1_numval2);
2535: --dbms_output.put_line(' l_ec2_numval1= '||l_ec2_numval1);

Line 2652: l_ec1_numval1 := fnd_number.canonical_to_number(l_ec1_value1);

2648: ,l_ec2_value1
2649: ,l_ec2_value2 ;
2650: CLOSE get_ec_values;
2651: IF ec1_tbl(i).data_type_code = 'NUMBER' THEN
2652: l_ec1_numval1 := fnd_number.canonical_to_number(l_ec1_value1);
2653: l_ec2_numval1 := fnd_number.canonical_to_number(l_ec2_value1);
2654: IF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'EQ' THEN
2655: IF l_ec1_numval1 <> l_ec2_numval1 THEN
2656: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 2653: l_ec2_numval1 := fnd_number.canonical_to_number(l_ec2_value1);

2649: ,l_ec2_value2 ;
2650: CLOSE get_ec_values;
2651: IF ec1_tbl(i).data_type_code = 'NUMBER' THEN
2652: l_ec1_numval1 := fnd_number.canonical_to_number(l_ec1_value1);
2653: l_ec2_numval1 := fnd_number.canonical_to_number(l_ec2_value1);
2654: IF l_ec1_operator_code = 'EQ' AND l_ec2_operator_code = 'EQ' THEN
2655: IF l_ec1_numval1 <> l_ec2_numval1 THEN
2656: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
2657: okl_debug_pub.log_debug(fnd_log.level_procedure