246: IF PG_DEBUG <> 0 THEN
247: oe_debug_pub.add ('first_wo_reservation_created: ' || 'first_wo_reservation_created others exception: '||sqlerrm,1);
248: END IF;
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
252: END IF;
253: CTO_MSG_PUB.Count_And_Get(
254: p_msg_count => x_msg_count,
247: oe_debug_pub.add ('first_wo_reservation_created: ' || 'first_wo_reservation_created others exception: '||sqlerrm,1);
248: END IF;
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
251: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
252: END IF;
253: CTO_MSG_PUB.Count_And_Get(
254: p_msg_count => x_msg_count,
255: p_msg_data => x_msg_data
412: IF PG_DEBUG <> 0 THEN
413: oe_debug_pub.add ('last_wo_reservation_deleted: ' || 'last_wo_reservation_deleted raised others exception: '||sqlerrm,1);
414: END IF;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
417: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
418: END IF;
419: CTO_MSG_PUB.Count_And_Get(
420: p_msg_count => x_msg_count,
413: oe_debug_pub.add ('last_wo_reservation_deleted: ' || 'last_wo_reservation_deleted raised others exception: '||sqlerrm,1);
414: END IF;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
417: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
418: END IF;
419: CTO_MSG_PUB.Count_And_Get(
420: p_msg_count => x_msg_count,
421: p_msg_data => x_msg_data
535: IF PG_DEBUG <> 0 THEN
536: oe_debug_pub.add ('flow_creation: ' || 'flow_creation raised others exception: '||sqlerrm,1);
537: END IF;
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
540: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
541: END IF;
542: CTO_MSG_PUB.Count_And_Get(
543: p_msg_count => x_msg_count,
536: oe_debug_pub.add ('flow_creation: ' || 'flow_creation raised others exception: '||sqlerrm,1);
537: END IF;
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
540: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
541: END IF;
542: CTO_MSG_PUB.Count_And_Get(
543: p_msg_count => x_msg_count,
544: p_msg_data => x_msg_data
694: IF PG_DEBUG <> 0 THEN
695: oe_debug_pub.add ('flow_deletion: ' || 'flow_deletion raised others exception:'||sqlerrm,1);
696: END IF;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
699: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
700: END IF;
701: CTO_MSG_PUB.Count_And_Get(
702: p_msg_count => x_msg_count,
695: oe_debug_pub.add ('flow_deletion: ' || 'flow_deletion raised others exception:'||sqlerrm,1);
696: END IF;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
699: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
700: END IF;
701: CTO_MSG_PUB.Count_And_Get(
702: p_msg_count => x_msg_count,
703: p_msg_data => x_msg_data