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.CSF_LOCUS_PUB dependencies on FND_API

Line 196: x_return_status := fnd_api.g_ret_sts_success;

192: RETURN NUMBER IS
193: RESULT VARCHAR2(6);
194: GEO_TYPE VARCHAR2(6);
195: BEGIN
196: x_return_status := fnd_api.g_ret_sts_success;
197:
198: verify_locus_local(
199: p_api_version => 1
200: , p_locus => p_geom

Line 375: RETURN fnd_api.g_true;

371: FUNCTION should_call_lf(p_geom IN MDSYS.SDO_GEOMETRY)
372: RETURN VARCHAR2 AS
373: BEGIN
374: IF p_geom IS NULL THEN
375: RETURN fnd_api.g_true;
376: ELSE
377: RETURN fnd_api.g_false;
378: END IF;
379: END should_call_lf;

Line 377: RETURN fnd_api.g_false;

373: BEGIN
374: IF p_geom IS NULL THEN
375: RETURN fnd_api.g_true;
376: ELSE
377: RETURN fnd_api.g_false;
378: END IF;
379: END should_call_lf;
380:
381: FUNCTION get_locus_segmentid(p_geom IN MDSYS.SDO_GEOMETRY)

Line 740: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

736:
737: l_from_segment_id NUMBER;
738: l_to_segment_id NUMBER;
739: BEGIN
740: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
741: RAISE fnd_api.g_exc_unexpected_error;
742: END IF;
743:
744: -- Initialize message list if p_init_msg_list is set to TRUE

Line 741: RAISE fnd_api.g_exc_unexpected_error;

737: l_from_segment_id NUMBER;
738: l_to_segment_id NUMBER;
739: BEGIN
740: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
741: RAISE fnd_api.g_exc_unexpected_error;
742: END IF;
743:
744: -- Initialize message list if p_init_msg_list is set to TRUE
745: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 745: IF fnd_api.to_boolean (p_init_msg_list) THEN

741: RAISE fnd_api.g_exc_unexpected_error;
742: END IF;
743:
744: -- Initialize message list if p_init_msg_list is set to TRUE
745: IF fnd_api.to_boolean (p_init_msg_list) THEN
746: fnd_msg_pub.initialize;
747: END IF;
748:
749: -- Initialize API return status to success

Line 750: x_return_status := fnd_api.g_ret_sts_success;

746: fnd_msg_pub.initialize;
747: END IF;
748:
749: -- Initialize API return status to success
750: x_return_status := fnd_api.g_ret_sts_success;
751:
752: l_from_segment_id := p_segment_id_tbl(p_segment_id_tbl.FIRST);
753: l_to_segment_id := p_segment_id_tbl(p_segment_id_tbl.LAST);
754:

Line 805: IF fnd_api.to_boolean(p_commit) THEN

801:
802: -- Close the CLOB
803: dbms_lob.CLOSE(l_route);
804:
805: IF fnd_api.to_boolean(p_commit) THEN
806: COMMIT;
807: END IF;
808: EXCEPTION
809: WHEN OTHERS THEN

Line 810: x_return_status := fnd_api.g_ret_sts_unexp_error;

806: COMMIT;
807: END IF;
808: EXCEPTION
809: WHEN OTHERS THEN
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
812: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
813: END IF;
814: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 841: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

837: l_srid NUMBER;
838: BEGIN
839: SAVEPOINT csf_save_locuses;
840:
841: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
842: RAISE fnd_api.g_exc_unexpected_error;
843: END IF;
844:
845: -- Initialize message list if p_init_msg_list is set to TRUE

Line 842: RAISE fnd_api.g_exc_unexpected_error;

838: BEGIN
839: SAVEPOINT csf_save_locuses;
840:
841: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
842: RAISE fnd_api.g_exc_unexpected_error;
843: END IF;
844:
845: -- Initialize message list if p_init_msg_list is set to TRUE
846: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 846: IF fnd_api.to_boolean (p_init_msg_list) THEN

842: RAISE fnd_api.g_exc_unexpected_error;
843: END IF;
844:
845: -- Initialize message list if p_init_msg_list is set to TRUE
846: IF fnd_api.to_boolean (p_init_msg_list) THEN
847: fnd_msg_pub.initialize;
848: END IF;
849:
850: -- Initialize API return status to success

Line 851: x_return_status := fnd_api.g_ret_sts_success;

847: fnd_msg_pub.initialize;
848: END IF;
849:
850: -- Initialize API return status to success
851: x_return_status := fnd_api.g_ret_sts_success;
852:
853: l_srid := NVL(p_srid, 8307);
854:
855: FORALL i IN 1..p_location_id_tbl.COUNT

Line 866: IF fnd_api.to_boolean(p_commit) THEN

862: , mdsys.sdo_ordinate_array( p_longitude_tbl(i), p_latitude_tbl(i) )
863: )
864: WHERE location_id = p_location_id_tbl(i);
865:
866: IF fnd_api.to_boolean(p_commit) THEN
867: COMMIT;
868: END IF;
869: EXCEPTION
870: WHEN OTHERS THEN

Line 872: x_return_status := fnd_api.g_ret_sts_unexp_error;

868: END IF;
869: EXCEPTION
870: WHEN OTHERS THEN
871: ROLLBACK TO csf_save_locuses;
872: x_return_status := fnd_api.g_ret_sts_unexp_error;
873: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
874: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
875: END IF;
876: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 895: IF (p_soft_validation = fnd_api.g_true) THEN

891: l_geometry mdsys.sdo_geometry;
892: l_locus_string VARCHAR2(200);
893: l_geo_type VARCHAR2(6);
894: BEGIN
895: IF (p_soft_validation = fnd_api.g_true) THEN
896: IF p_geom IS NULL
897: OR p_geom.sdo_gtype <> 2001
898: OR p_geom.sdo_elem_info IS NULL
899: OR p_geom.sdo_ordinates IS NULL

Line 970: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

966: * @param x_segment_id Nearest Street Segment Id.
967: */
968: FUNCTION get_segment_id (
969: p_api_version IN NUMBER default 1.0
970: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
971: , p_latitude IN NUMBER
972: , p_longitude IN NUMBER
973: , p_country IN VARCHAR2
974: , x_segment_id OUT NOCOPY NUMBER

Line 1000: x_return_status := FND_API.G_RET_STS_SUCCESS;

996: if ( p_init_msg_list = 'TRUE' ) then
997: x_msg_count := 0; /* FND_MSG_PUB.initialize; */
998: end if;
999:
1000: x_return_status := FND_API.G_RET_STS_SUCCESS;
1001:
1002: --
1003: -- Validate parameters
1004: --

Line 1050: x_return_status := FND_API.G_RET_STS_ERROR;

1046: x_msg_count := 1;
1047: x_msg_data := 'roadsegmentid:' || l_roadsegmentid || ':distance:' || l_dist;
1048:
1049: if (l_dist = -1) THEN
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: END if;
1052:
1053: RETURN x_segment_id;
1054: