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_UTIL

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 265: BIS_UTILITIES_PVT.Add_Error_Message

261:
262: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
263: -- POPULATE THE ERROR TABLE
264: --added this message
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

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 294: BIS_UTILITIES_PVT.Add_Error_Message

290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
291: when others then
292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
293: l_error_tbl := x_error_tbl;
294: BIS_UTILITIES_PVT.Add_Error_Message
295: ( p_error_msg_id => SQLCODE
296: , p_error_description => SQLERRM
297: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Levels'
298: , p_error_table => l_error_tbl

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 328: BIS_UTILITIES_PVT.Add_Error_Message

324: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
325: -- POPULATE THE ERROR TABLE
326: --added the error message
327: l_error_tbl := x_error_tbl;
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

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 358: BIS_UTILITIES_PVT.Add_Error_Message

354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
355: when others then
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
357: l_error_tbl := x_error_tbl;
358: BIS_UTILITIES_PVT.Add_Error_Message
359: ( p_error_msg_id => SQLCODE
360: , p_error_description => SQLERRM
361: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Level'
362: , p_error_table => l_error_tbl

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 394: BIS_UTILITIES_PVT.Add_Error_Message

390:
391: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
392: --added last two parameters
393: l_error_tbl := x_error_tbl;
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

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 426: BIS_UTILITIES_PVT.Add_Error_Message

422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: when others then
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
425: l_error_tbl := x_error_tbl;
426: BIS_UTILITIES_PVT.Add_Error_Message
427: ( p_error_msg_id => SQLCODE
428: , p_error_description => SQLERRM
429: , p_error_proc_name => G_PKG_NAME||'.Translate_Dimension_Level'
430: , p_error_table => l_error_tbl

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 471: BIS_UTILITIES_PVT.Add_Error_Message

467: -- commented out NOCOPY since we want to continue anyway
468: /*
469: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
470: --added last two parameters
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

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 490: BIS_UTIL.Validate_For_Update ( p_last_update_date => l_Dimension_Level_Rec.Last_Update_Date

486: FROM BIS_LEVELS
487: WHERE short_name = p_Dimension_Level_Rec.Dimension_Level_Short_Name;
488:
489: IF (l_count > 0) THEN
490: BIS_UTIL.Validate_For_Update ( p_last_update_date => l_Dimension_Level_Rec.Last_Update_Date
491: ,p_owner => p_owner
492: ,p_force_mode => p_force_mode
493: ,p_table_name => 'BIS_LEVELS'
494: ,p_key_value => p_Dimension_Level_Rec.Dimension_Level_Short_Name

Line 526: BIS_UTILITIES_PVT.Add_Error_Message

522: /*
523: WHEN OTHERS THEN
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
525: --added last two parameters
526: BIS_UTILITIES_PVT.Add_Error_Message
527: ( p_error_msg_id => SQLCODE
528: , p_error_description => SQLERRM
529: , p_error_proc_name => G_PKG_NAME||'.Load_Dimension_Level'
530: , p_error_table => x_error_tbl

Line 547: BIS_UTILITIES_PVT.Add_Error_Message

543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
544: when others then
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
546: l_error_tbl := x_error_tbl;
547: BIS_UTILITIES_PVT.Add_Error_Message
548: ( p_error_msg_id => SQLCODE
549: , p_error_description => SQLERRM
550: , p_error_proc_name => G_PKG_NAME||'.Load_Dimension_Level'
551: , p_error_table => l_error_tbl

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 588: BIS_UTILITIES_PVT.Add_Error_Message

584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
585: WHEN OTHERS THEN
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587: l_error_tbl := x_error_tbl;
588: BIS_UTILITIES_PVT.Add_Error_Message
589: ( p_error_msg_id => SQLCODE
590: , p_error_description => SQLERRM
591: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension_Level'
592: , p_error_table => l_error_tbl

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 628: BIS_UTILITIES_PVT.Add_Error_Message

624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
625: WHEN OTHERS THEN
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
627: l_error_tbl := x_error_tbl;
628: BIS_UTILITIES_PVT.Add_Error_Message
629: ( p_error_msg_id => SQLCODE
630: , p_error_description => SQLERRM
631: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
632: , p_error_table => l_error_tbl

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 660: BIS_UTILITIES_PVT.Add_Error_Message

656: WHEN FND_API.G_EXC_ERROR THEN
657: x_return_status := FND_API.G_RET_STS_ERROR ;
658: WHEN OTHERS THEN
659: l_error_tbl := x_error_tbl;
660: BIS_UTILITIES_PVT.Add_Error_Message
661: ( p_error_msg_id => SQLCODE
662: , p_error_description => SQLERRM
663: , p_error_proc_name => G_PKG_NAME||'.Delete_Dimension_Level'
664: , p_error_table => l_error_tbl

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 904: /*BIS_UTIL.Validate_For_Update

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
907: , p_force_mode => p_force_mode
908: , p_table_name => 'BSC_SYS_DIM_LEVELS_B'

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 1048: BIS_UTILITIES_PVT.Add_Error_Message

1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045: WHEN OTHERS THEN
1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1047: l_error_tbl := x_error_tbl;
1048: BIS_UTILITIES_PVT.Add_Error_Message
1049: ( p_error_msg_id => SQLCODE
1050: , p_error_description => SQLERRM
1051: , p_error_proc_name => G_PKG_NAME||'.Trans_DimObj_By_Given_Lang'
1052: , p_error_table => l_error_tbl

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