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_STRUCTURE_VALIDATE_PVT dependencies on FND_API

Line 77: x_return_status := fnd_api.g_ret_sts_error;

73: fnd_message.set_token('FK', 'geography_type');
74: fnd_message.set_token('COLUMN', 'geography_type');
75: fnd_message.set_token('TABLE', 'hz_geography_types_b');
76: fnd_msg_pub.add;
77: x_return_status := fnd_api.g_ret_sts_error;
78: END IF;
79:
80: END validate_geography_type;
81:

Line 128: x_return_status := fnd_api.g_ret_sts_error;

124: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
125: fnd_message.set_token('TOKEN1', 'geography');
126: fnd_message.set_token('TOKEN2', 'geography_id '||p_geography_id);
127: fnd_msg_pub.add;
128: x_return_status := fnd_api.g_ret_sts_error;
129: END IF;
130:
131: EXCEPTION
132: WHEN NO_DATA_FOUND THEN

Line 159: -- be FND_API.G_RET_STS_SUCCESS (success),

155: -- p_geo_rel_type_rec geography relationship type record.
156: --
157: -- IN/OUT:
158: -- x_return_status Return status after the call. The status can
159: -- be FND_API.G_RET_STS_SUCCESS (success),
160: -- FND_API.G_RET_STS_ERROR (error),
161: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
162: --
163: -- NOTES

Line 160: -- FND_API.G_RET_STS_ERROR (error),

156: --
157: -- IN/OUT:
158: -- x_return_status Return status after the call. The status can
159: -- be FND_API.G_RET_STS_SUCCESS (success),
160: -- FND_API.G_RET_STS_ERROR (error),
161: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
162: --
163: -- NOTES
164: --

Line 161: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

157: -- IN/OUT:
158: -- x_return_status Return status after the call. The status can
159: -- be FND_API.G_RET_STS_SUCCESS (success),
160: -- FND_API.G_RET_STS_ERROR (error),
161: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
162: --
163: -- NOTES
164: --
165: -- MODIFICATION HISTORY

Line 209: x_return_status := fnd_api.g_ret_sts_error;

205: IF p_geo_rel_type_rec.geography_type = p_geo_rel_type_rec.parent_geography_type THEN
206:
207: fnd_message.set_name('AR', 'HZ_GEO_DUPL_GEO_TYPE');
208: fnd_msg_pub.add;
209: x_return_status := fnd_api.g_ret_sts_error;
210:
211: END IF;
212: --dbms_output.put_line('In validate after mandatory validation '||x_return_status);
213:

Line 275: -- be FND_API.G_RET_STS_SUCCESS (success),

271: -- p_geo_structure_rec geography structure type record.
272: --
273: -- IN/OUT:
274: -- x_return_status Return status after the call. The status can
275: -- be FND_API.G_RET_STS_SUCCESS (success),
276: -- FND_API.G_RET_STS_ERROR (error),
277: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
278: --
279: -- NOTES

Line 276: -- FND_API.G_RET_STS_ERROR (error),

272: --
273: -- IN/OUT:
274: -- x_return_status Return status after the call. The status can
275: -- be FND_API.G_RET_STS_SUCCESS (success),
276: -- FND_API.G_RET_STS_ERROR (error),
277: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
278: --
279: -- NOTES
280: --

Line 277: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

273: -- IN/OUT:
274: -- x_return_status Return status after the call. The status can
275: -- be FND_API.G_RET_STS_SUCCESS (success),
276: -- FND_API.G_RET_STS_ERROR (error),
277: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
278: --
279: -- NOTES
280: --
281: -- MODIFICATION HISTORY

Line 360: x_return_status := fnd_api.g_ret_sts_error;

356: IF l_geography_type <> 'COUNTRY' THEN
357: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_TYPE' );
358: FND_MESSAGE.SET_TOKEN( 'GEO_ID', p_geo_structure_rec.geography_id);
359: FND_MSG_PUB.ADD;
360: x_return_status := fnd_api.g_ret_sts_error;
361: END IF;
362: END IF;
363:
364: IF p_create_update_flag = 'C' THEN

Line 393: x_return_status := fnd_api.g_ret_sts_error;

389: IF l_geo_count > 0 THEN
390: fnd_message.set_name('AR', 'HZ_GEO_TYPE_EXISTS_IN_STRUCT');
391: fnd_message.set_token('P_GEO_TYPE', p_geo_structure_rec.geography_type);
392: fnd_msg_pub.add;
393: x_return_status := fnd_api.g_ret_sts_error;
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: SELECT count(*) INTO l_pgeo_count

Line 394: RAISE FND_API.G_EXC_ERROR;

390: fnd_message.set_name('AR', 'HZ_GEO_TYPE_EXISTS_IN_STRUCT');
391: fnd_message.set_token('P_GEO_TYPE', p_geo_structure_rec.geography_type);
392: fnd_msg_pub.add;
393: x_return_status := fnd_api.g_ret_sts_error;
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: SELECT count(*) INTO l_pgeo_count
398: FROM hz_geo_structure_levels

Line 406: x_return_status := fnd_api.g_ret_sts_error;

402: IF l_pgeo_count > 0 THEN
403: fnd_message.set_name('AR', 'HZ_GEO_PTYPE_EXISTS_IN_STRUCT');
404: fnd_message.set_token('P_PGEO_TYPE', p_geo_structure_rec.parent_geography_type);
405: fnd_msg_pub.add;
406: x_return_status := fnd_api.g_ret_sts_error;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409:
410: END;

Line 407: RAISE FND_API.G_EXC_ERROR;

