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_MSG_PUB

Line 76: fnd_msg_pub.add;

72: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
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;

Line 127: fnd_msg_pub.add;

123:
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

Line 208: fnd_msg_pub.add;

204: -- because a geography_type can not be parent of the same geography_type.
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);

Line 359: FND_MSG_PUB.ADD;

355:
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:

Line 392: fnd_msg_pub.add;

388:
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:

Line 405: fnd_msg_pub.add;

401:
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:

Line 429: FND_MSG_PUB.ADD;

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;
431: END;
432: ELSE
433: x_return_status := FND_API.G_RET_STS_ERROR;

Line 436: FND_MSG_PUB.ADD;

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;
438: END IF;
439: END IF;
440: END IF;

Line 450: FND_MSG_PUB.ADD;

446: 'GEOGRAPHY_ELEMENT6','GEOGRAPHY_ELEMENT7','GEOGRAPHY_ELEMENT8','GEOGRAPHY_ELEMENT9','GEOGRAPHY_ELEMENT10')
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:

Line 510: fnd_msg_pub.add;

506: IF l_count > 0 THEN
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:

Line 540: fnd_msg_pub.add;

536: EXCEPTION
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:

Line 621: FND_MSG_PUB.ADD;

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' );
621: FND_MSG_PUB.ADD;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: END IF;
624: END IF;
625:

Line 644: fnd_msg_pub.add;

640:
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:

Line 659: fnd_msg_pub.add;

655: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
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: