APPS.ZX_CONDITIONS_PKG dependencies on FND_API

Line 126: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;

122: ,x_msg_data OUT NOCOPY VARCHAR2
123: ,x_condition_group_code OUT NOCOPY VARCHAR2
124: ) IS
125:
126: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
127: l_miss_number NUMBER := FND_API.G_MISS_NUM;
128: l_miss_date DATE := FND_API.G_MISS_DATE;
129: l_procedure_name VARCHAR2(30) := 'CHECK_DUP_TAX_CONDITIONS';
130:

Line 127: l_miss_number NUMBER := FND_API.G_MISS_NUM;

123: ,x_condition_group_code OUT NOCOPY VARCHAR2
124: ) IS
125:
126: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
127: l_miss_number NUMBER := FND_API.G_MISS_NUM;
128: l_miss_date DATE := FND_API.G_MISS_DATE;
129: l_procedure_name VARCHAR2(30) := 'CHECK_DUP_TAX_CONDITIONS';
130:
131: BEGIN

Line 128: l_miss_date DATE := FND_API.G_MISS_DATE;

124: ) IS
125:
126: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
127: l_miss_number NUMBER := FND_API.G_MISS_NUM;
128: l_miss_date DATE := FND_API.G_MISS_DATE;
129: l_procedure_name VARCHAR2(30) := 'CHECK_DUP_TAX_CONDITIONS';
130:
131: BEGIN
132:

Line 204: x_return_status := FND_API.G_RET_STS_ERROR;

200: AND NVL(b.VALUE_LOW,l_miss_char) = NVL(p_value_low,l_miss_char)
201: AND NVL(b.VALUE_HIGH,l_miss_char) = NVL(p_value_high,l_miss_char)
202: AND rownum = 1;
203: END IF;
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
206: FND_LOG.STRING(G_LEVEL_PROCEDURE,
207: G_MODULE_NAME || l_procedure_name,
208: 'Ended with duplicate code existing at : '||x_condition_group_code);

Line 214: x_return_status := FND_API.G_RET_STS_SUCCESS;

210:
211: EXCEPTION
212: WHEN NO_DATA_FOUND THEN
213: -- success case for us
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
216: FND_LOG.STRING(G_LEVEL_PROCEDURE,
217: G_MODULE_NAME || l_procedure_name,
218: 'Ended with NO duplicate code -- VALID record');

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

217: G_MODULE_NAME || l_procedure_name,
218: 'Ended with NO duplicate code -- VALID record');
219: END IF;
220: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: x_msg_data := SQLERRM;
223: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.STRING(G_LEVEL_PROCEDURE,
225: G_MODULE_NAME || l_procedure_name,