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

Line 38: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

34: ( p_api_version IN NUMBER
35: , p_commit IN VARCHAR2 := FND_API.G_FALSE
36: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
37: , x_return_status OUT NOCOPY VARCHAR2
38: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
39: )
40: IS
41: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
42: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 42: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

38: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
39: )
40: IS
41: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
42: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
43: BEGIN
44:
45: BIS_Target_Level_PVT.Value_ID_Conversion
46: ( p_api_version => p_api_version

Line 57: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

53: BIS_Target_Level_PVT.Create_Target_Level
54: ( p_api_version => p_api_version
55: , p_commit => p_commit
56: , p_Target_Level_Rec => l_Target_Level_Rec
57: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
58: , x_return_status => x_return_status
59: , x_error_Tbl => x_error_Tbl
60: );
61:

Line 93: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

89: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
90: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
91: , x_Target_Level_tbl OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Tbl_Type
92: , x_return_status OUT NOCOPY VARCHAR2
93: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
94: )
95: IS
96: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
97: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 97: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

93: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
94: )
95: IS
96: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
97: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
98: l_target_level_tbl BIS_Target_Level_PUB.Target_Level_Tbl_Type;
99: BEGIN
100:
101: l_measure_rec := p_measure_rec;

Line 103: if (BIS_UTILITIES_PUB.Value_Missing

99: BEGIN
100:
101: l_measure_rec := p_measure_rec;
102:
103: if (BIS_UTILITIES_PUB.Value_Missing
104: (l_Measure_Rec.Measure_id) = FND_API.G_TRUE
105: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)
106: = FND_API.G_TRUE) then
107: BIS_MEASURE_PVT.Value_ID_Conversion

Line 105: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)

101: l_measure_rec := p_measure_rec;
102:
103: if (BIS_UTILITIES_PUB.Value_Missing
104: (l_Measure_Rec.Measure_id) = FND_API.G_TRUE
105: OR BIS_UTILITIES_PUB.Value_NULL(l_Measure_Rec.Measure_id)
106: = FND_API.G_TRUE) then
107: BIS_MEASURE_PVT.Value_ID_Conversion
108: ( p_api_version => p_api_version
109: , p_Measure_Short_Name => l_Measure_Rec.Measure_Short_Name

Line 165: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

161: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
162: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
163: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
164: , x_return_status OUT NOCOPY VARCHAR2
165: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
166: )
167: IS
168: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
169: l_Target_Level_Rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;

Line 170: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

166: )
167: IS
168: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
169: l_Target_Level_Rec_p BIS_Target_Level_PUB.Target_Level_Rec_Type;
170: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
171: BEGIN
172:
173: l_target_level_rec := p_target_level_rec;
174:

Line 244: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

240: ( p_api_version IN NUMBER
241: , p_commit IN VARCHAR2 := FND_API.G_FALSE
242: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
243: , x_return_status OUT NOCOPY VARCHAR2
244: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
245: )
246: IS
247: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
248: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 248: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

244: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
245: )
246: IS
247: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
248: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
249: BEGIN
250:
251: BIS_Target_Level_PVT.Value_ID_Conversion
252: ( p_api_version => p_api_version

Line 263: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

259: BIS_Target_Level_PVT.Update_Target_Level
260: ( p_api_version => p_api_version
261: , p_commit => p_commit
262: , p_Target_Level_Rec => l_Target_Level_Rec
263: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
264: , x_return_status => x_return_status
265: , x_error_Tbl => x_error_Tbl
266: );
267:

Line 295: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

291: ( p_api_version IN NUMBER
292: , p_commit IN VARCHAR2 := FND_API.G_FALSE
293: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
294: , x_return_status OUT NOCOPY VARCHAR2
295: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
296: )
297: IS
298: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
299: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 299: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

295: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
296: )
297: IS
298: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
299: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
300: BEGIN
301:
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:

Line 306: if ( BIS_UTILITIES_PUB.Value_Missing

302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: l_target_level_rec := p_target_level_rec;
305:
306: if ( BIS_UTILITIES_PUB.Value_Missing
307: (p_Target_Level_Rec.Target_Level_id) = FND_API.G_TRUE
308: OR BIS_UTILITIES_PUB.Value_NULL
309: (p_Target_Level_Rec.Target_Level_id) = FND_API.G_TRUE) then
310: BIS_Target_Level_PVT.Value_ID_Conversion

Line 308: OR BIS_UTILITIES_PUB.Value_NULL

304: l_target_level_rec := p_target_level_rec;
305:
306: if ( BIS_UTILITIES_PUB.Value_Missing
307: (p_Target_Level_Rec.Target_Level_id) = FND_API.G_TRUE
308: OR BIS_UTILITIES_PUB.Value_NULL
309: (p_Target_Level_Rec.Target_Level_id) = FND_API.G_TRUE) then
310: BIS_Target_Level_PVT.Value_ID_Conversion
311: ( p_api_version
312: , p_Target_Level_Rec.Target_Level_Short_Name

Line 355: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

351: PROCEDURE Validate_Target_Level
352: ( p_api_version IN NUMBER
353: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
354: , x_return_status OUT NOCOPY VARCHAR2
355: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
356: )
357: IS
358: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
359: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 359: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

355: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
356: )
357: IS
358: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
359: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
360: BEGIN
361:
362: BIS_Target_Level_PVT.Value_ID_Conversion
363: ( p_api_version => p_api_version

Line 399: , p_user_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

395: END Validate_Target_Level;
396: --
397: PROCEDURE Get_User_Id
398: ( p_api_version IN NUMBER
399: , p_user_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
400: , x_user_id OUT NOCOPY NUMBER
401: , x_return_status OUT NOCOPY VARCHAR2
402: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
403: )

Line 402: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

398: ( p_api_version IN NUMBER
399: , p_user_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
400: , x_user_id OUT NOCOPY NUMBER
401: , x_return_status OUT NOCOPY VARCHAR2
402: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
403: )
404: is
405: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
406: BEGIN

Line 405: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

401: , x_return_status OUT NOCOPY VARCHAR2
402: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
403: )
404: is
405: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
406: BEGIN
407: x_return_status := FND_API.G_RET_STS_SUCCESS;
408:
409: select user_id into x_user_id

Line 438: , p_user_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

434: --
435: Procedure Retrieve_User_Target_Levels
436: ( p_api_version IN NUMBER
437: , p_user_id IN NUMBER
438: , p_user_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
439: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
440: , x_Target_Level_Tbl OUT NOCOPY BIS_Target_LEVEL_PUB.Target_Level_Tbl_Type
441: , x_return_status OUT NOCOPY VARCHAR2
442: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 442: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

438: , p_user_name IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
439: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
440: , x_Target_Level_Tbl OUT NOCOPY BIS_Target_LEVEL_PUB.Target_Level_Tbl_Type
441: , x_return_status OUT NOCOPY VARCHAR2
442: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
443: )
444: IS
445: l_user_id number := p_user_id;
446: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 446: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

442: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
443: )
444: IS
445: l_user_id number := p_user_id;
446: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
447: BEGIN
448: x_return_status := FND_API.G_RET_STS_SUCCESS ;
449:
450: --checked for null also

Line 451: if (BIS_UTILITIES_PUB.Value_Missing(l_user_id) = FND_API.G_TRUE

447: BEGIN
448: x_return_status := FND_API.G_RET_STS_SUCCESS ;
449:
450: --checked for null also
451: if (BIS_UTILITIES_PUB.Value_Missing(l_user_id) = FND_API.G_TRUE
452: OR BIS_UTILITIES_PUB.Value_NULL(l_user_id)
453: = FND_API.G_TRUE)
454: then
455:

Line 452: OR BIS_UTILITIES_PUB.Value_NULL(l_user_id)

448: x_return_status := FND_API.G_RET_STS_SUCCESS ;
449:
450: --checked for null also
451: if (BIS_UTILITIES_PUB.Value_Missing(l_user_id) = FND_API.G_TRUE
452: OR BIS_UTILITIES_PUB.Value_NULL(l_user_id)
453: = FND_API.G_TRUE)
454: then
455:
456: Get_User_Id( p_api_version => 1.0

Line 506: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

502: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
503: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
504: , p_owner IN VARCHAR2
505: , x_return_status OUT NOCOPY VARCHAR2
506: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
507: )
508: IS
509: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
510: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 510: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

506: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
507: )
508: IS
509: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
510: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
511: BEGIN
512:
513: BIS_TARGET_LEVEL_PVT.Value_ID_Conversion
514: ( p_api_version => p_api_version

Line 528: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

524: BIS_UTILITIES_PVT.Add_Error_Message
525: ( p_error_msg_name => 'BIS_INVALID_TAR_LEVEL_ID'
526: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
527: , p_error_proc_name => G_PKG_NAME||'.Translate_Target_Level'
528: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
529: , p_error_table => l_error_tbl
530: , x_error_table => x_error_tbl
531: );
532: RAISE FND_API.G_EXC_ERROR;

Line 573: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

569: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
570: , p_owner IN VARCHAR2
571: , p_up_loaded IN VARCHAR2 := FND_API.G_FALSE
572: , x_return_status OUT NOCOPY VARCHAR2
573: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
574: )
575: IS
576: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
577: l_return_status VARCHAR2(100); -- 2486702

Line 579: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

575: IS
576: l_Target_Level_Rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
577: l_return_status VARCHAR2(100); -- 2486702
578: l_return_msg VARCHAR2(3000); -- 2486702
579: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
580:
581: BEGIN
582:
583: l_Target_Level_Rec := p_Target_Level_Rec;

Line 598: ); -- BIS_UTILITIES_PUB.put_line(p_text => ' ok 2 x_return_status = ' || x_return_status ) ;

594: (
595: p_target_level_rec => l_Target_Level_Rec
596: , x_return_status => l_return_status
597: , x_return_msg => l_return_msg
598: ); -- BIS_UTILITIES_PUB.put_line(p_text => ' ok 2 x_return_status = ' || x_return_status ) ;
599:
600: IF ( l_return_status <> 'S' ) THEN -- 2486702
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;

Line 668: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

664: (p_api_version IN NUMBER
665: ,p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
666: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
667: , x_return_status OUT NOCOPY VARCHAR2
668: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
669: )
670: IS
671: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
672:

Line 671: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

667: , x_return_status OUT NOCOPY VARCHAR2
668: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
669: )
670: IS
671: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
672:
673: BEGIN
674: BIS_Target_Level_PVT.Retrieve_TL_From_DimLvlShNms
675: (