23: l_kpi_measure_id NUMBER;
24:
25: BEGIN
26:
27: FND_MSG_PUB.Initialize;
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: SAVEPOINT BscKpiMeasureWeightPub_Create;
31:
75: EXCEPTION
76: WHEN FND_API.G_EXC_ERROR THEN
77: ROLLBACK TO BscKpiMeasureWeightPub_Create;
78: IF (x_msg_data IS NULL) THEN
79: FND_MSG_PUB.Count_And_Get
80: ( p_encoded => FND_API.G_FALSE
81: , p_count => x_msg_count
82: , p_data => x_msg_data
83: );
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
87: ROLLBACK TO BscKpiMeasureWeightPub_Create;
88: IF (x_msg_data IS NULL) THEN
89: FND_MSG_PUB.Count_And_Get
90: ( p_encoded => FND_API.G_FALSE
91: , p_count => x_msg_count
92: , p_data => x_msg_data
93: );
132: l_kpi_measure_weights_rec BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;
133: l_kpi_measure_id NUMBER;
134: BEGIN
135:
136: FND_MSG_PUB.Initialize;
137: x_return_status := FND_API.G_RET_STS_SUCCESS;
138:
139: SAVEPOINT BscKpiMeasureWeightPub_Update;
140:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: ROLLBACK TO BscKpiMeasureWeightPub_Update;
187: IF (x_msg_data IS NULL) THEN
188: FND_MSG_PUB.Count_And_Get
189: ( p_encoded => FND_API.G_FALSE
190: , p_count => x_msg_count
191: , p_data => x_msg_data
192: );
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
196: ROLLBACK TO BscKpiMeasureWeightPub_Update;
197: IF (x_msg_data IS NULL) THEN
198: FND_MSG_PUB.Count_And_Get
199: ( p_encoded => FND_API.G_FALSE
200: , p_count => x_msg_count
201: , p_data => x_msg_data
202: );
242: l_kpi_measure_id NUMBER;
243:
244: BEGIN
245:
246: FND_MSG_PUB.Initialize;
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248:
249: SAVEPOINT BscKpiMeasureWeightPub_Delete;
250:
294: EXCEPTION
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO BscKpiMeasureWeightPub_Delete;
297: IF (x_msg_data IS NULL) THEN
298: FND_MSG_PUB.Count_And_Get
299: ( p_encoded => FND_API.G_FALSE
300: , p_count => x_msg_count
301: , p_data => x_msg_data
302: );
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
306: ROLLBACK TO BscKpiMeasureWeightPub_Delete;
307: IF (x_msg_data IS NULL) THEN
308: FND_MSG_PUB.Count_And_Get
309: ( p_encoded => FND_API.G_FALSE
310: , p_count => x_msg_count
311: , p_data => x_msg_data
312: );
349: AND prototype_flag <> 2;
350:
351: BEGIN
352:
353: FND_MSG_PUB.Initialize;
354: x_return_status := FND_API.G_RET_STS_SUCCESS;
355:
356: SAVEPOINT BscKpiMeasureWeightPub_DelAll;
357:
390: EXCEPTION
391: WHEN FND_API.G_EXC_ERROR THEN
392: ROLLBACK TO BscKpiMeasureWeightPub_DelAll;
393: IF (x_msg_data IS NULL) THEN
394: FND_MSG_PUB.Count_And_Get
395: ( p_encoded => FND_API.G_FALSE
396: , p_count => x_msg_count
397: , p_data => x_msg_data
398: );
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
402: ROLLBACK TO BscKpiMeasureWeightPub_DelAll;
403: IF (x_msg_data IS NULL) THEN
404: FND_MSG_PUB.Count_And_Get
405: ( p_encoded => FND_API.G_FALSE
406: , p_count => x_msg_count
407: , p_data => x_msg_data
408: );
438: )
439: IS
440: BEGIN
441:
442: FND_MSG_PUB.Initialize;
443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:
445: -- Any Business Logic Validation
446:
458:
459: EXCEPTION
460: WHEN FND_API.G_EXC_ERROR THEN
461: IF (x_msg_data IS NULL) THEN
462: FND_MSG_PUB.Count_And_Get
463: ( p_encoded => FND_API.G_FALSE
464: , p_count => x_msg_count
465: , p_data => x_msg_data
466: );
467: END IF;
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: IF (x_msg_data IS NULL) THEN
471: FND_MSG_PUB.Count_And_Get
472: ( p_encoded => FND_API.G_FALSE
473: , p_count => x_msg_count
474: , p_data => x_msg_data
475: );