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

Line 10: p_commit IN varchar2 -- := FND_API.G_FALSE

6: -- Return x_return_status = 'DISABLE' if it disables one or more common
7: -- Dimension in the Checking.
8: -------------------------------------------------------------------------------------------------------------------
9: PROCEDURE Check_Common_Dim_Levels(
10: p_commit IN varchar2 -- := FND_API.G_FALSE
11: ,p_Tab_Id IN number
12: ,x_return_status OUT NOCOPY varchar2
13: ,x_msg_count OUT NOCOPY number
14: ,x_msg_data OUT NOCOPY varchar2

Line 30: x_return_status := FND_API.G_RET_STS_SUCCESS;

26:
27:
28: BEGIN
29: FND_MSG_PUB.Initialize;
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: SAVEPOINT BSCCheDimLevsPUB;
32: --DBMS_OUTPUT.PUT_LINE('Begin Check_Common_Dim_Levels' );
33: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels p_Tab_Id = ' || p_Tab_Id );
34: -- Get the Common Dimension Level already define in the DB.

Line 104: BSC_SCORECARD_PUB.Update_Tab_Time_Stamp( FND_API.G_FALSE

100: IF l_deleted_rows <> 0 THEN
101: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels - l_deleted_rows = '||l_deleted_rows);
102:
103: l_Bsc_Tab_Entity_Rec.Bsc_Tab_Id:=p_Tab_Id;
104: BSC_SCORECARD_PUB.Update_Tab_Time_Stamp( FND_API.G_FALSE
105: ,l_Bsc_Tab_Entity_Rec
106: ,x_return_status
107: ,x_msg_count
108: ,x_msg_data

Line 121: WHEN FND_API.G_EXC_ERROR THEN

117: commit;
118: */
119:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO BSCCheDimLevsPUB;
123: FND_MSG_PUB.Count_And_Get
124: ( p_encoded => FND_API.G_FALSE
125: , p_count => x_msg_count

Line 124: ( p_encoded => FND_API.G_FALSE

120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO BSCCheDimLevsPUB;
123: FND_MSG_PUB.Count_And_Get
124: ( p_encoded => FND_API.G_FALSE
125: , p_count => x_msg_count
126: , p_data => x_msg_data
127: );
128: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

124: ( p_encoded => FND_API.G_FALSE
125: , p_count => x_msg_count
126: , p_data => x_msg_data
127: );
128: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: RAISE;
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO BSCCheDimLevsPUB;

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: , p_count => x_msg_count
126: , p_data => x_msg_data
127: );
128: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: RAISE;
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO BSCCheDimLevsPUB;
133: FND_MSG_PUB.Count_And_Get

Line 131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

127: );
128: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: RAISE;
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO BSCCheDimLevsPUB;
133: FND_MSG_PUB.Count_And_Get
134: ( p_encoded => FND_API.G_FALSE
135: , p_count => x_msg_count

Line 134: ( p_encoded => FND_API.G_FALSE

130: RAISE;
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO BSCCheDimLevsPUB;
133: FND_MSG_PUB.Count_And_Get
134: ( p_encoded => FND_API.G_FALSE
135: , p_count => x_msg_count
136: , p_data => x_msg_data
137: );
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

134: ( p_encoded => FND_API.G_FALSE
135: , p_count => x_msg_count
136: , p_data => x_msg_data
137: );
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
140: RAISE;
141: WHEN NO_DATA_FOUND THEN
142: ROLLBACK TO BSCCheDimLevsPUB;

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

135: , p_count => x_msg_count
136: , p_data => x_msg_data
137: );
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
140: RAISE;
141: WHEN NO_DATA_FOUND THEN
142: ROLLBACK TO BSCCheDimLevsPUB;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

139: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
140: RAISE;
141: WHEN NO_DATA_FOUND THEN
142: ROLLBACK TO BSCCheDimLevsPUB;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF (x_msg_data IS NOT NULL) THEN
145: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels ';
146: ELSE
147: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels ';

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

149: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
150: RAISE;
151: WHEN OTHERS THEN
152: ROLLBACK TO BSCCheDimLevsPUB;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: IF (x_msg_data IS NOT NULL) THEN
155: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels ';
156: ELSE
157: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels ';

Line 185: x_return_status := FND_API.G_RET_STS_SUCCESS;

181: l_tab_id number;
182:
183: BEGIN
184: FND_MSG_PUB.Initialize;
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186: SAVEPOINT BSCCheDimLevsDL_PUB;
187: --DBMS_OUTPUT.PUT_LINE('Begin Check_Common_Dim_Levels_DL' );
188: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels_DL p_Dim_Level_Id = ' || p_Dim_Level_Id );
189: open c_tabs_to_check;

Line 204: WHEN FND_API.G_EXC_ERROR THEN

200: close c_tabs_to_check;
201: --DBMS_OUTPUT.PUT_LINE('Begin Check_Common_Dim_Levels_DL' );
202:
203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: if c_tabs_to_check%isopen then
206: close c_tabs_to_check;
207: end if;
208: ROLLBACK TO BSCCheDimLevsDL_PUB;

Line 210: ( p_encoded => FND_API.G_FALSE

206: close c_tabs_to_check;
207: end if;
208: ROLLBACK TO BSCCheDimLevsDL_PUB;
209: FND_MSG_PUB.Count_And_Get
210: ( p_encoded => FND_API.G_FALSE
211: , p_count => x_msg_count
212: , p_data => x_msg_data
213: );
214: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

210: ( p_encoded => FND_API.G_FALSE
211: , p_count => x_msg_count
212: , p_data => x_msg_data
213: );
214: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: RAISE;
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: if c_tabs_to_check%isopen then

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211: , p_count => x_msg_count
212: , p_data => x_msg_data
213: );
214: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: RAISE;
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: if c_tabs_to_check%isopen then
219: close c_tabs_to_check;

Line 217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

213: );
214: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: RAISE;
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: if c_tabs_to_check%isopen then
219: close c_tabs_to_check;
220: end if;
221: ROLLBACK TO BSCCheDimLevsDL_PUB;

Line 223: ( p_encoded => FND_API.G_FALSE

219: close c_tabs_to_check;
220: end if;
221: ROLLBACK TO BSCCheDimLevsDL_PUB;
222: FND_MSG_PUB.Count_And_Get
223: ( p_encoded => FND_API.G_FALSE
224: , p_count => x_msg_count
225: , p_data => x_msg_data
226: );
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

223: ( p_encoded => FND_API.G_FALSE
224: , p_count => x_msg_count
225: , p_data => x_msg_data
226: );
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
229: RAISE;
230: WHEN OTHERS THEN
231: if c_tabs_to_check%isopen then

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

224: , p_count => x_msg_count
225: , p_data => x_msg_data
226: );
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
229: RAISE;
230: WHEN OTHERS THEN
231: if c_tabs_to_check%isopen then
232: close c_tabs_to_check;

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231: if c_tabs_to_check%isopen then
232: close c_tabs_to_check;
233: end if;
234: ROLLBACK TO BSCCheDimLevsDL_PUB;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF (x_msg_data IS NOT NULL) THEN
237: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels_DL';
238: ELSE
239: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels_DL';

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

265: l_tab_id number;
266:
267: BEGIN
268: FND_MSG_PUB.Initialize;
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: SAVEPOINT BSCCheckCDimByDim;
271: --DBMS_OUTPUT.PUT_LINE('Begin Check_Common_Dim_Levels_by_Dim' );
272: --DBMS_OUTPUT.PUT_LINE('Check_Common_Dim_Levels_by_Dim p_Dimension_Id = ' || p_Dimension_Id );
273: open c_tabs_to_check;

Line 288: WHEN FND_API.G_EXC_ERROR THEN

284: close c_tabs_to_check;
285: --DBMS_OUTPUT.PUT_LINE('End Check_Common_Dim_Levels_by_Dim' );
286:
287: EXCEPTION
288: WHEN FND_API.G_EXC_ERROR THEN
289: if c_tabs_to_check%isopen then
290: close c_tabs_to_check;
291: end if;
292: ROLLBACK TO BSCCheckCDimByDim;

Line 294: ( p_encoded => FND_API.G_FALSE

290: close c_tabs_to_check;
291: end if;
292: ROLLBACK TO BSCCheckCDimByDim;
293: FND_MSG_PUB.Count_And_Get
294: ( p_encoded => FND_API.G_FALSE
295: , p_count => x_msg_count
296: , p_data => x_msg_data
297: );
298: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

294: ( p_encoded => FND_API.G_FALSE
295: , p_count => x_msg_count
296: , p_data => x_msg_data
297: );
298: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: RAISE;
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: if c_tabs_to_check%isopen then

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: , p_count => x_msg_count
296: , p_data => x_msg_data
297: );
298: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: RAISE;
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: if c_tabs_to_check%isopen then
303: close c_tabs_to_check;

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: );
298: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: RAISE;
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: if c_tabs_to_check%isopen then
303: close c_tabs_to_check;
304: end if;
305: ROLLBACK TO BSCCheckCDimByDim;

Line 307: ( p_encoded => FND_API.G_FALSE

303: close c_tabs_to_check;
304: end if;
305: ROLLBACK TO BSCCheckCDimByDim;
306: FND_MSG_PUB.Count_And_Get
307: ( p_encoded => FND_API.G_FALSE
308: , p_count => x_msg_count
309: , p_data => x_msg_data
310: );
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

307: ( p_encoded => FND_API.G_FALSE
308: , p_count => x_msg_count
309: , p_data => x_msg_data
310: );
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
313: RAISE;
314: WHEN OTHERS THEN
315: if c_tabs_to_check%isopen then

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

308: , p_count => x_msg_count
309: , p_data => x_msg_data
310: );
311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
312: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
313: RAISE;
314: WHEN OTHERS THEN
315: if c_tabs_to_check%isopen then
316: close c_tabs_to_check;

Line 319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

315: if c_tabs_to_check%isopen then
316: close c_tabs_to_check;
317: end if;
318: ROLLBACK TO BSCCheckCDimByDim;
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: IF (x_msg_data IS NOT NULL) THEN
321: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels_by_Dim';
322: ELSE
323: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels_by_Dim';

Line 334: p_commit IN varchar2 := FND_API.G_FALSE

330: -------------------------------------------------------------------------------------------------------------------
331: -- Find_Common_Dim_Levels
332: -------------------------------------------------------------------------------------------------------------------
333: PROCEDURE Find_Common_Dim_Levels(
334: p_commit IN varchar2 := FND_API.G_FALSE
335: ,p_Tab_Id IN number
336: ,x_Dim_Level_Tbl OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type
337: ,x_return_status OUT NOCOPY varchar2
338: ,x_msg_count OUT NOCOPY number

Line 408: x_return_status := FND_API.G_RET_STS_SUCCESS;

404: l_Firt_Dim_Family_Flag BOOLEAN;
405:
406: BEGIN
407: FND_MSG_PUB.Initialize;
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409: --DBMS_OUTPUT.PUT_LINE('Begin Find_Common_Dim_Levels');
410:
411: --Evaluate that not KPI in the tab has PMF Measures as Default One
412: SELECT COUNT(SOURCE)

Line 544: WHEN FND_API.G_EXC_ERROR THEN

540: x_mode => 'I');
541: commit;
542: */
543: EXCEPTION
544: WHEN FND_API.G_EXC_ERROR THEN
545: FND_MSG_PUB.Count_And_Get
546: ( p_encoded => FND_API.G_FALSE
547: , p_count => x_msg_count
548: , p_data => x_msg_data

Line 546: ( p_encoded => FND_API.G_FALSE

542: */
543: EXCEPTION
544: WHEN FND_API.G_EXC_ERROR THEN
545: FND_MSG_PUB.Count_And_Get
546: ( p_encoded => FND_API.G_FALSE
547: , p_count => x_msg_count
548: , p_data => x_msg_data
549: );
550: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

546: ( p_encoded => FND_API.G_FALSE
547: , p_count => x_msg_count
548: , p_data => x_msg_data
549: );
550: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: RAISE;
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: FND_MSG_PUB.Count_And_Get

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547: , p_count => x_msg_count
548: , p_data => x_msg_data
549: );
550: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: RAISE;
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: FND_MSG_PUB.Count_And_Get
555: ( p_encoded => FND_API.G_FALSE

Line 553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

549: );
550: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: RAISE;
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: FND_MSG_PUB.Count_And_Get
555: ( p_encoded => FND_API.G_FALSE
556: , p_count => x_msg_count
557: , p_data => x_msg_data

Line 555: ( p_encoded => FND_API.G_FALSE

551: x_return_status := FND_API.G_RET_STS_ERROR;
552: RAISE;
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: FND_MSG_PUB.Count_And_Get
555: ( p_encoded => FND_API.G_FALSE
556: , p_count => x_msg_count
557: , p_data => x_msg_data
558: );
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

555: ( p_encoded => FND_API.G_FALSE
556: , p_count => x_msg_count
557: , p_data => x_msg_data
558: );
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
561: RAISE;
562: WHEN NO_DATA_FOUND THEN
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

556: , p_count => x_msg_count
557: , p_data => x_msg_data
558: );
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
561: RAISE;
562: WHEN NO_DATA_FOUND THEN
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF (x_msg_data IS NOT NULL) THEN

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
561: RAISE;
562: WHEN NO_DATA_FOUND THEN
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: IF (x_msg_data IS NOT NULL) THEN
565: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Find_Common_Dim_Levels ';
566: ELSE
567: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Find_Common_Dim_Levels ';

Line 572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

568: END IF;
569: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
570: RAISE;
571: WHEN OTHERS THEN
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573: IF (x_msg_data IS NOT NULL) THEN
574: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Find_Common_Dim_Levels ';
575: ELSE
576: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Find_Common_Dim_Levels ';

Line 587: p_commit IN varchar2 := FND_API.G_FALSE

583: /*-------------------------------------------------------------------------------------------------------------------
584: Retrieve_Common_Dim_Levels
585: -------------------------------------------------------------------------------------------------------------------*/
586: PROCEDURE Retrieve_Common_Dim_Levels(
587: p_commit IN varchar2 := FND_API.G_FALSE
588: ,p_Tab_Id IN number
589: ,x_Dim_Level_Tbl OUT NOCOPY BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Tbl_Type
590: ,x_return_status OUT NOCOPY varchar2
591: ,x_msg_count OUT NOCOPY number

Line 617: x_return_status := FND_API.G_RET_STS_SUCCESS;

613: ORDER BY CL.DIM_LEVEL_INDEX;
614:
615: BEGIN
616: FND_MSG_PUB.Initialize;
617: x_return_status := FND_API.G_RET_STS_SUCCESS;
618: --DBMS_OUTPUT.PUT_LINE('Begin Retrieve_Common_Dim_Levels');
619:
620: v_Index := 0;
621: v_Parent_Dim_Level_Id := -1;

Line 642: WHEN FND_API.G_EXC_ERROR THEN

638:
639: --DBMS_OUTPUT.PUT_LINE('End Retrieve_Common_Dim_Levels');
640:
641: EXCEPTION
642: WHEN FND_API.G_EXC_ERROR THEN
643: FND_MSG_PUB.Count_And_Get
644: ( p_encoded => FND_API.G_FALSE
645: , p_count => x_msg_count
646: , p_data => x_msg_data

Line 644: ( p_encoded => FND_API.G_FALSE

640:
641: EXCEPTION
642: WHEN FND_API.G_EXC_ERROR THEN
643: FND_MSG_PUB.Count_And_Get
644: ( p_encoded => FND_API.G_FALSE
645: , p_count => x_msg_count
646: , p_data => x_msg_data
647: );
648: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

644: ( p_encoded => FND_API.G_FALSE
645: , p_count => x_msg_count
646: , p_data => x_msg_data
647: );
648: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: RAISE;
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: FND_MSG_PUB.Count_And_Get

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: , p_count => x_msg_count
646: , p_data => x_msg_data
647: );
648: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: RAISE;
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: FND_MSG_PUB.Count_And_Get
653: ( p_encoded => FND_API.G_FALSE

Line 651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

647: );
648: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: RAISE;
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: FND_MSG_PUB.Count_And_Get
653: ( p_encoded => FND_API.G_FALSE
654: , p_count => x_msg_count
655: , p_data => x_msg_data

Line 653: ( p_encoded => FND_API.G_FALSE

649: x_return_status := FND_API.G_RET_STS_ERROR;
650: RAISE;
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
652: FND_MSG_PUB.Count_And_Get
653: ( p_encoded => FND_API.G_FALSE
654: , p_count => x_msg_count
655: , p_data => x_msg_data
656: );
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

653: ( p_encoded => FND_API.G_FALSE
654: , p_count => x_msg_count
655: , p_data => x_msg_data
656: );
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
659: RAISE;
660: WHEN NO_DATA_FOUND THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

654: , p_count => x_msg_count
655: , p_data => x_msg_data
656: );
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
659: RAISE;
660: WHEN NO_DATA_FOUND THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: IF (x_msg_data IS NOT NULL) THEN

Line 661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
659: RAISE;
660: WHEN NO_DATA_FOUND THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: IF (x_msg_data IS NOT NULL) THEN
663: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Retrieve_Common_Dim_Levels ';
664: ELSE
665: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Retrieve_Common_Dim_Levels ';

Line 670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

666: END IF;
667: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
668: RAISE;
669: WHEN OTHERS THEN
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671: IF (x_msg_data IS NOT NULL) THEN
672: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Retrieve_Common_Dim_Levels ';
673: ELSE
674: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Retrieve_Common_Dim_Levels ';

Line 684: p_commit IN varchar2 := FND_API.G_FALSE

680: /*-------------------------------------------------------------------------------------------------------------------
681: Check_Dim_Level_Default_Value
682: -------------------------------------------------------------------------------------------------------------------*/
683: PROCEDURE Check_Dim_Level_Default_Value(
684: p_commit IN varchar2 := FND_API.G_FALSE
685: ,p_Tab_Id IN number
686: ,x_return_status OUT NOCOPY varchar2
687: ,x_msg_count OUT NOCOPY number
688: ,x_msg_data OUT NOCOPY varchar2

Line 703: x_return_status := FND_API.G_RET_STS_SUCCESS;

699: WHERE TAB_ID = p_Tab_Id;
700:
701: BEGIN
702: FND_MSG_PUB.Initialize;
703: x_return_status := FND_API.G_RET_STS_SUCCESS;
704: SAVEPOINT BSCChkDimLevDefPUB;
705:
706: --DBMS_OUTPUT.PUT_LINE('Begin Check_Dim_Level_Default_Value');
707:

Line 733: if p_commit = FND_API.G_TRUE then

729: end loop;
730:
731: END LOOP;
732:
733: if p_commit = FND_API.G_TRUE then
734: commit;
735: end if;
736: --DBMS_OUTPUT.PUT_LINE('End Check_Dim_Level_Default_Value');
737:

Line 739: WHEN FND_API.G_EXC_ERROR THEN

735: end if;
736: --DBMS_OUTPUT.PUT_LINE('End Check_Dim_Level_Default_Value');
737:
738: EXCEPTION
739: WHEN FND_API.G_EXC_ERROR THEN
740: ROLLBACK TO BSCChkDimLevDefPUB;
741: FND_MSG_PUB.Count_And_Get
742: ( p_encoded => FND_API.G_FALSE
743: , p_count => x_msg_count

Line 742: ( p_encoded => FND_API.G_FALSE

738: EXCEPTION
739: WHEN FND_API.G_EXC_ERROR THEN
740: ROLLBACK TO BSCChkDimLevDefPUB;
741: FND_MSG_PUB.Count_And_Get
742: ( p_encoded => FND_API.G_FALSE
743: , p_count => x_msg_count
744: , p_data => x_msg_data
745: );
746: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

742: ( p_encoded => FND_API.G_FALSE
743: , p_count => x_msg_count
744: , p_data => x_msg_data
745: );
746: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: RAISE;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO BSCChkDimLevDefPUB;

Line 747: x_return_status := FND_API.G_RET_STS_ERROR;

743: , p_count => x_msg_count
744: , p_data => x_msg_data
745: );
746: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: RAISE;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO BSCChkDimLevDefPUB;
751: FND_MSG_PUB.Count_And_Get

Line 749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

745: );
746: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: RAISE;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO BSCChkDimLevDefPUB;
751: FND_MSG_PUB.Count_And_Get
752: ( p_encoded => FND_API.G_FALSE
753: , p_count => x_msg_count

Line 752: ( p_encoded => FND_API.G_FALSE

748: RAISE;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: ROLLBACK TO BSCChkDimLevDefPUB;
751: FND_MSG_PUB.Count_And_Get
752: ( p_encoded => FND_API.G_FALSE
753: , p_count => x_msg_count
754: , p_data => x_msg_data
755: );
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

752: ( p_encoded => FND_API.G_FALSE
753: , p_count => x_msg_count
754: , p_data => x_msg_data
755: );
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
758: RAISE;
759: WHEN NO_DATA_FOUND THEN
760: ROLLBACK TO BSCChkDimLevDefPUB;

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

753: , p_count => x_msg_count
754: , p_data => x_msg_data
755: );
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
758: RAISE;
759: WHEN NO_DATA_FOUND THEN
760: ROLLBACK TO BSCChkDimLevDefPUB;
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

757: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
758: RAISE;
759: WHEN NO_DATA_FOUND THEN
760: ROLLBACK TO BSCChkDimLevDefPUB;
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
762: IF (x_msg_data IS NOT NULL) THEN
763: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Check_Dim_Level_Default_Value ';
764: ELSE
765: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Check_Dim_Level_Default_Value ';

Line 771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

767: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
768: RAISE;
769: WHEN OTHERS THEN
770: ROLLBACK TO BSCChkDimLevDefPUB;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: IF (x_msg_data IS NOT NULL) THEN
773: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Check_Dim_Level_Default_Value ';
774: ELSE
775: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Check_Dim_Level_Default_Value ';

Line 831: x_return_status := FND_API.G_RET_STS_SUCCESS;

827: WHERE indicator = l_Kpi_Id;
828:
829: BEGIN
830: FND_MSG_PUB.Initialize;
831: x_return_status := FND_API.G_RET_STS_SUCCESS;
832:
833: IF(p_Kpi_Id IS NOT NULL) THEN
834: l_Kpi_Id := p_Kpi_Id;
835: FOR cd IN c_tab_id LOOP

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

840: ,x_return_status => x_return_status
841: ,x_msg_count => x_msg_count
842: ,x_msg_data => x_msg_data
843: );
844: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
845: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set Failed: at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels');
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848: END LOOP;

Line 846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

842: ,x_msg_data => x_msg_data
843: );
844: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
845: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set Failed: at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels');
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: END IF;
848: END LOOP;
849: /***************For Shared Indiactors ***********************************/
850:

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

866: ,x_return_status => x_return_status
867: ,x_msg_count => x_msg_count
868: ,x_msg_data => x_msg_data
869: );
870: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
871: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set Failed: at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels');
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: END IF;
874: END LOOP;

Line 872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

868: ,x_msg_data => x_msg_data
869: );
870: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
871: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set Failed: at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels');
872: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
873: END IF;
874: END LOOP;
875:
876: ELSIF(p_Dim_Level_Id IS NOT NULL) THEN

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

881: ,x_return_status => x_return_status
882: ,x_msg_count => x_msg_count
883: ,x_msg_data => x_msg_data
884: );
885: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set Failed: at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels');
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: END IF;
889: END IF;

Line 887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

883: ,x_msg_data => x_msg_data
884: );
885: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
886: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set Failed: at BSC_COMMON_DIM_LEVELS_PUB.Check_Common_Dim_Levels');
887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
888: END IF;
889: END IF;
890:
891: EXCEPTION

Line 892: WHEN FND_API.G_EXC_ERROR THEN

888: END IF;
889: END IF;
890:
891: EXCEPTION
892: WHEN FND_API.G_EXC_ERROR THEN
893: FND_MSG_PUB.Count_And_Get
894: ( p_encoded => FND_API.G_FALSE
895: , p_count => x_msg_count
896: , p_data => x_msg_data

Line 894: ( p_encoded => FND_API.G_FALSE

890:
891: EXCEPTION
892: WHEN FND_API.G_EXC_ERROR THEN
893: FND_MSG_PUB.Count_And_Get
894: ( p_encoded => FND_API.G_FALSE
895: , p_count => x_msg_count
896: , p_data => x_msg_data
897: );
898: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

894: ( p_encoded => FND_API.G_FALSE
895: , p_count => x_msg_count
896: , p_data => x_msg_data
897: );
898: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: RAISE;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: FND_MSG_PUB.Count_And_Get

Line 899: x_return_status := FND_API.G_RET_STS_ERROR;

895: , p_count => x_msg_count
896: , p_data => x_msg_data
897: );
898: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: RAISE;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: FND_MSG_PUB.Count_And_Get
903: ( p_encoded => FND_API.G_FALSE

Line 901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

897: );
898: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
899: x_return_status := FND_API.G_RET_STS_ERROR;
900: RAISE;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: FND_MSG_PUB.Count_And_Get
903: ( p_encoded => FND_API.G_FALSE
904: , p_count => x_msg_count
905: , p_data => x_msg_data

Line 903: ( p_encoded => FND_API.G_FALSE

899: x_return_status := FND_API.G_RET_STS_ERROR;
900: RAISE;
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: FND_MSG_PUB.Count_And_Get
903: ( p_encoded => FND_API.G_FALSE
904: , p_count => x_msg_count
905: , p_data => x_msg_data
906: );
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

903: ( p_encoded => FND_API.G_FALSE
904: , p_count => x_msg_count
905: , p_data => x_msg_data
906: );
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
909: RAISE;
910: WHEN NO_DATA_FOUND THEN
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

904: , p_count => x_msg_count
905: , p_data => x_msg_data
906: );
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
909: RAISE;
910: WHEN NO_DATA_FOUND THEN
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: IF (x_msg_data IS NOT NULL) THEN

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
908: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
909: RAISE;
910: WHEN NO_DATA_FOUND THEN
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: IF (x_msg_data IS NOT NULL) THEN
913: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button ';
914: ELSE
915: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button ';

Line 920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

916: END IF;
917: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
918: RAISE;
919: WHEN OTHERS THEN
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: IF (x_msg_data IS NOT NULL) THEN
922: x_msg_data := x_msg_data||' -> BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button ';
923: ELSE
924: x_msg_data := SQLERRM||' at BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button ';