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_LF_PUB dependencies on FND_API

Line 92: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

88: -- History: 19-04-2000 L Mbekeani Added lat long to locus
89: -- End Comments
90: PROCEDURE CSF_LF_ResolveAddress
91: ( p_api_version IN NUMBER
92: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
93: , x_return_status OUT NOCOPY VARCHAR2
94: , x_msg_count OUT NOCOPY NUMBER
95: , x_msg_data OUT NOCOPY VARCHAR2
96: , p_country IN VARCHAR2

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: if ( p_init_msg_list = 'TRUE' ) then
140: x_msg_count := 0; /* FND_MSG_PUB.initialize; */
141: end if;
142:
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: --
146: -- Validate parameters
147: --

Line 219: x_return_status := FND_API.G_RET_STS_ERROR;

215: --
216:
217: if ( l_retCode = MISSING_COUNTRY_NAME ) then
218:
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: x_msg_count := 1;
221: x_msg_data := l_result_int(1).msg_data;
222:
223: raise CSF_LF_COUNTRY_NOT_SET_ERROR;

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

223: raise CSF_LF_COUNTRY_NOT_SET_ERROR;
224:
225: elsif ( l_retCode = MISSING_STATE_NAME ) then
226:
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: x_msg_count := 1;
229: x_msg_data := l_result_int(1).msg_data;
230:
231: raise CSF_LF_STATE_NOT_SET_ERROR;

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

231: raise CSF_LF_STATE_NOT_SET_ERROR;
232:
233: elsif ( l_retCode = MISSING_CITY_NAME ) then
234:
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: x_msg_count := 1;
237: x_msg_data := l_result_int(1).msg_data;
238:
239: raise CSF_LF_CITY_NOT_SET_ERROR;

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: raise CSF_LF_CITY_NOT_SET_ERROR;
240:
241: elsif ( l_retCode = MISSING_ROAD_NAME ) then
242:
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: x_msg_count := 1;
245: x_msg_data := l_result_int(1).msg_data;
246:
247: raise CSF_LF_ROAD_NOT_SET_ERROR;

Line 251: x_return_status := FND_API.G_RET_STS_ERROR;

247: raise CSF_LF_ROAD_NOT_SET_ERROR;
248:
249: -- added for LF enhancement of forced accuracy
250: elsif ( l_retCode = REQUIRED_ACCURACY_EXCEPTION ) then
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: x_msg_count := 1;
253: x_msg_data := l_result_int(1).msg_data;
254: RAISE CSF_LF_REQ_ACCURACY_NOT_GOT;
255:

Line 258: x_return_status := FND_API.G_RET_STS_ERROR;

254: RAISE CSF_LF_REQ_ACCURACY_NOT_GOT;
255:
256: elsif ( l_retCode > 0 ) then
257:
258: x_return_status := FND_API.G_RET_STS_ERROR;
259: x_msg_count := 1;
260: x_msg_data := l_result_int(1).msg_data;
261:
262: else

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: x_resultsArray(J).alternate := l_result_int(J).alternate;
313:
314: end loop;
315:
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317: x_msg_count := l_numResults;
318: x_msg_data := 'Success';
319:
320: end if;

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321:
322: EXCEPTION
323:
324: when CSF_LF_VERSION_ERROR then
325: x_return_status := FND_API.G_RET_STS_ERROR;
326: x_msg_count := 1;
327: x_msg_data := 'Incompatibale version';
328:
329: when CSF_LF_REQ_ACCURACY_NOT_GOT then

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: x_msg_count := 1;
327: x_msg_data := 'Incompatibale version';
328:
329: when CSF_LF_REQ_ACCURACY_NOT_GOT then
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: x_msg_count := 1;
332: x_msg_data := l_result_int(1).msg_data;
333:
334: END CSF_LF_ResolveAddress;

Line 354: , p_init_msg_list IN VARCHAR2 default fnd_api.g_false

350: -- Version:
351: -- End Comments
352: PROCEDURE CSF_LocustoGeometry
353: ( p_api_version IN NUMBER
354: , p_init_msg_list IN VARCHAR2 default fnd_api.g_false
355: , x_return_status OUT NOCOPY VARCHAR2
356: , x_msg_count OUT NOCOPY NUMBER
357: , x_msg_data OUT NOCOPY VARCHAR2
358: , p_locus IN MDSYS.SDO_GEOMETRY

Line 388: x_return_status := FND_API.G_RET_STS_SUCCESS;

384: if ( p_init_msg_list = 'TRUE' ) then
385: null; /* FND_MSG_PUB.initialize; */
386: end if;
387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389:
390: CSF_LOCUS_PUB.read_locus (
391: p_api_version => l_api_version
392: , x_return_status => x_return_status

Line 426: x_return_status := FND_API.G_RET_STS_SUCCESS;

422: getCoordonSegment(segmentLength, segmentGeometry.sdo_ordinates,x_offset,coord);
423:
424: x_point := mdsys.sdo_geometry(2001,8307,mdsys.sdo_point_type(coord.long,coord.lat,0),null,null);
425:
426: x_return_status := FND_API.G_RET_STS_SUCCESS;
427: end if;
428:
429: -- Get the segId
430: -- Fetch The segment geometry

Line 437: x_return_status := FND_API.G_RET_STS_ERROR;

433:
434: EXCEPTION
435:
436: when CSF_LF_VERSION_ERROR then
437: x_return_status := FND_API.G_RET_STS_ERROR;
438:
439: when NO_DATA_FOUND then
440: x_return_status := FND_API.G_RET_STS_ERROR;
441:

Line 440: x_return_status := FND_API.G_RET_STS_ERROR;

436: when CSF_LF_VERSION_ERROR then
437: x_return_status := FND_API.G_RET_STS_ERROR;
438:
439: when NO_DATA_FOUND then
440: x_return_status := FND_API.G_RET_STS_ERROR;
441:
442: END CSF_LocustoGeometry;
443:
444: -- Start of Comments

Line 462: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

458: -- Version:
459: -- End Comments
460: PROCEDURE CSF_GeometrytoLocus
461: ( p_api_version IN NUMBER
462: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
463: , x_return_status OUT NOCOPY VARCHAR2
464: , x_msg_count OUT NOCOPY NUMBER
465: , x_msg_data OUT NOCOPY VARCHAR2
466: , p_point IN MDSYS.SDO_GEOMETRY

Line 484: x_return_status := FND_API.G_RET_STS_SUCCESS;

480: if ( p_init_msg_list = 'TRUE' ) then
481: null; /* FND_MSG_PUB.initialize; */
482: end if;
483:
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485:
486: EXCEPTION
487:
488: when CSF_LF_VERSION_ERROR then

Line 489: x_return_status := FND_API.G_RET_STS_ERROR;

485:
486: EXCEPTION
487:
488: when CSF_LF_VERSION_ERROR then
489: x_return_status := FND_API.G_RET_STS_ERROR;
490:
491: END CSF_GeometrytoLocus;
492:
493: -- Start of Comments

Line 512: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE

508: -- End Comments
509:
510: PROCEDURE CSF_LocustoTimeZone
511: ( p_api_version IN NUMBER
512: , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
513: , x_return_status OUT NOCOPY VARCHAR2
514: , x_msg_count OUT NOCOPY NUMBER
515: , x_msg_data OUT NOCOPY VARCHAR2
516: , p_locus IN MDSYS.SDO_GEOMETRY

Line 538: x_return_status := FND_API.G_RET_STS_SUCCESS;

534: if ( p_init_msg_list = 'TRUE' ) THEN
535: x_msg_count := 0; /* FND_MSG_PUB.initialize; */
536: end if;
537:
538: x_return_status := FND_API.G_RET_STS_SUCCESS;
539:
540: CSF_LOCUS_PUB.VERIFY_LOCUS (
541: p_api_version => l_api_version
542: , x_return_status => x_return_status

Line 566: x_return_status := FND_API.G_RET_STS_SUCCESS;

562: OPEN C_TIMEZONE FOR sql_stmt_str;
563: FETCH C_TIMEZONE INTO x_timezone;
564: CLOSE C_TIMEZONE;
565:
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567: else
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: end if;
570:

Line 568: x_return_status := FND_API.G_RET_STS_ERROR;

564: CLOSE C_TIMEZONE;
565:
566: x_return_status := FND_API.G_RET_STS_SUCCESS;
567: else
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: end if;
570:
571: EXCEPTION
572:

Line 574: x_return_status := FND_API.G_RET_STS_ERROR;

570:
571: EXCEPTION
572:
573: when NO_DATA_FOUND then
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: x_msg_data := 'INVALID ROADSEGMENT_ID';
576:
577: when OTHERS then
578: x_return_status := FND_API.G_RET_STS_ERROR;

Line 578: x_return_status := FND_API.G_RET_STS_ERROR;

574: x_return_status := FND_API.G_RET_STS_ERROR;
575: x_msg_data := 'INVALID ROADSEGMENT_ID';
576:
577: when OTHERS then
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: x_msg_data := 'UNKNOWN ERROR';
580: END;
581:
582: -- ----------------------------------------------------------------------------