DBA Data[Home] [Help]

APPS.ZX_EVNT_OPTIONS_MIGRATE_PKG dependencies on FND_API

Line 27: x_return_status := FND_API.G_RET_STS_SUCCESS;

23: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
24: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
25: END IF;
26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: INSERT INTO ZX_EVNT_CLS_OPTIONS (
30: EVENT_CLASS_OPTIONS_ID,
31: APPLICATION_ID,

Line 132: x_return_status := FND_API.G_RET_STS_ERROR ;

128: END IF;
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: x_return_status := FND_API.G_RET_STS_ERROR ;
133: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
134: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT',' AP Event Class Options Migration : '||SQLERRM);
135: FND_MSG_PUB.Add;
136: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 151: x_return_status := FND_API.G_RET_STS_SUCCESS;

147: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
148: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
149: END IF;
150:
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152:
153: INSERT INTO ZX_EVNT_CLS_OPTIONS (
154: EVENT_CLASS_OPTIONS_ID,
155: APPLICATION_ID,

Line 258: x_return_status := FND_API.G_RET_STS_ERROR ;

254: END IF;
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: x_return_status := FND_API.G_RET_STS_ERROR ;
259: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
260: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','AR Event Class Options Migration : '||SQLERRM);
261: FND_MSG_PUB.Add;
262: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 278: x_return_status := FND_API.G_RET_STS_SUCCESS;

274: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
275: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
276: END IF;
277:
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:
280: INSERT INTO ZX_EVNT_CLS_OPTIONS (
281: EVENT_CLASS_OPTIONS_ID,
282: APPLICATION_ID,

Line 379: x_return_status := FND_API.G_RET_STS_ERROR ;

375: END IF;
376:
377: EXCEPTION
378: WHEN OTHERS THEN
379: x_return_status := FND_API.G_RET_STS_ERROR ;
380: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
381: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT',' PO Event Class Options Migration : '||SQLERRM);
382: FND_MSG_PUB.Add;
383: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 399: x_return_status := FND_API.G_RET_STS_SUCCESS;

395: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
396: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
397: END IF;
398:
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400:
401: /*-----------------------------------------------------+
402: | Process records from AR |
403: +-----------------------------------------------------*/

Line 406: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

402: | Process records from AR |
403: +-----------------------------------------------------*/
404: AR_OPTIONS_MIGRATE(l_return_status);
405:
406: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
407: x_return_status := FND_API.G_RET_STS_ERROR ;
408: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
409: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Event Class Options Migration : '||SQLERRM);
410: FND_MSG_PUB.Add;

Line 407: x_return_status := FND_API.G_RET_STS_ERROR ;

403: +-----------------------------------------------------*/
404: AR_OPTIONS_MIGRATE(l_return_status);
405:
406: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
407: x_return_status := FND_API.G_RET_STS_ERROR ;
408: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
409: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Event Class Options Migration : '||SQLERRM);
410: FND_MSG_PUB.Add;
411: RETURN;

Line 419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

415: /*-----------------------------------------------------+
416: | Process records from AP |
417: +-----------------------------------------------------*/
418: AP_OPTIONS_MIGRATE (l_return_status);
419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
420: x_return_status := FND_API.G_RET_STS_ERROR ;
421: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
422: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Event Class Options Migration : '||SQLERRM);
423: FND_MSG_PUB.Add;

Line 420: x_return_status := FND_API.G_RET_STS_ERROR ;

416: | Process records from AP |
417: +-----------------------------------------------------*/
418: AP_OPTIONS_MIGRATE (l_return_status);
419: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
420: x_return_status := FND_API.G_RET_STS_ERROR ;
421: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
422: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Event Class Options Migration : '||SQLERRM);
423: FND_MSG_PUB.Add;
424: RETURN;

Line 431: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

427: /*-----------------------------------------------------+
428: | Process records from PO |
429: +-----------------------------------------------------*/
430: PO_OPTIONS_MIGRATE (l_return_status);
431: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
432: x_return_status := FND_API.G_RET_STS_ERROR ;
433: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
434: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Event Class Options Migration : '||SQLERRM);
435: FND_MSG_PUB.Add;

Line 432: x_return_status := FND_API.G_RET_STS_ERROR ;

428: | Process records from PO |
429: +-----------------------------------------------------*/
430: PO_OPTIONS_MIGRATE (l_return_status);
431: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
432: x_return_status := FND_API.G_RET_STS_ERROR ;
433: FND_MESSAGE.SET_NAME ('ZX','GENERIC_MESSAGE');
434: FND_MESSAGE.SET_TOKEN ('GENERIC_TEXT','Event Class Options Migration : '||SQLERRM);
435: FND_MSG_PUB.Add;
436: RETURN;