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

Line 28: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

24:
25:
26: PROCEDURE Create_Functional_Area(
27: p_Api_Version IN NUMBER
28: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
29: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
30: ,x_Return_Status OUT NOCOPY VARCHAR2
31: ,x_Msg_Count OUT NOCOPY NUMBER
32: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 42: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

38: BEGIN
39: SAVEPOINT CreateFuncAreaSP_Pvt;
40: FND_MSG_PUB.Initialize;
41:
42: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
43: l_Func_Area_Rec := p_Func_Area_Rec;
44:
45: IF(l_Func_Area_Rec.Created_By IS NULL) THEN
46: l_Func_Area_Rec.Created_By := FND_GLOBAL.USER_ID;

Line 122: IF (p_Commit = FND_API.G_TRUE) THEN

118: AND T.LANGUAGE = L.LANGUAGE_CODE
119: );
120:
121: -- Commit if required
122: IF (p_Commit = FND_API.G_TRUE) THEN
123: COMMIT;
124: END IF;
125:
126: EXCEPTION

Line 127: WHEN FND_API.G_EXC_ERROR THEN

123: COMMIT;
124: END IF;
125:
126: EXCEPTION
127: WHEN FND_API.G_EXC_ERROR THEN
128: ROLLBACK TO CreateFuncAreaSP_Pvt;
129: IF (x_msg_data IS NULL) THEN
130: FND_MSG_PUB.Count_And_Get
131: ( p_encoded => FND_API.G_FALSE

Line 131: ( p_encoded => FND_API.G_FALSE

127: WHEN FND_API.G_EXC_ERROR THEN
128: ROLLBACK TO CreateFuncAreaSP_Pvt;
129: IF (x_msg_data IS NULL) THEN
130: FND_MSG_PUB.Count_And_Get
131: ( p_encoded => FND_API.G_FALSE
132: , p_count => x_msg_count
133: , p_data => x_msg_data
134: );
135: END IF;

Line 136: x_return_status := FND_API.G_RET_STS_ERROR;

132: , p_count => x_msg_count
133: , p_data => x_msg_data
134: );
135: END IF;
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: ROLLBACK TO CreateFuncAreaSP_Pvt;
139: IF (x_msg_data IS NULL) THEN
140: FND_MSG_PUB.Count_And_Get

Line 137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

133: , p_data => x_msg_data
134: );
135: END IF;
136: x_return_status := FND_API.G_RET_STS_ERROR;
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: ROLLBACK TO CreateFuncAreaSP_Pvt;
139: IF (x_msg_data IS NULL) THEN
140: FND_MSG_PUB.Count_And_Get
141: ( p_encoded => FND_API.G_FALSE

Line 141: ( p_encoded => FND_API.G_FALSE

137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: ROLLBACK TO CreateFuncAreaSP_Pvt;
139: IF (x_msg_data IS NULL) THEN
140: FND_MSG_PUB.Count_And_Get
141: ( p_encoded => FND_API.G_FALSE
142: , p_count => x_msg_count
143: , p_data => x_msg_data
144: );
145: END IF;

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

142: , p_count => x_msg_count
143: , p_data => x_msg_data
144: );
145: END IF;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: WHEN NO_DATA_FOUND THEN
148: ROLLBACK TO CreateFuncAreaSP_Pvt;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF (x_msg_data IS NOT NULL) THEN

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

145: END IF;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: WHEN NO_DATA_FOUND THEN
148: ROLLBACK TO CreateFuncAreaSP_Pvt;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF (x_msg_data IS NOT NULL) THEN
151: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
152: ELSE
153: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

153: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
154: END IF;
155: WHEN OTHERS THEN
156: ROLLBACK TO CreateFuncAreaSP_Pvt;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: IF (x_msg_data IS NOT NULL) THEN
159: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';
160: ELSE
161: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Functional_Area ';

Line 170: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

166:
167: -- Update Functional Area API
168: PROCEDURE Update_Functional_Area(
169: p_Api_Version IN NUMBER
170: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
171: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
172: ,x_Return_Status OUT NOCOPY VARCHAR2
173: ,x_Msg_Count OUT NOCOPY NUMBER
174: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 181: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

177: l_Func_Area_Rec BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type;
178: BEGIN
179: SAVEPOINT UpdateFuncAreaSP_Pvt;
180: FND_MSG_PUB.Initialize;
181: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
182:
183: BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area
184: (
185: p_Func_Area_Rec => p_Func_Area_Rec

Line 191: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

187: ,x_Return_Status => x_Return_Status
188: ,x_Msg_Count => x_Msg_Count
189: ,x_Msg_Data => x_Msg_Data
190: );
191: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193: END IF;
194:
195: --DBMS_OUTPUT.PUT_LINE ('l_Func_Area_Rec.Short_Name - ' || l_Func_Area_Rec.Short_Name);

Line 192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

188: ,x_Msg_Count => x_Msg_Count
189: ,x_Msg_Data => x_Msg_Data
190: );
191: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
193: END IF;
194:
195: --DBMS_OUTPUT.PUT_LINE ('l_Func_Area_Rec.Short_Name - ' || l_Func_Area_Rec.Short_Name);
196: -- Name can never be null

Line 242: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

238: ,x_Return_Status => x_Return_Status
239: ,x_Msg_Count => x_Msg_Count
240: ,x_Msg_Data => x_Msg_Data
241: );
242: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- Commit if required

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239: ,x_Msg_Count => x_Msg_Count
240: ,x_Msg_Data => x_Msg_Data
241: );
242: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- Commit if required
247: IF (p_Commit = FND_API.G_TRUE) THEN

Line 247: IF (p_Commit = FND_API.G_TRUE) THEN

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245:
246: -- Commit if required
247: IF (p_Commit = FND_API.G_TRUE) THEN
248: COMMIT;
249: END IF;
250:
251: EXCEPTION

Line 252: WHEN FND_API.G_EXC_ERROR THEN

248: COMMIT;
249: END IF;
250:
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO UpdateFuncAreaSP_Pvt;
254: IF (x_msg_data IS NULL) THEN
255: FND_MSG_PUB.Count_And_Get
256: ( p_encoded => FND_API.G_FALSE

Line 256: ( p_encoded => FND_API.G_FALSE

252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO UpdateFuncAreaSP_Pvt;
254: IF (x_msg_data IS NULL) THEN
255: FND_MSG_PUB.Count_And_Get
256: ( p_encoded => FND_API.G_FALSE
257: , p_count => x_msg_count
258: , p_data => x_msg_data
259: );
260: END IF;

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: , p_count => x_msg_count
258: , p_data => x_msg_data
259: );
260: END IF;
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO UpdateFuncAreaSP_Pvt;
264: IF (x_msg_data IS NULL) THEN
265: FND_MSG_PUB.Count_And_Get

Line 262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

258: , p_data => x_msg_data
259: );
260: END IF;
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO UpdateFuncAreaSP_Pvt;
264: IF (x_msg_data IS NULL) THEN
265: FND_MSG_PUB.Count_And_Get
266: ( p_encoded => FND_API.G_FALSE

Line 266: ( p_encoded => FND_API.G_FALSE

262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO UpdateFuncAreaSP_Pvt;
264: IF (x_msg_data IS NULL) THEN
265: FND_MSG_PUB.Count_And_Get
266: ( p_encoded => FND_API.G_FALSE
267: , p_count => x_msg_count
268: , p_data => x_msg_data
269: );
270: END IF;

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

267: , p_count => x_msg_count
268: , p_data => x_msg_data
269: );
270: END IF;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: WHEN NO_DATA_FOUND THEN
273: ROLLBACK TO UpdateFuncAreaSP_Pvt;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: IF (x_msg_data IS NOT NULL) THEN

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

270: END IF;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: WHEN NO_DATA_FOUND THEN
273: ROLLBACK TO UpdateFuncAreaSP_Pvt;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: IF (x_msg_data IS NOT NULL) THEN
276: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
277: ELSE
278: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
279: END IF;
280: WHEN OTHERS THEN
281: ROLLBACK TO UpdateFuncAreaSP_Pvt;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: IF (x_msg_data IS NOT NULL) THEN
284: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';
285: ELSE
286: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Functional_Area ';

Line 294: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

290:
291: -- Translate the Functional Area Name/Description
292: PROCEDURE Translate_Functional_Area(
293: p_Api_Version IN NUMBER
294: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
295: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
296: ,x_Return_Status OUT NOCOPY VARCHAR2
297: ,x_Msg_Count OUT NOCOPY NUMBER
298: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 306: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

302:
303: BEGIN
304: SAVEPOINT TransFuncAreaSP_Pvt;
305: FND_MSG_PUB.Initialize;
306: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
307:
308: BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area
309: (
310: p_Func_Area_Rec => p_Func_Area_Rec

Line 316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

312: ,x_Return_Status => x_Return_Status
313: ,x_Msg_Count => x_Msg_Count
314: ,x_Msg_Data => x_Msg_Data
315: );
316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320: -- Name can never be null

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: ,x_Msg_Count => x_Msg_Count
314: ,x_Msg_Data => x_Msg_Data
315: );
316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319:
320: -- Name can never be null
321: IF (l_Func_Area_Rec.Name <> p_Func_Area_Rec.Name) THEN

Line 369: IF (p_Commit = FND_API.G_TRUE) THEN

365:
366: -- Translate the Measures
367:
368: -- Commit if required
369: IF (p_Commit = FND_API.G_TRUE) THEN
370: COMMIT;
371: END IF;
372:
373: EXCEPTION

Line 374: WHEN FND_API.G_EXC_ERROR THEN

370: COMMIT;
371: END IF;
372:
373: EXCEPTION
374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO TransFuncAreaSP_Pvt;
376: IF (x_msg_data IS NULL) THEN
377: FND_MSG_PUB.Count_And_Get
378: ( p_encoded => FND_API.G_FALSE

Line 378: ( p_encoded => FND_API.G_FALSE

374: WHEN FND_API.G_EXC_ERROR THEN
375: ROLLBACK TO TransFuncAreaSP_Pvt;
376: IF (x_msg_data IS NULL) THEN
377: FND_MSG_PUB.Count_And_Get
378: ( p_encoded => FND_API.G_FALSE
379: , p_count => x_msg_count
380: , p_data => x_msg_data
381: );
382: END IF;

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379: , p_count => x_msg_count
380: , p_data => x_msg_data
381: );
382: END IF;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO TransFuncAreaSP_Pvt;
386: IF (x_msg_data IS NULL) THEN
387: FND_MSG_PUB.Count_And_Get

Line 384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

380: , p_data => x_msg_data
381: );
382: END IF;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO TransFuncAreaSP_Pvt;
386: IF (x_msg_data IS NULL) THEN
387: FND_MSG_PUB.Count_And_Get
388: ( p_encoded => FND_API.G_FALSE

Line 388: ( p_encoded => FND_API.G_FALSE

384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: ROLLBACK TO TransFuncAreaSP_Pvt;
386: IF (x_msg_data IS NULL) THEN
387: FND_MSG_PUB.Count_And_Get
388: ( p_encoded => FND_API.G_FALSE
389: , p_count => x_msg_count
390: , p_data => x_msg_data
391: );
392: END IF;

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: , p_count => x_msg_count
390: , p_data => x_msg_data
391: );
392: END IF;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: WHEN NO_DATA_FOUND THEN
395: ROLLBACK TO TransFuncAreaSP_Pvt;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF (x_msg_data IS NOT NULL) THEN

Line 396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

392: END IF;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: WHEN NO_DATA_FOUND THEN
395: ROLLBACK TO TransFuncAreaSP_Pvt;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: IF (x_msg_data IS NOT NULL) THEN
398: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
399: ELSE
400: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

400: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
401: END IF;
402: WHEN OTHERS THEN
403: ROLLBACK TO TransFuncAreaSP_Pvt;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: IF (x_msg_data IS NOT NULL) THEN
406: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';
407: ELSE
408: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Translate_Functional_Area ';

Line 437: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

433: WHERE F.SHORT_NAME = p_Func_Area_Rec.Short_Name;
434:
435: BEGIN
436: FND_MSG_PUB.Initialize;
437: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
438: l_Count := 0;
439:
440: FOR cRFA IN cRetrieveFuncArea LOOP
441: x_Func_Area_Rec.Functional_Area_Id := cRFA.FUNCTIONAL_AREA_ID;

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: l_Count := 1;
451: END LOOP;
452:
453: IF (l_Count = 0) THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN

Line 458: WHEN FND_API.G_EXC_ERROR THEN

454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: IF (x_msg_data IS NULL) THEN
460: FND_MSG_PUB.Count_And_Get
461: ( p_encoded => FND_API.G_FALSE
462: , p_count => x_msg_count

Line 461: ( p_encoded => FND_API.G_FALSE

457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: IF (x_msg_data IS NULL) THEN
460: FND_MSG_PUB.Count_And_Get
461: ( p_encoded => FND_API.G_FALSE
462: , p_count => x_msg_count
463: , p_data => x_msg_data
464: );
465: END IF;

Line 466: x_return_status := FND_API.G_RET_STS_ERROR;

462: , p_count => x_msg_count
463: , p_data => x_msg_data
464: );
465: END IF;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: IF (x_msg_data IS NULL) THEN
469: FND_MSG_PUB.Count_And_Get
470: ( p_encoded => FND_API.G_FALSE

Line 467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

463: , p_data => x_msg_data
464: );
465: END IF;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: IF (x_msg_data IS NULL) THEN
469: FND_MSG_PUB.Count_And_Get
470: ( p_encoded => FND_API.G_FALSE
471: , p_count => x_msg_count

Line 470: ( p_encoded => FND_API.G_FALSE

466: x_return_status := FND_API.G_RET_STS_ERROR;
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: IF (x_msg_data IS NULL) THEN
469: FND_MSG_PUB.Count_And_Get
470: ( p_encoded => FND_API.G_FALSE
471: , p_count => x_msg_count
472: , p_data => x_msg_data
473: );
474: END IF;

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: , p_count => x_msg_count
472: , p_data => x_msg_data
473: );
474: END IF;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: WHEN NO_DATA_FOUND THEN
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: IF (x_msg_data IS NOT NULL) THEN
479: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';

Line 477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

473: );
474: END IF;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: WHEN NO_DATA_FOUND THEN
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: IF (x_msg_data IS NOT NULL) THEN
479: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
480: ELSE
481: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';

Line 484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

480: ELSE
481: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
482: END IF;
483: WHEN OTHERS THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF (x_msg_data IS NOT NULL) THEN
486: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';
487: ELSE
488: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Retrieve_Functional_Area ';

Line 498: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

494: -- This is the Functional Area/Application ID dependency table
495:
496: PROCEDURE Create_Func_Area_Apps_Dep (
497: p_Api_Version IN NUMBER
498: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
499: ,p_Functional_Area_Id IN NUMBER
500: ,p_Application_Id IN NUMBER
501: ,x_Return_Status OUT NOCOPY VARCHAR2
502: ,x_Msg_Count OUT NOCOPY NUMBER

Line 513: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

509: BEGIN
510: SAVEPOINT CreateFuncAreaAppDepSP_Pvt;
511: FND_MSG_PUB.Initialize;
512:
513: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
514:
515: INSERT INTO BIS_FUNC_AREA_APP_DEPENDENCY
516: (
517: FUNCTIONAL_AREA_ID

Line 527: IF (p_Commit = FND_API.G_TRUE) THEN

523: ,p_Application_Id
524: );
525:
526: -- Commit if required
527: IF (p_Commit = FND_API.G_TRUE) THEN
528: COMMIT;
529: END IF;
530:
531: EXCEPTION

Line 532: WHEN FND_API.G_EXC_ERROR THEN

528: COMMIT;
529: END IF;
530:
531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
534: IF (x_msg_data IS NULL) THEN
535: FND_MSG_PUB.Count_And_Get
536: ( p_encoded => FND_API.G_FALSE

Line 536: ( p_encoded => FND_API.G_FALSE

532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
534: IF (x_msg_data IS NULL) THEN
535: FND_MSG_PUB.Count_And_Get
536: ( p_encoded => FND_API.G_FALSE
537: , p_count => x_msg_count
538: , p_data => x_msg_data
539: );
540: END IF;

Line 541: x_return_status := FND_API.G_RET_STS_ERROR;

537: , p_count => x_msg_count
538: , p_data => x_msg_data
539: );
540: END IF;
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
544: IF (x_msg_data IS NULL) THEN
545: FND_MSG_PUB.Count_And_Get

Line 542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

538: , p_data => x_msg_data
539: );
540: END IF;
541: x_return_status := FND_API.G_RET_STS_ERROR;
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
544: IF (x_msg_data IS NULL) THEN
545: FND_MSG_PUB.Count_And_Get
546: ( p_encoded => FND_API.G_FALSE

Line 546: ( p_encoded => FND_API.G_FALSE

542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
544: IF (x_msg_data IS NULL) THEN
545: FND_MSG_PUB.Count_And_Get
546: ( p_encoded => FND_API.G_FALSE
547: , p_count => x_msg_count
548: , p_data => x_msg_data
549: );
550: END IF;

Line 551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

547: , p_count => x_msg_count
548: , p_data => x_msg_data
549: );
550: END IF;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: WHEN NO_DATA_FOUND THEN
553: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF (x_msg_data IS NOT NULL) THEN

Line 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

550: END IF;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: WHEN NO_DATA_FOUND THEN
553: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF (x_msg_data IS NOT NULL) THEN
556: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
557: ELSE
558: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
559: END IF;
560: WHEN OTHERS THEN
561: ROLLBACK TO CreateFuncAreaAppDepSP_Pvt;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF (x_msg_data IS NOT NULL) THEN
564: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';
565: ELSE
566: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Create_Func_Area_Apps_Dep ';

Line 573: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

569:
570: -- Update Functional Area dependency with Application ID
571: PROCEDURE Update_Func_Area_Apps_Dep (
572: p_Api_Version IN NUMBER
573: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
574: ,p_Functional_Area_Id IN NUMBER
575: ,p_Application_Id IN NUMBER
576: ,x_Return_Status OUT NOCOPY VARCHAR2
577: ,x_Msg_Count OUT NOCOPY NUMBER

Line 588: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

584: BEGIN
585: SAVEPOINT UpdateFuncAreaAppDepSP_Pvt;
586: FND_MSG_PUB.Initialize;
587:
588: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
589:
590: -- currently we do not have the default flag to update,
591: -- this API is for future implementations.
592:

Line 594: IF (p_Commit = FND_API.G_TRUE) THEN

590: -- currently we do not have the default flag to update,
591: -- this API is for future implementations.
592:
593: -- Commit if required
594: IF (p_Commit = FND_API.G_TRUE) THEN
595: COMMIT;
596: END IF;
597:
598: EXCEPTION

Line 599: WHEN FND_API.G_EXC_ERROR THEN

595: COMMIT;
596: END IF;
597:
598: EXCEPTION
599: WHEN FND_API.G_EXC_ERROR THEN
600: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
601: IF (x_msg_data IS NULL) THEN
602: FND_MSG_PUB.Count_And_Get
603: ( p_encoded => FND_API.G_FALSE

Line 603: ( p_encoded => FND_API.G_FALSE

599: WHEN FND_API.G_EXC_ERROR THEN
600: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
601: IF (x_msg_data IS NULL) THEN
602: FND_MSG_PUB.Count_And_Get
603: ( p_encoded => FND_API.G_FALSE
604: , p_count => x_msg_count
605: , p_data => x_msg_data
606: );
607: END IF;

Line 608: x_return_status := FND_API.G_RET_STS_ERROR;

604: , p_count => x_msg_count
605: , p_data => x_msg_data
606: );
607: END IF;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
611: IF (x_msg_data IS NULL) THEN
612: FND_MSG_PUB.Count_And_Get

Line 609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

605: , p_data => x_msg_data
606: );
607: END IF;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
611: IF (x_msg_data IS NULL) THEN
612: FND_MSG_PUB.Count_And_Get
613: ( p_encoded => FND_API.G_FALSE

Line 613: ( p_encoded => FND_API.G_FALSE

609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
611: IF (x_msg_data IS NULL) THEN
612: FND_MSG_PUB.Count_And_Get
613: ( p_encoded => FND_API.G_FALSE
614: , p_count => x_msg_count
615: , p_data => x_msg_data
616: );
617: END IF;

Line 618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

614: , p_count => x_msg_count
615: , p_data => x_msg_data
616: );
617: END IF;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: WHEN NO_DATA_FOUND THEN
620: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: IF (x_msg_data IS NOT NULL) THEN

Line 621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

617: END IF;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: WHEN NO_DATA_FOUND THEN
620: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: IF (x_msg_data IS NOT NULL) THEN
623: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
624: ELSE
625: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';

Line 629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

625: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
626: END IF;
627: WHEN OTHERS THEN
628: ROLLBACK TO UpdateFuncAreaAppDepSP_Pvt;
629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
630: IF (x_msg_data IS NOT NULL) THEN
631: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';
632: ELSE
633: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Update_Func_Area_Apps_Dep ';

Line 642: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

638:
639: -- Delete the Functional Area
640: PROCEDURE Delete_Functional_Area(
641: p_Api_Version IN NUMBER
642: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
643: ,p_Func_Area_Rec IN BIS_FUNCTIONAL_AREA_PUB.Functional_Area_Rec_Type
644: ,x_Return_Status OUT NOCOPY VARCHAR2
645: ,x_Msg_Count OUT NOCOPY NUMBER
646: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 659: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

655: WHERE B.FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id;
656: BEGIN
657: SAVEPOINT DeleteFuncAreaSP_Pvt;
658: FND_MSG_PUB.Initialize;
659: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
660: l_Func_Area_Rec := p_Func_Area_Rec;
661:
662: FOR cFAD IN c_FuncArea_Dep LOOP
663: BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep (

Line 672: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

668: ,x_Return_Status => x_Return_Status
669: ,x_Msg_Count => x_Msg_Count
670: ,x_Msg_Data => x_Msg_Data
671: );
672: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676: END LOOP;

Line 673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

669: ,x_Msg_Count => x_Msg_Count
670: ,x_Msg_Data => x_Msg_Data
671: );
672: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
673: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
674: END IF;
675:
676: END LOOP;
677:

Line 685: IF (p_Commit = FND_API.G_TRUE) THEN

681:
682: DELETE BIS_FUNCTIONAL_AREAS_TL
683: WHERE FUNCTIONAL_AREA_ID = l_Func_Area_Rec.Functional_Area_Id;
684: -- Commit if required
685: IF (p_Commit = FND_API.G_TRUE) THEN
686: COMMIT;
687: END IF;
688:
689: EXCEPTION

Line 690: WHEN FND_API.G_EXC_ERROR THEN

686: COMMIT;
687: END IF;
688:
689: EXCEPTION
690: WHEN FND_API.G_EXC_ERROR THEN
691: ROLLBACK TO DeleteFuncAreaSP_Pvt;
692: IF (x_msg_data IS NULL) THEN
693: FND_MSG_PUB.Count_And_Get
694: ( p_encoded => FND_API.G_FALSE

Line 694: ( p_encoded => FND_API.G_FALSE

690: WHEN FND_API.G_EXC_ERROR THEN
691: ROLLBACK TO DeleteFuncAreaSP_Pvt;
692: IF (x_msg_data IS NULL) THEN
693: FND_MSG_PUB.Count_And_Get
694: ( p_encoded => FND_API.G_FALSE
695: , p_count => x_msg_count
696: , p_data => x_msg_data
697: );
698: END IF;

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: , p_count => x_msg_count
696: , p_data => x_msg_data
697: );
698: END IF;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: ROLLBACK TO DeleteFuncAreaSP_Pvt;
702: IF (x_msg_data IS NULL) THEN
703: FND_MSG_PUB.Count_And_Get

Line 700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

696: , p_data => x_msg_data
697: );
698: END IF;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: ROLLBACK TO DeleteFuncAreaSP_Pvt;
702: IF (x_msg_data IS NULL) THEN
703: FND_MSG_PUB.Count_And_Get
704: ( p_encoded => FND_API.G_FALSE

Line 704: ( p_encoded => FND_API.G_FALSE

700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
701: ROLLBACK TO DeleteFuncAreaSP_Pvt;
702: IF (x_msg_data IS NULL) THEN
703: FND_MSG_PUB.Count_And_Get
704: ( p_encoded => FND_API.G_FALSE
705: , p_count => x_msg_count
706: , p_data => x_msg_data
707: );
708: END IF;

Line 709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

705: , p_count => x_msg_count
706: , p_data => x_msg_data
707: );
708: END IF;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: WHEN NO_DATA_FOUND THEN
711: ROLLBACK TO DeleteFuncAreaSP_Pvt;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: IF (x_msg_data IS NOT NULL) THEN

Line 712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

708: END IF;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: WHEN NO_DATA_FOUND THEN
711: ROLLBACK TO DeleteFuncAreaSP_Pvt;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
713: IF (x_msg_data IS NOT NULL) THEN
714: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
715: ELSE
716: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';

Line 720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

716: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
717: END IF;
718: WHEN OTHERS THEN
719: ROLLBACK TO DeleteFuncAreaSP_Pvt;
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: IF (x_msg_data IS NOT NULL) THEN
722: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';
723: ELSE
724: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Delete_Functional_Area ';

Line 731: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE

727:
728: -- remove Functional Area/Application ID dependency
729: PROCEDURE Remove_Func_Area_Apps_Dep (
730: p_Api_Version IN NUMBER
731: ,p_Commit IN VARCHAR2 := FND_API.G_FALSE
732: ,p_Functional_Area_Id IN NUMBER
733: ,p_Application_Id IN NUMBER
734: ,x_Return_Status OUT NOCOPY VARCHAR2
735: ,x_Msg_Count OUT NOCOPY NUMBER

Line 743: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

739:
740: BEGIN
741: SAVEPOINT RemoveFuncAreaDependencySP_Pvt;
742: FND_MSG_PUB.Initialize;
743: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
744:
745: DELETE BIS_FUNC_AREA_APP_DEPENDENCY B
746: WHERE B.FUNCTIONAL_AREA_ID = p_Functional_Area_Id
747: AND B.APPLICATION_ID = p_Application_Id;

Line 750: IF (p_Commit = FND_API.G_TRUE) THEN

746: WHERE B.FUNCTIONAL_AREA_ID = p_Functional_Area_Id
747: AND B.APPLICATION_ID = p_Application_Id;
748:
749: -- Commit if required
750: IF (p_Commit = FND_API.G_TRUE) THEN
751: COMMIT;
752: END IF;
753:
754: EXCEPTION

Line 755: WHEN FND_API.G_EXC_ERROR THEN

751: COMMIT;
752: END IF;
753:
754: EXCEPTION
755: WHEN FND_API.G_EXC_ERROR THEN
756: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
757: IF (x_msg_data IS NULL) THEN
758: FND_MSG_PUB.Count_And_Get
759: ( p_encoded => FND_API.G_FALSE

Line 759: ( p_encoded => FND_API.G_FALSE

755: WHEN FND_API.G_EXC_ERROR THEN
756: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
757: IF (x_msg_data IS NULL) THEN
758: FND_MSG_PUB.Count_And_Get
759: ( p_encoded => FND_API.G_FALSE
760: , p_count => x_msg_count
761: , p_data => x_msg_data
762: );
763: END IF;

Line 764: x_return_status := FND_API.G_RET_STS_ERROR;

760: , p_count => x_msg_count
761: , p_data => x_msg_data
762: );
763: END IF;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
767: IF (x_msg_data IS NULL) THEN
768: FND_MSG_PUB.Count_And_Get

Line 765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

761: , p_data => x_msg_data
762: );
763: END IF;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
767: IF (x_msg_data IS NULL) THEN
768: FND_MSG_PUB.Count_And_Get
769: ( p_encoded => FND_API.G_FALSE

Line 769: ( p_encoded => FND_API.G_FALSE

765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
766: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
767: IF (x_msg_data IS NULL) THEN
768: FND_MSG_PUB.Count_And_Get
769: ( p_encoded => FND_API.G_FALSE
770: , p_count => x_msg_count
771: , p_data => x_msg_data
772: );
773: END IF;

Line 774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

770: , p_count => x_msg_count
771: , p_data => x_msg_data
772: );
773: END IF;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: WHEN NO_DATA_FOUND THEN
776: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: IF (x_msg_data IS NOT NULL) THEN

Line 777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

773: END IF;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
775: WHEN NO_DATA_FOUND THEN
776: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: IF (x_msg_data IS NOT NULL) THEN
779: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
780: ELSE
781: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';

Line 785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

781: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
782: END IF;
783: WHEN OTHERS THEN
784: ROLLBACK TO RemoveFuncAreaDependencySP_Pvt;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: IF (x_msg_data IS NOT NULL) THEN
787: x_msg_data := x_msg_data||' -> BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';
788: ELSE
789: x_msg_data := SQLERRM||' at BIS_FUNCTIONAL_AREA_PVT.Remove_Func_Area_Apps_Dep ';