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_BIS_DIM_REL_PUB dependencies on BSC_DIMENSION_LEVELS_PUB

Line 1459: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

1455:
1456: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
1457: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
1458:
1459: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1460:
1461: l_count NUMBER;
1462: l_flag BOOLEAN := TRUE;
1463: l_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;

Line 1861: l_flag := BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship

1857: AND parent_dim_level_id = l_bsc_dim_obj_rec.bsc_parent_level_id;
1858: IF (l_count = 0) THEN
1859: IF (l_bsc_dim_obj_rec.bsc_relation_type = 1) THEN
1860: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_DIM_REL_PUB.Is_Valid_Relationship');
1861: l_flag := BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship
1862: ( p_commit => FND_API.G_FALSE
1863: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
1864: , x_return_status => x_return_status
1865: , x_msg_count => x_msg_count

Line 1869: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship.');

1865: , x_msg_count => x_msg_count
1866: , x_msg_data => x_msg_data
1867: );
1868: IF (NOT l_flag) THEN
1869: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship.');
1870: --DBMS_OUTPUT.PUT_LINE(SUBSTR(x_msg_data, 1, 200));
1871: RAISE FND_API.G_EXC_ERROR;
1872: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1873: END IF;

Line 1886: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');

1882: RAISE FND_API.G_EXC_ERROR;
1883: END IF;
1884: END IF;
1885: --DBMS_OUTPUT.PUT_LINE('reached I 6');
1886: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');
1887: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation
1888: ( p_commit => FND_API.G_FALSE
1889: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
1890: , x_return_status => x_return_status

Line 1887: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation

1883: END IF;
1884: END IF;
1885: --DBMS_OUTPUT.PUT_LINE('reached I 6');
1886: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');
1887: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation
1888: ( p_commit => FND_API.G_FALSE
1889: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
1890: , x_return_status => x_return_status
1891: , x_msg_count => x_msg_count

Line 1896: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');

1892: , x_msg_data => x_msg_data
1893: );
1894: --DBMS_OUTPUT.PUT_LINE('reached I 7');
1895: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1896: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
1897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1899: -- START Granluar Locking
1900: -- Change the time stamp of the Child Dimension Level

Line 1909: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');

1905: , x_msg_count => x_msg_count
1906: , x_msg_data => x_msg_data
1907: );
1908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1909: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;
1912: END IF;
1913: -- END Granluar Locking

Line 2022: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship');

2018:
2019: --DBMS_OUTPUT.PUT_LINE('PARENT IDS STAGE3');
2020: IF (l_count = 0) THEN
2021: IF (l_bsc_dim_obj_rec.bsc_relation_type = 1) THEN
2022: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship');
2023: l_flag := BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship
2024: ( p_commit => FND_API.G_FALSE
2025: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
2026: , x_return_status => x_return_status

Line 2023: l_flag := BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship

2019: --DBMS_OUTPUT.PUT_LINE('PARENT IDS STAGE3');
2020: IF (l_count = 0) THEN
2021: IF (l_bsc_dim_obj_rec.bsc_relation_type = 1) THEN
2022: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship');
2023: l_flag := BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship
2024: ( p_commit => FND_API.G_FALSE
2025: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
2026: , x_return_status => x_return_status
2027: , x_msg_count => x_msg_count

Line 2031: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship');

2027: , x_msg_count => x_msg_count
2028: , x_msg_data => x_msg_data
2029: );
2030: IF (NOT l_flag) THEN
2031: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship');
2032: RAISE FND_API.G_EXC_ERROR;
2033: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
2034: END IF;
2035: ELSE

Line 2047: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');

2043: RAISE FND_API.G_EXC_ERROR;
2044: END IF;
2045: END IF;
2046:
2047: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');
2048: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation
2049: ( p_commit => FND_API.G_FALSE
2050: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
2051: , x_return_status => x_return_status

Line 2048: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation

2044: END IF;
2045: END IF;
2046:
2047: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');
2048: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation
2049: ( p_commit => FND_API.G_FALSE
2050: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
2051: , x_return_status => x_return_status
2052: , x_msg_count => x_msg_count

Line 2056: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');

2052: , x_msg_count => x_msg_count
2053: , x_msg_data => x_msg_data
2054: );
2055: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2056: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2058: END IF;
2059:
2060: -- START Granluar Locking

Line 2070: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');

2066: , x_msg_count => x_msg_count
2067: , x_msg_data => x_msg_data
2068: );
2069: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2070: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;
2073: END IF;
2074: --DBMS_OUTPUT.PUT_LINE('PARENT IDS STAGE4');

Line 2247: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_OBJ_PUB.check_indp_dimobjs Failed: at BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level <'||x_msg_data||'>');

2243: , x_msg_count => x_msg_count
2244: , x_msg_data => x_msg_data
2245: );
2246: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2247: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_OBJ_PUB.check_indp_dimobjs Failed: at BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level <'||x_msg_data||'>');
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END IF;
2250:
2251: /*************************************************************

Line 2948: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;

2944: l_alias VARCHAR2(4);
2945: l_flag BOOLEAN;
2946:
2947: l_col_names VARCHAR2(400) := NULL;
2948: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
2949: l_count NUMBER := 0;
2950: e_mlog_exception EXCEPTION;
2951: l_error_msg VARCHAR2(4000);
2952: l_max_code NUMBER;

Line 3358: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable Failed: at BSC_DIMENSION_LEVELS_PUB.Drop_M_To_N_Unused_Tabs <'||x_msg_data||'>');

3354: , x_msg_count => x_msg_count
3355: , x_msg_data => x_msg_data
3356: );
3357: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3358: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable Failed: at BSC_DIMENSION_LEVELS_PUB.Drop_M_To_N_Unused_Tabs <'||x_msg_data||'>');
3359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3360: END IF;
3361: ELSE
3362: SELECT dim_level_id