DBA Data[Home] [Help]

APPS.OE_OE_INLINE_ADDRESS dependencies on FND_API

Line 832: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

828: ,x_msg_data => l_msg_data
829: ,x_location_id => x_location_id
830: );
831:
832: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;

Line 833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

829: ,x_location_id => x_location_id
830: );
831:
832: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:

Line 834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

830: );
831:
832: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:
838: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 835: RAISE FND_API.G_EXC_ERROR;

831:
832: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
833: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:
838: x_return_status := FND_API.G_RET_STS_SUCCESS;
839:

Line 838: x_return_status := FND_API.G_RET_STS_SUCCESS;

834: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:
838: x_return_status := FND_API.G_RET_STS_SUCCESS;
839:
840: -- Get message count and data
841:
842: OE_MSG_PUB.Count_And_Get

Line 851: WHEN FND_API.G_EXC_ERROR THEN

847: oe_debug_pub.add('Exiting oe_oe_inline_address.create_location', 1);
848:
849: EXCEPTION
850:
851: WHEN FND_API.G_EXC_ERROR THEN
852:
853:
854: IF l_debug_level > 0 THEN
855: oe_debug_pub.add( 'INSIDE CREATE_LOCATION EXC ERROR' , 1 ) ;

Line 857: x_return_status := FND_API.G_RET_STS_ERROR;

853:
854: IF l_debug_level > 0 THEN
855: oe_debug_pub.add( 'INSIDE CREATE_LOCATION EXC ERROR' , 1 ) ;
856: END IF;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: OE_MSG_PUB.Count_And_Get
859: ( p_count => x_msg_count
860: , p_data => x_msg_data
861: );

Line 870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

866: ( p_count => x_msg_count
867: , p_data => x_msg_data
868: );
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871:
872:
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add( 'INSIDE CREATE_LOCATION UNEXPECTED ERROR' , 1 ) ;

Line 876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

872:
873: IF l_debug_level > 0 THEN
874: oe_debug_pub.add( 'INSIDE CREATE_LOCATION UNEXPECTED ERROR' , 1 ) ;
875: END IF;
876: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
877: OE_MSG_PUB.Count_And_Get
878: ( p_count => x_msg_count
879: , p_data => x_msg_data
880: );

Line 895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

891:
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add( 'INSIDE CREATE_LOCATION WHEN OTHERS' , 1 ) ;
894: END IF;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
896: OE_MSG_PUB.Count_And_Get
897: ( p_count => x_msg_count
898: , p_data => x_msg_data
899: );

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

984: return;
985: ELSIF
986: x_msg_count > 1 THEN
987: FOR x IN 1..x_msg_count LOOP
988: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
989: tmp_var1 := tmp_var1 || ' ' || tmp_var;
990: END LOOP;
991: x_msg_data := tmp_var1;
992: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';

Line 996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

992: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';
993: return;
994: END IF;
995:
996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;

Line 997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

993: return;
994: END IF;
995:
996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:

Line 998: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

994: END IF;
995:
996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 999: RAISE FND_API.G_EXC_ERROR;

995:
996: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: x_return_status := FND_API.G_RET_STS_SUCCESS;
1003:

Line 1002: x_return_status := FND_API.G_RET_STS_SUCCESS;

998: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: x_return_status := FND_API.G_RET_STS_SUCCESS;
1003:
1004: -- Get message count and data
1005:
1006: OE_MSG_PUB.Count_And_Get

Line 1014: WHEN FND_API.G_EXC_ERROR THEN

1010:
1011:
1012: EXCEPTION
1013:
1014: WHEN FND_API.G_EXC_ERROR THEN
1015:
1016:
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018:

Line 1017: x_return_status := FND_API.G_RET_STS_ERROR;

1013:
1014: WHEN FND_API.G_EXC_ERROR THEN
1015:
1016:
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018:
1019: -- Get message count and data
1020:
1021: OE_MSG_PUB.Count_And_Get

Line 1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1022: ( p_count => x_msg_count
1023: , p_data => x_msg_data
1024: );
1025:
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027:
1028:
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030:

Line 1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1025:
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027:
1028:
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030:
1031: -- Get message count and data
1032:
1033: OE_MSG_PUB.Count_And_Get

Line 1041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1037:
1038: WHEN OTHERS THEN
1039:
1040:
1041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1042:
1043: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1044: THEN
1045: OE_MSG_PUB.Add_Exc_Msg

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

1155: return;
1156: ELSIF
1157: x_msg_count > 1 THEN
1158: FOR x IN 1..x_msg_count LOOP
1159: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
1160: tmp_var1 := tmp_var1 || ' ' || tmp_var;
1161: END LOOP;
1162: x_msg_data := tmp_var1;
1163: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';

Line 1167: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1163: --x_msg_data := x_msg_data || '**CREATE_PARTY_SITE**';
1164: return;
1165: END IF;
1166:
1167: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;

Line 1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1164: return;
1165: END IF;
1166:
1167: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172:

Line 1169: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1165: END IF;
1166:
1167: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172:
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1170: RAISE FND_API.G_EXC_ERROR;

1166:
1167: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172:
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;
1174:

Line 1173: x_return_status := FND_API.G_RET_STS_SUCCESS;

1169: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172:
1173: x_return_status := FND_API.G_RET_STS_SUCCESS;
1174:
1175: -- Get message count and data
1176:
1177: OE_MSG_PUB.Count_And_Get

Line 1185: WHEN FND_API.G_EXC_ERROR THEN

1181:
1182:
1183: EXCEPTION
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186:
1187:
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189:

Line 1188: x_return_status := FND_API.G_RET_STS_ERROR;

1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186:
1187:
1188: x_return_status := FND_API.G_RET_STS_ERROR;
1189:
1190: -- Get message count and data
1191:
1192: OE_MSG_PUB.Count_And_Get

Line 1197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1193: ( p_count => x_msg_count
1194: , p_data => x_msg_data
1195: );
1196:
1197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1198:
1199:
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1201:

Line 1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1196:
1197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1198:
1199:
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1201:
1202: -- Get message count and data
1203:
1204: OE_MSG_PUB.Count_And_Get

Line 1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1208:
1209: WHEN OTHERS THEN
1210:
1211:
1212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1213:
1214: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1215: THEN
1216: OE_MSG_PUB.Add_Exc_Msg

Line 1331: p_create_profile => FND_API.G_FALSE,

1327: HZ_CUST_ACCOUNT_SITE_V2PUB.Create_Cust_Site_Use
1328: (
1329: p_cust_site_use_rec => l_acct_site_uses,
1330: p_customer_profile_rec => l_cust_profile_rec,
1331: p_create_profile => FND_API.G_FALSE,
1332: x_return_status => x_return_status,
1333: x_msg_count => x_msg_count,
1334: x_msg_data => x_msg_data,
1335: x_site_use_id => x_site_use_id