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

Line 41: RAISE FND_API.G_EXC_ERROR;

37: END IF;
38: OPEN c_analysis_option_comb(p_objective_id, p_kpi_measure_id);
39: FETCH c_analysis_option_comb INTO c_analysis_option_comb_rec;
40: IF c_analysis_option_comb%NOTFOUND THEN
41: RAISE FND_API.G_EXC_ERROR;
42: END IF;
43: CLOSE c_analysis_option_comb;
44:
45: IF c_kpi_measure_id%ISOPEN THEN

Line 55: RAISE FND_API.G_EXC_ERROR;

51: c_analysis_option_comb_rec.analysis_option2,
52: c_analysis_option_comb_rec.series_id);
53: FETCH c_kpi_measure_id INTO l_kpi_measure_id;
54: IF c_kpi_measure_id%NOTFOUND THEN
55: RAISE FND_API.G_EXC_ERROR;
56: END IF;
57: CLOSE c_kpi_measure_id;
58:
59: RETURN l_kpi_measure_id;

Line 77: p_commit IN VARCHAR2 := FND_API.G_FALSE

73:
74: /************************************************************************************
75: ************************************************************************************/
76: PROCEDURE Create_Kpi_Measure_Props (
77: p_commit IN VARCHAR2 := FND_API.G_FALSE
78: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
79: , p_cascade_shared IN BOOLEAN := TRUE
80: , x_return_status OUT NOCOPY VARCHAR2
81: , x_msg_count OUT NOCOPY NUMBER

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94:
95: BEGIN
96:
97: FND_MSG_PUB.Initialize;
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: SAVEPOINT BscKpiMeasurePub_Create;
101:
102: -- Any Business Logic Validation

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

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

Line 112: RAISE FND_API.G_EXC_ERROR;

108: , x_msg_count => x_msg_count
109: , x_msg_data => x_msg_data
110: );
111: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114:
115: IF p_cascade_shared THEN
116: FOR c_shared IN c_shared_obj(p_kpi_measure_rec.objective_id) LOOP

Line 124: RAISE FND_API.G_EXC_ERROR;

120: , p_kpi_measure_id => p_kpi_measure_rec.kpi_measure_id
121: , p_shared_objective_id => c_shared.indicator
122: );
123: IF l_kpi_measure_id IS NULL THEN
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;
126:
127: l_kpi_measure_rec := p_kpi_measure_rec;
128: l_kpi_measure_rec.objective_id := c_shared.indicator;

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

134: , x_return_status => x_return_status
135: , x_msg_count => x_msg_count
136: , x_msg_data => x_msg_data
137: );
138: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
142: END LOOP;

Line 139: RAISE FND_API.G_EXC_ERROR;

135: , x_msg_count => x_msg_count
136: , x_msg_data => x_msg_data
137: );
138: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: END IF;
141:
142: END LOOP;
143: END IF;

Line 147: WHEN FND_API.G_EXC_ERROR THEN

143: END IF;
144:
145:
146: EXCEPTION
147: WHEN FND_API.G_EXC_ERROR THEN
148: ROLLBACK TO BscKpiMeasurePub_Create;
149: IF (x_msg_data IS NULL) THEN
150: FND_MSG_PUB.Count_And_Get
151: ( p_encoded => FND_API.G_FALSE

Line 151: ( p_encoded => FND_API.G_FALSE

147: WHEN FND_API.G_EXC_ERROR THEN
148: ROLLBACK TO BscKpiMeasurePub_Create;
149: IF (x_msg_data IS NULL) THEN
150: FND_MSG_PUB.Count_And_Get
151: ( p_encoded => FND_API.G_FALSE
152: , p_count => x_msg_count
153: , p_data => x_msg_data
154: );
155: END IF;

Line 156: x_return_status := FND_API.G_RET_STS_ERROR;

152: , p_count => x_msg_count
153: , p_data => x_msg_data
154: );
155: END IF;
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO BscKpiMeasurePub_Create;
159: IF (x_msg_data IS NULL) THEN
160: FND_MSG_PUB.Count_And_Get

Line 157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

153: , p_data => x_msg_data
154: );
155: END IF;
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO BscKpiMeasurePub_Create;
159: IF (x_msg_data IS NULL) THEN
160: FND_MSG_PUB.Count_And_Get
161: ( p_encoded => FND_API.G_FALSE

Line 161: ( p_encoded => FND_API.G_FALSE

157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO BscKpiMeasurePub_Create;
159: IF (x_msg_data IS NULL) THEN
160: FND_MSG_PUB.Count_And_Get
161: ( p_encoded => FND_API.G_FALSE
162: , p_count => x_msg_count
163: , p_data => x_msg_data
164: );
165: END IF;

Line 166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

162: , p_count => x_msg_count
163: , p_data => x_msg_data
164: );
165: END IF;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: WHEN NO_DATA_FOUND THEN
168: ROLLBACK TO BscKpiMeasurePub_Create;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: IF (x_msg_data IS NOT NULL) THEN

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

165: END IF;
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: WHEN NO_DATA_FOUND THEN
168: ROLLBACK TO BscKpiMeasurePub_Create;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: IF (x_msg_data IS NOT NULL) THEN
171: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
172: ELSE
173: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';

Line 177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

173: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
174: END IF;
175: WHEN OTHERS THEN
176: ROLLBACK TO BscKpiMeasurePub_Create;
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_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
180: ELSE
181: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';

Line 188: p_commit IN VARCHAR2 := FND_API.G_FALSE

184:
185: /************************************************************************************
186: ************************************************************************************/
187: PROCEDURE Create_Default_Kpi_Meas_Props (
188: p_commit IN VARCHAR2 := FND_API.G_FALSE
189: , p_objective_id IN NUMBER
190: , p_kpi_measure_id IN NUMBER
191: , p_cascade_shared IN BOOLEAN := TRUE
192: , x_return_status OUT NOCOPY VARCHAR2

Line 211: x_return_status := FND_API.G_RET_STS_SUCCESS;

207: l_config_type BSC_KPIS_B.CONFIG_TYPE%TYPE;
208: BEGIN
209:
210: FND_MSG_PUB.Initialize;
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212:
213: SAVEPOINT BscKpiMeasurePub_CreateDef;
214:
215: l_kpi_measure_rec.objective_id := p_objective_id;

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

247: , x_return_status => x_return_status
248: , x_msg_count => x_msg_count
249: , x_msg_data => x_msg_data
250: );
251: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: IF p_cascade_shared THEN

Line 252: RAISE FND_API.G_EXC_ERROR;

248: , x_msg_count => x_msg_count
249: , x_msg_data => x_msg_data
250: );
251: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: IF p_cascade_shared THEN
256: FOR c_shared IN c_shared_obj(l_kpi_measure_rec.objective_id) LOOP

Line 264: RAISE FND_API.G_EXC_ERROR;

260: , p_kpi_measure_id => l_kpi_measure_rec.kpi_measure_id
261: , p_shared_objective_id => c_shared.indicator
262: );
263: IF l_kpi_measure_id IS NULL THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266:
267: --l_kpi_measure_rec := p_kpi_measure_rec;
268: l_kpi_measure_rec.objective_id := c_shared.indicator;

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

274: , x_return_status => x_return_status
275: , x_msg_count => x_msg_count
276: , x_msg_data => x_msg_data
277: );
278: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:
282: END LOOP;

Line 279: RAISE FND_API.G_EXC_ERROR;

275: , x_msg_count => x_msg_count
276: , x_msg_data => x_msg_data
277: );
278: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281:
282: END LOOP;
283: END IF;

Line 287: WHEN FND_API.G_EXC_ERROR THEN

283: END IF;
284:
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO BscKpiMeasurePub_CreateDef;
289: IF (x_msg_data IS NULL) THEN
290: FND_MSG_PUB.Count_And_Get
291: ( p_encoded => FND_API.G_FALSE

Line 291: ( p_encoded => FND_API.G_FALSE

287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO BscKpiMeasurePub_CreateDef;
289: IF (x_msg_data IS NULL) THEN
290: FND_MSG_PUB.Count_And_Get
291: ( p_encoded => FND_API.G_FALSE
292: , p_count => x_msg_count
293: , p_data => x_msg_data
294: );
295: END IF;

Line 296: x_return_status := FND_API.G_RET_STS_ERROR;

292: , p_count => x_msg_count
293: , p_data => x_msg_data
294: );
295: END IF;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: ROLLBACK TO BscKpiMeasurePub_CreateDef;
299: IF (x_msg_data IS NULL) THEN
300: FND_MSG_PUB.Count_And_Get

Line 297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

293: , p_data => x_msg_data
294: );
295: END IF;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: ROLLBACK TO BscKpiMeasurePub_CreateDef;
299: IF (x_msg_data IS NULL) THEN
300: FND_MSG_PUB.Count_And_Get
301: ( p_encoded => FND_API.G_FALSE

Line 301: ( p_encoded => FND_API.G_FALSE

297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: ROLLBACK TO BscKpiMeasurePub_CreateDef;
299: IF (x_msg_data IS NULL) THEN
300: FND_MSG_PUB.Count_And_Get
301: ( p_encoded => FND_API.G_FALSE
302: , p_count => x_msg_count
303: , p_data => x_msg_data
304: );
305: END IF;

Line 306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

302: , p_count => x_msg_count
303: , p_data => x_msg_data
304: );
305: END IF;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: WHEN NO_DATA_FOUND THEN
308: ROLLBACK TO BscKpiMeasurePub_CreateDef;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: IF (x_msg_data IS NOT NULL) THEN

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

305: END IF;
306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
307: WHEN NO_DATA_FOUND THEN
308: ROLLBACK TO BscKpiMeasurePub_CreateDef;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: IF (x_msg_data IS NOT NULL) THEN
311: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';
312: ELSE
313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';

Line 317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';
314: END IF;
315: WHEN OTHERS THEN
316: ROLLBACK TO BscKpiMeasurePub_CreateDef;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
318: IF (x_msg_data IS NOT NULL) THEN
319: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';
320: ELSE
321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';

Line 328: p_commit IN VARCHAR2 := FND_API.G_FALSE

324:
325: /************************************************************************************
326: ************************************************************************************/
327: PROCEDURE Update_Kpi_Measure_Props (
328: p_commit IN VARCHAR2 := FND_API.G_FALSE
329: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
330: , p_cascade_shared IN BOOLEAN := TRUE
331: , x_return_status OUT NOCOPY VARCHAR2
332: , x_msg_count OUT NOCOPY NUMBER

Line 349: x_return_status := FND_API.G_RET_STS_SUCCESS;

345:
346: BEGIN
347:
348: FND_MSG_PUB.Initialize;
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: SAVEPOINT BscKpiMeasurePub_Update;
352:
353: -- Any Business Logic Validation

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

358: , x_return_status => x_return_status
359: , x_msg_count => x_msg_count
360: , x_msg_data => x_msg_data
361: );
362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365:
366: IF p_cascade_shared THEN

Line 363: RAISE FND_API.G_EXC_ERROR;

359: , x_msg_count => x_msg_count
360: , x_msg_data => x_msg_data
361: );
362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
363: RAISE FND_API.G_EXC_ERROR;
364: END IF;
365:
366: IF p_cascade_shared THEN
367: FOR c_shared IN c_shared_obj(p_kpi_measure_rec.objective_id) LOOP

Line 375: RAISE FND_API.G_EXC_ERROR;

371: , p_kpi_measure_id => p_kpi_measure_rec.kpi_measure_id
372: , p_shared_objective_id => c_shared.indicator
373: );
374: IF l_kpi_measure_id IS NULL THEN
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: l_kpi_measure_rec := p_kpi_measure_rec;
379: l_kpi_measure_rec.objective_id := c_shared.indicator;

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

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

Line 390: RAISE FND_API.G_EXC_ERROR;

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

Line 397: WHEN FND_API.G_EXC_ERROR THEN

393: END LOOP;
394: END IF;
395:
396: EXCEPTION
397: WHEN FND_API.G_EXC_ERROR THEN
398: ROLLBACK TO BscKpiMeasurePub_Update;
399: IF (x_msg_data IS NULL) THEN
400: FND_MSG_PUB.Count_And_Get
401: ( p_encoded => FND_API.G_FALSE

Line 401: ( p_encoded => FND_API.G_FALSE

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

Line 406: x_return_status := FND_API.G_RET_STS_ERROR;

402: , p_count => x_msg_count
403: , p_data => x_msg_data
404: );
405: END IF;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO BscKpiMeasurePub_Update;
409: IF (x_msg_data IS NULL) THEN
410: FND_MSG_PUB.Count_And_Get

Line 407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

403: , p_data => x_msg_data
404: );
405: END IF;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO BscKpiMeasurePub_Update;
409: IF (x_msg_data IS NULL) THEN
410: FND_MSG_PUB.Count_And_Get
411: ( p_encoded => FND_API.G_FALSE

Line 411: ( p_encoded => FND_API.G_FALSE

407: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
408: ROLLBACK TO BscKpiMeasurePub_Update;
409: IF (x_msg_data IS NULL) THEN
410: FND_MSG_PUB.Count_And_Get
411: ( p_encoded => FND_API.G_FALSE
412: , p_count => x_msg_count
413: , p_data => x_msg_data
414: );
415: END IF;

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

412: , p_count => x_msg_count
413: , p_data => x_msg_data
414: );
415: END IF;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: WHEN NO_DATA_FOUND THEN
418: ROLLBACK TO BscKpiMeasurePub_Update;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: IF (x_msg_data IS NOT NULL) THEN

Line 419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

415: END IF;
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: WHEN NO_DATA_FOUND THEN
418: ROLLBACK TO BscKpiMeasurePub_Update;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: IF (x_msg_data IS NOT NULL) THEN
421: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
422: ELSE
423: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
424: END IF;
425: WHEN OTHERS THEN
426: ROLLBACK TO BscKpiMeasurePub_Update;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: IF (x_msg_data IS NOT NULL) THEN
429: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
430: ELSE
431: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';

Line 438: p_commit IN VARCHAR2:= FND_API.G_FALSE

434:
435: /************************************************************************************
436: ************************************************************************************/
437: PROCEDURE Delete_Kpi_Measure_Props (
438: p_commit IN VARCHAR2:= FND_API.G_FALSE
439: , p_objective_id IN NUMBER
440: , p_kpi_measure_id IN NUMBER
441: , p_cascade_shared IN BOOLEAN := TRUE
442: , x_return_status OUT NOCOPY VARCHAR2

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

455:
456: BEGIN
457:
458: FND_MSG_PUB.Initialize;
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461: SAVEPOINT BscKpiMeasurePub_Delete;
462:
463: -- Any Business Logic Validation

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

469: , x_return_status => x_return_status
470: , x_msg_count => x_msg_count
471: , x_msg_data => x_msg_data
472: );
473: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
474: RAISE FND_API.G_EXC_ERROR;
475: END IF;
476:
477: IF p_cascade_shared THEN

Line 474: RAISE FND_API.G_EXC_ERROR;

470: , x_msg_count => x_msg_count
471: , x_msg_data => x_msg_data
472: );
473: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
474: RAISE FND_API.G_EXC_ERROR;
475: END IF;
476:
477: IF p_cascade_shared THEN
478:

Line 487: RAISE FND_API.G_EXC_ERROR;

483: , p_kpi_measure_id => p_kpi_measure_id
484: , p_shared_objective_id => c_shared.indicator
485: );
486: IF l_kpi_measure_id IS NULL THEN
487: RAISE FND_API.G_EXC_ERROR;
488: END IF;
489:
490: BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props
491: ( p_commit => p_commit

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

494: , x_return_status => x_return_status
495: , x_msg_count => x_msg_count
496: , x_msg_data => x_msg_data
497: );
498: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:
502: END LOOP;

Line 499: RAISE FND_API.G_EXC_ERROR;

495: , x_msg_count => x_msg_count
496: , x_msg_data => x_msg_data
497: );
498: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:
502: END LOOP;
503:

Line 507: WHEN FND_API.G_EXC_ERROR THEN

503:
504: END IF;
505:
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: ROLLBACK TO BscKpiMeasurePub_Delete;
509: IF (x_msg_data IS NULL) THEN
510: FND_MSG_PUB.Count_And_Get
511: ( p_encoded => FND_API.G_FALSE

Line 511: ( p_encoded => FND_API.G_FALSE

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

Line 516: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 521: ( p_encoded => FND_API.G_FALSE

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

Line 526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

522: , p_count => x_msg_count
523: , p_data => x_msg_data
524: );
525: END IF;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: WHEN NO_DATA_FOUND THEN
528: ROLLBACK TO BscKpiMeasurePub_Delete;
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF (x_msg_data IS NOT NULL) THEN

Line 529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

525: END IF;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: WHEN NO_DATA_FOUND THEN
528: ROLLBACK TO BscKpiMeasurePub_Delete;
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF (x_msg_data IS NOT NULL) THEN
531: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
532: ELSE
533: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';

Line 537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

533: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
534: END IF;
535: WHEN OTHERS THEN
536: ROLLBACK TO BscKpiMeasurePub_Delete;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: IF (x_msg_data IS NOT NULL) THEN
539: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
540: ELSE
541: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';

Line 548: p_commit IN VARCHAR2:= FND_API.G_FALSE

544:
545: /************************************************************************************
546: ************************************************************************************/
547: PROCEDURE Delete_Obj_Kpi_Measure_Props (
548: p_commit IN VARCHAR2:= FND_API.G_FALSE
549: , p_objective_id IN NUMBER
550: , p_cascade_shared IN BOOLEAN := TRUE
551: , x_return_status OUT NOCOPY VARCHAR2
552: , x_msg_count OUT NOCOPY NUMBER

Line 566: x_return_status := FND_API.G_RET_STS_SUCCESS;

562:
563: BEGIN
564:
565: FND_MSG_PUB.Initialize;
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567:
568: SAVEPOINT BscKpiMeasurePub_DeleteAll;
569:
570: -- Any Business Logic Validation

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

575: , x_return_status => x_return_status
576: , x_msg_count => x_msg_count
577: , x_msg_data => x_msg_data
578: );
579: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: IF p_cascade_shared THEN

Line 580: RAISE FND_API.G_EXC_ERROR;

576: , x_msg_count => x_msg_count
577: , x_msg_data => x_msg_data
578: );
579: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
580: RAISE FND_API.G_EXC_ERROR;
581: END IF;
582:
583: IF p_cascade_shared THEN
584:

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

590: , x_return_status => x_return_status
591: , x_msg_count => x_msg_count
592: , x_msg_data => x_msg_data
593: );
594: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;
597:
598: END LOOP;

Line 595: RAISE FND_API.G_EXC_ERROR;

591: , x_msg_count => x_msg_count
592: , x_msg_data => x_msg_data
593: );
594: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
595: RAISE FND_API.G_EXC_ERROR;
596: END IF;
597:
598: END LOOP;
599:

Line 603: WHEN FND_API.G_EXC_ERROR THEN

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

Line 607: ( p_encoded => FND_API.G_FALSE

603: WHEN FND_API.G_EXC_ERROR THEN
604: ROLLBACK TO BscKpiMeasurePub_DeleteAll;
605: IF (x_msg_data IS NULL) THEN
606: FND_MSG_PUB.Count_And_Get
607: ( p_encoded => FND_API.G_FALSE
608: , p_count => x_msg_count
609: , p_data => x_msg_data
610: );
611: END IF;

Line 612: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 617: ( p_encoded => FND_API.G_FALSE

613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
614: ROLLBACK TO BscKpiMeasurePub_DeleteAll;
615: IF (x_msg_data IS NULL) THEN
616: FND_MSG_PUB.Count_And_Get
617: ( p_encoded => FND_API.G_FALSE
618: , p_count => x_msg_count
619: , p_data => x_msg_data
620: );
621: END IF;

Line 622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

618: , p_count => x_msg_count
619: , p_data => x_msg_data
620: );
621: END IF;
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: WHEN NO_DATA_FOUND THEN
624: ROLLBACK TO BscKpiMeasurePub_DeleteAll;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: IF (x_msg_data IS NOT NULL) THEN

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: END IF;
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: WHEN NO_DATA_FOUND THEN
624: ROLLBACK TO BscKpiMeasurePub_DeleteAll;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: IF (x_msg_data IS NOT NULL) THEN
627: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
628: ELSE
629: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

Line 633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

629: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
630: END IF;
631: WHEN OTHERS THEN
632: ROLLBACK TO BscKpiMeasurePub_DeleteAll;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: IF (x_msg_data IS NOT NULL) THEN
635: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
636: ELSE
637: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

Line 655: x_return_status := FND_API.G_RET_STS_SUCCESS;

651: IS
652: BEGIN
653:
654: FND_MSG_PUB.Initialize;
655: x_return_status := FND_API.G_RET_STS_SUCCESS;
656:
657: -- Any Business Logic Validation
658:
659: BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props

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

663: , x_return_status => x_return_status
664: , x_msg_count => x_msg_count
665: , x_msg_data => x_msg_data
666: );
667: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: EXCEPTION

Line 668: RAISE FND_API.G_EXC_ERROR;

664: , x_msg_count => x_msg_count
665: , x_msg_data => x_msg_data
666: );
667: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN

Line 672: WHEN FND_API.G_EXC_ERROR THEN

668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670:
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: IF (x_msg_data IS NULL) THEN
674: FND_MSG_PUB.Count_And_Get
675: ( p_encoded => FND_API.G_FALSE
676: , p_count => x_msg_count

Line 675: ( p_encoded => FND_API.G_FALSE

671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: IF (x_msg_data IS NULL) THEN
674: FND_MSG_PUB.Count_And_Get
675: ( p_encoded => FND_API.G_FALSE
676: , p_count => x_msg_count
677: , p_data => x_msg_data
678: );
679: END IF;

Line 680: x_return_status := FND_API.G_RET_STS_ERROR;

676: , p_count => x_msg_count
677: , p_data => x_msg_data
678: );
679: END IF;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: IF (x_msg_data IS NULL) THEN
683: FND_MSG_PUB.Count_And_Get
684: ( p_encoded => FND_API.G_FALSE

Line 681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

677: , p_data => x_msg_data
678: );
679: END IF;
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: IF (x_msg_data IS NULL) THEN
683: FND_MSG_PUB.Count_And_Get
684: ( p_encoded => FND_API.G_FALSE
685: , p_count => x_msg_count

Line 684: ( p_encoded => FND_API.G_FALSE

680: x_return_status := FND_API.G_RET_STS_ERROR;
681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: IF (x_msg_data IS NULL) THEN
683: FND_MSG_PUB.Count_And_Get
684: ( p_encoded => FND_API.G_FALSE
685: , p_count => x_msg_count
686: , p_data => x_msg_data
687: );
688: END IF;

Line 689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

685: , p_count => x_msg_count
686: , p_data => x_msg_data
687: );
688: END IF;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: WHEN NO_DATA_FOUND THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: IF (x_msg_data IS NOT NULL) THEN
693: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

Line 691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

687: );
688: END IF;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: WHEN NO_DATA_FOUND THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: IF (x_msg_data IS NOT NULL) THEN
693: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
694: ELSE
695: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

Line 698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

694: ELSE
695: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
696: END IF;
697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF (x_msg_data IS NOT NULL) THEN
700: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
701: ELSE
702: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';