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.PV_RULE_EVALUATION_PUB dependencies on FND_LOG

Line 9: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT

5: -- Used for inserting output messages to the message table.
6: -- --------------------------------------------------------------
7: PROCEDURE Debug(
8: p_msg_string IN VARCHAR2,
9: p_msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT
10: );
11:
12: PROCEDURE Set_Message(
13: p_msg_level IN NUMBER,

Line 226: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

222: l_api_version_number CONSTANT NUMBER := 1.0;
223:
224: begin
225:
226: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
227: Debug(l_api_name,FND_LOG.LEVEL_PROCEDURE);
228: END IF;
229:
230: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 227: Debug(l_api_name,FND_LOG.LEVEL_PROCEDURE);

223:
224: begin
225:
226: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
227: Debug(l_api_name,FND_LOG.LEVEL_PROCEDURE);
228: END IF;
229:
230: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
231: p_api_version,

Line 268: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

264: loop
265:
266: fetch lc_get_rule_details into l_attribute_id, l_rule_id, l_currency,l_operator,l_cri_id, l_att_val, l_att_to_val;
267:
268: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
269: debug(' Rule ID '||l_rule_id ||' Attribute ID '||l_attribute_id||' Criteria ID '||l_cri_id);
270: l_temp_variable := l_att_val;
271: while (l_temp_variable is not null) loop
272: debug('attr Val' ||substr( l_temp_variable, 1, 1800 ));

Line 304: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

300:
301: IF l_attr_value is null THEN
302: l_attr_value := l_prev_att_val;
303: l_attribute_value := ''''||l_prev_att_val||'''';
304: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
305: l_temp_variable := l_attribute_value;
306: while (l_temp_variable is not null) loop
307: debug('l_attribute_value' ||substr( l_temp_variable, 1, 1800 ));
308: l_temp_variable := substr( l_temp_variable, 1801 );

Line 320: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

316: l_attribute_value := l_attribute_value || ',' || '''' || l_att_val || '''';
317:
318: IF lc_get_rule_details%NOTFOUND THEN
319:
320: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
321: debug('At the last record ................');
322: END IF;
323:
324: l_criteria_count := l_criteria_count - 1;

Line 335: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

331:
332: l_attr_value := substr(l_attr_value, 1, length(l_attr_value)-length(l_att_val)-length(x_delimiter));
333: l_attribute_value := substr(l_attribute_value, 1, length(l_attribute_value)-length(l_att_val)-3);
334:
335: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
336: l_temp_variable := l_attribute_value;
337: while (l_temp_variable is not null) loop
338: debug('l_attribute_value for the last record' ||substr( l_temp_variable, 1, 1800 ));
339: l_temp_variable := substr( l_temp_variable, 1801 );

Line 451: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

447:
448: END IF;
449:
450: ELSE
451: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
452: debug('At first record ');
453: END IF;
454:
455: l_non_cri_count := l_non_cri_count + 1;

Line 533: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

529: IF l_rule_id_tbl.count > 0 THEN
530:
531: for i in 1 .. l_rule_id_tbl.count
532: loop
533: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: debug(' Rule ID ####################### '|| l_rule_id_tbl(i));
535: debug(' Attribute ID ################## '|| x_attr_id_tbl(i));
536: debug(' Criteria ID ################### '|| l_criterion_id_tbl(i));
537: debug(' Currency ###################### '|| l_currency_tbl(i));

Line 569: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

565: from pv_lookups
566: where lookup_type = 'PV_NUM_DATE_OPERATOR'
567: and lookup_code = l_operator_tbl(i);
568:
569: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
570: debug(' Operator Meaning '|| l_opr_meaning );
571: END IF;
572:
573: -- ==========================================================================

Line 592: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

588: -- only for selected attribute values
589: -- ==========================================================================
590: IF (l_lov_string IS NULL OR LENGTH(l_lov_string) = 0) THEN
591:
592: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
593: Debug ('Value could be NUMBER, DATE OR CURRENCY or STRING would be free text');
594: END IF;
595:
596: END IF;

Line 603: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

599:
600:
601: IF (l_lov_string IS NOT NULL OR LENGTH(l_lov_string) <> 0) THEN
602:
603: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
604: debug(' in the If Condition ');
605: END IF;
606:
607: -- ==========================================================================

Line 631: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

627: END IF;
628:
629: l_attr_in_string := replace(l_attribute_value_tbl(i),'''','');
630:
631: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
632: --debug(' Attribute in string '||l_attr_in_string);
633: l_temp_variable := l_attr_in_string;
634: while (l_temp_variable is not null) loop
635: debug('Attribute in string ' ||substr( l_temp_variable, 1, 1800 ));

Line 657: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

653: END IF;
654: END LOOP;
655: CLOSE lc_attr_cursor;
656:
657: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: debug('Attribute Meaning for Between '|| l_attr_val_meaning ||'AND' ||l_attr_to_val_mean);
659: END IF;
660:
661: l_concat_attr_mean := l_attr_val_meaning || ' and ' || l_attr_to_val_mean;

Line 676: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

672: l_concat_attr_mean := l_concat_attr_mean ||','|| l_attr_val_meaning;
673: ELSE
674: l_concat_attr_mean := l_attr_val_meaning;
675: END IF;
676: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
677: debug('line Attribute Meaning '||l_attr_val_meaning);
678: END IF;
679: END LOOP;
680: CLOSE lc_attr_cursor;

Line 682: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

678: END IF;
679: END LOOP;
680: CLOSE lc_attr_cursor;
681:
682: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
683: debug('Attribute Meaning '||l_concat_attr_mean);
684: END IF;
685:
686:

Line 709: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

705: x_evaluation_criteria_tbl(l_count) := l_opr_meaning || ' '||
706: replace(l_attribute_value_tbl(i),'''') || ' and ' || l_attr_to_val(i);
707: ELSE
708: x_evaluation_criteria_tbl(l_count) := l_opr_meaning ||' '|| replace(l_attribute_value_tbl(i),'''');
709: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: debug(' x_evaluation_criteria_tbl(l_count) '|| x_evaluation_criteria_tbl(l_count));
711: END IF;
712: END IF;
713:

Line 716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

712: END IF;
713:
714: END IF;
715:
716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
717: Debug('Before calling check_match partner_id '||p_partner_id||
718: ' l_attr_val_tbl(i) ' ||l_attr_val_tbl(i) ||'p_operator '|| l_operator_tbl(i),FND_LOG.LEVEL_PROCEDURE );
719: END IF;
720:

Line 718: ' l_attr_val_tbl(i) ' ||l_attr_val_tbl(i) ||'p_operator '|| l_operator_tbl(i),FND_LOG.LEVEL_PROCEDURE );

714: END IF;
715:
716: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
717: Debug('Before calling check_match partner_id '||p_partner_id||
718: ' l_attr_val_tbl(i) ' ||l_attr_val_tbl(i) ||'p_operator '|| l_operator_tbl(i),FND_LOG.LEVEL_PROCEDURE );
719: END IF;
720:
721: l_result := pv_check_match_pub.Check_Match
722: (

Line 745: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

741: ELSE
742:
743: x_attr_evaluation_result_tbl(x_attr_evaluation_result_tbl.count) := 'FAIL';
744: l_rule_pass_flag := FALSE;
745: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
746: Debug('Failed evaluating ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^',FND_LOG.LEVEL_PROCEDURE);
747: END IF;
748: x_rule_pass_flag := 'FAIL';
749: END IF;

Line 746: Debug('Failed evaluating ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^',FND_LOG.LEVEL_PROCEDURE);

742:
743: x_attr_evaluation_result_tbl(x_attr_evaluation_result_tbl.count) := 'FAIL';
744: l_rule_pass_flag := FALSE;
745: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
746: Debug('Failed evaluating ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^',FND_LOG.LEVEL_PROCEDURE);
747: END IF;
748: x_rule_pass_flag := 'FAIL';
749: END IF;
750:

Line 755: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

751:
752: x_partner_attr_value_tbl.extend;
753: x_partner_attr_value_tbl(x_partner_attr_value_tbl.count) := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
754:
755: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
756: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);
757: l_temp_variable := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
758: while (l_temp_variable is not null) loop
759: debug('Partner Attribute Value %%%%%%%% :' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);

Line 756: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);

752: x_partner_attr_value_tbl.extend;
753: x_partner_attr_value_tbl(x_partner_attr_value_tbl.count) := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
754:
755: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
756: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);
757: l_temp_variable := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
758: while (l_temp_variable is not null) loop
759: debug('Partner Attribute Value %%%%%%%% :' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);
760: l_temp_variable := substr( l_temp_variable, 1801 );

Line 759: debug('Partner Attribute Value %%%%%%%% :' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);

755: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
756: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);
757: l_temp_variable := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
758: while (l_temp_variable is not null) loop
759: debug('Partner Attribute Value %%%%%%%% :' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);
760: l_temp_variable := substr( l_temp_variable, 1801 );
761: end loop;
762:
763: debug('Return Type %%%%%%%%%%%%%%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).return_type,FND_LOG.LEVEL_PROCEDURE);

Line 763: debug('Return Type %%%%%%%%%%%%%%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).return_type,FND_LOG.LEVEL_PROCEDURE);

759: debug('Partner Attribute Value %%%%%%%% :' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);
760: l_temp_variable := substr( l_temp_variable, 1801 );
761: end loop;
762:
763: debug('Return Type %%%%%%%%%%%%%%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).return_type,FND_LOG.LEVEL_PROCEDURE);
764: END IF;
765:
766: END LOOP;
767:

Line 771: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

767:
768:
769: END IF;
770:
771: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
772: debug('End of partner_eval_outcome',FND_LOG.LEVEL_PROCEDURE);
773: END IF;
774:
775:

Line 772: debug('End of partner_eval_outcome',FND_LOG.LEVEL_PROCEDURE);

768:
769: END IF;
770:
771: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
772: debug('End of partner_eval_outcome',FND_LOG.LEVEL_PROCEDURE);
773: END IF;
774:
775:
776:

Line 782: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

778: EXCEPTION
779: WHEN FND_API.G_EXC_ERROR THEN
780: x_return_status := FND_API.G_RET_STS_ERROR;
781:
782: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
783: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_ERROR );
784: END IF;
785: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
786: p_count => x_msg_count,

Line 783: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_ERROR );

779: WHEN FND_API.G_EXC_ERROR THEN
780: x_return_status := FND_API.G_RET_STS_ERROR;
781:
782: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
783: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_ERROR );
784: END IF;
785: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
786: p_count => x_msg_count,
787: p_data => x_msg_data);

Line 792: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

788:
789: WHEN FND_API.g_exc_unexpected_error THEN
790: x_return_status := FND_API.g_ret_sts_unexp_error;
791:
792: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
793: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );
794: END IF;
795:
796: FND_MSG_PUB.count_and_get(

Line 793: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );

789: WHEN FND_API.g_exc_unexpected_error THEN
790: x_return_status := FND_API.g_ret_sts_unexp_error;
791:
792: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
793: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );
794: END IF;
795:
796: FND_MSG_PUB.count_and_get(
797: p_encoded => FND_API.g_false,

Line 809: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

805: END IF;
806:
807: x_return_status := FND_API.G_RET_STS_ERROR;
808:
809: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
810: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );
811: END IF;
812:
813: FND_MSG_PUB.count_and_get(

Line 810: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );

806:
807: x_return_status := FND_API.G_RET_STS_ERROR;
808:
809: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
810: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );
811: END IF;
812:
813: FND_MSG_PUB.count_and_get(
814: p_encoded => FND_API.g_false,

Line 1038: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1034:
1035:
1036:
1037:
1038: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1039: Debug(l_api_name,FND_LOG.LEVEL_PROCEDURE);
1040: END IF;
1041:
1042: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 1039: Debug(l_api_name,FND_LOG.LEVEL_PROCEDURE);

1035:
1036:
1037:
1038: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1039: Debug(l_api_name,FND_LOG.LEVEL_PROCEDURE);
1040: END IF;
1041:
1042: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1043: p_api_version,

Line 1083: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1079: loop
1080:
1081: fetch lc_get_rule_details into l_attribute_id, l_rule_id, l_currency,l_operator,l_cri_id, l_att_val, l_att_to_val;
1082:
1083: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1084: debug(' Rule ID '||l_rule_id ||' Attribute ID '||l_attribute_id||' Criteria ID '||l_cri_id);
1085: --||' Attr Value '||l_att_val);
1086: l_temp_variable := l_att_val;
1087: while (l_temp_variable is not null) loop

Line 1132: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1128: l_attr_value := l_prev_att_val;
1129:
1130: l_attribute_value := ''''||l_prev_att_val||'''';
1131:
1132: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1133: --debug('l_attribute_value '||l_attribute_value);
1134: l_temp_variable := l_attribute_value;
1135: while (l_temp_variable is not null) loop
1136: debug('l_attribute_value ' ||substr( l_temp_variable, 1, 1800 ));

Line 1155: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1151:
1152:
1153: IF lc_get_rule_details%NOTFOUND THEN
1154:
1155: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1156: debug('At the last record ................');
1157: END IF;
1158:
1159:

Line 1172: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1168:
1169: l_attr_value := substr(l_attr_value, 1, length(l_attr_value)-length(l_att_val)-length(x_delimiter));
1170: l_attribute_value := substr(l_attribute_value, 1, length(l_attribute_value)-length(l_att_val)-3);
1171:
1172: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1173: --debug('l_attribute_value for last record '|| l_attribute_value);
1174: l_temp_variable := l_attribute_value;
1175: while (l_temp_variable is not null) loop
1176: debug('l_attribute_value for the last record' ||substr( l_temp_variable, 1, 1800 ));

Line 1303: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1299:
1300: END IF;
1301:
1302: ELSE
1303: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1304: debug('At first record ');
1305: END IF;
1306:
1307: l_non_cri_count := l_non_cri_count + 1;

Line 1394: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1390: IF l_rule_id_tbl.count > 0 THEN
1391:
1392: for i in 1 .. l_rule_id_tbl.count
1393: loop
1394: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1395: debug(' Rule ID ####################### '|| l_rule_id_tbl(i));
1396: debug(' Attribute ID ################## '|| x_attr_id_tbl(i));
1397: debug(' Criteria ID ################### '|| l_criterion_id_tbl(i));
1398: debug(' Currency ###################### '|| l_currency_tbl(i));

Line 1431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1427: from pv_lookups
1428: where lookup_type = 'PV_NUM_DATE_OPERATOR'
1429: and lookup_code = l_operator_tbl(i);
1430:
1431: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: debug(' Operator Meaning '|| l_opr_meaning );
1433: END IF;
1434:
1435: -- ==========================================================================

Line 1453: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1449: -- only for selected attribute values
1450: -- ==========================================================================
1451: IF (l_lov_string IS NULL OR LENGTH(l_lov_string) = 0) THEN
1452:
1453: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1454: Debug ('Value could be NUMBER, DATE OR CURRENCY or STRING would be free text');
1455: END IF;
1456:
1457: END IF;

Line 1462: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1458:
1459:
1460: IF (l_lov_string IS NOT NULL OR LENGTH(l_lov_string) <> 0) THEN
1461:
1462: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: debug(' in the If Condition ');
1464: END IF;
1465:
1466: -- ==========================================================================

Line 1491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1487: END IF;
1488:
1489: l_attr_in_string := replace(l_attribute_value_tbl(i),'''','');
1490:
1491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1492: --debug(' Attribute in string '||l_attr_in_string);
1493: l_temp_variable := l_attr_in_string;
1494: while (l_temp_variable is not null) loop
1495: debug('Attribute in String ' ||substr( l_temp_variable, 1, 1800 ));

Line 1525: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1521: END IF;
1522: END LOOP;
1523: CLOSE lc_attr_cursor;
1524:
1525: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1526: debug('Attribute Meaning for Between '|| l_attr_val_meaning ||'AND' ||l_attr_to_val_mean);
1527: END IF;
1528:
1529: l_concat_attr_mean := l_attr_val_meaning || ' and ' || l_attr_to_val_mean;

Line 1550: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1546: l_concat_attr_mean := l_concat_attr_mean ||','|| l_attr_val_meaning;
1547: ELSE
1548: l_concat_attr_mean := l_attr_val_meaning;
1549: END IF;
1550: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1551: debug('line Attribute Meaning '||l_attr_val_meaning);
1552: END IF;
1553: END LOOP;
1554: CLOSE lc_attr_cursor;

Line 1556: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1552: END IF;
1553: END LOOP;
1554: CLOSE lc_attr_cursor;
1555:
1556: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1557: debug('Attribute Meaning '||l_concat_attr_mean);
1558: END IF;
1559:
1560:

Line 1589: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1585: END IF;
1586:
1587: END IF;
1588:
1589: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1590: debug('Start of pv_check_match_pub.Check_Match ',FND_LOG.LEVEL_PROCEDURE);
1591: debug('p_entity_id '||p_partner_id);
1592: --||' p_rule_attr_value '||l_attr_val_tbl(i)
1593: l_temp_variable := l_attr_val_tbl(i);

Line 1590: debug('Start of pv_check_match_pub.Check_Match ',FND_LOG.LEVEL_PROCEDURE);

1586:
1587: END IF;
1588:
1589: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1590: debug('Start of pv_check_match_pub.Check_Match ',FND_LOG.LEVEL_PROCEDURE);
1591: debug('p_entity_id '||p_partner_id);
1592: --||' p_rule_attr_value '||l_attr_val_tbl(i)
1593: l_temp_variable := l_attr_val_tbl(i);
1594: while (l_temp_variable is not null) loop

Line 1600: ||' p_operator '||l_operator_tbl(i),FND_LOG.LEVEL_PROCEDURE );

1596: l_temp_variable := substr( l_temp_variable, 1801 );
1597: end loop;
1598:
1599: debug(' p_attribute_id '||x_attr_id_tbl(i)||' p_rule_to_attr_value '||l_attr_to_val(i)
1600: ||' p_operator '||l_operator_tbl(i),FND_LOG.LEVEL_PROCEDURE );
1601:
1602:
1603: END IF;
1604:

Line 1619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1615: p_rule_currency_code => l_currency_tbl(i),
1616: x_entity_attr_value => l_entity_attr_value
1617: );
1618:
1619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);
1621: l_temp_variable := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
1622: while (l_temp_variable is not null) loop
1623: debug('Partner Attribute Value %%%%%%%% : ' ||substr( l_temp_variable, 1, 1800 ),FND_LOG.LEVEL_PROCEDURE);

Line 1620: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);

1616: x_entity_attr_value => l_entity_attr_value
1617: );
1618:
1619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);
1621: l_temp_variable := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
1622: while (l_temp_variable is not null) loop
1623: debug('Partner Attribute Value %%%%%%%% : ' ||substr( l_temp_variable, 1, 1800 ),FND_LOG.LEVEL_PROCEDURE);
1624: l_temp_variable := substr( l_temp_variable, 1801 );

Line 1623: debug('Partner Attribute Value %%%%%%%% : ' ||substr( l_temp_variable, 1, 1800 ),FND_LOG.LEVEL_PROCEDURE);

1619: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);
1621: l_temp_variable := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
1622: while (l_temp_variable is not null) loop
1623: debug('Partner Attribute Value %%%%%%%% : ' ||substr( l_temp_variable, 1, 1800 ),FND_LOG.LEVEL_PROCEDURE);
1624: l_temp_variable := substr( l_temp_variable, 1801 );
1625: end loop;
1626: END IF;
1627:

Line 1639: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1635:
1636: x_attr_evaluation_result_tbl(x_attr_evaluation_result_tbl.count) := 'FAIL';
1637: l_rule_pass_flag := FALSE;
1638:
1639: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1640: Debug('Failed evaluating ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^');
1641: END IF;
1642:
1643: x_rule_pass_flag := 'FAIL';

