APPS.CSI_GIS_INSTANCE_LOC_UTL_PKG dependencies on FND_MESSAGE

Line 89: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_FOUND');

85: csi_t_gen_utility_pvt.add( 'Instance Type:'||l_instance_type);
86:
87: EXCEPTION WHEN NO_DATA_FOUND THEN
88: csi_t_gen_utility_pvt.add( 'Instance does not exist in csi_item_instances');
89: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_FOUND');
90: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
91: FND_MSG_PUB.ADD;
92: x_return_status := FND_API.G_RET_STS_ERROR;
93: return;

Line 90: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);

86:
87: EXCEPTION WHEN NO_DATA_FOUND THEN
88: csi_t_gen_utility_pvt.add( 'Instance does not exist in csi_item_instances');
89: FND_MESSAGE.SET_NAME('CSI','CSI_INSTANCE_NOT_FOUND');
90: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
91: FND_MSG_PUB.ADD;
92: x_return_status := FND_API.G_RET_STS_ERROR;
93: return;
94:

Line 110: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_CAPTL_REBUILD');

106:
107:
108: IF l_csi_item_type NOT IN (1,3) THEN
109: -- Raise error
110: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_CAPTL_REBUILD');
111: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
112: FND_MSG_PUB.ADD;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: return;

Line 111: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);

107:
108: IF l_csi_item_type NOT IN (1,3) THEN
109: -- Raise error
110: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_CAPTL_REBUILD');
111: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
112: FND_MSG_PUB.ADD;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: return;
115:

Line 119: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_SERIALIZED');

115:
116: END IF;
117:
118: IF l_serial_number_control_code = 1 THEN
119: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_SERIALIZED');
120: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
121: FND_MSG_PUB.ADD;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: return;

Line 120: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);

116: END IF;
117:
118: IF l_serial_number_control_code = 1 THEN
119: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_NOT_SERIALIZED');
120: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
121: FND_MSG_PUB.ADD;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: return;
124: END IF;

Line 127: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_ROUTE_CNT_GEOCODE');

123: return;
124: END IF;
125:
126: IF nvl(l_network_asset_flag,'N') = 'Y' THEN
127: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_ROUTE_CNT_GEOCODE');
128: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
129: FND_MSG_PUB.ADD;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: return;

Line 128: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);

124: END IF;
125:
126: IF nvl(l_network_asset_flag,'N') = 'Y' THEN
127: FND_MESSAGE.SET_NAME('CSI','CSI_ASSET_ROUTE_CNT_GEOCODE');
128: FND_MESSAGE.SET_TOKEN('INSTANCE',l_instance_number);
129: FND_MSG_PUB.ADD;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: return;
132: END IF;

Line 254: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LAT_VALUE');

250: END IF;
251:
252: IF p_mode = 'LAT' THEN
253: IF NOT (x_value BETWEEN -90 AND +90) THEN
254: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LAT_VALUE');
255: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
256: FND_MSG_PUB.ADD;
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: return;

Line 255: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

251:
252: IF p_mode = 'LAT' THEN
253: IF NOT (x_value BETWEEN -90 AND +90) THEN
254: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LAT_VALUE');
255: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
256: FND_MSG_PUB.ADD;
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: return;
259: END IF;

Line 262: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LON_VALUE');

258: return;
259: END IF;
260: ELSIF p_mode = 'LON' THEN
261: IF NOT (x_value BETWEEN -180 AND +180) THEN
262: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LON_VALUE');
263: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
264: FND_MSG_PUB.ADD;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: return;

Line 263: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

259: END IF;
260: ELSIF p_mode = 'LON' THEN
261: IF NOT (x_value BETWEEN -180 AND +180) THEN
262: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LON_VALUE');
263: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
264: FND_MSG_PUB.ADD;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: return;
267: END IF;

Line 303: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');

299:
300:
301: IF p_geocode_format = 'DMS' THEN
302: IF (NOT(l_d_pos < l_m_pos and l_m_pos < l_s_pos)) OR (substr(l_value,l_s_pos + 1) IS NOT NULL) THEN
303: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');
304: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
305: IF p_mode = 'LAT' THEN
306: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
307: ELSE

Line 304: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

300:
301: IF p_geocode_format = 'DMS' THEN
302: IF (NOT(l_d_pos < l_m_pos and l_m_pos < l_s_pos)) OR (substr(l_value,l_s_pos + 1) IS NOT NULL) THEN
303: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');
304: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
305: IF p_mode = 'LAT' THEN
306: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
307: ELSE
308: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 306: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

302: IF (NOT(l_d_pos < l_m_pos and l_m_pos < l_s_pos)) OR (substr(l_value,l_s_pos + 1) IS NOT NULL) THEN
303: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');
304: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
305: IF p_mode = 'LAT' THEN
306: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
307: ELSE
308: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
309: END IF;
310: FND_MSG_PUB.ADD;

Line 308: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

304: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
305: IF p_mode = 'LAT' THEN
306: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
307: ELSE
308: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
309: END IF;
310: FND_MSG_PUB.ADD;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: RETURN;

Line 316: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');

312: RETURN;
313: END IF;
314: ELSE
315: IF (NOT(l_d_pos < l_m_pos) or (l_s_pos > 0) or (substr(l_value,l_m_pos + 1) IS NOT NULL)) THEN
316: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
317: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
318: IF p_mode = 'LAT' THEN
319: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
320: ELSE

Line 317: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

313: END IF;
314: ELSE
315: IF (NOT(l_d_pos < l_m_pos) or (l_s_pos > 0) or (substr(l_value,l_m_pos + 1) IS NOT NULL)) THEN
316: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
317: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
318: IF p_mode = 'LAT' THEN
319: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
320: ELSE
321: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 319: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

315: IF (NOT(l_d_pos < l_m_pos) or (l_s_pos > 0) or (substr(l_value,l_m_pos + 1) IS NOT NULL)) THEN
316: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
317: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
318: IF p_mode = 'LAT' THEN
319: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
320: ELSE
321: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
322: END IF;
323: FND_MSG_PUB.ADD;

Line 321: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

317: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
318: IF p_mode = 'LAT' THEN
319: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
320: ELSE
321: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
322: END IF;
323: FND_MSG_PUB.ADD;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: RETURN;

Line 341: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DEGREE_VALUE');

337: RAISE Invalid_Decimal;
338: END IF;
339:
340: IF l_degrees < 0 THEN
341: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DEGREE_VALUE');
342: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
343: IF p_mode = 'LAT' THEN
344: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
345: ELSE

Line 342: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

338: END IF;
339:
340: IF l_degrees < 0 THEN
341: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DEGREE_VALUE');
342: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
343: IF p_mode = 'LAT' THEN
344: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
345: ELSE
346: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 344: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

340: IF l_degrees < 0 THEN
341: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DEGREE_VALUE');
342: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
343: IF p_mode = 'LAT' THEN
344: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
345: ELSE
346: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
347: END IF;
348: FND_MSG_PUB.ADD;

Line 346: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

342: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
343: IF p_mode = 'LAT' THEN
344: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
345: ELSE
346: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
347: END IF;
348: FND_MSG_PUB.ADD;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: return;

Line 355: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DEGREE_VALUE');

351: END IF;
352:
353: EXCEPTION
354: WHEN INVALID_NUMBER THEN
355: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DEGREE_VALUE');
356: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
357: IF p_mode = 'LAT' THEN
358: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
359: ELSE

Line 356: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

352:
353: EXCEPTION
354: WHEN INVALID_NUMBER THEN
355: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DEGREE_VALUE');
356: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
357: IF p_mode = 'LAT' THEN
358: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
359: ELSE
360: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 358: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

354: WHEN INVALID_NUMBER THEN
355: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DEGREE_VALUE');
356: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
357: IF p_mode = 'LAT' THEN
358: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
359: ELSE
360: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
361: END IF;
362: FND_MSG_PUB.ADD;

Line 360: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

356: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
357: IF p_mode = 'LAT' THEN
358: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
359: ELSE
360: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
361: END IF;
362: FND_MSG_PUB.ADD;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: RETURN;

Line 366: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_DEGREE_VALUE');

362: FND_MSG_PUB.ADD;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: RETURN;
365: WHEN Invalid_Decimal THEN
366: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_DEGREE_VALUE');
367: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
368: IF p_mode = 'LAT' THEN
369: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
370: ELSE

Line 367: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

363: x_return_status := FND_API.G_RET_STS_ERROR;
364: RETURN;
365: WHEN Invalid_Decimal THEN
366: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_DEGREE_VALUE');
367: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
368: IF p_mode = 'LAT' THEN
369: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
370: ELSE
371: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 369: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

365: WHEN Invalid_Decimal THEN
366: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_DEGREE_VALUE');
367: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
368: IF p_mode = 'LAT' THEN
369: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
370: ELSE
371: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
372: END IF;
373: FND_MSG_PUB.ADD;

Line 371: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

367: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
368: IF p_mode = 'LAT' THEN
369: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
370: ELSE
371: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
372: END IF;
373: FND_MSG_PUB.ADD;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: RETURN;

Line 391: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_MINUTES_VALUE');

387: END IF;
388:
389: END IF;
390: IF l_minutes < 0 OR l_minutes > 59 THEN
391: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_MINUTES_VALUE');
392: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
393: IF p_mode = 'LAT' THEN
394: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
395: ELSE

Line 392: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

388:
389: END IF;
390: IF l_minutes < 0 OR l_minutes > 59 THEN
391: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_MINUTES_VALUE');
392: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
393: IF p_mode = 'LAT' THEN
394: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
395: ELSE
396: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 394: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

390: IF l_minutes < 0 OR l_minutes > 59 THEN
391: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_MINUTES_VALUE');
392: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
393: IF p_mode = 'LAT' THEN
394: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
395: ELSE
396: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
397: END IF;
398: FND_MSG_PUB.ADD;

Line 396: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

392: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
393: IF p_mode = 'LAT' THEN
394: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
395: ELSE
396: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
397: END IF;
398: FND_MSG_PUB.ADD;
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: return;

Line 405: FND_MESSAGE.SET_NAME('CSI','CSI_INV_MINUTES_VALUE');

401: END IF;
402:
403: EXCEPTION
404: WHEN INVALID_NUMBER THEN
405: FND_MESSAGE.SET_NAME('CSI','CSI_INV_MINUTES_VALUE');
406: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
407: IF p_mode = 'LAT' THEN
408: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
409: ELSE

Line 406: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

402:
403: EXCEPTION
404: WHEN INVALID_NUMBER THEN
405: FND_MESSAGE.SET_NAME('CSI','CSI_INV_MINUTES_VALUE');
406: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
407: IF p_mode = 'LAT' THEN
408: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
409: ELSE
410: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 408: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

404: WHEN INVALID_NUMBER THEN
405: FND_MESSAGE.SET_NAME('CSI','CSI_INV_MINUTES_VALUE');
406: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
407: IF p_mode = 'LAT' THEN
408: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
409: ELSE
410: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
411: END IF;
412: FND_MSG_PUB.ADD;

Line 410: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

406: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
407: IF p_mode = 'LAT' THEN
408: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
409: ELSE
410: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
411: END IF;
412: FND_MSG_PUB.ADD;
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: RETURN;

Line 416: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_MINUTES_VALUE');

412: FND_MSG_PUB.ADD;
413: x_return_status := FND_API.G_RET_STS_ERROR;
414: RETURN;
415: WHEN Invalid_Decimal THEN
416: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_MINUTES_VALUE');
417: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
418: IF p_mode = 'LAT' THEN
419: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
420: ELSE

