DBA Data[Home] [Help]

APPS.FII_FINANCIAL_DIMENSION_PKG dependencies on FII_UTIL

Line 74: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.update_demension(+)');

70: x_message_count out nocopy number,
71: x_error_message out nocopy varchar2) as
72: begin
73: if g_debug_flag = 'Y' then
74: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.update_demension(+)');
75: end if;
76:
77: update FII_FINANCIAL_DIMENSIONS
78: set system_enabled_flag = p_system_enabled_flag,

Line 121: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.update_demension(-)');

117: x_error_message);
118: x_status := FND_API.G_RET_STS_SUCCESS;
119:
120: if g_debug_flag = 'Y' then
121: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.update_demension(-)');
122: end if;
123:
124: exception
125: when others then

Line 134: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.update_demension(EXCEPTION)');

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)');
135: fii_util.debug_line(sqlerrm);
136: end if;
137: end;
138:

Line 135: fii_util.debug_line(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)');
135: fii_util.debug_line(sqlerrm);
136: end if;
137: end;
138:
139: procedure resetProdCateg( x_status OUT nocopy VARCHAR2,

Line 151: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(+)');

147: vsid number;
148: col_name varchar2(30);
149: begin
150: if g_debug_flag = 'Y' then
151: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(+)');
152: end if;
153:
154: for r in dim loop
155: begin

Line 198: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(-)');

194: end loop;
195:
196: x_status := FND_API.G_RET_STS_SUCCESS;
197: if g_debug_flag = 'Y' then
198: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(-)');
199: end if;
200:
201: exception
202: when others then

Line 211: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.resetProdCateg(EXCEPTION)');

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)');
212: fii_util.debug_line(sqlerrm);
213: end if;
214: end;
215:

Line 212: fii_util.debug_line(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)');
212: fii_util.debug_line(sqlerrm);
213: end if;
214: end;
215:
216:

Line 295: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(+)');

291: x.usage_code='DBI');
292:
293: begin
294: if g_debug_flag = 'Y' then
295: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(+)');
296: end if;
297:
298: if p_event = 'D' then
299: delete from fii_dim_mapping_rules

Line 419: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(-)');

415: end if;
416: end if;
417:
418: if g_debug_flag = 'Y' then
419: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(-)');
420: end if;
421:
422: exception
423: when others then

Line 432: fii_util.debug_line('FII_FINANCIAL_DIMENSION_PKG.manage_dimension_map_rules(EXCEPTION)');

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)');
433: fii_util.debug_line(sqlerrm);
434: end if;
435: end;
436:

Line 433: fii_util.debug_line(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)');
433: fii_util.debug_line(sqlerrm);
434: end if;
435: end;
436:
437:

Line 458: FII_UTIL.debug_line('FII_FINANCIAL_DIMENSION_PKG.DeleteJeInclusionRules(+)');

454: l_msg_count number;
455: l_msg_data varchar2(2000);
456: BEGIN
457: IF g_debug_flag = 'Y' THEN
458: FII_UTIL.debug_line('FII_FINANCIAL_DIMENSION_PKG.DeleteJeInclusionRules(+)');
459: END IF;
460:
461: DELETE FROM GL_JE_INCLUSION_RULES
462: WHERE je_rule_set_id = p_je_rule_set_id;

Line 470: FII_UTIL.debug_line('FII_FINANCIAL_DIMENSION_PKG.update_demension(-)');

466:
467: x_status := FND_API.G_RET_STS_SUCCESS;
468:
469: IF g_debug_flag = 'Y' THEN
470: FII_UTIL.debug_line('FII_FINANCIAL_DIMENSION_PKG.update_demension(-)');
471: END IF;
472:
473: EXCEPTION
474: WHEN OTHERS THEN

Line 483: FII_UTIL.debug_line('FII_FINANCIAL_DIMENSION_PKG.DeleteJeInclusionRules(EXCEPTION)');

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)');
484: FII_UTIL.debug_line(sqlerrm);
485: END IF;
486: END;
487:

Line 484: FII_UTIL.debug_line(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)');
484: FII_UTIL.debug_line(sqlerrm);
485: END IF;
486: END;
487:
488: end FII_FINANCIAL_DIMENSION_PKG;