DBA Data[Home] [Help]

APPS.BIS_PMF_DATA_SOURCE_PUB dependencies on FND_API

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

16: REM | HISTORY |
17: REM | APR-2000 irchen Creation |
18: REM | 27-JAN-03 arhegde For having different local variables for IN and OUT |
19: REM | parameters (bug#2758428) |
20: REM | 30-JAN-03 sugopal FND_API.G_MISS_xxx should not be used in |
21: REM | initialization or declaration (bug#2774644) |
22: REM | 30-JAN-03 mdamle SONAR Conversion to Java (APIs called from Java) |
23: REM +=======================================================================+
24: */

Line 33: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

29:
30: Procedure Retrieve_Target_Level
31: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
32: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
33: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
34: , x_target_level_rec OUT NOCOPY BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
35: )
36: IS
37: l_target_level_rec BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;

Line 68: when FND_API.G_EXC_ERROR then

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
69: RETURN;
70: when FND_API.G_EXC_UNEXPECTED_ERROR then
71: RETURN;
72: when others then

Line 70: when FND_API.G_EXC_UNEXPECTED_ERROR then

66:
67: EXCEPTION
68: when FND_API.G_EXC_ERROR then
69: RETURN;
70: when FND_API.G_EXC_UNEXPECTED_ERROR then
71: RETURN;
72: when others then
73: BIS_UTILITIES_PVT.Add_Error_Message
74: ( p_error_msg_id => SQLCODE

Line 84: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

80:
81: Procedure Retrieve_Target
82: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
83: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
84: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
85: , x_target_rec OUT NOCOPY BIS_TARGET_PUB.Target_Rec_Type
86: )
87: IS
88: l_target_rec BIS_TARGET_PUB.Target_Rec_Type;

Line 118: when FND_API.G_EXC_ERROR then

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;
120: when FND_API.G_EXC_UNEXPECTED_ERROR then
121: RETURN;
122: when others then

Line 120: when FND_API.G_EXC_UNEXPECTED_ERROR then

116:
117: EXCEPTION
118: when FND_API.G_EXC_ERROR then
119: RETURN;
120: when FND_API.G_EXC_UNEXPECTED_ERROR then
121: RETURN;
122: when others then
123: BIS_UTILITIES_PVT.Add_Error_Message
124: ( p_error_msg_id => SQLCODE

Line 136: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

132: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
133: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
134: , p_alert_type IN VARCHAR2 := NULL
135: , p_alert_level IN VARCHAR2 := NULL
136: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
137: , x_Target_owners_rec OUT NOCOPY BIS_TARGET_PUB.Target_Owners_Rec_Type
138: )
139: IS
140:

Line 168: when FND_API.G_EXC_ERROR then

164:
165: x_Target_owners_rec := l_Target_owners_rec;
166:
167: EXCEPTION
168: when FND_API.G_EXC_ERROR then
169: RETURN;
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: RETURN;
172: when others then

Line 170: when FND_API.G_EXC_UNEXPECTED_ERROR then

166:
167: EXCEPTION
168: when FND_API.G_EXC_ERROR then
169: RETURN;
170: when FND_API.G_EXC_UNEXPECTED_ERROR then
171: RETURN;
172: when others then
173: BIS_UTILITIES_PVT.Add_Error_Message
174: ( p_error_msg_id => SQLCODE

Line 185: , p_all_info IN VARCHAR2 := FND_API.G_TRUE

181:
182: Procedure Retrieve_Actual
183: ( p_measure_instance IN BIS_MEASURE_PUB.Measure_Instance_type
184: , p_dim_level_value_tbl IN BIS_DIM_LEVEL_VALUE_PUB.Dim_Level_Value_Tbl_Type
185: , p_all_info IN VARCHAR2 := FND_API.G_TRUE
186: , x_actual_rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
187: )
188: IS
189:

Line 230: when FND_API.G_EXC_ERROR then

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;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: RETURN;
234: when others then

Line 232: when FND_API.G_EXC_UNEXPECTED_ERROR then

228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: RETURN;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: RETURN;
234: when others then
235: BIS_UTILITIES_PVT.Add_Error_Message
236: ( p_error_msg_id => SQLCODE

Line 310: , p_all_info => FND_API.G_FALSE

306:
307: Retrieve_Actual
308: ( p_measure_instance => l_Measure_Instance
309: , p_dim_level_value_tbl => l_Dim_Level_Value_Tbl
310: , p_all_info => FND_API.G_FALSE
311: , x_actual_rec => l_Actual_Rec
312: );
313:
314: x_actual_value := l_actual_rec.actual;

Line 319: when FND_API.G_EXC_ERROR then

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;
321: when FND_API.G_EXC_UNEXPECTED_ERROR then
322: RETURN;
323: when others then

Line 321: when FND_API.G_EXC_UNEXPECTED_ERROR then

317:
318: EXCEPTION
319: when FND_API.G_EXC_ERROR then
320: RETURN;
321: when FND_API.G_EXC_UNEXPECTED_ERROR then
322: RETURN;
323: when others then
324: BIS_UTILITIES_PVT.Add_Error_Message
325: ( p_error_msg_id => SQLCODE

Line 421: , p_all_info => FND_API.G_FALSE

417: --
418: BIS_PMF_DATA_SOURCE_PUB.Retrieve_Target
419: ( p_measure_instance => l_measure_instance
420: , p_dim_level_value_tbl => l_dim_level_value_tbl
421: , p_all_info => FND_API.G_FALSE
422: , x_target_rec => l_target_rec
423: );
424:
425: x_target_id := l_target_rec.Target_id;

Line 447: when FND_API.G_EXC_ERROR then

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;
449: RETURN;
450: when FND_API.G_EXC_UNEXPECTED_ERROR then
451: x_return_status := SQLERRM;

Line 450: when FND_API.G_EXC_UNEXPECTED_ERROR then

446: EXCEPTION
447: when FND_API.G_EXC_ERROR then
448: x_return_status := SQLERRM;
449: RETURN;
450: when FND_API.G_EXC_UNEXPECTED_ERROR then
451: x_return_status := SQLERRM;
452: RETURN;
453: when others then
454: BIS_UTILITIES_PVT.Add_Error_Message

Line 522: , p_commit => FND_API.G_TRUE

518: l_actual_rec.comparison_actual_value := p_comparison_actual_value;
519:
520: BIS_ACTUAL_PUB.Post_Actual
521: ( p_api_version => 1.0
522: , p_commit => FND_API.G_TRUE
523: , p_Actual_Rec => l_actual_rec
524: , x_return_status => x_return_status
525: , x_msg_count => l_msg_count
526: , x_msg_data => l_msg_data