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_MESSAGE

Line 72: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

68: WHERE GEOGRAPHY_TYPE = UPPER(p_geography_type)
69: AND GEOGRAPHY_USE = decode(p_master_ref_flag,'Y','MASTER_REF',GEOGRAPHY_USE);
70:
71: IF l_count = 0 THEN
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;

Line 73: fnd_message.set_token('FK', 'geography_type');

69: AND GEOGRAPHY_USE = decode(p_master_ref_flag,'Y','MASTER_REF',GEOGRAPHY_USE);
70:
71: IF l_count = 0 THEN
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;

Line 74: fnd_message.set_token('COLUMN', 'geography_type');

70:
71: IF l_count = 0 THEN
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;

Line 75: fnd_message.set_token('TABLE', 'hz_geography_types_b');

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

Line 124: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');

120: AND GEOGRAPHY_USE = decode(p_master_ref_flag,'Y','MASTER_REF',GEOGRAPHY_USE);
121:
122: IF l_count = 0 THEN
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;

Line 125: fnd_message.set_token('TOKEN1', 'geography');

121:
122: IF l_count = 0 THEN
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;

Line 126: fnd_message.set_token('TOKEN2', 'geography_id '||p_geography_id);

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

Line 207: fnd_message.set_name('AR', 'HZ_GEO_DUPL_GEO_TYPE');

203: -- check if geography_type and parent_geography_type are same . If yes , raise error
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;

Line 357: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_TYPE' );

353: FROM HZ_GEOGRAPHIES
354: WHERE geography_id = p_geo_structure_rec.geography_id;
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;

Line 358: FND_MESSAGE.SET_TOKEN( 'GEO_ID', p_geo_structure_rec.geography_id);

354: WHERE geography_id = p_geo_structure_rec.geography_id;
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;

Line 390: fnd_message.set_name('AR', 'HZ_GEO_TYPE_EXISTS_IN_STRUCT');

386: WHERE geography_id = p_geo_structure_rec.geography_id
387: AND geography_type = p_geo_structure_rec.geography_type;
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;

Line 391: fnd_message.set_token('P_GEO_TYPE', p_geo_structure_rec.geography_type);

387: AND geography_type = p_geo_structure_rec.geography_type;
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;

Line 403: fnd_message.set_name('AR', 'HZ_GEO_PTYPE_EXISTS_IN_STRUCT');

399: WHERE geography_id = p_geo_structure_rec.geography_id
400: AND parent_geography_type = p_geo_structure_rec.parent_geography_type;
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;

Line 404: fnd_message.set_token('P_PGEO_TYPE', p_geo_structure_rec.parent_geography_type);

400: AND parent_geography_type = p_geo_structure_rec.parent_geography_type;
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;

Line 427: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_VAL_LEVEL');

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;
431: END;

Line 434: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_VAL_LEVEL_INVALID_GEO');

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

Line 448: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_ELEMENT_COL_INVALID');

444: /* IF UPPER(p_geo_structure_rec.geography_element_column) NOT IN (
445: 'GEOGRAPHY_ELEMENT2','GEOGRAPHY_ELEMENT3','GEOGRAPHY_ELEMENT4','GEOGRAPHY_ELEMENT5',
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;*/

Line 449: FND_MESSAGE.SET_TOKEN( 'GEO_ID', p_geo_structure_rec.geography_id);

445: 'GEOGRAPHY_ELEMENT2','GEOGRAPHY_ELEMENT3','GEOGRAPHY_ELEMENT4','GEOGRAPHY_ELEMENT5',
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:

Line 508: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

504: AND BACKWARD_REL_CODE = 'CHILD_OF';
505:
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:

Line 509: fnd_message.set_token('COLUMN', 'geography_type');

505:
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;

Line 538: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

534: WHERE RELATIONSHIP_TYPE_ID = p_relationship_type_id;
535:
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;

Line 539: fnd_message.set_token('COLUMN', 'relationship_type_id');

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

Line 619: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

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

Line 620: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'included_geography_type' );

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

Line 642: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');

638: FROM hz_geography_types_b
639: WHERE geography_type=p_zone_type_rec.geography_type;
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;

Line 643: fnd_message.set_token('COLUMN', 'geography_type');

639: WHERE geography_type=p_zone_type_rec.geography_type;
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;

Line 655: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

651: FROM hz_geographies
652: WHERE geography_id = p_zone_type_rec.limited_by_geography_id;
653:
654: IF l_count = 0 THEN
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;

Line 656: fnd_message.set_token('FK', 'limited_by_geography_id');

652: WHERE geography_id = p_zone_type_rec.limited_by_geography_id;
653:
654: IF l_count = 0 THEN
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;

Line 657: fnd_message.set_token('COLUMN','limited_by_geography_id');

653:
654: IF l_count = 0 THEN
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;

Line 658: fnd_message.set_token('TABLE','hz_geographies');

654: IF l_count = 0 THEN
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;