DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VWP_TIMES_PVT

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

1445: IF (c_visit_rec.START_DATE_TIME IS NOT NULL
1446: AND c_visit_rec.START_DATE_TIME <> Fnd_Api.G_MISS_DATE
1447: AND c_visit_rec.DEPARTMENT_ID IS NOT NULL
1448: AND c_visit_rec.DEPARTMENT_ID <> FND_API.G_MISS_NUM) THEN
1449: l_visit_end_date:= AHL_VWP_TIMES_PVT.get_visit_end_time(p_visit_id);
1450: END IF;
1451:
1452:
1453: -- PRAKKUM ::FP PIE :: 13-OCT-2010

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

2669: END IF;
2670: END IF;--if l_Visit_rec.visit_type_code IS NOT NULL
2671:
2672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2673: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
2674: END IF;
2675:
2676: --Now adjust the times derivation for task
2677: AHL_VWP_TIMES_PVT.Calculate_Task_Times(p_api_version => 1.0,

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

2673: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
2674: END IF;
2675:
2676: --Now adjust the times derivation for task
2677: AHL_VWP_TIMES_PVT.Calculate_Task_Times(p_api_version => 1.0,
2678: p_init_msg_list => Fnd_Api.G_FALSE,
2679: p_commit => Fnd_Api.G_FALSE,
2680: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,
2681: x_return_status => l_return_status,

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

2683: x_msg_data => l_msg_data,
2684: p_visit_id => l_visit_rec.visit_id);
2685:
2686: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2687: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);
2688: END IF;
2689:
2690: --Standard check to count messages
2691: l_msg_count := Fnd_Msg_Pub.count_msg;

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

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

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

3274: END LOOP;
3275: CLOSE c_visit_task_links;
3276:
3277: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3278: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
3279: END IF;
3280:
3281: --Now adjust the times derivation for visit.
3282: AHL_VWP_TIMES_PVT.Calculate_Task_Times

Line 3282: AHL_VWP_TIMES_PVT.Calculate_Task_Times

3278: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
3279: END IF;
3280:
3281: --Now adjust the times derivation for visit.
3282: AHL_VWP_TIMES_PVT.Calculate_Task_Times
3283: (p_api_version => 1.0,
3284: p_init_msg_list => Fnd_Api.G_FALSE,
3285: p_commit => Fnd_Api.G_FALSE,
3286: p_validation_level => Fnd_Api.G_VALID_LEVEL_FULL,

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

3289: x_msg_data => l_msg_data,
3290: p_visit_id => l_visit_id);
3291:
3292: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3293: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);
3294: END IF;
3295:
3296: -- Return ID of the new visit
3297: p_x_Visit_rec.visit_id := l_visit_id;

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

4317: ELSIF l_visit_rec.department_id is not null
4318: and c_visit_rec.department_id is not null
4319: and l_visit_rec.department_id <>c_visit_rec.department_id THEN
4320:
4321: l_visit_end_date:= AHL_VWP_TIMES_PVT.get_visit_end_time(l_visit_rec.visit_id);
4322: -- To find out if visit has workorder in production store this info in rec type
4323: OPEN c_Visit_WO (l_visit_rec.visit_id);
4324: FETCH c_visit_WO INTO l_workrec;
4325:

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

4773: -- PRAKKUM :: VWPE: ER:12424063 :: 11-APR-2011 :: Validation before calling this API to get tasks update count :: END
4774: END IF; -- if l_is_comp_visit = 'N'
4775:
4776: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4777: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
4778: END IF;
4779:
4780: -- Added cxcheng POST11510--------------
4781: AHL_VWP_TIMES_PVT.Calculate_Task_Times

Line 4781: AHL_VWP_TIMES_PVT.Calculate_Task_Times

4777: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Before calling AHL_VWP_TIMES_PVT.Calculate_Task_Times');
4778: END IF;
4779:
4780: -- Added cxcheng POST11510--------------
4781: AHL_VWP_TIMES_PVT.Calculate_Task_Times
4782: ( p_api_version => 1.0,
4783: p_init_msg_list => Fnd_Api.G_FALSE,
4784: p_commit => Fnd_Api.G_FALSE,
4785: p_validation_level=> Fnd_Api.G_VALID_LEVEL_FULL,

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

4788: x_msg_data => l_msg_data,
4789: p_visit_id => l_visit_rec.visit_id);
4790:
4791: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4792: fnd_log.string(fnd_log.level_statement,L_DEBUG,'After calling AHL_VWP_TIMES_PVT.Calculate_Task_Times - l_return_status : '||l_return_status);
4793: END IF;
4794:
4795: IF l_return_status <> 'S' THEN
4796: RAISE Fnd_Api.G_EXC_ERROR;