Line 417: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

413: x_return_status := FND_API.G_RET_STS_ERROR;
414: RETURN;
415: WHEN Invalid_Decimal THEN
416: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_MINUTES_VALUE');
417: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
418: IF p_mode = 'LAT' THEN
419: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
420: ELSE
421: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 419: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

415: WHEN Invalid_Decimal THEN
416: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_MINUTES_VALUE');
417: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
418: IF p_mode = 'LAT' THEN
419: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
420: ELSE
421: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
422: END IF;
423: FND_MSG_PUB.ADD;

Line 421: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

417: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
418: IF p_mode = 'LAT' THEN
419: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
420: ELSE
421: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
422: END IF;
423: FND_MSG_PUB.ADD;
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: RETURN;

Line 436: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_SECONDS_VALUE');

432: INTO l_seconds
433: FROM DUAL;
434:
435: IF l_seconds < 0 OR l_seconds > 59 THEN
436: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_SECONDS_VALUE');
437: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
438: IF p_mode = 'LAT' THEN
439: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
440: ELSE

Line 437: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

433: FROM DUAL;
434:
435: IF l_seconds < 0 OR l_seconds > 59 THEN
436: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_SECONDS_VALUE');
437: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
438: IF p_mode = 'LAT' THEN
439: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
440: ELSE
441: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 439: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

435: IF l_seconds < 0 OR l_seconds > 59 THEN
436: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_SECONDS_VALUE');
437: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
438: IF p_mode = 'LAT' THEN
439: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
440: ELSE
441: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
442: END IF;
443: FND_MSG_PUB.ADD;

Line 441: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

437: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
438: IF p_mode = 'LAT' THEN
439: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
440: ELSE
441: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
442: END IF;
443: FND_MSG_PUB.ADD;
444: x_return_status := FND_API.G_RET_STS_ERROR;
445: return;

Line 450: FND_MESSAGE.SET_NAME('CSI','CSI_INV_SECONDS_VALUE');

446: END IF;
447:
448: EXCEPTION
449: WHEN INVALID_NUMBER THEN
450: FND_MESSAGE.SET_NAME('CSI','CSI_INV_SECONDS_VALUE');
451: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
452: IF p_mode = 'LAT' THEN
453: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
454: ELSE

Line 451: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

447:
448: EXCEPTION
449: WHEN INVALID_NUMBER THEN
450: FND_MESSAGE.SET_NAME('CSI','CSI_INV_SECONDS_VALUE');
451: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
452: IF p_mode = 'LAT' THEN
453: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
454: ELSE
455: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

Line 453: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

449: WHEN INVALID_NUMBER THEN
450: FND_MESSAGE.SET_NAME('CSI','CSI_INV_SECONDS_VALUE');
451: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
452: IF p_mode = 'LAT' THEN
453: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
454: ELSE
455: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
456: END IF;
457: FND_MSG_PUB.ADD;

Line 455: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

451: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
452: IF p_mode = 'LAT' THEN
453: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
454: ELSE
455: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
456: END IF;
457: FND_MSG_PUB.ADD;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: RETURN;

Line 535: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_DD_VALUE');

531: INTO l_latitude_value
532: FROM DUAL;
533: EXCEPTION
534: WHEN INVALID_NUMBER THEN
535: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_DD_VALUE');
536: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
537: FND_MSG_PUB.ADD;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: return;

Line 536: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

532: FROM DUAL;
533: EXCEPTION
534: WHEN INVALID_NUMBER THEN
535: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_DD_VALUE');
536: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
537: FND_MSG_PUB.ADD;
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: return;
540: END;

Line 547: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LONG_DD_VALUE');

543: INTO l_longitude_value
544: FROM DUAL;
545: EXCEPTION
546: WHEN INVALID_NUMBER THEN
547: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LONG_DD_VALUE');
548: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
549: FND_MSG_PUB.ADD;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: return;

Line 548: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

544: FROM DUAL;
545: EXCEPTION
546: WHEN INVALID_NUMBER THEN
547: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LONG_DD_VALUE');
548: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
549: FND_MSG_PUB.ADD;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: return;
552: END;

Line 555: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LAT_VALUE');

551: return;
552: END;
553:
554: IF NOT (l_latitude_value BETWEEN -90 AND +90) THEN
555: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LAT_VALUE');
556: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
557: FND_MSG_PUB.ADD;
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: return;

Line 556: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

552: END;
553:
554: IF NOT (l_latitude_value BETWEEN -90 AND +90) THEN
555: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LAT_VALUE');
556: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
557: FND_MSG_PUB.ADD;
558: x_return_status := FND_API.G_RET_STS_ERROR;
559: return;
560: END IF;

Line 562: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LON_VALUE');

558: x_return_status := FND_API.G_RET_STS_ERROR;
559: return;
560: END IF;
561: IF NOT (l_longitude_value BETWEEN -180 AND +180) THEN
562: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LON_VALUE');
563: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
564: FND_MSG_PUB.ADD;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: return;

Line 563: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

559: return;
560: END IF;
561: IF NOT (l_longitude_value BETWEEN -180 AND +180) THEN
562: FND_MESSAGE.SET_NAME('CSI','CSI_OOR_LON_VALUE');
563: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
564: FND_MSG_PUB.ADD;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: return;
567: END IF;

Line 576: FND_MESSAGE.SET_NAME('CSI','CSI_INV_CHAR_LAT_VALUE');

572:
573: l_char:=substr(l_latitude,i,1);
574:
575: IF l_char NOT IN ('0','1','2','3','4','5','6','7','8','9','N','S','E','W','D','M','S',' ','+','-','.') THEN
576: FND_MESSAGE.SET_NAME('CSI','CSI_INV_CHAR_LAT_VALUE');
577: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
578: FND_MSG_PUB.ADD;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: l_error_count :=l_error_count + 1;

Line 577: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

573: l_char:=substr(l_latitude,i,1);
574:
575: IF l_char NOT IN ('0','1','2','3','4','5','6','7','8','9','N','S','E','W','D','M','S',' ','+','-','.') THEN
576: FND_MESSAGE.SET_NAME('CSI','CSI_INV_CHAR_LAT_VALUE');
577: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
578: FND_MSG_PUB.ADD;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: l_error_count :=l_error_count + 1;
581: return;

Line 589: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_VALUE');

585: l_direction_count := l_direction_count + 1;
586: END IF;
587:
588: IF i <> 1 and l_char in ('+','-') THEN
589: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_VALUE');
590: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
591: FND_MSG_PUB.ADD;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: return;

Line 590: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

586: END IF;
587:
588: IF i <> 1 and l_char in ('+','-') THEN
589: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_VALUE');
590: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
591: FND_MSG_PUB.ADD;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: return;
594: END IF;

Line 598: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_VALUE');

594: END IF;
595:
596: IF p_geocode_format = 'DMS' THEN
597: IF l_direction_count > 2 THEN
598: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_VALUE');
599: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
600: FND_MSG_PUB.ADD;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: l_error_count :=l_error_count + 1;

Line 599: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

595:
596: IF p_geocode_format = 'DMS' THEN
597: IF l_direction_count > 2 THEN
598: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_VALUE');
599: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
600: FND_MSG_PUB.ADD;
601: x_return_status := FND_API.G_RET_STS_ERROR;
602: l_error_count :=l_error_count + 1;
603: return;

Line 608: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_VALUE');

604: END IF;
605:
606: ELSIF p_geocode_format = 'DM' THEN
607: IF l_direction_count > 1 THEN
608: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_VALUE');
609: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
610: FND_MSG_PUB.ADD;
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: l_error_count :=l_error_count + 1;

Line 609: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

605:
606: ELSIF p_geocode_format = 'DM' THEN
607: IF l_direction_count > 1 THEN
608: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_VALUE');
609: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
610: FND_MSG_PUB.ADD;
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: l_error_count :=l_error_count + 1;
613: return;

Line 628: FND_MESSAGE.SET_NAME('CSI','CSI_INV_CHAR_LONG_VALUE');

624:
625: l_char:=substr(l_longitude,i,1);
626:
627: IF l_char NOT IN ('0','1','2','3','4','5','6','7','8','9','N','S','E','W','D','M','S',' ','+','-','.') THEN
628: FND_MESSAGE.SET_NAME('CSI','CSI_INV_CHAR_LONG_VALUE');
629: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
630: FND_MSG_PUB.ADD;
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: return;

Line 629: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

625: l_char:=substr(l_longitude,i,1);
626:
627: IF l_char NOT IN ('0','1','2','3','4','5','6','7','8','9','N','S','E','W','D','M','S',' ','+','-','.') THEN
628: FND_MESSAGE.SET_NAME('CSI','CSI_INV_CHAR_LONG_VALUE');
629: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
630: FND_MSG_PUB.ADD;
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: return;
633: END IF;

Line 640: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_VALUE');

636: l_direction_count := l_direction_count + 1;
637: END IF;
638:
639: IF i <> 1 and l_char in ('+','-') THEN
640: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_VALUE');
641: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
642: FND_MSG_PUB.ADD;
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: return;

Line 641: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

637: END IF;
638:
639: IF i <> 1 and l_char in ('+','-') THEN
640: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_VALUE');
641: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
642: FND_MSG_PUB.ADD;
643: x_return_status := FND_API.G_RET_STS_ERROR;
644: return;
645: END IF;

Line 649: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_VALUE');

645: END IF;
646:
647: IF p_geocode_format = 'DMS' THEN
648: IF l_direction_count > 2 THEN
649: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_VALUE');
650: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
651: FND_MSG_PUB.ADD;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: return;

Line 650: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

646:
647: IF p_geocode_format = 'DMS' THEN
648: IF l_direction_count > 2 THEN
649: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_VALUE');
650: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
651: FND_MSG_PUB.ADD;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: return;
654: END IF;

Line 657: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_VALUE');

653: return;
654: END IF;
655: ELSIF p_geocode_format = 'DM' THEN
656: IF l_direction_count > 1 THEN
657: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_VALUE');
658: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
659: FND_MSG_PUB.ADD;
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: return;

Line 658: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

654: END IF;
655: ELSIF p_geocode_format = 'DM' THEN
656: IF l_direction_count > 1 THEN
657: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_VALUE');
658: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
659: FND_MSG_PUB.ADD;
660: x_return_status := FND_API.G_RET_STS_ERROR;
661: return;
662: END IF;

Line 669: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');

665:
666: IF p_geocode_format = 'DMS' THEN
667:
668: IF NOT (instr(l_latitude,'D') > 0 AND instr(l_latitude,'M') > 0 AND instr(l_latitude,'S') > 0) THEN
669: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');
670: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
671: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
672: FND_MSG_PUB.ADD;
673: x_return_status := FND_API.G_RET_STS_ERROR;

Line 670: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

666: IF p_geocode_format = 'DMS' THEN
667:
668: IF NOT (instr(l_latitude,'D') > 0 AND instr(l_latitude,'M') > 0 AND instr(l_latitude,'S') > 0) THEN
669: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');
670: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
671: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
672: FND_MSG_PUB.ADD;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: return;

Line 671: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

667:
668: IF NOT (instr(l_latitude,'D') > 0 AND instr(l_latitude,'M') > 0 AND instr(l_latitude,'S') > 0) THEN
669: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');
670: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
671: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
672: FND_MSG_PUB.ADD;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: return;
675: END IF;

Line 677: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');

