APPS.HZ_POPULATE_TIMEZONE_PKG dependencies on FND_API

Line 151: x_return_status := FND_API.G_RET_STS_SUCCESS;

147:
148: BEGIN
149:
150: --Initialize API return status to success.
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152: x_timezone_id := null;
153:
154: if p_phone_country_code is null
155: then

Line 157: x_return_status := FND_API.G_RET_STS_ERROR;

153:
154: if p_phone_country_code is null
155: then
156: x_timezone_id := null;
157: x_return_status := FND_API.G_RET_STS_ERROR;
158: return;
159: else -- phone_country_code is not null
160: if p_area_code is not null
161: then

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

172:
173: if l_tz_count >1 -- need country code to be passed in
174: then
175: x_timezone_id := null;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: return;
178: elsif l_tz_count = 1
179: then
180: open get_area_code_tzone_csr;

Line 209: x_return_status := FND_API.G_RET_STS_ERROR;

205: close get_tz_by_pcc_cc_csr;
206: if x_timezone_id is null
207: then
208: x_timezone_id := null;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: return;
211: end if; -- x_timezone_id is null
212:
213: else

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211: end if; -- x_timezone_id is null
212:
213: else
214: x_timezone_id := null;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: return;
217: end if;
218: elsif l_count = 0
219: then

Line 221: x_return_status := FND_API.G_RET_STS_ERROR;

217: end if;
218: elsif l_count = 0
219: then
220: x_timezone_id := null;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: return;
223: end if; -- l_count = 1
224: end if; -- if timezone_id is null
225: end if;

Line 230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

226:
227: EXCEPTION
228:
229: WHEN OTHERS THEN
230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231:
232: /* FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
233: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
234: FND_MSG_PUB.ADD; */

Line 302: p_init_msg_list => FND_API.G_TRUE,

298: FOR i IN I_CONTACT_POINT_ID.FIRST..I_CONTACT_POINT_ID.LAST
299: LOOP
300: get_phone_timezone_id(
301: p_api_version => 1.0,
302: p_init_msg_list => FND_API.G_TRUE,
303: p_phone_country_code => I_PHONE_COUNTRY_CODE(i),
304: p_area_code => I_PHONE_AREA_CODE(i),
305: p_phone_prefix => null,
306: p_country_code => null,-- don't need to pass in this

Line 311: if l_return_status <> fnd_api.g_ret_sts_success

307: x_timezone_id => l_timezone_id,
308: x_return_status => l_return_status ,
309: x_msg_count =>l_msg_count ,
310: x_msg_data => l_msg_data);
311: if l_return_status <> fnd_api.g_ret_sts_success
312: then -- we don't raise error
313: l_timezone_id := null;
314: end if;
315:

Line 352: p_init_msg_list => FND_API.G_TRUE,

348: FOR i IN I_CONTACT_POINT_ID.FIRST..I_CONTACT_POINT_ID.LAST
349: LOOP
350: get_phone_timezone_id(
351: p_api_version => 1.0,
352: p_init_msg_list => FND_API.G_TRUE,
353: p_phone_country_code => I_PHONE_COUNTRY_CODE(i),
354: p_area_code => I_PHONE_AREA_CODE(i),
355: p_phone_prefix => null,
356: p_country_code => null,-- don't need to pass in this

Line 361: if l_return_status <> fnd_api.g_ret_sts_success

357: x_timezone_id => l_timezone_id,
358: x_return_status => l_return_status ,
359: x_msg_count =>l_msg_count ,
360: x_msg_data => l_msg_data);
361: if l_return_status <> fnd_api.g_ret_sts_success
362: then -- we don't raise error
363: l_timezone_id := null;
364: end if;
365:

Line 457: p_init_msg_list => FND_API.G_TRUE,

453: FOR i IN I_LOCATION_ID.FIRST..I_LOCATION_ID.LAST
454: LOOP
455: hz_timezone_pub.get_timezone_id(
456: p_api_version => 1.0,
457: p_init_msg_list => FND_API.G_TRUE,
458: p_postal_code => I_POSTAL_CODE(i),
459: p_city => I_CITY(i),
460: p_state => I_STATE(i),
461: p_country => I_COUNTRY(i),

Line 466: if l_return_status <> fnd_api.g_ret_sts_success

462: x_timezone_id => l_timezone_id,
463: x_return_status => l_return_status ,
464: x_msg_count =>l_msg_count ,
465: x_msg_data => l_msg_data);
466: if l_return_status <> fnd_api.g_ret_sts_success
467: then -- we don't raise error
468: l_timezone_id := null;
469: end if;
470:

Line 507: p_init_msg_list => FND_API.G_TRUE,

503: FOR i IN I_LOCATION_ID.FIRST..I_LOCATION_ID.LAST
504: LOOP
505: hz_timezone_pub.get_timezone_id(
506: p_api_version => 1.0,
507: p_init_msg_list => FND_API.G_TRUE,
508: p_postal_code => I_POSTAL_CODE(i),
509: p_city => I_CITY(i),
510: p_state => I_STATE(i),
511: p_country => I_COUNTRY(i),

Line 516: if l_return_status <> fnd_api.g_ret_sts_success

512: x_timezone_id => l_timezone_id,
513: x_return_status => l_return_status ,
514: x_msg_count =>l_msg_count ,
515: x_msg_data => l_msg_data);
516: if l_return_status <> fnd_api.g_ret_sts_success
517: then -- we don't raise error
518: l_timezone_id := null;
519: end if;
520: