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

Line 23: x_return_status := FND_API.G_RET_STS_SUCCESS;

19: select rowid from BIS_USER_IND_SELECTIONS
20: where IND_SELECTION_ID = l_user_ind_id;
21:
22: BEGIN
23: x_return_status := FND_API.G_RET_STS_SUCCESS;
24:
25: BIS_UTILITIES_PUB.Retrieve_User(
26: p_user_id => p_Indicator_Region_Rec.user_id
27: ,p_user_name => p_Indicator_Region_Rec.user_name

Line 34: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

30: ,x_return_status => x_return_status
31: ,x_error_Tbl => x_error_Tbl
32: );
33:
34: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
35: RAISE e_CreateException;
36: END IF;
37:
38: BIS_INDICATOR_REGION_PVT.Validate_User_Ind_Selection(

Line 45: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

41: p_user_id => l_user_id,
42: p_Indicator_Region_Rec => p_Indicator_Region_Rec,
43: x_return_status => x_return_status);
44:
45: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
46: RAISE e_CreateException;
47: END IF;
48:
49: BIS_INDICATOR_REGION_PVT.Create_User_Ind_Selection(

Line 57: x_return_status := FND_API.G_RET_STS_ERROR;

53: x_error_Tbl => x_error_Tbl);
54:
55: EXCEPTION
56: WHEN e_CreateException THEN
57: x_return_status := FND_API.G_RET_STS_ERROR;
58: WHEN OTHERS THEN
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
60: l_error_tbl := x_error_Tbl;
61: BIS_UTILITIES_PVT.Add_Error_Message

Line 59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

55: EXCEPTION
56: WHEN e_CreateException THEN
57: x_return_status := FND_API.G_RET_STS_ERROR;
58: WHEN OTHERS THEN
59: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
60: l_error_tbl := x_error_Tbl;
61: BIS_UTILITIES_PVT.Add_Error_Message
62: ( p_error_table => l_error_Tbl
63: , p_error_msg_id => SQLCODE

Line 76: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,

72: p_api_version IN NUMBER,
73: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
74: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
75: p_plug_id IN NUMBER ,
76: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
77: x_Indicator_Region_Tbl
78: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 88: x_return_status := FND_API.G_RET_STS_SUCCESS;

84: e_RetrieveException EXCEPTION;
85: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
86: l_Indicator_Region_Tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
87: BEGIN
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:
90: BIS_UTILITIES_PUB.Retrieve_User(
91: p_user_id => p_user_id
92: ,p_user_name => p_user_name

Line 99: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

95: ,x_return_status => x_return_status
96: ,x_error_Tbl => x_error_Tbl
97: );
98:
99: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
100: RAISE e_RetrieveException;
101: END IF;
102:
103: l_Indicator_Region_rec.plug_id := p_plug_id;

Line 112: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

108: p_user_id => l_indicator_region_rec.user_id,
109: p_Indicator_Region_Rec => l_Indicator_Region_Rec,
110: x_return_status => x_return_status);
111:
112: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
113: RAISE e_RetrieveException;
114: END IF;
115:
116: BIS_INDICATOR_REGION_PVT.Retrieve_User_Ind_Selections(

Line 139: x_return_status := FND_API.G_RET_STS_ERROR;

135: END IF;
136:
137: EXCEPTION
138: WHEN e_RetrieveException THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: l_error_tbl := x_error_Tbl;
143: BIS_UTILITIES_PVT.Add_Error_Message

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

137: EXCEPTION
138: WHEN e_RetrieveException THEN
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: l_error_tbl := x_error_Tbl;
143: BIS_UTILITIES_PVT.Add_Error_Message
144: ( p_error_table => l_error_Tbl
145: , p_error_msg_id => SQLCODE

Line 156: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,

152: END Retrieve_User_Ind_Selections;
153:
154: Procedure Retrieve_User_Ind_Selections(
155: p_api_version IN NUMBER,
156: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
157: p_Target_level_rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type,
158: x_Indicator_Region_Tbl
159: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
160: x_return_status OUT NOCOPY VARCHAR2,

Line 173: x_return_status := FND_API.G_RET_STS_SUCCESS;

169: l_target_level_rec_p BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type;
170: l_Indicator_Region_Tbl BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type;
171: BEGIN
172:
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174: l_Target_level_rec := p_Target_level_rec;
175:
176: IF BIS_UTILITIES_PUB.VALUE_MISSING(p_Target_level_rec.Target_Level_ID)
177: = FND_API.G_TRUE THEN

Line 177: = FND_API.G_TRUE THEN

173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174: l_Target_level_rec := p_Target_level_rec;
175:
176: IF BIS_UTILITIES_PUB.VALUE_MISSING(p_Target_level_rec.Target_Level_ID)
177: = FND_API.G_TRUE THEN
178:
179: -- mdamle 01/15/2001 - Resequence Dimensions
180: IF (l_target_level_rec.org_level_id IS NOT NULL) AND
181: (l_target_level_rec.time_level_id IS NOT NULL) THEN

Line 193: , p_all_info => FND_API.G_FALSE

189: l_target_level_Rec_p := l_target_level_Rec;
190: BIS_TARGET_LEVEL_PUB.Retrieve_Target_Level
191: ( p_api_version => 1.0
192: , p_Target_level_rec => l_Target_level_rec_p
193: , p_all_info => FND_API.G_FALSE
194: , x_Target_level_rec => l_Target_level_rec
195: , x_return_status => x_return_status
196: , x_error_Tbl => x_error_Tbl
197: );

Line 237: x_return_status := FND_API.G_RET_STS_ERROR;

233:
234:
235: EXCEPTION
236: WHEN e_RetrieveException THEN
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: WHEN OTHERS THEN
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: l_error_tbl := x_error_Tbl;
241: BIS_UTILITIES_PVT.Add_Error_Message

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: EXCEPTION
236: WHEN e_RetrieveException THEN
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: WHEN OTHERS THEN
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: l_error_tbl := x_error_Tbl;
241: BIS_UTILITIES_PVT.Add_Error_Message
242: ( p_error_table => l_error_Tbl
243: , p_error_msg_id => SQLCODE

Line 268: x_return_status := FND_API.G_RET_STS_SUCCESS;

264: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
265:
266: e_UpdateException EXCEPTION;
267: BEGIN
268: x_return_status := FND_API.G_RET_STS_SUCCESS;
269:
270: BIS_UTILITIES_PUB.Retrieve_User(
271: p_user_id => p_user_id
272: ,p_user_name => p_user_name

Line 279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

275: ,x_return_status => x_return_status
276: ,x_error_Tbl => x_error_Tbl
277: );
278:
279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
280: RAISE e_UpdateException;
281: END IF;
282:
283: FOR i in 1..p_Indicator_Region_Tbl.count LOOP

Line 292: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

288: p_user_id => l_user_id,
289: p_Indicator_Region_Rec => p_Indicator_Region_Tbl(i),
290: x_return_status => x_return_status);
291:
292: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
293: RAISE e_UpdateException;
294: END IF;
295:
296: BIS_INDICATOR_REGION_PVT.Update_User_Ind_Selection(

Line 309: x_return_status := FND_API.G_RET_STS_ERROR;

305: END LOOP;
306:
307: EXCEPTION
308: WHEN e_UpdateException THEN
309: x_return_status := FND_API.G_RET_STS_ERROR;
310: WHEN OTHERS THEN
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: l_error_tbl := x_error_Tbl;
313: BIS_UTILITIES_PVT.Add_Error_Message

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: EXCEPTION
308: WHEN e_UpdateException THEN
309: x_return_status := FND_API.G_RET_STS_ERROR;
310: WHEN OTHERS THEN
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: l_error_tbl := x_error_Tbl;
313: BIS_UTILITIES_PVT.Add_Error_Message
314: ( p_error_table => l_error_Tbl
315: , p_error_msg_id => SQLCODE

Line 339: x_return_status := FND_API.G_RET_STS_SUCCESS;

335: l_user_name VARCHAR2(100);
336: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
337: e_DeleteException EXCEPTION;
338: BEGIN
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340:
341: BIS_UTILITIES_PUB.Retrieve_User(
342: p_user_id => p_user_id
343: ,p_user_name => p_user_name

Line 350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

346: ,x_return_status => x_return_status
347: ,x_error_Tbl => x_error_Tbl
348: );
349:
350: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
351: RAISE e_DeleteException;
352: END IF;
353:
354: l_Indicator_Region_rec.user_id := l_user_id;

Line 365: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

361: p_user_id => l_Indicator_Region_Rec.user_id,
362: p_Indicator_Region_Rec => l_Indicator_Region_Rec,
363: x_return_status => x_return_status);
364:
365: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
366: RAISE e_DeleteException;
367: END IF;
368:
369: BIS_INDICATOR_REGION_PVT.Delete_User_Ind_Selections(

Line 379: x_return_status := FND_API.G_RET_STS_ERROR;

375: x_error_Tbl => x_error_Tbl);
376:
377: EXCEPTION
378: WHEN e_DeleteException THEN
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: WHEN OTHERS THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: l_error_tbl := x_error_Tbl;
383: BIS_UTILITIES_PVT.Add_Error_Message

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

377: EXCEPTION
378: WHEN e_DeleteException THEN
379: x_return_status := FND_API.G_RET_STS_ERROR;
380: WHEN OTHERS THEN
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
382: l_error_tbl := x_error_Tbl;
383: BIS_UTILITIES_PVT.Add_Error_Message
384: ( p_error_table => l_error_Tbl
385: , p_error_msg_id => SQLCODE