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_DIM_LEVEL_FILTERS_PUB dependencies on BSC_DIM_LEVEL_FILTERS_PUB

Line 1: PACKAGE BODY BSC_DIM_LEVEL_FILTERS_PUB AS

1: PACKAGE BODY BSC_DIM_LEVEL_FILTERS_PUB AS
2: /* $Header: BSCPFILB.pls 120.5 2007/12/21 09:14:40 psomesul noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 121: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';

117: WHEN NO_DATA_FOUND THEN
118:
119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120: IF (x_msg_data IS NOT NULL) THEN
121: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';
122: ELSE
123: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';
124: END IF;
125: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 123: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';

119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
120: IF (x_msg_data IS NOT NULL) THEN
121: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';
122: ELSE
123: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';
124: END IF;
125: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
126:
127: WHEN OTHERS THEN

Line 131: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';

127: WHEN OTHERS THEN
128:
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: IF (x_msg_data IS NOT NULL) THEN
131: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';
132: ELSE
133: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';
134: END IF;
135: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 133: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';

129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: IF (x_msg_data IS NOT NULL) THEN
131: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';
132: ELSE
133: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.Validate_List_Button_Security ';
134: END IF;
135: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
136: END Validate_List_Button_Security;
137:

Line 198: -- BSC_DIM_LEVEL_FILTERS_PUB.check_key_values(

194: IF(x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
195: RETURN;
196: END IF;
197:
198: -- BSC_DIM_LEVEL_FILTERS_PUB.check_key_values(
199: validate_key_items(
200: p_tab_id => p_tab_id
201: ,p_dim_level_id => p_dim_level_id
202: ,p_level_vals_list => p_level_vals_list

Line 254: BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view(

250: --INSERT INTO bsc_sys_filters(source_type, source_code, dim_level_id,dim_level_value) VALUES (1,p_tab_id , p_dim_level_id, 0);
251: END IF;
252:
253: --Validate and rebuild level values VIEW definition and validate each child dimension object
254: BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view(
255: p_tab_id => p_tab_id
256: ,p_dim_level_id => p_dim_level_id
257: ,x_return_status => x_return_status
258: ,x_msg_count => x_msg_count

Line 269: BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns(

265: ,x_msg_data => x_msg_data
266: );
267:
268: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
269: BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns(
270: p_tab_id => p_tab_id
271: ,x_return_status => x_return_status
272: ,x_msg_count => x_msg_count
273: ,x_msg_data => x_msg_data

Line 409: BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view(

405: EXIT;
406: END LOOP;
407:
408: IF (l_need_view) THEN
409: BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view(
410: p_tab_id => p_tab_id
411: , p_dim_level_id => p_dim_level_id
412: , p_commit => p_commit
413: , x_return_status => x_return_status

Line 473: BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable(

469:
470:
471: FOR cd IN c_childs LOOP
472: IF (l_need_view) THEN
473: BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable(
474: p_tab_id => p_tab_id,
475: p_ch_level_id => cd.child_dim_level_id,
476: p_pa_level_id => p_dim_level_id,
477: p_commit => p_commit,

Line 485: BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view(

481: );
482: END IF;
483:
484: --RECURSIVE CALL TO PROCESS THE CHILD
485: BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view(
486: p_tab_id => p_tab_id,
487: p_dim_level_id => cd.child_dim_level_id,
488: x_return_status => x_return_status,
489: x_msg_count => x_msg_count,

Line 520: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';

516: WHEN NO_DATA_FOUND THEN
517:
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: IF (x_msg_data IS NOT NULL) THEN
520: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';
521: ELSE
522: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';
523: END IF;
524:

Line 522: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';

518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
519: IF (x_msg_data IS NOT NULL) THEN
520: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';
521: ELSE
522: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';
523: END IF;
524:
525: RAISE;
526:

Line 531: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';

527: WHEN OTHERS THEN
528:
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF (x_msg_data IS NOT NULL) THEN
531: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';
532: ELSE
533: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';
534: END IF;
535: RAISE;

Line 533: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';

529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF (x_msg_data IS NOT NULL) THEN
531: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';
532: ELSE
533: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.process_filter_view ';
534: END IF;
535: RAISE;
536: END process_filter_view;
537:

Line 606: l_view := BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name(

602: IF (l_table is NULL) THEN
603: RETURN;
604: END IF;
605:
606: l_view := BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name(
607: p_dimension_table => l_table,
608: x_return_status => x_return_status,
609: x_msg_count => x_msg_count,
610: x_msg_data => x_msg_data

Line 699: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';

695:
696: WHEN NO_DATA_FOUND THEN
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: IF (x_msg_data IS NOT NULL) THEN
699: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';
700: ELSE
701: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';
702: END IF;
703:

Line 701: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';

697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: IF (x_msg_data IS NOT NULL) THEN
699: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';
700: ELSE
701: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';
702: END IF;
703:
704: RAISE;
705:

Line 709: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';

705:
706: WHEN OTHERS THEN
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708: IF (x_msg_data IS NOT NULL) THEN
709: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';
710: ELSE
711: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';
712: END IF;
713: RAISE;

Line 711: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';

707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708: IF (x_msg_data IS NOT NULL) THEN
709: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';
710: ELSE
711: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.create_filter_view ';
712: END IF;
713: RAISE;
714:
715: END create_filter_view;

Line 791: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';

787: WHEN NO_DATA_FOUND THEN
788:
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: IF (x_msg_data IS NOT NULL) THEN
791: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';
792: ELSE
793: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';
794: END IF;
795:

Line 793: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';

789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
790: IF (x_msg_data IS NOT NULL) THEN
791: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';
792: ELSE
793: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';
794: END IF;
795:
796: RAISE;
797:

Line 802: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';

798: WHEN OTHERS THEN
799:
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: IF (x_msg_data IS NOT NULL) THEN
802: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';
803: ELSE
804: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';
805: END IF;
806: RAISE;

Line 804: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';

800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
801: IF (x_msg_data IS NOT NULL) THEN
802: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';
803: ELSE
804: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_new_filter_view_name ';
805: END IF;
806: RAISE;
807: END get_new_filter_view_name;
808:

Line 917: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';

913: WHEN NO_DATA_FOUND THEN
914:
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: IF (x_msg_data IS NOT NULL) THEN
917: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';
918: ELSE
919: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';
920: END IF;
921: x_sql := NULL;

Line 919: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';

915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: IF (x_msg_data IS NOT NULL) THEN
917: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';
918: ELSE
919: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';
920: END IF;
921: x_sql := NULL;
922: RAISE;
923:

Line 928: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';

924: WHEN OTHERS THEN
925:
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
927: IF (x_msg_data IS NOT NULL) THEN
928: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';
929: ELSE
930: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';
931: END IF;
932: x_sql := NULL;

Line 930: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';

926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
927: IF (x_msg_data IS NOT NULL) THEN
928: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';
929: ELSE
930: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filter_dimension_SQL ';
931: END IF;
932: x_sql := NULL;
933: RAISE;
934:

Line 1037: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';

1033: WHEN NO_DATA_FOUND THEN
1034:
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: IF (x_msg_data IS NOT NULL) THEN
1037: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';
1038: ELSE
1039: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';
1040: END IF;
1041: x_sql := l_dummy_sql;

Line 1039: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';

1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: IF (x_msg_data IS NOT NULL) THEN
1037: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';
1038: ELSE
1039: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';
1040: END IF;
1041: x_sql := l_dummy_sql;
1042: RAISE;
1043:

Line 1048: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';

1044: WHEN OTHERS THEN
1045:
1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1047: IF (x_msg_data IS NOT NULL) THEN
1048: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';
1049: ELSE
1050: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';
1051: END IF;
1052: x_sql := l_dummy_sql;

Line 1050: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';

1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1047: IF (x_msg_data IS NOT NULL) THEN
1048: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';
1049: ELSE
1050: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.get_filtered_dim_values_SQL ';
1051: END IF;
1052: x_sql := l_dummy_sql;
1053: RAISE;
1054:

Line 1244: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';

1240: WHEN NO_DATA_FOUND THEN
1241:
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243: IF (x_msg_data IS NOT NULL) THEN
1244: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';
1245: ELSE
1246: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';
1247: END IF;
1248: IF (ref_cur%ISOPEN) THEN

Line 1246: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';

1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243: IF (x_msg_data IS NOT NULL) THEN
1244: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';
1245: ELSE
1246: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';
1247: END IF;
1248: IF (ref_cur%ISOPEN) THEN
1249: CLOSE ref_cur;
1250: END IF;

Line 1258: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';

1254: WHEN OTHERS THEN
1255:
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257: IF (x_msg_data IS NOT NULL) THEN
1258: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';
1259: ELSE
1260: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';
1261: END IF;
1262: IF (ref_cur%ISOPEN) THEN

Line 1260: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';

1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257: IF (x_msg_data IS NOT NULL) THEN
1258: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';
1259: ELSE
1260: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.del_filters_not_applicable ';
1261: END IF;
1262: IF (ref_cur%ISOPEN) THEN
1263: CLOSE ref_cur;
1264: END IF;

Line 1339: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';

1335: WHEN NO_DATA_FOUND THEN
1336:
1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: IF (x_msg_data IS NOT NULL) THEN
1339: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';
1340: ELSE
1341: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';
1342: END IF;
1343:

Line 1341: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';

1337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1338: IF (x_msg_data IS NOT NULL) THEN
1339: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';
1340: ELSE
1341: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';
1342: END IF;
1343:
1344: RAISE;
1345:

Line 1350: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';

1346: WHEN OTHERS THEN
1347:
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: IF (x_msg_data IS NOT NULL) THEN
1350: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';
1351: ELSE
1352: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';
1353: END IF;
1354: RAISE;

Line 1352: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';

1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: IF (x_msg_data IS NOT NULL) THEN
1350: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';
1351: ELSE
1352: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.update_tab_who_columns ';
1353: END IF;
1354: RAISE;
1355:
1356: END update_tab_who_columns;

Line 1521: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';

1517: WHEN NO_DATA_FOUND THEN
1518:
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: IF (x_msg_data IS NOT NULL) THEN
1521: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';
1522: ELSE
1523: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';
1524: END IF;
1525:

Line 1523: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';

1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: IF (x_msg_data IS NOT NULL) THEN
1521: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';
1522: ELSE
1523: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';
1524: END IF;
1525:
1526: RAISE;
1527:

Line 1532: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';

1528: WHEN OTHERS THEN
1529:
1530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1531: IF (x_msg_data IS NOT NULL) THEN
1532: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';
1533: ELSE
1534: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';
1535: END IF;
1536: RAISE;

Line 1534: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';

1530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1531: IF (x_msg_data IS NOT NULL) THEN
1532: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';
1533: ELSE
1534: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_key_items ';
1535: END IF;
1536: RAISE;
1537:
1538: END validate_key_items;

Line 1731: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';

1727: END IF;
1728:
1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1730: IF (x_msg_data IS NOT NULL) THEN
1731: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';
1732: ELSE
1733: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';
1734: END IF;
1735:

Line 1733: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';

1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1730: IF (x_msg_data IS NOT NULL) THEN
1731: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';
1732: ELSE
1733: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';
1734: END IF;
1735:
1736: RAISE;
1737:

Line 1745: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';

1741: END IF;
1742:
1743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1744: IF (x_msg_data IS NOT NULL) THEN
1745: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';
1746: ELSE
1747: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';
1748: END IF;
1749: RAISE;

Line 1747: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';

1743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1744: IF (x_msg_data IS NOT NULL) THEN
1745: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';
1746: ELSE
1747: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_parent_key_items ';
1748: END IF;
1749: RAISE;
1750:
1751: END validate_parent_key_items;

Line 1961: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';

1957: END IF;
1958:
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: IF (x_msg_data IS NOT NULL) THEN
1961: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';
1962: ELSE
1963: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';
1964: END IF;
1965:

Line 1963: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';

1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: IF (x_msg_data IS NOT NULL) THEN
1961: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';
1962: ELSE
1963: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';
1964: END IF;
1965:
1966: RAISE;
1967:

Line 1975: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';

1971: END IF;
1972:
1973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1974: IF (x_msg_data IS NOT NULL) THEN
1975: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';
1976: ELSE
1977: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';
1978: END IF;
1979: RAISE;

Line 1977: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';

1973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1974: IF (x_msg_data IS NOT NULL) THEN
1975: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';
1976: ELSE
1977: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PUB.validate_child_key_items ';
1978: END IF;
1979: RAISE;
1980:
1981: END validate_child_key_items;

Line 1984: END BSC_DIM_LEVEL_FILTERS_PUB;

1980:
1981: END validate_child_key_items;
1982:
1983:
1984: END BSC_DIM_LEVEL_FILTERS_PUB;