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.CSI_GIS_INSTANCE_LOC_UTL_PKG dependencies on FND_MSG_PUB

Line 91: FND_MSG_PUB.ADD;

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:
95: END;

Line 112: FND_MSG_PUB.ADD;

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

Line 121: FND_MSG_PUB.ADD;

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

Line 129: FND_MSG_PUB.ADD;

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

Line 256: FND_MSG_PUB.ADD;

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;
260: ELSIF p_mode = 'LON' THEN

Line 264: FND_MSG_PUB.ADD;

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

Line 310: FND_MSG_PUB.ADD;

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;
313: END IF;
314: ELSE

Line 323: FND_MSG_PUB.ADD;

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;
326: END IF;
327: END IF;

Line 348: FND_MSG_PUB.ADD;

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;
351: END IF;
352:

Line 362: FND_MSG_PUB.ADD;

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;
365: WHEN Invalid_Decimal THEN
366: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_DEGREE_VALUE');

Line 373: FND_MSG_PUB.ADD;

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;
376: END;
377:

Line 398: FND_MSG_PUB.ADD;

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;
401: END IF;
402:

Line 412: FND_MSG_PUB.ADD;

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;
415: WHEN Invalid_Decimal THEN
416: FND_MESSAGE.SET_NAME('CSI','CSI_INV_DECIMAL_MINUTES_VALUE');

Line 423: FND_MSG_PUB.ADD;

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;
426: END;
427:

Line 443: FND_MSG_PUB.ADD;

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;
446: END IF;
447:

Line 457: FND_MSG_PUB.ADD;

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;
460: END;
461: END IF;

Line 537: FND_MSG_PUB.ADD;

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;
541: BEGIN

Line 549: FND_MSG_PUB.ADD;

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

Line 557: FND_MSG_PUB.ADD;

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;
561: IF NOT (l_longitude_value BETWEEN -180 AND +180) THEN

Line 564: FND_MSG_PUB.ADD;

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

Line 578: FND_MSG_PUB.ADD;

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

Line 591: FND_MSG_PUB.ADD;

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

Line 600: FND_MSG_PUB.ADD;

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

Line 610: FND_MSG_PUB.ADD;

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

Line 630: FND_MSG_PUB.ADD;

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

Line 642: FND_MSG_PUB.ADD;

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

Line 651: FND_MSG_PUB.ADD;

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;
655: ELSIF p_geocode_format = 'DM' THEN

Line 659: FND_MSG_PUB.ADD;

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

Line 672: FND_MSG_PUB.ADD;

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;
676: IF NOT (instr(l_longitude,'D') > 0 AND instr(l_longitude,'M') > 0 AND instr(l_longitude,'S') > 0) THEN

Line 680: FND_MSG_PUB.ADD;

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

Line 692: FND_MSG_PUB.ADD;

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

Line 701: FND_MSG_PUB.ADD;

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

Line 710: FND_MSG_PUB.ADD;

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

Line 719: FND_MSG_PUB.ADD;

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

Line 732: FND_MSG_PUB.ADD;

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

Line 740: FND_MSG_PUB.ADD;

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

Line 749: FND_MSG_PUB.ADD;

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

Line 758: FND_MSG_PUB.ADD;

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

Line 767: FND_MSG_PUB.ADD;

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