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_VWP_VISITS_PVT dependencies on FND_PROFILE

Line 1484: IF FND_PROFILE.VALUE('AHL_ENIGMA_3C_URL') IS NOT NULL THEN

1480: CLOSE c_get_subinv_loc_dtls;
1481: END IF;
1482:
1483: -- SKPATHAK :: 19-MAY-2010 :: Enigma Job Card Changes :: START
1484: IF FND_PROFILE.VALUE('AHL_ENIGMA_3C_URL') IS NOT NULL THEN
1485: l_visit_rec.jc_exist := AHL_PRD_PRINT_PVT.Generated_JobCard_Exists('VST',c_visit_rec.visit_id);
1486: l_visit_rec.view_jc_url := AHL_PRD_PRINT_PVT.Get_JC_File_Location('VST',c_visit_rec.visit_id);
1487: l_visit_rec.jc_gen_status := AHL_PRD_PRINT_PVT.Get_Latest_JCG_Status('VST',c_visit_rec.visit_id);
1488: l_visit_rec.jc_gen_error_text := AHL_PRD_PRINT_PVT.Get_JCG_Error_Msg('VST',c_visit_rec.visit_id);

Line 2131: l_visit_rec.proj_template_id := FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID');

2127: END IF; --project name not null
2128: ELSE
2129: -- If Project Template Name is null
2130: IF l_visit_rec.project_name IS NULL THEN
2131: l_visit_rec.proj_template_id := FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID');
2132: ELSE --project template name is null but project name is not null
2133: OPEN get_project_id_csr (l_visit_rec.project_name);
2134: FETCH get_project_id_csr INTO l_visit_rec.project_id;
2135: IF get_project_id_csr%NOTFOUND THEN

Line 2182: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN

2178: Fnd_Message.SET_NAME('AHL','AHL_VWP_SUBINV_NOT_EXISTS');
2179: Fnd_Msg_Pub.ADD;
2180: RAISE Fnd_Api.G_EXC_ERROR;
2181: ELSE
2182: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN
2183: CLOSE c_subinv_validate;
2184: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
2185: FND_MESSAGE.Set_Token('INV', l_visit_rec.subinventory);
2186: FND_MSG_PUB.ADD;

Line 2219: IF (l_status_id <> NVL(FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'), l_status_id)) THEN

2215: OPEN c_subinv_validate (l_visit_rec.comp_planning_subinv, l_visit_rec.organization_id);
2216: FETCH c_subinv_validate INTO l_status_id;
2217: CLOSE c_subinv_validate;
2218:
2219: IF (l_status_id <> NVL(FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'), l_status_id)) THEN
2220: -- Planning and In-Repair Sub Inventory should be Unserviceable.
2221: FND_MESSAGE.SET_NAME('AHL', 'AHL_CMP_SUBINV_NOT_UNSVC');
2222: FND_MSG_PUB.ADD;
2223: RAISE FND_API.G_EXC_ERROR;

Line 2243: IF (l_status_id <> NVL(FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'), l_status_id)) THEN

2239: OPEN c_subinv_validate (l_visit_rec.comp_inrepair_subinv, l_visit_rec.organization_id);
2240: FETCH c_subinv_validate INTO l_status_id;
2241: CLOSE c_subinv_validate;
2242:
2243: IF (l_status_id <> NVL(FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'), l_status_id)) THEN
2244: -- Planning and In-Repair Sub Inventory should be Unserviceable.
2245: FND_MESSAGE.SET_NAME('AHL', 'AHL_CMP_SUBINV_NOT_UNSVC');
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;

Line 2397: l_visit_rec.PLAN_END_DATE:= l_visit_rec.START_DATE + (FND_PROFILE.VALUE('AHL_TRANSIT_VISIT_DEFAULT_DURATION')/1440);

2393: -- Planned End Date is madatory for transit visit
2394: /*
2395: IF p_module_type = 'JSP' AND ( l_visit_rec.PLAN_END_DATE IS NULL
2396: OR l_visit_rec.PLAN_END_DATE = FND_API.g_miss_date) THEN
2397: l_visit_rec.PLAN_END_DATE:= l_visit_rec.START_DATE + (FND_PROFILE.VALUE('AHL_TRANSIT_VISIT_DEFAULT_DURATION')/1440);
2398: END IF;
2399: */
2400: ELSE
2401: l_Visit_rec.unit_schedule_id := NULL;

Line 2704: l_visit_rec.START_DATE + (FND_PROFILE.VALUE('AHL_TRANSIT_VISIT_DEFAULT_DURATION')/1440));

2700: IF l_Visit_rec.unit_schedule_id IS NOT NULL
2701: AND l_Visit_rec.unit_schedule_id <> FND_API.G_MISS_NUM THEN
2702: l_date_time := NVL(NVL(l_visit_rec.PLAN_END_DATE,
2703: AHL_VWP_TIMES_PVT.get_visit_end_time(l_Visit_rec.visit_id)),
2704: l_visit_rec.START_DATE + (FND_PROFILE.VALUE('AHL_TRANSIT_VISIT_DEFAULT_DURATION')/1440));
2705:
2706: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2707: fnd_log.string(fnd_log.level_statement,L_DEBUG,'l_date_time - '||l_date_time);
2708: END IF;

Line 3899: l_proj_template_id := FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID');

3895: IF (l_visit_rec.project_id IS NOT NULL) OR (l_visit_rec.proj_template_id IS NOT NULL) THEN
3896: l_proj_template_id := l_visit_rec.proj_template_id;
3897: l_project_id := l_visit_rec.project_id;
3898: ELSE
3899: l_proj_template_id := FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID');
3900: END IF;
3901: ELSE --project template name is null but project name is not null
3902: OPEN get_project_id_csr (l_visit_rec.project_name);
3903: FETCH get_project_id_csr INTO l_project_id;

Line 3970: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN

3966: Fnd_Message.SET_NAME('AHL','AHL_VWP_SUBINV_NOT_EXISTS');
3967: Fnd_Msg_Pub.ADD;
3968: RAISE Fnd_Api.G_EXC_ERROR;
3969: ELSE
3970: IF l_status_id in (NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_UNSERVICABLE'), -1), NVL(fnd_profile.value('AHL_MTL_MAT_STATUS_MRB'), -1)) THEN
3971: CLOSE c_subinv_validate;
3972: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
3973: FND_MESSAGE.Set_Token('INV', l_visit_rec.subinventory);
3974: FND_MSG_PUB.ADD;

Line 4109: IF (l_status_id <> NVL(FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'), l_status_id)) THEN

4105: OPEN c_subinv_validate (l_visit_rec.comp_planning_subinv, l_visit_rec.organization_id);
4106: FETCH c_subinv_validate INTO l_status_id;
4107: CLOSE c_subinv_validate;
4108:
4109: IF (l_status_id <> NVL(FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'), l_status_id)) THEN
4110: -- Planning and In-Repair Sub Inventory should be Unserviceable.
4111: FND_MESSAGE.SET_NAME('AHL', 'AHL_CMP_SUBINV_NOT_UNSVC');
4112: FND_MSG_PUB.ADD;
4113: RAISE FND_API.G_EXC_ERROR;

Line 4133: IF (l_status_id <> NVL(FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'), l_status_id)) THEN

4129: OPEN c_subinv_validate (l_visit_rec.comp_inrepair_subinv, l_visit_rec.organization_id);
4130: FETCH c_subinv_validate INTO l_status_id;
4131: CLOSE c_subinv_validate;
4132:
4133: IF (l_status_id <> NVL(FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_UNSERVICABLE'), l_status_id)) THEN
4134: -- Planning and In-Repair Sub Inventory should be Unserviceable.
4135: FND_MESSAGE.SET_NAME('AHL', 'AHL_CMP_SUBINV_NOT_UNSVC');
4136: FND_MSG_PUB.ADD;
4137: RAISE FND_API.G_EXC_ERROR;