DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_PRD_WORKORDER_PVT

Line 4371: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;

4367: l_operation_sequence NUMBER;
4368: l_workorder_operation_id NUMBER;
4369: l_visit_id NUMBER;
4370: i NUMBER := 0 ;
4371: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
4372: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4373:
4374: -- Cursor to get the materials associated to the default stage task
4375: Cursor get_scheduled_mat_detls (c_task_id IN NUMBER)

Line 4492: 'Before calling AHL_PRD_WORKORDER_PVT.process_stage_jobs and l_workorder_tbl count is:'||l_workorder_tbl.count);

4488: END IF;
4489:
4490: IF (fnd_log.level_procedure >= l_log_current_level) THEN
4491: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY,
4492: 'Before calling AHL_PRD_WORKORDER_PVT.process_stage_jobs and l_workorder_tbl count is:'||l_workorder_tbl.count);
4493: END IF;
4494:
4495: --Call AHL_PRD_WORKORDER_PVT.process_stage_jobs to remove resource requirements
4496: -- from default stage work order after visit is P2Ped.

Line 4495: --Call AHL_PRD_WORKORDER_PVT.process_stage_jobs to remove resource requirements

4491: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY,
4492: 'Before calling AHL_PRD_WORKORDER_PVT.process_stage_jobs and l_workorder_tbl count is:'||l_workorder_tbl.count);
4493: END IF;
4494:
4495: --Call AHL_PRD_WORKORDER_PVT.process_stage_jobs to remove resource requirements
4496: -- from default stage work order after visit is P2Ped.
4497: IF l_workorder_tbl.count > 0 THEN
4498: AHL_PRD_WORKORDER_PVT.process_stage_jobs (
4499: p_api_version => 1.0 ,

Line 4498: AHL_PRD_WORKORDER_PVT.process_stage_jobs (

4494:
4495: --Call AHL_PRD_WORKORDER_PVT.process_stage_jobs to remove resource requirements
4496: -- from default stage work order after visit is P2Ped.
4497: IF l_workorder_tbl.count > 0 THEN
4498: AHL_PRD_WORKORDER_PVT.process_stage_jobs (
4499: p_api_version => 1.0 ,
4500: p_init_msg_list => FND_API.G_TRUE,
4501: p_commit => FND_API.G_FALSE,
4502: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4514: 'After calling AHL_PRD_WORKORDER_PVT.process_stage_jobs. l_return_status = ' || l_return_status);

4510:
4511: IF (l_log_statement >= l_log_current_level) THEN
4512: fnd_log.string(l_log_statement,
4513: L_DEBUG_KEY,
4514: 'After calling AHL_PRD_WORKORDER_PVT.process_stage_jobs. l_return_status = ' || l_return_status);
4515: END IF;
4516:
4517: -- Check Error Message stack.
4518: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN