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_ACTUAL_PUB dependencies on FND_API

Line 26: x_return_status := FND_API.G_RET_STS_SUCCESS;

22: l_target_level_rec BIS_TARGET_LEVEL_PUB.TARGET_LEVEL_REC_TYPE;
23: l_indicator_region_tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
24:
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: l_Target_level_Rec := p_target_level_rec;
28:
29: -- mdamle 01/15/2001 - Resequence the dimensions levels for product teams still using Org and Time
30: IF (l_target_level_rec.org_level_id IS NOT NULL) AND

Line 41: , p_all_info => FND_API.G_TRUE

37: END IF;
38:
39: BIS_INDICATOR_REGION_PUB.Retrieve_User_Ind_Selections
40: ( p_api_version => p_api_version
41: , p_all_info => FND_API.G_TRUE
42: , p_Target_level_Rec => l_Target_level_Rec
43: , x_Indicator_Region_Tbl => x_Indicator_Region_Tbl
44: , x_return_status => x_return_status
45: , x_error_Tbl => x_error_Tbl

Line 63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

59: END IF;
60:
61: EXCEPTION
62: WHEN OTHERS THEN
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
64:
65: END Retrieve_User_Selections;
66:
67:

Line 71: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

67:
68: -- Posts actual value into BIS table.
69: PROCEDURE Post_Actual
70: ( p_api_version IN NUMBER
71: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
72: ,p_commit IN VARCHAR2 Default FND_API.G_FALSE
73: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
74: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
75: ,x_return_status OUT NOCOPY VARCHAR2

Line 72: ,p_commit IN VARCHAR2 Default FND_API.G_FALSE

68: -- Posts actual value into BIS table.
69: PROCEDURE Post_Actual
70: ( p_api_version IN NUMBER
71: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
72: ,p_commit IN VARCHAR2 Default FND_API.G_FALSE
73: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
74: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
75: ,x_return_status OUT NOCOPY VARCHAR2
76: ,x_msg_count OUT NOCOPY NUMBER

Line 73: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

69: PROCEDURE Post_Actual
70: ( p_api_version IN NUMBER
71: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
72: ,p_commit IN VARCHAR2 Default FND_API.G_FALSE
73: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
74: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
75: ,x_return_status OUT NOCOPY VARCHAR2
76: ,x_msg_count OUT NOCOPY NUMBER
77: ,x_msg_data OUT NOCOPY VARCHAR2

Line 120: when FND_API.G_EXC_ERROR then

116: , x_error_Tbl => x_error_Tbl
117: );
118:
119: EXCEPTION
120: when FND_API.G_EXC_ERROR then
121: --dbms_output.put_line('PUB 1 Exception');
122: x_return_status := FND_API.G_RET_STS_ERROR ;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: --dbms_output.put_line('PUB 2 Exception');

Line 122: x_return_status := FND_API.G_RET_STS_ERROR ;

118:
119: EXCEPTION
120: when FND_API.G_EXC_ERROR then
121: --dbms_output.put_line('PUB 1 Exception');
122: x_return_status := FND_API.G_RET_STS_ERROR ;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: --dbms_output.put_line('PUB 2 Exception');
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: when others then

Line 123: when FND_API.G_EXC_UNEXPECTED_ERROR then

119: EXCEPTION
120: when FND_API.G_EXC_ERROR then
121: --dbms_output.put_line('PUB 1 Exception');
122: x_return_status := FND_API.G_RET_STS_ERROR ;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: --dbms_output.put_line('PUB 2 Exception');
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: when others then
127: --dbms_output.put_line('PUB 3 Exception');

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

121: --dbms_output.put_line('PUB 1 Exception');
122: x_return_status := FND_API.G_RET_STS_ERROR ;
123: when FND_API.G_EXC_UNEXPECTED_ERROR then
124: --dbms_output.put_line('PUB 2 Exception');
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: when others then
127: --dbms_output.put_line('PUB 3 Exception');
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
129: l_error_tbl := x_error_tbl;

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

124: --dbms_output.put_line('PUB 2 Exception');
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
126: when others then
127: --dbms_output.put_line('PUB 3 Exception');
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
129: l_error_tbl := x_error_tbl;
130: BIS_UTILITIES_PVT.Add_Error_Message
131: ( p_error_msg_id => SQLCODE
132: , p_error_description => SQLERRM

Line 142: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

138: END Post_Actual;
139:
140: PROCEDURE Retrieve_Actual
141: ( p_api_version IN NUMBER
142: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
144: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
145: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
146: ,x_return_status OUT NOCOPY VARCHAR2

Line 143: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE

139:
140: PROCEDURE Retrieve_Actual
141: ( p_api_version IN NUMBER
142: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
144: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
145: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
146: ,x_return_status OUT NOCOPY VARCHAR2
147: ,x_msg_count OUT NOCOPY NUMBER

Line 158: x_return_status := FND_API.G_RET_STS_SUCCESS;

154: l_actual_rec_p BIS_ACTUAL_PUB.Actual_Rec_Type;
155:
156: BEGIN
157:
158: x_return_status := FND_API.G_RET_STS_SUCCESS;
159: -- dbms_output.put_line('In PUB Retrieve_Actual');
160:
161: BIS_ACTUAL_PVT.Value_ID_Conversion
162: ( p_api_version => p_api_version

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

198: );
199:
200: EXCEPTION
201: WHEN OTHERS THEN
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
203:
204: END Retrieve_Actual;
205:
206:

Line 213: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

209: -- If information about dimension values are not required, set all_info
210: -- to FALSE.
211: PROCEDURE Retrieve_Actuals
212: ( p_api_version IN NUMBER
213: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
214: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
215: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
216: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
217: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type

Line 214: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

210: -- to FALSE.
211: PROCEDURE Retrieve_Actuals
212: ( p_api_version IN NUMBER
213: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
214: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
215: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
216: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
217: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
218: ,x_return_status OUT NOCOPY VARCHAR2

Line 215: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE

211: PROCEDURE Retrieve_Actuals
212: ( p_api_version IN NUMBER
213: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
214: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
215: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
216: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
217: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
218: ,x_return_status OUT NOCOPY VARCHAR2
219: ,x_msg_count OUT NOCOPY NUMBER

Line 225: x_return_status := FND_API.G_RET_STS_SUCCESS;

221: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
222: )
223: IS
224: BEGIN
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226: -- dbms_output.put_line('In PUB Retrieve_Actuals');
227:
228: EXCEPTION
229: WHEN OTHERS THEN

Line 230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

226: -- dbms_output.put_line('In PUB Retrieve_Actuals');
227:
228: EXCEPTION
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
231:
232: END Retrieve_Actuals;
233:
234:

Line 241: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

237: -- If information about dimension values are not required, set all_info
238: -- to FALSE.
239: PROCEDURE Retrieve_Latest_Actual
240: ( p_api_version IN NUMBER
241: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
242: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
243: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
244: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
245: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type

Line 242: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

238: -- to FALSE.
239: PROCEDURE Retrieve_Latest_Actual
240: ( p_api_version IN NUMBER
241: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
242: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
243: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
244: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
245: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
246: ,x_return_status OUT NOCOPY VARCHAR2

Line 243: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE

239: PROCEDURE Retrieve_Latest_Actual
240: ( p_api_version IN NUMBER
241: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
242: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
243: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
244: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
245: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
246: ,x_return_status OUT NOCOPY VARCHAR2
247: ,x_msg_count OUT NOCOPY NUMBER

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
250: )
251: IS
252: BEGIN
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254: -- dbms_output.put_line('In PUB Retrieve_Latest_Actual');
255:
256: EXCEPTION
257: WHEN OTHERS THEN

Line 258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

254: -- dbms_output.put_line('In PUB Retrieve_Latest_Actual');
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259:
260: END Retrieve_Latest_Actual;
261:
262:

Line 269: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

265: -- If information about dimension values are not required, set all_info
266: -- to FALSE.
267: PROCEDURE Retrieve_Latest_Actuals
268: ( p_api_version IN NUMBER
269: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
270: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
271: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
272: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
273: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type

Line 270: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

266: -- to FALSE.
267: PROCEDURE Retrieve_Latest_Actuals
268: ( p_api_version IN NUMBER
269: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
270: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
271: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
272: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
273: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
274: ,x_return_status OUT NOCOPY VARCHAR2

Line 271: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE

267: PROCEDURE Retrieve_Latest_Actuals
268: ( p_api_version IN NUMBER
269: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
270: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
271: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
272: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
273: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
274: ,x_return_status OUT NOCOPY VARCHAR2
275: ,x_msg_count OUT NOCOPY NUMBER

Line 281: x_return_status := FND_API.G_RET_STS_SUCCESS;

277: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
278: )
279: IS
280: BEGIN
281: x_return_status := FND_API.G_RET_STS_SUCCESS;
282: -- dbms_output.put_line('In PUB Retrieve_Latest_Actuals');
283:
284: EXCEPTION
285: WHEN OTHERS THEN

Line 286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

282: -- dbms_output.put_line('In PUB Retrieve_Latest_Actuals');
283:
284: EXCEPTION
285: WHEN OTHERS THEN
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
287:
288: END Retrieve_Latest_Actuals;
289:
290:

Line 293: , p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

289:
290:
291: PROCEDURE Validate_Actual
292: ( p_api_version IN NUMBER
293: , p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
294: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
295: , p_event IN VARCHAR2
296: , p_user_id IN NUMBER
297: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type

Line 294: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

290:
291: PROCEDURE Validate_Actual
292: ( p_api_version IN NUMBER
293: , p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
294: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
295: , p_event IN VARCHAR2
296: , p_user_id IN NUMBER
297: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
298: , x_return_status OUT NOCOPY VARCHAR2

Line 305: x_return_status := FND_API.G_RET_STS_SUCCESS;

301: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
302: )
303: IS
304: BEGIN
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306: -- dbms_output.put_line('In PUB Validate_Actual');
307:
308:
309:

Line 312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

308:
309:
310: EXCEPTION
311: WHEN OTHERS THEN
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313:
314: END Validate_Actual;
315:
316: END BIS_ACTUAL_PUB;