DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_ADDR_PKG dependencies on FND_API

Line 39: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;

35: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
36: p_status IN hz_party_sites.status%TYPE
37: ) AS
38:
39: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;
40: p_lock_flag VARCHAR2(30) := FND_API.G_FALSE;
41: l_contact_person VARCHAR2(40) := NULL;
42: l_msg_count NUMBER(15);
43: l_loc_id NUMBER(15);

Line 40: p_lock_flag VARCHAR2(30) := FND_API.G_FALSE;

36: p_status IN hz_party_sites.status%TYPE
37: ) AS
38:
39: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;
40: p_lock_flag VARCHAR2(30) := FND_API.G_FALSE;
41: l_contact_person VARCHAR2(40) := NULL;
42: l_msg_count NUMBER(15);
43: l_loc_id NUMBER(15);
44: lv_rowid VARCHAR2(25);

Line 126: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

122:
123: IF l_msg_count > 1 THEN
124: FOR i IN 1..l_msg_count
125: LOOP
126: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
127: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
128: END LOOP;
129: l_msg_data := l_tmp_var1;
130: END IF;

Line 171: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

167: --ssawhney added this code corresponding to IF condition as part of #2338473
168: IF l_msg_count > 1 THEN
169: FOR i IN 1..l_msg_count
170: LOOP
171: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
172: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
173: END LOOP;
174: l_msg_data := l_tmp_var1;
175: END IF;

Line 232: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;

228: p_location_ovn IN OUT NOCOPY hz_party_sites.object_version_number%TYPE,
229: p_status IN hz_party_sites.status%TYPE
230: )
231: AS
232: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;
233: p_lock_flag VARCHAR2(30) := FND_API.G_FALSE;
234: l_contact_person VARCHAR2(40) := NULL;
235: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
236: l_msg_count NUMBER(15);

Line 233: p_lock_flag VARCHAR2(30) := FND_API.G_FALSE;

229: p_status IN hz_party_sites.status%TYPE
230: )
231: AS
232: p_init_msg_list VARCHAR2(30) := FND_API.G_TRUE;
233: p_lock_flag VARCHAR2(30) := FND_API.G_FALSE;
234: l_contact_person VARCHAR2(40) := NULL;
235: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
236: l_msg_count NUMBER(15);
237: l_loc_id NUMBER(15);

Line 288: p_location_rec_update.address_style := NVL(p_address_style,FND_API.G_MISS_CHAR);

284: END IF;
285:
286: p_location_rec_update.location_id := p_location_id;
287: p_location_rec_update.country := p_country;
288: p_location_rec_update.address_style := NVL(p_address_style,FND_API.G_MISS_CHAR);
289: p_location_rec_update.address1 := NVL(p_addr_line_1,FND_API.G_MISS_CHAR);
290: p_location_rec_update.address2 := NVL(p_addr_line_2,FND_API.G_MISS_CHAR);
291: p_location_rec_update.address3 := NVL(p_addr_line_3,FND_API.G_MISS_CHAR);
292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);

Line 289: p_location_rec_update.address1 := NVL(p_addr_line_1,FND_API.G_MISS_CHAR);

285:
286: p_location_rec_update.location_id := p_location_id;
287: p_location_rec_update.country := p_country;
288: p_location_rec_update.address_style := NVL(p_address_style,FND_API.G_MISS_CHAR);
289: p_location_rec_update.address1 := NVL(p_addr_line_1,FND_API.G_MISS_CHAR);
290: p_location_rec_update.address2 := NVL(p_addr_line_2,FND_API.G_MISS_CHAR);
291: p_location_rec_update.address3 := NVL(p_addr_line_3,FND_API.G_MISS_CHAR);
292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);
293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);

Line 290: p_location_rec_update.address2 := NVL(p_addr_line_2,FND_API.G_MISS_CHAR);

286: p_location_rec_update.location_id := p_location_id;
287: p_location_rec_update.country := p_country;
288: p_location_rec_update.address_style := NVL(p_address_style,FND_API.G_MISS_CHAR);
289: p_location_rec_update.address1 := NVL(p_addr_line_1,FND_API.G_MISS_CHAR);
290: p_location_rec_update.address2 := NVL(p_addr_line_2,FND_API.G_MISS_CHAR);
291: p_location_rec_update.address3 := NVL(p_addr_line_3,FND_API.G_MISS_CHAR);
292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);
293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);
294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);

Line 291: p_location_rec_update.address3 := NVL(p_addr_line_3,FND_API.G_MISS_CHAR);

287: p_location_rec_update.country := p_country;
288: p_location_rec_update.address_style := NVL(p_address_style,FND_API.G_MISS_CHAR);
289: p_location_rec_update.address1 := NVL(p_addr_line_1,FND_API.G_MISS_CHAR);
290: p_location_rec_update.address2 := NVL(p_addr_line_2,FND_API.G_MISS_CHAR);
291: p_location_rec_update.address3 := NVL(p_addr_line_3,FND_API.G_MISS_CHAR);
292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);
293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);
294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);
295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);

Line 292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);

288: p_location_rec_update.address_style := NVL(p_address_style,FND_API.G_MISS_CHAR);
289: p_location_rec_update.address1 := NVL(p_addr_line_1,FND_API.G_MISS_CHAR);
290: p_location_rec_update.address2 := NVL(p_addr_line_2,FND_API.G_MISS_CHAR);
291: p_location_rec_update.address3 := NVL(p_addr_line_3,FND_API.G_MISS_CHAR);
292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);
293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);
294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);
295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);
296: p_location_rec_update.county := NVL(p_county,FND_API.G_MISS_CHAR);

Line 293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);

289: p_location_rec_update.address1 := NVL(p_addr_line_1,FND_API.G_MISS_CHAR);
290: p_location_rec_update.address2 := NVL(p_addr_line_2,FND_API.G_MISS_CHAR);
291: p_location_rec_update.address3 := NVL(p_addr_line_3,FND_API.G_MISS_CHAR);
292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);
293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);
294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);
295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);
296: p_location_rec_update.county := NVL(p_county,FND_API.G_MISS_CHAR);
297: p_location_rec_update.postal_code := NVL(p_postal_code,FND_API.G_MISS_CHAR);

Line 294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);

290: p_location_rec_update.address2 := NVL(p_addr_line_2,FND_API.G_MISS_CHAR);
291: p_location_rec_update.address3 := NVL(p_addr_line_3,FND_API.G_MISS_CHAR);
292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);
293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);
294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);
295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);
296: p_location_rec_update.county := NVL(p_county,FND_API.G_MISS_CHAR);
297: p_location_rec_update.postal_code := NVL(p_postal_code,FND_API.G_MISS_CHAR);
298: p_location_rec_update.address_lines_phonetic := NVL(p_address_lines_phonetic,FND_API.G_MISS_CHAR);

Line 295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);

291: p_location_rec_update.address3 := NVL(p_addr_line_3,FND_API.G_MISS_CHAR);
292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);
293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);
294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);
295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);
296: p_location_rec_update.county := NVL(p_county,FND_API.G_MISS_CHAR);
297: p_location_rec_update.postal_code := NVL(p_postal_code,FND_API.G_MISS_CHAR);
298: p_location_rec_update.address_lines_phonetic := NVL(p_address_lines_phonetic,FND_API.G_MISS_CHAR);
299: p_location_rec_update.delivery_point_code := NVL(p_delivery_point_code,FND_API.G_MISS_CHAR);

Line 296: p_location_rec_update.county := NVL(p_county,FND_API.G_MISS_CHAR);

292: p_location_rec_update.address4 := NVL(p_addr_line_4,FND_API.G_MISS_CHAR);
293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);
294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);
295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);
296: p_location_rec_update.county := NVL(p_county,FND_API.G_MISS_CHAR);
297: p_location_rec_update.postal_code := NVL(p_postal_code,FND_API.G_MISS_CHAR);
298: p_location_rec_update.address_lines_phonetic := NVL(p_address_lines_phonetic,FND_API.G_MISS_CHAR);
299: p_location_rec_update.delivery_point_code := NVL(p_delivery_point_code,FND_API.G_MISS_CHAR);
300: P_PARTY_SITE_REC_update.PARTY_ID := p_party_id;

Line 297: p_location_rec_update.postal_code := NVL(p_postal_code,FND_API.G_MISS_CHAR);

293: p_location_rec_update.city := NVL(p_city,FND_API.G_MISS_CHAR);
294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);
295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);
296: p_location_rec_update.county := NVL(p_county,FND_API.G_MISS_CHAR);
297: p_location_rec_update.postal_code := NVL(p_postal_code,FND_API.G_MISS_CHAR);
298: p_location_rec_update.address_lines_phonetic := NVL(p_address_lines_phonetic,FND_API.G_MISS_CHAR);
299: p_location_rec_update.delivery_point_code := NVL(p_delivery_point_code,FND_API.G_MISS_CHAR);
300: P_PARTY_SITE_REC_update.PARTY_ID := p_party_id;
301: P_PARTY_SITE_REC_update.PARTY_SITE_ID := p_party_site_id;

Line 298: p_location_rec_update.address_lines_phonetic := NVL(p_address_lines_phonetic,FND_API.G_MISS_CHAR);

294: p_location_rec_update.state := NVL(p_state,FND_API.G_MISS_CHAR);
295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);
296: p_location_rec_update.county := NVL(p_county,FND_API.G_MISS_CHAR);
297: p_location_rec_update.postal_code := NVL(p_postal_code,FND_API.G_MISS_CHAR);
298: p_location_rec_update.address_lines_phonetic := NVL(p_address_lines_phonetic,FND_API.G_MISS_CHAR);
299: p_location_rec_update.delivery_point_code := NVL(p_delivery_point_code,FND_API.G_MISS_CHAR);
300: P_PARTY_SITE_REC_update.PARTY_ID := p_party_id;
301: P_PARTY_SITE_REC_update.PARTY_SITE_ID := p_party_site_id;
302: P_PARTY_SITE_REC_update.LOCATION_ID := p_location_id;

Line 299: p_location_rec_update.delivery_point_code := NVL(p_delivery_point_code,FND_API.G_MISS_CHAR);

295: p_location_rec_update.province := NVL(p_province,FND_API.G_MISS_CHAR);
296: p_location_rec_update.county := NVL(p_county,FND_API.G_MISS_CHAR);
297: p_location_rec_update.postal_code := NVL(p_postal_code,FND_API.G_MISS_CHAR);
298: p_location_rec_update.address_lines_phonetic := NVL(p_address_lines_phonetic,FND_API.G_MISS_CHAR);
299: p_location_rec_update.delivery_point_code := NVL(p_delivery_point_code,FND_API.G_MISS_CHAR);
300: P_PARTY_SITE_REC_update.PARTY_ID := p_party_id;
301: P_PARTY_SITE_REC_update.PARTY_SITE_ID := p_party_site_id;
302: P_PARTY_SITE_REC_update.LOCATION_ID := p_location_id;
303: P_PARTY_SITE_REC_update.IDENTIFYING_ADDRESS_FLAG := p_correspondence;

Line 322: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

318: --sbaliga added this code corresponding to IF condition as part of #2338473
319: IF l_msg_count > 1 THEN
320: FOR i IN 1..l_msg_count
321: LOOP
322: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
323: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
324: END LOOP;
325: l_msg_data := l_tmp_var1;
326: END IF;

Line 342: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

338: IF l_return_status ='E' or l_return_status ='U' THEN
339: --ssawhney added this code corresponding to IF condition as part of #2338473
340: IF l_msg_count > 1 THEN
341: FOR i IN 1..l_msg_count LOOP
342: l_tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
343: l_tmp_var1 := l_tmp_var1 || ' '|| l_tmp_var;
344: END LOOP;
345: l_msg_data := l_tmp_var1;
346: END IF;