APPS.BIS_TARGET_LEVEL_PVT dependencies on BIS_UTILITIES_PUB

Line 161: := BIS_UTILITIES_PUB.G_NULL_NUM;

157: IS
158: BEGIN
159:
160: x_dimension_level_rec.Dimension_ID
161: := BIS_UTILITIES_PUB.G_NULL_NUM;
162: x_dimension_level_rec.Dimension_Short_Name
163: := BIS_UTILITIES_PUB.G_NULL_CHAR;
164: x_dimension_level_rec.Dimension_Name
165: := BIS_UTILITIES_PUB.G_NULL_CHAR;

Line 163: := BIS_UTILITIES_PUB.G_NULL_CHAR;

159:
160: x_dimension_level_rec.Dimension_ID
161: := BIS_UTILITIES_PUB.G_NULL_NUM;
162: x_dimension_level_rec.Dimension_Short_Name
163: := BIS_UTILITIES_PUB.G_NULL_CHAR;
164: x_dimension_level_rec.Dimension_Name
165: := BIS_UTILITIES_PUB.G_NULL_CHAR;
166: x_dimension_level_rec.Dimension_Level_ID
167: := BIS_UTILITIES_PUB.G_NULL_NUM;

Line 165: := BIS_UTILITIES_PUB.G_NULL_CHAR;

161: := BIS_UTILITIES_PUB.G_NULL_NUM;
162: x_dimension_level_rec.Dimension_Short_Name
163: := BIS_UTILITIES_PUB.G_NULL_CHAR;
164: x_dimension_level_rec.Dimension_Name
165: := BIS_UTILITIES_PUB.G_NULL_CHAR;
166: x_dimension_level_rec.Dimension_Level_ID
167: := BIS_UTILITIES_PUB.G_NULL_NUM;
168: x_dimension_level_rec.Dimension_Level_Short_Name
169: := BIS_UTILITIES_PUB.G_NULL_CHAR;

Line 167: := BIS_UTILITIES_PUB.G_NULL_NUM;

163: := BIS_UTILITIES_PUB.G_NULL_CHAR;
164: x_dimension_level_rec.Dimension_Name
165: := BIS_UTILITIES_PUB.G_NULL_CHAR;
166: x_dimension_level_rec.Dimension_Level_ID
167: := BIS_UTILITIES_PUB.G_NULL_NUM;
168: x_dimension_level_rec.Dimension_Level_Short_Name
169: := BIS_UTILITIES_PUB.G_NULL_CHAR;
170: x_dimension_level_rec.Dimension_Level_Name
171: := BIS_UTILITIES_PUB.G_NULL_CHAR;

Line 169: := BIS_UTILITIES_PUB.G_NULL_CHAR;

165: := BIS_UTILITIES_PUB.G_NULL_CHAR;
166: x_dimension_level_rec.Dimension_Level_ID
167: := BIS_UTILITIES_PUB.G_NULL_NUM;
168: x_dimension_level_rec.Dimension_Level_Short_Name
169: := BIS_UTILITIES_PUB.G_NULL_CHAR;
170: x_dimension_level_rec.Dimension_Level_Name
171: := BIS_UTILITIES_PUB.G_NULL_CHAR;
172: x_dimension_level_rec.Description
173: := BIS_UTILITIES_PUB.G_NULL_CHAR;

Line 171: := BIS_UTILITIES_PUB.G_NULL_CHAR;

167: := BIS_UTILITIES_PUB.G_NULL_NUM;
168: x_dimension_level_rec.Dimension_Level_Short_Name
169: := BIS_UTILITIES_PUB.G_NULL_CHAR;
170: x_dimension_level_rec.Dimension_Level_Name
171: := BIS_UTILITIES_PUB.G_NULL_CHAR;
172: x_dimension_level_rec.Description
173: := BIS_UTILITIES_PUB.G_NULL_CHAR;
174: x_dimension_level_rec.Level_Values_View_Name
175: := BIS_UTILITIES_PUB.G_NULL_CHAR;

Line 173: := BIS_UTILITIES_PUB.G_NULL_CHAR;

169: := BIS_UTILITIES_PUB.G_NULL_CHAR;
170: x_dimension_level_rec.Dimension_Level_Name
171: := BIS_UTILITIES_PUB.G_NULL_CHAR;
172: x_dimension_level_rec.Description
173: := BIS_UTILITIES_PUB.G_NULL_CHAR;
174: x_dimension_level_rec.Level_Values_View_Name
175: := BIS_UTILITIES_PUB.G_NULL_CHAR;
176: x_dimension_level_rec.where_Clause
177: := BIS_UTILITIES_PUB.G_NULL_CHAR;

Line 175: := BIS_UTILITIES_PUB.G_NULL_CHAR;

171: := BIS_UTILITIES_PUB.G_NULL_CHAR;
172: x_dimension_level_rec.Description
173: := BIS_UTILITIES_PUB.G_NULL_CHAR;
174: x_dimension_level_rec.Level_Values_View_Name
175: := BIS_UTILITIES_PUB.G_NULL_CHAR;
176: x_dimension_level_rec.where_Clause
177: := BIS_UTILITIES_PUB.G_NULL_CHAR;
178: x_dimension_level_rec.source
179: := BIS_UTILITIES_PUB.G_NULL_CHAR;

Line 177: := BIS_UTILITIES_PUB.G_NULL_CHAR;

173: := BIS_UTILITIES_PUB.G_NULL_CHAR;
174: x_dimension_level_rec.Level_Values_View_Name
175: := BIS_UTILITIES_PUB.G_NULL_CHAR;
176: x_dimension_level_rec.where_Clause
177: := BIS_UTILITIES_PUB.G_NULL_CHAR;
178: x_dimension_level_rec.source
179: := BIS_UTILITIES_PUB.G_NULL_CHAR;
180:
181: EXCEPTION

Line 179: := BIS_UTILITIES_PUB.G_NULL_CHAR;

175: := BIS_UTILITIES_PUB.G_NULL_CHAR;
176: x_dimension_level_rec.where_Clause
177: := BIS_UTILITIES_PUB.G_NULL_CHAR;
178: x_dimension_level_rec.source
179: := BIS_UTILITIES_PUB.G_NULL_CHAR;
180:
181: EXCEPTION
182: WHEN FND_API.G_EXC_ERROR THEN
183: RAISE

Line 375: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

371: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
372: l_Measure_Rec BIS_MEASURE_PUB.Measure_Rec_Type;
373: l_target_level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
374: l_return_status VARCHAR2(100);
375: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
376: l_Measure_Rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
377: l_Dimension_Level_Rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
378:
379: BEGIN

Line 380: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Measure_ID)

376: l_Measure_Rec_p BIS_MEASURE_PUB.Measure_Rec_Type;
377: l_Dimension_Level_Rec_p BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
378:
379: BEGIN
380: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Measure_ID)
381: = FND_API.G_TRUE) then
382: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Measure_Short_Name)
383: = FND_API.G_TRUE) then
384:

Line 382: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Measure_Short_Name)

378:
379: BEGIN
380: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Measure_ID)
381: = FND_API.G_TRUE) then
382: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Measure_Short_Name)
383: = FND_API.G_TRUE) then
384:
385: l_Measure_Rec.Measure_Short_Name := p_target_level_rec.Measure_Short_Name;
386:

Line 404: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Org_Level_ID)

400: else
401: l_target_level_rec.Measure_ID := p_target_level_rec.Measure_ID;
402: end if;
403:
404: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Org_Level_ID)
405: = FND_API.G_TRUE) then
406: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Org_Level_Short_Name)
407: = FND_API.G_TRUE) then
408: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Org_Level_Short_Name;

Line 406: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Org_Level_Short_Name)

402: end if;
403:
404: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Org_Level_ID)
405: = FND_API.G_TRUE) then
406: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Org_Level_Short_Name)
407: = FND_API.G_TRUE) then
408: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Org_Level_Short_Name;
409:
410: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;

Line 427: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;

423: else
424: l_target_level_rec.Org_Level_ID := p_target_level_rec.Org_Level_ID;
425:
426: end if;
427: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
428: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
429:
430: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Time_Level_ID)
431: = FND_API.G_TRUE) then

Line 428: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;

424: l_target_level_rec.Org_Level_ID := p_target_level_rec.Org_Level_ID;
425:
426: end if;
427: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
428: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
429:
430: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Time_Level_ID)
431: = FND_API.G_TRUE) then
432: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Time_Level_Short_Name)

Line 430: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Time_Level_ID)

426: end if;
427: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
428: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
429:
430: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Time_Level_ID)
431: = FND_API.G_TRUE) then
432: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Time_Level_Short_Name)
433: = FND_API.G_TRUE) then
434: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Time_Level_Short_Name;

Line 432: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Time_Level_Short_Name)

428: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
429:
430: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Time_Level_ID)
431: = FND_API.G_TRUE) then
432: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Time_Level_Short_Name)
433: = FND_API.G_TRUE) then
434: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Time_Level_Short_Name;
435:
436: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;

Line 453: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;

449: else
450: l_target_level_rec.Time_Level_ID := p_target_level_rec.Time_Level_ID;
451:
452: end if;
453: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
454: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
455:
456:
457: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension1_Level_ID)

Line 454: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;

450: l_target_level_rec.Time_Level_ID := p_target_level_rec.Time_Level_ID;
451:
452: end if;
453: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
454: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
455:
456:
457: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension1_Level_ID)
458: = FND_API.G_TRUE) then

Line 457: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension1_Level_ID)

453: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
454: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
455:
456:
457: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension1_Level_ID)
458: = FND_API.G_TRUE) then
459: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension1_Level_Short_Name)
460: = FND_API.G_TRUE) then
461: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension1_Level_Short_Name;

Line 459: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension1_Level_Short_Name)

455:
456:
457: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension1_Level_ID)
458: = FND_API.G_TRUE) then
459: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension1_Level_Short_Name)
460: = FND_API.G_TRUE) then
461: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension1_Level_Short_Name;
462:
463: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;

Line 480: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;

476: else
477: l_target_level_rec.Dimension1_Level_ID := p_target_level_rec.Dimension1_Level_ID;
478:
479: end if;
480: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
481: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
482:
483:
484: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension2_Level_ID)

Line 481: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;

477: l_target_level_rec.Dimension1_Level_ID := p_target_level_rec.Dimension1_Level_ID;
478:
479: end if;
480: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
481: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
482:
483:
484: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension2_Level_ID)
485: = FND_API.G_TRUE) then

Line 484: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension2_Level_ID)

480: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
481: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
482:
483:
484: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension2_Level_ID)
485: = FND_API.G_TRUE) then
486: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension2_Level_Short_Name)
487: = FND_API.G_TRUE) then
488: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension2_Level_Short_Name;

Line 486: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension2_Level_Short_Name)

482:
483:
484: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension2_Level_ID)
485: = FND_API.G_TRUE) then
486: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension2_Level_Short_Name)
487: = FND_API.G_TRUE) then
488: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension2_Level_Short_Name;
489:
490: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;

Line 507: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;

503: else
504: l_target_level_rec.Dimension2_Level_ID := p_target_level_rec.Dimension2_Level_ID;
505:
506: end if;
507: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
508: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
509:
510: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension3_Level_ID)
511: = FND_API.G_TRUE) then

Line 508: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;

504: l_target_level_rec.Dimension2_Level_ID := p_target_level_rec.Dimension2_Level_ID;
505:
506: end if;
507: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
508: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
509:
510: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension3_Level_ID)
511: = FND_API.G_TRUE) then
512: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension3_Level_Short_Name)

Line 510: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension3_Level_ID)

506: end if;
507: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
508: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
509:
510: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension3_Level_ID)
511: = FND_API.G_TRUE) then
512: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension3_Level_Short_Name)
513: = FND_API.G_TRUE) then
514: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension3_Level_Short_Name;

Line 512: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension3_Level_Short_Name)

508: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
509:
510: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension3_Level_ID)
511: = FND_API.G_TRUE) then
512: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension3_Level_Short_Name)
513: = FND_API.G_TRUE) then
514: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension3_Level_Short_Name;
515:
516: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;

Line 533: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;

529: else
530: l_target_level_rec.Dimension3_Level_ID := p_target_level_rec.Dimension3_Level_ID;
531:
532: end if;
533: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
534: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
535:
536:
537: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension4_Level_ID)

Line 534: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;

530: l_target_level_rec.Dimension3_Level_ID := p_target_level_rec.Dimension3_Level_ID;
531:
532: end if;
533: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
534: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
535:
536:
537: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension4_Level_ID)
538: = FND_API.G_TRUE) then

Line 537: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension4_Level_ID)

533: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
534: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
535:
536:
537: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension4_Level_ID)
538: = FND_API.G_TRUE) then
539: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension4_Level_Short_Name)
540: = FND_API.G_TRUE) then
541: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension4_Level_Short_Name;

Line 539: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension4_Level_Short_Name)

535:
536:
537: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension4_Level_ID)
538: = FND_API.G_TRUE) then
539: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension4_Level_Short_Name)
540: = FND_API.G_TRUE) then
541: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension4_Level_Short_Name;
542:
543: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;

Line 560: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;

556: else
557: l_target_level_rec.Dimension4_Level_ID := p_target_level_rec.Dimension4_Level_ID;
558:
559: end if;
560: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
561: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
562:
563: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension5_Level_ID)
564: = FND_API.G_TRUE) then

Line 561: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;

557: l_target_level_rec.Dimension4_Level_ID := p_target_level_rec.Dimension4_Level_ID;
558:
559: end if;
560: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
561: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
562:
563: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension5_Level_ID)
564: = FND_API.G_TRUE) then
565: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension5_Level_Short_Name)

Line 563: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension5_Level_ID)

559: end if;
560: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
561: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
562:
563: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension5_Level_ID)
564: = FND_API.G_TRUE) then
565: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension5_Level_Short_Name)
566: = FND_API.G_TRUE) then
567: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension5_Level_Short_Name;

Line 565: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension5_Level_Short_Name)

561: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
562:
563: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension5_Level_ID)
564: = FND_API.G_TRUE) then
565: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension5_Level_Short_Name)
566: = FND_API.G_TRUE) then
567: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension5_Level_Short_Name;
568: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
569: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 583: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;

579: end if;
580: else
581: l_target_level_rec.Dimension5_Level_ID := p_target_level_rec.Dimension5_Level_ID;
582: end if;
583: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
584: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
585:
586: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension6_Level_ID)
587: = FND_API.G_TRUE) then

Line 584: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;

580: else
581: l_target_level_rec.Dimension5_Level_ID := p_target_level_rec.Dimension5_Level_ID;
582: end if;
583: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
584: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
585:
586: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension6_Level_ID)
587: = FND_API.G_TRUE) then
588: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension6_Level_Short_Name)

Line 586: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension6_Level_ID)

582: end if;
583: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
584: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
585:
586: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension6_Level_ID)
587: = FND_API.G_TRUE) then
588: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension6_Level_Short_Name)
589: = FND_API.G_TRUE) then
590: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension6_Level_Short_Name;

Line 588: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension6_Level_Short_Name)

584: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
585:
586: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension6_Level_ID)
587: = FND_API.G_TRUE) then
588: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension6_Level_Short_Name)
589: = FND_API.G_TRUE) then
590: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension6_Level_Short_Name;
591: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
592: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 606: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;

602: end if;
603: else
604: l_target_level_rec.Dimension6_Level_ID := p_target_level_rec.Dimension6_Level_ID;
605: end if;
606: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
607: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
608:
609: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension7_Level_ID)
610: = FND_API.G_TRUE) then

Line 607: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;

603: else
604: l_target_level_rec.Dimension6_Level_ID := p_target_level_rec.Dimension6_Level_ID;
605: end if;
606: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
607: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
608:
609: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension7_Level_ID)
610: = FND_API.G_TRUE) then
611: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension7_Level_Short_Name)

Line 609: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension7_Level_ID)

605: end if;
606: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
607: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
608:
609: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension7_Level_ID)
610: = FND_API.G_TRUE) then
611: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension7_Level_Short_Name)
612: = FND_API.G_TRUE) then
613: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension7_Level_Short_Name;

Line 611: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension7_Level_Short_Name)

607: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
608:
609: if (BIS_UTILITIES_PUB.Value_Missing(p_target_level_rec.Dimension7_Level_ID)
610: = FND_API.G_TRUE) then
611: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.Dimension7_Level_Short_Name)
612: = FND_API.G_TRUE) then
613: l_Dimension_Level_Rec.Dimension_Level_Short_Name := p_target_level_rec.Dimension7_Level_Short_Name;
614: l_Dimension_Level_Rec_p := l_Dimension_Level_Rec;
615: BIS_DIMENSION_LEVEL_PVT.Value_ID_Conversion

Line 629: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;

625: end if;
626: else
627: l_target_level_rec.Dimension7_Level_ID := p_target_level_rec.Dimension7_Level_ID;
628: end if;
629: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
630: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
631:
632: l_target_level_id := Get_Level_Id_From_Dimlevels(l_target_level_rec);
633:

Line 630: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;

626: else
627: l_target_level_rec.Dimension7_Level_ID := p_target_level_rec.Dimension7_Level_ID;
628: end if;
629: l_Dimension_Level_Rec.Dimension_Level_Short_Name := BIS_UTILITIES_PUB.G_NULL_CHAR;
630: l_Dimension_Level_Rec.Dimension_Level_Id := BIS_UTILITIES_PUB.G_NULL_NUM;
631:
632: l_target_level_id := Get_Level_Id_From_Dimlevels(l_target_level_rec);
633:
634: return l_target_level_id;

Line 647: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

643: , p_commit IN VARCHAR2 := FND_API.G_FALSE
644: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
645: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
646: , x_return_status OUT NOCOPY VARCHAR2
647: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
648: )
649: IS
650: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
651: BEGIN

Line 650: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

646: , x_return_status OUT NOCOPY VARCHAR2
647: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
648: )
649: IS
650: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
651: BEGIN
652:
653: Create_Target_Level
654: ( p_api_version => p_api_version

Line 658: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

654: ( p_api_version => p_api_version
655: , p_commit => p_commit
656: , p_validation_level => p_validation_level
657: , p_Target_Level_Rec => p_Target_Level_Rec
658: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
659: , x_return_status => x_return_status
660: , x_error_Tbl => x_error_Tbl
661: );
662:

Line 688: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

684: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
685: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
686: , p_owner IN VARCHAR2
687: , x_return_status OUT NOCOPY VARCHAR2
688: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
689: )
690: IS
691: l_user_id NUMBER;
692: l_login_id NUMBER;

Line 696: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

692: l_login_id NUMBER;
693: l_id NUMBER;
694: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
695: l_Target_Level_Id NUMBER;
696: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
697:
698: -- l_msg VARCHAR2(3000); -- 2515991
699:
700:

Line 743: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

739: BIS_UTILITIES_PVT.Add_Error_Message
740: ( p_error_msg_name => 'BIS_TRG_LVL_SHORT_NAME_UNIQUE'
741: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
742: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
743: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
744: , p_error_table => l_error_tbl
745: , x_error_table => x_error_tbl
746: );
747: RAISE FND_API.G_EXC_ERROR;

Line 759: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

755: BIS_UTILITIES_PVT.Add_Error_Message
756: ( p_error_msg_name => 'BIS_TRG_LVL_DIMLEVELS_UNIQUE'
757: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
758: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
759: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
760: , p_error_table => l_error_tbl
761: , x_error_table => x_error_tbl
762: );
763: RAISE FND_API.G_EXC_ERROR;

Line 766: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

762: );
763: RAISE FND_API.G_EXC_ERROR;
764: end if;
765:
766: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
767: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
768: ELSE
769: l_user_id := fnd_global.user_id;
770: END IF;

Line 767: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

763: RAISE FND_API.G_EXC_ERROR;
764: end if;
765:
766: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
767: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
768: ELSE
769: l_user_id := fnd_global.user_id;
770: END IF;
771: l_login_id := fnd_global.LOGIN_ID;

Line 773: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.system_flag)

769: l_user_id := fnd_global.user_id;
770: END IF;
771: l_login_id := fnd_global.LOGIN_ID;
772:
773: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.system_flag)
774: = FND_API.G_TRUE)
775: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.system_flag)
776: = FND_API.G_TRUE)
777: THEN

Line 775: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.system_flag)

771: l_login_id := fnd_global.LOGIN_ID;
772:
773: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.system_flag)
774: = FND_API.G_TRUE)
775: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.system_flag)
776: = FND_API.G_TRUE)
777: THEN
778: l_Target_Level_Rec.system_flag := 'N';
779: END IF;

Line 891: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

887: BIS_UTILITIES_PVT.Add_Error_Message
888: ( p_error_msg_name => 'BIS_TAR_LEVEL_UNIQUENESS_ERROR'
889: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
890: , p_error_proc_name => G_PKG_NAME||'.Create_Target_Level'
891: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
892: , p_error_table => l_error_tbl
893: , x_error_table => x_error_tbl
894: );
895: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991

Line 895: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991

891: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
892: , p_error_table => l_error_tbl
893: , x_error_table => x_error_tbl
894: );
895: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
896:
897: when FND_API.G_EXC_ERROR then
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ;-- 2515991

Line 899: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ;-- 2515991

895: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
896:
897: when FND_API.G_EXC_ERROR then
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ;-- 2515991
900:
901: when FND_API.G_EXC_UNEXPECTED_ERROR then
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991

Line 903: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991

899: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ;-- 2515991
900:
901: when FND_API.G_EXC_UNEXPECTED_ERROR then
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
904:
905: when others then
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991

Line 907: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991

903: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
904:
905: when others then
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: -- BIS_UTILITIES_PUB.put_line(p_text => l_msg ) ; -- 2515991
908:
909: l_error_tbl := x_error_tbl;
910: BIS_UTILITIES_PVT.Add_Error_Message
911: ( p_error_msg_id => SQLCODE

Line 925: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

921: ( p_api_version IN NUMBER
922: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
923: , x_count OUT NOCOPY NUMBER
924: , x_return_status OUT NOCOPY VARCHAR2
925: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
926: )
927: IS
928: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
929: BEGIN

Line 928: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

924: , x_return_status OUT NOCOPY VARCHAR2
925: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
926: )
927: IS
928: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
929: BEGIN
930:
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932: select count(1) into x_count

Line 968: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

964: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
965: , p_Measure_Rec IN BIS_MEASURE_PUB.Measure_Rec_Type
966: , x_Target_Level_tbl OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Tbl_Type
967: , x_return_status OUT NOCOPY VARCHAR2
968: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
969: )
970: IS
971:
972: i NUMBER := 0;

Line 975: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

971:
972: i NUMBER := 0;
973: l_Measure_id NUMBER;
974: l_Target_Level_rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
975: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
976:
977: cursor tar_level_bv IS
978: Select measure_id
979: , TARGET_LEVEL_ID

Line 1177: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

1173: BIS_UTILITIES_PVT.Add_Error_Message
1174: ( p_error_msg_name => 'BIS_INVALID_MEASURE_ID'
1175: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1176: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Levels'
1177: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1178: , p_error_table => l_error_tbl
1179: , x_error_table => x_error_tbl
1180: );
1181: RAISE FND_API.G_EXC_ERROR;

Line 1221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1217: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1218: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
1219: , x_Target_Level_Rec IN OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
1220: , x_return_status OUT NOCOPY VARCHAR2
1221: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1222: )
1223: IS
1224: l_ID NUMBER;
1225: l_indicator_id NUMBER;

Line 1233: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1229: l_Def_Notify_Resp_short_name VARCHAR2(100);
1230: l_Def_Notify_Resp_name VARCHAR2(240);
1231: l_Def_Notify_Resp_ID NUMBER;
1232: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1233: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1234: BEGIN
1235: x_return_status := FND_API.G_RET_STS_SUCCESS;
1236:
1237: l_Target_Level_rec := x_Target_Level_rec;

Line 1427: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

1423: BIS_UTILITIES_PVT.Add_Error_Message
1424: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
1425: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1426: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Target_Level'
1427: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1428: , p_error_table => l_error_tbl
1429: , x_error_table => x_error_tbl
1430: );
1431: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1466: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1462: ,p_target_level_tbl IN BIS_TARGET_LEVEL_PUB.target_level_tbl_type
1463: ,p_all_info IN VARCHAR2 := FND_API.G_TRUE
1464: ,x_target_level_tbl OUT NOCOPY BIS_TARGET_LEVEL_PUB.target_level_tbl_type
1465: ,x_return_status OUT NOCOPY VARCHAR2
1466: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1467: )
1468: IS
1469: TYPE ref_cursor_type IS REF CURSOR;
1470: c_targ_level_details ref_cursor_type;

Line 1478: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1474: l_index NUMBER;
1475: l_sql VARCHAR2(32000);
1476: l_is_bind BOOLEAN := FALSE;
1477: l_is_execute BOOLEAN := FALSE;
1478: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1479:
1480: BEGIN
1481:
1482: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1737: IF (BIS_UTILITIES_PUB.Value_Missing

1733: );
1734:
1735: -- If input record changed, then update record
1736: --
1737: IF (BIS_UTILITIES_PUB.Value_Missing
1738: (p_Target_Level_Rec.Target_Level_Short_Name) = FND_API.G_FALSE) THEN
1739: x_target_level_rec.Target_Level_Short_Name :=
1740: p_target_level_rec.Target_Level_Short_Name;
1741: -- x_changed := FND_API.G_TRUE;

Line 1744: IF (BIS_UTILITIES_PUB.Value_Missing

1740: p_target_level_rec.Target_Level_Short_Name;
1741: -- x_changed := FND_API.G_TRUE;
1742: END IF;
1743:
1744: IF (BIS_UTILITIES_PUB.Value_Missing
1745: (p_Target_Level_Rec.Target_Level_Name) = FND_API.G_FALSE) THEN
1746: x_target_level_rec.Target_Level_Name :=
1747: p_target_level_rec.Target_Level_Name;
1748: -- x_changed := FND_API.G_TRUE;

Line 1751: IF (BIS_UTILITIES_PUB.Value_Missing

1747: p_target_level_rec.Target_Level_Name;
1748: -- x_changed := FND_API.G_TRUE;
1749: END IF;
1750:
1751: IF (BIS_UTILITIES_PUB.Value_Missing
1752: (p_Target_Level_Rec.Description) = FND_API.G_FALSE) THEN
1753: x_target_level_rec.Description := p_target_level_rec.Description;
1754: -- x_changed := FND_API.G_TRUE;
1755: END IF;

Line 1757: IF (BIS_UTILITIES_PUB.Value_Missing

1753: x_target_level_rec.Description := p_target_level_rec.Description;
1754: -- x_changed := FND_API.G_TRUE;
1755: END IF;
1756:
1757: IF (BIS_UTILITIES_PUB.Value_Missing
1758: (p_Target_Level_Rec.org_Level_ID) = FND_API.G_FALSE) THEN
1759: x_target_level_rec.org_Level_ID :=
1760: p_target_level_rec.org_Level_ID;
1761: -- x_changed := FND_API.G_TRUE;

Line 1764: IF (BIS_UTILITIES_PUB.Value_Missing

1760: p_target_level_rec.org_Level_ID;
1761: -- x_changed := FND_API.G_TRUE;
1762: END IF;
1763:
1764: IF (BIS_UTILITIES_PUB.Value_Missing
1765: (p_Target_Level_Rec.time_Level_ID) = FND_API.G_FALSE) THEN
1766: x_target_level_rec.time_Level_ID :=
1767: p_target_level_rec.time_Level_ID;
1768: -- x_changed := FND_API.G_TRUE;

Line 1771: IF (BIS_UTILITIES_PUB.Value_Missing

1767: p_target_level_rec.time_Level_ID;
1768: -- x_changed := FND_API.G_TRUE;
1769: END IF;
1770:
1771: IF (BIS_UTILITIES_PUB.Value_Missing
1772: (p_Target_Level_Rec.Dimension1_Level_ID) = FND_API.G_FALSE) THEN
1773: x_target_level_rec.Dimension1_Level_ID :=
1774: p_target_level_rec.Dimension1_Level_ID;
1775: -- x_changed := FND_API.G_TRUE;

Line 1778: IF (BIS_UTILITIES_PUB.Value_Missing

1774: p_target_level_rec.Dimension1_Level_ID;
1775: -- x_changed := FND_API.G_TRUE;
1776: END IF;
1777:
1778: IF (BIS_UTILITIES_PUB.Value_Missing
1779: (p_Target_Level_Rec.Dimension2_Level_ID) = FND_API.G_FALSE) THEN
1780: x_target_level_rec.Dimension2_Level_ID :=
1781: p_target_level_rec.Dimension2_Level_ID;
1782: -- x_changed := FND_API.G_TRUE;

Line 1785: IF (BIS_UTILITIES_PUB.Value_Missing

1781: p_target_level_rec.Dimension2_Level_ID;
1782: -- x_changed := FND_API.G_TRUE;
1783: END IF;
1784:
1785: IF (BIS_UTILITIES_PUB.Value_Missing
1786: (p_Target_Level_Rec.Dimension3_Level_ID) = FND_API.G_FALSE) THEN
1787: x_target_level_rec.Dimension3_Level_ID :=
1788: p_target_level_rec.Dimension3_Level_ID;
1789: -- x_changed := FND_API.G_TRUE;

Line 1792: IF (BIS_UTILITIES_PUB.Value_Missing

1788: p_target_level_rec.Dimension3_Level_ID;
1789: -- x_changed := FND_API.G_TRUE;
1790: END IF;
1791:
1792: IF (BIS_UTILITIES_PUB.Value_Missing
1793: (p_Target_Level_Rec.Dimension4_Level_ID) = FND_API.G_FALSE) THEN
1794: x_target_level_rec.Dimension4_Level_ID :=
1795: p_target_level_rec.Dimension4_Level_ID;
1796: -- x_changed := FND_API.G_TRUE;

Line 1799: IF (BIS_UTILITIES_PUB.Value_Missing

1795: p_target_level_rec.Dimension4_Level_ID;
1796: -- x_changed := FND_API.G_TRUE;
1797: END IF;
1798:
1799: IF (BIS_UTILITIES_PUB.Value_Missing
1800: (p_Target_Level_Rec.Dimension5_Level_ID) = FND_API.G_FALSE) THEN
1801: x_target_level_rec.Dimension5_Level_ID :=
1802: p_target_level_rec.Dimension5_Level_ID;
1803: -- x_changed := FND_API.G_TRUE;

Line 1806: IF (BIS_UTILITIES_PUB.Value_Missing

1802: p_target_level_rec.Dimension5_Level_ID;
1803: -- x_changed := FND_API.G_TRUE;
1804: END IF;
1805:
1806: IF (BIS_UTILITIES_PUB.Value_Missing
1807: (p_Target_Level_Rec.Dimension6_Level_ID) = FND_API.G_FALSE) THEN
1808: x_target_level_rec.Dimension6_Level_ID :=
1809: p_target_level_rec.Dimension6_Level_ID;
1810: -- x_changed := FND_API.G_TRUE;

Line 1813: IF (BIS_UTILITIES_PUB.Value_Missing

1809: p_target_level_rec.Dimension6_Level_ID;
1810: -- x_changed := FND_API.G_TRUE;
1811: END IF;
1812:
1813: IF (BIS_UTILITIES_PUB.Value_Missing
1814: (p_Target_Level_Rec.Dimension7_Level_ID) = FND_API.G_FALSE) THEN
1815: x_target_level_rec.Dimension7_Level_ID :=
1816: p_target_level_rec.Dimension7_Level_ID;
1817: -- x_changed := FND_API.G_TRUE;

Line 1820: IF (BIS_UTILITIES_PUB.Value_Missing

1816: p_target_level_rec.Dimension7_Level_ID;
1817: -- x_changed := FND_API.G_TRUE;
1818: END IF;
1819:
1820: IF (BIS_UTILITIES_PUB.Value_Missing
1821: (p_Target_Level_Rec.Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN
1822: -- bug# 3735203
1823: IF(p_Target_Level_Rec.Workflow_Process_Short_Name <> '-1') THEN
1824: x_target_level_rec.Workflow_Process_Short_Name :=

Line 1832: IF (BIS_UTILITIES_PUB.Value_Missing

1828: END IF;
1829: -- x_changed := FND_API.G_TRUE;
1830: END IF;
1831:
1832: IF (BIS_UTILITIES_PUB.Value_Missing
1833: (p_Target_Level_Rec.Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN
1834: x_target_level_rec.Default_Notify_Resp_ID :=
1835: p_target_level_rec.Default_Notify_Resp_ID;
1836: END IF;

Line 1838: IF (BIS_UTILITIES_PUB.Value_Missing

1834: x_target_level_rec.Default_Notify_Resp_ID :=
1835: p_target_level_rec.Default_Notify_Resp_ID;
1836: END IF;
1837:
1838: IF (BIS_UTILITIES_PUB.Value_Missing
1839: (p_Target_Level_Rec.Default_Notify_Resp_short_name)=FND_API.G_FALSE) THEN
1840: x_target_level_rec.Default_Notify_Resp_short_name :=
1841: p_target_level_rec.Default_Notify_Resp_short_name;
1842: END IF;

Line 1845: IF (BIS_UTILITIES_PUB.Value_Missing

1841: p_target_level_rec.Default_Notify_Resp_short_name;
1842: END IF;
1843:
1844:
1845: IF (BIS_UTILITIES_PUB.Value_Missing
1846: (p_Target_Level_Rec.Computing_function_ID) = FND_API.G_FALSE) THEN
1847: -- bug# 3735203
1848: IF (p_Target_Level_Rec.Computing_function_ID <> -1) THEN
1849: x_target_level_rec.Computing_function_ID :=

Line 1857: IF (BIS_UTILITIES_PUB.Value_Missing

1853: END IF;
1854: -- x_changed := FND_API.G_TRUE;
1855: END IF;
1856:
1857: IF (BIS_UTILITIES_PUB.Value_Missing
1858: (p_Target_Level_Rec.Workflow_Item_Type) = FND_API.G_FALSE) THEN
1859: -- bug# 3735203
1860: IF( p_Target_Level_Rec.Workflow_Item_Type <> '-1') THEN
1861: x_target_level_rec.Workflow_Item_Type :=

Line 1869: IF (BIS_UTILITIES_PUB.Value_Missing

1865: END IF;
1866: -- x_changed := FND_API.G_TRUE;
1867: END IF;
1868:
1869: IF (BIS_UTILITIES_PUB.Value_Missing
1870: (p_Target_Level_Rec.Report_Function_ID) = FND_API.G_FALSE) THEN
1871: x_target_level_rec.Report_Function_ID :=
1872: p_target_level_rec.Report_Function_ID;
1873: -- x_changed := FND_API.G_TRUE;

Line 1876: IF (BIS_UTILITIES_PUB.Value_Missing

1872: p_target_level_rec.Report_Function_ID;
1873: -- x_changed := FND_API.G_TRUE;
1874: END IF;
1875:
1876: IF (BIS_UTILITIES_PUB.Value_Missing
1877: (p_Target_Level_Rec.Unit_Of_Measure) = FND_API.G_FALSE) THEN
1878: x_target_level_rec.Unit_Of_Measure :=
1879: p_target_level_rec.Unit_Of_Measure;
1880: -- x_changed := FND_API.G_TRUE;

Line 1883: IF (BIS_UTILITIES_PUB.Value_Missing

1879: p_target_level_rec.Unit_Of_Measure;
1880: -- x_changed := FND_API.G_TRUE;
1881: END IF;
1882:
1883: IF (BIS_UTILITIES_PUB.Value_Missing
1884: (p_Target_Level_Rec.System_Flag) = FND_API.G_FALSE) THEN
1885: x_target_level_rec.System_Flag :=
1886: p_target_level_rec.System_Flag;
1887: -- x_changed := FND_API.G_TRUE;

Line 1890: IF (BIS_UTILITIES_PUB.Value_Missing

1886: p_target_level_rec.System_Flag;
1887: -- x_changed := FND_API.G_TRUE;
1888: END IF;
1889:
1890: IF (BIS_UTILITIES_PUB.Value_Missing
1891: (p_Target_Level_Rec.Source) = FND_API.G_FALSE) THEN
1892: x_target_level_rec.Source :=
1893: p_target_level_rec.Source;
1894: -- x_changed := FND_API.G_TRUE;

Line 1909: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1905: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1906: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1907: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1908: , x_return_status OUT NOCOPY VARCHAR2
1909: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1910: )
1911: IS
1912: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1913: BEGIN

Line 1912: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1908: , x_return_status OUT NOCOPY VARCHAR2
1909: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1910: )
1911: IS
1912: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1913: BEGIN
1914:
1915: Update_Target_Level
1916: ( p_api_version => p_api_version

Line 1920: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

1916: ( p_api_version => p_api_version
1917: , p_commit => p_commit
1918: , p_validation_level => p_validation_level
1919: , p_Target_Level_Rec => p_Target_Level_Rec
1920: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
1921: , p_up_loaded => FND_API.G_FALSE
1922: , x_return_status => x_return_status
1923: , x_error_Tbl => x_error_Tbl
1924: );

Line 1952: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

1948: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
1949: , p_owner IN VARCHAR2
1950: , p_up_loaded IN VARCHAR2 := FND_API.G_FALSE
1951: , x_return_status OUT NOCOPY VARCHAR2
1952: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1953: )
1954: IS
1955: l_user_id NUMBER;
1956: l_login_id NUMBER;

Line 1962: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1958: l_Target_Level_orig BIS_Target_Level_PUB.Target_Level_Rec_Type;
1959: l_changed VARCHAR2(10) := FND_API.G_FALSE;
1960: l_target_level_id NUMBER;
1961: l_Target_Tbl BIS_TARGET_PUB.Target_Tbl_Type;
1962: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1963:
1964: --added this
1965: DUPLICATE_DIMENSION_VALUE EXCEPTION;
1966: PRAGMA EXCEPTION_INIT(DUPLICATE_DIMENSION_VALUE, -1);

Line 1998: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

1994: BIS_UTILITIES_PVT.Add_Error_Message
1995: ( p_error_msg_name => 'BIS_INVALID_TAR_LEVEL_ID'
1996: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1997: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
1998: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
1999: , p_error_table => l_error_tbl
2000: , x_error_table => x_error_tbl
2001: );
2002: RAISE FND_API.G_EXC_ERROR;

Line 2026: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

2022: BIS_UTILITIES_PVT.Add_Error_Message
2023: ( p_error_msg_name => 'BIS_NO_CHANGE_SEED_TARGET_LVL'
2024: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2025: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
2026: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2027: , p_error_table => l_error_tbl
2028: , x_error_table => x_error_tbl
2029: );
2030:

Line 2045: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

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

Line 2071: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

2067: BIS_UTILITIES_PVT.Add_Error_Message
2068: ( p_error_msg_name => 'BIS_TRG_LVL_DIMLEVELS_UNIQUE'
2069: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2070: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
2071: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2072: , p_error_table => l_error_tbl
2073: , x_error_table => x_error_tbl
2074: );
2075: RAISE FND_API.G_EXC_ERROR;

Line 2079: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

2075: RAISE FND_API.G_EXC_ERROR;
2076: end if;
2077: end if;
2078:
2079: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
2080: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
2081: ELSE
2082: l_user_id := fnd_global.user_id;
2083: END IF;

Line 2080: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

2076: end if;
2077: end if;
2078:
2079: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
2080: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
2081: ELSE
2082: l_user_id := fnd_global.user_id;
2083: END IF;
2084: l_login_id := fnd_global.LOGIN_ID;

Line 2089: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.source)

2085: --
2086: /*
2087: ----------------
2088: --Adding this for the source column
2089: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.source)
2090: = FND_API.G_TRUE)
2091: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.source)
2092: = FND_API.G_TRUE)
2093: THEN

Line 2091: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.source)

2087: ----------------
2088: --Adding this for the source column
2089: IF (BIS_UTILITIES_PUB.Value_Missing(l_Target_Level_Rec.source)
2090: = FND_API.G_TRUE)
2091: OR (BIS_UTILITIES_PUB.Value_NULL(l_Target_Level_Rec.source)
2092: = FND_API.G_TRUE)
2093: THEN
2094: l_Target_Level_Rec.source := FND_PROFILE.value('BIS_SOURCE');
2095: END IF;

Line 2153: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

2149: BIS_UTILITIES_PVT.Add_Error_Message
2150: ( p_error_msg_name => 'BIS_TAR_LEVEL_UNIQUENESS_ERROR'
2151: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2152: , p_error_proc_name => G_PKG_NAME||'.Update_Target_Level'
2153: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2154: , p_error_table => l_error_tbl
2155: , x_error_table => x_error_tbl
2156: );
2157: when FND_API.G_EXC_ERROR then

Line 2185: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2181: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2182: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2183: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2184: , x_return_status OUT NOCOPY VARCHAR2
2185: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2186: )
2187: IS
2188: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2189: BEGIN

Line 2188: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2184: , x_return_status OUT NOCOPY VARCHAR2
2185: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2186: )
2187: IS
2188: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2189: BEGIN
2190:
2191: Translate_Target_Level
2192: ( p_api_version => p_api_version

Line 2196: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER

2192: ( p_api_version => p_api_version
2193: , p_commit => p_commit
2194: , p_validation_level => p_validation_level
2195: , p_Target_Level_Rec => p_Target_Level_Rec
2196: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
2197: , x_return_status => x_return_status
2198: , x_error_Tbl => x_error_Tbl
2199: );
2200:

Line 2225: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2221: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2222: , p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
2223: , p_owner IN VARCHAR2
2224: , x_return_status OUT NOCOPY VARCHAR2
2225: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2226: )
2227: IS
2228: l_user_id NUMBER;
2229: l_login_id NUMBER;

Line 2234: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2230: l_count NUMBER := 0;
2231: l_changed VARCHAR2(10) := FND_API.G_FALSE;
2232: l_Target_Level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2233: l_Target_Level_orig BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
2234: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2235:
2236: BEGIN
2237:
2238: l_Target_Level_rec := p_Target_Level_Rec;

Line 2272: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

2268: BIS_UTILITIES_PVT.Add_Error_Message
2269: ( p_error_msg_name => 'BIS_TARGET_LEVEL_SHORT_NAME_UNIQUE'
2270: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2271: , p_error_proc_name => G_PKG_NAME||'.Translate_Target_Level'
2272: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2273: , p_error_table => l_error_tbl
2274: , x_error_table => x_error_tbl
2275: );
2276: RAISE FND_API.G_EXC_ERROR;

Line 2290: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN

2286: */
2287:
2288: l_target_level_rec.target_level_id := l_target_level_Orig.target_level_id;
2289: --
2290: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
2291: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
2292: ELSE
2293: l_user_id := fnd_global.user_id;
2294: END IF;

Line 2291: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;

2287:
2288: l_target_level_rec.target_level_id := l_target_level_Orig.target_level_id;
2289: --
2290: IF p_owner = BIS_UTILITIES_PUB.G_SEED_OWNER THEN
2291: l_user_id := BIS_UTILITIES_PUB.G_SEED_USER_ID;
2292: ELSE
2293: l_user_id := fnd_global.user_id;
2294: END IF;
2295:

Line 2348: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2344: , p_force_delete IN NUMBER := 0--gbhaloti #3148615
2345: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2346: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
2347: , x_return_status OUT NOCOPY VARCHAR2
2348: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2349: )
2350: IS
2351: l_Target_Tbl BIS_TARGET_PUB.Target_Tbl_Type;
2352: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 2352: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2348: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2349: )
2350: IS
2351: l_Target_Tbl BIS_TARGET_PUB.Target_Tbl_Type;
2352: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2353: BEGIN
2354:
2355: x_return_status := FND_API.G_RET_STS_SUCCESS;
2356: BIS_TARGET_PVT.Retrieve_Targets( p_api_version

Line 2377: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

2373: BIS_UTILITIES_PVT.Add_Error_Message
2374: ( p_error_msg_name => 'BIS_NO_DELETE_TARGET_LEVEL'
2375: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2376: , p_error_proc_name => G_PKG_NAME||'.Delete_Target_Level'
2377: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
2378: , p_error_table => l_error_tbl
2379: , x_error_table => x_error_tbl
2380: );
2381:

Line 2436: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2432: ( p_api_version IN NUMBER
2433: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2434: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
2435: , x_return_status OUT NOCOPY VARCHAR2
2436: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2437: )
2438: IS
2439: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2440: l_error VARCHAR2(10) := FND_API.G_FALSE;

Line 2439: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2435: , x_return_status OUT NOCOPY VARCHAR2
2436: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2437: )
2438: IS
2439: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2440: l_error VARCHAR2(10) := FND_API.G_FALSE;
2441: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2442: BEGIN
2443:

Line 2441: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;

2437: )
2438: IS
2439: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2440: l_error VARCHAR2(10) := FND_API.G_FALSE;
2441: l_error_Tbl_p BIS_UTILITIES_PUB.Error_Tbl_Type;
2442: BEGIN
2443:
2444: x_return_status := FND_API.G_RET_STS_SUCCESS;
2445:

Line 2637: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Workflow_Process_Short_Name) =FND_API.G_TRUE ) THEN

2633: END;
2634:
2635: BEGIN
2636: -- bug# 3735203
2637: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Workflow_Process_Short_Name) =FND_API.G_TRUE ) THEN
2638: IF(p_Target_Level_Rec.Workflow_Process_Short_Name <> '-1') THEN
2639: BIS_TARGET_LEVEL_VALIDATE_PVT.Validate_WF_Process_Short_Name
2640: ( p_api_version => p_api_version
2641: , p_validation_level => p_validation_level

Line 2686: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Computing_function_ID) =FND_API.G_TRUE ) THEN

2682: END;
2683:
2684: BEGIN
2685: -- bug# 3735203
2686: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Computing_function_ID) =FND_API.G_TRUE ) THEN
2687: IF(p_Target_Level_Rec.Computing_function_ID <> -1) THEN
2688: BIS_TARGET_LEVEL_VALIDATE_PVT.Validate_Df_computed_target_Id
2689: ( p_api_version => p_api_version
2690: , p_validation_level => p_validation_level

Line 2746: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2742: , p_Dim_level_short_name in VARCHAR2
2743: , p_Dime_Level_NAME in VARCHAR2
2744: , x_dim_level_id OUT NOCOPY NUMBER
2745: , x_return_status OUT NOCOPY VARCHAR2
2746: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2747: )
2748: IS
2749: l_convert VARCHAR2(10);
2750:

Line 2786: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

2782: ( p_api_version IN NUMBER
2783: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
2784: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
2785: , x_return_status OUT NOCOPY VARCHAR2
2786: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2787: )
2788: IS
2789: l_convert VARCHAR2(10);
2790: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 2790: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

2786: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2787: )
2788: IS
2789: l_convert VARCHAR2(10);
2790: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2791: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
2792: BEGIN
2793: x_return_status := FND_API.G_RET_STS_SUCCESS;
2794: x_Target_Level_Rec := p_Target_Level_Rec;

Line 2959: -- if (BIS_UTILITIES_PUB.Value_Missing

2955: );
2956:
2957: if (l_convert = FND_API.G_TRUE) then
2958:
2959: -- if (BIS_UTILITIES_PUB.Value_Missing
2960: -- (x_Target_Level_Rec.Computing_Function_ID) = FND_API.G_TRUE) then
2961: BEGIN
2962: BIS_COMPUTED_TARGET_PVT.Value_ID_Conversion
2963: ( p_api_version => p_api_version

Line 3013: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

3009: , p_Target_Level_Short_Name IN VARCHAR2
3010: , p_Target_Level_Name IN VARCHAR2
3011: , x_Target_Level_ID OUT NOCOPY NUMBER
3012: , x_return_status OUT NOCOPY VARCHAR2
3013: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3014: )
3015: IS
3016: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3017: BEGIN

Line 3016: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3012: , x_return_status OUT NOCOPY VARCHAR2
3013: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3014: )
3015: IS
3016: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3017: BEGIN
3018:
3019: x_return_status := FND_API.G_RET_STS_SUCCESS;
3020:

Line 3021: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Short_Name)

3017: BEGIN
3018:
3019: x_return_status := FND_API.G_RET_STS_SUCCESS;
3020:
3021: if (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Short_Name)
3022: = FND_API.G_TRUE) then
3023: SELECT Target_Level_id into x_Target_Level_ID
3024: FROM bisbv_Target_Levels
3025: WHERE target_level_short_name = p_Target_Level_Short_Name;

Line 3026: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Name)

3022: = FND_API.G_TRUE) then
3023: SELECT Target_Level_id into x_Target_Level_ID
3024: FROM bisbv_Target_Levels
3025: WHERE target_level_short_name = p_Target_Level_Short_Name;
3026: elsif (BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Name)
3027: = FND_API.G_TRUE) then
3028: SELECT Target_Level_id into x_Target_Level_ID
3029: FROM bisbv_Target_Levels
3030: WHERE target_level_name = p_Target_Level_Name;

Line 3039: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

3035: BIS_UTILITIES_PVT.Add_Error_Message
3036: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
3037: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3038: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
3039: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3040: , p_error_table => l_error_tbl
3041: , x_error_table => x_error_tbl
3042: );
3043:

Line 3079: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

3075: , p_user_id IN NUMBER
3076: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
3077: , x_Target_Level_Tbl OUT NOCOPY BIS_Target_LEVEL_PUB.Target_Level_Tbl_Type
3078: , x_return_status OUT NOCOPY VARCHAR2
3079: , x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3080: )
3081: IS
3082: l_flag NUMBER :=0;
3083: -- juwang bug#2225110 needs to check if end date and start date

Line 3099: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3095: order by UPPER(target_level_name);
3096:
3097: l_Target_Level_rec BIS_Target_LEVEL_PUB.Target_Level_Rec_Type;
3098: l_Target_Level_rec_p BIS_Target_LEVEL_PUB.Target_Level_Rec_Type;
3099: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3100:
3101: BEGIN
3102:
3103: for cr in ind_res loop

Line 3129: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

3125: BIS_UTILITIES_PVT.Add_Error_Message
3126: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3127: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3128: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Target_Levels'
3129: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3130: , p_error_table => l_error_tbl
3131: , x_error_table => x_error_tbl
3132: );
3133: RAISE FND_API.G_EXC_ERROR;

Line 3169: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

3165: ( p_api_version IN NUMBER
3166: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3167: , x_last_update_date OUT NOCOPY DATE
3168: , x_return_status OUT NOCOPY VARCHAR2
3169: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3170: )
3171: IS
3172: l_date_char VARCHAR2(32000);
3173: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 3173: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3169: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3170: )
3171: IS
3172: l_date_char VARCHAR2(32000);
3173: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3174:
3175: BEGIN
3176: x_return_status := FND_API.G_RET_STS_SUCCESS;
3177: --

Line 3178: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Target_Level_ID)

3174:
3175: BEGIN
3176: x_return_status := FND_API.G_RET_STS_SUCCESS;
3177: --
3178: IF( BIS_UTILITIES_PUB.Value_Not_Missing(p_Target_Level_Rec.Target_Level_ID)
3179: = FND_API.G_TRUE
3180: ) THEN
3181: SELECT NVL(LAST_UPDATE_DATE, CREATION_DATE)
3182: INTO x_last_update_date

Line 3197: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

3193: BIS_UTILITIES_PVT.Add_Error_Message
3194: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3195: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3196: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
3197: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3198: , p_error_table => l_error_tbl
3199: , x_error_table => x_error_tbl
3200: );
3201: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3230: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

3226: ( p_api_version IN NUMBER
3227: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3228: , p_timestamp IN VARCHAR := NULL
3229: , x_return_status OUT NOCOPY VARCHAR2
3230: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3231: )
3232: IS
3233: --
3234: l_form_date DATE;

Line 3237: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3233: --
3234: l_form_date DATE;
3235: l_last_update_date DATE;
3236: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
3237: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3238: --
3239: BEGIN
3240: x_return_status := FND_API.G_RET_STS_SUCCESS;
3241: --

Line 3294: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

3290: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3291: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
3292: , x_dimension_level_number OUT NOCOPY NUMBER
3293: , x_return_status OUT NOCOPY VARCHAR2
3294: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3295: )
3296: IS
3297:
3298: l_time_dimension_id NUMBER;

Line 3302: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3298: l_time_dimension_id NUMBER;
3299: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3300: l_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;
3301: l_found NUMBER := 0;
3302: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3303:
3304: CURSOR cr_tl_id_dim_level(p_target_level_id NUMBER) IS
3305: select
3306: dimension1_level_id,

Line 3353: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

3349: BIS_UTILITIES_PVT.Add_Error_Message
3350: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3351: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3352: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Time_Level_Value'
3353: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3354: , p_error_table => l_error_tbl
3355: , x_error_table => x_error_tbl
3356: );
3357: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3389: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

3385: BIS_UTILITIES_PVT.Add_Error_Message
3386: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3387: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3388: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Time_Level_Value'
3389: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3390: , p_error_table => l_error_tbl
3391: , x_error_table => x_error_tbl
3392: );
3393: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3428: -- BIS_UTILITIES_PUB.put_line(p_text =>'Target level time dim level is: '||x_dimension_level_number);

3424: IF l_Dimension_Level_Rec.DIMENSION_ID = l_time_dimension_id THEN
3425: x_Dimension_Level_Rec := l_Dimension_Level_Rec;
3426: x_dimension_level_number := i;
3427: l_found := 1;
3428: -- BIS_UTILITIES_PUB.put_line(p_text =>'Target level time dim level is: '||x_dimension_level_number);
3429: EXIT;
3430: END IF;
3431: END LOOP;
3432:

Line 3479: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3475:
3476: l_Target_Level_Rec BIS_Target_Level_PUB.Target_Level_Rec_Type;
3477: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3478: l_dimension_level_number NUMBER;
3479: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3480: l_return_status VARCHAR2(32000);
3481:
3482: BEGIN
3483:

Line 3514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

3510: , p_Target_Level_Rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3511: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
3512: , x_dimension_level_number OUT NOCOPY NUMBER
3513: , x_return_status OUT NOCOPY VARCHAR2
3514: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3515: )
3516: IS
3517:
3518: l_org_dimension_id NUMBER;

Line 3523: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3519: l_dimension_short_name VARCHAR2(80);
3520: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
3521: l_dimension_level_tbl BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type;
3522: l_err_track NUMBER := 0;
3523: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3524:
3525:
3526: CURSOR cr_ol_id_dim_level(p_target_level_id NUMBER) IS
3527: select

Line 3552: -- BIS_UTILITIES_PUB.put_line(p_text =>' test inside bisvtalb tgt lvl id = ' || p_Target_Level_Rec.target_level_id );

3548: where target_level_short_name = p_target_level_short_name;
3549:
3550: BEGIN
3551:
3552: -- BIS_UTILITIES_PUB.put_line(p_text =>' test inside bisvtalb tgt lvl id = ' || p_Target_Level_Rec.target_level_id );
3553:
3554: l_err_track := 100;
3555:
3556: IF (BIS_UTILITIES_PVT.Value_Not_Missing(p_Target_Level_Rec.target_level_id)

Line 3582: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

3578: BIS_UTILITIES_PVT.Add_Error_Message
3579: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3580: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3581: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Org_Level'
3582: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3583: , p_error_table => l_error_tbl
3584: , x_error_table => x_error_tbl
3585: );
3586: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3601: -- BIS_UTILITIES_PUB.put_line(p_text => ' dim short name = ' || l_dimension_short_name ) ;

3597: l_err_track := 400;
3598:
3599: l_dimension_short_name := BIS_UTILITIES_PVT.Get_Org_Dimension_Name_TL(p_Target_Level_Rec.target_level_id,NULL);
3600:
3601: -- BIS_UTILITIES_PUB.put_line(p_text => ' dim short name = ' || l_dimension_short_name ) ;
3602:
3603: l_err_track := 500;
3604:
3605: Select dimension_id

Line 3637: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

3633: BIS_UTILITIES_PVT.Add_Error_Message
3634: ( p_error_msg_name => 'BIS_INVALID_TARGET_LEVEL_VALUE'
3635: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3636: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Org_Level'
3637: , p_error_type => BIS_UTILITIES_PUB.G_ERROR
3638: , p_error_table => l_error_tbl
3639: , x_error_table => x_error_tbl
3640: );
3641:

Line 3663: -- BIS_UTILITIES_PUB.put_line(p_text =>' test inside bisvtalb ' );

3659:
3660: END IF;
3661:
3662:
3663: -- BIS_UTILITIES_PUB.put_line(p_text =>' test inside bisvtalb ' );
3664: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_org_dimension_id inside bisvtalb is = ' || l_org_dimension_id ) ;
3665:
3666: x_dimension_level_number := 0;
3667:

Line 3664: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_org_dimension_id inside bisvtalb is = ' || l_org_dimension_id ) ;

3660: END IF;
3661:
3662:
3663: -- BIS_UTILITIES_PUB.put_line(p_text =>' test inside bisvtalb ' );
3664: -- BIS_UTILITIES_PUB.put_line(p_text => ' l_org_dimension_id inside bisvtalb is = ' || l_org_dimension_id ) ;
3665:
3666: x_dimension_level_number := 0;
3667:
3668: FOR i IN 1..l_dimension_level_tbl.COUNT

Line 3682: BIS_UTILITIES_PUB.put_line(p_text =>'Target level org dim level is: '||x_dimension_level_number);

3678:
3679: IF l_Dimension_Level_Rec.DIMENSION_ID = l_org_dimension_id THEN
3680: x_Dimension_Level_Rec := l_Dimension_Level_Rec;
3681: x_dimension_level_number := i;
3682: BIS_UTILITIES_PUB.put_line(p_text =>'Target level org dim level is: '||x_dimension_level_number);
3683: EXIT;
3684: END IF;
3685:
3686: END LOOP;

Line 3689: BIS_UTILITIES_PUB.put_line(p_text =>' bisvtalb: Org level could not be found for this target level ' ) ;

3685:
3686: END LOOP;
3687:
3688: if (x_dimension_level_number = 0) then
3689: BIS_UTILITIES_PUB.put_line(p_text =>' bisvtalb: Org level could not be found for this target level ' ) ;
3690: end if;
3691:
3692:
3693: EXCEPTION

Line 3701: BIS_UTILITIES_PUB.put_line(p_text =>'Error while getting org level: bisvtalb ' || l_err_track || SQLERRM);

3697: x_return_status := FND_API.G_RET_STS_ERROR;
3698: IF cr_ol_sn_dim_level%ISOPEN THEN CLOSE cr_ol_sn_dim_level; END IF;
3699: IF cr_ol_id_dim_level%ISOPEN THEN CLOSE cr_ol_id_dim_level; END IF;
3700: WHEN OTHERS THEN
3701: BIS_UTILITIES_PUB.put_line(p_text =>'Error while getting org level: bisvtalb ' || l_err_track || SQLERRM);
3702: IF cr_ol_sn_dim_level%ISOPEN THEN CLOSE cr_ol_sn_dim_level; END IF;
3703: IF cr_ol_id_dim_level%ISOPEN THEN CLOSE cr_ol_id_dim_level; END IF;
3704: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
3705: l_error_Tbl := x_error_Tbl;

Line 3727: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

3723: p_api_version IN NUMBER
3724: , p_target_level_rec IN BIS_Target_Level_PUB.Target_Level_Rec_Type
3725: , x_Target_Level_Rec OUT NOCOPY BIS_Target_Level_PUB.Target_Level_Rec_Type
3726: , x_return_status OUT NOCOPY VARCHAR2
3727: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
3728: )
3729: IS
3730: l_measure_rec BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3731: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;

Line 3735: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

3731: l_measure_rec_p BIS_MEASURE_PUB.MEASURE_REC_TYPE;
3732: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3733: l_dim_level_rec_p BIS_DIMENSION_LEVEL_PUB.DIMENSION_LEVEL_REC_TYPE;
3734: l_target_level_id NUMBER;
3735: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3736:
3737: l_dim1_id NUMBER;
3738: l_dim2_id NUMBER;
3739: l_dim3_id NUMBER;

Line 3777: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_short_name) = FND_API.G_TRUE) THEN

3773: BEGIN
3774:
3775:
3776: IF (p_target_level_rec.measure_short_name IS NOT NULL
3777: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_short_name) = FND_API.G_TRUE) THEN
3778: l_measure_rec.measure_short_name := p_target_level_rec.measure_short_name;
3779: END IF;
3780: IF (p_target_level_rec.measure_id IS NOT NULL
3781: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_id) = FND_API.G_TRUE) THEN

Line 3781: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_id) = FND_API.G_TRUE) THEN

3777: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_short_name) = FND_API.G_TRUE) THEN
3778: l_measure_rec.measure_short_name := p_target_level_rec.measure_short_name;
3779: END IF;
3780: IF (p_target_level_rec.measure_id IS NOT NULL
3781: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.measure_id) = FND_API.G_TRUE) THEN
3782: l_measure_rec.measure_id := p_target_level_rec.measure_id;
3783: END IF;
3784: --Populate the measure record with all the relevant values
3785: l_measure_rec_p := l_measure_rec;

Line 3796: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension1_level_short_name) = FND_API.G_TRUE) THEN

3792: );
3793:
3794:
3795: IF (p_target_level_rec.dimension1_level_short_name IS NOT NULL
3796: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension1_level_short_name) = FND_API.G_TRUE) THEN
3797: OPEN c_dim_lvl(p_target_level_rec.dimension1_level_short_name);
3798: FETCH c_dim_lvl INTO x_target_level_rec.dimension1_level_id,x_target_level_rec.dimension1_level_name;
3799: CLOSE c_dim_lvl;
3800: END IF;

Line 3802: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension2_level_short_name)= FND_API.G_TRUE) THEN

3798: FETCH c_dim_lvl INTO x_target_level_rec.dimension1_level_id,x_target_level_rec.dimension1_level_name;
3799: CLOSE c_dim_lvl;
3800: END IF;
3801: IF (p_target_level_rec.dimension2_level_short_name IS NOT NULL
3802: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension2_level_short_name)= FND_API.G_TRUE) THEN
3803: OPEN c_dim_lvl(p_target_level_rec.dimension2_level_short_name);
3804: FETCH c_dim_lvl INTO x_target_level_rec.dimension2_level_id,x_target_level_rec.dimension2_level_name;
3805: CLOSE c_dim_lvl;
3806: END IF;

Line 3808: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension3_level_short_name)= FND_API.G_TRUE) THEN

3804: FETCH c_dim_lvl INTO x_target_level_rec.dimension2_level_id,x_target_level_rec.dimension2_level_name;
3805: CLOSE c_dim_lvl;
3806: END IF;
3807: IF (p_target_level_rec.dimension3_level_short_name IS NOT NULL
3808: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension3_level_short_name)= FND_API.G_TRUE) THEN
3809: OPEN c_dim_lvl(p_target_level_rec.dimension3_level_short_name);
3810: FETCH c_dim_lvl INTO x_target_level_rec.dimension3_level_id,x_target_level_rec.dimension3_level_name;
3811: CLOSE c_dim_lvl;
3812: END IF;

Line 3814: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension4_level_short_name)= FND_API.G_TRUE) THEN

3810: FETCH c_dim_lvl INTO x_target_level_rec.dimension3_level_id,x_target_level_rec.dimension3_level_name;
3811: CLOSE c_dim_lvl;
3812: END IF;
3813: IF (p_target_level_rec.dimension4_level_short_name IS NOT NULL
3814: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension4_level_short_name)= FND_API.G_TRUE) THEN
3815: OPEN c_dim_lvl(p_target_level_rec.dimension4_level_short_name);
3816: FETCH c_dim_lvl INTO x_target_level_rec.dimension4_level_id,x_target_level_rec.dimension4_level_name;
3817: CLOSE c_dim_lvl;
3818: END IF;

Line 3820: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension5_level_short_name)= FND_API.G_TRUE) THEN

3816: FETCH c_dim_lvl INTO x_target_level_rec.dimension4_level_id,x_target_level_rec.dimension4_level_name;
3817: CLOSE c_dim_lvl;
3818: END IF;
3819: IF (p_target_level_rec.dimension5_level_short_name IS NOT NULL
3820: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension5_level_short_name)= FND_API.G_TRUE) THEN
3821: OPEN c_dim_lvl(p_target_level_rec.dimension5_level_short_name);
3822: FETCH c_dim_lvl INTO x_target_level_rec.dimension5_level_id,x_target_level_rec.dimension5_level_name;
3823: CLOSE c_dim_lvl;
3824: END IF;

Line 3826: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension6_level_short_name)= FND_API.G_TRUE) THEN

3822: FETCH c_dim_lvl INTO x_target_level_rec.dimension5_level_id,x_target_level_rec.dimension5_level_name;
3823: CLOSE c_dim_lvl;
3824: END IF;
3825: IF (p_target_level_rec.dimension6_level_short_name IS NOT NULL
3826: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension6_level_short_name)= FND_API.G_TRUE) THEN
3827: OPEN c_dim_lvl(p_target_level_rec.dimension6_level_short_name);
3828: FETCH c_dim_lvl INTO x_target_level_rec.dimension6_level_id,x_target_level_rec.dimension6_level_name;
3829: CLOSE c_dim_lvl;
3830: END IF;

Line 3832: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension7_level_short_name)= FND_API.G_TRUE) THEN

3828: FETCH c_dim_lvl INTO x_target_level_rec.dimension6_level_id,x_target_level_rec.dimension6_level_name;
3829: CLOSE c_dim_lvl;
3830: END IF;
3831: IF (p_target_level_rec.dimension7_level_short_name IS NOT NULL
3832: AND BIS_UTILITIES_PUB.Value_Not_Missing(p_target_level_rec.dimension7_level_short_name)= FND_API.G_TRUE) THEN
3833: OPEN c_dim_lvl(p_target_level_rec.dimension7_level_short_name);
3834: FETCH c_dim_lvl INTO x_target_level_rec.dimension7_level_id,x_target_level_rec.dimension7_level_name;
3835: CLOSE c_dim_lvl;
3836: END IF;

Line 3843: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension1_level_id)= FND_API.G_TRUE) THEN

3839:
3840: --Get the dimension ids for all the dimension level ids. This will be later used to
3841: --sequence the dimension levels
3842: IF (x_target_level_rec.dimension1_level_id IS NOT NULL
3843: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension1_level_id)= FND_API.G_TRUE) THEN
3844: SetNULL(l_dim_level_rec,l_dim_level_rec);
3845: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension1_level_id;
3846: l_dim_level_rec_p := l_dim_level_rec;
3847: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3857: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension2_level_id)= FND_API.G_TRUE) THEN

3853: l_dim1_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3854: END IF;
3855:
3856: IF (x_target_level_rec.dimension2_level_id IS NOT NULL
3857: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension2_level_id)= FND_API.G_TRUE) THEN
3858: SetNULL(l_dim_level_rec,l_dim_level_rec);
3859: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension2_level_id;
3860: l_dim_level_rec_p := l_dim_level_rec;
3861: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3871: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension3_level_id)= FND_API.G_TRUE) THEN

3867: l_dim2_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3868: END IF;
3869:
3870: IF (x_target_level_rec.dimension3_level_id IS NOT NULL
3871: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension3_level_id)= FND_API.G_TRUE) THEN
3872: SetNULL(l_dim_level_rec,l_dim_level_rec);
3873: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension3_level_id;
3874: l_dim_level_rec_p := l_dim_level_rec;
3875: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3885: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension4_level_id)= FND_API.G_TRUE) THEN

3881: l_dim3_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3882: END IF;
3883:
3884: IF (x_target_level_rec.dimension4_level_id IS NOT NULL
3885: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension4_level_id)= FND_API.G_TRUE) THEN
3886: SetNULL(l_dim_level_rec,l_dim_level_rec);
3887: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension4_level_id;
3888: l_dim_level_rec_p := l_dim_level_rec;
3889: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3899: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension5_level_id)= FND_API.G_TRUE) THEN

3895: l_dim4_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3896: END IF;
3897:
3898: IF (x_target_level_rec.dimension5_level_id IS NOT NULL
3899: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension5_level_id)= FND_API.G_TRUE) THEN
3900: SetNULL(l_dim_level_rec,l_dim_level_rec);
3901: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension5_level_id;
3902: l_dim_level_rec_p := l_dim_level_rec;
3903: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3913: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension6_level_id)= FND_API.G_TRUE) THEN

3909: l_dim5_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3910: END IF;
3911:
3912: IF (x_target_level_rec.dimension6_level_id IS NOT NULL
3913: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension6_level_id)= FND_API.G_TRUE) THEN
3914: SetNULL(l_dim_level_rec,l_dim_level_rec);
3915: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension6_level_id;
3916: l_dim_level_rec_p := l_dim_level_rec;
3917: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 3927: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension7_level_id)= FND_API.G_TRUE) THEN

3923: l_dim6_id := BIS_UTILITIES_PVT.checkmissnum(l_dim_level_rec.dimension_id);
3924: END IF;
3925:
3926: IF (x_target_level_rec.dimension7_level_id IS NOT NULL
3927: AND BIS_UTILITIES_PUB.Value_Not_Missing(x_target_level_rec.dimension7_level_id)= FND_API.G_TRUE) THEN
3928: SetNULL(l_dim_level_rec,l_dim_level_rec);
3929: l_dim_level_rec.dimension_level_id := x_target_level_rec.dimension7_level_id;
3930: l_dim_level_rec_p := l_dim_level_rec;
3931: BIS_DIMENSION_LEVEL_PUB.Retrieve_Dimension_Level( p_api_version => p_api_version

Line 4195: x_Target_Level_Rec.Dimension1_Level_ID := NVL(l_DIM1_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

4191: -- l_dim7_level_value_id := p_dim7_level_value_id;
4192: END IF;
4193:
4194: x_Target_Level_Rec.Measure_ID := l_Measure_Rec.Measure_ID;
4195: x_Target_Level_Rec.Dimension1_Level_ID := NVL(l_DIM1_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4196: x_Target_Level_Rec.Dimension2_Level_ID := NVL(l_DIM2_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4197: x_Target_Level_Rec.Dimension3_Level_ID := NVL(l_DIM3_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4198: x_Target_Level_Rec.Dimension4_Level_ID := NVL(l_DIM4_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4199: x_Target_Level_Rec.Dimension5_Level_ID := NVL(l_DIM5_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

Line 4196: x_Target_Level_Rec.Dimension2_Level_ID := NVL(l_DIM2_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

4192: END IF;
4193:
4194: x_Target_Level_Rec.Measure_ID := l_Measure_Rec.Measure_ID;
4195: x_Target_Level_Rec.Dimension1_Level_ID := NVL(l_DIM1_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4196: x_Target_Level_Rec.Dimension2_Level_ID := NVL(l_DIM2_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4197: x_Target_Level_Rec.Dimension3_Level_ID := NVL(l_DIM3_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4198: x_Target_Level_Rec.Dimension4_Level_ID := NVL(l_DIM4_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4199: x_Target_Level_Rec.Dimension5_Level_ID := NVL(l_DIM5_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4200: x_Target_Level_Rec.Dimension6_Level_ID := NVL(l_DIM6_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

Line 4197: x_Target_Level_Rec.Dimension3_Level_ID := NVL(l_DIM3_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

4193:
4194: x_Target_Level_Rec.Measure_ID := l_Measure_Rec.Measure_ID;
4195: x_Target_Level_Rec.Dimension1_Level_ID := NVL(l_DIM1_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4196: x_Target_Level_Rec.Dimension2_Level_ID := NVL(l_DIM2_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4197: x_Target_Level_Rec.Dimension3_Level_ID := NVL(l_DIM3_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4198: x_Target_Level_Rec.Dimension4_Level_ID := NVL(l_DIM4_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4199: x_Target_Level_Rec.Dimension5_Level_ID := NVL(l_DIM5_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4200: x_Target_Level_Rec.Dimension6_Level_ID := NVL(l_DIM6_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4201: x_Target_Level_Rec.Dimension7_Level_ID := NVL(l_DIM7_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

Line 4198: x_Target_Level_Rec.Dimension4_Level_ID := NVL(l_DIM4_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

4194: x_Target_Level_Rec.Measure_ID := l_Measure_Rec.Measure_ID;
4195: x_Target_Level_Rec.Dimension1_Level_ID := NVL(l_DIM1_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4196: x_Target_Level_Rec.Dimension2_Level_ID := NVL(l_DIM2_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4197: x_Target_Level_Rec.Dimension3_Level_ID := NVL(l_DIM3_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4198: x_Target_Level_Rec.Dimension4_Level_ID := NVL(l_DIM4_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4199: x_Target_Level_Rec.Dimension5_Level_ID := NVL(l_DIM5_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4200: x_Target_Level_Rec.Dimension6_Level_ID := NVL(l_DIM6_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4201: x_Target_Level_Rec.Dimension7_Level_ID := NVL(l_DIM7_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4202: l_target_level_id := Get_Level_Id_From_Dimlevels(x_target_level_rec) ;

Line 4199: x_Target_Level_Rec.Dimension5_Level_ID := NVL(l_DIM5_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

4195: x_Target_Level_Rec.Dimension1_Level_ID := NVL(l_DIM1_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4196: x_Target_Level_Rec.Dimension2_Level_ID := NVL(l_DIM2_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4197: x_Target_Level_Rec.Dimension3_Level_ID := NVL(l_DIM3_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4198: x_Target_Level_Rec.Dimension4_Level_ID := NVL(l_DIM4_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4199: x_Target_Level_Rec.Dimension5_Level_ID := NVL(l_DIM5_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4200: x_Target_Level_Rec.Dimension6_Level_ID := NVL(l_DIM6_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4201: x_Target_Level_Rec.Dimension7_Level_ID := NVL(l_DIM7_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4202: l_target_level_id := Get_Level_Id_From_Dimlevels(x_target_level_rec) ;
4203: x_Target_Level_Rec.Target_Level_Id := l_target_level_id;

Line 4200: x_Target_Level_Rec.Dimension6_Level_ID := NVL(l_DIM6_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

4196: x_Target_Level_Rec.Dimension2_Level_ID := NVL(l_DIM2_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4197: x_Target_Level_Rec.Dimension3_Level_ID := NVL(l_DIM3_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4198: x_Target_Level_Rec.Dimension4_Level_ID := NVL(l_DIM4_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4199: x_Target_Level_Rec.Dimension5_Level_ID := NVL(l_DIM5_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4200: x_Target_Level_Rec.Dimension6_Level_ID := NVL(l_DIM6_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4201: x_Target_Level_Rec.Dimension7_Level_ID := NVL(l_DIM7_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4202: l_target_level_id := Get_Level_Id_From_Dimlevels(x_target_level_rec) ;
4203: x_Target_Level_Rec.Target_Level_Id := l_target_level_id;
4204: x_Target_Level_Rec.Dimension1_Level_Short_Name := NVL(l_DIM1_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4201: x_Target_Level_Rec.Dimension7_Level_ID := NVL(l_DIM7_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);

4197: x_Target_Level_Rec.Dimension3_Level_ID := NVL(l_DIM3_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4198: x_Target_Level_Rec.Dimension4_Level_ID := NVL(l_DIM4_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4199: x_Target_Level_Rec.Dimension5_Level_ID := NVL(l_DIM5_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4200: x_Target_Level_Rec.Dimension6_Level_ID := NVL(l_DIM6_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4201: x_Target_Level_Rec.Dimension7_Level_ID := NVL(l_DIM7_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4202: l_target_level_id := Get_Level_Id_From_Dimlevels(x_target_level_rec) ;
4203: x_Target_Level_Rec.Target_Level_Id := l_target_level_id;
4204: x_Target_Level_Rec.Dimension1_Level_Short_Name := NVL(l_DIM1_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4205: x_Target_Level_Rec.Dimension2_Level_Short_Name := NVL(l_DIM2_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4204: x_Target_Level_Rec.Dimension1_Level_Short_Name := NVL(l_DIM1_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4200: x_Target_Level_Rec.Dimension6_Level_ID := NVL(l_DIM6_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4201: x_Target_Level_Rec.Dimension7_Level_ID := NVL(l_DIM7_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4202: l_target_level_id := Get_Level_Id_From_Dimlevels(x_target_level_rec) ;
4203: x_Target_Level_Rec.Target_Level_Id := l_target_level_id;
4204: x_Target_Level_Rec.Dimension1_Level_Short_Name := NVL(l_DIM1_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4205: x_Target_Level_Rec.Dimension2_Level_Short_Name := NVL(l_DIM2_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4206: x_Target_Level_Rec.Dimension3_Level_Short_Name := NVL(l_DIM3_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4207: x_Target_Level_Rec.Dimension4_Level_Short_Name := NVL(l_DIM4_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4205: x_Target_Level_Rec.Dimension2_Level_Short_Name := NVL(l_DIM2_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4201: x_Target_Level_Rec.Dimension7_Level_ID := NVL(l_DIM7_LEVEL_ID,BIS_UTILITIES_PUB.G_NULL_NUM);
4202: l_target_level_id := Get_Level_Id_From_Dimlevels(x_target_level_rec) ;
4203: x_Target_Level_Rec.Target_Level_Id := l_target_level_id;
4204: x_Target_Level_Rec.Dimension1_Level_Short_Name := NVL(l_DIM1_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4205: x_Target_Level_Rec.Dimension2_Level_Short_Name := NVL(l_DIM2_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4206: x_Target_Level_Rec.Dimension3_Level_Short_Name := NVL(l_DIM3_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4207: x_Target_Level_Rec.Dimension4_Level_Short_Name := NVL(l_DIM4_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4206: x_Target_Level_Rec.Dimension3_Level_Short_Name := NVL(l_DIM3_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4202: l_target_level_id := Get_Level_Id_From_Dimlevels(x_target_level_rec) ;
4203: x_Target_Level_Rec.Target_Level_Id := l_target_level_id;
4204: x_Target_Level_Rec.Dimension1_Level_Short_Name := NVL(l_DIM1_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4205: x_Target_Level_Rec.Dimension2_Level_Short_Name := NVL(l_DIM2_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4206: x_Target_Level_Rec.Dimension3_Level_Short_Name := NVL(l_DIM3_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4207: x_Target_Level_Rec.Dimension4_Level_Short_Name := NVL(l_DIM4_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4207: x_Target_Level_Rec.Dimension4_Level_Short_Name := NVL(l_DIM4_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4203: x_Target_Level_Rec.Target_Level_Id := l_target_level_id;
4204: x_Target_Level_Rec.Dimension1_Level_Short_Name := NVL(l_DIM1_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4205: x_Target_Level_Rec.Dimension2_Level_Short_Name := NVL(l_DIM2_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4206: x_Target_Level_Rec.Dimension3_Level_Short_Name := NVL(l_DIM3_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4207: x_Target_Level_Rec.Dimension4_Level_Short_Name := NVL(l_DIM4_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4204: x_Target_Level_Rec.Dimension1_Level_Short_Name := NVL(l_DIM1_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4205: x_Target_Level_Rec.Dimension2_Level_Short_Name := NVL(l_DIM2_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4206: x_Target_Level_Rec.Dimension3_Level_Short_Name := NVL(l_DIM3_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4207: x_Target_Level_Rec.Dimension4_Level_Short_Name := NVL(l_DIM4_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4205: x_Target_Level_Rec.Dimension2_Level_Short_Name := NVL(l_DIM2_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4206: x_Target_Level_Rec.Dimension3_Level_Short_Name := NVL(l_DIM3_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4207: x_Target_Level_Rec.Dimension4_Level_Short_Name := NVL(l_DIM4_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4206: x_Target_Level_Rec.Dimension3_Level_Short_Name := NVL(l_DIM3_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4207: x_Target_Level_Rec.Dimension4_Level_Short_Name := NVL(l_DIM4_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4214: x_Target_Level_Rec.Dimension4_Level_Name := NVL(l_DIM4_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4207: x_Target_Level_Rec.Dimension4_Level_Short_Name := NVL(l_DIM4_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4214: x_Target_Level_Rec.Dimension4_Level_Name := NVL(l_DIM4_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4215: x_Target_Level_Rec.Dimension5_Level_Name := NVL(l_DIM5_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4208: x_Target_Level_Rec.Dimension5_Level_Short_Name := NVL(l_DIM5_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4214: x_Target_Level_Rec.Dimension4_Level_Name := NVL(l_DIM4_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4215: x_Target_Level_Rec.Dimension5_Level_Name := NVL(l_DIM5_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4216: x_Target_Level_Rec.Dimension6_Level_Name := NVL(l_DIM6_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4209: x_Target_Level_Rec.Dimension6_Level_Short_Name := NVL(l_DIM6_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4214: x_Target_Level_Rec.Dimension4_Level_Name := NVL(l_DIM4_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4215: x_Target_Level_Rec.Dimension5_Level_Name := NVL(l_DIM5_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4216: x_Target_Level_Rec.Dimension6_Level_Name := NVL(l_DIM6_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4217: x_Target_Level_Rec.Dimension7_Level_Name := NVL(l_DIM7_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

Line 4214: x_Target_Level_Rec.Dimension4_Level_Name := NVL(l_DIM4_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4210: x_Target_Level_Rec.Dimension7_Level_Short_Name := NVL(l_DIM7_LEVEL_SHORT_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4214: x_Target_Level_Rec.Dimension4_Level_Name := NVL(l_DIM4_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4215: x_Target_Level_Rec.Dimension5_Level_Name := NVL(l_DIM5_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4216: x_Target_Level_Rec.Dimension6_Level_Name := NVL(l_DIM6_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4217: x_Target_Level_Rec.Dimension7_Level_Name := NVL(l_DIM7_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4218:

Line 4215: x_Target_Level_Rec.Dimension5_Level_Name := NVL(l_DIM5_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4211: x_Target_Level_Rec.Dimension1_Level_Name := NVL(l_DIM1_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4214: x_Target_Level_Rec.Dimension4_Level_Name := NVL(l_DIM4_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4215: x_Target_Level_Rec.Dimension5_Level_Name := NVL(l_DIM5_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4216: x_Target_Level_Rec.Dimension6_Level_Name := NVL(l_DIM6_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4217: x_Target_Level_Rec.Dimension7_Level_Name := NVL(l_DIM7_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4218:
4219: EXCEPTION

Line 4216: x_Target_Level_Rec.Dimension6_Level_Name := NVL(l_DIM6_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4212: x_Target_Level_Rec.Dimension2_Level_Name := NVL(l_DIM2_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4214: x_Target_Level_Rec.Dimension4_Level_Name := NVL(l_DIM4_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4215: x_Target_Level_Rec.Dimension5_Level_Name := NVL(l_DIM5_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4216: x_Target_Level_Rec.Dimension6_Level_Name := NVL(l_DIM6_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4217: x_Target_Level_Rec.Dimension7_Level_Name := NVL(l_DIM7_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4218:
4219: EXCEPTION
4220: when others then

Line 4217: x_Target_Level_Rec.Dimension7_Level_Name := NVL(l_DIM7_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);

4213: x_Target_Level_Rec.Dimension3_Level_Name := NVL(l_DIM3_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4214: x_Target_Level_Rec.Dimension4_Level_Name := NVL(l_DIM4_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4215: x_Target_Level_Rec.Dimension5_Level_Name := NVL(l_DIM5_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4216: x_Target_Level_Rec.Dimension6_Level_Name := NVL(l_DIM6_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4217: x_Target_Level_Rec.Dimension7_Level_Name := NVL(l_DIM7_LEVEL_NAME,BIS_UTILITIES_PUB.G_NULL_CHAR);
4218:
4219: EXCEPTION
4220: when others then
4221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4300: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

4296: l_return_status VARCHAR2(100);
4297: l_return_msg VARCHAR2(3000);
4298: l_level_short_nm bis_levels.short_name%TYPE;
4299: l_dim_short_nm bis_dimensions.short_name%TYPE;
4300: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
4301:
4302: BEGIN
4303:
4304: SELECT indicator_id

Line 4343: BIS_UTILITIES_PUB.put_line(p_text => 'Error in validation of Performance Measure for the Summary Level '

4339: EXCEPTION
4340: WHEN NO_DATA_FOUND THEN
4341: x_return_status := 'E';
4342: /* -- 2515991
4343: BIS_UTILITIES_PUB.put_line(p_text => 'Error in validation of Performance Measure for the Summary Level '
4344: || nvl (p_target_level_rec.target_level_short_name, ' ' )
4345: || '. ' || sqlerrm
4346: || ' The measure ' || nvl(p_Target_Level_rec.Measure_short_Name, ' ')
4347: || ' was not found in the target system. '

Line 4354: BIS_UTILITIES_PUB.put_line(p_text => 'Error in validation of dimension levels for the Summary Level '

4350:
4351: WHEN OTHERS THEN
4352: x_return_status := 'E';
4353: /* -- 2515991
4354: BIS_UTILITIES_PUB.put_line(p_text => 'Error in validation of dimension levels for the Summary Level '
4355: || nvl (p_target_level_rec.target_level_short_name, ' ' ) || '.'
4356: || ' This Summary Level will not be created. ') ;
4357: */
4358:

Line 4436: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in Level_Correspond_To_Dim in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991

4432:
4433:
4434: EXCEPTION
4435: WHEN OTHERS THEN
4436: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in Level_Correspond_To_Dim in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991
4437: x_return_status := 'E';
4438:
4439: END Level_Correspond_To_Dim;
4440:

Line 4497: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;

4493: || ' , there is no Dimension corresponding to the Level '
4494: || nvl( l_lvl_short_name, ' ' )
4495: || '. Upload of this Summary Level is therefore aborted.';
4496:
4497: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
4498: */
4499:
4500: RAISE FND_API.G_EXC_ERROR;
4501:

Line 4539: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;

4535: || nvl( p_pm_short_name , ' ' )
4536: || ' , there is no Dimension Level corresponding to the Dimension '
4537: || nvl( l_dim_short_name , ' ' )
4538: || '. Upload of this Summary Level is therefore aborted.';
4539: BIS_UTILITIES_PUB.put_line(p_text => l_error_msg ) ;
4540: */
4541:
4542: RAISE FND_API.G_EXC_ERROR;
4543: END IF;

Line 4553: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in COMPARE_LEVELS_DIMS in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991

4549:
4550: EXCEPTION
4551: WHEN OTHERS THEN
4552: x_return_status := 'E';
4553: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in COMPARE_LEVELS_DIMS in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991
4554:
4555: END COMPARE_LEVELS_DIMS;
4556:
4557:

Line 4576: -- BIS_UTILITIES_PUB.put_line(p_text => 'There is no dimension corresponding to level ' || nvl( p_level_shtnm , ' ' ) ); -- 2515991

4572: RETURN l_dim_id;
4573:
4574: EXCEPTION
4575: WHEN NO_DATA_FOUND THEN
4576: -- BIS_UTILITIES_PUB.put_line(p_text => 'There is no dimension corresponding to level ' || nvl( p_level_shtnm , ' ' ) ); -- 2515991
4577: RETURN NULL;
4578: WHEN OTHERS THEN
4579: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in GET_DIM_ID_FRM_LVL_SHTNM in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm );-- 2515991
4580: RETURN NULL;

Line 4579: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in GET_DIM_ID_FRM_LVL_SHTNM in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm );-- 2515991

4575: WHEN NO_DATA_FOUND THEN
4576: -- BIS_UTILITIES_PUB.put_line(p_text => 'There is no dimension corresponding to level ' || nvl( p_level_shtnm , ' ' ) ); -- 2515991
4577: RETURN NULL;
4578: WHEN OTHERS THEN
4579: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in GET_DIM_ID_FRM_LVL_SHTNM in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm );-- 2515991
4580: RETURN NULL;
4581: END GET_DIM_ID_FRM_LVL_SHTNM;
4582:
4583:

Line 4633: -- BIS_UTILITIES_PUB.put_line(p_text => 'The number of dimensions = ' || nvl (l_num_dims, 0) || ' is incorrect. ' ) ; -- 2515991

4629: EXCEPTION
4630: WHEN OTHERS THEN
4631: x_return_status := 'E';
4632: x_num_dims := 0;
4633: -- BIS_UTILITIES_PUB.put_line(p_text => 'The number of dimensions = ' || nvl (l_num_dims, 0) || ' is incorrect. ' ) ; -- 2515991
4634: END GET_MEASURE_DIMS_ARRAY;
4635:
4636:
4637: PROCEDURE ADD_TO_MEASURE_ARRAY -- Procedure added for 2486702

Line 4651: -- BIS_UTILITIES_PUB.put_line(p_text => 'Error in ADD_TO_MEASURE_ARRAY in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991

4647:
4648: EXCEPTION
4649: WHEN OTHERS THEN
4650: NULL;
4651: -- BIS_UTILITIES_PUB.put_line(p_text => 'Error in ADD_TO_MEASURE_ARRAY in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991
4652: END ADD_TO_MEASURE_ARRAY;
4653:
4654:
4655: PROCEDURE GET_TL_LVLS_ARRAY -- Procedure added for 2486702

Line 4714: -- BIS_UTILITIES_PUB.put_line(p_text => 'The number of dimension levels = ' || nvl(l_num_levels, 0) || ' is incorrect. ' ) ; -- 2515991

4710: EXCEPTION
4711: WHEN OTHERS THEN
4712: x_return_status := 'E';
4713: x_num_lvls := 0;
4714: -- BIS_UTILITIES_PUB.put_line(p_text => 'The number of dimension levels = ' || nvl(l_num_levels, 0) || ' is incorrect. ' ) ; -- 2515991
4715: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in GET_TL_LVLS_ARRAY in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ;
4716: END GET_TL_LVLS_ARRAY;
4717:
4718:

Line 4715: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in GET_TL_LVLS_ARRAY in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ;

4711: WHEN OTHERS THEN
4712: x_return_status := 'E';
4713: x_num_lvls := 0;
4714: -- BIS_UTILITIES_PUB.put_line(p_text => 'The number of dimension levels = ' || nvl(l_num_levels, 0) || ' is incorrect. ' ) ; -- 2515991
4715: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in GET_TL_LVLS_ARRAY in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ;
4716: END GET_TL_LVLS_ARRAY;
4717:
4718:
4719:

Line 4746: -- BIS_UTILITIES_PUB.put_line(p_text =>'The dimension ' || nvl(l_dim_short_name, ' ') || ' is not unique. ' ); -- 2515991

4742: INTO l_dim_short_name
4743: FROM BIS_DIMENSIONS
4744: WHERE dimension_id = p_dim_tbl_type(i);
4745:
4746: -- BIS_UTILITIES_PUB.put_line(p_text =>'The dimension ' || nvl(l_dim_short_name, ' ') || ' is not unique. ' ); -- 2515991
4747:
4748: RAISE FND_API.G_EXC_ERROR;
4749:
4750: END IF;

Line 4777: -- BIS_UTILITIES_PUB.put_line(p_text => 'The level ' || nvl(p_short_name, ' ') || ' is invalid. ' ) ; -- 2515991

4773:
4774: EXCEPTION
4775: WHEN OTHERS THEN
4776: NULL;
4777: -- BIS_UTILITIES_PUB.put_line(p_text => 'The level ' || nvl(p_short_name, ' ') || ' is invalid. ' ) ; -- 2515991
4778: END ADD_TO_LEVEL_ARRAY;
4779:
4780:
4781:

Line 4809: -- BIS_UTILITIES_PUB.put_line(p_text =>'The level ' || nvl(p_lvl_tbl_type(i), ' ') || ' is not unique. ' ); -- 2515991

4805: IF (p_lvl_tbl_type(i) = p_lvl_tbl_type(j)) THEN
4806: IF (IS_ORG_OR_TIME_LEVEL(p_lvl_tbl_type(i))) THEN
4807: l_count := l_count + 1;
4808: ELSE
4809: -- BIS_UTILITIES_PUB.put_line(p_text =>'The level ' || nvl(p_lvl_tbl_type(i), ' ') || ' is not unique. ' ); -- 2515991
4810: RAISE FND_API.G_EXC_ERROR;
4811: END IF;
4812: END IF;
4813: END LOOP;

Line 4817: -- BIS_UTILITIES_PUB.put_line(p_text =>'The dimension level corresponding to Organization or Time dimension appears -- 2515991

4813: END LOOP;
4814:
4815: IF (l_count > 1) THEN
4816:
4817: -- BIS_UTILITIES_PUB.put_line(p_text =>'The dimension level corresponding to Organization or Time dimension appears -- 2515991
4818: -- more than twice in the definition of this Summary Level.' );
4819:
4820: RAISE FND_API.G_EXC_ERROR;
4821: END IF;

Line 4829: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in CHECK_UNIQUE_LEVELS in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991

4825: RETURN TRUE;
4826:
4827: EXCEPTION
4828: WHEN OTHERS THEN
4829: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in CHECK_UNIQUE_LEVELS in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991
4830: RETURN FALSE;
4831: END CHECK_UNIQUE_LEVELS;
4832:
4833:

Line 4862: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in IS_ORG_OR_TIME_LEVEL in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991

4858: END IF;
4859:
4860: EXCEPTION
4861: WHEN OTHERS THEN
4862: -- BIS_UTILITIES_PUB.put_line(p_text => ' Error in IS_ORG_OR_TIME_LEVEL in BIS_TARGET_LEVEL_PVT -- ' || sqlerrm ) ; -- 2515991
4863: RETURN FALSE;
4864: END IS_ORG_OR_TIME_LEVEL;
4865:
4866: