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.BSC_DIMENSION_GROUPS_PUB dependencies on FND_API

Line 62: p_commit IN varchar2 := FND_API.G_FALSE

58: --: for the API for the Dimension Group entity.
59: --: This procedure is part of the Dimension Group API.
60:
61: procedure Create_Dimension_Group(
62: p_commit IN varchar2 := FND_API.G_FALSE
63: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
64: ,p_create_Dim_Levels IN BOOLEAN
65: ,x_return_status OUT NOCOPY varchar2
66: ,x_msg_count OUT NOCOPY number

Line 73: x_return_status := FND_API.G_RET_STS_SUCCESS;

69:
70: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
71:
72: begin
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74: FND_MSG_PUB.Initialize;
75: -- Assign all values in the passed "Record" parameter to the locally defined
76: -- "Record" variable.
77: l_Dim_Grp_Rec := p_Dim_Grp_Rec;

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

146: ,l_Dim_Grp_Rec
147: ,x_return_status
148: ,x_msg_count
149: ,x_msg_data);
150: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153: END IF;
154:

Line 151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

147: ,x_return_status
148: ,x_msg_count
149: ,x_msg_data);
150: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
152: END IF;
153: END IF;
154:
155: /* else

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

165: ,l_Dim_Grp_Rec
166: ,x_return_status
167: ,x_msg_count
168: ,x_msg_data);
169: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172: END IF;
173: end if;*/

Line 170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

166: ,x_return_status
167: ,x_msg_count
168: ,x_msg_data);
169: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172: END IF;
173: end if;*/
174:

Line 180: RAISE FND_API.G_EXC_ERROR;

176:
177: FND_MESSAGE.SET_NAME('BSC','BSC_GROUP_NAME_NOT_ENTERED');
178: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
179: FND_MSG_PUB.ADD;
180: RAISE FND_API.G_EXC_ERROR;
181:
182: end if;
183:
184:

Line 186: WHEN FND_API.G_EXC_ERROR THEN

182: end if;
183:
184:
185: EXCEPTION
186: WHEN FND_API.G_EXC_ERROR THEN
187: IF (x_msg_data IS NULL) THEN
188: FND_MSG_PUB.Count_And_Get
189: ( p_encoded => 'F'
190: , p_count => x_msg_count

Line 194: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

190: , p_count => x_msg_count
191: , p_data => x_msg_data
192: );
193: END IF;
194: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: IF (x_msg_data IS NULL) THEN
198: FND_MSG_PUB.Count_And_Get

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: , p_data => x_msg_data
192: );
193: END IF;
194: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: IF (x_msg_data IS NULL) THEN
198: FND_MSG_PUB.Count_And_Get
199: ( p_encoded => 'F'

Line 196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

192: );
193: END IF;
194: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: IF (x_msg_data IS NULL) THEN
198: FND_MSG_PUB.Count_And_Get
199: ( p_encoded => 'F'
200: , p_count => x_msg_count

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

200: , p_count => x_msg_count
201: , p_data => x_msg_data
202: );
203: END IF;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
206: WHEN NO_DATA_FOUND THEN
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (x_msg_data IS NOT NULL) THEN

Line 205: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

201: , p_data => x_msg_data
202: );
203: END IF;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
206: WHEN NO_DATA_FOUND THEN
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (x_msg_data IS NOT NULL) THEN
209: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

203: END IF;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
206: WHEN NO_DATA_FOUND THEN
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (x_msg_data IS NOT NULL) THEN
209: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';
210: ELSE
211: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';

Line 215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

211: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';
212: END IF;
213: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
214: WHEN OTHERS THEN
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: IF (x_msg_data IS NOT NULL) THEN
217: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';
218: ELSE
219: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';

Line 226: p_commit IN varchar2 := FND_API.G_FALSE

222: end Create_Dimension_Group;
223:
224:
225: procedure Create_Dimension_Group(
226: p_commit IN varchar2 := FND_API.G_FALSE
227: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
228: ,x_return_status OUT NOCOPY varchar2
229: ,x_msg_count OUT NOCOPY number
230: ,x_msg_data OUT NOCOPY varchar2

Line 239: x_return_status := FND_API.G_RET_STS_SUCCESS;

235: BEGIN
236: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
237: l_Dim_Grp_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Grp_Rec.Bsc_Last_Update_Date, SYSDATE);
238:
239: x_return_status := FND_API.G_RET_STS_SUCCESS;
240: Create_Dimension_Group(
241: p_commit => p_commit
242: ,p_Dim_Grp_Rec => l_Dim_Grp_Rec
243: ,p_create_Dim_Levels => TRUE

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

244: ,x_return_status => x_return_status
245: ,x_msg_count => x_msg_count
246: ,x_msg_data => x_msg_data
247: );
248: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN

Line 249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

245: ,x_msg_count => x_msg_count
246: ,x_msg_data => x_msg_data
247: );
248: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: IF (x_msg_data IS NULL) THEN

Line 252: WHEN FND_API.G_EXC_ERROR THEN

248: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: IF (x_msg_data IS NULL) THEN
254: FND_MSG_PUB.Count_And_Get
255: ( p_encoded => 'F'
256: , p_count => x_msg_count

Line 260: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

256: , p_count => x_msg_count
257: , p_data => x_msg_data
258: );
259: END IF;
260: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: IF (x_msg_data IS NULL) THEN
264: FND_MSG_PUB.Count_And_Get

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: , p_data => x_msg_data
258: );
259: END IF;
260: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: IF (x_msg_data IS NULL) THEN
264: FND_MSG_PUB.Count_And_Get
265: ( p_encoded => 'F'

Line 262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

258: );
259: END IF;
260: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: IF (x_msg_data IS NULL) THEN
264: FND_MSG_PUB.Count_And_Get
265: ( p_encoded => 'F'
266: , p_count => x_msg_count

Line 270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

266: , p_count => x_msg_count
267: , p_data => x_msg_data
268: );
269: END IF;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
272: WHEN NO_DATA_FOUND THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: IF (x_msg_data IS NOT NULL) THEN

Line 271: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

267: , p_data => x_msg_data
268: );
269: END IF;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
272: WHEN NO_DATA_FOUND THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: IF (x_msg_data IS NOT NULL) THEN
275: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

269: END IF;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
272: WHEN NO_DATA_FOUND THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: IF (x_msg_data IS NOT NULL) THEN
275: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';
276: ELSE
277: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

277: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';
278: END IF;
279: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
280: WHEN OTHERS THEN
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: IF (x_msg_data IS NOT NULL) THEN
283: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';
284: ELSE
285: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group ';

Line 293: p_commit IN varchar2 := FND_API.G_FALSE

289: /************************************************************************************
290: ************************************************************************************/
291:
292: procedure Retrieve_Dimension_Group(
293: p_commit IN varchar2 := FND_API.G_FALSE
294: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
295: ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
296: ,x_return_status OUT NOCOPY varchar2
297: ,x_msg_count OUT NOCOPY number

Line 302: x_return_status := FND_API.G_RET_STS_SUCCESS;

298: ,x_msg_data OUT NOCOPY varchar2
299: ) is
300:
301: begin
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303: BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group( p_commit
304: ,p_Dim_Grp_Rec
305: ,x_Dim_Grp_Rec
306: ,x_return_status

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

312: ,x_Dim_Grp_Rec
313: ,x_return_status
314: ,x_msg_count
315: ,x_msg_data);
316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319: EXCEPTION
320: WHEN FND_API.G_EXC_ERROR THEN

Line 317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

313: ,x_return_status
314: ,x_msg_count
315: ,x_msg_data);
316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319: EXCEPTION
320: WHEN FND_API.G_EXC_ERROR THEN
321: IF (x_msg_data IS NULL) THEN

Line 320: WHEN FND_API.G_EXC_ERROR THEN

316: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: END IF;
319: EXCEPTION
320: WHEN FND_API.G_EXC_ERROR THEN
321: IF (x_msg_data IS NULL) THEN
322: FND_MSG_PUB.Count_And_Get
323: ( p_encoded => 'F'
324: , p_count => x_msg_count

Line 328: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

324: , p_count => x_msg_count
325: , p_data => x_msg_data
326: );
327: END IF;
328: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
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

Line 329: x_return_status := FND_API.G_RET_STS_ERROR;

325: , p_data => x_msg_data
326: );
327: END IF;
328: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
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 => 'F'

Line 330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

326: );
327: END IF;
328: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
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 => 'F'
334: , p_count => x_msg_count

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: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
340: WHEN NO_DATA_FOUND THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: IF (x_msg_data IS NOT NULL) THEN

Line 339: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

335: , p_data => x_msg_data
336: );
337: END IF;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
340: WHEN NO_DATA_FOUND THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: IF (x_msg_data IS NOT NULL) THEN
343: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Retrieve_Dimension_Group ';

Line 341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

337: END IF;
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
340: WHEN NO_DATA_FOUND THEN
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
342: IF (x_msg_data IS NOT NULL) THEN
343: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Retrieve_Dimension_Group ';
344: ELSE
345: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Retrieve_Dimension_Group ';

Line 349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

345: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Retrieve_Dimension_Group ';
346: END IF;
347: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: IF (x_msg_data IS NOT NULL) THEN
351: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Retrieve_Dimension_Group ';
352: ELSE
353: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Retrieve_Dimension_Group ';

Line 363: p_commit IN varchar2 := FND_API.G_FALSE

359: /************************************************************************************
360: ************************************************************************************/
361:
362: procedure Update_Dimension_Group(
363: p_commit IN varchar2 := FND_API.G_FALSE
364: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
365: ,p_create_Dim_Levels IN BOOLEAN
366: ,x_return_status OUT NOCOPY varchar2
367: ,x_msg_count OUT NOCOPY number

Line 376: x_return_status := FND_API.G_RET_STS_SUCCESS;

372: begin
373:
374: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
375: l_Dim_Grp_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Grp_Rec.Bsc_Last_Update_Date, SYSDATE);
376: x_return_status := FND_API.G_RET_STS_SUCCESS;
377:
378: BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group( p_commit
379: ,l_Dim_Grp_Rec
380: ,x_return_status

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

385: ,p_Dim_Grp_Rec
386: ,x_return_status
387: ,x_msg_count
388: ,x_msg_data);
389: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: END IF;
392: END IF;
393:

Line 390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

386: ,x_return_status
387: ,x_msg_count
388: ,x_msg_data);
389: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
391: END IF;
392: END IF;
393:
394: EXCEPTION

Line 395: WHEN FND_API.G_EXC_ERROR THEN

391: END IF;
392: END IF;
393:
394: EXCEPTION
395: WHEN FND_API.G_EXC_ERROR THEN
396: IF (x_msg_data IS NULL) THEN
397: FND_MSG_PUB.Count_And_Get
398: ( p_encoded => 'F'
399: , p_count => x_msg_count

Line 403: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

399: , p_count => x_msg_count
400: , p_data => x_msg_data
401: );
402: END IF;
403: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: IF (x_msg_data IS NULL) THEN
407: FND_MSG_PUB.Count_And_Get

Line 404: x_return_status := FND_API.G_RET_STS_ERROR;

400: , p_data => x_msg_data
401: );
402: END IF;
403: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: IF (x_msg_data IS NULL) THEN
407: FND_MSG_PUB.Count_And_Get
408: ( p_encoded => 'F'

Line 405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

401: );
402: END IF;
403: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
404: x_return_status := FND_API.G_RET_STS_ERROR;
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: IF (x_msg_data IS NULL) THEN
407: FND_MSG_PUB.Count_And_Get
408: ( p_encoded => 'F'
409: , p_count => x_msg_count

Line 413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

409: , p_count => x_msg_count
410: , p_data => x_msg_data
411: );
412: END IF;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
415: WHEN NO_DATA_FOUND THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: IF (x_msg_data IS NOT NULL) THEN

Line 414: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

410: , p_data => x_msg_data
411: );
412: END IF;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
415: WHEN NO_DATA_FOUND THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: IF (x_msg_data IS NOT NULL) THEN
418: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

412: END IF;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
415: WHEN NO_DATA_FOUND THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: IF (x_msg_data IS NOT NULL) THEN
418: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';
419: ELSE
420: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';

Line 424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

420: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';
421: END IF;
422: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
423: WHEN OTHERS THEN
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: IF (x_msg_data IS NOT NULL) THEN
426: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';
427: ELSE
428: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';

Line 436: p_commit IN varchar2 := FND_API.G_FALSE

432: END Update_Dimension_Group;
433:
434:
435: procedure Update_Dimension_Group(
436: p_commit IN varchar2 := FND_API.G_FALSE
437: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
438: ,x_return_status OUT NOCOPY varchar2
439: ,x_msg_count OUT NOCOPY number
440: ,x_msg_data OUT NOCOPY varchar2

Line 448: x_return_status := FND_API.G_RET_STS_SUCCESS;

444: begin
445: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
446: l_Dim_Grp_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Grp_Rec.Bsc_Last_Update_Date, SYSDATE);
447:
448: x_return_status := FND_API.G_RET_STS_SUCCESS;
449: Update_Dimension_Group(
450: p_commit => p_commit
451: ,p_Dim_Grp_Rec => l_Dim_Grp_Rec
452: ,p_create_Dim_Levels => TRUE

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

453: ,x_return_status => x_return_status
454: ,x_msg_count => x_msg_count
455: ,x_msg_data => x_msg_data
456: );
457: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460: EXCEPTION
461: WHEN FND_API.G_EXC_ERROR THEN

Line 458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

454: ,x_msg_count => x_msg_count
455: ,x_msg_data => x_msg_data
456: );
457: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460: EXCEPTION
461: WHEN FND_API.G_EXC_ERROR THEN
462: IF (x_msg_data IS NULL) THEN

Line 461: WHEN FND_API.G_EXC_ERROR THEN

457: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
459: END IF;
460: EXCEPTION
461: WHEN FND_API.G_EXC_ERROR THEN
462: IF (x_msg_data IS NULL) THEN
463: FND_MSG_PUB.Count_And_Get
464: ( p_encoded => 'F'
465: , p_count => x_msg_count

Line 469: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

465: , p_count => x_msg_count
466: , p_data => x_msg_data
467: );
468: END IF;
469: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472: IF (x_msg_data IS NULL) THEN
473: FND_MSG_PUB.Count_And_Get

Line 470: x_return_status := FND_API.G_RET_STS_ERROR;

466: , p_data => x_msg_data
467: );
468: END IF;
469: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472: IF (x_msg_data IS NULL) THEN
473: FND_MSG_PUB.Count_And_Get
474: ( p_encoded => 'F'

Line 471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

467: );
468: END IF;
469: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472: IF (x_msg_data IS NULL) THEN
473: FND_MSG_PUB.Count_And_Get
474: ( p_encoded => 'F'
475: , p_count => x_msg_count

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

475: , p_count => x_msg_count
476: , p_data => x_msg_data
477: );
478: END IF;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
481: WHEN NO_DATA_FOUND THEN
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: IF (x_msg_data IS NOT NULL) THEN

Line 480: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

476: , p_data => x_msg_data
477: );
478: END IF;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
481: WHEN NO_DATA_FOUND THEN
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: IF (x_msg_data IS NOT NULL) THEN
484: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';

Line 482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

478: END IF;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
481: WHEN NO_DATA_FOUND THEN
482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
483: IF (x_msg_data IS NOT NULL) THEN
484: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';
485: ELSE
486: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';

Line 490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

486: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';
487: END IF;
488: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
489: WHEN OTHERS THEN
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: IF (x_msg_data IS NOT NULL) THEN
492: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';
493: ELSE
494: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group ';

Line 506: p_commit IN varchar2 := FND_API.G_FALSE

502:
503: --: This procedure is part of the Dimension Group API.
504:
505: procedure Delete_Dimension_Group(
506: p_commit IN varchar2 := FND_API.G_FALSE
507: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
508: ,x_return_status OUT NOCOPY varchar2
509: ,x_msg_count OUT NOCOPY number
510: ,x_msg_data OUT NOCOPY varchar2

Line 514: x_return_status := FND_API.G_RET_STS_SUCCESS;

510: ,x_msg_data OUT NOCOPY varchar2
511: )is
512:
513: begin
514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515: -- When deleting dimension groups the first thing to do is to delete
516: -- the dimension levels from the group.
517: Delete_Dim_Levels_In_Group( p_commit
518: ,p_Dim_Grp_Rec

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

518: ,p_Dim_Grp_Rec
519: ,x_return_status
520: ,x_msg_count
521: ,x_msg_data);
522: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group( p_commit
526: ,p_Dim_Grp_Rec

Line 523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

519: ,x_return_status
520: ,x_msg_count
521: ,x_msg_data);
522: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
524: END IF;
525: BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group( p_commit
526: ,p_Dim_Grp_Rec
527: ,x_return_status

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529: ,x_msg_data);
530:
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: IF (x_msg_data IS NULL) THEN
535: FND_MSG_PUB.Count_And_Get
536: ( p_encoded => 'F'
537: , p_count => x_msg_count

Line 541: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

537: , p_count => x_msg_count
538: , p_data => x_msg_data
539: );
540: END IF;
541: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: IF (x_msg_data IS NULL) THEN
545: FND_MSG_PUB.Count_And_Get

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538: , p_data => x_msg_data
539: );
540: END IF;
541: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: IF (x_msg_data IS NULL) THEN
545: FND_MSG_PUB.Count_And_Get
546: ( p_encoded => 'F'

Line 543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

539: );
540: END IF;
541: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
544: IF (x_msg_data IS NULL) THEN
545: FND_MSG_PUB.Count_And_Get
546: ( p_encoded => 'F'
547: , p_count => x_msg_count

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: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
553: WHEN NO_DATA_FOUND THEN
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555: IF (x_msg_data IS NOT NULL) THEN

Line 552: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

548: , p_data => x_msg_data
549: );
550: END IF;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
553: WHEN NO_DATA_FOUND THEN
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||' -> BSC_DIMENSION_GROUPS_PUB.Delete_Dimension_Group ';

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: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
553: WHEN NO_DATA_FOUND THEN
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||' -> BSC_DIMENSION_GROUPS_PUB.Delete_Dimension_Group ';
557: ELSE
558: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Delete_Dimension_Group ';

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

558: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Delete_Dimension_Group ';
559: END IF;
560: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
561: WHEN OTHERS THEN
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||' -> BSC_DIMENSION_GROUPS_PUB.Delete_Dimension_Group ';
565: ELSE
566: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Delete_Dimension_Group ';

Line 579: p_commit IN varchar2 := FND_API.G_FALSE

575: --: This procedure assigns the dimension to the dimension group.
576: --: This procedure is part of the Dimension Group API.
577:
578: procedure Create_Dim_Levels_In_Group(
579: p_commit IN varchar2 := FND_API.G_FALSE
580: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
581: ,x_return_status OUT NOCOPY varchar2
582: ,x_msg_count OUT NOCOPY number
583: ,x_msg_data OUT NOCOPY varchar2

Line 599: x_return_status := FND_API.G_RET_STS_SUCCESS;

595: l_comp_disp_name bsc_sys_dim_levels_vl.comp_disp_name%TYPE;
596: l_Dim_Grp_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
597: begin
598:
599: x_return_status := FND_API.G_RET_STS_SUCCESS;
600: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
601:
602: dim_properties_default_values (
603: x_dim_level_index => l_dim_level_index

Line 646: WHEN FND_API.G_EXC_ERROR THEN

642: ,x_msg_count
643: ,x_msg_data);
644:
645: EXCEPTION
646: WHEN FND_API.G_EXC_ERROR THEN
647: IF (x_msg_data IS NULL) THEN
648: FND_MSG_PUB.Count_And_Get
649: ( p_encoded => 'F'
650: , p_count => x_msg_count

Line 654: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

650: , p_count => x_msg_count
651: , p_data => x_msg_data
652: );
653: END IF;
654: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: IF (x_msg_data IS NULL) THEN
658: FND_MSG_PUB.Count_And_Get

Line 655: x_return_status := FND_API.G_RET_STS_ERROR;

651: , p_data => x_msg_data
652: );
653: END IF;
654: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: IF (x_msg_data IS NULL) THEN
658: FND_MSG_PUB.Count_And_Get
659: ( p_encoded => 'F'

Line 656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

652: );
653: END IF;
654: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: IF (x_msg_data IS NULL) THEN
658: FND_MSG_PUB.Count_And_Get
659: ( p_encoded => 'F'
660: , p_count => x_msg_count

Line 664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

660: , p_count => x_msg_count
661: , p_data => x_msg_data
662: );
663: END IF;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
666: WHEN NO_DATA_FOUND THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: IF (x_msg_data IS NOT NULL) THEN

Line 665: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

661: , p_data => x_msg_data
662: );
663: END IF;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
666: WHEN NO_DATA_FOUND THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: IF (x_msg_data IS NOT NULL) THEN
669: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Create_Dim_Levels_In_Group ';

Line 667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

663: END IF;
664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
665: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
666: WHEN NO_DATA_FOUND THEN
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: IF (x_msg_data IS NOT NULL) THEN
669: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Create_Dim_Levels_In_Group ';
670: ELSE
671: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Create_Dim_Levels_In_Group ';

Line 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Create_Dim_Levels_In_Group ';
672: END IF;
673: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
674: WHEN OTHERS THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF (x_msg_data IS NOT NULL) THEN
677: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Create_Dim_Levels_In_Group ';
678: ELSE
679: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Create_Dim_Levels_In_Group ';

Line 689: p_commit IN varchar2 := FND_API.G_FALSE

685: /************************************************************************************
686: ************************************************************************************/
687:
688: procedure Retrieve_Dim_Levels_In_Group(
689: p_commit IN varchar2 := FND_API.G_FALSE
690: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
691: ,x_Dim_Grp_Rec IN OUT NOCOPY BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
692: ,x_return_status OUT NOCOPY varchar2
693: ,x_msg_count OUT NOCOPY number

Line 698: x_return_status := FND_API.G_RET_STS_SUCCESS;

694: ,x_msg_data OUT NOCOPY varchar2
695: ) is
696:
697: begin
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699: BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Levels_In_Group( p_commit
700: ,p_Dim_Grp_Rec
701: ,x_Dim_Grp_Rec
702: ,x_return_status

Line 707: WHEN FND_API.G_EXC_ERROR THEN

703: ,x_msg_count
704: ,x_msg_data);
705:
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: IF (x_msg_data IS NULL) THEN
709: FND_MSG_PUB.Count_And_Get
710: ( p_encoded => 'F'
711: , p_count => x_msg_count

Line 715: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

711: , p_count => x_msg_count
712: , p_data => x_msg_data
713: );
714: END IF;
715: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: IF (x_msg_data IS NULL) THEN
719: FND_MSG_PUB.Count_And_Get

Line 716: x_return_status := FND_API.G_RET_STS_ERROR;

712: , p_data => x_msg_data
713: );
714: END IF;
715: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: IF (x_msg_data IS NULL) THEN
719: FND_MSG_PUB.Count_And_Get
720: ( p_encoded => 'F'

Line 717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

713: );
714: END IF;
715: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: IF (x_msg_data IS NULL) THEN
719: FND_MSG_PUB.Count_And_Get
720: ( p_encoded => 'F'
721: , p_count => x_msg_count

Line 725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

721: , p_count => x_msg_count
722: , p_data => x_msg_data
723: );
724: END IF;
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
727: WHEN NO_DATA_FOUND THEN
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729: IF (x_msg_data IS NOT NULL) THEN

Line 726: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

722: , p_data => x_msg_data
723: );
724: END IF;
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
727: WHEN NO_DATA_FOUND THEN
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729: IF (x_msg_data IS NOT NULL) THEN
730: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Retrieve_Dim_Levels_In_Group ';

Line 728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

724: END IF;
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
727: WHEN NO_DATA_FOUND THEN
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729: IF (x_msg_data IS NOT NULL) THEN
730: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Retrieve_Dim_Levels_In_Group ';
731: ELSE
732: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Retrieve_Dim_Levels_In_Group ';

Line 736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

732: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Retrieve_Dim_Levels_In_Group ';
733: END IF;
734: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
735: WHEN OTHERS THEN
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF (x_msg_data IS NOT NULL) THEN
738: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Retrieve_Dim_Levels_In_Group ';
739: ELSE
740: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Retrieve_Dim_Levels_In_Group ';

Line 750: p_commit IN varchar2 := FND_API.G_FALSE

746: /************************************************************************************
747: ************************************************************************************/
748:
749: procedure Update_Dim_Levels_In_Group(
750: p_commit IN varchar2 := FND_API.G_FALSE
751: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
752: ,x_return_status OUT NOCOPY varchar2
753: ,x_msg_count OUT NOCOPY number
754: ,x_msg_data OUT NOCOPY varchar2

Line 758: x_return_status := FND_API.G_RET_STS_SUCCESS;

754: ,x_msg_data OUT NOCOPY varchar2
755: ) is
756:
757: begin
758: x_return_status := FND_API.G_RET_STS_SUCCESS;
759: BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group( p_commit
760: ,p_Dim_Grp_Rec
761: ,x_return_status
762: ,x_msg_count

Line 766: WHEN FND_API.G_EXC_ERROR THEN

762: ,x_msg_count
763: ,x_msg_data);
764:
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: IF (x_msg_data IS NULL) THEN
768: FND_MSG_PUB.Count_And_Get
769: ( p_encoded => 'F'
770: , p_count => x_msg_count

Line 774: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

770: , p_count => x_msg_count
771: , p_data => x_msg_data
772: );
773: END IF;
774: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: IF (x_msg_data IS NULL) THEN
778: FND_MSG_PUB.Count_And_Get

Line 775: x_return_status := FND_API.G_RET_STS_ERROR;

771: , p_data => x_msg_data
772: );
773: END IF;
774: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: IF (x_msg_data IS NULL) THEN
778: FND_MSG_PUB.Count_And_Get
779: ( p_encoded => 'F'

Line 776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

772: );
773: END IF;
774: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777: IF (x_msg_data IS NULL) THEN
778: FND_MSG_PUB.Count_And_Get
779: ( p_encoded => 'F'
780: , p_count => x_msg_count

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

780: , p_count => x_msg_count
781: , p_data => x_msg_data
782: );
783: END IF;
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
786: WHEN NO_DATA_FOUND THEN
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788: IF (x_msg_data IS NOT NULL) THEN

Line 785: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

781: , p_data => x_msg_data
782: );
783: END IF;
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
786: WHEN NO_DATA_FOUND THEN
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788: IF (x_msg_data IS NOT NULL) THEN
789: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group ';

Line 787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

783: END IF;
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
786: WHEN NO_DATA_FOUND THEN
787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788: IF (x_msg_data IS NOT NULL) THEN
789: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group ';
790: ELSE
791: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group ';

Line 795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

791: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group ';
792: END IF;
793: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
794: WHEN OTHERS THEN
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: IF (x_msg_data IS NOT NULL) THEN
797: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group ';
798: ELSE
799: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group ';

Line 811: p_commit IN varchar2 := FND_API.G_FALSE

807:
808: --: This procedure deletes dimensions from dimension groups.
809:
810: procedure Delete_Dim_Levels_In_Group(
811: p_commit IN varchar2 := FND_API.G_FALSE
812: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
813: ,x_return_status OUT NOCOPY varchar2
814: ,x_msg_count OUT NOCOPY number
815: ,x_msg_data OUT NOCOPY varchar2

Line 819: x_return_status := FND_API.G_RET_STS_SUCCESS;

815: ,x_msg_data OUT NOCOPY varchar2
816: ) is
817:
818: begin
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
820: BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group( p_commit
821: ,p_Dim_Grp_Rec
822: ,x_return_status
823: ,x_msg_count

Line 827: WHEN FND_API.G_EXC_ERROR THEN

823: ,x_msg_count
824: ,x_msg_data);
825:
826: EXCEPTION
827: WHEN FND_API.G_EXC_ERROR THEN
828: IF (x_msg_data IS NULL) THEN
829: FND_MSG_PUB.Count_And_Get
830: ( p_encoded => 'F'
831: , p_count => x_msg_count

Line 835: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

831: , p_count => x_msg_count
832: , p_data => x_msg_data
833: );
834: END IF;
835: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
838: IF (x_msg_data IS NULL) THEN
839: FND_MSG_PUB.Count_And_Get

Line 836: x_return_status := FND_API.G_RET_STS_ERROR;

832: , p_data => x_msg_data
833: );
834: END IF;
835: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
838: IF (x_msg_data IS NULL) THEN
839: FND_MSG_PUB.Count_And_Get
840: ( p_encoded => 'F'

Line 837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

833: );
834: END IF;
835: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
836: x_return_status := FND_API.G_RET_STS_ERROR;
837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
838: IF (x_msg_data IS NULL) THEN
839: FND_MSG_PUB.Count_And_Get
840: ( p_encoded => 'F'
841: , p_count => x_msg_count

Line 845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

841: , p_count => x_msg_count
842: , p_data => x_msg_data
843: );
844: END IF;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
847: WHEN NO_DATA_FOUND THEN
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: IF (x_msg_data IS NOT NULL) THEN

Line 846: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

842: , p_data => x_msg_data
843: );
844: END IF;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
847: WHEN NO_DATA_FOUND THEN
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: IF (x_msg_data IS NOT NULL) THEN
850: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group ';

Line 848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

844: END IF;
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
847: WHEN NO_DATA_FOUND THEN
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: IF (x_msg_data IS NOT NULL) THEN
850: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group ';
851: ELSE
852: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group ';

Line 856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

852: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group ';
853: END IF;
854: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
855: WHEN OTHERS THEN
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: IF (x_msg_data IS NOT NULL) THEN
858: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group ';
859: ELSE
860: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group ';

Line 914: x_return_status := FND_API.G_RET_STS_SUCCESS;

910: WHERE short_name = cp_dim_level_shortname;
911:
912: BEGIN
913:
914: x_return_status := FND_API.G_RET_STS_SUCCESS;
915:
916: -- group
917: IF (c_dim_group%ISOPEN) THEN
918: CLOSE c_dim_group;

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

953:
954: l_dim_grp_rec_out.bsc_level_id := l_dim_level_id;
955: l_dim_grp_rec_out.Bsc_Dim_Level_Group_Id := l_dim_group_id;
956:
957: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
958: x_return_status := C_DEFAULT_DATA;
959: END IF;
960: ELSE
961: x_return_status := C_DEFAULT_DATA;

Line 999: WHEN FND_API.G_EXC_ERROR THEN

995:
996: END IF;
997:
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: IF (c_dim_group%ISOPEN) THEN
1001: CLOSE c_dim_group;
1002: END IF;
1003: IF (c_dim_level%ISOPEN) THEN

Line 1013: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1009: , p_count => x_msg_count
1010: , p_data => x_msg_data
1011: );
1012: END IF;
1013: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: IF (c_dim_group%ISOPEN) THEN
1017: CLOSE c_dim_group;

Line 1014: x_return_status := FND_API.G_RET_STS_ERROR;

1010: , p_data => x_msg_data
1011: );
1012: END IF;
1013: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: IF (c_dim_group%ISOPEN) THEN
1017: CLOSE c_dim_group;
1018: END IF;

Line 1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1011: );
1012: END IF;
1013: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: IF (c_dim_group%ISOPEN) THEN
1017: CLOSE c_dim_group;
1018: END IF;
1019: IF (c_dim_level%ISOPEN) THEN

Line 1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1025: , p_count => x_msg_count
1026: , p_data => x_msg_data
1027: );
1028: END IF;
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1031: WHEN OTHERS THEN
1032: IF (c_dim_group%ISOPEN) THEN
1033: CLOSE c_dim_group;

Line 1030: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1026: , p_data => x_msg_data
1027: );
1028: END IF;
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1030: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1031: WHEN OTHERS THEN
1032: IF (c_dim_group%ISOPEN) THEN
1033: CLOSE c_dim_group;
1034: END IF;

Line 1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1034: END IF;
1035: IF (c_dim_level%ISOPEN) THEN
1036: CLOSE c_dim_level;
1037: END IF;
1038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1039: IF (x_msg_data IS NOT NULL) THEN
1040: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Retrieve_Sys_Dim_Lvls_Grp_Wrap ';
1041: ELSE
1042: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.Retrieve_Sys_Dim_Lvls_Grp_Wrap ';

Line 1098: x_return_status := FND_API.G_RET_STS_SUCCESS;

1094: l_dim_grp_rec BSC_DIMENSION_GROUPS_PUB.BSC_DIM_GROUP_REC_TYPE;
1095: l_dim_level_id NUMBER;
1096: l_dim_group_id NUMBER;
1097: BEGIN
1098: x_return_status := FND_API.G_RET_STS_SUCCESS;
1099: FND_MSG_PUB.Initialize;
1100: IF (p_all_id NOT IN (0, -1)) THEN
1101: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_ALL_ID');
1102: FND_MSG_PUB.ADD;

Line 1103: RAISE FND_API.G_EXC_ERROR;

1099: FND_MSG_PUB.Initialize;
1100: IF (p_all_id NOT IN (0, -1)) THEN
1101: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_ALL_ID');
1102: FND_MSG_PUB.ADD;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105: -- Dimension level short name in bsc_sys_dim_levels_b should be same as dimension
1106: -- level short name in bis_levels.
1107: SELECT dim_level_id

Line 1128: p_commit => FND_API.G_TRUE

1124: l_dim_grp_rec.bsc_dim_level_group_id := l_dim_group_id;
1125: l_dim_grp_rec.bsc_group_level_total_flag := p_all_id;
1126:
1127: BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group(
1128: p_commit => FND_API.G_TRUE
1129: ,p_dim_grp_rec => l_dim_grp_rec
1130: ,x_return_status => x_return_status
1131: ,x_msg_count => x_msg_count
1132: ,x_msg_data => x_msg_data

Line 1136: WHEN FND_API.G_EXC_ERROR THEN

1132: ,x_msg_data => x_msg_data
1133: );
1134:
1135: EXCEPTION
1136: WHEN FND_API.G_EXC_ERROR THEN
1137: IF (x_msg_data IS NULL) THEN
1138: FND_MSG_PUB.Count_And_Get
1139: ( p_encoded => 'F'
1140: , p_count => x_msg_count

Line 1144: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1140: , p_count => x_msg_count
1141: , p_data => x_msg_data
1142: );
1143: END IF;
1144: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1147: IF (x_msg_data IS NULL) THEN
1148: FND_MSG_PUB.Count_And_Get

Line 1145: x_return_status := FND_API.G_RET_STS_ERROR;

1141: , p_data => x_msg_data
1142: );
1143: END IF;
1144: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1147: IF (x_msg_data IS NULL) THEN
1148: FND_MSG_PUB.Count_And_Get
1149: ( p_encoded => 'F'

Line 1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1142: );
1143: END IF;
1144: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1147: IF (x_msg_data IS NULL) THEN
1148: FND_MSG_PUB.Count_And_Get
1149: ( p_encoded => 'F'
1150: , p_count => x_msg_count

Line 1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1150: , p_count => x_msg_count
1151: , p_data => x_msg_data
1152: );
1153: END IF;
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1156: WHEN NO_DATA_FOUND THEN
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158: IF (x_msg_data IS NOT NULL) THEN

Line 1155: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1151: , p_data => x_msg_data
1152: );
1153: END IF;
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1156: WHEN NO_DATA_FOUND THEN
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158: IF (x_msg_data IS NOT NULL) THEN
1159: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.set_dim_lvl_grp_prop_wrap ';

Line 1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1153: END IF;
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1156: WHEN NO_DATA_FOUND THEN
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158: IF (x_msg_data IS NOT NULL) THEN
1159: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.set_dim_lvl_grp_prop_wrap ';
1160: ELSE
1161: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.set_dim_lvl_grp_prop_wrap ';

Line 1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1161: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.set_dim_lvl_grp_prop_wrap ';
1162: END IF;
1163: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1164: WHEN OTHERS THEN
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: IF (x_msg_data IS NOT NULL) THEN
1167: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.set_dim_lvl_grp_prop_wrap ';
1168: ELSE
1169: x_msg_data := SQLERRM||' at BSC_DIMENSION_GROUPS_PUB.set_dim_lvl_grp_prop_wrap ';

Line 1194: WHEN FND_API.G_EXC_ERROR THEN

1190: return BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( p_table_name
1191: ,p_column_name);
1192: EXCEPTION
1193:
1194: WHEN FND_API.G_EXC_ERROR THEN
1195: l_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1197: ,p_data => l_msg_data);
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1195: l_return_status := FND_API.G_RET_STS_ERROR;

1191: ,p_column_name);
1192: EXCEPTION
1193:
1194: WHEN FND_API.G_EXC_ERROR THEN
1195: l_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1197: ,p_data => l_msg_data);
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1194: WHEN FND_API.G_EXC_ERROR THEN
1195: l_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1197: ,p_data => l_msg_data);
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1200: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1201: ,p_data => l_msg_data);
1202: raise;

Line 1199: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1195: l_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1197: ,p_data => l_msg_data);
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1200: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1201: ,p_data => l_msg_data);
1202: raise;
1203: WHEN NO_DATA_FOUND THEN

Line 1204: l_return_status := FND_API.G_RET_STS_ERROR;

1200: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1201: ,p_data => l_msg_data);
1202: raise;
1203: WHEN NO_DATA_FOUND THEN
1204: l_return_status := FND_API.G_RET_STS_ERROR;
1205: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1206: ,p_data => l_msg_data);
1207: raise;
1208: WHEN OTHERS THEN

Line 1209: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1205: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1206: ,p_data => l_msg_data);
1207: raise;
1208: WHEN OTHERS THEN
1209: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1211: ,p_data => l_msg_data);
1212: raise;
1213: end Get_Next_Value;

Line 1220: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

1216: /* Used only by PMF for "All" enhancement to upload bisdimlv.ldt.
1217: * Called from BISDIMLV.lct
1218: */
1219: PROCEDURE Translate_Dimension_Group
1220: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
1221: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1222: ,x_return_status OUT NOCOPY VARCHAR2
1223: ,x_msg_count OUT NOCOPY NUMBER
1224: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1255: WHEN FND_API.G_EXC_ERROR THEN

1251: ,x_msg_data => x_msg_data
1252: );
1253:
1254: EXCEPTION
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: FND_MSG_PUB.Count_And_Get(
1258: p_encoded => 'F'
1259: ,p_count => x_msg_count

Line 1256: x_return_status := FND_API.G_RET_STS_ERROR;

1252: );
1253:
1254: EXCEPTION
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: FND_MSG_PUB.Count_And_Get(
1258: p_encoded => 'F'
1259: ,p_count => x_msg_count
1260: ,p_data => x_msg_data

Line 1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1258: p_encoded => 'F'
1259: ,p_count => x_msg_count
1260: ,p_data => x_msg_data
1261: );
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: FND_MSG_PUB.Count_And_Get(
1265: p_encoded => 'F'
1266: ,p_count => x_msg_count

Line 1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1259: ,p_count => x_msg_count
1260: ,p_data => x_msg_data
1261: );
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: FND_MSG_PUB.Count_And_Get(
1265: p_encoded => 'F'
1266: ,p_count => x_msg_count
1267: ,p_data => x_msg_data

Line 1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1266: ,p_count => x_msg_count
1267: ,p_data => x_msg_data
1268: );
1269: WHEN OTHERS THEN
1270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1271: IF (x_msg_data IS NOT NULL) THEN
1272: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.Translate_Dimension_Group ';
1273: ELSE
1274: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.Translate_Dimension_Group '||SQLERRM;

Line 1337: p_commit IN VARCHAR2 := FND_API.G_FALSE

1333: * where the bisdimlv.ldt is uploaded to BSC data model.
1334: */
1335:
1336: PROCEDURE load_dimension_group (
1337: p_commit IN VARCHAR2 := FND_API.G_FALSE
1338: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1339: ,x_return_status OUT NOCOPY VARCHAR2
1340: ,x_msg_count OUT NOCOPY NUMBER
1341: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1352: x_return_status := FND_API.G_RET_STS_SUCCESS;

1348: l_owner_name VARCHAR2(100);
1349: l_ret_code BOOLEAN;
1350: BEGIN
1351:
1352: x_return_status := FND_API.G_RET_STS_SUCCESS;
1353: l_Bsc_Dim_Group_Rec.Bsc_Dim_Level_Group_Short_Name := p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name;
1354: l_Bsc_Dim_Group_Rec.Bsc_Created_By := p_Dim_Grp_Rec.Bsc_Created_By;
1355: l_Bsc_Dim_Group_Rec.Bsc_Last_Updated_By := p_Dim_Grp_Rec.Bsc_Last_Updated_By;
1356:

Line 1398: p_commit => FND_API.G_TRUE

1394: );
1395: IF (l_ret_code) THEN
1396:
1397: BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group(
1398: p_commit => FND_API.G_TRUE
1399: ,p_Dim_Grp_Rec => l_Bsc_Dim_Group_Rec
1400: ,p_create_Dim_Levels => FALSE
1401: ,x_return_status => x_return_status
1402: ,x_msg_count => x_msg_count

Line 1409: p_commit => FND_API.G_TRUE

1405: END IF;
1406: ELSE
1407:
1408: BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group(
1409: p_commit => FND_API.G_TRUE
1410: ,p_Dim_Grp_Rec => l_Bsc_Dim_Group_Rec
1411: ,p_create_Dim_Levels => FALSE
1412: ,x_return_status => x_return_status
1413: ,x_msg_count => x_msg_count

Line 1420: WHEN FND_API.G_EXC_ERROR THEN

1416:
1417: END IF;
1418:
1419: EXCEPTION
1420: WHEN FND_API.G_EXC_ERROR THEN
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: FND_MSG_PUB.Count_And_Get(
1423: p_encoded => 'F'
1424: ,p_count => x_msg_count

Line 1421: x_return_status := FND_API.G_RET_STS_ERROR;

1417: END IF;
1418:
1419: EXCEPTION
1420: WHEN FND_API.G_EXC_ERROR THEN
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: FND_MSG_PUB.Count_And_Get(
1423: p_encoded => 'F'
1424: ,p_count => x_msg_count
1425: ,p_data => x_msg_data

Line 1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1423: p_encoded => 'F'
1424: ,p_count => x_msg_count
1425: ,p_data => x_msg_data
1426: );
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: FND_MSG_PUB.Count_And_Get(
1430: p_encoded => 'F'
1431: ,p_count => x_msg_count

Line 1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1424: ,p_count => x_msg_count
1425: ,p_data => x_msg_data
1426: );
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: FND_MSG_PUB.Count_And_Get(
1430: p_encoded => 'F'
1431: ,p_count => x_msg_count
1432: ,p_data => x_msg_data

Line 1435: x_return_status := FND_API.G_RET_STS_ERROR;

1431: ,p_count => x_msg_count
1432: ,p_data => x_msg_data
1433: );
1434: WHEN NO_DATA_FOUND THEN
1435: x_return_status := FND_API.G_RET_STS_ERROR;
1436: IF (x_msg_data IS NOT NULL) THEN
1437: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.load_dimension_group ';
1438: ELSE
1439: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.load_dimension_group '||SQLERRM;

Line 1442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1438: ELSE
1439: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.load_dimension_group '||SQLERRM;
1440: END IF;
1441: WHEN OTHERS THEN
1442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1443: IF (x_msg_data IS NOT NULL) THEN
1444: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.load_dimension_group ';
1445: ELSE
1446: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.load_dimension_group '||SQLERRM;

Line 1456: p_commit IN VARCHAR2 := FND_API.G_FALSE

1452: /* This API is used only by PMF as of now for "All" enhancement
1453: * where the bisdimlv.ldt is uploaded to BSC data model.
1454: */
1455: PROCEDURE load_dim_levels_in_group(
1456: p_commit IN VARCHAR2 := FND_API.G_FALSE
1457: ,p_Bsc_Pmf_Dim_Rec IN BSC_PMF_UI_API_PUB.Bsc_Pmf_Dim_Rec_Type
1458: ,p_Dim_Grp_Rec IN BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type
1459: ,x_return_status OUT NOCOPY VARCHAR2
1460: ,x_msg_count OUT NOCOPY NUMBER

Line 1468: x_return_status := FND_API.G_RET_STS_SUCCESS;

1464: l_rel_count NUMBER;
1465: l_Bsc_Dim_Group_Rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1466: BEGIN
1467:
1468: x_return_status := FND_API.G_RET_STS_SUCCESS;
1469: l_Bsc_Dim_Group_Rec := p_Dim_Grp_Rec;
1470:
1471: SELECT dim_level_id
1472: INTO l_Bsc_Dim_Group_Rec.Bsc_Level_Id

Line 1511: WHEN FND_API.G_EXC_ERROR THEN

1507:
1508: END IF;
1509:
1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get
1514: ( p_encoded => 'F'
1515: , p_count => x_msg_count

Line 1512: x_return_status := FND_API.G_RET_STS_ERROR;

1508: END IF;
1509:
1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: x_return_status := FND_API.G_RET_STS_ERROR;
1513: FND_MSG_PUB.Count_And_Get
1514: ( p_encoded => 'F'
1515: , p_count => x_msg_count
1516: , p_data => x_msg_data

Line 1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1514: ( p_encoded => 'F'
1515: , p_count => x_msg_count
1516: , p_data => x_msg_data
1517: );
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: FND_MSG_PUB.Count_And_Get
1521: ( p_encoded => 'F'
1522: , p_count => x_msg_count

Line 1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1515: , p_count => x_msg_count
1516: , p_data => x_msg_data
1517: );
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: FND_MSG_PUB.Count_And_Get
1521: ( p_encoded => 'F'
1522: , p_count => x_msg_count
1523: , p_data => x_msg_data

Line 1526: x_return_status := FND_API.G_RET_STS_ERROR;

1522: , p_count => x_msg_count
1523: , p_data => x_msg_data
1524: );
1525: WHEN NO_DATA_FOUND THEN
1526: x_return_status := FND_API.G_RET_STS_ERROR;
1527: IF (x_msg_data IS NOT NULL) THEN
1528: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.load_dim_levels_in_group ';
1529: ELSE
1530: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.load_dim_levels_in_group '||SQLERRM;

Line 1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1529: ELSE
1530: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.load_dim_levels_in_group '||SQLERRM;
1531: END IF;
1532: WHEN OTHERS THEN
1533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1534: IF (x_msg_data IS NOT NULL) THEN
1535: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.load_dim_levels_in_group ';
1536: ELSE
1537: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.load_dim_levels_in_group '||SQLERRM;

Line 1557: x_return_status := FND_API.G_RET_STS_SUCCESS;

1553: WHERE short_name = cp_short_name;
1554:
1555: BEGIN
1556:
1557: x_return_status := FND_API.G_RET_STS_SUCCESS;
1558:
1559: IF (c_dim_grp_id%ISOPEN) THEN
1560: CLOSE c_dim_grp_id;
1561: END IF;

Line 1572: x_return_status := FND_API.G_RET_STS_ERROR ;

1568: WHEN NO_DATA_FOUND THEN
1569: IF (c_dim_grp_id%ISOPEN) THEN
1570: CLOSE c_dim_grp_id;
1571: END IF;
1572: x_return_status := FND_API.G_RET_STS_ERROR ;
1573: IF (x_msg_data IS NOT NULL) THEN
1574: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.ret_dimgrpid_fr_shname ';
1575: ELSE
1576: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.ret_dimgrpid_fr_shname '||SQLERRM;

Line 1578: WHEN FND_API.G_EXC_ERROR THEN

1574: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.ret_dimgrpid_fr_shname ';
1575: ELSE
1576: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.ret_dimgrpid_fr_shname '||SQLERRM;
1577: END IF;
1578: WHEN FND_API.G_EXC_ERROR THEN
1579: IF (c_dim_grp_id%ISOPEN) THEN
1580: CLOSE c_dim_grp_id;
1581: END IF;
1582: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1582: x_return_status := FND_API.G_RET_STS_ERROR ;

1578: WHEN FND_API.G_EXC_ERROR THEN
1579: IF (c_dim_grp_id%ISOPEN) THEN
1580: CLOSE c_dim_grp_id;
1581: END IF;
1582: x_return_status := FND_API.G_RET_STS_ERROR ;
1583: FND_MSG_PUB.Count_And_Get(
1584: p_encoded => 'F'
1585: ,p_count => x_msg_count
1586: ,p_data => x_msg_data

Line 1588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1584: p_encoded => 'F'
1585: ,p_count => x_msg_count
1586: ,p_data => x_msg_data
1587: );
1588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1589: IF (c_dim_grp_id%ISOPEN) THEN
1590: CLOSE c_dim_grp_id;
1591: END IF;
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1589: IF (c_dim_grp_id%ISOPEN) THEN
1590: CLOSE c_dim_grp_id;
1591: END IF;
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1593: FND_MSG_PUB.Count_And_Get(
1594: p_encoded => 'F'
1595: ,p_count => x_msg_count
1596: ,p_data => x_msg_data

Line 1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1598: WHEN OTHERS THEN
1599: IF (c_dim_grp_id%ISOPEN) THEN
1600: CLOSE c_dim_grp_id;
1601: END IF;
1602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1603: IF (x_msg_data IS NOT NULL) THEN
1604: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PUB.ret_dimgrpid_fr_shname ';
1605: ELSE
1606: x_msg_data := 'BSC_DIMENSION_GROUPS_PUB.ret_dimgrpid_fr_shname '||SQLERRM;

Line 1630: p_commit => FND_API.G_FALSE

1626:
1627: BEGIN
1628: BSC_DIMENSION_GROUPS_PVT.Translate_Dim_By_Given_Lang
1629: (
1630: p_commit => FND_API.G_FALSE
1631: , p_Dim_Grp_Rec => p_Dim_Grp_Rec
1632: , x_return_status => x_return_status
1633: , x_msg_count => x_msg_count
1634: , x_msg_data => x_msg_data

Line 1638: WHEN FND_API.G_EXC_ERROR THEN

1634: , x_msg_data => x_msg_data
1635: );
1636:
1637: EXCEPTION
1638: WHEN FND_API.G_EXC_ERROR THEN
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1641: ,p_data => x_msg_data);
1642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1639: x_return_status := FND_API.G_RET_STS_ERROR;

1635: );
1636:
1637: EXCEPTION
1638: WHEN FND_API.G_EXC_ERROR THEN
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1641: ,p_data => x_msg_data);
1642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1638: WHEN FND_API.G_EXC_ERROR THEN
1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1641: ,p_data => x_msg_data);
1642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1645: ,p_data => x_msg_data);
1646: WHEN NO_DATA_FOUND THEN

Line 1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1639: x_return_status := FND_API.G_RET_STS_ERROR;
1640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1641: ,p_data => x_msg_data);
1642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1645: ,p_data => x_msg_data);
1646: WHEN NO_DATA_FOUND THEN
1647: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1647: x_return_status := FND_API.G_RET_STS_ERROR;

1643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1644: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1645: ,p_data => x_msg_data);
1646: WHEN NO_DATA_FOUND THEN
1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1649: ,p_data => x_msg_data);
1650: WHEN OTHERS THEN
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1647: x_return_status := FND_API.G_RET_STS_ERROR;
1648: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1649: ,p_data => x_msg_data);
1650: WHEN OTHERS THEN
1651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1652: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1653: ,p_data => x_msg_data);
1654: END Translate_Dim_By_Given_Lang;
1655: