DBA Data[Home] [Help]

APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_VWP_COST_PVT

Line 246: AHL_VWP_COST_PVT.Calculate_WO_Cost

242: -- Not to calculate cost if visit is in cancelled status
243: IF l_visit_status <>'CANCELLED' THEN
244:
245: -- To call to get cost if calculated
246: AHL_VWP_COST_PVT.Calculate_WO_Cost
247: (
248: p_api_version => 1.0,
249: p_init_msg_list => Fnd_Api.G_FALSE,
250: p_commit=> Fnd_Api.G_FALSE,

Line 262: 'AHL_VWP_COST_PVT.Calculate_WO_Cost API threw error : x_return_status : ' || x_return_status

258: fnd_log.string
259: (
260: fnd_log.level_exception,
261: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
262: 'AHL_VWP_COST_PVT.Calculate_WO_Cost API threw error : x_return_status : ' || x_return_status
263: );
264: END IF;
265: RAISE FND_API.G_EXC_ERROR;
266: END IF;

Line 271: AHL_VWP_COST_PVT.Calculate_Visit_Cost

267:
268: -- To get visit cost calculated
269: IF(l_cost_price_rec.Is_Cst_Struc_updated = 'N') AND (l_cost_price_rec.workorder_id IS NOT NULL) THEN
270:
271: AHL_VWP_COST_PVT.Calculate_Visit_Cost
272: (
273: p_visit_id => l_cost_price_rec.visit_id,
274: p_Session_id => l_cost_price_rec.mr_session_id,
275: x_Actual_cost => l_cost_price_rec.actual_cost,

Line 286: 'AHL_VWP_COST_PVT.Calculate_Visit_Cost API threw error : x_return_status : ' || x_return_status

282: fnd_log.string
283: (
284: fnd_log.level_exception,
285: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
286: 'AHL_VWP_COST_PVT.Calculate_Visit_Cost API threw error : x_return_status : ' || x_return_status
287: );
288: END IF;
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;

Line 293: AHL_VWP_COST_PVT.Get_Profit_or_Loss

289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:
292: -- To get profit and loss
293: AHL_VWP_COST_PVT.Get_Profit_or_Loss
294: (
295: p_actual_price => l_cost_price_rec.actual_price,
296: p_estimated_price => l_cost_price_rec.estimated_price,
297: p_actual_cost => l_cost_price_rec.actual_cost,

Line 311: 'AHL_VWP_COST_PVT.Get_Profit_or_Loss API threw error : x_return_status : ' || x_return_status

307: fnd_log.string
308: (
309: fnd_log.level_exception,
310: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
311: 'AHL_VWP_COST_PVT.Get_Profit_or_Loss API threw error : x_return_status : ' || x_return_status
312: );
313: END IF;
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;

Line 1008: -- call AHL_VWP_COST_PVT.calculate_visit_cost

1004: END IF;
1005:
1006: END IF; -- released required flag
1007:
1008: -- call AHL_VWP_COST_PVT.calculate_visit_cost
1009:
1010: AHL_VWP_COST_PVT.Estimate_WO_Cost
1011: (
1012: p_api_version => 1.0,

Line 1010: AHL_VWP_COST_PVT.Estimate_WO_Cost

1006: END IF; -- released required flag
1007:
1008: -- call AHL_VWP_COST_PVT.calculate_visit_cost
1009:
1010: AHL_VWP_COST_PVT.Estimate_WO_Cost
1011: (
1012: p_api_version => 1.0,
1013: p_init_msg_list => Fnd_Api.G_FALSE,
1014: p_commit=> Fnd_Api.G_FALSE,

Line 1026: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status

1022: fnd_log.string
1023: (
1024: fnd_log.level_exception,
1025: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
1026: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status
1027: );
1028: END IF;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;

Line 2502: AHL_VWP_COST_PVT.Estimate_WO_Cost

2498: -- get a snapshot number for ahl_snapshot_number_s for the whole set
2499: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_number FROM DUAL;
2500:
2501: -- call calculate workorder cost
2502: AHL_VWP_COST_PVT.Estimate_WO_Cost
2503: (
2504: p_api_version => 1.0,
2505: p_init_msg_list => Fnd_Api.G_FALSE,
2506: p_commit=> Fnd_Api.G_FALSE,

Line 2518: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status

2514: fnd_log.string
2515: (
2516: fnd_log.level_exception,
2517: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2518: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status
2519: );
2520: END IF;
2521: RAISE FND_API.G_EXC_ERROR;
2522: END IF;

Line 2530: AHL_VWP_COST_PVT.Calculate_Task_Cost

2526: OPEN workorder_csr(summary_tasks_rec.visit_task_id);
2527: FETCH workorder_csr INTO l_workorder_id, l_wip_entity_id;
2528:
2529: IF(workorder_csr%FOUND)THEN
2530: AHL_VWP_COST_PVT.Calculate_Task_Cost
2531: (
2532: p_visit_task_id => summary_tasks_rec.visit_task_id,
2533: p_session_id => p_x_cost_price_rec.mr_session_id,
2534: x_Actual_cost => l_actual_cost,

Line 2547: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :summary: x_return_status : ' || x_return_status

2543: fnd_log.string
2544: (
2545: fnd_log.level_error,
2546: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2547: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :summary: x_return_status : ' || x_return_status
2548: );
2549: END IF;
2550: CLOSE workorder_csr;
2551: EXIT;

Line 2598: AHL_VWP_COST_PVT.Calculate_Task_Cost

2594: END LOOP;
2595:
2596: -- take a snapshot of all other tasks
2597: FOR other_tasks_rec IN other_tasks_snapshot_csr(p_x_cost_price_rec.visit_id) LOOP
2598: AHL_VWP_COST_PVT.Calculate_Task_Cost
2599: (
2600: p_visit_task_id => other_tasks_rec.visit_task_id,
2601: p_session_id => p_x_cost_price_rec.mr_session_id,
2602: x_Actual_cost => l_actual_cost,

Line 2615: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :other: x_return_status : ' || x_return_status

2611: fnd_log.string
2612: (
2613: fnd_log.level_error,
2614: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2615: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :other: x_return_status : ' || x_return_status
2616: );
2617: END IF;
2618: EXIT;
2619: END IF;