403: fnd_message.set_name('AR', 'HZ_GEO_PTYPE_EXISTS_IN_STRUCT');
404: fnd_message.set_token('P_PGEO_TYPE', p_geo_structure_rec.parent_geography_type);
405: fnd_msg_pub.add;
406: x_return_status := fnd_api.g_ret_sts_error;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409:
410: END;
411: END IF;

Line 426: x_return_status := FND_API.G_RET_STS_ERROR;

422: FROM ar_lookups
423: WHERE lookup_type = 'HZ_ADDRESS_VALIDATION_LEVEL'
424: AND lookup_code = p_geo_structure_rec.addr_val_level;
425: EXCEPTION WHEN NO_DATA_FOUND THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_VAL_LEVEL');
428: -- The Address Validation Level is invalid. Please pass a valid Address Validation Level
429: FND_MSG_PUB.ADD;
430: RAISE FND_API.G_EXC_ERROR;

Line 430: RAISE FND_API.G_EXC_ERROR;

426: x_return_status := FND_API.G_RET_STS_ERROR;
427: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_VAL_LEVEL');
428: -- The Address Validation Level is invalid. Please pass a valid Address Validation Level
429: FND_MSG_PUB.ADD;
430: RAISE FND_API.G_EXC_ERROR;
431: END;
432: ELSE
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_VAL_LEVEL_INVALID_GEO');

Line 433: x_return_status := FND_API.G_RET_STS_ERROR;

429: FND_MSG_PUB.ADD;
430: RAISE FND_API.G_EXC_ERROR;
431: END;
432: ELSE
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_VAL_LEVEL_INVALID_GEO');
435: -- Address validation level can be set only for parent geography type, 'COUNTRY'
436: FND_MSG_PUB.ADD;
437: RAISE FND_API.G_EXC_ERROR;

Line 437: RAISE FND_API.G_EXC_ERROR;

433: x_return_status := FND_API.G_RET_STS_ERROR;
434: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_VAL_LEVEL_INVALID_GEO');
435: -- Address validation level can be set only for parent geography type, 'COUNTRY'
436: FND_MSG_PUB.ADD;
437: RAISE FND_API.G_EXC_ERROR;
438: END IF;
439: END IF;
440: END IF;
441:

Line 451: x_return_status := fnd_api.g_ret_sts_error;

447: THEN
448: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_ELEMENT_COL_INVALID');
449: FND_MESSAGE.SET_TOKEN( 'GEO_ID', p_geo_structure_rec.geography_id);
450: FND_MSG_PUB.ADD;
451: x_return_status := fnd_api.g_ret_sts_error;
452: END IF;*/
453:
454:
455: IF p_create_update_flag = 'U' THEN

Line 511: x_return_status := fnd_api.g_ret_sts_error;

507:
508: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
509: fnd_message.set_token('COLUMN', 'geography_type');
510: fnd_msg_pub.add;
511: x_return_status := fnd_api.g_ret_sts_error;
512:
513: END IF;
514:
515: EXCEPTION

Line 541: x_return_status := fnd_api.g_ret_sts_error;

537: WHEN NO_DATA_FOUND THEN
538: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
539: fnd_message.set_token('COLUMN', 'relationship_type_id');
540: fnd_msg_pub.add;
541: x_return_status := fnd_api.g_ret_sts_error;
542: END validate_relationship_type_id;
543:
544:
545: /**

Line 616: and p_zone_type_rec.limited_by_geography_id <> fnd_api.g_miss_num THEN

612: );
613:
614: IF p_create_update_flag = 'C' and
615: p_zone_type_rec.limited_by_geography_id is not null
616: and p_zone_type_rec.limited_by_geography_id <> fnd_api.g_miss_num THEN
617: -- check for the mandatory columnm included_geography_type
618: IF p_zone_type_rec.included_geography_type.count = 0 THEN
619: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
620: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'included_geography_type' );

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: IF p_zone_type_rec.included_geography_type.count = 0 THEN
619: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
620: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'included_geography_type' );
621: FND_MSG_PUB.ADD;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: END IF;
624: END IF;
625:
626:

Line 645: x_return_status := fnd_api.g_ret_sts_error;

641: IF l_count > 0 THEN
642: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
643: fnd_message.set_token('COLUMN', 'geography_type');
644: fnd_msg_pub.add;
645: x_return_status := fnd_api.g_ret_sts_error;
646: END IF;
647: END IF;
648:
649: IF (p_zone_type_rec.limited_by_geography_id IS NOT NULL AND p_zone_type_rec.limited_by_geography_id <> fnd_api.g_miss_num) THEN

Line 649: IF (p_zone_type_rec.limited_by_geography_id IS NOT NULL AND p_zone_type_rec.limited_by_geography_id <> fnd_api.g_miss_num) THEN

645: x_return_status := fnd_api.g_ret_sts_error;
646: END IF;
647: END IF;
648:
649: IF (p_zone_type_rec.limited_by_geography_id IS NOT NULL AND p_zone_type_rec.limited_by_geography_id <> fnd_api.g_miss_num) THEN
650: SELECT count(*) INTO l_count
651: FROM hz_geographies
652: WHERE geography_id = p_zone_type_rec.limited_by_geography_id;
653:

Line 660: x_return_status := fnd_api.g_ret_sts_error;

656: fnd_message.set_token('FK', 'limited_by_geography_id');
657: fnd_message.set_token('COLUMN','limited_by_geography_id');
658: fnd_message.set_token('TABLE','hz_geographies');
659: fnd_msg_pub.add;
660: x_return_status := fnd_api.g_ret_sts_error;
661: END IF;
662: END IF;
663:
664: