35: ) IS
36: l_Periodicities_Rec_Type BSC_PERIODICITIES_PUB.Periodicities_Rec_Type;
37: BEGIN
38: SAVEPOINT CreatePeriodicityPVT;
39: FND_MSG_PUB.Initialize;
40: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
41:
42: l_Periodicities_Rec_Type := p_Periodicities_Rec_Type;
43:
125: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO CreatePeriodicityPVT;
128: IF (x_msg_data IS NULL) THEN
129: FND_MSG_PUB.Count_And_Get
130: ( p_encoded => FND_API.G_FALSE
131: , p_count => x_msg_count
132: , p_data => x_msg_data
133: );
135: x_Return_Status := FND_API.G_RET_STS_ERROR;
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: ROLLBACK TO CreatePeriodicityPVT;
138: IF (x_msg_data IS NULL) THEN
139: FND_MSG_PUB.Count_And_Get
140: ( p_encoded => FND_API.G_FALSE
141: , p_count => x_msg_count
142: , p_data => x_msg_data
143: );
203: AND TL.PERIODICITY_ID = B.PERIODICITY_ID
204: AND TL.LANGUAGE = USERENV('LANG');
205:
206: BEGIN
207: FND_MSG_PUB.Initialize;
208: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
209:
210: FOR C1RP IN c_RetrievePeriodicity LOOP
211: x_Periodicities_Rec_Type.Periodicity_Id := C1RP.PERIODICITY_ID;
236:
237: EXCEPTION
238: WHEN FND_API.G_EXC_ERROR THEN
239: IF (x_msg_data IS NULL) THEN
240: FND_MSG_PUB.Count_And_Get
241: ( p_encoded => FND_API.G_FALSE
242: , p_count => x_msg_count
243: , p_data => x_msg_data
244: );
246: x_Return_Status := FND_API.G_RET_STS_ERROR;
247: --removed rollback here.
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: IF (x_msg_data IS NULL) THEN
250: FND_MSG_PUB.Count_And_Get
251: ( p_encoded => FND_API.G_FALSE
252: , p_count => x_msg_count
253: , p_data => x_msg_data
254: );
285: l_Base_Periodicity_Source BSC_SYS_PERIODICITIES.SOURCE%TYPE;
286:
287: BEGIN
288: SAVEPOINT UpdatePeriodicityPVT;
289: FND_MSG_PUB.Initialize;
290: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
291:
292: x_Structural_Flag := FND_API.G_FALSE;
293:
380: EXCEPTION
381: WHEN FND_API.G_EXC_ERROR THEN
382: ROLLBACK TO UpdatePeriodicityPVT;
383: IF (x_msg_data IS NULL) THEN
384: FND_MSG_PUB.Count_And_Get
385: ( p_encoded => FND_API.G_FALSE
386: , p_count => x_msg_count
387: , p_data => x_msg_data
388: );
390: x_Return_Status := FND_API.G_RET_STS_ERROR;
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: ROLLBACK TO UpdatePeriodicityPVT;
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: );
428: FROM BSC_KPI_PERIODICITIES K
429: WHERE K.PERIODICITY_ID = p_Periodicities_Rec_Type.Periodicity_Id;
430: BEGIN
431: SAVEPOINT IncrRefreshPerPVT;
432: FND_MSG_PUB.Initialize;
433: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
434:
435:
436: FOR cObj IN c_Objectives LOOP
444: EXCEPTION
445: WHEN FND_API.G_EXC_ERROR THEN
446: ROLLBACK TO IncrRefreshPerPVT;
447: IF (x_msg_data IS NULL) THEN
448: FND_MSG_PUB.Count_And_Get
449: ( p_encoded => FND_API.G_FALSE
450: , p_count => x_msg_count
451: , p_data => x_msg_data
452: );
454: x_Return_Status := FND_API.G_RET_STS_ERROR;
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: ROLLBACK TO IncrRefreshPerPVT;
457: IF (x_msg_data IS NULL) THEN
458: FND_MSG_PUB.Count_And_Get
459: ( p_encoded => FND_API.G_FALSE
460: , p_count => x_msg_count
461: , p_data => x_msg_data
462: );
490: ,x_Msg_Data OUT NOCOPY VARCHAR2
491: ) IS
492: BEGIN
493: SAVEPOINT DeletePeriodicityPVT;
494: FND_MSG_PUB.Initialize;
495:
496: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
497:
498: DELETE BSC_SYS_PERIODS_TL
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: ROLLBACK TO DeletePeriodicityPVT;
517: IF (x_msg_data IS NULL) THEN
518: FND_MSG_PUB.Count_And_Get
519: ( p_encoded => FND_API.G_FALSE
520: , p_count => x_msg_count
521: , p_data => x_msg_data
522: );
524: x_Return_Status := FND_API.G_RET_STS_ERROR;
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526: ROLLBACK TO DeletePeriodicityPVT;
527: IF (x_msg_data IS NULL) THEN
528: FND_MSG_PUB.Count_And_Get
529: ( p_encoded => FND_API.G_FALSE
530: , p_count => x_msg_count
531: , p_data => x_msg_data
532: );