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_DEFAULT_KEY_ITEM_PUB dependencies on BSC_DEFAULT_KEY_ITEM_PUB

Line 1: PACKAGE BODY BSC_DEFAULT_KEY_ITEM_PUB AS

1: PACKAGE BODY BSC_DEFAULT_KEY_ITEM_PUB AS
2: /* $Header: BSCPDKIB.pls 120.4.12000000.2 2007/10/15 06:41:06 psomesul noship $ */
3:
4: PROCEDURE Validate_key_shared_obj
5: (

Line 101: l_key_name := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value

97: WHERE indicator = p_kpi_id
98: AND dim_set_id = l_dim_set_id
99: AND dim_level_index = l_dim_level_index;
100:
101: l_key_name := BSC_DEFAULT_KEY_ITEM_PUB.get_table_column_value
102: (
103: p_table_name => l_level_view_name
104: , p_column_name => 'NAME'
105: , p_where_cond => 'CODE=' || l_def_key_id

Line 141: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';

137:
138: WHEN NO_DATA_FOUND THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: IF (x_msg_data IS NOT NULL) THEN
141: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
142: ELSE
143: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
144: END IF;
145: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 143: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';

139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: IF (x_msg_data IS NOT NULL) THEN
141: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
142: ELSE
143: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
144: END IF;
145: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
146: WHEN OTHERS THEN
147:

Line 150: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';

146: WHEN OTHERS THEN
147:
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: IF (x_msg_data IS NOT NULL) THEN
150: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
151: ELSE
152: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
153: END IF;
154: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 152: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';

148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: IF (x_msg_data IS NOT NULL) THEN
150: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
151: ELSE
152: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj ';
153: END IF;
154: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
155: END Validate_key_shared_obj;
156:

Line 248: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Update_Default_Key_Items ';

244: WHEN OTHERS THEN
245: ROLLBACK TO bsc_key_item_pub_upd_key_item;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: IF (x_msg_data IS NOT NULL) THEN
248: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Update_Default_Key_Items ';
249: ELSE
250: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Update_Default_Key_Items ';
251: END IF;
252: END Update_Default_Key_Items;

Line 250: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Update_Default_Key_Items ';

246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: IF (x_msg_data IS NOT NULL) THEN
248: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Update_Default_Key_Items ';
249: ELSE
250: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Update_Default_Key_Items ';
251: END IF;
252: END Update_Default_Key_Items;
253:
254:

Line 330: BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item

326: END IF;
327: END LOOP;
328: --now call pradeep's update API
329:
330: BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item
331: (
332: p_kpi_id => l_indicator
333: , p_params => l_params
334: , p_commit => FND_API.G_FALSE

Line 369: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';

365: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
366: WHEN NO_DATA_FOUND THEN
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: IF (x_msg_data IS NOT NULL) THEN
369: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
370: ELSE
371: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
372: END IF;
373: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 371: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';

367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: IF (x_msg_data IS NOT NULL) THEN
369: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
370: ELSE
371: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
372: END IF;
373: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
374: WHEN OTHERS THEN
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 377: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';

373: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
374: WHEN OTHERS THEN
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: IF (x_msg_data IS NOT NULL) THEN
377: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
378: ELSE
379: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
380: END IF;
381: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 379: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';

375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: IF (x_msg_data IS NOT NULL) THEN
377: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
378: ELSE
379: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Set_Key_Item_Value ';
380: END IF;
381: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
382: END Set_Key_Item_Value;
383:

Line 425: BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj

421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422:
423: IF (p_kpi_id IS NOT NULL AND p_params IS NOT NULL) THEN
424:
425: BSC_DEFAULT_KEY_ITEM_PUB.Validate_key_shared_obj
426: (
427: p_kpi_id => p_kpi_id
428: , p_params => p_params
429: , x_return_status => x_return_status

Line 655: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item ';

651:
652: WHEN OTHERS THEN
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: IF (x_msg_data IS NOT NULL) THEN
655: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item ';
656: ELSE
657: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item ';
658: END IF;
659: IF(ref_cur%ISOPEN) THEN

Line 657: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item ';

653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: IF (x_msg_data IS NOT NULL) THEN
655: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item ';
656: ELSE
657: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Update_Key_Item ';
658: END IF;
659: IF(ref_cur%ISOPEN) THEN
660: CLOSE ref_cur;
661: END IF;

Line 732: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Cascade_Key_Item_Changes ';

728: WHEN OTHERS THEN
729:
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: IF (x_msg_data IS NOT NULL) THEN
732: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Cascade_Key_Item_Changes ';
733: ELSE
734: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Cascade_Key_Item_Changes ';
735: END IF;
736: RAISE;

Line 734: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Cascade_Key_Item_Changes ';

730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: IF (x_msg_data IS NOT NULL) THEN
732: x_msg_data := x_msg_data||' -> BSC_DEFAULT_KEY_ITEM_PUB.Cascade_Key_Item_Changes ';
733: ELSE
734: x_msg_data := SQLERRM||' at BSC_DEFAULT_KEY_ITEM_PUB.Cascade_Key_Item_Changes ';
735: END IF;
736: RAISE;
737: END Cascade_Key_Item_Changes;
738:

Line 739: END BSC_DEFAULT_KEY_ITEM_PUB;

735: END IF;
736: RAISE;
737: END Cascade_Key_Item_Changes;
738:
739: END BSC_DEFAULT_KEY_ITEM_PUB;
740: