124: exception
125: when others then
126: x_status := FND_API.G_RET_STS_ERROR;
127: x_message_count := 1;
128: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
129: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.update_dimension');
130: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
131: FND_MSG_PUB.ADD;
132: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
125: when others then
126: x_status := FND_API.G_RET_STS_ERROR;
127: x_message_count := 1;
128: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
129: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.update_dimension');
130: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
131: FND_MSG_PUB.ADD;
132: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
133: if g_debug_flag = 'Y' then
126: x_status := FND_API.G_RET_STS_ERROR;
127: x_message_count := 1;
128: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
129: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.update_dimension');
130: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
131: FND_MSG_PUB.ADD;
132: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
133: if g_debug_flag = 'Y' then
134: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.update_demension(EXCEPTION)');
201: exception
202: when others then
203: x_status := FND_API.G_RET_STS_ERROR;
204: x_message_count := 1;
205: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
206: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.resetProdCateg');
207: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
208: FND_MSG_PUB.ADD;
209: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
202: when others then
203: x_status := FND_API.G_RET_STS_ERROR;
204: x_message_count := 1;
205: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
206: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.resetProdCateg');
207: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
208: FND_MSG_PUB.ADD;
209: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
210: if g_debug_flag = 'Y' then
203: x_status := FND_API.G_RET_STS_ERROR;
204: x_message_count := 1;
205: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
206: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.resetProdCateg');
207: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
208: FND_MSG_PUB.ADD;
209: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
210: if g_debug_flag = 'Y' then
211: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.resetProdCateg(EXCEPTION)');
422: exception
423: when others then
424: x_status := FND_API.G_RET_STS_ERROR;
425: x_message_count := 1;
426: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
427: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules');
428: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
429: FND_MSG_PUB.ADD;
430: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
423: when others then
424: x_status := FND_API.G_RET_STS_ERROR;
425: x_message_count := 1;
426: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
427: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules');
428: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
429: FND_MSG_PUB.ADD;
430: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
431: if g_debug_flag = 'Y' then
424: x_status := FND_API.G_RET_STS_ERROR;
425: x_message_count := 1;
426: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
427: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules');
428: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
429: FND_MSG_PUB.ADD;
430: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
431: if g_debug_flag = 'Y' then
432: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(EXCEPTION)');
473: EXCEPTION
474: WHEN OTHERS THEN
475: x_status := FND_API.G_RET_STS_ERROR;
476: x_message_count := 1;
477: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
478: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.DeleteJeInclusionRules');
479: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
480: FND_MSG_PUB.ADD;
481: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
474: WHEN OTHERS THEN
475: x_status := FND_API.G_RET_STS_ERROR;
476: x_message_count := 1;
477: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
478: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.DeleteJeInclusionRules');
479: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
480: FND_MSG_PUB.ADD;
481: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
482: IF g_debug_flag = 'Y' THEN
475: x_status := FND_API.G_RET_STS_ERROR;
476: x_message_count := 1;
477: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
478: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_FINANCIAL_DIMENSION_PKG.DeleteJeInclusionRules');
479: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
480: FND_MSG_PUB.ADD;
481: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
482: IF g_debug_flag = 'Y' THEN
483: FII_UTIL.debug_line('FII_FINANCIAL_DIMENSION_PKG.DeleteJeInclusionRules(EXCEPTION)');