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 164: x_return_status := fnd_api.g_ret_sts_success;

160: )
161: RETURN NUMBER IS
162: RESULT VARCHAR2(6);
163: BEGIN
164: x_return_status := fnd_api.g_ret_sts_success;
165:
166: verify_locus(
167: p_api_version => 1
168: , p_locus => p_geom

Line 311: RETURN fnd_api.g_true;

307: FUNCTION should_call_lf(p_geom IN MDSYS.SDO_GEOMETRY)
308: RETURN VARCHAR2 AS
309: BEGIN
310: IF p_geom IS NULL THEN
311: RETURN fnd_api.g_true;
312: ELSE
313: RETURN fnd_api.g_false;
314: END IF;
315: END should_call_lf;

Line 313: RETURN fnd_api.g_false;

309: BEGIN
310: IF p_geom IS NULL THEN
311: RETURN fnd_api.g_true;
312: ELSE
313: RETURN fnd_api.g_false;
314: END IF;
315: END should_call_lf;
316:
317: FUNCTION get_locus_segmentid(p_geom IN MDSYS.SDO_GEOMETRY)

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

632:
633: l_from_segment_id NUMBER;
634: l_to_segment_id NUMBER;
635: BEGIN
636: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
637: RAISE fnd_api.g_exc_unexpected_error;
638: END IF;
639:
640: -- Initialize message list if p_init_msg_list is set to TRUE

Line 637: RAISE fnd_api.g_exc_unexpected_error;

633: l_from_segment_id NUMBER;
634: l_to_segment_id NUMBER;
635: BEGIN
636: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
637: RAISE fnd_api.g_exc_unexpected_error;
638: END IF;
639:
640: -- Initialize message list if p_init_msg_list is set to TRUE
641: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 641: IF fnd_api.to_boolean (p_init_msg_list) THEN

637: RAISE fnd_api.g_exc_unexpected_error;
638: END IF;
639:
640: -- Initialize message list if p_init_msg_list is set to TRUE
641: IF fnd_api.to_boolean (p_init_msg_list) THEN
642: fnd_msg_pub.initialize;
643: END IF;
644:
645: -- Initialize API return status to success

Line 646: x_return_status := fnd_api.g_ret_sts_success;

642: fnd_msg_pub.initialize;
643: END IF;
644:
645: -- Initialize API return status to success
646: x_return_status := fnd_api.g_ret_sts_success;
647:
648: l_from_segment_id := p_segment_id_tbl(p_segment_id_tbl.FIRST);
649: l_to_segment_id := p_segment_id_tbl(p_segment_id_tbl.LAST);
650:

Line 701: IF fnd_api.to_boolean(p_commit) THEN

697:
698: -- Close the CLOB
699: dbms_lob.CLOSE(l_route);
700:
701: IF fnd_api.to_boolean(p_commit) THEN
702: COMMIT;
703: END IF;
704: EXCEPTION
705: WHEN OTHERS THEN

Line 706: x_return_status := fnd_api.g_ret_sts_unexp_error;

702: COMMIT;
703: END IF;
704: EXCEPTION
705: WHEN OTHERS THEN
706: x_return_status := fnd_api.g_ret_sts_unexp_error;
707: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
708: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
709: END IF;
710: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

733: l_srid NUMBER;
734: BEGIN
735: SAVEPOINT csf_save_locuses;
736:
737: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
738: RAISE fnd_api.g_exc_unexpected_error;
739: END IF;
740:
741: -- Initialize message list if p_init_msg_list is set to TRUE

Line 738: RAISE fnd_api.g_exc_unexpected_error;

734: BEGIN
735: SAVEPOINT csf_save_locuses;
736:
737: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
738: RAISE fnd_api.g_exc_unexpected_error;
739: END IF;
740:
741: -- Initialize message list if p_init_msg_list is set to TRUE
742: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 742: IF fnd_api.to_boolean (p_init_msg_list) THEN

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

Line 747: x_return_status := fnd_api.g_ret_sts_success;

743: fnd_msg_pub.initialize;
744: END IF;
745:
746: -- Initialize API return status to success
747: x_return_status := fnd_api.g_ret_sts_success;
748:
749: l_srid := NVL(p_srid, 8307);
750:
751: FORALL i IN 1..p_location_id_tbl.COUNT

Line 762: IF fnd_api.to_boolean(p_commit) THEN

758: , mdsys.sdo_ordinate_array( p_longitude_tbl(i), p_latitude_tbl(i) )
759: )
760: WHERE location_id = p_location_id_tbl(i);
761:
762: IF fnd_api.to_boolean(p_commit) THEN
763: COMMIT;
764: END IF;
765: EXCEPTION
766: WHEN OTHERS THEN

Line 768: x_return_status := fnd_api.g_ret_sts_unexp_error;

764: END IF;
765: EXCEPTION
766: WHEN OTHERS THEN
767: ROLLBACK TO csf_save_locuses;
768: x_return_status := fnd_api.g_ret_sts_unexp_error;
769: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
770: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
771: END IF;
772: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

786: l_result VARCHAR2(6);
787: l_geometry mdsys.sdo_geometry;
788: l_locus_string VARCHAR2(200);
789: BEGIN
790: IF (p_soft_validation = fnd_api.g_true) THEN
791: IF p_geom IS NULL
792: OR p_geom.sdo_gtype <> 2001
793: OR p_geom.sdo_elem_info IS NULL
794: OR p_geom.sdo_ordinates IS NULL