eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BIS_PMF_DEFINER_WRAPPER_PVT dependencies on FND_API

Line 30: REM | 30-JAN-03 sugopal FND_API.G_MISS_xxx should not be used in |

26: REM | Jun-05-2002 Fixed for bug#2405029(backward compatible issue)|
27: REM | 26-JUL-2002 rchandra Fixed for enh 2440739 |
28: REM | 23-JAN-03 sugopal For having different local variables for IN and OUT |
29: REM | parameters (bug#2758428) |
30: REM | 30-JAN-03 sugopal FND_API.G_MISS_xxx should not be used in |
31: REM | initialization or declaration (bug#2774644) |
32: REM | 11-APR-03 sugopal Not possible to update an existing value with null |
33: REM | in the Create/Update performance measures page - |
34: REM | modified Update_Performance_Measure for bug#2869324 |

Line 65: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711

61: ,p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
62: ,p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
63: -- Fix for 1850860 ends here
64: ,p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
65: ,p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
66: ,p_measure_Type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
67: ,p_application_id IN NUMBER := c_default_appl --2465354
68: ,x_return_status OUT NOCOPY VARCHAR2
69: ,x_msg_count OUT NOCOPY VARCHAR2

Line 80: IF (l_ret = FND_API.G_FALSE) THEN

76: l_ret VARCHAR2(32000);
77: Begin
78: FND_MSG_PUB.initialize;
79: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);
80: IF (l_ret = FND_API.G_FALSE) THEN
81: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
82: END IF;
83:
84: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Name);

Line 85: IF (l_ret = FND_API.G_FALSE) THEN

81: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
82: END IF;
83:
84: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Name);
85: IF (l_ret = FND_API.G_FALSE) THEN
86: l_measure_rec.Measure_Name := p_Measure_Name;
87: END IF;
88:
89: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Description);

Line 90: IF (l_ret = FND_API.G_FALSE) THEN

86: l_measure_rec.Measure_Name := p_Measure_Name;
87: END IF;
88:
89: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Description);
90: IF (l_ret = FND_API.G_FALSE) THEN
91: l_measure_rec.Description := p_Description;
92: END IF;
93:
94: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension1_ID);

Line 95: IF (l_ret = FND_API.G_FALSE) THEN

91: l_measure_rec.Description := p_Description;
92: END IF;
93:
94: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension1_ID);
95: IF (l_ret = FND_API.G_FALSE) THEN
96: l_measure_rec.Dimension1_ID := p_Dimension1_ID;
97: END IF;
98:
99: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension2_ID);

Line 100: IF (l_ret = FND_API.G_FALSE) THEN

96: l_measure_rec.Dimension1_ID := p_Dimension1_ID;
97: END IF;
98:
99: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension2_ID);
100: IF (l_ret = FND_API.G_FALSE) THEN
101: l_measure_rec.Dimension2_ID := p_Dimension2_ID;
102: END IF;
103:
104: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension3_ID);

Line 105: IF (l_ret = FND_API.G_FALSE) THEN

101: l_measure_rec.Dimension2_ID := p_Dimension2_ID;
102: END IF;
103:
104: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension3_ID);
105: IF (l_ret = FND_API.G_FALSE) THEN
106: l_measure_rec.Dimension3_ID := p_Dimension3_ID;
107: END IF;
108:
109: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension4_ID);

Line 110: IF (l_ret = FND_API.G_FALSE) THEN

106: l_measure_rec.Dimension3_ID := p_Dimension3_ID;
107: END IF;
108:
109: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension4_ID);
110: IF (l_ret = FND_API.G_FALSE) THEN
111: l_measure_rec.Dimension4_ID := p_Dimension4_ID;
112: END IF;
113:
114: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension5_ID);

Line 115: IF (l_ret = FND_API.G_FALSE) THEN

111: l_measure_rec.Dimension4_ID := p_Dimension4_ID;
112: END IF;
113:
114: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension5_ID);
115: IF (l_ret = FND_API.G_FALSE) THEN
116: l_measure_rec.Dimension5_ID := p_Dimension5_ID;
117: END IF;
118:
119: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension6_ID);

Line 120: IF (l_ret = FND_API.G_FALSE) THEN

116: l_measure_rec.Dimension5_ID := p_Dimension5_ID;
117: END IF;
118:
119: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension6_ID);
120: IF (l_ret = FND_API.G_FALSE) THEN
121: l_measure_rec.Dimension6_ID := p_Dimension6_ID;
122: END IF;
123:
124: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension7_ID);

Line 125: IF (l_ret = FND_API.G_FALSE) THEN

121: l_measure_rec.Dimension6_ID := p_Dimension6_ID;
122: END IF;
123:
124: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension7_ID);
125: IF (l_ret = FND_API.G_FALSE) THEN
126: l_measure_rec.Dimension7_ID := p_Dimension7_ID;
127: END IF;
128:
129: -----

Line 131: IF (l_ret = FND_API.G_FALSE) THEN

127: END IF;
128:
129: -----
130: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Unit_Of_Measure_Class);
131: IF (l_ret = FND_API.G_FALSE) THEN
132: l_measure_rec.Unit_Of_Measure_Class := p_Unit_Of_Measure_Class;
133: END IF;
134:
135: --Fix for 1850860 starts here

Line 137: IF (l_ret = FND_API.G_FALSE) THEN

133: END IF;
134:
135: --Fix for 1850860 starts here
136: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source_type);
137: IF (l_ret = FND_API.G_FALSE) THEN
138: l_measure_rec.actual_data_source_type := p_actual_data_source_type;
139: END IF;
140: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);
141: IF (l_ret = FND_API.G_FALSE) THEN

Line 141: IF (l_ret = FND_API.G_FALSE) THEN

137: IF (l_ret = FND_API.G_FALSE) THEN
138: l_measure_rec.actual_data_source_type := p_actual_data_source_type;
139: END IF;
140: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);
141: IF (l_ret = FND_API.G_FALSE) THEN
142: l_measure_rec.actual_data_source := p_actual_data_source;
143: END IF;
144: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);
145: IF (l_ret = FND_API.G_FALSE) THEN

Line 145: IF (l_ret = FND_API.G_FALSE) THEN

141: IF (l_ret = FND_API.G_FALSE) THEN
142: l_measure_rec.actual_data_source := p_actual_data_source;
143: END IF;
144: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);
145: IF (l_ret = FND_API.G_FALSE) THEN
146: l_measure_rec.function_name := p_function_name;
147: END IF;
148: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);
149: IF (l_ret = FND_API.G_FALSE) THEN

Line 149: IF (l_ret = FND_API.G_FALSE) THEN

145: IF (l_ret = FND_API.G_FALSE) THEN
146: l_measure_rec.function_name := p_function_name;
147: END IF;
148: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);
149: IF (l_ret = FND_API.G_FALSE) THEN
150: l_measure_rec.comparison_source := p_comparison_source;
151: END IF;
152: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);
153: IF (l_ret = FND_API.G_FALSE) THEN

Line 153: IF (l_ret = FND_API.G_FALSE) THEN

149: IF (l_ret = FND_API.G_FALSE) THEN
150: l_measure_rec.comparison_source := p_comparison_source;
151: END IF;
152: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);
153: IF (l_ret = FND_API.G_FALSE) THEN
154: l_measure_rec.increase_in_measure := p_increase_in_measure;
155: END IF;
156: -- Fix for 1850860 ends here
157: -- 2440739

Line 159: IF (l_ret = FND_API.G_FALSE) THEN

155: END IF;
156: -- Fix for 1850860 ends here
157: -- 2440739
158: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_enable_link);
159: IF (l_ret = FND_API.G_FALSE) THEN
160: l_measure_rec.enable_link := p_enable_link;
161: END IF;
162: -- 2440739
163: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_obsolete);

Line 164: IF (l_ret = FND_API.G_FALSE) THEN

160: l_measure_rec.enable_link := p_enable_link;
161: END IF;
162: -- 2440739
163: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_obsolete);
164: IF (l_ret = FND_API.G_FALSE) THEN
165: l_measure_rec.obsolete := p_obsolete;
166: END IF;
167: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_type);
168: IF (l_ret = FND_API.G_FALSE) THEN

Line 168: IF (l_ret = FND_API.G_FALSE) THEN

164: IF (l_ret = FND_API.G_FALSE) THEN
165: l_measure_rec.obsolete := p_obsolete;
166: END IF;
167: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_measure_type);
168: IF (l_ret = FND_API.G_FALSE) THEN
169: l_measure_rec.measure_type := p_measure_type;
170: END IF;
171:
172: l_measure_rec.Application_Id := p_application_id ; --2465354

Line 174: , p_commit => fnd_api.G_TRUE

170: END IF;
171:
172: l_measure_rec.Application_Id := p_application_id ; --2465354
173: BIS_MEASURE_PUB.Create_Measure( p_api_version => g_api_version
174: , p_commit => fnd_api.G_TRUE
175: , p_Measure_Rec => l_measure_rec
176: , x_return_status => l_return_status
177: , x_error_tbl => l_error_tbl
178: );

Line 236: , p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711

232: , p_comparison_source IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
233: , p_increase_in_measure IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
234: -- Fix for 1850860 ends here
235: , p_enable_link IN VARCHAR2 := c_hide_url -- 2440739
236: , p_obsolete IN VARCHAR2 := FND_API.G_FALSE --3865711
237: , p_measure_type IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
238: , p_application_id IN NUMBER := c_default_appl -- 2465354
239: , x_return_status OUT NOCOPY VARCHAR2
240: , x_msg_count OUT NOCOPY VARCHAR2

Line 275: , p_commit => fnd_api.G_TRUE

271: l_measure_rec.measure_type := p_measure_type;
272: l_measure_rec.Application_Id := p_application_id ; --2465354
273:
274: BIS_MEASURE_PUB.Update_Measure( p_api_version => g_api_version
275: , p_commit => fnd_api.G_TRUE
276: , p_Measure_Rec => l_measure_rec
277: , x_return_status => l_return_status
278: , x_error_tbl => l_error_tbl
279: );

Line 336: IF (l_ret = FND_API.G_FALSE) THEN

332: Begin
333: FND_MSG_PUB.initialize;
334:
335: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_ID);
336: IF (l_ret = FND_API.G_FALSE) THEN
337: l_measure_rec.Measure_ID := p_Measure_ID;
338: END IF;
339:
340: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);

Line 341: IF (l_ret = FND_API.G_FALSE) THEN

337: l_measure_rec.Measure_ID := p_Measure_ID;
338: END IF;
339:
340: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);
341: IF (l_ret = FND_API.G_FALSE) THEN
342: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
343: END IF;
344:
345:

Line 347: , p_commit => fnd_api.G_TRUE

343: END IF;
344:
345:
346: BIS_MEASURE_PUB.Delete_Measure( p_api_version => g_api_version
347: , p_commit => fnd_api.G_TRUE
348: , p_Measure_Rec => l_measure_rec
349: , x_return_status => l_return_status
350: , x_error_tbl => l_error_tbl
351: );

Line 429: (p_Target_Level_Id) = FND_API.G_FALSE) THEN

425: Begin
426: FND_MSG_PUB.initialize;
427:
428: IF (BIS_UTILITIES_PUB.Value_Missing
429: (p_Target_Level_Id) = FND_API.G_FALSE) THEN
430: l_target_level_rec.Target_Level_Id :=
431: p_Target_Level_Id;
432: END IF;
433:

Line 435: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN

431: p_Target_Level_Id;
432: END IF;
433:
434: IF (BIS_UTILITIES_PUB.Value_Missing
435: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN
436: l_target_level_rec.Target_Level_Short_Name :=
437: p_Target_Level_Short_Name;
438: END IF;
439:

Line 443: , p_commit => fnd_api.G_TRUE

439:
440: BIS_Target_Level_PVT.Delete_Target_Level
441: ( p_api_version => g_api_version
442: , p_force_delete => p_force_delete --gbhaloti #3148615
443: , p_commit => fnd_api.G_TRUE
444: , p_Target_Level_Rec => l_Target_Level_Rec
445: , x_return_status => l_return_status
446: , x_error_Tbl => l_error_Tbl
447: );

Line 514: (p_Target_Level_Id) = FND_API.G_FALSE) THEN

510: Begin
511: FND_MSG_PUB.initialize;
512:
513: IF (BIS_UTILITIES_PUB.Value_Missing
514: (p_Target_Level_Id) = FND_API.G_FALSE) THEN
515: l_target_level_rec.Target_Level_Id :=
516: p_Target_Level_Id;
517: END IF;
518:

Line 520: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN

516: p_Target_Level_Id;
517: END IF;
518:
519: IF (BIS_UTILITIES_PUB.Value_Missing
520: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN
521: l_target_level_rec.Target_Level_Short_Name :=
522: p_Target_Level_Short_Name;
523: END IF;
524:

Line 526: (p_Target_Level_Name) = FND_API.G_FALSE) THEN

522: p_Target_Level_Short_Name;
523: END IF;
524:
525: IF (BIS_UTILITIES_PUB.Value_Missing
526: (p_Target_Level_Name) = FND_API.G_FALSE) THEN
527: l_target_level_rec.Target_Level_Name :=
528: p_Target_Level_Name;
529: END IF;
530:

Line 532: (p_Description) = FND_API.G_FALSE) THEN

528: p_Target_Level_Name;
529: END IF;
530:
531: IF (BIS_UTILITIES_PUB.Value_Missing
532: (p_Description) = FND_API.G_FALSE) THEN
533: l_target_level_rec.Description := p_Description;
534: END IF;
535:
536: IF (BIS_UTILITIES_PUB.Value_Missing

Line 537: (p_Measure_Id) = FND_API.G_FALSE) THEN

533: l_target_level_rec.Description := p_Description;
534: END IF;
535:
536: IF (BIS_UTILITIES_PUB.Value_Missing
537: (p_Measure_Id) = FND_API.G_FALSE) THEN
538: l_target_level_rec.Measure_Id := p_Measure_Id;
539: END IF;
540:
541: IF (BIS_UTILITIES_PUB.Value_Missing

Line 542: (p_Dimension1_Level_ID) = FND_API.G_FALSE) THEN

538: l_target_level_rec.Measure_Id := p_Measure_Id;
539: END IF;
540:
541: IF (BIS_UTILITIES_PUB.Value_Missing
542: (p_Dimension1_Level_ID) = FND_API.G_FALSE) THEN
543: l_target_level_rec.Dimension1_Level_ID :=
544: p_Dimension1_Level_ID;
545: END IF;
546:

Line 548: (p_Dimension2_Level_ID) = FND_API.G_FALSE) THEN

544: p_Dimension1_Level_ID;
545: END IF;
546:
547: IF (BIS_UTILITIES_PUB.Value_Missing
548: (p_Dimension2_Level_ID) = FND_API.G_FALSE) THEN
549: l_target_level_rec.Dimension2_Level_ID :=
550: p_Dimension2_Level_ID;
551: END IF;
552:

Line 554: (p_Dimension3_Level_ID) = FND_API.G_FALSE) THEN

550: p_Dimension2_Level_ID;
551: END IF;
552:
553: IF (BIS_UTILITIES_PUB.Value_Missing
554: (p_Dimension3_Level_ID) = FND_API.G_FALSE) THEN
555: l_target_level_rec.Dimension3_Level_ID :=
556: p_Dimension3_Level_ID;
557: END IF;
558:

Line 560: (p_Dimension4_Level_ID) = FND_API.G_FALSE) THEN

556: p_Dimension3_Level_ID;
557: END IF;
558:
559: IF (BIS_UTILITIES_PUB.Value_Missing
560: (p_Dimension4_Level_ID) = FND_API.G_FALSE) THEN
561: l_target_level_rec.Dimension4_Level_ID :=
562: p_Dimension4_Level_ID;
563: END IF;
564:

Line 566: (p_Dimension5_Level_ID) = FND_API.G_FALSE) THEN

562: p_Dimension4_Level_ID;
563: END IF;
564:
565: IF (BIS_UTILITIES_PUB.Value_Missing
566: (p_Dimension5_Level_ID) = FND_API.G_FALSE) THEN
567: l_target_level_rec.Dimension5_Level_ID :=
568: p_Dimension5_Level_ID;
569: END IF;
570:

Line 572: (p_Dimension6_Level_ID) = FND_API.G_FALSE) THEN

568: p_Dimension5_Level_ID;
569: END IF;
570:
571: IF (BIS_UTILITIES_PUB.Value_Missing
572: (p_Dimension6_Level_ID) = FND_API.G_FALSE) THEN
573: l_target_level_rec.Dimension6_Level_ID :=
574: p_Dimension6_Level_ID;
575: END IF;
576:

Line 578: (p_Dimension7_Level_ID) = FND_API.G_FALSE) THEN

574: p_Dimension6_Level_ID;
575: END IF;
576:
577: IF (BIS_UTILITIES_PUB.Value_Missing
578: (p_Dimension7_Level_ID) = FND_API.G_FALSE) THEN
579: l_target_level_rec.Dimension7_Level_ID :=
580: p_Dimension7_Level_ID;
581: END IF;
582:

