DBA Data[Home] [Help]

APPS.BSC_PERIODS_PUB dependencies on FND_MSG_PUB

Line 205: FND_MSG_PUB.Initialize;

201: x_End_Period VARCHAR2(32000);
202:
203: BEGIN
204: SAVEPOINT CreatePeriodsPubSP;
205: FND_MSG_PUB.Initialize;
206: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
207: --dbms_output.put_line('before assigning ');
208: l_Period_Record := p_Period_Record;
209: l_period_Varray_Record := Parse_Periods

Line 257: FND_MSG_PUB.Count_And_Get

253: EXCEPTION
254: WHEN FND_API.G_EXC_ERROR THEN
255: ROLLBACK TO CreatePeriodsPubSP;
256: IF (x_msg_data IS NULL) THEN
257: FND_MSG_PUB.Count_And_Get
258: ( p_encoded => FND_API.G_FALSE
259: , p_count => x_msg_count
260: , p_data => x_msg_data
261: );

Line 267: FND_MSG_PUB.Count_And_Get

263: x_return_status := FND_API.G_RET_STS_ERROR;
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: ROLLBACK TO CreatePeriodsPubSP;
266: IF (x_msg_data IS NULL) THEN
267: FND_MSG_PUB.Count_And_Get
268: ( p_encoded => FND_API.G_FALSE
269: , p_count => x_msg_count
270: , p_data => x_msg_data
271: );

Line 311: FND_MSG_PUB.Initialize;

307: x_Start_Period VARCHAR2(32000);
308:
309: BEGIN
310: SAVEPOINT UpdatePeriodsPubSP;
311: FND_MSG_PUB.Initialize;
312: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
313:
314: l_Period_Record := p_Period_Record;
315: l_period_Varray_Record := Parse_Periods

Line 362: FND_MSG_PUB.Count_And_Get

358: EXCEPTION
359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO UpdatePeriodsPubSP;
361: IF (x_msg_data IS NULL) THEN
362: FND_MSG_PUB.Count_And_Get
363: ( p_encoded => FND_API.G_FALSE
364: , p_count => x_msg_count
365: , p_data => x_msg_data
366: );

Line 372: FND_MSG_PUB.Count_And_Get

368: x_return_status := FND_API.G_RET_STS_ERROR;
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO UpdatePeriodsPubSP;
371: IF (x_msg_data IS NULL) THEN
372: FND_MSG_PUB.Count_And_Get
373: ( p_encoded => FND_API.G_FALSE
374: , p_count => x_msg_count
375: , p_data => x_msg_data
376: );

Line 410: FND_MSG_PUB.Initialize;

406: , x_Msg_Data OUT NOCOPY VARCHAR2
407: )IS
408: BEGIN
409: SAVEPOINT DeletePeriodsPubSP;
410: FND_MSG_PUB.Initialize;
411: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
412:
413: BSC_PERIODS_PUB.Validate_Periods_Action
414: ( p_Api_Version => p_Api_Version

Line 448: FND_MSG_PUB.Count_And_Get

444: EXCEPTION
445: WHEN FND_API.G_EXC_ERROR THEN
446: ROLLBACK TO DeletePeriodsPubSP;
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 DeletePeriodsPubSP;
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 500: FND_MSG_PUB.Initialize;

496: l_No_Base_Periods NUMBER;
497: l_Is_Daily_Periodicity BOOLEAN;
498: BEGIN
499:
500: FND_MSG_PUB.Initialize;
501: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
502: IF(p_Period_Record.Base_Periodicity_Id IS NOT NULL) THEN
503: l_No_Base_Periods := BSC_PERIODS_UTILITY_PKG.Get_Periods_In_Base_Period(p_Period_Record.Base_Periodicity_Id);
504: l_Is_Daily_Periodicity := BSC_PERIODS_UTILITY_PKG.Is_Base_Periodicity_Daily(p_Period_Record.Base_Periodicity_Id);

Line 512: FND_MSG_PUB.ADD;

508: IF(p_Action <> BSC_PERIODS_UTILITY_PKG.C_DELETE ) THEN
509: IF((NOT l_Is_Daily_Periodicity) AND (p_Period_Record.Base_Periodicity_Id IS NOT NULL)) THEN
510: IF(x_Start_Period <> 1 OR x_End_Period <> l_No_Base_Periods) THEN
511: FND_MESSAGE.SET_NAME('BSC','BSC_WRONG_PERIODS');
512: FND_MSG_PUB.ADD;
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515: END IF;
516: END IF;

Line 521: FND_MSG_PUB.Count_And_Get

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

Line 530: FND_MSG_PUB.Count_And_Get

526: END IF;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: IF (x_msg_data IS NULL) THEN
530: FND_MSG_PUB.Count_And_Get
531: ( p_encoded => FND_API.G_FALSE
532: , p_count => x_msg_count
533: , p_data => x_msg_data
534: );

Line 594: FND_MSG_PUB.Initialize;

590: l_Period_DB_Col BSC_SYS_PERIODICITIES.DB_COLUMN_NAME%TYPE;
591:
592: BEGIN
593: --dbms_output.put_line('START :Create_Periodicity_View :- ' ||DBMS_UTILITY.GET_TIME);
594: FND_MSG_PUB.Initialize;
595: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
596: x_Periodicity_View_Name := Get_Valid_Period_View_Name(p_Short_Name);
597:
598: --dbms_output.put_line('BEFORE PREPARING SQL TEXT ');

Line 651: FND_MSG_PUB.ADD;

647: EXCEPTION
648: WHEN OTHERS THEN
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_CREATE_PER_VIEW');
651: FND_MSG_PUB.ADD;
652: FND_MSG_PUB.Count_And_Get
653: ( p_encoded => FND_API.G_FALSE
654: , p_count => x_msg_count
655: , p_data => x_msg_data

Line 652: FND_MSG_PUB.Count_And_Get

648: WHEN OTHERS THEN
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_CREATE_PER_VIEW');
651: FND_MSG_PUB.ADD;
652: FND_MSG_PUB.Count_And_Get
653: ( p_encoded => FND_API.G_FALSE
654: , p_count => x_msg_count
655: , p_data => x_msg_data
656: );

Line 672: FND_MSG_PUB.Initialize;

668: , x_Msg_Data OUT NOCOPY VARCHAR2
669: )IS
670: l_Sql_Stmt VARCHAR2(32000);
671: BEGIN
672: FND_MSG_PUB.Initialize;
673: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
674:
675: l_Sql_Stmt := 'DROP VIEW ' || p_Periodicity_View;
676:

Line 683: FND_MSG_PUB.ADD;

679:
680: EXCEPTION
681: WHEN OTHERS THEN
682: FND_MESSAGE.SET_NAME('BSC','BSC_ERROR_DELETE_PER_VIEW');
683: FND_MSG_PUB.ADD;
684: --dbms_output.put_line('WHEN THEN ERROR IS :- '||SUBSTR(SQLERRM,1,200) );
685: END Drop_Periodicity_View;
686: /*************************************************************************************/
687: