DBA Data[Home] [Help]

APPS.CN_PSUM_PVT dependencies on FND_MSG_PUB

Line 83: FND_MSG_PUB.initialize;

79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean( p_init_msg_list ) THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85: -- Initialize API return status to success
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87: x_total_rows := 0;

Line 258: FND_MSG_PUB.Count_And_Get

254: IF FND_API.To_Boolean( p_commit ) THEN
255: COMMIT WORK;
256: END IF;
257: -- Standard call to get message count and if count is 1, get message info.
258: FND_MSG_PUB.Count_And_Get
259: (
260: p_count => x_msg_count ,
261: p_data => x_msg_data ,
262: p_encoded => FND_API.G_FALSE

Line 269: FND_MSG_PUB.Count_And_Get

265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: ROLLBACK TO Get_Psum_Data_SP ;
268: x_return_status := FND_API.G_RET_STS_ERROR ;
269: FND_MSG_PUB.Count_And_Get
270: (
271: p_count => x_msg_count ,
272: p_data => x_msg_data ,
273: p_encoded => FND_API.G_FALSE

Line 279: FND_MSG_PUB.Count_And_Get

275:
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: ROLLBACK TO Get_Psum_Data_SP ;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
279: FND_MSG_PUB.Count_And_Get
280: (
281: p_count => x_msg_count ,
282: p_data => x_msg_data ,
283: p_encoded => FND_API.G_FALSE

Line 288: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

284: );
285: WHEN OTHERS THEN
286: ROLLBACK TO Get_Psum_Data_SP ;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
291: END IF;
292: FND_MSG_PUB.Count_And_Get

Line 290: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

286: ROLLBACK TO Get_Psum_Data_SP ;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
291: END IF;
292: FND_MSG_PUB.Count_And_Get
293: (
294: p_count => x_msg_count ,

Line 292: FND_MSG_PUB.Count_And_Get

288: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
291: END IF;
292: FND_MSG_PUB.Count_And_Get
293: (
294: p_count => x_msg_count ,
295: p_data => x_msg_data ,
296: p_encoded => FND_API.G_FALSE

Line 345: FND_MSG_PUB.initialize;

341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: END IF;
343: -- Initialize message list if p_init_msg_list is set to TRUE.
344: IF FND_API.to_Boolean( p_init_msg_list ) THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347: -- Initialize API return status to success
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: x_total_rows := 0;

Line 535: FND_MSG_PUB.Count_And_Get

531: IF FND_API.To_Boolean( p_commit ) THEN
532: COMMIT WORK;
533: END IF;
534: -- Standard call to get message count and if count is 1, get message info.
535: FND_MSG_PUB.Count_And_Get
536: (
537: p_count => x_msg_count ,
538: p_data => x_msg_data ,
539: p_encoded => FND_API.G_FALSE

Line 546: FND_MSG_PUB.Count_And_Get

542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: ROLLBACK TO Get_MO_Psum_Data_SP ;
545: x_return_status := FND_API.G_RET_STS_ERROR ;
546: FND_MSG_PUB.Count_And_Get
547: (
548: p_count => x_msg_count ,
549: p_data => x_msg_data ,
550: p_encoded => FND_API.G_FALSE

Line 556: FND_MSG_PUB.Count_And_Get

552:
553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
554: ROLLBACK TO Get_MO_Psum_Data_SP ;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556: FND_MSG_PUB.Count_And_Get
557: (
558: p_count => x_msg_count ,
559: p_data => x_msg_data ,
560: p_encoded => FND_API.G_FALSE

Line 565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

561: );
562: WHEN OTHERS THEN
563: ROLLBACK TO Get_MO_Psum_Data_SP ;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
568: END IF;
569: FND_MSG_PUB.Count_And_Get

Line 567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

563: ROLLBACK TO Get_MO_Psum_Data_SP ;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
568: END IF;
569: FND_MSG_PUB.Count_And_Get
570: (
571: p_count => x_msg_count ,

Line 569: FND_MSG_PUB.Count_And_Get

565: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
566: THEN
567: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
568: END IF;
569: FND_MSG_PUB.Count_And_Get
570: (
571: p_count => x_msg_count ,
572: p_data => x_msg_data ,
573: p_encoded => FND_API.G_FALSE