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);
2088: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
2089: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2090:
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);
2088: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
2089: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2090:
2091: x_msg_data := fnd_message.get;
2084: x_msg_count := 1;
2085:
2086: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
2087: fnd_message.set_token('ERROR_TEXT', SQLERRM);
2088: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
2089: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2090:
2091: x_msg_data := fnd_message.get;
2092: WHEN OTHERS THEN
2085:
2086: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
2087: fnd_message.set_token('ERROR_TEXT', SQLERRM);
2088: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
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;
2087: fnd_message.set_token('ERROR_TEXT', SQLERRM);
2088: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
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);
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);
2176: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
2177: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2178:
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);
2176: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
2177: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2178:
2179: x_msg_data := fnd_message.get;
2172: x_msg_count := 1;
2173:
2174: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
2175: fnd_message.set_token('ERROR_TEXT', SQLERRM);
2176: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
2177: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2178:
2179: x_msg_data := fnd_message.get;
2180: WHEN OTHERS THEN
2173:
2174: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
2175: fnd_message.set_token('ERROR_TEXT', SQLERRM);
2176: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
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;
2175: fnd_message.set_token('ERROR_TEXT', SQLERRM);
2176: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
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 ;