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
137: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
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
137: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
138: 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
263: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
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
263: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
264: 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
384: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
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
384: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
385: END IF;
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;
412: END IF;
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;
412: END IF;
413:
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;
425: END IF;
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;
425: END IF;
426:
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;
437: END IF;
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;
437: END IF;
438: