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

Line 29: , p_commit IN VARCHAR2 := FND_API.G_FALSE

25:
26:
27: PROCEDURE Create_Custom_Region_Items
28: ( p_api_version IN NUMBER
29: , p_commit IN VARCHAR2 := FND_API.G_FALSE
30: , p_Custom_Region_Items_Rec IN BIS_CUSTOMIZATION_PUB.custom_region_items_type
31: , x_return_status OUT NOCOPY VARCHAR2
32: , x_msg_count OUT NOCOPY NUMBER
33: , x_msg_data OUT NOCOPY VARCHAR2

Line 40: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

36:
37: BEGIN
38:
39: FND_MSG_PUB.Initialize;
40: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
41:
42: BIS_CUSTOMIZATION_PVT.Create_Custom_Region_Items
43: ( p_api_version => p_api_version
44: , p_commit => p_commit

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

46: , x_return_status => x_return_status
47: , x_msg_count => x_msg_count
48: , x_msg_data => x_msg_data
49: );
50: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
51: RAISE FND_API.G_EXC_ERROR;
52: END IF;
53:
54: EXCEPTION

Line 51: RAISE FND_API.G_EXC_ERROR;

47: , x_msg_count => x_msg_count
48: , x_msg_data => x_msg_data
49: );
50: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
51: RAISE FND_API.G_EXC_ERROR;
52: END IF;
53:
54: EXCEPTION
55: WHEN FND_API.G_EXC_ERROR THEN

Line 55: WHEN FND_API.G_EXC_ERROR THEN

51: RAISE FND_API.G_EXC_ERROR;
52: END IF;
53:
54: EXCEPTION
55: WHEN FND_API.G_EXC_ERROR THEN
56: IF (x_msg_data IS NULL) THEN
57: FND_MSG_PUB.Count_And_Get
58: ( p_encoded => FND_API.G_FALSE
59: , p_count => x_msg_count

Line 58: ( p_encoded => FND_API.G_FALSE

54: EXCEPTION
55: WHEN FND_API.G_EXC_ERROR THEN
56: IF (x_msg_data IS NULL) THEN
57: FND_MSG_PUB.Count_And_Get
58: ( p_encoded => FND_API.G_FALSE
59: , p_count => x_msg_count
60: , p_data => x_msg_data
61: );
62: END IF;

Line 63: x_return_status := FND_API.G_RET_STS_ERROR;

59: , p_count => x_msg_count
60: , p_data => x_msg_data
61: );
62: END IF;
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: IF (x_msg_data IS NULL) THEN
66: FND_MSG_PUB.Count_And_Get
67: ( p_encoded => FND_API.G_FALSE

Line 64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

60: , p_data => x_msg_data
61: );
62: END IF;
63: x_return_status := FND_API.G_RET_STS_ERROR;
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: IF (x_msg_data IS NULL) THEN
66: FND_MSG_PUB.Count_And_Get
67: ( p_encoded => FND_API.G_FALSE
68: , p_count => x_msg_count

Line 67: ( p_encoded => FND_API.G_FALSE

63: x_return_status := FND_API.G_RET_STS_ERROR;
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: IF (x_msg_data IS NULL) THEN
66: FND_MSG_PUB.Count_And_Get
67: ( p_encoded => FND_API.G_FALSE
68: , p_count => x_msg_count
69: , p_data => x_msg_data
70: );
71: END IF;

Line 72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

68: , p_count => x_msg_count
69: , p_data => x_msg_data
70: );
71: END IF;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: WHEN NO_DATA_FOUND THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: IF (x_msg_data IS NOT NULL) THEN
76: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Custom_Region_Items ';

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

70: );
71: END IF;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: WHEN NO_DATA_FOUND THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: IF (x_msg_data IS NOT NULL) THEN
76: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Custom_Region_Items ';
77: ELSE
78: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Create_Custom_Region_Items ';

Line 81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

77: ELSE
78: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Create_Custom_Region_Items ';
79: END IF;
80: WHEN OTHERS THEN
81: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
82: IF (x_msg_data IS NOT NULL) THEN
83: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Custom_Region_Items ';
84: ELSE
85: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Create_Custom_Region_Items ';

Line 93: , p_commit IN VARCHAR2 := FND_API.G_FALSE

89: --
90: --
91: PROCEDURE Update_Custom_Region_Items
92: ( p_api_version IN NUMBER
93: , p_commit IN VARCHAR2 := FND_API.G_FALSE
94: , p_Custom_Region_Items_Rec IN BIS_CUSTOMIZATION_PUB.custom_Region_Items_type
95: , x_return_status OUT NOCOPY VARCHAR2
96: , x_msg_count OUT NOCOPY NUMBER
97: , x_msg_data OUT NOCOPY VARCHAR2

Line 103: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

99: IS
100: BEGIN
101:
102: FND_MSG_PUB.Initialize;
103: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
104:
105: BIS_CUSTOMIZATION_PVT.Update_Custom_Region_Items
106: ( p_api_version => p_api_version
107: , p_commit => p_commit

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

109: , x_return_status => x_return_status
110: , x_msg_count => x_msg_count
111: , x_msg_data => x_msg_data
112: );
113: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116:
117: EXCEPTION

Line 114: RAISE FND_API.G_EXC_ERROR;

110: , x_msg_count => x_msg_count
111: , x_msg_data => x_msg_data
112: );
113: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116:
117: EXCEPTION
118: WHEN FND_API.G_EXC_ERROR THEN

Line 118: WHEN FND_API.G_EXC_ERROR THEN

114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116:
117: EXCEPTION
118: WHEN FND_API.G_EXC_ERROR THEN
119: IF (x_msg_data IS NULL) THEN
120: FND_MSG_PUB.Count_And_Get
121: ( p_encoded => FND_API.G_FALSE
122: , p_count => x_msg_count

Line 121: ( p_encoded => FND_API.G_FALSE

117: EXCEPTION
118: WHEN FND_API.G_EXC_ERROR THEN
119: IF (x_msg_data IS NULL) THEN
120: FND_MSG_PUB.Count_And_Get
121: ( p_encoded => FND_API.G_FALSE
122: , p_count => x_msg_count
123: , p_data => x_msg_data
124: );
125: END IF;

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

122: , p_count => x_msg_count
123: , p_data => x_msg_data
124: );
125: END IF;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: IF (x_msg_data IS NULL) THEN
129: FND_MSG_PUB.Count_And_Get
130: ( p_encoded => FND_API.G_FALSE

Line 127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

123: , p_data => x_msg_data
124: );
125: END IF;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: IF (x_msg_data IS NULL) THEN
129: FND_MSG_PUB.Count_And_Get
130: ( p_encoded => FND_API.G_FALSE
131: , p_count => x_msg_count

Line 130: ( p_encoded => FND_API.G_FALSE

126: x_return_status := FND_API.G_RET_STS_ERROR;
127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
128: IF (x_msg_data IS NULL) THEN
129: FND_MSG_PUB.Count_And_Get
130: ( p_encoded => FND_API.G_FALSE
131: , p_count => x_msg_count
132: , p_data => x_msg_data
133: );
134: END IF;

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

131: , p_count => x_msg_count
132: , p_data => x_msg_data
133: );
134: END IF;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: WHEN NO_DATA_FOUND THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: IF (x_msg_data IS NOT NULL) THEN
139: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133: );
134: END IF;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: WHEN NO_DATA_FOUND THEN
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138: IF (x_msg_data IS NOT NULL) THEN
139: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';
140: ELSE
141: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

140: ELSE
141: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';
142: END IF;
143: WHEN OTHERS THEN
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: IF (x_msg_data IS NOT NULL) THEN
146: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';
147: ELSE
148: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Custom_Region_items ';

Line 155: , p_commit IN VARCHAR2 := FND_API.G_FALSE

151: END Update_Custom_Region_Items;
152:
153: PROCEDURE Create_Custom_Region_Items_UI
154: ( p_api_version IN NUMBER
155: , p_commit IN VARCHAR2 := FND_API.G_FALSE
156: , p_customization_application_id IN NUMBER
157: , p_customization_code IN VARCHAR2
158: , p_region_application_id IN NUMBER
159: , p_region_code IN VARCHAR2

Line 174: x_return_status := FND_API.G_RET_STS_SUCCESS;

170:
171: l_custom_region_items_rec BIS_CUSTOMIZATION_PUB.custom_region_items_type;
172: BEGIN
173: FND_MSG_PUB.Initialize;
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:
176: l_custom_region_items_rec.customization_application_id := p_customization_application_id;
177: l_custom_region_items_rec.customization_code := p_customization_code;
178: l_custom_region_items_rec.region_application_id := p_region_application_id;

Line 196: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

192: , x_return_status => x_return_status
193: , x_msg_count => x_msg_count
194: , x_msg_data => x_msg_data
195: );
196: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
197: FND_MESSAGE.SET_NAME('BIS','BIS_CUSTOMIZATION_FAIL');
198: FND_MSG_PUB.ADD;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;

Line 199: RAISE FND_API.G_EXC_ERROR;

195: );
196: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
197: FND_MESSAGE.SET_NAME('BIS','BIS_CUSTOMIZATION_FAIL');
198: FND_MSG_PUB.ADD;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN
203: IF (x_msg_data IS NULL) THEN

Line 202: WHEN FND_API.G_EXC_ERROR THEN

198: FND_MSG_PUB.ADD;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN
203: IF (x_msg_data IS NULL) THEN
204: FND_MSG_PUB.Count_And_Get
205: ( p_encoded => FND_API.G_FALSE
206: , p_count => x_msg_count

Line 205: ( p_encoded => FND_API.G_FALSE

201: EXCEPTION
202: WHEN FND_API.G_EXC_ERROR THEN
203: IF (x_msg_data IS NULL) THEN
204: FND_MSG_PUB.Count_And_Get
205: ( p_encoded => FND_API.G_FALSE
206: , p_count => x_msg_count
207: , p_data => x_msg_data
208: );
209: END IF;

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206: , p_count => x_msg_count
207: , p_data => x_msg_data
208: );
209: END IF;
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: WHEN OTHERS THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF (x_msg_data IS NOT NULL) THEN
214: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Custom_region_items_UI ';

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

208: );
209: END IF;
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: WHEN OTHERS THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF (x_msg_data IS NOT NULL) THEN
214: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Custom_region_items_UI ';
215: ELSE
216: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Create_Custom_region_items_UI ';

Line 226: , p_commit IN VARCHAR2 := FND_API.G_FALSE

222: -- updates rows into ak_custom_region_items and tl tables
223: --
224: PROCEDURE Update_Custom_Region_Items_UI
225: ( p_api_version IN NUMBER
226: , p_commit IN VARCHAR2 := FND_API.G_FALSE
227: , p_customization_application_id IN NUMBER
228: , p_customization_code IN VARCHAR2
229: , p_region_application_id IN NUMBER
230: , p_region_code IN VARCHAR2

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241:
242: l_custom_region_items_rec BIS_CUSTOMIZATION_PUB.custom_region_items_type;
243: BEGIN
244: FND_MSG_PUB.Initialize;
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246:
247: l_custom_region_items_rec.customization_application_id := p_customization_application_id;
248: l_custom_region_items_rec.customization_code := p_customization_code;
249: l_custom_region_items_rec.region_application_id := p_region_application_id;

Line 267: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

263: , x_return_status => x_return_status
264: , x_msg_count => x_msg_count
265: , x_msg_data => x_msg_data
266: );
267: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
268: FND_MESSAGE.SET_NAME('BSC','BIS_CUSTOMIZATION_FAIL');
269: FND_MSG_PUB.ADD;
270: RAISE FND_API.G_EXC_ERROR;
271: END IF;

Line 270: RAISE FND_API.G_EXC_ERROR;

266: );
267: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
268: FND_MESSAGE.SET_NAME('BSC','BIS_CUSTOMIZATION_FAIL');
269: FND_MSG_PUB.ADD;
270: RAISE FND_API.G_EXC_ERROR;
271: END IF;
272:
273:
274: EXCEPTION

Line 275: WHEN FND_API.G_EXC_ERROR THEN

271: END IF;
272:
273:
274: EXCEPTION
275: WHEN FND_API.G_EXC_ERROR THEN
276: IF (x_msg_data IS NULL) THEN
277: FND_MSG_PUB.Count_And_Get
278: ( p_encoded => FND_API.G_FALSE
279: , p_count => x_msg_count

Line 278: ( p_encoded => FND_API.G_FALSE

274: EXCEPTION
275: WHEN FND_API.G_EXC_ERROR THEN
276: IF (x_msg_data IS NULL) THEN
277: FND_MSG_PUB.Count_And_Get
278: ( p_encoded => FND_API.G_FALSE
279: , p_count => x_msg_count
280: , p_data => x_msg_data
281: );
282: END IF;

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

279: , p_count => x_msg_count
280: , p_data => x_msg_data
281: );
282: END IF;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: IF (x_msg_data IS NOT NULL) THEN
287: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Custom_region_items_UI ';

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281: );
282: END IF;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: WHEN OTHERS THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: IF (x_msg_data IS NOT NULL) THEN
287: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Custom_region_items_UI ';
288: ELSE
289: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Custom_region_items_UI ';

Line 296: , p_commit IN VARCHAR2 := FND_API.G_FALSE

292: END Update_Custom_region_items_UI;
293:
294: PROCEDURE Delete_Custom_Region_Items
295: ( p_api_version IN NUMBER
296: , p_commit IN VARCHAR2 := FND_API.G_FALSE
297: , p_Custom_Region_Items_Rec IN BIS_CUSTOMIZATION_PUB.custom_Region_Items_type
298: , x_return_status OUT NOCOPY VARCHAR2
299: , x_msg_count OUT NOCOPY NUMBER
300: , x_msg_data OUT NOCOPY VARCHAR2

Line 306: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

302: IS
303: BEGIN
304:
305: FND_MSG_PUB.Initialize;
306: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
307:
308: BIS_CUSTOMIZATION_PVT.Delete_Custom_Region_Items
309: ( p_api_version => p_api_version
310: , p_commit => p_commit

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_ERROR;
318: END IF;
319:
320: EXCEPTION

Line 317: RAISE FND_API.G_EXC_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_ERROR;
318: END IF;
319:
320: EXCEPTION
321: WHEN FND_API.G_EXC_ERROR THEN

Line 321: WHEN FND_API.G_EXC_ERROR THEN

317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319:
320: EXCEPTION
321: WHEN FND_API.G_EXC_ERROR THEN
322: IF (x_msg_data IS NULL) THEN
323: FND_MSG_PUB.Count_And_Get
324: ( p_encoded => FND_API.G_FALSE
325: , p_count => x_msg_count

Line 324: ( p_encoded => FND_API.G_FALSE

320: EXCEPTION
321: WHEN FND_API.G_EXC_ERROR THEN
322: IF (x_msg_data IS NULL) THEN
323: FND_MSG_PUB.Count_And_Get
324: ( p_encoded => FND_API.G_FALSE
325: , p_count => x_msg_count
326: , p_data => x_msg_data
327: );
328: END IF;

Line 329: x_return_status := FND_API.G_RET_STS_ERROR;

325: , p_count => x_msg_count
326: , p_data => x_msg_data
327: );
328: END IF;
329: x_return_status := FND_API.G_RET_STS_ERROR;
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: IF (x_msg_data IS NULL) THEN
332: FND_MSG_PUB.Count_And_Get
333: ( p_encoded => FND_API.G_FALSE

Line 330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

326: , p_data => x_msg_data
327: );
328: END IF;
329: x_return_status := FND_API.G_RET_STS_ERROR;
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: IF (x_msg_data IS NULL) THEN
332: FND_MSG_PUB.Count_And_Get
333: ( p_encoded => FND_API.G_FALSE
334: , p_count => x_msg_count

Line 333: ( p_encoded => FND_API.G_FALSE

329: x_return_status := FND_API.G_RET_STS_ERROR;
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331: IF (x_msg_data IS NULL) THEN
332: FND_MSG_PUB.Count_And_Get
333: ( p_encoded => FND_API.G_FALSE
334: , p_count => x_msg_count
335: , p_data => x_msg_data
336: );
337: END IF;

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334: , p_count => x_msg_count
335: , p_data => x_msg_data
336: );
337: END IF;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: WHEN NO_DATA_FOUND THEN
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
341: IF (x_msg_data IS NOT NULL) THEN
342: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';

Line 340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

336: );
337: END IF;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: WHEN NO_DATA_FOUND THEN
340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
341: IF (x_msg_data IS NOT NULL) THEN
342: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';
343: ELSE
344: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

343: ELSE
344: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';
345: END IF;
346: WHEN OTHERS THEN
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: IF (x_msg_data IS NOT NULL) THEN
349: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';
350: ELSE
351: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Delete_Custom_Region_items ';

Line 358: , p_commit IN VARCHAR2 := FND_API.G_FALSE

354: END Delete_Custom_Region_Items;
355:
356: PROCEDURE Delete_Custom_Region_Items_UI
357: ( p_api_version IN NUMBER
358: , p_commit IN VARCHAR2 := FND_API.G_FALSE
359: , p_customization_application_id IN NUMBER
360: , p_customization_code IN VARCHAR2
361: , p_region_application_id IN NUMBER
362: , p_region_code IN VARCHAR2

Line 373: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

369: ) IS
370: l_custom_region_items_rec BIS_CUSTOMIZATION_PUB.custom_region_items_type;
371: BEGIN
372: FND_MSG_PUB.Initialize;
373: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
374:
375: l_custom_region_items_rec.customization_application_id := p_customization_application_id;
376: l_custom_region_items_rec.customization_code := p_customization_code;
377: l_custom_region_items_rec.region_application_id := p_region_application_id;

Line 391: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

387: , x_return_status => x_return_status
388: , x_msg_count => x_msg_count
389: , x_msg_data => x_msg_data);
390:
391: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
392: FND_MESSAGE.SET_NAME('BSC','BIS_CUSTOMIZATION_FAIL');
393: FND_MSG_PUB.ADD;
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;

Line 394: RAISE FND_API.G_EXC_ERROR;

390:
391: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
392: FND_MESSAGE.SET_NAME('BSC','BIS_CUSTOMIZATION_FAIL');
393: FND_MSG_PUB.ADD;
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397:
398: EXCEPTION

Line 399: WHEN FND_API.G_EXC_ERROR THEN

395: END IF;
396:
397:
398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN
400: IF (x_msg_data IS NULL) THEN
401: FND_MSG_PUB.Count_And_Get
402: ( p_encoded => FND_API.G_FALSE
403: , p_count => x_msg_count

Line 402: ( p_encoded => FND_API.G_FALSE

398: EXCEPTION
399: WHEN FND_API.G_EXC_ERROR THEN
400: IF (x_msg_data IS NULL) THEN
401: FND_MSG_PUB.Count_And_Get
402: ( p_encoded => FND_API.G_FALSE
403: , p_count => x_msg_count
404: , p_data => x_msg_data
405: );
406: END IF;

Line 407: x_return_status := FND_API.G_RET_STS_ERROR;

403: , p_count => x_msg_count
404: , p_data => x_msg_data
405: );
406: END IF;
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: WHEN OTHERS THEN
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: IF (x_msg_data IS NOT NULL) THEN
411: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Delete_Custom_region_items_UI ';

Line 409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

405: );
406: END IF;
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: WHEN OTHERS THEN
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: IF (x_msg_data IS NOT NULL) THEN
411: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Delete_Custom_region_items_UI ';
412: ELSE
413: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Delete_Custom_region_items_UI ';

Line 420: , p_commit IN VARCHAR2 := FND_API.G_FALSE

416: END Delete_Custom_Region_Items_UI;
417:
418: PROCEDURE Create_Customizations
419: ( p_api_version IN NUMBER
420: , p_commit IN VARCHAR2 := FND_API.G_FALSE
421: , p_Customizations_Rec IN BIS_CUSTOMIZATION_PUB.customizations_type
422: , x_return_status OUT NOCOPY VARCHAR2
423: , x_msg_count OUT NOCOPY NUMBER
424: , x_msg_data OUT NOCOPY VARCHAR2)

Line 429: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

425: IS
426:
427: BEGIN
428: FND_MSG_PUB.Initialize;
429: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
430:
431: BIS_CUSTOMIZATION_PVT.Create_Customizations
432: ( p_api_version => p_api_version
433: , p_commit => p_commit

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

436: , x_msg_count => x_msg_count
437: , x_msg_data => x_msg_data
438: );
439:
440: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN

Line 441: RAISE FND_API.G_EXC_ERROR;

437: , x_msg_data => x_msg_data
438: );
439:
440: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445: IF (x_msg_data IS NULL) THEN

Line 444: WHEN FND_API.G_EXC_ERROR THEN

440: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445: IF (x_msg_data IS NULL) THEN
446: FND_MSG_PUB.Count_And_Get
447: ( p_encoded => FND_API.G_FALSE
448: , p_count => x_msg_count

Line 447: ( p_encoded => FND_API.G_FALSE

443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445: IF (x_msg_data IS NULL) THEN
446: FND_MSG_PUB.Count_And_Get
447: ( p_encoded => FND_API.G_FALSE
448: , p_count => x_msg_count
449: , p_data => x_msg_data
450: );
451: END IF;

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

448: , p_count => x_msg_count
449: , p_data => x_msg_data
450: );
451: END IF;
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: IF (x_msg_data IS NULL) THEN
455: FND_MSG_PUB.Count_And_Get
456: ( p_encoded => FND_API.G_FALSE

Line 453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

449: , p_data => x_msg_data
450: );
451: END IF;
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: IF (x_msg_data IS NULL) THEN
455: FND_MSG_PUB.Count_And_Get
456: ( p_encoded => FND_API.G_FALSE
457: , p_count => x_msg_count

Line 456: ( p_encoded => FND_API.G_FALSE

452: x_return_status := FND_API.G_RET_STS_ERROR;
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: IF (x_msg_data IS NULL) THEN
455: FND_MSG_PUB.Count_And_Get
456: ( p_encoded => FND_API.G_FALSE
457: , p_count => x_msg_count
458: , p_data => x_msg_data
459: );
460: END IF;

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: , p_count => x_msg_count
458: , p_data => x_msg_data
459: );
460: END IF;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: WHEN NO_DATA_FOUND THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF (x_msg_data IS NOT NULL) THEN
465: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Customizations ';

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

459: );
460: END IF;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: WHEN NO_DATA_FOUND THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: IF (x_msg_data IS NOT NULL) THEN
465: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Customizations ';
466: ELSE
467: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Create_Customizations ';

Line 470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

466: ELSE
467: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Create_Customizations ';
468: END IF;
469: WHEN OTHERS THEN
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: IF (x_msg_data IS NOT NULL) THEN
472: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Customizations ';
473: ELSE
474: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Create_Customizations ';

Line 482: , p_commit IN VARCHAR2 := FND_API.G_FALSE

478: --
479:
480: PROCEDURE Update_Customizations
481: ( p_api_version IN NUMBER
482: , p_commit IN VARCHAR2 := FND_API.G_FALSE
483: , p_Customizations_Rec IN BIS_CUSTOMIZATION_PUB.customizations_type
484: , x_return_status OUT NOCOPY VARCHAR2
485: , x_msg_count OUT NOCOPY NUMBER
486: , x_msg_data OUT NOCOPY VARCHAR2

Line 491: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

487: )
488: IS
489: BEGIN
490: FND_MSG_PUB.Initialize;
491: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
492:
493:
494: BIS_CUSTOMIZATION_PVT.Update_Customizations
495: ( p_api_version => p_api_version

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

499: , x_msg_count => x_msg_count
500: , x_msg_data => x_msg_data
501: );
502:
503: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: EXCEPTION

Line 504: RAISE FND_API.G_EXC_ERROR;

500: , x_msg_data => x_msg_data
501: );
502:
503: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN

Line 508: WHEN FND_API.G_EXC_ERROR THEN

504: RAISE FND_API.G_EXC_ERROR;
505: END IF;
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: IF (x_msg_data IS NULL) THEN
510: FND_MSG_PUB.Count_And_Get
511: ( p_encoded => FND_API.G_FALSE
512: , p_count => x_msg_count

Line 511: ( p_encoded => FND_API.G_FALSE

507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: IF (x_msg_data IS NULL) THEN
510: FND_MSG_PUB.Count_And_Get
511: ( p_encoded => FND_API.G_FALSE
512: , p_count => x_msg_count
513: , p_data => x_msg_data
514: );
515: END IF;

Line 516: x_return_status := FND_API.G_RET_STS_ERROR;

512: , p_count => x_msg_count
513: , p_data => x_msg_data
514: );
515: END IF;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: IF (x_msg_data IS NULL) THEN
519: FND_MSG_PUB.Count_And_Get
520: ( p_encoded => FND_API.G_FALSE

Line 517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

513: , p_data => x_msg_data
514: );
515: END IF;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: IF (x_msg_data IS NULL) THEN
519: FND_MSG_PUB.Count_And_Get
520: ( p_encoded => FND_API.G_FALSE
521: , p_count => x_msg_count

Line 520: ( p_encoded => FND_API.G_FALSE

516: x_return_status := FND_API.G_RET_STS_ERROR;
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: IF (x_msg_data IS NULL) THEN
519: FND_MSG_PUB.Count_And_Get
520: ( p_encoded => FND_API.G_FALSE
521: , p_count => x_msg_count
522: , p_data => x_msg_data
523: );
524: END IF;

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

521: , p_count => x_msg_count
522: , p_data => x_msg_data
523: );
524: END IF;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: WHEN NO_DATA_FOUND THEN
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: IF (x_msg_data IS NOT NULL) THEN
529: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Customizations ';

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

523: );
524: END IF;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: WHEN NO_DATA_FOUND THEN
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: IF (x_msg_data IS NOT NULL) THEN
529: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Customizations ';
530: ELSE
531: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Customizations ';

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

530: ELSE
531: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Customizations ';
532: END IF;
533: WHEN OTHERS THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF (x_msg_data IS NOT NULL) THEN
536: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Customizations ';
537: ELSE
538: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Customizations ';

Line 546: , p_commit IN VARCHAR2 := FND_API.G_FALSE

542:
543:
544: PROCEDURE Create_Customizations_UI
545: ( p_api_version IN NUMBER
546: , p_commit IN VARCHAR2 := FND_API.G_FALSE
547: , p_customization_application_id IN NUMBER
548: , p_customization_code IN VARCHAR2
549: , p_region_application_id IN NUMBER
550: , p_region_code IN VARCHAR2

Line 574: x_return_status := FND_API.G_RET_STS_SUCCESS;

570: IS
571: l_customizations_rec BIS_CUSTOMIZATION_PUB.customizations_type;
572: BEGIN
573: FND_MSG_PUB.Initialize;
574: x_return_status := FND_API.G_RET_STS_SUCCESS;
575:
576: l_customizations_rec.customization_application_id := p_customization_application_id;
577: l_customizations_rec.customization_code := p_customization_code;
578: l_customizations_rec.region_application_id := p_region_application_id;

Line 605: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

601: , x_msg_count => x_msg_count
602: , x_msg_data => x_msg_data
603: );
604:
605: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
606: FND_MESSAGE.SET_NAME('BSC','BIS_CUSTOMIZATION_FAIL');
607: FND_MSG_PUB.ADD;
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;

Line 608: RAISE FND_API.G_EXC_ERROR;

604:
605: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
606: FND_MESSAGE.SET_NAME('BSC','BIS_CUSTOMIZATION_FAIL');
607: FND_MSG_PUB.ADD;
608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: EXCEPTION
612: WHEN FND_API.G_EXC_ERROR THEN

Line 612: WHEN FND_API.G_EXC_ERROR THEN

608: RAISE FND_API.G_EXC_ERROR;
609: END IF;
610:
611: EXCEPTION
612: WHEN FND_API.G_EXC_ERROR THEN
613: IF (x_msg_data IS NULL) THEN
614: FND_MSG_PUB.Count_And_Get
615: ( p_encoded => FND_API.G_FALSE
616: , p_count => x_msg_count

Line 615: ( p_encoded => FND_API.G_FALSE

611: EXCEPTION
612: WHEN FND_API.G_EXC_ERROR THEN
613: IF (x_msg_data IS NULL) THEN
614: FND_MSG_PUB.Count_And_Get
615: ( p_encoded => FND_API.G_FALSE
616: , p_count => x_msg_count
617: , p_data => x_msg_data
618: );
619: END IF;

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: , p_count => x_msg_count
617: , p_data => x_msg_data
618: );
619: END IF;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: WHEN OTHERS THEN
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: IF (x_msg_data IS NOT NULL) THEN
624: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Customizations_UI ';

Line 622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

618: );
619: END IF;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: WHEN OTHERS THEN
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: IF (x_msg_data IS NOT NULL) THEN
624: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Create_Customizations_UI ';
625: ELSE
626: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Create_Customizations_UI ';

Line 633: , p_commit IN VARCHAR2 := FND_API.G_FALSE

629: END Create_Customizations_UI;
630:
631: PROCEDURE Update_Customizations_UI
632: ( p_api_version IN NUMBER
633: , p_commit IN VARCHAR2 := FND_API.G_FALSE
634: , p_customization_application_id IN NUMBER
635: , p_customization_code IN VARCHAR2
636: , p_region_application_id IN NUMBER
637: , p_region_code IN VARCHAR2

Line 661: x_return_status := FND_API.G_RET_STS_SUCCESS;

657: IS
658: l_customizations_rec BIS_CUSTOMIZATION_PUB.customizations_type;
659: BEGIN
660: FND_MSG_PUB.Initialize;
661: x_return_status := FND_API.G_RET_STS_SUCCESS;
662:
663: l_customizations_rec.customization_application_id := p_customization_application_id;
664: l_customizations_rec.customization_code := p_customization_code;
665: l_customizations_rec.region_application_id := p_region_application_id;

Line 692: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

688: , x_msg_count => x_msg_count
689: , x_msg_data => x_msg_data
690: );
691:
692: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
693: FND_MESSAGE.SET_NAME('BSC','BIS_CUSTOMIZATION_FAIL');
694: FND_MSG_PUB.ADD;
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;

Line 695: RAISE FND_API.G_EXC_ERROR;

691:
692: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
693: FND_MESSAGE.SET_NAME('BSC','BIS_CUSTOMIZATION_FAIL');
694: FND_MSG_PUB.ADD;
695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697:
698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN

Line 699: WHEN FND_API.G_EXC_ERROR THEN

695: RAISE FND_API.G_EXC_ERROR;
696: END IF;
697:
698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN
700: IF (x_msg_data IS NULL) THEN
701: FND_MSG_PUB.Count_And_Get
702: ( p_encoded => FND_API.G_FALSE
703: , p_count => x_msg_count

Line 702: ( p_encoded => FND_API.G_FALSE

698: EXCEPTION
699: WHEN FND_API.G_EXC_ERROR THEN
700: IF (x_msg_data IS NULL) THEN
701: FND_MSG_PUB.Count_And_Get
702: ( p_encoded => FND_API.G_FALSE
703: , p_count => x_msg_count
704: , p_data => x_msg_data
705: );
706: END IF;

Line 707: x_return_status := FND_API.G_RET_STS_ERROR;

703: , p_count => x_msg_count
704: , p_data => x_msg_data
705: );
706: END IF;
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: WHEN OTHERS THEN
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: IF (x_msg_data IS NOT NULL) THEN
711: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Customizations_UI ';

Line 709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

705: );
706: END IF;
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: WHEN OTHERS THEN
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: IF (x_msg_data IS NOT NULL) THEN
711: x_msg_data := x_msg_data||' -> BIS_CUSTOMIZATION_PUB.Update_Customizations_UI ';
712: ELSE
713: x_msg_data := SQLERRM||' at BIS_CUSTOMIZATION_PUB.Update_Customizations_UI ';