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 332: IF (c_visit_rec.START_DATE_TIME IS NOT NULL AND c_visit_rec.START_DATE_TIME <> Fnd_Api.G_MISS_DATE) THEN

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

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

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

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

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

Line 367: RAISE Fnd_Api.G_EXC_ERROR;

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

Line 449: p_encoded => Fnd_Api.g_false);

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

Line 468: WHEN Fnd_Api.G_EXC_ERROR THEN

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

Line 469: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 473: p_encoded => Fnd_Api.g_false);

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

Line 476: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 477: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 481: p_encoded => Fnd_Api.g_false);

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

Line 484: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 492: p_encoded => Fnd_Api.g_false);

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