DBA Data[Home] [Help]

APPS.CZ_MIGRATE dependencies on FND_API

Line 541: IF(xReturnStatus = FND_API.G_RET_STS_ERROR)THEN

537: x_return_status => xReturnStatus,
538: x_msg_count => xMsgCount,
539: x_msg_data => xMsgData);
540:
541: IF(xReturnStatus = FND_API.G_RET_STS_ERROR)THEN
542:
543: --Bug #4058286 - do not stop if a jrad document is missing.
544:
545: report(xMsgData, URGENCY_WARNING);

Line 547: ELSIF(xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR)THEN

543: --Bug #4058286 - do not stop if a jrad document is missing.
544:
545: report(xMsgData, URGENCY_WARNING);
546:
547: ELSIF(xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR)THEN
548:
549: report(xMsgData, URGENCY_ERROR);
550: RETURN FATAL_ERROR;
551: END IF;

Line 559: IF(xReturnStatus = FND_API.G_RET_STS_ERROR)THEN

555: x_return_status => xReturnStatus,
556: x_msg_count => xMsgCount,
557: x_msg_data => xMsgData);
558:
559: IF(xReturnStatus = FND_API.G_RET_STS_ERROR)THEN
560:
561: --Bug #4058286 - do not stop if a jrad document is missing.
562:
563: report(xMsgData, URGENCY_WARNING);

Line 565: ELSIF(xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR)THEN

561: --Bug #4058286 - do not stop if a jrad document is missing.
562:
563: report(xMsgData, URGENCY_WARNING);
564:
565: ELSIF(xReturnStatus = FND_API.G_RET_STS_UNEXP_ERROR)THEN
566:
567: report(xMsgData, URGENCY_ERROR);
568: RETURN FATAL_ERROR;
569: END IF;

Line 2079: x_return_status := FND_API.G_RET_STS_ERROR;

2075: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2076: delete from cz_jrad_chunks; commit;
2077: EXCEPTION
2078: WHEN NO_DATA_FOUND THEN
2079: x_return_status := FND_API.G_RET_STS_ERROR;
2080: x_msg_count := 1;
2081: x_msg_data := CZ_UTILS.GET_TEXT('CZ_NO_JRADDOC_EXISTS','DOC',p_ui_def_id );
2082: WHEN EXPLORETREE_ERROR THEN
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2079: x_return_status := FND_API.G_RET_STS_ERROR;
2080: x_msg_count := 1;
2081: x_msg_data := CZ_UTILS.GET_TEXT('CZ_NO_JRADDOC_EXISTS','DOC',p_ui_def_id );
2082: WHEN EXPLORETREE_ERROR THEN
2083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2084: x_msg_count := 1;
2085:
2086: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
2087: fnd_message.set_token('ERROR_TEXT', SQLERRM);

Line 2093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2089: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2090:
2091: x_msg_data := fnd_message.get;
2092: WHEN OTHERS THEN
2093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2094: x_msg_count := 1;
2095: x_msg_data := CZ_UTILS.GET_TEXT('CZ_JRADDOC_EXPERR', 'ERR', SQLERRM);
2096: END import_jrad_docs;
2097:

Line 2116: x_return_status := FND_API.G_RET_STS_SUCCESS;

2112: l_seq_nbr cz_jrad_chunks.seq_nbr%TYPE;
2113: l_XML_CHUNK VARCHAR2(32767);
2114:
2115: BEGIN
2116: x_return_status := FND_API.G_RET_STS_SUCCESS;
2117: IF (p_link_name IS NULL) THEN l_link_name := ' ';
2118: ELSE l_link_name := '@'||p_link_name;
2119: END IF;
2120:

Line 2171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2167: EXCEPTION
2168: WHEN NO_DATA_FOUND THEN
2169: NULL;
2170: WHEN EXPLORETREE_ERROR THEN
2171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2172: x_msg_count := 1;
2173:
2174: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
2175: fnd_message.set_token('ERROR_TEXT', SQLERRM);

Line 2181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2177: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2178:
2179: x_msg_data := fnd_message.get;
2180: WHEN OTHERS THEN
2181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2182: x_msg_data := SQLERRM;
2183: END import_template_jrad_docs ;
2184: ------------------------------------------------------------------------------------------------------------
2185: END cz_migrate;