87: p_location_rec_insert.created_by_module := 'IGS';
88: p_location_rec_insert.application_id := 8405;
89:
90: HZ_LOCATION_V2PUB.create_location (
91: P_INIT_MSG_LIST => FND_API.G_TRUE,
92: P_LOCATION_REC => p_location_rec_insert,
93: P_DO_ADDR_VAL => 'Y',
94: X_LOCATION_ID => l_location_id,
95: x_addr_val_status => l_addr_val_status,
105: -- bug 2338473 logic to display more than one error modified.
106: x_msg_data := l_msg_data;
107: IF l_msg_count > 1 THEN
108: FOR i IN 1..l_msg_count LOOP
109: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
110: tmp_var1 := tmp_var1 || ' '|| tmp_var;
111: END LOOP;
112: x_msg_data := tmp_var1;
113: END IF;
217:
218:
219: p_location_rec_update.location_id := x_location_id;
220: p_location_rec_update.country := x_country;
221: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
222: p_location_rec_update.address1 := NVL(x_addr_line_1,FND_API.G_MISS_CHAR);
223: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
224: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
225: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
218:
219: p_location_rec_update.location_id := x_location_id;
220: p_location_rec_update.country := x_country;
221: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
222: p_location_rec_update.address1 := NVL(x_addr_line_1,FND_API.G_MISS_CHAR);
223: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
224: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
225: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
226: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
219: p_location_rec_update.location_id := x_location_id;
220: p_location_rec_update.country := x_country;
221: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
222: p_location_rec_update.address1 := NVL(x_addr_line_1,FND_API.G_MISS_CHAR);
223: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
224: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
225: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
226: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
227: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
220: p_location_rec_update.country := x_country;
221: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
222: p_location_rec_update.address1 := NVL(x_addr_line_1,FND_API.G_MISS_CHAR);
223: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
224: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
225: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
226: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
227: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
228: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
221: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
222: p_location_rec_update.address1 := NVL(x_addr_line_1,FND_API.G_MISS_CHAR);
223: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
224: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
225: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
226: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
227: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
228: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
229: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
222: p_location_rec_update.address1 := NVL(x_addr_line_1,FND_API.G_MISS_CHAR);
223: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
224: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
225: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
226: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
227: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
228: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
229: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
230: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
223: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
224: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
225: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
226: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
227: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
228: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
229: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
230: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
231:
224: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
225: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
226: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
227: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
228: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
229: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
230: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
231:
232: p_location_rec_update.delivery_point_code := NVL(x_delivery_point_code,FND_API.G_MISS_CHAR);
225: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
226: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
227: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
228: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
229: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
230: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
231:
232: p_location_rec_update.delivery_point_code := NVL(x_delivery_point_code,FND_API.G_MISS_CHAR);
233:
226: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
227: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
228: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
229: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
230: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
231:
232: p_location_rec_update.delivery_point_code := NVL(x_delivery_point_code,FND_API.G_MISS_CHAR);
233:
234: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
228: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
229: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
230: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
231:
232: p_location_rec_update.delivery_point_code := NVL(x_delivery_point_code,FND_API.G_MISS_CHAR);
233:
234: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
235: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
236: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
230: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
231:
232: p_location_rec_update.delivery_point_code := NVL(x_delivery_point_code,FND_API.G_MISS_CHAR);
233:
234: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
235: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
236: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
237:
238: HZ_LOCATION_V2PUB.update_location(
231:
232: p_location_rec_update.delivery_point_code := NVL(x_delivery_point_code,FND_API.G_MISS_CHAR);
233:
234: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
235: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
236: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
237:
238: HZ_LOCATION_V2PUB.update_location(
239: P_INIT_MSG_LIST => FND_API.G_TRUE,
232: p_location_rec_update.delivery_point_code := NVL(x_delivery_point_code,FND_API.G_MISS_CHAR);
233:
234: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
235: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
236: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
237:
238: HZ_LOCATION_V2PUB.update_location(
239: P_INIT_MSG_LIST => FND_API.G_TRUE,
240: P_LOCATION_REC => p_location_rec_update,
235: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
236: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
237:
238: HZ_LOCATION_V2PUB.update_location(
239: P_INIT_MSG_LIST => FND_API.G_TRUE,
240: P_LOCATION_REC => p_location_rec_update,
241: p_do_addr_val => 'Y',
242: p_object_version_number => x_object_version_number,
243: x_addr_val_status => l_addr_val_status,
252: x_msg_data := l_msg_data;
253:
254: IF l_msg_count > 1 THEN
255: FOR i IN 1..l_msg_count LOOP
256: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
257: tmp_var1 := tmp_var1 || ' '|| tmp_var;
258: END LOOP;
259: x_msg_data := tmp_var1;
260: END IF;