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_STRUCTURE_PUB dependencies on FND_MESSAGE

Line 81: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_MULTIPLE_GEO_COL');

77: FETCH c_geo_parent INTO l_geo_parent;
78: EXIT WHEN c_geo_parent%NOTFOUND;
79: IF l_geo_parent.geography_element_column <> p_geo_element_column
80: THEN
81: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_MULTIPLE_GEO_COL');
82: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geography_id);
83: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_geography_type);
84: FND_MSG_PUB.ADD;
85: x_return_status := fnd_api.g_ret_sts_error;

Line 82: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geography_id);

78: EXIT WHEN c_geo_parent%NOTFOUND;
79: IF l_geo_parent.geography_element_column <> p_geo_element_column
80: THEN
81: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_MULTIPLE_GEO_COL');
82: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geography_id);
83: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_geography_type);
84: FND_MSG_PUB.ADD;
85: x_return_status := fnd_api.g_ret_sts_error;
86: END IF;

Line 83: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_geography_type);

79: IF l_geo_parent.geography_element_column <> p_geo_element_column
80: THEN
81: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_MULTIPLE_GEO_COL');
82: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geography_id);
83: FND_MESSAGE.SET_TOKEN('GEO_TYPE', p_geography_type);
84: FND_MSG_PUB.ADD;
85: x_return_status := fnd_api.g_ret_sts_error;
86: END IF;
87: END LOOP;

Line 125: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

121: INTO l_count
122: FROM hz_geography_types_b
123: WHERE GEOGRAPHY_TYPE = l_geography_type;
124:
125: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
126: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
127: FND_MSG_PUB.ADD;
128: RAISE FND_API.G_EXC_ERROR;
129:

Line 126: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');

122: FROM hz_geography_types_b
123: WHERE GEOGRAPHY_TYPE = l_geography_type;
124:
125: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
126: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
127: FND_MSG_PUB.ADD;
128: RAISE FND_API.G_EXC_ERROR;
129:
130: EXCEPTION

Line 241: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_VALUE');

237: WHERE GEOGRAPHY_TYPE = l_parent_geography_type;
238:
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
241: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_VALUE');
242: FND_MESSAGE.SET_TOKEN('VALUE', l_parent_geography_type);
243: FND_MESSAGE.SET_TOKEN('COLUMN', 'parent_geography_type');
244: FND_MSG_PUB.ADD;
245: RAISE FND_API.G_EXC_ERROR;

Line 242: FND_MESSAGE.SET_TOKEN('VALUE', l_parent_geography_type);

238:
239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
241: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_VALUE');
242: FND_MESSAGE.SET_TOKEN('VALUE', l_parent_geography_type);
243: FND_MESSAGE.SET_TOKEN('COLUMN', 'parent_geography_type');
244: FND_MSG_PUB.ADD;
245: RAISE FND_API.G_EXC_ERROR;
246: END;

Line 243: FND_MESSAGE.SET_TOKEN('COLUMN', 'parent_geography_type');

239: EXCEPTION
240: WHEN NO_DATA_FOUND THEN
241: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_VALUE');
242: FND_MESSAGE.SET_TOKEN('VALUE', l_parent_geography_type);
243: FND_MESSAGE.SET_TOKEN('COLUMN', 'parent_geography_type');
244: FND_MSG_PUB.ADD;
245: RAISE FND_API.G_EXC_ERROR;
246: END;
247: -- check if geography_type is already 'PARENT_OF' parent_geography_type (bug fix 2838632)

Line 256: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_REL_TYPE');

252: AND status = 'A'
253: AND forward_rel_code='PARENT_OF'
254: AND backward_rel_code = 'CHILD_OF';
255: IF l_count > 0 THEN
256: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_REL_TYPE');
257: FND_MESSAGE.SET_TOKEN('CHILD', l_geography_type);
258: FND_MESSAGE.SET_TOKEN('PARENT', l_parent_geography_type);
259: FND_MSG_PUB.ADD;
260: RAISE FND_API.G_EXC_ERROR;

Line 257: FND_MESSAGE.SET_TOKEN('CHILD', l_geography_type);

253: AND forward_rel_code='PARENT_OF'
254: AND backward_rel_code = 'CHILD_OF';
255: IF l_count > 0 THEN
256: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_REL_TYPE');
257: FND_MESSAGE.SET_TOKEN('CHILD', l_geography_type);
258: FND_MESSAGE.SET_TOKEN('PARENT', l_parent_geography_type);
259: FND_MSG_PUB.ADD;
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;

Line 258: FND_MESSAGE.SET_TOKEN('PARENT', l_parent_geography_type);

254: AND backward_rel_code = 'CHILD_OF';
255: IF l_count > 0 THEN
256: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_REL_TYPE');
257: FND_MESSAGE.SET_TOKEN('CHILD', l_geography_type);
258: FND_MESSAGE.SET_TOKEN('PARENT', l_parent_geography_type);
259: FND_MSG_PUB.ADD;
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262:

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

325: select 1 into l_count from
326: hz_relationship_types
327: where relationship_type_id=p_relationship_type_id;
328: EXCEPTION WHEN NO_DATA_FOUND THEN
329: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
330: FND_MESSAGE.SET_TOKEN('TOKEN1', 'Relationship Type');
331: FND_MESSAGE.SET_TOKEN('TOKEN2', 'relationship_type_id '||p_relationship_type_id);
332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;

Line 330: FND_MESSAGE.SET_TOKEN('TOKEN1', 'Relationship Type');

326: hz_relationship_types
327: where relationship_type_id=p_relationship_type_id;
328: EXCEPTION WHEN NO_DATA_FOUND THEN
329: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
330: FND_MESSAGE.SET_TOKEN('TOKEN1', 'Relationship Type');
331: FND_MESSAGE.SET_TOKEN('TOKEN2', 'relationship_type_id '||p_relationship_type_id);
332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;
334: END;

Line 331: FND_MESSAGE.SET_TOKEN('TOKEN2', 'relationship_type_id '||p_relationship_type_id);

327: where relationship_type_id=p_relationship_type_id;
328: EXCEPTION WHEN NO_DATA_FOUND THEN
329: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
330: FND_MESSAGE.SET_TOKEN('TOKEN1', 'Relationship Type');
331: FND_MESSAGE.SET_TOKEN('TOKEN2', 'relationship_type_id '||p_relationship_type_id);
332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;
334: END;
335:

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

414:
415: ----dbms_output.put_line('Country_code is '||l_country_code);
416:
417: IF l_country_code IS NULL THEN
418: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
419: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code' );
420: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geo_structure_rec.geography_id );
421: FND_MSG_PUB.ADD;
422: RAISE FND_API.G_EXC_ERROR;

Line 419: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code' );

415: ----dbms_output.put_line('Country_code is '||l_country_code);
416:
417: IF l_country_code IS NULL THEN
418: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
419: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code' );
420: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geo_structure_rec.geography_id );
421: FND_MSG_PUB.ADD;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;

Line 420: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geo_structure_rec.geography_id );

416:
417: IF l_country_code IS NULL THEN
418: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
419: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code' );
420: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geo_structure_rec.geography_id );
421: FND_MSG_PUB.ADD;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:

Line 436: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );

432: AND geography_id = p_geo_structure_rec.geography_id
433: AND rownum < 2;
434:
435: IF l_count > 0 THEN
436: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
437: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column');
438: FND_MSG_PUB.ADD;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;*/

Line 437: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column');

433: AND rownum < 2;
434:
435: IF l_count > 0 THEN
436: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
437: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column');
438: FND_MSG_PUB.ADD;
439: RAISE FND_API.G_EXC_ERROR;
440: END IF;*/
441:

Line 656: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );

652: AND geography_id = p_geography_id
653: AND rownum < 2;
654:
655: IF l_count > 0 THEN
656: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
657: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column for this geography_id' );
658: FND_MSG_PUB.ADD;
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;

Line 657: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column for this geography_id' );

653: AND rownum < 2;
654:
655: IF l_count > 0 THEN
656: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
657: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column for this geography_id' );
658: FND_MSG_PUB.ADD;
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:

Line 671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

667: AND geography_type = p_geography_type
668: AND parent_geography_type = p_parent_geography_type;
669:
670: IF p_object_version_number <> l_object_version_number THEN
671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
672: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geo_structure_levels');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: ELSE

Line 672: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geo_structure_levels');

668: AND parent_geography_type = p_parent_geography_type;
669:
670: IF p_object_version_number <> l_object_version_number THEN
671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
672: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geo_structure_levels');
673: FND_MSG_PUB.ADD;
674: RAISE FND_API.G_EXC_ERROR;
675: ELSE
676: p_object_version_number := l_object_version_number+1;

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

675: ELSE
676: p_object_version_number := l_object_version_number+1;
677: END IF;
678: EXCEPTION WHEN NO_DATA_FOUND THEN
679: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
680: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code , geography_element_column' );
681: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_ERROR;

Line 680: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code , geography_element_column' );

676: p_object_version_number := l_object_version_number+1;
677: END IF;
678: EXCEPTION WHEN NO_DATA_FOUND THEN
679: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
680: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code , geography_element_column' );
681: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_ERROR;
684: END;

Line 681: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );

677: END IF;
678: EXCEPTION WHEN NO_DATA_FOUND THEN
679: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
680: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'country_code , geography_element_column' );
681: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );
682: FND_MSG_PUB.ADD;
683: RAISE FND_API.G_EXC_ERROR;
684: END;
685:

Line 710: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_ELEMENT_NONUPDATEABLE' );

706: AND hrl.subject_id in ( SELECT geography_id from hz_geographies where
707: country_code = l_country_code )
708: AND rownum <2;
709: --dbms_output.put_line('after execute');
710: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_ELEMENT_NONUPDATEABLE' );
711: --FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column' );
712: FND_MSG_PUB.ADD;
713: --x_return_status := FND_API.G_RET_STS_ERROR;
714: RAISE FND_API.G_EXC_ERROR;

Line 711: --FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column' );

707: country_code = l_country_code )
708: AND rownum <2;
709: --dbms_output.put_line('after execute');
710: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_ELEMENT_NONUPDATEABLE' );
711: --FND_MESSAGE.SET_TOKEN( 'COLUMN', 'geography_element_column' );
712: FND_MSG_PUB.ADD;
713: --x_return_status := FND_API.G_RET_STS_ERROR;
714: RAISE FND_API.G_EXC_ERROR;
715:

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

836: l_column := 'parent_geography_type';
837: END IF;
838:
839: IF l_error = TRUE THEN
840: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
841: FND_MESSAGE.SET_TOKEN( 'COLUMN', l_column );
842: FND_MSG_PUB.ADD;
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;

Line 841: FND_MESSAGE.SET_TOKEN( 'COLUMN', l_column );

837: END IF;
838:
839: IF l_error = TRUE THEN
840: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
841: FND_MESSAGE.SET_TOKEN( 'COLUMN', l_column );
842: FND_MSG_PUB.ADD;
843: RAISE FND_API.G_EXC_ERROR;
844: END IF;
845:

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

853: AND geography_type = p_geography_type
854: AND parent_geography_type = p_parent_geography_type;
855:
856: EXCEPTION WHEN NO_DATA_FOUND THEN
857: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
858: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'relationship_type_id,country_code' );
859: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;

Line 858: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'relationship_type_id,country_code' );

854: AND parent_geography_type = p_parent_geography_type;
855:
856: EXCEPTION WHEN NO_DATA_FOUND THEN
857: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
858: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'relationship_type_id,country_code' );
859: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;
862: END;

Line 859: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );

855:
856: EXCEPTION WHEN NO_DATA_FOUND THEN
857: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
858: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'relationship_type_id,country_code' );
859: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_type '||p_geography_type||', parent_geography_type '||p_parent_geography_type );
860: FND_MSG_PUB.ADD;
861: RAISE FND_API.G_EXC_ERROR;
862: END;
863: -- code added for bug 4730508

Line 1349: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_LIMITED_GEOGRAPHY');

1345:
1346: -- check if included_geography_type is COUNTRY and if yes, check for limited_by_geography_id to be null
1347: IF p_zone_type_rec.included_geography_type(i) = 'COUNTRY' THEN
1348: IF p_zone_type_rec.limited_by_geography_id IS NOT NULL THEN
1349: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_LIMITED_GEOGRAPHY');
1350: FND_MSG_PUB.ADD;
1351: RAISE FND_API.G_EXC_ERROR;
1352: END IF;
1353: END IF;

