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_MESSAGE

Line 74: fnd_message.set_name('AR', 'HZ_GEO_STRUCT_UNDEFINED');

70: WHERE geography_id = l_geography_id
71: AND rownum <2;
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;

Line 75: fnd_message.set_token('GEO_ID', l_geography_id);

71: AND rownum <2;
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:

Line 99: fnd_message.set_name('AR', 'HZ_GEO_INVALID_COMBINATION');

95: and parent_geography_type=p_parent_geography_type;
96:
97: EXCEPTION
98: WHEN NO_DATA_FOUND THEN
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;

Line 100: fnd_message.set_token('COUNTRY', p_country_code);

96:
97: EXCEPTION
98: WHEN NO_DATA_FOUND THEN
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;

Line 101: fnd_message.set_token('PARENT_GEO', p_parent_geography_type);

97: EXCEPTION
98: WHEN NO_DATA_FOUND THEN
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;

Line 102: fnd_message.set_token('CHILD_GEO', p_geography_type);

98: WHEN NO_DATA_FOUND THEN
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;

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

144: RETURN l_geography_type;
145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
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;

Line 149: fnd_message.set_token('FK','geography_id');

145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
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;

Line 150: fnd_message.set_token('COLUMN', 'geography_id');

146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
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;

Line 151: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');

147: WHEN NO_DATA_FOUND THEN
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:

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

258: SELECT country_code INTO l_country_code
259: FROM HZ_GEOGRAPHIES
260: WHERE geography_id=p_master_relation_rec.parent_geography_id;
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;

Line 263: fnd_message.set_token('TOKEN1', 'country_code');

259: FROM HZ_GEOGRAPHIES
260: WHERE geography_id=p_master_relation_rec.parent_geography_id;
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:

Line 264: fnd_message.set_token('TOKEN2', 'geography_id '||p_master_relation_rec.parent_geography_id);

260: WHERE geography_id=p_master_relation_rec.parent_geography_id;
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;

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

298: AND relationship_type='MASTER_REF'
299: AND status = 'A';
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;

Line 303: fnd_message.set_token('COLUMN', 'geography_id');

299: AND status = 'A';
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;

Line 377: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );

373: -- identifier_subtype, which is STANDARD_NAME. So, for NAME, if anything other than
374: -- STANDARD_NAME is used raise error.
375: ELSIF p_geo_identifier_rec.identifier_type='NAME' THEN
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;

Line 378: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );

374: -- STANDARD_NAME is used raise error.
375: ELSIF p_geo_identifier_rec.identifier_type='NAME' THEN
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;

Line 379: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'HZ_GEO_IDENTIFIER_SUBTYPE' );

375: ELSIF p_geo_identifier_rec.identifier_type='NAME' THEN
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

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

406: WHERE language_code = p_geo_identifier_rec.language_code
407: AND rownum <2;
408:
409: IF l_count = 0 THEN
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;

Line 411: fnd_message.set_token('FK','language_code');

407: AND rownum <2;
408:
409: IF l_count = 0 THEN
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;

Line 412: fnd_message.set_token('COLUMN', 'language_code');

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

Line 413: fnd_message.set_token('TABLE','FND_LANGUAGES');

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

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

428: AND identifier_value=p_geo_identifier_rec.identifier_value
429: AND language_code = p_geo_identifier_rec.language_code;
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;

Line 433: fnd_message.set_token('COLUMN', 'geography_id,identifier_type,identifier_subtype,identifier_value,language_code');

429: AND language_code = p_geo_identifier_rec.language_code;
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; */

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

463: AND identifier_type = p_geo_identifier_rec.identifier_type
464: AND rownum <2;
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;

Line 468: fnd_message.set_token('COLUMN', 'identifier_value within the identifier_type NAME and language code '||p_geo_identifier_rec.language_code);

464: AND rownum <2;
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;

Line 487: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');

483: AND language_code = p_geo_identifier_rec.language_code
484: ;
485:
486: IF l_count = 0 THEN
487: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
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);

Line 488: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');

484: ;
485:
486: IF l_count = 0 THEN
487: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
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;

Line 489: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id '||p_geo_identifier_rec.geography_id||',identifier_type '||p_geo_identifier_rec.identifier_type||

485:
486: IF l_count = 0 THEN
487: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
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;

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

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

Line 602: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_code_type' );

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

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

614: FROM FND_TIMEZONES_B
615: WHERE timezone_code = p_master_geography_rec.timezone_code;
616:
617: IF l_count = 0 THEN
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;

Line 619: fnd_message.set_token('FK', 'timezone_code');

615: WHERE timezone_code = p_master_geography_rec.timezone_code;
616:
617: IF l_count = 0 THEN
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;

Line 620: fnd_message.set_token('COLUMN','timezone_code');

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

Line 621: fnd_message.set_token('TABLE','FND_TIMEZONES_B');

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

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

630: FROM fnd_languages
631: WHERE language_code = UPPER(p_master_geography_rec.language_code)
632: AND rownum <2;
633: IF l_count = 0 THEN
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;

Line 635: fnd_message.set_token('FK', 'language_code');

631: WHERE language_code = UPPER(p_master_geography_rec.language_code)
632: AND rownum <2;
633: IF l_count = 0 THEN
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;

Line 636: fnd_message.set_token('COLUMN','language_code');

632: AND rownum <2;
633: IF l_count = 0 THEN
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;

Line 637: fnd_message.set_token('TABLE','FND_LANGUAGES');

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

Line 651: fnd_message.set_name('AR', 'HZ_GEO_DUPLICATE_GEOG_CODE');

647: WHERE geography_code=p_master_geography_rec.geography_code
648: AND geography_type='COUNTRY';
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;

Line 652: fnd_message.set_token('COUNTRY_CODE', p_master_geography_rec.geography_code);

648: AND geography_type='COUNTRY';
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;

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

673: SELECT count(*) INTO l_count
674: FROM FND_TERRITORIES
675: WHERE territory_code = UPPER(p_master_geography_rec.geography_code);
676: IF l_count = 0 THEN
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;

Line 678: fnd_message.set_token('FK','territory_code');

674: FROM FND_TERRITORIES
675: WHERE territory_code = UPPER(p_master_geography_rec.geography_code);
676: IF l_count = 0 THEN
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;

Line 679: fnd_message.set_token('COLUMN', 'geography_code');

675: WHERE territory_code = UPPER(p_master_geography_rec.geography_code);
676: IF l_count = 0 THEN
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;

Line 680: fnd_message.set_token('TABLE','FND_TERRITORIES');

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

Line 691: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');

687: IF p_master_geography_rec.geography_type <> 'COUNTRY' THEN
688: --dbms_output.put_line('parent count is '||to_char(l_parent_geography_tbl.count));
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;

Line 692: fnd_message.set_token('COLUMN', 'parent_geography_id');

688: --dbms_output.put_line('parent count is '||to_char(l_parent_geography_tbl.count));
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;

Line 830: fnd_message.set_name('AR', 'HZ_GEO_INVALID_RANGE');

826: -- If geography_from and geography_to are alpha numeric, it will execute the exception part.
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

Line 837: fnd_message.set_name('AR', 'HZ_GEO_INVALID_RANGE');

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

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

848: AND geography_use <> 'MASTER_REF';
849:
850:
851: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 853: fnd_message.set_token('FK','geography_id');

849:
850:
851: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 854: fnd_message.set_token('COLUMN', 'zone_id');

850:
851: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 855: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');

851: EXCEPTION WHEN NO_DATA_FOUND THEN
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:

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

868: AND geography_use = 'MASTER_REF';
869:
870:
871: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 873: fnd_message.set_token('FK','geography_id');

869:
870:
871: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 874: fnd_message.set_token('COLUMN', 'master_ref_geography_id');

870:
871: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

Line 875: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');

871: EXCEPTION WHEN NO_DATA_FOUND THEN
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;

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

937: FROM hz_geographies
938: WHERE geography_id = p_zone_relation_rec.geography_id;
939:
940: IF l_count = 0 THEN
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;

Line 942: fnd_message.set_token('FK', 'geography_id');

938: WHERE geography_id = p_zone_relation_rec.geography_id;
939:
940: IF l_count = 0 THEN
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;

Line 943: fnd_message.set_token('COLUMN','geography_id');

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

Line 944: fnd_message.set_token('TABLE','HZ_GEOGRAPHIES');

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

Line 955: fnd_message.set_name('AR', 'HZ_GEO_INVALID_VALUE');

951: FROM hz_geographies
952: WHERE geography_id = p_zone_relation_rec.included_geography_id;
953:
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;

Line 956: fnd_message.set_token('VALUE',p_zone_relation_rec.included_geography_id);

952: WHERE geography_id = p_zone_relation_rec.included_geography_id;
953:
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;

Line 957: fnd_message.set_token('COLUMN', 'included_geography_id');

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