APPS.CSD_PARAMETER_EFFECTIVITY_PVT dependencies on FND_LOG

Line 12: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;

8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_PARAMETER_EFFECTIVITY_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvpreb.pls';
12: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;
13: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14:
15: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 13: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

9:
10: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_PARAMETER_EFFECTIVITY_PVT';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvpreb.pls';
12: G_LEVEL_PROCEDURE NUMBER := FND_LOG.LEVEL_PROCEDURE;
13: G_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
14:
15: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
16: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17:

Line 75: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');

71: l_match BOOLEAN := FALSE;
72:
73: BEGIN
74: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
75: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Begin API');
76: END IF;
77:
78: -- standard check for API compatibility.
79: IF NOT Fnd_Api.Compatible_API_Call

Line 96: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Checking for the default value. Step-1. Param_id ='||p_param_id);

92: x_return_status := G_RET_STS_SUCCESS;
93:
94: -- find out if the param_id passed has a always applicable value.
95: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
96: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Checking for the default value. Step-1. Param_id ='||p_param_id);
97: END IF;
98:
99: BEGIN
100: SELECT value,NVL(applicable,'N')

Line 118: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Bulk fetching all the rules. Step-2. Param_id ='||p_param_id);

114:
115: -- we have rules(possibly) defined for the parameter.
116: -- fetch all the rules and their corresponding values.
117: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
118: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Bulk fetching all the rules. Step-2. Param_id ='||p_param_id);
119: END IF;
120:
121: SELECT rule_id,value
122: BULK COLLECT INTO l_param_value_tbl

Line 135: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Checking for rule conditions');

131:
132: -- we will check to see if there are any rule conditions exist for the rules specified.
133: -- this is row by row processing.
134: IF (G_LEVEL_PROCEDURE >= G_RUNTIME_LEVEL) THEN
135: Fnd_Log.STRING(G_LEVEL_PROCEDURE, lc_api_name,'Checking for rule conditions');
136: END IF;
137: FOR i IN 1 ..l_param_value_tbl.COUNT
138: LOOP
139: SELECT rule_condition_id,