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 FND_LOG

Line 844: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

840: IS
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:

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 846: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_ApplicationId='||to_char(p_ApplicationId), FALSE);

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')
850: INTO l_application_short_name

Line 854: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

850: INTO l_application_short_name
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:

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 856: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'l_application_short_name'||l_application_short_name, FALSE);

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;
860: EXCEPTION

Line 862: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

858:
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:

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 864: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , SQLERRM, FALSE);

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;
868:

Line 884: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

880: FLEX_VALUE_SET_ID = :1';
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:

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 886: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_ValueSetId='||to_char(p_ValueSetId), FALSE);

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;
890: DBMS_SQL.PARSE(params_cursor, l_ValueSetSql,DBMS_SQL.native);

Line 921: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

917: end loop;
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:

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 923: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'l_dataType'||l_dataType, FALSE);

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:
927: RETURN l_dataType;

Line 932: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

928:
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');

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 941: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

937: FND_MSG_PUB.ADD;
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');

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 954: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

950: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
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;

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 992: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

988: errors_received EXCEPTION;
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);

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 994: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_FlexFieldAppShortName='||p_FlexFieldAppShortName, FALSE);

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);
998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, FALSE);

Line 995: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_FlexFieldName='||p_FlexFieldName, FALSE);

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);
998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, FALSE);
999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, FALSE);

Line 996: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_AttributeCategory='||p_AttributeCategory, FALSE);

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);
998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, FALSE);
999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, FALSE);
1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, FALSE);

Line 997: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute1='||p_Attribute1, FALSE);

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);
998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, FALSE);
999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, FALSE);
1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, FALSE);
1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);

Line 998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, 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);
998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, FALSE);
999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, FALSE);
1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, FALSE);
1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);
1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);

Line 999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, 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);
998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, FALSE);
999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, FALSE);
1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, FALSE);
1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);
1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);
1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);

Line 1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, 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);
998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, FALSE);
999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, FALSE);
1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, FALSE);
1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);
1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);
1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);
1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);

Line 1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);

997: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute1='||p_Attribute1, FALSE);
998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, FALSE);
999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, FALSE);
1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, FALSE);
1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);
1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);
1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);
1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);
1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);

Line 1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);

998: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute2='||p_Attribute2, FALSE);
999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, FALSE);
1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, FALSE);
1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);
1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);
1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);
1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);
1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);
1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);

Line 1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);

999: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute3='||p_Attribute3, FALSE);
1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, FALSE);
1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);
1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);
1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);
1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);
1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);
1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);
1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);

Line 1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);

1000: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute4='||p_Attribute4, FALSE);
1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);
1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);
1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);
1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);
1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);
1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);
1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);
1008: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute12='||p_Attribute12, FALSE);

Line 1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);

1001: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute5='||p_Attribute5, FALSE);
1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);
1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);
1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);
1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);
1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);
1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);
1008: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute12='||p_Attribute12, FALSE);
1009: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute13='||p_Attribute13, FALSE);

Line 1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);

1002: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute6='||p_Attribute6, FALSE);
1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);
1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);
1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);
1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);
1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);
1008: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute12='||p_Attribute12, FALSE);
1009: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute13='||p_Attribute13, FALSE);
1010: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute14='||p_Attribute14, FALSE);

Line 1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);

1003: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute7='||p_Attribute7, FALSE);
1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);
1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);
1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);
1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);
1008: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute12='||p_Attribute12, FALSE);
1009: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute13='||p_Attribute13, FALSE);
1010: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute14='||p_Attribute14, FALSE);
1011: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute15='||p_Attribute15, FALSE);

Line 1008: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute12='||p_Attribute12, FALSE);

1004: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute8='||p_Attribute8, FALSE);
1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);
1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);
1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);
1008: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute12='||p_Attribute12, FALSE);
1009: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute13='||p_Attribute13, FALSE);
1010: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute14='||p_Attribute14, FALSE);
1011: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute15='||p_Attribute15, FALSE);
1012: end if;

Line 1009: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute13='||p_Attribute13, FALSE);

1005: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute9='||p_Attribute9, FALSE);
1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);
1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);
1008: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute12='||p_Attribute12, FALSE);
1009: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute13='||p_Attribute13, FALSE);
1010: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute14='||p_Attribute14, FALSE);
1011: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute15='||p_Attribute15, FALSE);
1012: end if;
1013:

Line 1010: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute14='||p_Attribute14, FALSE);

1006: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute10='||p_Attribute10, FALSE);
1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);
1008: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute12='||p_Attribute12, FALSE);
1009: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute13='||p_Attribute13, FALSE);
1010: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute14='||p_Attribute14, FALSE);
1011: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute15='||p_Attribute15, FALSE);
1012: end if;
1013:
1014: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_AttributeCategory);

Line 1011: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute15='||p_Attribute15, FALSE);

1007: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute11='||p_Attribute11, FALSE);
1008: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute12='||p_Attribute12, FALSE);
1009: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute13='||p_Attribute13, FALSE);
1010: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute14='||p_Attribute14, FALSE);
1011: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_Attribute15='||p_Attribute15, FALSE);
1012: end if;
1013:
1014: fnd_flex_descval.set_column_value('ATTRIBUTE_CATEGORY', p_AttributeCategory);
1015: fnd_flex_descval.set_column_value('ATTRIBUTE1', p_Attribute1);

Line 1038: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1034: ELSE
1035: return(FND_FLEX_DESCVAL.concatenated_values);
1036: END IF;
1037: ELSE
1038: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1039: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1040: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* An error has occured so we will call ', FALSE);
1041: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* FND_FLEX_DESCVAL.error_segment to detemine ', FALSE);
1042: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* which segment contains the error. ', FALSE);

Line 1039: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);

1035: return(FND_FLEX_DESCVAL.concatenated_values);
1036: END IF;
1037: ELSE
1038: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1039: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1040: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* An error has occured so we will call ', FALSE);
1041: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* FND_FLEX_DESCVAL.error_segment to detemine ', FALSE);
1042: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* which segment contains the error. ', FALSE);
1043: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);

Line 1040: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* An error has occured so we will call ', FALSE);

1036: END IF;
1037: ELSE
1038: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1039: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1040: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* An error has occured so we will call ', FALSE);
1041: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* FND_FLEX_DESCVAL.error_segment to detemine ', FALSE);
1042: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* which segment contains the error. ', FALSE);
1043: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1044: end if;

Line 1041: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* FND_FLEX_DESCVAL.error_segment to detemine ', FALSE);

1037: ELSE
1038: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1039: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1040: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* An error has occured so we will call ', FALSE);
1041: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* FND_FLEX_DESCVAL.error_segment to detemine ', FALSE);
1042: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* which segment contains the error. ', FALSE);
1043: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1044: end if;
1045:

Line 1042: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* which segment contains the error. ', FALSE);

1038: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1039: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1040: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* An error has occured so we will call ', FALSE);
1041: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* FND_FLEX_DESCVAL.error_segment to detemine ', FALSE);
1042: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* which segment contains the error. ', FALSE);
1043: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1044: end if;
1045:
1046:

Line 1043: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);

1039: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1040: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* An error has occured so we will call ', FALSE);
1041: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* FND_FLEX_DESCVAL.error_segment to detemine ', FALSE);
1042: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '* which segment contains the error. ', FALSE);
1043: fnd_log.message(FND_LOG.LEVEL_STATEMENT, '*************************************************', FALSE);
1044: end if;
1045:
1046:
1047: error_segment := FND_FLEX_DESCVAL.error_segment;

Line 1048: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1044: end if;
1045:
1046:
1047: error_segment := FND_FLEX_DESCVAL.error_segment;
1048: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1049: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'error_segment = ' || error_segment, FALSE);
1050: end if;
1051: RAISE errors_received;
1052:

Line 1049: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'error_segment = ' || error_segment, FALSE);

1045:
1046:
1047: error_segment := FND_FLEX_DESCVAL.error_segment;
1048: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1049: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'error_segment = ' || error_segment, FALSE);
1050: end if;
1051: RAISE errors_received;
1052:
1053: END IF;

Line 1055: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1051: RAISE errors_received;
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

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 1065: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1061: error_msg := fnd_flex_descval.error_message;
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:

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 1067: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'Here are the error messages: ', FALSE);

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
1071: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1071: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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
1071: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1072: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , error_msg, FALSE);
1073: END IF;
1074:
1075: else

Line 1072: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , error_msg, FALSE);

1068: END IF;
1069:
1070: if(length(error_msg) < 200) then
1071: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1072: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , error_msg, FALSE);
1073: END IF;
1074:
1075: else
1076: while e < 5001 and substr(error_msg, s, e) is not null

Line 1078: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1074:
1075: else
1076: while e < 5001 and substr(error_msg, s, e) is not null
1077: loop
1078: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1079: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , substr(error_msg, s, e), FALSE);
1080: END IF;
1081:
1082: s := s + 200;

Line 1079: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , substr(error_msg, s, e), FALSE);

1075: else
1076: while e < 5001 and substr(error_msg, s, e) is not null
1077: loop
1078: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1079: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , substr(error_msg, s, e), FALSE);
1080: END IF;
1081:
1082: s := s + 200;
1083: e := e + 200;

Line 1109: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1105:
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;

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 1111: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'MO_GLOBAL.GET_ACCESS_MODE='||MO_GLOBAL.GET_ACCESS_MODE(), FALSE);

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:
1115: IF ( MO_GLOBAL.GET_ACCESS_MODE() = 'S') THEN

Line 1112: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'MO_GLOBAL.GET_CURRENT_ORG_ID='||MO_GLOBAL.GET_CURRENT_ORG_ID, FALSE);

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:
1115: IF ( MO_GLOBAL.GET_ACCESS_MODE() = 'S') THEN
1116: RETURN MO_GLOBAL.GET_CURRENT_ORG_ID;

Line 1138: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1134: RULE_OBJECT_ID = :1';
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:

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 1140: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'p_rule_object_id='||to_char(p_rule_object_id), FALSE);

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;
1144: DBMS_SQL.PARSE(params_cursor, l_sql,DBMS_SQL.native);

Line 1162: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1158: end loop;
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:

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 1164: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'l_parent_rule_object_id='||to_char(l_parent_rule_object_id), FALSE);

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:
1168: RETURN FALSE;

Line 1176: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1172: IF DBMS_SQL.IS_OPEN(params_cursor) THEN
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;

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;