eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_GEO_UI_UTIL_PUB dependencies on FND_API

Line 182: IF FND_API.to_Boolean(p_init_msg_list) THEN

178: del_all_usg boolean := true;
179:
180: BEGIN
181: -- Initialize message list if p_init_msg_list is set to TRUE.
182: IF FND_API.to_Boolean(p_init_msg_list) THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185:
186: -- Initialize API return status to success.

Line 187: x_return_status := FND_API.G_RET_STS_SUCCESS;

183: FND_MSG_PUB.initialize;
184: END IF;
185:
186: -- Initialize API return status to success.
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188:
189: -- set gnr regenration message to N initially
190: x_show_gnr := 'N';
191: l_show_gnr := 'N';

Line 249: p_init_msg_list => FND_API.G_FALSE,

245: if(l_address_usage_dtls_tbl.count > 0)
246: then
247: hz_address_usages_pub.create_address_usages(p_address_usages_rec => l_address_usages_rec,
248: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
249: p_init_msg_list => FND_API.G_FALSE,
250: x_usage_id => l_tax_id_ret,
251: x_return_status => l_return_status,
252: x_msg_count => l_msg_count,
253: x_msg_data => l_msg_data);

Line 257: RAISE FND_API.G_EXC_ERROR ;

253: x_msg_data => l_msg_data);
254:
255: if(l_return_status <> 'S')
256: then
257: RAISE FND_API.G_EXC_ERROR ;
258: end if;
259: if(nvl(l_show_gnr, 'N') = 'Y')
260: then
261: x_show_gnr := 'Y';

Line 291: p_init_msg_list => FND_API.G_FALSE,

287: hz_address_usages_pub.create_address_usage_dtls(
288: p_usage_id => l_tax_usage_id,
289: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
290: x_usage_dtl_id => l_tax_id_ret,
291: p_init_msg_list => FND_API.G_FALSE,
292: x_return_status => l_return_status,
293: x_msg_count => l_msg_count,
294: x_msg_data => l_msg_data);
295: if(l_return_status <> 'S')

Line 297: RAISE FND_API.G_EXC_ERROR ;

293: x_msg_count => l_msg_count,
294: x_msg_data => l_msg_data);
295: if(l_return_status <> 'S')
296: then
297: RAISE FND_API.G_EXC_ERROR ;
298: end if;
299:
300: if(nvl(l_show_gnr, 'N') = 'Y')
301: then

Line 334: p_init_msg_list => FND_API.G_FALSE,

330: if del_usg = true and (del_all_usg = false or l <> p_tax_tbl.last)
331: then
332: hz_address_usages_pub.delete_address_usages(p_usage_id => l_tax_usage_id,
333: p_address_usage_dtls_tbl => l_address_usage_dtls_del_tbl,
334: p_init_msg_list => FND_API.G_FALSE,
335: x_return_status => l_return_status,
336: x_msg_count => l_msg_count,
337: x_msg_data => l_msg_data);
338: if(nvl(l_show_gnr, 'N') = 'Y')

Line 348: p_init_msg_list => FND_API.G_FALSE,

344: then
345: l_address_usage_dtls_del_tbl.delete;
346: hz_address_usages_pub.delete_address_usages(p_usage_id => l_tax_usage_id,
347: p_address_usage_dtls_tbl => l_address_usage_dtls_del_tbl,
348: p_init_msg_list => FND_API.G_FALSE,
349: x_return_status => l_return_status,
350: x_msg_count => l_msg_count,
351: x_msg_data => l_msg_data);
352:

Line 362: RAISE FND_API.G_EXC_ERROR ;

358: end if;
359:
360: if(l_return_status <> 'S')
361: then
362: RAISE FND_API.G_EXC_ERROR ;
363: end if;
364:
365: end if; -- end of p_tax_tbl.count > 0 check
366:

Line 404: p_init_msg_list => FND_API.G_FALSE,

400: if(l_address_usage_dtls_tbl.count > 0)
401: then
402: hz_address_usages_pub.create_address_usages(p_address_usages_rec => l_address_usages_rec,
403: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
404: p_init_msg_list => FND_API.G_FALSE,
405: x_usage_id => l_geo_id_ret,
406: x_return_status => l_return_status,
407: x_msg_count => l_msg_count,
408: x_msg_data => l_msg_data);

Line 411: RAISE FND_API.G_EXC_ERROR ;

407: x_msg_count => l_msg_count,
408: x_msg_data => l_msg_data);
409: if(l_return_status <> 'S')
410: then
411: RAISE FND_API.G_EXC_ERROR ;
412: end if;
413: if(nvl(l_show_gnr, 'N') = 'Y')
414: then
415: x_show_gnr := 'Y';

Line 444: p_init_msg_list => FND_API.G_FALSE,

440: hz_address_usages_pub.create_address_usage_dtls(
441: p_usage_id => l_geo_usage_id,
442: p_address_usage_dtls_tbl => l_address_usage_dtls_tbl,
443: x_usage_dtl_id => l_geo_id_ret,
444: p_init_msg_list => FND_API.G_FALSE,
445: x_return_status => l_return_status,
446: x_msg_count => l_msg_count,
447: x_msg_data => l_msg_data);
448: if(l_return_status <> 'S')

Line 450: RAISE FND_API.G_EXC_ERROR ;

446: x_msg_count => l_msg_count,
447: x_msg_data => l_msg_data);
448: if(l_return_status <> 'S')
449: then
450: RAISE FND_API.G_EXC_ERROR ;
451: end if;
452:
453: if(nvl(l_show_gnr, 'N') = 'Y')
454: then

Line 486: p_init_msg_list => FND_API.G_FALSE,

482: if del_usg = true and (del_all_usg = false or l <> p_geo_tbl.last)
483: then
484: hz_address_usages_pub.delete_address_usages(p_usage_id => l_geo_usage_id,
485: p_address_usage_dtls_tbl => l_address_usage_dtls_del_tbl,
486: p_init_msg_list => FND_API.G_FALSE,
487: x_return_status => l_return_status,
488: x_msg_count => l_msg_count,
489: x_msg_data => l_msg_data);
490: if(nvl(l_show_gnr, 'N') = 'Y')

Line 500: p_init_msg_list => FND_API.G_FALSE,

496: then
497: l_address_usage_dtls_del_tbl.delete;
498: hz_address_usages_pub.delete_address_usages(p_usage_id => l_geo_usage_id,
499: p_address_usage_dtls_tbl => l_address_usage_dtls_del_tbl,
500: p_init_msg_list => FND_API.G_FALSE,
501: x_return_status => l_return_status,
502: x_msg_count => l_msg_count,
503: x_msg_data => l_msg_data);
504: if(nvl(l_show_gnr, 'N') = 'Y')

Line 511: RAISE FND_API.G_EXC_ERROR ;

507: end if;
508: end if;
509: if(l_return_status <> 'S')
510: then
511: RAISE FND_API.G_EXC_ERROR ;
512: end if;
513: end if; -- end of p_tax_tbl.count > 0 check
514: END IF; -- END OF CHECK FOR p_usage_tbl.COUNT > 0
515:

Line 518: WHEN FND_API.G_EXC_ERROR THEN

514: END IF; -- END OF CHECK FOR p_usage_tbl.COUNT > 0
515:
516:
517: EXCEPTION
518: WHEN FND_API.G_EXC_ERROR THEN
519:
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: FND_MSG_PUB.Count_And_Get(
522: p_encoded => FND_API.G_FALSE,

Line 520: x_return_status := FND_API.G_RET_STS_ERROR;

516:
517: EXCEPTION
518: WHEN FND_API.G_EXC_ERROR THEN
519:
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: FND_MSG_PUB.Count_And_Get(
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data);

Line 522: p_encoded => FND_API.G_FALSE,

518: WHEN FND_API.G_EXC_ERROR THEN
519:
520: x_return_status := FND_API.G_RET_STS_ERROR;
521: FND_MSG_PUB.Count_And_Get(
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data);
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526:

Line 525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

521: FND_MSG_PUB.Count_And_Get(
522: p_encoded => FND_API.G_FALSE,
523: p_count => x_msg_count,
524: p_data => x_msg_data);
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526:
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: FND_MSG_PUB.Count_And_Get(
529: p_encoded => FND_API.G_FALSE,

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

523: p_count => x_msg_count,
524: p_data => x_msg_data);
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526:
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: FND_MSG_PUB.Count_And_Get(
529: p_encoded => FND_API.G_FALSE,
530: p_count => x_msg_count,
531: p_data => x_msg_data);

Line 529: p_encoded => FND_API.G_FALSE,

525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526:
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: FND_MSG_PUB.Count_And_Get(
529: p_encoded => FND_API.G_FALSE,
530: p_count => x_msg_count,
531: p_data => x_msg_data);
532:
533: WHEN OTHERS THEN

Line 535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

531: p_data => x_msg_data);
532:
533: WHEN OTHERS THEN
534:
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
538: FND_MSG_PUB.ADD;
539: FND_MSG_PUB.Count_And_Get(

Line 540: p_encoded => FND_API.G_FALSE,

536: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
537: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
538: FND_MSG_PUB.ADD;
539: FND_MSG_PUB.Count_And_Get(
540: p_encoded => FND_API.G_FALSE,
541: p_count => x_msg_count,
542: p_data => x_msg_data);
543: END update_map_usages;
544: