163:
164: -- Debugging messages start: --------------------------------------------------
165: /*
166:
167: --htp.print('');
168: --htp.print('');
169: htp.print('' );
170: htp.print('');
171: htp.print('' );
164: -- Debugging messages start: --------------------------------------------------
165: /*
166:
167: --htp.print('');
168: --htp.print('');
169: htp.print('' );
170: htp.print('');
171: htp.print('' );
172: htp.print('' );
165: /*
166:
167: --htp.print('');
168: --htp.print('');
169: htp.print('' );
170: htp.print('');
171: htp.print('' );
172: htp.print('' );
173: htp.print('' );
166:
167: --htp.print('');
168: --htp.print('');
169: htp.print('' );
170: htp.print('');
171: htp.print('' );
172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
167: --htp.print('');
168: --htp.print('');
169: htp.print('' );
170: htp.print('');
171: htp.print('' );
172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
175: htp.print('' );
168: --htp.print('');
169: htp.print('' );
170: htp.print('');
171: htp.print('' );
172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
175: htp.print('' );
176: htp.print('');
169: htp.print('' );
170: htp.print('');
171: htp.print('' );
172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
175: htp.print('' );
176: htp.print('');
177:
170: htp.print('');
171: htp.print('' );
172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
175: htp.print('' );
176: htp.print('');
177:
178: --*/
171: htp.print('' );
172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
175: htp.print('' );
176: htp.print('');
177:
178: --*/
179: -- Debugging messages end --------------------------------------------------
172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
175: htp.print('' );
176: htp.print('');
177:
178: --*/
179: -- Debugging messages end --------------------------------------------------
180:
217: AND L.DIMENSION7_LEVEL_ID = l_DIMENSION7_LEVEL_ID)
218: OR (l_DIMENSION7_LEVEL_ID IS NULL));
219:
220: exception when others then
221: --htp.print('');
222: --htp.p('');
223: --htp.p('');
224: return null;
225: end;
218: OR (l_DIMENSION7_LEVEL_ID IS NULL));
219:
220: exception when others then
221: --htp.print('');
222: --htp.p('');
223: --htp.p('');
224: return null;
225: end;
226: --*/
219:
220: exception when others then
221: --htp.print('');
222: --htp.p('');
223: --htp.p('');
224: return null;
225: end;
226: --*/
227: --htp.print(' Get_Target_For_Level after query flag');
223: --htp.p('');
224: return null;
225: end;
226: --*/
227: --htp.print(' Get_Target_For_Level after query flag');
228:
229: /*
230: l_Measure_Rec.Measure_Short_Name := p_MEASURE_SHORT_NAME;
231: BIS_MEASURE_PUB.Retrieve_Measure(p_api_version => 1.0,
235: x_return_status => l_Rstatus,
236: x_error_Tbl => l_Error_Tbl);
237:
238: if l_Rstatus = FND_API.G_RET_STS_ERROR then
239: htp.print('error1');
240: else
241: htp.print('m id: '||l_Measure_Rec.Measure_ID);
242: l_Target_Level_Rec.Measure_ID := l_Measure_Rec.Measure_ID;
243: l_Target_Level_Rec.Org_Level_ID := l_ORG_LEVEL_ID;
237:
238: if l_Rstatus = FND_API.G_RET_STS_ERROR then
239: htp.print('error1');
240: else
241: htp.print('m id: '||l_Measure_Rec.Measure_ID);
242: l_Target_Level_Rec.Measure_ID := l_Measure_Rec.Measure_ID;
243: l_Target_Level_Rec.Org_Level_ID := l_ORG_LEVEL_ID;
244: l_Target_Level_Rec.Time_Level_ID := l_TIME_LEVEL_ID;
245: l_Target_Level_Rec.Dimension1_Level_ID := l_DIMENSION1_LEVEL_ID;
254: x_Target_Level_Rec => l_Target_Level_Rec,
255: x_return_status => l_Rstatus,
256: x_error_Tbl => l_Error_Tbl);
257: if l_Rstatus = FND_API.G_RET_STS_ERROR then
258: htp.print('error2');
259: else
260:
261: l_target_level := l_Target_Level_Rec.Target_Level_ID;
262: MEASURE_SHORT_NAME := l_Measure_Rec.Measure_Short_Name;
266: */
267:
268: -- Debugging messages: --------------------------------------------------
269: /*
270: htp.print('' );
271: htp.print('' );
272: htp.print('' );
273: --*/
274:
267:
268: -- Debugging messages: --------------------------------------------------
269: /*
270: htp.print('' );
271: htp.print('' );
272: htp.print('' );
273: --*/
274:
275: l_target := Get_Target_Value( l_TARGET_LEVEL
268: -- Debugging messages: --------------------------------------------------
269: /*
270: htp.print('' );
271: htp.print('' );
272: htp.print('' );
273: --*/
274:
275: l_target := Get_Target_Value( l_TARGET_LEVEL
276: --, p_ORG_LEVEL_VALUE
320:
321: -- Debugging messages start: --------------------------------------------------
322: /*
323:
324: htp.print('' );
325: --htp.print('' );
326: --htp.print('' );
327: htp.print('' );
328: htp.print('' );
321: -- Debugging messages start: --------------------------------------------------
322: /*
323:
324: htp.print('' );
325: --htp.print('' );
326: --htp.print('' );
327: htp.print('' );
328: htp.print('' );
329: htp.print('' );
322: /*
323:
324: htp.print('' );
325: --htp.print('' );
326: --htp.print('' );
327: htp.print('' );
328: htp.print('' );
329: htp.print('' );
330: htp.print('' );
323:
324: htp.print('' );
325: --htp.print('' );
326: --htp.print('' );
327: htp.print('' );
328: htp.print('' );
329: htp.print('' );
330: htp.print('' );
331: htp.print('');
324: htp.print('' );
325: --htp.print('' );
326: --htp.print('' );
327: htp.print('' );
328: htp.print('' );
329: htp.print('' );
330: htp.print('' );
331: htp.print('');
332: htp.print('' );
325: --htp.print('' );
326: --htp.print('' );
327: htp.print('' );
328: htp.print('' );
329: htp.print('' );
330: htp.print('' );
331: htp.print('');
332: htp.print('' );
333: htp.print('');
326: --htp.print('' );
327: htp.print('' );
328: htp.print('' );
329: htp.print('' );
330: htp.print('' );
331: htp.print('');
332: htp.print('' );
333: htp.print('');
334: htp.print('' );
327: htp.print('' );
328: htp.print('' );
329: htp.print('' );
330: htp.print('' );
331: htp.print('');
332: htp.print('' );
333: htp.print('');
334: htp.print('' );
335: --*/
328: htp.print('' );
329: htp.print('' );
330: htp.print('' );
331: htp.print('');
332: htp.print('' );
333: htp.print('');
334: htp.print('' );
335: --*/
336: -- Debugging messages end ----------------------------------------------------
329: htp.print('' );
330: htp.print('' );
331: htp.print('');
332: htp.print('' );
333: htp.print('');
334: htp.print('' );
335: --*/
336: -- Debugging messages end ----------------------------------------------------
337:
330: htp.print('' );
331: htp.print('');
332: htp.print('' );
333: htp.print('');
334: htp.print('' );
335: --*/
336: -- Debugging messages end ----------------------------------------------------
337:
338: -- dmarkman 07/20 do 'select' on BISBV_TARGETS instead of BIS_TRAGET_VALUES
403: end if;
404: --*/
405:
406:
407: --htp.print('');
408:
409: return 'T_' || l_target || '_' || v_range1_low || '_' || v_range1_high;
410:
411: EXCEPTION
427: Return NULL ;
428: Else
429:
430: -- Debugging messages: --------------------------------------------------
431: -- htp.br;
432: -- htp.print('FUNCTION Get_LEVEL_ID p_Level_Short_Name: ' || p_Level_Short_Name);
433: -- htp.br;
434:
435: /*
428: Else
429:
430: -- Debugging messages: --------------------------------------------------
431: -- htp.br;
432: -- htp.print('FUNCTION Get_LEVEL_ID p_Level_Short_Name: ' || p_Level_Short_Name);
433: -- htp.br;
434:
435: /*
436: Select LEVEL_ID
429:
430: -- Debugging messages: --------------------------------------------------
431: -- htp.br;
432: -- htp.print('FUNCTION Get_LEVEL_ID p_Level_Short_Name: ' || p_Level_Short_Name);
433: -- htp.br;
434:
435: /*
436: Select LEVEL_ID
437: Into l_level_id
460: l_level_id := l_Level_Rec.Dimension_Level_ID;
461: end if;
462: --*/
463:
464: -- htp.print('l_level_id : ' || l_level_id);
465:
466: Return l_level_id ;
467: End If ;
468: EXCEPTION
1050: l_VIEWBY_LEVEL_ID NUMBER;
1051:
1052: Begin
1053:
1054: --htp.print ('I Value : ' || pDimension1LevelValue || pDimension1);
1055:
1056: if pDimension1 is not null then
1057: if pDimension1LevelValue = gvAll then
1058: vDimension1Level := 'TOTAL ' || pDimension1;
1297: );
1298:
1299: if v_return_status = FND_API.G_RET_STS_ERROR then
1300: for i in 1..v_msg_count loop
1301: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
1302: htp.br;
1303: end loop;
1304: end if;
1305:
1298:
1299: if v_return_status = FND_API.G_RET_STS_ERROR then
1300: for i in 1..v_msg_count loop
1301: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
1302: htp.br;
1303: end loop;
1304: end if;
1305:
1306: vSql := 'select '||v_id_name||' from '||v_table;