APPS.PSB_PURGE_DATA_EXTRACT_PVT dependencies on FND_MSG_PUB

Line 131: FND_MSG_PUB.initialize;

127:
128: -- Initialize message list if p_init_msg_list is set to TRUE.
129:
130: if FND_API.to_Boolean (p_init_msg_list) then
131: FND_MSG_PUB.initialize;
132: end if;
133:
134: -- Initialize API return status to success
135:

Line 215: FND_MSG_PUB.Add;

211: where data_extract_id = p_data_extract_id;
212:
213: if (l_worksheet_cnt > 0) then
214: FND_MESSAGE.SET_NAME('PSB', 'PSB_DE_CANNOT_BE_DELETED');
215: FND_MSG_PUB.Add;
216: p_purge := 'NO_PURGE';
217: raise FND_API.G_EXC_ERROR;
218: End if;
219: End;

Line 483: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

479: end if;
480:
481: -- Standard call to get message count and if count is 1, get message info.
482:
483: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
484: p_data => p_msg_data);
485:
486: EXCEPTION
487:

Line 497: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

493: /*For Bug No : 2577889 End*/
494:
495: p_return_status := FND_API.G_RET_STS_ERROR;
496:
497: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
498: p_data => p_msg_data);
499:
500:
501: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 510: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

506: /*For Bug No : 2577889 End*/
507:
508: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509:
510: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
511: p_data => p_msg_data);
512:
513:
514: when OTHERS then

Line 521: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

517: --rollback to Purge_Data_Extract;
518: rollback;
519: /*For Bug No : 2577889 End*/
520:
521: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
522:
523: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
524: l_api_name);
525: end if;

Line 523: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

519: /*For Bug No : 2577889 End*/
520:
521: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
522:
523: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
524: l_api_name);
525: end if;
526:
527: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 527: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

523: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
524: l_api_name);
525: end if;
526:
527: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
528: p_data => p_msg_data);
529:
530: END Purge_Data_Extract;
531:

Line 599: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

595: EXCEPTION
596: --
597: WHEN OTHERS THEN
598: --
599: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
600: --
601: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
602: l_api_name ) ;
603: END IF ;

Line 601: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

597: WHEN OTHERS THEN
598: --
599: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
600: --
601: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
602: l_api_name ) ;
603: END IF ;
604: --
605: PSB_MESSAGE_S.Print_Error( p_mode => FND_FILE.OUTPUT,

Line 659: FND_MSG_PUB.Add;

655: end loop;
656:
657: end if;
658:
659: FND_MSG_PUB.Add;
660:
661: end if;
662:
663: -- Clear Message Token stack