1221: ROLLBACK TO delete_agreement_pub;
1222: p_return_status := FND_API.G_RET_STS_ERROR;
1223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1224: THEN
1225: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1226: FND_MESSAGE.SET_TOKEN('AGREEMENT',p_pm_agreement_reference);
1227: FND_MSG_PUB.ADD;
1228: END IF;
1229: FND_MSG_PUB.Count_And_Get
1222: p_return_status := FND_API.G_RET_STS_ERROR;
1223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1224: THEN
1225: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1226: FND_MESSAGE.SET_TOKEN('AGREEMENT',p_pm_agreement_reference);
1227: FND_MSG_PUB.ADD;
1228: END IF;
1229: FND_MSG_PUB.Count_And_Get
1230: ( p_count => p_msg_count ,
1898: ROLLBACK TO update_project_pub;
1899: p_return_status := FND_API.G_RET_STS_ERROR;
1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1901: THEN
1902: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1903: FND_MESSAGE.SET_TOKEN('AGREEMENT',l_agreement_in_rec.pm_agreement_reference);
1904: FND_MESSAGE.SET_TOKEN('FUNDING',l_funding_in_rec.pm_funding_reference);
1905: FND_MSG_PUB.ADD;
1906: END IF;
1899: p_return_status := FND_API.G_RET_STS_ERROR;
1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1901: THEN
1902: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1903: FND_MESSAGE.SET_TOKEN('AGREEMENT',l_agreement_in_rec.pm_agreement_reference);
1904: FND_MESSAGE.SET_TOKEN('FUNDING',l_funding_in_rec.pm_funding_reference);
1905: FND_MSG_PUB.ADD;
1906: END IF;
1907:
1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1901: THEN
1902: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_P_AMG');
1903: FND_MESSAGE.SET_TOKEN('AGREEMENT',l_agreement_in_rec.pm_agreement_reference);
1904: FND_MESSAGE.SET_TOKEN('FUNDING',l_funding_in_rec.pm_funding_reference);
1905: FND_MSG_PUB.ADD;
1906: END IF;
1907:
1908: FND_MSG_PUB.Count_And_Get
2987: ROLLBACK TO delete_funding_pub;
2988: p_return_status := FND_API.G_RET_STS_ERROR;
2989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2990: THEN
2991: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
2992: FND_MESSAGE.SET_TOKEN('FUNDING',p_pm_funding_reference);
2993: FND_MSG_PUB.ADD;
2994: END IF;
2995: FND_MSG_PUB.Count_And_Get
2988: p_return_status := FND_API.G_RET_STS_ERROR;
2989: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2990: THEN
2991: FND_MESSAGE.SET_NAME('PA','PA_ROW_ALREADY_LOCKED_T_AMG');
2992: FND_MESSAGE.SET_TOKEN('FUNDING',p_pm_funding_reference);
2993: FND_MSG_PUB.ADD;
2994: END IF;
2995: FND_MSG_PUB.Count_And_Get
2996: ( p_count => p_msg_count ,