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_API

Line 77: x_return_status := fnd_api.g_ret_sts_error;

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
81: /*SELECT 1 into l_count

Line 104: x_return_status := fnd_api.g_ret_sts_error;

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:
108: /**

Line 153: x_return_status := fnd_api.g_ret_sts_error;

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:
157: /**

Line 214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

210: p_old_end_date => l_end_date,
211: x_return_status => x_return_status
212: );
213:
214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: END IF;

Line 215: RAISE FND_API.G_EXC_ERROR;

211: x_return_status => x_return_status
212: );
213:
214: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: END IF;
219:

Line 230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

226: p_master_ref_flag => 'Y',
227: x_return_status => x_return_status
228: );
229:
230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;
233:
234: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_id(

Line 231: RAISE FND_API.G_EXC_ERROR;

227: x_return_status => x_return_status
228: );
229:
230: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;
233:
234: HZ_GEO_STRUCTURE_VALIDATE_PVT.validate_geography_id(
235: p_geography_id => p_master_relation_rec.parent_geography_id,

Line 240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

236: p_master_ref_flag => 'Y',
237: x_return_status => x_return_status
238: );
239:
240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243:
244: END IF;

Line 241: RAISE FND_API.G_EXC_ERROR;

237: x_return_status => x_return_status
238: );
239:
240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
241: RAISE FND_API.G_EXC_ERROR;
242: END IF;
243:
244: END IF;
245:

Line 266: x_return_status := fnd_api.g_ret_sts_error;

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:
270: -- validate whether geography_type is at lower level to parent_geography_type per that country structure

Line 279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

275: p_country_code => l_country_code,
276: x_return_status => x_return_status
277: );
278:
279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
280: ----dbms_output.put_line('x_return_status is '||x_return_status);
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283:

Line 281: RAISE FND_API.G_EXC_ERROR;

277: );
278:
279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
280: ----dbms_output.put_line('x_return_status is '||x_return_status);
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283:
284: ----dbms_output.put_line('after validate_structure');
285: END IF;

Line 305: x_return_status := fnd_api.g_ret_sts_error;

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:
309: END validate_master_relation;

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

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
385: ELSE

Line 415: x_return_status := fnd_api.g_ret_sts_error;

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

Line 435: x_return_status := fnd_api.g_ret_sts_error;

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:
439: HZ_UTILITY_V2PUB.validate_lookup(

Line 470: x_return_status := fnd_api.g_ret_sts_error;

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

Line 493: x_return_status := fnd_api.g_ret_sts_error;

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

Line 562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

558: x_return_status => x_return_status
559: );
560:
561: --dbms_output.put_line('In validate, after date validation '||x_return_status);
562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:
566:

Line 563: RAISE FND_API.G_EXC_ERROR;

559: );
560:
561: --dbms_output.put_line('In validate, after date validation '||x_return_status);
562: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:
566:
567: IF p_create_update_flag = 'C' THEN

Line 575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

571: p_master_ref_flag => 'Y',
572: x_return_status => x_return_status
573: );
574:
575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578: -- validate geography name for mandatory
579: HZ_UTILITY_V2PUB.validate_mandatory (

Line 576: RAISE FND_API.G_EXC_ERROR;

572: x_return_status => x_return_status
573: );
574:
575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578: -- validate geography name for mandatory
579: HZ_UTILITY_V2PUB.validate_mandatory (
580: p_create_update_flag =>'C',

Line 587: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

583: p_restricted => 'N',
584: x_return_status => x_return_status
585: );
586:
587: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
588: RAISE FND_API.G_EXC_ERROR;
589: END IF;
590:
591: hz_utility_v2pub.validate_created_by_module(

Line 588: RAISE FND_API.G_EXC_ERROR;

584: x_return_status => x_return_status
585: );
586:
587: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
588: RAISE FND_API.G_EXC_ERROR;
589: END IF;
590:
591: hz_utility_v2pub.validate_created_by_module(
592: p_create_update_flag => 'C',

Line 604: x_return_status := FND_API.G_RET_STS_ERROR;

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:
608: --dbms_output.put_line('In valiadte, after geography_code_type validation');

Line 623: x_return_status := fnd_api.g_ret_sts_error;

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:
627: -- language_code must be FK to fnd_languages

Line 639: x_return_status := fnd_api.g_ret_sts_error;

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:
643: --validate for duplicate country

Line 654: x_return_status := fnd_api.g_ret_sts_error;

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

Line 682: x_return_status := fnd_api.g_ret_sts_error;

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:
686: -- if geography_type <> 'COUNTRY' then atleast one parent should be passed.

Line 694: x_return_status := fnd_api.g_ret_sts_error;

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:
698: END validate_master_geography;

Line 832: x_return_status := fnd_api.g_ret_sts_error;

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
836: IF p_geography_range_rec.geography_from > p_geography_range_rec.geography_to THEN

Line 839: x_return_status := fnd_api.g_ret_sts_error;

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:
843: -- validate zone_id

Line 857: x_return_status := fnd_api.g_ret_sts_error;

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
861: --master_ref_geography_id is mandatory only in create

Line 877: x_return_status := fnd_api.g_ret_sts_error;

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:
881: END validate_geography_range;

Line 946: x_return_status := fnd_api.g_ret_sts_error;

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
950: SELECT count(*) INTO l_count

Line 959: x_return_status := fnd_api.g_ret_sts_error;

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