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.BIS_DIMENSION_LEVEL_PUB dependencies on BIS_UTILITIES_PUB

Line 93: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

89: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
90: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
91: , p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
92: , p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
93: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
94: , p_force_mode IN BOOLEAN := FALSE
95: , x_return_status OUT NOCOPY VARCHAR2
96: , x_msg_count OUT NOCOPY NUMBER
97: , x_msg_data OUT NOCOPY VARCHAR2

Line 101: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

97: , x_msg_data OUT NOCOPY VARCHAR2
98: )
99: IS
100: l_return_status VARCHAR2(10);
101: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
102: l_msg_count NUMBER;
103: l_msg_data VARCHAR2(4000);
104: BEGIN
105:

Line 172: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

168: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
169: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
170: , p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
171: , p_Bsc_Dim_Level_Rec IN BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type
172: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
173: , x_return_status OUT NOCOPY VARCHAR2
174: , x_msg_count OUT NOCOPY NUMBER
175: , x_msg_data OUT NOCOPY VARCHAR2
176: )

Line 179: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

175: , x_msg_data OUT NOCOPY VARCHAR2
176: )
177: IS
178: l_return_status VARCHAR2(10);
179: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
180: l_msg_count NUMBER;
181: l_msg_data VARCHAR2(4000);
182: BEGIN
183:

Line 246: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

242: ( p_api_version IN NUMBER
243: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
244: , x_Dimension_Level_Tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
245: , x_return_status OUT NOCOPY VARCHAR2
246: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
247: )
248: IS
249: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
250: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 250: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

246: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
247: )
248: IS
249: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
250: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
251: BEGIN
252: --commented out NOCOPY this section
253: /*
254: BIS_DIMENSION_PVT.Value_ID_Conversion

Line 269: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

265: BIS_UTILITIES_PVT.Add_Error_Message
266: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
267: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
268: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Levels'
269: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
270: , p_error_table => x_error_tbl
271: , x_error_table => x_error_tbl
272: );
273: RAISE FND_API.G_EXC_ERROR;

Line 310: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

306: ( p_api_version IN NUMBER
307: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
308: , x_Dimension_Level_Rec IN OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
309: , x_return_status OUT NOCOPY VARCHAR2
310: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
311: )
312: IS
313: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
314: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 314: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

310: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
311: )
312: IS
313: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
314: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
315: BEGIN
316:
317: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
318: ( p_api_version => 1.0

Line 332: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

328: BIS_UTILITIES_PVT.Add_Error_Message
329: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_VALUE'
330: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
331: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Level'
332: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
333: , p_error_table => l_error_tbl
334: , x_error_table => x_error_tbl
335: );
336: RAISE FND_API.G_EXC_ERROR;

Line 374: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

370: ( p_api_version IN NUMBER
371: , p_commit IN VARCHAR2 := FND_API.G_FALSE
372: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
373: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
374: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
375: , x_return_status OUT NOCOPY VARCHAR2
376: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
377: )
378: IS

Line 376: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

372: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
373: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
374: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
375: , x_return_status OUT NOCOPY VARCHAR2
376: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
377: )
378: IS
379: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
380: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 380: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

376: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
377: )
378: IS
379: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
380: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
381: BEGIN
382:
383: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
384: ( p_api_version => p_api_version

Line 398: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

394: BIS_UTILITIES_PVT.Add_Error_Message
395: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_LEVEL_ID'
396: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
397: , p_error_proc_name => G_PKG_NAME||'.Translate_Dimension_Level'
398: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
399: , p_error_table => l_error_tbl
400: , x_error_table => x_error_tbl
401: );
402: RAISE FND_API.G_EXC_ERROR;

Line 441: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER

437: ( p_api_version IN NUMBER
438: , p_commit IN VARCHAR2 := FND_API.G_FALSE
439: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
440: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
441: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
442: , x_return_status OUT NOCOPY VARCHAR2
443: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
444: , p_force_mode IN BOOLEAN := FALSE
445: )

Line 443: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

439: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
440: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
441: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
442: , x_return_status OUT NOCOPY VARCHAR2
443: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
444: , p_force_mode IN BOOLEAN := FALSE
445: )
446: IS
447: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

Line 448: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

444: , p_force_mode IN BOOLEAN := FALSE
445: )
446: IS
447: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
448: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
449: l_return_status VARCHAR2(10);
450: l_return_msg VARCHAR2(32000);
451: l_count NUMBER;
452: l_ret_code BOOLEAN;

Line 475: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

471: BIS_UTILITIES_PVT.Add_Error_Message
472: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_LEVEL_ID'
473: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
474: , p_error_proc_name => G_PKG_NAME||'.Load_Dimension_Level'
475: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
476: , p_error_table => x_error_tbl
477: , x_error_table => x_error_tbl
478: );
479: RAISE FND_API.G_EXC_ERROR;

Line 563: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

559: , p_commit IN VARCHAR2 := FND_API.G_FALSE
560: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
561: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
562: , x_return_status OUT NOCOPY VARCHAR2
563: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
564: )
565: IS
566: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
567: BEGIN

Line 566: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

562: , x_return_status OUT NOCOPY VARCHAR2
563: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
564: )
565: IS
566: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
567: BEGIN
568:
569: BIS_DIMENSION_LEVEL_PVT.Create_Dimension_Level
570: (

Line 603: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

599: , p_commit IN VARCHAR2 := FND_API.G_FALSE
600: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
601: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
602: , x_return_status OUT NOCOPY VARCHAR2
603: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
604: )
605: IS
606: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
607: BEGIN

Line 606: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

602: , x_return_status OUT NOCOPY VARCHAR2
603: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
604: )
605: IS
606: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
607: BEGIN
608:
609: BIS_DIMENSION_LEVEL_PVT.Update_Dimension_Level
610: (

Line 643: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

639: p_commit IN VARCHAR2 := FND_API.G_FALSE
640: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
641: , p_Dimension_Level_Rec IN BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
642: , x_return_status OUT NOCOPY VARCHAR2
643: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
644: ) IS
645: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
646: BEGIN
647: BIS_DIMENSION_LEVEL_PVT.Delete_Dimension_Level

Line 645: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

641: , p_Dimension_Level_Rec IN BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
642: , x_return_status OUT NOCOPY VARCHAR2
643: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
644: ) IS
645: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
646: BEGIN
647: BIS_DIMENSION_LEVEL_PVT.Delete_Dimension_Level
648: (
649: p_commit => p_commit

Line 902: l_owner_name := BIS_UTILITIES_PUB.Get_Owner_Name(p_Bsc_Dim_Level_Rec.Bsc_Last_Updated_By);

898: FETCH c_bsc_dim_obj_exists INTO l_short_name;
899:
900: IF (c_bsc_dim_obj_exists%FOUND) THEN -- Update mode
901: l_last_update_date := NVL(p_Bsc_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);
902: l_owner_name := BIS_UTILITIES_PUB.Get_Owner_Name(p_Bsc_Dim_Level_Rec.Bsc_Last_Updated_By);
903:
904: /*BIS_UTIL.Validate_For_Update
905: ( p_last_update_date => l_last_update_date
906: , p_owner => l_owner_name

Line 1025: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1021: p_commit IN VARCHAR2 := FND_API.G_FALSE
1022: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1023: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1024: , x_return_status OUT NOCOPY VARCHAR2
1025: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1026: ) IS
1027: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1028: BEGIN
1029: BIS_DIMENSION_LEVEL_PVT.Trans_DimObj_By_Given_Lang

Line 1027: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1023: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1024: , x_return_status OUT NOCOPY VARCHAR2
1025: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1026: ) IS
1027: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1028: BEGIN
1029: BIS_DIMENSION_LEVEL_PVT.Trans_DimObj_By_Given_Lang
1030: (
1031: p_commit => p_commit

Line 1163: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1159: IS
1160: l_Dimension_Level_Rec_In BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1161: l_Dimension_Level_Rec_Out BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1162: l_return_status VARCHAR2(10);
1163: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1164: l_count NUMBER;
1165: BEGIN
1166:
1167: FND_MSG_PUB.Initialize;

Line 1336: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1332: ) IS
1333: l_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;
1334: x_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;
1335: l_Bsc_Dim_Level_Rec_Type BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1336: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1337:
1338: BEGIN
1339: SAVEPOINT DimObjObsoleteUpdate;
1340: IF (p_dim_obj_short_name IS NULL OR p_dim_obj_short_name = '') THEN