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

APPS.BIS_PMF_DATA_SOURCE_PUB dependencies on BIS_UTILITIES_PUB

Line 40: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

36: IS
37: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
38: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
39: l_return_status VARCHAR2(32000);
40: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
41:
42: BEGIN
43:
44: l_target_level_rec := x_target_level_rec;

Line 64: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved target level: '

60: , x_error_Tbl => l_error_Tbl
61: );
62:
63: x_target_level_rec := l_target_level_rec;
64: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved target level: '
65: ||x_target_level_rec.target_level_short_Name);
66:
67: EXCEPTION
68: when FND_API.G_EXC_ERROR then

Line 91: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

87: IS
88: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;
89: l_target_rec_p BIS_TARGET_PUB.Target_Rec_Type;
90: l_return_status VARCHAR2(32000);
91: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
92:
93: BEGIN
94:
95: l_target_rec := x_target_rec;

Line 115: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved target: '||x_target_rec.target);

111: , x_error_Tbl => l_error_Tbl
112: );
113:
114: x_target_rec := l_target_rec;
115: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved target: '||x_target_rec.target);
116:
117: EXCEPTION
118: when FND_API.G_EXC_ERROR then
119: RETURN;

Line 144: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

140:
141: l_Target_owners_rec BIS_TARGET_PUB.Target_Owners_Rec_Type;
142: l_Target_rec BIS_TARGET_PUB.Target_Rec_Type;
143: l_return_status VARCHAR2(32000);
144: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
145:
146: BEGIN
147:
148: l_Target_owners_rec := x_Target_owners_rec;

Line 192: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

188: IS
189:
190: l_actual_rec BIS_ACTUAL_PUB.Actual_Rec_Type;
191: l_return_status VARCHAR2(32000);
192: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
193:
194: BEGIN
195:
196: l_actual_rec := x_actual_rec;

Line 227: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved actual: '||x_actual_rec.actual);

223: ); */
224:
225: x_actual_rec := l_actual_rec;
226:
227: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved actual: '||x_actual_rec.actual);
228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: RETURN;

Line 249: , p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

245: , p_Target_Level_ID IN NUMBER := NULL
246: , p_Plan_ID IN NUMBER := NULL
247: , p_Actual_ID IN NUMBER := NULL
248: , p_Target_ID IN NUMBER := NULL
249: , p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
250: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
251: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
252: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 250: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

246: , p_Plan_ID IN NUMBER := NULL
247: , p_Actual_ID IN NUMBER := NULL
248: , p_Target_ID IN NUMBER := NULL
249: , p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
250: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
251: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
252: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 251: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

247: , p_Actual_ID IN NUMBER := NULL
248: , p_Target_ID IN NUMBER := NULL
249: , p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
250: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
251: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
252: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 252: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

248: , p_Target_ID IN NUMBER := NULL
249: , p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
250: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
251: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
252: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

249: , p_Dimension1_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
250: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
251: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
252: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

250: , p_Dimension1_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
251: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
252: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

251: , p_Dimension2_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
252: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
259: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

252: , p_Dimension2_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
259: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
260: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

253: , p_Dimension3_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
259: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
260: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
261: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

Line 258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

254: , p_Dimension3_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
259: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
260: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
261: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
262: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

Line 259: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

255: , p_Dimension4_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
259: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
260: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
261: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
262: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
263: , x_actual_value OUT NOCOPY NUMBER

Line 260: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

256: , p_Dimension4_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
259: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
260: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
261: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
262: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
263: , x_actual_value OUT NOCOPY NUMBER
264: )

Line 261: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM

257: , p_Dimension5_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
259: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
260: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
261: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
262: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
263: , x_actual_value OUT NOCOPY NUMBER
264: )
265: IS

Line 262: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR

258: , p_Dimension5_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
259: , p_Dimension6_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
260: , p_Dimension6_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
261: , p_Dimension7_Level_ID IN NUMBER := BIS_UTILITIES_PUB.G_NULL_NUM
262: , p_Dimension7_Level_Value_ID IN VARCHAR2 := BIS_UTILITIES_PUB.G_NULL_CHAR
263: , x_actual_value OUT NOCOPY NUMBER
264: )
265: IS
266:

Line 316: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved actual: '||x_actual_value);

312: );
313:
314: x_actual_value := l_actual_rec.actual;
315:
316: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieved actual: '||x_actual_value);
317:
318: EXCEPTION
319: when FND_API.G_EXC_ERROR then
320: RETURN;

Line 382: BIS_UTILITIES_PUB.put_line(p_text =>' ------- Begin log file - Retrieve Target - From Java ------- ');

378: , x_return_status => l_return_status
379: , x_return_msg => l_return_msg
380: ) ;
381:
382: BIS_UTILITIES_PUB.put_line(p_text =>' ------- Begin log file - Retrieve Target - From Java ------- ');
383:
384: -- Form a measure instance record
385: --
386: BIS_PMF_DATA_SOURCE_PVT.Form_Measure_Instance

Line 393: BIS_UTILITIES_PUB.put_line(p_text =>'Target level id: '||l_Measure_Instance.target_level_id);

389: , p_plan_id => p_plan_id
390: , x_measure_instance => l_Measure_Instance
391: );
392:
393: BIS_UTILITIES_PUB.put_line(p_text =>'Target level id: '||l_Measure_Instance.target_level_id);
394: BIS_UTILITIES_PUB.put_line(p_text =>'Measure id: '||l_Measure_Instance.measure_id);
395:
396:
397: -- Form a dimension level value table

Line 394: BIS_UTILITIES_PUB.put_line(p_text =>'Measure id: '||l_Measure_Instance.measure_id);

390: , x_measure_instance => l_Measure_Instance
391: );
392:
393: BIS_UTILITIES_PUB.put_line(p_text =>'Target level id: '||l_Measure_Instance.target_level_id);
394: BIS_UTILITIES_PUB.put_line(p_text =>'Measure id: '||l_Measure_Instance.measure_id);
395:
396:
397: -- Form a dimension level value table
398: --

Line 412: BIS_UTILITIES_PUB.put_line(p_text =>'Dim Level Value ' || i || ': '||l_Dim_Level_Value_Tbl(i).Dimension_Level_Value_ID);

408: , x_Dim_Level_Value_Tbl => l_Dim_Level_Value_Tbl
409: );
410:
411: FOR i IN 1..7 LOOP
412: BIS_UTILITIES_PUB.put_line(p_text =>'Dim Level Value ' || i || ': '||l_Dim_Level_Value_Tbl(i).Dimension_Level_Value_ID);
413: END LOOP;
414:
415:
416: -- Request target information

Line 444: BIS_UTILITIES_PUB.put_line(p_text =>' ------- End log file - Retrieve Target - From Java ------- ');

440: x_notify_resp3_short_name := l_target_Rec.notify_resp3_short_name;
441: x_notify_resp3_name := l_target_Rec.notify_resp3_name;
442:
443:
444: BIS_UTILITIES_PUB.put_line(p_text =>' ------- End log file - Retrieve Target - From Java ------- ');
445:
446: EXCEPTION
447: when FND_API.G_EXC_ERROR then
448: x_return_status := SQLERRM;

Line 489: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

485: ) IS
486: l_actual_rec BIS_ACTUAL_PUB.Actual_Rec_Type;
487: l_msg_count NUMBER;
488: l_msg_data VARCHAR2(32000);
489: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
490: BEGIN
491: l_actual_rec.target_level_id := p_target_level_id;
492: l_actual_rec.Target_Level_Name := p_Target_Level_Name;
493: l_actual_rec.Target_Level_Short_Name := p_Target_Level_Short_Name;

Line 530: BIS_UTILITIES_PUB.put_line(p_text =>'Actual posted: '||x_return_status);

526: , x_msg_data => l_msg_data
527: , x_error_Tbl => l_error_Tbl
528: );
529:
530: BIS_UTILITIES_PUB.put_line(p_text =>'Actual posted: '||x_return_status);
531:
532: END Post_Actual;
533:
534: