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
820: ( p_count => x_msg_count
821: , p_data => x_msg_data
822: );
823:
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: );
839:
838: );
839:
840: -- Get message count and data
841:
842: OE_MSG_PUB.Count_And_Get
843: ( p_count => x_msg_count
844: , p_data => x_msg_data
845: );
846:
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: );
858:
857: );
858:
859: -- Get message count and data
860:
861: OE_MSG_PUB.Count_And_Get
862: ( p_count => x_msg_count
863: , p_data => x_msg_data
864: );
865:
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: );
877:
874: ( p_count => x_msg_count
875: , p_data => x_msg_data
876: );
877:
878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: OE_MSG_PUB.Add_Exc_Msg
881: ( G_PKG_NAME
882: , 'Create_Location'
876: );
877:
878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
879: THEN
880: OE_MSG_PUB.Add_Exc_Msg
881: ( G_PKG_NAME
882: , 'Create_Location'
883: );
884: END IF;
884: END IF;
885:
886: -- Get message count and data
887:
888: OE_MSG_PUB.Count_And_Get
889: ( p_count => x_msg_count
890: , p_data => x_msg_data
891: );
892:
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
977: ( p_count => x_msg_count
978: , p_data => x_msg_data
979: );
980:
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
992: ( p_count => x_msg_count
993: , p_data => x_msg_data
994: );
995:
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
1004: ( p_count => x_msg_count
1005: , p_data => x_msg_data
1006: );
1007:
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
1016: ( G_PKG_NAME
1017: , 'Create_Location'
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
1016: ( G_PKG_NAME
1017: , 'Create_Location'
1018: );
1019: END IF;
1019: END IF;
1020:
1021: -- Get message count and data
1022:
1023: OE_MSG_PUB.Count_And_Get
1024: ( p_count => x_msg_count
1025: , p_data => x_msg_data
1026: );
1027:
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
1144: ( p_count => x_msg_count
1145: , p_data => x_msg_data
1146: );
1147:
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
1159: ( p_count => x_msg_count
1160: , p_data => x_msg_data
1161: );
1162:
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
1171: ( p_count => x_msg_count
1172: , p_data => x_msg_data
1173: );
1174:
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
1183: ( G_PKG_NAME
1184: , 'Create_Location'
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
1183: ( G_PKG_NAME
1184: , 'Create_Location'
1185: );
1186: END IF;
1186: END IF;
1187:
1188: -- Get message count and data
1189:
1190: OE_MSG_PUB.Count_And_Get
1191: ( p_count => x_msg_count
1192: , p_data => x_msg_data
1193: );
1194: END Create_Account_Site;
1862:
1863:
1864: BEGIN
1865:
1866: oe_msg_pub.initialize;
1867: savepoint add_customer;
1868: l_cust_number := in_cust_number;
1869:
1870: IF in_cust_account_id is null then
1941:
1942:
1943: if x_return_status in ('E','U') then
1944:
1945: /* OE_MSG_PUB.Count_And_Get
1946: ( p_count => x_msg_count
1947: , p_data => x_msg_data
1948: );
1949: */