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_GEOGRAPHY_VALIDATE_PVT dependencies on FND_MSG_PUB

Line 76: fnd_msg_pub.add;

72:
73: IF l_count = 0 THEN
74: fnd_message.set_name('AR', 'HZ_GEO_STRUCT_UNDEFINED');
75: fnd_message.set_token('GEO_ID', l_geography_id);
76: fnd_msg_pub.add;
77: x_return_status := fnd_api.g_ret_sts_error;
78: END IF;
79:
80: -- check whether geography_type and parent_geography_type are as per the country structure

Line 103: fnd_msg_pub.add;

99: fnd_message.set_name('AR', 'HZ_GEO_INVALID_COMBINATION');
100: fnd_message.set_token('COUNTRY', p_country_code);
101: fnd_message.set_token('PARENT_GEO', p_parent_geography_type);
102: fnd_message.set_token('CHILD_GEO', p_geography_type);
103: fnd_msg_pub.add;
104: x_return_status := fnd_api.g_ret_sts_error;
105: END;
106: END validate_structure;
107:

Line 152: fnd_msg_pub.add;

148: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
149: fnd_message.set_token('FK','geography_id');
150: fnd_message.set_token('COLUMN', 'geography_id');
151: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');
152: fnd_msg_pub.add;
153: x_return_status := fnd_api.g_ret_sts_error;
154: END get_geography_type;
155:
156:

Line 265: fnd_msg_pub.add;

261: IF l_country_code IS NULL THEN
262: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
263: fnd_message.set_token('TOKEN1', 'country_code');
264: fnd_message.set_token('TOKEN2', 'geography_id '||p_master_relation_rec.parent_geography_id);
265: fnd_msg_pub.add;
266: x_return_status := fnd_api.g_ret_sts_error;
267:
268: END IF;
269:

Line 304: fnd_msg_pub.add;

300:
301: IF l_count > 0 THEN
302: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
303: fnd_message.set_token('COLUMN', 'geography_id');
304: fnd_msg_pub.add;
305: x_return_status := fnd_api.g_ret_sts_error;
306: END IF;
307: END IF;
308:

Line 380: FND_MSG_PUB.ADD;

376: IF (p_geo_identifier_rec.identifier_subtype <> 'STANDARD_NAME') THEN
377: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
378: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );
379: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'HZ_GEO_IDENTIFIER_SUBTYPE' );
380: FND_MSG_PUB.ADD;
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: END IF;
383: -- this will not be called as only NAME and CODE are valid identifier type
384: -- but keeping it as 'catch all' condition to validate what is passed in

Line 414: fnd_msg_pub.add;

410: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
411: fnd_message.set_token('FK','language_code');
412: fnd_message.set_token('COLUMN', 'language_code');
413: fnd_message.set_token('TABLE','FND_LANGUAGES');
414: fnd_msg_pub.add;
415: x_return_status := fnd_api.g_ret_sts_error;
416: END IF;
417: END IF;
418: END IF;

Line 434: fnd_msg_pub.add;

430:
431: IF l_count > 0 THEN
432: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
433: fnd_message.set_token('COLUMN', 'geography_id,identifier_type,identifier_subtype,identifier_value,language_code');
434: fnd_msg_pub.add;
435: x_return_status := fnd_api.g_ret_sts_error;
436: END IF;
437: END IF; */
438:

Line 469: fnd_msg_pub.add;

465:
466: IF l_count > 0 THEN
467: fnd_message.set_name('AR', 'HZ_API_DUPLICATE_COLUMN');
468: fnd_message.set_token('COLUMN', 'identifier_value within the identifier_type NAME and language code '||p_geo_identifier_rec.language_code);
469: fnd_msg_pub.add;
470: x_return_status := fnd_api.g_ret_sts_error;
471: END IF;
472: END IF;
473: END IF;

Line 492: FND_MSG_PUB.ADD;

488: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
489: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id '||p_geo_identifier_rec.geography_id||',identifier_type '||p_geo_identifier_rec.identifier_type||
490: ', identifier_subtype '||p_geo_identifier_rec.identifier_subtype||', identifier_value '||p_geo_identifier_rec.identifier_value||
491: ', language_code '||p_geo_identifier_rec.language_code);
492: FND_MSG_PUB.ADD;
493: x_return_status := fnd_api.g_ret_sts_error;
494: END IF;
495: END IF;
496:

Line 603: FND_MSG_PUB.ADD;

599: -- geography_code_type is mandatory if geography_code is NOT NULL
600: IF (p_master_geography_rec.geography_code IS NOT NULL AND p_master_geography_rec.geography_code_type IS NULL) THEN
601: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
602: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_code_type' );
603: FND_MSG_PUB.ADD;
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: END IF;
606:
607:

Line 622: fnd_msg_pub.add;

618: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
619: fnd_message.set_token('FK', 'timezone_code');
620: fnd_message.set_token('COLUMN','timezone_code');
621: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
622: fnd_msg_pub.add;
623: x_return_status := fnd_api.g_ret_sts_error;
624: END IF;
625: END IF;
626:

Line 638: fnd_msg_pub.add;

634: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
635: fnd_message.set_token('FK', 'language_code');
636: fnd_message.set_token('COLUMN','language_code');
637: fnd_message.set_token('TABLE','FND_LANGUAGES');
638: fnd_msg_pub.add;
639: x_return_status := fnd_api.g_ret_sts_error;
640: END IF;
641: END IF;
642:

Line 653: fnd_msg_pub.add;

649:
650: IF l_count > 0 THEN
651: fnd_message.set_name('AR', 'HZ_GEO_DUPLICATE_GEOG_CODE');
652: fnd_message.set_token('COUNTRY_CODE', p_master_geography_rec.geography_code);
653: fnd_msg_pub.add;
654: x_return_status := fnd_api.g_ret_sts_error;
655: END IF;
656: END IF;
657:

Line 681: fnd_msg_pub.add;

677: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
678: fnd_message.set_token('FK','territory_code');
679: fnd_message.set_token('COLUMN', 'geography_code');
680: fnd_message.set_token('TABLE','FND_TERRITORIES');
681: fnd_msg_pub.add;
682: x_return_status := fnd_api.g_ret_sts_error;
683: END IF;
684: END IF;
685:

Line 693: fnd_msg_pub.add;

689:
690: IF l_parent_geography_tbl.count = 0 THEN
691: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
692: fnd_message.set_token('COLUMN', 'parent_geography_id');
693: fnd_msg_pub.add;
694: x_return_status := fnd_api.g_ret_sts_error;
695: END IF;
696: END IF;
697:

Line 831: fnd_msg_pub.add;

827: BEGIN
828: -- geography_to must be greater than or equal to geography_from
829: IF to_number(p_geography_range_rec.geography_from) > to_number(p_geography_range_rec.geography_to) THEN
830: fnd_message.set_name('AR', 'HZ_GEO_INVALID_RANGE');
831: fnd_msg_pub.add;
832: x_return_status := fnd_api.g_ret_sts_error;
833: END IF;
834: EXCEPTION WHEN VALUE_ERROR THEN
835: -- geography_to must be greater than or equal to geography_from

Line 838: fnd_msg_pub.add;

834: EXCEPTION WHEN VALUE_ERROR THEN
835: -- geography_to must be greater than or equal to geography_from
836: IF p_geography_range_rec.geography_from > p_geography_range_rec.geography_to THEN
837: fnd_message.set_name('AR', 'HZ_GEO_INVALID_RANGE');
838: fnd_msg_pub.add;
839: x_return_status := fnd_api.g_ret_sts_error;
840: END IF;
841: END;
842:

Line 856: fnd_msg_pub.add;

852: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
853: fnd_message.set_token('FK','geography_id');
854: fnd_message.set_token('COLUMN', 'zone_id');
855: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');
856: fnd_msg_pub.add;
857: x_return_status := fnd_api.g_ret_sts_error;
858: END;
859:
860: --validate master_ref_geography_id

Line 876: fnd_msg_pub.add;

872: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
873: fnd_message.set_token('FK','geography_id');
874: fnd_message.set_token('COLUMN', 'master_ref_geography_id');
875: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');
876: fnd_msg_pub.add;
877: x_return_status := fnd_api.g_ret_sts_error;
878: END;
879: END IF;
880:

Line 945: fnd_msg_pub.add;

941: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
942: fnd_message.set_token('FK', 'geography_id');
943: fnd_message.set_token('COLUMN','geography_id');
944: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');
945: fnd_msg_pub.add;
946: x_return_status := fnd_api.g_ret_sts_error;
947: END IF;
948:
949: --validate included_geography_id

Line 958: fnd_msg_pub.add;

954: IF l_count = 0 THEN
955: fnd_message.set_name('AR', 'HZ_GEO_INVALID_VALUE');
956: fnd_message.set_token('VALUE',p_zone_relation_rec.included_geography_id);
957: fnd_message.set_token('COLUMN', 'included_geography_id');
958: fnd_msg_pub.add;
959: x_return_status := fnd_api.g_ret_sts_error;
960: END IF;
961: END validate_zone_relation;
962: