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

Line 58: , p_error_Tbl IN BIS_UTILITIES_PUB.Error_Tbl_Type

54: FUNCTION isPMFDimensionLevel(p_dim_level_id IN NUMBER) RETURN BOOLEAN ;
55: FUNCTION IS_TARGET_DEFINED( p_dim_level_id IN NUMBER) RETURN BOOLEAN;
56: FUNCTION IS_ASSIGNED_TO_KPI( p_dim_level_id IN NUMBER) RETURN BOOLEAN ;
57: PROCEDURE validate_disabling (p_dim_level_id IN NUMBER
58: , p_error_Tbl IN BIS_UTILITIES_PUB.Error_Tbl_Type
59: , x_return_status OUT NOCOPY VARCHAR2
60: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
61: );
62:

Line 60: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

56: FUNCTION IS_ASSIGNED_TO_KPI( p_dim_level_id IN NUMBER) RETURN BOOLEAN ;
57: PROCEDURE validate_disabling (p_dim_level_id IN NUMBER
58: , p_error_Tbl IN BIS_UTILITIES_PUB.Error_Tbl_Type
59: , x_return_status OUT NOCOPY VARCHAR2
60: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
61: );
62:
63: --
64: --

Line 107: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

103: PROCEDURE UpdateRecord
104: ( p_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
105: , x_Dimension_Level_Rec OUT NOCOPY BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
106: , x_return_status OUT NOCOPY VARCHAR2
107: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
108: );
109: --
110: FUNCTION Is_Level_Name_Used
111: (

Line 207: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

203: PROCEDURE UpdateRecord
204: ( p_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
205: , x_Dimension_Level_Rec OUT NOCOPY BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
206: , x_return_status OUT NOCOPY VARCHAR2
207: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
208: )
209: IS
210: --
211: l_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;

Line 213: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

209: IS
210: --
211: l_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;
212: l_return_status VARCHAR2(10);
213: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
214: --
215: BEGIN
216:
217: -- retrieve record from db

Line 233: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_ID) = FND_API.G_TRUE) AND (p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN

229:
230: -- apply changes
231:
232: -- Primary dimension starts
233: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_ID) = FND_API.G_TRUE) AND (p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN
234: l_Dimension_Level_Rec.Dimension_ID := p_Dimension_Level_Rec.Dimension_ID;
235: END IF;
236: --
237: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_Short_Name) = FND_API.G_TRUE) AND(p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN

Line 237: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_Short_Name) = FND_API.G_TRUE) AND(p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN

233: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_ID) = FND_API.G_TRUE) AND (p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN
234: l_Dimension_Level_Rec.Dimension_ID := p_Dimension_Level_Rec.Dimension_ID;
235: END IF;
236: --
237: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_Short_Name) = FND_API.G_TRUE) AND(p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN
238: l_Dimension_Level_Rec.Dimension_Short_Name := p_Dimension_Level_Rec.Dimension_Short_Name ;
239: END IF;
240: --
241: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_Name) = FND_API.G_TRUE) AND (p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN

Line 241: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_Name) = FND_API.G_TRUE) AND (p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN

237: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_Short_Name) = FND_API.G_TRUE) AND(p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN
238: l_Dimension_Level_Rec.Dimension_Short_Name := p_Dimension_Level_Rec.Dimension_Short_Name ;
239: END IF;
240: --
241: IF( (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Dimension_Name) = FND_API.G_TRUE) AND (p_Dimension_Level_Rec.Primary_Dim = FND_API.G_TRUE) ) THEN
242: l_Dimension_Level_Rec.Dimension_Name := p_Dimension_Level_Rec.Dimension_Name;
243: END IF;
244: -- Primary dimension ends
245:

Line 246: IF( BIS_UTILITIES_PUB.Value_Not_Missing(

242: l_Dimension_Level_Rec.Dimension_Name := p_Dimension_Level_Rec.Dimension_Name;
243: END IF;
244: -- Primary dimension ends
245:
246: IF( BIS_UTILITIES_PUB.Value_Not_Missing(
247: p_Dimension_Level_Rec.Dimension_Level_ID)
248: = FND_API.G_TRUE
249: ) THEN
250: l_Dimension_Level_Rec.Dimension_Level_ID

Line 254: IF( BIS_UTILITIES_PUB.Value_Not_Missing(

250: l_Dimension_Level_Rec.Dimension_Level_ID
251: := p_Dimension_Level_Rec.Dimension_Level_ID;
252: END IF;
253: --
254: IF( BIS_UTILITIES_PUB.Value_Not_Missing(
255: p_Dimension_Level_Rec.Dimension_Level_Short_Name)
256: = FND_API.G_TRUE
257: ) THEN
258: l_Dimension_Level_Rec.Dimension_Level_Short_Name

Line 262: IF( BIS_UTILITIES_PUB.Value_Not_Missing(

258: l_Dimension_Level_Rec.Dimension_Level_Short_Name
259: := p_Dimension_Level_Rec.Dimension_Level_Short_Name ;
260: END IF;
261: --
262: IF( BIS_UTILITIES_PUB.Value_Not_Missing(
263: p_Dimension_Level_Rec.Dimension_Level_Name)
264: = FND_API.G_TRUE
265: ) THEN
266: l_Dimension_Level_Rec.Dimension_Level_Name

Line 271: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Description)

267: := p_Dimension_Level_Rec.Dimension_Level_Name;
268: END IF;
269: --
270: -- jxyu added AND condition
271: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Description)
272: = FND_API.G_TRUE)
273: AND (p_Dimension_Level_Rec.Description IS NOT NULL) THEN
274: l_Dimension_Level_Rec.Description
275: := p_Dimension_Level_Rec.Description;

Line 279: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Level_Values_View_Name) = FND_API.G_TRUE)

275: := p_Dimension_Level_Rec.Description;
276: END IF;
277: --
278: -- jxyu added AND condition
279: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Level_Values_View_Name) = FND_API.G_TRUE)
280: AND (p_Dimension_Level_Rec.Level_Values_View_Name IS NOT NULL) THEN
281: l_Dimension_Level_Rec.Level_Values_View_Name
282: := p_Dimension_Level_Rec.Level_Values_View_Name;
283: END IF;

Line 286: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.where_Clause )

282: := p_Dimension_Level_Rec.Level_Values_View_Name;
283: END IF;
284: --
285: -- jxyu added AND condition
286: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.where_Clause )
287: = FND_API.G_TRUE)
288: AND (p_Dimension_Level_Rec.where_Clause IS NOT NULL) THEN
289: l_Dimension_Level_Rec.where_Clause
290: := p_Dimension_Level_Rec.where_Clause;

Line 294: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.source )

290: := p_Dimension_Level_Rec.where_Clause;
291: END IF;
292: --
293: --jxyu modified the condition
294: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.source )
295: = FND_API.G_TRUE)
296: AND (p_Dimension_Level_Rec.source IS NOT NULL) THEN
297: l_Dimension_Level_Rec.source
298: := p_Dimension_Level_Rec.source;

Line 305: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Attribute_Code ) = FND_API.G_TRUE)

301: --jxyu added for #2435226
302: -- Bug #3266561 -removed condition to default comparision to NULL when passed from UI;
303: l_Dimension_Level_Rec.Comparison_Label_Code := p_Dimension_Level_Rec.Comparison_Label_Code;
304:
305: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Attribute_Code ) = FND_API.G_TRUE)
306: AND (p_Dimension_Level_Rec.Attribute_Code IS NOT NULL) THEN
307: l_Dimension_Level_Rec.Attribute_Code
308: := p_Dimension_Level_Rec.Attribute_Code;
309: END IF;

Line 311: IF(BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Application_ID) = FND_API.G_TRUE)

307: l_Dimension_Level_Rec.Attribute_Code
308: := p_Dimension_Level_Rec.Attribute_Code;
309: END IF;
310:
311: IF(BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Application_ID) = FND_API.G_TRUE)
312: AND (p_Dimension_Level_Rec.Application_ID IS NOT NULL) THEN
313: l_Dimension_Level_Rec.Application_ID := p_Dimension_Level_Rec.Application_ID;
314: END IF;
315:

Line 319: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Long_Lov ) = FND_API.G_TRUE)

315:
316: -- Bug #3266561 -removed condition to default default_search to NULL when passed from UI;
317: l_Dimension_Level_Rec.default_search := p_Dimension_Level_Rec.Default_Search;
318:
319: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Long_Lov ) = FND_API.G_TRUE)
320: AND (p_Dimension_Level_Rec.Long_Lov IS NOT NULL) THEN
321: l_Dimension_Level_Rec.Long_Lov
322: := p_Dimension_Level_Rec.Long_Lov;
323: END IF;

Line 328: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.View_Object_Name ) = FND_API.G_TRUE)

324:
325: l_Dimension_Level_Rec.Master_Level := p_Dimension_Level_Rec.Master_Level;
326:
327:
328: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.View_Object_Name ) = FND_API.G_TRUE)
329: AND (p_Dimension_Level_Rec.View_Object_Name IS NOT NULL) THEN
330: l_Dimension_Level_Rec.View_Object_Name
331: := p_Dimension_Level_Rec.View_Object_Name;
332: END IF;

Line 337: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Enabled ) = FND_API.G_TRUE)

333:
334: -- Bug #3567463 -removed condition to default Default_Values_Api to NULL when passed from UI;
335: l_Dimension_Level_Rec.Default_Values_Api := p_Dimension_Level_Rec.Default_Values_Api;
336:
337: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Enabled ) = FND_API.G_TRUE)
338: AND (p_Dimension_Level_Rec.Enabled IS NOT NULL) THEN
339: l_Dimension_Level_Rec.Enabled
340: := p_Dimension_Level_Rec.Enabled;
341: END IF;

Line 343: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Hide ) = FND_API.G_TRUE)

339: l_Dimension_Level_Rec.Enabled
340: := p_Dimension_Level_Rec.Enabled;
341: END IF;
342:
343: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Rec.Hide ) = FND_API.G_TRUE)
344: AND (p_Dimension_Level_Rec.Hide IS NOT NULL) THEN
345: l_Dimension_Level_Rec.Hide := p_Dimension_Level_Rec.Hide;
346: END IF;
347:

Line 379: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

375: ( p_api_version IN NUMBER
376: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
377: , x_Dimension_Level_Tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
378: , x_return_status OUT NOCOPY VARCHAR2
379: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
380: )
381: IS
382: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
383: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

Line 382: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

378: , x_return_status OUT NOCOPY VARCHAR2
379: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
380: )
381: IS
382: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
383: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
384: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
385: --flag to check if there is an error
386: l_flag NUMBER :=0;

Line 466: IF BIS_UTILITIES_PUB.Value_Not_Missing(

462: BEGIN
463:
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465:
466: IF BIS_UTILITIES_PUB.Value_Not_Missing(
467: p_Dimension_Rec.dimension_id)
468: = FND_API.G_TRUE
469: THEN
470:

Line 501: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(

497: x_dimension_level_tbl(x_dimension_level_tbl.count+1) := l_dim_level_rec;
498:
499: end loop;
500:
501: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(
502: p_Dimension_Rec.dimension_short_name)
503: = FND_API.G_TRUE
504: THEN
505:

Line 534: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(

530:
531: x_dimension_level_tbl(x_dimension_level_tbl.count+1) := l_dim_level_rec;
532:
533: end loop;
534: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(
535: p_Dimension_Rec.dimension_name)
536: = FND_API.G_TRUE
537: THEN
538:

Line 575: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

571: BIS_UTILITIES_PVT.Add_Error_Message
572: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
573: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
574: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Levels'
575: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
576: , p_error_table => l_error_tbl
577: , x_error_table => x_error_tbl
578: );
579:

Line 590: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

586: BIS_UTILITIES_PVT.Add_Error_Message
587: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
588: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
589: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Levels'
590: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
591: , p_error_table => l_error_tbl
592: , x_error_table => x_error_tbl
593: );
594:

Line 630: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

626: ( p_api_version IN NUMBER
627: , p_Dimension_level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
628: , x_Dimension_level_Rec IN OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
629: , x_return_status OUT NOCOPY VARCHAR2
630: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
631: )
632: IS
633: l_dim_id NUMBER;
634: l_dim_short_name varchar2(30);

Line 637: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

633: l_dim_id NUMBER;
634: l_dim_short_name varchar2(30);
635: l_dim_name varchar2(80);
636: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
637: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
638: cursor cr_lev_id is
639: select dimension_id
640: , dimension_short_name
641: , dimension_name

Line 718: IF BIS_UTILITIES_PUB.Value_Not_Missing(

714: BEGIN
715:
716: x_return_status := FND_API.G_RET_STS_SUCCESS;
717:
718: IF BIS_UTILITIES_PUB.Value_Not_Missing(
719: p_Dimension_level_Rec.dimension_level_id)
720: = FND_API.G_TRUE
721: THEN
722: OPEN cr_lev_id;

Line 751: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(

747: x_return_status := FND_API.G_RET_STS_ERROR;
748: END IF;
749: CLOSE cr_lev_id;
750:
751: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(
752: p_Dimension_level_Rec.dimension_level_short_name)
753: = FND_API.G_TRUE
754: THEN
755: OPEN cr_lev_short_name;

Line 784: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(

780: x_return_status := FND_API.G_RET_STS_ERROR;
781: END IF;
782: CLOSE cr_lev_short_name;
783:
784: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(
785: p_Dimension_level_Rec.dimension_level_name)
786: = FND_API.G_TRUE
787: THEN
788: OPEN cr_lev_name;

Line 823: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

819: BIS_UTILITIES_PVT.Add_Error_Message
820: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_VALUE'
821: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
822: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Level'
823: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
824: , p_error_table => l_error_tbl
825: , x_error_table => x_error_tbl
826: );
827: RAISE FND_API.G_EXC_ERROR;

Line 837: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

833: BIS_UTILITIES_PVT.Add_Error_Message
834: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_VALUE'
835: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
836: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Dimension_Level'
837: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
838: , p_error_table => l_error_tbl
839: , x_error_table => x_error_tbl
840: );
841: RAISE FND_API.G_EXC_ERROR;

Line 882: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

878: p_api_version IN NUMBER
879: ,p_all_dim_levels_tbl IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
880: ,x_all_dim_levels_tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
881: ,x_return_status OUT NOCOPY VARCHAR2
882: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
883: )
884: IS
885: TYPE ref_cursor_type IS REF CURSOR;
886: c_dim_level_details ref_cursor_type;

Line 893: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

889: l_bind_var_tbl bind_variables_tbl_type;
890: l_sql VARCHAR2(32000);
891: l_is_bind BOOLEAN := FALSE;
892: l_is_execute BOOLEAN := FALSE;
893: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
894:
895: BEGIN
896:
897: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1072: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1068: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1069: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1070: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1071: , x_return_status OUT NOCOPY VARCHAR2
1072: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1073: )
1074: IS
1075: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1076: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

Line 1075: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1071: , x_return_status OUT NOCOPY VARCHAR2
1072: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1073: )
1074: IS
1075: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1076: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1077: BEGIN
1078:
1079:

Line 1087: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

1083: ( p_api_version => p_api_version
1084: , p_commit => p_commit
1085: , p_validation_level => p_validation_level
1086: , p_Dimension_Level_Rec => l_Dimension_Level_Rec
1087: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1088: , x_return_status => x_return_status
1089: , x_error_Tbl => x_error_Tbl
1090: );
1091:

Line 1116: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1112: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1113: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1114: , p_owner IN VARCHAR2
1115: , x_return_status OUT NOCOPY VARCHAR2
1116: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1117: )
1118: IS
1119: l_user_id NUMBER;
1120: l_login_id NUMBER;

Line 1125: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1121: l_id NUMBER;
1122: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1123: l_level_name_is_used BOOLEAN;
1124: l_msg VARCHAR2(1000);
1125: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1126:
1127: DUPLICATE_DIMENSION_VALUE EXCEPTION;
1128: PRAGMA EXCEPTION_INIT(DUPLICATE_DIMENSION_VALUE, -1);
1129:

Line 1139: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.Dimension_id) = FND_API.G_TRUE )

1135: ( p_dimension_level_Rec => p_dimension_level_Rec
1136: , x_dimension_level_Rec => l_dimension_level_Rec
1137: );
1138:
1139: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.Dimension_id) = FND_API.G_TRUE )
1140: OR (BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.Dimension_id) = FND_API.G_TRUE )
1141: THEN
1142:
1143: BIS_DIMENSION_PVT.Value_ID_Conversion

Line 1140: OR (BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.Dimension_id) = FND_API.G_TRUE )

1136: , x_dimension_level_Rec => l_dimension_level_Rec
1137: );
1138:
1139: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.Dimension_id) = FND_API.G_TRUE )
1140: OR (BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.Dimension_id) = FND_API.G_TRUE )
1141: THEN
1142:
1143: BIS_DIMENSION_PVT.Value_ID_Conversion
1144: ( p_api_version

Line 1170: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

1166: BIS_UTILITIES_PVT.Add_Error_Message
1167: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
1168: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1169: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension_Level'
1170: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1171: , p_error_table => l_error_tbl
1172: , x_error_table => x_error_tbl
1173: );
1174:

Line 1183: l_Dimension_Level_Rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

1179: -- ankgoel: bug#3891748 - Created_By will take precedence over Owner.
1180: -- Last_Updated_By can be different from Created_By while creating dim levels
1181: -- during sync-up
1182: IF (l_Dimension_Level_Rec.Created_By IS NULL) THEN
1183: l_Dimension_Level_Rec.Created_By := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1184: END IF;
1185: IF (l_Dimension_Level_Rec.Last_Updated_By IS NULL) THEN
1186: l_Dimension_Level_Rec.Last_Updated_By := l_Dimension_Level_Rec.Created_By;
1187: END IF;

Line 1192: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.source)

1188: IF (l_Dimension_Level_Rec.Last_Update_Login IS NULL) THEN
1189: l_Dimension_Level_Rec.Last_Update_Login := fnd_global.LOGIN_ID;
1190: END IF;
1191:
1192: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.source)
1193: = FND_API.G_TRUE)
1194: OR (BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.source)
1195: = FND_API.G_TRUE)
1196: THEN

Line 1194: OR (BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.source)

1190: END IF;
1191:
1192: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.source)
1193: = FND_API.G_TRUE)
1194: OR (BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.source)
1195: = FND_API.G_TRUE)
1196: THEN
1197: l_Dimension_Level_Rec.source := FND_PROFILE.value('BIS_SOURCE');
1198: END IF;

Line 1258: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

1254:
1255: l_msg := 'Failed to upload ' || nvl(l_Dimension_Level_Rec.Dimension_Level_Short_Name, ' ');
1256: l_msg := l_msg || ' Level name: ' || nvl(l_Dimension_Level_Rec.Dimension_Level_Name, ' ');
1257: l_msg := l_msg || ' already exists in the database. ' ;
1258: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
1259:
1260: END IF;
1261:
1262:

Line 1272: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

1268: BIS_UTILITIES_PVT.Add_Error_Message
1269: ( p_error_msg_name => 'BIS_DIM_LEVEL_UNIQUENESS_ERROR'
1270: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1271: , p_error_proc_name => G_PKG_NAME||'.Create_Dimension_Level'
1272: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1273: , p_error_table => l_error_tbl
1274: , x_error_table => x_error_tbl
1275: );
1276:

Line 1469: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

1465: fnd_message.set_name('BIS', 'BIS_LVL_UPLD_FAIL');
1466: fnd_message.set_token('SHORT_NAME', p_level_short_name);
1467: fnd_message.set_token('NAME', p_level_name);
1468: l_msg := fnd_message.get;
1469: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
1470: */
1471:
1472: l_msg := 'Failed to upload ' || nvl ( p_level_short_name , ' ' );
1473: l_msg := l_msg || ' Level name: ' || nvl ( p_level_name , ' ' );

Line 1475: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);

1471:
1472: l_msg := 'Failed to upload ' || nvl ( p_level_short_name , ' ' );
1473: l_msg := l_msg || ' Level name: ' || nvl ( p_level_name , ' ' );
1474: l_msg := l_msg || ' already exists in the database. ' ;
1475: BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
1476:
1477:
1478: ROLLBACK TO InsertIntoBISLevels;
1479: RAISE;

Line 1491: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1487: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1488: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1489: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1490: , x_return_status OUT NOCOPY VARCHAR2
1491: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1492: )
1493: IS
1494: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1495: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1495: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1491: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1492: )
1493: IS
1494: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1495: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1496: BEGIN
1497:
1498: l_Dimension_Level_Rec := p_Dimension_Level_Rec;
1499: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);

Line 1506: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

1502: ( p_api_version => p_api_version
1503: , p_commit => p_commit
1504: , p_validation_level => p_validation_level
1505: , p_Dimension_Level_Rec => l_Dimension_Level_Rec
1506: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1507: , x_return_status => x_return_status
1508: , x_error_Tbl => x_error_Tbl
1509: );
1510:

Line 1535: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1531: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1532: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1533: , p_owner IN VARCHAR2
1534: , x_return_status OUT NOCOPY VARCHAR2
1535: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1536: )
1537: IS
1538: l_user_id NUMBER;
1539: l_login_id NUMBER;

Line 1542: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1538: l_user_id NUMBER;
1539: l_login_id NUMBER;
1540: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1541: l_count NUMBER := 0;
1542: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1543: --exception
1544:
1545: DUPLICATE_DIMENSION_VALUE EXCEPTION;
1546: PRAGMA EXCEPTION_INIT(DUPLICATE_DIMENSION_VALUE, -1);

Line 1575: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

1571: BIS_UTILITIES_PVT.Add_Error_Message
1572: ( p_error_msg_name => 'BIS_INVALID_DIM_LEVEL_ID'
1573: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1574: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
1575: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1576: , p_error_table => l_error_tbl
1577: , x_error_table => x_error_tbl
1578: );
1579: RAISE FND_API.G_EXC_ERROR;

Line 1594: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

1590: RAISE FND_API.G_EXC_ERROR;
1591: END IF;
1592: END IF;
1593:
1594: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1595: l_login_id := fnd_global.LOGIN_ID;
1596:
1597: ----------------
1598: --Adding this for the source column

Line 1599: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.source)

1595: l_login_id := fnd_global.LOGIN_ID;
1596:
1597: ----------------
1598: --Adding this for the source column
1599: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.source)
1600: = FND_API.G_TRUE)
1601: OR (BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.source)
1602: = FND_API.G_TRUE)
1603: THEN

Line 1601: OR (BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.source)

1597: ----------------
1598: --Adding this for the source column
1599: IF (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.source)
1600: = FND_API.G_TRUE)
1601: OR (BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.source)
1602: = FND_API.G_TRUE)
1603: THEN
1604: l_Dimension_Level_Rec.source := FND_PROFILE.value('BIS_SOURCE');
1605: END IF;

Line 1656: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

1652: BIS_UTILITIES_PVT.Add_Error_Message
1653: ( p_error_msg_name => 'BIS_DIM_LEVEL_UNIQUENESS_ERROR'
1654: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1655: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
1656: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1657: , p_error_table => l_error_tbl
1658: , x_error_table => x_error_tbl
1659: );
1660: WHEN NO_DATA_FOUND THEN

Line 1692: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1688: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1689: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1690: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1691: , x_return_status OUT NOCOPY VARCHAR2
1692: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1693: )
1694: IS
1695: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1696: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

Line 1695: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1691: , x_return_status OUT NOCOPY VARCHAR2
1692: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1693: )
1694: IS
1695: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1696: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1697: BEGIN
1698:
1699: l_Dimension_Level_Rec := p_Dimension_Level_Rec;

Line 1707: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

1703: ( p_api_version => p_api_version
1704: , p_commit => p_commit
1705: , p_validation_level => p_validation_level
1706: , p_Dimension_Level_Rec => l_Dimension_Level_Rec
1707: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1708: , x_return_status => x_return_status
1709: , x_error_Tbl => x_error_Tbl
1710: );
1711:

Line 1736: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1732: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1733: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1734: , p_owner IN VARCHAR2
1735: , x_return_status OUT NOCOPY VARCHAR2
1736: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1737: )
1738: IS
1739: l_user_id NUMBER;
1740: l_login_id NUMBER;

Line 1743: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1739: l_user_id NUMBER;
1740: l_login_id NUMBER;
1741: l_count NUMBER := 0;
1742: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1743: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1744:
1745: BEGIN
1746: x_return_status := FND_API.G_RET_STS_SUCCESS;
1747:

Line 1768: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);

1764: IF( x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1765: RAISE FND_API.G_EXC_ERROR;
1766: END IF;
1767: --
1768: l_user_id := BIS_UTILITIES_PUB.Get_Owner_Id(p_owner);
1769: l_login_id := fnd_global.LOGIN_ID;
1770: --
1771: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);
1772: Update bis_levels_TL

Line 1820: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1816: ( p_api_version IN NUMBER
1817: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1818: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1819: , x_return_status OUT NOCOPY VARCHAR2
1820: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1821: )
1822: is
1823: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1824: begin

Line 1823: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1819: , x_return_status OUT NOCOPY VARCHAR2
1820: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1821: )
1822: is
1823: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1824: begin
1825:
1826: x_return_status := FND_API.G_RET_STS_SUCCESS;
1827: x_Dimension_Level_Rec := p_Dimension_Level_Rec;

Line 1829: if (BIS_UTILITIES_PUB.Value_Missing

1825:
1826: x_return_status := FND_API.G_RET_STS_SUCCESS;
1827: x_Dimension_Level_Rec := p_Dimension_Level_Rec;
1828:
1829: if (BIS_UTILITIES_PUB.Value_Missing
1830: (x_Dimension_Level_Rec.Dimension_level_id) = FND_API.G_TRUE
1831: AND ( BIS_UTILITIES_PUB.Value_Not_Missing
1832: (x_Dimension_Level_Rec.Dimension_level_short_name) = FND_API.G_TRUE
1833: OR BIS_UTILITIES_PUB.Value_Not_Missing

Line 1831: AND ( BIS_UTILITIES_PUB.Value_Not_Missing

1827: x_Dimension_Level_Rec := p_Dimension_Level_Rec;
1828:
1829: if (BIS_UTILITIES_PUB.Value_Missing
1830: (x_Dimension_Level_Rec.Dimension_level_id) = FND_API.G_TRUE
1831: AND ( BIS_UTILITIES_PUB.Value_Not_Missing
1832: (x_Dimension_Level_Rec.Dimension_level_short_name) = FND_API.G_TRUE
1833: OR BIS_UTILITIES_PUB.Value_Not_Missing
1834: (x_Dimension_Level_Rec.Dimension_level_name) = FND_API.G_TRUE)
1835: ) then

Line 1833: OR BIS_UTILITIES_PUB.Value_Not_Missing

1829: if (BIS_UTILITIES_PUB.Value_Missing
1830: (x_Dimension_Level_Rec.Dimension_level_id) = FND_API.G_TRUE
1831: AND ( BIS_UTILITIES_PUB.Value_Not_Missing
1832: (x_Dimension_Level_Rec.Dimension_level_short_name) = FND_API.G_TRUE
1833: OR BIS_UTILITIES_PUB.Value_Not_Missing
1834: (x_Dimension_Level_Rec.Dimension_level_name) = FND_API.G_TRUE)
1835: ) then
1836: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion
1837: ( p_api_version

Line 1846: if (BIS_UTILITIES_PUB.Value_Missing

1842: , x_error_Tbl
1843: );
1844: end if;
1845:
1846: if (BIS_UTILITIES_PUB.Value_Missing
1847: (x_Dimension_Level_Rec.Dimension_id) = FND_API.G_TRUE
1848: AND ( BIS_UTILITIES_PUB.Value_Not_Missing
1849: (x_Dimension_Level_Rec.Dimension_short_name) = FND_API.G_TRUE
1850: OR BIS_UTILITIES_PUB.Value_Not_Missing

Line 1848: AND ( BIS_UTILITIES_PUB.Value_Not_Missing

1844: end if;
1845:
1846: if (BIS_UTILITIES_PUB.Value_Missing
1847: (x_Dimension_Level_Rec.Dimension_id) = FND_API.G_TRUE
1848: AND ( BIS_UTILITIES_PUB.Value_Not_Missing
1849: (x_Dimension_Level_Rec.Dimension_short_name) = FND_API.G_TRUE
1850: OR BIS_UTILITIES_PUB.Value_Not_Missing
1851: (x_Dimension_Level_Rec.Dimension_name) = FND_API.G_TRUE)
1852: ) then

Line 1850: OR BIS_UTILITIES_PUB.Value_Not_Missing

1846: if (BIS_UTILITIES_PUB.Value_Missing
1847: (x_Dimension_Level_Rec.Dimension_id) = FND_API.G_TRUE
1848: AND ( BIS_UTILITIES_PUB.Value_Not_Missing
1849: (x_Dimension_Level_Rec.Dimension_short_name) = FND_API.G_TRUE
1850: OR BIS_UTILITIES_PUB.Value_Not_Missing
1851: (x_Dimension_Level_Rec.Dimension_name) = FND_API.G_TRUE)
1852: ) then
1853: BIS_DIMENSION_PVT.Value_ID_Conversion
1854: ( p_api_version

Line 1896: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1892: , p_Dimension_Level_Short_Name IN VARCHAR2
1893: , p_Dimension_Level_Name IN VARCHAR2
1894: , x_Dimension_Level_ID OUT NOCOPY NUMBER
1895: , x_return_status OUT NOCOPY VARCHAR2
1896: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1897: )
1898: is
1899: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1900: begin

Line 1899: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1895: , x_return_status OUT NOCOPY VARCHAR2
1896: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1897: )
1898: is
1899: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1900: begin
1901:
1902: x_return_status := FND_API.G_RET_STS_SUCCESS;
1903:

Line 1904: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Short_Name)

1900: begin
1901:
1902: x_return_status := FND_API.G_RET_STS_SUCCESS;
1903:
1904: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Short_Name)
1905: = FND_API.G_TRUE) then
1906: SELECT dimension_level_id into x_Dimension_Level_ID
1907: FROM bisbv_dimension_levels
1908: WHERE dimension_level_short_name = p_Dimension_Level_Short_Name;

Line 1909: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Name)

1905: = FND_API.G_TRUE) then
1906: SELECT dimension_level_id into x_Dimension_Level_ID
1907: FROM bisbv_dimension_levels
1908: WHERE dimension_level_short_name = p_Dimension_Level_Short_Name;
1909: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Level_Name)
1910: = FND_API.G_TRUE) then
1911: SELECT dimension_level_id into x_Dimension_Level_ID
1912: FROM bisbv_dimension_levels
1913: WHERE dimension_level_name = p_Dimension_Level_Name;

Line 1922: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

1918: BIS_UTILITIES_PVT.Add_Error_Message
1919: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
1920: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1921: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
1922: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1923: , p_error_table => l_error_tbl
1924: , x_error_table => x_error_tbl
1925: );
1926:

Line 1956: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1952: ( p_api_version IN NUMBER
1953: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1954: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1955: , x_return_status OUT NOCOPY VARCHAR2
1956: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1957: )
1958: IS
1959: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1960: l_error VARCHAR2(10) := FND_API.G_FALSE;

Line 1959: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1955: , x_return_status OUT NOCOPY VARCHAR2
1956: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1957: )
1958: IS
1959: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1960: l_error VARCHAR2(10) := FND_API.G_FALSE;
1961: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
1962: BEGIN
1963:

Line 1961: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

1957: )
1958: IS
1959: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1960: l_error VARCHAR2(10) := FND_API.G_FALSE;
1961: l_error_tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
1962: BEGIN
1963:
1964: BEGIN
1965: BIS_DIM_LEVEL_VALIDATE_PVT.Validate_Record

Line 2019: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2015: p_commit IN VARCHAR2 := FND_API.G_FALSE
2016: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2017: , p_Dimension_Level_Rec IN BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
2018: , x_return_status OUT NOCOPY VARCHAR2
2019: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2020: ) IS
2021: l_dim_level_id NUMBER;
2022: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2023:

Line 2022: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2018: , x_return_status OUT NOCOPY VARCHAR2
2019: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2020: ) IS
2021: l_dim_level_id NUMBER;
2022: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2023:
2024: CURSOR cr_dim_short_name IS
2025: SELECT level_id
2026: FROM BIS_LEVELS

Line 2047: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

2043: BIS_UTILITIES_PVT.Add_Error_Message
2044: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
2045: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2046: , p_error_proc_name => G_PKG_NAME||'.Delete_Dimension_Level'
2047: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2048: , p_error_table => l_error_tbl
2049: , x_error_table => x_error_tbl
2050: );
2051: RAISE FND_API.G_EXC_ERROR;

Line 2097: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2093: p_commit IN VARCHAR2 := FND_API.G_FALSE
2094: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2095: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
2096: , x_return_status OUT NOCOPY VARCHAR2
2097: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2098: ) IS
2099:
2100: l_dim_level_id NUMBER;
2101: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 2101: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2097: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2098: ) IS
2099:
2100: l_dim_level_id NUMBER;
2101: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2102: l_user_id NUMBER;
2103: l_login_id NUMBER;
2104:
2105: BEGIN

Line 2429: , p_error_Tbl IN BIS_UTILITIES_PUB.Error_Tbl_Type

2425:
2426: END IS_ASSIGNED_TO_KPI;
2427:
2428: PROCEDURE validate_disabling (p_dim_level_id IN NUMBER
2429: , p_error_Tbl IN BIS_UTILITIES_PUB.Error_Tbl_Type
2430: , x_return_status OUT NOCOPY VARCHAR2
2431: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2432: ) IS
2433: BEGIN

Line 2431: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2427:
2428: PROCEDURE validate_disabling (p_dim_level_id IN NUMBER
2429: , p_error_Tbl IN BIS_UTILITIES_PUB.Error_Tbl_Type
2430: , x_return_status OUT NOCOPY VARCHAR2
2431: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2432: ) IS
2433: BEGIN
2434: -- check if the dimension level type is of PMF and then check if this can be disabled.
2435: IF ( isPMFDimensionLevel( p_dim_level_id => p_dim_level_id )) THEN

Line 2443: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

2439: BIS_UTILITIES_PVT.Add_Error_Message
2440: ( p_error_msg_name => 'BIS_PMF_DIM_LVL_USED_IN_TARGET'
2441: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2442: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
2443: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2444: , p_error_table => p_error_tbl
2445: , x_error_table => x_error_tbl
2446: );
2447: RAISE FND_API.G_EXC_ERROR;

Line 2456: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

2452: BIS_UTILITIES_PVT.Add_Error_Message
2453: ( p_error_msg_name => 'BIS_BSC_DIM_LVL_KPI_ASSIGNED'
2454: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2455: , p_error_proc_name => G_PKG_NAME||'.Update_Dimension_Level'
2456: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2457: , p_error_table => p_error_tbl
2458: , x_error_table => x_error_tbl
2459: );
2460: RAISE FND_API.G_EXC_ERROR;