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 948: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');

944: WHERE relationship_id = p_relationship_id
945: AND relationship_code = 'PARENT_OF';
946:
947: EXCEPTION WHEN NO_DATA_FOUND THEN
948: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
949: fnd_message.set_token('token1', 'relationship');
950: fnd_message.set_token('token1', 'relationship_id '||p_relationship_id);
951: fnd_msg_pub.add;
952: RAISE FND_API.G_EXC_ERROR;

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

945: AND relationship_code = 'PARENT_OF';
946:
947: EXCEPTION WHEN NO_DATA_FOUND THEN
948: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
949: fnd_message.set_token('token1', 'relationship');
950: fnd_message.set_token('token1', 'relationship_id '||p_relationship_id);
951: fnd_msg_pub.add;
952: RAISE FND_API.G_EXC_ERROR;
953: END;

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

946:
947: EXCEPTION WHEN NO_DATA_FOUND THEN
948: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
949: fnd_message.set_token('token1', 'relationship');
950: fnd_message.set_token('token1', 'relationship_id '||p_relationship_id);
951: fnd_msg_pub.add;
952: RAISE FND_API.G_EXC_ERROR;
953: END;
954:

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

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

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

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

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

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

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

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

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

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

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

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

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

1198: FROM HZ_GEOGRAPHIES
1199: WHERE geography_id = p_geo_identifier_rec.geography_id;
1200:
1201: EXCEPTION when no_data_found THEN
1202: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
1203: fnd_message.set_token('TOKEN1','Geography record');
1204: fnd_message.set_token('TOKEN2','geography_id '||p_geo_identifier_rec.geography_id);
1205: fnd_msg_pub.add;
1206: RAISE FND_API.G_EXC_ERROR;

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

1199: WHERE geography_id = p_geo_identifier_rec.geography_id;
1200:
1201: EXCEPTION when no_data_found THEN
1202: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
1203: fnd_message.set_token('TOKEN1','Geography record');
1204: fnd_message.set_token('TOKEN2','geography_id '||p_geo_identifier_rec.geography_id);
1205: fnd_msg_pub.add;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END;

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

1200:
1201: EXCEPTION when no_data_found THEN
1202: fnd_message.set_name('AR', 'HZ_GEO_NO_RECORD');
1203: fnd_message.set_token('TOKEN1','Geography record');
1204: fnd_message.set_token('TOKEN2','geography_id '||p_geo_identifier_rec.geography_id);
1205: fnd_msg_pub.add;
1206: RAISE FND_API.G_EXC_ERROR;
1207: END;
1208:

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

1253: AND UPPER(identifier_value) = UPPER(p_geo_identifier_rec.identifier_value)
1254: AND geography_type = 'COUNTRY';
1255:
1256: IF l_count > 0 THEN
1257: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');
1258: FND_MESSAGE.SET_TOKEN('IDEN_VAL', p_geo_identifier_rec.identifier_value);
1259: FND_MSG_PUB.ADD;
1260: x_return_status := fnd_api.g_ret_sts_error;
1261: RAISE FND_API.G_EXC_ERROR;

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

1254: AND geography_type = 'COUNTRY';
1255:
1256: IF l_count > 0 THEN
1257: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');
1258: FND_MESSAGE.SET_TOKEN('IDEN_VAL', p_geo_identifier_rec.identifier_value);
1259: FND_MSG_PUB.ADD;
1260: x_return_status := fnd_api.g_ret_sts_error;
1261: RAISE FND_API.G_EXC_ERROR;
1262: END IF;

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

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

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

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

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

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

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

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

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

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

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

1520: FOR UPDATE of geography_id NOWAIT;
1521:
1522: --validate object_version_number
1523: IF l_object_version_number <> p_object_version_number THEN
1524: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1525: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_identifiers');
1526: FND_MSG_PUB.ADD;
1527: RAISE FND_API.G_EXC_ERROR;
1528: ELSE

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

1521:
1522: --validate object_version_number
1523: IF l_object_version_number <> p_object_version_number THEN
1524: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1525: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_identifiers');
1526: FND_MSG_PUB.ADD;
1527: RAISE FND_API.G_EXC_ERROR;
1528: ELSE
1529: p_object_version_number := l_object_version_number + 1;

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

1529: p_object_version_number := l_object_version_number + 1;
1530: END IF;
1531:
1532: EXCEPTION WHEN NO_DATA_FOUND THEN
1533: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1534: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1535: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geo_identifier_rec.geography_id||', identifier_type: '||
1536: p_geo_identifier_rec.identifier_type||', identifier_subtype: '||p_geo_identifier_rec.identifier_subtype||', identifier_value: '||
1537: p_geo_identifier_rec.identifier_value||', language_code: '||p_geo_identifier_rec.language_code);

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

1530: END IF;
1531:
1532: EXCEPTION WHEN NO_DATA_FOUND THEN
1533: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1534: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1535: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geo_identifier_rec.geography_id||', identifier_type: '||
1536: p_geo_identifier_rec.identifier_type||', identifier_subtype: '||p_geo_identifier_rec.identifier_subtype||', identifier_value: '||
1537: p_geo_identifier_rec.identifier_value||', language_code: '||p_geo_identifier_rec.language_code);
1538: FND_MSG_PUB.ADD;

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

1531:
1532: EXCEPTION WHEN NO_DATA_FOUND THEN
1533: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1534: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1535: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geo_identifier_rec.geography_id||', identifier_type: '||
1536: p_geo_identifier_rec.identifier_type||', identifier_subtype: '||p_geo_identifier_rec.identifier_subtype||', identifier_value: '||
1537: p_geo_identifier_rec.identifier_value||', language_code: '||p_geo_identifier_rec.language_code);
1538: FND_MSG_PUB.ADD;
1539: RAISE FND_API.G_EXC_ERROR;

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

1562: l_new_geo_subtype := p_geo_identifier_rec.new_identifier_subtype;
1563: -- validate new subtype
1564: IF (l_new_geo_subtype IS NOT NULL) THEN
1565: IF (p_geo_identifier_rec.new_identifier_subtype <> 'STANDARD_NAME') THEN
1566: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
1567: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );
1568: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'HZ_GEO_IDENTIFIER_SUBTYPE' );
1569: FND_MSG_PUB.ADD;
1570: x_return_status := FND_API.G_RET_STS_ERROR;

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

1563: -- validate new subtype
1564: IF (l_new_geo_subtype IS NOT NULL) THEN
1565: IF (p_geo_identifier_rec.new_identifier_subtype <> 'STANDARD_NAME') THEN
1566: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
1567: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );
1568: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'HZ_GEO_IDENTIFIER_SUBTYPE' );
1569: FND_MSG_PUB.ADD;
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: END IF;

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

1564: IF (l_new_geo_subtype IS NOT NULL) THEN
1565: IF (p_geo_identifier_rec.new_identifier_subtype <> 'STANDARD_NAME') THEN
1566: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
1567: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );
1568: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'HZ_GEO_IDENTIFIER_SUBTYPE' );
1569: FND_MSG_PUB.ADD;
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: END IF;
1572: l_subtype_updated := 'Y';

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

1616: AND ROWID <> l_rowid ;
1617:
1618: IF l_count > 0 THEN
1619:
1620: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1621: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1622: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1623: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1624: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);

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

1617:
1618: IF l_count > 0 THEN
1619:
1620: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1621: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1622: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1623: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1624: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1625: FND_MSG_PUB.ADD;

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

1618: IF l_count > 0 THEN
1619:
1620: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1621: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1622: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1623: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1624: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1625: FND_MSG_PUB.ADD;
1626: x_return_status := fnd_api.g_ret_sts_error;

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

1619:
1620: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1621: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1622: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1623: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1624: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1625: FND_MSG_PUB.ADD;
1626: x_return_status := fnd_api.g_ret_sts_error;
1627: RAISE FND_API.G_EXC_ERROR;

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

1620: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1621: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'NAME');
1622: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1623: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1624: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1625: FND_MSG_PUB.ADD;
1626: x_return_status := fnd_api.g_ret_sts_error;
1627: RAISE FND_API.G_EXC_ERROR;
1628: EXIT;

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

1645: AND ROWID <> l_rowid ;
1646:
1647: IF l_count > 0 THEN
1648:
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1650: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1651: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1652: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1653: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);

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

1646:
1647: IF l_count > 0 THEN
1648:
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1650: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1651: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1652: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1653: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1654: FND_MSG_PUB.ADD;

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

1647: IF l_count > 0 THEN
1648:
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1650: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1651: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1652: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1653: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1654: FND_MSG_PUB.ADD;
1655: x_return_status := fnd_api.g_ret_sts_error;

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

1648:
1649: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1650: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1651: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1652: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1653: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1654: FND_MSG_PUB.ADD;
1655: x_return_status := fnd_api.g_ret_sts_error;
1656: RAISE FND_API.G_EXC_ERROR;

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

1649: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUPLICATE_VALUE');
1650: FND_MESSAGE.SET_TOKEN('IDENT_TYPE', 'CODE');
1651: FND_MESSAGE.SET_TOKEN('VALUE', l_new_geo_value);
1652: FND_MESSAGE.SET_TOKEN('GEO_ID', p_geo_identifier_rec.geography_id);
1653: FND_MESSAGE.SET_TOKEN('PARENT_GEO_ID', l_get_all_parents.subject_id);
1654: FND_MSG_PUB.ADD;
1655: x_return_status := fnd_api.g_ret_sts_error;
1656: RAISE FND_API.G_EXC_ERROR;
1657: EXIT;

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

1670: AND geography_type = 'COUNTRY'
1671: AND rowid <> l_rowid;
1672:
1673: IF l_count > 0 THEN
1674: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');
1675: FND_MESSAGE.SET_TOKEN('IDEN_VAL', l_new_geo_value);
1676: FND_MSG_PUB.ADD;
1677: x_return_status := fnd_api.g_ret_sts_error;
1678: RAISE FND_API.G_EXC_ERROR;

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

1671: AND rowid <> l_rowid;
1672:
1673: IF l_count > 0 THEN
1674: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_DUP_COUNTRY_IDEN');
1675: FND_MESSAGE.SET_TOKEN('IDEN_VAL', l_new_geo_value);
1676: FND_MSG_PUB.ADD;
1677: x_return_status := fnd_api.g_ret_sts_error;
1678: RAISE FND_API.G_EXC_ERROR;
1679: END IF;

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

1684: END IF;
1685:
1686: --do not allow the updation of primary_flag from 'Y' to 'N'
1687: IF (l_old_primary_flag = 'Y' AND p_geo_identifier_rec.primary_flag = 'N') THEN
1688: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1689: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'primary_flag from Y to N');
1690: FND_MSG_PUB.ADD;
1691: x_return_status := FND_API.G_RET_STS_ERROR;
1692: RAISE FND_API.G_EXC_ERROR;

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

1685:
1686: --do not allow the updation of primary_flag from 'Y' to 'N'
1687: IF (l_old_primary_flag = 'Y' AND p_geo_identifier_rec.primary_flag = 'N') THEN
1688: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_COLUMN' );
1689: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'primary_flag from Y to N');
1690: FND_MSG_PUB.ADD;
1691: x_return_status := FND_API.G_RET_STS_ERROR;
1692: RAISE FND_API.G_EXC_ERROR;
1693: END IF;

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

1809: AND language_code = p_language_code;
1810:
1811: IF l_primary_flag = 'Y' THEN
1812: l_delete_flag := 'N';
1813: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NONDELETEABLE' );
1814: FND_MSG_PUB.ADD;
1815: x_return_status := FND_API.G_RET_STS_ERROR;
1816: RAISE FND_API.G_EXC_ERROR;
1817: END IF;

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

1851: );
1852: END IF;
1853:
1854: EXCEPTION WHEN NO_DATA_FOUND THEN
1855: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1856: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1857: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geography_id||', identifier_type: '||
1858: p_identifier_type||', identifier_subtype: '||p_identifier_subtype||', identifier_value: '||
1859: p_identifier_value||', language_code: '||p_language_code);

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

1852: END IF;
1853:
1854: EXCEPTION WHEN NO_DATA_FOUND THEN
1855: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1856: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1857: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geography_id||', identifier_type: '||
1858: p_identifier_type||', identifier_subtype: '||p_identifier_subtype||', identifier_value: '||
1859: p_identifier_value||', language_code: '||p_language_code);
1860: FND_MSG_PUB.ADD;

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

1853:
1854: EXCEPTION WHEN NO_DATA_FOUND THEN
1855: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
1856: FND_MESSAGE.SET_TOKEN('TOKEN1', 'geography_identifier');
1857: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id: '||p_geography_id||', identifier_type: '||
1858: p_identifier_type||', identifier_subtype: '||p_identifier_subtype||', identifier_value: '||
1859: p_identifier_value||', language_code: '||p_language_code);
1860: FND_MSG_PUB.ADD;
1861: RAISE FND_API.G_EXC_ERROR;

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

2128: FOR UPDATE of geography_id NOWAIT;
2129:
2130: --validate object_version_number
2131: IF l_object_version_number <> p_object_version_number THEN
2132: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2133: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geographies');
2134: FND_MSG_PUB.ADD;
2135: RAISE FND_API.G_EXC_ERROR;
2136: ELSE

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

2129:
2130: --validate object_version_number
2131: IF l_object_version_number <> p_object_version_number THEN
2132: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2133: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geographies');
2134: FND_MSG_PUB.ADD;
2135: RAISE FND_API.G_EXC_ERROR;
2136: ELSE
2137: p_object_version_number := l_object_version_number + 1;

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

2137: p_object_version_number := l_object_version_number + 1;
2138: END IF;
2139:
2140: EXCEPTION WHEN NO_DATA_FOUND THEN
2141: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
2142: FND_MESSAGE.SET_TOKEN('TOKEN1','geography');
2143: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id '||p_geography_id);
2144: FND_MSG_PUB.ADD;
2145: RAISE FND_API.G_EXC_ERROR;

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

2138: END IF;
2139:
2140: EXCEPTION WHEN NO_DATA_FOUND THEN
2141: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
2142: FND_MESSAGE.SET_TOKEN('TOKEN1','geography');
2143: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id '||p_geography_id);
2144: FND_MSG_PUB.ADD;
2145: RAISE FND_API.G_EXC_ERROR;
2146: END;

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

2139:
2140: EXCEPTION WHEN NO_DATA_FOUND THEN
2141: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_RECORD');
2142: FND_MESSAGE.SET_TOKEN('TOKEN1','geography');
2143: FND_MESSAGE.SET_TOKEN('TOKEN2', 'geography_id '||p_geography_id);
2144: FND_MSG_PUB.ADD;
2145: RAISE FND_API.G_EXC_ERROR;
2146: END;
2147: --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 2181: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

2177: WHERE timezone_code = p_timezone_code
2178: AND rownum <2;
2179:
2180: IF l_count = 0 THEN
2181: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2182: fnd_message.set_token('FK', 'timezone_code');
2183: fnd_message.set_token('COLUMN','timezone_code');
2184: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2185: fnd_msg_pub.add;

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

2178: AND rownum <2;
2179:
2180: IF l_count = 0 THEN
2181: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2182: fnd_message.set_token('FK', 'timezone_code');
2183: fnd_message.set_token('COLUMN','timezone_code');
2184: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2185: fnd_msg_pub.add;
2186: RAISE FND_API.G_EXC_ERROR;

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

2179:
2180: IF l_count = 0 THEN
2181: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2182: fnd_message.set_token('FK', 'timezone_code');
2183: fnd_message.set_token('COLUMN','timezone_code');
2184: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2185: fnd_msg_pub.add;
2186: RAISE FND_API.G_EXC_ERROR;
2187: END IF;

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

2180: IF l_count = 0 THEN
2181: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2182: fnd_message.set_token('FK', 'timezone_code');
2183: fnd_message.set_token('COLUMN','timezone_code');
2184: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
2185: fnd_msg_pub.add;
2186: RAISE FND_API.G_EXC_ERROR;
2187: END IF;
2188: END IF;

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

2487: AND geography_from = p_geography_range_rec.geography_from
2488: AND to_char(start_date,'DD-MON-YYYY') = to_char(p_geography_range_rec.start_date,'DD_MON-YYYY');
2489:
2490: IF l_count > 0 THEN
2491: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2492: FND_MESSAGE.SET_TOKEN( 'COLUMN','geography_id, geography_from, start_date');
2493: FND_MSG_PUB.ADD;
2494: RAISE FND_API.G_EXC_ERROR;
2495: END IF; */

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

2488: AND to_char(start_date,'DD-MON-YYYY') = to_char(p_geography_range_rec.start_date,'DD_MON-YYYY');
2489:
2490: IF l_count > 0 THEN
2491: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
2492: FND_MESSAGE.SET_TOKEN( 'COLUMN','geography_id, geography_from, start_date');
2493: FND_MSG_PUB.ADD;
2494: RAISE FND_API.G_EXC_ERROR;
2495: END IF; */
2496:

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

2599: FOR UPDATE OF geography_id,geography_from,start_date NOWAIT;
2600:
2601: --validate object_version_number
2602: IF l_object_version_number <> p_object_version_number THEN
2603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2604: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_ranges');
2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: ELSE

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

2600:
2601: --validate object_version_number
2602: IF l_object_version_number <> p_object_version_number THEN
2603: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2604: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_geography_ranges');
2605: FND_MSG_PUB.ADD;
2606: RAISE FND_API.G_EXC_ERROR;
2607: ELSE
2608: p_object_version_number := l_object_version_number + 1;

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

2608: p_object_version_number := l_object_version_number + 1;
2609: END IF;
2610:
2611: EXCEPTION WHEN NO_DATA_FOUND THEN
2612: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
2613: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Geography Range');
2614: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_from '||p_geography_from||', start_date '||p_start_date);
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;

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

2609: END IF;
2610:
2611: EXCEPTION WHEN NO_DATA_FOUND THEN
2612: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
2613: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Geography Range');
2614: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_from '||p_geography_from||', start_date '||p_start_date);
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617:

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

2610:
2611: EXCEPTION WHEN NO_DATA_FOUND THEN
2612: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD' );
2613: FND_MESSAGE.SET_TOKEN( 'TOKEN1', 'Geography Range');
2614: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'geography_id '||p_geography_id||', geography_from '||p_geography_from||', start_date '||p_start_date);
2615: FND_MSG_PUB.ADD;
2616: RAISE FND_API.G_EXC_ERROR;
2617:
2618: END;

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

2743: )
2744: AND rownum < 2;
2745:
2746: EXCEPTION WHEN NO_DATA_FOUND THEN
2747: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RELATIONSHIP');
2748: FND_MESSAGE.SET_TOKEN( 'INCL_GEO_ID',p_zone_relation_tbl(i).included_geography_id);
2749: FND_MESSAGE.SET_TOKEN( 'LIM_GEO_ID', l_limited_by_geography_id );
2750: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2751: FND_MSG_PUB.ADD;

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

2744: AND rownum < 2;
2745:
2746: EXCEPTION WHEN NO_DATA_FOUND THEN
2747: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RELATIONSHIP');
2748: FND_MESSAGE.SET_TOKEN( 'INCL_GEO_ID',p_zone_relation_tbl(i).included_geography_id);
2749: FND_MESSAGE.SET_TOKEN( 'LIM_GEO_ID', l_limited_by_geography_id );
2750: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2751: FND_MSG_PUB.ADD;
2752: RAISE FND_API.G_EXC_ERROR;

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

2745:
2746: EXCEPTION WHEN NO_DATA_FOUND THEN
2747: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RELATIONSHIP');
2748: FND_MESSAGE.SET_TOKEN( 'INCL_GEO_ID',p_zone_relation_tbl(i).included_geography_id);
2749: FND_MESSAGE.SET_TOKEN( 'LIM_GEO_ID', l_limited_by_geography_id );
2750: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2751: FND_MSG_PUB.ADD;
2752: RAISE FND_API.G_EXC_ERROR;
2753: END;

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

2746: EXCEPTION WHEN NO_DATA_FOUND THEN
2747: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RELATIONSHIP');
2748: FND_MESSAGE.SET_TOKEN( 'INCL_GEO_ID',p_zone_relation_tbl(i).included_geography_id);
2749: FND_MESSAGE.SET_TOKEN( 'LIM_GEO_ID', l_limited_by_geography_id );
2750: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2751: FND_MSG_PUB.ADD;
2752: RAISE FND_API.G_EXC_ERROR;
2753: END;
2754: END IF;

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

2804: AND status = 'A'
2805: AND rownum < 2;
2806:
2807: IF l_count > 0 THEN
2808: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_OVERLAPPING_GEOGS' );
2809: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2810: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2811: FND_MSG_PUB.ADD;
2812: RAISE FND_API.G_EXC_ERROR;

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

2805: AND rownum < 2;
2806:
2807: IF l_count > 0 THEN
2808: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_OVERLAPPING_GEOGS' );
2809: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2810: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2811: FND_MSG_PUB.ADD;
2812: RAISE FND_API.G_EXC_ERROR;
2813: EXIT;

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

2806:
2807: IF l_count > 0 THEN
2808: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_OVERLAPPING_GEOGS' );
2809: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2810: FND_MESSAGE.SET_TOKEN( 'ZONE_TYPE', l_zone_type);
2811: FND_MSG_PUB.ADD;
2812: RAISE FND_API.G_EXC_ERROR;
2813: EXIT;
2814: END IF;

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

2825: AND status = 'A'
2826: AND rownum <2;
2827:
2828: IF l_count > 0 THEN
2829: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_DUPL_INCL_GEO_ID' );
2830: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2831: FND_MESSAGE.SET_TOKEN( 'ZONE_ID', p_geography_id);
2832: FND_MSG_PUB.ADD;
2833: RAISE FND_API.G_EXC_ERROR;

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

2826: AND rownum <2;
2827:
2828: IF l_count > 0 THEN
2829: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_DUPL_INCL_GEO_ID' );
2830: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2831: FND_MESSAGE.SET_TOKEN( 'ZONE_ID', p_geography_id);
2832: FND_MSG_PUB.ADD;
2833: RAISE FND_API.G_EXC_ERROR;
2834: EXIT;

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

2827:
2828: IF l_count > 0 THEN
2829: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_DUPL_INCL_GEO_ID' );
2830: FND_MESSAGE.SET_TOKEN( 'GEO_ID',p_zone_relation_tbl(i).included_geography_id );
2831: FND_MESSAGE.SET_TOKEN( 'ZONE_ID', p_geography_id);
2832: FND_MSG_PUB.ADD;
2833: RAISE FND_API.G_EXC_ERROR;
2834: EXIT;
2835: END IF;

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

2971: FROM hz_geography_types_b
2972: WHERE geography_type = p_zone_type;
2973:
2974: EXCEPTION WHEN NO_DATA_FOUND THEN
2975: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2976: fnd_message.set_token('FK', 'geography_type');
2977: fnd_message.set_token('COLUMN','zone_type');
2978: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2979: fnd_msg_pub.add;

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

2972: WHERE geography_type = p_zone_type;
2973:
2974: EXCEPTION WHEN NO_DATA_FOUND THEN
2975: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2976: fnd_message.set_token('FK', 'geography_type');
2977: fnd_message.set_token('COLUMN','zone_type');
2978: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2979: fnd_msg_pub.add;
2980: RAISE FND_API.G_EXC_ERROR;

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

2973:
2974: EXCEPTION WHEN NO_DATA_FOUND THEN
2975: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2976: fnd_message.set_token('FK', 'geography_type');
2977: fnd_message.set_token('COLUMN','zone_type');
2978: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2979: fnd_msg_pub.add;
2980: RAISE FND_API.G_EXC_ERROR;
2981: END;

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

2974: EXCEPTION WHEN NO_DATA_FOUND THEN
2975: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
2976: fnd_message.set_token('FK', 'geography_type');
2977: fnd_message.set_token('COLUMN','zone_type');
2978: fnd_message.set_token('TABLE','HZ_GEOGRAPHY_TYPES_B');
2979: fnd_msg_pub.add;
2980: RAISE FND_API.G_EXC_ERROR;
2981: END;
2982:

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

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

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

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

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

3003: AND geography_type = p_zone_type
3004: AND rownum <2;
3005:
3006: IF l_count > 0 THEN
3007: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
3008: FND_MESSAGE.SET_TOKEN( 'COLUMN','zone code');
3009: FND_MSG_PUB.ADD;
3010: RAISE FND_API.G_EXC_ERROR;
3011: END IF;

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

3004: AND rownum <2;
3005:
3006: IF l_count > 0 THEN
3007: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
3008: FND_MESSAGE.SET_TOKEN( 'COLUMN','zone code');
3009: FND_MSG_PUB.ADD;
3010: RAISE FND_API.G_EXC_ERROR;
3011: END IF;
3012: END IF;

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

3012: END IF;
3013:
3014: -- zone_code_type is mandatory if zone_code is NOT NULL
3015: IF (p_zone_code IS NOT NULL AND p_zone_code_type IS NULL) THEN
3016: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3017: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'zone_code_type' );
3018: FND_MSG_PUB.ADD;
3019: RAISE FND_API.G_EXC_ERROR;
3020: END IF;

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

3013:
3014: -- zone_code_type is mandatory if zone_code is NOT NULL
3015: IF (p_zone_code IS NOT NULL AND p_zone_code_type IS NULL) THEN
3016: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3017: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'zone_code_type' );
3018: FND_MSG_PUB.ADD;
3019: RAISE FND_API.G_EXC_ERROR;
3020: END IF;
3021:

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

3027: WHERE timezone_code = p_timezone_code
3028: AND rownum <2;
3029:
3030: IF l_count = 0 THEN
3031: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3032: fnd_message.set_token('FK', 'timezone_code');
3033: fnd_message.set_token('COLUMN','timezone_code');
3034: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3035: fnd_msg_pub.add;

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

3028: AND rownum <2;
3029:
3030: IF l_count = 0 THEN
3031: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3032: fnd_message.set_token('FK', 'timezone_code');
3033: fnd_message.set_token('COLUMN','timezone_code');
3034: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3035: fnd_msg_pub.add;
3036: RAISE FND_API.G_EXC_ERROR;

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

3029:
3030: IF l_count = 0 THEN
3031: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3032: fnd_message.set_token('FK', 'timezone_code');
3033: fnd_message.set_token('COLUMN','timezone_code');
3034: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3035: fnd_msg_pub.add;
3036: RAISE FND_API.G_EXC_ERROR;
3037: END IF;

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

3030: IF l_count = 0 THEN
3031: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
3032: fnd_message.set_token('FK', 'timezone_code');
3033: fnd_message.set_token('COLUMN','timezone_code');
3034: fnd_message.set_token('TABLE','FND_TIMEZONES_B');
3035: fnd_msg_pub.add;
3036: RAISE FND_API.G_EXC_ERROR;
3037: END IF;
3038: END IF;

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

3038: END IF;
3039:
3040: -- there must be atleast one included geography for a zone
3041: IF p_zone_relation_tbl.count = 0 THEN
3042: fnd_message.set_name('AR', 'HZ_GEO_NO_INCL_GEOGRAPHIES');
3043: fnd_msg_pub.add;
3044: RAISE FND_API.G_EXC_ERROR;
3045: END IF;
3046:

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

3057: IF l_country_code IS NOT NULL THEN
3058: EXIT;
3059: END IF;
3060: EXCEPTION WHEN NO_DATA_FOUND THEN
3061: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD');
3062: FND_MESSAGE.SET_TOKEN( 'TOKEN1','country code');
3063: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'included_geography_id '||p_zone_relation_tbl(i).included_geography_id);
3064: FND_MSG_PUB.ADD;
3065: RAISE FND_API.G_EXC_ERROR;

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

3058: EXIT;
3059: END IF;
3060: EXCEPTION WHEN NO_DATA_FOUND THEN
3061: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD');
3062: FND_MESSAGE.SET_TOKEN( 'TOKEN1','country code');
3063: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'included_geography_id '||p_zone_relation_tbl(i).included_geography_id);
3064: FND_MSG_PUB.ADD;
3065: RAISE FND_API.G_EXC_ERROR;
3066: EXIT;

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

3059: END IF;
3060: EXCEPTION WHEN NO_DATA_FOUND THEN
3061: FND_MESSAGE.SET_NAME( 'AR', 'HZ_GEO_NO_RECORD');
3062: FND_MESSAGE.SET_TOKEN( 'TOKEN1','country code');
3063: FND_MESSAGE.SET_TOKEN( 'TOKEN2', 'included_geography_id '||p_zone_relation_tbl(i).included_geography_id);
3064: FND_MSG_PUB.ADD;
3065: RAISE FND_API.G_EXC_ERROR;
3066: EXIT;
3067: END;

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

3312: WHEN OTHERS THEN
3313: --g_dup_checked := 'N';
3314: ROLLBACK TO create_master_relation;
3315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3316: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3318: FND_MSG_PUB.ADD;
3319: FND_MSG_PUB.Count_And_Get(
3320: p_encoded => FND_API.G_FALSE,

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

3313: --g_dup_checked := 'N';
3314: ROLLBACK TO create_master_relation;
3315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3316: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3317: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3318: FND_MSG_PUB.ADD;
3319: FND_MSG_PUB.Count_And_Get(
3320: p_encoded => FND_API.G_FALSE,
3321: p_count => x_msg_count,

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

3413:
3414: WHEN OTHERS THEN
3415: ROLLBACK TO update_relationship;
3416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3419: FND_MSG_PUB.ADD;
3420: FND_MSG_PUB.Count_And_Get(
3421: p_encoded => FND_API.G_FALSE,

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

3414: WHEN OTHERS THEN
3415: ROLLBACK TO update_relationship;
3416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3419: FND_MSG_PUB.ADD;
3420: FND_MSG_PUB.Count_And_Get(
3421: p_encoded => FND_API.G_FALSE,
3422: p_count => x_msg_count,

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

3513: ROLLBACK TO create_geo_identifier;
3514: x_return_status := FND_API.G_RET_STS_ERROR;
3515: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
3516: IF p_index_name = 'HZ_GEOGRAPHY_IDENTIFIERS_U1' THEN
3517: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
3518: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,identifier_type,identifier_subtype,identifier_value,language_code');
3519: FND_MSG_PUB.ADD;
3520: END IF;
3521: FND_MSG_PUB.Count_And_Get(

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

3514: x_return_status := FND_API.G_RET_STS_ERROR;
3515: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
3516: IF p_index_name = 'HZ_GEOGRAPHY_IDENTIFIERS_U1' THEN
3517: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
3518: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,identifier_type,identifier_subtype,identifier_value,language_code');
3519: FND_MSG_PUB.ADD;
3520: END IF;
3521: FND_MSG_PUB.Count_And_Get(
3522: p_encoded => FND_API.G_FALSE,

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

3525:
3526: WHEN OTHERS THEN
3527: ROLLBACK TO create_geo_identifier;
3528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3529: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3531: FND_MSG_PUB.ADD;
3532: FND_MSG_PUB.Count_And_Get(
3533: p_encoded => FND_API.G_FALSE,

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

3526: WHEN OTHERS THEN
3527: ROLLBACK TO create_geo_identifier;
3528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3529: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3530: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3531: FND_MSG_PUB.ADD;
3532: FND_MSG_PUB.Count_And_Get(
3533: p_encoded => FND_API.G_FALSE,
3534: p_count => x_msg_count,

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

3630:
3631: WHEN OTHERS THEN
3632: ROLLBACK TO update_geo_identifier;
3633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3634: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3635: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3636: FND_MSG_PUB.ADD;
3637: FND_MSG_PUB.Count_And_Get(
3638: p_encoded => FND_API.G_FALSE,

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

3631: WHEN OTHERS THEN
3632: ROLLBACK TO update_geo_identifier;
3633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3634: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3635: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3636: FND_MSG_PUB.ADD;
3637: FND_MSG_PUB.Count_And_Get(
3638: p_encoded => FND_API.G_FALSE,
3639: p_count => x_msg_count,

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

3737:
3738: WHEN OTHERS THEN
3739: ROLLBACK TO delete_geo_identifier;
3740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3741: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3742: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3743: FND_MSG_PUB.ADD;
3744: FND_MSG_PUB.Count_And_Get(
3745: p_encoded => FND_API.G_FALSE,

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

3738: WHEN OTHERS THEN
3739: ROLLBACK TO delete_geo_identifier;
3740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3741: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3742: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3743: FND_MSG_PUB.ADD;
3744: FND_MSG_PUB.Count_And_Get(
3745: p_encoded => FND_API.G_FALSE,
3746: p_count => x_msg_count,

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

3839:
3840: WHEN OTHERS THEN
3841: ROLLBACK TO create_master_geography;
3842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3843: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3845: FND_MSG_PUB.ADD;
3846: FND_MSG_PUB.Count_And_Get(
3847: p_encoded => FND_API.G_FALSE,

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

3840: WHEN OTHERS THEN
3841: ROLLBACK TO create_master_geography;
3842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3843: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3845: FND_MSG_PUB.ADD;
3846: FND_MSG_PUB.Count_And_Get(
3847: p_encoded => FND_API.G_FALSE,
3848: p_count => x_msg_count,

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

3945:
3946: WHEN OTHERS THEN
3947: ROLLBACK TO update_geography;
3948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3949: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3950: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3951: FND_MSG_PUB.ADD;
3952: FND_MSG_PUB.Count_And_Get(
3953: p_encoded => FND_API.G_FALSE,

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

3946: WHEN OTHERS THEN
3947: ROLLBACK TO update_geography;
3948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3949: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3950: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3951: FND_MSG_PUB.ADD;
3952: FND_MSG_PUB.Count_And_Get(
3953: p_encoded => FND_API.G_FALSE,
3954: p_count => x_msg_count,

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

4047: ROLLBACK TO create_geography_range;
4048: x_return_status := FND_API.G_RET_STS_ERROR;
4049: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
4050: IF p_index_name = 'HZ_GEOGRAPHY_RANGES_U1' THEN
4051: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
4052: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_from and start_date');
4053: FND_MSG_PUB.ADD;
4054: END IF;
4055: FND_MSG_PUB.Count_And_Get(

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

4048: x_return_status := FND_API.G_RET_STS_ERROR;
4049: HZ_UTILITY_V2PUB.find_index_name(p_index_name);
4050: IF p_index_name = 'HZ_GEOGRAPHY_RANGES_U1' THEN
4051: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
4052: FND_MESSAGE.SET_TOKEN('COLUMN', 'geography_id,geography_from and start_date');
4053: FND_MSG_PUB.ADD;
4054: END IF;
4055: FND_MSG_PUB.Count_And_Get(
4056: p_encoded => FND_API.G_FALSE,

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

4059:
4060: WHEN OTHERS THEN
4061: ROLLBACK TO create_geography_range;
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4065: FND_MSG_PUB.ADD;
4066: FND_MSG_PUB.Count_And_Get(
4067: p_encoded => FND_API.G_FALSE,

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

4060: WHEN OTHERS THEN
4061: ROLLBACK TO create_geography_range;
4062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4063: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4064: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4065: FND_MSG_PUB.ADD;
4066: FND_MSG_PUB.Count_And_Get(
4067: p_encoded => FND_API.G_FALSE,
4068: p_count => x_msg_count,

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

4168:
4169: WHEN OTHERS THEN
4170: ROLLBACK TO update_geography_range;
4171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4174: FND_MSG_PUB.ADD;
4175: FND_MSG_PUB.Count_And_Get(
4176: p_encoded => FND_API.G_FALSE,

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

4169: WHEN OTHERS THEN
4170: ROLLBACK TO update_geography_range;
4171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4172: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4173: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4174: FND_MSG_PUB.ADD;
4175: FND_MSG_PUB.Count_And_Get(
4176: p_encoded => FND_API.G_FALSE,
4177: p_count => x_msg_count,

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

4275:
4276: WHEN OTHERS THEN
4277: ROLLBACK TO create_zone_relation;
4278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4280: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4281: FND_MSG_PUB.ADD;
4282: FND_MSG_PUB.Count_And_Get(
4283: p_encoded => FND_API.G_FALSE,

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

4276: WHEN OTHERS THEN
4277: ROLLBACK TO create_zone_relation;
4278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4279: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4280: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4281: FND_MSG_PUB.ADD;
4282: FND_MSG_PUB.Count_And_Get(
4283: p_encoded => FND_API.G_FALSE,
4284: p_count => x_msg_count,

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

4413:
4414: WHEN OTHERS THEN
4415: ROLLBACK TO create_zone;
4416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4419: FND_MSG_PUB.ADD;
4420: FND_MSG_PUB.Count_And_Get(
4421: p_encoded => FND_API.G_FALSE,

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

4414: WHEN OTHERS THEN
4415: ROLLBACK TO create_zone;
4416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4417: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
4418: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
4419: FND_MSG_PUB.ADD;
4420: FND_MSG_PUB.Count_And_Get(
4421: p_encoded => FND_API.G_FALSE,
4422: p_count => x_msg_count,