APPS.CN_OVER_ASSIGN_PVT dependencies on FND_MSG_PUB

Line 59: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

55: FETCH srp_role_info INTO l_sr_start_date , l_sr_end_date;
56:
57: -- cn_qm_mgr_srp_groups(cn_srp_role) end_date cannot be null
58: IF l_sr_end_date IS NULL THEN
59: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
60: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_SR_ED_NULL');
61: FND_MSG_PUB.Add;
62: END IF;
63: RAISE FND_API.G_EXC_ERROR;

Line 61: FND_MSG_PUB.Add;

57: -- cn_qm_mgr_srp_groups(cn_srp_role) end_date cannot be null
58: IF l_sr_end_date IS NULL THEN
59: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
60: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_SR_ED_NULL');
61: FND_MSG_PUB.Add;
62: END IF;
63: RAISE FND_API.G_EXC_ERROR;
64: END IF;
65:

Line 402: FND_MSG_PUB.initialize;

398: END IF;
399:
400: -- Initialize message list if p_init_msg_list is set to TRUE.
401: IF FND_API.to_Boolean( p_init_msg_list ) THEN
402: FND_MSG_PUB.initialize;
403: END IF;
404:
405: -- Initialize API return status to success
406: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

410: FETCH c_srp_info INTO l_srp_info;
411:
412: -- cn_qm_mgr_srp_groups(cn_srp_role) end_date cannot be null
413: IF l_srp_info.end_date IS NULL THEN
414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
415: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_SR_ED_NULL');
416: FND_MSG_PUB.Add;
417: END IF;
418: RAISE FND_API.G_EXC_ERROR;

Line 416: FND_MSG_PUB.Add;

412: -- cn_qm_mgr_srp_groups(cn_srp_role) end_date cannot be null
413: IF l_srp_info.end_date IS NULL THEN
414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
415: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_SR_ED_NULL');
416: FND_MSG_PUB.Add;
417: END IF;
418: RAISE FND_API.G_EXC_ERROR;
419: END IF;
420:

Line 423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

419: END IF;
420:
421: IF c_srp_info%notfound THEN
422: -- invalid srp_role_id
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
424: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_INVALID_SRPROLE');
425: FND_MSG_PUB.Add;
426: END IF;
427: RAISE FND_API.G_EXC_ERROR;

Line 425: FND_MSG_PUB.Add;

421: IF c_srp_info%notfound THEN
422: -- invalid srp_role_id
423: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
424: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_INVALID_SRPROLE');
425: FND_MSG_PUB.Add;
426: END IF;
427: RAISE FND_API.G_EXC_ERROR;
428: END IF;
429: CLOSE c_srp_info;

Line 746: FND_MSG_PUB.Count_And_Get

742:
743: END LOOP; -- end of each quota category
744: END IF;
745: -- Standard call to get message count and if count is 1 get message info.
746: FND_MSG_PUB.Count_And_Get
747: ( p_count => x_msg_count ,
748: p_data => x_msg_data ,
749: p_encoded => FND_API.G_FALSE
750: );

Line 755: FND_MSG_PUB.Count_And_Get

751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_ERROR ;
755: FND_MSG_PUB.Count_And_Get
756: (p_count => x_msg_count ,
757: p_data => x_msg_data ,
758: p_encoded => FND_API.G_FALSE
759: );

Line 762: FND_MSG_PUB.Count_And_Get

758: p_encoded => FND_API.G_FALSE
759: );
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: FND_MSG_PUB.Count_And_Get
763: (p_count => x_msg_count ,
764: p_data => x_msg_data ,
765: p_encoded => FND_API.G_FALSE
766: );

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

765: p_encoded => FND_API.G_FALSE
766: );
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
769: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
770: THEN
771: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
772: END IF;
773: FND_MSG_PUB.Count_And_Get

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

767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
769: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
770: THEN
771: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
772: END IF;
773: FND_MSG_PUB.Count_And_Get
774: (p_count => x_msg_count ,
775: p_data => x_msg_data ,

Line 773: FND_MSG_PUB.Count_And_Get

769: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
770: THEN
771: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
772: END IF;
773: FND_MSG_PUB.Count_And_Get
774: (p_count => x_msg_count ,
775: p_data => x_msg_data ,
776: p_encoded => FND_API.G_FALSE
777: );