Line 1656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1652: x_partner_attr_value_tbl.extend;
1653: x_partner_attr_value_tbl(x_partner_attr_value_tbl.count)
1654: := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
1655:
1656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1657: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);
1658: l_temp_variable := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
1659: while (l_temp_variable is not null) loop
1660: debug('Partner Attribute Value %%%%%%%% : ' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);

Line 1657: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);

1653: x_partner_attr_value_tbl(x_partner_attr_value_tbl.count)
1654: := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
1655:
1656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1657: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);
1658: l_temp_variable := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
1659: while (l_temp_variable is not null) loop
1660: debug('Partner Attribute Value %%%%%%%% : ' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);
1661: l_temp_variable := substr( l_temp_variable, 1801 );

Line 1660: debug('Partner Attribute Value %%%%%%%% : ' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);

1656: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1657: --debug('Partner Attribute Value %%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).attribute_value,FND_LOG.LEVEL_PROCEDURE);
1658: l_temp_variable := l_entity_attr_value(x_attr_id_tbl(i)).attribute_value;
1659: while (l_temp_variable is not null) loop
1660: debug('Partner Attribute Value %%%%%%%% : ' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);
1661: l_temp_variable := substr( l_temp_variable, 1801 );
1662: end loop;
1663: debug('Return Type %%%%%%%%%%%%%%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).return_type,FND_LOG.LEVEL_PROCEDURE);
1664:

Line 1663: debug('Return Type %%%%%%%%%%%%%%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).return_type,FND_LOG.LEVEL_PROCEDURE);

1659: while (l_temp_variable is not null) loop
1660: debug('Partner Attribute Value %%%%%%%% : ' ||substr( l_temp_variable, 1, 1800 ) ,FND_LOG.LEVEL_PROCEDURE);
1661: l_temp_variable := substr( l_temp_variable, 1801 );
1662: end loop;
1663: debug('Return Type %%%%%%%%%%%%%%%%%%%% :'||l_entity_attr_value(x_attr_id_tbl(i)).return_type,FND_LOG.LEVEL_PROCEDURE);
1664:
1665:
1666: END IF;
1667:

Line 1670: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1666: END IF;
1667:
1668: END LOOP;
1669:
1670: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1671: debug('End of quick_partner_eval_outcome',FND_LOG.LEVEL_PROCEDURE);
1672: END IF;
1673:
1674: END IF;

Line 1671: debug('End of quick_partner_eval_outcome',FND_LOG.LEVEL_PROCEDURE);

1667:
1668: END LOOP;
1669:
1670: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1671: debug('End of quick_partner_eval_outcome',FND_LOG.LEVEL_PROCEDURE);
1672: END IF;
1673:
1674: END IF;
1675: EXCEPTION

Line 1679: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1675: EXCEPTION
1676: WHEN FND_API.G_EXC_ERROR THEN
1677: x_return_status := FND_API.G_RET_STS_ERROR;
1678:
1679: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1680: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_ERROR );
1681: END IF;
1682: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1683: p_count => x_msg_count,

Line 1680: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_ERROR );

1676: WHEN FND_API.G_EXC_ERROR THEN
1677: x_return_status := FND_API.G_RET_STS_ERROR;
1678:
1679: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1680: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_ERROR );
1681: END IF;
1682: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1683: p_count => x_msg_count,
1684: p_data => x_msg_data);

Line 1689: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1685:
1686: WHEN FND_API.g_exc_unexpected_error THEN
1687: x_return_status := FND_API.g_ret_sts_unexp_error;
1688:
1689: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1690: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );
1691: END IF;
1692:
1693: FND_MSG_PUB.count_and_get(

Line 1690: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );

1686: WHEN FND_API.g_exc_unexpected_error THEN
1687: x_return_status := FND_API.g_ret_sts_unexp_error;
1688:
1689: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1690: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );
1691: END IF;
1692:
1693: FND_MSG_PUB.count_and_get(
1694: p_encoded => FND_API.g_false,

Line 1706: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1702: END IF;
1703:
1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705:
1706: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1707: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );
1708: END IF;
1709:
1710: FND_MSG_PUB.count_and_get(

Line 1707: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );

1703:
1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705:
1706: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1707: debug( fnd_msg_pub.get(p_encoded => 'F'),FND_LOG.LEVEL_UNEXPECTED );
1708: END IF;
1709:
1710: FND_MSG_PUB.count_and_get(
1711: p_encoded => FND_API.g_false,

Line 1739: p_msg_level IN NUMBER := FND_LOG.LEVEL_STATEMENT

1735: --| |
1736: --==============================================================================
1737: PROCEDURE Debug(
1738: p_msg_string IN VARCHAR2,
1739: p_msg_level IN NUMBER := FND_LOG.LEVEL_STATEMENT
1740: )
1741: IS
1742: l_module_source VARCHAR2(100) := 'pv.plsql.program.rule.evaluation';
1743: BEGIN

Line 1745: IF (p_msg_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL)

1741: IS
1742: l_module_source VARCHAR2(100) := 'pv.plsql.program.rule.evaluation';
1743: BEGIN
1744:
1745: IF (p_msg_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1746: THEN
1747: fnd_log.string(p_msg_level, l_module_source,p_msg_string);
1748: END IF;
1749: END Debug;

Line 1747: fnd_log.string(p_msg_level, l_module_source,p_msg_string);

1743: BEGIN
1744:
1745: IF (p_msg_level >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1746: THEN
1747: fnd_log.string(p_msg_level, l_module_source,p_msg_string);
1748: END IF;
1749: END Debug;
1750: -- =================================End of Debug================================
1751: