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

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

210: l_element_range := 'F';
211: END IF;
212:
213: EXCEPTION WHEN NO_DATA_FOUND THEN
214: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
215: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_element_column');
216: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_type :'||l_get_all_parents.parent_object_type||', country_code :'||l_country_code);
217: FND_MSG_PUB.ADD;
218: x_return_status := fnd_api.g_ret_sts_error;

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

211: END IF;
212:
213: EXCEPTION WHEN NO_DATA_FOUND THEN
214: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
215: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_element_column');
216: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_type :'||l_get_all_parents.parent_object_type||', country_code :'||l_country_code);
217: FND_MSG_PUB.ADD;
218: x_return_status := fnd_api.g_ret_sts_error;
219: RAISE FND_API.G_EXC_ERROR;

Line 216: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_type :'||l_get_all_parents.parent_object_type||', country_code :'||l_country_code);

212:
213: EXCEPTION WHEN NO_DATA_FOUND THEN
214: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
215: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_element_column');
216: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_type :'||l_get_all_parents.parent_object_type||', country_code :'||l_country_code);
217: FND_MSG_PUB.ADD;
218: x_return_status := fnd_api.g_ret_sts_error;
219: RAISE FND_API.G_EXC_ERROR;
220: END;

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

353: l_geo_element_col_id := l_geo_element_col||'_id';
354: l_geo_element_col_code := l_geo_element_col||'_CODE';
355:
356: EXCEPTION WHEN NO_DATA_FOUND THEN
357: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
358: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_element_column');
359: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_type :'||l_parent_object_type||'and for country_code of geography_id:'||p_geography_id);
360: FND_MSG_PUB.ADD;
361:

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

354: l_geo_element_col_code := l_geo_element_col||'_CODE';
355:
356: EXCEPTION WHEN NO_DATA_FOUND THEN
357: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
358: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_element_column');
359: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_type :'||l_parent_object_type||'and for country_code of geography_id:'||p_geography_id);
360: FND_MSG_PUB.ADD;
361:
362: RAISE FND_API.G_EXC_ERROR;

Line 359: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_type :'||l_parent_object_type||'and for country_code of geography_id:'||p_geography_id);

355:
356: EXCEPTION WHEN NO_DATA_FOUND THEN
357: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
358: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_element_column');
359: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_type :'||l_parent_object_type||'and for country_code of geography_id:'||p_geography_id);
360: FND_MSG_PUB.ADD;
361:
362: RAISE FND_API.G_EXC_ERROR;
363: END;

Line 512: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');

508: AND relationship_type = 'MASTER_REF');
509:
510: IF l_count > 0 THEN
511:
512: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
513: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
514: FND_MESSAGE.SET_TOKEN('VALUE', p_child_name);
515: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
516: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);

Line 513: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');

509:
510: IF l_count > 0 THEN
511:
512: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
513: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
514: FND_MESSAGE.SET_TOKEN('VALUE', p_child_name);
515: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
516: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);
517: FND_MSG_PUB.ADD;

Line 514: FND_MESSAGE.SET_TOKEN('VALUE', p_child_name);

510: IF l_count > 0 THEN
511:
512: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
513: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
514: FND_MESSAGE.SET_TOKEN('VALUE', p_child_name);
515: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
516: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);
517: FND_MSG_PUB.ADD;
518: x_return_status := fnd_api.g_ret_sts_error;

Line 515: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);

511:
512: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
513: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
514: FND_MESSAGE.SET_TOKEN('VALUE', p_child_name);
515: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
516: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);
517: FND_MSG_PUB.ADD;
518: x_return_status := fnd_api.g_ret_sts_error;
519:

Line 516: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);

512: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
513: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
514: FND_MESSAGE.SET_TOKEN('VALUE', p_child_name);
515: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
516: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);
517: FND_MSG_PUB.ADD;
518: x_return_status := fnd_api.g_ret_sts_error;
519:
520: END IF;

Line 556: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');

552: AND relationship_type = 'MASTER_REF');
553:
554: IF l_count > 0 THEN
555:
556: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
557: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
558: FND_MESSAGE.SET_TOKEN('VALUE', p_child_code);
559: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
560: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);

Line 557: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');

553:
554: IF l_count > 0 THEN
555:
556: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
557: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
558: FND_MESSAGE.SET_TOKEN('VALUE', p_child_code);
559: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
560: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);
561: FND_MSG_PUB.ADD;

Line 558: FND_MESSAGE.SET_TOKEN('VALUE', p_child_code);

554: IF l_count > 0 THEN
555:
556: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
557: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
558: FND_MESSAGE.SET_TOKEN('VALUE', p_child_code);
559: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
560: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);
561: FND_MSG_PUB.ADD;
562: x_return_status := fnd_api.g_ret_sts_error;

Line 559: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);

555:
556: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
557: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
558: FND_MESSAGE.SET_TOKEN('VALUE', p_child_code);
559: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
560: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);
561: FND_MSG_PUB.ADD;
562: x_return_status := fnd_api.g_ret_sts_error;
563:

Line 560: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);

556: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
557: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
558: FND_MESSAGE.SET_TOKEN('VALUE', p_child_code);
559: FND_MESSAGE.SET_TOKEN('GEO_ID', p_child_id);
560: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', p_parent_id);
561: FND_MSG_PUB.ADD;
562: x_return_status := fnd_api.g_ret_sts_error;
563:
564: END IF;

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

747:
748: -- End of added section (Neeraj Shinde Bug# 5393825)
749:
750: EXCEPTION when no_data_found THEN
751: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
752: fnd_message.set_token('TOKEN1','Geography record');
753: fnd_message.set_token('TOKEN2','geography_id '||p_master_relation_rec.geography_id);
754: fnd_msg_pub.add;
755: RAISE FND_API.G_EXC_ERROR;

Line 752: fnd_message.set_token('TOKEN1','Geography record');

748: -- End of added section (Neeraj Shinde Bug# 5393825)
749:
750: EXCEPTION when no_data_found THEN
751: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
752: fnd_message.set_token('TOKEN1','Geography record');
753: fnd_message.set_token('TOKEN2','geography_id '||p_master_relation_rec.geography_id);
754: fnd_msg_pub.add;
755: RAISE FND_API.G_EXC_ERROR;
756: END;

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

749:
750: EXCEPTION when no_data_found THEN
751: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
752: fnd_message.set_token('TOKEN1','Geography record');
753: fnd_message.set_token('TOKEN2','geography_id '||p_master_relation_rec.geography_id);
754: fnd_msg_pub.add;
755: RAISE FND_API.G_EXC_ERROR;
756: END;
757: -- a geography can not have two countries as its parents

Line 768: fnd_message.set_name('AR', 'HZ_GEO_MULTIPLE_COUNTRIES');

764: AND NVL(status,'A') = 'A'
765: AND level_number = 1;
766:
767: IF l_count > 0 THEN
768: fnd_message.set_name('AR', 'HZ_GEO_MULTIPLE_COUNTRIES');
769: fnd_message.set_token('GEO_ID', p_master_relation_rec.geography_id);
770: fnd_msg_pub.add;
771: RAISE FND_API.G_EXC_ERROR;
772: END IF;

Line 769: fnd_message.set_token('GEO_ID', p_master_relation_rec.geography_id);

765: AND level_number = 1;
766:
767: IF l_count > 0 THEN
768: fnd_message.set_name('AR', 'HZ_GEO_MULTIPLE_COUNTRIES');
769: fnd_message.set_token('GEO_ID', p_master_relation_rec.geography_id);
770: fnd_msg_pub.add;
771: RAISE FND_API.G_EXC_ERROR;
772: END IF;
773: END IF;

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

939: WHERE relationship_id = p_relationship_id
940: AND relationship_code = 'PARENT_OF';
941:
942: EXCEPTION WHEN NO_DATA_FOUND THEN
943: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
944: fnd_message.set_token('token1', 'relationship');
945: fnd_message.set_token('token1', 'relationship_id '||p_relationship_id);
946: fnd_msg_pub.add;
947: RAISE FND_API.G_EXC_ERROR;

Line 944: fnd_message.set_token('token1', 'relationship');

940: AND relationship_code = 'PARENT_OF';
941:
942: EXCEPTION WHEN NO_DATA_FOUND THEN
943: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
944: fnd_message.set_token('token1', 'relationship');
945: fnd_message.set_token('token1', 'relationship_id '||p_relationship_id);
946: fnd_msg_pub.add;
947: RAISE FND_API.G_EXC_ERROR;
948: END;

Line 945: fnd_message.set_token('token1', 'relationship_id '||p_relationship_id);

941:
942: EXCEPTION WHEN NO_DATA_FOUND THEN
943: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
944: fnd_message.set_token('token1', 'relationship');
945: fnd_message.set_token('token1', 'relationship_id '||p_relationship_id);
946: fnd_msg_pub.add;
947: RAISE FND_API.G_EXC_ERROR;
948: END;
949:

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

1001: AND status = 'A';
1002:
1003: --dbms_output.put_line('l_parent_count '|| to_char(l_parent_count));
1004: EXCEPTION WHEN NO_DATA_FOUND THEN
1005: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1006: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Relationship');
1007: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'object_id '||l_geography_id||',object_type '||l_geography_type||' and relationship_type MASTER_REF');
1008: FND_MSG_PUB.ADD;
1009: RAISE FND_API.G_EXC_ERROR;

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

1002:
1003: --dbms_output.put_line('l_parent_count '|| to_char(l_parent_count));
1004: EXCEPTION WHEN NO_DATA_FOUND THEN
1005: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1006: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Relationship');
1007: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'object_id '||l_geography_id||',object_type '||l_geography_type||' and relationship_type MASTER_REF');
1008: FND_MSG_PUB.ADD;
1009: RAISE FND_API.G_EXC_ERROR;
1010: END;

Line 1007: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'object_id '||l_geography_id||',object_type '||l_geography_type||' and relationship_type MASTER_REF');

1003: --dbms_output.put_line('l_parent_count '|| to_char(l_parent_count));
1004: EXCEPTION WHEN NO_DATA_FOUND THEN
1005: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1006: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Relationship');
1007: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'object_id '||l_geography_id||',object_type '||l_geography_type||' and relationship_type MASTER_REF');
1008: FND_MSG_PUB.ADD;
1009: RAISE FND_API.G_EXC_ERROR;
1010: END;
1011:

Line 1015: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_SINGLE_PARENT' );

1011:
1012:
1013: -- if there exists only one parent then do not update
1014: IF (l_parent_count = 1 AND p_status = 'I') THEN
1015: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_SINGLE_PARENT' );
1016: FND_MESSAGE.SET_TOKEN( 'REL_ID', p_relationship_id);
1017: FND_MESSAGE.SET_TOKEN( 'GEO_ID', l_geography_id);
1018: FND_MSG_PUB.ADD;
1019: RAISE FND_API.G_EXC_ERROR;

Line 1016: FND_MESSAGE.SET_TOKEN( 'REL_ID', p_relationship_id);

1012:
1013: -- if there exists only one parent then do not update
1014: IF (l_parent_count = 1 AND p_status = 'I') THEN
1015: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_SINGLE_PARENT' );
1016: FND_MESSAGE.SET_TOKEN( 'REL_ID', p_relationship_id);
1017: FND_MESSAGE.SET_TOKEN( 'GEO_ID', l_geography_id);
1018: FND_MSG_PUB.ADD;
1019: RAISE FND_API.G_EXC_ERROR;
1020: --l_update_flag := 'N';

Line 1017: FND_MESSAGE.SET_TOKEN( 'GEO_ID', l_geography_id);

1013: -- if there exists only one parent then do not update
1014: IF (l_parent_count = 1 AND p_status = 'I') THEN
1015: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_SINGLE_PARENT' );
1016: FND_MESSAGE.SET_TOKEN( 'REL_ID', p_relationship_id);
1017: FND_MESSAGE.SET_TOKEN( 'GEO_ID', l_geography_id);
1018: FND_MSG_PUB.ADD;
1019: RAISE FND_API.G_EXC_ERROR;
1020: --l_update_flag := 'N';
1021: END IF;

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

1193: FROM HZ_GEOGRAPHIES
1194: WHERE geography_id = p_geo_identifier_rec.geography_id;
1195:
1196: EXCEPTION when no_data_found THEN
1197: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
1198: fnd_message.set_token('TOKEN1','Geography record');
1199: fnd_message.set_token('TOKEN2','geography_id '||p_geo_identifier_rec.geography_id);
1200: fnd_msg_pub.add;
1201: RAISE FND_API.G_EXC_ERROR;

Line 1198: fnd_message.set_token('TOKEN1','Geography record');

1194: WHERE geography_id = p_geo_identifier_rec.geography_id;
1195:
1196: EXCEPTION when no_data_found THEN
1197: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
1198: fnd_message.set_token('TOKEN1','Geography record');
1199: fnd_message.set_token('TOKEN2','geography_id '||p_geo_identifier_rec.geography_id);
1200: fnd_msg_pub.add;
1201: RAISE FND_API.G_EXC_ERROR;
1202: END;

Line 1199: fnd_message.set_token('TOKEN2','geography_id '||p_geo_identifier_rec.geography_id);

1195:
1196: EXCEPTION when no_data_found THEN
1197: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
1198: fnd_message.set_token('TOKEN1','Geography record');
1199: fnd_message.set_token('TOKEN2','geography_id '||p_geo_identifier_rec.geography_id);
1200: fnd_msg_pub.add;
1201: RAISE FND_API.G_EXC_ERROR;
1202: END;
1203:

Line 1252: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');

1248: AND UPPER(identifier_value) = UPPER(p_geo_identifier_rec.identifier_value)
1249: AND geography_type = 'COUNTRY';
1250:
1251: IF l_count > 0 THEN
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');
1253: FND_MESSAGE.SET_TOKEN('IDEN_VAL', p_geo_identifier_rec.identifier_value);
1254: FND_MSG_PUB.ADD;
1255: x_return_status := fnd_api.g_ret_sts_error;
1256: RAISE FND_API.G_EXC_ERROR;

Line 1253: FND_MESSAGE.SET_TOKEN('IDEN_VAL', p_geo_identifier_rec.identifier_value);

1249: AND geography_type = 'COUNTRY';
1250:
1251: IF l_count > 0 THEN
1252: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');
1253: FND_MESSAGE.SET_TOKEN('IDEN_VAL', p_geo_identifier_rec.identifier_value);
1254: FND_MSG_PUB.ADD;
1255: x_return_status := fnd_api.g_ret_sts_error;
1256: RAISE FND_API.G_EXC_ERROR;
1257: END IF;

Line 1265: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_SUBTYPE' );

1261:
1262: -- Primary name should be of subtype 'STANDARD_NAME'
1263: IF (p_geo_identifier_rec.identifier_type = 'NAME' AND p_geo_identifier_rec.primary_flag = 'Y') THEN
1264: IF p_geo_identifier_rec.identifier_subtype <> 'STANDARD_NAME' THEN
1265: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_SUBTYPE' );
1266: FND_MESSAGE.SET_TOKEN( 'SUBTYPE', p_geo_identifier_rec.identifier_subtype);
1267: FND_MSG_PUB.ADD;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: RAISE FND_API.G_EXC_ERROR;

Line 1266: FND_MESSAGE.SET_TOKEN( 'SUBTYPE', p_geo_identifier_rec.identifier_subtype);

1262: -- Primary name should be of subtype 'STANDARD_NAME'
1263: IF (p_geo_identifier_rec.identifier_type = 'NAME' AND p_geo_identifier_rec.primary_flag = 'Y') THEN
1264: IF p_geo_identifier_rec.identifier_subtype <> 'STANDARD_NAME' THEN
1265: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_INVALID_SUBTYPE' );
1266: FND_MESSAGE.SET_TOKEN( 'SUBTYPE', p_geo_identifier_rec.identifier_subtype);
1267: FND_MSG_PUB.ADD;
1268: x_return_status := FND_API.G_RET_STS_ERROR;
1269: RAISE FND_API.G_EXC_ERROR;
1270: END IF;

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

1369: --dbms_output.put_line('after getting geo_element_column'||l_geo_element_col);
1370: EXCEPTION
1371: WHEN NO_DATA_FOUND THEN
1372: --dbms_output.put_line('in the error');
1373: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
1374: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography structure level');
1375: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||to_char(l_count)||',country_code: '||l_country_code||',geography_type: '||l_geography_type);
1376: FND_MSG_PUB.ADD;
1377: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1374: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography structure level');

1370: EXCEPTION
1371: WHEN NO_DATA_FOUND THEN
1372: --dbms_output.put_line('in the error');
1373: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
1374: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography structure level');
1375: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||to_char(l_count)||',country_code: '||l_country_code||',geography_type: '||l_geography_type);
1376: FND_MSG_PUB.ADD;
1377: x_return_status := FND_API.G_RET_STS_ERROR;
1378: END;

Line 1375: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||to_char(l_count)||',country_code: '||l_country_code||',geography_type: '||l_geography_type);

1371: WHEN NO_DATA_FOUND THEN
1372: --dbms_output.put_line('in the error');
1373: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
1374: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography structure level');
1375: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||to_char(l_count)||',country_code: '||l_country_code||',geography_type: '||l_geography_type);
1376: FND_MSG_PUB.ADD;
1377: x_return_status := FND_API.G_RET_STS_ERROR;
1378: END;
1379: END IF;

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

1511: FOR UPDATE of geography_id NOWAIT;
1512:
1513: --validate object_version_number
1514: IF l_object_version_number <> p_object_version_number THEN
1515: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1516: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_identifiers');
1517: FND_MSG_PUB.ADD;
1518: RAISE FND_API.G_EXC_ERROR;
1519: ELSE

Line 1516: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_identifiers');

1512:
1513: --validate object_version_number
1514: IF l_object_version_number <> p_object_version_number THEN
1515: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1516: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_identifiers');
1517: FND_MSG_PUB.ADD;
1518: RAISE FND_API.G_EXC_ERROR;
1519: ELSE
1520: p_object_version_number := l_object_version_number + 1;

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

1520: p_object_version_number := l_object_version_number + 1;
1521: END IF;
1522:
1523: EXCEPTION WHEN NO_DATA_FOUND THEN
1524: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1525: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1526: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geo_identifier_rec.geography_id||', identifier_type: '||
1527: p_geo_identifier_rec.identifier_type||', identifier_subtype: '||p_geo_identifier_rec.identifier_subtype||', identifier_value: '||
1528: p_geo_identifier_rec.identifier_value||', language_code: '||p_geo_identifier_rec.language_code);

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

1521: END IF;
1522:
1523: EXCEPTION WHEN NO_DATA_FOUND THEN
1524: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1525: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1526: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geo_identifier_rec.geography_id||', identifier_type: '||
1527: p_geo_identifier_rec.identifier_type||', identifier_subtype: '||p_geo_identifier_rec.identifier_subtype||', identifier_value: '||
1528: p_geo_identifier_rec.identifier_value||', language_code: '||p_geo_identifier_rec.language_code);
1529: FND_MSG_PUB.ADD;

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

1522:
1523: EXCEPTION WHEN NO_DATA_FOUND THEN
1524: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1525: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1526: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geo_identifier_rec.geography_id||', identifier_type: '||
1527: p_geo_identifier_rec.identifier_type||', identifier_subtype: '||p_geo_identifier_rec.identifier_subtype||', identifier_value: '||
1528: p_geo_identifier_rec.identifier_value||', language_code: '||p_geo_identifier_rec.language_code);
1529: FND_MSG_PUB.ADD;
1530: RAISE FND_API.G_EXC_ERROR;

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

1553: l_new_geo_subtype := p_geo_identifier_rec.new_identifier_subtype;
1554: -- validate new subtype
1555: IF (l_new_geo_subtype IS NOT NULL) THEN
1556: IF (p_geo_identifier_rec.new_identifier_subtype <> 'STANDARD_NAME') THEN
1557: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
1558: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );
1559: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'HZ_GEO_IDENTIFIER_SUBTYPE' );
1560: FND_MSG_PUB.ADD;
1561: x_return_status := FND_API.G_RET_STS_ERROR;

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

1554: -- validate new subtype
1555: IF (l_new_geo_subtype IS NOT NULL) THEN
1556: IF (p_geo_identifier_rec.new_identifier_subtype <> 'STANDARD_NAME') THEN
1557: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
1558: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );
1559: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'HZ_GEO_IDENTIFIER_SUBTYPE' );
1560: FND_MSG_PUB.ADD;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: END IF;

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

1555: IF (l_new_geo_subtype IS NOT NULL) THEN
1556: IF (p_geo_identifier_rec.new_identifier_subtype <> 'STANDARD_NAME') THEN
1557: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
1558: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );
1559: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'HZ_GEO_IDENTIFIER_SUBTYPE' );
1560: FND_MSG_PUB.ADD;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: END IF;
1563: l_subtype_updated := 'Y';

Line 1611: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');

1607: AND ROWID <> l_rowid ;
1608:
1609: IF l_count > 0 THEN
1610:
1611: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1612: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1613: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1614: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1615: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);

Line 1612: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');

1608:
1609: IF l_count > 0 THEN
1610:
1611: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1612: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1613: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1614: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1615: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1616: FND_MSG_PUB.ADD;

Line 1613: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);

1609: IF l_count > 0 THEN
1610:
1611: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1612: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1613: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1614: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1615: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1616: FND_MSG_PUB.ADD;
1617: x_return_status := fnd_api.g_ret_sts_error;

Line 1614: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);

1610:
1611: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1612: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1613: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1614: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1615: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1616: FND_MSG_PUB.ADD;
1617: x_return_status := fnd_api.g_ret_sts_error;
1618: RAISE FND_API.G_EXC_ERROR;

Line 1615: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);

1611: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1612: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1613: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1614: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1615: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1616: FND_MSG_PUB.ADD;
1617: x_return_status := fnd_api.g_ret_sts_error;
1618: RAISE FND_API.G_EXC_ERROR;
1619: EXIT;

Line 1640: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');

1636: AND ROWID <> l_rowid ;
1637:
1638: IF l_count > 0 THEN
1639:
1640: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1641: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1642: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1643: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1644: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);

Line 1641: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');

1637:
1638: IF l_count > 0 THEN
1639:
1640: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1641: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1642: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1643: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1644: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1645: FND_MSG_PUB.ADD;

Line 1642: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);

1638: IF l_count > 0 THEN
1639:
1640: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1641: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1642: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1643: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1644: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1645: FND_MSG_PUB.ADD;
1646: x_return_status := fnd_api.g_ret_sts_error;

Line 1643: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);

1639:
1640: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1641: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1642: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1643: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1644: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1645: FND_MSG_PUB.ADD;
1646: x_return_status := fnd_api.g_ret_sts_error;
1647: RAISE FND_API.G_EXC_ERROR;

Line 1644: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);

1640: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1641: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1642: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1643: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1644: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1645: FND_MSG_PUB.ADD;
1646: x_return_status := fnd_api.g_ret_sts_error;
1647: RAISE FND_API.G_EXC_ERROR;
1648: EXIT;

Line 1665: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');

1661: AND geography_type = 'COUNTRY'
1662: AND rowid <> l_rowid;
1663:
1664: IF l_count > 0 THEN
1665: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');
1666: FND_MESSAGE.SET_TOKEN('IDEN_VAL', l_new_geo_value);
1667: FND_MSG_PUB.ADD;
1668: x_return_status := fnd_api.g_ret_sts_error;
1669: RAISE FND_API.G_EXC_ERROR;

Line 1666: FND_MESSAGE.SET_TOKEN('IDEN_VAL', l_new_geo_value);

1662: AND rowid <> l_rowid;
1663:
1664: IF l_count > 0 THEN
1665: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');
1666: FND_MESSAGE.SET_TOKEN('IDEN_VAL', l_new_geo_value);
1667: FND_MSG_PUB.ADD;
1668: x_return_status := fnd_api.g_ret_sts_error;
1669: RAISE FND_API.G_EXC_ERROR;
1670: END IF;

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

1675: END IF;
1676:
1677: --do not allow the updation of primary_flag from 'Y' to 'N'
1678: IF (l_old_primary_flag = 'Y' AND p_geo_identifier_rec.primary_flag = 'N') THEN
1679: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1680: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'primary_flag from Y to N');
1681: FND_MSG_PUB.ADD;
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: RAISE FND_API.G_EXC_ERROR;

Line 1680: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'primary_flag from Y to N');

1676:
1677: --do not allow the updation of primary_flag from 'Y' to 'N'
1678: IF (l_old_primary_flag = 'Y' AND p_geo_identifier_rec.primary_flag = 'N') THEN
1679: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1680: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'primary_flag from Y to N');
1681: FND_MSG_PUB.ADD;
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;

Line 1800: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NONDELETEABLE' );

1796: AND language_code = p_language_code;
1797:
1798: IF l_primary_flag = 'Y' THEN
1799: l_delete_flag := 'N';
1800: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NONDELETEABLE' );
1801: FND_MSG_PUB.ADD;
1802: x_return_status := FND_API.G_RET_STS_ERROR;
1803: RAISE FND_API.G_EXC_ERROR;
1804: END IF;

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

1838: );
1839: END IF;
1840:
1841: EXCEPTION WHEN NO_DATA_FOUND THEN
1842: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1843: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1844: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geography_id||', identifier_type: '||
1845: p_identifier_type||', identifier_subtype: '||p_identifier_subtype||', identifier_value: '||
1846: p_identifier_value||', language_code: '||p_language_code);

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

1839: END IF;
1840:
1841: EXCEPTION WHEN NO_DATA_FOUND THEN
1842: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1843: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1844: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geography_id||', identifier_type: '||
1845: p_identifier_type||', identifier_subtype: '||p_identifier_subtype||', identifier_value: '||
1846: p_identifier_value||', language_code: '||p_language_code);
1847: FND_MSG_PUB.ADD;

Line 1844: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geography_id||', identifier_type: '||

1840:
1841: EXCEPTION WHEN NO_DATA_FOUND THEN
1842: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1843: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1844: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geography_id||', identifier_type: '||
1845: p_identifier_type||', identifier_subtype: '||p_identifier_subtype||', identifier_value: '||
1846: p_identifier_value||', language_code: '||p_language_code);
1847: FND_MSG_PUB.ADD;
1848: RAISE FND_API.G_EXC_ERROR;

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

2115: FOR UPDATE of geography_id NOWAIT;
2116:
2117: --validate object_version_number
2118: IF l_object_version_number <> p_object_version_number THEN
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2120: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geographies');
2121: FND_MSG_PUB.ADD;
2122: RAISE FND_API.G_EXC_ERROR;
2123: ELSE

Line 2120: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geographies');

2116:
2117: --validate object_version_number
2118: IF l_object_version_number <> p_object_version_number THEN
2119: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2120: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geographies');
2121: FND_MSG_PUB.ADD;
2122: RAISE FND_API.G_EXC_ERROR;
2123: ELSE
2124: p_object_version_number := l_object_version_number + 1;

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

2124: p_object_version_number := l_object_version_number + 1;
2125: END IF;
2126:
2127: EXCEPTION WHEN NO_DATA_FOUND THEN
2128: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
2129: FND_MESSAGE.SET_TOKEN('TOKEN1','geography');
2130: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id '||p_geography_id);
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;

Line 2129: FND_MESSAGE.SET_TOKEN('TOKEN1','geography');

2125: END IF;
2126:
2127: EXCEPTION WHEN NO_DATA_FOUND THEN
2128: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
2129: FND_MESSAGE.SET_TOKEN('TOKEN1','geography');
2130: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id '||p_geography_id);
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END;

Line 2130: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id '||p_geography_id);

2126:
2127: EXCEPTION WHEN NO_DATA_FOUND THEN
2128: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
2129: FND_MESSAGE.SET_TOKEN('TOKEN1','geography');
2130: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id '||p_geography_id);
2131: FND_MSG_PUB.ADD;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END;
2134: --dbms_output.put_line('start date and old end date and end date '||to_char(l_start_date,'dd-mon-yyyy')||'*'||to_char(l_end_date,'dd-mon-yyyy')||'*'||to_char(p_end_date,'dd-mon-yyyy')||'*');

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

2164: WHERE timezone_code = p_timezone_code
2165: AND rownum <2;
2166:
2167: IF l_count = 0 THEN
2168: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2169: fnd_message.set_token('FK', 'timezone_code');
2170: fnd_message.set_token('COLUMN','timezone_code');
2171: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2172: fnd_msg_pub.add;

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

2165: AND rownum <2;
2166:
2167: IF l_count = 0 THEN
2168: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2169: fnd_message.set_token('FK', 'timezone_code');
2170: fnd_message.set_token('COLUMN','timezone_code');
2171: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2172: fnd_msg_pub.add;
2173: RAISE FND_API.G_EXC_ERROR;

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

2166:
2167: IF l_count = 0 THEN
2168: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2169: fnd_message.set_token('FK', 'timezone_code');
2170: fnd_message.set_token('COLUMN','timezone_code');
2171: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2172: fnd_msg_pub.add;
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;

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

2167: IF l_count = 0 THEN
2168: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2169: fnd_message.set_token('FK', 'timezone_code');
2170: fnd_message.set_token('COLUMN','timezone_code');
2171: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2172: fnd_msg_pub.add;
2173: RAISE FND_API.G_EXC_ERROR;
2174: END IF;
2175: END IF;

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

2474: AND geography_from = p_geography_range_rec.geography_from
2475: AND to_char(start_date,'DD-MON-YYYY') = to_char(p_geography_range_rec.start_date,'DD_MON-YYYY');
2476:
2477: IF l_count > 0 THEN
2478: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2479: FND_MESSAGE.SET_TOKEN( 'COLUMN','geography_id, geography_from, start_date');
2480: FND_MSG_PUB.ADD;
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF; */

Line 2479: FND_MESSAGE.SET_TOKEN( 'COLUMN','geography_id, geography_from, start_date');

2475: AND to_char(start_date,'DD-MON-YYYY') = to_char(p_geography_range_rec.start_date,'DD_MON-YYYY');
2476:
2477: IF l_count > 0 THEN
2478: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2479: FND_MESSAGE.SET_TOKEN( 'COLUMN','geography_id, geography_from, start_date');
2480: FND_MSG_PUB.ADD;
2481: RAISE FND_API.G_EXC_ERROR;
2482: END IF; */
2483:

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

2586: FOR UPDATE OF geography_id,geography_from,start_date NOWAIT;
2587:
2588: --validate object_version_number
2589: IF l_object_version_number <> p_object_version_number THEN
2590: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2591: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_ranges');
2592: FND_MSG_PUB.ADD;
2593: RAISE FND_API.G_EXC_ERROR;
2594: ELSE

Line 2591: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_ranges');

2587:
2588: --validate object_version_number
2589: IF l_object_version_number <> p_object_version_number THEN
2590: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2591: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_ranges');
2592: FND_MSG_PUB.ADD;
2593: RAISE FND_API.G_EXC_ERROR;
2594: ELSE
2595: p_object_version_number := l_object_version_number + 1;

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

2595: p_object_version_number := l_object_version_number + 1;
2596: END IF;
2597:
2598: EXCEPTION WHEN NO_DATA_FOUND THEN
2599: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
2600: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Geography Range');
2601: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_from '||p_geography_from||', start_date '||p_start_date);
2602: FND_MSG_PUB.ADD;
2603: RAISE FND_API.G_EXC_ERROR;

Line 2600: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Geography Range');

2596: END IF;
2597:
2598: EXCEPTION WHEN NO_DATA_FOUND THEN
2599: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
2600: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Geography Range');
2601: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_from '||p_geography_from||', start_date '||p_start_date);
2602: FND_MSG_PUB.ADD;
2603: RAISE FND_API.G_EXC_ERROR;
2604:

Line 2601: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_from '||p_geography_from||', start_date '||p_start_date);

2597:
2598: EXCEPTION WHEN NO_DATA_FOUND THEN
2599: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
2600: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Geography Range');
2601: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_from '||p_geography_from||', start_date '||p_start_date);
2602: FND_MSG_PUB.ADD;
2603: RAISE FND_API.G_EXC_ERROR;
2604:
2605: END;

Line 2734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RELATIONSHIP');

2730: )
2731: AND rownum < 2;
2732:
2733: EXCEPTION WHEN NO_DATA_FOUND THEN
2734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RELATIONSHIP');
2735: FND_MESSAGE.SET_TOKEN( 'INCL_GEO_ID',p_zone_relation_tbl(i).included_geography_id);
2736: FND_MESSAGE.SET_TOKEN( 'LIM_GEO_ID', l_limited_by_geography_id );
2737: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2738: FND_MSG_PUB.ADD;

Line 2735: FND_MESSAGE.SET_TOKEN( 'INCL_GEO_ID',p_zone_relation_tbl(i).included_geography_id);

2731: AND rownum < 2;
2732:
2733: EXCEPTION WHEN NO_DATA_FOUND THEN
2734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RELATIONSHIP');
2735: FND_MESSAGE.SET_TOKEN( 'INCL_GEO_ID',p_zone_relation_tbl(i).included_geography_id);
2736: FND_MESSAGE.SET_TOKEN( 'LIM_GEO_ID', l_limited_by_geography_id );
2737: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2738: FND_MSG_PUB.ADD;
2739: RAISE FND_API.G_EXC_ERROR;

Line 2736: FND_MESSAGE.SET_TOKEN( 'LIM_GEO_ID', l_limited_by_geography_id );

2732:
2733: EXCEPTION WHEN NO_DATA_FOUND THEN
2734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RELATIONSHIP');
2735: FND_MESSAGE.SET_TOKEN( 'INCL_GEO_ID',p_zone_relation_tbl(i).included_geography_id);
2736: FND_MESSAGE.SET_TOKEN( 'LIM_GEO_ID', l_limited_by_geography_id );
2737: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2738: FND_MSG_PUB.ADD;
2739: RAISE FND_API.G_EXC_ERROR;
2740: END;

Line 2737: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);

2733: EXCEPTION WHEN NO_DATA_FOUND THEN
2734: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RELATIONSHIP');
2735: FND_MESSAGE.SET_TOKEN( 'INCL_GEO_ID',p_zone_relation_tbl(i).included_geography_id);
2736: FND_MESSAGE.SET_TOKEN( 'LIM_GEO_ID', l_limited_by_geography_id );
2737: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2738: FND_MSG_PUB.ADD;
2739: RAISE FND_API.G_EXC_ERROR;
2740: END;
2741: END IF;

Line 2795: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_OVERLAPPING_GEOGS' );

2791: AND status = 'A'
2792: AND rownum < 2;
2793:
2794: IF l_count > 0 THEN
2795: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_OVERLAPPING_GEOGS' );
2796: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2797: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2798: FND_MSG_PUB.ADD;
2799: RAISE FND_API.G_EXC_ERROR;

Line 2796: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );

2792: AND rownum < 2;
2793:
2794: IF l_count > 0 THEN
2795: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_OVERLAPPING_GEOGS' );
2796: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2797: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2798: FND_MSG_PUB.ADD;
2799: RAISE FND_API.G_EXC_ERROR;
2800: EXIT;

Line 2797: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);

2793:
2794: IF l_count > 0 THEN
2795: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_OVERLAPPING_GEOGS' );
2796: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2797: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2798: FND_MSG_PUB.ADD;
2799: RAISE FND_API.G_EXC_ERROR;
2800: EXIT;
2801: END IF;

Line 2816: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_DUPL_INCL_GEO_ID' );

2812: AND status = 'A'
2813: AND rownum <2;
2814:
2815: IF l_count > 0 THEN
2816: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_DUPL_INCL_GEO_ID' );
2817: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2818: FND_MESSAGE.SET_TOKEN( 'ZONE_ID', p_geography_id);
2819: FND_MSG_PUB.ADD;
2820: RAISE FND_API.G_EXC_ERROR;

Line 2817: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );

2813: AND rownum <2;
2814:
2815: IF l_count > 0 THEN
2816: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_DUPL_INCL_GEO_ID' );
2817: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2818: FND_MESSAGE.SET_TOKEN( 'ZONE_ID', p_geography_id);
2819: FND_MSG_PUB.ADD;
2820: RAISE FND_API.G_EXC_ERROR;
2821: EXIT;

Line 2818: FND_MESSAGE.SET_TOKEN( 'ZONE_ID', p_geography_id);

2814:
2815: IF l_count > 0 THEN
2816: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_DUPL_INCL_GEO_ID' );
2817: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2818: FND_MESSAGE.SET_TOKEN( 'ZONE_ID', p_geography_id);
2819: FND_MSG_PUB.ADD;
2820: RAISE FND_API.G_EXC_ERROR;
2821: EXIT;
2822: END IF;

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

2958: FROM hz_geography_types_b
2959: WHERE geography_type = p_zone_type;
2960:
2961: EXCEPTION WHEN NO_DATA_FOUND THEN
2962: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2963: fnd_message.set_token('FK', 'geography_type');
2964: fnd_message.set_token('COLUMN','zone_type');
2965: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2966: fnd_msg_pub.add;

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

2959: WHERE geography_type = p_zone_type;
2960:
2961: EXCEPTION WHEN NO_DATA_FOUND THEN
2962: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2963: fnd_message.set_token('FK', 'geography_type');
2964: fnd_message.set_token('COLUMN','zone_type');
2965: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2966: fnd_msg_pub.add;
2967: RAISE FND_API.G_EXC_ERROR;

Line 2964: fnd_message.set_token('COLUMN','zone_type');

2960:
2961: EXCEPTION WHEN NO_DATA_FOUND THEN
2962: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2963: fnd_message.set_token('FK', 'geography_type');
2964: fnd_message.set_token('COLUMN','zone_type');
2965: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2966: fnd_msg_pub.add;
2967: RAISE FND_API.G_EXC_ERROR;
2968: END;

Line 2965: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');

2961: EXCEPTION WHEN NO_DATA_FOUND THEN
2962: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2963: fnd_message.set_token('FK', 'geography_type');
2964: fnd_message.set_token('COLUMN','zone_type');
2965: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2966: fnd_msg_pub.add;
2967: RAISE FND_API.G_EXC_ERROR;
2968: END;
2969:

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

2974: AND geography_type = p_zone_type
2975: AND rownum <2;
2976:
2977: IF l_count > 0 THEN
2978: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2979: FND_MESSAGE.SET_TOKEN( 'COLUMN','zone name');
2980: FND_MSG_PUB.ADD;
2981: RAISE FND_API.G_EXC_ERROR;
2982: END IF;

Line 2979: FND_MESSAGE.SET_TOKEN( 'COLUMN','zone name');

2975: AND rownum <2;
2976:
2977: IF l_count > 0 THEN
2978: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2979: FND_MESSAGE.SET_TOKEN( 'COLUMN','zone name');
2980: FND_MSG_PUB.ADD;
2981: RAISE FND_API.G_EXC_ERROR;
2982: END IF;
2983:

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

2990: AND geography_type = p_zone_type
2991: AND rownum <2;
2992:
2993: IF l_count > 0 THEN
2994: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2995: FND_MESSAGE.SET_TOKEN( 'COLUMN','zone code');
2996: FND_MSG_PUB.ADD;
2997: RAISE FND_API.G_EXC_ERROR;
2998: END IF;

Line 2995: FND_MESSAGE.SET_TOKEN( 'COLUMN','zone code');

2991: AND rownum <2;
2992:
2993: IF l_count > 0 THEN
2994: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2995: FND_MESSAGE.SET_TOKEN( 'COLUMN','zone code');
2996: FND_MSG_PUB.ADD;
2997: RAISE FND_API.G_EXC_ERROR;
2998: END IF;
2999: END IF;

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

2999: END IF;
3000:
3001: -- zone_code_type is mandatory if zone_code is NOT NULL
3002: IF (p_zone_code IS NOT NULL AND p_zone_code_type IS NULL) THEN
3003: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3004: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'zone_code_type' );
3005: FND_MSG_PUB.ADD;
3006: RAISE FND_API.G_EXC_ERROR;
3007: END IF;

Line 3004: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'zone_code_type' );

3000:
3001: -- zone_code_type is mandatory if zone_code is NOT NULL
3002: IF (p_zone_code IS NOT NULL AND p_zone_code_type IS NULL) THEN
3003: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3004: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'zone_code_type' );
3005: FND_MSG_PUB.ADD;
3006: RAISE FND_API.G_EXC_ERROR;
3007: END IF;
3008:

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

3014: WHERE timezone_code = p_timezone_code
3015: AND rownum <2;
3016:
3017: IF l_count = 0 THEN
3018: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3019: fnd_message.set_token('FK', 'timezone_code');
3020: fnd_message.set_token('COLUMN','timezone_code');
3021: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3022: fnd_msg_pub.add;

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

3015: AND rownum <2;
3016:
3017: IF l_count = 0 THEN
3018: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3019: fnd_message.set_token('FK', 'timezone_code');
3020: fnd_message.set_token('COLUMN','timezone_code');
3021: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3022: fnd_msg_pub.add;
3023: RAISE FND_API.G_EXC_ERROR;

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

3016:
3017: IF l_count = 0 THEN
3018: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3019: fnd_message.set_token('FK', 'timezone_code');
3020: fnd_message.set_token('COLUMN','timezone_code');
3021: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3022: fnd_msg_pub.add;
3023: RAISE FND_API.G_EXC_ERROR;
3024: END IF;

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

3017: IF l_count = 0 THEN
3018: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3019: fnd_message.set_token('FK', 'timezone_code');
3020: fnd_message.set_token('COLUMN','timezone_code');
3021: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3022: fnd_msg_pub.add;
3023: RAISE FND_API.G_EXC_ERROR;
3024: END IF;
3025: END IF;

Line 3029: fnd_message.set_name('AR', 'HZ_GEO_NO_INCL_GEOGRAPHIES');

3025: END IF;
3026:
3027: -- there must be atleast one included geography for a zone
3028: IF p_zone_relation_tbl.count = 0 THEN
3029: fnd_message.set_name('AR', 'HZ_GEO_NO_INCL_GEOGRAPHIES');
3030: fnd_msg_pub.add;
3031: RAISE FND_API.G_EXC_ERROR;
3032: END IF;
3033:

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

3044: IF l_country_code IS NOT NULL THEN
3045: EXIT;
3046: END IF;
3047: EXCEPTION WHEN NO_DATA_FOUND THEN
3048: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD');
3049: FND_MESSAGE.SET_TOKEN( 'TOKEN1','country code');
3050: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'included_geography_id '||p_zone_relation_tbl(i).included_geography_id);
3051: FND_MSG_PUB.ADD;
3052: RAISE FND_API.G_EXC_ERROR;

Line 3049: FND_MESSAGE.SET_TOKEN( 'TOKEN1','country code');

3045: EXIT;
3046: END IF;
3047: EXCEPTION WHEN NO_DATA_FOUND THEN
3048: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD');
3049: FND_MESSAGE.SET_TOKEN( 'TOKEN1','country code');
3050: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'included_geography_id '||p_zone_relation_tbl(i).included_geography_id);
3051: FND_MSG_PUB.ADD;
3052: RAISE FND_API.G_EXC_ERROR;
3053: EXIT;

Line 3050: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'included_geography_id '||p_zone_relation_tbl(i).included_geography_id);

3046: END IF;
3047: EXCEPTION WHEN NO_DATA_FOUND THEN
3048: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD');
3049: FND_MESSAGE.SET_TOKEN( 'TOKEN1','country code');
3050: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'included_geography_id '||p_zone_relation_tbl(i).included_geography_id);
3051: FND_MSG_PUB.ADD;
3052: RAISE FND_API.G_EXC_ERROR;
3053: EXIT;
3054: END;

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

3299: WHEN OTHERS THEN
3300: --g_dup_checked := 'N';
3301: ROLLBACK TO create_master_relation;
3302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3303: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3305: FND_MSG_PUB.ADD;
3306: FND_MSG_PUB.Count_And_Get(
3307: p_encoded => FND_API.G_FALSE,

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

3300: --g_dup_checked := 'N';
3301: ROLLBACK TO create_master_relation;
3302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3303: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3304: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3305: FND_MSG_PUB.ADD;
3306: FND_MSG_PUB.Count_And_Get(
3307: p_encoded => FND_API.G_FALSE,
3308: p_count => x_msg_count,

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

3400:
3401: WHEN OTHERS THEN
3402: ROLLBACK TO update_relationship;
3403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3404: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3406: FND_MSG_PUB.ADD;
3407: FND_MSG_PUB.Count_And_Get(
3408: p_encoded => FND_API.G_FALSE,

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

3401: WHEN OTHERS THEN
3402: ROLLBACK TO update_relationship;
3403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3404: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3406: FND_MSG_PUB.ADD;
3407: FND_MSG_PUB.Count_And_Get(
3408: p_encoded => FND_API.G_FALSE,
3409: p_count => x_msg_count,

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

3500: ROLLBACK TO create_geo_identifier;
3501: x_return_status := FND_API.G_RET_STS_ERROR;
3502: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
3503: IF p_index_name = 'HZ_GEOGRAPHY_IDENTIFIERS_U1' THEN
3504: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
3505: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,identifier_type,identifier_subtype,identifier_value,language_code');
3506: FND_MSG_PUB.ADD;
3507: END IF;
3508: FND_MSG_PUB.Count_And_Get(

Line 3505: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,identifier_type,identifier_subtype,identifier_value,language_code');

3501: x_return_status := FND_API.G_RET_STS_ERROR;
3502: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
3503: IF p_index_name = 'HZ_GEOGRAPHY_IDENTIFIERS_U1' THEN
3504: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
3505: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,identifier_type,identifier_subtype,identifier_value,language_code');
3506: FND_MSG_PUB.ADD;
3507: END IF;
3508: FND_MSG_PUB.Count_And_Get(
3509: p_encoded => FND_API.G_FALSE,

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

3512:
3513: WHEN OTHERS THEN
3514: ROLLBACK TO create_geo_identifier;
3515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3516: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3517: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3518: FND_MSG_PUB.ADD;
3519: FND_MSG_PUB.Count_And_Get(
3520: p_encoded => FND_API.G_FALSE,

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

3513: WHEN OTHERS THEN
3514: ROLLBACK TO create_geo_identifier;
3515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3516: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3517: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3518: FND_MSG_PUB.ADD;
3519: FND_MSG_PUB.Count_And_Get(
3520: p_encoded => FND_API.G_FALSE,
3521: p_count => x_msg_count,

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

3617:
3618: WHEN OTHERS THEN
3619: ROLLBACK TO update_geo_identifier;
3620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3621: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3623: FND_MSG_PUB.ADD;
3624: FND_MSG_PUB.Count_And_Get(
3625: p_encoded => FND_API.G_FALSE,

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

3618: WHEN OTHERS THEN
3619: ROLLBACK TO update_geo_identifier;
3620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3621: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3622: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3623: FND_MSG_PUB.ADD;
3624: FND_MSG_PUB.Count_And_Get(
3625: p_encoded => FND_API.G_FALSE,
3626: p_count => x_msg_count,

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

3724:
3725: WHEN OTHERS THEN
3726: ROLLBACK TO delete_geo_identifier;
3727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3728: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3730: FND_MSG_PUB.ADD;
3731: FND_MSG_PUB.Count_And_Get(
3732: p_encoded => FND_API.G_FALSE,

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

3725: WHEN OTHERS THEN
3726: ROLLBACK TO delete_geo_identifier;
3727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3728: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3729: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3730: FND_MSG_PUB.ADD;
3731: FND_MSG_PUB.Count_And_Get(
3732: p_encoded => FND_API.G_FALSE,
3733: p_count => x_msg_count,

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

3826:
3827: WHEN OTHERS THEN
3828: ROLLBACK TO create_master_geography;
3829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3830: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3832: FND_MSG_PUB.ADD;
3833: FND_MSG_PUB.Count_And_Get(
3834: p_encoded => FND_API.G_FALSE,

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

3827: WHEN OTHERS THEN
3828: ROLLBACK TO create_master_geography;
3829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3830: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3831: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3832: FND_MSG_PUB.ADD;
3833: FND_MSG_PUB.Count_And_Get(
3834: p_encoded => FND_API.G_FALSE,
3835: p_count => x_msg_count,

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

3932:
3933: WHEN OTHERS THEN
3934: ROLLBACK TO update_geography;
3935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3936: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3938: FND_MSG_PUB.ADD;
3939: FND_MSG_PUB.Count_And_Get(
3940: p_encoded => FND_API.G_FALSE,

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

3933: WHEN OTHERS THEN
3934: ROLLBACK TO update_geography;
3935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3936: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3937: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3938: FND_MSG_PUB.ADD;
3939: FND_MSG_PUB.Count_And_Get(
3940: p_encoded => FND_API.G_FALSE,
3941: p_count => x_msg_count,

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

4034: ROLLBACK TO create_geography_range;
4035: x_return_status := FND_API.G_RET_STS_ERROR;
4036: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
4037: IF p_index_name = 'HZ_GEOGRAPHY_RANGES_U1' THEN
4038: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
4039: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_from and start_date');
4040: FND_MSG_PUB.ADD;
4041: END IF;
4042: FND_MSG_PUB.Count_And_Get(

Line 4039: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_from and start_date');

4035: x_return_status := FND_API.G_RET_STS_ERROR;
4036: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
4037: IF p_index_name = 'HZ_GEOGRAPHY_RANGES_U1' THEN
4038: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
4039: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_from and start_date');
4040: FND_MSG_PUB.ADD;
4041: END IF;
4042: FND_MSG_PUB.Count_And_Get(
4043: p_encoded => FND_API.G_FALSE,

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

4046:
4047: WHEN OTHERS THEN
4048: ROLLBACK TO create_geography_range;
4049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4052: FND_MSG_PUB.ADD;
4053: FND_MSG_PUB.Count_And_Get(
4054: p_encoded => FND_API.G_FALSE,

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

4047: WHEN OTHERS THEN
4048: ROLLBACK TO create_geography_range;
4049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4050: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4051: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4052: FND_MSG_PUB.ADD;
4053: FND_MSG_PUB.Count_And_Get(
4054: p_encoded => FND_API.G_FALSE,
4055: p_count => x_msg_count,

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

4155:
4156: WHEN OTHERS THEN
4157: ROLLBACK TO update_geography_range;
4158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4159: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4161: FND_MSG_PUB.ADD;
4162: FND_MSG_PUB.Count_And_Get(
4163: p_encoded => FND_API.G_FALSE,

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

4156: WHEN OTHERS THEN
4157: ROLLBACK TO update_geography_range;
4158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4159: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4161: FND_MSG_PUB.ADD;
4162: FND_MSG_PUB.Count_And_Get(
4163: p_encoded => FND_API.G_FALSE,
4164: p_count => x_msg_count,

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

4262:
4263: WHEN OTHERS THEN
4264: ROLLBACK TO create_zone_relation;
4265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4266: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4267: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4268: FND_MSG_PUB.ADD;
4269: FND_MSG_PUB.Count_And_Get(
4270: p_encoded => FND_API.G_FALSE,

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

4263: WHEN OTHERS THEN
4264: ROLLBACK TO create_zone_relation;
4265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4266: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4267: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4268: FND_MSG_PUB.ADD;
4269: FND_MSG_PUB.Count_And_Get(
4270: p_encoded => FND_API.G_FALSE,
4271: p_count => x_msg_count,

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

4400:
4401: WHEN OTHERS THEN
4402: ROLLBACK TO create_zone;
4403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4404: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4406: FND_MSG_PUB.ADD;
4407: FND_MSG_PUB.Count_And_Get(
4408: p_encoded => FND_API.G_FALSE,

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

4401: WHEN OTHERS THEN
4402: ROLLBACK TO create_zone;
4403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4404: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4405: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4406: FND_MSG_PUB.ADD;
4407: FND_MSG_PUB.Count_And_Get(
4408: p_encoded => FND_API.G_FALSE,
4409: p_count => x_msg_count,