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

Line 165: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

161: -- Get a particular Visit Records with all details
162: --------------------------------------------------------------------
163: PROCEDURE Get_Visit_Details (
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
166: p_commit IN VARCHAR2 := Fnd_Api.g_false,
167: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
168: p_module_type IN VARCHAR2 := 'JSP',
169: p_visit_id IN NUMBER,

Line 166: p_commit IN VARCHAR2 := Fnd_Api.g_false,

162: --------------------------------------------------------------------
163: PROCEDURE Get_Visit_Details (
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
166: p_commit IN VARCHAR2 := Fnd_Api.g_false,
167: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
168: p_module_type IN VARCHAR2 := 'JSP',
169: p_visit_id IN NUMBER,
170:

Line 167: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

163: PROCEDURE Get_Visit_Details (
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
166: p_commit IN VARCHAR2 := Fnd_Api.g_false,
167: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
168: p_module_type IN VARCHAR2 := 'JSP',
169: p_visit_id IN NUMBER,
170:
171: x_Visit_rec OUT NOCOPY Visit_Rec_Type,

Line 250: IF Fnd_Api.to_boolean(p_init_msg_list)

246: AHL_DEBUG_PUB.Debug( 'Get Visit Details' ||': Start');
247: END IF;
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE.
250: IF Fnd_Api.to_boolean(p_init_msg_list)
251: THEN
252: Fnd_Msg_Pub.initialize;
253: END IF;
254:

Line 256: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

252: Fnd_Msg_Pub.initialize;
253: END IF;
254:
255: -- Initialize API return status to success
256: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
257:
258: -- Standard call to check for call compatibility.
259: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
260: p_api_version,

Line 259: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,

255: -- Initialize API return status to success
256: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
257:
258: -- Standard call to check for call compatibility.
259: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
260: p_api_version,
261: l_api_name,G_PKG_NAME)
262: THEN
263: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 263: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

259: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
260: p_api_version,
261: l_api_name,G_PKG_NAME)
262: THEN
263: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: ------------------------------Start of API Body------------------------------------
266:
267: ----------------------------------------- Cursor ----------------------------------

Line 335: IF (c_visit_rec.START_DATE_TIME IS NOT NULL AND c_visit_rec.START_DATE_TIME <> Fnd_Api.G_MISS_DATE) THEN

331: -- Post 11.5.10
332: -- Added l_min and l_min_close
333: -- Reema Start
334: -- To check if visit starttime is not null then store time in HH4 format
335: IF (c_visit_rec.START_DATE_TIME IS NOT NULL AND c_visit_rec.START_DATE_TIME <> Fnd_Api.G_MISS_DATE) THEN
336: l_hour := TO_NUMBER(TO_CHAR(c_visit_rec.START_DATE_TIME , 'HH24'));
337: ELSE
338: l_hour := NULL;
339: c_visit_rec.START_DATE_TIME := NULL;

Line 343: IF (visit_rec.CLOSE_DATE_TIME IS NOT NULL AND visit_rec.CLOSE_DATE_TIME <> Fnd_Api.G_MISS_DATE) THEN

339: c_visit_rec.START_DATE_TIME := NULL;
340: END IF;
341:
342: -- To check if visit closetime is not null then store time in HH4 format
343: IF (visit_rec.CLOSE_DATE_TIME IS NOT NULL AND visit_rec.CLOSE_DATE_TIME <> Fnd_Api.G_MISS_DATE) THEN
344: l_hour_close := TO_NUMBER(TO_CHAR(visit_rec.CLOSE_DATE_TIME , 'HH24'));
345: ELSE
346: l_hour_close := NULL;
347: visit_rec.CLOSE_DATE_TIME := Null;

Line 355: AND c_visit_rec.START_DATE_TIME <> Fnd_Api.G_MISS_DATE) THEN

351: Get_Due_by_Date(p_visit_id => l_visit_id, x_due_by_date => l_due_date);
352:
353:
354: IF (c_visit_rec.START_DATE_TIME IS NOT NULL
355: AND c_visit_rec.START_DATE_TIME <> Fnd_Api.G_MISS_DATE) THEN
356:
357:
358:
359: --END IF;

Line 370: RAISE Fnd_Api.G_EXC_ERROR;

366: IF c_proj_template%NOTFOUND THEN
367: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
368: Fnd_Message.SET_NAME('AHL','AHL_VWP_INVALID_PROTEM');
369: Fnd_Msg_Pub.ADD;
370: RAISE Fnd_Api.G_EXC_ERROR;
371: END IF;
372: END IF;
373: CLOSE c_proj_template;
374: END IF;

Line 452: p_encoded => Fnd_Api.g_false);

448: -- Standard call to get message count and if count is 1, get message info
449: Fnd_Msg_Pub.Count_And_Get
450: ( p_count => x_msg_count,
451: p_data => x_msg_data,
452: p_encoded => Fnd_Api.g_false);
453:
454: -- Check if API is called in debug mode. If yes, enable debug.
455: IF G_DEBUG='Y' THEN
456: Ahl_Debug_Pub.enable_debug;

Line 471: WHEN Fnd_Api.G_EXC_ERROR THEN

467: END IF;
468: RETURN;
469:
470: EXCEPTION
471: WHEN Fnd_Api.G_EXC_ERROR THEN
472: x_return_status := Fnd_Api.G_RET_STS_ERROR;
473: ROLLBACK TO Get_Visit_Details;
474: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
475: p_data => x_msg_data,

Line 472: x_return_status := Fnd_Api.G_RET_STS_ERROR;

468: RETURN;
469:
470: EXCEPTION
471: WHEN Fnd_Api.G_EXC_ERROR THEN
472: x_return_status := Fnd_Api.G_RET_STS_ERROR;
473: ROLLBACK TO Get_Visit_Details;
474: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
475: p_data => x_msg_data,
476: p_encoded => Fnd_Api.g_false);

Line 476: p_encoded => Fnd_Api.g_false);

472: x_return_status := Fnd_Api.G_RET_STS_ERROR;
473: ROLLBACK TO Get_Visit_Details;
474: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
475: p_data => x_msg_data,
476: p_encoded => Fnd_Api.g_false);
477:
478:
479: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 479: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

475: p_data => x_msg_data,
476: p_encoded => Fnd_Api.g_false);
477:
478:
479: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
481: ROLLBACK TO Get_Visit_Details;
482: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
483: p_data => x_msg_data,

Line 480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

476: p_encoded => Fnd_Api.g_false);
477:
478:
479: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
481: ROLLBACK TO Get_Visit_Details;
482: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
483: p_data => x_msg_data,
484: p_encoded => Fnd_Api.g_false);

Line 484: p_encoded => Fnd_Api.g_false);

480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
481: ROLLBACK TO Get_Visit_Details;
482: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
483: p_data => x_msg_data,
484: p_encoded => Fnd_Api.g_false);
485:
486: WHEN OTHERS THEN
487: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
488: ROLLBACK TO Get_Visit_Details;

Line 487: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

483: p_data => x_msg_data,
484: p_encoded => Fnd_Api.g_false);
485:
486: WHEN OTHERS THEN
487: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
488: ROLLBACK TO Get_Visit_Details;
489: Fnd_Msg_Pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
490: p_procedure_name => 'Get_Visit_Details',
491: p_error_text => SQLERRM);

Line 495: p_encoded => Fnd_Api.g_false);

491: p_error_text => SQLERRM);
492:
493: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count,
494: p_data => x_msg_data,
495: p_encoded => Fnd_Api.g_false);
496: END Get_Visit_Details;
497:
498:
499: