DBA Data[Home] [Help]

APPS.IGS_GR_VENUE_ADDR_PKG dependencies on FND_API

Line 68: p_init_msg_list => FND_API.G_TRUE,

64:
65:
66: /* Hz_Location_Pub.CREATE_LOCATION(
67: p_api_version => 1.0,
68: p_init_msg_list => FND_API.G_TRUE,
69: p_location_rec => p_location_rec_insert,
70: x_return_status => l_return_status,
71: x_msg_count => l_msg_count,
72: x_msg_data=> l_msg_data,

Line 78: p_init_msg_list => FND_API.G_FALSE,

74: ); */
75:
76:
77: HZ_LOCATION_V2PUB.create_location(
78: p_init_msg_list => FND_API.G_FALSE,
79: p_location_rec => p_location_rec_insert,
80: x_location_id => l_location_id ,
81: x_return_status => l_return_status,
82: x_msg_count => l_msg_count,

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

87: IF l_return_status IN ('E', 'U') THEN
88:
89: IF l_msg_count > 1 THEN
90: FOR i IN 1..l_msg_count LOOP
91: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
92: tmp_var1 := tmp_var1 || ' '|| tmp_var;
93: END LOOP;
94: x_msg_data := tmp_var1;
95: END IF;

Line 101: p_lock_flag =>FND_API.G_FALSE,

97: ELSIF l_return_status = 'S' THEN
98:
99: HZ_TAX_ASSIGNMENT_V2PUB.CREATE_LOC_ASSIGNMENT(
100: p_location_id => l_location_id,
101: p_lock_flag =>FND_API.G_FALSE,
102: p_created_by_module => 'IGS',
103: x_return_status =>l_return_status,
104: x_msg_count => l_msg_count,
105: x_msg_data =>l_msg_data,

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

111:
112: IF l_return_status IN ('E', 'U') THEN
113: IF l_msg_count > 1 THEN
114: FOR i IN 1..l_msg_count LOOP
115: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
116: tmp_var1 := tmp_var1 || ' '|| tmp_var;
117: END LOOP;
118: x_msg_data := tmp_var1;
119: END IF;

Line 202: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);

198:
199: BEGIN
200: p_location_rec_update.location_id := x_location_id;
201: p_location_rec_update.country := x_country;
202: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
203: p_location_rec_update.address1 := x_addr_line_1;
204: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
205: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
206: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);

Line 204: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);

200: p_location_rec_update.location_id := x_location_id;
201: p_location_rec_update.country := x_country;
202: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
203: p_location_rec_update.address1 := x_addr_line_1;
204: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
205: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
206: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
207: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);

Line 205: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);

201: p_location_rec_update.country := x_country;
202: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
203: p_location_rec_update.address1 := x_addr_line_1;
204: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
205: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
206: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
207: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);

Line 206: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);

202: p_location_rec_update.address_style := NVL(x_address_style,FND_API.G_MISS_CHAR);
203: p_location_rec_update.address1 := x_addr_line_1;
204: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
205: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
206: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
207: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);

Line 207: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);

203: p_location_rec_update.address1 := x_addr_line_1;
204: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
205: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
206: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
207: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
211: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);

Line 208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);

204: p_location_rec_update.address2 := NVL(x_addr_line_2,FND_API.G_MISS_CHAR);
205: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
206: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
207: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
211: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
212: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);

Line 209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);

205: p_location_rec_update.address3 := NVL(x_addr_line_3,FND_API.G_MISS_CHAR);
206: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
207: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
211: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
212: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
213: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);

Line 210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);

206: p_location_rec_update.address4 := NVL(x_addr_line_4,FND_API.G_MISS_CHAR);
207: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
211: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
212: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
213: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
214: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);

Line 211: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);

207: p_location_rec_update.city := NVL(x_city,FND_API.G_MISS_CHAR);
208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
211: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
212: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
213: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
214: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
215:

Line 212: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);

208: p_location_rec_update.state := NVL(x_state,FND_API.G_MISS_CHAR);
209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
211: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
212: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
213: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
214: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
215:
216: OPEN c_loc;

Line 213: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);

209: p_location_rec_update.province := NVL(x_province,FND_API.G_MISS_CHAR);
210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
211: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
212: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
213: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
214: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
215:
216: OPEN c_loc;
217: FETCH c_loc INTO loc_rec;

Line 214: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);

210: p_location_rec_update.county := NVL(x_county,FND_API.G_MISS_CHAR);
211: p_location_rec_update.postal_code := NVL(x_postal_code,FND_API.G_MISS_CHAR);
212: p_location_rec_update.address_lines_phonetic := NVL(x_address_lines_phonetic,FND_API.G_MISS_CHAR);
213: p_location_rec_update.address_effective_date := NVL(x_start_dt,FND_API.G_MISS_DATE);
214: p_location_rec_update.address_expiration_date := NVL(x_end_dt,FND_API.G_MISS_DATE);
215:
216: OPEN c_loc;
217: FETCH c_loc INTO loc_rec;
218: CLOSE c_loc;

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

228: IF l_return_status IN ('E', 'U') THEN
229:
230: IF l_msg_count > 1 THEN
231: FOR i IN 1..l_msg_count LOOP
232: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
233: tmp_var1 := tmp_var1 || ' '|| tmp_var;
234: END LOOP;
235: x_msg_data := tmp_var1;
236: END IF;

Line 242: p_lock_flag =>FND_API.G_FALSE,

238: ELSIF l_return_status = 'S' THEN
239:
240: HZ_TAX_ASSIGNMENT_V2PUB.UPDATE_LOC_ASSIGNMENT(
241: p_location_id => l_location_id,
242: p_lock_flag =>FND_API.G_FALSE,
243: p_created_by_module => 'IGS',
244: x_return_status =>l_return_status,
245: x_msg_count => l_msg_count,
246: x_msg_data => l_msg_data,

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

252: IF l_return_status IN ('E', 'U') THEN
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;