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

Line 7: p_commit IN VARCHAR2 := FND_API.G_FALSE

3:
4: /************************************************************************************
5: ************************************************************************************/
6: PROCEDURE Create_Kpi_Measure_Props (
7: p_commit IN VARCHAR2 := FND_API.G_FALSE
8: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
9: , x_return_status OUT NOCOPY VARCHAR2
10: , x_msg_count OUT NOCOPY NUMBER
11: , x_msg_data OUT NOCOPY VARCHAR2

Line 18: x_return_status := FND_API.G_RET_STS_SUCCESS;

14: l_count NUMBER;
15: BEGIN
16:
17: FND_MSG_PUB.Initialize;
18: x_return_status := FND_API.G_RET_STS_SUCCESS;
19:
20: SAVEPOINT BscKpiMeasurePvt_Create;
21:
22: IF (p_kpi_measure_rec.objective_id IS NULL) THEN

Line 25: RAISE FND_API.G_EXC_ERROR;

21:
22: IF (p_kpi_measure_rec.objective_id IS NULL) THEN
23: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
24: FND_MSG_PUB.ADD;
25: RAISE FND_API.G_EXC_ERROR;
26: ELSIF (p_kpi_measure_rec.kpi_measure_id IS NULL) THEN
27: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
28: FND_MSG_PUB.ADD;
29: RAISE FND_API.G_EXC_ERROR;

Line 29: RAISE FND_API.G_EXC_ERROR;

25: RAISE FND_API.G_EXC_ERROR;
26: ELSIF (p_kpi_measure_rec.kpi_measure_id IS NULL) THEN
27: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
28: FND_MSG_PUB.ADD;
29: RAISE FND_API.G_EXC_ERROR;
30: ELSE
31: SELECT COUNT(1) INTO l_count
32: FROM bsc_kpi_measure_props
33: WHERE indicator = p_kpi_measure_rec.objective_id

Line 40: RAISE FND_API.G_EXC_ERROR;

36: FND_MESSAGE.SET_NAME('BSC','BSC_OBJ_KPIMEASURE_EXISTS');
37: FND_MESSAGE.SET_TOKEN('OBJECTIVE_ID', p_kpi_measure_rec.objective_id);
38: FND_MESSAGE.SET_TOKEN('KPI_MEASURE_ID', p_kpi_measure_rec.kpi_measure_id);
39: FND_MSG_PUB.ADD;
40: RAISE FND_API.G_EXC_ERROR;
41: END IF;
42: END IF;
43:
44: INSERT INTO bsc_kpi_measure_props

Line 77: IF (p_commit = FND_API.G_TRUE) THEN

73: , NVL(p_kpi_measure_rec.last_updated_by, FND_GLOBAL.USER_ID)
74: , NVL(p_kpi_measure_rec.last_update_login, FND_GLOBAL.LOGIN_ID)
75: );
76:
77: IF (p_commit = FND_API.G_TRUE) THEN
78: COMMIT;
79: END IF;
80:
81: EXCEPTION

Line 82: WHEN FND_API.G_EXC_ERROR THEN

78: COMMIT;
79: END IF;
80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO BscKpiMeasurePvt_Create;
84: IF (x_msg_data IS NULL) THEN
85: FND_MSG_PUB.Count_And_Get
86: ( p_encoded => FND_API.G_FALSE

Line 86: ( p_encoded => FND_API.G_FALSE

82: WHEN FND_API.G_EXC_ERROR THEN
83: ROLLBACK TO BscKpiMeasurePvt_Create;
84: IF (x_msg_data IS NULL) THEN
85: FND_MSG_PUB.Count_And_Get
86: ( p_encoded => FND_API.G_FALSE
87: , p_count => x_msg_count
88: , p_data => x_msg_data
89: );
90: END IF;

Line 91: x_return_status := FND_API.G_RET_STS_ERROR;

87: , p_count => x_msg_count
88: , p_data => x_msg_data
89: );
90: END IF;
91: x_return_status := FND_API.G_RET_STS_ERROR;
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: ROLLBACK TO BscKpiMeasurePvt_Create;
94: IF (x_msg_data IS NULL) THEN
95: FND_MSG_PUB.Count_And_Get

Line 92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

88: , p_data => x_msg_data
89: );
90: END IF;
91: x_return_status := FND_API.G_RET_STS_ERROR;
92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: ROLLBACK TO BscKpiMeasurePvt_Create;
94: IF (x_msg_data IS NULL) THEN
95: FND_MSG_PUB.Count_And_Get
96: ( p_encoded => FND_API.G_FALSE

Line 96: ( p_encoded => FND_API.G_FALSE

92: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
93: ROLLBACK TO BscKpiMeasurePvt_Create;
94: IF (x_msg_data IS NULL) THEN
95: FND_MSG_PUB.Count_And_Get
96: ( p_encoded => FND_API.G_FALSE
97: , p_count => x_msg_count
98: , p_data => x_msg_data
99: );
100: END IF;

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

97: , p_count => x_msg_count
98: , p_data => x_msg_data
99: );
100: END IF;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: WHEN NO_DATA_FOUND THEN
103: ROLLBACK TO BscKpiMeasurePvt_Create;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF (x_msg_data IS NOT NULL) THEN

Line 104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

100: END IF;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: WHEN NO_DATA_FOUND THEN
103: ROLLBACK TO BscKpiMeasurePvt_Create;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF (x_msg_data IS NOT NULL) THEN
106: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
107: ELSE
108: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';

Line 112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

108: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
109: END IF;
110: WHEN OTHERS THEN
111: ROLLBACK TO BscKpiMeasurePvt_Create;
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_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
115: ELSE
116: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';

Line 123: p_commit IN VARCHAR2 := FND_API.G_FALSE

119:
120: /************************************************************************************
121: ************************************************************************************/
122: PROCEDURE Update_Kpi_Measure_Props (
123: p_commit IN VARCHAR2 := FND_API.G_FALSE
124: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
125: , x_return_status OUT NOCOPY VARCHAR2
126: , x_msg_count OUT NOCOPY NUMBER
127: , x_msg_data OUT NOCOPY VARCHAR2

Line 133: x_return_status := FND_API.G_RET_STS_SUCCESS;

129: IS
130: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
131: BEGIN
132: FND_MSG_PUB.Initialize;
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:
135: SAVEPOINT BscKpiMeasurePvt_Update;
136:
137: IF (p_kpi_measure_rec.objective_id IS NULL) THEN

Line 140: RAISE FND_API.G_EXC_ERROR;

136:
137: IF (p_kpi_measure_rec.objective_id IS NULL) THEN
138: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
139: FND_MSG_PUB.ADD;
140: RAISE FND_API.G_EXC_ERROR;
141: ELSIF (p_kpi_measure_rec.kpi_measure_id IS NULL) THEN
142: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
143: FND_MSG_PUB.ADD;
144: RAISE FND_API.G_EXC_ERROR;

Line 144: RAISE FND_API.G_EXC_ERROR;

140: RAISE FND_API.G_EXC_ERROR;
141: ELSIF (p_kpi_measure_rec.kpi_measure_id IS NULL) THEN
142: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
143: FND_MSG_PUB.ADD;
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:
147: Retrieve_Kpi_Measure_Props
148: ( p_objective_id => p_kpi_measure_rec.objective_id

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

151: , x_return_status => x_return_status
152: , x_msg_count => x_msg_count
153: , x_msg_data => x_msg_data
154: );
155: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;
158:
159: l_kpi_measure_rec.default_calculation:= p_kpi_measure_rec.default_calculation;

Line 156: RAISE FND_API.G_EXC_ERROR;

152: , x_msg_count => x_msg_count
153: , x_msg_data => x_msg_data
154: );
155: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;
158:
159: l_kpi_measure_rec.default_calculation:= p_kpi_measure_rec.default_calculation;
160: IF(p_kpi_measure_rec.prototype_color IS NOT NULL) THEN

Line 208: IF (p_commit = FND_API.G_TRUE) THEN

204: , last_update_login = l_kpi_measure_rec.last_update_login
205: WHERE indicator = l_kpi_measure_rec.objective_id
206: AND kpi_measure_id = l_kpi_measure_rec.kpi_measure_id;
207:
208: IF (p_commit = FND_API.G_TRUE) THEN
209: COMMIT;
210: END IF;
211:
212: EXCEPTION

Line 213: WHEN FND_API.G_EXC_ERROR THEN

209: COMMIT;
210: END IF;
211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO BscKpiMeasurePvt_Update;
215: IF (x_msg_data IS NULL) THEN
216: FND_MSG_PUB.Count_And_Get
217: ( p_encoded => FND_API.G_FALSE

Line 217: ( p_encoded => FND_API.G_FALSE

213: WHEN FND_API.G_EXC_ERROR THEN
214: ROLLBACK TO BscKpiMeasurePvt_Update;
215: IF (x_msg_data IS NULL) THEN
216: FND_MSG_PUB.Count_And_Get
217: ( p_encoded => FND_API.G_FALSE
218: , p_count => x_msg_count
219: , p_data => x_msg_data
220: );
221: END IF;

Line 222: x_return_status := FND_API.G_RET_STS_ERROR;

218: , p_count => x_msg_count
219: , p_data => x_msg_data
220: );
221: END IF;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO BscKpiMeasurePvt_Update;
225: IF (x_msg_data IS NULL) THEN
226: FND_MSG_PUB.Count_And_Get

Line 223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

219: , p_data => x_msg_data
220: );
221: END IF;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO BscKpiMeasurePvt_Update;
225: IF (x_msg_data IS NULL) THEN
226: FND_MSG_PUB.Count_And_Get
227: ( p_encoded => FND_API.G_FALSE

Line 227: ( p_encoded => FND_API.G_FALSE

223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO BscKpiMeasurePvt_Update;
225: IF (x_msg_data IS NULL) THEN
226: FND_MSG_PUB.Count_And_Get
227: ( p_encoded => FND_API.G_FALSE
228: , p_count => x_msg_count
229: , p_data => x_msg_data
230: );
231: END IF;

Line 232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

228: , p_count => x_msg_count
229: , p_data => x_msg_data
230: );
231: END IF;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: WHEN NO_DATA_FOUND THEN
234: ROLLBACK TO BscKpiMeasurePvt_Update;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF (x_msg_data IS NOT NULL) THEN

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231: END IF;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: WHEN NO_DATA_FOUND THEN
234: ROLLBACK TO BscKpiMeasurePvt_Update;
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_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
238: ELSE
239: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';

Line 243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

239: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
240: END IF;
241: WHEN OTHERS THEN
242: ROLLBACK TO BscKpiMeasurePvt_Update;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: IF (x_msg_data IS NOT NULL) THEN
245: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
246: ELSE
247: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';

Line 254: p_commit IN VARCHAR2:= FND_API.G_FALSE

250:
251: /************************************************************************************
252: ************************************************************************************/
253: PROCEDURE Delete_Kpi_Measure_Props (
254: p_commit IN VARCHAR2:= FND_API.G_FALSE
255: , p_objective_id IN NUMBER
256: , p_kpi_measure_id IN NUMBER
257: , x_return_status OUT NOCOPY VARCHAR2
258: , x_msg_count OUT NOCOPY NUMBER

Line 264: x_return_status := FND_API.G_RET_STS_SUCCESS;

260: )
261: IS
262: BEGIN
263: FND_MSG_PUB.Initialize;
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265:
266: SAVEPOINT BscKpiMeasurePvt_Delete;
267:
268: IF (p_objective_id IS NULL) THEN

Line 271: RAISE FND_API.G_EXC_ERROR;

267:
268: IF (p_objective_id IS NULL) THEN
269: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
270: FND_MSG_PUB.ADD;
271: RAISE FND_API.G_EXC_ERROR;
272: ELSIF (p_kpi_measure_id IS NULL) THEN
273: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
274: FND_MSG_PUB.ADD;
275: RAISE FND_API.G_EXC_ERROR;

Line 275: RAISE FND_API.G_EXC_ERROR;

271: RAISE FND_API.G_EXC_ERROR;
272: ELSIF (p_kpi_measure_id IS NULL) THEN
273: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
274: FND_MSG_PUB.ADD;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:
278: DELETE FROM bsc_kpi_measure_props
279: WHERE indicator = p_objective_id

Line 282: IF (p_commit = FND_API.G_TRUE) THEN

278: DELETE FROM bsc_kpi_measure_props
279: WHERE indicator = p_objective_id
280: AND kpi_measure_id = p_kpi_measure_id;
281:
282: IF (p_commit = FND_API.G_TRUE) THEN
283: COMMIT;
284: END IF;
285:
286: EXCEPTION

Line 287: WHEN FND_API.G_EXC_ERROR THEN

283: COMMIT;
284: END IF;
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO BscKpiMeasurePvt_Delete;
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 BscKpiMeasurePvt_Delete;
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 BscKpiMeasurePvt_Delete;
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 BscKpiMeasurePvt_Delete;
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 BscKpiMeasurePvt_Delete;
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 BscKpiMeasurePvt_Delete;
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 BscKpiMeasurePvt_Delete;
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_PVT.Delete_Kpi_Measure_Props ';
312: ELSE
313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';

Line 317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';
314: END IF;
315: WHEN OTHERS THEN
316: ROLLBACK TO BscKpiMeasurePvt_Delete;
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_PVT.Delete_Kpi_Measure_Props ';
320: ELSE
321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';

Line 328: p_commit IN VARCHAR2:= FND_API.G_FALSE

324:
325: /************************************************************************************
326: ************************************************************************************/
327: PROCEDURE Delete_Obj_Kpi_Measure_Props (
328: p_commit IN VARCHAR2:= FND_API.G_FALSE
329: , p_objective_id IN NUMBER
330: , x_return_status OUT NOCOPY VARCHAR2
331: , x_msg_count OUT NOCOPY NUMBER
332: , x_msg_data OUT NOCOPY VARCHAR2

Line 337: x_return_status := FND_API.G_RET_STS_SUCCESS;

333: )
334: IS
335: BEGIN
336: FND_MSG_PUB.Initialize;
337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338:
339: SAVEPOINT BscKpiMeasurePvt_DeleteAll;
340:
341: IF (p_objective_id IS NULL) THEN

Line 344: RAISE FND_API.G_EXC_ERROR;

340:
341: IF (p_objective_id IS NULL) THEN
342: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
343: FND_MSG_PUB.ADD;
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347: DELETE FROM bsc_kpi_measure_props
348: WHERE indicator = p_objective_id;

Line 350: IF (p_commit = FND_API.G_TRUE) THEN

346:
347: DELETE FROM bsc_kpi_measure_props
348: WHERE indicator = p_objective_id;
349:
350: IF (p_commit = FND_API.G_TRUE) THEN
351: COMMIT;
352: END IF;
353:
354: EXCEPTION

Line 355: WHEN FND_API.G_EXC_ERROR THEN

351: COMMIT;
352: END IF;
353:
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
357: IF (x_msg_data IS NULL) THEN
358: FND_MSG_PUB.Count_And_Get
359: ( p_encoded => FND_API.G_FALSE

Line 359: ( p_encoded => FND_API.G_FALSE

355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
357: IF (x_msg_data IS NULL) THEN
358: FND_MSG_PUB.Count_And_Get
359: ( p_encoded => FND_API.G_FALSE
360: , p_count => x_msg_count
361: , p_data => x_msg_data
362: );
363: END IF;

Line 364: x_return_status := FND_API.G_RET_STS_ERROR;

360: , p_count => x_msg_count
361: , p_data => x_msg_data
362: );
363: END IF;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
367: IF (x_msg_data IS NULL) THEN
368: FND_MSG_PUB.Count_And_Get

Line 365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

361: , p_data => x_msg_data
362: );
363: END IF;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
367: IF (x_msg_data IS NULL) THEN
368: FND_MSG_PUB.Count_And_Get
369: ( p_encoded => FND_API.G_FALSE

Line 369: ( p_encoded => FND_API.G_FALSE

365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
367: IF (x_msg_data IS NULL) THEN
368: FND_MSG_PUB.Count_And_Get
369: ( p_encoded => FND_API.G_FALSE
370: , p_count => x_msg_count
371: , p_data => x_msg_data
372: );
373: END IF;

Line 374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

370: , p_count => x_msg_count
371: , p_data => x_msg_data
372: );
373: END IF;
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: WHEN NO_DATA_FOUND THEN
376: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF (x_msg_data IS NOT NULL) THEN

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

373: END IF;
374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
375: WHEN NO_DATA_FOUND THEN
376: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF (x_msg_data IS NOT NULL) THEN
379: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
380: ELSE
381: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';

Line 385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
382: END IF;
383: WHEN OTHERS THEN
384: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: IF (x_msg_data IS NOT NULL) THEN
387: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
388: ELSE
389: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';

Line 406: x_return_status := FND_API.G_RET_STS_SUCCESS;

402: )
403: IS
404: BEGIN
405: FND_MSG_PUB.Initialize;
406: x_return_status := FND_API.G_RET_STS_SUCCESS;
407:
408: IF (p_objective_id IS NULL) THEN
409: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
410: FND_MSG_PUB.ADD;

Line 411: RAISE FND_API.G_EXC_ERROR;

407:
408: IF (p_objective_id IS NULL) THEN
409: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
410: FND_MSG_PUB.ADD;
411: RAISE FND_API.G_EXC_ERROR;
412: ELSIF (p_kpi_measure_id IS NULL) THEN
413: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
414: FND_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_ERROR;

Line 415: RAISE FND_API.G_EXC_ERROR;

411: RAISE FND_API.G_EXC_ERROR;
412: ELSIF (p_kpi_measure_id IS NULL) THEN
413: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
414: FND_MSG_PUB.ADD;
415: RAISE FND_API.G_EXC_ERROR;
416: END IF;
417:
418: SELECT
419: indicator

Line 453: WHEN FND_API.G_EXC_ERROR THEN

449: WHERE indicator = p_objective_id
450: AND kpi_measure_id = p_kpi_measure_id;
451:
452: EXCEPTION
453: WHEN FND_API.G_EXC_ERROR THEN
454: IF (x_msg_data IS NULL) THEN
455: FND_MSG_PUB.Count_And_Get
456: ( p_encoded => FND_API.G_FALSE
457: , p_count => x_msg_count

Line 456: ( p_encoded => FND_API.G_FALSE

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

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

457: , p_count => x_msg_count
458: , p_data => x_msg_data
459: );
460: END IF;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: IF (x_msg_data IS NULL) THEN
464: FND_MSG_PUB.Count_And_Get
465: ( p_encoded => FND_API.G_FALSE

Line 462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

458: , p_data => x_msg_data
459: );
460: END IF;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: IF (x_msg_data IS NULL) THEN
464: FND_MSG_PUB.Count_And_Get
465: ( p_encoded => FND_API.G_FALSE
466: , p_count => x_msg_count

Line 465: ( p_encoded => FND_API.G_FALSE

461: x_return_status := FND_API.G_RET_STS_ERROR;
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: IF (x_msg_data IS NULL) THEN
464: FND_MSG_PUB.Count_And_Get
465: ( p_encoded => FND_API.G_FALSE
466: , p_count => x_msg_count
467: , p_data => x_msg_data
468: );
469: END IF;

Line 470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

466: , p_count => x_msg_count
467: , p_data => x_msg_data
468: );
469: END IF;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: WHEN NO_DATA_FOUND THEN
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: IF (x_msg_data IS NOT NULL) THEN
474: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';

Line 472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

468: );
469: END IF;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: WHEN NO_DATA_FOUND THEN
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: IF (x_msg_data IS NOT NULL) THEN
474: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
475: ELSE
476: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

475: ELSE
476: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
477: END IF;
478: WHEN OTHERS THEN
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: IF (x_msg_data IS NOT NULL) THEN
481: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
482: ELSE
483: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';