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_PUB dependencies on BIS_UTILITIES_PUB

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

51: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
52: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
53: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
54: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
55: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
56: , p_force_mode IN BOOLEAN := FALSE
57: , x_return_status OUT NOCOPY VARCHAR2
58: , x_msg_count OUT NOCOPY NUMBER
59: , x_msg_data OUT NOCOPY VARCHAR2

Line 63: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

59: , x_msg_data OUT NOCOPY VARCHAR2
60: )
61: IS
62: l_return_status VARCHAR2(10);
63: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
64: l_msg_count NUMBER;
65: l_msg_data VARCHAR2(4000);
66: BEGIN
67:

Line 81: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

77: BIS_UTILITIES_PVT.Add_Error_Message(
78: p_error_msg_name => 'BIS_DIMENSION_UNIQUENESS_ERROR'
79: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
80: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension'
81: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
82: );
83: RAISE FND_API.G_EXC_ERROR;
84: END IF;
85:

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

145: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
146: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
147: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
148: , p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
149: , p_Owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
150: , x_return_status OUT NOCOPY VARCHAR2
151: , x_msg_count OUT NOCOPY NUMBER
152: , x_msg_data OUT NOCOPY VARCHAR2
153: )

Line 156: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

152: , x_msg_data OUT NOCOPY VARCHAR2
153: )
154: IS
155: l_return_status VARCHAR2(10);
156: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
157: l_msg_count NUMBER;
158: l_msg_data VARCHAR2(4000);
159: BEGIN
160:

Line 221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

217: Procedure Retrieve_Dimensions
218: ( p_api_version IN NUMBER
219: , x_Dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
220: , x_return_status OUT NOCOPY VARCHAR2
221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
222: )
223: IS
224: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
225: BEGIN

Line 224: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

220: , x_return_status OUT NOCOPY VARCHAR2
221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
222: )
223: IS
224: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
225: BEGIN
226: BIS_DIMENSION_PVT.Retrieve_Dimensions
227: ( p_api_version => p_api_version
228: , x_Dimension_Tbl => x_Dimension_Tbl

Line 258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

254: ( p_api_version IN NUMBER
255: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
256: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
259: )
260: IS
261: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
262: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 262: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

258: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
259: )
260: IS
261: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
262: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
263: BEGIN
264:
265: BIS_DIMENSION_PVT.Value_ID_Conversion
266: ( p_api_version => 1.0

Line 280: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

276: BIS_UTILITIES_PVT.Add_Error_Message (
277: p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
278: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
279: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension'
280: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
281: , p_error_table => l_error_tbl
282: , x_error_table => x_error_tbl
283: );
284: RAISE FND_API.G_EXC_ERROR;

Line 324: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

320: ( p_api_version IN NUMBER
321: , p_num IN NUMBER
322: , x_dimension_rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
323: , x_return_status OUT NOCOPY VARCHAR2
324: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
325: )
326: IS
327: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
328: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 328: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

324: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
325: )
326: IS
327: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
328: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
329: BEGIN
330: if (p_num = 1) then
331: l_Dimension_Rec.dimension_short_name := 'ORGANIZATION';
332: elsif (p_num = 2) then

Line 339: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

335: BIS_UTILITIES_PVT.Add_Error_Message
336: ( p_error_msg_name => 'BIS_INVALID_REQUIRED_DIMENSION'
337: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
338: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Required_Dimension'
339: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
340: );
341: RAISE FND_API.G_EXC_ERROR;
342: end if;
343:

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

375: ( p_api_version IN NUMBER
376: , p_commit IN VARCHAR2 := FND_API.G_FALSE
377: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
378: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
379: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
380: , x_return_status OUT NOCOPY VARCHAR2
381: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
382: )
383: IS

Line 381: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

377: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
378: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
379: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
380: , x_return_status OUT NOCOPY VARCHAR2
381: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
382: )
383: IS
384: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

381: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
382: )
383: IS
384: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
385: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
386: l_return_status VARCHAR2(10);
387: l_return_msg VARCHAR2(32000);
388:
389: BEGIN

Line 410: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

406: BIS_UTILITIES_PVT.Add_Error_Message
407: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
408: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
409: , p_error_proc_name => G_PKG_NAME||'.Translate_Dimension'
410: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
411: );
412: RAISE FND_API.G_EXC_ERROR;
413: end if;
414:

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

447: ( p_api_version IN NUMBER
448: , p_commit IN VARCHAR2 := FND_API.G_FALSE
449: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
450: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
451: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
452: , x_return_status OUT NOCOPY VARCHAR2
453: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
454: , p_force_mode IN BOOLEAN := FALSE
455: )

Line 453: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

449: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
450: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
451: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
452: , x_return_status OUT NOCOPY VARCHAR2
453: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
454: , p_force_mode IN BOOLEAN := FALSE
455: )
456: IS
457: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

Line 458: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

454: , p_force_mode IN BOOLEAN := FALSE
455: )
456: IS
457: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
458: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
459: l_return_status VARCHAR2(10);
460: l_return_msg VARCHAR2(32000);
461: l_count NUMBER;
462: l_ret_code BOOLEAN;

Line 471: -- BIS_UTILITIES_PUB.put_line(p_text => 'YYYYYYYYY' );

467: ( x_return_status => l_return_status
468: , x_return_msg => l_return_msg
469: );
470:
471: -- BIS_UTILITIES_PUB.put_line(p_text => 'YYYYYYYYY' );
472:
473: -- l_Dimension_Rec := p_Dimension_Rec;
474:
475: BIS_DIMENSION_PVT.Value_ID_Conversion

Line 555: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

551: , p_commit IN VARCHAR2 := FND_API.G_FALSE
552: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
553: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
554: , x_return_status OUT NOCOPY VARCHAR2
555: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
556: )
557: IS
558: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
559: BEGIN

Line 558: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

554: , x_return_status OUT NOCOPY VARCHAR2
555: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
556: )
557: IS
558: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
559: BEGIN
560:
561: BIS_DIMENSION_PVT.Update_Dimension
562: ( p_api_version => p_api_version

Line 595: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

591: p_commit IN VARCHAR2 := FND_API.G_FALSE
592: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
593: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
594: , x_return_status OUT NOCOPY VARCHAR2
595: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
596: )
597: IS
598: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
599: BEGIN

Line 598: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

594: , x_return_status OUT NOCOPY VARCHAR2
595: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
596: )
597: IS
598: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
599: BEGIN
600: BIS_DIMENSION_PVT.Delete_Dimension
601: (
602: p_commit => p_commit

Line 632: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

628: , p_commit IN VARCHAR2 := FND_API.G_FALSE
629: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
630: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
631: , x_return_status OUT NOCOPY VARCHAR2
632: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
633: )
634: IS
635: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
636: BEGIN

Line 635: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

631: , x_return_status OUT NOCOPY VARCHAR2
632: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
633: )
634: IS
635: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
636: BEGIN
637: BIS_DIMENSION_PVT.Create_Dimension
638: (
639: p_api_version => p_api_version

Line 733: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

729: p_commit IN VARCHAR2 := FND_API.G_FALSE
730: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
731: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
732: , x_return_status OUT NOCOPY VARCHAR2
733: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
734: ) IS
735: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
736: BEGIN
737: BIS_DIMENSION_PVT.Translate_Dim_By_Given_Lang

Line 735: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

731: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
732: , x_return_status OUT NOCOPY VARCHAR2
733: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
734: ) IS
735: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
736: BEGIN
737: BIS_DIMENSION_PVT.Translate_Dim_By_Given_Lang
738: (
739: p_commit => p_commit

Line 776: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

772: ) IS
773: l_dim_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
774: x_dim_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
775: l_dim_obj_sht_name BSC_SYS_DIM_LEVELS_B.SHORT_NAME%TYPE;
776: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
777:
778: CURSOR cr_dim_obj IS
779: SELECT
780: obj_short_name short_name