APPS.OE_ITORD_UTIL dependencies on FND_API

Line 101: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

97: p_lang_code => USERENV('LANG'),
98: x_region_tab => l_region_id_tbl,
99: x_return_status => l_return_status );
100:
101: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
102: IF l_debug_level > 0 then
103: oe_debug_pub.add('Unexpected error in WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');
104: END IF;
105:

Line 642: x_return_status := FND_API.G_RET_STS_SUCCESS;

638: )
639: IS
640: BEGIN
641:
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643:
644: INSERT INTO OE_ITEM_ORDERABILITY
645: (
646: orderability_id,

Line 677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

673:
674: EXCEPTION
675: WHEN OTHERS
676: THEN
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
678:
679: OE_MSG_PUB.Add_Exc_Msg
680: (
681: G_PKG_NAME

Line 694: x_return_status := FND_API.G_RET_STS_SUCCESS;

690: )
691: IS
692: BEGIN
693:
694: x_return_status := FND_API.G_RET_STS_SUCCESS;
695:
696: UPDATE OE_ITEM_ORDERABILITY
697: SET item_level = p_item_orderability_rec.item_level,
698: item_category_id = p_item_orderability_rec.item_category_id,

Line 713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

709:
710: EXCEPTION
711: WHEN OTHERS
712: THEN
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714:
715: OE_MSG_PUB.Add_Exc_Msg
716: (
717: G_PKG_NAME

Line 732: x_return_status := FND_API.G_RET_STS_SUCCESS;

728: )
729: IS
730: BEGIN
731:
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: INSERT INTO OE_ITEM_ORDERABILITY_RULES
735: (
736: ORDERABILITY_ID,

Line 822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

818: ) returning rowid into x_rowid ;
819: EXCEPTION
820: WHEN OTHERS
821: THEN
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823:
824: OE_MSG_PUB.Add_Exc_Msg
825: (
826: G_PKG_NAME

Line 840: x_return_status := FND_API.G_RET_STS_SUCCESS;

836: )
837: IS
838: BEGIN
839:
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: UPDATE OE_ITEM_ORDERABILITY_RULES
843: SET RULE_LEVEL = p_item_orderability_rules_rec.RULE_LEVEL,
844: CUSTOMER_ID = p_item_orderability_rules_rec.CUSTOMER_ID,

Line 888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

884:
885: EXCEPTION
886: WHEN OTHERS
887: THEN
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
889:
890: OE_MSG_PUB.Add_Exc_Msg
891: (
892: G_PKG_NAME