Line 584: (P_WORKFLOW_ITEM_TYPE) = FND_API.G_FALSE) THEN

580: p_Dimension7_Level_ID;
581: END IF;
582:
583: IF (BIS_UTILITIES_PUB.Value_Missing
584: (P_WORKFLOW_ITEM_TYPE) = FND_API.G_FALSE) THEN
585: l_target_level_rec.Workflow_Item_type :=
586: P_WORKFLOW_ITEM_TYPE;
587: END IF;
588:

Line 590: (p_Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN

586: P_WORKFLOW_ITEM_TYPE;
587: END IF;
588:
589: IF (BIS_UTILITIES_PUB.Value_Missing
590: (p_Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN
591: l_target_level_rec.Workflow_Process_Short_Name :=
592: p_Workflow_Process_Short_Name;
593: END IF;
594:

Line 596: (p_Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN

592: p_Workflow_Process_Short_Name;
593: END IF;
594:
595: IF (BIS_UTILITIES_PUB.Value_Missing
596: (p_Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN
597: l_target_level_rec.Default_Notify_Resp_ID :=
598: p_Default_Notify_Resp_ID;
599: END IF;
600:

Line 602: (p_Default_Not_Resp_short_name)=FND_API.G_FALSE) THEN

598: p_Default_Notify_Resp_ID;
599: END IF;
600:
601: IF (BIS_UTILITIES_PUB.Value_Missing
602: (p_Default_Not_Resp_short_name)=FND_API.G_FALSE) THEN
603: l_target_level_rec.Default_Notify_Resp_short_name :=
604: p_Default_Not_Resp_short_name;
605: END IF;
606: l_target_level_Rec.computing_function_id := p_computing_function_id;

Line 613: (p_Source) = FND_API.G_FALSE) THEN

609: l_target_level_rec.unit_of_measure := p_unit_of_measure;
610: -- l_target_level_rec.Source := 'EDW';
611: ---------------
612: IF (BIS_UTILITIES_PUB.Value_Missing
613: (p_Source) = FND_API.G_FALSE) THEN
614: l_target_level_rec.Source := p_Source;
615: END IF;
616: -----------------------------------
617: -- 2465354

Line 627: , p_commit => fnd_api.G_TRUE

623: -- 2465354
624:
625: BIS_Target_Level_PVT.Update_Target_Level
626: ( p_api_version => g_api_version
627: , p_commit => fnd_api.G_TRUE
628: , p_Target_Level_Rec => l_Target_Level_Rec
629: , p_owner => l_owner --2465354
630: , x_return_status => l_return_status
631: , x_error_Tbl => l_error_Tbl

Line 700: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN

696: Begin
697: FND_MSG_PUB.initialize;
698:
699: IF (BIS_UTILITIES_PUB.Value_Missing
700: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN
701: l_target_level_rec.Target_Level_Short_Name :=
702: p_Target_Level_Short_Name;
703: END IF;
704:

Line 706: (p_Target_Level_Name) = FND_API.G_FALSE) THEN

702: p_Target_Level_Short_Name;
703: END IF;
704:
705: IF (BIS_UTILITIES_PUB.Value_Missing
706: (p_Target_Level_Name) = FND_API.G_FALSE) THEN
707: l_target_level_rec.Target_Level_Name :=
708: p_Target_Level_Name;
709: END IF;
710:

Line 712: (p_Description) = FND_API.G_FALSE) THEN

708: p_Target_Level_Name;
709: END IF;
710:
711: IF (BIS_UTILITIES_PUB.Value_Missing
712: (p_Description) = FND_API.G_FALSE) THEN
713: l_target_level_rec.Description := p_Description;
714: END IF;
715:
716: IF (BIS_UTILITIES_PUB.Value_Missing

Line 717: (p_Measure_Id) = FND_API.G_FALSE) THEN

713: l_target_level_rec.Description := p_Description;
714: END IF;
715:
716: IF (BIS_UTILITIES_PUB.Value_Missing
717: (p_Measure_Id) = FND_API.G_FALSE) THEN
718: l_target_level_rec.Measure_Id := p_Measure_Id;
719: END IF;
720:
721: IF (BIS_UTILITIES_PUB.Value_Missing

Line 722: (p_Dimension1_Level_ID) = FND_API.G_FALSE) THEN

718: l_target_level_rec.Measure_Id := p_Measure_Id;
719: END IF;
720:
721: IF (BIS_UTILITIES_PUB.Value_Missing
722: (p_Dimension1_Level_ID) = FND_API.G_FALSE) THEN
723: l_target_level_rec.Dimension1_Level_ID :=
724: p_Dimension1_Level_ID;
725: END IF;
726:

Line 728: (p_Dimension2_Level_ID) = FND_API.G_FALSE) THEN

724: p_Dimension1_Level_ID;
725: END IF;
726:
727: IF (BIS_UTILITIES_PUB.Value_Missing
728: (p_Dimension2_Level_ID) = FND_API.G_FALSE) THEN
729: l_target_level_rec.Dimension2_Level_ID :=
730: p_Dimension2_Level_ID;
731: END IF;
732:

Line 734: (p_Dimension3_Level_ID) = FND_API.G_FALSE) THEN

730: p_Dimension2_Level_ID;
731: END IF;
732:
733: IF (BIS_UTILITIES_PUB.Value_Missing
734: (p_Dimension3_Level_ID) = FND_API.G_FALSE) THEN
735: l_target_level_rec.Dimension3_Level_ID :=
736: p_Dimension3_Level_ID;
737: END IF;
738:

Line 740: (p_Dimension4_Level_ID) = FND_API.G_FALSE) THEN

736: p_Dimension3_Level_ID;
737: END IF;
738:
739: IF (BIS_UTILITIES_PUB.Value_Missing
740: (p_Dimension4_Level_ID) = FND_API.G_FALSE) THEN
741: l_target_level_rec.Dimension4_Level_ID :=
742: p_Dimension4_Level_ID;
743: END IF;
744:

Line 746: (p_Dimension5_Level_ID) = FND_API.G_FALSE) THEN

742: p_Dimension4_Level_ID;
743: END IF;
744:
745: IF (BIS_UTILITIES_PUB.Value_Missing
746: (p_Dimension5_Level_ID) = FND_API.G_FALSE) THEN
747: l_target_level_rec.Dimension5_Level_ID :=
748: p_Dimension5_Level_ID;
749: END IF;
750:

Line 752: (p_Dimension6_Level_ID) = FND_API.G_FALSE) THEN

748: p_Dimension5_Level_ID;
749: END IF;
750:
751: IF (BIS_UTILITIES_PUB.Value_Missing
752: (p_Dimension6_Level_ID) = FND_API.G_FALSE) THEN
753: l_target_level_rec.Dimension6_Level_ID :=
754: p_Dimension6_Level_ID;
755: END IF;
756:

Line 758: (p_Dimension7_Level_ID) = FND_API.G_FALSE) THEN

754: p_Dimension6_Level_ID;
755: END IF;
756:
757: IF (BIS_UTILITIES_PUB.Value_Missing
758: (p_Dimension7_Level_ID) = FND_API.G_FALSE) THEN
759: l_target_level_rec.Dimension7_Level_ID :=
760: p_Dimension7_Level_ID;
761: END IF;
762:

Line 764: (P_WORKFLOW_ITEM_TYPE) = FND_API.G_FALSE) THEN

760: p_Dimension7_Level_ID;
761: END IF;
762:
763: IF (BIS_UTILITIES_PUB.Value_Missing
764: (P_WORKFLOW_ITEM_TYPE) = FND_API.G_FALSE) THEN
765: l_target_level_rec.Workflow_Item_type :=
766: P_WORKFLOW_ITEM_TYPE;
767: END IF;
768:

Line 770: (p_Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN

766: P_WORKFLOW_ITEM_TYPE;
767: END IF;
768:
769: IF (BIS_UTILITIES_PUB.Value_Missing
770: (p_Workflow_Process_Short_Name) = FND_API.G_FALSE) THEN
771: l_target_level_rec.Workflow_Process_Short_Name :=
772: p_Workflow_Process_Short_Name;
773: END IF;
774:

Line 776: (p_Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN

772: p_Workflow_Process_Short_Name;
773: END IF;
774:
775: IF (BIS_UTILITIES_PUB.Value_Missing
776: (p_Default_Notify_Resp_ID) = FND_API.G_FALSE) THEN
777: l_target_level_rec.Default_Notify_Resp_ID :=
778: p_Default_Notify_Resp_ID;
779: END IF;
780:

Line 782: (p_Default_Not_Resp_short_name)=FND_API.G_FALSE) THEN

778: p_Default_Notify_Resp_ID;
779: END IF;
780:
781: IF (BIS_UTILITIES_PUB.Value_Missing
782: (p_Default_Not_Resp_short_name)=FND_API.G_FALSE) THEN
783: l_target_level_rec.Default_Notify_Resp_short_name :=
784: p_Default_Not_Resp_short_name;
785: END IF;
786: l_target_level_Rec.computing_function_id := p_computing_function_id;

Line 793: (p_Source) = FND_API.G_FALSE) THEN

789: l_target_level_rec.unit_of_measure := p_unit_of_measure;
790: -- l_target_level_rec.Source := 'EDW';
791: ---------------
792: IF (BIS_UTILITIES_PUB.Value_Missing
793: (p_Source) = FND_API.G_FALSE) THEN
794: l_target_level_rec.Source := p_Source;
795: END IF;
796: -----------------------------------
797: BIS_PMF_DEFINER_WRAPPER_PVT.GET_TIME_LEVEL_ID

Line 891: , p_commit => fnd_api.G_TRUE

887: -- 2465354
888:
889: BIS_Target_Level_PVT.Create_Target_Level
890: ( p_api_version => g_api_version
891: , p_commit => fnd_api.G_TRUE
892: , p_Target_Level_Rec => l_Target_Level_Rec
893: , p_owner => l_owner --2465354
894: , x_return_status => l_return_status
895: , x_error_Tbl => l_error_Tbl

Line 938: (p_Target_Level_ID) = FND_API.G_FALSE) THEN

934: BEGIN
935: FND_MSG_PUB.initialize;
936: --
937: IF (BIS_UTILITIES_PUB.Value_Missing
938: (p_Target_Level_ID) = FND_API.G_FALSE) THEN
939: l_Measure_Security_Rec.Target_Level_ID :=
940: p_Target_Level_ID;
941: END IF;
942:

Line 944: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN

940: p_Target_Level_ID;
941: END IF;
942:
943: IF (BIS_UTILITIES_PUB.Value_Missing
944: (p_Target_Level_Short_Name) = FND_API.G_FALSE) THEN
945: l_Measure_Security_Rec.Target_Level_Short_Name :=
946: p_Target_Level_Short_Name;
947: END IF;
948:

Line 950: (p_Responsibility_ID) = FND_API.G_FALSE) THEN

946: p_Target_Level_Short_Name;
947: END IF;
948:
949: IF (BIS_UTILITIES_PUB.Value_Missing
950: (p_Responsibility_ID) = FND_API.G_FALSE) THEN
951: l_Measure_Security_Rec.Responsibility_ID :=
952: p_Responsibility_ID;
953: END IF;
954:

Line 956: (p_Responsibility_Short_Name) = FND_API.G_FALSE) THEN

952: p_Responsibility_ID;
953: END IF;
954:
955: IF (BIS_UTILITIES_PUB.Value_Missing
956: (p_Responsibility_Short_Name) = FND_API.G_FALSE) THEN
957: l_Measure_Security_Rec.Responsibility_Short_Name :=
958: p_Responsibility_Short_Name;
959: END IF;
960: -- 2465354

Line 970: , p_commit => fnd_api.G_TRUE

966: -- 2465354
967:
968: BIS_MEASURE_SECURITY_PVT.Create_Measure_Security
969: ( p_api_version => g_api_version
970: , p_commit => fnd_api.G_TRUE
971: , p_Measure_Security_Rec => l_Measure_Security_Rec
972: , p_owner => l_owner --2465354
973: , x_return_status => l_return_status
974: , x_error_Tbl => l_error_Tbl

Line 1017: (p_Target_Level_ID) = FND_API.G_FALSE) THEN

1013: FND_MSG_PUB.initialize;
1014: --
1015: FND_MSG_PUB.initialize;
1016: IF (BIS_UTILITIES_PUB.Value_Missing
1017: (p_Target_Level_ID) = FND_API.G_FALSE) THEN
1018: l_Measure_Security_Rec.Target_Level_ID :=
1019: p_Target_Level_ID;
1020: END IF;
1021:

Line 1023: (p_Responsibility_ID) = FND_API.G_FALSE) THEN

1019: p_Target_Level_ID;
1020: END IF;
1021:
1022: IF (BIS_UTILITIES_PUB.Value_Missing
1023: (p_Responsibility_ID) = FND_API.G_FALSE) THEN
1024: l_Measure_Security_Rec.Responsibility_ID :=
1025: p_Responsibility_ID;
1026: END IF;
1027:

Line 1030: , p_commit => fnd_api.G_FALSE --gbhaloti, removed commit for #3475674

1026: END IF;
1027:
1028: BIS_MEASURE_SECURITY_PVT.Delete_Measure_Security
1029: ( p_api_version => g_api_version
1030: , p_commit => fnd_api.G_FALSE --gbhaloti, removed commit for #3475674
1031: , p_Measure_Security_Rec => l_Measure_Security_Rec
1032: , x_return_status => l_return_status
1033: , x_error_Tbl => l_error_Tbl
1034: );

Line 1114: IF BIS_UTILITIES_PUB.VALUE_MISSINg(p_target_id)=FND_API.G_FALSE THEN

1110: l_return_status varchar2(10);
1111:
1112: BEGIN
1113: FND_MSG_PUB.initialize;
1114: IF BIS_UTILITIES_PUB.VALUE_MISSINg(p_target_id)=FND_API.G_FALSE THEN
1115: l_target_rec.target_id := p_target_id;
1116: END IF;
1117:
1118: l_target_rec.target_level_id := p_target_level_id;

Line 1170: -- = FND_API.G_TRUE

1166: ,x_msg_data => x_msg_data
1167: );
1168:
1169: -- IF( BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec_out.TARGET_ID)
1170: -- = FND_API.G_TRUE
1171: -- OR l_Target_Rec_out.TARGET_ID IS NULL
1172: -- ) THEN
1173:
1174: IF( BIS_UTILITIES_PUB.Value_Missing(P_TARGET_ID)

Line 1175: = FND_API.G_TRUE

1171: -- OR l_Target_Rec_out.TARGET_ID IS NULL
1172: -- ) THEN
1173:
1174: IF( BIS_UTILITIES_PUB.Value_Missing(P_TARGET_ID)
1175: = FND_API.G_TRUE
1176: OR P_TARGET_ID IS NULL
1177: ) THEN
1178: BIS_PMF_DEFINER_WRAPPER_PVT.GET_TIME_LEVEL_ID
1179: (p_performance_measure_id => NULL

Line 1263: ,p_commit => FND_API.G_TRUE

1259:
1260: BIS_TARGET_PVT.CREATE_TARGET
1261: (p_api_version => 1.0
1262: ,p_is_dbimeasure => p_is_dbimeasure --gbhaloti #3148615
1263: ,p_commit => FND_API.G_TRUE
1264: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1265: ,p_target_rec => l_target_rec
1266: ,x_return_status => x_return_status
1267: ,x_error_tbl => l_error_tbl

Line 1264: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1260: BIS_TARGET_PVT.CREATE_TARGET
1261: (p_api_version => 1.0
1262: ,p_is_dbimeasure => p_is_dbimeasure --gbhaloti #3148615
1263: ,p_commit => FND_API.G_TRUE
1264: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1265: ,p_target_rec => l_target_rec
1266: ,x_return_status => x_return_status
1267: ,x_error_tbl => l_error_tbl
1268: );

Line 1275: ,p_commit => FND_API.G_TRUE

1271:
1272: BIS_TARGET_PVT.UPDATE_TARGET
1273: (p_api_version => 1.0
1274: ,p_is_dbimeasure => p_is_dbimeasure --gbhaloti #3148615
1275: ,p_commit => FND_API.G_TRUE
1276: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1277: ,p_target_rec => l_target_rec
1278: ,x_return_status => x_return_status
1279: ,x_error_tbl => l_error_tbl

Line 1276: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1272: BIS_TARGET_PVT.UPDATE_TARGET
1273: (p_api_version => 1.0
1274: ,p_is_dbimeasure => p_is_dbimeasure --gbhaloti #3148615
1275: ,p_commit => FND_API.G_TRUE
1276: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1277: ,p_target_rec => l_target_rec
1278: ,x_return_status => x_return_status
1279: ,x_error_tbl => l_error_tbl
1280: );

Line 1355: IF BIS_UTILITIES_PUB.VALUE_MISSINg(p_target_id)=FND_API.G_FALSE THEN

1351: l_return_status varchar2(10);
1352:
1353: BEGIN
1354: FND_MSG_PUB.initialize;
1355: IF BIS_UTILITIES_PUB.VALUE_MISSINg(p_target_id)=FND_API.G_FALSE THEN
1356: l_target_rec.target_id := p_target_id;
1357: END IF;
1358: l_target_rec.target_level_id := p_target_level_id;
1359: l_target_rec.target_level_short_name := p_target_level_short_name;

Line 1395: ,p_commit => FND_API.G_TRUE

1391: l_target_rec.notify_resp3_short_name := p_notify_resp1_short_name;
1392: l_target_rec.notify_resp3_name := p_notify_resp1_name;
1393: BIS_TARGET_PVT.UPDATE_TARGET
1394: (p_api_version => 1.0
1395: ,p_commit => FND_API.G_TRUE
1396: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1397: ,p_target_rec => l_target_rec
1398: ,x_return_status => x_return_status
1399: ,x_error_tbl => l_error_tbl

Line 1396: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1392: l_target_rec.notify_resp3_name := p_notify_resp1_name;
1393: BIS_TARGET_PVT.UPDATE_TARGET
1394: (p_api_version => 1.0
1395: ,p_commit => FND_API.G_TRUE
1396: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1397: ,p_target_rec => l_target_rec
1398: ,x_return_status => x_return_status
1399: ,x_error_tbl => l_error_tbl
1400: );

Line 1442: ,p_commit => FND_API.G_TRUE

1438: l_target_rec.target_level_id := p_target_level_id;
1439: l_target_rec.target_level_short_name := p_target_level_short_name;
1440: BIS_TARGET_PVT.DELETE_TARGET
1441: (p_api_version => 1.0
1442: ,p_commit => FND_API.G_TRUE
1443: ,p_target_Rec => l_target_rec
1444: ,x_return_status => x_return_status
1445: ,x_error_tbl => l_error_tbl
1446: );

Line 1535: IF (p_performance_measure_id <> FND_API.G_MISS_NUM AND

1531: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1532: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1533:
1534: BEGIN
1535: IF (p_performance_measure_id <> FND_API.G_MISS_NUM AND
1536: p_source <> FND_API.G_MISS_CHAR) THEN
1537: OPEN c_perf_dim_src;
1538: FETCH c_perf_dim_src INTO l_sequence_no;
1539: CLOSE c_perf_dim_src;

Line 1536: p_source <> FND_API.G_MISS_CHAR) THEN

1532: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1533:
1534: BEGIN
1535: IF (p_performance_measure_id <> FND_API.G_MISS_NUM AND
1536: p_source <> FND_API.G_MISS_CHAR) THEN
1537: OPEN c_perf_dim_src;
1538: FETCH c_perf_dim_src INTO l_sequence_no;
1539: CLOSE c_perf_dim_src;
1540: x_sequence_no := l_sequence_no;

Line 1541: ELSIF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN

1537: OPEN c_perf_dim_src;
1538: FETCH c_perf_dim_src INTO l_sequence_no;
1539: CLOSE c_perf_dim_src;
1540: x_sequence_no := l_sequence_no;
1541: ELSIF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN
1542: OPEN c_perf_dim;
1543: FETCH c_perf_dim INTO l_sequence_no;
1544: CLOSE c_perf_dim;
1545: x_sequence_no := l_sequence_no;

Line 1548: IF (p_target_level_id <> FND_API.G_MISS_NUM) THEN

1544: CLOSE c_perf_dim;
1545: x_sequence_no := l_sequence_no;
1546: END IF;
1547:
1548: IF (p_target_level_id <> FND_API.G_MISS_NUM) THEN
1549: OPEN c_dim;
1550: FETCH c_dim INTO l_sequence_no
1551: ,l_Dimension1_level_id, l_dimension1_level_short_name,l_Dimension1_level_name
1552: ,l_Dimension2_level_id, l_dimension2_level_short_name,l_Dimension2_level_name

Line 1598: WHEN FND_API.G_EXC_ERROR THEN

1594: x_dim_level_name := l_dimension7_level_name;
1595: END IF;
1596: END IF;
1597: EXCEPTION
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: IF c_perf_dim_src%ISOPEN THEN -- bug 3045087
1600: CLOSE c_perf_dim_src;
1601: END IF;
1602: IF c_perf_dim%ISOPEN THEN

Line 1608: x_return_status := FND_API.G_RET_STS_ERROR;

1604: END IF;
1605: IF c_dim%ISOPEN THEN
1606: CLOSE c_dim;
1607: END IF;
1608: x_return_status := FND_API.G_RET_STS_ERROR;
1609: l_error_Tbl_p := x_error_Tbl;
1610: BIS_UTILITIES_PVT.Add_Error_Message
1611: ( p_error_table => l_error_Tbl_p
1612: , p_error_msg_id => SQLCODE

Line 1616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1612: , p_error_msg_id => SQLCODE
1613: , p_error_description => SQLERRM
1614: , x_error_table => x_error_Tbl
1615: );
1616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1617: IF c_perf_dim_src%ISOPEN THEN
1618: CLOSE c_perf_dim_src;
1619: END IF;
1620: IF c_perf_dim%ISOPEN THEN

Line 1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1622: END IF;
1623: IF c_dim%ISOPEN THEN
1624: CLOSE c_dim;
1625: END IF;
1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1627: l_error_Tbl_p := x_error_Tbl;
1628: BIS_UTILITIES_PVT.Add_Error_Message
1629: ( p_error_table => l_error_Tbl_p
1630: , p_error_msg_id => SQLCODE

Line 1644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1640: END IF;
1641: IF c_dim%ISOPEN THEN
1642: CLOSE c_dim;
1643: END IF;
1644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1645: l_error_Tbl_p := x_error_Tbl;
1646: BIS_UTILITIES_PVT.Add_Error_Message
1647: ( p_error_table => l_error_Tbl_p
1648: , p_error_msg_id => SQLCODE

Line 1713: IF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN

1709: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
1710: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1711:
1712: BEGIN
1713: IF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN
1714: OPEN c_perf_dim;
1715: FETCH c_perf_dim INTO l_sequence_no;
1716: CLOSE c_perf_dim;
1717: x_sequence_no := l_sequence_no;

Line 1719: IF (p_target_level_id <> FND_API.G_MISS_NUM) THEN

1715: FETCH c_perf_dim INTO l_sequence_no;
1716: CLOSE c_perf_dim;
1717: x_sequence_no := l_sequence_no;
1718: END IF;
1719: IF (p_target_level_id <> FND_API.G_MISS_NUM) THEN
1720: OPEN c_dim;
1721: FETCH c_dim INTO l_sequence_no
1722: ,l_Dimension1_level_id, l_dimension1_level_short_name,l_Dimension1_level_name
1723: ,l_Dimension2_level_id, l_dimension2_level_short_name,l_Dimension2_level_name

Line 1768: WHEN FND_API.G_EXC_ERROR THEN

1764: x_dim_level_name := l_dimension7_level_name;
1765: END IF;
1766: END IF;
1767: EXCEPTION
1768: WHEN FND_API.G_EXC_ERROR THEN
1769: IF c_perf_dim%ISOPEN THEN -- bug 3045087
1770: CLOSE c_perf_dim;
1771: END IF;
1772: IF c_dim%ISOPEN THEN

Line 1775: x_return_status := FND_API.G_RET_STS_ERROR;

1771: END IF;
1772: IF c_dim%ISOPEN THEN
1773: CLOSE c_dim;
1774: END IF;
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777: IF c_perf_dim%ISOPEN THEN -- bug 3045087
1778: CLOSE c_perf_dim;
1779: END IF;

Line 1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1772: IF c_dim%ISOPEN THEN
1773: CLOSE c_dim;
1774: END IF;
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777: IF c_perf_dim%ISOPEN THEN -- bug 3045087
1778: CLOSE c_perf_dim;
1779: END IF;
1780: IF c_dim%ISOPEN THEN

Line 1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1779: END IF;
1780: IF c_dim%ISOPEN THEN
1781: CLOSE c_dim;
1782: END IF;
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: WHEN OTHERS THEN
1785: IF c_perf_dim%ISOPEN THEN -- bug 3045087
1786: CLOSE c_perf_dim;
1787: END IF;

Line 1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1787: END IF;
1788: IF c_dim%ISOPEN THEN
1789: CLOSE c_dim;
1790: END IF;
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1792: END;
1793: --
1794: PROCEDURE GET_ORG_LEVEL_ID
1795: (p_performance_measure_id IN NUMBER DEFAULT BIS_UTILITIES_PUB.G_NULL_NUM

Line 1861: IF (p_performance_measure_id <> FND_API.G_MISS_NUM

1857: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
1858: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1859:
1860: BEGIN
1861: IF (p_performance_measure_id <> FND_API.G_MISS_NUM
1862: AND p_source <> FND_API.G_MISS_CHAR) THEN
1863: OPEN c_perf_dim_src;
1864: FETCH c_perf_dim_src INTO l_sequence_no;
1865: CLOSE c_perf_dim_src;

Line 1862: AND p_source <> FND_API.G_MISS_CHAR) THEN

1858: l_error_Tbl_p BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
1859:
1860: BEGIN
1861: IF (p_performance_measure_id <> FND_API.G_MISS_NUM
1862: AND p_source <> FND_API.G_MISS_CHAR) THEN
1863: OPEN c_perf_dim_src;
1864: FETCH c_perf_dim_src INTO l_sequence_no;
1865: CLOSE c_perf_dim_src;
1866: x_sequence_no := l_sequence_no;

Line 1867: ELSIF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN

1863: OPEN c_perf_dim_src;
1864: FETCH c_perf_dim_src INTO l_sequence_no;
1865: CLOSE c_perf_dim_src;
1866: x_sequence_no := l_sequence_no;
1867: ELSIF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN
1868: OPEN c_perf_dim;
1869: FETCH c_perf_dim INTO l_sequence_no;
1870: CLOSE c_perf_dim;
1871: x_sequence_no := l_sequence_no;

Line 1874: IF (p_target_level_id <> FND_API.G_MISS_NUM) THEN

1870: CLOSE c_perf_dim;
1871: x_sequence_no := l_sequence_no;
1872: END IF;
1873:
1874: IF (p_target_level_id <> FND_API.G_MISS_NUM) THEN
1875: OPEN c_dim;
1876: FETCH c_dim INTO l_sequence_no
1877: ,l_Dimension1_level_id, l_dimension1_level_short_name,l_Dimension1_level_name
1878: ,l_Dimension2_level_id, l_dimension2_level_short_name,l_Dimension2_level_name

Line 1924: WHEN FND_API.G_EXC_ERROR THEN

1920: x_dim_level_name := l_dimension7_level_name;
1921: END IF;
1922: END IF;
1923: EXCEPTION
1924: WHEN FND_API.G_EXC_ERROR THEN
1925: IF c_perf_dim_src%ISOPEN THEN -- bug 3045087
1926: CLOSE c_perf_dim_src;
1927: END IF;
1928: IF c_perf_dim%ISOPEN THEN -- bug 3045087

Line 1934: x_return_status := FND_API.G_RET_STS_ERROR;

1930: END IF;
1931: IF c_dim%ISOPEN THEN -- bug 3045087
1932: CLOSE c_dim;
1933: END IF;
1934: x_return_status := FND_API.G_RET_STS_ERROR;
1935: l_error_Tbl_p := x_error_Tbl;
1936: BIS_UTILITIES_PVT.Add_Error_Message
1937: ( p_error_table => l_error_Tbl_p
1938: , p_error_msg_id => SQLCODE

Line 1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1938: , p_error_msg_id => SQLCODE
1939: , p_error_description => SQLERRM
1940: , x_error_table => x_error_Tbl
1941: );
1942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1943: IF c_perf_dim_src%ISOPEN THEN -- bug 3045087
1944: CLOSE c_perf_dim_src;
1945: END IF;
1946: IF c_perf_dim%ISOPEN THEN -- bug 3045087

Line 1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1948: END IF;
1949: IF c_dim%ISOPEN THEN -- bug 3045087
1950: CLOSE c_dim;
1951: END IF;
1952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1953: l_error_Tbl_p := x_error_Tbl;
1954: BIS_UTILITIES_PVT.Add_Error_Message
1955: ( p_error_table => l_error_Tbl_p
1956: , p_error_msg_id => SQLCODE

Line 1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1966: END IF;
1967: IF c_dim%ISOPEN THEN -- bug 3045087
1968: CLOSE c_dim;
1969: END IF;
1970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1971: l_error_Tbl_p := x_error_Tbl;
1972: BIS_UTILITIES_PVT.Add_Error_Message
1973: ( p_error_table => l_error_Tbl_p
1974: , p_error_msg_id => SQLCODE

Line 2041: IF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN

2037: l_dimension7_level_short_name BISFV_TARGET_LEVELS.dimension7_level_short_name%TYPE;
2038: l_dimension7_level_name BISFV_TARGET_LEVELS.dimension7_level_name%TYPE;
2039:
2040: BEGIN
2041: IF (p_performance_measure_id <> FND_API.G_MISS_NUM) THEN
2042: OPEN c_perf_dim;
2043: FETCH c_perf_dim INTO l_sequence_no;
2044: CLOSE c_perf_dim;
2045: x_sequence_no := l_sequence_no;

Line 2047: IF (p_target_level_id <> FND_API.G_MISS_NUM) THEN

2043: FETCH c_perf_dim INTO l_sequence_no;
2044: CLOSE c_perf_dim;
2045: x_sequence_no := l_sequence_no;
2046: END IF;
2047: IF (p_target_level_id <> FND_API.G_MISS_NUM) THEN
2048: OPEN c_dim;
2049: FETCH c_dim INTO l_sequence_no
2050: ,l_Dimension1_level_id, l_dimension1_level_short_name,l_Dimension1_level_name
2051: ,l_Dimension2_level_id, l_dimension2_level_short_name,l_Dimension2_level_name

Line 2096: WHEN FND_API.G_EXC_ERROR THEN

2092: x_dim_level_name := l_dimension7_level_name;
2093: END IF;
2094: END IF;
2095: EXCEPTION
2096: WHEN FND_API.G_EXC_ERROR THEN
2097: IF c_perf_dim%ISOPEN THEN -- bug 3045087
2098: CLOSE c_perf_dim;
2099: END IF;
2100: IF c_dim%ISOPEN THEN -- bug 3045087

Line 2103: x_return_status := FND_API.G_RET_STS_ERROR;

2099: END IF;
2100: IF c_dim%ISOPEN THEN -- bug 3045087
2101: CLOSE c_dim;
2102: END IF;
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2105: IF c_perf_dim%ISOPEN THEN -- bug 3045087
2106: CLOSE c_perf_dim;
2107: END IF;

Line 2104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2100: IF c_dim%ISOPEN THEN -- bug 3045087
2101: CLOSE c_dim;
2102: END IF;
2103: x_return_status := FND_API.G_RET_STS_ERROR;
2104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2105: IF c_perf_dim%ISOPEN THEN -- bug 3045087
2106: CLOSE c_perf_dim;
2107: END IF;
2108: IF c_dim%ISOPEN THEN -- bug 3045087

Line 2111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2107: END IF;
2108: IF c_dim%ISOPEN THEN -- bug 3045087
2109: CLOSE c_dim;
2110: END IF;
2111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2112: WHEN OTHERS THEN
2113: IF c_perf_dim%ISOPEN THEN -- bug 3045087
2114: CLOSE c_perf_dim;
2115: END IF;

Line 2119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2115: END IF;
2116: IF c_dim%ISOPEN THEN -- bug 3045087
2117: CLOSE c_dim;
2118: END IF;
2119: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2120: END;
2121:
2122:
2123: PROCEDURE ADD_TO_FND_MSG_STACK

Line 2588: RAISE FND_API.G_EXC_ERROR;

2584: IF (l_target_level_rec.target_level_id IS NULL)
2585: THEN
2586: FND_MESSAGE.SET_NAME('BIS','BIS_NO_DLC_ACCESS');
2587: FND_MSG_PUB.ADD;
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590: IF (l_return_Status <> FND_API.G_RET_STS_ERROR) THEN
2591: --Check if the user has access to set the target . IF not throw him/her/it back to the
2592: --Reports Page

Line 2590: IF (l_return_Status <> FND_API.G_RET_STS_ERROR) THEN

2586: FND_MESSAGE.SET_NAME('BIS','BIS_NO_DLC_ACCESS');
2587: FND_MSG_PUB.ADD;
2588: RAISE FND_API.G_EXC_ERROR;
2589: END IF;
2590: IF (l_return_Status <> FND_API.G_RET_STS_ERROR) THEN
2591: --Check if the user has access to set the target . IF not throw him/her/it back to the
2592: --Reports Page
2593: l_dlc_sec := 'N';
2594: FOR c_rec IN c_resp LOOP

Line 2604: IF (l_return_status <> FND_API.G_RET_STS_ERROR) THEN

2600: ,p_Measure_Security_Rec => l_measure_security_rec
2601: ,x_return_status => l_return_status
2602: ,x_error_Tbl => l_error_tbl
2603: );
2604: IF (l_return_status <> FND_API.G_RET_STS_ERROR) THEN
2605: l_dlc_sec := 'Y';
2606: EXIT;
2607: END IF;
2608: */

Line 2620: RAISE FND_API.G_EXC_ERROR;

2616: END LOOP;
2617: IF (l_dlc_sec = 'N') THEN
2618: FND_MESSAGE.SET_NAME('BIS', 'BIS_NO_SECURITY_ACCESS');
2619: FND_MSG_PUB.ADD;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622: x_measure_name := BIS_UTILITIES_PVT.checkmisschar(l_target_level_Rec.measure_name);
2623: x_measure_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.measure_id);
2624: x_target_level_id := BIS_UTILITIES_PVT.checkmissnum(l_target_level_rec.target_level_id);

Line 2750: WHEN FND_API.G_EXC_ERROR THEN

2746: );
2747: END IF;
2748: EXCEPTION
2749:
2750: WHEN FND_API.G_EXC_ERROR THEN
2751: IF c_dim_lvl%ISOPEN THEN -- bug 3045087
2752: CLOSE c_dim_lvl;
2753: END IF;
2754: IF c_resp%ISOPEN THEN -- bug 3045087

Line 2760: x_return_status := FND_API.G_RET_STS_ERROR;

2756: END IF;
2757: IF c_indresp%ISOPEN THEN -- bug 3045087
2758: CLOSE c_indresp;
2759: END IF;
2760: x_return_status := FND_API.G_RET_STS_ERROR;
2761: FND_MSG_PUB.Count_And_Get
2762: ( p_count => x_msg_count,
2763: p_data => x_msg_data
2764: );

Line 2766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2762: ( p_count => x_msg_count,
2763: p_data => x_msg_data
2764: );
2765:
2766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2767: IF c_dim_lvl%ISOPEN THEN -- bug 3045087
2768: CLOSE c_dim_lvl;
2769: END IF;
2770: IF c_resp%ISOPEN THEN -- bug 3045087

Line 2776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2772: END IF;
2773: IF c_indresp%ISOPEN THEN -- bug 3045087
2774: CLOSE c_indresp;
2775: END IF;
2776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2777: FND_MSG_PUB.Count_And_Get
2778: ( p_count => x_msg_count,
2779: p_data => x_msg_data
2780: );

Line 2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2787: END IF;
2788: IF c_indresp%ISOPEN THEN -- bug 3045087
2789: CLOSE c_indresp;
2790: END IF;
2791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2792: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2793: THEN
2794: FND_MSG_PUB.Add_Exc_Msg
2795: ( G_PKG_NAME,

Line 2825: IF (BIS_UTILITIES_PUB.VALUE_MISSING(p_target_level_id) = FND_API.G_FALSE) THEN

2821: BEGIN
2822: FND_MSG_PUB.initialize;
2823: -- Delete all responsibility associated with this target level
2824:
2825: IF (BIS_UTILITIES_PUB.VALUE_MISSING(p_target_level_id) = FND_API.G_FALSE) THEN
2826: l_target_level_rec.target_level_id := p_target_level_id;
2827: l_measure_security_rec.target_level_id := p_target_level_id;
2828: END IF;
2829:

Line 2833: p_commit => FND_API.G_FALSE,

2829:
2830: BIS_MEASURE_SECURITY_PVT.DELETE_MEASURE_SECURITY
2831: (
2832: p_api_version => g_api_version,
2833: p_commit => FND_API.G_FALSE,
2834: p_target_level_rec => l_target_level_rec,
2835: x_return_status => l_return_status,
2836: x_error_tbl => l_error_tbl
2837: );

Line 2862: IF (BIS_UTILITIES_PUB.VALUE_MISSING(l_responsibility_id) = FND_API.G_FALSE) THEN

2858: l_responsibility_id := l_responsibilities;
2859: l_responsibilities := '';
2860: END IF;
2861:
2862: IF (BIS_UTILITIES_PUB.VALUE_MISSING(l_responsibility_id) = FND_API.G_FALSE) THEN
2863: l_measure_security_rec.responsibility_id := l_responsibility_id;
2864:
2865: BIS_MEASURE_SECURITY_PVT.Create_Measure_Security
2866: (

Line 2868: p_commit => FND_API.G_FALSE,

2864:
2865: BIS_MEASURE_SECURITY_PVT.Create_Measure_Security
2866: (
2867: p_api_version => g_api_version,
2868: p_commit => FND_API.G_FALSE,
2869: p_measure_security_rec => l_measure_security_rec,
2870: x_return_status => l_return_status,
2871: x_error_tbl => l_error_tbl
2872: );

Line 2904: IF (BIS_UTILITIES_PUB.VALUE_MISSING(p_target_level_id) = FND_API.G_FALSE) THEN

2900: l_error_tbl BIS_UTILITIES_PUB.ERROR_TBL_TYPE;
2901: l_names VARCHAR2(32000) := '';
2902: l_sep VARCHAR2(2) := '';
2903: BEGIN
2904: IF (BIS_UTILITIES_PUB.VALUE_MISSING(p_target_level_id) = FND_API.G_FALSE) THEN
2905: l_target_level_rec.target_level_id := p_target_level_id;
2906: END IF;
2907:
2908: l_target_level_rec_p := l_target_level_rec;

Line 2913: p_all_info => FND_API.G_TRUE,

2909: BIS_TARGET_LEVEL_PUB.RETRIEVE_TARGET_LEVEL
2910: (
2911: p_api_version => g_api_version,
2912: p_target_level_rec => l_target_level_rec_p,
2913: p_all_info => FND_API.G_TRUE,
2914: x_Target_Level_Rec => l_target_level_rec,
2915: x_return_status => x_return_status,
2916: x_error_Tbl => l_error_tbl
2917: );

Line 2927: IF l_target_level_rec.dimension1_level_name <> FND_API.G_MISS_CHAR THEN

2923: x_msg_count => x_msg_count,
2924: x_msg_data => x_msg_data
2925: );
2926:
2927: IF l_target_level_rec.dimension1_level_name <> FND_API.G_MISS_CHAR THEN
2928: l_names := l_names || l_sep || l_target_level_rec.dimension1_level_name;
2929: l_sep := ', ';
2930: END IF;
2931:

Line 2932: IF l_target_level_rec.dimension2_level_name <> FND_API.G_MISS_CHAR THEN

2928: l_names := l_names || l_sep || l_target_level_rec.dimension1_level_name;
2929: l_sep := ', ';
2930: END IF;
2931:
2932: IF l_target_level_rec.dimension2_level_name <> FND_API.G_MISS_CHAR THEN
2933: l_names := l_names || l_sep || l_target_level_rec.dimension2_level_name;
2934: l_sep := ', ';
2935: END IF;
2936:

Line 2937: IF l_target_level_rec.dimension3_level_name <> FND_API.G_MISS_CHAR THEN

2933: l_names := l_names || l_sep || l_target_level_rec.dimension2_level_name;
2934: l_sep := ', ';
2935: END IF;
2936:
2937: IF l_target_level_rec.dimension3_level_name <> FND_API.G_MISS_CHAR THEN
2938: l_names := l_names || l_sep || l_target_level_rec.dimension3_level_name;
2939: l_sep := ', ';
2940: END IF;
2941:

Line 2942: IF l_target_level_rec.dimension4_level_name <> FND_API.G_MISS_CHAR THEN

2938: l_names := l_names || l_sep || l_target_level_rec.dimension3_level_name;
2939: l_sep := ', ';
2940: END IF;
2941:
2942: IF l_target_level_rec.dimension4_level_name <> FND_API.G_MISS_CHAR THEN
2943: l_names := l_names || l_sep || l_target_level_rec.dimension4_level_name;
2944: l_sep := ', ';
2945: END IF;
2946:

Line 2947: IF l_target_level_rec.dimension5_level_name <> FND_API.G_MISS_CHAR THEN

2943: l_names := l_names || l_sep || l_target_level_rec.dimension4_level_name;
2944: l_sep := ', ';
2945: END IF;
2946:
2947: IF l_target_level_rec.dimension5_level_name <> FND_API.G_MISS_CHAR THEN
2948: l_names := l_names || l_sep || l_target_level_rec.dimension5_level_name;
2949: l_sep := ', ';
2950: END IF;
2951:

Line 2952: IF l_target_level_rec.dimension6_level_name <> FND_API.G_MISS_CHAR THEN

2948: l_names := l_names || l_sep || l_target_level_rec.dimension5_level_name;
2949: l_sep := ', ';
2950: END IF;
2951:
2952: IF l_target_level_rec.dimension6_level_name <> FND_API.G_MISS_CHAR THEN
2953: l_names := l_names || l_sep || l_target_level_rec.dimension6_level_name;
2954: l_sep := ', ';
2955: END IF;
2956:

Line 2957: IF l_target_level_rec.dimension7_level_name <> FND_API.G_MISS_CHAR THEN

2953: l_names := l_names || l_sep || l_target_level_rec.dimension6_level_name;
2954: l_sep := ', ';
2955: END IF;
2956:
2957: IF l_target_level_rec.dimension7_level_name <> FND_API.G_MISS_CHAR THEN
2958: l_names := l_names || l_sep || l_target_level_rec.dimension7_level_name;
2959: l_sep := ', ';
2960: END IF;
2961:

Line 3163: IF (l_ret = FND_API.G_FALSE) THEN

3159: Begin
3160:
3161: FND_MSG_PUB.initialize;
3162: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Id);
3163: IF (l_ret = FND_API.G_FALSE) THEN
3164: l_measure_rec.Measure_Id := p_Measure_Id;
3165: END IF;
3166:
3167: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);

Line 3168: IF (l_ret = FND_API.G_FALSE) THEN

3164: l_measure_rec.Measure_Id := p_Measure_Id;
3165: END IF;
3166:
3167: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Short_Name);
3168: IF (l_ret = FND_API.G_FALSE) THEN
3169: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
3170: END IF;
3171:
3172: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Name);

Line 3173: IF (l_ret = FND_API.G_FALSE) THEN

3169: l_measure_rec.Measure_Short_Name := p_Measure_Short_Name;
3170: END IF;
3171:
3172: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Measure_Name);
3173: IF (l_ret = FND_API.G_FALSE) THEN
3174: l_measure_rec.Measure_Name := p_Measure_Name;
3175: END IF;
3176:
3177: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Description);

Line 3178: IF (l_ret = FND_API.G_FALSE) THEN

3174: l_measure_rec.Measure_Name := p_Measure_Name;
3175: END IF;
3176:
3177: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Description);
3178: IF (l_ret = FND_API.G_FALSE) THEN
3179: l_measure_rec.Description := p_Description;
3180: END IF;
3181:
3182: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension1_ID);

