APPS.OE_ITORD_UTIL dependencies on FND_API

Line 104: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 121: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then

117: p_region_id => l_region_id_tbl(i),
118: x_zone_tab => Region_Loc_zone_tab,
119: x_return_status => l_return_status);
120:
121: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
122: IF l_debug_level > 0 then
123: oe_debug_pub.add('Unexpected error in WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches');
124: END IF;
125:

Line 673: x_return_status := FND_API.G_RET_STS_SUCCESS;

669: )
670: IS
671: BEGIN
672:
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: INSERT INTO OE_ITEM_ORDERABILITY
676: (
677: orderability_id,

Line 708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

704:
705: EXCEPTION
706: WHEN OTHERS
707: THEN
708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
709:
710: OE_MSG_PUB.Add_Exc_Msg
711: (
712: G_PKG_NAME

Line 725: x_return_status := FND_API.G_RET_STS_SUCCESS;

721: )
722: IS
723: BEGIN
724:
725: x_return_status := FND_API.G_RET_STS_SUCCESS;
726:
727: UPDATE OE_ITEM_ORDERABILITY
728: SET item_level = p_item_orderability_rec.item_level,
729: item_category_id = p_item_orderability_rec.item_category_id,

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

740:
741: EXCEPTION
742: WHEN OTHERS
743: THEN
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745:
746: OE_MSG_PUB.Add_Exc_Msg
747: (
748: G_PKG_NAME

Line 763: x_return_status := FND_API.G_RET_STS_SUCCESS;

759: )
760: IS
761: BEGIN
762:
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: INSERT INTO OE_ITEM_ORDERABILITY_RULES
766: (
767: ORDERABILITY_ID,

Line 853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

849: ) returning rowid into x_rowid ;
850: EXCEPTION
851: WHEN OTHERS
852: THEN
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854:
855: OE_MSG_PUB.Add_Exc_Msg
856: (
857: G_PKG_NAME

Line 871: x_return_status := FND_API.G_RET_STS_SUCCESS;

867: )
868: IS
869: BEGIN
870:
871: x_return_status := FND_API.G_RET_STS_SUCCESS;
872:
873: UPDATE OE_ITEM_ORDERABILITY_RULES
874: SET RULE_LEVEL = p_item_orderability_rules_rec.RULE_LEVEL,
875: CUSTOMER_ID = p_item_orderability_rules_rec.CUSTOMER_ID,

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

915:
916: EXCEPTION
917: WHEN OTHERS
918: THEN
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920:
921: OE_MSG_PUB.Add_Exc_Msg
922: (
923: G_PKG_NAME