DBA Data[Home] [Help]

APPS.BISVIEWER_PMF dependencies on HTP

Line 167: --htp.print('');

163:
164: -- Debugging messages start: --------------------------------------------------
165: /*
166:
167: --htp.print('');
168: --htp.print('');
169: htp.print('' );
170: htp.print('');
171: htp.print('' );

Line 168: --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('' );

Line 169: 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('' );

Line 170: 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('' );

Line 171: 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('' );

Line 172: 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('');

Line 173: 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:

Line 174: htp.print('' );

170: htp.print('');
171: htp.print('' );
172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
175: htp.print('' );
176: htp.print('');
177:
178: --*/

Line 175: htp.print('' );

171: htp.print('' );
172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
175: htp.print('' );
176: htp.print('');
177:
178: --*/
179: -- Debugging messages end --------------------------------------------------

Line 176: htp.print('');

172: htp.print('' );
173: htp.print('' );
174: htp.print('' );
175: htp.print('' );
176: htp.print('');
177:
178: --*/
179: -- Debugging messages end --------------------------------------------------
180:

Line 221: --htp.print('');

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;

Line 222: --htp.p('');

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: --*/

Line 223: --htp.p('');

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');

Line 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,

Line 239: htp.print('error1');

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;

Line 241: htp.print('m id: '||l_Measure_Rec.Measure_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;

Line 258: htp.print('error2');

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;

Line 270: htp.print('' );

266: */
267:
268: -- Debugging messages: --------------------------------------------------
269: /*
270: htp.print('' );
271: htp.print('' );
272: htp.print('' );
273: --*/
274:

Line 271: htp.print('' );

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

Line 272: htp.print('' );

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

Line 324: htp.print('' );

320:
321: -- Debugging messages start: --------------------------------------------------
322: /*
323:
324: htp.print('' );
325: --htp.print('' );
326: --htp.print('' );
327: htp.print('' );
328: htp.print('' );

Line 325: --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('' );

Line 326: --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('' );

Line 327: 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('');

Line 328: 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('' );

Line 329: 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('');

Line 330: 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('' );

Line 331: 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: --*/

Line 332: htp.print('' );

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 ----------------------------------------------------

Line 333: 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 ----------------------------------------------------
337:

Line 334: htp.print('' );

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

Line 407: --htp.print('');

403: end if;
404: --*/
405:
406:
407: --htp.print('');
408:
409: return 'T_' || l_target || '_' || v_range1_low || '_' || v_range1_high;
410:
411: EXCEPTION

Line 431: -- htp.br;

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: /*

Line 432: -- htp.print('FUNCTION Get_LEVEL_ID p_Level_Short_Name: ' || p_Level_Short_Name);

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

Line 433: -- htp.br;

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

Line 464: -- htp.print('l_level_id : ' || 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

Line 1054: --htp.print ('I Value : ' || pDimension1LevelValue || pDimension1);

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;

Line 1301: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));

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:

Line 1302: htp.br;

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;