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:
18: /****************** private routines ****************************************/
19: FUNCTION is_rule_condition_match(
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:
18: /****************** private routines ****************************************/
19: FUNCTION is_rule_condition_match(
20: p_parameter_type IN VARCHAR2,
51: END is_rule_condition_match;
52:
53: PROCEDURE PARAMETER_VALUE(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE,
57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: p_param_id IN NUMBER,
59: p_rule_input_rec IN RULE_INPUT_REC_TYPE,
52:
53: PROCEDURE PARAMETER_VALUE(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE,
57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: p_param_id IN NUMBER,
59: p_rule_input_rec IN RULE_INPUT_REC_TYPE,
60: x_param_value OUT NOCOPY VARCHAR2,
53: PROCEDURE PARAMETER_VALUE(
54: p_api_version IN NUMBER,
55: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
56: p_commit IN VARCHAR2 := FND_API.G_FALSE,
57: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58: p_param_id IN NUMBER,
59: p_rule_input_rec IN RULE_INPUT_REC_TYPE,
60: x_param_value OUT NOCOPY VARCHAR2,
61: x_return_status OUT NOCOPY VARCHAR2,
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
80: (lc_api_version,
81: p_api_version,
82: lc_api_name,
83: G_PKG_NAME)
81: p_api_version,
82: lc_api_name,
83: G_PKG_NAME)
84: THEN
85: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN
89: Fnd_Msg_Pub.initialize;
84: THEN
85: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: IF Fnd_Api.to_Boolean(p_init_msg_list) THEN
89: Fnd_Msg_Pub.initialize;
90: END IF;
91:
92: x_return_status := G_RET_STS_SUCCESS;