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.FUN_RULE_UTILITY_PKG dependencies on FUN_RULE_UTILITY_PKG

Line 1: PACKAGE BODY FUN_RULE_UTILITY_PKG AS

1: PACKAGE BODY FUN_RULE_UTILITY_PKG AS
2: /*$Header: FUNXTMRULGENUTB.pls 120.3 2006/02/22 10:51:20 ammishra noship $ */
3:
4: --------------------------------------
5: -- declaration of private global varibles

Line 845: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.getApplicationShortName', FALSE);

841: l_application_short_name VARCHAR2(30);
842: BEGIN
843:
844: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
845: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.getApplicationShortName', FALSE);
846: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_ApplicationId='||to_char(p_ApplicationId), FALSE);
847: end if;
848:
849: SELECT nvl(application_short_name, 'FUN')

Line 855: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_UTILITY_PKG.getApplicationShortName', FALSE);

851: FROM fnd_application
852: WHERE application_id = p_ApplicationId;
853:
854: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
855: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_UTILITY_PKG.getApplicationShortName', FALSE);
856: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'l_application_short_name'||l_application_short_name, FALSE);
857: end if;
858:
859: RETURN l_application_short_name;

Line 863: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.getApplicationShortName:->Exception', FALSE);

859: RETURN l_application_short_name;
860: EXCEPTION
861: WHEN OTHERS THEN
862: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
863: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.getApplicationShortName:->Exception', FALSE);
864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , SQLERRM, FALSE);
865: END IF;
866:
867: APP_EXCEPTION.RAISE_EXCEPTION;

Line 885: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.getValueSetDataType', FALSE);

881:
882: BEGIN
883:
884: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
885: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.getValueSetDataType', FALSE);
886: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_ValueSetId='||to_char(p_ValueSetId), FALSE);
887: end if;
888:
889: params_cursor := DBMS_SQL.OPEN_CURSOR;

Line 922: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_UTILITY_PKG.getValueSetDataType', FALSE);

918:
919: DBMS_SQL.CLOSE_CURSOR(params_cursor);
920:
921: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
922: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_UTILITY_PKG.getValueSetDataType', FALSE);
923: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'l_dataType'||l_dataType, FALSE);
924: end if;
925:
926:

Line 933: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.getValueSetDataType:->INVAILD_DATA_TYPE', FALSE);

929: EXCEPTION
930: WHEN INVAILD_DATA_TYPE THEN
931:
932: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
933: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.getValueSetDataType:->INVAILD_DATA_TYPE', FALSE);
934: END IF;
935:
936: FND_MESSAGE.SET_NAME('FUN','FUN_RULE_INVALID_CRIT_DATATYPE');
937: FND_MSG_PUB.ADD;

Line 942: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.getValueSetDataType:->INVAILD_LENGTH_TYPE', FALSE);

938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939:
940: WHEN INVAILD_LENGTH_TYPE THEN
941: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
942: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.getValueSetDataType:->INVAILD_LENGTH_TYPE', FALSE);
943: END IF;
944:
945: FND_MESSAGE.SET_NAME('FUN','FUN_RULE_INVALID_CRIT_LENGTH');
946: FND_MSG_PUB.ADD;

Line 955: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.getValueSetDataType:->Exception='||SQLERRM, FALSE);

951: DBMS_SQL.CLOSE_CURSOR(params_cursor);
952: END IF;
953:
954: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
955: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.getValueSetDataType:->Exception='||SQLERRM, FALSE);
956: END IF;
957:
958: RAISE;
959:

Line 993: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.GET_RULE_DFF_RESULT_VALUE', FALSE);

989: error_segment VARCHAR2(30);
990:
991: BEGIN
992: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
993: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.GET_RULE_DFF_RESULT_VALUE', FALSE);
994: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_FlexFieldAppShortName='||p_FlexFieldAppShortName, FALSE);
995: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_FlexFieldName='||p_FlexFieldName, FALSE);
996: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_AttributeCategory='||p_AttributeCategory, FALSE);
997: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute1='||p_Attribute1, FALSE);

Line 1056: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_UTILITY_PKG.GET_RULE_DFF_RESULT_VALUE', FALSE);

1052:
1053: END IF;
1054:
1055: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1056: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_UTILITY_PKG.GET_RULE_DFF_RESULT_VALUE', FALSE);
1057: end if;
1058:
1059: EXCEPTION
1060: WHEN errors_received THEN

Line 1066: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.GET_RULE_DFF_RESULT_VALUE:->errors_received', FALSE);

1062: s :=1;
1063: e := 200;
1064:
1065: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.GET_RULE_DFF_RESULT_VALUE:->errors_received', FALSE);
1067: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'Here are the error messages: ', FALSE);
1068: END IF;
1069:
1070: if(length(error_msg) < 200) then

Line 1092: fun_rule_utility_pkg.print_debug(0,'Before calling Rules Engine.');

1088:
1089: END get_rule_dff_result_value;
1090:
1091: /*Usage
1092: fun_rule_utility_pkg.print_debug(0,'Before calling Rules Engine.');
1093: */
1094:
1095: PROCEDURE print_debug(
1096: p_indent IN NUMBER,

Line 1110: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.GET_MOAC_ORG_ID', FALSE);

1106: FUNCTION get_moac_org_id
1107: RETURN NUMBER IS
1108: BEGIN
1109: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1110: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.GET_MOAC_ORG_ID', FALSE);
1111: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'MO_GLOBAL.GET_ACCESS_MODE='||MO_GLOBAL.GET_ACCESS_MODE(), FALSE);
1112: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'MO_GLOBAL.GET_CURRENT_ORG_ID='||MO_GLOBAL.GET_CURRENT_ORG_ID, FALSE);
1113: end if;
1114:

Line 1139: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE', FALSE);

1135:
1136: BEGIN
1137:
1138: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1139: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE', FALSE);
1140: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_rule_object_id='||to_char(p_rule_object_id), FALSE);
1141: end if;
1142:
1143: params_cursor := DBMS_SQL.OPEN_CURSOR;

Line 1163: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE', FALSE);

1159:
1160: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1161:
1162: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1163: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE', FALSE);
1164: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'l_parent_rule_object_id='||to_char(l_parent_rule_object_id), FALSE);
1165: end if;
1166:
1167:

Line 1177: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE:->Exception='||SQLERRM, FALSE);

1173: DBMS_SQL.CLOSE_CURSOR(params_cursor);
1174: END IF;
1175:
1176: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1177: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_UTILITY_PKG.IS_USE_INSTANCE:->Exception='||SQLERRM, FALSE);
1178: END IF;
1179:
1180: RAISE;
1181: END IS_USE_INSTANCE;

Line 1183: END FUN_RULE_UTILITY_PKG;

1179:
1180: RAISE;
1181: END IS_USE_INSTANCE;
1182:
1183: END FUN_RULE_UTILITY_PKG;