Line 1376: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_INC_GEO_TYPE');

1372: CONNECT BY PRIOR geography_type = parent_geography_type
1373: AND country_code = l_country_code;
1374:
1375: EXCEPTION WHEN NO_DATA_FOUND THEN
1376: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_INC_GEO_TYPE');
1377: FND_MESSAGE.SET_TOKEN('P_LIMITED_BY_GEOGRAPHY', l_limited_by_geo_type);
1378: FND_MSG_PUB.ADD;
1379: RAISE FND_API.G_EXC_ERROR;
1380: END;

Line 1377: FND_MESSAGE.SET_TOKEN('P_LIMITED_BY_GEOGRAPHY', l_limited_by_geo_type);

1373: AND country_code = l_country_code;
1374:
1375: EXCEPTION WHEN NO_DATA_FOUND THEN
1376: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_INC_GEO_TYPE');
1377: FND_MESSAGE.SET_TOKEN('P_LIMITED_BY_GEOGRAPHY', l_limited_by_geo_type);
1378: FND_MSG_PUB.ADD;
1379: RAISE FND_API.G_EXC_ERROR;
1380: END;
1381: END IF;

Line 1502: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

1498:
1499:
1500: --validate object_version_number
1501: IF l_object_version_number <> p_object_version_number THEN
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1503: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_types_b');
1504: FND_MSG_PUB.ADD;
1505: RAISE FND_API.G_EXC_ERROR;
1506: ELSE

Line 1503: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_types_b');

1499:
1500: --validate object_version_number
1501: IF l_object_version_number <> p_object_version_number THEN
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1503: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_types_b');
1504: FND_MSG_PUB.ADD;
1505: RAISE FND_API.G_EXC_ERROR;
1506: ELSE
1507: p_object_version_number := l_object_version_number + 1;

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

1507: p_object_version_number := l_object_version_number + 1;
1508: END IF;
1509:
1510: EXCEPTION WHEN NO_DATA_FOUND THEN
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
1512: FND_MESSAGE.SET_TOKEN('TOKEN1','zone_type');
1513: FND_MESSAGE.SET_TOKEN('TOKEN2', 'zone_type '||p_geography_type);
1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;

Line 1512: FND_MESSAGE.SET_TOKEN('TOKEN1','zone_type');

1508: END IF;
1509:
1510: EXCEPTION WHEN NO_DATA_FOUND THEN
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
1512: FND_MESSAGE.SET_TOKEN('TOKEN1','zone_type');
1513: FND_MESSAGE.SET_TOKEN('TOKEN2', 'zone_type '||p_geography_type);
1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;
1516:

Line 1513: FND_MESSAGE.SET_TOKEN('TOKEN2', 'zone_type '||p_geography_type);

1509:
1510: EXCEPTION WHEN NO_DATA_FOUND THEN
1511: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
1512: FND_MESSAGE.SET_TOKEN('TOKEN1','zone_type');
1513: FND_MESSAGE.SET_TOKEN('TOKEN2', 'zone_type '||p_geography_type);
1514: FND_MSG_PUB.ADD;
1515: RAISE FND_API.G_EXC_ERROR;
1516:
1517: END;

Line 1546: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

1542: AND rownum <2;
1543:
1544: --dbms_output.put_line('l_count is '||to_char(l_count));
1545: IF l_count >0 THEN
1546: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1547: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'postal_code_range_flag from Y to N as there exists rows in hz_geography_ranges');
1548: FND_MSG_PUB.ADD;
1549: -- x_return_status := FND_API.G_RET_STS_ERROR;
1550: RAISE FND_API.G_EXC_ERROR;

Line 1547: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'postal_code_range_flag from Y to N as there exists rows in hz_geography_ranges');

1543:
1544: --dbms_output.put_line('l_count is '||to_char(l_count));
1545: IF l_count >0 THEN
1546: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1547: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'postal_code_range_flag from Y to N as there exists rows in hz_geography_ranges');
1548: FND_MSG_PUB.ADD;
1549: -- x_return_status := FND_API.G_RET_STS_ERROR;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;

Line 1565: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );

1561:
1562: --dbms_output.put_line('l_count for limited_id '||to_char(l_count));
1563:
1564: IF l_count > 0 THEN
1565: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1566: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'limited_by_geography_id as there exists zones for this geography_type');
1567: FND_MSG_PUB.ADD;
1568: -- x_return_status := FND_API.G_RET_STS_ERROR;
1569: RAISE FND_API.G_EXC_ERROR;

Line 1566: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'limited_by_geography_id as there exists zones for this geography_type');

1562: --dbms_output.put_line('l_count for limited_id '||to_char(l_count));
1563:
1564: IF l_count > 0 THEN
1565: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1566: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'limited_by_geography_id as there exists zones for this geography_type');
1567: FND_MSG_PUB.ADD;
1568: -- x_return_status := FND_API.G_RET_STS_ERROR;
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;

Line 1602: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_LIMITED_GEOGRAPHY');

1598:
1599: -- check if included_geography_type is COUNTRY and if yes, check for limited_by_geography_id to be null
1600: IF p_zone_type_rec.included_geography_type(i) = 'COUNTRY' THEN
1601: IF p_zone_type_rec.limited_by_geography_id IS NOT NULL THEN
1602: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_LIMITED_GEOGRAPHY');
1603: FND_MSG_PUB.ADD;
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;
1606: END IF;

Line 1782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

1778: ROLLBACK TO create_geography_type;
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1781: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
1782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1783: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
1784: FND_MSG_PUB.ADD;
1785: END IF;
1786: FND_MSG_PUB.Count_And_Get(

Line 1783: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');

1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
1781: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
1782: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1783: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
1784: FND_MSG_PUB.ADD;
1785: END IF;
1786: FND_MSG_PUB.Count_And_Get(
1787: p_encoded => FND_API.G_FALSE,

Line 1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1790:
1791: WHEN OTHERS THEN
1792: ROLLBACK TO create_geography_type;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1796: FND_MSG_PUB.ADD;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,

Line 1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

1791: WHEN OTHERS THEN
1792: ROLLBACK TO create_geography_type;
1793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1795: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1796: FND_MSG_PUB.ADD;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_encoded => FND_API.G_FALSE,
1799: p_count => x_msg_count,

Line 1896: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1892:
1893: WHEN OTHERS THEN
1894: ROLLBACK TO create_geo_rel_type;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1897: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1898: FND_MSG_PUB.ADD;
1899: FND_MSG_PUB.Count_And_Get(
1900: p_encoded => FND_API.G_FALSE,

Line 1897: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1893: WHEN OTHERS THEN
1894: ROLLBACK TO create_geo_rel_type;
1895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1896: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1897: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1898: FND_MSG_PUB.ADD;
1899: FND_MSG_PUB.Count_And_Get(
1900: p_encoded => FND_API.G_FALSE,
1901: p_count => x_msg_count,

Line 2000: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1996:
1997: WHEN OTHERS THEN
1998: ROLLBACK TO update_geo_rel_type;
1999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2000: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2001: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2002: FND_MSG_PUB.ADD;
2003: FND_MSG_PUB.Count_And_Get(
2004: p_encoded => FND_API.G_FALSE,

Line 2001: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

1997: WHEN OTHERS THEN
1998: ROLLBACK TO update_geo_rel_type;
1999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2000: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2001: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2002: FND_MSG_PUB.ADD;
2003: FND_MSG_PUB.Count_And_Get(
2004: p_encoded => FND_API.G_FALSE,
2005: p_count => x_msg_count,

Line 2102: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

2098: WHEN DUP_VAL_ON_INDEX THEN
2099: ROLLBACK TO create_geo_structure;
2100: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2101: IF p_index_name = 'HZ_GEO_STRUCTURE_LEVELS_U1' THEN
2102: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2103: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_type and parent_geography_type');
2104: FND_MSG_PUB.ADD;
2105: END IF;
2106: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2103: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_type and parent_geography_type');

2099: ROLLBACK TO create_geo_structure;
2100: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2101: IF p_index_name = 'HZ_GEO_STRUCTURE_LEVELS_U1' THEN
2102: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2103: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_type and parent_geography_type');
2104: FND_MSG_PUB.ADD;
2105: END IF;
2106: x_return_status := FND_API.G_RET_STS_ERROR;
2107: FND_MSG_PUB.Count_And_Get(

Line 2115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2111:
2112: WHEN OTHERS THEN
2113: ROLLBACK TO create_geo_structure;
2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2116: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2117: FND_MSG_PUB.ADD;
2118: FND_MSG_PUB.Count_And_Get(
2119: p_encoded => FND_API.G_FALSE,

Line 2116: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2112: WHEN OTHERS THEN
2113: ROLLBACK TO create_geo_structure;
2114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2116: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2117: FND_MSG_PUB.ADD;
2118: FND_MSG_PUB.Count_And_Get(
2119: p_encoded => FND_API.G_FALSE,
2120: p_count => x_msg_count,

Line 2226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2222:
2223: WHEN OTHERS THEN
2224: ROLLBACK TO update_geo_structure;
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2228: FND_MSG_PUB.ADD;
2229: FND_MSG_PUB.Count_And_Get(
2230: p_encoded => FND_API.G_FALSE,

Line 2227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2223: WHEN OTHERS THEN
2224: ROLLBACK TO update_geo_structure;
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2227: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2228: FND_MSG_PUB.ADD;
2229: FND_MSG_PUB.Count_And_Get(
2230: p_encoded => FND_API.G_FALSE,
2231: p_count => x_msg_count,

Line 2331: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2327:
2328: WHEN OTHERS THEN
2329: ROLLBACK TO delete_geo_structure;
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2332: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2333: FND_MSG_PUB.ADD;
2334: FND_MSG_PUB.Count_And_Get(
2335: p_encoded => FND_API.G_FALSE,

Line 2332: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2328: WHEN OTHERS THEN
2329: ROLLBACK TO delete_geo_structure;
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2332: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2333: FND_MSG_PUB.ADD;
2334: FND_MSG_PUB.Count_And_Get(
2335: p_encoded => FND_API.G_FALSE,
2336: p_count => x_msg_count,

Line 2433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

2429: ROLLBACK TO create_zone_type;
2430: x_return_status := FND_API.G_RET_STS_ERROR;
2431: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2432: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
2433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2434: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
2435: FND_MSG_PUB.ADD;
2436: END IF;
2437: FND_MSG_PUB.Count_And_Get(

Line 2434: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');

2430: x_return_status := FND_API.G_RET_STS_ERROR;
2431: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
2432: IF p_index_name = 'HZ_GEOGRAPHY_TYPES_B_U1' THEN
2433: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2434: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_type');
2435: FND_MSG_PUB.ADD;
2436: END IF;
2437: FND_MSG_PUB.Count_And_Get(
2438: p_encoded => FND_API.G_FALSE,

Line 2445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2441:
2442: WHEN OTHERS THEN
2443: ROLLBACK TO create_zone_type;
2444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2446: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2447: FND_MSG_PUB.ADD;
2448: FND_MSG_PUB.Count_And_Get(
2449: p_encoded => FND_API.G_FALSE,

Line 2446: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

2442: WHEN OTHERS THEN
2443: ROLLBACK TO create_zone_type;
2444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2445: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2446: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2447: FND_MSG_PUB.ADD;
2448: FND_MSG_PUB.Count_And_Get(
2449: p_encoded => FND_API.G_FALSE,
2450: p_count => x_msg_count,

Line 2548: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

2544:
2545: WHEN OTHERS THEN
2546: ROLLBACK TO update_zone_type;
2547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2548: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2549: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2550: FND_MSG_PUB.ADD;
2551: FND_MSG_PUB.Count_And_Get(
2552: p_encoded => FND_API.G_FALSE,

Line 2549: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

2545: WHEN OTHERS THEN
2546: ROLLBACK TO update_zone_type;
2547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2548: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2549: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2550: FND_MSG_PUB.ADD;
2551: FND_MSG_PUB.Count_And_Get(
2552: p_encoded => FND_API.G_FALSE,
2553: p_count => x_msg_count,