Line 3183: IF (l_ret = FND_API.G_FALSE) THEN

3179: l_measure_rec.Description := p_Description;
3180: END IF;
3181:
3182: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension1_ID);
3183: IF (l_ret = FND_API.G_FALSE) THEN
3184: l_measure_rec.Dimension1_ID := p_Dimension1_ID;
3185: END IF;
3186:
3187: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension2_ID);

Line 3188: IF (l_ret = FND_API.G_FALSE) THEN

3184: l_measure_rec.Dimension1_ID := p_Dimension1_ID;
3185: END IF;
3186:
3187: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension2_ID);
3188: IF (l_ret = FND_API.G_FALSE) THEN
3189: l_measure_rec.Dimension2_ID := p_Dimension2_ID;
3190: END IF;
3191:
3192: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension3_ID);

Line 3193: IF (l_ret = FND_API.G_FALSE) THEN

3189: l_measure_rec.Dimension2_ID := p_Dimension2_ID;
3190: END IF;
3191:
3192: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension3_ID);
3193: IF (l_ret = FND_API.G_FALSE) THEN
3194: l_measure_rec.Dimension3_ID := p_Dimension3_ID;
3195: END IF;
3196:
3197: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension4_ID);

Line 3198: IF (l_ret = FND_API.G_FALSE) THEN

3194: l_measure_rec.Dimension3_ID := p_Dimension3_ID;
3195: END IF;
3196:
3197: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension4_ID);
3198: IF (l_ret = FND_API.G_FALSE) THEN
3199: l_measure_rec.Dimension4_ID := p_Dimension4_ID;
3200: END IF;
3201:
3202: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension5_ID);

Line 3203: IF (l_ret = FND_API.G_FALSE) THEN

3199: l_measure_rec.Dimension4_ID := p_Dimension4_ID;
3200: END IF;
3201:
3202: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension5_ID);
3203: IF (l_ret = FND_API.G_FALSE) THEN
3204: l_measure_rec.Dimension5_ID := p_Dimension5_ID;
3205: END IF;
3206:
3207: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension6_ID);

Line 3208: IF (l_ret = FND_API.G_FALSE) THEN

3204: l_measure_rec.Dimension5_ID := p_Dimension5_ID;
3205: END IF;
3206:
3207: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension6_ID);
3208: IF (l_ret = FND_API.G_FALSE) THEN
3209: l_measure_rec.Dimension6_ID := p_Dimension6_ID;
3210: END IF;
3211:
3212: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension7_ID);

Line 3213: IF (l_ret = FND_API.G_FALSE) THEN

3209: l_measure_rec.Dimension6_ID := p_Dimension6_ID;
3210: END IF;
3211:
3212: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Dimension7_ID);
3213: IF (l_ret = FND_API.G_FALSE) THEN
3214: l_measure_rec.Dimension7_ID := p_Dimension7_ID;
3215: END IF;
3216:
3217: -----

Line 3219: IF (l_ret = FND_API.G_FALSE) THEN

3215: END IF;
3216:
3217: -----
3218: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_Unit_Of_Measure_Class);
3219: IF (l_ret = FND_API.G_FALSE) THEN
3220: l_measure_rec.Unit_Of_Measure_Class := p_Unit_Of_Measure_Class;
3221: END IF;
3222:
3223: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source_type);

Line 3224: IF (l_ret = FND_API.G_FALSE) THEN

3220: l_measure_rec.Unit_Of_Measure_Class := p_Unit_Of_Measure_Class;
3221: END IF;
3222:
3223: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source_type);
3224: IF (l_ret = FND_API.G_FALSE) THEN
3225: l_measure_rec.actual_data_source_type := p_actual_data_source_type;
3226: END IF;
3227: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);
3228: IF (l_ret = FND_API.G_FALSE) THEN

Line 3228: IF (l_ret = FND_API.G_FALSE) THEN

3224: IF (l_ret = FND_API.G_FALSE) THEN
3225: l_measure_rec.actual_data_source_type := p_actual_data_source_type;
3226: END IF;
3227: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_actual_data_source);
3228: IF (l_ret = FND_API.G_FALSE) THEN
3229: l_measure_rec.actual_data_source := p_actual_data_source;
3230: END IF;
3231: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);
3232: IF (l_ret = FND_API.G_FALSE) THEN

Line 3232: IF (l_ret = FND_API.G_FALSE) THEN

3228: IF (l_ret = FND_API.G_FALSE) THEN
3229: l_measure_rec.actual_data_source := p_actual_data_source;
3230: END IF;
3231: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_function_name);
3232: IF (l_ret = FND_API.G_FALSE) THEN
3233: l_measure_rec.function_name := p_function_name;
3234: END IF;
3235: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);
3236: IF (l_ret = FND_API.G_FALSE) THEN

Line 3236: IF (l_ret = FND_API.G_FALSE) THEN

3232: IF (l_ret = FND_API.G_FALSE) THEN
3233: l_measure_rec.function_name := p_function_name;
3234: END IF;
3235: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_comparison_source);
3236: IF (l_ret = FND_API.G_FALSE) THEN
3237: l_measure_rec.comparison_source := p_comparison_source;
3238: END IF;
3239: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);
3240: IF (l_ret = FND_API.G_FALSE) THEN

Line 3240: IF (l_ret = FND_API.G_FALSE) THEN

3236: IF (l_ret = FND_API.G_FALSE) THEN
3237: l_measure_rec.comparison_source := p_comparison_source;
3238: END IF;
3239: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_increase_in_measure);
3240: IF (l_ret = FND_API.G_FALSE) THEN
3241: l_measure_rec.increase_in_measure := p_increase_in_measure;
3242: END IF;
3243: --2440739
3244: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_enable_link);

Line 3245: IF (l_ret = FND_API.G_FALSE) THEN

3241: l_measure_rec.increase_in_measure := p_increase_in_measure;
3242: END IF;
3243: --2440739
3244: l_ret := BIS_UTILITIES_PUB.Value_Missing(p_enable_link);
3245: IF (l_ret = FND_API.G_FALSE) THEN
3246: l_measure_rec.increase_in_measure := p_enable_link;
3247: END IF;
3248: --2440739
3249: BIS_MEASURE_PUB.Retrieve_Measure( p_api_version => g_api_version

Line 3251: , p_all_info => fnd_api.G_TRUE

3247: END IF;
3248: --2440739
3249: BIS_MEASURE_PUB.Retrieve_Measure( p_api_version => g_api_version
3250: , p_Measure_Rec => l_measure_rec
3251: , p_all_info => fnd_api.G_TRUE
3252: , x_Measure_Rec => x_measure_rec
3253: , x_return_status => l_return_status
3254: , x_error_Tbl => l_error_tbl
3255: );