673: x_return_status := FND_API.G_RET_STS_ERROR;
674: return;
675: END IF;
676: IF NOT (instr(l_longitude,'D') > 0 AND instr(l_longitude,'M') > 0 AND instr(l_longitude,'S') > 0) THEN
677: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');
678: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
679: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
680: FND_MSG_PUB.ADD;
681: x_return_status := FND_API.G_RET_STS_ERROR;

Line 678: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

674: return;
675: END IF;
676: IF NOT (instr(l_longitude,'D') > 0 AND instr(l_longitude,'M') > 0 AND instr(l_longitude,'S') > 0) THEN
677: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');
678: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
679: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
680: FND_MSG_PUB.ADD;
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: return;

Line 679: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

675: END IF;
676: IF NOT (instr(l_longitude,'D') > 0 AND instr(l_longitude,'M') > 0 AND instr(l_longitude,'S') > 0) THEN
677: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DMS_VALUE');
678: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
679: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
680: FND_MSG_PUB.ADD;
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: return;
683: END IF;

Line 689: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');

685:
686: ELSIF p_geocode_format = 'DM' THEN
687:
688: IF (instr(SubStr(l_latitude,1,l_latitude_length-1),'S') > 0) THEN
689: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
690: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
691: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
692: FND_MSG_PUB.ADD;
693: x_return_status := FND_API.G_RET_STS_ERROR;

Line 690: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

686: ELSIF p_geocode_format = 'DM' THEN
687:
688: IF (instr(SubStr(l_latitude,1,l_latitude_length-1),'S') > 0) THEN
689: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
690: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
691: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
692: FND_MSG_PUB.ADD;
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: return;

Line 691: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

687:
688: IF (instr(SubStr(l_latitude,1,l_latitude_length-1),'S') > 0) THEN
689: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
690: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
691: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
692: FND_MSG_PUB.ADD;
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: return;
695: END IF;

Line 698: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');

694: return;
695: END IF;
696:
697: IF (instr(SubStr(l_longitude,1,l_longitude_length-1),'S') > 0 ) THEN
698: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
699: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
700: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
701: FND_MSG_PUB.ADD;
702: x_return_status := FND_API.G_RET_STS_ERROR;

Line 699: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

695: END IF;
696:
697: IF (instr(SubStr(l_longitude,1,l_longitude_length-1),'S') > 0 ) THEN
698: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
699: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
700: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
701: FND_MSG_PUB.ADD;
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: return;

Line 700: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

696:
697: IF (instr(SubStr(l_longitude,1,l_longitude_length-1),'S') > 0 ) THEN
698: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
699: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
700: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
701: FND_MSG_PUB.ADD;
702: x_return_status := FND_API.G_RET_STS_ERROR;
703: return;
704: END IF;

Line 707: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');

703: return;
704: END IF;
705:
706: IF NOT (instr(l_latitude,'D') > 0 AND instr(l_latitude,'M') > 0 ) THEN
707: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
708: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
709: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
710: FND_MSG_PUB.ADD;
711: x_return_status := FND_API.G_RET_STS_ERROR;

Line 708: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

704: END IF;
705:
706: IF NOT (instr(l_latitude,'D') > 0 AND instr(l_latitude,'M') > 0 ) THEN
707: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
708: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
709: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
710: FND_MSG_PUB.ADD;
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: return;

Line 709: FND_MESSAGE.SET_TOKEN('ORD','Latitude');

705:
706: IF NOT (instr(l_latitude,'D') > 0 AND instr(l_latitude,'M') > 0 ) THEN
707: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
708: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
709: FND_MESSAGE.SET_TOKEN('ORD','Latitude');
710: FND_MSG_PUB.ADD;
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: return;
713: END IF;

Line 716: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');

712: return;
713: END IF;
714:
715: IF NOT (instr(l_longitude,'D') > 0 AND instr(l_longitude,'M') > 0 ) THEN
716: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
717: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
718: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
719: FND_MSG_PUB.ADD;
720: x_return_status := FND_API.G_RET_STS_ERROR;

Line 717: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

713: END IF;
714:
715: IF NOT (instr(l_longitude,'D') > 0 AND instr(l_longitude,'M') > 0 ) THEN
716: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
717: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
718: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
719: FND_MSG_PUB.ADD;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: return;

Line 718: FND_MESSAGE.SET_TOKEN('ORD','Longitude');

714:
715: IF NOT (instr(l_longitude,'D') > 0 AND instr(l_longitude,'M') > 0 ) THEN
716: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_LAT_LONG_DM_VALUE');
717: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
718: FND_MESSAGE.SET_TOKEN('ORD','Longitude');
719: FND_MSG_PUB.ADD;
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: return;
722: END IF;

Line 730: FND_MESSAGE.SET_NAME('CSI','CSI_LAT_LONG_DIFF_FORMAT');

726:
727:
728: IF (l_latitude_direction = 'A' and NOT(l_longitude_direction = 'A')) OR
729: (l_longitude_direction = 'A' and NOT(l_latitude_direction = 'A')) THEN
730: FND_MESSAGE.SET_NAME('CSI','CSI_LAT_LONG_DIFF_FORMAT');
731: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
732: FND_MSG_PUB.ADD;
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: return;

Line 731: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

727:
728: IF (l_latitude_direction = 'A' and NOT(l_longitude_direction = 'A')) OR
729: (l_longitude_direction = 'A' and NOT(l_latitude_direction = 'A')) THEN
730: FND_MESSAGE.SET_NAME('CSI','CSI_LAT_LONG_DIFF_FORMAT');
731: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
732: FND_MSG_PUB.ADD;
733: x_return_status := FND_API.G_RET_STS_ERROR;
734: return;
735: END IF;

Line 738: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_DIRECTION');

734: return;
735: END IF;
736:
737: IF l_latitude_direction NOT IN ('N','S','A') THEN
738: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_DIRECTION');
739: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
740: FND_MSG_PUB.ADD;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: return;

Line 739: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

735: END IF;
736:
737: IF l_latitude_direction NOT IN ('N','S','A') THEN
738: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_DIRECTION');
739: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
740: FND_MSG_PUB.ADD;
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: return;
743: END IF;

Line 747: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_NEG_VALUE');

743: END IF;
744:
745: IF l_latitude_sign = '-' THEN
746: IF l_latitude_direction = 'N' THEN
747: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_NEG_VALUE');
748: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
749: FND_MSG_PUB.ADD;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: return;

Line 748: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

744:
745: IF l_latitude_sign = '-' THEN
746: IF l_latitude_direction = 'N' THEN
747: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LAT_NEG_VALUE');
748: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
749: FND_MSG_PUB.ADD;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: return;
752: END IF;

Line 756: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_DIRECTION');

752: END IF;
753: END IF;
754:
755: IF l_longitude_direction NOT IN ('E','W','A') THEN
756: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_DIRECTION');
757: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
758: FND_MSG_PUB.ADD;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: return;

Line 757: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

753: END IF;
754:
755: IF l_longitude_direction NOT IN ('E','W','A') THEN
756: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_DIRECTION');
757: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
758: FND_MSG_PUB.ADD;
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: return;
761: END IF;

Line 765: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_NEG_VALUE');

761: END IF;
762:
763: IF l_longitude_sign = '-' THEN
764: IF l_longitude_direction = 'E' THEN
765: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_NEG_VALUE');
766: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
767: FND_MSG_PUB.ADD;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: return;

Line 766: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);

762:
763: IF l_longitude_sign = '-' THEN
764: IF l_longitude_direction = 'E' THEN
765: FND_MESSAGE.SET_NAME('CSI','CSI_INV_LON_NEG_VALUE');
766: FND_MESSAGE.SET_TOKEN('INSTANCE',p_instance_number);
767: FND_MSG_PUB.ADD;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: return;
770: END IF;