[Home] [Help]
885: --dbms_output.put_line('Entering : validate_order_header');
886: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
887: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Begin Procedure');
888: END IF;
889: l_operating_unit_id := mo_global.get_current_org_id();
890: IF (l_operating_unit_id IS NULL) THEN
891: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');
892: FND_MSG_PUB.ADD;
893: END IF;
2348: AND wdj.wip_entity_id = wo.wip_entity_id
2349: AND wdj.owning_department = bmd.department_id
2350: AND upper(bmd.department_class_code) = 'VENDOR'
2351: AND org.organization_id = vst.organization_id
2352: AND NVL (org.operating_unit, mo_global.get_current_org_id ()) = mo_global.get_current_org_id()
2353: AND wo.status_code = G_OSP_WO_RELEASED;
2354:
2355: l_exist VARCHAR2(1);
2356: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_workorder';
4314: --index defined on osp_order_number if two concurrent users submit the OSP Order creation at
4315: --the same time
4316: l_osp_order_number := l_osp_order_id;
4317: --Derive operating_unit_id
4318: l_operating_unit_id :=mo_global.get_current_org_id();
4319: IF (l_operating_unit_id IS NULL) THEN
4320: FND_MESSAGE.Set_Name('AHL', 'AHL_OSP_ORG_NOT_SET');
4321: FND_MSG_PUB.ADD;
4322: RAISE FND_API.G_EXC_ERROR;
4419: AND wo.visit_id = vst.visit_id
4420: AND wo.visit_task_id = vts.visit_task_id
4421: AND vst.visit_id = vts.visit_id
4422: AND vst.organization_id = org.organization_id
4423: AND NVL (org.operating_unit, mo_global.get_current_org_id ())= mo_global.get_current_org_id();
4424:
4425: l_item_service_rels_tbl(i).inv_org_id := l_organization_id;
4426: l_item_service_rels_tbl(i).inv_item_id := l_inventory_item_id;
4427: l_item_service_rels_tbl(i).service_item_id := l_service_item_id;