DBA Data[Home] [Help]

APPS.FII_CHANGE_LOG_PKG dependencies on FII_UTIL

Line 14: fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(+)');

10: x_message_count out nocopy number,
11: x_error_message out nocopy varchar2) is
12: begin
13: if g_debug_flag = 'Y' then
14: fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(+)');
15: end if;
16:
17: update fii_change_log
18: set item_value = p_item_value,

Line 26: fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(-)');

22: where log_item = p_log_item;
23:
24: x_status := FND_API.G_RET_STS_SUCCESS;
25: if g_debug_flag = 'Y' then
26: fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(-)');
27: end if;
28:
29: exception
30: when others then

Line 39: fii_util.debug_line('FII_CHANGE_LOG_PKG.update_change_log(EXCEPTION)');

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;
42: end;
43:

Line 40: fii_util.debug_line(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;
42: end;
43:
44:

Line 50: fii_util.debug_line('FII_CHANGE_LOG_PKG.set_recollection_for_fii(+)');

46: x_message_count out nocopy number,
47: x_error_message out nocopy varchar2) is
48: begin
49: if g_debug_flag = 'Y' then
50: fii_util.debug_line('FII_CHANGE_LOG_PKG.set_recollection_for_fii(+)');
51: end if;
52:
53: UPDATE FII_CHANGE_LOG
54: SET item_value = 'Y',

Line 66: fii_util.debug_line('FII_CHANGE_LOG_PKG.set_recollection_for_fii(-)');

62: 'CCID_RELOAD',
63: 'FA_RESUMMARIZE');
64:
65: if g_debug_flag = 'Y' then
66: fii_util.debug_line('FII_CHANGE_LOG_PKG.set_recollection_for_fii(-)');
67: end if;
68: x_status := FND_API.G_RET_STS_SUCCESS;
69:
70: exception

Line 80: fii_util.debug_line('FII_CHANGE_LOG_PKG.set_recollection_for_fii(EXCEPTION)');

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;
83:
84: end;

Line 81: fii_util.debug_line(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;
83:
84: end;
85:

Line 96: fii_util.debug_line('FII_CHANGE_LOG_PKG.add_change_log_item(+)');

92: l_item_count NUMBER(15);
93:
94: begin
95: if g_debug_flag = 'Y' then
96: fii_util.debug_line('FII_CHANGE_LOG_PKG.add_change_log_item(+)');
97: end if;
98:
99: --Check if this item exists in fii_change_log table.
100: --Add item only if it doesn't already exist.

Line 124: fii_util.debug_line('FII_CHANGE_LOG_PKG.add_change_log_item(-)');

120:
121: END IF;
122:
123: if g_debug_flag = 'Y' then
124: fii_util.debug_line('FII_CHANGE_LOG_PKG.add_change_log_item(-)');
125: end if;
126: x_status := FND_API.G_RET_STS_SUCCESS;
127:
128: exception

Line 138: fii_util.debug_line('FII_CHANGE_LOG_PKG.add_change_log_item(EXCEPTION)');

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;
141:
142: end;

Line 139: fii_util.debug_line(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;
141:
142: end;
143: