DBA Data[Home] [Help]

APPS.OE_OE_INLINE_ADDRESS dependencies on FND_API

Line 809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

805: ,x_msg_data => l_msg_data
806: ,x_location_id => x_location_id
807: );
808:
809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;

Line 810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

806: ,x_location_id => x_location_id
807: );
808:
809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;
814:

Line 811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

807: );
808:
809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;
814:
815: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 812: RAISE FND_API.G_EXC_ERROR;

808:
809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;
814:
815: x_return_status := FND_API.G_RET_STS_SUCCESS;
816:

Line 815: x_return_status := FND_API.G_RET_STS_SUCCESS;

811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
812: RAISE FND_API.G_EXC_ERROR;
813: END IF;
814:
815: x_return_status := FND_API.G_RET_STS_SUCCESS;
816:
817: -- Get message count and data
818:
819: OE_MSG_PUB.Count_And_Get

Line 828: WHEN FND_API.G_EXC_ERROR THEN

824: oe_debug_pub.add('Exiting oe_oe_inline_address.create_location', 1);
825:
826: EXCEPTION
827:
828: WHEN FND_API.G_EXC_ERROR THEN
829:
830:
831: IF l_debug_level > 0 THEN
832: oe_debug_pub.add( 'INSIDE CREATE_LOCATION EXC ERROR' , 1 ) ;

Line 834: x_return_status := FND_API.G_RET_STS_ERROR;

830:
831: IF l_debug_level > 0 THEN
832: oe_debug_pub.add( 'INSIDE CREATE_LOCATION EXC ERROR' , 1 ) ;
833: END IF;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: OE_MSG_PUB.Count_And_Get
836: ( p_count => x_msg_count
837: , p_data => x_msg_data
838: );

Line 847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

843: ( p_count => x_msg_count
844: , p_data => x_msg_data
845: );
846:
847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
848:
849:
850: IF l_debug_level > 0 THEN
851: oe_debug_pub.add( 'INSIDE CREATE_LOCATION UNEXPECTED ERROR' , 1 ) ;

Line 853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

849:
850: IF l_debug_level > 0 THEN
851: oe_debug_pub.add( 'INSIDE CREATE_LOCATION UNEXPECTED ERROR' , 1 ) ;
852: END IF;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
854: OE_MSG_PUB.Count_And_Get
855: ( p_count => x_msg_count
856: , p_data => x_msg_data
857: );

Line 872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

868:
869: IF l_debug_level > 0 THEN
870: oe_debug_pub.add( 'INSIDE CREATE_LOCATION WHEN OTHERS' , 1 ) ;
871: END IF;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
873: OE_MSG_PUB.Count_And_Get
874: ( p_count => x_msg_count
875: , p_data => x_msg_data
876: );

Line 958: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

954: return;
955: ELSIF
956: x_msg_count > 1 THEN
957: FOR x IN 1..x_msg_count LOOP
958: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
959: tmp_var1 := tmp_var1 || ' ' || tmp_var;
960: END LOOP;
961: x_msg_data := tmp_var1;
962: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';

Line 966: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

962: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';
963: return;
964: END IF;
965:
966: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;

Line 967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

963: return;
964: END IF;
965:
966: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:

Line 968: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

964: END IF;
965:
966: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:
972: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 969: RAISE FND_API.G_EXC_ERROR;

965:
966: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973:

Line 972: x_return_status := FND_API.G_RET_STS_SUCCESS;

968: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974: -- Get message count and data
975:
976: OE_MSG_PUB.Count_And_Get

Line 984: WHEN FND_API.G_EXC_ERROR THEN

980:
981:
982: EXCEPTION
983:
984: WHEN FND_API.G_EXC_ERROR THEN
985:
986:
987: x_return_status := FND_API.G_RET_STS_ERROR;
988:

Line 987: x_return_status := FND_API.G_RET_STS_ERROR;

983:
984: WHEN FND_API.G_EXC_ERROR THEN
985:
986:
987: x_return_status := FND_API.G_RET_STS_ERROR;
988:
989: -- Get message count and data
990:
991: OE_MSG_PUB.Count_And_Get

Line 996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

992: ( p_count => x_msg_count
993: , p_data => x_msg_data
994: );
995:
996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
997:
998:
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1000:

Line 999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

995:
996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
997:
998:
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1000:
1001: -- Get message count and data
1002:
1003: OE_MSG_PUB.Count_And_Get

Line 1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1007:
1008: WHEN OTHERS THEN
1009:
1010:
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1012:
1013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1014: THEN
1015: OE_MSG_PUB.Add_Exc_Msg

Line 1125: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

1121: return;
1122: ELSIF
1123: x_msg_count > 1 THEN
1124: FOR x IN 1..x_msg_count LOOP
1125: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1126: tmp_var1 := tmp_var1 || ' ' || tmp_var;
1127: END LOOP;
1128: x_msg_data := tmp_var1;
1129: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';

Line 1133: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1129: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';
1130: return;
1131: END IF;
1132:
1133: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1130: return;
1131: END IF;
1132:
1133: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138:

Line 1135: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1131: END IF;
1132:
1133: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138:
1139: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1136: RAISE FND_API.G_EXC_ERROR;

1132:
1133: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138:
1139: x_return_status := FND_API.G_RET_STS_SUCCESS;
1140:

Line 1139: x_return_status := FND_API.G_RET_STS_SUCCESS;

1135: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138:
1139: x_return_status := FND_API.G_RET_STS_SUCCESS;
1140:
1141: -- Get message count and data
1142:
1143: OE_MSG_PUB.Count_And_Get

Line 1151: WHEN FND_API.G_EXC_ERROR THEN

1147:
1148:
1149: EXCEPTION
1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152:
1153:
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155:

Line 1154: x_return_status := FND_API.G_RET_STS_ERROR;

1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152:
1153:
1154: x_return_status := FND_API.G_RET_STS_ERROR;
1155:
1156: -- Get message count and data
1157:
1158: OE_MSG_PUB.Count_And_Get

Line 1163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1159: ( p_count => x_msg_count
1160: , p_data => x_msg_data
1161: );
1162:
1163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1164:
1165:
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1167:

Line 1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1162:
1163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1164:
1165:
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1167:
1168: -- Get message count and data
1169:
1170: OE_MSG_PUB.Count_And_Get

Line 1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1174:
1175: WHEN OTHERS THEN
1176:
1177:
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1179:
1180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1181: THEN
1182: OE_MSG_PUB.Add_Exc_Msg

Line 1297: p_create_profile => FND_API.G_FALSE,

1293: HZ_CUST_ACCOUNT_SITE_V2PUB.Create_Cust_Site_Use
1294: (
1295: p_cust_site_use_rec => l_acct_site_uses,
1296: p_customer_profile_rec => l_cust_profile_rec,
1297: p_create_profile => FND_API.G_FALSE,
1298: x_return_status => x_return_status,
1299: x_msg_count => x_msg_count,
1300: x_msg_data => x_msg_data,
1301: x_site_use_id => x_site_use_id