APPS.ZX_TCM_VALIDATE_EXEMPT_PKG dependencies on FND_API

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS;

39: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
40: BEGIN
41: -- Logging Infra: Setting up runtime message level
42: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44: x_valid_flag := 'N';
45: IF p_legal_entity_id IS NULL THEN
46: IF p_trx_type_id IS NOT NULL AND p_batch_source_id IS NOT NULL AND p_org_id IS NOT NULL THEN
47: BEGIN

Line 56: x_return_status := FND_API.G_RET_STS_ERROR;

52: p_batch_source_id => p_batch_source_id, -- IN
53: p_operating_unit_id => p_org_id -- IN
54: );
55: EXCEPTION WHEN OTHERS THEN
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
58: l_log_msg := 'Function XLE_BUSINESSINFO_GRP.Get_OrdertoCash_Info returned errors';
59: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
60: END IF;

Line 64: x_return_status := FND_API.G_RET_STS_ERROR;

60: END IF;
61:
62: END;
63: ELSE
64: x_return_status := FND_API.G_RET_STS_ERROR;
65: ----- Unable to derive legal entity
66: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
67: l_log_msg := 'Transaction Type Id or Batch source Id or Org Id is null.';
68: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 75: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

71: ELSE
72: l_legal_entity_id := p_legal_entity_id;
73:
74: END IF;
75: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
76: RAISE FND_API.G_EXC_ERROR;
77:
78: END IF;
79: IF l_legal_entity_id IS NOT NULL THEN

Line 76: RAISE FND_API.G_EXC_ERROR;

72: l_legal_entity_id := p_legal_entity_id;
73:
74: END IF;
75: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
76: RAISE FND_API.G_EXC_ERROR;
77:
78: END IF;
79: IF l_legal_entity_id IS NOT NULL THEN
80:

Line 166: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN

162: x_valid_flag := 'N';
163:
164: END IF;
165:
166: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: -- Logging Infra: Statement level
169: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
170: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR';

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163:
164: END IF;
165:
166: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: -- Logging Infra: Statement level
169: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
170: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR';
171: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 170: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR';

166: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: -- Logging Infra: Statement level
169: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
170: l_log_msg := 'E: EXC: FND_API.G_EXC_ERROR';
171: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
172: END IF;
173:
174: WHEN OTHERS THEN

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

171: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
172: END IF;
173:
174: WHEN OTHERS THEN
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: -- Logging Infra: Statement level
177: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
178: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'E: EXC: OTHERS: '||SQLCODE||': '||SQLERRM);
179: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);