DBA Data[Home] [Help]

APPS.BSC_PERIODICITIES_PVT dependencies on FND_MSG_PUB

Line 39: FND_MSG_PUB.Initialize;

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:

Line 129: FND_MSG_PUB.Count_And_Get

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: );

Line 139: FND_MSG_PUB.Count_And_Get

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: );

Line 207: FND_MSG_PUB.Initialize;

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;

Line 240: FND_MSG_PUB.Count_And_Get

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: );

Line 250: FND_MSG_PUB.Count_And_Get

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: );

Line 289: FND_MSG_PUB.Initialize;

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:

Line 384: FND_MSG_PUB.Count_And_Get

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: );

Line 394: FND_MSG_PUB.Count_And_Get

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: );

Line 432: FND_MSG_PUB.Initialize;

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

Line 448: FND_MSG_PUB.Count_And_Get

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: );

Line 458: FND_MSG_PUB.Count_And_Get

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: );

Line 494: FND_MSG_PUB.Initialize;

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

Line 518: FND_MSG_PUB.Count_And_Get

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: );

Line 528: FND_MSG_PUB.Count_And_Get

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: );