32: x_message_count := 1;
33: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
34: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_CHANGE_LOG_PKG.update_change_log');
35: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
36: FND_MSG_PUB.ADD;
37: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
38: if g_debug_flag = 'Y' then
39: fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(EXCEPTION)');
40: fii_util.debug_line(sqlerrm);
33: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
34: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_CHANGE_LOG_PKG.update_change_log');
35: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
36: FND_MSG_PUB.ADD;
37: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
38: if g_debug_flag = 'Y' then
39: fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(EXCEPTION)');
40: fii_util.debug_line(sqlerrm);
41: end if;
73: x_message_count := 1;
74: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
75: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_CHANGE_LOG_PKG.set_recollection_for_fii');
76: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
77: FND_MSG_PUB.ADD;
78: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
79: if g_debug_flag = 'Y' then
80: fii_util.debug_line('FII_CHANGE_LOG_PKG.set_recollection_for_fii(EXCEPTION)');
81: fii_util.debug_line(sqlerrm);
74: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
75: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_CHANGE_LOG_PKG.set_recollection_for_fii');
76: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
77: FND_MSG_PUB.ADD;
78: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
79: if g_debug_flag = 'Y' then
80: fii_util.debug_line('FII_CHANGE_LOG_PKG.set_recollection_for_fii(EXCEPTION)');
81: fii_util.debug_line(sqlerrm);
82: end if;
131: x_message_count := 1;
132: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
133: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_CHANGE_LOG_PKG.add_change_log_item');
134: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
135: FND_MSG_PUB.ADD;
136: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
137: if g_debug_flag = 'Y' then
138: fii_util.debug_line('FII_CHANGE_LOG_PKG.add_change_log_item(EXCEPTION)');
139: fii_util.debug_line(sqlerrm);
132: FND_MESSAGE.SET_NAME ('FII','FII_ERROR');
133: FND_MESSAGE.SET_TOKEN('FUNCTION', 'FII_CHANGE_LOG_PKG.add_change_log_item');
134: FND_MESSAGE.SET_TOKEN('SQLERRMC', sqlerrm);
135: FND_MSG_PUB.ADD;
136: FND_MSG_PUB.Count_And_Get(p_count => x_message_count, p_data => x_error_message);
137: if g_debug_flag = 'Y' then
138: fii_util.debug_line('FII_CHANGE_LOG_PKG.add_change_log_item(EXCEPTION)');
139: fii_util.debug_line(sqlerrm);
140: end if;