APPS.ZX_SECURITY dependencies on FND_API

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

284: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'SET_SECURITY_CONTEXT.BEGIN','ZX_SECURITY: CHECK_WRITE_ACCESS()+');
286: END IF;
287:
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289: IF fnd_profile.value('ZX_GCO_WRITE_ACCESS') = 'Y' then
290: IF p_first_party_org_id <> -99 then
291: select 1
292: into l_count

Line 313: x_return_status := FND_API.G_RET_STS_ERROR;

309: END IF;
310:
311: EXCEPTION
312: WHEN NO_DATA_FOUND THEN
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: FND_MESSAGE.Set_Name ('ZX','GENERIC_MESSAGE');
315: FND_MESSAGE.Set_Token('GENERIC_TEXT', SQLERRM);
316:
317: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

318: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'SET_SECURITY_CONTEXT', SQLERRM);
319: END IF;
320:
321: WHEN OTHERS THEN
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
324: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||'SET_SECURITY_CONTEXT', SQLERRM);
325: END IF;
326:

Line 401: x_return_status := FND_API.G_RET_STS_SUCCESS;

397: 'ZX_SECURITY: SET_SECURITY_CONTEXT()+' ||
398: ', OU: '||to_char(p_internal_org_id)||' and LE: '||to_char(p_legal_entity_id));
399: END IF;
400:
401: x_return_status := FND_API.G_RET_STS_SUCCESS;
402:
403: L_EFFECTIVE_DATE := nvl(p_effective_date,sysdate);
404:
405: ZX_TCM_PTP_PKG.GET_TAX_SUBSCRIBER(p_legal_entity_id,

Line 427: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

423: name_value('EFFECTIVEDATE',to_char(L_EFFECTIVE_DATE));
424: G_EFFECTIVE_DATE := L_EFFECTIVE_DATE;
425: END IF;
426:
427: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
428: x_return_status := FND_API.G_RET_STS_ERROR;
429:
430: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
431: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 428: x_return_status := FND_API.G_RET_STS_ERROR;

424: G_EFFECTIVE_DATE := L_EFFECTIVE_DATE;
425: END IF;
426:
427: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
428: x_return_status := FND_API.G_RET_STS_ERROR;
429:
430: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
431: FND_LOG.STRING(G_LEVEL_STATEMENT,
432: G_MODULE_NAME||'SET_SECURITY_CONTEXT',

Line 469: x_return_status := FND_API.G_RET_STS_SUCCESS;

465: 'ZX_SECURITY: SET_SECURITY_CONTEXT()+' ||
466: ', OU: '||to_char(p_internal_org_id)||' and LE: '||to_char(p_legal_entity_id));
467: END IF;
468:
469: x_return_status := FND_API.G_RET_STS_SUCCESS;
470:
471: L_EFFECTIVE_DATE := nvl(p_effective_date,sysdate);
472:
473: ZX_TCM_PTP_PKG.GET_TAX_SUBSCRIBER(p_legal_entity_id,

Line 506: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

502: name_value('EFFECTIVEDATE',to_char(L_EFFECTIVE_DATE));
503: G_EFFECTIVE_DATE := L_EFFECTIVE_DATE;
504: END IF;
505:
506: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508:
509: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 507: x_return_status := FND_API.G_RET_STS_ERROR;

503: G_EFFECTIVE_DATE := L_EFFECTIVE_DATE;
504: END IF;
505:
506: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508:
509: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.STRING(G_LEVEL_STATEMENT,
511: G_MODULE_NAME||'SET_SECURITY_CONTEXT',

Line 545: x_return_status := FND_API.G_RET_STS_SUCCESS;

541: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'SET_SECURITY_CONTEXT.BEGIN','ZX_SECURITY: SET_SECURITY_CONTEXT()+');
543: END IF;
544:
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547: L_EFFECTIVE_DATE := nvl(p_effective_date,sysdate);
548:
549: L_FIRST_PARTY_ORG_ID := p_first_party_org_id;