APPS.AHL_VWP_VISITS_PVT dependencies on FND_PROFILE

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

1827: l_visit_rec.proj_template_id := l_proj_template_id;
1828: ELSE
1829: -- If Project Template Name is null
1830: -- then use the profile value
1831: l_visit_rec.proj_template_id := FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID');
1832: END IF;
1833:
1834: /*Added by sowsubra - starts - Issue#86 changes*/
1835: l_dummy := NULL;

Line 1855: 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

1851: Fnd_Message.SET_NAME('AHL','AHL_VWP_SUBINV_NOT_EXISTS');
1852: Fnd_Msg_Pub.ADD;
1853: RAISE Fnd_Api.G_EXC_ERROR;
1854: ELSE
1855: 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
1856: CLOSE c_subinv_validate;
1857: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
1858: FND_MESSAGE.Set_Token('INV', l_visit_rec.subinventory);
1859: FND_MSG_PUB.ADD;

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

2003: -- Planned End Date is madatory for transit visit
2004: /*
2005: IF p_module_type = 'JSP' AND ( l_visit_rec.PLAN_END_DATE IS NULL
2006: OR l_visit_rec.PLAN_END_DATE = FND_API.g_miss_date) THEN
2007: l_visit_rec.PLAN_END_DATE:= l_visit_rec.START_DATE + (FND_PROFILE.VALUE('AHL_TRANSIT_VISIT_DEFAULT_DURATION')/1440);
2008: END IF;
2009: */
2010: ELSE
2011: l_Visit_rec.unit_schedule_id := NULL;

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

2176: IF l_Visit_rec.unit_schedule_id IS NOT NULL
2177: AND l_Visit_rec.unit_schedule_id <> FND_API.G_MISS_NUM THEN
2178: l_date_time := NVL(NVL(l_visit_rec.PLAN_END_DATE,
2179: AHL_VWP_TIMES_PVT.get_visit_end_time(l_Visit_rec.visit_id)),
2180: l_visit_rec.START_DATE + (FND_PROFILE.VALUE('AHL_TRANSIT_VISIT_DEFAULT_DURATION')/1440));
2181:
2182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2183: fnd_log.string(fnd_log.level_statement,L_DEBUG,'l_date_time - '||l_date_time);
2184: END IF;

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

3167: END IF;
3168: ELSE
3169: -- If Project Template Name is null
3170: -- then use the profile value
3171: l_proj_template_id := FND_PROFILE.VALUE('AHL_DEFAULT_PA_TEMPLATE_ID');
3172: END IF;
3173:
3174: IF (l_proj_template_id <> c_visit_rec.project_template_id) AND (c_visit_rec.project_id IS NOT NULL) THEN
3175: -- Project Template cannot be updated if Project has been created for Visit

Line 3204: 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

3200: Fnd_Message.SET_NAME('AHL','AHL_VWP_SUBINV_NOT_EXISTS');
3201: Fnd_Msg_Pub.ADD;
3202: RAISE Fnd_Api.G_EXC_ERROR;
3203: ELSE
3204: 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
3205: CLOSE c_subinv_validate;
3206: FND_MESSAGE.SET_NAME('AHL', 'AHL_SUBINVENTORY_NOT_SVC');
3207: FND_MESSAGE.Set_Token('INV', l_visit_rec.subinventory);
3208: FND_MSG_PUB.ADD;