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_KPI_GROUP_PUB dependencies on BSC_KPI_GROUP_PUB

Line 1: package body BSC_KPI_GROUP_PUB as

1: package body BSC_KPI_GROUP_PUB as
2: /* $Header: BSCPKGPB.pls 120.0 2005/06/01 15:25:33 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_GROUP_PUB';
5:

Line 4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_GROUP_PUB';

1: package body BSC_KPI_GROUP_PUB as
2: /* $Header: BSCPKGPB.pls 120.0 2005/06/01 15:25:33 appldev noship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_KPI_GROUP_PUB';
5:
6:
7: --New procedure with OUT parameter
8: procedure Create_Kpi_Group(

Line 10: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec

6:
7: --New procedure with OUT parameter
8: procedure Create_Kpi_Group(
9: p_commit IN varchar2 := FND_API.G_FALSE
10: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
11: ,x_Bsc_Kpi_Group_Rec OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
12: ,x_return_status OUT NOCOPY varchar2
13: ,x_msg_count OUT NOCOPY number
14: ,x_msg_data OUT NOCOPY varchar2

Line 11: ,x_Bsc_Kpi_Group_Rec OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec

7: --New procedure with OUT parameter
8: procedure Create_Kpi_Group(
9: p_commit IN varchar2 := FND_API.G_FALSE
10: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
11: ,x_Bsc_Kpi_Group_Rec OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
12: ,x_return_status OUT NOCOPY varchar2
13: ,x_msg_count OUT NOCOPY number
14: ,x_msg_data OUT NOCOPY varchar2
15: ) is

Line 17: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;

13: ,x_msg_count OUT NOCOPY number
14: ,x_msg_data OUT NOCOPY varchar2
15: ) is
16:
17: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
18:
19: begin
20: FND_MSG_PUB.Initialize;
21: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 105: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';

101: WHEN NO_DATA_FOUND THEN
102: ROLLBACK TO BSCCreateKPIGROUP;
103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: IF (x_msg_data IS NOT NULL) THEN
105: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';
106: ELSE
107: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';
108: END IF;
109: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 107: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';

103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
104: IF (x_msg_data IS NOT NULL) THEN
105: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';
106: ELSE
107: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';
108: END IF;
109: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
110: WHEN OTHERS THEN
111: ROLLBACK TO BSCCreateKPIGROUP;

Line 114: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';

110: WHEN OTHERS THEN
111: ROLLBACK TO BSCCreateKPIGROUP;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF (x_msg_data IS NOT NULL) THEN
114: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';
115: ELSE
116: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';
117: END IF;
118: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 116: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';

112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF (x_msg_data IS NOT NULL) THEN
114: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';
115: ELSE
116: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group with parameter x_Bsc_Kpi_Group_Rec ';
117: END IF;
118: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
119:
120: end Create_Kpi_Group;

Line 128: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec

124: ************************************************************************************/
125: --Modified procedure without OUT parameter
126: procedure Create_Kpi_Group(
127: p_commit IN varchar2 := FND_API.G_FALSE
128: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
129: ,x_return_status OUT NOCOPY varchar2
130: ,x_msg_count OUT NOCOPY number
131: ,x_msg_data OUT NOCOPY varchar2
132: ) is

Line 134: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;

130: ,x_msg_count OUT NOCOPY number
131: ,x_msg_data OUT NOCOPY varchar2
132: ) is
133:
134: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
135: l_Bsc_Kpi_Group_Rec_Out BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
136:
137: begin
138: FND_MSG_PUB.Initialize;

Line 135: l_Bsc_Kpi_Group_Rec_Out BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;

131: ,x_msg_data OUT NOCOPY varchar2
132: ) is
133:
134: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
135: l_Bsc_Kpi_Group_Rec_Out BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
136:
137: begin
138: FND_MSG_PUB.Initialize;
139: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 144: BSC_KPI_GROUP_PUB.Create_Kpi_Group( p_commit => p_commit

140:
141: l_Bsc_Kpi_Group_Rec := p_Bsc_Kpi_Group_Rec;
142:
143: -- Call the create kpi group API with OUT parameter for kpi group record.
144: BSC_KPI_GROUP_PUB.Create_Kpi_Group( p_commit => p_commit
145: ,p_Bsc_Kpi_Group_Rec => l_Bsc_Kpi_Group_Rec
146: ,x_Bsc_Kpi_Group_Rec => l_Bsc_Kpi_Group_Rec_Out
147: ,x_return_status => x_return_status
148: ,x_msg_count => x_msg_count

Line 179: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group ';

175: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
176: WHEN NO_DATA_FOUND THEN
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF (x_msg_data IS NOT NULL) THEN
179: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group ';
180: ELSE
181: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group ';
182: END IF;
183: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 181: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group ';

177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF (x_msg_data IS NOT NULL) THEN
179: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group ';
180: ELSE
181: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group ';
182: END IF;
183: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
184: WHEN OTHERS THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 187: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group ';

183: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
184: WHEN OTHERS THEN
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF (x_msg_data IS NOT NULL) THEN
187: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group ';
188: ELSE
189: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group ';
190: END IF;
191: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 189: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group ';

185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: IF (x_msg_data IS NOT NULL) THEN
187: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Create_Kpi_Group ';
188: ELSE
189: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Create_Kpi_Group ';
190: END IF;
191: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
192:
193: end Create_Kpi_Group;

Line 200: p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec

196: /************************************************************************************
197: ************************************************************************************/
198: --new procedure. Initializing the kpi group record.
199: procedure Initialize_Kpi_Group_Rec(
200: p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
201: ,x_Bsc_Kpi_Group_Rec OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
202: ,x_return_status OUT NOCOPY varchar2
203: ,x_msg_count OUT NOCOPY number
204: ,x_msg_data OUT NOCOPY varchar2

Line 201: ,x_Bsc_Kpi_Group_Rec OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec

197: ************************************************************************************/
198: --new procedure. Initializing the kpi group record.
199: procedure Initialize_Kpi_Group_Rec(
200: p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
201: ,x_Bsc_Kpi_Group_Rec OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
202: ,x_return_status OUT NOCOPY varchar2
203: ,x_msg_count OUT NOCOPY number
204: ,x_msg_data OUT NOCOPY varchar2
205: ) is

Line 229: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Initialize_Kpi_Group_Rec ';

225: EXCEPTION
226: WHEN OTHERS THEN
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: IF (x_msg_data IS NOT NULL) THEN
229: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Initialize_Kpi_Group_Rec ';
230: ELSE
231: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Initialize_Kpi_Group_Rec ';
232: END IF;
233: RAISE;

Line 231: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Initialize_Kpi_Group_Rec ';

227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
228: IF (x_msg_data IS NOT NULL) THEN
229: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Initialize_Kpi_Group_Rec ';
230: ELSE
231: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Initialize_Kpi_Group_Rec ';
232: END IF;
233: RAISE;
234: end Initialize_Kpi_Group_Rec;
235:

Line 241: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec

237: ************************************************************************************/
238:
239: procedure Retrieve_Kpi_Group(
240: p_commit IN varchar2 := FND_API.G_FALSE
241: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
242: ,x_Bsc_Kpi_Group_Rec IN OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
243: ,x_return_status OUT NOCOPY varchar2
244: ,x_msg_count OUT NOCOPY number
245: ,x_msg_data OUT NOCOPY varchar2

Line 242: ,x_Bsc_Kpi_Group_Rec IN OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec

238:
239: procedure Retrieve_Kpi_Group(
240: p_commit IN varchar2 := FND_API.G_FALSE
241: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
242: ,x_Bsc_Kpi_Group_Rec IN OUT NOCOPY BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
243: ,x_return_status OUT NOCOPY varchar2
244: ,x_msg_count OUT NOCOPY number
245: ,x_msg_data OUT NOCOPY varchar2
246: ) is

Line 282: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';

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

Line 284: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';

280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: IF (x_msg_data IS NOT NULL) THEN
282: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';
283: ELSE
284: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';
285: END IF;
286: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
287: WHEN OTHERS THEN
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 290: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';

286: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
287: WHEN OTHERS THEN
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: IF (x_msg_data IS NOT NULL) THEN
290: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';
291: ELSE
292: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';
293: END IF;
294: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 292: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';

288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: IF (x_msg_data IS NOT NULL) THEN
290: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';
291: ELSE
292: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Retrieve_Kpi_Group ';
293: END IF;
294: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
295:
296: end Retrieve_Kpi_Group;

Line 303: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec

299: ************************************************************************************/
300:
301: procedure Update_Kpi_Group(
302: p_commit IN varchar2 := FND_API.G_FALSE
303: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
304: ,x_return_status OUT NOCOPY varchar2
305: ,x_msg_count OUT NOCOPY number
306: ,x_msg_data OUT NOCOPY varchar2
307: ) is

Line 346: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Update_Kpi_Group ';

342: WHEN NO_DATA_FOUND THEN
343: ROLLBACK TO BSCUpdateKPIGROUP;
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: IF (x_msg_data IS NOT NULL) THEN
346: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
347: ELSE
348: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
349: END IF;
350: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 348: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Update_Kpi_Group ';

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

Line 355: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Update_Kpi_Group ';

351: WHEN OTHERS THEN
352: ROLLBACK TO BSCUpdateKPIGROUP;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF (x_msg_data IS NOT NULL) THEN
355: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
356: ELSE
357: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
358: END IF;
359: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 357: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Update_Kpi_Group ';

353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: IF (x_msg_data IS NOT NULL) THEN
355: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
356: ELSE
357: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Update_Kpi_Group ';
358: END IF;
359: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
360:
361: end Update_Kpi_Group;

Line 368: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec

364: ************************************************************************************/
365:
366: procedure Delete_Kpi_Group(
367: p_commit IN varchar2 := FND_API.G_FALSE
368: ,p_Bsc_Kpi_Group_Rec IN BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec
369: ,x_return_status OUT NOCOPY varchar2
370: ,x_msg_count OUT NOCOPY number
371: ,x_msg_data OUT NOCOPY varchar2
372: ) is

Line 374: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;

370: ,x_msg_count OUT NOCOPY number
371: ,x_msg_data OUT NOCOPY varchar2
372: ) is
373:
374: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
375:
376: begin
377: FND_MSG_PUB.Initialize;
378: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 423: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';

419: WHEN NO_DATA_FOUND THEN
420: ROLLBACK TO BSCDeleteKPIGROUP;
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF (x_msg_data IS NOT NULL) THEN
423: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
424: ELSE
425: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
426: END IF;
427: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 425: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';

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

Line 432: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';

428: WHEN OTHERS THEN
429: ROLLBACK TO BSCDeleteKPIGROUP;
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: IF (x_msg_data IS NOT NULL) THEN
432: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
433: ELSE
434: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
435: END IF;
436: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 434: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';

430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: IF (x_msg_data IS NOT NULL) THEN
432: x_msg_data := x_msg_data||' -> BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
433: ELSE
434: x_msg_data := SQLERRM||' at BSC_KPI_GROUP_PUB.Delete_Kpi_Group ';
435: END IF;
436: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
437:
438: end Delete_Kpi_Group;

Line 443: end BSC_KPI_GROUP_PUB;

439:
440: /************************************************************************************
441: ************************************************************************************/
442:
443: end BSC_KPI_GROUP_PUB;