DBA Data[Home] [Help]

APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on AHL_VWP_COST_PVT

Line 283: AHL_VWP_COST_PVT.Calculate_WO_Cost

279: -- Not to calculate cost if visit is in cancelled status
280: IF l_visit_status <>'CANCELLED' THEN
281:
282: -- To call to get cost if calculated
283: AHL_VWP_COST_PVT.Calculate_WO_Cost
284: (
285: p_api_version => 1.0,
286: p_init_msg_list => Fnd_Api.G_FALSE,
287: p_commit=> Fnd_Api.G_FALSE,

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

295: fnd_log.string
296: (
297: fnd_log.level_exception,
298: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
299: 'AHL_VWP_COST_PVT.Calculate_WO_Cost API threw error : x_return_status : ' || x_return_status
300: );
301: END IF;
302: RAISE FND_API.G_EXC_ERROR;
303: END IF;

Line 308: AHL_VWP_COST_PVT.Calculate_Visit_Cost

304:
305: -- To get visit cost calculated
306: IF(l_cost_price_rec.Is_Cst_Struc_updated = 'N') AND (l_cost_price_rec.workorder_id IS NOT NULL) THEN
307:
308: AHL_VWP_COST_PVT.Calculate_Visit_Cost
309: (
310: p_visit_id => l_cost_price_rec.visit_id,
311: p_Session_id => l_cost_price_rec.mr_session_id,
312: x_Actual_cost => l_cost_price_rec.actual_cost,

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

319: fnd_log.string
320: (
321: fnd_log.level_exception,
322: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
323: 'AHL_VWP_COST_PVT.Calculate_Visit_Cost API threw error : x_return_status : ' || x_return_status
324: );
325: END IF;
326: RAISE FND_API.G_EXC_ERROR;
327: END IF;

Line 330: AHL_VWP_COST_PVT.Get_Profit_or_Loss

326: RAISE FND_API.G_EXC_ERROR;
327: END IF;
328:
329: -- To get profit and loss
330: AHL_VWP_COST_PVT.Get_Profit_or_Loss
331: (
332: p_actual_price => l_cost_price_rec.actual_price,
333: p_estimated_price => l_cost_price_rec.estimated_price,
334: p_actual_cost => l_cost_price_rec.actual_cost,

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

344: fnd_log.string
345: (
346: fnd_log.level_exception,
347: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.get_visit_cost_details',
348: 'AHL_VWP_COST_PVT.Get_Profit_or_Loss API threw error : x_return_status : ' || x_return_status
349: );
350: END IF;
351: RAISE FND_API.G_EXC_ERROR;
352: END IF;

Line 1077: -- call AHL_VWP_COST_PVT.calculate_visit_cost

1073: END IF;
1074:
1075: END IF; -- released required flag
1076:
1077: -- call AHL_VWP_COST_PVT.calculate_visit_cost
1078:
1079: AHL_VWP_COST_PVT.Estimate_WO_Cost
1080: (
1081: p_api_version => 1.0,

Line 1079: AHL_VWP_COST_PVT.Estimate_WO_Cost

1075: END IF; -- released required flag
1076:
1077: -- call AHL_VWP_COST_PVT.calculate_visit_cost
1078:
1079: AHL_VWP_COST_PVT.Estimate_WO_Cost
1080: (
1081: p_api_version => 1.0,
1082: p_init_msg_list => Fnd_Api.G_FALSE,
1083: p_commit=> Fnd_Api.G_FALSE,

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

1091: fnd_log.string
1092: (
1093: fnd_log.level_exception,
1094: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.estimate_visit_cost',
1095: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status
1096: );
1097: END IF;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;

Line 2583: AHL_VWP_COST_PVT.Estimate_WO_Cost

2579: -- get a snapshot number for ahl_snapshot_number_s for the whole set
2580: SELECT AHL_SNAPSHOTS_S.NEXTVAL INTO l_snapshot_number FROM DUAL;
2581:
2582: -- call calculate workorder cost
2583: AHL_VWP_COST_PVT.Estimate_WO_Cost
2584: (
2585: p_api_version => 1.0,
2586: p_init_msg_list => Fnd_Api.G_FALSE,
2587: p_commit=> Fnd_Api.G_FALSE,

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

2595: fnd_log.string
2596: (
2597: fnd_log.level_exception,
2598: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2599: 'AHL_VWP_COST_PVT.Estimate_WO_Cost API threw error : x_return_status : ' || x_return_status
2600: );
2601: END IF;
2602: RAISE FND_API.G_EXC_ERROR;
2603: END IF;

Line 2611: AHL_VWP_COST_PVT.Calculate_Task_Cost

2607: OPEN workorder_csr(summary_tasks_rec.visit_task_id);
2608: FETCH workorder_csr INTO l_workorder_id, l_wip_entity_id;
2609:
2610: IF(workorder_csr%FOUND)THEN
2611: AHL_VWP_COST_PVT.Calculate_Task_Cost
2612: (
2613: p_visit_task_id => summary_tasks_rec.visit_task_id,
2614: p_session_id => p_x_cost_price_rec.mr_session_id,
2615: x_Actual_cost => l_actual_cost,

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

2624: fnd_log.string
2625: (
2626: fnd_log.level_error,
2627: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2628: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :summary: x_return_status : ' || x_return_status
2629: );
2630: END IF;
2631: CLOSE workorder_csr;
2632: EXIT;

Line 2679: AHL_VWP_COST_PVT.Calculate_Task_Cost

2675: END LOOP;
2676:
2677: -- take a snapshot of all other tasks
2678: FOR other_tasks_rec IN other_tasks_snapshot_csr(p_x_cost_price_rec.visit_id) LOOP
2679: AHL_VWP_COST_PVT.Calculate_Task_Cost
2680: (
2681: p_visit_task_id => other_tasks_rec.visit_task_id,
2682: p_session_id => p_x_cost_price_rec.mr_session_id,
2683: x_Actual_cost => l_actual_cost,

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

2692: fnd_log.string
2693: (
2694: fnd_log.level_error,
2695: 'ahl.plsql.AHL_VWP_VISIT_CST_PR_PVT.create_cost_snapshot',
2696: 'AHL_VWP_COST_PVT.Calculate_Task_Cost API threw error :other: x_return_status : ' || x_return_status
2697: );
2698: END IF;
2699: EXIT;
2700: END IF;