DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VWP_TIMES_PVT

Line 1235: l_visit_end_date:= AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id);

1231: IF (c_visit_rec.START_DATE_TIME IS NOT NULL
1232: AND c_visit_rec.START_DATE_TIME <> Fnd_Api.G_MISS_DATE
1233: AND c_visit_rec.DEPARTMENT_ID IS NOT NULL
1234: AND c_visit_rec.DEPARTMENT_ID <> FND_API.G_MISS_NUM) THEN
1235: l_visit_end_date:= AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id);
1236: END IF;
1237:
1238: -- Post 11.5.10
1239: -- get the project template name from cursor

Line 2149: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');

2145: END IF;
2146: END IF;
2147:
2148: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2149: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
2150: END IF;
2151:
2152: --Now adjust the times derivation for task
2153: AHL_VWP_TIMES_PVT.Calculate_Task_Times(p_api_version => 1.0,

Line 2153: AHL_VWP_TIMES_PVT.Calculate_Task_Times(p_api_version => 1.0,

2149: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
2150: END IF;
2151:
2152: --Now adjust the times derivation for task
2153: AHL_VWP_TIMES_PVT.Calculate_Task_Times(p_api_version => 1.0,
2154: p_init_msg_list => Fnd_Api.G_FALSE,
2155: p_commit => Fnd_Api.G_FALSE,
2156: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
2157: x_return_status => l_return_status,

Line 2163: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);

2159: x_msg_data => l_msg_data,
2160: p_visit_id => l_visit_rec.visit_id);
2161:
2162: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2163: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);
2164: END IF;
2165:
2166: --Standard check to count messages
2167: l_msg_count := Fnd_Msg_Pub.count_msg;

Line 2179: AHL_VWP_TIMES_PVT.get_visit_end_time(l_Visit_rec.visit_id)),

2175: -- Added by sjayacha as per Shailaja mail
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);

Line 2712: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');

2708: END LOOP;
2709: CLOSE c_visit_task_links;
2710:
2711: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2712: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
2713: END IF;
2714:
2715: --Now adjust the times derivation for visit.
2716: AHL_VWP_TIMES_PVT.Calculate_Task_Times

Line 2716: AHL_VWP_TIMES_PVT.Calculate_Task_Times

2712: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
2713: END IF;
2714:
2715: --Now adjust the times derivation for visit.
2716: AHL_VWP_TIMES_PVT.Calculate_Task_Times
2717: (p_api_version => 1.0,
2718: p_init_msg_list => Fnd_Api.G_FALSE,
2719: p_commit => Fnd_Api.G_FALSE,
2720: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

Line 2727: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);

2723: x_msg_data => l_msg_data,
2724: p_visit_id => l_visit_id);
2725:
2726: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2727: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);
2728: END IF;
2729:
2730: -- Return ID of the new visit
2731: p_x_Visit_rec.visit_id := l_visit_id;

Line 3432: l_visit_end_date:= AHL_VWP_TIMES_PVT.get_visit_end_time(l_visit_rec.visit_id);

3428: ELSIF l_visit_rec.department_id is not null
3429: and c_visit_rec.department_id is not null
3430: and l_visit_rec.department_id <>c_visit_rec.department_id THEN
3431:
3432: l_visit_end_date:= AHL_VWP_TIMES_PVT.get_visit_end_time(l_visit_rec.visit_id);
3433: -- To find out if visit has workorder in production store this info in rec type
3434: OPEN c_Visit_WO (l_visit_rec.visit_id);
3435: FETCH c_visit_WO INTO l_workrec;
3436:

Line 3610: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');

3606: );
3607:
3608: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3609: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling Ahl_Visits_Pkg.UPDATE_ROW');
3610: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
3611: END IF;
3612:
3613: -- Added cxcheng POST11510--------------
3614: AHL_VWP_TIMES_PVT.Calculate_Task_Times

Line 3614: AHL_VWP_TIMES_PVT.Calculate_Task_Times

3610: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
3611: END IF;
3612:
3613: -- Added cxcheng POST11510--------------
3614: AHL_VWP_TIMES_PVT.Calculate_Task_Times
3615: ( p_api_version => 1.0,
3616: p_init_msg_list => Fnd_Api.G_FALSE,
3617: p_commit => Fnd_Api.G_FALSE,
3618: p_validation_level=> Fnd_Api.G_VALID_LEVEL_FULL,

Line 3625: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);

3621: x_msg_data => l_msg_data,
3622: p_visit_id => l_visit_rec.visit_id);
3623:
3624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3625: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);
3626: END IF;
3627:
3628: IF l_return_status <> 'S' THEN
3629: RAISE Fnd_Api.G_EXC_ERROR;