5: -- Declare package constants --
6: -------------------------------
7:
8: -- Log Level Constants
9: G_LOG_LEVEL_STATEMENT constant number := FND_LOG.Level_Statement; --1--
10: G_LOG_LEVEL_PROCEDURE constant number := FND_LOG.Level_Procedure; --2--
11: G_LOG_LEVEL_EVENT constant number := FND_LOG.Level_Event; --3--
12: G_LOG_LEVEL_EXCEPTION constant number := FND_LOG.Level_Exception; --4--
13: G_LOG_LEVEL_ERROR constant number := FND_LOG.Level_Error; --5--
6: -------------------------------
7:
8: -- Log Level Constants
9: G_LOG_LEVEL_STATEMENT constant number := FND_LOG.Level_Statement; --1--
10: G_LOG_LEVEL_PROCEDURE constant number := FND_LOG.Level_Procedure; --2--
11: G_LOG_LEVEL_EVENT constant number := FND_LOG.Level_Event; --3--
12: G_LOG_LEVEL_EXCEPTION constant number := FND_LOG.Level_Exception; --4--
13: G_LOG_LEVEL_ERROR constant number := FND_LOG.Level_Error; --5--
14: G_LOG_LEVEL_UNEXPECTED constant number := FND_LOG.Level_Unexpected;--6--
7:
8: -- Log Level Constants
9: G_LOG_LEVEL_STATEMENT constant number := FND_LOG.Level_Statement; --1--
10: G_LOG_LEVEL_PROCEDURE constant number := FND_LOG.Level_Procedure; --2--
11: G_LOG_LEVEL_EVENT constant number := FND_LOG.Level_Event; --3--
12: G_LOG_LEVEL_EXCEPTION constant number := FND_LOG.Level_Exception; --4--
13: G_LOG_LEVEL_ERROR constant number := FND_LOG.Level_Error; --5--
14: G_LOG_LEVEL_UNEXPECTED constant number := FND_LOG.Level_Unexpected;--6--
15:
8: -- Log Level Constants
9: G_LOG_LEVEL_STATEMENT constant number := FND_LOG.Level_Statement; --1--
10: G_LOG_LEVEL_PROCEDURE constant number := FND_LOG.Level_Procedure; --2--
11: G_LOG_LEVEL_EVENT constant number := FND_LOG.Level_Event; --3--
12: G_LOG_LEVEL_EXCEPTION constant number := FND_LOG.Level_Exception; --4--
13: G_LOG_LEVEL_ERROR constant number := FND_LOG.Level_Error; --5--
14: G_LOG_LEVEL_UNEXPECTED constant number := FND_LOG.Level_Unexpected;--6--
15:
16: ------------------------------
9: G_LOG_LEVEL_STATEMENT constant number := FND_LOG.Level_Statement; --1--
10: G_LOG_LEVEL_PROCEDURE constant number := FND_LOG.Level_Procedure; --2--
11: G_LOG_LEVEL_EVENT constant number := FND_LOG.Level_Event; --3--
12: G_LOG_LEVEL_EXCEPTION constant number := FND_LOG.Level_Exception; --4--
13: G_LOG_LEVEL_ERROR constant number := FND_LOG.Level_Error; --5--
14: G_LOG_LEVEL_UNEXPECTED constant number := FND_LOG.Level_Unexpected;--6--
15:
16: ------------------------------
17: -- Declare package messages --
10: G_LOG_LEVEL_PROCEDURE constant number := FND_LOG.Level_Procedure; --2--
11: G_LOG_LEVEL_EVENT constant number := FND_LOG.Level_Event; --3--
12: G_LOG_LEVEL_EXCEPTION constant number := FND_LOG.Level_Exception; --4--
13: G_LOG_LEVEL_ERROR constant number := FND_LOG.Level_Error; --5--
14: G_LOG_LEVEL_UNEXPECTED constant number := FND_LOG.Level_Unexpected;--6--
15:
16: ------------------------------
17: -- Declare package messages --
18: ------------------------------
1712:
1713: ----------------------------------------------------------
1714: -- Create View For Collapsing Attribute Dimension Model --
1715: ----------------------------------------------------------
1716: if (G_LOG_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1717:
1718: for i in 0..(round((length(p_attr_query)/4000),0)) loop
1719:
1720: FEM_ENGINES_PKG.Tech_Message (
2203: ,' ,.<>/?;:[]{}\|-=+`~!@#$%^&*()"'''
2204: ,'________________________________'
2205: ));
2206:
2207: if (G_LOG_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2208:
2209: FEM_ENGINES_PKG.Tech_Message (
2210: p_severity => G_LOG_LEVEL_STATEMENT
2211: ,p_module => l_module_name||'.'||l_attr_col||'.attrn'
2651: ,' ,.<>/?;:[]{}\|-=+`~!@#$%^&*()"'''
2652: ,'________________________________'
2653: ));
2654:
2655: if (G_LOG_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2656:
2657: FEM_ENGINES_PKG.Tech_Message (
2658: p_severity => G_LOG_LEVEL_STATEMENT
2659: ,p_module => l_module_name||'.'||l_attr_col||'.attrd'