eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_COMMON_DIMENSIONS_PVT dependencies on BSC_COMMON_DIMENSIONS_PVT

Line 1: PACKAGE BODY BSC_COMMON_DIMENSIONS_PVT AS

1: PACKAGE BODY BSC_COMMON_DIMENSIONS_PVT AS
2: /* $Header: BSCVLIBB.pls 120.2.12000000.1 2007/07/17 07:44:52 appldev noship $ */
3:
4: PROCEDURE Get_Parent_level_properties
5: (

Line 82: BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value

78:
79: IF (l_row_cnt = 0) THEN
80: -- before creating records we will update default_value in bsc_kpi_dim_levels_b.the same way as it was
81: -- happening in VB
82: BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value
83: (
84: p_dim_level_id => l_dim_level_id
85: ,p_default_value => 'D'||l_dim_level_index
86: ,p_Tab_Id => p_tab_id

Line 95: BSC_COMMON_DIMENSIONS_PVT.Get_Parent_level_properties

91: IF(x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95: BSC_COMMON_DIMENSIONS_PVT.Get_Parent_level_properties
96: (
97: p_tab_id => p_tab_id
98: ,p_level_index => l_dim_level_index
99: ,x_parent_level_id => l_parent_level_id

Line 137: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';

133: RAISE;
134: WHEN NO_DATA_FOUND THEN
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: IF (x_msg_data IS NOT NULL) THEN
137: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
138: ELSE
139: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
140: END IF;
141:

Line 139: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';

135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: IF (x_msg_data IS NOT NULL) THEN
137: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
138: ELSE
139: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
140: END IF;
141:
142: RAISE;
143: WHEN OTHERS THEN

Line 146: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';

142: RAISE;
143: WHEN OTHERS THEN
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: IF (x_msg_data IS NOT NULL) THEN
146: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
147: ELSE
148: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
149: END IF;
150:

Line 148: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';

144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: IF (x_msg_data IS NOT NULL) THEN
146: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
147: ELSE
148: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
149: END IF;
150:
151: RAISE;
152: END insert_common_dimensions;

Line 201: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';

197: RAISE;
198: WHEN NO_DATA_FOUND THEN
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF (x_msg_data IS NOT NULL) THEN
201: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
202: ELSE
203: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
204: END IF;
205:

Line 203: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';

199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF (x_msg_data IS NOT NULL) THEN
201: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
202: ELSE
203: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
204: END IF;
205:
206: RAISE;
207: WHEN OTHERS THEN

Line 210: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';

206: RAISE;
207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF (x_msg_data IS NOT NULL) THEN
210: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
211: ELSE
212: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
213: END IF;
214:

Line 212: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';

208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF (x_msg_data IS NOT NULL) THEN
210: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
211: ELSE
212: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
213: END IF;
214:
215: RAISE;
216:

Line 266: x_msg_data := x_msg_data || ' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions_tabs ';

262: RAISE;
263: WHEN OTHERS THEN
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: IF (x_msg_data IS NOT NULL) THEN
266: x_msg_data := x_msg_data || ' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions_tabs ';
267: ELSE
268: x_msg_data := SQLERRM || ' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions_tabs ';
269: END IF;
270: RAISE;

Line 268: x_msg_data := SQLERRM || ' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions_tabs ';

264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: IF (x_msg_data IS NOT NULL) THEN
266: x_msg_data := x_msg_data || ' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions_tabs ';
267: ELSE
268: x_msg_data := SQLERRM || ' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions_tabs ';
269: END IF;
270: RAISE;
271: END delete_common_dimensions_tabs;
272:

Line 321: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';

317: RAISE;
318: WHEN NO_DATA_FOUND THEN
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: IF (x_msg_data IS NOT NULL) THEN
321: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';
322: ELSE
323: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';
324: END IF;
325:

Line 323: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';

319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: IF (x_msg_data IS NOT NULL) THEN
321: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';
322: ELSE
323: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';
324: END IF;
325:
326: RAISE;
327: WHEN OTHERS THEN

Line 330: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';

326: RAISE;
327: WHEN OTHERS THEN
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: IF (x_msg_data IS NOT NULL) THEN
330: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';
331: ELSE
332: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';
333: END IF;
334:

Line 332: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';

328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: IF (x_msg_data IS NOT NULL) THEN
330: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';
331: ELSE
332: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';
333: END IF;
334:
335: RAISE;
336:

Line 414: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';

410: RAISE;
411: WHEN NO_DATA_FOUND THEN
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: IF (x_msg_data IS NOT NULL) THEN
414: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
415: ELSE
416: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
417: END IF;
418:

Line 416: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';

412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: IF (x_msg_data IS NOT NULL) THEN
414: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
415: ELSE
416: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
417: END IF;
418:
419: RAISE;
420: WHEN OTHERS THEN

Line 423: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';

419: RAISE;
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF (x_msg_data IS NOT NULL) THEN
423: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
424: ELSE
425: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
426: END IF;
427:

Line 425: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';

421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF (x_msg_data IS NOT NULL) THEN
423: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
424: ELSE
425: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
426: END IF;
427:
428: RAISE;
429:

Line 454: SET DEFAULT_VALUE = BSC_COMMON_DIMENSIONS_PVT.C_ALL

450: BEGIN
451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452:
453: UPDATE bsc_kpi_dim_levels_b
454: SET DEFAULT_VALUE = BSC_COMMON_DIMENSIONS_PVT.C_ALL
455: WHERE indicator IN (
456: SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_Tab_Id )
457: AND default_value like BSC_COMMON_DIMENSIONS_PVT.C_COM_DIM_DEFAULT_VALUE;
458:

Line 457: AND default_value like BSC_COMMON_DIMENSIONS_PVT.C_COM_DIM_DEFAULT_VALUE;

453: UPDATE bsc_kpi_dim_levels_b
454: SET DEFAULT_VALUE = BSC_COMMON_DIMENSIONS_PVT.C_ALL
455: WHERE indicator IN (
456: SELECT indicator FROM bsc_tab_indicators WHERE tab_id = p_Tab_Id )
457: AND default_value like BSC_COMMON_DIMENSIONS_PVT.C_COM_DIM_DEFAULT_VALUE;
458:
459: EXCEPTION
460:
461: WHEN FND_API.G_EXC_ERROR THEN

Line 482: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';

478: RAISE;
479: WHEN NO_DATA_FOUND THEN
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: IF (x_msg_data IS NOT NULL) THEN
482: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
483: ELSE
484: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
485: END IF;
486:

Line 484: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';

480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: IF (x_msg_data IS NOT NULL) THEN
482: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
483: ELSE
484: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
485: END IF;
486:
487: RAISE;
488: WHEN OTHERS THEN

Line 491: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';

487: RAISE;
488: WHEN OTHERS THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF (x_msg_data IS NOT NULL) THEN
491: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
492: ELSE
493: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
494: END IF;
495:

Line 493: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';

489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF (x_msg_data IS NOT NULL) THEN
491: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
492: ELSE
493: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
494: END IF;
495:
496: RAISE;
497: END reset_dim_default_value;

Line 560: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';

556: RAISE;
557: WHEN NO_DATA_FOUND THEN
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: IF (x_msg_data IS NOT NULL) THEN
560: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
561: ELSE
562: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
563: END IF;
564:

Line 562: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';

558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: IF (x_msg_data IS NOT NULL) THEN
560: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
561: ELSE
562: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
563: END IF;
564:
565: RAISE;
566: WHEN OTHERS THEN

Line 569: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';

565: RAISE;
566: WHEN OTHERS THEN
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: IF (x_msg_data IS NOT NULL) THEN
569: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
570: ELSE
571: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
572: END IF;
573:

Line 571: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';

567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: IF (x_msg_data IS NOT NULL) THEN
569: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
570: ELSE
571: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
572: END IF;
573:
574: RAISE;
575: END set_dim_default_value;

Line 606: END BSC_COMMON_DIMENSIONS_PVT;

602: END Get_Parent_level_properties;
603:
604:
605:
606: END BSC_COMMON_DIMENSIONS_PVT;
607: